SUMMARY:

• 8+ Years of extensive experience as a PL/SQL, Oracle Developer with ETL experience.
• Expertise in Software Development Life Cycle(SDLC) of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 11g/10g /9i database.
• Extensively worked with Oracle Reports Builder 11g , creating new Reports and extending the functionality of existing Reports as per User Requirements.
• Strong experience in providing technical documentation and status reports of the applications as per the requirement.
• Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Worked with Arrays, Records, Dynamic SQL and Exception Handling.
• Involved in Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, sql trace and TKPROF.
• Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus.
• Automating data loading, extraction, reports generation using UNIX Shell scripting.
• Experience in handling very large data files using Export - Import Utilities and SQL*Loader.
• Efficient in creating Test cases and performed data validation and process testing for application moving into production. Worked on automating data loading, extraction, reports generation using UNIX Shell scripting.
• Knowledge of standard data modeling patterns and practices, e.g. 3NF, dimensional models, and the ability to produce logical and physical models using Visio.
• Experience working in Agile Scrum model and Waterfall model life cycles.
• Well versed in utilizing JIRA as Ticketing Tool. GIT Hub, Source Tree for Promoting (Check-in) the code to higher environment and to maintain in the repository. Utilized Stash to raise Pull Requests and get the Co developer’s approvals and Confluence for meeting notes.
• Working Experience in Data extraction, Transmission and Loading (ETL).
• Extensively used ETL methodologies for supporting data Extraction, Transformation and Loading (ETL)process in a corporate-wide-ETL solution using Informatica Power Center.
• Worked extensively on various Informatica Data Integration components - Repository Manager, Designer and Workflow Manager/Monitor.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Working on building Queries, Stored Procedures, Functions, Triggers etc. in T-SQL, PL/SQL that meet business needs.
• Worked with Business Managers, Analysts, and end users to correlate Business Logic and Specifications for ETL Development.
• Good understanding of Data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• Knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.
• Worked extensively in developing, deploying, and testing of Oracle Forms .
• Highly organized and efficient to prioritize and manage multiple tasks.
• Proven ability to work efficiently in both independent and teamwork environments.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g/12c, SQL Server 2005/2007, MS Access, DB2.

Languages: SQL, PL/SQL, Pro*C, C/C++, JAVA, .NET, XML, UNIX Shell Scripting, Perl Scripting.

Oracle Tools/ GUI: Forms 6i/9i/10g, Reports 6i/9i/10g/11g, Discoverer 4i/10g.

Tools: TOAD, SQL DEVELOPER, SQL*Loader, Oracle SQL*Plus, SQL Navigator, UNIX/LINUX Utilities.

Web Technologies: HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, Java Script, CSS, DHTML, XML.

Operating Systems: Windows Family, MS-DOS, UNIX, Solaris.

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, NY

Senior Oracle Developer

Responsibilities:

• Worked on Oracle PL/SQL Development, Oracle Forms & Reports in all phases of SDLC involving Analysis, Design, Development, Implementation, Testing and Deployment of Business applications using Oracle RDBMS on various platforms.
• Developed and modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers based on technical and functional specification documents.
• Used various Informatica Power Center and Data Quality transformations as - aggregator, source qualifier, update strategy, expression, joiner, lookup, router, sorter, filter, XML Parser, labeler, parser, address validator, match, merge, comparison and standardizer to perform various data loading and cleansing activities.
• Involved with all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing and documentation.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.
• Conduct or perform data modeling exercises in support of specific needs for data, reports, or analyses.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Involved in Unit Testing and Preparing and using Test data/cases to verify accuracy and completeness of ETL process.
• Worked on Migration and Upgradation of the Databases between different environments and versions.
• Created and modified Unix Shell scripts with SED and AWK to update database, create flat file reports and monitor system performance.

Environment: Oracle Database 11g/12c, PL/SQL Developer, UNIX, SQL Loader, SQL Developer, PL/SQL Developer Oracle Forms 10g, Oracle Reports 11g, HTML, XML, SQL, ETL Informatica.

