Manager Project

S uresh Pidathala

**** ****** ****** *****, *** Arbor, Michigan – 48108

734-***-**** **********@*****.***

LinkedIn: http://www.linkedin.com/in/sureshpidathala

SUMMARY

* ***** ** ********** ** IT and 5 years of experience in Administration,

•

Support, Development and Maintenance of Data Warehouse/Data Marts using

Informatica PowerCenter 8.x/7.x/6.x/5.1.x, PowerMart 4.7

Familiar with the concepts of both Ralph Kimball and Bill Inmon

•

4 years of extensive experience as ETL Systems Admin responsible for corporate

•

ETL infrastructure

2 years of experience as EAI Systems Admin on various Middleware technologies

•

such as Sun JavaCAPS, ICAN, SeeBeyond, CrossWorlds and IBM MQ Series

2 years of experience as EDI/B2B Systems Admin dealing with both ANSI X12

•

and EDIFACT sets

Performed and guided ETL System Builds on Sun Solaris, HP UX, IBM AIX, Red

•

Hat Linux and Windows Server Platforms

Strong Knowledge of Data Warehousing concepts and Dimensional Modeling

•

Installed and Configured Integrated ETL Solaris platform interface to Mainframe,

•

AS/400 Systems using Informatica Power Exchange

Installed and configured Informatica Power Channel for both flat file transfers as

•

well as a plug in to Power Center as ODBC driver replacement.

Built and configured shared as well as dedicated ETL environments for

•

applications.

Worked in various relational database environments including Oracle, UDB DB2,

•

SQL Server, etc. and strong knowledge of database programming using SQL,

PL/SQL,T SQL, Stored procedures and Triggers .

Strong knowledge of programming in UNIX Shell scripts. Extensively used shell

•

programming to code Automated Startup Scripts, Log and file space monitoring,

Setting up Production Alert Mechanisms for ETL, etc.

Excellent communication, interpersonal and Team organizing skills.

•

Excellent Analytical & Programming skills.

•

TECHNICAL SKILLS

Data Warehousing /ETL

Informatica PowerCenter 8.x/7.x/6.x/5.1.x, PowerMart 4.7, Power Exchange,

•

PowerChannel 7.x, PowerConnect

EAI – Enterprise Application Integration

JCAPS 5.3/ 6.2, ICAN, See Beyond, CrossWorlds, IBM MQ Series

•

EDI/B2B – Electronic Data Interchange

Axway Synchrony Integrator, GXS Enterprise, Application Integrator, Tradeguide,

•

McAfee Ebusiness Server

Operating Systems

Sun Solaris 5.8,5.9,5.10, IBM AIX 5.3, HP UX 11.0, Red Hat Linux 5.2, Win Server 2003

•

Languages

Proficient in coding UNIX shell scripts: bash, korn and their derivatives

•

Worked with Perl, Sed/Awk constructs for data cleansing and other operations.

•

Worked with VB scripts

•

Familiar expertise in relational database programming using PL/SQL and T SQL

•

Familiar with: C, C++

•

Databases

Oracle, DB2 UDB, SQL Server

•

Environment & Tools

Control M, Autosys, Maestro, NDM Network Data Mover, Serena Changeman, BMC

•

Patrol – Perceiver monitoring

ERWIN, Ms Visio, Ms Project, Toad, SQL Plus, Rocket Shuttle.

•

•

EXPERIENCE

Sr. Systems Engineer Apr’ 08 – Present

Borders Group Inc., Ann Arbor, MI

Borders is the second largest bookstore chain in the United States and an international

•

bookseller. Role was to administer the shared Integration platform encompassing

various technologies in ETL, EAI and EDI/B2B space. While retaining focus as a lead

Informatica administrator/architect, the role also required simultaneous administration

of various Middleware platforms such as JCAPS, ICAN, CrossWorlds and B2B

platforms such as GXS Enterprise and Axway Global’s Synchrony Integrator.

•

ETL – Informatica 8.5.1/ 8.6.2

•

•

Administered and reengineered existing Informatica v8.5.1 platform on 32 – bit

•

Windows Enterprise Server 2003.

Architected, installed and configured Informatica v8.6.2 platform on 64 bit RedHat

•

Linux 5.2 Advanced OS.

Upgraded existing repositories from v8.5.1 to v8.6.2

•

Leveraged Red Hat Global File System GFS with its limitations to build and configure

•

Informatica services in a Highly Available and Grid framework.

