SUMMARY

• Extensive knowledge and experience in all phases of Software Development Life Cycle (SDLC) .
• Experience with requirement gathering, conducting Joint Application Development (JAD) and Joint Requirement Planning (JRP) sessions, User Acceptance Testing (UAT), Gap analysis.
• Experienced in creating and maintaining Naming Standards.
• Exposure to Data Governance.
• Experienced in design of Relational and Dimensional Data Modeling using data modeling tools like Erwin data modeler, Power Designer, Microsoft Visio and Embarcadero ER studio and also implementing RDBMS specific features.
• Experienced in Conceptual / Logical models and Physical database design for Online Transactional Processing (OLTP), Operational Data Store (ODS) and Online Analytical Processing (OLTP) systems.
• Experience in Normalization (3NF) and De Normalization techniques for optimum performance in relational and dimensional environments.
• Worked extensively on Forward and Reverse engineering processes.
• Experience in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Strong Data analysis skills for Decision Support System (DSS), OLTP and OLAP.
• Strong knowledge in Data mapping from source to target database schemas, Data Profiling, Data Cleansing and writing data scripts.
• Experience in identifying and developing the Facts and Dimensions from the Enterprise Architecture for designing Star Schema and Snowflake Schema.
• Strong physical data modeling experience on multiple database platform like Oracle, MS SQL, DB2, Sybase, Teradata.
• Proficient in using data analysis tools like SQL Server Management Studio, Toad and SQL developer.
• Excellent in using the Ralph Kimball's and Inmon methodologies.
• Experience in creating reports wireframe/prototype and Unified Modeling Language.
• Good exposure to tools like Informatica, Micro Strategy and IBM Data Stage and SSIS 2008/2005.
• Experience in dealing with different data sources ranging from flat files, Excel, Oracle, Sybase, and SQL Server.
• Experienced in creating standard abbreviation document for logical, physical and dimensional data models.
• Attention to detail, self - motivating and enthusiastic to work in a fast paced environment with new technologies as an individual and/or as a team member.

TECHNICAL SKILLS

Data Modeling Tools: Erwin data modeler r 9.1/ 8.2/ 7.3/ 7.0 , ER Studio, MS VISIO, Rational Rose, Oracle Designer, IBM infosphere Data Architect

Operating Systems: Windows, Unix, Linux, Mac OS, MS DOS

RDBMS: Oracle9i/10g/11g, MS SQL Server 2008/05/00, MS Access, Teradata, DB2, Sybase and PL/SQL.

Language’s: C, C++, Java, .NET, PL/SQL and SQL, HTML, XML, UML’s.

Reporting Tools: Cognos 8, Microsoft Analysis Services, Business Intelligence, Actuate Reports 10, OBIEE and Crystal Reports 9.

Other Tools: Toad, SSMS, Microsoft DTS/SSIS, MS Office, MS Project, Informatica, Win Runner, Load Runner, Quick test Pro

ETL Tools: Infomatica Power center 8.6/7.1/6.2 and Microsoft DTS/SSIS.

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Data Modeler

Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solution.
• Gathered the required document and analyzed the process.
• Assisted developers, ETL, BI team and end users to understand the data model.
• Created Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Developed the logical data models and physical data models that captured current state/future state data elements and data flows using ERwin.
• Worked on Bill inmon methodologies for modeling.
• Worked with Enterprise Architecture teams to come up with Naming Standards.
• Involved in identifying the process flow, the work-flow and data flows of the core systems.
• Worked closely with the Data Architect team to acknowledge the highlevel classes, attributes and in corporate them into the Business Object Model (BOM).
• Created models for Teradata master data management.
• Worked extensively on Forward and Reverse engineering processes.
• Translated the model into physical model using the Forward Engineering technique in Power Designer.
• Used ModelMart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Redefined many attributes and relationships in the reverse engineered model.
• Conducted walkthroughs with the DBA to convey the changes made to the data models.
• Extracted the Metadata from the Metadata repositories to generate the Mapping Documents.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
• Effectively used Normalization to 3NF/Denormalization techniques for optimum performance.
• Performed updates and enhancements to the already existing data models as required by using ERWIN/CA.

Environment: SQL Server, Teradata, Oracle, DTS, Win NT, Business Objects and Erwin, star schema, snowflake schema, Sybase 12, Informatica

Confidential, Charlotte, NC

Data Modeler

Responsibilities:

• Gathered the business requirements document and analyzed the data.
• Created logical data models from the conceptual data models and its conversion into physical data model design using Erwin.
• Extracted data from data sources Oracle, CSV files, text files, SQL-Server, Teradata and applied required transformations to clean the data.
• Developed Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERwin and Power Designer.
• Developed Physical Data Model for multiple platforms - SQL Server/ DB2/ Oracle/Teradata.
• Worked extensively on Forward and Reverse engineering processes.
• Created DDL Scripts for implementing Data Modeling changes.
• Involved in the creation of the solution definition document (SDD) which was the basic source of information for the project requirement document.
• Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
• Extensively worked on Performance Tuning ofSQL and understanding Joins and Data distribution.
• Worked with ETL team to produce PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
• Develop and optimize database queries, and assist team members in database related questions and issues
• Worked on marketing attribution analysis and MROI frameworks.
• Resolved the data type inconsistencies between the source systems and the target system using the Source-to-Target Mapping Documents.
• Developed and worked with both structured and unstructured data and analytics
• Manage data suppliers to understand incoming data and relationships.
• Provide Source to Target Mappings from data models to provide basis for data integration (ETL) specifications.
• Assist with SLA definition, analysis and application performance tuning
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using ER Studio.
• Enforced mandatory capture metadata during the logical phase design.

