SUMMARY

• Informatica Administrator/Developer with 12+ years of IT experience in Data warehousing, Business Intelligence.
• Proven ability to conceptualize, design and implement solutions
• Possess wide range of IT industry experience with Banking / Finance, Media and Entertainment, Invest Banking, Utilities, Telecom etc.
• Configured Power Exchange connections for SAP, Sales Force applications.
• Installation and configuration of Informatica servers and client environments.
• Involved in debugging and Performance tuning of targets, sources, mappings and sessions
• Automated system health checks using shell scripts.
• Strong experience in installation of Informatica on UNIX, Migration of repositories, and upgradation of repositories.
• Involved in a role as an Informatica Administrator in upgrading the repository database and giving permission to various groups of users and testers
• Good experience in maintaining Oracle, ODBC connections and installing and maintaining various new database connectivity software and Informatica plugins for respective softwares
• Have good experience as informatica administrator in creating domains, repositories and folders, applying hotfixes and updating to new versions
• Involved in preparing migration documents to move the mappings from development to production repositories
• Configuration of grid in power center environment with the load balancer functionality, Dispatch process, dispatch mode, resources, resource provision thresholds service level to achieve optimal performance
• Good Knowledge on using scheduling tools to automate running of Informatica workflows
• Involved in UNIX shell scripting, FTP and file management in various UNIX environments
• Team player and self - starter with good communication skills and ability to work independently and as part of a team
• Collaborated onsite teams, interacted and well managed various offshore teams.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical skills.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 10.1,10.0, 9.6.1/9.5/9.1/9.0/8.6.1/8.5/8.1.1/7.1.3 , Informatica Power Exchange Express 10.1

Project Management: Team Handling, Effort estimation, Client communication and reporting, Quality Assurance

Data Bases: Oracle7.x/8.1/8i/9i/10g,11,12.1, MS SQL Server 2000/2005/2008 , Sybase, DB2, Teradata 12/13/14, Salesforce.com, Informix

Tools: Mercury Quality Center, Toad, Taragui, Teradata SQL Assistant, Erwin, PL SQL Developer, SQL Developer

Operating Systems: Redhat Linux 7.2,5.1, 5.3,SunOS, AIX 5.3, Windows 2000/2003,XP,Window 7

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Informatica Administrator

Responsibilities:

• Install, configure and maintain enterprise Informatica in grid.
• Install and configure Power Exchange CDC express/log-miner
• Perform upgrades, apply hot-fix/patches on Informatica in Linux environment.
• Perform scheduled Backups for Informatica Repositories.
• Monitor and tune ETL repository for performance improvements.
• Hands on Informatica Power-center advanced Administration skills related to GRID, HA and DR.
• Schedule and monitor batch jobs in production and other non-production environments.
• Investigate and resolve Infomatica connectivity and logic issues during interface testing Informatica Design/Development associated with CCB to Edge Application interfaces.
• Work with users, Project manager to ensure that implemented solutions satisfy business requirements and are delivered in timely manner.
• The nature of the specific duties is so specialized and complex that knowledge required to perform the duties is usually associated with the attainment of baccalaureate or higher degree.

Environment: Informatica 10.1/10.0/9.1/9.5/9.6 , Power Exchange Express 10.1, Oracle 12, DB2, SQL Server, Redhat Linux 7.2, CAWA Scheduler, Putty, JIRA

Confidential, Dallas, TX

Informatica Administrator/Team Lead

Responsibilities:

• ECR/SIS call reviews (ECR and Weekend deployments in Prod and NonProd Environment)
• Informatica folder/Object migration, Unix file/Schedule migration, Unix file migrations using SVN
• Informatica New connection creation(Teradata, oracle )
• Directory structure creation for Batch/Informatica.
• Compose Maestro schedulers,TWS activities, Modify Parameter/ Calender, Maestro Deployments
• AOTS trouble tickets resolution, Webtrax WR tickets resolution.
• Reporting activities (Deployment Plan, Issue report,Deployment statistics,Deployment Report)
• Unlocking objects in informatica 9.x, ODBC Setup, Setup of informatica on Citrix
• Folder,User and Group creation in Informatica 9.1/9.5/9.6 admin console
• Informatica Troubleshooting from Infrastructure side
• Performed Informatica upgrade from 9.1 to 9.5.and 9.5 to 9.6
• Participate in capacity planning and coordination with IT infrastructure engineers.
• Keeps up-to-date on vendor license agreements and maintain license inventory.
• Automated server health checks and file system memory management using shell Scripts.
• Work with application teams to fulfill database tasks (creating databases, accounts, tables, etc.)
• Creation and configuration of integration services to run on the Grid.
• Worked on Grid with Key features like workflow and session on Grid, Adaptive Load balancing,Dynamic Partitioning,Robust interoperability.
• Implemented grid for parallel processing,loadbalancing, real-time ETL processes
• Installed and configured HA architecture to makes system available Confidential any given point of time.
• Created and configured Operating system profiles to maintain the security between the project teams.
• Configured Teradata Loader connections, SAP, Sales Force application connections.
• Backup and restore of domain and Repository services.
• Automated System health checks and implemented alerting mechanism using Shell Scripts.
• Worked with Network, Operating system teams for any system related performance issues.
• Worked with Firewall Team for adding new system entries to Server.
• Worked with release management teams for infrastructure related outages like Password change, Operating system patch, application upgrade activities.
• Worked on installation of Informatica,HotFix,EBF,TPT API,TTU
• Created new Informatica users for all the groups using PowerCenter and IDQ services, managed their permissions on different objects like relational connections and repository folders
• DR Setup
• Unix to Linux Project implementation
• Coordinated with different teams DBAs, storage ops, system admins, server ops etc.

Environment: Informatica 9.1/9.5/9.6, Informatica Data Quality (IDQ 9.5/9.6), Oracle 11, DB2,SQL Server, Teradata 13/14,Redhat Enterprise Linux, TWS scheduler, Putty, BMC Remedy, Webtrax

Confidential, Stamford, CT

Lead Informatica Developer

Responsibilities:

• Developed error handling strategy which was implemented enterprise wide as a standard to process data from all source systems, the process uses a re-usable Informatica code which uses custom SQL queries to populate the errors from source system
• Lead a group of 10 or more junior and senior developers on a variety of development projects which involved moving data from different sources to Enterprise Data Warehouse
• Extensively used mapping parameters and variables, created Informatica workflows to automate the creation of parameter files
• Actively involved in standardizing Informatica code practices and documenting the standards followed enterprise wide
• Part of Code review and design review boards responsible for making sure the codes adhere to the UPMC standards and signing off the Informatica solutions before development, respectively
• Used deployment groups, repository queries and labels to actively deploy Informatica code from one environment to the other
• Worked extensively on developing re-usable logics which are used in multiple projects
• Developed ETL process which audit’s ETL loads, passes incremental parameters and deletes bad data in the case of partial runs
• Work involved understanding the new business requirements in existing system and then designing the ETL architecture.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Create mappings to build business rules to load data.
• Various transformations (SQ, lookup, Router, aggregators, filters, SG and UPS) were used to handle situations depending upon the requirement.
• Done performance tuning in Informatica. Implemented slowly changing strategy to manage the data in the dimension tables.
• Responsible for creating reusable transformations and Maplets.
• Prepare the Weekly Status Report and attend the weekly call with the Client.
• Enhancement the existing Project as per requirement
• Fixing the Bugs in existing system
• Automation of existing scripts and Manual activities

Environment: Informatica 9.1 hotfix2, oracle 11g, PL/SQL Developer, Informatica Power Center 8.x, SQL, PL/SQL,PL SQL Developer, SQL Developer, HPSM, HPQC

Confidential, NY

Senior Informatica Administrator

Responsibilities:

• Setting up and configuring enterprise Informatica Implementation with PowerCenter 8.X (8.6 and further preferable) on UNIX and Oracle 10g and greater
• Extensively work in installing/configuring PowerExchange.
• Using PMSTACK, truss to generate core dumps for Long running and hanging jobs to isolate the issue.
• Automated creation of project related folders in both Informatica and Linux.
• Create and maintain the software migration process, coordinator and implement improvements to the migration process.
• Closely work with Informatica Corp for product issues, licensing and understanding product roadmaps
• Maintaining security through effective management of users/groups
• Working with off shore (India) team. .
• Extensively worked in Implementation of patches and upgrades.
• Implementation of maintenance activities like Power downs / Reboots etc
• Performed server file handle checks to avoid any server related performance issues.
• Extensively worked in Implementation of patches and upgrades.
• Extensively worked in automation of deployments to Production from Test environment
• Coordinating with internal clients / storage /UNIX / DBA teams to resolve issues
• Providing technical support for theInformaticaenvironment.
• Automated process to update repository statistics and purge the repository logs, to improve the performance of the repository.
• Automated repository and Domain related backups using shell scripts.
• Worked on a POC for installing informatica 9.5
• Collected Informatica logs from server and administrator tool and analyzed them along with Informatica technical support to determine the root causes in the cases of Informatica outages
• Upgraded informatica environment from 8.6 Hotfix 4 to 9.1.0 Hotfix 5
• Planned all the installation steps and documented the checklist during every hotfix/patch installs on Informatica servers
• Actively involved in technical discussions and served as an informatica SME for most of the informatica related issues
• Created new Informatica users for all the groups using PowerCenter and IDQ services, managed their permissions on different objects like relational connections and repository folders
• Experienced in working closely with DBA’s and Unix System engineers for fixing Production issues related to Informatica

Environment: Informatica 8.6/9.1/9.5, oracle 10g/11g, Red hat enterprise Linux, open suise Linux, TOAD Teardata, UNIX, Win SCP, Windows 7, Linux, DB2,SQL Server,Power Exchange for SAP and SFDC.

Confidential

Senior Informatica Admin/Developer

Responsibilities:

• Work involved understanding the new business requirements in existing system and then designing the ETL architecture.
• The work also included working with the data modelling team to understand the logical design and then come up with the physical design specifications, which was then implemented in database.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Created mappings to build business rules to load data.
• Various transformations (SQ, lookup, Router, aggregators, filters, SG and UPS) were used to handle situations depending upon the requirement.
• Done performance tuning in Informatica. Implemented slowly changing strategy to manage the data in the dimension tables.
• Responsible for creating reusable transformations and Maplets.
• Prepare the Weekly Status Report and attend the weekly call with the Client.
• Review of Unit test cases, testing individual modules of the software against the Unit test cases.
• Testing for Correct data.
• Improving the performance of Workflow so that it takes minimal time.
• Involved in installation of Informatica on UNIX, Migration of repositories (Folder Level), up gradation of repositories
• Involved in Install, upgrade, configure and maintain Power Center 7.x instances
• Interact with UNIX and Database Administrators to create and maintain each Power Center instances. .
• Manage and administer system performance including on-going optimization and tuning of Informatica environment
• Manages repository users, pmservers, repository functions (adding folders, migrating objects, etc.), and maintaining a clean and organized environment (truncating log files, removing invalid shared objects, etc.).
• Creation of repository, backup and upgradation of repository
• Shutting down and restarting the Informatica servers when there is a requirement
• Perform complex troubleshooting, root-cause analysis, solution development
• Resolving all type of Informatica technical issues
• Informatica Admin activities like deployment, maintaining logs
• Object migration(using static and dynamic deployment grp)

Environment: Informatica 7.x/8.1, oracle 10g/11g, Red hat enterprise Linux, PL/SQL Developer, TOAD 8.6

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Created mappings to build business rules to load data.
• Various transformations (SQ, lookup, Router, aggregators, filters, SG and UPS) were used to handle situations depending upon the requirement.
• Done performance tuning in Informatica. Implemented slowly changing strategy to manage the data in the dimension tables.
• Responsible for creating reusable transformations and Maplets.
• Prepare the Weekly Status Report and attend the weekly call with the Client.
• Involved in installation of Informatica on UNIX, Migration of repositories (Folder Level), up gradation of repositories
• Involved in Install, upgrade, configure and maintain Power Center 7.x instances
• Interact with UNIX and Database Administrators to create and maintain each Power Center instances. .
• Manage and administer system performance including on-going optimization and tuning of Informatica environment
• Manages domain and repository users, domain functions, repository functions (adding folders, migrating objects, etc.), and maintaining a clean and organized environment (truncating log files, removing invalid shared objects, etc.).
• Creation of repository, backup and upgradation of repository
• Shutting down and restarting the Informatica servers when there is a requirement

Environment: Informatica 6.x/7.x, oracle 9i, unix