PROFESSIONAL SUMMARY:

• Over 12 years of Experience in the field of Software (Database, SQL, PLSQL)& Electrical Design, Development and Implementation.
• Expertise in all the phases of System development life Cycle (SDLC)
• Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
• Experience programming PL/SQL batch environment utilizing large tables (size more then 500 million rows(100 GB)) and high transaction throughout requirements.
• Experienced in working with many complex SQL queries with joins, date functions, inline views, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports and analyzing existing data.
• Experienced on DBA activities like creating schema, users, managing table-spaces, granting and revoking objects privileges on database objects, Sql monitoring.
• Performance Improvement of PL SQL code and improving memory utilization of Relational Database and Data Warehousing Systems using various improvement features.
• Proficient in debugging/testing PL/SQL packages/procedure/function and ODI packages to troubleshoot issues.
• Designed database schema's using Entity relationship modeling with ER diagrams & database normalization principles.
• Work Experience in writing shell script in Unix & Perl environment.
• Designed and Developed Data-stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Ability to collaborate with the Product Management team to understand and deliver the right solutions for business needs and comfortable working with Offshore team.
• Comfortable in working with a fast-paced, team environment.
• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, including executives, managers, and subject matter experts.

TECHNICAL SKILLS:

Databases: Oracle 10G,11G,12C,MS-SQL Server, MS Access, MySQL,DB2

Scripting: SQL, PL/SQL, Unix,DB2, T-SQL, PERL

ETL Tool: Informatica, Datastage, ODI, SQL/ PL SQL developer,TOAD

Query Tools: TOAD, SQL Navigator, SQL* PLUS, OBIEE,SQL developer

Operating Systems: Windows 2000/XP,LINUX 9.2/9.3, Solaris

Languages: Java,C, C++, HTML, XML, PHP,Pro*C

Reporting Tool: Business Objects, Crystal Reports

GUI: Oracle Forms 9i and Reports 9i

Other Tools: SQL*Loader, ERWIN, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Sr PLSQL (Informatica) Developer

Responsibilities:

• Closely worked with Analysts to create Compliance Engine in Fidelity.
• Extensively used Oracle PLSQL, INFORMATICA to complete the task in Agile environment. Worked with Data Architect to better understand data flow for PLSQL/ODI implementation.
• Created/Modified unix script to create/modify AUTOSYS jobs.
• Worked in truly global work environment and shared tasks across the team.
• Worked on performance improvement for existing PLSLQ and for new development for the Compliance engine.
• Created and modified New/existing PL/SQL Packages , Procedures, Functions using joins, sub queries, correlated sub queries, Native Dynamic SQL and Cursor Variables and REF CURSORS as well as Materialized view and Pragma Autonomous Transactions for ETL(Extract/Load/Transform) and Conversion project.
• Used Various PLSQL performance improvement techniques like BULK COLLECT, FOR ALL, and Table Partitioning, Autonomous Transactions, Global Temporary Tables etc.
• Used EXPLAIN PLAN, TRACE, TKPROF utility to analyze root cause of existing/new SQL query for informed decision in performance improvement task, and used Oracle EXADATA features to drastically improve Data retrieval and SQL query performance.
• Performed DBA activities like, creating table, indexes, sequences, views, triggers, materialized views, grants, impdp/expdp utilities in Oracle Database.

Environment: Oracle Database 11g/12C/Exadata, TOAD, UNIX, PVCS, WinSCP, UNIX, Stash, Jira, Visio, XML,APEX

Confidential, St Petersburg, Florida

Sr PLSQL (ODI) Developer & Analyst

Responsibilities:

• Closely worked with Business Analyst to understand business requirement and created implementation strategy using Angular2/Java/Oracle(PLSQL)/ ODI technology.
• Worked in team environment while maintaining individual performance to improve communication among team member.
• Worked with Data Architect to better understand data flow for PLSQL/ODI implementation.
• Created heathy team environment to focus towards one goal to meet company’s expectation.
• Created and modified New/existing PL/SQL Packages , Procedures, Functions using joins, sub queries, correlated sub queries, Native Dynamic SQL and Cursor Variables and REF CURSORS as well as Materialized view and Pragma Autonomous Transactions for ETL(Extract/Load/Transform) and Conversion project.
• Used Various PLSQL performance improvement techniques like BULK COLLECT, FOR ALL, and Table Partitioning, Autonomous Transactions, Global Temporary Tables etc.
• Used EXPLAIN PLAN, TRACE, TKPROF utility to analyze root cause of existing/new SQL query for informed decision in performance improvement task, and used Oracle EXADATA features to drastically improve Data retrieval and SQL query performance.
• Performed DBA activities like, creating table, indexes, sequences, views, triggers, materialized views, grants, impdp/expdp utilities in Oracle Database.
• Extensively Used SQL Developer /TOAD tool for development testing SQL / PLSQL code.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Created ODI work flow to create Realtime job,End of the day job to accommodate business requirement using ODI knowledge modules like LKM, IKM and CKM.
• Learned Java programming to Navigate / identify/trace the application bug.
• Used TFS to manage/monitor routine development task, to maintain CODE base using Source Tree/ GIT, GENESIS auto deployment in DEV/QA and Prod environment.
• Used Service Now requesting system to request manual deployment/enhancement on the existing Hardware/Software.

