Data Manager

Uday Reddy

Senior: Informatica Administrator

Phone: 510-***-****

Email: *********@*****.***

PROFESSIONAL SUMMARY:

7+ years of IT experience in analysis, design, development, testing and Implementation Informatica Workflows using Data Warehousing/Data mart design, ETL, OLAP client /server applications.

ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 10.x/9.x.

Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes through Informatica.

Proficient in Data warehouse ETL activities using SQL, PL/SQL, PROC, SQL LOADER, C, Data structures using C, UNIX scripting.

Strong ETL experience using Informatica Power Center with various versions 10.x/9.x/8.x Client tools - Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor and Server tools – Informatica Server, Repository Server manager and Power Mart .

Knowledge in Full Life Cycle development of Data Warehousing.

Used Informatica data quality (IDQ) in cleaning and formatting customer master data.

Experience in Software development life cycle (SDLC) Such as testing, migrating, developing, etc.

Proficient and worked with databases like Oracle, SQL Server, IBM DB2, XML, Teradata, Excel sheets, Flat Files.

Excellent working knowledge of UNIX shell scripts.

Extensively worked on Data migration, Data Cleansing and Data Staging of operational sources using ETL process and providing data mining features for Data warehouses.

Strong knowledge on Relation Databases on different platforms such as Windows/Unix Linux using GUI tools like SQL DEVELOPER, SQL PLUS, MICROSOFT VISUAL

Analytical and Technical aptitude with the ability to solve complex problems.

Excellent Written, Communications and Analytical skills with ability to perform independently as well as in a team quick learner and able to meet deadlines.

Extensive usage of reusable components for sources, targets, user defined functions, transformations, mapplets, worklets and sessions.

Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications

Experience in Informatica Administration and hands-on experience in installing, configuring, upgrading the Informatica Power Center and Data Quality.

Experienced in setting up Disaster Recovery environment and involved in annual DR test exercises

Experienced in handling various Informatica Power Center code migration methods (XML Export/Import, Deployment Group and Object Copy)

Experience in handling Informatica repository back-up’s, restore and fail-over of services from primary to back-up nodes and vice-versa.

Experience in Migration of informatica PowerCenter from One version to another version.

Experience in installing Informatica in UNIX & WINDOWS environment.

Expertise in documenting the ETL process, Source to Target Mapping specifications, status reports and meeting minutes.

Experience in working on onsite and offshore delivery model.

Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.

Good knowledge on Software Development Life Cycle.

Experience in project and issue tracking tool like REMEDY, SERVICE-NOW, JIRA.

Overview of EDI transactions.

Overview of Data Warehousing concepts.

Good understanding on file transport protocols like FTP, SFTP

Good understanding on using PGP encryption.

Good overview of production support procedures, Release and change management.

Diverse background with fast Learning and creative Analytical abilities with good Technical, Problem Solving, Communication and Interpersonal skills.

EDUCATIONAL QUALIFICATIONS

Bachelor of Technology, JNTU, India.

Northwestern Polytechnic University, CA, USA.

TECHNICAL SKILLS:

ETL Tools

Informatica Power Center 10.x, 9.x, 8.x, 7.x, Informatica PowerExchange 9.x, 10.x, Informatica B2B, IDQ, Analyst.

RDBMS

Oracle11g / 10g / 9i, SQL Server 2000/2005/2008/2014

Operating System

UNIX, RHEL, IBM AIX, Windows NT/2000/XP/7/2012

Job Scheduling Tools

Informatica, UC4(Atomic), Control-M

Languages

SQL, PL/SQL

Tools

MS Office, TOAD, Winscp, Putty, Sql-Developer, Service Now, Remedy

PROFESSIONAL EXPERIENCE:

Dept. Of Health Care Services, Sacramento, CA Oct’16 – Sep’17

Role: Informatica IDQ Administrator.

Helped in creating DFD’s and architecture diagrams for new environments.

Upgrading informatica from lower versions to higher versions i.e., from 9.5.0 to 9.5.1 to 10.1.1 HF1.

Involved in migrating Informatica Power Center from version 9.5.1 to 10.1 on all environments i.e., Dev, Test & Prod systems

Designed and configured a new stand-alone server with Windows SQL Server 2014 and Informatica Power Center 10.1 in the DEV, TEST and PROD systems

Migrate T-MSIS Informatica data repository to the new server in the DEV, TEST and PROD systems

Designed, configured and install the IDQ services in DEV, TEST and PROD systems in new environment.

