SUMMARY

• Around Seven years of experience in data modeling with knowledge in finance, banking, healthcare and retail domain.
• Expertise in data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Experience in developing Entity - Relationship diagrams, modeling Transactional Databases and Data Warehouse.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions, creation of cubes.
• Proficient in Normalizing (using 3NF) and De normalizing techniques for optimum performance in relational and dimensional database environments.
• Experience in developing conceptual, logical and physical data models as per enterprise standards.
• Efficient in process modeling using data modeling tools in both forward and reverse engineering cases.
• Experience in designing the Star and Snowflake Schema, identifying the Facts and Dimensions.
• Worked with various RDBMS like Oracle 9i/10g/11g, SQL Server 2005/2008,DB2 UDB, Teradata.
• A good understanding of Extract, Transform and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS) and Informatica.
• Experience in Ralph Kimball and Bill Inmon approaches.
• Good understanding and knowledge with Agile and Waterfall environments.
• Worked on creating source to target mapping documents for SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Informatica environments.
• Facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams.
• Experience with Oracle Tools and utilities such as TOAD, SQL*Plus and SQL Navigator.
• Good experience in data transformation, data mapping from source to target database schemas and also data cleansing.
• Good experience with DDL and DML including Functions, Indexes, Joins, Views, Constrains, Primary key, foreign key.
• Excellent analytical, communication skills with clear understanding of business process flow, SDLC life cycle. Quick starter with ability to master and apply new concepts. Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, ER Studio, Power Designer

ETL Tools: Microsoft DTS/SSIS, ODI and Informatica

Programming Languages: SQL, T-SQL,HTML, XML

Database Tools: Microsoft SQL Server 2000/2008, Teradata, Oracle 10g/11g, MS Access,DB2

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

Operating Systems: Windows, Unix

PROFESSIONAL EXPERIENCE

Confidential, Tulsa, OK

Sr. Data Modeler/Analyst

RESPONSIBILITIES:

• Gathered and translated business requirements, worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
• Worked with DBAs to create a best fit Physical Data Model from the Logical Data Model using Erwin.
• In order of better understanding the requirement documents, carried out couple of JAD sessions with Management, SME (Subject Matter Expertise), vendors, users and other stakeholders.
• Worked on the conversion process of data which is stored in flat files into Oracle tables.
• Conducted team meetings and JAD sessions.
• Implemented naming standards, and warehouse metadata for fact and dimension of Logical and Physical Data Model.
• Worked on data mapping process from source system to target system.
• Widely used Normalization methods and have done different normalizations (3NF).
• Identified the measures and dimensions and organizing these into facts in creating the Dimensional Model within the business requirements.
• Translated the Logical Data Model into Physical Data Model with Forward Engineering in Erwin tool.
• Conducted logical data model walkthroughs and validation.
• Designed Fact tables, Dimension and aggregate tables for Data warehouse.
• Performed in depth data analysis on Oracle and Teradata systems.
• Extensively worked with the Teradata SQL Assistant and Toad.
• Developed and maintained the central repository, populated it with the metadata.
• Developed the data warehouse model (star schema) for the proposed central model for the Project
• Design, develop and implement test plan to test the data migration process.
• Worked with business analyst in generating weekly reports.

Environment: Erwin 9.5, SQL Server 2008, Windows, MS OLAP, SQL Loader, SQL Server 2008 Reporting Services (SSRS), Crystal Enterprise 10.

Confidential, Hamilton, NJ

Sr. Data Modeler/Analyst

RESPONSIBILITIES:

• Developed a Conceptual model using Erwin based on requirements analysis.
• Produced functional decomposition diagrams and defined logical data model.
• Designed a logical and physical data model using data modeling tool Erwin.
• Used forward engineering to create DDL from Physical Data Model, based on the requirements from the Logical Data Model.
• Conducted team meetings and Joint Application Design (JAD) session.
• Involved in implementing data warehouse using Ralph Kimball methodology along with architects and data governance teams and consulted the team on the design issues and implementations.
• Conducting the meetings with business users to gather data warehouse requirements.
• Interacted with the Business Analyst, QA team in their testing and DBA’s.
• Used Normalization and De Normalization methods.
• 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.
• Designed multiple facts and dimensions and implemented data marts.
• Identified and tracked the Slowly Changing Dimensions(SCD) and determined the hierarchies in dimensions.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Involved in Data Mapping activities for the data warehouse.
• Developed monthly summary and downstream data marts from enterprise wide databases in accordance with reporting requirements with dimensions like time, customers, services and accounts.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Handled performance requirements for databases in OLTP and OLAP models.

