SUMMARY:

• Over 8.5 years of IT experience in Data warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse
• 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 Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD andSQL*LOADER.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Extensive experience with Oracle 11g or higher Relational Database Management Systems (RDBMS)
• Worked in Agile Environment as an Oracle Developer
• Expert level of experience in tuning Oracle database and database objects for performance while working with large dataset
• Deep knowledge of Unix scripting and Oracle Forms 3 Tier environment
• Extensive experience with Oracle Forms and Reports Development
• 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 HINT
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Experienced in development of ETL mapping and scripts.
• Experienced with Batch systems scheduling using Autosys and processing.
• Experienced working with offshore vendors and establishing offshore teams and processes.
• Excellent team player with an ability to perform individually, good interpersonal and analytical skills
• Exposed to banking & Insurance domain.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, .Net,C,C++,PROC

Databases: Oracle 11g/10g/9i/8i, teradata, SQL

Data Warehouse: Informatica power center, Data modeling, IBM InfoSphere 8.5

Scripting: UNIX shell scripting using KSH, AWK and RHEL

GUI: Toad, Ultra Edit, Tech10,ACT tool

Scheduling Tool: Autosys

Versioning Tools: PVCS, Subversion

Reporting Tools: Oracle Reports 2.5, Business Objects Developer Suite 5.1/BO XIR2

Environment: Citrix

Operating Systems: Windows 10/ XP/Vista, Unix / Linux

PROFESSIONAL EXPERIENCE:

Confidential

I.T. Analyst

• Worked closely with Project Team, SME and Internal Business Patners (IPs) to clarify business requirements and translate the requirements into technical specifications.
• Assisted Project Manager in scope estimation and work breakdown structure (WBS) to meet Project Milestone.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Perform Maintenance, including managing Space, Remove Bad Files, Remove Cache Files and monitoring services.
• Involved in creating shell scripting to sending a metrics about the policy details on monthly basis
• Translated business requirements and software design specifications into Oracle Forms applications.
• Creating shell script to exuecte the procedures automatically for automate process
• Created database objects for the system like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and adding bulk collect process to rectifying performance bottlenecks.
• Analyzed Autosys job flows and created JIL's for data validation process such as pre and post load SQL checks.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Coordinated with execution team to define the batch flow for data validation process.
• Maintaining Versions of Components using Subversion tool.
• Worked closely with the QA team to ensure the test cases are meeting the requirements documented.

Confidential, Hartford, CT

Lead ETL developer

• Involved with the Business analysts in requirements gathering and data mapping.
• Assisted in the design of an efficient reliable ETL mechanism for the creation of the Rating Data Store data mart.
• Prepared Impact Analysis and Design Specifications for ETL Coding and mapping standards.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
• Coordinated with offshore vendor and established offshore teams and processes for code development.
• Creating shell script to exuecte the procedures automatically for automate process
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILEpackage.
• Extensively performed unit testing and coordinated functional testing.
• Worked in Autosys for creating Jil scripts to schedule ETL jobs.
• Involved in Developing the ETL Components in the Exadata environment based on the requirements given.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools likeToad, PL/SQL Developer and SQL* plus.
• Involved in project activities such as preparing the component inventory, impact analysis, build, implementation, integration, and testing the components.
• Integrating the various components and verifying the unit test results and system test results.
• Automated the Informatica jobs using UNIX shell scripting
• Maintaining Versions of Components using Subversion tool.
• Regular communication with clients on various aspects.

Confidential, Hartford, CT

ETL developer

• Involving in project activities from preparing the component inventory, impact analysis, build, implementation, integrating, and testing the components.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time
• Involved in tuning the PL/SQL code according to Exadata standards for better performance of the application. Ex: Modifying FOR loop into BULK COLLECT and replacing update to merge statement.
• Creating shell script to exuecte the procedures automatically for automate process
• Integrating the various components and verifying the unit test results and system test results.
• Responsible for preparing and sending the release plan for various releases.
• Coordinating with Onsite support team for client side resolution.
• Interaction with migration team and tracking the progress and documenting.
• Reporting to Offshore and Onsite Project Manager regarding the progress of the Project

Confidential,Hartford, CT

ETL developer

• Understanding the existing ETL code and identifying equivalent component in the new architecture
• Involved in Developing the ETL Components in the Exadata environment
• Designed architecture for the Informatica Workflows to Migrate the 4TB of history data
• Worked closely with Maintenance & Invest team for the retrofit changes
• Responsible for preparing migration strategy document.
• Integrating the various components and verifying the unit test results and system test results.
• Addressing Issues and Maintaining the History of Defect logs with proper resolutions
• Maintaining Versions of Components using PVCS tool.
• Responsible for preparing and sending the release plan for various releases.
• Designed Source to Target mappings to extract data from heterogeneous sources such as Oracle and Mainframe files as source and load it to the target tables.
• Worked with various transformations such as Lookup, Aggregator, Expression, Normalizer, Joiner, Router, Filter, Update Strategy, and Sequence Generator.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance
• Extensively performed unit testing and coordinate for system testing and functional testing.
• Worked in Autosys for creating Jil scripts to schedule ETL jobs daily, weekly, monthly and quarterly.

Confidential

ETL developer

• Involving in project activities from preparing the component inventory, impact analysis, build, implementation, integrating, and testing the components.
• Addressing Issues and Maintaining the History of Defect logs with proper resolutions
• Maintaining Versions of Components using Subversion tool.
• Worked closely with the QA team to ensure the test cases are meeting the requirements documented.
• Regular communication with clients on various aspects.

Confidential developer

• Involving in project activities from preparing the component inventory, impact analysis, build, implementation, integrating, and testing the components.
• Addressing Issues and Maintaining the History of Defect logs with proper resolutions
• Maintaining Versions of Components using Subversion tool.
• Worked closely with the QA team to ensure the test cases are meeting the requirements documented.
• Regular communication with clients on various aspects.

Confidential

• Resolving user issues within given time limit without any escalation and framing complex sql queries based on the user requirements.
• Addressing Issues and Maintaining the History of Defect logs with proper resolutions
• Regular communication with clients on various aspects.