Involved in upgrading informatica PowerExchange from V 9.5.0 to 9.5.1 to 10.1.1 on mainframes and configured PowerExchange 10.1.1 for proper function with existing transmission and repository tools.

Prepared architectural diagrams for informatica tools.

Created various batch scripts for Domain, Repository and Folder Backups.

Automated various backup workflows using informatica scheduler.

Responsible to monitor and keep the health of Informatica services and Informatica servers.

Performance tuning, Creating E-Mail notification tasks.

Responsible to monitor and keep the health of Informatica services.

Maintain Centralized Issue Logs and weekly status reports.

Responsible for creating/changing Folders, users, connection objects, deployment groups, promoting/rollback of deployment groups from development to QA and to production environment.

Experienced in handling various Informatica Power Center code migration methods (XML Export/Import, Deployment Group and Object Copy).

Support assistance to Informatica developers and advice on their queries.

Co-ordinate with other support groups in case of planned/un-planned down time.

Do POC’s for new functionalities being used for first time.

Create service requests with vendors for unknown errors, enhancement requests and follow-up.

Maintenance of Informatica Repository, purging/archival of logs on Informatica servers.

On call support for Informatica.

Involved in versioning, creating, restoring, and taking backup of repository.

Provided hands on training to staff on various informatica administrative activities.

Charter Communications MO April’16 – Sept’16

Role: Sr. Informatica/Appworx Administrator

Responsible to monitor and keep the health of Informatica services and Informatica servers.

Upgrading Informatica from lower versions to upper versions i.e., from 9.5.1 to 9.6.1.

Installing Informatica 9X versions.

Performance tuning, Creating E-Mail notification tasks.

Involved in data replication, data warehousing and data mart, cluster and grid configurations

Responsible to monitor and keep the health of Informatica services, OBIEE services.

Maintain Centralized Issue Logs and weekly status reports.

Responsible for creating/changing Folders, users, connection objects, deployment groups, promoting/rollback of deployment groups from development to QA and to production environment.

Experienced in handling various Informatica Power Center code migration methods (XML Export/Import, Deployment Group and Object Copy).

Experienced in handling UC4 (Application Manager) code migrations from environment to environment.

Involved in LDAP Configuration.

Support assistance to Informatica developers and advice on their queries.

Co-ordinate with other support groups in case of planned/un-planned down time.

Do POC’s for new functionalities being used for first time.

Prepare RCA for service failures and follow-up with relevant stake holder if required.

Create service requests with vendors for unknown errors, enhancement requests and follow-up.

Maintenance of Informatica Repository, purging/archival of logs on Informatica servers.

Configuration Management.

Code Release Migration.

On call support for BI tool services, Monthly maintenance of Informatica servers.

Involved in versioning, creating, restoring, and taking backup of repository.

Creating tickets using Service Now.

Helped in creating DFD’s and Access Policy for procuring new servers.

AT&T, TX Mar’15 – Mar’16

Role: Sr. Informatica Lead Administrator

Responsibilities:

Reducing maintenance needs, improving reliability, reducing execution time and performance tuning and monitoring.

Monitor the day-to-day activity of the data warehouse, Informatica jobs, BI Tools and reporting.

Assist with the definition of ‘service level’ requirements from all areas of the organization, as they relate to the business Intelligence including application availability, acceptable downtime, data integrity, user support, issue resolution, etc.

Working with other IT teams on application project ETL processes. Ensure standards and procedures for Data Warehouse, ODS, and Data Mart ETL processes are followed.

Design and architect new ETL processes prior to development to ensure the best approach is chosen.

Analyze, review and suggestions to increase operating efficiency of ETL.

Installing Informatica on Unix as part of upgrade from 9.1 to 9.6.1

Maintain Centralized Issue Logs and weekly status reports.

Involved in LDAP configuration.

Involved in implementing the Land Process of loading the data into Informatica MDM Hub.

Created best practice using Informatica Data Validation Option to best utilize functionality from an operations and project perspective.

Created Business Reports using SSRS and converted ETL from SSIS to Informatica.

Involved in writing shell scripts for regular tasks. Good experience in LDAP configuration.

Good experience in versioning, creating, restoring, taking backup of repository

Troubleshooting production issues, Setup and administer Power Center security.

Support assistance to Informatica developers

Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.

Writing shell scripts to automate Informatica maintenance jobs, writing PMCMD and PMREP scripts.

Upgrading Informatica from lower versions to upper versions i.e., from 9.1 to 9.6.1,

