SUMMARY

• 7 years of professional experience in data modeling, designing, and data analysis with Conceptual, Logical, and Physical modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Highly Experienced in System Analysis, ER/Dimensional Data Modeling, Database design and implementation.
• Extensive experience in the Data Warehousing implementations for Retail, Health care and Insurance Industries.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin 9.5/9.0/8.2/7.3/7.1/7.0/4.0 , Power Designer and ER - Studio.
• Expertise in interacting with stakeholders, gathering Business requirements through story grooming sessions, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Experience in working with industry standard analysis techniques to uncover client requirements and identifying the roles and deliverables in the Organization by creating Use Case Models, Data Flow Models.
• Proficiency in defining ETL design and integrating data from disparate source systems and disparate data formats including Requirements gathering, Source system analysis, Data Quality, slowly changing dimension mappings, ETL-QA, Performance Tuning, Maintenance and Production Support using Informatica PowerCenter 8.6.1, 8.1.1, 7.1.x, PLSQL, MS SQL 2005/2000/7.0 Unix Shell.
• Experienced with Excel Functions, Lookup’s, Power Query and Pivot Tables and with different MS Office Suite like MS word and PowerPoint.
• Designed and published visually rich and intuitively interactive Tableau reports and dashboards for executive decision-making.
• Experienced in retrieving the data from different set of sources by writing simple/ complex SQL Queries.
• Experienced in Creating Source to Target mappings to load data from different set of sources to Data Warehouse.
• Experienced in creating implementation instructions for the Deployment & Provided warranty support and helped business users during the post-production Verification.
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball Methodology of Dimensional and Relational Data Modeling.
• Coherent with Normalization/De-normalization techniques in relational/dimensional environments and have performed normalizations up to 3NF (Third Normal Form).
• Expertise in Data Modeling using tools likes ERwin & Power Designer along with the hands-on experience in using Forward Engineering and Reverse engineering functionality.
• Strong experience providing support during User Acceptance Testing.
• Identified Slowly Changing Dimensions, Role Playing Dimensions and Hierarchies in dimensions.
• Experience in developing ETL process for Data warehousing using ETL tool Informatica and Netezza.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and Strong understanding of principles of Data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II.
• Experience in Workflow Analysis, Functional decomposition Analysis, Object Modeling along with Activity Diagrams.
• Experience in creating, maintaining and designing database diagrams, setting table relationships and indexes.
• Experience with business requirements analysis, entity relationship planning, database design, reporting structures.
• Experience on various Software Development Life Cycles including Analysis, Design, Development and Testing.
• Ability to adjust quickly to the new business Software Development Lifecycle Environment. Good team player and have strong ability to work under high stress environments.
• Excellent problem solving and analytical skills with exceptional ability to learn and master new technologies efficiently.

TECHNICAL SKILLS

Data analysis: Requirements Gathering, Process/Production Model analysis, Data Normalization, System Design, Data architecture internal Standards development, Metadata and Reports, Source and Target system Analysis, Project Management.

Languages: SQL, T-SQL, PL/SQL, Basic C, C++, SAS & UNIX, Python.

Database Systems: Oracle 11g/10g/9i/8i, DB2, Microsoft SQL Server 2008/2005/2000 , MySQL, MS-Access, Teradata V14.

MS Office Suite: MS Office 2010/ 2007/ 2003 (MS Word, MS Access MS Excel, MS PowerPoint).

Operating Systems: Microsoft Windows NT/2000/XP/ 2003/2007/2008.

ETL and Reporting Environment: SQL Server, SSIS, Informatica Power Center 8.6.1/ 8.1.1/ 7.1. x /6.1.2/5.1, SAP Business Objects.

Data Modeling Tools: CA Erwin Data Modeler 9.5/9.0/8.2/7.3/7.2/7.1/7.0/4.0 , Embarcadero ER/Studio 16.0.2/16.0.0 , Oracle SQL Data Modeler, SAP Power Designer 16.5/16.0.

Others: Crystal Reports 2008, MS Visio, Jira, Github, Sharepoint, Toad, Tableau.

PROFESSIONAL EXPERIENCE

Senior Business Analyst/Data Modeler

Confidential, Arlington, VA

Responsibilities:

• Worked with Business Analysts team in requirements gathering and in preparing functional specifications and translating them to technical specifications.
• Extensively involved in developing logical and physical data models that fit in exactly for the current state and the future state data elements and data flows using Erwin.
• To document business names and descriptions for tables and columns, relationships among datasets and data types, business rules and domains used ER/Studio.
• Utilized existing Informatica, Teradata, and SQL Server to deliver work and fix production issues on time in fast paced environment.
• Well-versed in writing SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.
• Defined the key columns for the Dimension and Fact tables of both the Warehouse and Data Mart.
• Interacted with the End users frequently and transferred the knowledge to them.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schema for the detailed data marts and Plan data marts involving shared dimensions (Conformed).
• Worked on Infomatica Data Quality to resolve customers address related issues.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Ensured the feasibility of the logical and physical design models.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the warehouse data integrity checks and shell scripts to balance the data between source and target tables after each ETL process.
• Maintain change log and history tables for each data model and solved the production issues by debugging the code.
• Performed Data Validation and Unit Testing before handing over the data for production and Quality Testing.

Environment: Informatica Power Center 8.x/7.x/6/x, Oracle 10g, PL/SQL, ERwin 7.2, ER/Studio, SIEM Technology, TOAD for Oracle Version 8.6.0.38, and SQL developer for Oracle.

