SUMMARY

• Above 7+ Years of IT experience in production & development support, Analysis, Design, testing, Implementation and proven ability to work with diverse and disparate teams and consistently recognized for organizing and completing projects in a business environment including all phases of software development life cycle.
• Extensive experience in Oracle (12c, 11g, 10g, 9i, 8), Microsoft SQL Server 2016/2012/2008 , SSIS, SSRS, T - SQL exposure to data Warehousing tools Informatica, SAS, Netezza, Rational Rose, HP QTP, Selenium and hands on experience writing SQL queries and PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, d Cursors, Database Objects and Collections.
• Experience in SAS intelligence to extract data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS) and involved in fine Tuning, Performance, and Query optimization of the Database as required by the application.
• Extensive experience in System Life Cycle Methodologies (SDLC) in Database driven Application Development and Hands on experience in Data Conversion, Analysis, Design, Development, Mapping, Testing and Implementation of various projects.
• IT experience in client Server Architecture, Business applications design, development and maintenance, Programming and software development in heterogeneous environment.
• Exceptional skills and proven ability to manage, motivate, facilitate, and support large teams and team-based processes for conceptualizing and writing proposals and/or producing other large-scale, complex program/technical designs and related documents, products and designed and developed ETL Mappings to load data from Source systems.
• Proactive in seeking out, synthesizing, presenting and disseminating information relevant to new business/program development including information on new opportunities, emerging needs and trends, innovations, existing programs/projects.
• Experienced in Full Life-cycle Development: Requirements Analysis, Design, Programming, Implementation, Testing, and Production Maintenance of Information systems
• Experience in Offshore Coordination whereby assisted many new system studies along with project/client management & logical analysis and design with PL/SQL batch processes in Development and Test area.
• Possess excellent problem solving, inter-personal and communication skills, proven self-starter capable of working on multiple projects and willingness to learn new technologies and applythem in creative ways.

TECHNICAL SKILLS

Relational Databases: Oracle 12c/11g/10g/9i/8, Netezza, MS-SQL Server 2016/2012/2008 .

ERP Packages: Oracle Applications (11i/11/10.7), Oracle Process Manufacturing 11i

Oracle Modules: Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Purchase Order (PO), Order Management (OM).

Tools: /Utilities SQL Developer/data Modeler, Cognos (Reporting), SAS Studio, Asp.net, Discover forms/reports, SAS 9.4, 9.3, and 9.2, TOAD Discoverer10g, PL/SQL developer, SQL*Loader, PVCS, SAS Visual Analytics 7.4, Erwin, Rational Rose, exp/Imp, Data pump, SQL Migration wizard.

Testing Skills: (Manual/Automated Testing) WinRunner, HP QTP/UFT, Selenium.

ETL/OLAP Tools: Informatica 7.1, Datastage 4.0, Business Objects 6.5, SAP Business Objects, Integration Services, SSRS, SSAS, SSIS, SAP data Services, SAP Crystal Reports, Crystal Reports.

Languages: SQL, PL/SQL, Visual Studio, Visual Basic, Java, C, C++

Java Technologies: Java, JDK, J2SDK, Servlets, JSP, XML

Operating System: UNIX Linux/HP/Solaris, Windows 64Bit/32 Bit.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. Oracle PL/SQL, MS-SQL

Responsibilities:

• Involved in developing frameworks for Data Architecture, Data Governance, Data Quality, Master Data Management, Data Integration, Data Security, and Data retention processes.
• Responsible for Business Intelligence tools (SSIS, SSAS, and SSRS) in MS SQL Server, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
• Worked on maintaining a holistic view of information assets by creating and maintaining artifacts that illustrate how information is stored, processed, and accessed.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server and built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Worked on ETL, data profiling, data quality and clean ups for SSIS packages.
• Develops and tests corresponding data check programs to work with the Clinical Data Management System.
• Responsible for SAS programming background for maintaining existing code, ad hoc reporting and supporting the reporting functions.
• Responsible for SAS intelligence to extract data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data.
• Worked on loading external data into the Data Management System and verifies accuracy of data load.
• Perform testing on database entry screens sufficient to confirm that database output matches the expected results.
• Developed PL/SQL Stored Procedures, Functions, Packages, and Triggers to implement business rules into the Clinical application.
• Responsible for data validations, feeding of live data and user acceptance for each module and responsible for coding and modifications to enforce business rules and to improve Performance of the system.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using SQL developer and responsible for Developing and integrating clinical data reports, and migrating to data warehouse reporting systems.
• Responsible for Creating test plans and test scenarios for the functionality and performance testing.

Environment: Oracle 12c/11g, MS-SQL Server 2016/2012/2008 , SQL Integration Services, SSRS, SSAS, SSIS, SQL Developer, TOAD, PL/SQL, Netezza, SQL*Loader, MS Visual Studio, SAS Visual Analytics 7.4, SAS 9.4-9.2, Export/Import/Data pump, Linux, Windows, SAS, Java, Cognos, EDC Application.

Confidential, Washington, DC