Installing Informatica 9X versions.

Performance tuning, Creating E-Mail notification tasks.

Involved in data replication, data warehousing and data mart, cluster and grid configurations

Have experience in using ‘sed’ and ‘awk’ while writing shell scripts.

Responsible to monitor and keep the health of Informatica services, OBIEE services.

Responsible for creating/changing Folders, users, connection objects, deployment groups, promoting/rollback of deployment groups from development to QA and to production environment.

Support assistance to Informatica developers and advice on their queries.

Co-ordinate with other support groups in case of planned/un-planned down time.

Involved in setup of DR environments

Configured match rule set property by enabling search by rules in MDM according to Business Rules.

Do POC’s for new functionalities being used for first time.

Prepare RCA for service failures and follow-up with relevant stake holder if required.

Create service requests with vendors for unknown errors, enhancement requests and follow-up.

Maintenance of Informatica Repository, purging/archival of logs on Informatica servers.

Configuration Management.

Code Release Migration.

On call support for BI tool services, Monthly maintenance of Informatica servers.

Environment: Informatica Power Center 9.1/8.6, MS SQL server 2005, Oracle 10g/11g, Toad, PL/SQL (Stored Procedures, Triggers, Packages), MS Visio, Windows 7, Winscp, Putty

IKS Health Hyderabad, India Jan’13-Nov’14

Role: ETL Administrator

Project Description: The project deals with building a real time view of enterprise wide data. Sales order, shipment, customer, invoice, product and contract data from disparate databases used by these operational systems will be extracted periodically into the data warehouse database. Using the data warehouse database and business Intelligence Front End Tools, user requirements will be addressed by means of queries, Decision Support Systems (DSS), Online Analytical Processing, Sales and Purchase activities. This Data Warehouse is used to deliver reports and information to sales and marketing management.

Responsibilities:

•Installing Informatica on UNIX as part of upgrade from 9.5.1 to 9.6.1.

•Upgrading Informatica from lower versions to Higher versions in DEV,UAT, and PROD environments i.e., from 9.5.1 to 9.6.1

•Configure and Installation of the Informatica IDQ tool in the DEV, TEST, and PROD environments.

•Installation and support for Informatica tools.

•Responsible to monitor and keep the health of Informatica services and Informatica servers.

•On call support for Informatica services.

•Responsible for creating/changing Folders, users, connection objects, deployment groups, promoting/rollback of deployment groups from development to QA and to production environment.

•Support assistance to Informatica developers and advice on their queries.

•Co-ordinate with other support groups in case of planned/un-planned down time.

•Support for annual DR testing.

•Do POC’s for new functionalities being used for first time.

•Prepare RCA for Informatica service failures and follow-up with relevant stake holder if required.

•Create service requests with Informatica support for unknown errors and follow-up.

•Maintenance of Informatica Repository, purging/archival of logs on Informatica servers.

Environment:

Informatica Power Center 9.5.1/8.6, Meta data manager, MS SQL server 2005, Oracle 10g/11g, Toad, PL/SQL (Stored Procedures, Triggers, Packages), MS Visio, Windows 7, Winscp, Putty

TMI Network, Hyderabad, INDIA Jan’10 – Dec’12

ETL Developer

Responsibilities:

Convert the Business requirements into technical requirement documentation (LSD and ETL Design Documentation).

Perform analysis, validation on the DB2 data received from California Track, Qcare related oracle data from Colorado and integrate the various source systems.

Design ETL for Framework, Logging Activity, Control Tables and Error Handling by Interacting with the ETL Integration Consultants and Architects.

Developed Informatica technical mapping document to pull data from different Source systems and integrate.

Workflow Recovery with mapping build for recovery, Tuning and Error Handling.

Debugging and Performance Tuning of sources, targets, mappings and sessions.

Developed Slowly Changing Dimension Mappings of type II

Complex mappings creation using various transformation tasks and fine tune.

Assist in usage of Exceptional handling, records, arrays, Partitioning of tables, Bulk Collects.

Create RFC and SRs for any enhancements for deployment and get approvals.

Do health checks by ensuring the source data and target data are accurate and valid.

Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes – success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.

Environment: Informatica 8.6.1, ORACLE RDBMS 10g, PL/SQL, DB2,WinSQL, MS SQL Server, Shell programming, MS Visio, Winscp, VSS, TOAD 9, UNIX AIX, Cygwin, Tivoli, Erwin, Remedy User

Contact this candidate