SUMMARY

• 6+ Years of substantial experience in Information Technology in various roles as Sr. Oracle PL/SQL Developer with solid background in Oracle 12c/11g/10g/9i, SQL, PL/SQL, Unix Shell Scripting and Linux/Windows.
• Successfully managed multiple projects, working through a different geographical location (onshore - offshore) for Investment Banking, Insurance and Telecom domains.
• Proficient in writing PL/SQL programming using Packages, Cursors, Stored Procedures, Functions, Triggers, advance PL/SQL for performance optimization like bulk collections, records, TKPROF, SQL Trace utility.
• Extensive experience in developing all database schema objects such as Tables, Views, Indexes, Constraints, Sequences, Synonyms, Materialized Views and Database Links.
• Extensively worked on PL/SQL Records and Collections, Bulk bindings, Ref Cursors, Nested tables and Dynamic SQL, Autonomous transaction, Compound triggers.
• Involved in Database Migration from Oracle 10g to 11g and implementing RAC (real application cluster).
• Extensive experience in back end database development tools like SQL*PLUS, TOAD, SQL Navigator, SQL Developer, PL/SQL Developer, Erwin.
• In depth knowledge in development methodologies like Software Development Life Cycle (SDLC) processes, Agile, Scrum, Waterfall and OOAD (Object Oriented Analysis and Design).
• Experience in loading data from Flat files and XML files into database, performing business validations on the data using PL/SQL Procedures, SQL*Loader.
• Used ETL tools to develop jobs for extracting, cleaning, transforming and loading data into data warehouse and to different databases and apply patches.
• Experience in ETL Data warehousing using Informatica Power Center 9.1/ 8.x.
• Experience in Informatica Power Center, Repository Manager, Designer, Workflow Manager and Workflow monitor.
• Working Experience in implementing complex business rules through Informatica transformations, Workflows/Worklets and Mappings/Mapplets.
• Worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Normalizer, Joiner, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, XML Source Qualifier and External procedure.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as a part of team.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, Oracle 11g SQL Server, Advance Queuing

SQL Utilities: SQL*Plus, SQL*Plus Worksheet, SQL*Loader, Import/Export

Performance Tuning: SQL Trace, TKPROF, Explain Plan, HINTS

Languages\Scripting: SQL, PL/SQL, C, Java, HTML, JavaScript, JDBC, Shell Scripting

Data Modeling Tools: SQL Navigator, SQL Station, TOAD and Eclipse

Scheduler: Autosys, Cron Job Utility

Version Control Tools: IBM Rational Clear Case, Source Tree

ETL Tools: Informatica Power Center 9.1

Operating Systems: Win 98, XP/NT, Windows 2000, Red Hat Linux7

PROFESSIONAL EXPERIENCE

Confidential, Buffalo Grove, IL

Sr. PL/SQL Developer

Responsibilities:

• Gathered end user requirements, developed applications and different audit functionalities depending on the requirement acting for both system analysts and application developer.
• Wrote user requirement documents, created technical specs and design documents for various projects.
• Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic sql queries etc.
• Programming in SQL server using stored procedures, triggers, views, user-defined functions and cte's.
• Involved in database design, normalization, de-normalization in building data warehouse and reporting systems.
• Involved in query tuning by creating cluster and non-cluster indexes on tables, and used index tuning wizard.
• Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
• Used event handlers for event handling which includes on pre-execute, post execute and error.
• Involved in package logging in both standard (SQL server and file based) and custom logging using customer stored procedure and tables.
• Involved in monitoring and deployment of SSIS packages across dev., uat, and production environments using dtexec utility, command prompt with .bat files etc.
• Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.
• Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.
• Created adhoc reports more often based on end user requirements.
• Performed daily DBA activities, security assignment, user setup, backup, restore and job monitoring on MS SQL Server
• Generated and formatted reports using global variables, expressions and functions.
• Involved in developing parameterized reports using single values, multi values and cascading parameters.
• Build effective queries for high performance reporting and rendered them to html, xml, pdf, MS word and excel formats using SSRS (2005/2008).
• Managed and implemented SSIS packages to do the nightly refresh of data
• Answered technical inquiries and responded to troubleshooting requests

Environment: SQL server 2000/2005/2008 , SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i, Enterprise Manager, ERWIN Data Modeler, SSIS, SSRS, SSAS, Windows Server 2003/2008, OLTP, OLAP, DTS, HTML, XML, C#, .Net, Visual Studio 2008, ETL, MS Access

Confidential, Irving, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Extensively interacted with business users in understanding business application, business data flow, data relations and the various logistics processes.
• Holding Client meetings on a weekly basis to collect requirements and suggested modifications.
• Managing offshore development team and doing Code Review, Verification and Testing of the Code before delivery.
• Responsible for Analyzing, Implementing and Preparing estimates for Change Requests raised by the client.
• Developed PL/SQL Packages, Procedures, Functions, Triggers, Indexes and Collections to implement business logic using SQL navigator. Generated server-side PL/SQL scripts for data manipulation and validation and Materialized Views for remote instances using oracle tools like Toad, PL/SQL DeveloperandSQL*Plus.
• Developed complex SQL queries including Joins, Sub queries, Correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Data loads are being performed by using the SQL Loader, Imports & UTL files based on file formats.
• Coded PL/SQL packages and procedures to perform data loading, error handling and logging, used procedures into an existing ETL process.
• Improved the performance of the slow SQL queries by implementing indexes, using BULK LOAD, BULK COLLECT and developed various procedures, functions and packages to implement the new business.
• Analyzing the Sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Worked for ETL process of data loading from different sources and data validation process from staging area to database.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Worked extensively on different types of transformations like Source qualifier, Expression, Aggregator, Router, Filter, Update strategy, Lookup, sorter, Normalizer, Sequence generator, etc.
• Involved in Unit testing and System Integration testing for PL/ SQL Stored Procedures and Functions.

