SUMMARY:

• Almost 11+ years of experience in IT, designing and developing oracle based applications.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Currently for the past 3 years I was/am working as an Architect in my current and previous organization respectively.
• My work lies grooming team members with advanced technologies Oracle SQL & PL/SQL, ODI OWB & Informatica for delivering on time and within budget, Creating BRS, HLD,DLD design documents for development, Customer Interaction, Getting Requirements, Managing Resources and Delivery.
• Extensive experience in Oracle DB Rel. 12C, 11g, 10g, 9i, 8i starting from SQL, PL/SQL, ER - Modeling, Dimensional Modeling for Data Warehouse, Performance Tuning and Optimization, ETL using PL/SQL, OWB, ODI and Informatica.
• Apart from Operating Systems, Basic Office related Software and ETL Software I work in Project Management Tools MPP, Design Tools ERWIN Replication Tools OGG, IDEs Toad, PL/SQL Dev. SQL Dev. Version Controls CVS, Share Point, SVN, Star Team Reporting Tools Oracle Reports 6i, 9i, 10g, Discoverer, Express and OBIEE
• I have experience with Oracle SCM, Order Management & ORDM, EBS FA, AP, AR .

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Consultant

Responsibilities:

• Involved in Oracle physical database design by Create/Enhance the OLTP as well as Dimensional Model.
• Extensively worked on complex Oracle SQL, PL/SQL, ODI& OGG Development.
• Building Load Plans, Writing & Integrating Packages.
• Monitoring ODI jobs by querying the Repository and integrate it with OBIEE, OGG for real time data synchronization from EBS, Siebel CRM and populating the EDW.
• Created a Framework for SQL Injection for automatically finding the data points for Data Correction, Production Support, and emergency code push during holidays/ non-working days / disastrous days etc.
• Created a Framework for ODI Automated Delta Export & Delta Import work repository.
• Created a Framework for Creating ODI Interfaces automatically by using ODI SDK.
• Created a Framework for ODI to generate automated Test Data for Tables.
• Created a Framework for getting Suggestions for Performance Improvement on Long Running Queries. This Framework currently Supports Oracle, MSSQL, MySQL & Teradata.
• Created a Framework for generating multiple EXTRACT & REPLICAT parameter files for OGG to integrate with EDW & Oracle 11i EBS.
• Created Several Packages, Scenarios, Dynamic Refresh Variables Based on one and another, Integration with Web-Services into the Packages etc. with ODI.

Confidential

Solution/Technical Architect

Responsibilities:

• Writing Project Management Plan;
• Planning the activities of the team; monitoring and reporting on progress;
• Analysis of the desired functionality of the machine and documenting this in a User Requirements Specification;
• Involved in Oracle physical database design by Create/Enhance the OLTP as well as Dimensional Model.
• Extensively worked on complex Oracle SQL, PL/SQL & ODI Development.
• Building Load Plans. Invoking it from DBMS SCHEDULER.
• Extensively worked on Oracle Utilities like Export, Import, Rman, Data Pump etc.
• Creating Data Modeling objects like Tables, Views, Materialized Views, Global Temporary tables and Stored Subprograms like Procedure, Function, Package etc.
• Extensive usage of BULK DML and BULK FETCH, Dynamic SQL, Virtual Columns, With & Model Clause for reporting. Designing MV’s, Partitioning Techniques, Compound Triggers, JOBs, and Schedulers.

Confidential

Chief Technical Architect/Designer

Responsibilities:

• Involved in Oracle physical database design by Create/Enhance the OLTP as well as Dimensional Model.
• Extensively worked on complex Oracle SQL, PL/SQL & ODI Development.
• Building Load Plans. Invoking it from DBMS SCHEDULER.
• Extensively worked on Oracle Utilities like Export, Import, Rman, Data Pump etc.
• Creating Data Modeling objects like Tables, Views, Materialized Views, Global Temporary tables and Stored Subprograms like Procedure, Function, Package etc.
• Creating optimization techniques/portfolios/Best-Practices Documents and then getting executed those by the team members against the Product.
• Building Complex Concurrent Programs & Workflows for the Product.

Confidential

Oracle Principal Consultant/Architect

Responsibilities:

• Custom ETL framework creation so that team members can use these generic Frameworks and can build ODI Interface, Procedure & Packages.
• Building Load Plans. Invoking it from DBMS SCHEDULER.
• Preparing BRS, SLD, HLD, and DLD Documents by constantly interacting with Customer.
• Preparing Training Documents and pertaining training sessions.
• Mentoring team members in up-coming and existing technologies.
• Preparing POC solutions for the Up-Coming Customers.

Confidential

Oracle Principal Consultant/Architect

Responsibilities:

• Custom KM creations Parallel read/write from Excel, Access & SQL Server LKM & IKM Modules .
• Building Scenarios, Load Plans. Invoking it from DBMS SCHEDULER.
• Optimization of SQL queries, and performance tuning by using Explain plan and Analysis.
• Fixing the problems in PL/SQL& ODI code and checking if any problems with DDL scripts; further escalating the issues in severe cases to the development and other support teams about possible impact on the RMS Application functionality.
• Responsible for Unit level testing, Module level testing and Application testing.
• Preparing BRS, SLD, HLD, DLD Documents by constantly interacting the Customer.
• Preparing Training Documents and pertaining training sessions.
• Mentoring team members in up-coming and existing technologies.
• Preparing POC solutions for the Up-Coming Customers.

Confidential

DATA Architect

Responsibilities:

• Created the architecture and solution for the entire migration process from OWB to ODI using limited resources:
• Designed the BRS & HLD to form the migration scope by writing initial mapping query to extract map information from OWB Repository.
• Designed how existing architecture of OWB can be mapped to ODI so that less resource is consumed but we can deliver in timely & effective manner.
• Designed the whole metadata driven LOAD Stack for parallel & serial jobs.
• Now my team is doing data preparation and enhancements to the generated script by LOAD Stack.
• Parallel Project2: Stubhub OWB2Informatica Migration DW 2.2
• I designed the architecture and solution for the entire migration process from OWB to Informatica using limited resources.
• Designed the BRS & HLD to form the migration scope by writing initial mapping query to extract map information from OWB Repository.
• Designed how existing architecture of OWB can be mapped to Informatica so that less resource is consumed but we can deliver in timely & effective manner.
• Designed the whole metadata driven LOAD Stack for parallel & serial jobs.
• My team completed data preparation and enhancements to the generated script by LOAD Stack.
• Created a metadata driven approach by writing the initial queries from OWB existing repository and also for ODI new repository to get the whole QA process audited and synched:
• Designed the Initial Specs and HLD.
• Created a framework to synchronize Source and Target DB by using DBMS COMPARISON.

Confidential, Wilmington, DE

Principal ETL Consultant

Responsibilities:

• Designed a Data load framework for dynamically adding Tables replicating from one system to another.
• Reverse Engineering framework for Data Stage Jobs.Developing SCDs and implementing end to end Quality Stage & Parallel Partitioning for SCDs through Data stage 8.5
• In process of developing a data purging framework.
• Designed a BI framework using SQL & PL/SQL and then by integrating OBIEE with that.
• Involved in unit testing the application code and database code for data integrity and application functionality; Unit Test is donethrough an automated unit test frameworkCalled Quest Code Tester.

Environment: Oracle 9i, Oracle 10g, Oracle 11g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Erwin 4.1.4, Toad 8.6 & 9.1, UNIX, Solaris, Windows.

Confidential, Hagerstown, Maryland

Sr. PL/SQL/ETLConsultant

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Interacted with the business users and collected the requirements and prepared BRD (Business Requirement Document) that provides detailed information about the requirements.
• Fixing the problems in PL/SQL code and any problems with DDL scripts for tables and indexes and escalating the issues in severe cases to the development and other support teams about possible impact on the application functionality.
• Responsible for Unit level testing, Module level testing and Application testing.
• Tuning Database and SQL for Optimal Performance, Redesign and build the Schemas to meet optimal Performance measures.
• Ensure smooth execution of Incident Management, Problem Management, Change Management, Release Management and Availability Management.
• Involved in the ASM/AD activities on the PACTS requirements.
• Maintaining and updating the process documents related to the project, procedural documentations.
• Involved in Development, testing, and release management for the PACTS releases.
• We tested our code through an automated unit test framework called Quest Code Tester.

Environment: Oracle 11g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Erwin 4.1.4, Toad 10.1, UNIX, Solaris, Windows.

