EXPERIENCE SUMMARY:

• Experienced in Data Warehousing and Business Intelligence domain with technical knowledge of various sectors including Finance and Banking. A highly motivated individual who is organized, efficient and skilled in a multitude of tasks, including
• Client Interaction
• Project Planning and Implementation
• Offshore and Onshore team Collaboration
• Meeting & Event Planning
• Strong understanding of software life cycle management (SDLC) and methodologies like Waterfall and Agile.
• Highly Proficient in business SDLC documentation including deliverables for Data Analysis like Data Dictionary, Source to Target Mappings documents etc.
• Experienced in working with Oracle, SQL Server, and Teradata RDBMS systems. Expertise in writing DML, DDL, DCL and TCL statements.
• Experienced working with Teradata Utilities like BTEQ, MLOAD, Fast Load, Fast Export, TPUMP
• Expert in leading & coordinating with offshore and onshore teams in the right direction to achieve client objectives.
• Efficiently participated in requirement gathering and designing phases producing innovative ideas that met needs of the end users.
• Researched customer defect tickets, and conducted testing to pinpoint the issue, provided next steps to developers for resolution.
• Documented source and target systems from a data architecture category perspective - e.g. documenting source and target systems.
• Proficient in preparing functional specification document (FSD) and technical specification document.
• Experienced in working with ETL tools like Informatica, SSIS and Import/Export Studio.
• Experienced in manual testing and defect validation.
• Efficiently handled HP Quality Center in raising the defects, fixing the defects and running the test cases.
• Performed smoke testing and integration testing of the developed objects.
• Test data preparation for testing and have experience in data validation using SQL.
• Extensive experience preparing delivery documents and user manuals.

PROFESSIONAL EXPERIENCE

• Business Intelligence
• SAP BI 7.3
• Requirements Gathering
• Data warehouse
• SAP BW 3.5
• Documentation
• Data Modeling
• SAP BE Analyzer
• Communication
• Multi-Dimensional Modeling
• ECC 6.0
• Data Analysis
• ETL
• Crystal Reports
• Problem Solving
• Master Data Management
• SSIS, SSAS, SSRS
• Customer Relationship Management
• Tableau
• Oracle 9i, 10g, 11g
• Matlab
• MS SQL Server 2012
• Business Objects
• SQL
• MS Access
• SAS Miner, SAS EG
• PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior Data Analyst

Responsibilities:

• Identified source and target tables to look for column joins to validate the coverage based on data dictionary and hand off specifications for different subject areas.
• Performed Data profiling to check for inconsistencies and accuracies between different source flat files and staging tables as well as from staging to destination EDW for different business areas.
• Validated critical and non-critical data quality requirements by looking at log tables and metadata between source flat files and staging/destination tables.
• Identified data coverage and completeness issues in Logical Data Model using ERWIN, checking data design constraints and data integrity of all primary and natural keys by looking at the data dictionary.
• Used joins likeInner Join, Outer joinwhile creating tables from multiple tables in SQL.
• Created mappings in order to load the flat files into relational database so as to support ad-hoc reporting on EDW tables.
• Created SCD1 and SCD2 type mappings to load the mart dimensional tables.
• Worked on Data cleansing/scrubbing and validation.
• Developed SAS data marts for business users to serve ad-hoc reporting request for business users to validate their issuers, firm and inspection units.
• Optimized the performance by data validation and data cleaning using statistical procedures like PROC FREQ, PROC MEANS, PROC REPORT, PROC FORMAT.

Confidential, Cleveland,OH

Senior Data Analyst

Responsibilities:

• Intensive use of SQL within the Teradata environment. Created and modified tables, views and columns as necessary. Extracted data from existing data sources and wrote Ad-Hoc queries by using SQL. Created numerous Volatile, Global, Set, Multi-Set tables in Teradata platform.
• Developed numerous documentation guides to various systems within the data warehouse, along with SQL scripts to pull specialized datasets from the data warehouse.
• Worked with the project team to perform gap analysis, design, development, testing, implementation and production support tasks.
• Understanding and articulating the scope, risks, issues, project dependencies, deliverables and milestones and preparing presentations for senior management understanding and attention towards high risks/issues.
• Extensively involved in requirements gathering and data gathering to support developers in handling the design specification.
• Worked independently on data modeling/architecture and data aggregation design.
• Documented process flow/work-flow diagrams using MS-Visio to depict current and future state of the processes.
• Part of team that automated monthly reporting process using VBA and MS Excel.
• Migrated data from Flat Files into SQL Server database using SQL Server import/export studio.
• Designed and developed various business reports by using advanced techniques with SAS (PROC Report, PROC Tabulate, PROC SQL), SQL and OLAP functions (csum, msum, mavg, mdiff, cube and rollup), and MS Excel.
• Designed/Developed scripts to move data from the staging tables to the target tables.
• Analysis of data and development of reporting, primarily in Business Intelligence software Tableau 8.0.x/8.1

Confidential

Data Analyst/Systems Analyst/Data Modeler

Responsibilities:

• Worked as an intern for three months and graduated to a Software Associate in Capgemini. My role included Production Support, Data Modeling, Ad-hoc Data Extraction, Data Mining, and Data Profiling on Enterprise Data Warehouses of various clients.
• At Bristol-Myers Squibb, I worked as a Data Analyst on their Sales Operations & Marketing EDW. The objective of the solution was to manage sales force effectiveness and improve effectiveness of drill down operations.
• At Lendlease, I worked as a Data Analyst on a Real Estate Listings DWH. The objective on this solution was to mine real estate listings using SQL and Predictive Regression.
• Additionally, I also worked as a Data Modeler and Senior Analyst on Capgemini’s internal POC EDW which acted as an Enterprise Content Management system and a Federated EDW, allowing Capgemini to demonstrate the benefits of a federated architecture to its associate clients and perform training to internal staff.