SUMMARY:

• Extensive 6 years’ experience with proven ability in the area of Client/Server and ETL Application Development, Data modeling, Database Design, Data processing, Data Warehouse and Support using Informatica with Oracle technology on different platforms.
• More than 5 years proven experience in PL/SQL that includes Cursors, Ref - cursors, bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools etc.
• Over 5 years’ experience in Oracle data warehousing and Business Intelligence: Data modeling in dimensional structures - Star/Snowflake schema, ETL, OLAP, OLTP, VLDB (very large application).
• Expertise in Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table and Calling Appropriate Interface tables and API’s.
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
• Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
• More than 3 years’ experience using Informatica Power Center for ETL development
• Developed different Business Intelligence OLAP report using OBIEE.
• Proficient in using UNIX and Shell Scripting.
• Experience in Data Flow Diagram, ER Diagrams using Oracle designer.
• Followed all phases of System Development Life Cycle (SDLC) and Best Practices.
• Strong interpersonal skills, ability to interact with people at all levels. Possess solid communication and presentation skills.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, SQL*Plus

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

Business Intelligence Tool: OBIEE 10.1.3.4., Oracle reports 10g/9i/6iModeling Visio, Oracle designer, ERWIN

ETL Informatica: Power Center 9.1, PL/SQL, SQL Loader

Other Tools: TOAD 8.0/8.5/9.0/9.6/12.06 , SQL Developer, SQL Navigator, PLSQL Developer, ISQL, PVCS, FTP, Toad, SDLC

Operating Systems: Sun Solaris, HP-UX, AIX, UNIX, Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Production Support | PL/SQL Developer

Responsibilities:

• Regularly involved and resolved production support tickets.
• Promptly fixed bugs in packages, Triggers, Procedures and Functions.
• 24 hours monitoring in production issues in email by using log monitoring steps, and acting based on severity.
• Monitor Real Time(RT) payments through between Rackspace and WebService. If any eruption between this service happen. Find out any missed payments and let Billing, Collections know right a way. Make sure customer does not fell any service disruption.
• Successfully closed many tickets relating to production issues which involved discussing with other teams and then finally providing fix to it.
• Involved in converting functional specifications document to a detailed design document.
• Creating and modifying SQL procedures to implement the new business requirements.
• Extensively working with Quality Assurance team to fix all the issues to meet the deadlines of production.
• Populating data in oracle tables from flat files using sql loader utility and control files.
• Worked on Project named Auto Pay - from this customer could set up payment plan with their choice.
• Developed procedures and functions based on business requirements.
• Used BULK BINDING and FORALL features in PL/SQL for performing DML operations on large data set to improve performance.

Environment: Oracle Database 11g R2, Erwin, TOAD, UNIX, SQL, PL/SQL, Visio, Putty, ChangeGear, SVN, SharePoint, Change Gear(For Ticketing),Windows Server 2012(Scheduling Task).

Confidential, MN

Oracle PL/SQL Developer

Responsibilities:

• Prepared technical design documents Agent History View from scratch.
• Gathered Mapping document for development for the project.
• Analyzed the specifications and provided technical solutions based on client requirements.
• Interact with client for requirement gathering and clarification for any change request.
• Serving as an expert PL/SQL technical resource to the programming staff in the program development, testing and implementation process.
• Participated in taking KT’s at both offshore and on shore end.
• Developed PL SQL packages, procedures and functions to support the reports by retrieving the data from for the application.
• After developing code meticulously explained in design and code reviews meeting and suggested for integration testing.
• Optimization and tuning SQL queries to improve application performance. developing packages for implementing business logic through Procedures and functions.
• Created various SQL and PL/SQL scripts for the data conversion and applied various business rules to make the data compatible and in sync with the requirements.
• Wrote high performance queries/PL/SQL codes using Collections, Bulk Collects, Materialized Views (MV), Objects, Nested Tables, REF Cursors, and Indexing.
• Created UNIX Shell script program to call the SQL loader program that transfers data in data file to staging table and runs the custom concurrent program to transfer data from staging table to interface tables.
• Maintaining SVN.

Confidential, Lewisville, TX

ETL | Oracle PL/SQL Developer

Responsibilities:

