SUMMARY:

• I bring 11+ years of information technology experience covering all phases of the system development and maintenance life cycles. I have worked in private sectors. I compliment my technical background with experience in a wide range of industries, including transportation, healthcare, retail and financial services.
• As a Team Leader, Systems Analyst, Application Support Analyst, ETL Lead and/or Senior ETL Developer in the Systems Delivery Practice and the Business Intelligence Practice at my employments/contracts with Capgemini and TCS, I proved to be and effective and reliable IT Professional. Working as an Informatica Admin - Daily tasks such as running repo queries, copying objects using labels from DEV to INT to TEST to PROD Repositories, version control, etc. Created and managed DB connections, User Groups, Users (Security), Folder Permissions.

TECHNICAL SKILLS:

Operating System: Unix, Linux, Windows XP, Mac OS

Environment: Client/Server

Database: Oracle 10g,Oracle 9i,Sybase,DB2

Internet Tools: HTML,XML

Languages: PL/SQL, Java, Visual Basic

Other: Powercenter 8.6.1,Powercenter 7.1.3,Data Modelling, Toad, SQL Advantage,DB Artisian,autosys

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Mid-Tier Informatica Administrator

• Monitoring the Application Services thru Site Scope / NetIQ. Deploy the etl folders from lower environments to PROD.
• Installed the Informatica 7.1.1/8.1.1 SP 3/8.6.1/9.0/9.5.1 and BO 6.5/XI on the Physical Servers.
• Applying the EBF patches and Service Packs for Informatica.
• Prepared the Test Cases and Test Plans for Operational Acceptance Testing using Quality Center to verify how the new project impacts on the Server with existing applications running.
• Upgraded the Informatica versions from 6.2 to 7.1, 7.1 to 8.1.1. SP3, 8.1.1 SP3 to 8.6, 8.6 to 9.0, 9.0 to 9.5.1
• Coordination between the Application team and Firewall team to resolve the firewall issues on the application servers for the upstream data loads.
• Maintaining Informatica Repository and Business Objects Servers.
• Escalation of Informatica Issues to Informatica Tech Support
• Supporting the application project team’s requests on adhoc basis.
• Verifying the data source connectivity, coordinating the Outages, Disk Space issues, Login issues on Citrix.
• Worked with infrastructure teams to ensure an effective operating environment
• Defined standards and implemented INFORMATICA best practices.
• Supported highly available and distributed ETL environment.
• Imparted 24/7 on call support on a monthly rotation basis.
• Defining the Job Groups, Jobs, Job dependencies on Tidal Enterprise Scheduler
• Setting the Tidal Job rules and defining schedule dependencies

Environment: Informatica 9.5.1/9.0.1/8.6.1/8.1.1/7.1/6.2, Informatica Data Quality, Data Profiling, Data Explorer, Informatica Power Exchange, Tidal Enterprise Scheduler, Sql Server 2000/2005/2008/2008 R2, Solarc 11.01/11.02/11.03/11.06, Business Objects XI / 6.5.1 / 5.1, Site scope, NetIQ, Informatica Web services, Informatica Data Quality, Data Profiling, Kalido DIW/MDM, Oracle 10g, MAXIMO, SAP R/3, Test Director, Clear Case, Clear Quest, Remedy, Sun Solaris, Windows 2003

Confidential, NY

Consultant-Level2 specialist

• ETL Application Registration (Fully Hosted/Evaluation Only/Review the config file/Create Unix File system/Create an opportunity in SFDC)
• EBIS Web Calender and status Report
• Informatica SCM(Folder Level migration/Object Level Migration)
• Informatica object Migration using Repository Manager
• Informatica Administration activity(by using Admin console)
• Code review of mappings of various application across plant
• Give expert solution to the users for problem in informatica
• Application De - Registration
• EBIS Knowledgebase(creating twiki,Categorization,velocity)
• EBIS Turnover policies/procedures(SCM)
• Outage Handling(Escalation Procedure,Running metadata queries and procedures,checking database blocking,creating outage log)
• Troubleshooting user's problems (application and infrastructure related)
• Coordinating with users for migrating code from Informatica 7.1.3 to Informatica 8.6.1

Environment: Linux,Windows XP,Informatica Powercenter 7.1.3, Informatica Powercenter 8.6.1,sybase

Confidential,Georgia

Team Leader/ETL Developer

• Leading a team of 4 members
• Gathering of requirement of client's report requirement
• Designing of aggregate tables for user's reports
• Designing new datamarts
• Analyzing,designing and developing Extraction, Transformation and Load (ETL) processes for aggregate tables using Informatica 7.1.3
• Loading data from data warehouses to data mart.
• Reviewing ETL work from other team members
• Deploying the ETL at client side.
• Scheduling the informatica using autosys

Environment: MAC O/s,Unix,SQL,PL/SQL,Informatica Powercenter 7.1.3

Confidential

Support specialist and team leader

• Monitoring the remedy queue (alert message,tickets)
• Resolving the issue with in SLA
• Developing informatica mapping by using Powercenter 7.1.1
• Support all Informatica daily admin tasks
• Monitoring MQ series queue
• Coordinating with Tier2 group and client
• Conducting KT session with new team members
• Leading team of 4 team members

Environment: solaris2.6,Windows NT,Oracle 8i,informatica powercenter 7.1.1,Toad,IBM MQ Series,Citrix ICA Client,Remedy Version 4.05.01

Confidential,Chicago,Illinois

ETL developer

• GE Capital Rail Services (Rail), headquartered in Chicago, Illinois, is a global rail service provider of equipment, logistics and information. GE Rail's diverse fleet includes railcars of every major car type and several specialty car types.
• GE Rail offers many rail leasing options and financing structures, as well as railcar repair, maintenance and administrative services. GE Rail's customer base includes railroads and industrial shippers throughout North America and Europe.
• The overall objective of this project is to integrate TIP Inter Modal's data and applications with GE Rail data and applications. This will involve data migration, customization of existing GE Rail applications and acquisition & customization of TIP applications for use by GE Rail.
• The activities to be carried out include design, development, system and user acceptance testing and implementation for TIP Integration work.GE Rail is trying to consolidate all the rail's business applications, which have touch-points with the customer to be implemented through Siebel.
• Siebel has been identified as the flagship product for GE Rail's CRM strategy. As a part of this consolidation exercise, a decision has been taken to move the Quote Process and the Master Contract Process from AS/400 to Siebel. It has also been decided to move the Sales Pipeline, a web based application, to Siebel. As a part of TIP initiative, Asset Sales, Quote Process and Renewal Process for TIP equipment would also move to Siebel.

Confidential

Actuate Report Developer

• As an actuate report developer my tasks included are
• Analyzing the user's reporting requirement preparing design document for reports
• Preparing report layouts preparing reports using actuate5.0 testing the actuate reports preparing the user document

Environment: Windows2000,Oracle 8i,SQL,PL/SQL,Visual Basic 5.0,Actuate5.0,Toad,Citrix ICA Client