Confidential, Smithfield, RI

Senior Oracle Developer

Responsibilities:

• Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and maintenance.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Worked on Logical and physical modeling as well as Maintaining SQL Script for creation of database Objects and generating scripts using Erwin tool.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, OLAP Cubes using SSAS, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Wrote complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• Involved in the creation and deployment of the Reports using SSRS and configuring the SQL Server Reporting Server.
• Worked on Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008 with Import/Export data, Bulk insert and BCP.
• Involved in Unit testing of the Reports, Forms and PL/SQL Stored procedures.
• Customized Form filed like enabling, disabling form filed and incorporating oracle alerts using Form Builder 10g.
• Designed and Developed complex Reports to meet end user requirements and deployed using Oracle Report 11g.
• Worked extensively in Informatica, Teradata, Oracle 10g/11g, Unix Shell Scripting, SQL and PL/SQL with strong implementation on performance management.
• Created the jobs in Control-M to run the Informatica workflows.
• Designed and developed intranet web applications using Javascript and CSS.
• Hands on experience with client-side technologies that include Java Script, HTML, CSS and jQuery.

Environment: Oracle Database 11g/12c, PL/SQL Developer,UNIX, SQL Loader, SQL Developer, PL/SQL Developer Oracle Forms 10g, Oracle Reports 11g, HTML,XML, SQL.

Confidential, Dayton, Ohio

Senior Oracle Developer

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Developed the shell script, SQL*Loader script, and most of PL/SQL stored procedures, triggers and views to handle the Online and Batch process.
• Well conversant with documentation for specifications, developing test cases, technical design and writing training manual for end users. Experience in documenting the reports for future reference.
• Bug fixing and enhancing existing reports. Making changes to the reports that are created in earlier versions to Crystal reports.
• Designed and Developed complex Reports to meet end user requirements and deployed using Oracle Report 11g.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports.
• Interacted with Business Analysts to gather the user requirements and participated in data modeling JAD sessions.
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN crystal reports in HTML, RTF formatdepending upon the requirement, Published Data model in model mart, created naming convention files, coordinated with DBAs' to apply the data model changes.
• Developed complex report in both SSRS and Crystal Reports based on the requirements provided and going through multiple discussions with the Team.
• Oracle Backend Development involving creation and maintenance of PL/SQL Functions, Procedure, Triggers, Packages, PL/SQL Tables.
• Performed unit testing, system integration testing and assisted during user acceptance testing (UAT) on ETL packages and reports.
• Extensively worked on performance tuning and optimization of data ware housing, business intelligence and database jobs.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, OLAP Cubes using SSAS, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Developed Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Involved in Unit testing of the Reports, Forms and PL/SQL Stored procedures.

Environment: Oracle Database 10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, UNIX Scripting, Putty.

Confidential, Eden Prairie, MN

Senior Oracle Developer

Responsibilities:

• As a Senior Oracle Developer, worked on multiple production applications independently and as part of a team using Agile Methodologies.
• Designed and Developed complex Reports to meet end user requirements and deployed using Oracle Report 10g.
• Developed complex report in both SSRS and Crystal Reports based on the requirements provided and going through multiple discussions with the Team.
• Oracle Backend Development involving creation and maintenance of PL/SQL Functions, Procedure, Triggers, Packages, PL/SQL Tables.
• Extensive Experience in Relational and Dimensional Data Modeling for creating Logical and Physical Design of the Database and ER Diagrams using Data Modeling Tool like ERWIN.
• Working with the ETL Architecture and Functional teams on technical and functional requirements.
• Involved in User Acceptance Testing to ensure accuracy and the quality of data. User acceptance testing involved ETL/Data warehouse Testing of Data Mart, Database testing of source applications.
• Written Stored Procedure to fetch and insert complex data to flat tables which is sent to downstream systems.
• Wrote Stored Procedures for effective Insertion and Updating of the Data into the Tables. Sub-Queries and Joins were extensively used in Stored Procedures.
• Created View, Tables, Packages, Procedures and Functions.
• Wrote Stored Procedures/Functions/Packages in various schemas as per business requirements and was involved with the Tuning, Performance, Optimization of Queries and Standardization of the Code.
• Developed complex SQL queries to perform the back-end testing of the Oracle database using SQL and UNIX shell commands.
• Implemented Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on queries that take huge amounts of time to run and did performance tuning on it to reduce the cost and time to execute.
• Experience in Data warehousing, Data Architecture & Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center.

