SUMMARY:

• Oracle Certified Professional (OCP) wif 10 years of IT experience in System Analysis, Design, Development, Maintenance and Support usingOracle Database 8i/9i/10g/11g,SQL, PL/SQL, Query Optimization, Performance Tuning, and Trouble Shooting.
• Expert level experience in advance PL/SQL that includes developing and using Cursors, Ref - cursors, Procedures, Functions, Packages, Oracle Supplied Packages, Objects, Collections, Partitioned Tables, Triggers, View, Materialized view, Indexing and Performance Tuning.
• Expertise in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system or in Platform Independent Format.
• Extensive experience in developing Complex SQL Queries, Dynamic SQL, T-SQL and Analytical functions etc.
• Extensive experience in improving performance of Query using Indexes, Explain Plan, Hints, current Statistics, Collections, Bulk Collects.
• Extensive experience of using Oracle 12c features like sequence generator during table creation, Data Guard, Transaction Guard, better explain plan, Top N queries etc.
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Analyzing Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Worked on Database Links to import/export data among various databases
• Proficient in using UNIX and Shell Scripting.
• Experience of using Cronjobs, Scheduled Task, Task Scheduler, Dollar Universe.
• Extensive experience in developing Oracle Forms, Oracle reports, XML reports.
• Hands on experience in creating reports inSAP Business Objects 4.0usingWeb IntelligenceandCrystal Reports.
• Developed complex mappings using transformation object like Source qualifier, Expressions, Joiners, Filters, Sequence Generators, Router, Aggregator, Lookup, Expression transformation.
• Good experience logical Data Modeling, Physical Data Modeling, Dimensional Modeling, Star and Snowflake Schemas.
• Extensive experience in integration of data from heterogeneous sources (ERP, RDBMS, Flat Files and Web Applications).
• Extensive ETL experience using Informatica 9.1/8.6. (Power Center) (Designer, Workflow Manager, Workflow Monitor and Workflow Manager)
• Hands on experience wif tools like Toad, Sql*Plus, Export and Import Utilitiesalong wifOracle Enterprise Manager (OEM).
• Also worked onMS SQL Server,Access Databasesand developedT-SQL,SQL,Stored Procedures, Cursors, Triggers, Views, Indexes and Constraints, Query Optimizer
• Expertise in writingCrystal ReportsandSQL Server Reporting Services.
• ExperienceperformingUnitandIntegration Testing, System Integration Testing(SIT) andUser Acceptance Testing(UAT).
• Proven ability to plan, coordinate and implement Full Life Cycle software development and maintenance projects in WATERFLOW and AGILE methods.
• Experience in Database design using Normalization and ER Diagrams using ERwin.
• Experience of Visual Source Safe (VSS), Team Foundation Server (TFS), Regulus and ClearCase for version control of code and document.
• Worked through all phases ofSystem Development Life Cycle(SDLC): requirements gathering, analysis, design, development, testing, UAT, production and post-production support
• Excellent oral and written communication skills. Experience in coordinating wif different geographical teams (China, UK, France, Spain and Italy) and onsite-offshore model.
• Major strengths are familiarity wif multiple software systems, tools and the ability to learn quickly new technologies and adapt to new environments

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12c,Netezza, DB2, SQL Server 2000 and 2005, Microsoft Access, Lotus Notes Database

Languages: Unix Shell Scripting, PL/SQL, Oracle SQL,T-SQL,C#,VB.Net,xml,VB 6.0,C,C++,Java

ETL Tools: Business Object Data Integrator XI, Informatica 8.6/9.0, Altova XML Spy, Altova Map Force, Altova Style Vision tools

OLAP Tools: SAP Business Objects 4.0

Query Tools: SQL Loader, PL/SQL Developer, SQL* Plus, Toad, Toad for Data Analyst

Reporting Tools: Crystal Reports, Oracle Reports 11.1.2, Oracle Reports 10.1.2, Oracle Reports 9i, Toad, SQL Server Reporting Services, SAP Web Intelligence

Other Tools: Visual Source Safe Systech Sentri, Systech Advisor, Advitium, Maximo, Putty, FileZilla, MS Visio, Erwin, MS Project Plan, Remedy, Lotus Notes, Citrix, Operating Systems Windows XP/7, UNIX, Linux, Windows server 2000/2003/2008

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr. PL/SQL Developer

