SUMMARY:

• Starting with the last project, list the Areas and Applications handled in different projects. Do not mention the year.
• 10 years of IT experience in Data Analysis, Design, Development, Implementation, Testing, Support of Data warehouse and Data Integration Solutions using Informatica Powercenter 8x and 9x, scheduler tools like Redwood and data quality tools like IDQ
• Strong Data Warehousing ETL experience of using Informatica 9.6/9.5/9.1/8.6.1/8.1 Power Centre Client tools
• Expertise in working with relational databases such as Oracle 11g/10g/9i and SQL Server 2008
• Experienced in 24/7 On - call support for production environments.
• Created automated scripts for admin related activities, repository clean-up and code review.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
• Experience in Performance Tuning and Debugging of existing ETL processes
• Extensive Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Expertise in understanding the business rules based on High Level document specifications and implementation of the data transformation methodologies.
• Conducted multiple PoC's for the ETL application teams for Informatica
• Experience with dimensional modeling using star schema and snowflake models
• Worked across various verticals ranging from Finance, Energy and Industry and Telecommunication
• Independently perform complex troubleshooting, root-cause analysis and solution development
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills

TECHNICAL SPECIFICATIONS:

ETL TOOL: Informatica 8X and 9X versions, SAP BODS

DATABASES: Oracle9i/10g/11g, Microsoft SQL Server 2008, Teradata.

PROGRAMMING LANGUAGES: UNIX Shell Scripting, SQL

SCHEDULING TOOLS: Redwood

ENVIRONMENT: Windows XP/2000, Linux

OTHER SOFTWARE: Toad, Putty, WinScp, SQL Developer

OTHER APPLICATION: HP Quality Center 9/10, Citrix

PROFESSIONAL EXPERIENCE:

Confidential

Tech Lead, Tempe, Arizona

Responsibilities:

• Onsite Lead of 3 in USA and 14 in offshore - India
• Lead all deliverables from offshore & Onsite
• Prepare weekly status report and other documents required for the client meetings to explain the status of the project.
• Good Knowledge on SAP BODS used as ETL & Redwood used as Scheduler for providing support and maintenance.
• Identify deficiencies in critical processes, understand dependencies and manual interventions.
• Troubleshoot various ETL issues on a real time production environment and engage L3 support or database administrators for quick recoveries.

Technology: SAP BODS, Redwood, Oracle 11g, Windows

Confidential

ETL Lead, Atlanta, Georgia

Responsibilities:

• Lead a team of 4 in Atlanta,USA while constantly working on quarterly releases of COX internet programs.
• Lead a team of 4 in data analytics using informatica IDQ tool.
• Lead offshore team of 15 working 24*7 shifts in Hyderabad India office of Confidential .
• Lead a team of 4 in OBIEEE reporting which maintains production access in OBIEE environment and helps in generating customer reports on a daily basis.
• Guide our L3 support to build a robust ETL and OBIEE environment needed for UBB project.
• Call out direct meetings with Cox business and vertical leads to discuss and plan out multiple strategies in this new set up.
• To maintain our development partners, database administrators and offshore India team on the same page with the customer requirements and decisions.
• Troubleshoot various ETL issues on a real time production environment and engage L3 support or database administrators for quick recoveries.

Technology: Informatica 9X, OBIEE, Oracle 10g, UNIX

Confidential

Sr. Software Engineer, Atlanta, Georgia

Responsibilities:

• Created mapping for the proper functioning of the EM system and IBS system integration and daily BUC codes transfer from IBS to EM System
• Concerned for monitoring of failure due to any one of the source system is down then Informatica will log the error and TSG BDMD Ops will update the same to teams responsible.
• In case of session failure due to database connectivity or network issues, the failed session will be directed to a failure path where we can handle the error accordingly.
• Always actively maintained workflow logs generated during each run even if there is no failure to have a detailed record of its daily proper functioning.
• Created email task to notify error handling admin teams in case of failure.
• Responsible for the proper functioning of all the objects created in the workflow.

Technology: Informatica 8X, Oracle 10g, UNIX

Confidential

ETL Developer, Cincinnati, Ohio

Responsibilities:

• Worked as a primary resource for upgrading the project from Infa 8.1 to infa8.6.
• Working as an Administrator in Informatica and Business Object tools.
• Have hands on experience in all the four aspects in Informatica viz Designer, Repository Manager, Workflow Manager and Monitor
• Thorough maintenance and Admin related activities in Development, Quality Analysis and Production environments.
• Loading data and monitoring the run using Informatica tool.
• Extracting and maintaining daily reports using Business Objects tool.
• Maintenance of server used for the databases

Technology: Informatica 8X, Business Objects, Oracle 9i, UNIX