SUMMARY

• 7+ years in Information Technology with experience in Relational Data Modelling, Data Warehouse Data Modelling, Data Analysis and Data Profiling.
• Extensive experience in Financial, Insurance and Mortgage domains.
• Demonstrated expertise in logical and physical data modeling (ER and Dimensional)
• Extensive experience in developing data - marts, operational and analytical environments
• Strong knowledge in overall software development life cycle (SDLC).
• Experience with change management procedures.
• Experience with deployment of database changes
• Strong experience in customer communication, requirement analysis, data profiling, data modeling, understanding technical architecture, ETL architecture and data analysis.
• Professional hands-on experience in data warehouse design, data modeling and database administration activities
• Extensive experience using data modeling tools Erwin, Power designer and Microsoft Visio.
• Strong experience in all phases in Software development life cycle using agile development approach (e.g. Scrum) and Waterfall development approach.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Extensive Experience working with business users/SMEs as well as senior management.
• Strong experience in metadata management and industry naming standards.
• Demonstrated excellent delivery capabilities in Onshore and Offshore model.
• Experienced in data warehouse requirements gathering.
• Experienced in Conceptual, Logical and Physical Modeling techniques
• Extensive experience in ER Modeling and also Dimensional Modeling (Star & Snow-flake)
• Experience in SQL querying.
• Experience designing data models for Sql, Oracle 10g, Oracle 11g and Teradata database technologies.
• Extensive experience in Agile environment and have experience with the Agile project management tools like Version one and JIRA.
• Extensive experience in handling multiple teams.
• Experienced in Onsite-offshore delivery model/coordination
• Excellent written and oral communication skills.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Sr. Data Modeler

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed the data and did data profiling and data mapping.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, transformation logics and corporate meta-data definitions.
• Handled multiple projects across different towers like Home loans, Cards, Auto Finance, Direct Bank and Brokerage.
• Worked on the major projects like MasterCard Digital Enablement Service (MDES), PEGA/ BDW Integration, Maxymiser and Salesforce.
• Worked on logical and physical data models for Bank Data Warehouse (BDW), Mortgage Data Warehouse (MDW), Card Data Warehouse (CDW) and Enterprise Data Warehouse(EDW) using Erwin r7.3 and Erwin 9.5 and conduct review sessions with the team, business stakeholders and lead divisional data modelers.
• Worked on the data warehouses based on the Teradata and Oracle environments.
• Designed and Developed logical & physical data models and Meta Data to support the requirements using Erwin.
• Responsible for completing the Metadata for all the data elements.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats
• Designed and documented ETL specifications and meta-data repository.
• Good exposure in the ETL development.
• Ensured data quality, data understanding within supported areas.
• Walked through the Logical Data Models of all source systems for data quality analysis.
• Worked in the agile environment and performed fungible roles in the team whenever capacity was available.
• As a shared resource worked for multiple teams by splitting the capacity across the teams.

Environment: CA Erwin r7.3, CA Erwin 9.5, Teradata Version 13, Ab initio, Oracle 11g, XML, XSD, MS Excel, Version One.

Confidential, West Des Moines, IA

Sr. Data Modeler

Responsibilities:

• Requirement Analysis. Has been responsible for interacting with the business customers and internal IT team as part of gathering information on the proposed system
• Worked in an agile environment and used JIRA Agile which is an agile project management tool for software development teams.
• Designed the OLTP data model at the enterprise level.
• Data Profiling activities for new sources before creating new subject areas in warehouse
• Extensively worked in Data Governance, i.e. Meta data management, Master data Management, Data Quality, Data Security.
• Designed Logical and physical Data models for the Enterprise Data warehouse.
• Designed the data models using the Power designer 15 data modeling tool.
• Designed the data models based on the oracle 11g database.
• Designed staging area.
• Created and implemented ER models and dimensional models (star schemas)
• Generated SQL scripts.
• Created the DDL and DML scripts.
• Assisted DBA’s in the development of physical database.

Environment: Power Designer 15.0, CA Erwin r7, Oracle 11g, SQL Server 2005/2008, Informatica 7.1.3, Toad for SQL Server, XML, MS Excel, JIRA.

Confidential, Columbus, GA

Data Modeler / Data Analyst

Responsibilities:

• Worked in the Waterfall SDLC methodology process.
• Worked on a project called Rules and Ratebook next generation also called legacy mordenization project where the source was a mainframe system and the target was an Oracle 11g database.
• Support business areas and database platforms to ensure database design, creation, and generation is according to published standards, processes, and procedures.
• Interact with internal customers on significant technical matters frequently requiring coordination across organizational lines; Create business rule spreadsheets / mapping documents
• Created and implemented the OLTP data models.
• Worked in the Oracle 11g environment and used Erwin r7.3 data modelling tool.

Environment: Erwin r7, Oracle 11g, Mainframe, SQL Server 2005/2008, PL SQL, MS Excel.