The shared file system needed for Grid and HA options was reinforced with hardware

•

fencing to prevent file system corruption during node failures

Provided 24/7 Oncall support for level 1 Administration.

•

Set directions for ETL migrations and deployed/ migrated several projects to

•

Production environments.

Highly instrumental in developing standards and best practices for the development

•

Teams.

Administered user authentication and access controls within the published

•

guidelines of the corporation that was based on SOX compliance on a COBIT

framework.

Above was accomplished on the shared ETL platform by a variety of measures

•

available in the Informatica toolset as well by working in liaison with Data Security

teams, Database Administrators, System administrators and Platform Engineering

teams.

Maintained necessary licenses for PowerCenter Advanced Edition

•

•

•

EAI – JCAPS, ICAN, SeeBeyond, CrossWorlds, MQ Series

•

•

Provided 24/7 level 1 Administration support for JCAPS, ICAN SeeBeyond and

•

CrossWorlds Platforms

Participated as infrastructure engineer in the planning, design, test and

•

implementation phases of various projects including the launch of Borders.com

( ecommerce), Special Order Processing (SPO).

Migrated and deployed code among various environments including QA, UAT and

•

Prod.

Prepared Code drop instructions for Release / Change management Team for the

•

above

Administered several interfaces including Http/s, SFTP, FTP to name a few.

•

Designed and built a custom Key Performance Indicators (KPI) reporting interface to

•

the management

Ensured that the environment withstood auditing requirements for Payment Card

•

Industry (PCI) standards to protect card holder data

Installed and supported high availability message framework using Java Messaging

•

Grid (JMS)

Provided troubleshooting and technical resolution for Special Ordering Process

•

required for Borders retail store chains which was deployed on CrossWorlds platform

with IBM MQ Series as the messaging backbone making several check availability

and order placement calls in real time

Worked with Totality/ Verizon enginee rs in troubleshooting, maintenance and

•

reporting statistics for Ecommerce real time interfaces to Avalara ( Address and Tax

check calls ) and CyberSource ( Credit card validation and fraud detection )

Worked with Sun Support on troubleshooting production issues, such as performance

•

issues, JMD Grid sync failures etc.

Applied ESR Rollups and Patches for JCAPS 5.1.3

•

•

EDI/B2B Axway Synchrony Integrator, GXS Enterprise, Application Integrator

•

•

Provided 24/7 level 1 Administration support for EDI/ B2B platform

•

Responsible for Development, Deployment and Post Implementation Support

•

Domain experience includes Order Management (Retail and Ecommerce) and Supply

•

Chain Management

Worked in a B2B environment that interacts with 450+ Trading Partners 24/7

•

Managed and updated contacts for all of these vendors on a periodic basis.

•

Gathered requirements, designed and provided end to end implementation; from well

•

documented Tech designs, EDI mappings, test cases to automated electronic

exchanges with Fulfillment Partners.

Created Trading Partner profiles and VAN setup for Vendors.

•

Setup up and maintained AS2 connectivity for limited vendors

•

Implemented mailbox functionality in GXS Enterprise

•

Worked on EDI standards ANSI X12 and EDIFACT

•

Leveraged McAfee Ebusiness Server to pgp encrypt and decrypt external traffic via

•

SFTP/ FTP interfaces .

Worked extensively with ANSI X12 Incoming and Outgoing Business Transactions –

•

850, 855, 860, 865, 856, 810, FA997 etc) and their subsequent revisions.

Provided automated and on demand weekly statistics to management on EDI and all

•

B2B transactions for the organization.

Environment: Informatica PowerCenter 8.5.1/ 8.6.2 Metadata Manager, Data Profiler,

JCAPS 5.3/6.2, ICAN, See Beyond, CrossWorlds, BlueStone, IBM MQ Series, QPASA,

GXS Enterprise, Application Integrator, Tradeguide, Axway Synchrony Integrator, Mcafee

Ebusiness Server, AS/400, MainFrame, Windows 2003, AIX 5.3, Oracle, DB2 UDB,SQL

Server, Control M, Big Brother

S r. ETL/Informatica Administrator Oct’ 07 – Apr’ 08

Syntel Inc. (American Express), Phoenix, AZ

Employed by Syntel, assignment was to support one of the company’s biggest client –

American Express.

•

American Express is one of the nation's largest fortune 500 companies providing a

•

wide range of banking and financial services. The project scope involved a full time Sr.