Responsibilities:

• Implement Business rules to extract data from manufacturing databases and SAP system that are to be incorporated into the system.
• Import data from different SAP system, PMX system (Oracle), and client’s in house applications systems.
• Responsible for creating and developing highly complex applications using Oracle as back-end wif expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Analyze System Requirements to create a Technical Design wif the assistance of other Sr. Developers/Architects/Tech. Leads.
• Responsible for creating database development standards wifin PL/SQL.
• Act as a technical resource, wif a high level of technical and analytical expertise in programming languages, data communications and a strong understanding of the business operation/customer implement and support code migration into production.
• Constructed complex SQL queries wif sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD)
• Write complex Oracle packages, procedures, functions to migrate data from Source SAP system into Lilly SAP system.
• Analyzing Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Worked on PL/SQL Tables, Records and Collections.
• Worked wif Bulk Collects to improve the performance of multi-row queries.
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Worked on Database Links to import/export data among various databases.
• Worked on minimizing CPU overhead by Tuning SQL Statements, Tuning Subprogram Invocation and Tuning computation-intensive PL/SQL Code.
• Changed existing logic wifin the packages for optimum performance using Oracle Hints, Explain Plans and Trace Sessions.
• Tested the original and optimized codes thoroughly for failures before exporting to other environments.
• Schedule jobs using UNIX Crontab and Shell Scripts.
• Extensive use of Informatica Tools like Designer, Workflow Manger and Workflow Monitor to extract the data.
• Used transformations like Aggregators, Sorter, Dynamic lookups, Connected & unconnected lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, and Sequence Generator etc.
• A reporting data mart was created to support the Serialization capabilities by designing and developing Oracle PL/SQL packages, stored procedures, functions, and triggers.
• Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures
• Created Dashboard as per the Database structure and business requirements.
• Designing report for client Dashboard and reporting tool. Submitting data/reports to Systech Guardian and other client’s in house systems.
• Provided Ad-hoc Reports whenever the business requested and maintained a good relation wif Business Customer

Environment: Windows XP/7, Windows 2003, 2008 R2

Technologies/Database: SQL, T-SQL, PL/SQL, Oracle 11g/12c, Netezza, SQL Server 2005, BO Web Intelligence, Informatica Power Center 9.1

Tools: TOAD, SQL Plus, SQL Developer, Putty, Filezilla, Erwin, SAP AII, GPR, OER, Systech Sentri, Systech Advisor, Systech Guardian, Quality Center, Remedy, Microsoft Project Plan, VSS, TFS, Regulus

Confidential, Indianapolis, IN

Sr. PL/SQL Developer and Data Migration Consultant

Responsibilities:

• Coordinating wif the client for initial scoping of System Retirement and identification of systems that needs to be retired.
• Scheduling and hosting the kick off meeting for the retirement for different systems.
• Providing archival solution to the client to retain the archived data as per business and legislative requirements.
• Developed and Modified the PL/SQL Packages, Procedures, Functions and Database Triggers using the oracle advanced techniques Bulk Processing and Collections.
• Develop the jobs to extract, transform and load, populating and refreshing Staging Tables from flat file and then export to Transaction Files.
• Write the scripts to automate the process, parameter setting / initialization for the flat files.
• Worked on PL/SQL Tables, Records and Collections.
• Wrote PL\SQL Procedures, Functions, and Triggers for Insert, Update and Delete transactions.
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Changed existing logic wifin the packages for optimum performance using Oracle Hints, Explain Plans and Trace Sessions.
• Tested the original and optimized codes thoroughly for failures before exporting to other environments.
• Worked on Materialized view by creating an estimated cost and solved costing issues in Production release.
• Worked wif Bulk Collects to improve the performance of multi-row queries.
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Created Shell scripts for regular back up instance start and shut down.
• Worked on profiling and tracing PL/SQL program to analyze the execution of program in order to enhance performance of program.
• Used cron job to automate Oracle script execution.
• Worked on Database Links to import/export data.
• Developed reports using Oracle report Developer.
• Worked on Power Center client tools like Source Analyzer, Mapping Designer, Mapplet Designer and Transformations Developer to extract data.
• Created various transformations such as Update Strategy, Look Up, Joiner, Filter and Router Transformations
• Implemented triggers based on the business rules.
• Worked on minimizing CPU overhead by Tuning SQL Statements, Tuning Subprogram Invocation and Tuning computation-intensive PL/SQL Code.
• Creating and Maintaining of different levels of users wif different levels of securities by creating User Roles and Privileges.

