Ashveen Kumar, PMP LinkedIn:

Cell: 403-***-**** Email: adjwzb@r.postjobfree.com Informatica Administrator, Developer (Powercenter, AXON, EDC)

SUMMARY:

PMI Certified Project Management Professional (PMP) having 16 years of experience in Information Technology Industry with expertise in developing and maintaining Business Intelligence and Data Warehouse applications.

Experience in interacting with business users to analyze the business process and requirements and transforming them into functional and technical requirements. Excellent communication skills, client interaction, documentation and presentation skills.

10+ years of experience in Informatica (Administration, development and support) projects using Informatica Power center (8.x,9.x,10.x). Involved in development, Installing, Upgrade, Administer, Analyze, Design and implementation of Data warehousing ETL solutions using Informatica Power Center, Metadata Manager, Data Validation Option, BDM, IDQ, EDC, Data Lake

Configured the Informatica BDM/BDQ/EIC/IDL 10.1/10.2.1 and integrated with the Cloudera and Horton Hadoop Frameworks

Strong concepts in metadata management, metadata capturing from various sources (traditional, Big Data and Cloud systems), data lineage, data domain classifications, data catalog and business glossary

Strong concepts in AXON and/or Enterprise Data Governance and creating workflows in AXON. Implemented policies, guidelines, tools, metrics, and standards for managing metadata.

Good experience in using the Informatica Server Grid for high availability of resources, Secure@Source

Experience in task automation (code deployment, server maintenance, user, folder creation) using Power Shell Scripts, Job scheduling (Control-m) and Communicating with Server using pmcmd.

Experienced in Business Objects (XI R2/ R3, BO4), administration including setting up security features based on users/ groups and roles.

Involved in BO upgrade/ conversion projects. Extensively used BO reporting functionalities such as Master Detailed, Slice and Dice, Drilling, filters, ranks, sections etc.

Relational and dimensional data modeling. Good experience in database (Oracle, MS SQL). Tuning SQL queries, stored procedures, Unix shell scripting

Use Case, Flow Charts, Data flow diagrams, Microsoft Visio, MS-Project and Configuration Management. Expert in agile and waterfall project management methodologies. Able to manage project teams and known for high-quality deliverables that meet timeline and budgetary targets.

Strong skills in business analysis, data analysis, and data mapping for ETL processes. Excellent communication, documentation and presentation skills. Coordinated with IT and business teams and developed exceptional project teams.

PROJECT EXPERIENCE:

1. Data Management and Technology – Informatica Admin

Client: Rogers Communications Inc., Brampton, ON

Team Size: 5

Duration: 6 years (Jan’15 - Present)

Tools: Informatica 9/10.x, Informatica BDM, AXON, EDC, Oracle, SQL Server, Teradata, Control-M

Roles and Responsibilities:

1.Install/Upgrade process for the BDM/EDC and the IDL and their association with the different application services on the domain

2.Created different scanners Hive/Oracle/PowerCenter/Platform to load the data assets into a single place repository - EDC

3.Installed and configured PowerCenter 9.x, 10.x on AIX platform for DEV, QA and PROD servers

4.Used Informatica Data Quality to profile the project source data, define or confirm the definition of the metadata, cleanse and accurately check the project data, check for duplicate or redundant records, and provided information on how to proceed with backend ETL processes

5.Trained Data Owners and Stewards. Established security control, identified permission levels. Govern security to data lake. Worked with DG team and IT custodians to govern roles and permissions to data lake.

6.Got trained on Informatica Secure@Source: Data Security Deep Dive

7.Upgraded Informatica from 9.5.1 to 9.6.1 HF4 and then to 10.1.1 HF1. Applied EBFs (emergency break fixes) as and when required.

8.Designed and documented Informatica standards document.

9.Created and maintained Informatica users, groups and privileges.

10.Worked on SQL queries to query the Repository DB to find deviations of ETL code from coding standards and presenting it as MSTR report optimize the server

11.Automated code deployment tasks using Unix shell scripting.

12.Created scripts for server monitoring, user and folder creation etc.

13.Informatica server performance tuning activities – including cleanup activities

14.Migration of Informatica (mappings/ sessions/ workflows), parameter files, Unix scripts from Dev to QA. Testing the Informatica Objects in QA before moving them to Production.

15.Ensure that all support requests are properly approved, documented, and communicated using Incident Management tool. Documenting common issues, resolution procedures and lessons learnt.

