IT professional with exceptional Data Warehouse, Database, Business Intelligence experience having 9 years of experience in Software Development Life Cycle. • High analytical and verbal skills • Sound Understanding of Data warehousing concepts • Problem solving and decision making capabilities, recognized by associates for quality of data, alternative solutions and confident, accurate, decision making • Around 8 years of Technical and Functional experience in Decision Support Systems - Data warehousing implementing ETL Informatica Power Center v9x • An year experience in UNIX and DOS shell scripting.
Client-focused • Self-directed • Deadline-driven • Proficient - Communication and Technical skills, Interpersonal relations • Smart worker • Result-oriented as an individual or in team • Adaptable to new Concepts and Ideas • Flexible • Excellent decision making skills with a positive approach • Dedicated and highly ambitious to achieve personal goals as well as the organizational goals.
Data Warehouse Proficiency
Data Modeling • Loading and Unloading Data from the Data warehouse Tables • Hands-on with SQL queries • Best practices • System & Delivery process • Hands-on DWH Tuning, Testing, Schemas and Data Marts.
Informatica PowerCenter Proficiency
Extensive experience in ETL (Informatica) development using Oracle, Flat Files as both Sources and Targets • Experience in Informatica 8.6 using components such as Mapping Designer, different types of Transformations such as (Source Qualifier, Filter, Aggregation, Router, Update Strategy, Lookup, etc.) • Experienced in creating Reusable Sessions, Mapplets, Transformations and Worklets • Proficient in using Informatica Workflow Manager, Workflow monitor to create, schedule and control Workflows, Tasks, and Sessions • Testing and Debugging of Informatica Mappings, Mapplets, Sessions, Tasks, Worklets and Workflows. • Well acquainted with Performance Tuning of sources, targets, mapping transformations and sessions to overcome the bottlenecks in mappings. • Strong analytical and conceptual skills in database design and implementation of RDBMS concepts. • Experienced in Oracle database development using PL/SQL.
Extensive experience in ETL INFORMATICA POWERCENTER (Informatica) development using Oracle, Flat Files as both Sources and Targets * Experience in Informatica 8.6 using components such as Mapping Designer, different types of Transformations such as (Source Qualifier, Filter, Aggregation, Router, Update Strategy, Lookup, etc.) * Experienced in creating Reusable Sessions, Mapplets, Transformations and Worklets * Proficient in using Informatica Workflow Manager, Workflow monitor to create, schedule and control Workflows, Tasks, and Sessions * Testing and Debugging of Informatica Mappings, Mapplets, Sessions, Tasks, Worklets and Workflows * Well acquainted with Performance Tuning of sources, targets, mapping transformations and sessions to overcome the bottlenecks in mappings * Strong analytical and conceptual skills in database design and implementation of RDBMS concepts * Experienced in Oracle database development using PL/SQL. ETL Tools *Informatica Power Center v8.6/v9x
Scripting Language *UNIX Shell Scripting
DOS Batch Scripting.
Programming Languages *SQL / PL/SQL.
Database Tools *Oracle Database Developer
SQL Server 2005/2012/2014
Other Tools / Packages *Web FOCUS v7.1
Win SCP, MS Visio, MS Office, Tivoli Workload Scheduler (TWS), Ultra Edit, Notepad++, Control-M Scheduler, TFS.
PL/SQL, ETL, Dimensional Modeling, Oracle 10g/11g, Erwin Data Modeler.
Data warehousing design and Physical/Logical Data Modeling, Star Schema and Snow Flake Schema * Loading and Unloading Data from the Data warehouse Tables * Experience working with SQL queries * Well versed with Unix Shell Scripting.
West Bend Mutual InsuranceWest Bend, WIProject Description
Bundle5 is a small project that fixes defects, minor and major enhancements for different Line of Business like Personal Insurance, Commercial Insurance and Workers Comp.
Designed to move data from the Policy Management System (PMS), Policy Administration System (PAS), Claims Management System (CMS) and Duck Creek source system to SQL Server and Produce reports through Business Objects to Customers and End Users.
Roles & Responsibilities Lead a small team of 4 developers through the Software Development Life Cycle.
Managed peer reviews.
Performed ETL Informatica Code Review.
Work as a Technical Lead for couple of work stream - PMS.
PAS, CMS and Duck Creek.
Managed time and resource to get the task to completion.
Work closely with business to get the business requirement.
Performed the design needed for ETL front and BI side.
Environment: Informatica v9.1 as ETL, SQL Server 2012 as Database, Control-M Scheduler, Notepad++ for Comparing data, WINSCP as UNIX Box, MS Visual Studio 2014 as TFS, MS Visio, Word and Excel.
General ElectricFairfield, CTProject DescriptionDesign Data Model and Perform Impact Analysis using Informatica tool for ETL Load and Oracle.Led a group of 3 developers through the Software Development Life Cycle.Converted the Requirement document to a high level requirement document for the developers to code.Helped developers to build ETL mapping and perform end-to-end testing of Data warehouse/Data Mart load. Mainly worked on developing stored procedure using the Oracle 10g PL/SQL language for reporting. Improved the performance of the application by rewriting the SQL queries.Creation of database objects like tables, views, procedures using oracle tools like Toad, PL/SQL Developer and SQL* plus.Modified and tested stored procedures written in Oracle PL/SQL in support of migration effort. Worked in embedded SQL calling Oracle PL/SQL 8.0.6 procedures and Informatica mappings in Batch scripts.Involved in preparation of UTC and performed various Administration tasks, Tuning of Queries. Highly involved in solving the different production issues, working with the other teams. Also worked in Tivoli Workload Scheduler to schedule the jobs for nightly batch cycle.Worked on enhancement of the existing mappings and tuning them for better performance.
Education and Training
Bachelor of Engineering:Computer Science & EngineeringSATHYABAMA UNIVERSITY, Chennai, Tamil Nadu, IndiaGPA: First Class with DistinctionComputer Science & Engineering First Class with Distinction