Project Data

VIKESH GOPI PARAMEL [pic]

Email: *************@*****.***

Mobile: +1-510-***-****

[pic]

Summary

. Informatica consultant and a solution architect with close to 8 years

of experience in ETL Infrastructure Administration/Architecture and

Informatica ETL development.

. Demonstrated excellence in design, development and support of

Informatica ETL solutions using different data sources. Defining

Informatica standards and best practices.

. Good experience in designing and implementing ETL environments using

ETL strategies as well as tools Like Informatica Power Center 8.x/9.x,

Power Exchange, Metadata Manager, IDQ and B2B.

. Skilled in designing and implementation of Informatica Infrastructure

Architecture for better cost effective and efficient environment.

. Special proficiency in installing Informatica 8.x/9.x and upgrading

Informatica Version 8.x to Version 9.x. Experience in applying

Informatica Latest Hot fixes/Patches. Installation & configuration,

Domain/multi-node setup, High Availability setup, Load balancing,

Server performance tuning, User management, etc.

. Extended exposure in designing, implementing and coordinating the DR

strategy/plan for all Production infrastructure build.

. Extensive experience in error handling and problem fixing in

Informatica. Installing and configuring Oracle DAC server and client.

And integrating it with Informatica.

. Good ability in developing, modifying and testing UNIX shell scripts

and necessary test plans to ensure the successful execution of the

data loading process and automated processes for informatica

administrators.

. Extended experience in 24X7 on call Production support and preparing

procedures/documentation whenever necessary.

. Good experience in configuring and use of Informatica cloud services.

Part of Informatica partner program on spreading knowledge and major

advantages of using Informatica cloud services.

. Excellent communication and interpersonal skills, ability to learn

quickly, good analytical reasoning and high adaptability to new

technologies and tools.

. Act as a point of technical escalation and resolution during the

project lifecycle as it relates to technical decisions.

. Proactively work with partners to ensure that appropriate staffing

resources are assigned, put in place, and effectively utilized at the

appropriate time.

. Experience in all aspects of Project Management from requirements

through development, planning, business analysis, execution,

monitoring, scheduling and estimation of medium to large sized

projects involving complex business solutions.

. Capable of managing clients for entire business practices and

procedures; expertise in analyzing client's business and requirements,

suggesting and implementing processes to deliver high quality business

solutions and recommendations.

. Recognized for managing complex projects (with tight timelines),

Building and Leading Teams, Cultivating and nurturing relationships,

and Critical Problem-Solving.

. Motivating and enthusiastic professional with an excellent approach to

achieve triumph in all projects.

. Capable of delivering success in a complex project with scope for

learning and challenge.

Technical Skills

Operating Systems : Windows XP Professional, Windows 7, UNIX, Linux

Databases : Oracle, MySQL

Internet Tools : HTML, XML, CSS

Languages : PL/SQL, Java, J2EE

Primary Skills : Informatica 8.x/9.x, Informatica B2B, Informatica

Metadata Manager

Informatica PowerExchange, Informatica IDQ

Others : MS Office, EDI, Tomcat, Eclipse, Control-M, OBIEE,

Qlikview, Oracle DAC, Autosys,

Informatica cloud.

Professional Experience

Company - Accenture Services Private Limited

(November 2013 to December 2014)

Project #1 : UBS HRIT - Fusion Project (Client - UBS)

(November 2013 to December 2014)

Team size : 50

Technical Skills : Informatica 9.x, Oracle, PL/SQL, LINUX, Autosys

Job Function : Team Lead & Solution Architect

The Fusion programme aims to replace the existing UBS HCM platform (HRI -

Peoplesoft) with the new Oracle Fusion HCM cloud platform. As part of the

UBS global HR transformation program Accenture, in partnership with Oracle,

are working to implement the Fusion system across HRIT. The fusion

programme is the re-plat forming of Peoplesoft HR to Oracle Fusion HCM

SaaS.

Within this implementation, Accenture is leading the Data Integration,

Application Remediation and technical upgrade work. In addition, we are

providing business analysis, technical and solution architecture support

across the programme.

Roles and Responsibilities:-

. Install/Upgrade and configure Informatica 9.5.1.

. Identified potential risks/sub-standards and fixed them in the setup.

. Worked on ETL Architecture to furnish business requirement specs and

document them for Informatica developments.

. Design and implement a complete DEV, SIT, UAT, Pre-Prod, Prod and