16.Weekly status meetings to conduct the reviews of the Implementation plans for production release. Working with other teams involving DBAs, MicroStrategy reporting support etc.

17.Technical hands-on in Development and Production projects.

2. Global Point Solution and IAM (Identity and Access Management)

Client: Manulife Financial, Toronto

Team Size: 10

Duration: 15 months (Oct’13 – Dec’14)

Technology: Informatica 9.x, Business Objects, Oracle and MSSQL

Project Description:

Replace the legacy system by building a new system using Informatica as an ETL tool - to support various Investment management applications.

Roles and Responsibilities:

1.Onsite lead - Requirement gathering and analysis client interaction, project planning, release activities, estimating, budgeting, team mentoring, offshore team on-boarding activities. Built the offshore team through multiple interview sessions and started getting the work done from offshore team providing them technical and business requirements and guidance.

2.Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.

3.Developed Informatica workflows using task developer, Worklet/ workflow designer in Workflow manager and monitored the results using workflow monitor.

4.Workflow/ mappings performance tuning, database management, Unix shell scripting

5.Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

3. Data & Information Management

Organization: CGI

Client: Tufts Health Plan

Team Size: 8

Duration: 5 months (June’13 - Oct’13)

Technology: Informatica 9.x, Business Objects 4, Oracle

Project Description:

The project was about Data and Information Management for Tufts Health Plan (USA). Developing and maintaining the Data warehouse applications involving BI tools - Informatica, Business Objects.

Roles and Responsibilities:

1.Project team lead for applications involving Informatica and BO (including hands on activities, architect roles - ETL and reporting needs)

2.Hands on experience in creating Informatica mappings, workflows, sessions etc.

3.Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.

4.Created and scheduled Sessions, Jobs based on demand, run on time and run only once

5.Involved in the Performance Tuning of Database and Informatica. Improved performance by identifying and rectifying the performance bottle necks.

6.Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.

7.Client interaction, Project planning, Release activities, estimating, budgeting

8.Collaborating releases management, improving SDLC of projects, Quality management etc.

4. Enmax Touchdown Design

Organization: IBM

Client: Enmax (Calgary, Canada)

Team Size: 12

Duration: 5 months (Feb’13 – May’13)

Technology: Informatica 9.x, Oracle, Maximo, Itron

Project Description:

The project involved designing a new system to implement Maximo (Asset Management) and Itron (Metering data) at Enmax to improve management of its assets and existing processes. Informatica is used as an integration tool across different interfaces.

Roles and Responsibilities:

1.Requirement gathering, reverse engineering, client workshops

2.Business needs transformation into design/ tech. specs.

3.Developed project planning (WBS) and project scope management documentation

4.Participated in the analysis and documentation of the AS-IS and proposed TO-BE project architectures.

5.Member of the architecture team to identify various interfaces involving Informatica and create functional/ technical specs for interfaces.

6.Project management activities. Worked with senior managers/ client for estimating, scoping and scheduling tasks.

7.Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.

8.Liaising with outside IT consultants and other third party contractors (Vendor Management) to ensure projects completed on time.

5. Project Name: Building Technology Roadmap

Organization: IBM

Client: Enbridge (Calgary, Canada)

Team Size: 6

Duration: 7 months (July’12 – Jan’13)

Technology: Opti & Sim tools (iLOG, Anylogic), Oracle, Informatica 9.x

Project Description:

The project was aimed to build the technology roadmap for Enbridge to help them plan and build better pipeline network to maximize their Operating Margin and Return on Investment. Ideas of Business Analytics were applied to plan and build a better system.

Roles and Responsibilities:

a.Transforming business needs into technical requirements and solutions

b.Authored the project charter, documents detailing the business information requirements, functional specifications and executive presentations detailing the team's recommendations and findings.

c.Built credibility and rapport. Maintained communication with stakeholders at multiple levels, including those external to the organization.

d.Project Management activities - scoping, estimating, planning and release of the deliverables. Defined the project phases with milestones.

e.Responsible for identifying, analyzing, measuring and managing project risks.

f.Created cost-benefit analyses and ROI assessments that were used as the basis for decision-making

6. Project Name: ETL Support and Data Management/ BO Administration

Organization: Groundswell Group

Client: Cenovus Energy (Calgary, Canada)

Team Size: 15

Duration: 11 months (Sep’11 – July’12)

Technology: Informatica 8.6.1, Oracle 10g, BusinessObjects XI R 3.1

