PROFESSIONAL SUMMARY:

• 9+ years of experience working with Oracle SQL and PL/SQL and Informatica Power Center tools such as Informatica Mapping Designer, Repository Manager and Workflow Manager. Have strong business knowledge in the Insurance domain.
• Hands - on experience understanding and working all stages of Software Development Life Cycle (SDLC) in Agile, Water-Fall and Hybrid methodologies. Experience in SDLC includes Requirement gathering, Analysis, Design, Development and Testing.
• Acquired Oracle Certified Associate (OCA) certification. Experience in Performance Tuning, Query Optimization, Indexing, and Normalization.
• Extensive experience in building Informatica Mappings for ETL to load data into staging tables, perform conversion and transformation tasks and generate emails using Shell Scripts and schedule them using Autosys jobs.
• Expert level of experience in tuning Oracle database and database objects for performance while working with large dataset
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Excellent knowledge in Oracle SQL and PL/SQL queries and packages and defining objects like Tables, Stored Procedures, Views, Indexes, Triggers and functions.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINT
• Experience in Project Management activities such as Resource planning and Effort Estimation.
• Passionate and highly-motivated professional with excellent analytical and troubleshooting skills. Ability to work on multiple tasks in a fast-paced environment independently or as part of a team to accomplish critical business objectives.
• Well versed in Autosys JIL Scripts (Job Information Language).
• Strong communication, analytical and problem-solving skills exhibited by working closely with key players to identify business problems and system solutions.
• Exposure to Data Modelling, Data Mapping and Erwin tool.
• Working in the Insurance domain and acquired INS 21, INS22, INS 23 and ETHICS certification. Certified Associate in General Insurance (AINS) provided by the Institutes (American Institute for Chartered Property Casualty Underwriters
• Part of the Centre of Excellence team within the account whose responsibilities include suggesting best practices and focusing on emerging technologies like Big Data and Hadoop.

TECHNICAL SKILLS:

Data Warehousing: Toad, SQL*Plus, SQL*Loader, SQL, PL/SQL, Informatica Power Center 10.2/9.1/8.6.1/8.1.1/8.0/, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, Datamart, OLAP, OLTP, Mapplet, Transformations.

Big Data Ecosystems: Hadoop, Hive, Sqoop

Databases: Oracle 12/11g//9i/8i/8.0/7.0, IBM DB2, MS SQL Server 2005/ 2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, MS Access.

Programming GUI: Visual Basic 6.0/5.0, C, C++, HTML, Unix Shell Scripting

Environment: Sun Solaris 2.6/2.7/2.8/8.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT, Red Hat Linux, Win XP.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5.5/3.5.2

Business Objects: 6.5/6.0/5.x, Oracle Reports 9i, Cognos Series 7.0/6.0

Development Tools: TOAD 12, Visio, Eclipse, Tortoise SVN, Putty, HP Quality Center

Execution Methodologies: Waterfall, Agile

Languages: Oracle PL/SQL, Informatica Power center, Linux, ETL Development, Teradata, Hadoop (Python),Hive,Spark, Proc ( C ++)

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Technical Lead / Lead Developer

Responsibilities:

• Involved in the Project startup phases such as Resourceplanning and effort estimation using the Delphi estimation template
• Assisted Project Manager in scope estimation and work breakdown structure (WBS) to meet Project Milestone
• Involved with the Business analysts and other department heads in requirements gathering requirements from and prepared theTechnical Specification Document in line with each Business Requirement Document (BRD) and Functional Specification Document (FSD).
• Involved with the Data Modelers in extensive review of the mapping documents.
• Analyzed both physical as well as the logical data models prepared by the Data Modeler using the Erwin tool.
• Worked Extensively on Informatica tools such as Repository Manager,Mapping Designer, Workflow Manager and Workflow Monitor.
• Strong knowledge of Dimensional modelling concepts likeStar Schema, Snow Flake Schema, Dimension and Fact table
• Designed Source to Target mappings to extract data from heterogeneous sources such as Oracle Tables, Flat files and SQL server as source and load it to the targettables.
• Worked with various Informatica transformations such as Lookup, Aggregator, Expression, Normalizer, Joiner, Router, Filter, Update Strategy, and Sequence Generator.
• Performed tuning of Informatica Mappings and sessions to get optimum performance.
• Used InformaticaWorkflow monitor to monitor tasks, workflows and also to monitor performance.
• Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy
• Involved in creating shell scripting to sending a metrics about the policy details on monthly basis
• 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
• Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.
• Used different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues.
• Creating shell script to execute 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.
• Maintaining Versions of Components using Subversion tool.
• Worked closely with the QA team to ensure the test cases are meeting the requirements documented.

Environment: PL/SQL, UNIX, shell script, Autosys, Oracle 11g Exadata, SQL* Plu, TOAD, Tortoise SVN, Workload Control Center, Ultra Edit, Erwin, Hadoop, Informatica

Confidential, Hartford, CT

Technical Lead / Lead Developer

Responsibilities:

• 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.
• Developed Oracle procedures, Packages, Functions, Triggers using SQL and PL/SQLto pull data from various source environments to the application in the desired format that can blend in the customized framework.
• Involved in Performance tuning - analyzing complex SQL statements and determining the most efficient way to improve query performance.
• Created various indexessuch as B-Tree and Bitmap on the tables for faster retrieval of the data to enhance database performance.
• Developed materialized views for data replication in distributed environments.
• Partitioned large Tables using range partition technique.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Migrated more than 110 applications spanning 4 TB of Data from Oracle 10g to 11g.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions.
• Extensively involved in using Oracle hintsand Explain Plan to direct the optimizer to choose an optimum query execution plan
• 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.

Environment: PL/SQL, UNIX, shell script, Autosys, Oracle 11g Exadata, SQL* Plus, TOAD, Tortoise SVN, Workload Control Center, Ultra Edit, Erwin, Informatica Power center

Confidential, Hartford, CT

Technical Lead / Lead Developer

Responsibilities:

• 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
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• 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
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• 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

Environment: PL/SQL, UNIX, shell script, Autosys, Oracle 11g Exadata, SQL* Plus, TOAD, Tortoise SVN, Workload Control Center, Ultra Edit, Erwin, Informatica Power center

Confidential, Hartford, CT

Technical Lead / Lead Developer

Responsibilities:

• 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.

Environment: PL/SQL, UNIX, shell script, Autosys, Oracle 11g Exadata, SQL* Plus, TOAD, Tortoise SVN, Workload Control Center, Ultra Edit, Erwin, Informatica Power center

Confidential

Lead Developer

Responsibilities:

• 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

Lead Developer

Responsibilities:

• 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

Lead Developer

Responsibilities:

• 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.