SUMMARY

• Twelve Plus Years’ of Data Modeling, Application Design, Development and Maintenance Experience working for Confidential, Confidential, Confidential, Confidential, Confidential, Confidential .
• Six Sigma Green Belt Certified.
• Extensive expertise in working with different versions of Oracle and SQL Server Databases.
• Skill - set - Erwin 7.3, 8.2 & 9.2, SQL, PL/SQL, Oracle Data Integrator, Vi Editor, MS-Excel (2003, 2007),Physical & Logical Data Modeling & Query Tuning.
• Experience in analysis, design development and deployment of software.
• Experience working in globally distributed technology teams. Handled multiple roles - Data Modeler, Data Analyst, Business Analyst, Oracle Developer and Back-End Developer.
• Experienced in creating & managing Facts, Dimensions & Data Marts.
• Involved in full lifecycle software development starting with specifications through software design, development and testing.
• Significant experience in ETL components and implementation.
• Proficiency in Software Development Life Cycle (SDLC) and AGILE methodologies of development process such as requirement analysis & definition, prototyping, proof of concept, designing, coding, testing and implementation.
• Quick and accurate thinker with efficient analytical skill set.
• Experienced in Configuration Management, setting up company Version policies, build schedule using Tortoise SVN and Visual Source Safe (VSS), Clear Case.
• Significant experience in offshore leading, coordination thus implementing a successful onsite-offshore model of delivery.
• Strong team player, motivator but have also executed projects independently.
• Excellent Written, Analytical Skills and Verbal Communication skills with a customer service oriented attitude.

TECHNICAL SKILLS

Databases: Oracle 8i, 9i, 10g,11i, MS SQL Server 2008/2005/2000

Programming Languages: SQL, PL/SQL, COAX, VBA.

Data Modeling Tool: ERwin Data Modeler 7.3, 8.2, 9.2

Reporting: MS Access Reports, Oracle Reports, Oracle Discoverer 4i

Version Control: Visual Source Safe 6.0, Tortoise SVN, Clearcase

Other Tools: Microsoft Visual Studio, Toad, SQL Navigator, Dreamcoder, Visio, Excel (2003,2007), MHub - Abinitio, PL/ SQL Developer, HP Quality Center, EBX5

ETL: Oracle Data Integrator (Formerly Sunopsis) Ver 10.1.3

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

Data Modeler

Responsibilities:

• Analyze business requirements & profile data sources to develop a Logical Data Model.
• Liaison with Business Analysts and DBAs to customize Data Models.
• Work on Remedy requests to modify Data Models & generate requested DDL.
• Work on Informatica Metadata Manager, build Glossary and run full lineage to check the tool’s scalability.

Confidential, Princeton, NJ

Data Modeler/ Business Analyst

Responsibilities:

• Discuss with business & ascertain the scope of the Project. This included Interviews with MPR’s technical subject experts and MPR’s Business Analyst
• Develop a high level understanding of their source systems in a short time period.
• Analyze Reporting requirements and ensure the coverage of source data from reporting needs perspective.
• Build a logical and Physical data model as per dimensional data modeling standards.
• Write the Source - Target Mapping document for the ETL Team.
• Generate & maintain migration scripts to build a physical Database schema.
• Reviewing prior documentation provided by MPR.

Confidential, New York City, NY

Data Modeler/ Business Analyst

Responsibilities:

• Gathered and analyzed requirements. Discussed the requirements with business for any clarifications.
• Customized physical data model for various schemas in FSDW data model per Confidential requirements.
• Analyzed existing legacy system source data model & data models from multiple semi-automatic systems to understand business logics and updated FSDW model to in corporate specific business requirements.
• Created and maintained Reference Data Dictionary from the Data Definition spreadsheet.
• Prepared Source to Target Mapping Document for new database comparing existing legacy system mapping details.
• Designed the changes to data model to accommodate many to many relationships.
• Physicalized tables on various databases/ schemas.
• Created and Maintained Data Dictionary.
• Helped ETL team in writing and executing test cases as per business scenarios.

Confidential, New York City, NY

Data Modeler/ Data Analyst

Responsibilities:

• Created physical and logical data model for Framesoft and Algo subject area.
• Created and maintained Reference Data Dictionary from the Data Definition spreadsheet.
• Gathered and analyzed requirements. Discussed the requirements with the Business Analysts for any clarifications.
• Prepared Source to Target Mapping Document using upstream data files as the source.
• Performed Static Reference data loads in Orchestra network’s EBX 5 (MDM Tool).
• Designed the changes to data model to accommodate many to many relationships.
• Created Data Modeling Functional Specification Documents.
• Physicalized tables on EBX5.
• Created and Maintained Data Dictionary for CDW Phase 1.
• Created Functional Specification Document for Entitlements.
• Created SQL reports for business usage for manual comparison of document onboarding process.
• Categorized attributes which would be masked for client sensitive data.
• Helped ETL team in writing and executing test cases as per business scenarios.

