SUMMARY

• Over 9 Years experience of software development life cycle experience in Software Design, Development and Implementation of SQL Server, Oracle, SQL, PL/SQL and Informatica.
• Strong working experience in ETL, Data Analysis, Data modeling, logical and Physical database
• Working experience in Banking, Aviation and Energy Industries.
• Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers, Shell - Scripts, Informatica mappings, Sessions and SQL Loader scripts.
• Good understanding of oracle Data Dictionary and Normalization Techniques.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Expertise in performing Data export, Import and various operations using TOAD.
• Very strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing PLSQL code, modifying database parameters.
• Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL, Informatica8.6 to populate the tables in OLTP and OLAP Data warehouse Environment.
• Involved in Production Support and troubleshooting data quality and integrity issues
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Used Exception Handling extensively to debug and display the error messages in the application.
• Experience in Installing Software’s and Configuring Databases.
• Experience in UNIX Shell Scripting.
• Possess good communication skills and quick learning ability.

TECHNICAL SKILLS

Databases: SQL Server, Oracle 8i/9i/10g/11g, MS access

Programming Languages: C, C++, JAVA, HTML, HTML5, DHTML, Java Script, SQL, PL/SQL

Tools: and Utilities: SQL*PLUS, SQL*LOADER, PL/SQL Developer, Toad

Operating Systems: UNIX (RHEL, SOLARIS), LINUX, Windows (98/2000/XP/VISTA), DOS

ETL Tools: Informatica Power center 8.6

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow diagrams, Data Modeling, Data WarehousingSystem Integration.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer

Responsibilities:

• Gathering the requirements from Business Analysts and convert them to functional specifications.
• Involved in complete life cycle of Software Development Life Cycle.
• Involved in complete life cycle of ETL process to read the data form Source databases and load them to Target (Agile) Database.
• Created/Modified oracle script - Packages, Procedures, and Functions to get data from flat files and load to Staging database and then to Target database.
• Created Oracle tables, Indexes, Sequences to load the data to target tables.
• Created Views/Materialized Views as per business logic.
• Involved in Unit testing, Regression testing validate data and test the end result.
• Create Active Batch jobs to automate the load process using Active Batch Scheduling tool.
• Handling the trouble tickets based on priority levels.
• Monitor Scheduled jobs during the load run.
• Used finetune techniques in SQL -hints, bulk load, indexes and reduced the time effectively for performance loads.
• Used Exception handling to debug and display the error messages in the application.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 12c/11g/10g, SQL Developer, SQL *Plus, TOAD, and Export/Import utility, UNIX, Windows XP, Active Batch Scheduling tool, Remedy Ticketing tool.

Confidential, Manitowoc, WI

Oracle Developer

Responsibilities:

• Gathering the requirements from Business Analysts and converting them to Functional specifications.
• Preparing Functional and Technical Design documents.
• Created test cases for Unit testing, Integration testing and User acceptance testing.
• Participated in developing architecture of staging databases and involved in designing the tables and partitioning them.
• Involved in complete life cycle of ETL process for data movement from Source data to Staging and finally to AlCIE database.
• Effectively used cursors, records, user defined objects, dynamic SQL, bulk loads, and exception handlers in the programming.
• Wrote stored procedures, Functions and packages, triggers as per the business logic.
• Created views, materialized views, sequences as per the requirement.
• Handling the trouble tickets which come into an application from the users based on the priority level.
• Used fine tune techniques in SQL (hints, bulk load, creating indexes etc.) and reduced the time effectively for each load.
• Involved in scheduling automated jobs using Control-M and monitor during the load run.
• Developed Unit test cases to validate and test the end result.
• Used Exception Handling extensively to debug and display the error messages in the application.
• Actively participated in Unit testing, Integration testing and Regression testing.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 10g, SQL Developer, MCC Oracle, SQL *Plus, TOAD, and Export/Import utility

Confidential, Green Bay, WI

Oracle PL/SQL Developer

Responsibilities:

• Gathering the requirements from Business Analysts and converting them to Functional specifications.
• Preparing Functional and Technical Design documents.
• Created test cases for Unit testing, Integration testing and User acceptance testing.
• Participated in developing architecture of staging databases and involved in designing the tables and partitioning them.
• Involved in complete life cycle of ETL process for data movement from Source data to Staging and finally to Actimize database.
• Effectively used cursors, records, user defined objects, dynamic SQL, bulk loads, and exception handlers in the programming.
• Wrote stored procedures, Functions and packages, triggers as per the business logic.
• Created views, materialized views, sequences as per the requirement.
• Implemented common auditing procedure to capture the load status for every job that occurs.
• Developed CDC process for all account and Loan tables using hash key functionality.
• Involved in running CDC process manually for testing purpose.
• Handling the trouble tickets which come into an application from the users based on the priority level.
• Extensively used informatica transformations like lookup, expression, filter, aggregator, normalizer, rank, sorter, sql, update etc.
• Used fine tune techniques in SQL (hints, bulk load, creating indexes etc.) and Informatica (bulk loads, re-use cache, effective use of join and aggregate transformations etc..), reduced the time effectively for each load.
• Involved in scheduling automated jobs using Control-M and monitor during the load run.
• Developed Unit test cases to validate and test the end result.
• Used Exception Handling extensively to debug and display the error messages in the application.
• Actively participated in Unit testing, Integration testing and Regression testing.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 10g, SQL Developer, SQL *Plus, TOAD, Control-M, Export/Import utility and Informatica 10.1.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in complete life cycle of ETL process for data movement from Source data to Staging and finally to Warehouse.
• Involved in Data Architecture and System Architecture and designed Database Tables for RDBMS system using ERWIN
• Designed and Developed Data warehouse Admin Console
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Closely co-ordinate with the Lead in the Architecture of the data model
• Analyzed critical/complex processes of application packages to design ETL processes and adopted strategy to prevent failures and acted swiftly to recover from application failures
• Developed data loading plans to seamlessly automate the data loading procedures from
• Multiple data sources (Flat files, SQL Server, Oracle) into Data Warehouses
• Involved in test case preparation and performed UNIT Testing. Integration Testing and User acceptance Testing
• Supported the Informatica developers in Database Server Performance, tracking user activity, troubleshooting errors, tracking server resources and activities, tracing server events
• Creation and running of workflows and sessions in Workflow Manager.
• Involved in performance tuning of the Informatica mapping using various components like Parameter files, Variables and Dynamic Cache.
• Majorly Involved in designing of Data warehouse and creating tables, Indexes, Procedures, Functions, Packages, Sequences using SQL, PL/SQL.
• Used shell scripts for making the running procedure of mapping automated and as event based.
• Documenting the ETL design specifications and mappings and maintaining the version control of mappings, which are changed according to the business rules.

Environment: Informatica Power Center 8.6, Oracle 8i, SQL, PL/SQL, and UNIX