ETL Informatica administrator that includes setting up of 24/7 offshore support spread

across Accenture, Cognizant and Syntel resources. Scope also included providing

Level 1 Infrastructure Administration Support in addition to Level 2 Informatica

Administration Support under the umbrella of a standardized CoE (Center of

Excellence) Model. Role was embedded as a direct report to Chief Technology Office

(CTO) that oversees various ETL environment builds, code build, deployment and

migrations across the Account Receivables and Rebate and Rewards platforms. Role

was to provide a roadmap and restructure Business Intelligence and Data Warehousing

(BI&DW) division.

•

Installed and Configured Informatica 8.1.1 on 64 bit AIX and Solaris platforms

•

Configured and defined Domain and nodes per requirements across E1, E2 and E3

•

environments.

Architected Server Grid Technology .

•

Architected, Configured and Tested built in high availability framewor k that can

•

natively handle failovers, recovery and resilience across all PowerCenter servers ( Data

Integration server, Repository server, JBOSS/Tomcat Servers ).

Worked with IBM Team to migrate from IBM Legacy SAN to EMC SAN.

•

The above was needed to implement shared SAN using VERITAS Clustered File

•

System (VCFS) in order to leverage High Availability (HA) and Grid options provided by

PowerCenter v8 Advanced Edition

Handled the installation of Meta data Manager and DataAnalyzer components of

•

PowerCenter v8.

Configured Advance Edition tools like Data Analyzer (Power Analyzer) and Metadata

•

Manager on Version 8.1.1, Performed Metadata queries and Reports.

Procured and maintained necessary licenses for Advanced Edition, Pushdown

•

Optimization etc.

Configured the licensing and usage of UDO (Unstructured Data Option)

•

Installed and Configured PowerExchange Clients on UNIX platform

•

Configured the environment for MQ Series connectivity.

•

Configured the build of DataProfiler Warehouses .

•

Management of permissions and privileges, Identification of possible security loopholes

•

and responsible Security focal point of contact for security across the ETL

environment.

Environment: Informatica PowerCenter 8.1.1, MetaData Manager, Data Analyzer, Power

Exchange, PowerConnect for MQ Series, Flat Files and Mainframe Datasets, Solaris,

AIX, DB2 UDB, Control M, NDM.

Sr. ETL/Informatica Administrator Aug’ 06 – Sep’ 07

VSoft Consulting Group (National City Bank Corp)., Strongsville, OH

Employed by Vsoft, assignment was to support IT work at one of their client – National

City.

National City Corporation, headquartered in Cleveland, Ohio, is one of the nation's

•

largest financial holding companies providing a full range of banking and financial

services. The project scope involves full time ETL Informatica administration that

includes (on call) level 1 Infrastructure Administration Support. Role was embedded in

National City’s core Center of Excellence that oversees and undertakes various ETL

environment builds, code build, deployment and migrations across the selling divisions

and portfolios. Role was an integral part of Common Services and Enterprise Data

Support.

•

Proof of Concept Informatica v.8.x parallel upgrade activities

•

•

Installed, Configured, upgraded Informatica 8.1.0/8.1.1 32/64 bit on 32/64 bit AIX and

•

Solaris platforms

Architected and Tested Server Grid Technology.

•

Architected, Configured and Tested built in high availability framework that can natively

•

handle failovers, recovery and resilience across all PowerCenter servers (Data

Integration server, Repository server, JBOSS/Tomcat Servers).

Implemented SAN disks which were shared between all the clustered environments so

•

that the files/scripts are not distributed across multiple nodes.

Upgraded from Version 7.1.3 to Version 8.1.0(32bit) and then from 8.1.0 to 8.1.1(32/64

•

bit)

Installed and configured Data Analyzer (Power Analyzer) and Metadata Manager on

•

Version 8.1.1, Performed Metadata queries and Reports.

Maintained necessary licenses for PowerCenter Advanced Edition and ensured that

•

utilization stayed within licensing limits.

•

Primary/ Day to Day Responsibilities at NCC

•

Installation and Configuration of 7.1.3 Informatica Server services, setting up

•

multiple ETL environments for a project’s lifecycle including Class 3 Production builds.

Developed UNIX scripts for automated startups, backups, services monitoring, and

•

File Disk space cleanup among others.

Scripted NDM and PowerChannel batches for file transfers between Mainframe and

•

Solaris Informatica servers.

Coordinated Capacity Planning, Hardware Sizing and Implementation plan for