Confidential, Tampa, Fl

Sr. Oracle PL/SQL/ETL Consultant

Responsibilities:

• Worked with business analysts to understand the business requirements and created technical requirements document.
• Responsible for development activities at the back-end side as well as actively participated in analysis and designing part.
• Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Identifying performance bottlenecks, suggesting and implementing alternative approaches like range partitioning of tables, use of global temporary tables.
• Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Developed code using advance features of 10g such as Regexp *, analytical functions, used UTL packages
• Provide resolutions to time-sensitive ad-hoc requests for information from management.
• Optimization of SQL queries, and performance tuning by using Explain plan and Analysis.

Environment: Oracle 10g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Erwin 4.1.4, Toad 10.1Cisco POC

Confidential

Data Migration Architect

Responsibilities:

.

• Writing a Project Management Plan;
• Planning the activities of the team; monitoring and reporting on progress;
• Worked on Oracle Reports, Oracle Discoverer, Oracle Express
• Analysis of the desired functionality of the machine and documenting this in a User Requirements Specification;
• Involved in Oracle physical database design
• Extensively worked on complex Oracle SQL Development
• Extensively worked on Oracle Utilities like Export, Import, Rman, Data Pump etc.
• Transferred Excel sheet data into Oracle database by using one of our Data Migration framework written in house in TechMahindra .
• Used Oracle Reports to write custom reports of Data Migration. Data Migration Framework’s Reporting Capability is used for the basic reports.
• Creating Data Modeling objects like Tables, Views, Materialized Views, Global Temporary tables and Stored Subprograms like Procedure, Function, Package etc.
• Extensive usage of BULK DML and BULK FETCH,DynamicSQL,Virtual Columns, With & Model Clause for reporting,Compound Triggers is done.

Confidential

Data Migration Architect

Responsibilities:

• Daily interaction with high-level clients both internally and externally
• Provided RFP, BRS, Data Migration HLD,Data Migration DLD documents.
• Extensively Used PL/SQL & OWB for Loading into the Clarity’s Warehouse DB and for reporting We have used PRO*C, Oracle Reports. We have used Discoverer for complex Cross Tab Reports.

Confidential

Data Migration Architect

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Interacted with the business users and collected the requirements and prepared BRD (Business Requirement Document), HLD, DLD.
• Prepared the whole ETL starting from requirement to UAT

Environment: Oracle 9i, SQL, PL/SQL, Erwin 4.0, SQL*Plus, SQL*Loader, UNIX, Windows XP.

Confidential

Data Migration Consultant

Responsibilities:

• Daily interaction with high-level clients internally and through mails.
• Provided RFP, BRS, Data Migration HLD, Data Migration DLD documents.
• Extensively Used PL/SQL for Loading into the Clarity’s WarehouseDB and for reconciliation we have modeled data structure like stack, queues.
• Also implemented Djikstar’s Algorithm for finding the shortest path for Virtual Circuits and for modeling the circuits like Tug2, Tug3 and bearer.
• Created a Data parsing Framework with Oracle Forms which can parse CSV, TXT, XML, INI, TUF files and reconcile the inventory by populating the Oracle database.
• Implemented this solution with zero defects in production.

Confidential

Data Migration Consultant

Responsibilities:

• Daily interaction with high-level clients both internally and externally
• Provided Data Migration HLD,Data Migration DLD documents.
• Extensively Used PL/SQL and Informatica for Loading into the Clarity’s WarehouseDB and for reporting We have used PRO*C, Oracle Reports. andCognos for critical Cross Tab Reporting.
• Performed Query Optimization through Oracle SQL analyze and Toad.
• Used Index, Compiler Hints and Materialized Views for optimization of Queries.
• Used Data Pump, Export, Import and SQL Loader.

Confidential

Data Migration Consultant

Responsibilities:

• Provided Data Migration DLD documents.
• Extensively Used PL/SQL for Loading into the Cramer’s DB and for reporting We have used Oracle Reports and Oracle Express for critical Cross Tab Reporting.
• Modeled Task Engine & Delivery Engine Templates and written various callouts for data migration and Configuration for providing the custom integration with Cramer.
• Written a Task Engine Auto create Tool to populate and execute the Task Engine and Delivery Engine tasks into the Database.