SUMMARY

• Highly accomplished Data Management Professional and Certified Scrum Master with 12+ years of IT experience in Banking, Insurance and Retail business domains, specializing in Data Modeling, Data Warehousing, Pega, Business Analysis, Data Analysis, Data Architecture, Data Migration, Database Design, ETL(INFORMATICA, DATASTAGE), BI (OBIEE, COGNOS, TABLEAU) Reporting, Hadoop Ecosystem and IBM Mainframes spanning all phases of Software Development Life Cycle.
• Demonstrated experience collaborating with business and technical stakeholder groups to understand client technical requirements, collect data, deliver analysis and provide problem resolution or recommend systems solution options.
• Data Modeler with strong Conceptual, Logical and Physical Data Modeling skills, having experience in requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Extensive experience in Relational and Dimensional Data modeling for creating ER Diagrams using ERwin data modeling tool.
• Integral part of Data Management team performing Data Extraction, Data Analysis, Data Cleansing, Data Mapping and Data Profiling exercises using Informatica Analyst and other profiling tools.
• Hands on experience in creating and managing Logical and Physical Data Models using Industry Standard Models IBM Banking Data Warehouse (BDW) and Teradata Financial Services Logical Data Model (FSLDM) for Enterprise Data Warehouse Applications (EDW).
• Involved in the Database Design for Operational Data Store working with DBAs and ETL Architects.
• Hands - on experience in using SQL for analyzing and provisioning data and by writing Stored Procedures using T-SQL, Teradata SQL and PL / SQL database languages.
• Developed Data Migration strategies using an ideal mix of Oracle Database, Teradata, SQL server, zOS DB2 based Loading Strategies and ETL tools.
• Experience in ETL Design, Development and Maintenance using Informatica Power Center and IBM Datastage.
• Well-versed in Developing Reporting Applications using Cognos, OBIEE and Tableau tools.
• Strong experience in Designing, Developing and supporting applications involving IBM Mainframes and related technologies.
• Good Data Analysis knowledge and exposure working on Hadoop Cloudera Distribution in an Enterprise Data Warehouse Environment involving range of toolsets like HUE, HIVE and IMPALA.
• Analyzed and documented the legacy programs written in SAS on zOS and Windows operating systems.
• Successfully lead a team of Data Analysts for implementation of CCAR (Comprehensive Capital Analysis and Review), FHLB, Profitability, AML, Pega (CUBE) and LCR programs.
• Involved in using Enterprise Business Glossary while carrying out day-to-day data modeling activities.

AREAS OF EXPERTISE

• Data Analysis
• Data Modeling
• Data Architecture
• Data Warehousing
• Big Data
• Data Migration
• AWS
• Pega
• Business Requirements Gathering
• Database Designing
• ETL
• Business Intelligence
• IBM Mainframes
• Data Dictionary

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter, IBM Datastage

Databases: IBM Db2, Oracle, Teradata, SQL Server

Data Modeling Tool: ERwin, Power Designer, Business Glossary

Industry Data Models: IBM BDW, Teradata FSLDM

Data Analysis Tool: Informatica Analyst

DB Programming Language: Sql, Pl/Sql

Reporting Tool: OBIEE, Cognos, Tableau

Mainframe Skills: Cobol, Jcl, Vsam, Eztreive, Rexx, SAS

Hadoop Tools: Hue, Hive, Impala

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler

Responsibilities:

• Manage MDM Provider project requirements elicitation, analysis, Modeling and documentation process to capture business and data needs.
• Create and maintain Reference data for the EDW Provider Datamart.
• Engage with Provider project teams to communicate the design and develop Logical and Physical data model.
• Promote usability data standards and develop high quality design using Power Designer
• Provide consultative support and advise as required for Confidential partners.
• Created Data Dictionary for reference to the other stakeholders in the project.
• Perform data profiling to measure and analyze data integrity and quality, provide solution to meet the data integrity and integration requirements.
• Create the Model in accordance with customer specifications, to ensure data accessibility and quality.

Confidential

Senior Data Analyst

Responsibilities:

• Leading the data analysis work for understanding the PEGA system underlying data structures in the operational and transactional data marts.
• Coordinate the data extraction from different legacy applications (such as Global Genius) for gathering the required data for ISO Reporting delivery.
• Work closely with Reporting business users for obtaining the functional requirements for capturing required ISO statistical plans and coverages.
• Develop and maintain the data mapping sheets capturing the data analysis and technical details around the source and target definitions along with their mappings.
• Create reference data sheets for data elements delivered as part of reporting requirements.
• Ensure the optimum storage of front-end application (Pega) data in the operational data store for reporting needs. Coordinate alignment of attributes using xml/tags-names to the database table/columns.
• Validate and provide sign-off on the Premium and Losses data feed from AGCS to Verisk for ISO Reporting submission.
• Create Midcorp policies/submissions in Pega tool to validate and test the data flow end-to-end for accuracy and data lineage.
• Update the Business Analysts, Cognos Developers and Architects for any changes to the data lineage and source for tracking purposes.
• Engage with the 3rd party vendor Verisk for delivery of the extract containing premium and losses data.

Confidential

Lead Data Analyst

Responsibilities:

• Leading a team of Data Analysts onshore and offshore working for CCAR, FHLB, Profitability, LCR and AML programs.
• Worked extensively in documenting the Data Analysis requirements and Gap Analysis outcomes in the form of Functional Specifications and Data Mapping documents.
• Interact closely with business counterparts for transformations of requirements into data structures, which can be used to efficiently store, manipulate and retrieve information.
• Involved in carrying out Data Validation and Loading of data into testing regions using combinations of Informatica PowerCenter, SQL and Teradata Stored Procedures.
• Involved in working on data analysis for sourcing-in new data into EDW on Hadoop distribution making use of HUE, HIVE and IMPALA tools.

Confidential, Memphis, Tennessee

Data Modeler, Data Migration Lead

Responsibilities:

• Developed Conceptual and Normalized Logical model using Erwin based on requirements analysis for Operational Data Store (ODS) working in OTX project.
• Created Data Dictionary for reference to the other stakeholders in the project.
• Accountable for Design, planning and execution of ETL processes for migrating data from Mainframe based Interpose Application to new operational system OTX (Online Transaction Xchange) using IBM DataStage.
• Perform source system data analysis including gap analysis in order to manage source to target Data Mapping, Data Profiling and Data Extraction activities.
• Involved in analyzing and coding the stored procedures using PL / SQL language for provisioning transactional historical data from Oracle database.
• Create and maintain Reference data for the new OTX system..
• Performed analysis and documented existing legacy Crystal Reports and processes around them for coming up with new design using IBM Cognos.
• Created Cognos List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.