Responsibilities:

• As a team lead involved in the full development lifecycle (SDLC) and was responsible for collecting business requirements, system analysis, detailed technical design (Architecture), application development, data modeling, implementation and maintenance (production support) of Data Warehouses, Data mart and OLTP system..
• Participating in all aspects of database programming on Oracle SQL, PL/SQL and related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Table Partitions, Triggers, Materialized Views, external tables etc.
• Building Data Warehouse for reporting and analysis purpose.
• Writing (ETL Scripts) PL/SQL scripts, custom PL/SQL subprograms that extract data from different systems and populate into the Data Mart and data warehouse schemas.
• Performing analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Unix Shell Scripts for Data Warehouses, Data mart and OLTP system.
• Using Oracle 12c new features: and execute PL/SQL functions inside SQL statements using “WITH” clause, restrict access to program units through use of a “white list,” specified by the “ACCESSIBLE BY” clause, fine-tuned privileges for a program unit by granting roles to that unit, “DEFAULT ON NULL”, “IDENTITY” columns, Row limiting using “FETCH FIRST”, Invisible columns, Composite Trigger to avoid mutating error etc.
• Using Bulk binds (FORALL, BULK COLLECT), Hints, Collections, bind variables and Dynamic SQL, and parallel processing to improve performance.
• Performing code review for other developers, providing suggestions to improve performance.
• Maintaining different versions of codes using GIT (version control software).
• Performing Unit test, UAT, creating test plan for QA and preparing production implementation scripts, rollback scripts.

• Crating XML data using XMLELEMENT, XMLFOREST, DBMS_XMLGEN package, parsing XML data using SQL function EXTRACT, GETSTRINGVAL, SYS_XMLGEN, XML_Query etc. Proficient using UPDATEXML, APPENDCHILXML etc.

• Working in Agile environment (Scrum, Kanban) using JIRA.
• Involved in performance tuning of SQL queries and PL/SQL subprograms.
• Writing Shell Scripts for job automation and ETL purpose using External Table interface.

• Involved in all phases of system development lifecycle (SDLC) i.e. collecting user requirements, design (Architecture), development, testing, implementation and production support of the Supply Chain Management System.
• Participating in all aspects of database programming on Oracle SQL, PL/SQL and related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Table Partitions, Triggers, Materialized Views, external tables etc.
• Building Data Warehouse.
• Writing (ETL Scripts) PL/SQL scripts, custom PL/SQL subprograms that extract data from different systems and populate into the Data Mart and data warehouse schemas.
• Performing analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Unix Shell Scripts for Data Warehouses, Data mart and OLTP system.
• Using Bulk binds (FORALL, BULK COLLECT), Hints, Collections, bind variables and Dynamic SQL, and parallel processing to improve performance.
• Performing code review for other developers, providing suggestions to improve performance.
• Maintaining different versions of codes using GIT (version control software).
• Performing Unit test, UAT, creating test plan for QA and preparing production implementation scripts, rollback scripts.
• Writing Shell Scripts for job automation and ETL purpose using External Table interface.
• Using Oracle Reports Builder, BI publisher to create reports.
• Involved in performance tuning of SQL queries and PL/SQL subprograms.

• Involved in all phases of system development lifecycle (SDLC) i.e. collecting user requirements, design (Architecture), development, testing, implementation and production support of the Inventory Management System.
• Participated in all aspects of database programming on Oracle SQL, PL/SQL and related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Table Partitions, Triggers, Materialized Views etc.
• Performed analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Unix Shell Scripts for Data Warehouses, Data mart and OLTP system.
• Used Bulk binds, Hints, Collections, bind variables and Dynamic SQL, and parallel processing to improve performance.
• Performed code review for other developers, providing suggestions to improve performance.
• Maintained different versions of codes using GIT.
• Used Oracle Reports Builder, BI publisher to create report in different format.
• Worked in Agile environment (Scrum, Kanban) using JIRA.

Involved in performance tuning of SQL queries and PL/SQL subprogram using DBMS_XPLAN.DISPLAY_CURSOR, DBMS_PROFILER, SQL Trace utility and Explain plan etc.

