PROFESSIONAL SUMMARY:

• Having very Good exposure to ETL tool like Informatica.
• Performed extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.
• Experience with DBA tasks involving database creation, performance tuning,creation of indexes, creating and modifying table spacesfor optimization purposes.
• Experienced in Data loading using PL/SQL Scripts and SQL Server Integration Services packages SSIS .
• Experience in performance analysis and created partitions, indexes and Aggregate tables where necessary.
• Experience in performing gap analysis.
• Experience in SQL and good knowledge in PLSQL programming and developed Stored Procedures and Triggers.
• Experience in Data transformation and Data mapping from source to targetdatabase schemas and also data cleansing.
• Extensive experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers and Packages for business logic implementation.
• Worked with various RDBMS like Oracle, SQL Server,DB2 UDB, and Teradata.
• Extensive experience analyzing and documenting business requirements and system functional specifications including use cases 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 in Ralph Kimball and Bill Inmon approaches.
• Experience working with Agileand Waterfalldata modeling methodologies.
• Worked extensively on XML data and XSD schemadesigning.
• Strong experience working with conceptual, logical and physical data modeling considering Meta data standards.
• Having good knowledge in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in designing star schema identification of facts, measures and dimensions , Snowflake schemafor Data Warehouse, ODS architecture by using tools like Erwin datamodeler, Power Designerand Embarcadero E-R Studio .
• Extensive experience in the Data Warehousing implementations for Retail, Financial, Insurance and Banking Industries.
• 7 years of professional experience in Data Modeling, Business Object modeling Data Analysis and design of OLTP and OLAP systems.
• Building reports using SQL SERVER Reporting Services, Crystal Reportsand Business Objects.
• Experience in using and Database Tools for TOAD for data analyst.
• Excellent communication skills, self-starter with ability to work with minimal guidance.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Data Modeler

Responsibilities:

• Working with the business users, Service Integration Team, CIS Customer integration Systems to gather business requirements.
• Obtained requirements services in the form of request response XML, XSD, message layouts, ICDs .
• Identified high level Classes associated with the services.
• Worked closely with the Data Architect team to acknowledge the high level classes, attributes and incorporate them in the Business Object Model BOM .
• Performed source services to target mapping BOM
• Created, updated and maintained the BOM based on the services received for various backend functions like CIS, TEDD and EXPERIAN.
• Created Class Diagrams using the tool IBM RSA rational software architect .
• Created and updated other CCB artifacts like BOM log, mapping documents, BOM file and responsible for consolidations of the same.
• Performed merging of various BOM versions to maintain a consistent unified BOM.
• Resolved discrepancies in terms of duplications, consistency and quality by correcting with appropriate naming standards class words .
• Worked closely with the Index Modeling Team, SOA team, SI team and assisted in incorporating physical information in the BOM and XML/XSD/WSDL creation.
• Participated as the Primary, Secondary and email reviewer as a part of the Data Consistency Review Board DCRB .

Environment: IDM Rational Software Architect 7.6, Oracle, DB2, MS Excel.

Confidential

Role: Data Modeler

Responsibilities:

• Working with business users to know the business requirements.
• Dealing with Business analysts to understand the business challenges and data for reporting.
• Designed Star schema for Risk Retail reporting for credit card portfolio subject area.
• Conducted team meetings and JAD sessions for the requirements clarifications.
• Gave suggestions in the requirementsto business.
• Performed gap analysis.
• Created and maintained Logical and Physical models for the data mart which supports the Risk Retail reporting for credit card portfolio includes creating partitions, indexes for the tables.
• Created System Design Specification SDS document.
• Maintained metadata, version controlling of the data model.
• Involved in business process modeling using UML through Rational Rose.
• Conducted design reviews with business analysts, Enterprise data architect and solution lead to create proof of concept for the reports.
• Created source to targetmapping documents of credit card portfolio data mart for all sources.
• Wrote SQL scripts for creating tables, Sequences, Triggers, views and materialized views.
• Wrote SQL scripts for loading data from staging area to target tables.
• Did performance analysis and created partitions, indexes and Aggregate tables where necessary.
• Broken down the hierarchies from the dimensions to create the roll up dimensions.
• CreatedSQL scripts for loading the aggregate tables and rollup dimensions.
• Created package for automated loading of historical and ongoing datainto aggregates.
• Performed unit testing, System integrated testing for the aggregate tables.
• Performed data analysis on the target tables to make sure the data as per the business expectations.
• Worked with analysts to create reporting universes in Business Objects.

