SUMMARY

• Around 8 years and 2 months of IT experience and technical proficiency in the field of Data Warehousing and worked as Developer/Informatica Administrator/Architect
• Strong Informatica Administration & Architecture skills in building brand new Informatica Environments, Managing the Repositories.
• Project Leader & primary contact for Confidential ’s Informatica Architecture and application.
• Proficient in UNIX Shell Scripting.
• Configured Informatica environments for Confidential business including Rail, Aviation, Energy Services & Power systems, Shared Services.
• Strong Power center Development experience. Worked extensively on various Data warehouse projects having Informatica, Cognos technologies.
• Experienced in upgrading the Power Center Environments from v7 to v8 and v8 to v9, with different integration which includes POWER EXCHANGE FOR DB2, SALES FORCE, TERADATA
• Experienced in Powerexchange for SAP for ALE - IDOCS,SAP-R3 through ABAP, BAPI-RFC function setup and development.
• Implemented PUSHDOWN OPTIMIZATION (PDO) solution for better performance and optimization.
• Implemented Powerexchange for Greenplum using odbc interface and loader utility for Power and Water business.
• Expert in setting up the Powerexchange CDC RAC and non-RAC oracle environment relational source.
• Strong Experience in Disaster Recovery design plan for power center environment. Participated in many DR Drills.
• Extensive experience in Business Intelligence. Experience in integrating the power center environment with Cognos cube refresh and BO report refresh.
• Handled environment having 15 V9 repositories.
• Expert in designing ETL and Development Solutions Architecture without compromising performance with low costs.
• Expert in Performance Analysis, Memory Analysis and code tuning for ETL workflows.
• Able to work in multi-functional projects with strong logical and reasoning skills and innovative problem-solving skills, proven ability to adapt new tools, languages and operating tools.
• Experienced in Cognos reporting development.
• Configured Proactive Monitoring Tool (version 3.0) for PowerCenter 9.6
• Implemented In-palce-upgrade successfully from PowerCenter 9.1 to 9.6

TECHNICAL SKILLS

Operating Systems: Windows NT, Windows 2000, Solaris, Unix, Linux

Databases: Oracle 8i, 9i, 10g & 11g MS SQL Server 2000, MS-Access, My SQL, Teradata, DB2

Languages: C/C++, SQL, PL/SQL, Unix Shell scripting

ETL Tools: Informatica 7.x/8.x/9X (Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Designer, Workflow Monitor, Workflow Manager), Toad, SQL Developer,TOAD, Putty, Powerexchange for salesforce, Teradata,DB2 & SAP

BI Reporting Tools: Cognos

CDC Tools: PowerExcahege CDC

PROFESSIONAL EXPERIENCE

Confidential - Cincinnati, OH

INFORMATICA ARCHITECT, Project Technical Lead

Responsibilities:

• Project lead for a team of 15(1 onsite and 14 offshore)
• Ensuring 24x7 production support and reporting various production issues encountered to customer on daily basis.
• Involve in the design, development and implementations of the Enterprise Data Warehouse (EDW) Data marts providing inputs and reviews at various stages of the project from run team prospective to improve performance from ETL loading and reporting prospective.
• Answering the technical queries, driving the product initiatives and metrics collection & analysis.
• Creating, updating and maintaining technical documentation for tools and projects involved as required.
• Heading the change managements for code promotions into production for various technologies
• Inspection, reviews, performance tuning and arranging meetings for defect preventions.
• Planning the schedules for maintenance of applications and servers.
• Preparing business continuity plan as the DWH reports are used on daily basis to assess the risk of various power projects and make important decisions.
• Co-ordination with design teams and technical support of different tools to improve performance and availability along with installation and configuration of the data warehouse tools as required.
• Solution architect for Business and Project teams to choose Powercenter products
• Automating Aglie manual process in powercenter Administration which will reduce tickets and SLA’s.
• Handling Proof of Concepts for New Powercenter tools and design configurations to fit Confidential Environments.
• Preparing presentation, Case studies with POC results and taking GO or NO - GO decisions

Environment: Oracle 11g/10g/9i/8i, Informatica 8.x, 9x TOAD, Unix/Linux, Perl, Teradata

Confidential

Team Technical Lead

Responsibilities:

• Understanding the existing requirements and logic implemented
• Development of complex ETL mappings
• Development of Cognos Reports
• Involved in the Peer Review of every Mappings in the project
• Identifying and resolving the issues.
• Performance Improvement of ETL codes
• Implementation of new requirement

Confidential

Developer

Responsibilities:

• Understanding the requirements completely as per the Specification and applying the changes.
• Development of Procedures
• Performance Tuning of Jobs process, identifying and resolving performance Issues.
• Involved in the Peer Review of every Report in the project.