SUMMARY

• Overall, 7 years experience in teh IT industry as data modeler in Data modeling forData Warehouse, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Experienced in all phases of SDLCincluding requirementgathering, development, testing, debugging, deployment, documentation, production supportand agile project management methodologies, Microsoft SQL Server database management, OBIEE.
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Involved in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Big Data and Cloud experience using Hadoop, AWS, Azure, Snowflake, Informatica Power Center Business Intelligence, Dimensional Modeling, ER Modeling
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Worked extensively on Erwin and ER Studio in several projects in bothOLAP and OLTPapplications.
• Experienced in integration of various relational and non - relational sources such as DB2, Oracle, SQL Server, NoSQL, XML and Flat Files.
• Extensive experienced in Normalization (1NF, 2NF, 3NF and BCNF) and De-normalization techniques for improved database performance Data Warehouse/Data Mart environments.
• Experience in using Informatica ETL tools and utilizes such as BDM and IDQ.
• Proficient in oracle tools and utilities such as TOAD, SQL*PLUS and SQL developer.
• Strong expertise in Metadata, Data Quality, Master Data Management (MDM) and Data Governance.
• Proficient in oracle tools like Toad, SQL*PLUS and SQL developer.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Knowledge onData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Implemented Slowly Changing Dimensions, Type I & II in Dimension tables as per teh requirement specifications.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions
• Good understanding ofviews, Synonyms, Indexes, Joins and Partitioning.
• Experience in data extractions from SAP systems and performing data reconciliations between different source systems.
• Highly motivated team player with teh ability to work independently and adapt quickly to new and emerging technologies.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x,10.x, Microsoft SQL Server Integration Services (SSIS), Microsoft Analysis Services, Business Objects

Data Modeling Tools: Erwin 9.5/9.X, HDFS, Redshift, ER/Studio, AWS, Azure, Snowflake.

RDBMS: Oracle, MS SQL Server, MS Access, DB2, Teradata, DB2 UDB 7.1, PL/SQL, TOAD, PUTTY

Languages: SQL, UNIX Shell, PL/SQL, Python.

Reporting tools: Autosys/Control -M, Power BI, Tableau.

Operating Systems: Microsoft Windows 10/7/NT/XP and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler Analyst

Responsibilities:

• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Analyzed database requirements in detail with teh project stakeholders by conducting Joint Requirements Development sessions
• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for using Erwin based on requirements analysis.
• Created dimensional model for teh reporting system by identifying required dimensions and facts usingErwin r9.5.
• Used forward engineering to create a Physical Data Model withDDLdat best suits teh requirements from teh Logical Data Model
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate teh developed models.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Extensively used Informatica debugger to figure out teh problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Responsible for defining teh naming standards for data warehouse
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2, Snowflake andSQL Serverdatabase systems
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups, and their privileges
• Extracted data from teh databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Prepared ETL technical Mapping Documents along with test cases for each Mapping for future developments to maintain SDLC and Migration process.

Environment: Erwin, Informatica 10.x, SQL Server, SQL, Oracle, DB2

Confidential

Data Modeler

Responsibilities:

• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Analyzed database requirements in detail with teh project stakeholders by conducting Joint Requirements Development sessions
• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for using Erwin based on requirements analysis.
• Created dimensional model for teh reporting system by identifying required dimensions and facts usingErwin r9.5.
• Created Snowflake Schemas by normalizing teh dimension tables as appropriate and creating a Sub Dimension named Demographic as a subset to teh Customer Dimension.
• Used forward engineering to create a Physical Data Model withDDLdat best suits teh requirements from teh Logical Data Model
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate teh developed models
• Identified, formulated, and documented detailed business rules and Use Cases based on requirements analysis
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Created ETL jobs to load financial JSON data and server data into Mongo DB and transported Mongo DB into teh Data Warehouse.
• Extensively used Informatica debugger to figure out teh problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Responsible for defining teh naming standards for data warehouse
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2, Snowflake andSQL Serverdatabase systems
• Exhaustively collected business and technical metadata and maintained naming standards
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in teh form of Entity Relationships and elicit more information
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups, and their privileges
• Used Model Mart ofErwinfor effective model management of sharing, dividing, and reusing model information and design for productivity improvement
• Extracted data from teh databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Designed and developed star schema, snowflake schema and created fact tables and dimension tables for teh warehouse and data marts using Erwin.
• Developed complex ETL mappings for Stage, Dimensions, Facts and Data marts load.
• Prepared ETL technical Mapping Documents along with test cases for each Mapping for future developments to maintain SDLC and Migration process. Used Talend for Extraction and Reporting purpose.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Integrated teh work tasks with relevant teams for smooth transition from testing to implementation

