SUMMARY

• Around 7 years of extensive experience in Data Modeling, Data Analysis for Online Transactional Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications
• Good understanding of Software Development Life Cycle (SDLC), Project management methodologies and Microsoft SQL server database management systems.
• Expert in Agile and waterfall methodologies.
• A good expertise in Extract Transform and Load (ETL) data from spread sheets, database tables and other sources using Microsoft Data Transformation Service (DTS) and Informatica.
• Experience in developing Entity Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like ERWIN, ER/Studio and Power Designer.
• Efficient in with Normalization (1NF, 2NF and 3NF) and De - normalization techniques for improved database
• Performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Worked in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Experienced in data cleansing, data transformation, data mapping specifications from source to target database.
• Worked on collecting business and technical Metadata and maintained naming standards.
• Well versed in Kimball/Inmon data warehouse philosophies.
• Efficient in data mart design and creation of cubes using dimensional data modeling and identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Developed the data warehouse model (star schema) for the proposed central model for the project.
• Experienced in creating models for Oracle/Teradata/ SQL Server/DB2.
• Experienced in working with BI Reporting teams which use tools such as Micro-Strategy, Business Objects and SSRS as well as development of ETL mapping and scripts.
• Experienced in Data Extraction/Transformation/Loading (ETL), Data Conversion and Data Migration by using SQL Server Integration Services (SSIS) and PL/SQL Scripts. Experienced in supporting Informatica applications, data extraction from heterogeneous sources using Informatica Power Centre.
• Experienced in dealing with different data sources ranging from flat files, Excel, Oracle, Sybase, SQL server.
• Experienced in designing, error handling and exception handling procedures to identify, record and report errors.
• Good knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.

TECHNICAL SKILLS

Databases: Oracle7/8i/9i/10g/11g, SQL Server 2000/2005/2008/2012 , Sybase, Teradata, DB2.

Modeling Tools: Erwin 8.x/9.x,ERStudio 9.x, Power Designer.

Reporting Tools: Cognos 8 / 10, Oracle Reports, Tableau, Business Objects, and IDQ.

Other Tools: SQL Navigator, TOAD, T-SQL, Informatica Power Center, Ab Initio, Teradata SQL Assistant.

Languages: C, C++, VB, Java, Perl, PHP, PL/SQL and SQL.

Operating Systems/Platforms: Windows NT, 2000 & XP, Vista, UNIX and Linux.

Frame work and methodologies: Data Modeling (ER & Dimensional), Database Design, Requirement Analysis, ETL Design, Object Oriented Design, Development, Testing, Data Mapping, Metadata Management, Master Data Management, Data Profiling, Deployment, Documentation, Project Management, and Semantic Layer.

PROFESSIONAL EXPERIENCE

Confidential - Charlotte NC

Data Modeler/ Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed reporting requirements for Data warehousing.
• Participated in JAD sessions involving the discussion of various reporting needs.
• Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.
• Developed a Conceptual models using ERWIN based on requirements analysis.
• Created ER diagrams (Entity Relationship diagrams) using ERWIN and created logical and physical models as well.
• Created dimensional model for the reporting system by identifying required dimensions and facts using ERWIN.
• Used forward engineering to generate DDL from the Physical Data Model and handed it to the DBA.
• Executed DDL to create databases, tables and views.
• Designed a STAR schema for the detailed data marts and Plan data marts involving Conformed dimensions.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Conducted design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Conducted updates and enhancements to the existing data models as required using ERWIN.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP database environments.
• Created and maintained the Data Model repository as per company standards.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Prepared analytical and status reports and updated the project plan as required.

Environment: ERwin Data r7, ER Studio, SQL Server 2000, Tableau 7.0, Crystal Reports 8.0, Sybase Powerdesign.

Confidential-New Orleans, LA

Data Modeler/Analyst

Responsibilities:

