SUMMARY

• An Assertive professional with over 8 plus years of IT experience handling all phases of SDLC like analysis, design, development, implementation and deployment of large software products in both Client/Server and Web Server Environment.
• Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL.
• Expertise in Database Design, Development, and Enhancement and Maintaining usingOracle 11g/10g/9i/8i, Web deployment, PL/SQL Forms 10g/9i, Oracle SQL Loader in Windows and UNIX environments. Strong knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Proficient in PLSQL programming, designed and developed Stored procedures, Functions, Triggers, and Packages to provide database access and manipulation functionality
• Developed and Automated batch load process using SQL*Loader, Shell scripts and Crontab
• Used oracle features like Collections, Ref cursors, Analytical functions, Global temp tables, External tables and Materialized views
• Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming.
• Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer & full suite of Oracle Tools including development and customization of Oracle Developer (Reports & Forms) and Oracle discoverer.
• Extensive experience in identifying performance issues, debugging and performance tuning using SQL Trace, Explain plan, Indexing, Hints, Partitioning, TKPROF, Profiling and Oracle Code Coverage Utilities.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12c, MySQL 5, MS SQL SERVER 2005/2008, DB2/UDB, SAP Tables and MS Access

Other Technologies: HP Project and Portfolio Management (PPM), HP ALM/QC, Oracle E - Business Suite 12, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM)

Programming Languages: SQL, PL/SQL, Unix shell scripts, SAS, C/C++/C#, Perl, XML, HTML, VB.NET

ETL Tools: IBM Infosphere DataStage, Informatica

Data Warehousing: Star & Snow-Flake schema Modeling, Erwin, Sybase Power Developer, SSIS, SSRS, OWB, ODI

Dev. Tools: Windows/Linux/Mac OS Environment, Eclipse, Git, Xcode, Subversion (SVN), CVS, ClearCase.

Tools: TOAD, SQL*PLUS, SQL Developer, SQL*Loader, Crystal Reports, Forms 6i/9i/10g, Reports 6i/9i/10g, Work Flow Builder and XML Publisher.

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Sr. Oracle PL/SQL Developer

Responsibilities:

• Created various database objects like tables, views, materialized views, procedures, functions and packages using oracle tools like Toad, SQL Developer and SQL* plus.
• Extensively used bulk collection in PL/SQL objects, partitioned the fact tables and materialized views for improving the performance.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Transferred SQL and Korn shell programs into ODI and created data extracts.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Involved in requirement analysis, preparing functional specifications, system design, development and database administration.
• Involved in Importing and exporting the Tables, Users, and Schemas.
• Designed DW tables, scripts, ETL maps and ODI Extracts, Configured ODI modules and ETL tools and supported accessible applications, and Documented and maintained ETL specifications and processes.
• Experience with custom development of data warehouse, operational data store, and OLTP systems.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Database Triggers.
• Created Shell Scripts for invoking SQL scripts.
• Customized few forms for the Business manages to validate the data.
• Involved in creating Pseudo code documents for writing stored procedures.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.

Environment: Oracle 10g / 11g, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, TOAD, UNIX, Shell scripting.

Confidential, Dallas, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testingand Implementation.
• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Fix open ticket as created by users that includes code modification and issue data analysis.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Created Shell scripts to access data and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
• Optimized the performance using PL/SQL table types and record types.
• Did SQL and PL/SQL programming for ODI and oracle.
• Developed AR Credit memo and AR Customers forms.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Analysis and generation of mainframe commands to add users to missing mainframe groups as well as analysis of RACF permission sets and reporting of access that users may lose based on the cleanup process.
• Played a major role in designing the dimensional modeling of star schema for the enterprise data ware house of ODS.
• Participate in upgrading Oracle database(s) and Oracle Warehouse Builder to Version 11.2.0.4
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed DAO layers in applications to access the db objects from Java.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process.
• Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
• Wrote SQL queries to developed test data for use during test execution.
• Perform Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.
• Worked on MS Access to Oracle 10g database conversion including tables, queries, standard procedures, forms and triggers.
• DataStage jobs were scheduled, monitored, performance of individual stages was analyzed and multiple instances of a job were run using DataStage Director.
• Created complicated reports using reporting tool Cognos.
• Used DS Erwin MetaBroker to import Erwin 4.x Metadata into DataStage Repository.
• Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements.
• Created & Deployed SSIS (SQL Server Integration Services) Projects, Schemas and Configured Report Server to generate reports through SSRS SQL Server.
• Involved in Unit testing and Integration testing of forms and reports.
• Coding of documents in XML for data transformation.
• Developed test procedures to Unit test the application.
• Worked on Oracle OLAP tool to produce analytic measures, including time-series calculations, forecasts.
• Implemented table and index partitioning of various tables with huge data.
• Wrote a Perl-based server to generate reports of trades, and tickets in PostScript and HTML formats.
• Developed scripts in Korn shell and Perl for network management
• Provided Post production Technical Support to the users.

Environment: Oracle 10g / 11g, SQL, PL/SQL, SQL*PLUS, SQL*Loader,Oracle Forms 9i/10g, Reports 9i/10g,CVS, TOAD, UNIX, Shell scripting, HP PPM, Oracle Warehouse Builder 11.2.0.2,Subversion (SVN), CVS, Perl.

Confidential, Madison, WI

PL/SQL Developer

Responsibilities:

