SUMMARY

• 8+ years of professional experience in data modeling, analysis, design, and development of databases for business applications in OLTP and Data Warehouse environments. Extensive knowledge in finance, healthcare, banking and retail domain.
• Experience in Logical/Physical Data Modeling, Relational and Dimensional Modeling for Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems (ODS, ADS and Data Marts).
• Excellent communication and inter personal skills in understanding the flow of business process and ability to interact with all the levels in Software Development Life Cycle (SDLC).
• Experience in developing Entity - Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like Erwin, ER/Studio and Power Designer.
• Good knowledge and experience with Normalization / Denormalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Efficient in enterprise data warehouses using Kimball data warehouse and Inmon’s methodologies.
• Experience in creating Mapping documents for data extraction, transformation and loading.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience in performing Gap analysis.
• Worked extensively on XML data and XSD schema designing.
• Worked on developing data models by breaking down the XML schemas.
• Experience in designing Star Schema, Snowflake schema for Data Warehouse, by using tools like Erwin data modeler, Power Designer and Embarcadero E-R Studio.
• Experience working on creating models for Teradata master data management.
• Experience with DBA tasks involving performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.
• Good Knowledge on SQL queries and creating database objects like stored procedures, triggers, packages and functions using SQL and PL/SQL for implementing the business techniques.
• Experience in Data Analysis using SQL Queries and Data profiling tools.
• Experience in Physical modeling for various platforms like Teradata, Oracle, DB2, SQL server.
• Experience in working with different ETL tool environments like SSIS, Informatica and reporting tool environments like SQL Server Reporting Services (SSRS), COGNOS and Business Objects.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, 9.2.5,Erwin r 8.2.5,Erwin r8, Erwin r7.1/7.2, Rational Rose 2000, ER Studio and Oracle Designer

OLAP Tools: Microsoft Analysis Services, Business Objects, Crystal Reports 9

ETL Tools: Microsoft DTS/SSIS, SSRS and Informatica 7.1.3

Programming Languages: SQL, PL/SQL, VB, XML, C, C++

Database Tools: Microsoft SQL Server 2000/2008, Teradata, Oracle 10g/9i, and MS Access

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server 2003/2007.

Operating Systems: Microsoft Windows 9x / NT / 2000/ XP / Vista/7 and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

Sr. Data Modeler/ Data Architect

Responsibilities:

• Worked closely with the business and IT partners to deliver the data systems to meet their needs and understand the future direction of business.
• Collaboratively worked with the Data modeling architects and other data modelers in the team to design the Enterprise Level Standard Data model.
• Worked closely with the development and database administrators to guide the development of the physical data model and database design.
• Worked on designing Conceptual, Logical and Physical data models and performed data design reviews with the Project team members.
• Worked on different data domains like Insurance, Banking, Trust, Retirement etc. as well as various subject areas like Party, Transaction, Event, Product and Account.
• Worked on building the Logical data model from the scratch from the XMLs as the data source.
• Worked on building the data models to convert the data from one data Application to another in a way that suit the needs of the target database.
• Very familiar with the versioning and saving the models to the data mart and maintaining the Data Mart Repository.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns.
• Having a good understanding of the Software development Lifecycle.
• Ensure the data warehouse and data mart designs to efficiently support the reporting and BI team requirements.
• Produced 3NF data models for OLTP designs using data modeling best practices and modeling skills.
• Created data models for different databases like Oracle, Teradata.
• Responsible for defining the naming standards fordatawarehouse.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules.
• Enforced Referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Created Source to Target Mapping Documents to help guide the data model design from the Data source to the data model.

Environment: Erwin 9.6, Erwin 8.2.5, Altova XML Spy, Oracle 11g, Teradata R15, MS Office, Windows 7, Star Team.

Confidential, Dallas, TX

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Worked closely with Business, DBA team, ETL and Reporting teams and have good experience with requirements gathering, conducting JAD session to discuss overall design patterns of Conceptual, Logical and Physical data Models.
• Identified and compiled common business terms for the new policy generating system and also worked on contract Subject Area.
• Worked on various databases such as Oracle, Teradata and Netizza.
• Created a high-level industry standard, generalized data model to convert it into Logical and Physical model at later stages of the project using Erwin and Visio.
• Generated XMLs from the Erwin to be loaded into MDR (metadata repository)
• Identified and Defined entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use. Identified source elements and done mapping with the target systems.
• Used SQL tools like Teradata SQL Assistant and TOAD to run SQL queries and validate the data in warehouse.
• Worked extensively on both Waterfall and Agile Methodologies and have a good understanding of the Project management.
• Normalized the database based on the new model developed to put them into the 3NF of thedata warehouse.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Wrote SQL scripts for creating tables, Sequences, Triggers, views and materialized views.
• Closely worked with Business Architects and Solution Architects to created source to target mapping documents for the ETL developers and helped them understand complex transformations involving business input
• Conducted performance tuning of the database that included creating indexes, optimizing SQL statements.
• Developed and maintained data dictionary to create Metadata reports for technical and business purpose in MDR.
• Created action plans to track identified open issues and action items related to the project.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Designed Data Flow Diagrams, E/R Diagrams and enforced all referential integrity constraints.
• Prepared analytical and status reports and updated the project plan as required.