Sr. Oracle PL/SQL, MS-SQL Programmer

Responsibilities:

• Responsible for integrating data from multiple data sets, analyze and interpret complex data sets and make findings relevant and actionable for both internal and external stakeholders.
• Worked on setting up, deploying, configuring, and monitoring data warehouse reporting systems.
• Worked on SAS programming background for maintaining existing code, ad hoc reporting and supporting the reporting functions.
• Provided timely, accurate and reliable management reporting and analysis of data and assisted in developing of additional reporting information systems, as needed.
• Responsible for verifying data quality to ensure accurate analysis and reporting and worked on enhancement of designed federated Data Marts for performance enhancement.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server and deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Responsible for T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing and developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS) and involved in fine-tuning, performance, and Query optimization of the Database as required by the application.
• Developed Fact Tables, Dimension Tables, Staging tables, and Stored Procedures for data mart and involved in modifying various existing packages, procedures, functions and triggers according to the new business measures.
• Worked on PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Responsible for performance tuning of SQL queries written in procedures and functions at the back end, frontend Confidential Apps forms.
• Responsible for Documentation of all the project developments and methodologies
• Followed for the defect-fix, as per the standards defined and the system requirements.

Environment: Oracle 12c/11g, MS-SQL Server 2012/2008, Integration services, SSIS, SSR, SSAS, MS Visual Studio, Netezza, SQL Developer, TOAD, PL/SQL, SQL*Loader, SAS Studio, SAS Visual Analytics, Oracle Data pump (Export/Import), Linux, Windows, .NET, C#, ASP.NET, Python, SQL, MVC, XML.

Confidential, IL

Sr. Oracle PL/SQL & MS-SQL Programmer Analyst

Responsibilities:

• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
• Worked on System Analysis, Design, Coding, Testing, Development and Documentation.
• Designed and developed the automation process for data conversions.
• Developed new strategies for data conversions using SQL*Loader flat files.
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Integrated SQL Server reporting services with MOSS (Microsoft Office Share Point Server) to auto deliver reports to the Share Point portal.
• Created sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Responsible for SAS macros to replace hard coded passwords allow a smooth secure interface between environments. Analyzed programs to determine resolutions for business team issues. Optimized SQL downloads, refractor COGNOS push for cube data. Test and QA all work.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS) and involved in fine-tuning, performance, and Query optimization of the Database as required by the application.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments and Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Responsible for SAS intelligence to extract data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data.
• Developed and Modified UNIX Shell scripts and executed them as cron batch jobs.
• Created complex reporting views for masking actual table data as part of the security and to eliminate the complexity of the large queries.
• Improved the application performance significantly by tuning SQL Queries and PL/SQL program units, developed and modified triggers, packages, functions and stored procedures for data conversions.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, hints, indexing and Partitioning of tables.
• Experience in SAS intelligence to extract data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data.
• Performed need based activities ongoing maintenance for Development, QA, QC and Staging environments, Jobs scheduling in Scheduler, Data Import from production for QA/QC, DB Objects Creation and validation.
• Interacting with UI development team to Develop in tandem back-end solutions with front-end web executions.
• Designed and developed the data migration Scripts and Programs to upgrade the Development, QA, UAT and Production DB schemas upgrade to Oracle 12c from Oracle 11g in Development and Production Environments.
• Analyzing and prioritizing the production issue tickets and moving them from development to scheduled releases.
• Created and managed many objects in large Oracle Databases containing millions of records.
• Extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors, REF Cursors and loops.
• Created indexes on tables to improve the performance by eliminating the full table scans.
• Used SQL loader for migrating the flat file data into targeted tables in Oracle Databases.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, Explain plan and Trace sessions for Cost based and Rule based optimization.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans, profiling and Trace sessions for Cost based Optimization.
• Prioritized initiation requests; ensured projects were delivered on time, budget and to user satisfaction and Formulated procedures; ensured quality, programming and project management standards were met.

Environment: Oracle 12c/11g/9i, MS-SQL Server 2012/2008, SSAS, SSRS, SSIS, Visual Studio, SAS Visual Analytics, SQL Developer, TOAD, PL/SQL, Netezza, SQL*Loader, Export/Import/Data pump, Linux, HP-UX, Windows, Informatica, Cognos, Java.

Confidential, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Formulated procedures; ensured quality, programming and project management standards were met.
• Prioritized initiation requests; ensured projects were delivered on time, budget and to user satisfaction.
• Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.
• Developed and supported the enterprise data warehouse and the reporting front-end for the high quality decision support and executive information solutions.
• Analysis, Design and Implementation of Oracle Discoverer queries & Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems.
• Developed SQL scripts to fetch complex data from different tables in remote databases using joins and database links for Unit Testing for data conversions.
• Provided direction and leadership to the IT team of programmer analysts, systems analysts and technical specialists; including scheduling, assignment, review/monitoring work, recruitment/performance evaluation.
• Designed and developed a data conversion process to extract, transform and load 1TB of data in a severely time constrained environment.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS) and configured SSIS packages using Package configuration wizard to allow packages run on different environments and Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Wrote PLSQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
• Used SQL Loader for migrating flat file data into target, generated server side PL/SQL scripts for data manipulation and validation and created various materialized views for remote instances.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based and Rule based Optimization.
• Developed and modified triggers, packages, functions and stored procedures for data conversions.

