SUMMARY

• Result - oriented professional wif over 10+ years of experience in Requirements gathering, System & Data Analysis, Data Architecture, Database Design and Database Modeling.
• Strong background in various Data Modeling tools using ERWIN, ER/Studio and Power Designer.
• Expert noledge in SDLC (Software Development Life Cycle) and good experience in the field of business analysis, reviewing, analyzing, and evaluating business systems and user needs, business modeling, document processing.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing ERWIN diagrams, analyzing data sources and creating interface documents.
• Performed Gap analysis of current state to desired state and documented requirements for control gaps identified.
• Experience in developing Map Reduce Programs using Apache Hadoop for analyzing the Bigdata as per the requirement.
• Experience in various Teradata utilities like Fastload, Multiload, BTEQ, and Teradata SQL Assistant.
• Designed and developed Data Marts for Data Warehouse, ODS architecture by following Star Schema and Snowflake Schema Methodology, and using industry leading Data Modeling tools like ERWIN, ER/Studio and Power Designer.
• Developed dimensions and fact tables for data marts wif various Dimensions like Time, Services, Customers, Sales and Orders.
• Having Experience in Normalizing Data from 1NF to 3NF.
• Understanding the Slowly Changing Dimensions Type1, Type2, Type3.
• Conducted JAD sessions, created Use Cases, work flows and Power Point presentations.
• Gatheird and translated business requirements into technical designs and developed physical aspects of the specified design.
• Gatheird and documented Functional and Technical Design documents and Source to Target Mappings.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems (RDBMS) and from RDBMS to HDFS.
• Excellent noledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in Requirement gathering, System analysis, handling business and technical issues & communicating wif both business and technical users.
• Experienced in working on both Agile methodology and Waterfall methodology.
• Assisted quality assurance team in preparing test scripts and test cases.
• Worked on Documenting Data Models, logic, coding, testing, changes and corrections.
• Energetic and self-motivated team player wif excellent communication, interpersonal, and leadership skills, thrives in both independent and collaborative work environments.
• Self-directing individual contributor wif skills at matrixes and virtual team contribution/integration and wif experience in leading and directing other team members.

Confidential, FL

Sr. Data Steward/Data Architect

Responsibilities:

• Collaborate wif Business Analysts, Product Owners and Business Customers to identify data usage patterns and to formulate Business names, definitions and data quality rules for data elements.
• Understand the relationships across business information and units of data.
• Conducted Integrated Data Warehouse (IDW) project business requirement sessions wif business users to understand the requirements.
• Analyzed the requirements for developing Logical model, Physical model and Source to Target Mappings.
• Accountable and responsible for establishing a Data Governance initiative and framework wifin the program as well as contributing to and ensuring compliance to the overall Data Governance strategy.
• Modeled the dimensions and facts using Erwin 9.6 for centralized Data warehouse.
• Translate business and data requirements into Logical data models in support of Enterprise Communication Data Model, OLTP, OLAP, Operational Data Store(ODS) and Analytical systems.
• Worked wif ETL teams and 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 Teradata for OLTP systems by generating models to support T-Mobile 's Revenue Management Applications that connect to SAS.
• Created the Data model for the Subject Area in the Enterprise Data Warehouse(CDR).
• Generated data models to make extracts for SAS sourcing data from Enterprise Data Warehouse.
• Defined relationships, cardinalities among entities.
• Analyzed existing Logical Data Model (LDM) and made appropriate changes to make it compatible wif business logic and
• Involved in data model reviews wif internal Data architect, source system analysts, and business users wif in depth explanation of the data model to make sure it is in line wif business requirements.
• Worked as Data Architect to implement it in the data model.

Confidential, CA

Data Steward/Data Architect

Responsibilities:

