Summary:

• Over 8 years of total IT experience as Oracle PLSQL Developer with ETL/DWBI concepts and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, unit testing , documentation and Agile/Scrum Methodologies.
• 8 years of experience in SQL, PL/SQL and ORACLE including managing and leading DW/BI efforts from requirement gathering to its implementation.
• 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.
• Expertise in doing the RCA Root Cause Analysis and resolving performance bottlenecks
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in writing SQL queries, stored procedures, functions, packages, triggers, external tables, collections, BULK COLLECT and DBMS utilities.
• Experience in Performance Tuning, import, export, SQL Loader and DATA MIGRATION.
• Strong database design skills. Experienced in the Data Modeling tools Logical Database Modeling using Erwin Data modeler.
• Automation, Scheduling and monitoring of jobs with scheduler Autosys.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization CBO .
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS
• Proficient in writing Unix Shell scripting for scheduling jobs and Automation of ETL process
• Involved to working in slowly Changing Dimensions type 1, type2 and type 3 based on the requirement. Understanding the Star Schema and Snowflake Schema, relationship between Fact and Dimension tables. Understanding of primary, foreign, compound and surrogate keys relationship.
• Experience in Dataloader, SOQL writing for Salesforce Cloud .
• Hands on experience on GreenPlum Database Massively Parallel Processing .
• Management skills include Team Management, Project Planning, Monitoring, and self-starter with good communication skills and ability to work independently and as part of a team.
• Ability to adjust to the people, circumstances responsibility, with a Drive for results through self-motivation self-candor

Technical Skills:

Professional Experience:

Confidential

Role: ETL/DWBI/Oracle PLSQL Lead Developer

Project Description: Confidential A Smart Equipment Network SEN will have the ability to connect with fountain, vending coolers equipment to provide real time information to our business and enable a direct connection with our consumers.

• The SEN can be leveraged for
• Real-time equipment alarms and alerts can expedite service processes.
• Equipment product sales information can enable efficient route planning execution.
• Cashless payments on equipment can reduce trade loss.
• Dynamic consumer marketing can be directed through equipment.
• Real time gifting and coupons can be offered through equipment.
• Insights and analysis can be done with consumer behaviors from equipment interactions
• As part of this project, we will provide Real-time information on Consumption and Health Report of the Equipment to Insights and Business Users using SLALOM 3rd party vendor Dashboards built on Tableau .

Responsibilities:

• Direct interactions with the IT and Business team of every module is required for developing the Tower Extracts with multiple customizations.
• Extensively used SQL, PL/SQL code to develop custom ETL solutions and load data into SLALOM system.
• Designed and developed several Data loader Cron jobs for various clients with SLALOM Tableau Dashboards AND ERP sources and target systems such as Oracle and flat files.
• Transformed the business requirements into technical specifications and source-to-target mappings.
• Identified the gaps in the business requirements that would impact the execution of project and also the data quality across streams.
• Provided the dimensional data model to give optimal performance by changing the Primary Index of tables and applying various performance tuning techniques on Oracle 11g data warehouse environment.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Coded Unix Shell Scripts to process the data received from source system on daily basis.
• Involved in the continuous enhancements and fixing of production problems.
• Created and reviewed scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created and used indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Conducted daily status meetings to track the status and issues related to integration testing
• Conducted weekly status meetings with the client to discuss on the status of the project

Environment: Oracle 11g R2, Salesforce, TOAD, LINUX shell scripting, MS Office, MS Visio, Rally

Confidential

Role: ETL Lead Developer/ Quality Analyst/Technical Business Analyst

Responsibilities:

• Direct interactions with the IT and Business team of every module is required for developing the Data warehouse with multiple customizations.
• Extensively used SQL, PL/SQL code to develop custom ETL solutions and load data into data warehouse system.
• Designed and developed several Dataloader ETL batch jobs for various clients with Salesforce ALM front end AND ERP sources and target systems such as Oracle and flat files.
• Transformed the logical data model into physical data model on Oracle 11g data warehouse environment to give optimal performance for ETL jobs as well as BI reports.
• Transformed the business requirements into technical specifications and source-to-target mappings
• Identified the gaps in the business requirements that would impact the execution of project and also the data quality across streams.
• Provided the dimensional data model to give optimal performance by changing the Primary Index of tables and applying various performance tuning techniques on Oracle 11g data warehouse environment.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the data received from source system on daily basis.
• Involved in the continuous enhancements and fixing of production problems.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created and reviewed scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Conducted daily status meetings to track the status and issues related to integration testing
• Conducted weekly status meetings with the client to discuss on the status of the project
• Identified and communicated the challenges, issues and risks and made sure that the impact of these on the project is minimal to zero

Environment: Oracle 11g R2, Salesforce, TOAD, LINUX shell scripting, MS Office, MS Visio, MKS, Hp10.0 and Remedy

Confidential

Role: ETL Developer/ Quality Analyst/Technical Business Analyst

Project Description:. The main purpose of this data warehouse implementation is to support the Marketing needs as well as the Representative needs across countries. Since all countries are doing the business in the similar fashion a need to have a global view of the same data is required and Confidential also caters to that. The data is received in terms of ASCII files from various sources like Confidential Billing System, Standard Data and Central Master. The ETL is done using Oracle Loader External Tables and PL/SQL procedures. Job scheduling is done using Autosys.

Responsibilities:

• Worked independently on the critical milestone of the project interfaces by designing a completely parameterized code to be used across the interfaces and delivered them on time inspite of several hurdles like requirement changes, business rules changes, source data issues and complex business functionality.
• Analyzed the source systems to detect the data patterns and designed ETL strategy to process the data.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the data received from source system on daily basis.
• Involved in the continuous enhancements and fixing of production problems.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created and reviewed scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Supported the development and production support group in identifying and resolving production issues.
• Was instrumental in understanding the functional specifications and helped the rest of the team to understand the same.
• Involved in All the phases of the development like Analysis, Design, Coding, Unit Testing, System Testing and UAT
• Created and executed test cases, test scripts and test summary reports
• Provided support and training to the team regarding any technical and functional aspects of the project

Environment: Oracle 10g/11g R2, TOAD and UNIX AIX /LINUX shell scripting, MS Office, MS Visio, MKS.

Confidential

Role: ETL Developer/Technical Business Analyst/Quality Analyst

Project Description:. Insight Marketing Intelligence IMI is an analytics team which uses data from Confidential to analyze, infer and interpret various business scenarios and generate reports for users. Also apart from the adhoc reports requirement, there was a standard set of extracts that were been ftp'd to the IMI team over a campaign frequency.

Responsibilities:

• Worked independently with the business analysis team to understand the requirements.
• Prepared low level design document and generated the reports accordingly
• Developed and maintained the code for standard set of outbound extracts.
• Analyzed the complex requirements and developed the reports with utmost accuracy.
• Developed very complex reports i.e., New Rep Tenure report, Brochure Analysis, ALM impact Analysis and PATD Rep Analysis etc.

Environment: Oracle 10g/11g R2, TOAD and UNIX AIX /LINUX shell scripting, MS Office

Confidential

Role: PL/SQL Developer

• Project Description: Confidential support Project has many applications like Confidential. The application Thomson Innovation is running on around more than 50 servers. This application is an interface between the Client and the customers of the client and it mainly deals with Patents information. The application Confidential Pharmacy deals with Health Care and scientific information. All the customers interact with the data center Confidential maintaining by the Confidential by using this application. Thomson Innovation is a single, integrated solution that combines intellectual property, scientific literature, business data and news with analytic, collaboration and alerting tools in a robust platform..
• Confidential is one of the largest companies which maintain Patents related information for the clients. It has around 1500 applications related to Patents, Pharmacy and Life Sciences

Responsibilities:

• Production Support for Live Deployments
• Involved in Performance Tuning and Bug Fixing.
• Written Procedures, Packages, Collections and Triggers with PL/SQL.
• Involved in environment set up, starting up the database, for Production, Staging, Spring and QA environments

Environment: Oracle 10g, Flat Files, CSV Files, TOAD and UNIX AIX , MS Visio

Confidential

Role: PL/SQL Developer

Project Description: The Confidential Application has been developed to maintain and enhance the functionality of the existing application, which handles products of type Customer Premises Equipment and its Items. This includes the functionality of adapting the products supplied by different suppliers configure the products, mange different prices and exposing the product details to other consuming systems...Confidential is one of the largest Telecom Company in Confidential. This projects deals with BT product inventory.

Responsibilities:

• Production Support for Live Deployments
• Involved in Performance Tuning and Bug Fixing.
• Written Procedures, Packages, Collections and Triggers with PL/SQL.
• Involved in environment set up, starting up the database, for Production, Staging, Spring and QA environments

Environment: Oracle 10g, Flat Files, CSV Files, TOAD and UNIX AIX , MS Visio

Confidential

Role: PL/SQL Developer

Project Description: Rationalizes the Product building process in one application, this includes moving the functionalities and features of a Traditional Remedy application to web based interface with more user friendly operations. This handles Products of type, Network Services and Value Added Services. The application includes the features of product building and rules for the products...Confidential is one of the largest Telecom Company in Confidential. This projects deals with BT product inventory.

Responsibilities:

• Production Support for Live Deployments
• Involved in Performance Tuning and Bug Fixing.
• Written Procedures, Packages, Collections and Triggers with PL/SQL.
• Involved in environment set up, starting up the database, for Production, Staging, Spring and QA environments

Environment: Oracle 10g, Flat Files, CSV Files, TOAD and UNIX AIX , MS Visio

Confidential

Role: PL/SQL Developer

Project Description: Work Involves in providing intranet web application, All in one Case Tracker, Which keep track of all calls handled by Technician who takes calls, Creating emulators for Routers which are supported by Vonage, Pulling the data from database using Oracle 9i , Generating Reports for Technician calls, Generating SSQA Reports for Team Leads and Team Manager Daily. Developed internal trackers for E-mail, Level-2, Customer-Support and Technical-Support...Confidential is one of the largest Confidential. This projects deals with internal website of VonageConfidential.

Responsibilities:

• Production Support for Live Deployments
• Involved in Performance Tuning and Bug Fixing.
• Written Procedures, Packages, Collections and Triggers with PL/SQL.
• Involved in environment set up, starting up the database, for Production, Staging, Spring and QA environments

Environment: Oracle 10g, Flat Files, CSV Files, TOAD and UNIX AIX , MS Visio

Confidential

Role: PL/SQL Developer

Project Description: Work Involves in providing intranet web application, All in one Case Tracker, Which keep track of all calls handled by Technician who takes calls, Creating emulators for Routers which are supported by Confidential, Pulling the data from database using Oracle 9i , Generating Reports for Technician calls, Generating Confidential Reports for Team Leads and Team Manager Daily. Developed Task Tracker Site for E-mail, Level-2, Customer-Support and Technical-Support Technicians...Confidential also deals with VOIP and Broadband Internet connection in US..

Responsibilities:

• Production Support for Live Deployments
• Involved in Performance Tuning and Bug Fixing.
• Written Procedures, Packages, Collections and Triggers with PL/SQL.
• Involved in environment set up, starting up the database, for Production, Staging, Spring and QA environments

Environment: Oracle 10g, Flat Files, CSV Files, TOAD and UNIX AIX , MS Visio