Description
15+ year's software development expert with strong track record of development experience including 7 years designing and implementing data warehouses data marts and other business intelligence solutions throughoutthe business intelligence lifecycle. * Solid hands on experience with Data Warehousing tools Data Analysis Data Mapping Unit Testing Migration Conversions Problem Solving and Process Documentation. * Expert in managing/leading ETL and Business Intelligence Testing for supporting data extraction transformations and loading processing in a corporate-wide-ETL Solution using MS SQL Server. * Develop SSIS packages to extract data from flat files SQL Server database and Excel to load to data warehouse. Some of the data flow transformations used include Data Conversion Conditional Split Lookup Fuzzy Lookup Slow Changing Dimension OLE DB Command Merge Union All Sort Aggregate and more. Experienced as SQL Data Analyst / Data Reporting Analyst with strong background in design development and support of online databases and information products as well as data analysis/ reporting/processing. * Experience in Dimensional Data Modeling using Star and Snow Flake Schema designing data models using Erwin developing SSAS Cubes SSRS Reports. * Strong Understanding of Database Concepts that can be used to configure the business layer and optimize to improve the performance. Expertise in working with SQL queries and PL/SQL (Stored Procedures Triggers Packages/Functions). * Experience in delivering projects in a SOX compliant environment. * Competent in all aspects of Data Warehousing including project planning requirement gathering data modeling development deployment maintenance and enhancements. Able to work collaboratively quickly understand system architecture and business needs while committed to achieving corporate goals.
Accomplishments
Highlights:
Keywords