Project Description:

The project involved developing and supporting various Data Warehouse BI applications for Cenovus involving ETL and reporting tools

Roles and Responsibilities:

a.Performed the responsibilities of identifying project requirements and provide input in project initiation process

b.Managed efficient delivery of project in coordination with various business intelligence teams.

c.Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.

d.Keeping accurate administrative records of expenditure, accounting, costing and billing.

e.Responsible for all activities related to development, implementation, administration and support of ETL (Informatica) processes for large scale data warehouse applications using Informatica Power Center.

f.Monitored and provided effective resolution for all Informatica and Business Objects technical issues on a daily basis based on priority of SLAs.

g.Developed several complex mappings in Informatica using variety of Power Center transformations, Mapping Parameters etc.

h.Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

i.BO report generation (medium, complex Webi reports, drill down, dashboards etc.), BO Universe changes and BO Administration activities.

j.Sharing ideas / technical knowledge to team members & assisting team members in completing their tasks faster.

7. Project Name: One GLA universe enhancements

Organization: iGate Patni Global Solutions

Client: GE Health Care (USA)

Team Size: 10

Duration: 7 months (Feb’11 – Aug’11)

Technology: BusinessObjects XI R 3.1, MS SQL, Informatica 8.6

Project Description:

The project was aimed to incorporate major changes to the existing universe and subsequently change/ create the reports and convert some existing DeskI reports to WebI

Roles and Responsibilities:

a.Project management, Configuration management and defect prevention activities

b.Produced project status reports, managed the team and resolved day-to-day issues with emphasis on SDLC.

c.Conducting regular impact analysis in order to assess the consequences of the project deliverables on other sections of the business.

d.Lead the team to create mappings, workflows, sessions in Informatica PowerCenter to set up and support Data warehouse applications

e.Performed data manipulations using various Informatica transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.

f.Used Workflow Manager for Creating, Validating, Testing and running sequential and concurrent batches and sessions and scheduling them to run at specified time with required frequency.

g.Used Debugger to check the data flow in the mapping and made appropriate changes in the mappings to generate the required results.

h.Optimized ETL design and tools to gain efficiency and functionality.

i.Developed and made major changes to the BO universe, BO reports to incorporate the requirements of embedding data coming from different sources

j.Created scorecards/ dashboards with executive summary

8. Project Name: BO migration and Support from BO 5x to XI R3.1

Organization: Infosys

Client: Canadian Pacific Railways (Canada)

Team Size: 1

Duration: 16 months (Aug’09 – Dec’10)

Technology: BusinessObjects XI R 3.1, BO 5x, Oracle 10g, Informatica 8.6

Project Description:

Aim of the project was to migrate the old BO system BO 5x to BO XI R3.1 and then providing support to the new system

Roles and Responsibilities:

a.Responsible for the project management throughout the entire project lifecycle, including project initiation/proposals, project delivery, business liaison / stakeholder management, post implementation review and project close out / handover.

b.Responsible for migrating more than 3000 reports and around 100 universes. More than 200 users were migrated to the new system along with a new security architecture

c.Developed new universes and reports. Major role in scheduling, publishing and report bursting

d.Implemented new Security Roles in the new system

e.Made amendments to the existing universes and reports and doing Impact analysis on the new changes, added Universe level restrictions

f.Maintained the repositories for different environments like DEV, QA and PROD

g.Regularly synchronized the DEV, QA environments with the Production environment

h.Responsible to make sure Email, FTP, Unmanaged Disk options of scheduling are always up and running

i.Provided training to the end users for generating and scheduling their own reports, report bursting etc.

j.Design document creation, Unit testing, Configuration Management and Production level support

k.Worked on Informatica for setting up the data by creating various mappings. Involved in testing the ETL modules, planning, deploying and testing the ETL mappings.

l.Worked on estimating the conversion feasibilities from DeskI to WebI and was part of the conversion project team during the initial phase of the conversion project

9. Project Name: eDemurrage

Organization: Infosys

Client: Canadian Pacific Railways (Canada)

Team Size: 1

Duration: 12 Months (July’08 - July’09)

Technology: BusinessObjects 5.x – Designer and Full Client, Supervisor, Oracle PLSQL, Unix, Message Queues (MQ), C#.net

Project Description:

eDemurrage is a web application enabling customers and CPR specialists to review and validate Demurrage records and accounts in real time. This tool facilitates customer decision making regarding their fleets and improves the invoice accuracy

