SUMMARY

• Over 8 years of cross - cultural experience in areas of Requirements gathering, Development Process, Technical consultancy, Client management, Team building, Project execution and Quality management
• Experienced in Oracle PL/SQL, Data stage, Oracle Apps Technical with good knowledge in DBMS and RDBMS concepts.
• Experience in Data warehousing and OLAP/OLTP systems with huge volume of daily data.
• Experience in data transfer utilities like SQL*loader, Data pump and import/export.
• Strong programming skills with development experience in creating store procedures, PL/SQL Packages, Views, Triggers, Functions including Oracle Cursor management and Exception Handling
• Insightful problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to higher customer satisfaction and support activities.
• Implemented number process improvement and performance tuning strategies for cost reduction.
• Strong leadership skills with experience in managing teams while working closely with multiple projects.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to higher customer satisfaction
• Significant experience working with client, project managers and technical teams for securing and executing concurrent projects.
• Client certified subject matter expert(SME) in DataMarts and other business processing applications.
• Worked on building data marts and Cognos Cubes for various business requirements.
• Process Improvement and Query Tuning along with optimization using explain plan.
• Good knowledge in DB import and export and DA maintenance activities.
• Developing functions and Procedures for PL/SQL Packages considering reusability approach.
• Experience on working on UNIX and SAS environments and developed shell scripts for job processing.
• Created Custom Pages and included in customizing standard pages in Oracle Application Framework.
• Extending technical directions, constituting a technical gateway between Project Manager and Developers.
• Designing & developing proof of concepts and durable architectures.
• Migration of existing architecture including database up-gradation.
• Undertaking technological evangelization, visualizing the need for the design approach.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database
• Developed UNIX Shell Scripts to automate DBA activities and notification processes.

TECHNICAL SKILLS

Database: Oracle 10g/11g, Sybase, DB2

Reporting Tools: Qlikview, Cognos BI

ETL Tools: Data stage, Third party ETL tools, Custom Oracle Packages, SQL Loader

Languages: SQL, PL/SQL, C, Java

Versioning Software: Win CVS, SVN Tortoise

Data Modeling: XML Publisher

Operating Software: UNIX/LINUX, Windows 8/7/XP/2000

Web Design: JavaScript, CSS, HTML

Others: SQL*Plus, PL/SQL Developer, TOAD, MS Office Applications, JDeveloper

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in enhancement of Oracle Procedures and Packages for ETL Processing within the TED Database.
• Involved in development of customized tools for internal process such as Shift Handover Application, Cost Changes Application, and Customer Upload Processing which are reusable components.
• Good Experience in advanced PL/SQL concepts and architecture upgrades within data warehouse.
• Proposed and implemented multiple process / performance improvement projects for the client as part TEOA Initiative (Process improvement program at Client).
• Developed custom OAF pages and implemented search and DML operations.
• Debugging of standard OAF pages in order to embed customizations.
• Good Experience in implementation of configuration, extension and integration of OAF pages.
• Analyzing and Fixing Critical data issues were also part of Support Activities.
• Analyze customer data for data integrity and Normal Form standardization
• Develop matching methods to enrich customer data
• Analyze long data processes and streamline for time efficiency
• Part of design team for developing new processes and procedures to maximize process efficiency.
• Refresh schema level and full level production to non-production databases.
• Designed the database schema and create any necessary database objects.
• Formulate optimal application SQL using Grid Control and v$queries.
• Ensured database security is implemented to safeguard the data.
• Performance Tuning of database, SQL tuning for Application
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, Explain Plan.
• Application Database connectivity using ODBC and Oracle Net configuration.
• Created number of UNIX shell scripts for various tasks

Confidential, Hartford, CT

Oracle PL/SQL Developer

Responsibilities:

• Analyzed Internal & External Source systems and Business Requirements to develop Health Insurance Claims Data warehouse LOGICAL AND PHYSICAL MODEL (Facts and Dimensions) and Business Process Model.
• Developed back end interfaces using Tables, PL/SQL packages, stored procedures, functions, Collections, Object types specifically for financial reporting.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems by using Hints, Indexes, Partitioning and analyzing the Stats updates.
• Extensively used the Triggers, Indexes, Views and Materialized Views for the Application design.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Performed subsequent alterations using SQL, PL/SQL to make any changes on ad hoc requirements.
• Implemented Business Rules using PL/SQL Procedure/Packages with complex waterfall calculations.
• Wrote Ad-Hoc SQL queries for data analysis and Testing.
• Developed PL/SQL Procedures, Functions and Packages for Business Intelligence.
• Actively involved in Data Mapping of tables from Source system to Target system, including preparation of Entity Relationship Diagram.
• Generated cubes from the data warehouse for the analysis purposes.
• Normalized and De-normalized entities for the Data Warehouse.
• Involved in Data Extraction, Transformation and Loading (ETL process) from source to target and worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Worked on Production support for the backend database and reporting applications.
• Involved in importing Source Tables from the different databases.
• Worked on UNIX SAS for processing the data from datasets.
• FTP process is extensively used to send and receive the flat files.
• Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
• Involved in continuous enhancement, optimization and fixing of problems.
• Provided technical support to the user with regard to operational aspects.

Confidential, NY

ETL / Datastage Developer

Responsibilities:

• Created database objects like Tables, Views, Sequences, Synonyms, Packages, and Cursors as per the business requirements.
• Worked on different types of indexes and also used features like Bulk Collect for better performance.
• Involved on Data stage jobs creation using multiple transformation for processing data from different source types.
• Involved in all the phases of building the data marts like analyzing the business requirements, Technical specifications, ETL process design, performance enhancement and maintenance
• Extensively worked on Data Stage 8.1 Designer, Director, and Manager.
• Extracted data from various source systems like Oracle, Mainframes and Flat Files.
• Extensively used DataStage Designer to design, develop ETL jobs for extracting, transforming and loading the data into different data marts.
• Used various stages like Aggregator, Sort, Transformer and Sequential file.
• Implemented the Functional requirement of the Cash Flow and off market reports for better product control.
• Performed Import and Export of DataStage components and table definitions using DataStage Manager.
• Implemented enhancements to the current ETL programs based on the new requirements.
• Performed Unit Testing, Parallel testing, Integration Testing and User Acceptance Testing (UAT) for every code change and enhancement.
• Responsible for starting and stopping DataStage server during maintenances window.
• Extensively involved in DataStage admin tasks like creating projects, setting project level tunable and project level environment variables.
• Worked on improving the performance of the designed jobs by using various performance tuning strategies.
• Extensively involved in the data migration team to build the Re-usable DataStage job templates, common parameter sets, common DataStage job containers, SQL extract procedures and common re-usable shell scripts.
• Created Shell scripts, which will invoke Data Stage jobs passing all variables to job to execute like Source and target databases connection information, user id, password and others, file locations.

Confidential

Software Developer

Responsibilities:

• Involved in designing the data and business layer for the web based products and has created multiple packages.
• Involved in creating forms and application pages to collect data for processing to information.
• Performed support activities which included, data validation, process load testing and maintenance, export and import of the data and backups and also part of debugging issues with the data base.
• Developed multiple packages and procedures to load the data from various sources and process to the target tables.
• Created materialized views and informational views for complex drill down layer processing of data.
• Worked on creating UNIX shell scripts and control file scripts to load the flat file data to the staging area for processing.