PROFESSIONAL SUMMARY:

• Over 6.5 years of experience in Software Development and Expertise in Informatica, Oracle 11g/10g/9i/8i, Exadata, SQL, PL/SQL, Unix/Linux Scripting.
• Extensive experience in envisioning the relevance of data and translate the business needs into Data model.
• Excellent experience at creating technical documents like Technical Design documents, Impact Analysis document, Source to Target Mapping Document, Test plans and cases
• Extensive experience in designing and developing high volume transaction based systems, which supports parallel processing.
• Effective in handling requirement gathering, focusing on understanding and documenting the business processes and data requirements of those processes
• Experience on Data Profiling and Data Mining.
• Extensive experience working with various SOURCE and TARGET systems, which includes SALESFORCE.COM, XML, TANDEM, Flat Files and Relational Databases.
• Proficient in designing ETL workflow using various transformations such as Lookup, Aggregator, Joiner, Router, Union, Filter, Pivot, Update Strategy.
• Successfully implemented concept of slowly changing dimensions
• Highly skilled in tuning SQL queries using Optimizer Hints, Auto Trace, TK - Prof, Explain Plan
• Extensive programming experience in writing Database procedures, functions, packages, objects, database triggers, exception handlers, cursors, cursor variables, Analytical functions, Bind variable, Bulk Processing
• Highly skilled in Oracle PL/SQL, Informatica and Unix/Linux Shell/Perl scripting
• Extensively Worked on Oracle Cursors, Exception handling, maintaining Error and Performance log
• Highly involved in defining indexes, partitioning table, creating materialize view to improve application performance

TECHNICAL SKILLS

Data warehouse Tools: Informatica 9.5.1

Relational Databases: Exadata, Oracle 9i/10g/11g

Database Languages: SQL, SQL*Plus, PL/SQL

Programming Languages: PL/SQL, C, C++

Operating Systems: Windows XP/2000/NT, UNIX, Linux

Scheduling Tools: Control-M

Languages: C, SQL, PL/SQL, HTML, XML, UNIX/LINUX, SQL *Plus

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

PROFESSIONAL EXPERIENCE

Confidential, Lakeforest, IL

Senior ETL Developer

Responsibilities:

• Participated in the technical requirement gathering with the Subject Matter Experts (SME’s), Business Analysts and Users.
• Worked on the estimates (50%, 70%, and 90%) and designed the strategy based on the BRD documents.
• Involved in writing documents for various phases in the project lifecycle including: Analysis document, Functional specification, Technical specification, Unit test cases, and deployment plan
• Involved in POC for Informatica plug-in for Salesforce.
• Efficiently delivered data integration project to SALESFORCE and 1010DATA
• Developed new mappings using Informatica to merge/ extract data from Salesforce to Oracle database.
• Worked on data integration project with third party vendors like Precima, CHD, Oracle CRM, Star, as well as internal (OLTP)operational systems like Tandem, IBM, MDM, CAS, SIS and PeopleSoft to define file layout and file transfer method (FTP/SFTP/MFT) for inbound or out bound data feeds
• Designed and developed ETL using Informatica
• Designed and developed ETL using PL/SQL
• Worked on the feasibilities and Proof of Concept in the design phase before development.
• Designed plans for back out and recovery for implementation.
• Worked in AGILE/Waterfall model.
• Written Unit Test Scripts and performed them. Supported System Integration Testing and User Acceptance Testing (UAT) to validate data and played an active role in product rollouts.

Environment: Informatica 9.x, SQL,PL/SQL, Exadata, Oracle 10g/11g, LINUX/UNIX, SQL* Loader, Discoverer, Windows 2008 server R2, Toad 9/10, Control-M, PVCS, C++,C, HPSM, Remedy, Salesforce, HP Neoview

Confidential, Greenville, SC

ETL Developer

Responsibilities:

• Involved in writing documents for various phases in the project lifecycle including: Analysis document, Functional specification, Technical specification, Unit test cases, and deployment plan
• Worked on Data extraction (Interface) into flat files using UTL File and Data Load from flat files using SQL*Loader and Unix Shell Script
• Design and develop DW batch process using PL/SQL Stored procedures, functions, packages and/or triggers to perform the data validations on loaded data and transforming them to final objects
• Designed and developed ETL using Informatica
• Interacted with users on solving issues on the system and data-related problems
• Assisted the testers in creation of test scripts and SQL query’s that are used in testing the Oracle stored procedures, forms, Report
• Created database scheduler scripts and applications using UNIX shell scripts, SQL *Plus script
• Involved in shell script development based on user’s requirements

Environment: Informatica 9.x, Oracle Database 10g, TOAD, PL/SQL Developer, SQL Loader, Import/Export Utility, UNIX

Confidential, Greenville, SC

ETL Developer

Responsibilities:

• Design and develop batch process using oracle PL/SQL Stored procedures, functions, pipeline function, collection and packages.
• Extensively Worked on Oracle static, dynamic and Ref Cursor, Exception handling, maintaining Error and Performance log
• Create shell scripts to call oracle functions to load data into oracle tables from flat file using SQLLDR or External Table
• Tune SQL query using oracle advance features like oracle hints, merge, sub query, scalar sub query, with clause, outer join, bind variables, bulk collect, index skip scan, collection cashing mechanism, materialize view and query rewrite feature
• Extensively worked on performance tuning by using SQL-Related Performance Tools like EXPLAIN PLAN, Auto Trace and TKPROF
• Designed and developed ETL using Informatica
• Worked on Data extraction into flat files using UTL FILE and Data Load from flat files using SQL*Loader or External table

Environment: Oracle Database 9i / 8i, TOAD, PL/SQL Developer, SQL Loader, Import/Export Utility, UNIX, Informatica 8.x

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in software requirement specification and technical design.
• Gathering data elements needed for analysis of the data, decoding flat file data and loading into database tables using SQL*Loader.
• Created materialized views, partitions, tables, views and indexes.
• Involved in tuning and optimization of SQL statements.
• Created/modified the procedures, functions and packages to support data conversion.
• Used SQL hints and indexes to improve the performance of queries.
• Modified the existing shell scripts to support conversion process.
• Checked explain plan of the SQL queries to improve the performance.
• Performed Normalization and Logical Database Design.
• Created of database links and accessing the data through SQL statements.
• Involved in developing various Procedures, Functions and the PL/SQL objects

Environment: Oracle Database 9i, TOAD, PL/SQL Developer, SQL Loader, Import/Export Utility, UNIX