Roles and Responsibilities:

a.Supported the application 24*7 at the client location

b.Incorporated major enhancements to the existing application (adding new screens to the application, updating the database etc.)

c.Made changes to the existing BO Universe

d.Developed/ Published executive reports based on the user requirements

e.Wrote PLSQL stored procedures and was involved in query tuning activities

f.Created effective Test data and developed thorough Unit test cases to ensure successful execution of the data

g.Project Management activities

10. Project Name: British Petroleum Project Management Office (BPPMO)

Organization: Infosys

Client: British Petroleum (BP)

Team Size: 6

Duration: 8 Months (Nov’07 – June’08)

Technology: BusinessObjects (v 6.5.1) – Designer and Full Client, Supervisor, SQL Server

Project Description:

Developing portal to display reports to the BP employees. The reporting and metrics support the effective decision making in the organization

Roles and Responsibilities:

a.Developed executive reports based on the user requirements

b.Administrative jobs such as Creating New Users/Groups, Managing Categories/Documents, Publishing documents etc. using the Supervisor tool

c.Made amendments to existing universes and database changes

d.Design document creation, unit testing and configuration management activities

11. Project Name: BP Functions Support

Organization: Infosys

Client: British Petroleum (BP)

Team Size: 6

Duration: 12 Months (Oct’06 – Oct’07)

Technology: BusinessObjects Reporting Suite (6.1) including all the tools such as Full Client Reporting, Web Intelligence, Designer and Supervisor, MS SQL

Project Description:

Providing 2nd Line Support to the Reporting Area of a Portfolio, Project and Resource Management

Roles and Responsibilities:

a.Administrative Capabilities such as Login issues, Creation of New Users/Groups, Managing Categories/Documents, Publishing documents etc using the Supervisor tool. Also worked on another NT based tool ‘LDAP’ for validating and resolving Login problems

b.Enhancement and maintenance of various universes

c.Enhancements and bug fixes to existing reports

d.Creation of new full client reports based on the specifications provided by the user

e.High level of user Interaction in the form of Telephonic Conversations, Live Meetings, Keystone Slips, Emails etc.

12. Project Name: BP Competency Management Assurance System Engagement

Organization: Infosys

Client: British Petroleum (BP)

Team Size: 10

Duration: 10 Months (Dec’05 - Sep’06)

Technology: Business Objects (6.5.1) – Designer and Full Client, Oracle 9i

Project Description:

Competence Management Assurance System is a personnel competence management

tool used by BP to assess an employee’s capabilities against various competency metrics.

This assignment involved designing a new generic Universe using Designer for users to create

Ad-hoc reports based on CMAS application

Roles and Responsibilities:

a.Analysis, Design and Unit Testing of a new generic Universe using Designer to provide end users with Ad-hoc reporting capabilities on the Competence Management System

b.Also created ad hoc reports for users based on user requirements and made changes in the universe

13. Project Name: Bug Fixes/Enhancements/Canned Reports Development Engagement

Organization: Infosys

Client: British Petroleum (BP)

Team Size: 4

Duration: 10 Months (Feb’05 - Nov’05)

Technology: Business Objects (5.1) – Designer and Full Client, Oracle 9i

Project Description:

Data Warehouse Initiative was designed to capture the data for Management Information (MI).

The project involved enhancements and bug fixes pertaining to the MI database. Also, several canned reports were generated using Business Objects Full Client v 5.1.2 based on the Business Requirements.

Roles and Responsibilities:

a.Impact Analysis and Requirements Validation

b.Involved in bug fixes and also developed canned reports based on the business requirements

c.Knowledge Sharing and Business Objects training

d.Design Document Creation

14. Project Name: Optimizing Managerial Decision Systems for IKON, US

Organization: Infosys

Client: IKON Office Solutions, US

Team Size: 5

Duration: 11 Months (Mar’04 – Feb’05)

Technology: ASP, SQL Server

Project Description:

Providing Support to the module called Changepoint. Changepoint is a process and customer centric solution that automates and integrates the core business processes of services

Roles and Responsibilities:

a.Involved in supporting the application, making the desired changes in the ASP pages based on daily requests

b.Requirements Analysis, high level and detail level design, coding, unit testing

EDUCATION:

Bachelor of Engineering (Electronics and Communications Engineering)

PMI's Project Management Professional (PMP)®

Contact this candidate