PROFILE:

Data Modelling professional with around 7 plus years of total IT experience and experstise in data modeling for data warehouse/data mart development ,SQL and analysis of Online transactional Processing OLTP , data wearhouse OLAP and business Intellegence BI applications.

Experience Summary

• Proficient in all phases of the Software Development Lifecycle SDC .
• Extensive IT experience in Data Modelling, Data warehouse Design, ER Modelling, Business Object Modeling, Dimensional Modeling Star Schema. Snowflake Schema Modeling and good understanding of Online Transaction Processing and Online Analytical Processing OLTP OLAP .
• Generated DDL Scripts from Physical Data Model by using Forward Engineering technique
• Immense Experience in Customer Interaction, Collecting and Handling Customer Requirements.
• In a data warehouse environment, designed the staging area based on OLTP concepts, cleansed and profiled before loading into data marts.
• Coherent with Normalization/Denormalization techniques in relational/dimensional environments and have performed normalizations upto 3NF Third Normal Form .
• Competent knowledge in Data Modeling tools like ERWIN, IBM Rational Software Architect RSA and Embarcadero ER/Studio.
• Experienced as both an onsite and offshore project member.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and Strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions SCD Type I and Type II.
• Well versed in Forward and Reverse Engineering principles.
• Conversant in oracle tools and utilities like Toad, SQL PLUS, SQL Developer.
• Expertise in SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS
• Created data mappings to load data from target using different transformations and executed workflows for data loads to target systems.
• Good understanding of Ralph Kimball's and Bill Inmon's modeling techniques.
• A good expertise in Extract Transform and Load ETL data from spreadsheets, database tables and other sources using Informatica.
• Well-versed in writing SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.
• An excellent experience in generating ad-hoc repots using Crystal Reports.
• 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.

Skill Set

Professional Experience

Confidential

Role: Sr. Data Modeler / Data Analyst

Responsibilities:

• Created Design Fact Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Interacted with the business users on regular basis to consolidate and analyze the requirements.
• Identified, formulated and documented detailed business rules and use casesbased on requirements analysis, Involved in multiple projects with different business units. .
• Identified the Entities and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.
• Had a strong working experience in Extract/Transform/Load ETL design and implementation in areas related to Teradata utilities such as Fast Export and MLOAD for handling numerous tasks.
• Developed in Star and Snow flake schema dimensional data models.
• Enforced Referential Integrity R.I for consistent relationship between parent and child tables
• Extracted data from databases Oracle, SQL server and DB2 using Informatica to load it into a single repository for Data analysis.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models
• Compare data with original source documents and validate Data accuracy.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Used SQL Server Reporting Services SSRS to create reports.
• Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Developed Data Migration and Cleansing rules for the Integration Architecture OLTP, ODS, DW .
• Experienced in development of ETL mapping and scripts.
• Worked on multiple Data Marts in Enterprise Data Warehouse Project EDW
• Involved in designing OLAP data models extensively used slowly changing dimensions SCD .
• Involved in Generating ad-hoc reports using crystal reports 9.

Environment: Erwin 9, Oracle 11g, SQL Server, Crystal Reports, Windows 7, MS Office, Business Objects

Confidential

Role: Data Modeler/Data Analyst

Responsibilities:

• Involved in requirement gatheringand data analysisand Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community.

• Involved in logical and physical designs and transforming logical models into physical implementations.
• Normalized the data up to 3rd Normal form.
• Created Entity/Relationship Diagrams, grouped and created the tables, validated the data, identified PKs for lookup tables.
• Involved in modeling Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Utilized Erwin's forward/reverse engineering tools and target database schema conversion process.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages
• Designed data flows that extract, transform, and load data by optimizing SSIS performance
• Worked with slowly changing dimensions SCDs in implementing custom SCD transformations.
• Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic
• Integrated data from various Data sources like MS SQL Server, DB2, Teradata using Informatica to perform Extraction, Transformation, loading ETL processes .
• Developed mappings, sessions and batches for relational flat file sources and targets. Loaded data into target database from sources using Workflow Manager.
• Worked on stored procedures for processing business logic in the database.
• Performance query tuning to improve the performance along with index maintenance.
• Worked on the reporting requirements for the data warehouse.
• Created support documentation and worked closely with production support and testing team.

Environment: ERWIN 8.2, Oracle 11g, Crystal Reports, Toad, Windows OS, DB2, Teradata, SSRS, Business objects , SQL Server 2008

Confidential

Role: Data Modeler/Data Analyst

Responsibilities:

• Extensive analysis to find the issues present in the existing financial planning sources.
• Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community.
• Analyzed on what enhancements needed on the source systems.
• Designed new financial planning data mart to make the data available in the required format.
• Had working sessions with finance users to understand the grain for each subject area.
• Worked with business users to validate the reference data.
• Created detailed data specifications document which is a source for ETL team.
• Supported ETL team in understanding rules for loading data into data mart.
• Wrote SQL prototypes against new strategic sources to confirm the numbers are showing the same.
• Maintained complete metadata in the Erwin model.
• Maintaining database change logs, Sub models.
• Extensively using the Erwin design tool Erwin model manager to create and maintain the versions of the Financial Planning Data Mart.
• Helped testing team to create test cases.

Environment: ERWIN 8.2, Oracle 11g, Crystal Reports, Toad, Windows OS, DB2, Teradata, SSRS, Business objects , SQL Server 2008

Confidential

Role: Data Modeler/Data Analyst

Responsibilities:

• Involved in gathering user requirements along with the Business Analyst.
• Participated in creating the logical model of an online processing system for a large financial institution using Erwin.
• Worked with DBAs to generate physical model.
• Worked on Bill inmon methodologies for modeling.
• Created tables, views, procedures and SQL scripts and mapping documents.
• Worked on slowly changing dimensions SCD and hierarchical dimensions
• Worked on conversion process of data, which is stored in flat files into oracle tables.
• Designed and Developed SQL procedures, functions and packages to create Summary tables.
• Generating ad-hoc reports using crystal reports 9.
• Developed database backup and restore policy.
• Expertise in Creating Report Models for building Ad-hoc Reports Using SSRS.
• Expertise in Generating Reports using SSRS and Excel Spreadsheet.
• Expertise in Creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down Reports.
• Hands on Experience in creating ETL Packages using SQL Server 2005 Integration Services SSIS .
• Good Understanding in Database and Data Warehousing Concepts.

Environment:Oracle8i,SQLServer,SSIS,SSRS,ERWIN,HTML,Crystalreports9,MSOFFICE,WindowsXP.

Confidential

Role: SQL Developer

Responsibilities:

• Installed and configured SQL Server.
• Designed and developed the databases
• Created a logical design and physical design of the central relational database.
• 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.
• Has very good knowledge of the SQL code
• Excellent Experience with data modeling tools like Erwin
• Solid understanding of relational databases

Environment: Erwin, SQL Server, Windows NT, Crystal Reports