BCP/DR setup.

. Manage user account, groups and workspace creation for different

users.

. Infrastructure architecture planning, project planning and operational

activities.

. Prepare monthly/weekly reports and present it to the management.

. Developed and setup scripts for Informatica domain and repository

backup, truncate logs and housekeeping.

. Supported implementation of DIS to support the servicing of downstream

consumers which require HR data.

. Scheduling and setting up jobs in autosys.

. Proposed the solution to bundle the existing Informatica work package

of downstream GRW application with the new Informatica work package to

be used to get data from Fusion.

. Designed the new end to end architecture providing solution on how the

existing downstream application GRW would align itself and cope with

this Fusion change.

. Designed the Informatica Upgrade approach.

. Capacity planning and overlook of architecture plan of all integrated

systems.

. Provide timely advice to management and the project team on

environmental issues.

. Implement all aspects of the Environmental Management Plan and ensure

compliance.

Project #2 : Informatica Cloud POC (Accenture Internal)

(April 2014 to October 2014)

Team size : 4

Technical Skills : Informatica Cloud

Job Function : Team Lead

The Informatica cloud project is an internal project within Accenture.

Partnering with Informatica we build a team who has hands on experience in

Informatica cloud. And who could support and suggest to customers of using

Informatica cloud and a solution to their Data Integration processes.

Roles and Responsibilities:-

. Lead the team of Informatica cloud POC in Accenture.

. Install and setup Secure agent on the system.

. Attend sessions provided by Informatica on Informatica cloud.

. Implement POC projects on Informatica cloud using the different Cloud

Apps like Data Synchronization, Contact Validation, Data Replication,

Data Assessment, Mappings, etc.

. Provide presentations and showcase the solutions and Cloud Apps in

Informatica cloud.

Company - Fidelity Investments

(July 2007 to October 2013)

Project #1 : Enterprise Infrastructure Integration Services

(June 2008 to October 2013)

Team size : 5

Technical Skills : Informatica 8.x/9.x, Informatica B2B, Informatica

Metadata Manager,

Informatica PowerExchange, Informatica IDQ, DAC, Oracle, PL/SQL,

LINUX, Qlikview

Job Function : Informatica Architect/Administrator

- Tech Lead

EIIS - Enterprise Infrastructure Integration Services project is one

envisioned with the intent to consolidate EI Infrastructure Run for all

applications of EI and other Business Unit. The project involves

PowerCenter administration/development, ETL Infrastructure build, server

Maintenance and ETL Consulting for different applications. 24/7 production

on call Support for the infrastructure. The project involves exploring

other Informatica products in the lab server for the application developers

to leverage different products to develop POC and testing the new features

etc. The proactive maintenance helps in smoother functioning of real-time

business critical applications.

Roles and Responsibilities:-

. Install, upgrade and configure Informatica 8.x/9.x, B2B,

PowerExchange, Metadata Manager and IDQ on Linux.

. Install and configure Oracle DAC server and client, and integrated

with Informatica.

. Install and configure IDQ, B2B and Metadata Manager Components.

Configure OS Profiles and LDAP Authentication.

. Configure and integrate Informatica to connect with Salesforce to read

data.

. Design and implement a complete DR setup for all Production

environments.

. Coordinate and conduct complete DR test early twice to ensure business

continuity even at an event of disaster. Also document all steps,

process and procedures to be carried out at the event of a disaster.

. Manage user account, groups and workspace creation for different

customers.

. Support Informatica infrastructure/workflows 7am to 7pm(EST) on

weekdays and 48 hours support on weekends.

. Outage Handling - Notify the user group on scheduled outage during the

weekend, bringing down the Informatica service and restarting once the

change is done.

. Test and troubleshot mappings, sessions and workflows in DEV/QA

environment before Migration to PROD.

. Troubleshooting user's problems (application and infrastructure

related).

. Raise SR and coordinate with Informatica global support for unresolved

issues/concerns.

. Create process documents for ETL infrastructure run activities.

. Research on new innovative ideas to build cost effective and efficient

Informatica infrastructure.

. Coordinate with the client for gathering the business requirements.

. Setup new Informatica infrastructures for different business units, as

per requirement.

. Developed and setup scripts for Informatica domain and repository

backup.

. Mentor new comers in team. Lead and guide the team.

. Create reports and dashboards for task progress and performance

statistics using Qlikview.

. Infrastructure architecture planning, project planning and operational

activities.

