SUMMARY

• Around 11+ Years of experience in supporting and providing reporting solutions for Health Care, Financial, E - commerce, Banking, Manufacturing industries.
• Over 9+ years of experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experience using Informatica PowerCenter 10.x,9.x,8.x.
• Have knowledge and experience on SOX compliance documentations and Release Management activities.
• Extensive experience in developing complex mappings.
• Strong understanding in the Analysis, Design, Development, testing and Implementation of Data Warehouse Applications. Well versed with Star-Schema & Snowflake schemas for designing the Data Marts. Worked on database like Oracle 9i/10g/11g/12c,Teradata, SQL server 2008 R2.
• Knowledge of programming languages like PL/SQL, SQL
• Expertise over preparing report specifications, database designs to support the reporting requirements.
• Active team player and as an individual with excellent communication, interpersonal skills, self-motivated fast learner, and good listener.
• Experienced in Microsoft Visual Studio 2010.
• Experienced on working with Flat files, XML files and COBOL files from Source to Target.
• Experienced in using Workflow Administrator and Workflow Monitor
• Worked with various SQL Editors such as TOAD, SQL Plus, Hive and Impala.
• Developed multiple Stored Procedures and Triggers, formulated Backup/Recovery strategies, Optimizing Query Plan, Performance Tuning.
• Extensive Experience in drawing Data Flow Diagrams/Process Diagrams.
• Strong analytical, logical, and problem-solving skills and ability to quickly adapt to new technologies by self-learning.
• Flexible, enthusiastic, and project-oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS

Data Warehousing/ Data Migration - ETL Tools: Informatica PowerCenter/PowerMart 10.0, 9.6.1/9.5.1/9.1.1/9.0.1/8.6.1/8.1/8.0 , Informatica Power Analyzer, Power Exchange, Informatica Cloud, Kalido DIW, Kalido MDM, Informatica Cloud, SQL Server 2014, Oracle 11g, Lavastorm, QlikView 12.

Tools: SQL Developer (TOAD, Management studio 2008 R2), PL/SQL Developer, JIRA (Project tasks’-status tracking tool), MATT (Specs generating tool), Microsoft Visual Studio 2010, DIS Scheduler, Tivoli Scheduler, Putty, Tableau, IRIS ticketing tool, Hiperos, Impala

Languages: SQL, PL/SQL, T-SQL, SQL*Plus 3.3, C, C++, HTML, Unix Shell Scripting

Databases: Oracle 11g/10g/9i/8i, Teradata, SQL Server 2008 R 2 /2005/2000.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Informatica Developer/Bundle Lead

Responsibilities:

• Responsible for managing Datawarehouse applications support and enhancement activities
• Responsible for reviewing effort estimations and share it with stakeholders
• Responsible for operational efficiencies in support project including handling system downtime, outages, and windows patch updates, quarterly outage, etc.
• Responsible for escalation and resolution of issues and handle proactive communication with latest status
• Prepare weekly/monthly/quarterly reports, SLA metrics reports, dashboard reports, application performance reports, and decision-making for support/change request/application access activities.
• Collaborate with different source teams, infrastructure team, vendor teams to achieve faster resolution
• Responsible to identify different improvement areas and innovations to minimize the manual efforts, automate the activities
• Supporting Informatica ETL/Informatica Cloud based applications across DW OUS applications
• Handled project solution delivery by coordinating with customer, partner, and internal team to assure successful implementations on Dynatrace tool
• Conducting internal and customer interacting Weekly project calls.
• Supporting the Informatica Development team on issues and provided the technical solutions in Power Center/Informatica Cloud.
• Involved with the team to analyze the Incidents trend and follow up for any backlog tickets on daily basis to resolve with in the define SLA.
• Analyzed the production Incidents in IRIS ticketing system to understand and drill down the requirement for appropriate solutions.
• Organizing and representing various Weekly/Monthly/Quarterly status report deck’s to Business, to explain the applications nature and behavior.
• Participated in Design solution of a new project for Enterprise Data Warehouse and participated in SOW creation.
• Involved in MIM Calls and Protocols associated with P1/P2 Incidents, Executive Summary for critical issues.

Confidential, Tampa, FL

Sr.Informatica Developer/Bundle Lead

Responsibilities:

• Supporting Informatica ETL based applications across ARM BI CoE portfolio.
• Handling project solution delivery by coordinating with customer, partner, and internal team to assure successful implementations on Informatica Products (Power Center and Informatica Cloud).
• Conducting internal and customer interacting Weekly project calls.
• Supporting the Informatica Development team on issues and provided the technical solutions in Power Center/Informatica Cloud.
• Involved with the team to analyze the Incidents trend and follow up for any backlog tickets on daily basis to resolve with in the define SLA.
• Analyzed the production Incidents in IRIS ticketing system to understand and drill down the requirement for appropriate solutions.
• Organizing and representing various Weekly/Monthly/Quarterly status report deck’s to Business, to explain the applications nature and behavior.
• Participated in Design solution of a new project for Enterprise Data Warehouse and participated in SOW creation.
• Involved in MIM Calls and Protocols associated with P1/P2 Incidents, Executive Summary for critical issues.

Confidential

Sr ETL Developer/ Bundle Lead

Responsibilities:

• Handled the knowledge transition phase for 6 applications.
• Supported SaaS based application like Prizma, Totality and EPIC Hiperos
• Participated with senior management for strategy development and execution planning.
• Coordinated with team to analyze the Incidents trend and follow up for any backlog tickets on daily basis to resolve with in the define SLA.
• Analyzed the production Incidents in IRIS ticketing system to understand and drill down the requirement for appropriate solutions.
• Preformed Data migration for EPIC Hiperos system from Old system to New system for 16000+ JnJ Global users.
• Supported Hadoop application using hive and Impala. Jobs are scheduled in Tidal scheduler.
• Created and Supported Informatica cloud application jobs, to load data from flat files to Hiperos systems.
• Created Scatterplots, Histogram, BarGraph and Demographic graphs in Tableau to analyze the Incidents trend globally for SaaS applications.

Environment: Informatica 9.6.1, Informatica Cloud, Tidal Scheduler, SAS applications, IRIS, EPIC Hiperos, Tableau, Oracle SQL Developer, Mbox, BigData, Hive, Impala and UNIX.

Confidential, Pleasanton, CA

Sr. Informatica

Responsibilities:

• Manage project deliverables by analyzing functional and non-functional requirements.
• Participated with senior management for strategy development and execution planning.
• Analyzed the production defects raised by business analysts to understand and drill down the requirement for appropriate solutions.
• Managed and organized the SOX Schedule Release management process through Remedy as per Confidential compliance policy.
• As part of SOX release management process create various SOX Control documentation.
• Participated in various migration process like Informatica 8.6.1 to 9.5.1 and UNIX Landing Zone to Linux ZFS Landing Zone.
• Handle 30+ application and made fine-tuned to optimized mappings to reduce ETL run time and ensuring they ran within designated load window.
• Created various management presentation on monthly basis to explain the application nature and behavior.
• Created various adhoc presentation for Kaiser Management depending upon the requirement.
• Participating in all the code reviews and explaining team with all the review comments.
• Tracking the development status and report to the client on daily basis.
• Worked on IBM Rational Team Concert to migration the code from low environment to production
• Coordinating with SIT/UAT team for any user questions and resolve.
• Created multiple INC, WO and CRQ in remedy to track issue with infrastructure groups.
• Excellent Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Environment: Informatica 8.6.1, 9.5.1, 9.6.1, Tivoli Scheduler, IBM rational team concert, Remedy, EPIC, Oracle SQL Developer, and UNIX.