SUMMARY:

• Seven years of experience in Data Modeling, Data Designing and Data Analysis.
• Worked in Financial, Insurance, Healthcare and Energy domains.
• Experience in Logical/Physical Data Modeling, Relational and Dimensional Modeling for Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Developed Logical Data Model from Conceptual Data Model and transforming into Physical Data Model.
• Proficiency in using Data Modeling tools like Erwin, ER Studio and Power Designer in developing and modeling Entity Relationship diagrams, Transactional and Data warehouse Databases.
• Well versed wif the concepts of Forward Engineering and Reverse Engineering for the existing databases for the Conceptual and Logical/Physical models using Erwin tool.
• Generated DDL Scripts from Physical Data Model by using Forward Engineering technique
• Proficiency in Normalization to 3NF and Denormalization techniques for optimum performance of database environments like OLTP and OLAP systems.
• Experience in developing transactional enterprise data models which meet the normalization rules strictly and understanding of enterprise data warehouses by using Ralph Kimball Data warehouse methodologies.
• Well versed in system analysis ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
• Proficient in Data Analysis using SQL on Oracle MSSQL server and MS access
• Involved in implementing the Referential Integrity by using Primary and Foreign key relationships
• Good Knowledge in designing the data marts using Ralph Kimball's and Bill Inmon Dimensional Data Mart Modeling techniques.
• Experience in developing database schemas like Star Schema and Snowflake Schema for Dimensional Modeling and identifying Facts and Dimensions.
• Identified Slowly Changing Dimensions, Role Playing Dimensions and Hierarchies in dimensions.
• Developed test plans, test cases, procedures and designed documents wifin the given business requirements.
• Experienced wif Dimensional Data Modeling for Data Mart
• Experienced as Data Modeler for Data Warehousing wif good knowledge and expertise in all software development methodologies like Waterfall, Agile, Scrum in phases including analysis, Development, Testing and Maintenance..
• Organized User Acceptance Testing (UAT), conducted presentations and provided support for business users.
• Good Knowledge on SQL queries and creating database objects.
• Worked closely wif Business, DBA team, ETL and Reporting teams to define data requirements.
• Environment: Erwin, MS SQL Server 2008, Oracle 11g, Toad, Windows 7, MS Office, MS Visio. Worked on Data Profiling, Data Mapping, Data Validation and Data Cleansing for data accuracy between the data warehouse and the source systems.
• Proficiency in databases using Oracle 10g/11g, DB2, SQL server and Toad.
• Excellent analytical and problem solving skills, TEMPeffective team worker and quick learner wif the ability to master and work efficiently wif new technologies.
• Excellent communication and inter personal skills in understanding the flow of business process and ability to interact wif all the levels in Software Development Life Cycle (SDLC).

TECHNICAL SKILLS

Data Modeling Tools: Erwin r9.5/7.2/8.0, Embarcadero ER/Studio and Oracle Designer

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports9

ETL Tools: Microsoft DTS/SSIS, Data Stage 7.5, AbInitio and Informatica 7.1.3

Programming Languages: SQL, PL/SQL, Base SAS, HTML, XML, VB.NET, C, C++, UNIX and Shell Scripting

Database Tools: Microsoft SQL Server 2000/2005, MySQL, Oracle 10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio

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

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, FL

Sr. Data Modeler / Data Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings wif business users.
• Created logical data model from the conceptual model and it’s conversion into the physical database design using Erwin.
• Map business needs/requirements to subject area model and to logical enterprise model.
• Worked wif 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.
• 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 wif 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
• Interacted wif the data base administrators and business analyst for data type and class words
• 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.
• Involved in extensive Data Analysis on the Teradata and Oracle systems querying and writing in SQL and TOAD.
• Worked wif Architecture team to get the metadata approved for the new data elements dat are added for dis project.
• Ensured the quality consistency and accuracy of data in a timely affective and reliable manner.
• Maintained the integrity of data to ensure the TEMPeffective functioning and also monitored data quality.
• Created high level ETL design document.
• Did Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server.

Environment: Windows 2000/XP, Teradata 14, Erwin r9.1, SQL server 2005/2008, Business Objects XI, MS Excel 2007, Informatica 7.3.

