Data warehousing Resume Profile

A highly skilled and experienced senior data analyst, data engineer and data modeler in the field of data warehousing with demonstrated success in designing and implementing the data warehousing solutions, over the past 17 years.

CORE COMPETENCIES

Over 17 years of experience in Data warehousing technology.
Over 12 Years of Data Analysis Profiling. Over 3 years of data modeling experience. Heavy experience on BI tools and BI Architecture in the past.
ETL Architecture
Data Analyst for the BASEL II data integrity projects in banking commercial stream
Data Analyst and Designer for Enterprise data quality initiatives
Data Modeling Logical Modeling and Physical Modeling, Forward and reverse engineering.
Design and implementation of MDM Master Data Management projects in Customer and Product Domains
BI Architect Experienced in using both MOLAP ROLAP tools, Operational reporting tool and BI Tool evaluation.
Data Architect Experienced in data integration and ETL Architecture and a clear understanding of data structures.

Data Layer:

Expertise on Data Acquisition / Data migration, data conversion and integration projects.
Worked on end-to-end implementation of Enterprise Data Quality, which is part of the Data Governance.
Highly experienced on migrating data from legacy systems Mainframes VSAM, QSAM files, IMS DB/DC Hierarchical Database, COBOL to Oracle / SQL Server staging areas. Developing interfaces ETL tools between legacy systems to Oracle staging.
Worked on analysis, profiling implementation design, coding testing of BASEL II Data quality monitoring and profiling tool for the enterprise wide data elements.
Highly experienced in Data analysis and profiling using Informatica Data profiling tool Informatica Data Explorer and TOAD SQL queries. Experienced in using SSIS Data Profiling task and Viewer.
Highly experienced in using Informatica Power Center and Informatica Data Quality IDQ workbench for coding the business rules related to enterprise data elements A BASEL II Data Quality Initiative.
Worked extensively on source to target mappings, data requirements templates, data certification templates, end to end data lineage, requirements specification documents, element discovery forms, data flow diagrams data models.
Worked on creating / modifying the enterprise data element Business rules / data rules specifications by profiling the data through Informatica Data Explorer and SQL.
Data Cleansing rules for MDM Projects
Worked on MDM projects to create the golden record of the customers
Worked on Customer Product domains in MDM
Extensive analysis on Web traffic and click stream data
Have worked on legacy Mainframe Projects COBOL, JCL, VSAM, DB2 QSAM

Presentation Layer

Extensive experience in using OLAP products Microstrategy 5,6,7.i versions, Cognos and operational reporting tools like Crystal and Actuate
Vast experience in implementing MicroStrategy BI tool.
Strong working experience on COGNOS BI, COGNOS Report Net, COGNOS Metrics Manager
Design of Dashboards using OLAP tools
Advanced excel reporting including Bona Vista Charts
Knowledge of Analytical functions
Experience on working with E Commerce metrics Web Analytics
Analytics / reporting on Click Stream / Web Traffic data
Strong SQL writing skills for Analysis and Data Profiling
Worked as a Programmer, Team Member, Information Analyst, Data Analyst, DWH Consultant, and Architect Project Lead.
As a Data warehouse architect worked on ETL Business Intelligence tool evaluation methodologies and white papers.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship