ROLES

INDUSTRIES

• Data Integration Lead
• Data Integration Lead
• Data Integration Lead
• Technical Architect
• Informatica Architect
• Lead Data Architect, ETL Designer, ETL Developer
• PMO Content, Support to CRPII
• Informatica Tech Lead, Analyst, Project Lead
• Project Leader-Offshore
• Project Leader-Offshore
• Informatica / Data modeling, Oracle8i DBA
• Oracle9i DBA, Project Leader
• Oracle 8i DBA, Project Leader, Analyst Programmer
• Oracle DBA, Team/module Leader
• Oracle DBA, Team Leader, Analyst, Designer
• Oracle DBA, Team Leader, Designer, Programmer
• Analyst Designer, Team Leader
• Team leader, Designer, Programmer
• Designer, Programmer
• Programmer

• Marketing
• Healthcare Services
• Computer Software
• Telecommunications
• Entertainment
• Pharmaceuticals
• Financial Services
• Computer Networking
• Travel Tourism
• Travel Tourism
• Telecommunications
• Telecommunications
• Computer Hardware
• Automotive
• Automotive
• Automotive
• Electricity
• Automotive
• Automotive
• Automotive

ETL

ETL Informatica 9.5.1/8.6 /7.x/6.x/5.x, Certified Informatica 8 Designer, Certified Informatica 6.x Consultant.

Pentaho

Oracle Data Integrator ODI v10.1.3.5

BI

BI Concepts, Reasonable knowhow of Cognos and OBIEE Oracle Business Intelligence Enterprise Edition tools.

Data Integration

Informatica XE B2B , Complex Data Exchange CDE/DT

Tools

ERWin, Designer 6i, Informatica PowerPlug, TOAD, SQL Station, Advanced Query Tool, Quest Central for DB2, Rational Rose, VSS, PVCS, MS-Office, MS-Project etc., Alliance Remedy 4.05.02, Universe

Databases

Oracle 11g/10g,/9i/8i/7.x, Oracle 8i DBA , Integrated DBMS of AS/400, DB2 v7

MySQL

Languages

C, C , Pascal, RPG/400, CL/400, SQL, Oracle PL/SQL, Java2

GUI

Developer/2000 Rel 1.3 Forms 4.5, Reports 2.5 , Developer 6i

Application Server

Powertier 6.0, Exposure to Oracle9i Application Server

Internet Technology

Basic knowledge of Java, Servlet, JSP, XML/XSL

Hardware

HP servers Infinity, AS/400

O S

Windows NT, Unix Sun Solaris 5.8 , Windows, MS-DOS, OS/400, AIX Unix Server

Role: Data Integration Lead

Responsibilities:

• Managing EDW environment and multiple sub-projects
• Involved in many other data acquisition projects and analysis
• Pentaho to Informatica ETL conversion
• Involved in BI migration to Cloud Savvis
• Daily, weekly and monthly data load monitoring Informatica ETL and monitoring. Resolve issues if any during the data load. Enhancement/changes to the system.
• Mentoring the team for any technical issues.
• Point of contact for EDW data issues, International projects and other Data Acquisition projects.
• Regular discussion with respective offshore coordinators for critical decisions and/or planning.
• Prepare weekly status report and discuss with client Managers for any queries/decisions

Technical Environment: Oracle 11g/10g, Informatica 9.5.1/8.1, TOAD, Cognos 8.3, MySQL, Pentaho

Confidential

Role: Data Integration Lead

Responsibilities:

• Managing multiple projects and pool of resources to meet the need of offshore support/development
• Daily, weekly and monthly data load execution Informatica ETL and monitoring. Resolve issues if any during the data load.
• Follow-up with users and team to resolve the issues.
• Enhancement of SSIS ETL packages. Support to SSIS and Cognos administrative queries.
• Mentoring the team for any technical issues.
• Managing a team of 4 technical persons and tracking their tasks
• Single point of contact for offshore development and support.
• Regular discussion with respective onsite coordinators for critical decisions and/or planning.
• Prepare weekly status report and discuss with client Managers for any queries/decisions

Technical Environment: Oracle 10g, SQL Server 2005, Informatica 8.1, SSIS 2005, TOAD, Oracle Data Integrator ODI , Oracle Business Intelligence Enterprise Edition OBIEE , Oracle 10g, SQL Developer.

Role: Technical Architect

Responsibilities:

• Resolving Sales related issues.
• Communicating with business users to resolve their issues and other groups such as Marketing and Finance sustainment.
• Follow-up with users and team to resolve the issues.
• Mentoring the team for any technical issues.
• Managing a team of 4 technical persons.

Technical Environment: Informatica 8.5, Oracle 10g, Teradata, PL/SQL, Teradata SQL Assistant 7.1, Unix.

Role: Informatica Architect

Responsibilities:

• Study existing EAI system and come up with the architecture to implement using Informatica B2B tool.
• Set the standards and methodologies for developers providing sample use cases.
• PoC of new features/technologies and guide the developers to use the same.
• Design ETL architecture for the project

Technical Environment: Informatica 8.5.1/8.6, Informatica B2B XE , Complex Data Exchange Data Transformations , Oracle 10g, PL/SQL, Unix.

Role: Lead Data Architect, ETL Designer, ETL Developer

Responsibilities:

• Study AS-IS SCM Process Map from already existing ETL mappings.
• Determine effort estimates for each module for ETL part.
• Design and implement necessary changes in the mappings as per Abbott's standards including data error handling, purging strategy and incremental data load strategy.
• Develop transformation specs for each mapping.

Technical Environment: Informatica 6.2, Oracle 8.1.7, PL/SQL, Cognos 7, Coldfusion, Unix.

Role: PMO Content, Support to CRPII

Responsibilities:

• Provide support to CRP Conference Room Pilot phase II to business users.
• Understand and execute functional test scripts.
• Do Technical Review of ETL scripts and Oracle Workflow.
• Provide substance to the Model Office Testing Project Management.
• Interact with all Business Groups Canada, US and Corporate and around 34 Business Units.
• Create standards' documentations and governance model.
• Create Model Office Test Plan document.
• Study the Defect Management and create accordingly for Model Office.
• Tracking of Action Items and Issue Logs.
• Track all phases of the project by generating consolidated status reports of all Business Groups and Business Units.
• Follow-up for Model Office sign-off.

Technical Environment: Oracle Financials, Unix, Mainframe, OWB, Oracle Workflow, OFA, Oracle Discoverer, Oracle 9iR2 database, Lotus Notes, Test Director.

Role: Informatica Tech Lead, Analyst, Project Lead

Responsibilities:

• Providing maintenance and support to the Customer Insight module, part of Marketing IT and G2C Managed Services.
• Monitoring data load batch jobs on daily basis.
• Implementing Enhancement or Change Requests.
• ETL load tuning.
• Onsite coordinator for the onsite-offshore module.
• Hardware and enhancement estimation and impact analysis. Supporting application engine and supporting tools.

Technical Environment: Informatica 5.2, Oracle 8.1.7, Toad, Livelink, Visio, ERWin 5.x, Remedy Alliance Software , Universe, Unix.

Role: Project Leader-Offshore

Responsibilities:

• Providing support to the Siebel CRM application.
• Monitoring data loads on weekly basis.
• Collecting statistics and analyzing the same.
• Implementing Problem Reports or Change Requests. ETL load tuning.

Technical Environment: Informatica 5.2, DB2 v7, Quest Central for DB2, Advanced Query Tool, Unix.

Confidential

Role: Project Leader-Offshore

Responsibilities:

• To implement the Data Warehouse to help the client to increase the Siebel Marketing functionality, Requirement analysis, design, estimations, data modeling, ETL design and development with

organization quality standards of CMM level 5, client interaction, on time delivery, job scheduling, task assignment, impact analysis etc.

Technical Environment: Informatica 5.2, DB2 v7, Quest Central for DB2, Advanced Query Tool, Unix.

Role: Oracle8i DBA, Informatica / Data modeling

Responsibilities:

• Primary responsibility as a Oracle 8i DBA, Capacity planning for data mart, Partitioning, Datamart creation scripts.
• Scripts to check for DB, Informatica and Servers are up or down for every sixth hour.
• Developing Informatica Mappings.
• Data modeling in Designer 6i, Metadata transfer with Informatica PowerPlug,.

Technical Environment: Informatica 5.1, Oracle 8i, Informatica PowerPlug, Designer 6i, Brio Reporting tool, TOAD.

Confidential

Role: Oracle9i DBA, Project Leader

Responsibilities:

• Primary responsibility as a Project Leader and evaluation of Oracle9i Database and Oracle9i Application Server features.
• Evaluation of new features of Oracle9i database and Oracle9i Application Server.
• Deploying sample applications and verifying results.
• Handling a team of developers. Project scheduling, tracking, job assignment etc.

Technical Environment: Oracle9i Database Rel 2, Oracle9i Application Server.

Role: Oracle 8i DBA, Project Leader, Analyst Programmer

Responsibilities:

• Primary responsibility as a Project Leader.
• Analysis and design the system.
• Project estimation, scheduling, tracking, testing and delivery.
• Resource usage and managing the module/project etc.
• As a DBA involved in Oracle installation, Database Configuration, Security management, Database and Application Tuning. Functional and requirement specifications.
• Design, analysis and data modeling of the module Product Configurator.
• Leading the modules Invoicing and Product Configurator.

Technical Environment: Oracle 8i ver 8.1.7.0.0 , EJB Powertier 6.0.

Role: Oracle DBA, Team/module Leader

Responsibilities:

• DBA, Consultant to specify the hardware requirements and propose for future according to the customer requirements.
• Database and application tuning.
• Implementing Back-up and recovery strategies.
• Specifying hardware requirements to extend the database size.

Technical Environment: Oracle 8.x, 7.x on Windows NT, PL/SQL.

Role: Oracle DBA, Team Leader, Analyst, Designer

Responsibilities:

• User requirement specifications, analysis and design of the system.
• DBA activities like Database sizing, Back-up and recovery strategies etc.

Technical Environment: Oracle 7.x on Windows NT, PL/SQL, Developer/2000 Rel 1.3 Forms 4.5 and Reports 2.5 .

Role: Oracle DBA, Team Leader, Designer, Programmer

Responsibilities:

• User requirement specifications, Analysis and design of the system.
• DBA activities like database sizing, back-up and recovery strategies etc.,
• Team leading for different modules involved in the system.

Technical Environment: Oracle 7.x on Windows NT, Developer 2000 Rel 1.3 , Forms 4.5, Reports 2.5., PL/SQL.

Role: Analyst Designer, Team Leader

Responsibilities:

• User requirements specifications, Analysis and design of the system. DBA role, Test plans etc, Team Leader.

Technical Environment: Oracle 7.3 on Unix Sun Solaris , Developer 2000, Forms 4.5, Report 2.5, PL/SQL, VC Handheld version of TouchStar.

Role: Team leader, Designer, Programmer

Responsibilities:

• Implemented Payroll at one of the site of the client working as Site incharge with a primary responsibility for the System requirement specification, Design, Development and implementation, Team leading, user training, DBA role includes Database creation, Back-up and recovery strategies etc.

Technical Environment: Oracle 7.2 on Windows NT, PL/SQL, Developer 2000 Rel 1.3, Forms 4.5, Reports 2.5, C language.

Role: Designer, Programmer

Responsibilities:

• Design and programming, User interactions and user training.

Technical Environment: Oracle 7.2 on Windows NT, Developer 2000 Rel 1.3, Forms 4.5, Reports 2.5, PL/SQL.

Role: Programmer

Responsibilities:

• Programming, User interaction and user training.

Technical Environment: AS/400, RPG/400, OS/400, CL/400, SQL/400, SDA, RLU, FEU, SEU etc.