Environment: Oracle Database 12c/Exadata, Oracle R 12,TOAD, UNIX, PVCS, WinSCP, UNIX, Visio, XML,APEX

Confidential, Overland Park, Kansas

Oracle Developer & Analyst

Responsibilities:

• Arranged meeting with business analyst to understand business requirement to implement using Unix/Linux/SQL/PLSQL/DB2 technology.
• Created and modified New/existing PL/SQL Packages , Procedures, Functions using joins, sub queries, correlated sub queries, Native Dynamic SQL and Cursor Variables and REF CURSORS, PLSQL collection, Record type as well as Materialized view and Pragma Autonomous Transactions for ETL(Extract/Load/Transform) and Conversion project.
• Worked on Performance tuning of SQL/PLSQL code by using BULK COLLECT, FOR ALL, and Table Partitioning, Autonomous Transactions, Global Temporary Tables etc.
• Used EXPLAIN PLAN, TRACE, TKPROF utility to find out the performance of query to tune as per the requirement.
• Performed DBA activities like, creating table, indexes, sequences, views,triggers, materialized views, grants, impdp/expdp utilities in UDB/DB2 as well as Oracle Database.
• Migrated th excel sheets(CSV), text files, DMP files, IXF files into the respective Oracle Database tables using SQL *Loader and IMPDP/EXPDP/import/export utilities in Oracle as well as in UDB database.
• Created UNIX shells(BASH/KSH) scripts to automate data loading from CSV file to Oracle/DB2/UDB database.
• Used various tools SQL Developer/PL SQL developer /Toad tools for DBA and development purpose and ER Studio and ERVIN for data modeling.

Environment: Oracle Database 11g, Oracle R 12,TOAD, UNIX, PVCS, WinSCP, UNIX, Visio, XML,UDB,APEX, UDB,DB2

Confidential, Milwaukee, Wisconsin

Oracle Developer & Analyst

Responsibilities:

• Communicated with various departments to accommodate new health care products in On-Exchange Platform (Affordable Care Act).
• Arranged meeting with business to understand existing business process to better interpret existing process.
• Analyzed existing Data warehouse system, PL SQL codes to accommodate new health care product in existing data mart(Enterprise Data warehouse).
• Created Detailed Technical Documents from the existing code as per company standard document guidelines.
• Created various process flow diagram/Documentation to better to document existing process using Microsoft Office.
• Extensively debugged PLSQL code (Packages, Procedure, Functions) to do reverse engineering of existing PLSQL code and error tracking.
• Created/Optimized/enhanced the existing PLSQL Package, Procedures, Functions Triggers View, and SQL statements to improve overall code performance using TOAD/PLSQL developer, BULK COLLECT, FOR ALL, and Table Partitioning, Autonomous Transactions, Global Temporary Tables etc and EXPLAIN PLAN, TRACE, TKPROF utility.
• Worked on Data migration project to migrate excel sheets, text files into the respective Oracle Database tables using SQL *Loader scripts.
• Used ERWIN 3.5 tool for data modeling purpose and created activity hierarchy diagrams, data flow diagrams, work flow diagrams.
• Performed DBA activities like, creating table, indexes, sequences, views, triggers, materialized views, grants, impdp/expdp utilities in Oracle Database.
• Created Unix/Linux cell scripts to automate script execution. in Integration and Deployment in Production Env.
• Designed and Developed Data-stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.

Environment: Oracle Database 11g, Oracle 11i, Oracle R 12,TOAD, Informatica, UNIX, PVCS, WinSCP, Data Stage,UNIX, Visio, XML

Confidential, Harrison, NJ

Programmer & Business Analyst

Responsibilities:

• Worked in requirement gathering from the stake holders to create system which solve the routine operation.
• Collected data from various departments to creates report using Business intelligence software.
• Analyzed reports to make to create valuable information and reporting to the BA.
• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Involved in writing backend Packages extensively in PL/SQL codes and prepared Unit test cases..
• Maintained the data integrity and security using Integrity Constraints and Triggers as per the business requirement.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Used Microsoft Visio to create and change process flow diagram.
• Created/ modified Procedures, Triggers, Tables, Views and User-Defined Functions.
• Worked with Data warehouses, Data marts and subsets of data for reporting and data analysis purpose.
• Preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Actively Involved in Integration and Deployment in Production Environment.

Environment: Oracle Database 11g, Oracle 11i, TOAD, Informatica, Microsoft Windows Server 2008 R2, UNIX, PUTTY, C/C++,PVCS, WinSCP, SSRS,UNIX, IViso