Confidential, Warren, NJ

Data Modeler

Responsibilities:

• Gathered and analyzed requirements. Discussed the requirements with the Business Analysts for any clarifications.
• Performed gap analysis and discussed the gaps with the business.
• Prepared Source to Target Mapping Document. Responsible for mapping Product Processor’s data elements to IBM’s industry model (Banking Data Warehouse).
• Designed the changes to data model to accommodate many to many relationships.
• Familiar with BDW model concepts.
• Developed SQL modules to extract and validate data from the Table for each new deployment.
• Employed best practices in data analysis and designing solutions for handling data quality issues.
• Currently working on the Metadata HUB portal (Abinitio) as a user to load Data Modeling artifacts & validating the data loaded.
• Used VBA programming in Excel for Data Analysis.
• Prepared and maintained excel sheets for various mapping documents.

Confidential, New York City, NY

Data Modeler

Responsibilities:

• Gathered and analyzed requirements. Discussed the requirements with the Business Analysts for any clarifications.
• Performed gap analysis and discussed the gaps with the business.
• Prepared Source to Target Mapping Document.
• Designed the changes to data model to accommodate many to many relationships.
• Tuned SQL queries for long running queries after analyzing the explain Plan.
• Wrote reports in SQL for MIS reporting application, in various schemas like imports, exports, payments.
• Used VBA programming in Excel for Data Analysis.
• Prepared and maintained excel sheets for various mapping documents.

Data Warehouse Developer

Responsibilities:

• Gathered and analyzed requirements. Discussed the requirements with the Business Analysts for any clarifications.
• Performed gap analysis and discussed the gaps with the business.
• Prepared Source to Target Mapping Document.
• Designed the data Extraction, transformation and load process. The Extraction criterion is based on the Record Update Date.
• Developed the interfaces using Designer to extract and load and transform the data into target.
• Developed Packages and scenarios to integrate all the interfaces sequentially.
• Analyzed the SQL queries to find the inflation or dropping of records. Debugged the queries framed by ODI.
• Developed the stored procedures to update the process control tables.
• Populated Dimensions and Fact tables for the Marts.
• Reengineered the Knowledge modules to get the correct flow of the data.
• Deployed the scenarios to different environments and monitored the execution for any failures.
• Documented the technical specifications for the Marts and Centralized Data Warehouse.

Confidential, Lyndhurst, NJ

Sr. Oracle Developer

Responsibilities:

• Responsibilities include requirements study, Analysis, Design, Implementation & support.
• Involved in Production Support and support for Database Applications.
• Developed Complex SQL Queries to update and maintain the database.
• Developed Stored Procedures using PL/SQL to validate and insert data into Application Tables.
• Developed MS Access Reports.
• Developed PL/SQL Packages to communicate the success and failure of running the loader scripts.
• Developed Database triggers using PL/SQL for storing the important transactions in the history tables and to audit some master tables.
• Developed PL/SQL Functions, Cursors for various calculations in the application.
• Responsible for Tuning SQL Queries and Query Optimization.
• Provided End User training and mentored Graduate Engineering Trainees.

Sr. Oracle Developer/ Sr. Application Developer/ Business Analyst

Confidential, Cincinnati, OH

Responsibilities:

• Developed Complex SQL Queries to update and maintain the database
• Developed Stored Procedures using PL/SQL to validate and insert data into Application Tables.
• Developed Database triggers using PL/SQL for storing the important transactions in the history tables and to audit some master tables.
• Developed PL/SQL Functions, Cursors for various calculations in the application.
• Adding enhancements for the next release.Worked side-by-side with the end-users to test and ensure proper delivery.

Confidential, Cincinnati, OH

Responsibilities:

• Requirements Study, Analysis and Design
• Was involved in project implementation and start up in Columbia.
• Development of PL/SQL Procedures.
• Developed Database triggers using PL/SQL for storing the important transactions in the history tables and to audit some master tables.
• Developed PL/SQL Functions, Cursors for various calculations in the application.
• Responsible for Tuning SQL Queries and Query Optimization.
• Development and Unit Testing of critical modules - Manual Allowances in Order Entry, Increased Coater Planning, Sales Allocation and Credit Check.
• Debugging and testing the application.
• Providing post startup support related to modifications in database.

Confidential

Responsibilities:

• Preparation of Functional Specifications, Technical Specifications and Data Design documents
• Preparation of testing scripts
• Development of ETL routines
• Unit Testing of developed components
• Integration testing / System testing of all components
• Managing data security
• Catering reporting requirements