Environment: Erwin, oracle 11g,SSIS, SSRS, MS Excel, Informatica (IDQ).

Confidential, Reston, VA

Sr. Data Modeler/Analyst

RESPONSIBILITIES:

• Extracted data from data sources Oracle, CSV files, text files, SQL-Server and applied required transformations to clean the data.
• Lead the data architecture approach and worked closely with the ETL development team who design and develop the data load programs to extract, transform, and load the data from the source systems to the target BI databases.
• Create the architectural artifacts for the Enterprise Data Warehouse and the Operational Dashboard, such as Entity Relationship Diagrams (ERD), the DDL scripts, the Conceptual Data Model, and technical as well as business documents.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging into data warehouse.
• Followed 3 NF normalization techniques to create the model.
• Created integrity rules and defaults.
• Documented various requirements based on the changes that occur day to day.
• Performed Data Quality analysis to identify the quality of data, which is being stored.
• Interacted with systems and business teams to define business requirements, and conducted various reviews to finalize the artifacts.
• Interacted with ETL developers for making them understand the movement of required data.
• Worked with Data architects and IT architects to understand the movement of data and its storage.
• Successfully deployed SSIS package into production environment using package configurations to export various package properties which indeed make the package environment independent
• Document all the data modeling procedures, technical design
• Created Physical, Conceptual, and Logical model applying Kimball methodology using Erwin tool.
• Developed UML case diagrams contribute in the Functional documents for better understanding.
• Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, text, csv files.
• Used XML source in SSIS to read data from XML files into SQL server destination
• Created data source views from Oracle SQL Server and MY SQL data sources
• Used named queries and named calculations to modify the data source view
• Worked with STAR and SNOW Flake schema designs for the financial data-mart
• Created custom time dimensions and worked with role playing dimensions, degenerated dimensions.
• Created financial cube on geography and time dimensions along with parent child and balanced hierarchies
• Reported data using excel connecting to Micro Strategy(MSTR).
• Created roles and worked on database level and dimension level security on cubes
• Created aggregations based on year to improve the query performance and optimizing the storage.
• Involved in establishing organizational level analytics with help of Proclarity.

Environment: Erwin Data Modeler 8.2, TD SQL Assistant, MS SQL Server 2008, Toad Data Analyst SSIS/SSAS/SSRS 2008,MSTR,SQL Server Profiler, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS).

Confidential

Data Analyst

RESPONSIBILITIES:

• Responsibilities included gathering and preparation of requirements, functional specifications, technical specifications and the design of the database.
• Prepared the test cases, test plan for testing the Programs.
• Testing responsibilities included unit testing, integration testing, and business acceptance testing.
• Analyzing sell patterns and signifying techniques for upgrading.
• Created stored procedures and maintained internal applications.
• Provide expertise and recommendations for physical database design, architecture, testing, performance tuning and implementation.
• Identified and determined security violations, the causes of it and recommend corrective actions to ensure data security.
• Experience in off-hours on call support, handling resolution of issues on business critical production.
• Installed and configured SQL Server.
• Designed and developed the databases.
• Created a logical design of the central relational database using Erwin.
• Expertise in the forward engineering of the logical models to generate the physical tables using Erwin.
• Configured the DTS packages to run in periodic intervals.
• Extensively worked with DTS for Data Migration from source systems.
• 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.
• Created tables, views, triggers and indexes.
• Created integrity rules and defaults.
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Developed several forms & reports using Crystal Reports.

Environment: Erwin, SQL server 7.0, Windows XP, Crystal Reports, MS SQL server Analysis Manager, SQL Navigator.

Confidential

SQL Developer

RESPONSIBILITIES:

• Installed and configured SQL Server.
• Designed and developed the databases
• Created a logical design of the central relational database using Erwin.
• Involved in the forward engineering of the logical models to generate the physical tables using Erwin.
• Configured the DTS packages to run in periodic intervals.
• Extensively worked with DTS to load the data from source systems.
• Writing 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.
• Created tables, views, triggers, stored procedures and indexes.
• Created integrity rules and defaults.
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Developed several forms & reports using Crystal Reports.
• ADO.NET objects such as SQL connection, sql data adapter, sql data reader are used to retrieve the result sets from the SQL server.

Environment: SQL server 7.0, Erwin 5.0, Windows XP, Crystal Reports, Visual Studio.NET.