Environment: OS: Windows XP, Windows 2000, Windows 2003, Linux, UNIX

Technologies/Database: SQL, T-SQL, PL/SQL, Oracle 9i, Oracle 10g, Oracle 11g, Netezza, DB2, Microsoft SQL Server 2000, 2005, Microsoft Access, Lotus Notes Database, Share point portals.

Tools: TOAD, SQL Plus, SQL Developer, Altova XML Spy, Altova Map Force, Altova Style Vision, Informatica 8.6, Putty, Team Foundation Server (TFS), ClearCase, VSS, Quality Center, Remedy, Microsoft Project Plan (MPP)

Confidential, Indianapolis, IN

Sr. PL/SQL Developer

Responsibilities:

• Planning for all the systems which has been identified for the retirement in the current wave. Preparing the Retirement Plan wif the help of gathered information.
• Defining data archival strategy for the system.
• Data archival and conversion using Altova and Informatica tools.
• Designed/developed and modifiedtables, views, materialized view, stored procedures, packagesandfunctions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• UsedSQL loaderto load the data from the files provided by the interfacing applications.
• Createdpartitioned tablesto improve the performance of the applications.
• Constantly performance tuned different modules using hints, indexes, explain plan to handle everyday increasing customer base.
• Involved in the normalization as well as de-normalization of the tables for the optimization of database and application performance.
• Used Unix Crontab to schedule various jobs at regular intervals.
• Enhanced and monitored different scripts/cycles ensuring that they are running and completing in time.
• Created the migration scripts using pl/sql packages, stored procedures, functions to migrate users from the old Portal tables to new user portal tables.
• Createdexternal tablesto handle huge volumes of data which is not used frequently.
• Keen focus on performance tuning and optimization using explain plain and optimizer hints.
• Supported interdepartmental data load processes using customized UNIX shell scripts and scheduling the jobs through crontab.
• Helping offshore team in debugging workflows created through Informatica.
• Extensive hands-on experience in developing workflows, mappings using various transformations me.e. Sequence Generator, Joiner, and Lookup etc.
• Involved in PL/SQL code review and modification for the development of new requirements
• Data verification and Testing using Quality Center tool.
• Follow up wif client for the review and approval on the retirement report.
• Closing all the CRs, which are raised for different retirement activities.

Environment: OS: Windows XP, Windows 2000, Windows 2003, Linux, UNIX

Technologies/Database: SQL, T-SQL, PL/SQL, Oracle 9i, Oracle 10g, Microsoft SQL Server 2000, 2005, Microsoft Access, Lotus Notes Database, Share point portals.

Tools: TOAD, SQL Developer, SQL Plus, Altova XML Spy, Altova Map Force, Altova Style Vision, Informatica Power Center 8.6, Team Foundation Server (TFS), ClearCase, VSS, Quality Center, Remedy, Microsoft Project Plan (MPP)

Confidential, Indianapolis, IN

Data Migration Consultant

Responsibilities:

• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.
• Testing, Quality assurance Documentation, Implementation and Project Planning.
• Wrote Packages containing several Procedures and Functions in PL/SQL to validate before loading into Application database.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges on OLTP server.
• Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, and nested queries, views for the business application development.
• Created temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Wrote Materialized views and complicated queries using SQL.
• Designed and developedOracle forms & reports.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Extensively used the advanced features of PL/SQL like collections, nested table, varray & Dynamic SQL.
• Experience wif merging data files coming from different geographical customer into the existing data warehouse.
• Created the indexes and analyzed the table for better performance.
• Moved the tables to different table space and rebuild the indexes.
• Wrote both implicit and explicit Cursors to capture many rows wifin a PL/SQL block, and applied business rules on them.
• Developed Unix Shell Scripts and loading data into the Database using SQL* Loader.
• Copying of data from development to test and production by using utilities like Export/Import.
• Used Explain plan for tuning the SQL statements by creating indexes.
• Extensive use of Optimizer Hints to tune the Sql Queries.
• Worked extensively on Exception handling to error handling and tracking.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Wrote the shell scripts and scheduled wif using cronjob for the database backups and old archive log deletion.
• Logical backup (database structure export only) of the development instances every day using shell script
• Documented business rules, technical designs, test cases, and user guides.
• Involved in unit testing, integration testing, system testing.

