PROFESSIONAL SUMMARY:

• 10 Years of total IT experience and 8 years of relevant experience in Informatica Data Warehousing and Data Migration projects. Extensively used Informatica PowerCenter & Data Quality and also worked on the other BI tools like Business Objects. Worked on development, migration, enhancement and support maintenance projects
• Expertise in Installing and managing Informatica Power Center, Metadata Manager, Proactive Monitoring, DVO, Informatica Cloud Agent, Data Integration HUB and Data Quality.
• Implemented and Trained offshore team on Integration Best Practices, providing consulting to BI team, troubleshooting/fine tuning ETL’s for best performance.
• Worked on Performance tuning at Source, Target and Session level in Informatica
• Strong knowledge in Informatica Administration including Installation and up gradation, Configuration, Maintenance and Troubleshooting.
• Strong experience in installation of Informatica on Linux/Unix, Migration of Repositories, and up gradation of Repositories.
• Extensively worked on Informatica 8.x, 9.x and 10.1
• Experience in handling Production support
• Involved in writing various UNIX Shell Scripts for writing automated Scripts for scheduled queue process and PMCMD commands
• Provided technical leadership for the end - to-end evaluation and implementation of new technology and application solutions like Informatica Cloud, Informatica cloud - DIH Integration, Informatica Cloud - OData Connector Integration, B2B, Proactive Monitoring
• Experience in debugging and performance tuning of Sources, Targets, Mappings and Sessions
• Excellent Communication and Interpersonal skills, Quick Learner and high adaptability to new Technologies and Tools
• Provide subject matter expert on major technology initiatives, in order to apply the principles of the technology across the Covance project portfolio in a consistent fashion.
• Designed and implemented Metadata Repository and customized standard Informatica Metadata Models to accommodate a full range of metadata
• Strong Team working spirit, Communication and relationship management skills.
• Designed Infrastructure for Informatica Grid Architecture and High Available services across Data centers using EMC2 Veritas Clustering solution & SRDF.
• Experience in implementing Data Replication and CDC Technologies.
• Developed various utilities to automate admin tasks such as Informatica ETL Migration, ETL Standard validation, History Loads, Suspended Workflow List, Informatica Service Status Alerts, Disk Space Alerts, Invalid ETL Objects Tracker, Metadata Manager Refresh Utility, Missing Workflow Schedules using Informatica and UNIX shell scripting.
• Developed various utilities to do Informatica repository analysis such as ETL Touch File Report, ETL Connection Reports, ETL Source File Report, ETL Script Report, ETL Parameter File Reports which is used by developers and admins for the dependency analysis. 
• Involved in Development of Shell scripts to ftp the files for Informatica processing, emailing the results, generating the files across the environments and then to invoke the workflows
• Actively involved in preparation of ETL coding standards and checklists, code reviews, working with business users on UAT test scenarios
• Proven skills in people and communication management. Strong executive presentation skills.
• Team motivator with focus on on-time project delivery.
• Proven track record of taking on difficult challenges and producing successful results for major corporations like Toyota, Confidential, Confidential .
• Recognized by peers and senior management for exceptional problem-solving skills and a consistent ability to meet tight deadlines with minimal supervision

TECHNICAL SKILLS:

Industry Experience:  Manufacturing, Financial Services

Architecture/ETL/EIM Tools:  Informatica 8.1 - 10.1,Proactive Monitoring Tool,Metadata Manager,Informatica Cloud,Data Integration HUB,Test Data Management,PowerExchange for Mainframe and Salesforce,Salesforce

Databases:  Oracle 10.x/-11.x,Netezza 6.x/7.x

Operating Systems/Platforms:  Windows, Linux and Unix

Scheduling Tools:  Autosys

Bug Tracking Tools:  Quality Center

Programming:  ASP.NET 2.0 and 3.5

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Administrator

• Ensured support - services are up and running in all environments.
• Responsible for releasing Code to Production Environment (Developer will release code to QA initially)
• As the Informatica Administrator responsible for the smooth operation of Informatica in the Data Warehouse environment, including installing, upgrading, maintaining and tuning Informatica Power Center versions 8.1 through to 10.1 in four environments - Development, Testing, Quality Assurance and Production.
• Installed, configured, as well as actively involved in performing POC’s forData Quality, Metadata Manager, Data Analyzer, ILM - Data Subset, Data Archive and TDM
• Designed DR strategy for Informatica application.
• Involved in Informatica issue resolution, folder migration using Deployment groups, Administration and served as the first point of contact for any Informatica issues raised by project teams
• Actively involved in DR testing
• Managed successful migration of critical production and contingency servers with minimal business impact to application systems
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Worked on creation of ICS based data synchronization and data replication and mapping configuration tasks and ICRT (Real Time) based Guide, Processes, Objects, Connection, Service connectors, Process Objects using Informatica cloud application. 
• Scheduled and Deployed new event driven processes, ICS tasks and ICRT tasks.
• Used Informatica cloud real-time for salesforce Managed package, which provides out of the box integration with salesforce and creation of salesforce specific guides.
• Responsible for Technical management/communication planning, charter, scope, estimates/forecasts, status reports, change management, training development for team members, scheduling and tracking project financial goals, business objectives, risk registry, milestones and deliverables.
• Opening Informatica SR's (service requests) and working with INFA support to investigate/resolve issues.
• Responsible for the maintenance of all the Informatica environments (Production, Test, Development) including installation, configuration, performance tuning, monitoring and backups.
• Developed various utilities to automate admin tasks such as Informatica ETL Migration Automation, ETL Standard validation Utility, History Loads, Suspended Workflow List, Informatica Service Status Alerts, Disk Space Alerts, Invalid ETL Objects Tracker, Metadata Manager Refresh Utility, Missing Workflow Schedules, Schedule/Un-schedule Jobs, Cleanup Utilities using Informatica and UNIX shell scripting 
• Involved in various DB upgrade projects 
• Worked with Operations teams to help fixing infrastructure related issues pertaining to Network, Database and Unix
• Designed end to end Data Lineage analysis using Informatica Metadata Management tool.
• Designed and Developed ETL process using Informatica Power Center &Power Exchange.
• Developed Complex mappings to feed Integration Repository, Data warehouse & Data marts.
• Measuring the performance benchmarking and tuned Informatica Mappings, Sessionsand SQL for better performance by eliminating various performance bottlenecks.
• Created Database Stored Procedures, and Functions to process intermittent SQL queries directly on database.
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Worked with Business users in understanding Match Merge setup and incorporated their requirements and ideas
• Provided technical guidance and best practices to other developers and groups as Technical Lead.
• Created and delivered Integration architecture presentations to the Architecture Review Board (ARB); participated in the architecture peer review process to ensure consistency of designs across the organization.
• Delivered major projects which includes implementation of LDAP Integration across environments, Proactive Monitoring Tool for Governance and Operations, Informatica cloud integration, Cloud Integration with Data Integration HUB
• Designed and Developed ETL process using Informatica Power Center &Power Exchange.
• Measuring the performance benchmarking and tuned Informatica Mappings, Sessions, and SQL for better performance by eliminating various performance bottlenecks.
• Created Database Stored Procedures, and Functions to process intermittent SQL queries directly on database