• Gathered requirements, analysed and wrote the design documents.
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Prepared High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Responsible for defining the key identifiers for each mapping/interface.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing data.
• Prepared High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Performed legacy application data cleansing, data anomaly resolution and developed cleansing rule sets for on-going cleansing and data synchronization.
• Developed the data warehouse model (Kimball’s) with multiple data marts with conformed dimensions for the proposed central model of the Project.
• Implemented Star Schema methodologies in modeling and designing the logical data model into Dimensional Models.
• Worked with Database Administrators (DBAs) to finalize the physical properties of the tables such as Partition key, based on volumetric.
• Analysed the data from the sources, designed the data models and then generated scripts to create necessary tables and corresponding records for DBAs using Informatica.
• Exposure to implementing Extraction mapping in Informatica (Mapping Designer).
• Developed number of Data correction scripts using PL/SQL to handle any manual adjustments/corrections in System.
• Member of Data model and Design Review group that oversees data model changes and system design across Enterprise Data Warehouse.
• Trouble shooting issues in Production environment.

Environment: Oracle 10g/11g, Erwin 9.1, Informatica Power Center 9.1, Teradata, Crystal Reports, MS Office, Windows

Confidential- Cleveland, OH

Data Modeler/ Data Analyst

Responsibilities:

• Involved with Data profiling for multiple sources and answered complex business questions by providing data to business users.
• Experience developing data transformation and cleansing rules for migration using ETL tools.
• Analysed multiple source system to identify the data for migration
• Performed data mining on data using very complex SQL queries and discovered pattern.
• Designed semantic layer data model. Conducted performance optimization for BI infrastructure.
• Created DML code and statements for underlying & impacting databases.
• Worked with ETL team whose ETL methodology for supporting data extraction, transformations and loading processing.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Perform data reconciliation between integrated systems.
• Involved with Data Extraction, Modification, Validation, Analysis, Management and Reporting.
• Involved in Requirement gathering, analysis of the requirements from the business owners and users.
• Analysed business and end-user needs to ensure that project data requirements are identified and deliverables are met.
• Used gap analysis to do the data mapping document which is most essential in determining the source table, source columns, destination table, destination columns, and gaps and define any business rule changes in order to fill up those gaps.

Environment: Quality Center, MS Excel 2007, PL/SQL, XML, My SQL, Erwin, Informatica, Data MiningOracle 9i, 2NF, 3NF, TOAD, Teradata SQL Assistant,IDQ.

Confidential

Data Modeler / Data Analyst

Responsibilities:

• Installed, designed and developed the SQL Server database.
• Created a logical design of the central relational database using Erwin
• Configured the DTS packages to run in periodic intervals.
• Extensively worked with DTS to load the data from source systems, and run in periodic intervals
• Worked with data transformations in both normalized and de-normalized data environments
• Involved in data manipulation using stored procedures and Integration Services.
• Worked on query optimization, stored procedures, views, and triggers.
• Assisted in OLAP and Data Warehouse environment when assigned.
• Created tables, views, triggers, stored procedures and indexes.
• Designed and implemented database replication strategies for both internal and Disaster Recovery.
• 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: Windows Server 2003, MS SQL 2000, UNIX, Erwin, Crystal Reports.

Confidential

Data Analyst/Business Analyst

Responsibilities:

• The Data Mart (BMDM) system stores marketing data in an Oracle relational database and is interrogated using the Power play\ Impromptu end-user reporting tools.
• Responsible for data modeling and building a star schema model in Erwin.
• Identified the fact tables, dimensions and the key measures.
• Used star schema methodology for the modeling of the data.
• In creation of the data mart new functionality had to be added like Trend data Inclusion, Product Profitability Calculation \ Reporting, Concept Reporting, Size Of Line Reporting, Global Brand Grouping \ Reporting etc.
• Created an enterprise data dictionary and maintained standards documentation.
• Assisted data warehouse project team in extracting business rules.
• Analysis of data requirements and translation of these into dimensional data models.

Environment: Erwin, SSRS, SQL Server 2000/ 2005, Oracle 10g, UNIX, Toad, MS Office.