Environment: Erwin, Informatica 10.x, SQL Server, SQL, Oracle, DB2

Confidential

Data Modeler

Responsibilities:

• Worked with star schema and OLAP modeling.
• Worked with reversed engineer Data Model from Database instance.
• Conducted design discussions and meetings to come out with teh appropriate Data Mart at teh lowest level of grain for each of teh Dimensions involved.
• Created dimensional model for teh reporting system by identifying required dimensions and facts usingPower Designer.
• Designated Snowflake schemas with a very good understanding of FACT and dimensional tables for Data Warehouse by using Erwin.
• Physical data model and artifacts by using ERWIN, IBM Info Sphere IDA, Toad Data Modeling tools.
• Used forward engineering to create a Physical Data Model withDDLdat best suits teh requirements from teh Logical Data Model.
• UsedPower Designerfor reverse engineering to connect to existing database and ODS to create graphical representation in teh form of Entity Relationships and elicit more information.
• Experience in Testing teh ETL process for both before data validation and after data validation process. Tested teh messages published by ETL tool and data loaded into various databases.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Extracted data from teh databases (Oracle and SQL Server, DB2, FLAT FILES) using Big Data Spark/Sqoop/Informatica to load it into data lake/Datawarehouse.
• Designed a STAR schema for teh detailed data marts and Plan data marts involving confirmed dimensions.
• Performed logical data modeling, physical Data modeling (including reverse engineering) using teh Erwin Data modeling tool.
• Created and maintained teh Data Model repository as per company standards.
• Conducted design reviews with teh business analysts and content developers to create a proof of concept for teh reports.
• Developed dimensional model forDataWarehouse/OLAP applications by identifying required facts and dimensions.
• Ensured teh feasibility of teh logical and physical design models
• Collaborated with teh Reporting Team to design Monthly Summary Level Cubes to support teh further aggregated level of detailed reports.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups, and their privileges.
• Developed Star Schema and Snowflake Schema in designing teh Logical Model into Dimensional Model.
• Extensively used Informatica debugger to figure out teh problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Translated business requirements into dimensional data model using ERWIN
• Reverse engineered teh reports and identified teh Data Elements (in teh source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing
• Integrated teh work tasks with relevant teams for smooth transition from testing to implementation.
• Used ERWIN and TOAD to review Physical data model of PICA database (OLTP), Constraints, Foreign keys and indexing of tables

Environment: HDFS, Oracle 10g, Informatica 10.4

Confidential

Data Modeler

Responsibilities:

• Creating teh Conceptual Data Model as per teh Business process flow in Microsoft Visio.
• Involved in teh Analysis of teh Business requirements and Design teh Logical, Physical data Model using ERWIN.
• Analyzed database requirements in detail with teh project stakeholders by conducting Joint Requirements Development sessions.
• Creating Proof of Concepts from scratch illustrating how these data integration techniques can meet specific business requirements reducing cost and time to market.
• Working with BA engineers to answer questions about data quality and integrity as well as identifying opportunities for presenting existing data in novel ways.
• Used forward engineering to create a Physical Data Model withDDLdat best suits teh requirements from teh Logical Data Model.
• Generated DDL (DataDefinition Language) scripts using Erwin 8 and supported teh DBA in Physical Implementation ofdataModels.
• Recognized Use Cases from teh requirements. Created UML Diagrams including Use Cases Diagrams, Sequence Diagrams using MS Visio.
• Designed and Deployed Big data solutions on Cloudera Platform.
• Development of database objects like Hive External tables and HBase table DDL’s.
• Performed teh Data Mapping, Data design (Data Modeling) to integrate teh data across teh multiple databases into EDW.
• Involved in testing Snowflake to understand best possible way to use teh cloud resources and tune and Troubleshoot Snowflake for performance and optimize utilization and written SQL queries against Snowflake.
• Understanding teh data model, Data Extract, data profiling, de-duplication of data, data mapping, Source to Target mapping, look ups and transformations in excel, working with teh development team to meet business requirements and logic for teh Datawarehouse.
• Created HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL, and a variety of portfolios.
• Developed dimensional model forDataWarehouse/OLAP applications by identifying required facts and dimensions.
• Designed teh ETL processes using Informatica tool to load data from File system and Oracle into teh target SQL Developer
• Worked Extensively with DBA and Reporting team for improving teh Report Performance with teh Use of appropriate indexes and Partitioning.

Environment: Oracle 10g, Informatica 9, UNIX.