SUMMARY:

• 8+ years of experience in data modeling, business and data analysis, production support, database management, strategic analysis, requirements gathering, application and decision support.
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERWIN and Power Designer.
• Proficient in data mart design and creation of cubes using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in carrying out the entire Software Development Life Cycle (SDLC).
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience working on creating models for Oracle/Teradata/ SQL Server/DB2.
• Expertise in Source to target mapping in enterprise data warehouse environment
• Experience in developing Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like ERWIN, ER/Studio and Power Designer.
• Hands on experience with modeling using ERWIN in both forward and reverse engineering cases.
• Efficient in enterprise data warehouses using Kimball data warehouse and Inmon’s methodologies.
• Good in Data warehouse loads, determining hierarchies, building various logics to handle Slowly Changing Dimensions.
• Efficient in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modeling and UML.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Plus and SQL Navigator.
• Good understanding and knowledge with Agile and waterfall methodologies.
• Experience in design reviewing and validation of final data models.
• Excellent problem solving and analytical skills with exceptional ability to learn and master new technologies efficiently.

TECHNICAL SKILLS:

Operating Systems: Windows XP/2000/NT/Vista/7, UNIX, MS DOS, Sun Solaris.

Languages: C, Java, HTML, SQL, PL/SQL, XML

Databases: Oracle 11g/10g/9i/8i, SQL Server 7.0/2000/2005/2008 Teradata, Sybase 12.5/11, MS Access 2003/2000, DB2

Modeling Tools: ERWIN r 9.1/ 8.2/7.3/7.0, Embarcadero ER/Studio, MS VisioSybase Power Designer.

Micro: strategy, Tableau, Crystal reports XI, Business Intelligence, SSRSBusiness Objects 5.x / 6.x, Cognos7.0/6.0.

ETL Tools: Informatica Power Center 7.1/6.2, Data junction, Ab-Initio, Data Stage, SSIS.

Others: MS Office, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, MN

Sr. Data Analyst/Data Modeler

Responsibilities:

• Reviewed technical documentation to verify client requirements.
• Converted business data requirements into complex formatted data input spreadsheets.
• Executed SQL scripts and ETL load processes.
• Evaluated data loads through database queries.
• Support issue resolution through SQL and database tools.
• Worked closely with the project functional teams to make sure the requirements are satisfied.
• Reviewed project deliverables for completeness, quality, and compliance with established project standards.
• Identify, clarify, and resolve project activity issues and risks, escalating them as needed.
• Document and communicate the status of progress against plans, taking corrective action as necessary.
• Reviewed ongoing and new product changes to identify opportunities for process improvement.
• Troubleshooting Defects and Reporting Bugs using ALM tracking.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the Source ORACLE database.
• Analyzed business process workflows and assisted in the development of ETL procedures for migrating data from source to target systems.
• Created sequences and synonyms in different environments.
• Worked on multiple projects, gathered requirements and created Logical & physical data models.
• Conducted KT sessions and documented the process.
• Worked with QA/QCI team to resolve issues in DEV/TEST/PROD.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Analyzed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.
• Worked on reporting Incident tickets.
• Generated reports in Micro-strategy and Tableau.

Environment: Toad, SSIS, Windows 7, ALM, Oracle database, MySQL, MS Excel, Erwin, MySQL workbench, Splunk, CA agile central, Micro-strategy, Tableau, Salesforce, ServiceNow.

Confidential, WI

Sr.Data Modeler/Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Interacted with SME, developer to gather database requirements, actively participated in functional requirement gathering, system requirement gathering and application design.
• Developed the UML class diagrams for the proposed system using Erwin Software Architect.
• Performed data modeling using data modeling tool Embarcadero Data Architect.
• Created the data models for OLTP and Analytical systems.
• Performed in depth data analysis on Oracle and Teradata systems.
• Extensively worked with the Teradata SQL Assistant and Toad.
• Involved in data profiling to integrate the data from different sources.
• Extensively performed the gap analysis and impact analysis.
• Created the data mapping document from source to target and the data quality assessments for the source data.
• Worked with DBAs on support needs and provide guidance on architectural issues.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules.
• Good Experience in dealing Data Quality Issues.
• Conducted performance tuning of the database that included creating indexes, optimizing SQL statements.
• Created action plans to track identified open issues and action items related to the project.
• Assisted QA for developing test plans and test cases for Unit Testing, System Testing and Enterprise testing.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
• Extensively worked on the naming standards which incorporated the enterprise data modeling standards and generated reports to verify the model against the pre-defined enterprise standards.
• Designed the physical model for implementing the model into oracle 10g physical data base.

