SUMMARY

• Goal Oriented Data Modeler having 8+ years of professional experience indataanalysis,data modeling, design, development and implementation of OLTP,DataWarehouse & Business intelligence
• Extensive business domain experience in Finance, Banking, Healthcare and Insurance
• Hands on experienced in all phases ofDataModeling - Conceptual, Logical and Physical modeling
• Expertise inDataModeling using tools likes ERWIN, ER Studio, PoweDesigner and MS Visio along with the hands on experience in using Forward Engineering and Reverse engineering functionality.
• Hands-on experienced withdataarchitecting,datawarehousing,datamining, large-scaledata modeling, business Intelligence,datasharing techniques across enterprise systems, system analysis, business requirements gathering/analysis and experienced in implementing enterprisedata management procedures
• Hands-on knowledge of enterprise repository tools,datamodeling tools,datamapping anddata profiling tools.
• Demonstrated expertise with repository creation, anddataand information system life cycle methodologies
• Experienced with business requirements analysis, entity relationship planning, database design, reporting structures.
• Excellent experience in sub model/subject area sync, compare and merge operations
• Experienced in working with industry standard analysis techniques to uncover client requirements and identifying the roles and deliverables in the Organization by creating Use Case Models,DataFlow Models, Workflow Analysis, Functional decomposition Analysis, Object Modeling along with Activity Diagrams
• Expertise in interacting with stakeholders, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Experienced on various Software Development Life Cycles including Analysis, Design, Development and Testing to solidify client requirements in conjunction with Software Developers.
• Experienced with Business Process Modeling, Process Flow Modeling,Dataflow modeling
• Experienced in implementingDatawarehousing solutions involving Dimension modeling and Snow flake schema implementation (3 NF).
• Excellent experience in Extract, Transfer and Load process using ETL tools likeDataStage, Informatica,DataIntegrator and Sql Server Integration Services forDatamigration andData Warehousing projects.
• Involved in performance optimization of DWH solutions, both on ETL as well as Database side.
• Experienced in preparing project cutover plan, test plan with test cases for unit test, regression test and User Acceptance Testing (UAT)
• Strong experience providing support during User Acceptance Testing
• Highly skilled in System Analysis, ER/DimensionalDataModeling, Database design and implementing RDBMS specific features.
• Mentoring team members in ETL Area performance optimization area.
• Excellent experience in problem solving and supporting applications comes under 24/7
• Good team player, hard working, excellent work ethics, enthusiastic and high adaptability to changes in technology.
• Worked with theseniormembers of team to improve quality processes while implementing the projects.

TECHNICAL SKILLS

Data Modeling: DimensionalDataModeling, RelationalDataModeling, Star and Snowflake Schema, Fact and Dimension Tables, Conceptual, Logical and PhysicalDataModeling, ER Studio 7.1.1, UML, Rational Toolkit, Erwin, Power Designer.

DataWarehousing: Informatica PowerCenter, Power Exchange, DataExplorer, Data Profiling, Data cleansing, OLAP, OLTP, SQL*Plus, PL/SQL, Data Stage (Designer, Manager, Director).

Reporting: Crystal Reports, Business Objects, Micro Strategy, OBIEE, Cognos.

Databases: Oracle 10/11g DB2 8.0/7.0,MS SQL 7.0, SQL Server 2005 MS Access 2007 TeraData, Netezza, Mongo DB.

Environment: UNIX, LINUX, Windows 7/8.1

PROFESSIONAL EXPERIENCE

Confidential, Bronx, NY

Sr.Data Modeler & Data Analyst

Responsibilities:

• Designed an Industry standarddataModel specific to the company with group insurance offerings, Translated the business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling
• Identified and compiled common business terms for the new policy generating system and also worked on other Subject Areas.
• Created a high-level industry standard, generalizeddatamodel to convert it into logical and physical model at later stages of the project using Erwin and Visio
• Identified and Defined entities, relationships and attributes in thedatamodel as per new specifications in Erwin after analyzing the database systems currently in use. Identified source elements and done mapping with the target systems.
• Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Worked on data analysis, data profiling, data quality checks.
• Involved with creating mapping specifications documents to capture transformation rules.
• DevelopedDataMapping,DataGovernance, and Transformation and cleansing rules for the MasterData Management Architecture involving OLTP, ODS.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions todataissues and other challenges while implementing the OLAP model.
• Generated ad-hoc reports using Crystal Reports 9.
• Developed and maintaineddatadictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Prepared analytical and status reports and updated the project plan as required.
• Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and PhysicaldataModels.

