Other Details

Total Years of Experience – 5.5 yrs

TRAINED on 8.5+ ADMINISTRATION by INFORMATICA.

Informatica Certified Administrator on 8.6.x in MAR-10.

Has been Twice rewarded as Best Employee Award (SPOT Award).

Currently Located at Richardson, Texas working as an Lead Informatica Administrator for a Leading Telecom Organization.

Also have about 3+ years with HEALTH CARE Domain (Confidential), 2+ Yrs with Manufacturing Domain (Confidential) and 6 months with Entertainment Organization (Confidential.).

Education

• B.E in Information Technology

Profile

A result-oriented, determined and dynamic INFORMATICA ADMINSTRATOR having more than 5 years experience in US in Datawarehouse design and development using state of the art technologies such as Informatica, DataFlux, Oracle 10g. Have excellent problem-solving and proven mentoring skills.

Experience of direct client liaison, offshore-onsite model, business/systems analysis, proven communication skills and sound understanding of ETL and Business Intelligence have enabled me to successfully deliver projects in optimal time with adaptability to work under pressure in both small and large team environments.

Technical Skills

Operating Systems

UNIX, Windows

Languages

SQL, PL/SQL, UNIX Shell Scripting, perl

Databases

Oracle, MS-SQL Server

Development Tool

SQL Developer, TOAD.

Data warehousing Tools

Informatica Power Center ( ADMINISTRATION), DataFlux, COMPOSITE SOFTWARE

Source Control

Visual Source Safe

Ticketing Tools

ISM, Peregrine

Profession Skills

• Expertise in Disaster Recovery (DR) of Informatica components.
• Expertise in Upgrading of Informatica 7.1.4 to 8.1.1, 8.1.1 to 8.6.1 and Recently upgraded 8.6.1 to INFA 9.1.0.
• Expertise in Automating the Deployments / Code Promotions and Informatica usage processess.
• Define standards and Processes to be followed by ETL technical Teams.
• Help ETL Teams to optimize their Jobs and tools to gain efficiency and functionality.
• Good understanding in Dimensional Modeling, Star Schema and Snow Flake Schema methodologies.
• Complete SDLC experience from Requirements analysis, Design, Development, Quality Assurance to Deployment
• Team development and mentoring
• Presenting to peers, clients and third parties
• Providing internal training and knowledge-transfer and producing deliverable documentation

Organisation

Confidential..,
Confidential..,
Confidential

Role / Job Title

Lead Informatica Administrator
Lead Application Consultant
Senior Software Engineer

Duration

July 2011 – till date
Jan 2011 – July 2011
Sep 2006 – Dec 2011

Project Details:-

Client :- Confidential

Duration

July- 2011 – Till Date

Confidential is the nation\'s fastest mobile broadband network — and it\'s getting faster with 4G — serving millions of customers and enabling them to travel and communicate seamlessly with the best worldwide wireless coverage — offering the most phones that work in the most countries. Offering voice coverage in more than 220 countries, data roaming in more than 200 countries and mobile broadband in more than 130 countries.

The only U.S. national service provider to offer a 100 percent IP-based television service with Confidential U-verse TV, which provides an exciting alternative to cable with a better DVR, better features and apps and a better TV experience.

Managing the nation\'s largest Wi-Fi network (based on branded and operated sites) with nearly 27,000 Confidential Wi-Fi Hot Spots, including locations in all 50 states, and access to more than 215,000 hot spots around the globe.

One of the world\'s largest providers of IP-based communications services for businesses, with an extensive portfolio of Virtual Private Network (VPN), Voice over IP (VoIP) and other offerings—all backed by innovative security and customer support capabilities.

Technologies Used: Informatica Power Center 8.6.0 /8.6.1, 9.0.1 Oracle 10g,

My Primary responsibilities at AT&T.:

• Leading a team of 7 with one person onsite and 6 people at offshore Product development, enhancement and Automation.
• Responsible for the Informatica Environment at AT&T for an Application called CCPM ( Call-Center performance management, eCDW , EDW applications which includes all maintenance activities, code migrations, and upgrades.
• Expertise in Upgrading and Migrating of INFA 7.1.4 to 8.1.1, 8.1.1 to 8.6.1 and recently upgraded INFA 8.6.1 to INFA 9.1.0.
• Expertise in Disaster Recovery (DR) of Informatica components.
• Leading and mentoring Junior Administrators in the Team
• Responsible for Managing restricted access control to Informatica
• Assist the development teams in architecture and design and performance tuning and provide best practices to be followed on the platform
• Co-ordinate with all the dependent teams like Infrastruture, WINTEL, STORAGE, UNIX, IDentity Management team upon any planned maintainence and upon the impact on the same on Informatica.
• Write/modify scripts as required for production systems (shell scripts or Perl scripts)
• Review code going into production for accuracy, maintain Informatica with multiple nodes
• Monitor daily, weekly, monthly Data Warehouse load processes and other DW related processes
• Schedule daily backup of Informatica environment, restore Informatica environment when required
• Understanding of Meta Data and Data Quality needs on ETL and Data Warehouse processes
• Involved in designing the ETL mapping documents and managed software releases after each stage of the testing and defect removal
• Extensively Worked on Informatica Server and Client components such as Informatica Admin Console, Repository Manager, Power Exchange Navigator, Designer, Workflow Manager, and Workflow Monitor for ETL Development and Administration activities.
• Involved in deployment of Informatica as part of the Release Management of the Application .
• Continually worked towards improving and stabilizing production environment through shell scripts using Informatica command line utility and deploying them as part of release management
• Performed various system Installation, upgrades etc surrounding Informatica .

Single handedly worked and resolved numerous critical escalated production issues

Project Details:-

Client :- Confidential

Duration

Jan 2011 – July -2011

Confidential. is a fully integrated, broad-based entertainment company and a global leader in the creation, production, distribution, licensing and marketing of all forms of entertainment and their related businesses. A Time Warner Company, Confidential stands at the forefront of every aspect of the entertainment industry from feature films to television, home entertainment/DVD, animation, product and brand licensing and interactive entertainment. The company’s vast library, considered one of the best and largest in the world, consists of more than 6,650 feature films, 40,000 television titles and 14,000 animated titles (including over 1,500 classic animated shorts). Confidential employee population ranges from 7,000 to 15,000 on any given day in North America (depending on the level of television and movie production) and some 2,000 employees overseas.

Technologies Used: Informatica Power Center 8.6.0 /8.6.1, Oracle 10g,

My Primary responsibilities at Warner Bros.:

• Leading a team of 4 with one person onsite and 3 people at offshore Product development, enhancement and Automation.
• Responsible for the Informatica Environment at WARNER BROTHERS, including all maintenance activities, code migrations, and upgrades.
• Upgraded and Migrated INFA 8.5.1 to INFA 9.0.1 HF2.
• Leading and mentoring Junior Administrators in the Team
• Responsible for Managing restricted access control to Informatica
• Assist the development teams in architecture and design and performance tuning and provide best practices to be followed on the platform
• Co-ordinate with all the dependent teams like Infrastruture, WINTEL, STORAGE, UNIX, IDentity Management team upon any planned maintainence and upon the impact on the same on Informatica.
• Write/modify scripts as required for production systems (shell scripts or Perl scripts)
• Review code going into production for accuracy, maintain Informatica with multiple nodes
• Monitor daily, weekly, monthly Data Warehouse load processes and other DW related processes
• Schedule daily backup of Informatica environment, restore Informatica environment when required
• Understanding of Meta Data and Data Quality needs on ETL and Data Warehouse processes
• Involved in deployment of Informatica as part of the Release Management of the Application .
• Continually worked towards improving and stabilizing production environment through shell scripts using

Project Details:-

Client :- Confidential

Duration

November 2008 – Jan-2011

Confidential is a leading human therapeutics company in the biotechnology industry. For more than 25 years they have focused on accomplishing their mission to serve patients by discovering.

Technologies Used: Informatica Power Center 7.1.4/ 8.1.1 /8.6.1, Oracle 10g, DATAFLUX

My overall responsibilities at AMGEN:

• Leading a team of 3 to work continuously towards Product development, enhancement and Automation
• Experienced with Informatica 7.x, 8.x and upgrading to 8.x
• Maintenance and upgrade of Informatica environment on Hotfixes and Patches.
• ETL Code deployment for Data Warehouses and Data marts for production.
• Migrations from 7.x or 8.1.1 to 8.6.X.
• Write/modify scripts as required for production systems (shell scripts or Perl scripts)
• Review code going into production for accuracy, maintain Informatica with multiple nodes
• Monitor daily, weekly, monthly Data Warehouse load processes and other DW related processes
• Schedule daily backup of Informatica environment, restore Informatica environment when required
• Understanding of Meta Data and Data Quality needs on ETL and Data Warehouse processes
• Involved in designing the ETL mapping documents and managed software releases after each stage of the testing and defect removal
• Extensively Worked on Informatica Server and Client components such as Informatica Admin Console, Repository Manager, Power Exchange Navigator, Designer, Workflow Manager, and Workflow Monitor for ETL Development and Administration activities.
• Involved in deployment of Informatica as part of the Release Management of the Application .
• Continually worked towards improving and stabilizing production environment through shell scripts using Informatica command line utility and deploying them as part of release management
• Performed various system Installation, upgrades etc surrounding Informatica .
• Single handedly worked and resolved numerous critical escalated production issues.

Client :- Confidential

Duration

April 2008 – October 2008

Confidential is headquartered in Mesquite, Texas and Lineage Power Corporation is a leading global provider of complete telecom power systems, including innovative, reliable AC-DC and DC-DC switching power supplies, batteries, and power conversion products and services. Lineage Power Systems designs, manufactures and markets products to telecommunications service providers and enterprise customers in more than 40 countries, with fiscal 2007 sales of over US$ 500 million. Lineage Power is owned by The Gores Group. More information on Lineage Power can be found.

Technologies Used: Informatica Power Center 7.1.2, flat Files, Oracle9i, UNIX, SQL, PL/SQL

My overall responsibilities at LP Corporation:

The Scope of the work for this engagement covers Data sources to be analyzed, reports that needs to be designed & built and the data to be migrated to load the historical data from Tycoelectronics, that need to be considered for building the datawarehouse solution for Lineage Power .

The purpose involved capturing Customer, Vendor, Sales, Material, SAP Codes & Purchasing information from various Data sources which were captured in the form of ADR’s.

ADR ( Acquired data requisition)—Handled 40 ADR feeds, 
Have developed 25-30 feeds and Built mappings to extract the data from fixed width FLAT FILES and perform appropriate Business Validations and load the data into Target tables.

EDW: Pick the data from the Target tables, perform required RI validation and load the data to appropriate Master tables.

Involved in building the Stored Procedure for Extracting the TIME DIMENSION information. 
Involved creating a UNIX script for handling Variable record length