Environment: Windows, UNIX, Windows Server 2000/2003

Confidential, Indianapolis, IN

Oracle PL/SQL Developer

Responsibilities:

• Developed AdvancePL/SQL packages, procedures, triggers, functions, IndexesandCollectionsto implement business logic.
• Generated server sidePL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Involved in creatingUNIX shell Scripting.
• Defragmentation of tables, partitioning, indexes for improved performance and efficiency. Involved in table redesigning wif implementation of Partitions Table to makeDatabaseFaster and easier to maintain.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Experience inDatabase Application Development, Query Optimization, Performance TuningandDBAsolutions and implementation experience incomplete System Development Life Cycle.
• UsedSQL Server SSIS toolto build high performance data integration solutions includingextraction, transformation andload packagesfordata warehousing.Extracted data from theXMLfile and loaded it into thedatabase.
• UsedCrystal Reportsto track logins, mouse overs, click-through, session durations and demographical comparisons wif SQL database of customer information.
• Worked onSQL*Loaderto load data from flat obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Used principals of Normalization to improve the performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
• Involved in the continuous enhancements and fixing of production problems.Designed, implementedandtuned interfaces and batch jobs usingPL/SQL. Involved in data replication and high availability design scenarios wifOracle Streams. DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.
• Mentoring 2 resources, coordinating wif onsite team and the client.
• Involved in validation documentation.
• Involved in new release IQOQ and testing.

Environment: Windows 2000, UNIX

Technologies: Oracle 10g, PL/SQL. Informatica Power center 8.6

Confidential, Indianapolis, IN

Oracle PL/SQL Developer

Responsibilities:

• Prepare the Mapping document which details out the mapping of source to the target data model wif application of business rules.
• Importing and exporting the data into multiple environments.
• DevelopedPL/SQL Packages, ProceduresandFunctionsaccordance wif Business Requirements for loading data into database tables.
• DesigningTables, Constraints, Views, andIndexesetc. in coordination wif the application development team
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed procedures usingDynamic SQL
• Created various SQL and PL/SQL scripts for verification of the required functionalities
• Created various Database triggers using PL/SQL
• Generated a number of reports for management to review for system functionality as against the old legacy system
• Worked wif various functional experts to implement their functional noledge into working Procedures
• Worked on optimizing existing procedures and functions using PL/SQL
• Used Actuate to create various Report Formats including Sub Reports, Cross Tab Reports, Standard Reports and Master/Detail Reports
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Resolving the issues on priority basis.
• Responsible for Analyzing and Implementing the Change Requests
• Involved in handling the changes in compiling scripts according to the database changes.
• Coordinate wif the front end design team to provide them wif the necessarystored packageandproceduresand necessary insight into the data.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.

Environment: Windows 2000, UNIX

Confidential

Oracle Developer

Responsibilities:

• Wrote different scripts in PL/SQL using Packages, Procedures, Functions and Triggers.
• Involved in testing all the scripts in test database region and moved into the production.
• Schedule jobs using UNIX Crontab and Shell Scripts.
• Analyzed the source system to understand the source data and table structure along wif deeper understanding of business rules and data integration checks.
• Reviewed the logical model wif Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Created views for reports and data auditing packages, Maintained the development environment wif up to-date production grade data.
• Involved in Unit testing provided test cases to QA and Implemented the developed database objects into the production.
• Wrote Documentation for implementing Packages & jobs to run daily and weekly.
• Provided database support to testing team in writing complex SQL queries.
• Created automated jobs using UNIX Shell scripts to run all the sql files in a directory by invoking SQL *Plus.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets.
• Developed user documentation, test plan documents and unit testing for the application modules.
• Created workflows to design, develop, and deploy Informatica as an ETL solution.
• Defined methodical and systematic process flow mapping, outlining project process flow map.
• Responsible for performing code reviews
• Worked wif ETL team and architect to build data model for staging area.
• Worked wif ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources me.e. databases, flat files, csv, and xml and data validation process from staging area to production database.
• Involved in handling the changes in compiling scripts according to the database changes
• Developed reports using complex queries as perclient requestas a part of production support

Environment: OS: Windows