Environment: Erwin R8.2.5, MS Visio, Oracle 11g, Toad, Oracle Designer, SQL Server 2008, Oracle SQL developer 2008, Crystal Reports 9.

Confidential, NYC, NY

Sr. Data Analyst/Data Modeler

Responsibilities:

• Involved inDatamapping specifications to create and execute detailed system test plans.
• Thedatamapping specifies whatdatawill be extracted from an internaldatawarehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements,datamapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Set up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to loaddatafrom source flat files and RDBMS tables to target tables.
• Wrote and executed unit, system, integration and UAT scripts in adatawarehouse projects.
• Wrote and executed SQL queries to verify thatdatahas been moved from transactional system to DSS,Datawarehouse,datamart reporting system in accordance with requirements.
• Created the test environment for Staging area, loading the Staging area withdatafrom multiple sources.
• Responsible for analyzing variousdatasources such as flat files, ASCIIData, EBCDICData, RelationalData(Oracle, DB2 UDB, MS SQL Server) from various heterogeneousdatasources.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Tested the ETL process for both beforedatavalidation and afterdatavalidation process. Tested the messages published by ETL tool anddataloaded into various databases
• Experienced in creating UNIX scripts for file transfer and file manipulation.
• Provided support to client with assessing how many virtual user licenses would be needed for performance testing.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Informatica 8.1,DataFlux, Oracle 9i, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Teradata

Confidential, Chicago, IL

Data Analyst/ Data Modeler

Responsibilities:

• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to loaddatafrom source flat files and RDBMS tables to target tables.
• Responsible for differentDatamapping activities from Source systems to Teradata
• Involved inDatamapping specifications to create and execute detailed system test plans.
• Analyzed business requirements, system requirements,datamapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Leveraged DBA tools and Database team’s developed procedures to monitor tune and optimize database and application performance.
• Participated in meetings in the development of standards and procedures affecting database management, design and maintenance.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Tested the ETL process for both beforedatavalidation and afterdatavalidation process. Tested the messages published by ETL tool anddataloaded into various databases
• Experienced in creating UNIX scripts for file transfer and file manipulation.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Informatica 8.1,DataFlux, Oracle 9i, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Teradata

Confidential, Westchester, PA

Data Analyst

Responsibilities:

• Involved with data profiling for multiple sources and answered complex business questions by providingdatato business users.
• Worked withdatainvestigation, discovery and mapping tools to scan every singledatarecord from many sources.
• Wrote and executed unit, system, integration and UAT scripts in adatawarehouse projects.
• Worked on Front end Java applications fordataanalysis and providing results to Business users.
• Extensively used ETL methodology for supportingdataextraction, transformations and loading processing, in a complex EDW using Informatica.
• Performeddatareconciliation between integrated systems.
• Metrics reporting,datamining and trends in helpdesk environment using Access
• Wrote complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects XIR2.
• Extensively used MS Access to pull thedatafrom variousdatabases and integrate thedata.
• Worked on SAS and IDQ forDataAnalysis.
• Assisted in the oversight for compliance to the EnterpriseDataStandards
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volumedata
• Worked with Excel Pivot tables.
• Performeddatamanagement projects and fulfilling ad-hoc requests according to user specifications by utilizingdatamanagement software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Developed working documents to support findings and assign specific tasks.
• Excellent exposure inDataProfiling in reference toDataWarehouse and BI development.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Analysis on Mainframedatato generate reports for business users.
• Identify & record defects with required information for issue to be reproduced by development team.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Java, Business Objects XIR2, ETL Tools Informatica 8.6/9.1/9.5, SSIS, Oracle 11G, Teradata R13, Teradata SQL Assistant