SUMMARY:

• Twenty one years of IT work experience and Six plus years of Technical Lead experience, Oracle12c/11g/10g/9i/8i Developer/2000/R2.0 (Forms 10g/ 6i/5.0/4.5/, Reports 10g/6i/3.0/2.5), Oracle Database Server 12c/11g,10g/9i/8/8i on Windows 2000, NT, UNIX Linux and Sun - Solaris.
• Expertise in client server, Internet architecture applications development using Oracle 12c/11g/10g/9i/8i/8.x, PL/SQL, SQL* Plus, SQL *Loader.
• Expertise in Developing and customizing PL/SQL procedures, functions, packages, triggers, partition tables, object tables, nested tables, Forms and reports.
• Extensive Experience In development of Data Migration Data Conversions, Data Mapping, Data Extraction, Data Modeling & Data design, Customization of Products (Forms and Reports)
• Expertise in SDLC, Relational database, Entity Relationship Diagrams, Preliminary System Requirement Study, System Analysis & Development, Test Plan Preparation, Unit Testing, System Integration Testing, Documentation and Implementation for VLDB’s.
• Experience in PL/SQL, Stored Procedures, Packages and Database Triggers.
• Experience in DBA, Performance Tuning, Optimizing SQL, PL/SQL and debugging, of the applications Using Tuning Tools (SQLTRACE, TKPROF, EXPLAIN PLAN, ANALYZE).
• Expertise in SQL HINTS, Indexes like (B*Tree, Bitmap, Function Based, Hash Cluster, Reverse key) for faster performance.
• Experience in using the Oracle supplied packages DBMS SQL, DBMS LOB, UTIL FILE, DBMS JOB, DBMS SCHEDULER, and DBMS UTILITY.
• Involved in data extraction, transformation and loading ETL operations on Oracle using SQL LOADER, External table and Informatica and involved in design of dimensional models like Star Schema, Snowflake schemas
• Extensive experience in Premia custom Insurance Application and ODS data Movements and involved in writing the SQL, PL/SQL and Unix Shell scripts.
• Extensive experience in Developing the Premia custom Insurance Application and ODS data Movements by using PL/SQL Procedures.
• Extensive experience in Business of Future (BoF) to Common Landing Area (CLA) Online Extract transform and Load (ETL) CLA Load process.
• Extensive experience using Oracle Index, Views, Materialize Views, External Tables which is Manual ETL Process and it is a new feature of 9i Database. Exposure on EDI, Strong skills, ability to interact with people at all levels
• Extensive Team Lead experience to handle the onshore& offshore teams/ onshore-offshore model.
• Expertise with Infor10 Expense Management system to support the employee expenses and other employee components
• Expertise with ITVALUE suite Application to support the USPS employee and Contractors Time and Materials(T&M) and Firm Fixed Price(FFP)

TECHNICAL SKILLS:

Database: ORACLE (12C/11g/10g/9i/8i/8.x/7.x), SQL Server2000/2005, MS Access

GUI: Developer2000 (Forms 10g/6i/5.0/4.5, Reports 10g/6i/3.0/2.5), VB (6.0).

Languages/Internet: C, C++, PL/SQL, SQL, Pro* C, Java (2.0),Javascript, HTML, XMLOperating System: Sun Solaris, Win-NT/ 2000, HP-UNIX, Linux, MS-DOS, IBM-AIX

Data Base /Tools: SQL * Loader, SQL* plus, SQL * Navigator, Discoverer, TOAD,FTPNoetix Tools: Noetix Views, Noetix Platform, Noetix NWQ, Noetix EUL Generator

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

ITVALUE Operations Developer/Senior Oracle Consultant

Responsibilities:

• Responsible for Operations and Maintenance on user raised Incident addressing based on the priority level by doing the analysis and resolve the issue, Backlog items enhancement analysis and development of new functionality for ITVALUE application suite (PCTS, NPCTS, CFA, CFS) and existing enhancement functionality based on the backlog requirements and supporting ad-hoc requirements based on users need basis.
• Responsible for CIO requirement gathering, analysis, design and development of PCTS (Project Status tracking at Project & Task maintenance screen using PL/SQL, JavaScript, HTML and PL/SQL stored packages, Created DB trigger to capture the Project status tracking and also created the Reports in three different format, PDF, HTML and Excel for Admin level access.
• Responsible for requirement gathering, analysis, design and development of PCTS Assign Alternate Approvers on Multiple Assigning and Removing approvers as Add approvers and Remove Approvers for a PCTS Project level using PL/SQL, JavaScript, HTML and PL/SQL stored packages . currently system was supporting only one approver assignment for a project, Developed entirely new functionality which can assign based on Finance number and BPL( Business Project Lead) search criteria.
• Responsible for requirement gathering, analysis, design and development of PCTS Delete Invoices existing functionality enhancements by improving the existing functionality based on Vendor selection and Delivery Order selection criteria and delete invoices by entering the comments and capturing the delete invoices record set in history tables as per Invoice # and Invoice deletion comments and Invoice deleted by (user) and Invoice delete date based on Vendor (T & M) Invoices and Vendor FFP Invoices using PL/SQL, JavaScript, HTML and PL/SQL stored procedures, created DB triggers to capture the Delete Invoices record set in History tables and also created the reports in three different format, PDF, HTML and Excel for Admin access level.
• Responsible for requirement gathering, analysis, design and development of PCTS user readable information message at Fiscal year Rollover Manager job screen by using PL/SQL, JavaScript, HTML and PL/SQL stored procedures.
• Responsible for requirement gathering, analysis and development of PCTS contract maintenance who last name and first name exceeds more than 15 characters using PL/SQL, JavaScript, HTML and PL/SQL stored procedures
• Responsible for requirement gathering, analysis, design and development of PCTS Outdated manager list, existing PCTS, CFA forms drop list box not showing the manager list properly, to address the existing form level functionality addressing by fixing the issue one time data fix and on-going data refresh by creating DB trigger to updates the tables properly as per updates happening on transaction tables, all this achieved by using PL/SQL one time data fix and DB triggers to capture and update the PCTS and ITValue tables.
• Responsible for addressing the Timecard Adjustment and ad-hoc queries based on users request.
• Responsible for checking and doing analysis on Delete functionality from over all PCTS applications used as a Delete button or Delete Task and over all Delete referred at the PCTS application.
• Responsible for supporting the project queries on Oracle Apex 5.0 to display the output based on tab selection criteria.
• Responsible for supporting testing the applications when ever there is a DB patch and Linux Patches are applied.
• Responsible for Testing the Development ITVALUE Application suite from Middleware upgrade and created the issues reporting Document as well as issue reporting Excel sheet.
• Responsible for supporting on Monitoring the Control-M jobs on month weekly turn over basis and also addressing abended jobs by checking the logs and analysis the root cause and sending for force completing the jobs and requesting the jobs for re-running the jobs based on abended job analysis.

Environment: Linux, Windows XP, Windows server2003, Oracle 12C/11g/10g, HTML, JavaScript, TOAD12.9, Apex 5.0, ITVALUE Application Suite(PCTS,NPCTS,CFA,CFS), Control-M jobs Scheduling, Service Now(Incidents), Version One(Sprint)

Confidential, Milwaukee, WI

Senior Oracle Lead Consultant & Integration Analyst

Responsibilities:

• Responsible for requirement gathering, analysis, design and development of HR employee (Workday Force and Payroll/ODS) extract to support North America (NA) Gates Application for US, Mexico, Canada and Puerto Rico countries, business units or environments, coordinating all the teams for all the Gates Application to Workday Force and Payroll (ODS) requirement’s gathered.
• Responsible for extract, transform and loading (ETL) the North America Business Unit data (JCI BUS Unit) from Workday Force to Gates Tables for supporting the Gates Application for North America Region (US, MEX, CAN and PRI) Business Units by using Oracle 11G DB links and enhanced/wrote the Gates stored procedures using Oracle 11G SQL and PL/SQL.
• Responsible for extract, transform and Loading the North America HR employee data( JCI IF GATES) employee data from Workday Force/Payroll (ODS) for supporting Gates Application for JCI employees North America Region (US, MEX, CAN and PRI) Employees by using Oracle 11G DB links and enhanced/wrote the gates stored procedures using Oracle 11G SQL and PL/SQL.
• Responsible for loading across the globe source ERP system projects, North America and EMEA countries projects at JCI Database using SQL and PL/SQL and scheduled Unix shell scripts to upload the data to the lower steam sending and working with Infor10 expense management to validate.
• Responsible for loading the Europe the Middle East and Africa (EMEA) HR employees Projects code data from different continents like Europe, Singapore, China and few other Middle East countries for supporting the Gates Application using Oracle 11G SQL and PL/SQL and tested using SAT application whether all the loaded project codes available.
• Responsible for fixing the production support issues from HR employees logged issues from INFOR and Gates Application as well as Gates scheduled Jobs abend status.
• Responsible for fixing the double quotes issues from Gates Expense Report Export file generation Hearder, Line, Adc and Vat code for sending the files to BE Oracle using Oracle 11G SQL and PL/SQL.
• Responsible for Creating the Employee Expense Reports ER’s from various different employees using GUID’s for testing the Project codes and VAT Receipt Codes for various continents on testing environment using Gates and INFOR Application.
• Responsible for fixing the production support issues from unix abended jobs, troubleshooting and fixed the issues as and when the issues.
• Responsible for involving and coordinating EI interface to pull the ERs for processing to down streams system to send the ER’s and resetting the ER header status to one from other different status.
• Responsible for working and coordination with EI and Workday/payroll ODS and Gates teams for supporting the North America and Europe the Middle East and Africa (EMEA) HR employees.
• Responsible for creating and deploying JCI monthly exchange rate extract from JCI treasury for supporting to Gates/Infor application while employees expense processing.
• Responsible for extensively working on scheduling the jobs on Unix environment.
• Responsible for Global Workplace Solutions mandatory setup and loading all projects and Expense reports to manage and support to GWS team after getting split this from Building Efficiency BE group.
• Responsible for taking care of all integration analyst role with various source ERPs to gates/infor application by coordinating with various systems intermediate systems and making sure all the gates/infor data processed and sent it back to target systems for posting and payment of employee expenses.
• Responsible to handling the user remedy high/medium/low tickets and fixing it on a priority basis.

Environment: Unix, Windows server 2003, Windows XP, Oracle 11g/10g, OEM, IBM Job Scheduling Console 8.4 (2), TOAD. Infor10 Expense Management, BMC Remedy tool.

Confidential, Boston, MA

Senior Oracle Consultant

Responsibilities:

• Responsible for fixing the production support issues for Fixed Income (FIS) as well as Investment View support (IVS) and supporting other custom applications on various Databases (ITDB, IDR and OTS).
• Responsible for setting up the addition of accounts, deletion of accounts and running Euro, Euro Financials, Euro US Banking and Credit meeting reports to support the Global Credit team on weekly basis.
• Responsible for customizing the fixed income bond forward roll inventory report as per user request by enhancing few changes using Reports 11G and successfully deployed on PROD envt.
• Responsible for setting up the Global package for US Holidays, Non-US global reports runs for multiple users who are not based out of US using ER-Admin and setup completed successfully.
• Responsible for checking the overall reports failure and re-run the reports and see if the report fixes the issue, otherwise investigate the root cause using Ops Console and Oracle Reports 11G.
• Responsible for creating the standard operation procedures (SOP's) for fixing the recurring issues from Fixed Income and Investment View modules to support.
• Responsible for checking the overall fixed Income and Investment view batch jobs using Maestro Job Console and fixing the issues and re-running the jobs and also escalating the issues to respective teams to further investigate.
• Responsible for uploading the data on daily basis for Manual override, Credit Option Greek Overrides.
• Responsible for uploading the date on monthly basis for Muni Monthly scenario using PL/SQL by following the standard operation procedures.
• Responsible to checking the IV Publisher process, OTS Publisher Process up and running and also checking the ITDB Health checks and OTS Health checks up and running to make sure IV process and OTS process are up and running.
• Responsible for checking the Overall recons discrepancies ( IV-IV, IV-OTS, IV-ITDB, IV-IDR, IV-IDR SOD AND IV-IDR EOD) and investigating using Oracle 11g SQL queries and fixing issues and also escalating further to fix the permanent fix to the respective teams.
• Responsible for using the Investment View Monitor tool to fix most of the issues by running the call API or Republishing the messages on daily issue encounter basis.
• Responsible for checking the message flow from AppWatch tool and checking all the messages are clean and clear ITDB performance check and also taking care of the other Appwatch queue messages.
• Responsible for supporting the weekend activates for all the release related activities and attending the daily status calls on a timely manner.
• Responsible for working and coordination with offshore team on Fixed Income and Investment View project.

Environment: Unix, Windows server 2003, Windows XP, Oracle 11g/10g, OEM, IBM Job Scheduling Console 8.4 (2), PL/SQL Developer.

Confidential, Armonk, NY

Lead Oracle Consultant

Responsibilities:

• Responsible for requirement gathering, analysis, design and development of various extract CLA domains for UK, US and Canada business units or environments, creation and reviewing the Solution Approach Documents (SAD’s) coordinating the team for all the Business of Future (BoF) application to Common Landing Area (CLA) req’s gathered.
• Responsible for working as a team lead from onshore and offshore on BoF to CLA and making sure the deliverables are delivered as per release build cycle.
• Responsible for design, develop and setup of BoF to CLA load domains process using Oracle 10g/11g, SQL, PL/SQL and Power center Informatica for running the CLA Load job runs.
• Responsible for providing the impact analysis and task estimations for all the Business BR’s, TR’s, CR’s bug fixing and environment issues and making sure completion of the tasks from all the team members with respective Planned build cycles and releases planned.
• Responsible for validating the mapping validations and loading all the mapping tables’ data like TOA, LOB, LOC and other mapping tables for loading into the mapping table.
• Responsible of CLA flashback views for batch process to enable CLA load, Payment, Actuarial feeds using SQL & PL/SQL Package.
• Responsible for CLA views for extracting the data from BoF OLTP source table data by transforming the mapping logic, SDL compliance for all the domains loading on to CLA target tables.
• Responsible for loading the data into CLA tables by executing the CLA Lod job run, payment feed and Actuarial feed for reserves using power center and setting up the job’s from Power center Informatica.
• Responsible for reconciliation scripts by comparing the BoF OLTP source tables data with respect to CLA target tables for data reconcile using SQL and PL/SQL.
• Responsible for grants and synonyms for PM schema for running the CLA jobs from Power center Informatica.
• Responsible for design and develop complex validation scripts SQL’s ( Test scripts SQL’s) queries using oracle SQL and PL/SQL and tuned data base SQL queries to improve the Load Performance and also verifying and validating from all the team members.
• Responsible for analyze, design, coordinate, review and supervise the development of extracting the BoF to CLA Loads, CMP, LFD and translate the system requirements to task specifications to team members.
• Responsible for validating the data correctness while sending the data to the downstream systems before consuming by CMP and LFD DWH’s team.
• Responsible for developing the Programs in PL/SQL to Extract, Transform and Load the data from BoF OLTP to CLA by Creating Views, PL/SQL Procedures, Packages and Functions.
• Responsible for Performance tuning of SQL queries for CLA load scripts, mapping validation scripts, reconcile scipts and validation test scipts consisting of many tables with large volume of data.
• Responsible for using the Hints, Explain Plan, AWR for tuning the SQL & PL/SQL Procedures. Responsible for working closely with functional team to understand the development related requirements and translated technical design document and distributed to the team.
• Responsible for doing the DBA activities like Database tuning (SQL TRACE, TKPROF, EXPLAIN PLAN, ANALYZE) and creating the DB links for different databases access
• Responsible for validating and reviewing all the scripts from the team. Responsible for Attending all meeting with BoF, CLA (CMP & LFD) team and Over all BoF to CLA team and all other team members at onsite as well as offshore.

Environment: Unix, Windows server 2003,Windows NT, Oracle 11g/10g, OEM, Informatica, Java, TOAD.

Confidential, Pittsburgh, PA

Lead Oracle Consultant

Responsibilities:

• Responsible for identifying the data elements from the legacy system(HBS/SPARCS, CATS, EPH, HMS). Mapping the Prescriber and Patient attribute with ESPS data model to support ESPS Lombardi application by creating staging, tables for moving the data from legacy systems using SQL & PL/SQL DBMS Packages.
• Responsible for creating the requirement document for patient, prescriber.
• Responsible using the Oracle External-tables, Refcursors, Materialized views, Nested tables, Records, Types, Dynamic SQL and creating the DB Links for Legacy System data transfer to ESPS application using Manual ETL process.
• Responsible for working as a team lead to handle onshore and offshore teams on ESPS Data migration and making sure the deliverables are delivered as per build cycle.
• Responsible for developing the ETL Programs in PL/SQL to migrate the data from Legacy system to ESPS Application by writing PL/SQL Procedures, Packages and Functions.
• Responsible of using PL/SQL Collections and Records for Data transfer of Patient, Prescriber data, process by writing the SQL & PL/SQL Procedures. Responsible for using the advanced concepts of SQL and PL/SQL queries and trouble shooting and fixing the issues raised by users.
• Responsible for developing the HMS prescriber process and customizing the billing procedure using PL/SQL Procedure for ESPS application in CVSC for scheduling in Control-M.
• Responsible for Performance tuning of SQL queries for HMS, EPH consisting of many tables with large volume of data.
• Responsible for using the Hints, Explain Plan, AWR for tuning the SQL & PL/SQL Procedures. Responsible for creating the requirement document for patient, prescriber.
• Responsible for doing the DBA activities like Database tuning (SQL TRACE, TKPROF, EXPLAIN PLAN, ANALYZE) and creating the DB links for different databases access
• Responsible for writing the Unix shell scripts. Responsible for Attending the All meeting with ESPS team, Legacy team ESPS team view team and all other team members at onsite as well as offshore.

Environment: Unix, Windows server 2003,Windows NT, Oracle 11g/10g, OEM, Lombardi .NET, SQL Developer, TOAD.

Confidential . Lauderdale, FL

Oracle Enterprise Consultant

Responsibilities:

• Responsible for Mapping the Underwriting Policies & Claims for Data Transfer and Conversion from ODS (Legacy System) to One view by creating Tempout tables for moving the processed data from One View Application using SQL & PL/SQL DBMS Packages.
• Responsible using the Oracle External-tables, Refcursors, Materialized views, Nested tables, Records, Types, Dynamic SQL and creating the DB Links for ODS data transfer to One View and using web services.
• Responsible for developing the ETL Programs in PL/SQL to migrate the data from ODS to One View Application by writing PL/SQL Procedures, Packages and Functions.
• Responsible of using PL/SQL Collections and Records for Data transfer of Membership data, Cash flow process by writing the SQL & PL/SQL Procedures. Responsible for using the advanced concepts of SQL and PL/SQL queries and trouble shooting and fixing the issues raised by users
• Responsible for developing the new billing Cash flow process and customizing the billing procedure using PL/SQL Procedure for One View application in Cigna for scheduling in Control-M.
• Responsible for Performance tuning of SQL queries for ODS data warehouse consisting of many tables with large volume of data.
• Responsible for using the Hints, Explain Plan, AWR for tuning the SQL & PL/SQL Procedures
• Responsible for doing the DBA activities like Database tuning (SQL TRACE, TKPROF, EXPLAIN PLAN, ANALYZE) and creating the DB links for different databases access
• Responsible for writing the Unix shell scripts. Responsible for Attending the All meeting with ODS team, One view team and all other team members at onsite.

Environment: Unix, Windows server 2003,Windows NT, Oracle 11g/10g, OEM, Microsoft .NET, SQL Developer, TOAD.

Confidential . Richmond, VA

Lead Oracle Enterprise Consultant

Responsibilities:

• Responsible for Designed, developed and tested Oracle PL/SQL packages, stored procedures, functions and triggers for VFB using Oracle 11g advanced concepts..
• Responsible for Data Migration Underwriting Policies & Claims Data Conversion from Premia to ODS by creating Tempout tables for moving the processed data from Premia Application using SQL & PL/SQL Procedures by creating Flat files and DB Links.
• Responsible for working as a team lead to handle onshore and offshore teams on VFB Data migration and delivered the deliverables as per release cycle.
• Responsible for loading the Personify Customer data into Premia application by writing the PL/SQL stored Procedure and running through Control-M scheduler for real time system.
• Responsible for Data Transfer and loading other Masters like Membership, Agent, Adjuster, and Vendor from PMS system to Premia Application, all these achieved passing through Temp tables by writing PL/SQL stored procedures and SQL queries.
• Responsible for creating the Views, Materialized Views for Underwriting, Claims and Billing from scratch VFB ODS Warehouse for reporting.
• Responsible for writing the PL/SQL Procedure Scripts and creation of Debug log table using Clob and Blob, where error out messages will be stored and easy to trouble shoot.
• Responsible Data Conversion developing programs for Onset & Offset & Unearned and Inforce Premiums for sending the data to ODS by writing the PL/SQL DBMS Package.
• Responsible for Design, Developing the Collaborator Underwriting Quick Quote, Full Quote, Policy, Vehicle, Drivers, attributes screens using Microsoft .NET frame work.
• Responsible for Design, Developing the Collaborator Claims Header, Claims Additional Risk Info, Claims Claimant, Claims Reserve, Claims Estimate header and details screens using Microsoft.NET frame work for supporting OLTP system..
• Responsible for VFB accounts feed which sending the accounts details by encrypting to BBT bank using queuing process by writing the PL/SQL Packages and data transmitted using XML, XSL and Oracle net services HTTP, HTTP(S), SMTP & using transferring tools, protocols (ftp,scp,etc)
• Responsible for writing the Unix shell scripts and working as the DBA activities like Database tunning (SQL TRACE, TKPROF, EXPLAIN PLAN), RAC, creating the users, tablespaces, granting the privileges, Exporting, Importing and applying the Patches for various releases happened. Responsible for writing the Unix Shell scripts for automation using vi Editor. Involved in running AWR reports for checking the performance tuning
• Responsible for installations & working in all the Servers like Development, Test, Model Office (MO), Training and Production environment’s. Responsible for extensively working on PL/SQL Packages, Stored Procedures, Functions and triggers for Temp-in and out process.
• Responsible for Coordinating with offshore team on all Process information and testing for sending it to Scheduler running through Control-M. Responsible for Attending the All meeting with ODS team and all other team members at onsite as well as offshore.

Environment: UNIX, Windows server 2003, IBX-AIX, SQL Server 2005, Oracle 11g/10g, OEM, Microsoft .NET Frame Work, Java, JavaScript, HTML, XML, XSL, CSS, TOAD & Shell Scripts.