Environment: Environment: Erwin 8.2.5, Informatica Power Center 8.X, Teradata 13.0, Oracle 11g, netizza, Toad, DB2, Business Objects XI 3.1, WebI, MS Office, Windows 7.

Confidential, Seattle, WA

Sr. Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Conducted data modeling JAD sessions and communicated data-related standards
• Worked with DBAs to create a best fit physical data model from the logical data model.
• Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
• Developed logical and physical data models for central model consolidation.
• Used Erwin r8 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Developed process methodology for the Reverse Engineering phase of the project.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram)
• Utilized Erwin’s reverse engineering and target database schema conversion process.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and SQL Server.
• Extensively worked with the Teradata SQL Assistant and Toad.
• Involved in different team review meetings.
• Worked with report developers for building OLAP Cubes for ad hoc reporting.
• Performed unit testing and tuned for better performance.
• Involved in the critical design review of the finalized database model.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.

Environment: Erwin 8, Informatica 7.1.3,Toad, Oracle10g/9i, SQL Server 2000/2008, MS Excel, MS Visio, DB2, Microsoft Transaction Server, MS-SQL server analysis manager.

Confidential, Omaha, NE

Data Modeler

Responsibilities:

• Involved in gathering business requirements by conducting a series of meetings and brain storming sessions with the business users.
• Gathered and translated business requirements into detailed, production-level technical specifications, new Features, and enhancements to existing technical business functionality.
• Involved in identifying the process flow, the work flow and data flows of the core systems.
• Worked extensively on user requirements gathering and gap analysis.
• Created Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Worked on the Organization of Enterprise data using Zachman framework.
• Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the department.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Embarcadero ER Studio.
• Involved in designing the IIW warehouse for the company to store the data from the OLTP systems.
• Involved in implementing and testing of the developed application data standards.
• Involved in Data analysis for data conversion - included data mapping from source to target database schemas, specification and writing data extract scripts/programming of data conversion, in test and production environments.
• Data Warehouse - Designed and programmed ETL and aggregation of data in target database, working with staging, de-normalized and start schemas and dimensional reporting.

Environment: SQL Server 2000, Oracle Designer, PL/SQL, UNIX, Windows NT, Informatica6x.

Confidential

Data Modeler

Responsibilities:

• Identified goals and objectives of projects. Created project plan by gathering the requirements from the management.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs
• Requirement gathering from the users by conducting a series of meeting with the business system users to gather the requirements for reporting.
• Identification of risks in schedule and marking them in the Use Cases.
• Worked on creating new tables and columns to Basel data mart.
• 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
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Creating Data Definitions and the Meta Data Repository
• Worked with third party data base to store the required data for the client (Remedy A R Systems)
• Explored data to identify its model role and measurement level. Verified data for missing values and incorrect data. And then cleaned and structured the data based on the format required.
• Validated the model and ran alternate scenarios/sensitivity analysis.
• Implemented the model and communicated it to end-users and stakeholders.
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Assisted reporting team (Cognos).
• Created integrity rules and defaults.
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Used SQL to run ad-hoc queries and prepare reports to the management.
• Worked on Fidelity Information Systems (FI Systems) and Maintained security and data integrity of the database.
• Automated the reports using Crystal command

Environment: SQL Server 2000, Sybase12, Sybase Power Designer, UML, Business Objects 5, Teradata, Windows NT/2000, SSIS, SSRS, Embarcadero, ER studio, Erwin, DB2, Informatica, netizza,Query Management Facility (QMF), Data Stage, Clear Case forms, Unix and Shell Scripting.

Confidential

Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Extensively used Star Schema methodology in building and designing the logical data model.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Prepared business case for the data mart and then developed and deployed it.
• Used Erwin to transform data requirements into data models.
• Performed Reverse Engineering of the current application using Erwin, and developed Logical and Physical data models for Central Model consolidation.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Worked extensively in data analysis by querying in SQL and generating various PLSQL objects.

Environment: SQL server 2005, Linux, Windows XP, Erwin, MS Visio, TOAD

Confidential

Data Modeler

Responsibilities:

• Involved in gathering user requirements along with the Business Analyst.
• Part of the team responsible for the analysis, design and implementation of the business solutions.
• Gathered and translated business requirements into detailed, production-level technical specifications, new features and enhancements to existing technical business functionality.
• Prepared business case for the data mart and then developed and deployed it.
• Used Star schema methodology in building and designing the logical data model in the dimensional Models.
• Mapped the data between Source and Targets.
• Designed and Developed PL/SQL procedures, functions and packages to create Summary tables.
• Used MS Visio for creating of process flow diagrams.

Environment: Oracle Database 8i, SQL, PLSQL, Linux.