- Featured in:
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Inventory Management Resume Samples
Data Warehouse Engineer Resume Samples
No results found
0-5 years of experience
- Converted and redesigned 45 packages for project deployment. New ETL control flows; modular and audited data flows and transforms. Rewrote T-SQL in lookups to end transaction blocking and reduce memory use. Wrote T-SQL for incremental data extraction. Optimized run time by 89%.
- Reduce size of database by factor of 4 to reduce SSAS bottlenecks from DW loads and MDX queries.
- Rewrote Revenue by Employee packages to balance employee counts; measure group and hierarchies merged with GL database. Used windows functions for product, sales and customer packages.
- CAO proposal; to produce Cash statement by direct means; subtract COGS from Receivables.
- Resolved 1.5% variance between Sale and General Ledger reporting through forensic analysis of SSIS packages. Tabular T-SQL data model with PowerPivot DAX functions to filter and Calculate.
0-5 years of experience
Provided production support and new development for existing SQL Server 2008 R2 data warehouse.
- Designed tables, complex ETL mappings and workflows in Informatica and SSIS to integrate new billing system into existing data warehouse.
- Developed Reports in Business Objects XI 3.1, SSRS and Microsoft Excel.
- Provided production support, product enhancements and bug fixes to SSAS multidimensional cube.
- Created processes, procedures and tools to validate data post ETL.
- Lead project to create reusable transformations, mapplets and mappings in Informatica to create consistency in the application of business rules.
- Worked on project to reduce the number of staging and transformation layers between source data and reporting.
0-5 years of experience
- Designed and implemented Data warehouse business Intelligence system for Visa corporate, which helps to forecast the complete business.
- Physical and Logical Database designing and modeling experience.
- Backup/Restore databases, Monitor, and optimize databases.
- Data Modeling, ETL and data mapping across projects.
0-5 years of experience
- Constructing, deploying, maintaining operational data stores through data engineering functions including data extract, transformation, loading, integration in support of enterprise data infrastructures, data warehouse, operational data stores and master data management
- Enabling BI and advanced analytics solutions utilizing the Microsoft stack (SSMS 2012, SSIS, SSRS, SSAS, MDS, Visual Studio and Excel Services)
- Implementing concepts of programming and database concepts such as data structures, error handing, data manipulation and I/O processing
- Developing OLAP solutions by creating cubes using data from data marts/data warehouse for deeper and faster data analysis
- Programming views, stored procedures, and functions, and reviewing query performance, optimizing code and monitoring overall data warehouse performance
- Enforcing data quality, integrity and reliability and creating solutions throughout the data warehouse by designing, maintaining and promoting proper data governance and database efficiency
- Fluency in file processing concepts (flat file, archive file, XML, etc.) and data integration Investigating and troubleshoot coding errors and data flow failures
- Creating enhancements to existing data model and related platforms
- Ensuring security of data warehouse containing PHI
- Documenting and governing the life cycle of data, including source-to-target mappings, data dictionaries, transformations, and data quality and business rules