Environment: Oracle 12c / 11g / 10g SQL, PL/SQL, Oracle Performance Tuning, Autosys, TKPROF, Oracle Hints, UNIX, Java, Sub Version, Export / Import Utilities, TOAD, SQL Navigator, Query Analyzer, Enterprise Manager, Informatica Power Center 9.x/8.x.

Confidential, Dallas, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Worked as Senior Team Member, responsible for requirements gathering, status reporting, creating various metrics, project deliverables.
• Good understanding of Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• Involved in migrating production database from Oracle 10g to 11g on Windows NT and implementing RAC (real application cluster) and deployment of objects to production environment.
• Developed PL/SQL Packages, Procedures, Functions, Triggers, Indexes and Collections to implement business logic using TOAD, SQL developer.
• Involved in writing Oracle PL/SQL functions, procedures and packages in Oracle RAC environment.
• Experience in loading data from Flat files and XML files into database, performing business validations on the data using PL/SQL Procedures, SQL*Loader.
• Managing Terabytes of Data Volumes and created Materialized Views for replication of data from various data sources.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
• Involved in Unit testing and System Integration testing for PL/ SQL Stored Procedures and Functions.
• Developed complex SQL queries including Joins, Sub queries, Correlated queries, and Nested queries, Unions, Intersect and Aliases.
• CreatedRecords, Tables, Collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Handled dynamic PL/SQL errors usingException Handling, Error Loggingextensively for the ease of debugging and displaying the error messages in the application.
• PerformedSQL and PL/SQL tuningusing various tools likeExplain Plan, SQL*TRACE, TKPROFandAUTOTRACE.
• Analyzed the business requirements and framing theBusiness Logicfor theETL Process and maintained the ETL process using Informatica Power Center and worked on Power Center client tools like Source Analyzer, Target designer, Mapping Designer.
• Working on the transformations such as Source Qualifier, Expression, Lookups, Filter, Router, Sorter, Joiner, Sequence Generators, Aggregators, Union, and Rank.
• Carried out Disaster Recovery Tests for application on half-yearly basis to ensure no loss of data to deal with disasters.
• Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
• Created batch jobs, DBMS SCHEDULER jobs in regular maintenance, production support to load the data using UNIX shell scripting.

Environment: Oracle 12c/11g/10g SQL, PL/SQL, Oracle Performance Tuning, Erwin, Informatica Power Center 9.1, Autosys, TKPROF, Oracle Hints, UNIX, Java, Export / Import Utilities, TOAD, SQL Navigator, Query Analyzer, Enterprise Manager

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked as Team Member, responsible for requirements gathering, status reporting, creating various metrics, project deliverables.
• Good understanding of Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• Developed PL/SQL Packages, Procedures, Functions, Triggers, Indexes and Collections to implement business logic using TOAD, SQL developer.
• Involved in writing Oracle PL/SQL functions, procedures and packages in Oracle RAC environment.
• Experience in loading data from Flat files and XML files into database, performing business validations on the data using PL/SQL Procedures, SQL*Loader.
• Managing Terabytes of Data Volumes and created Materialized Views for replication of data from various data sources.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
• Involved in Unit testing and System Integration testing for PL/ SQL Stored Procedures and Functions.
• Developed complex SQL queries including Joins, Sub queries, Correlated queries, and Nested queries, Unions, Intersect and Aliases.
• CreatedRecords, Tables, Collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Handled dynamic PL/SQL errors usingException Handling, Error Loggingextensively for the ease of debugging and displaying the error messages in the application.
• PerformedSQL and PL/SQL tuningusing various tools likeExplain Plan, SQL*TRACE, TKPROFandAUTOTRACE.
• Analyzed the business requirements and framing theBusiness Logicfor theETL Process and maintained the ETL process using Informatica Power Center and worked on Power Center client tools like Source Analyzer, Target designer, Mapping Designer.
• Working on the transformations such as Source Qualifier, Expression, Lookups, Filter, Router, Sorter, Joiner, Sequence Generators, Aggregators, Union, and Rank.
• Carried out Disaster Recovery Tests for application on half-yearly basis to ensure no loss of data to deal with disasters.
• Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
• Created batch jobs, DBMS SCHEDULER jobs in regular maintenance, production support to load the data using UNIX shell scripting.

Environment: Oracle 12c/11g/10g SQL, PL/SQL, Oracle Performance Tuning, Erwin, Informatica Power Center 9.1, Autosys, TKPROF, Oracle Hints, UNIX, Java, Export / Import Utilities, TOAD, SQL Navigator, Query Analyzer, Enterprise Manager