• Extensively involved in writing SQL queries (Sub queries and Join conditions), co-related subqueries, in-line views and PL/SQL programming.
• Extensively used the advanced features of PL/SQL like collections, nested table and dynamic SQL.
• Work with cursor and ref cursor in PL/SQL scripts. Used ref cursor in functions to write the record set of cursor.
• Used Public Synonyms, read only User Accounts and Database Links to remote database.
• SQL, PL-SQL code tuning using hints, Explain Plan, SQL Trace, and TKPROF.
• Defining requirements by interacting with business group and application development group.
• Creating job flow diagrams, data flow diagrams, ER-Diagrams and process specifications as part of design.
• Developed Code Units, testing, debugging and implemented business rules using SQL, PLSQL (functions, procedures, packages, triggers), SQL*Loader, Korn shell scripts.
• Application tuning, Query tuning using Explain plan, SQL tuning sets, BULK Collect, BULK Load
• Designed and developed complex static and dynamic mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle. Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.

Environment: Oracle Database 11g R2, Informatica 9.1, Erwin, TOAD, UNIX, SQL, PL/SQL, Visio, Putty, Control-M

Confidential, Irving, TX

PL/SQL Developer & ETL Developer

Responsibilities:

• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle utilities like PL/SQL, SQL* Plus, SQL*Loader and handled complex Exceptions.
• Used Informatica 8.1 to load data from staging databases to target repositories
• Used various Informatica transformations like Expressions, Filters, Joiners, Lookup etc.
• Create PL/SQL Procedures and Functions to do the Data conversion.
• Created metadata, ETL mappings using Informatica; later started building Enterprise Data Warehouse using Oracle DB 10g and upgrading from 9i to 10g.
• Created batch jobs for loading data from Flat Files to database Interface tables using SQL*Loader/UTL FILE supplied package.
• Performance tuning/query optimization using Oracle Trace, Explain Plan, TkProf and utilizing table stored parameters.
• Enhanced the existing functionalities by modifying/developing forms, reports and PL/SQL based concurrent programs.
• Created UNIX Shell Scripts for automated execution of batch process.
• Created Perl scripts to transfer files using FTP.
• Wrote Database Triggers to implement complex business rules.
• Created complex program unit using PL/SQL Records, Collection types (Nested Tables and Varrays) in complex backend packages.
• Detailed user requirement Analysis and Design of systems.
• Coordinated with DBA in creating and managing Tables, Indexes, db links and Privileges.
• Developed Application Interfaces using PL/SQL stored Packages, Procedures, Functions, Collections, Object types and Triggers.
• Responsible for performing Pair code reviews and SDLC documentation.
• Performed basic script using PERL.

Environment: Oracle 11g, PL/SQL, SQL Plus, SQL*Loader, Pro*C, Oracle Developer 10g, Forms 10g, Reports 10g, Toad, Shell Scripting, AIX, Erwin, Oracle RAC, PVCS.

Confidential, Naperville, IL

ETL Developer & PL/SQL Developer

Responsibilities:

• Used Informatica ETL tool to create and optimized source-to-target mappings by using aggregator, filter, joiner, expression, lookups.
• Designed the process flows to record the dependencies between the mapping runs.
• Code for Fact and Dimension table population using Informatica Power Center
• Created metadata, ETL mappings using Oracle DB 9i; later started building Enterprise Data Warehouse using Oracle DB 10g and upgrading from 9i to 10g.
• Developed packages, procedures, functions and database triggers using SQL and PL/SQL.
• Use SQL Loader and External Table for data Load.
• Tested and took measures for maximum performance utilizing optimization hints, indexes, partitions, parallelism, storages and query optimization.
• Used UNIX shell scripts to clean and re-organize tables from time to time.
• Data Modeling using ERWIN.
• Created OLAP reports using Oracle Discoverer/OBIEE.
• Customized Reports in Oracle Report Developer 6i.

Environment: Oracle Application 11.5.10 (GL, AR, AP, PA, OM), Oracle Workflow, Oracle Database 9i/10g R2, SQL, PL/SQL, Discoverer 10g and Developer(Forms & Reports) 6i, SQL*Loader Oracle Application Server 10g, UNIX, Red Hat Linux, Windows XP Professional clients, Toad.