Environment: ORACLE, Toad for Data Analysts 2.5.1,Toad for Oracle 10,Toad Data Modeler 3.4,SQL Plus, Erwin Data Modeler8.2, Erwin Model Manager8.2, MS Visio, SourceOffsite SOS ,Windows XP, QC Explorer, Business Objects, Share point workspace 2010.

Confidential

Role: Sr. Data Modeler

Responsibilities:

• Extensive analysis to find the issues presentin 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: Sq1 Server 2005/2008, DB2, ORACLE, Toad for Oracle 9.1 Expert, Erwin Data Modeler 7.2/8.2,Informatica 9.1, MS Visio, Windows XP, Win7, WSFTP Pro 99, QC Explorer, Toad for Data Analysis.

Confidential

Responsibilities:

• Working with business users to know the business requirements.
• Initially phase designed the specialty marine data model for Contractor's Equipment and now working on enhancing this model for additional Inland Marine product offerings.
• Worked with ACORD XSD structure and Property and Casualty Insurance data model.
• Used the design of Inland Marine data model to design an Inland Marine policy XSD, which will borrow heavily from ACORD and will be the first step in building the canonical XSD for the Print Factory.
• Because of the nature of Inland Marine, there are quite a few entities and elements that do not fit a traditional P C model and they were accommodated into the model accordingly.
• Created lot of reference data for this application.
• Involved in using class diagrams UML in modeling the Logical Data Models and Physical Data Model.
• Created process flow diagrams by using MS Visio and maintained document designing
• Worked extensively with XSD, WSDL.
• Maintaining change logs, Sub models.
• Extensively using the Erwin design tool Erwin model manager to create and maintain the versions of the Inland Marine data model. Created integrity rules and defaults.
• Created documentation and test cases, working with users for new module enhancements and testing.
• Data Modeled with ERwin QA tracking for derivative pricing, stored procedures and triggers
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis.

Environment: Sq1 Server 2005, DB2, ORACLE, Toad for Oracle 9.1 Expert, Erwin Data Modeler 7.2.8, Erwin Model Manager 7.2.8, MS Visio, JAVA, XML, XML SPY, Windows XP, WSFTP Pro 99, QC Explorer.

Confidential

Role: Sr. Data Modeler

Responsibilities:

• Gather the various requirements from the business analysts.
• Gather all the Sales analysis reports prototypes from the business analysts belonging to different Business units Participated in JAD sessions involving the discussion of various reporting needs.
• Reverse Engineering the existing data marts and identified the Data Elements in the source systems , Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Warehouse at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schema for sales data involving shared dimensions Conformed for other subject areas using Erwin Data Modeler.
• Created and maintained Logical Data Model LDM for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values,codes, business rules, glossary terms, etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases,business object model, and system object model as they evolve and change.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Worked closely with the ETL Developers to explain the complex Data Transformation Logic.
• Employed naming standard editor for defining new naming standards for the entities, attributes, domains,columns and tables that applied consistently all over the enterprise.
• Implemented slowly changing dimensions Type2 and Type3 for accessing history of reference data changes.
• Provided source to target mappings to the ETL team to perform initial, full, and Incremental loads into the target data mart.

Environment:SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS2008, Crystal Reports7.5/8.0, Windows 2000, Micro strategy 9.3,Crystal Enterprise8.0, Erwin,power designer,CSV files,XML files,Business Objects,Oracle10g.