SUMMARY

• Over 10 years of IT experience includes Requirement Analysis, Testing, datamodeling, business anddataanalysis.
• Certified Software Testing Manager (CSTM)® from International Institute and Certified Scrum Master (CSM) ® with solid IT experience with experience in defining test methodology, designing test plans, preparing documentation, following Standard Operation Procedures and implementing test strategies during Software Development Life Cycle (SDLC).
• Around 7 + years of experience indatamodeling, business anddataanalysis, production support, database management, strategic analysis, requirements gathering, data modeling, data mapping, data profiling.
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERWIN and Power Designer.
• Proficient indatamart design and creation of cubes using dimensionaldatamodeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Well versed in Normalization / De normalization techniques for optimum performance in relational and dimensional database environments.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience in developing Entity-Relationship diagrams and modeling Transactional Databases and DataWarehouse using tools like ERWIN, ER/Studio and Power Designer.
• Solid experience with data governance, data steward, data quality concepts and implementations.
• Hands on experience with modeling using ERWIN in both forward and reverse engineering cases
• Experienced with both DDL and DML including Joins, Functions, Indexes, Views, Constraints, Primary Keys and Foreign Keys.
• Good inDatawarehouse loads, determining hierarchies, building various logics to handle Slowly Changing Dimensions.
• Expertise in working with business users as part of requirements gathering and converting them into technical solution.
• Deployed naming standard to theDataModel and followed company standard for Project Documentation.
• Expertise in Normalization techniques fordataconsistency and Flexible Database design.
• Experienced in writingdataquality rules to ensure quality, consistency and accuracy ofdata.
• Expertise indatadesign and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relationaldatamodeling.
• Designed the PL/SQL procedures for getting thedatafrom all systems toDataWarehousing system. Thedatawas standardized to store various Business Units in tables.
• Experience inDatatransformation andDatamapping from source to target database schemas and alsodatacleansing.
• Excellent understanding and exposure to SQL queries and PL/SQL stored procedures, triggers, functions and packages.
• Extensive knowledge of writing SQL queries, working with back end tools such as Toad fordata validation and verification.
• Strong experience in Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Experienced in writingDataTransformation andDataCleansing rules forDataMapping documents inDataWarehouse projects.
• Good understanding of Teradata SQL Assistant, Teradata Administrator anddataload/ export utilities like BTEQ, Fast Load, Multi Load, Fast Export.
• Experienced in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME's to obtain domain level information of projects.
• Worked in many Software Development Life Cycle (SDLC) implementations, performing process planning, documentation, functional and system design, implementation, unit testing, integration testing, and regression testing and system maintenance.
• Good understanding of Agile Methodology using Scrum Model including sprint planning, Retrospection, Demo and Daily stand-ups.
• Co-ordination and follow up with customer on issues/action items from offshore team.

PROFESSIONAL EXPERIENCE

Confidential, Middletown, NJ

Sr.Data Modeler/Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Created logicaldatamodel from the conceptual model and it's conversion into the physical database design using ERWIN.
• Map business needs/requirements to subject area model and to logical enterprise model.
• Worked with DBA's to create a best fit physicaldatamodel from the logicaldatamodel
• Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
• Developed thedatawarehouse model (star schema) for the proposed central model for the project.
• Created Logical/PhysicalDatamodels in 3NF in the Warehouse area of EnterpriseData Warehouse.
• Created 3NF business areadatamodeling with de-normalized physical implementationdataand information requirements analysis using ERWIN tool.
• Part of team conducting logicaldataanalysis anddatamodeling JAD sessions, communicated data-related standards.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Experience working on creating models for Teradata masterdatamanagement.
• Worked with Architecture team to get the metadata approved for the newdataelements that are added for this project.
• Responsible for creating the staging tables and source to target mapping documents for the ETL process.
• Did Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server.
• Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetchdatafrom legacy Oracle and SQL Server database systems
• 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.
• Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Involved inDataMapping.
• Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
• Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Windows 7, Teradata 14, ERWIN r9.1, SQL server 2005/2008, Business Objects XI, MS Excel 2010, Informatica, SQL, Oracle, TOAD forDataAnalysis, Teradata .

Confidential, NJ

Sr.Data Modeler/Analyst

Responsibilities:

• Requirement gathering and Business Analysis.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats
• Created logical & physicaldatamodels and MetaDatato support the requirements
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin.
• Preparation ofDataDictionary/MetaDataof thedataelements.
• Walked through the LogicalDataModels of all source systems fordataquality analysis
• Developed Logical and Physicaldatamodels that capture current state/future statedataelements and dataflows using Erwin / Star Schema.
• Responsible for removing Insertion, update and deletion anomalies by converting the table to Third Normal From.
• Worked on enterprise logicaldatamodeling project (in third normal form) to gatherdatarequirements for OLTP enhancements. Converted third normal form ERDs into dimensional ERDs fordatawarehouse effort.
• Involved in mapping spreadsheets that will provide theDataWarehouse Development (ETL) team with source to targetdatamapping, inclusive of logical names, physical names,datatypes, domain definitions, and corporate meta-datadefinitions.
• Converted physical database models from logical models, to build/generate DDL scripts.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Maintained MetaDataRepository for storing table definitions, table spaces and entity definitions.
• Tuning the Informatica Mappings for optimum performance and scheduling ETL Sessions.
• Created various geographical and time dimension reports of Fiscal year, Quarterly, Monthly, weekly, Daily reports for all Domains and published through Web Intelligence.