Confidential, Florida

Informatica Administrator

• Set up and configured production, QA, development and disaster recovery Informatica environments 9.6 with Master Gateway and Worker Nodes.
• Extensively worked on Informatica Grid and HA ( High Availability)
• Worked closely with the project team to formulate and implement a flexible system design that meets system and functional requirements.
• Designed base line architecture & installed/Upgraded Informatica 9.0 and performed migration of Repository from 8.1 to 9.0
• Created Nodes, Repository Services, and Integration services and configured on Master gateway/worker nodes.
• Created Users, folders, user management, groups and permissions, as well as privilege management.
• Configured Metadata Manager with Oracle and Netezza databases
• Created and configured Informatica Web Services Hub using Informatica Power Exchange for Web Service
• Controlled Security administration. Managed Informatica users and roles in order to enforce data security, while making sure all users have the necessary access to perform their tasks.
• Designed DR Strategy for Informatica Application.
• Involved in Informatica issue resolution, folder migration, Administration and served as the first line of support internally for any Informatica issues raised by the project teams.
• Responsible for the server administration teams for new hardware setup and ongoing maintenance.
• Closely worked with Database, Business Objects Dev, Web development & SA to meet the deadlines of each environment.
• Actively involved in DR testing.
• Ensured support - services are up and running in all environments.
• Responsible for releasing Code to Production Environment (Developer will release code to QA initially)
• Opening Informatica SR's (service requests) and working with INFA support to investigate/resolve issues.
• Responsible for the maintenance of all the Informatica environments (Production, Test, Development) including installation, configuration, performance tuning, monitoring and backups.

Confidential, Chicago

Informatica developer/Administrator

• Involved developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created various mappings using transformations like Aggregator, Source Qualifier, and Connected/Unconnected lookup, Update Strategy, Joiner, Filter and Router Transformations.
• Used Informatica Workflow manger to read data from sources to write to target databases, manage sessions
• Handling the infrastructure planning, designing for contingency of infrastructure, installation & configuration for improvement with effective solutions
• Responsible for pre-migration backup, restoration of backups and domains
• Responsible for installing, configuring and maintaining Informatica software (Power Center) in support of business processing requirements and configure client and server components.
• Installing hot fixes / service packs to the existing version of Informatica Power center.
• Responsible in troubleshooting, resolving Informatica problems, open service requests with Informatica Corporation and make sure to resolve the issue.
• Responsible to work with different teams providing recommendations, driving standards, plan and execute effective transition on development and production operations.
• Responsible in setup of Informatica upgrade approach plan, movement of ETL code in waves, identify to make sure code is properly tested and migrated to new version environment, and retire existing code.
• Responsible for creation and automation of server health maintenance scripts like Informatica Server start up, CPU and memory utilization check, Repository and log files, back up, and Informatica coding standards verification and validation, etc.
• Created multiple process related documents, shared to client and trained to team members. Informatica Object creation like Folder, User, User Group, Connection Objects, and assign privileges etc.
• Responsible to dig Error or Issue resolution and responsible to co-ordinate onshore team and other development, testing, production support teams.
• Created Admin ETL to check if any ETL codes are not as per defined standards and other ETLs to verify and validate user groups and privileges' in all repositories and send report to Informatica Administration team as an email attachment.
• Created a Repo Restore script for DR setup with pmrep and pmcmd commands.
• Administration Support on IDE and IDQ Tools in creation of users, backup of repo

Confidential

ASP.NETDeveloper

• Analysis and Design
• Developed ASP.NET pages in C# to meet the business requirements using Visual Studio. NET.
• Used ADO.NET for accessing data from the SQL Server 2005 database.
• Created stored procedures, user defined functions
• Used Style sheets for achieving uniformity in all the pages.
• Used AJAX controls to minimize server round trip and enhance customer experience.
• Used web service to pull the defendants’ demographics information
• Used iTextSharp to generate PDF reports