SUMMARY

• Around 5 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, and Tables, Indexes, Constraints, Materialized Views and others in Oracle 11g/10g /9i database.
• Extensively worked with OracleReportsBuilder 11g, also created new Reports as per User Requirement.
• 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.
• Working Experience in Data extraction, Transmission and Loading (ETL).
• Extensively used ETL methodologies for supporting dataExtraction, 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.
• Created OBIEE Repository and implemented the business logic by customization, Dimensional Hierarchies, Aggregate Navigation and Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks, cache management and implemented business logic for facts and dimensions.
• 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.
• Implemented JavaScript for Form Validation, Document Behaviors, look and feel and maintaining consistency.
• Developed the user interface for registration using HTML, CSS, jQuery and AJAX.
• Used both Hypertext Procedures(HTP) and Hypertext Functions(HTF) for developing some front end pages.
• 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, 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,HTF,HTP.

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

PROFESSIONAL EXPERIENCE

Confidential, Dayton, Ohio

Senior Oracle PL/SQL 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 thereportsfor future reference.
• Bug fixing and enhancing existingreports. Making changes to thereportsthat are created in earlier versions to Crystalreports.
• Designed and Developed complex Reports to meet end user requirements and deployed using Oracle Report 10g.
• Designed and developed stored procedures, queries and views necessary to supportSSRSreports.
• Interacted with Business Analysts to gather the user requirements and participated indatamodeling JAD sessions.
• Sever optimization and performance tuning of MySQL database running on both windows and Linux environments.
• Hands on experience with client side technologies that include Java Script, HTML, CSS and jQuery.
• Created DDL scripts for implementingDataModeling changes. CreatedERWINcrystal reports in HTML, RTF format depending upon the requirement, PublishedDatamodel in model mart, created naming convention files, coordinated with DBAs' to apply thedatamodel changes.
• Designs applications and services according to BH technical design standards in an Oracle EBS environment including the creation and communication of the technical design documentation.
• Developed complex report in both SSRS and Crystal Reports based on the requirements provided and going through multiple discussions with the Team.
• Designed test plan, scheduled and executed various phases of testing including system, Integration and UAT based on Migration strategies.
• Designed the look and feel of the APEX forms (User Interface) along with the users.
• Oracle Backend Development involving creation and maintenance of PL/SQL Functions, Procedure, Triggers, Packages, PL/SQL Tables.
• Perform unit testing, system integration testing and assist with user acceptance testing onETL packages and reports.
• Worked with SVN/CVS, and GIT Software Configuration tools (Source Control) & Managed all the environment and application level config using GIT.
• Extensively used UTL FILE, DBMS XMLGen for creating flat files and XML files used by the downstream systems.
• Used HTP and HTF for the purpose of creating the html tags in developing the frontend view of a webpage.
• Expert in performance tuning and optimization ofdataware housing, business intelligence and database jobs.
• Participate in designing the overall logical & physicaldatawarehouse/data-martdatamodel to support business requirements.
• Worked as a developer in creating complexStoredProcedures, SSIS packages, OLAP Cubes using SSAS, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• DevelopedStoredProcedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Involved in Unit testing of the Reports, Forms andPL/SQLStored procedure

Environment: Oracle Database 11g/12c, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, UNIX Scripting, Putty.

Confidential, Eden Prairie, MN

Senior Oracle PL/SQL 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.
• Coordinating different tasks with different teams for creating usage models for different projects & Managing source control systems using GIT and SVN.
• Developing various UI components in JQuery and Business Logic implementation using various technologies.
• 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.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• 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.
• Responsible for building APEX Authorization Schema to provide the security at user level.
• Experience in database administration, development, design, maintenance and production support of relational databases, business applications, new server setup, MySQL server installation, upgrade, migration.
• 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 Joinswere 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.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• 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.
• Responsible for performing validations against the database column data in Oracle APEX Interactive reports and tabular forms using JavaScript.
• Worked extensively on OBIEE and Siebel Analytics Metadata (RPD) Development, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
• 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.
• In depth experience on front-end web design and development using HTML5, CSS, Bootstrap, JavaScript, jQuery, JSON, AJAX, and AngularJS.
• Designing, creating and maintaining GIT repositories to client specifications and involved for setting up of Subversion-SVN server, server maintenance, Client machines setup.
• Understanding of Order to Cash and Procure to Pay business processes.
• 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.
• Order to Cash and/or Purchase to Pay transaction flows.
• 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
• Managed the Web servers and Data base servers of Production system, Backup DR and Development system.
• Extensively used Informaticafor 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.
• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• 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.
• Developed and implemented authorization and authentication rules for Application Administrators in order to manage the Oracle APEX applications, users, and their log activity details.
• Working on client end using Angular JS, jQuery, JavaScript, AJAX, bootstrap and jQuery plugins.
• 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 testingofPL/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, UNIX, Toad, XML, SQL, PLSQL, UNIX Scripting, Putty.

Confidential, Worcester, MA

Oracle Developer

Responsibilities:

• Involved in analysis, design and coding of Oracle processes in PL/SQLto built packages.
• Design and Development of data validation, load processes, test cases usingPL/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.
• CreatedTables, Views, Materialized views, and constraints.
• Used Oracle APEX utilities to Export and Import Large Volumes of Data in the format of CSV files, Excel Sheets into the tables.
• 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.
• Working on client side using jQuery, JavaScript, AJAX.
• Identified various extracts needed for upstream reporting applications and planning applications and designed structures for the same.
• Created Unit Test plans for various ETLs developed.
• Performed Unit Testing and Integration testing for the ETL’s.
• 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.
• DevelopedUNIX scriptsusingVI editorto 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.