• Responsible for technical Data governance, enterprise wide Data modeling and Database design.
• Researched, evaluated, architect, and deployed new tools, frameworks, and patterns to build sustainable Big Data platforms for the clients.
• Designed and implemented complex highly scalable statistical models and solutions that comply wif security requirements.
• Translated business requirements into Data architecture deliverables and artifacts.
• Participated in solution design, providing oversight and guidance related to Data design and usage.
• Involved using ETL tool Informatica to populate the Database, Data Transformation from the old Database to the new database using Oracle 12c/11g and SQL Server.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data Models using ER/Studio 9 (ER Studio)- Forward/Reverse Engineered Databases.
• Established Data architecture strategy, best practices, standards, and roadmaps.
• Reviewed requirements together wif QA Manager, ETL leads to enhancing the Data warehouse for the originations systems and servicing systems.
• Created ER diagrams using Open Sphere Model and implemented Fact and Dimension tables.
• Worked wif NoSQL database on simple queries and writing Stored Procedures for Normalization and De-normalization.
• Translate business and data requirements into Logical data models in support of Enterprise Data Models, ODS, OLAP, OLTP, Operational Data Structures and Analytical systems.
• Ensure Data design follows the prescribed reference architecture and framework.
• Facilitated more robust interpretations and understanding of member behaviors and commercial product performance.
• Managed and created and altered Databases, Tables, Views, Indexes and Constraints wif business rules.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using Star and Snow flake Schemas.
• Developed Star and Snowflake schemas based dimensional model to develop the Data warehouse.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions
• Involved in extensive Data Analysis on Oracle Systems Querying and Writing in SQL.
• Actively participated in Data mapping activities for the Data warehouse.
• Created summary tables using de-normalization technique to improve complex Join operations.
• Worked wif Data Scientist in order to create a Data marts for data science specific functions.
• Designed and implemented basic PL/SQL queries for testing and sales report/ data validation.
• Worked extensively on ER Studio for multiple Operations across Hartford in both OLAP and OLTP applications.
• Designed and governed data services messaging constructs in XSD format.
• Understand database performance factors and trends pertaining to very large database design and collaborate wif DBAs to implement mitigating physical modeling solutions; provide data structures optimized for information entry and retrieval.
• Applied appropriate level of abstraction in designs and confirmed that Data designs support the integration of data and information flow across systems and platforms.

Environment: ER Studio 9, Oracle 12c/11g, Informatica, MS SQL SERVER 2014, IDQ.

Confidential - AL

Data Modeler/ Data Architect

Responsibilities:

• Developed Logical and Physical Data models using ER Studio tool across the subject areas based on the specifications and established referential integrity of the system.
• Generated user and technical documentation for processes in all phases of the project.
• Conducted all data model reviews as appropriate during project lifecycle.
• Conducted team meetings and JAD sessions wif the SMEs, stakeholders and other management teams.
• Worked on Business Intelligence solution using Redshift DB, and Tableau.
• Analyzed the existing system and prepared and presented impact analysis using Netezza.
• Worked Tuning of queries and stored procedures wif Sybase power designer.
• Created named sets, calculated member and designed scope in SSAS.
• Created User requirement document for realizing MicroStrategy objects to be integrated in the report.
• Worked in data from database DB2 using Informatica to load it into a single repository for Data analysis.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Worked on gap analysis and Compared between CDS Transactions columns to the existing IBM BDW Industry Data Model.
• Normalized the database to put them into the 3NF of the Data warehouse.
• Implemented Type II changes for different Dimensions.
• Involved in Dimensional modeling, identifying the Facts and Dimensions.
• Maintain and enhance data model wif changes and furnish wif definitions, notes, reference values and check lists.
• Worked independently and prepare data strategy, Data governance documentation and presentation for Chief Data Office.
• Defined foundational data elements and enterprise data strategy as part of Data management framework.
• Performed Data Analysis and Data profiling using complex SQL on SQL Server and DB2.
• Evaluated proposed initiatives to ensure they meet business and technology goals and adhere to governance standards
• Assessed architectural impacts to all aspects of architecture, including security.
• Developed Data Mapping, Data Governance, and transformation and cleansing rules involving OLTP, ODS.
• Coordinated wif project DBA to update the physical database models to incorporate design changes (table de-normalization, type-code column additions, etc.) as they occur.
• Worked wif DBA's to design and build the Staging/Target databases.

Environment: ER Studio, DB2, SSAS, Sybase power designer, OLAP, ODS, Redshift DB, Tableau, Netezza, SQL Server.

Confidential, Hoffman Estates, IL

Data Steward/ Data Modeler

Responsibilities:

• Developed logical/ physical data models for building an Educational Data Warehouse using ERWIN tool.
• Normalized the database to put them into the 3NF of the data warehouse.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Identified and examined all ISBE applications to determine if they can be integrated wif other applications or if the data being collected is also collected in other applications which would allow those applications to be retired.
• Used ETL to Load Data from Flat Files to Staging area (Oracle 10g) using Informatics Power Center.
• Interacted wif program people and business owners on ISBE's IT Systems to reduce the data collection burden on the school districts which will greatly improve data quality and consistency.
• Involved in root cause analysis and identified redundant data by interacting wif the program owner and developers of the particular system.
• Conducted Gap analysis on various systems to identify redundant data.
• Conducted team meetings wif the SMEs and other management teams.
• Involved in documenting systems that are in the metadata workbook. An excel spreadsheet was created and the tables and fields were documented for various systems.
• Supported design, testing and implementation of the data warehouse. Assisted quality assurance team in preparing test scripts and test cases.
• Assisted developers by translating the project requirements.
• Provided other data analysis services, as required.
• Worked on ERWIN Workgroup Edition R 8.2 and Informatica Power Center 8.1.
• An enthusiastic and project-oriented team player wif solid communication and leadership skills.

Environment: ERWIN, Oracle 10g, MS SQL SERVER, Visio, Informatica Power Center.

Confidential, Kansas City, Missouri

Data Modeler/ Data Analyst

Responsibilities:

• Interacted wif business users to analyze the business process and requirements and transformed requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted Data Analysis, Data Discovery, Data Profiling using Informatica.
• Participated in Data modeling meetings, halped to identify the relationship between tables according to the requirements.
• Analyze various data sources such as SQL server, Oracle, Flat files etc. and identify potential source systems for projects.
• Provide user support to write instant queries and procedures using SQL and PL/SQL to provide decision support.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Coordinated data profiling/ data mapping wif business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Developed logical/physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Worked wif other data modelers in concurrent Data modeling environment.
• Involved in Dimensional modeling, identifying the Facts and Dimensions.
• Reverse Engineering models from Databases, files, External metadata using Erwin.
• Maintain and enhance data model wif changes and furnish wif definitions, notes, reference values and check lists.
• Metadata integration across Enterprise Data dictionary, Catalogs, Data Models and Informatica establishing lineage and traceability.
• Used UNIX scripting for file formatting before it gets into Informatica.
• Audit, Balance and Control design and physical model for ETL Framework.
• Worked very close wif Data Architects and DBA team to implement data model changes in database in all environments.
• Review Data mapping from source to target.
• Identify Data Cleansing Rules, Address validation rules, Match and merge rules and survivorship rules for creating the golden record for implementation.
• Worked on Erwin Workgroup Edition R8.2 and Informatica Power Center 8.1.
• Worked wif DBA's to design and build the Staging/Target databases.

Environment: Oracle 10g/9i, Erwin, Informatica, UNIX, SQL Server, Visio.

Confidential, Oaks PA

SQL Assistant

Responsibilities:

• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN.
• Validated and updated the appropriate Logical Data Models to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Worked on DB2 utilities like Multi Load, Fast Load, Fast Export, BTEQ, TPUMP, TPT and tools like SQL Assistant, Viewpoint.
• Writing complex SQL queries and optimizing the queries in SQL Server and DB2.
• Generated user and technical documentation for processes in all phases of the project.
• Conducted all data model reviews as appropriate during project lifecycle.
• Experienced in setting up connections to different Databases like SQL, DB2.
• Worked on numerous activities like monitoring DB2 platform using Viewpoint, remediating excessive statistics, tuning production ETL queries, resolving spool space issues, tuning high impact analytical queries, applying compression for space reclamation, Data Mover Development and Support etc.
• Worked in enhancement of the existing DB2 processes running on the Enterprise Data Warehouse.
• Coordinated wif project DBA to update the physical database models to incorporate design changes (table de-normalization, type-code column additions, etc.) as they occur.
• Involved in Data profiling and cleansing to remove redundant data.
• Provided input to resolve data limitation/constraints and issues.
• Reviewed processes and provided input into project plan.
• Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.
• Generated Data lineage documents for different applications as per requirement.
• Performed performance improvement of the existing Data warehouse applications to increase efficiency of the existing system.
• Extensively used tracing methods to troubleshoot various time consuming queries.
• Provided other Data analysis services, as required.

Environment: Erwin, MySQL, MS SQL SERVER, DB2, Visio.