Environment: Erwin, Informatica Power Center(Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse designer, Mapping Designer, Transformations), Oracle, PL/SQL, SQL* Loader, TOAD, Business Objects

Confidential, NJ

Data Modeler/Analyst

Responsibilities:

• Performeddataanalysis and profiling of sourcedatato better understand the sources.
• Created logicaldatamodel from the conceptual model and it's conversion into the physical database design using Erwin.
• Worked with DBA's to create a best-fit PhysicalDataModel from the logicaldatamodel.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part ofdataanalysis responsibilities.
• Interacted with the database administrators and business analysts for data type and class words.
• Conducted design sessions with business analysts and ETL developers to come up with a design that satisfies the organization's requirements.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created ER Diagrams,DataFlow Diagrams, grouped and created the tables, validated thedata, identified PK/ FK for lookup tables.
• Created 3NF business areadatamodeling with de-normalized physical implementationdataand information requirements analysis using Erwin tool.
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model.
• Ensured the quality, consistency, and accuracy ofdatain a timely, effective and reliable manner.
• Involved in ETL mapping documents indatawarehouse projects.
• Created high level ETL design document.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Assisted the ETL team to document the transformation rules fordatamigration from OLTP to Warehouse environment for reporting purposes.
• Involved in extensivedataanalysis on the Teradata and Oracle systems querying and writing in SQL and TOAD.
• Assisted the ETL team to document the transformation rules fordatamigration from OLTP to Warehouse environment for reporting purposes.
• Used SQL joins, aggregate functions, analytical functions, group by, order by clauses and interacted with DBA and developers for query optimization and tuning.
• Conducted several PhysicalDataModel training sessions with the ETL Developers. Worked with them on day-to-day basis to resolve any questions on Physical Model.

Environment: Oracle 11g, Erwin, Windows XP, MS Excel, Business Objects XI, SSIS, MS Access, Teradata,Excel, Informatica.

Confidential

Data Modeler/Analyst

Responsibilities:

• Attended and participated in information and requirements gathering sessions
• Ensured that business requirements can be translated into data requirements
• Involved in the analysis of the existing claims processing system, mapping phase according to functionality and data conversion procedure.
• Translated business requirements into working logical and physical data models.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
• 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.
• Experienced with Dimensional data modeling for Data Marts
• 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.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Designed the database tables & created table and column level constraints using the suggested naming conventions for constraint keys.
• Perform Data Profiling to assess the risk involved in integrating data for applications, Teradata system
• Created PL/SQL packages to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Developedstored procedures and triggers.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: Power Designer 16/15, Erwin v9.1, SQL Server 2000/2005/2008, MS-Excel, Visio, MS-Access, Oracle, SQL, PL/SQL, Teradata, Informatica v9.1

Confidential

Data Modeler/Analyst

Responsibilities:

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high-level determination of sources during initial scoping by the project team.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Maintain and enhance data model with changes and furnish with definitions, notes, and reference values and check lists.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments. Generate DDL scripts for database modification, Teradata Macros, Views and set tables.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Environment: SQL Server 2000/ 2005, Erwin 7.5.2, Windows XP, XML, Excel, Access, Visio.

Confidential 

Data Modeler/Analyst

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document)
• Involved in extensiveDatavalidation using SQL queries and back-end testing
• Designed and developed ETL processes using Informatica ETL tool for dimension and fact file creation
• DataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData,DataDefinitions and Data formats.
• Involved in Migrating thedatamodel from one database to Teradata database and prepared a Teradata staging model.
• Using ErWin v8.2 modeling tool, publishing of adatadictionary, review of the model and dictionary with subject matter experts and generation ofdatadefinition language.
• Managed full SDLC processes involving requirements management, workflow analysis, source data analysis,datamapping, metadata management,dataquality, testing strategy and maintenance of the model.
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volumedata
• Involved in extensiveDatavalidation 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
• Reviewed the model with application developers, ETL Team, DBAs and testing team to provide information about thedatamodel and business requirements.

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

Confidential 

QA Analyst

Responsibilities:

• Participating in preparing Test Plans.
• Preparing Test Scenarios, test cases and defect Tracking.
• Excellent experience as Quality Assurance Tester in Manual and Automated Testing of Web (J2EE) based applications using Rational Functional Tester, Rational Manual Tester and QTP.
• Strong experience in writing and executing Test cases and Test plans.
• Interacted with clients to determine User requirements and goals.
• Participated in analysis of Business and functional requirements
• Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
• Developed Test Plan and overall Test Strategy for the Application.
• Developed Test Cases and Test Scripts for System testing.
• Performed Positive and Negative Testing for this application.
• Extensively used SQL queries to check storage and accuracy of data in database table
• Work with the system engineers and development leaders to build the test plans and perform test execution.
• Ensure the traceability of test cases to requirements and help the project leaders to make sure all requirements are tested.
• Clearly communicate the situation to the testing team and project management for defect records.

Environment: Java/J2EE, Oracle, Toad, H.PQuality Center 11.0, QTP 8.0/9.2, UNIX,SOAPUI