Ahmad Mubashir Email & Phone Number

Grand Rapids, Mi

• Responsible for understanding the current and future Infrastructure requirements of applications on ETL platform • Responsible for setting up end-to-end enterprise Infrastructure platform for ETL operations, including server capacity planning; installation, configuration, testing and deployment of software • Responsible for conducting proof of concepts and thorough testing for new software products, functionalities, plugins, hotfixes, Emergency break fixed, new software versions and patches etc. on sandbox environment • Responsible for setting up SDLC process for software and/or application deployment across ETL environments • Responsible for troubleshooting all issues, raised by application team and if needed, work with Informatica vendor to get the fix for any known/unknown bug in software, in order to remediate the issue • Responsible for setting server reboot process, maintenance window for smooth operational processes • Responsible for coordinating with all distributed systems and application stakeholder for applying patches, upgrades, downtime, server reboots etc. • Responsible for performing end-to-end Informatica product suite upgrade (Power Center, Data Transformation, Metadata manager, Data Quality services etc.) in all the environments • Responsible for conducting the TSP process, to get new Informatica software (eg. Informatica 9.6.1, PMPC, DVO etc.) Certified for the organization at Enterprise level, to ensure proper user privileges, licensing etc. • Responsible for preparing step-by-step Installation handbook, run books, test cases, test result evidences for any new installation or upgrade • Responsible for reviewing the functional and non-functional requirements of applications and providing the guidelines to use best ETL tools and functionalities accordingly • Responsible for conducting routine health check of all Informatica environments, servers, databases etc.

Chicago, Il

• Gathering the requirements for the Informatica Power Center Install on Servers. • Responsible for Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain. • Configure the Security (LDAP), enabling the OS profiles and Applying Patches on the base install. • Creating Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and to configure the various connections. • Participated in team meetings and proposed ETL Strategy and provide them best practices. • Upgraded Informatica power center 9.5.1 to version 9.6.1 on Linux servers. • Install and configure DVO tool for validating the data. • Install and Configure Informatica DR environment platform. • Created Shell scripts to automate the Backups, ETL Execution. Worked on Managing the Alerts for the server failures using SMTP Configuration. • Worked with SAP connectors. • Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets. • Performed tuning of Informatica Mappings for optimum performance. • Implemented Informatica Power Center DR. • Worked closely with Development managers to evaluate the overall project timeline. • Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode. • Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements. • Involved in Prod Support to research and resolve the daily load issues and trouble shoot them. • Document the Prod job failures and provide the root cause analysis to the management. • Used Informatica Dynamic Deployment groups to deploy the Informatica jobs among different environments (DEV, TEST, QA and PROD). • Developed UNIX scripts for scheduling the delta loads and master loads using Autosys Scheduler.

Parsippany, Nj

• Installed and configured Power Center 9.1 on UNIX platform.• Upgraded to Informatica Power Center 9.1 from version 8.6.1. Installed Hot fixes, utilities, and patches released from Informatica Corporation.• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.• Configured OS Profiles and LDAP Authentication.• Extensively worked on Informatica Mappings/Session/Workflows to load data from Oracle to TD and vice versa.• Worked on Push down Optimization to optimize Oracle loads.• Installed and Configured Informatica MDM 9.7 Hub server, process server and Resource Kit in all the 5 environments starting from Dev,Test,UAT,PREP and Production.• Interactions with business users to understand the Match needs, source system trust scores, data model and table structures. • Created landing tables, stage tables, base objects, foreign key relationships and lookups. • Worked with Powercenter team to load data from external source systems to MDM hub.• Integrated MDM Hub with external applications and used SIF APIs (GET, SearchMatch, PUT, and CleansePut etc.) to search, update, cleanse and insert data in to Hub.• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and infacmd and pmrep operations).• Creation and maintenance of Informatica users and privileges.• Worked on Informatica Mapping Architect for Visio to automate Mappings, Sessions and Workflow generation.• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.• Worked on Informatica Templates to standardize the CISCO process and maintain consistency across different teams.• Worked on UNIX shell scripts to handle Job Control Process.

Philadelphia, Pa

• Installed/Upgraded Informatica products 9.1.0 HF3 to 9.5.1. • Configured Informatica Services for PowerCenter, Data Quality (IDQ), Data Profiling • Configured Enterprise Grid clustering and High Availability. Installed and configured Data validation Option (DVO) • Worked on Security management, creating Groups, Users and Folders. Used/Created OS Profiles for directory level security • Created shell scripts for file cleanup and archival • Involved in code reviews and migrations from multiple environments.• Worked on capacity planning and performance tuning • Used Pro-Active monitoring tool for monitor Informatica services. Worked on Root Cause Analysis for Production down time • Implemented Disaster Recovery, Backup and Restore strategy .Worked on monthly scheduled maintenance • Configured LDAP security • Created Shell scripts to automate code deployment, monitoring, backups and cleanup • Setup DR Environment and testing Worked with different teams on any POC for new implementations • Support for Informatica environment Maintenance • Configured Reporting and Dashboard services for PowerCenter, Metadata Manager and Model Repository (Data Quality)• Gathered User requirements, reporting requirements and the document for requirement specifications.• Interacted with business analyst and users, gathering the business requirements, designing and developing functional requirement documents.• Capture and document Business Requirements from client conducting interviews and workshops.• Implemented and configured OBIEE in Windows environment and integrate it with ORACLE data warehouse.• Build the OBI / Siebel Analytics repository (RPD) / metadata and define / create the subject areas where reporting and analysis are centered around.

Tampa, Florida

• Effectively maintained a complex multi-Tier Informatica platform on Windows server. • Responsible for resolution of all issues related to platform which includes product functionality, operational, performance and security issues. • Involved in upgrades of Informatica product suite from 8.6.1 to v9.1. • Installed, Configured Informatica product suite such as PowerCenter 9.1/9.5, Metadata Manager, Reference Table Manager (RTM), Essbase etc. • Responsible for Capacity planning, server monitoring, setting up load balancing techniques etc. on all Informatica environments/servers. • Involved in setting up the security configuration for Financial Transaction shared system. • On-call support for 24*7 • Responsible for setting up end to end application Infrastructure, including creation of users, security groups, ldap sync-up, security configuration, application folders and id's, setting up .profiles, parameters, environment variables etc. • Responsible for raising service requests with Informatica for resolving any product related issues • Responsible for creating and maintaining Build books, Run books, and test books • Responsible for setting up Audit and various other security compliances • Involved in migrating various complex applications between environments and to Production using TBD. • Involved in setting up the Domain and Node Backup processes, scheduling etc. • Involved in creating TNS/odbc entries, PWX nodes, data map migrations. Involved in implementing automated reusable scripts across environment which includes - Monitoring of INFA Services, CPU/Memory, volume group/SAN, Network etc.