• As a team lead involved in the full development lifecycle (SDLC) and was responsible for collecting business requirements, system analysis, detailed technical design (Architecture), application development, data modeling, implementation and maintenance (production support) of Data Warehouses, Data mart and OLTP system.
• Used data visualizationtool/BI tool Tableau to create interactive Dashboards, Worksheets and ad-hoc reports.
• Created different type of reports using Crystal Reports.
• Crating XML data using XMLELEMENT, XMLFOREST, DBMS_XMLGEN package, parsing XML data using SQL function EXTRACT, GETSTRINGVAL, SYS_XMLGEN, XML_Query etc. Proficient using UPDATEXML, APPENDCHILXML etc.
• Wrote database objects like Tables, Views, Stored Procedures, Functions, Packages, Materialized views, DB triggers, Partitions, Indexes.
• Used batch processing techniques such as Bulk collections, dynamic SQL, and parallel processing.
• Used Bulk binds (FORALL, BULK COLLECT), Hints, Records, Collections, Parallel Processing, and Dynamic SQL to improve performance for Data Warehouses, Data mart and OLTP system.
• wrote Oracle ETL scripts that extract data from an operational database and populate the staging and target OLTP and data warehouse schemas.
• Performed Unit testing, UAT, creating test plan for QA and preparing production implementation scripts, backup and rollback scripts.
• Wrote Korn shell scripts for production job automation in Linux/Unix.

• Performed ETL (extract, transform and load) using SQL * Loader, external files, external table interface, Unix shell script and custom Oracle PL/SQL program units.

• Working in Agile environment (Scrum, Kanban) using JIRA.

VMS - IQNavigator provides services procurement solutions through its vendor management system (VMS) and managed service provider (MSP) accessed from over 100 countries daily, IQNavigator's cloud-based Vendor Management System (VMS) software processes tens of billions of dollars in yearly services spend on complex services procurement and contingent workforce programs.

Responsibilities:

• Worked as a team lead, coordinated onsite and offshore teams.
• Collected and documented user requirements and creating mapping documents to support the implementation of the extraction, transformation, loading (ETL) and validation of data moving from legacy systems into vendor management system (VMS) and managed service provider (MSP) system.
• Involved in the design, development and testing of custom data migration scripts using Oracle PL/SQL in an optimized manner.
• Wrote database objects like Tables, Views, Procedures, Functions, Packages, Materialized views, DB triggers, Partitions, Indexes for Data Warehouses, Data mart and OLTP system and for ETL purposes.
• Used advanced Bulk techniques (FORALL, BULK COLLECT), Hints, Records, Collections, and Dynamic SQL to improve performance of Data Warehouses, Data mart and OLTP system.
• Created XML report using Oracle PL/SQL code.
• Involved in performance tuning of SQL and PL/SQL code using DBMS_XPLAN.DISPLAY_CURSOR, DBMS_PROFILER, SQL Trace utility and Explain plan.
• Wrote Korn shell scripts for production job automation in Linux.
• Maintained different versions of codes using SVN, Perforce.
• Used SQL * Loader to load data from external files.
  • Worked in Agile environment (Scrum, Kanban) using JIRA.

Project Name : Facets (Integrated Healthcare Solutions) : Facets is a complete healthcare solution comprises the module like : Group, Membership, Provider, Claims, Authorizations, Accumulators, HIPPA etc. Data is coming from various sources like Oracle, SQL Server, Sybase, DB2 etc which will be loaded into Facets. The entire ETL process consists of source systems, staging area, Facets, Data warehouse and Data mart. This was a 100?ta conversion project. Performed data conversion for Blue Cross & Blue Shield of Rhode Island, Affinity Medical Group. BCBS of Michigan.

Responsibilities:

• As a team lead involved in collecting user requirements and design the mapping documents.
• Involved in designing Entity Relationship Diagram (ERD), Dimension table, Fact table, Schema, Logical and Physical data models and Data Flow Diagram (DFD) for Data Warehouses, Data mart and OLTP system.
• Involved in design and development of ETL mappings and custom PL/SQL subprograms (package, procedure, functions etc.) in an optimized manner.
• Migrated data from customer’s legacy systems into Facets database (Oracle) and into Data warehouse.
• Wrote PL/SQL code (procedures, functions, packages, triggers, views, materialized views, batch jobs, etc.) for Data Warehouses, Data mart and OLTP system.
• Performed SQL and PL/SQL tuning using Explain Plan, Execution plan, SQL Trace utility & DBMS_PROFILER.
• Wrote Oracle ETL scripts that extract data from an operational database and populate the staging and target OLTP and data warehouse schemas.
• Wrote Korn shell scripts for production job automation in Linux/Unix.
• Used SQL*Loader, BCP (bulk loader), Informatica Powercenter to load data from external files.
• Wrote perl script for data cleaning.
• Wrote Batch jobs, daily jobs, one time jobs and queues.
• Used Oracle Reports Builder for reporting.

Responsibilities:

• Created high performance queries and PL/SQL codes using Bulk Binds, Collections, REF Cursors etc for OLTP and ETL.
• Wrote high performance procedures, functions, triggers, packages, Korn shell scripts for ETL process.
• Wrote Data Cleaning scripts.
• Used SQL * Loader to upload data into the staging files from external files, using Export, Import, for data transfer from one domain to another domain using FTP, SFTP, NDM (Direct), JAVA interfacing class.
• Did code review, checking code standard of other junior developers.
• Created and tuned various feeds/downloads, nightly jobs, and other daily/monthly reports/download.
• Did performance tuning using Explain Plan, Execution plan, SQL Trace utility, DBMS PROFILER.
• Maintained different versions of codes using CVS, Starteam, multiple task using JIRA.
• Performed Unit testing, UAT, created test plan for QA and prepared production implementation scripts.
• Did analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Korn Shell Scripts.
• Created rollback scripts.

• Involved in the full development lifecycle and was responsible for collecting business requirements, system analysis, functional specifications, detailed technical design, application development, data modeling, implementation and maintenance using Oracle SQL & PL/SQL.
• Created PL/SQL Packages, Procedures, Functions and Triggers.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
• Created Batch jobs, daily jobs, one time jobs and queues.
• Performed SQL performance tuning using Explain plan, Trace utility & TKProf.
• Documented all Oracle Reports, Packages, Procedures and Functions development specifications.
• Maintained different version of software (version control) using SVN and GIT.
• Provided production support solving Tickets created using the software named JIRA..
• Prepared test plan for QA for testing before moving from PreProd to Production environment.
• Wrote Unix Shell Script for different purposes.
• Prepared production implementation plan & scripts.
• Scheduled job using Tidal and Autosys.

Project Name : FastFinance (Mortgage & Financing for healthcare instruments)

Environment : Oracle 10g, PL/SQL, Oracle Reports Builder 10g, HTML, Korn Shell Script, Window NT, AIX, JAVA, FTP, SFTP, NDM (Direct), SQL Navigator 4.5, Version Control Software PVCS.

Responsibilities:

• Have been involved in Design, Development, Testing, Integration, Implementation and Maintenance of financial system using Oracle Database 10g, Oracle PL/SQL, JAVA, Korn shell script, Oracle Reports Builder, Oracle Database 10g, Windows NT, AIX. Involved in backend development.
• Wrote complicated stored Procedures, Functions, Database Triggers and Packages, Korn Shell Scripts.
• Analyzed, created new and modified existing reports, scheduled reports, oracle jobs using AIX, Oracle 10g, Oracle Web Toolkit, Reports (10g/9i), PL/SQL, Stored Procedures, Functions, Packages, Korn Shell Scripting, FTP, SFTP, NDM (direct).
• Did code reviews of other developers and provided suggestions to improve performance
• Wrote high performance queries/programs using Bulk Binds, REF Cursors etc.
• Helped other developers in tuning queries or programs and trained them to write well-tuned code.
• Converted Reports from 9i to 10g.
• Designed and Developed FTP, SFTP and NDM (direct) processes using Java, JavaScript, PL/SQL and Korn Shell Script wrapper for AIX, Unix and Linux.
• Created various feeds/downloads, nightly batch jobs and other daily/monthly reports/downloads.
• Tuned batch jobs and other daily/monthly reports/downloads.