. Identify project resources and directed work efforts for deadline-

driven assignments.

. Manage change control, procurement, and project escalations with

internal Dept.'s and third-party vendors.

. Coordinate solutions vendors (hosting, software, security, content

delivery), resolving issues with appropriate hardware requirements,

data dependencies, and solution architecture.

. Conduct Weekly status meetings to track the tasks progress.

Project #2 : EI Metrics Dashboard

(February 2013 to October 2013)

Team size : 4

Technical Skills : Informatica 8.x/9.x, Oracle, PL/SQL, LINUX, OBIEE,

Qlikview

Job Function : ETL & OBIEE Developer

EI Metrics dashboard is an extensive application which is used in tracking

and analyzing the performance of all the tickets handled by different teams

in EI BU. We can verify the number of tickets dealt by employees attending

customer services. Tracking all the tickets, through monthly and yearly

helped in improving customer satisfaction.

Roles and Responsibilities:-

. Identify Source tables (OLTP, ODS) and Target tables (OLAP) for Data

mapping.

. Development of mappings workflows and session tasks using Informatica

Power Center. Test and troubleshot mappings, sessions and workflows in

DEV/QA environment before Migration to PROD.

. Involved in building the ETL architecture and Source to Target mapping

to load data into Data warehouse.

. Involved in Dimensional modeling (Star Schema) of the Data warehouse

. Extracted the data from the flat files and other RDBMS databases into

staging area and populated onto Data warehouse.

. Installation of OBIEE 11.1.1.6.5 Enterprise Server in windows and

