preview

Financial, Retail And Shopping Domains

Satisfactory Essays

Summary:
Senior Analyst with 4 years of experience in Financial, Retail and Shopping domains. Extensive experience working with enterprise level data warehouses, ETL tools and writing advanced SQL queries including OLAP Cubes functionality across various RDBMS platforms (SQL Server, Teradata, Oracle & DB2).
Proficient with Data Analysis techniques like Data Profiling, Data Cleansing, Data Integrity, Data Mining, Data Reference and Security and etc. Strong knowledge and understanding of Data Lineage. Good knowledge of Dimensional Modeling and Normalization approaches and also Dimensional Modeling and Normalization approaches.
Adept at building innovative reports and interactive dashboards using Tableau. Publish reports in Tableau server …show more content…

Data Analyst
Working as a Sr.Data Analyst in Brokerage Technology division of Wells Fargo Advisors. Primary responsibilities are extracting Detailed Data requirements, conducting Current system Analysis, Impact Analysis, preparing Deliverables such as FDR, SSA(Source System Analysis), Source- to-Target Mappings, indentyfying the Transformation logic to develop ETL scripts.
Analyzed Metadata using DMM tools(Wells Fargo Specific) and Informatica Metadata Manager(IMM) as part on Information security and Risk Assessment project to trace out the confidential data fields in the Data Warehouse and ODS.
• Involved in the entire project life cycle from evaluation, installation and development of end user reports.
• Gathered and Analyzed User requirements, finance data and designed hierarchy to meet the requirements.
• Worked closely with BAs to gather and provide specific and crucial information through data mining using advanced SQL queries, OLAP functions and PL/SQL Stored Procedures and functions.
• Discovered Data Lineage and read application material to understand workflows and complexity. Mined data from numerous source systems.
• Conducted Curent system analysis to find the

Get Access