Senior Data Modeler

Confidential, Eden Prairie, MN

Responsibilities:

• Responsible for creating all the business scenarios and use cases required for product development process in the industry.
• Gathering and documenting all the Business requirements required as part of the product development.
• Working to uncover the client requirements and identifying the roles and deliverables in the Organization by creating Use Case Models, Data Flow Models.
• Finalizing all the reporting needs and interacted with different business users to make sure whether the use cases are satisfying their requirement.
• Performing product development process in Agile Sprint Methodology & also involved in project management to deliver the sprints within the deadlines.
• Designing and developing Conceptual model using My SQL Work bench & Erwin Designing Tool as per the User requirements and demonstrated to the business how their data base design look like.
• Designing & Developing Logical and Physical model with high normalization (3NF) by using Erwin designing Tool.
• Performed forward engineering in Erwin tool to generate schemas and provided SQL schemas to the development team to create tables in the databases.
• Partnered with finance, MIS teams, and accounting to ensure the consistency and accuracy of data and reporting.
• Maintaining the data of the other data (Meta Data Management) to give the business a single point of reference to the product development process flow.
• Worked closely with Analytical and Reporting infrastructure teams to ensure operational and analytical data warehouses were able to support all business requirements for OLAP reporting across the organization.
• Developing and coordinating to the Java development team by providing them the proper Extraction logics from the different sources, and conducted sessions with development team to make them understand the model and the data flow.
• Providing extensive support to the development team to finalize the UI Dashboards which are needed to be customized accordingly.

Environment: ERwin r9.0, My SQL Workbench, MS Excel, MS Visio, Oracle SQL Developer, Jira, Github, Oracle

Data Modeler/ Data Analyst

Confidential, San Antonio, TX

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Map business needs/requirements to subject area model and to logical enterprise model& developed many Subject areas from the scratch.
• Created logical data model from the conceptual model and its conversion into the physical database design using Erwin.
• Created Data Base Design of Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Conducted Review sessions of Data Models with DBA to have best fit physical Model Indexes for better DB performance.
• Reviewed Entities and relationships in the engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Involved in logical and physical database designs and data mappings between cross functional application and used SQL queries to filter data.
• Developed the data warehouse dimensional models &schema for the proposed central model for the project.
• Created Logical/Physical Data models in 3NF in the Warehouse area of Enterprise Data Warehouse.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Worked on the Snow-flaking the Dimensions to remove redundancy whenever required.
• Ensured production data being replicated into the ODS and the Data Warehouse without any data anomalies from the processing databases.
• Involved using ETL tool Informatica Power Center to populate the database, data transformation from the old database to the new database.
• Conducted data profiling for better understanding of joins in ER models.
• Involved in high level ETL design review sessions and assisted ETL developers in the detail design and development of ETL maps using Informatica Power Center.
• Assisted Reporting developers in building Reports using Crystal Reports.

Environment: SQL Server, Oracle, Teradata, ERwin r8.2, Windows, MS office, MS Access, Visio, Informatica, SharePoint.

Data Modeler

Confidential - La Roche, NY

Responsibilities:

• Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.
• Coordinated with DBA on data base build and table normalizations and de-normalizations.
• Understanding clients’ information needs, business objectives, and market sectors and implementing appropriate data analysis strategies.
• Recognized and extracted critical indicators from large and complex data sets and interpreted and expressed those indicators in the business context.
• Designed and maintained processes for measurement, tracking, reporting, and analyzing traffic and user experience.
• Maintained the quality of data analysis, researched output and reporting, and ensured that all deliverables met specified requirements.
• Communicated directly with clients to clarify requirements and present research findings and ensured clients received coherent service.
• Developed SQL and PL/SQL scripts to perform data cleansing and PL/SQL procedures to populate date and time dimensions.
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the warehouse data integrity checks and shell scripts to balance the data between source and target tables after each ETL process.
• Created mapping specification spreadsheets to document the transformation logic.
• Worked with Model Manager and multiple data marts, involving multiple subject areas simultaneously, domains and Naming Standards.
• Conducted and participated in JAD sessions with the project managers, business analysis team, finance and development teams to gather, analyze, and document the business and reporting requirements.

Environment: Oracle 9i/10g, MS SQL Server, DB2, Oracle SQL Developer, PL/SQL, Business Objects, ERwin, MS office suite

Data Modeler/ Data Base Analyst

Confidential

Responsibilities:

• Involved in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Development of physical data models and created DDL scripts to create database schema and database objects.
• Created user requirement documents based on functional specification.
• Created new tables, written stored procedures, triggers, views, functions.
• Created SSIS Packages by using transformations like Derived Column, Sort, Lookup, Conditional Split, Merge Join, Union and Execute SQL Task to load into database.
• Created SQL scripts for tuning.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Erwin 7.3.
• Data Extracted from Flat files, Excel and Transformed as per the logic and loaded into Data warehouse.
• Involved in performance tuning to optimize SQL queries.
• Created and Maintained indexes for various fast and efficient reporting processes.
• Worked with the team of business analysts, developers and end users for generating audit reports and troubleshoot the related queries and fix the connectivity issues.
• Wrote stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Understanding the DLD specifications document and working with design to develop the mappings using SQL Server Integration Services (SSIS).

Environment: MS SQL Server, Erwin 7.3, Visual Studio, T-SQL, Enterprise Manager, Query Analyzer, Windows, MS Office.