Enviroment: SQL, Teradata, Erwin platform, Power Designer, Oracle, SQL server, Win NT, Star Schema, Sybase

Confidential, Boston, MA

Data Modeler

Responsibilities:

• Gathering requirements from the SME’s and BSA’s and documenting the requirements in the data definition specification documents.
• Responsible for requirements gathering and documenting design specifications.
• Created Conceptual, Logical, and Physical data models using ER studio for new system
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
• Worked in the development of Physical Data Model for multiple platforms - SQL Server/ DB2/ Oracle/Teradata.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Developed mappings in Informatica to load the data from various sources includes SQL server, DB2, Oracle, Flat files into the Data Warehouse
• Experience in different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator.
• Create ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server usingSSIS.
• Scheduled DTS tools and services to run at different intervals in SQL server for developing ETL Routines to populate the database from different sources.
• Developed Data Migration and cleansing rules for the integration architecture.
• Developed a data topology based on the data storage, various replications, and movements of data.
• Scheduled DTS tools and services to run at different intervals in SQL server
• Developed ETL Routines to populate the database from different sources.
• Developed entities and relationships using Sybase Power Designer.
• Establish and maintain processes to support and grow data modeling practices, conceptual, intermediate logical/ canonical and physical data models per company direction.
• Conduct Design reviews with the business analysts, content developers and DBAs to ensure the feasibility of the designs.
• Worked with SQL Server Analysis Services to build the data warehouse that captured data from developed and existing OLTP systems.
• Performance query tuning to improve the performance along with index maintenance.
• Used Star and snowflake schema in dimensional data modeling in designing data marts.
• Developed data mapping documents between legacy, production and user interface systems.
• Implemented slowly changing dimensions Type2 and Type3 for accessing history of reference data changes.

ENVIRONMENT: SQL Server, Oracle, DTS, Win NT, Business Objects and Erwin, star schema, snowflake schema, Sybase

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Gathered and transferred business and functional requirements and Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing Broker Portal system
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements
• Created entity diagrams and relationship diagrams and modeled cascade to maintain referential integrity.
• Cleansed, extracted and analyzed business data on daily basis and prepared ad-hoc analytical reports using Excel and T-SQL.
• Performed GAP analysis with Teradata MDM and Drive (SQL) data Models to get clear understanding of requirements.
• Identified facts and dimensions and designed the Star Schema.
• Assisted the ETL staff, developers and end users to understand the data model. Helped ETL team in understanding the complex transformation rules and creating ETL maps.
• Expertise in the development of Physical Data Model for multiple platforms - SQL Server/ DB2/ Oracle/Teradata.
• Extensively worked with DTS to load the data from source systems.
• Worked extensively on Forward and Reverse engineering processes. Created DDL Scripts for implementing Data Modeling changes.
• Developed Data Mapping, Data Governance, and Transformation and Cleansing rules.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Participated in high-level and low-level design sessions including writing technical project documentation.
• Worked on SQL queries by writing new and editing already existing codes using SQL Plus.
• Created data design documents, logical and physical data models, maintained RTM, and requirements tracker documents.
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Added database objects (like indexes, partitions in oracle database) for performance.
• Developed several forms & reports using Crystal Reports.

ENVIRONMENT: Oracle 9i, Toad 8.1, Erwin, Microsoft Windows, SQL Plus, Star Schema, Teradata, Excel

Confidential

Data Modeler/ Data Analyst

Responsibilities:

• Requirement gathering from the users. A series of meetings were conducted with the business system users to gather the requirements for reporting.
• Created SQL tables with referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL.
• Developed Physical Data Model for multiple platforms - SQL Server/ DB2/ Oracle/Teradata.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using ERWin
• Prepared logical and physical data models by recognizing the proper entity and the attributes and implementing a proper relationship between them.
• Used SSIS, SSRS in solving business problems and managing reports in organization.
• Configured report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Prepared logical and physical data models by recognizing the proper entity and the attributes and implementing a proper relationship between them Created logical and physical models using Erwin.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
• Involved in testing the database for queries that were generated and handled the performance issues efficiently.
• Worked with the Forward Engineering of the logical models to generate the physical model using Erwin.
• Interaction with the developers and business teams for writing the technical specification document (TSD).
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to in corporate the new calculations.
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Assisted reporting team (Cognos).

ENVIRONMENT: SQL Server 2000, Sybase12, Sybase Power Designer, UML, Business Objects 5, Teradata, Windows NT/2000, Erwin, Informatica, Query Management Facility (QMF), Data Stage, Clear Case forms, Unix and Shell Scripting.