SUMMARY

• Around 8 years of programming experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Experience indeploying formsandreportson the web.
• Experience in developing bothweb layout and paper lay out reportsin various styles based on the user requirements
• Design, development and testing of Reports using Report 10g/11g.
• Experience in Data migration using Import Wizard,Apex Data Loader.
• Used Application Express as productive tool to build applications that report on database data.
• Good exposure to App Exchange applications and able to find appropriate applications, install and customize.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADand SQL*LOADER.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Strong experience inData warehouse concepts, ETL.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developedmaterialized viewsfor data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling forOLTPand dimension modeling forOLAP.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Loaded Data into Oracle Tables usingSQL Loader.
• Partitioned large Tables usingrange partition technique.
• Experience with Oracle Supplied Packages such asDBMS SQL, DBMS JOBandUTL FILE.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Worked extensively onRef Cursor, External TablesandCollections.
• Expertise inDynamic SQL, CollectionsandException handling.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience with Performance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
• CreatedShell Scriptsfor invoking SQL scripts and scheduled them using crone tab.
• Extensively worked on data extraction, transformation and loading data from various sources like Oracle, MS SQL Server, DB2, flat and mainframe files.
• Responsible for all activities related to the design, development, implementation and support of ETL process for large scale data warehouses usingInformaticapower centre.
• Database modeling, designing & developing SQL Server 2012, 2008 R2, 2005 database tables, stored procedures, functions, views and triggers,datawarehousing, creation ofDataMart, extensive use of SSIS DTS, and ETL,data migration, Publish and Subscribe strategies, "Brokerage" ofdatafrom heterogeneousdata sources and downstream delivery.
• Experience indeploying forms and reports on the web.
• Worked on Oracle Forms6i/10g/11g,Reports6i/10g/11g.
• Experience in developing bothweb layout and paper lay out reportsin various styles based on the user requirements.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, Java, ADO.NET, UNIX Shell Script

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2005, MS Access

Modeling Tools: UML, ERWIN

Development Tools: TOAD, SQL Developer, Microsoft Office Suite (Visio, Project)

Reporting Tools: Reports 6i/9i/10g, BI Reports, MARS Application

UI Tools: Forms Builder 6i/10g/11g, Application Developer Framework, APEX 4.0

Other Application: Symphony RPM Web application, Analytic Workbench

Operating Systems: Windows, Linux, AIX, Sun Solaris

Web Technologies: HTML, HTML5, CSS, CSS3, JavaScript’s, Ajax and XML

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

Sr. Oracle Developer

Responsibilities:

• Worked on Eclipse IDE with Force.com Plug-in environment for writing Business logic inApexProgramming Language.
• Worked onOracle Forms6i/10g/11g,Reports6i/10g/11g.
• Created and modified complex functions, stored procedures, packages and Triggers by using Oracle PL/SQLbased on the business rules.
• Extensively worked on Schema Migration, Database Program Migration, and Data Migration from Sybase to Oracle by using OracleSQL Developer.
• Worked onSQLTuning by using various tools like EXPLAINPLAN, DBMS PROFILER, and Hints etc.
• Worked on DynamicSQL by using Execute Immediate and DBMS SQLalong with Bulk Collect.
• Extensively used PL/advanced features like forward declaration, Procedure Overloading in the PL/SQLPackages.
• Used UTL FILE PACKAGES for writing DBMS OUTPUT into the files.
• Extensively used Oracle 11g features like RESULT CACHE, Compound Triggers etc.
• Worked onSQL*Loader to load data from flat files obtained from various facilities every day.
• Worked on Table partitioning and Index creation to improve the performance of the query.
• Worked with DBAs regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
• Developed PL/SQLtriggers and master tables for automatic creation of primary keys.
• Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology.
• Created mappings and workflows for data migration using Informatica Power Center.
• Report the project status and generate milestone reports.
• Developed ETL jobs using ODI tool for data migration operations.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL DeveloperandSQL* plus.
• Communicate withdevelopers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project's success.
• Extensively used the advanced features of PL/SQLlike Records, Tables, Object types and DynamicSQL.
• Developed Forms Screensused by Oracle Developer Suite forforms procedures, functions and packagesgenerate to end product of forms.
• Analyzed data, designed and developedOracle forms 10g queries, layout, report triggers, parameter form, data modelsetc.
• Programmed inUNIXshell scripts to provide a user interface toOracle formsandreports.
• Created Cron jobs inUNIXfor scheduling file preprocessing.
• Involved in the preparation of high level and technical design document, source to target mapping document by analyzing the business requirements and functional specifications.
• Usedinformatica Power Centre 9.5.1 for extraction, transformation and load (ETL) of data in the data warehouse.
• Developed complex mapping for calculation of member algorithm and base income algorithm by using Transformations like Aggregator, Normalize, Union, Joiner, Expression and Lookup, Update strategy, Stored Procedure, sequence generator and Router.
• Extracted data from flat files, oracle database, SQL server and staged into a landing database and applied business logic to load them in the ADUM data mart.
• Initialized utilization ofData WarehouseETL software during conversion of Legacy data in IMS to Oracle.
• Worked on FormsTriggers, Alerts, Data Blocks, LOVs, Parameters, and Program unitsby using PL/SQL procedures and functions of OOPS methodology
• Tested the Forms,debugged and fixed the Formsafter the testing
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Primary role to providedata modeling duties for the development and maintenance of tables (Fact, Dimension, Reference), views, stored procedures in a dimensional EnterpriseData Warehouse (EDW) and Enterprise Reporting held on an Oracle 11g based environment.
• Provide solutions for specific business requirements and modifications (e.g. Custom Fields addition to existing SSRS reports), and provide solutions to overcome existing issues (incorrect use of CLOBdataas a parameter in reports and associated stored procedures).
• Provide builds of EDW DDL changes to be incorporated into the overall deployment process per sprint (Agile) across multiple environments (testing N1/N and Production).
• Participate in requirements review, application design review and test plan reviews.

Environment: Oracle 11g/10g, WINDOWS 7,SQL, PL/SQL,SQL* Plus, TOAD,SQL*Loader, Shell Scripts,SQLPlus, Informatica 8.5,SQL Developer, UNIX, Windows XP.

Confidential, Birmingham, AL

Sr. PL/SQL/Reports developer

Responsibilities:

• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing SQLtuning of queries.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus, PL/SQL and TOAD.
• Generated XML using the Procedures, Functions and Packages.
• Running explain plan for tuning theSQLquires.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Designed and developed Oracle Forms & Reports using Forms10g/6i/4.5 and Reports10g/ 6i/2.5. Including Forms based on stored procedures.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client usingSQL*Loader. Involved in validating the data while data migration by creating PL/SQLPackages, Procedures, Functions, Triggers.
• Worked on performance tuning and used Explain Plan, TKPROF andSQLtrace for tuning the queries.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Wrote many simple and complex ad-hoc reports usingSQLPlus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Environment: Oracle 11g/10g, PL/SQL, Oracle Forms 10g, Reports10g, SQL Navigator, UNIX, Windows XP, WINCVS, SSH, SQL Developer, PLSQL Developer, TOAD.

Confidential, McLean, VA

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.
• 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.
• 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.
• Documented all the ETL and Oracle Procedures developed.
• 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 9i.
• 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 9i 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, VSS, WinSCP, Putty.

Confidential

Software Developer

Responsibilities:

• Change Request Development and troubleshooting user request.
• Oracle Back-end SQL, PL/SQL Development i.e. Complex SQL Queries containing hundreds of LOC, Views, Packages, Stored Procedures, Functions & Triggers.
• Inter-relation of different system environments.
• User Creation for different Environments.
• Implementation and user training.
• Responsible for Client Interaction for requirement gathering and business module verification,
• Also responsible Software Requirement Specification Verification, Software Design Documents and Application Development.
• Designed database tables using various Normalization techniques and database rules.
• Developed reports as per the requirements collected from the users using Discoverer and Oracle Reports 10g.
• Good Experience working on TOAD, PL/SQL Development for database access.
• Generate and maintain Keys, Constraints and Relationships between the tables for OLTP & OLAP instances.
• Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.

Environment: Oracle Database 10g, SQL, PLSQL, UNIX, SQL Developer, Java, Struts, JSP, Web Sphere 6.0, Eclipse 3.2, XML, Log4j, Jasper Reports

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Developing Stored Procedures, Functions and Triggers.
• Development was done extensively on collections (Associative Arrays, Nested Tables)
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed SQL tuning using Explain Plan, Hints and indexes.
• Partitioned tables and indexes for better performance of application.
• Involved in importing the production data to lower environments for testing purpose.
• Involved in handling the changes in compiling scripts according to the database changes.

Environment: Oracle Database 9i/10g, SQL, PL/SQL, Report Builder 6i, Forms Builder 6i, TOAD, UNIX, Perl Scripting.

Confidential

PL/SQL Developer

Responsibilities:

• Created new tables, views, queries for enhancement of the processes in the application.
• Developed advanced PL/SQLpackages, procedures, triggers, functions, Indexes and Collections. Generated PL/SQLscripts for data manipulation and validation.
• Developed UNIXShellscripts to automate various periodically repetitive database processes.
• PerformedSQLand PL/SQLquery tuning and optimization using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Registered various concurrent programs, request groups for reports and concurrent requests.
• Combined two concurrent programs as a request set.
• Developed aSQL*Loader program that would populate the data from a flat file into a temporary table and registered that as a concurrent program.
• Created Custom Menus and Responsibilities according to the requirement.
• Created Request groups and attached it to respective responsibilities using System Administrator.
• Assigned Profile Options to the new custom responsibilities.
• Used Hints, Indexes and other tuning techniques to increase the performance.
• Provided production support for the created responsibilities.
• Provided daily support for Financials users and fixed the production support issues.
• Developed various automated tools, which reduced time on processes by 92%; processes included fixed income data.
• Monitored and supported the test and pre-production environments, and Level-2 technical on-call support of production and disaster recovery environments.
• Involved in the continuous enhancements and fixing of production problems.
• Ensured 100% accuracy in solving real time issues.
• Acted as the first point of contact regarding software systems and systems' functionality to Data Analysts and associated business groups.
• Liaised and collaborated with teams across multiple locations including St. Paul, New York and Beijing.

Environment: Oracle 9i, PL/SQL, UNIX, HTML, Microsoft Project, SQL*Loader, Toad.

Confidential

Oracle Developer

Responsibilities:

• Analyzed the requirements and designed the program flow for CIMS.
• Participated in the full life cycle of this project including information gathering, analysis, design, development, testing and support of this module.
• Complete study of the system and prepared Logical and Physical database design.
• Implemented triggers to enhance functionality supplement validation and control navigation.
• Worked extensively as PL/SQLprogrammer, Developed PL/SQLProcedures that handle key business logic.
• Created front-end screens for opening new registrations.
• Designed and Created database usingSQL and PL/SQL, wrote backend stored procedures, functions and triggers which allow users to analyze daily, weekly and monthly connection requests, issued connections versus projected issues and keeping track of customer details monthly.
• Created database objects like Tables, Indexes, Sequences, Constraints, and Views.
• Wrote SQL loader scripts to load the data from flat files.
• Created PL/SQL program units to include DML, DDL statements using DynamicSQL.

Environment: Oracle 9i, PL/SQL, Forms 6i, Reports 6i and Windows, UNIX, HTML, Microsoft Project, SQL*Loader, Toad.