SUMMARY:

• Oracle Certified Professional (OCP) wif almost 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 teh 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 teh 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 teh 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 teh business operation/customer implement and support code migration into production.
• Constructed complex SQL queries wif sub-queries, inline views as per teh functional needs in teh 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 teh 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 teh packages for optimum performance using Oracle Hints, Explain Plans and Trace Sessions.
• Tested teh 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 teh 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 teh 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 teh 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 teh 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 teh client for initial scoping of System Retirement and identification of systems that needs to be retired.
• Scheduling and hosting teh kick off meeting for teh retirement for different systems.
• Providing archival solution to teh client to retain teh archived data as per business and legislative requirements.
• Developed and Modified teh PL/SQL Packages, Procedures, Functions and Database Triggers using teh oracle advanced techniques Bulk Processing and Collections.
• Develop teh jobs to extract, transform and load, populating and refreshing Staging Tables from flat file and tan export to Transaction Files.
• Write teh scripts to automate teh process, parameter setting / initialization for teh 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 teh packages for optimum performance using Oracle Hints, Explain Plans and Trace Sessions.
• Tested teh 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 teh 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 teh 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 teh 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 teh systems which has been identified for teh retirement in teh current wave. Preparing teh Retirement Plan wif teh help of gathered information.
• Defining data archival strategy for teh 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 teh procedures into an existing ETL process.
• UsedSQL loaderto load teh data from teh files provided by teh interfacing applications.
• Createdpartitioned tablesto improve teh performance of teh applications.
• Constantly performance tuned different modules using hints, indexes, explain plan to handle everyday increasing customer base.
• Involved in teh normalization as well as de-normalization of teh tables for teh 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 teh migration scripts using pl/sql packages, stored procedures, functions to migrate users from teh 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 teh 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 teh development of new requirements
• Data verification and Testing using Quality Center tool.
• Follow up wif client for teh review and approval on teh retirement report.
• Closing all teh 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

Module Lead & 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 teh business application development.
• Created temporary tables and developed SQL*Loader control files to load teh legacy data into teh 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 teh advanced features of PL/SQL like collections, nested table, varray & Dynamic SQL.
• Experience wif merging data files coming from different geographical customer into teh existing data warehouse.
• Created teh indexes and analyzed teh table for better performance.
• Moved teh tables to different table space and rebuild teh 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 teh Database using SQL* Loader.
• Copying of data from development to test and production by using utilities like Export/Import.
• Used Explain plan for tuning teh SQL statements by creating indexes.
• Extensive use of Optimizer Hints to tune teh Sql Queries.
• Worked extensively on Exception handling to error handling and tracking.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Wrote teh shell scripts and scheduled wif using cronjob for teh database backups and old archive log deletion.
• Logical backup (database structure export only) of teh 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

Technologies: Oracle 9i/10g, PL/SQL

Tools: TOAD, SQL Plus, VSS, Test Director, Quality Center, Remedy

Confidential, Indianapolis, IN

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 teh performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
• Involved in teh 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 teh 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

Tools: TOAD, VSS, Remedy, Test Director

Confidential, Indianapolis, IN

Oracle PL/SQL Developer

Responsibilities:

• Prepare teh Mapping document which details out teh mapping of source to teh target data model wif application of business rules.
• Importing and exporting teh data into multiple environments.
• DevelopedPL/SQL Packages, ProceduresandFunctionsaccordance wif Business Requirements for loading data into database tables.
• DesigningTables, Constraints, Views, andIndexesetc. in coordination wif teh 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 teh required functionalities
• Created various Database triggers using PL/SQL
• Generated a number of reports for management to review for system functionality as against teh old legacy system
• Worked wif various functional experts to implement their functional knowledge 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 teh requirements
• Resolving teh issues on priority basis.
• Responsible for Analyzing and Implementing teh Change Requests
• Involved in handling teh changes in compiling scripts according to teh database changes.
• Coordinate wif teh front end design team to provide them wif teh necessarystored packageandproceduresand necessary insight into teh 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 teh procedures into an existing ETL process.

Environment: Windows 2000, UNIX

Technologies: Oracle 10g, .NET

Tools: TOAD, VSS, Remedy, Test Director

Confidential

Oracle Developer

Responsibilities:

• Wrote different scripts in PL/SQL using Packages, Procedures, Functions and Triggers.
• Involved in testing all teh scripts in test database region and moved into teh production.
• Schedule jobs using UNIX Crontab and Shell Scripts.
• Analyzed teh source system to understand teh source data and table structure along wif deeper understanding of business rules and data integration checks.
• Reviewed teh logical model wif Business users, ETL Team, DBA’s and testing team to provide information about teh data model and business requirements.
• Created views for reports and data auditing packages, Maintained teh development environment wif up to-date production grade data.
• Involved in Unit testing provided test cases to QA and Implemented teh developed database objects into teh 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 teh 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 teh 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 teh database for loading data.
• Worked for ETL process of data loading from different sources me.e. databases, flat files, csv, xml and data validation process from staging area to production database.
• Involved in handling teh changes in compiling scripts according to teh database changes
• Developed reports using complex queries as perclient requestas a part of production support

Environment: OS: Windows