Linux machine(DEV, UAT & PROD ENV's)

. Configured OBIEE Repository (Physical, business and presentation

layer) to provide Analytical Reporting solutions to business.

. Worked on RPD part to develop custom logical tables, Columns and

hierarchies in BMM Layer & Presentation Layer.

. Identified joins, tables, Dimensions, Facts, Aggregates, and Measures

etc.

. Implemented Dimensional Hierarchies, Aggregate navigation,

Fragmentation content, and other various features.

. Created role based dashboards, pages, reports with various views i.e.

table, pivot, charts, narrator, column selector etc. and various

report prompts.

. Created drill down charts and drill down tables to gather more

information.

Project #3 : Fidelity ActionsXchange (July 2010 to July 2011)

Team size : 5

Technical Skills : Informatica PowerCenter 8.1.1,

Informatica PowerCenter 8.6.1,

Informatica B2B - Data Transformation, XML, XSD, Linux

Job Function : Informatica ETL Developer

Fidelity ActionsXchange is a leading provider of flexible, technology-

driven global corporate actions solutions to more than 50 of the world's

largest financial services firms. Leveraging more than 10 years of

analytical expertise, technology and service, the company offers solutions

that source, enhance, compare and validate corporate action announcements,

helping to turn complex data into valuable intelligence. ActionsXchange is

a wholly-owned subsidiary of Fidelity Investments and provides integrated

corporate actions event information to financial firms worldwide.

ActionsXchange supports the top 25% of the world's top asset managers.

Roles and Responsibilities:-

. Coordinate with the client for gathering the business requirements.

. Translate business requirements into Informatica PowerCenter

mappings/sessions/workflows.

. Develop mapping design document for ETL process.

. Enhancement of existing processes to support changes of clients.

. Support Informatica workflows 7am to 7pm(EST) on weekdays and 48 hours

support on weekends.

. Test and troubleshot mappings, sessions and workflows in DEV/QA

environment before Migration to PROD.

. Contact with Informatica technical support group regarding any unknown

issues.

. Create scripts for transforming unstructured data to structured format

using Informatica B2B Data Transformation.

. Self Learning to expertise on Informatica B2B - Data Transformation

and Data Exchange.

Project #4 : Fidelity Information Processing (Tools and Automation)

(June 2008 to December 2009)

Team size : 5

Technical Skills : Informatica PowerCenter 8.1.1, Linux, Unix, Oracle,

PL/SQL

Job Function : Informatica ETL Developer and

Informatica Administrator

DIPIT - Data Integration Platform for IT is FTG Enterprise Infrastructure's

integrated operational data store. It was envisioned with the intent to

consolidate EI Operational data for applications and improve operational

efficiency by facilitating near real-time reporting. It is primarily used

by EI Core operations and Application Services. The operational data of

applications is analyzed by mining the data to observe trends in their

functional, performance aspects and take proactive measures to improve

efficiency. This proactive monitoring helps in smoother functioning of real-

time business critical applications.

DIPIT acts as a single integration environment serving the needs of a

diverse user population with varied requirements. The growing importance of

DIPIT to ensure efficient IT operations has driven organic growth in the

number of integration partners and users who share information through

DIPIT or rely on the platform for key reporting and planning activities.

Roles and Responsibilities:-

. Coordinate with the client for gathering the business requirements.

. Translate business requirements into Informatica PowerCenter

mappings/sessions/workflows.

. Create process documents for ETL infrastructure run activities.

. Develop mapping design document for ETL process.

. Write stored procedures, functions, packages for the migration project

without affecting the existing functionality.

. Test and troubleshot mappings, sessions and workflows in DEV/QA

environment before Migration to PROD.

. Support Informatica infrastructure/workflows 7am to 7pm(EST) on

weekdays and 48 hours support on weekends.

. Enhancement of existing processes to support structural changes of

source.

. As a part of this project, we added Service center, Asset center,

Enterprise Registry, ITG Central, magic data from various sources to

ODS.

Project #5 : Secure Password website (June 2008 to August 2009)

Team size : 4

Technical Skills : Java, J2EE, Oracle, PL/SQL, HTML, CSS, Tomcat, JSF

Job Function : Web Application developer

Secure password website is critical application developed using

JSF/Ajax/Dojo and Ibatis framework to store user accounts and passwords for

various environments, servers and applications for Fidelity support center

(FSC).

As FSC is heart of supporting entire infrastructure on 24/7, the accounts

and passwords required for troubleshooting are stored in this website.

Roles and Responsibilities:-

. Develop CRUD application.

. Coordinate with onsite team members and partners.

. Implement encryption technique for password as per standard.

. Develop stored procedure and implemented Ibatis to access it.

. Implement Abstract Factory and Factory Pattern.

. Perform end to end testing of website.

. Develop Phase 2 of project with new enhancements.

. Took initiative and implemented same website for Fidelity Information

Processing Team.

Project #6 : Call Center Workspace (September 2007 to May 2008)

Team size : 10

Technical Skills : Java, J2EE, Oracle, PL/SQL

Job Function : Web Application developer, Tester, Log analysis

The Call Center Version named Call Center Workspace (CCW) is the first

incarnation of the FWS (Fesco Workstation) vision and is being built in

support of CSS associates. The Call Center version is to provide the

capability necessary to empower our associates to deliver outstanding

customer service. This initiative will create a new workspace that will

provide enhanced context passing, single sign-on and windows management.

Roles and Responsibilities:-

. Perform end to end testing of the application.

. Perform rigorous testing of - Telephony, Resource menu and Siebel.

. Analyze Performance Logs - capturing data based on various parameters

and display them as per requirements.

. Analyze Error Logs - analysis and interpretation of errors in various

environments and assigning them to the concerned developers.

. Develop the CCW Testing Manual - encapsulates the detailed testing

procedure and the installation of certain third party modules.

. Support the creation of the CCW User Manual.

Education

. B.Tech in Information Technology - Cochin University of Science and

Technology, Cochin, Kerala with 62.9% in 2007.

. AISSCE (12th) - Bharatiya Vidya Bhavans Vidya Mandir, Thrissur, Kerala

with 68.2% in 2003.

. AISSE (10th) - Bharatiya Vidya Bhavans Vidya Mandir, Thrissur, Kerala

with 77.6% in 2001.

Certification

. Informatica Certified - PowerCenter Data Integration 9.x: Developer

Specialist (Certificate No. 041-000268).

. Informatica Certified - PowerCenter Data Integration 9.x:

Administrator Specialist (Certificate No. 007-000125).

Rewards and Recognition

. On the Spot Award for Outstanding Contribution to Building Informatica

ETL Hosting Service and providing excellent customer support, March

2011.

. On the Spot Award for developing critical environments, consistently

meeting customer upgrade/migration needs, and for work on significant

PROD and DR infrastructure upgrades, July 2011.

. You've earned it Award for the great contribution in Migrating SFDW

(Statistical Financial Data Warehousing) database of terabytes of size

from Solaris, a portion of the database has been moved to Netezza and

the rest has been moved to new Linux environment.

. On the Spot Award for Outstanding Contribution to Building and

upgrading Pyramis Informatica ETL Services and providing excellent

customer support, March 2012.

> References upon request

Contact this candidate