Environment: Oracle Database 10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, UNIX Scripting, Putty.

Confidential, Ada, MI

Senior Oracle Developer

Responsibilities:

• Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
• Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.
• Developed and customized existing Reports as per client specific requirements using Oracle Reports Builder 10g.
• Worked on UNIX scripting for scheduling the jobs.
• Involved in various design discussions and requirement discussions with the end users.
• Involved in identifying all the Data Models for all the applications.
• Involved in creating reusable control table driven ETL Architecture.
• Created ETL Process control architecture and integrated the same architecture with reporting applications.
• Worked closely with all the application owners to know about the functionality of these applications in a very detail level to understand the data models being used by them.
• Studied various Planning applications to understand the source data for FDW.
• Created ETL Mapping specifications using functional specifications.
• Created Technical Specifications document based on functional specifications
• Extensively used Informatica for loading the data from various tables for different departments.
• Designed and developed complex Reports to meet end user requirements and deployed using Oracle Report 10g .
• Responsible for Dimensional DataModeling and Modeling Diagrams using ERWIN.
• Involved in fixing bugs within Packages and Stored Procedures.
• Involved in Tuning Database & Application performance using Explain Plan.
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
• Written Custom SQL scripts, Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions.
• Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.
• Evaluating System performance and sync them as per business need of the clients. Creating and Modifying Stored Procedures/Triggers for validating the integrity.

Environment: Oracle Database 10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, UNIX Scripting, Putty.

Confidential, Pleasanton, CA

Senior Oracle Developer

Responsibilities:

• Involved in analysis, Design, Development phases of the project.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Involved in walkthrough sessions with business users during Analysis and Designing phase.
• Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Writing SQL Reports and scheduling these reports from UNIX scripts.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Worked on performance issues and used EXPLAIN PLAN for tuning the queries.
• Developed Master Detail Reports in Reports to meet the requirements of end users within the system.
• Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.
• Involved in the migration project to load data from mainframe systems into oracle database.
• Under this project I worked in maintenance,Support and Development of various BPM based applications.
• Involved in Troubleshooting performance issues and bugs within packages and stored procedures using dbms output and explain plan.
• Involved in the design, development and testing of the PL/SQL Stored Procedures, Packages for the ETL.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX shell scripts.
• Developed Data entry Forms, complex and template forms in Forms.Creation of Pop-up Menus and maintaining Master Detail relation-ship.
• Responsible for Unit Testing and Integration testingof PL / SQL Packages, Procedures, Functions and Triggers.
• Designed & Developed logical & physical data model using Data Warehouse methodologies, including Star schema - Star-joined schema, conformed dimensions data architecture, early/late binding techniques, datamodeling, designing & developing ETL applications using Informatica.
• Worked in resolving on-going maintenance issues and bug fixes, monitoring Informatica Sessions as well as performance tuning of mappings and sessions.
• Development of client-side program units and sharing them among multiple applications for processing business logic in the database.

Environment: Oracle Database 10g/11g, Windows 7, Toad, XML, SQL, PLSQL, UNIX Scripting, Putty.

Confidential, Worcester, MA

Oracle Developer

Responsibilities:

• Involved in analysis, design and coding of Oracle processes in PL/SQL to built packages.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers, Cursors using Oracle 10g.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
• Developed Ref Cursors to accommodate the business rules.
• Created Tables, Views, Materialized views, and constraints.
• Created a Stored Procedure to do a partition swap from staging to FDW which is called in ETL to load the Fact data for various tables which are passed as parameters to the stored procedure.
• Create Oracle Stored Procedures to implement the ETL Process control logic.
• Created Oracle Stored Procedures for Segment Dimension which holds all the dimension keys.
• Designing and Developing Workflows according to Business needs using IBM BPM tool.
• Designed Oracle Views that generate these extracts for upstream applications and created ETLs to read these views and drop them in a file.
• Created a model for Audit mechanism and included the Audit counts in each of the ETLs to verify the source and target counts and sums.
• Identified various extracts needed for upstream reporting applications and planning applications and designed structures for the same.
• Designed and developed the Forms and Reports for the user Interface.
• Customized Form filed like enabling, disabling form filed and incorporating oracle alerts using Form Builder 10g.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the Error Messages in the application.
• Developed Grouping report and matrix reports using Oracle Reports 10g Report Builder.
• Involved in testing backend SQL queries for query optimization.
• Developed UNIX scripts using VI editor to create FTP Jobs and to schedule the jobs.
• Creating the concurrent programs and registering the functions to the oracle applications (EBS).

Environment: Oracle Database 10g, Oracle EBS, Windows XP, UNIX, SQL Loader, SQL Developer, PL/SQL Developer Oracle Forms 10g, Oracle Reports 10g, Discoverer10g, XML, SQL, PLSQL, Putty.

Confidential

Oracle Developer

Responsibilities:

• Used SQL*Loader to download the data into warehouse database from the flat files and other data files across different platforms.
• Developed SQL and Shell scripts to create temporary tables and developed SQL*Loader scripts to load data into the temporary staging tables.
• Designed and developed Forms using Oracle Forms 10g to allow the end users to manage the customer relation effectively and efficiently.
• Worked on creating Materialized Views to maintain copy of the remote data at local node.
• Mostly involved in code reviewing and Performance Tuning with optimization techniques in PL/SQL.
• Solving the complicated run time errors while running the process along with DBA team members.
• Involved in the development of database objects in both OLTP and OLAP databases.
• Addressing day-to-day issues with business users using tools like TOAD.
• Having good knowledge on Claims, Benefits, Provider and Contract affiliations.
• Created documentation for migration and performed extensive testing during the various phases of product implementation.
• Designed and developed the logic for handling Slowly Changing Dimension tables load by flagging the record using update strategy for populating the desired.
• Developed reusable mappletsand transformations for reusable business calculations.
• Used Exception Handling Logic in all mappings to handle the null values or rejected rows.
• Tuned the ETL components to gain the performance and to avoid business continuity.
• Worked with Persistent Caches for Conformed Dimensions for the better performance and faster data load to the Data Warehouse.
• Involved in performance tuning and optimization of Informatica Mappings and Sessions using partitions and data/index cache to manage very large volume of data.
• Performed query overrides in Lookup Transformation as and when required to improve the performance of the Mappings.
• Used Clear case for version controlling and Clear Quest for ticketing system.

Environment: Oracle Database 9i/10g, Oracle APEX 3.2, Windows XP, UNIX, SQL Loader, TOAD, Oracle Forms 10g, Oracle Reports 10g, XML, SQL, PLSQL, Informatica Power Center 8.1

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created heavy stored procedures for financial transaction by using Procedural parameters &worked with Packages, blocks &Exception Handling.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Developed PL/SQL Packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Extracted data from the XML files transmitted to the bank and loaded them efficiently into oracle temp tables for day to day customer financial transaction reconciliation.
• Designed and implemented client-server application using Oracle Forms 10g.
• Involved in the generation of User Interface using Oracle Forms by extensively creating Forms as per the client requirements.
• Developed various new Reports from Scratch utilizing Oracle Reports 10g for day to day validations.
• Developed ETL mappings, transformations using Informatica Power Center 8.1.
• Created various adhoc reports as of when required for the production analysis and bug fixing.
• Converted reports to browser supportable XML format.
• Extensively utilized TOAD for Performance Tuning by generating explain Plans.

Environment: Oracle Database 10g, UNIX, Windows XP, SQL * Loader, TOAD, SQL Navigator, Oracle Reports 10g, Oracle Forms 10g, Discoverer 10g, PL/SQL, UNIX, Perl, XML.