Confidential, New York City NY

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Conducting the meetings wif 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 wif 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.
• Interacted wif the data base administrators and business analyst for data type and classwords
• Used forward engineering to create a Physical Data Model wif DDL, based on the requirements from the Logical Data Model.
• Involved in extensive data analysis on the Teradata and Oracle systems querying and writing in SQL and TOAD.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Worked wif 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 TEMPeffective 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, Chicago, IL

Data Modeler/Data Analyst

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 wif Business Analyst.
• Interacted wif end users to identify key dimensions and measures dat 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 entire SDLC (Software Development LifeCycle).
• 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.
• Involved in extensive data analysis on the Teradata and Oracle systems querying and writing in SQL and TOAD.
• Created dimensional model for the reporting system by identifying required dimensions and facts using ERWIN
• 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 wif 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, Plymouth Meeting, PA

Data Modeler/Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Developed project plan wif 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.
• Ensured the quality consistency and accuracy of data in a timely affective and reliable manner.
• 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..
• Involved in the daily maintenance of the database dat 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.

Confidential

Data Modeler/ ETL Developer

Responsibilities:

• Responsible for requirements gathering and documenting design specifications.
• Designed Logical Data Modeling design using Erwin according to business requirements
• Involved in the creation and implementation of the physical database.
• Designed and developed the required stored procedures, triggers and database functions.
• Scheduled DTS tools and services to run at different intervals in SQL server for developing ETL Routines to populate the database from different sources.
• Extracted and loaded the data from the flat files.
• Worked wif SQL Server Analysis Services to build the data warehouse dat captured data from developed and existing OLTP systems.
• Created OLTP cubes using Cube and Dimension Wizards.
• Involved in loading the data from source tables to target data warehouse by performing transformations and validations.
• Performance query tuning to improve the performance along wif index maintenance.
• Worked on the reporting requirements for the data warehouse.
• Created support documentation and worked closely wif production support and testing team.

Environment: SQL Server, Oracle, DTS, Win NT, Cognos, MS Analysis ServicesERwin.

Confidential

Data Modeler /SQL Developer

Responsibilities:

• Involved in requirement gathering along wif the business analysts group.
• Gathered all the Sales Analysis report prototypes from the business analysts belonging to different Business units
• Gathered various requirement matrices from the business analysts.
• Participated in Joint Application Development(JAD) sessions
• Conducted Design discussions and meetings to come out wif the appropriate Data Model
• Designed for the various reporting requirements
• Designed a logical data model using database tool ERWIN r7.0
• Used ER Studio to create logical and physical data models for enterprise wide OLAP system.
• Developed monthly summary and downstream data marts from enterprise wide databases in accordance wif reporting requirements wif dimensions like time, customers, services and accounts.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse
• Modeled the dimensions and facts using Erwin for centralized data warehouse
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions
• Actively participated in data mapping activities for the data warehouse.
• Created summary tables using de-normalization technique to improve complex Join operations
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis pertaining to Loan products
• Participated in the tasks of data migration from legacy to new database system
• Worked on Metadata exchange among various proprietary systems using XML.
• Conducted Design reviews wif the business analysts, content developers and DBAs
• Designed and implemented a physical data model to handle marketing strategies and to satisfy reporting needs dynamically.
• Handled performance requirements for databases in OLTP and OLAP models.
• Worked wif the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Erwin r7.0, ER Studio, SQL Server 2000/2005, Windows XP/NT/2000, Oracle 8i, MS-DTS, UML, SQL Loader, Rational Rose 2000.

Confidential

Data Modeler.

Responsibilities:

• Involved in the entire System study, analysis and Design.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Created a logical design and physical design of the central relational database.
• Involved in the analysis of how the purchase order process was organized.
• Created integrity rules and defaults.
• Created SQL tables wif referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL.
• Involved in writing Triggers which internally called procedures and functions.
• Involved in testing the database for queries dat were generated and handled the performance issues TEMPeffectively.
• Maintained security and data integrity of the database.
• Involved in documenting the entire technical process.
• Supported technical teams involved wif ORACLE issues and operations.
• Involved in the maintenance of the database.

Environment: Oracle 9i/8i, PL/SQL, Oracle Designer and UNIX