•

Center of Excellence and other selling divisions/ portfolios that fall out of CoE’s scope.

Played the role of Technical advisor during Project initiation phases, build and

•

helped define Scope of Work and Service Level Agreements between CoE, Common

Services and portfolios/ applications that require ETL services.

Debated the pros and cons of technical roadblocks between onsite and onsite

•

offshore models of project development. Helped engage successful, secure and cost

effective outsourcing scenarios.

Management of permissions and privileges, Identification of possible security loopholes

•

and responsible Security focal point of contact for security across the ETL

environment.

Modeled and enabled Audit Trailing and recertification processes to ensure

•

consistent data and system security settings for and through System Test cycles, Quite

Production and Production environments.

Coordinated ETL Developments to Off shore, India with TCS ODC. Primary role being

•

Point of Contact for NCC Informatica Infrastructure and ETL Administration.

Environment: Informatica PowerCenter 7.1.3, PowerChannel, Power Exchange,

PowerConnect for MQ Series, Oracle, Flat Files and Mainframe Datasets, Solaris, AIX,

SQL Server, DB2 U, Autosys, Rocket Shuttle, NDM, Serena Changeman.

J ohnson and Johnson, Titusville, NJ Oct’ 05 – July’06

ETL Architect/ Informatica Administrator

Employed by Vsoft, assignment was to support IT work at one of their client – Johnson

and Johnson.

Johnson and Johnson is a provider of various pharmaceutical services and is a well

established pioneer in the industry. The project is a liaison between J&J and HCL, which

is an IT based company providing software solutions for various multinational companies.

The scope of the project included Onsite coordination for Data warehousing/ Business

Intelligence sectors of HCL Offshore development Centers (ODC’s) while concurrently

fulfilling the roles of ETL Architect and Informatica Administrator at the Client’s site.

Upgrade and configuration of ETL environment to Informatica 7.1.2 from Informatica

•

5.1.

The above includes installation of 7.1.2 Informatica Servers, setting up Development,

•

Staging and Production environments, and upgrade of Repositories.

Support and monitoring of ETL applications using Informatica Clients.

•

Management of permissions and privileges in accordance to the existing

•

development, staging and production environments.

Advised and trained existing users of 5.1 to the benefits and features of latest

•

Informatica version 7.1.2.

Successfully completed J&J sponsored training for a. Safe Harbor Privacy Training for

•

US HR Professionals and b. Information Asset Protection Policies Training ( IAPPT ).

Application, Maintenance and Support for HR application HR data warehouse that

•

acts as a HUB for various corporate data sources; scope includes overseeing the

development of minor patches.

Architect and Design customized Informatica ETL interface to Siebel CRM system.

•

Was primarily responsible for analysis, requirements gathering and design of the ETL

interface to the redesigned Sales force demographics source system.

Environment: Informatica PowerCenter 7.1.2, Oracle 9i, Cognos, Flat Files, HP UX 11.0,

SQL, PLSQL, Toad, Siebel CRM.

Time Warner Cable, Charlotte, NC May’ 05–Aug’ 05

Informatica Administrator

Employed by Kapisys Inc., assignment was to support IT work at one of their client – Time

Warner Cable.

Time Warner Cable, Charlotte division is a provider of various telecom, internet and cable

services. The project required the creation of separate Telephony datamart to leverage

billing data from existing ODS stages. The sources were from ICOMS and CSG billing

systems. The datamart was built on Oracle. The installation and configuration of

Informatica 7.1.2 on UNIX platform was successfully implemented.

Installation and configuration of Informatica PowerCenter 7.1.2 Server on UNIX

•

Creation of Informatica Repository on Oracle platform.

•

Extensively used Informatica Repository Manager and Informatica Repository Server

•

Administration Console .

Installation of Clients on Windows platform.

•

Created folders and logins for the users and assigned the necessary privileges .

•

Managing permissions and privileges in accordance to the existing development and

•

production environments.

Regularly schedule hot and cold backups of the Repository meta data .

•

Environment: Informatica PowerCenter 6.2/7.1.2, Oracle 9i, Cognos, Flat Files, AIX 5.2,

SQL, PLSQL, Toad, WinCVS.

E DUCATION

University of Tulsa

Tulsa, Oklahoma

M.S., Electrical Engineering

•

U niversity of Madras

Chennai, India

B.E., Electronics and Communications Engineering

•

Contact this candidate