Environment: Oracle 12c/11g/10g/9i, MS-SQL Server 2012/2008/2005 , PL/SQL Developer, TOAD, PL/SQL, SQL*Loader, Visual Studio, SSRS, SSIS, SSAS, Export/Import/Datapump, Linux, HP-UX, Windows, Java.

Confidential - Atlanta, GA

Sr. Oracle PL/SQL & MS-SQL developer

Responsibilities:

• Understanding the existing systems and handling Business Exceptions.
• Used performance-tuning utilities like EXPLAIN PLAN, SQL Trace to improve the performance by reducing the run time of queries on the database.
• Based on the data loaded in the target db. (Oracle) various business reports are developed.
• For the reporting purpose extensively used SQL Scripts.
• Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Used data profiling task in SSIS 2008 to identify poor data and repair it and Created report snapshots to improve the performance of SSRS.
• Written complex SQL queries using Joins, Sub queries and Group functions.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business measures.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Used Cursors, Native Dynamic SQL and Bulk Collections to implement the Bulk Load.
• Used Materialized views in order to improve the performance.
• Trouble shooting performance issues within packages using dbms output.
• Developed Forms and Reports for their customer master Management.
• Involved in Design and Development of Form to enter the customer Details, Sites details and Address Details using Forms 6i.
• Worked on to create the APIs to create the customers from the backend.
• Created a Form to manage the customer account profiles using Forms 6i.
• Involved in Design & Development of the Total customer report using Reports 6i.
• Created the total sales reports for the customers using Reports 6i.
• Coordinating with the business users for System Test and User Acceptance Test.
• Developed scripts for validating the UAT deployment for the schema objects.
• Responsible for Documentation of all the project developments and methodologies
• Followed for the defect-fix, as per the standards defined and the system requirements.

Environment: Oracle 11g/10g, MS-SQL Server 2008/2005, SSIS, PL/SQL Developer, TOAD, PL/SQL, SQL*Loader, Export/Import/Datapump, Linux, HP-UX, Windows, Java.

Confidential - Philadelphia, PA

Sr. Oracle PL/SQL & MS-SQL developer

Responsibilities:

• Analysis, design and development of required reports using Oracle reports.
• Customized the standard purchase order report as per the client requirement.
• Customized sales order acknowledgement report as per the changed sales order processing process.
• Developed Blanket Purchase Order report based on the client requirement.
• Designed and developed PO Interface, GL interface, Supplier Invoice Interface and Customer Interfaces from legacy system.
• Developed custom forms, reports and concurrent programs using Forms 6i, Reports 6i and registered them to Oracle Applications.
• System Administration activities included creating new responsibilities, requesting groups and users, registering custom applications, and registering forms as functions and reports as concurrent programs.
• Developed supplier conversion programs and customer conversion programs.
• Developed Outbound Interface to upload the payment data to Legacy system by using the UTL FILE Package.
• Involved in reporting enhancements using Oracle Discoverer tool.
• Developed Payables Invoice Outbound Interface to upload the data from AP base table to Legacy custom tables.

Environment: Oracle Applications 11i (PO, INV, BOM, WIP, GL, AP, AR), Forms 6i, Reports 6i, Discoverer 4i, SQL*PLUS 3.3, PL/SQL 2.3, Oracle 9i, UNIX & Windows XP professional, TOAD.

Confidential - Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

• Meeting with end user, collecting requirements and converting into technical specification.
• Developed Stored Procedures, Functions and Packages for implementing complex business logic.
• Created and maintained Oracle schema objects like Table spaces, Tables, Rollback segments, Indexes, Sequences and Synonyms.
• Involved in the ETL process of loading data from multiple sources using SAP DI.
• Created data flows to process the data into stage area and run transformations to load the data into main tables.
• Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS and Automated DI Jobs and procedures using Active Batch.
• Created UNIX Shell script for sending email to alert users for erroneous records.
• Responsible for performance tuning of SQL queries written in procedures and functions at the back end which are called from the front end forms
• Gathered statistics and analyzed tables and Indexes for performance tuning.
• Wrote complex SQL queries using Joins, Sub queries and Bulk Collections.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business measures.
• Migrated Oracle Forms 6i/ Reports 6i to Oracle Forms 10g/ Reports 10g.
• Responsible for SQL tuning and optimization using Explain Plan, TKPROF utility and optimizer hints.
• Handled various exceptions to troubleshoot PL/SQL code.
• Wrote PL/SQL blocks using cursors, REF cursors to generate results to Java based applications.
• Created indexes on tables for fast retrieval of data.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL's thorough out the projects
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, TOAD, Erwin, UNIX & Windows 2005/2003.