• Actively coordinated with offshore teams through requirements gathering, design, development and testing phases.
• Used Erwin relational tool for logical and physical model for target ODS model.
• Developed and modified complex stored Procedures, Functions, Triggers and Packages.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Developed Complex Stored Procedure using the Oracle 10g PL/SQL language for reporting
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc. Performance tuned the ODI interfaces.
• Extensively used PL/SQL advanced features like forward declaration, Procedure Overloading in the PL/SQL Packages.
• Short term assignment to assist Oracle in a data clean up and conversion / migration task using Oracle Warehouse Builder 10G Rel. 2, to migrate mainframe legacy to Oracle eBusiness Suite. Effectively utilized new features of OWB to perform Data Profiling, resulting in significant data cleansing.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Purchasing and Payables and Fixed Assets Module.
• Used structural query language (SQL) for database operation and manipulation.
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Created the flow charts and data mapping tables indicating the input files, output datasets and capacity planning for the data flow to the downstream applications.
• Developed forms to correct errors in interface process which are used to correct errors in staging and interface tables.
• Modified custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
• Played a major role in designing the dimensional modeling of star schema for the enterprise data ware house of ODS.
• Customized existing forms to define system Profile Options, Descriptive and Key Flex fields.
• Developed RDBMS including PL/SQL database backend programming with stored procedures, Functions and packages
• Exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Performed PL/SQL code reviews for maintaining standards and to identify inefficient SQL statements.
• Customized Reports and Forms to meet user requirements mainly in financial modules (AP, GL, and AR).
• Implemented features including materialized views for better performance of summary tables, autonomous transactions, coding dynamic SQL statements.

Environment: Oracle 10g, PL/SQL, UNIX, TOAD, Oracle Forms 9i/10g, Reports 9i/10g, ERwin, IBM Web Sphere Data Stage, MKS Integrity, CVS, SUN Solaris, MS SQL Server

Confidential, Cedar Rapids, IA

PL/SQL Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testingand Implementation.
• Analysis and documentation of functional requirements for new development and enhancements
• Actively coordinated with offshore teams through requirements gathering, design, development and testing phases.
• Development/modification of custom reports in purchasing and payables.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Create and Develop data model using modeling Erwin, ERStudio tools for Credit Loss Mitigation division
• Built analysis model using SQL, R and VBA. Designed database structure, backend code connection and statistic model in R.
• Analyzed the databases for data issues. Some of these issues included: linear referencing of pipeline data, looking for gaps, anomalies, etc.
• Converted custom forms using Forms in Installed base for global update of instance.
• Worked with business analysts for formulating the ER diagrams and data flow diagrams.
• Interaction with client / business teams for clarifications / updates.
• Developing Sql Loader to insert bulk data into staging tables from flat files.
• Participated in developing a Data Warehouse using Oracle Warehouse Builder.
• Created universes and business objects using SAP Business Objects. Wrote ETL using Oracle Warehouse Builder.
• Involved in Extraction, Transformation and Loading of data and store the data into staging tables for further various analyses.
• Was responsible for testing the integration of Intrepid Asset Management solution with SAP Linear Asset
• Customized the reports for Financial Module (GL, AP, and AR) using Report Builder.
• Involved in database development by creating PL/SQL functions, procedures and packages
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Developed Triggers for inserting/updating of tables
• Developed optimized PL/SQL API using Collections, Bulk Collect, Result Cache, Materialized view, Pipelined, Java Stored Procedure, External Procedure, various DBMS and UTL package.
• Used inner joins, outer join, union, union all and sub queries for filtering the Data
• Created views to analyze complex queries
• Tuning SQL and PL/SQL code using Statistic Collection, Oracle Hint, Table Partition, Parallel, TKPROF, Explain Plan and Automatic SQL Tuning techniques.
• Involved in generating Web base Reports for Clients

Environment: SQL Server 2005/2008, Oracle 10g, Oracle Forms 9i/10g, Reports 9i/10g, IBM Web Sphere Data stage and Quality Stage, Cognos 8 BI, Sybase TOAD, Crystal Reports, Erwin, Forms and Reports, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.
• Used SQL* Loader and PL/SQL stored procedure for data conversion and interfaces processes.
• Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.
• Assisted in day-to-day duties of DBA work like taking backup and recovery of database environment.
• Performed several Automations written in Perl-DBI/DBD and UNIX Shell scripting in an Agile environment.
• Involved in data loading using PL/SQL and SQL*Loader and cron jobs calling UNIX scripts to download and manipulate files
• Analyzed C/Java sources to gather business rules for the application and converted them intoPL/SQLcodes
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Form Builder 6i.
• Used Perl to implement reports and new features in the Web GUI.
• Involved in writing complex/ad-hoc queries to generate reports as per client request as a part of production support.
• Generated Matrix Reports for business operations, status and Asset Management reports using Oracle Reports 6i
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Involved in fine tuning and optimization of different SQL queries to insure faster response time.
• Assisted in designing End User Layouts (EUL’s) for Oracle Discoverer Reports based on the user/client requirements.
• Involved in Unit Testing and Performance Testing for reports.
• Used SQL Trace, Analyze, Explain Plan Utilities, and Hints to develop better SQL Queries.
• Worked as Production Support Developer to solve real time issues.
• Resolved Priority Production Support Issues and Defect Fixes.

Environment: Oracle 9i/10g,Forms 6i/10g, Perl, UNIX, shell script, SQL*LOADER, TOAD, SQL*Loader, Toad.