Environment: Erwin 8.0, Oracle Database 10g, Teradata 12.0, Windows 7.

Confidential, Minneapolis, MN

Sr.Data Modeler

Responsibilities:

• Interacted with Business Analysts to gather the user requirements
• Developed Logical data model and documentation for the entities, attributes, primary and foreign key structures, data relationships etc.
• Worked with DBA’s to create a best fit physical data model from the logical data model.
• Analyzed existing Conceptual and Physical data models and altered them using Erwin to support

enhancements.

• Created Design Fact & Dimensions Tables using ERWIN tool.
• Exhaustively collected business and technical Metadata and maintained naming standards.
• Created physical data models using forward engineering
• Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Worked on slowly changing dimension tables and hierarchies in dimensions.
• Conducted performance tuning of the database that included creating indexes, optimizing SQL statements.
• Regularly conducted and participated in weekly status meetings.

Environment: Windows 7, ERWIN r 7.3, SQL server 2005, Oracle 10g, DB2, MS Excel 2010.

Confidential, New York, NY

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Created logical data model from the conceptual model and its conversion into the physical database design using ERWIN.
• Map business needs/requirements to subject area model and to logical enterprise model.
• Worked with DBA’s to create a best fit physical data model from the logical data model
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Developed the data warehouse model (star 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.
• Created physical data models using forward engineering
• Created Design Fact & Dimensions Tables using ERWIN tool.
• Exhaustively collected business and technical Metadata and maintained naming standards.
• Experience working on creating models for Teradata master data management.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Maintained the integrity of data to ensure the effective functioning and also monitored data quality.
• Created high level ETL design document and assisted ETL developers in the detail design and development of ETL maps using Informatica.
• Did Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server.

Environment: Windows 7, Teradata 14, ERWIN r9.1, SQL server 2005/2008, Business Objects XI, MS Excel 2010, Informatica 7.3.

Confidential, Dallas, TX

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Conducting the meetings with business users to gather data warehouse requirements
• Conducted team meetings and Joint Application Design (JAD) session
• Gathered requirements and created use case diagrams as part of requirements analysis.
• Developed a Conceptual model using ERWIN based on requirements analysis.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Developed normalized Logical and Physical database models to design OLTP system for education finance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using ERWIN r8.2.
• Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems
• Used ERWIN for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Identified the Facts and Dimensions.
• Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.
• Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Involved in Data Mapping.
• Participated in performance management and tuning for stored procedures, tables and database servers.

Environment: ERWIN r8.2, SQL, SQL Server 2000/2005, Rational Rose, Windows XP, Oracle 8i, Windows XP/NT/2000

Confidential, San Francisco, CA

Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Interacted with end users to identify key dimensions and measures that were relevant quantitative.
• Created the Source System Analysis documents and Architectural Solution documents.
• Developed the logical and physical data model for the proposed solution.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Created views to support the Business Objects.
• Responsible for creating the staging tables and source to target mapping documents for the ETL process.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Extensively used the dimensional normal form for the data ware house design.
• Involved in many of the integration projects.
• Created Indexes and capacity planning and worked closely with the DBA’s.
• Created Summary and Aggregate tables for better performance of the query.

Environment: Oracle Database 10g, Teradata 12.0, Windows XP, TOAD for Data Analysis, ERWIN r7.3, Teradata SQL Assistant 13.0.

Confidential

Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Developed project plan with project manager’s assistance for the first two phases of the project.
• Developed system flow and data flow diagrams for the proposed system.
• Designed conceptual and logical data models.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering in ERWIN tool.
• Normalized the tables up to 3NF.
• Involved in the critical design review of the finalized database model.
• Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
• Involved in designing and implementing the security for the databases.
• Helped in migration and conversion of data from the Sybase database into Oracle 10g database, preparing mapping documents and developing partial SQL scripts as required.
• Created stored procedures, functions, database triggers and packages as per the business needs for developing Adhoc and robust reports. Incorporated Dynamic SQL, for generation of the where clauses dynamically based on the lexical parameters passed.
• Responsible for development and testing of conversion programs for importing data from text files into map Oracle database utilizing PERL shell scripts & SQL*Loader.
• Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Oracle Database 10g, SYBASE, Linux, Windows XP, ERWIN r7.3, TOAD, SQL*PLUS, SQL*LOADER.