SUMMARY

• Over 7years of IT experience in analysis, design, development, implementation and testing of applications in data warehousing and client/server environment using Oracle SQL and PL/SQL.
• Experienced in the use of Agile approaches, including Extreme Programming, Test - Driven Development and Scrum.
• Experience with SQL*Loader to load data from external source like flat files into database tables.
• Proficiency in data warehousing techniques like data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment, change data capture.
• Experience in Oracle SQL and PL/SQL including all database objects Stored procedures, Functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections, Analytical functions, Table Partitions.
• Proficient at working as a team player with an aim of contributing towards the team's success. Involved in unit testing, systems integration testing and documented the same.
• Possess good communication and inter-personal skills and able to adapt quickly to new technologies and environments.
• Experience in Tuning the application using Explain plan and SQL Trace to optimize the cost for higher efficiency.
• Extensive Knowledge and Experience in ETL tools like SQL * Loader and Informatica Power Center to transfer the data between different databases.
• Experience in Data Analysis and managing data warehouse and data marts.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Used Erwin tool for data modeling and MS Visio to create the flow chart and to show the process flow. Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP .
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables, Collections and Exception handling.
• Experience with Oracle Supplied Packages such as DBMS SQL,DBMS JOB and UTL FILE.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, XML, JAVA, C, C++, Visual Basic, HTML, XML, SOAP, Eclipse

Operating System: Windows XP, Linux, Unix

ETL tools: Informatica power center 9.0/8.x, Power Mart 5.1, Power Connect for SAP R/3, JASPERSOFT, Informatica Data Quality.

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

Oracle Tools: SQL Developer, SQL *Plus, SQL*Loader, TOAD, Oracle Forms developer (forms builder/developer suit).

Tools: DAR Support, Quality Center, Jira

Other Tools: Control-M, CVS, SVN.

Reporting Tools: Jasper Ireports, Oracle Reports 2.5, Tableau

WORK EXPERIENCE

Confidential

Sr. Oracle Developer

Responsibilities:

• Working on Production tickets, developing new oracle forms and supporting QA teams
• Modified Existing Oracle forms for new requirements.
• Involved in developing new resources using forms.
• Worked on agile and test driven environment, participated on daily scrum meetings, discussions and finalize road blocks.
• Involved in the continuous enhancements and fixing of production issues.
• Responsible for delivery and support activities to QA team.
• Experience in working with code versioning system (SVN)
• Developed/Modified PL/SQL triggers on main application tables to replicate the data into audit tables.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Prepared Unix scripts to compile the newly developed forms into SAT(System Acceptance Test) Environment and Production.
• Modified/created the existing/new DDL scripts to accommodate the new requirements.
• Supported the system test (SAT) to fix the issues reported by the test team.
• Wrote SQL queries to get the data from production to the business users.
• Experience working on JIRA, Quality center and prepared the user guide for the new requirements.

Environment: s: Oracle 11g, SQL Developer, Forms 11g, SQL, PL/SQL, TOAD, Windows 7, Oracle developer suit (Oracle forms builder), Linux, Winscp.

Confidential

Sr. Programmer Analyst

Roles and Responsibilities:

• Fixing the mismatches in the data which resulted during ETL load process Using PL/SQL Procedures.
• Worked on agile and test driven environment, participated on daily scrum meetings, discussions and finalize road blocks.
• Modified Oracle Forms for new requirements.
• Involved in the continuous enhancements and fixing of production problems.
• Experience in designing complex mappings and transformations with Transformation Mapper and other Jasper transformation components.
• Modified Existing Jobs in Jasper Tool as per new requirement and troubleshoot Loading Issue of the Jasper/PL-SQL Jobs.
• Developed/Modified PL/SQL triggers on main application tables to replicate the data into audit tables.
• Responsible for delivery and support activities to different QA groups.
• Responsible for Analyze, fix and closing production tickets by monitoring Ticketing systems (JIRA and DARS).
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Developed Tableau data visualization using Cross tabs, Pie Charts and Bar Charts and Density Chart.
• Strong Dashboard design experience and passionate practitioner of effective data visualization using Tableau. Familiarity with best practices around visualization and design.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, HINTS, SQL*TRACE, TKPROF.

Environment: s: Oracle 11g, SQL Developer, Forms 11g, SQL, PL/SQL, TOAD, JasperSoft, Windows 7, Tableau.

Confidential

Sr. Oracle Developer

• Worked on Production tickets, developed new oracle forms and supported QA teams
• Modified Existing Oracle forms for new requirements.
• Prepared Unix scripts to compile the newly developed forms into SAT(System Acceptance Test) Environment and Production.
• Modified/created the existing/new DDL scripts to accommodate the new requirements.
• Supported the system test(SAT) to fix the issues reported by the test team.
• Wrote sql queries to get the data from production to the business users.
• Worked on SVN and JIRA.
• Involved in developing new resources using forms.
• Worked on agile and test driven environment, participated on daily scrum meetings, discussions and finalize road blocks.
• Involved in the continuous enhancements and fixing of production issues.
• Responsible for delivery and support activities to QA team.
• Experience in working with code versioning system (SVN)
• Developed/Modified PL/SQL triggers on main application tables to replicate the data into audit tables.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Environment: s: Oracle 11g, SQL Developer, Oracle Forms 11g, SQL, PL/SQL, TOAD, Windows 7, Tableau.

Confidential

ETL-PL/SQL Developer

Roles and Responsibilities:

• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Analyzed the business requirements and software requirements to create the test procedures.
• Involved in all phases of the SDLC(Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines on Agile SDLC methodologies.
• Developed scripts to migrate data from older oracle versions to new oracle versions.
• Involved in developing the mappings and loading the Data into the Target Systems using the SQL Loader.
• Responsible for delivery of data to support activities to different QA groups.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Involved in developing the mappings and workflows for loading the Subscriber Data into the Target Database using the Informatica Powercenter.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart. procedures and Packages and the necessary insight into the Data.
• Created/Modified PL/SQL stored Procedures, Functions and Packages for moving the data from Staging to the Data Mart.
• Intensively worked on Informatica mappings and workflows. Used different types of Transformations as part of the mapping in the Design center.
• Used different kinds of Transformations like Expression, Joiner, Router, Filter, Sequence Generator, Sorter, Union and Stored Procedures and developed various mappings.

Environment: s: Oracle8i, SQL * plus, SQL * Loader, PL-SQL, Java, JavaScript, HTML,SQL Developer, Shell Scripts, UNIX, Windows XP,Informatica Powercenter 9.0

Confidential

ETL/Informatica

Roles and Responsibilities:

• Interacted with business users to understand the customer requirements
• Analyzed the business requirements and software requirements to create the test procedures
• Mapping of data from Legacy(DDP/DDPF)to new billing System(Amdocs 7.0) Using SQL *Loader and PL/SQL Procedures
• Intensively worked on Informatica mappings and workflows. Used different types of Transformations as part of the mapping in the Design center.
• Used different kinds Informatica Transformations like Expression, Joiner, Router, Filter, Sequence Generator, Sorter, Union and Stored Procedures and developed various mappings

Environment: Oracle 8i, Informatica, CVS, SQL,PL/SQL,Unix,Ms-Office, Windows XP.