Project Support

Abhishek Arora

Mobile: 1-913-***-**** ***********@*****.***

Professional Summary

• Having more than 4 years of professional experience in IT consulting industry for

Aviation & Energy (Oil&Gas/Power&Water/Energy Management) Domains.

• Having Excellent Knowledge on Business Intelligence and Data warehousing

concepts. He has extensive experience in managing Cognos environments ranging from

Cognos version 8.4 to Cognos 10.2 and has good knowledge in all the Cognos Studios and

other utilities like Cognos Framework Manager, Cognos Transformer etc., Cognos Life

Cycle Manager etc.

• He has vast knowledge in installation, migration and configuration of new Cognos

environments. He is also versed in version upgrade of existing Cognos Objects from the

existing environment to new version.

• Have working knowledge with Cognos security (Access manager, object level security,

data security) and good knowledge about the Cognos Architecture.

• He has also experience in creation and maintenance of various IBM Cognos

Framework Models encompassing both relational and dimensional packages. Additionally he

is also well versed on SLA management and marking service tickets to closure.

• Good team player with excellent communication skills, analytical and learning new

technologies.

• Also Certified with Cognos 8/10 Author, Cognos 8/10 Administrator and Cognos

8/10 Metadata Modeler.

• He has also closely worked with IBM Cognos support Team on PMR's for bugs in

the tool and also for implementing the Fix Packs and the Break Fixes.

• Had worked as a Cognos Administrator for GE Power & Water business leading

the entire Cognos Admin Team from Offshore.

• Had worked as an Cognos BI Architect at Client Location with Clarcor Industrial Air

(formerly GE Power & Water Air Filtration Business)

• Had worked as a Business Analyst for various Steam Turbine manufacturing

applications at client location for GE Power & Water Schenectady NY USA and later

worked as BI IT Support Lead for GE Power & water Business.

• Currently working as a BI Business Analyst for developing business logic for

the GE Power & Water –Distributive Power at Client Location (Cincinnati OH ).

Technical Skills

• Reporting Tools: Cognos BI (v8.4,10.1, 10.2), Cognos Administration, Cognos

Transformer, OLAP Cubes, Cognos Security,Cognos Framework Manager, Business Insight,

MOTIO CI/PI, Genware, OBIEE 11g, Tableau Desktop,

• ETL : Informatica, HVR

• Databases: Oracle 9i/10g/11g, SQL Server 2000, Teradata, Greenplum, Vectorwise

• Operation System: Windows XP, 7, Unix, Windows Server 2008, Windows

2012 datacenter edition.

• Change Management Tool : Service Now.

• Tools & Utilities: Putty, WinSCP, Tortoise

Experience

AMERICA EXPERIENCE TECH MAHINDRA Feb 2015 – Till Date

PROJECT DOMAIN IT

PROJECT NAME: Aero Financial Reporting

PROJECT TYPE: Development and Enhancement

CLIENT GENERAL ELECTRIC

ROLE Onsite Coordinator

ORGANIZATION TECH MAHINDRA (FORMERLY MAHINDRA SATYAM)

LOCATION Cincinnati, Ohio USA

ENVIRONMENT LANGUAGES: SQL, PL/SQL

(WITH SKILL

DATABASE : ORACLE, Greenplum, Vectorwise

VERSIONS)

INFORMATICA 9.X, HVR, COGNOS BI 10.2,

TOOLS : Tableau

WINDOWS, SUN SOLARIS, LINUX

O/S :

CHANGE SERVICE NOW

MANAGEMENT

TOOL

HARDWARE IBM, DELL

a) Project Description

• This Projects aimed automation of Distributive Power Services Dashboards in Tableau. It

takes the data from various heterogeneous source databases across various businesses and

PnL's of GE Distributive Power and transforms and automate the flow of data for tableau

reporting.

• Extracting, Transforming and loading the data for the various source system using

Informatica and loading it to Oracle ODS and using a replicator tool HVR loading it to

Vectorwise Database for tableau reporting. Along with handling all the break fix and

enhancements in the existing code.

• Thus pushing the changes to Production with every month release.

• This is spread across three different businesses. Aero, Wakesha, Jenbachker.

b) Contribution

As an IT support lead is responsible for

• Gathering requirements for the various new break fixes/enhancements for the potential

stakeholders and passing it to the offshore team.

• Maintaining and Planning track of the progress for each of the activities to be rollout for Monthly

release.

• Planning and conducting the transition Knowledge Transfer to the GAMS support after 2 months

of the changes moved to Production.

• Reviewing code for ensuring it met all the coding standards and plan for any deviation if any.

• Follow ups with the BI Operations Teams for timely moving the changes to Production .

• Act as a Single Point of Contact for any support related issues for the Customer and other

potential Users.

AMERICA EXPERIENCE TECH MAHINDRA NOV 2014 – Feb 2015

PROJECT DOMAIN IT

PROJECT NAME: PW ETS PLATFORM OPERATIONS

PROJECT TYPE: OPERATIONS SUPPORT

CLIENT GENERAL ELECTRIC

ROLE IT SUPPORT LEAD

ORGANIZATION TECH MAHINDRA (FORMERLY MAHINDRA SATYAM)

SCHENECTADY, NEW YORK,

LOCATION USA

ENVIRONMENT LANGUAGES: SQL

(WITH SKILL

DATABASE : ORACLE

VERSIONS)

OBIEE11g, DAC, COGNOS BI 10.1/10.2,

TOOLS : INFORMATICA 9.X,

GENWARE, MOTIO PI

WINDOWS, SUN SOLARIS, LINUX

O/S :

SERIES 7 LDAP

AUTHENICATION

SOURCE

CHANGE SERVICE NOW

MANAGEMENT

TOOL

HARDWARE IBM, DELL

a) Project Description

This project is aimed at maintaining, monitoring and supporting the BI software environments

for GE. The primary deliverables included planning, installing, configuring and maintaining the

IT infrastructure for GE and also debug and support the deliverables currently

being utilized and developed by respective development and support teams of multiple

vendors and that of GE.

GEPS (General Electric Power System) Enterprise Data Warehouse is one of the largest Data

Warehousing project to maintain all the data marts in centralized repository location. The purpose of the

application is to provide an intensive DSS (decision support system) for the GEPS management. The

applications, systems, and infrastructure are located in Atlanta, Schenectady, and Cincinnati.

b) Contribution

As an IT support lead is responsible for

• Coordinating with development project teams for objects migrations in to various environments

• Providing 24*7 support on the applications maintenance activities

• Providing support to all TSG Run Enabling Tools like Informatica, Cognos OBIEE and Service

Now

• Administration of Cognos/OBIEE Services and Servers, User Administration, Creation of Users

Project Folders, Migration among different environments

• Maintaining all application related issues which occurs and providing the root cause analysis to

the issues

• Applying various Hot Fix Bugs whenever required within the environment and Handling the

Outages and performing regular maintenance activities

• Responsible in providing up-to-date estimates of the project to customer

• Presenting various metrics to the customer for Daily, weekly and Monthly reviews

• Answering the technical queries, driving the product initiatives and metric collection and analysis.

• Ρε γυλαρ ιντ εραχ τιον ωι τη τηε ΓΕ Ενερ γψ Μανα γερ, α ταβασε

α δµινιστρα τορσ, Νε τ ωορκ Αδµινιστρα τορσ, Αππλιχατιον Υσερσ – αλλ

β ελον γιν γ τ ο δι φ φ ε ρεν τ δ επαρ τµεν τσ ανδ διϖισιονσ οφ ΓΕ Ενερ γψ

τ ο ενσυρε τηε σµοο τη ρυννιν γ οφ τηε αππλιχατιον.

AMERICA EXPERIENCE TECH MAHINDRA JULY 2014 – NOV 2014

PROJECT DOMAIN IT

PROJECT NAME: GE SCHENECTADY SHOP FLOOR IT SUPPORT

CLIENT GE POWER & WATER – STEAM TURBINE TECHNOLOGY

BUSINESS

ROLE ANALYST

LOCATION SCHENECTADY, NEW YORK, USA

ORGANIZATION TECH MAHINDRA (FORMERLY MAHINDRA SATYAM)

ENVIRONMENT DATABASE : ORACLE 9I,11G

(WITH SKILL MANUFACTURING EXECUTION SYSTEM

TOOLS : APPLICATIONS,

VERSIONS) KRONOS,MAXIMO, COPICS, ETC

WINDOWS 7/2008

O/S :

HARDWARE IBM, DELL

a) Project Description

• This Project involves providing day to day operations of IT systems for all Shop

Floor Applications, engage right IT Support teams ( Desk side, site Network and

telecom, facilities, ETS and corporate, application support) & communicate to all

stakeholders

• It also includes to address the most pivotal business and

technical/technology projects/issues first, in order to minimize the risk and

improve the process

• Understand the manufacturing systems and processes, its critical information flows,

and support requirements.

• Support IT project managers in the deployment of new systems and processes that impact

Schenectady. Provide business analyst support and assist with the extraction,

documentation, and solutions of business and systems requirements. This projects is an

8/5 regular support and 24/5 on call production support.

b) Contribution

As an IT support lead is responsible for

• Support day to day operations of IT systems. Troubleshoot and resolve shop floor device

(shopfloormachines,PC’s,thinclientsandhandhelds)issuesastheyarise.

• Respond and assist in troubleshooting wireless network issues.

• Serve as escalation point for ticket and incident facilitation and monitor to resolution.

• Support for Thin client profile, Roaming profile of shop PCs, Auto installation script

and Shop floor image for PCs

• Assist with application portfolio management, software asset management,

infrastructure resource management and configuration management in adherence to

ITIL practices and help maintain accurate configuration item relationships in the

Configuration Management Database (CMDB)

• Proactively identify and resolve issues before they impact plant operations

AMERICA EXPERIENCE TECH MAHINDRA FEB 2014 – JULY 2014

PROJECT DOMAIN IT

PROJECT NAME: GE CLARCOR BI MIGRATION PROJECT

CLARCOR INDUSTRIAL AIR (FORMERLY GE P&W AIR FILTRATION

CLIENT BUSINESS)

ROLE COGNOS BI ARCHITECT

LOCATION OVERLAND PARK, KANSAS USA

ORGANIZATION TECH MAHINDRA (FORMERLY MAHINDRA SATYAM)

ENVIRONMENT DATABASE : ORACLE

(WITH SKILL TOOLS : COGNOS 10.1, INFORMATICA 9.1,

VERSIONS)

WINDOWS, LINUX

O/S :

AUTHENICATION ACTIVE DIRECTORY

SOURCE

HARDWARE IBM, DELL

b) Project Description

• This Project involves the migration of Cognos and Informatica objects from GE

network to Clarcor Network. This migration also includes the installation and

configuration of the Cognos and Informatica environments in Clarcor network and it

used Active Directory as their cooperate Authentication Source

• It includes Testing of migrated objects in Clarcor development/QA environments

and production move post UAT Sign off

• Fixing of Environmental/code issues identified during testing

This projects is an 8/5 regular support and 24/7 on call production support.

b) Contribution

As an Cognos Architect is responsible for

• Migration of Cognos objects

• Planning,installation & Configuration of Cognos BI and Informatica in Clarcor Network

• Managing the activities of Informatica from Onsite.

• Fixing the Environmental issues identified during testing.

• Managing New development/Enhancement of Informatica/Cognos objects

• Coordinating with various support teams such as DBA, OS, Network,

Windows,Web Support Teams

• Managing the IBM Cognos BI vendor support tickets and applying various Hotfixes

and Fixed packs.

Page 3

INDIA EXPERIENCE TECH MAHINDRA NOV 2010 – FEB 2014

PROJECT DOMAIN IT

PROJECT NAME: TSG RUN ENABLING TOOLS

PROJECT TYPE: OPERATIONS SUPPORT

GENERAL

CLIENT ELECTRIC

ROLE COGNOS BI OPERATIONS OFFSHORE TEAM LEAD

ORGANIZATION TECH MAHINDRA (FORMERLY MAHINDRA SATYAM)

HYDERABAD

LOCATION INDIA

ENVIRONMENT LANGUAGES: SQL

(WITH SKILL

DATABASE : ORACLE

VERSIONS)

TOOLS : COGNOS 8.4, COGNOS BI 10.1/10.2, INFORMATICA 9.X,

GENWARE, MOTIO PI

WINDOWS, SUN SOLARIS, LINUX

O/S :

SERIES 7 LDAP

AUTHENICATION

SOURCE

CHANGE SERVICE NOW

MANAGEMENT

TOOL

HARDWARE IBM, DELL

a) Project Description

TSG Run -Enabling Tools project aimed at maintaining, monitoring and supporting the BI

software environments for GE. The primary deliverables included planning, installing,

configuring and maintaining the IT infrastructure for GE and also debug and support the

deliverables currently

being utilized and developed by respective development and support teams of multiple

vendors and that of GE.

TSG is a shared services organization that is responsible for all technical solution design and

infrastructure support delivery for GE Aviation and Energy businesses. The goal of TSG is to

provide standard infrastructure services and support operations to deliver to business service

level agreements. These services include Infrastructure Architecture, Security, Web, Application

and

Data Services Operations, Interfaces to the business teams with Data centers were located

across Atlanta, Cincinnati, Schenectady, Alpharetta and Hamilton .

b) Contribution

Actively connected with the client / customers /end users on their Cognos issues

and provide resolution within SLA.

Presented various metrics to the customer for Daily, weekly and Monthly reviews

Regularly training the team in improving the functional and technical knowledge .

Preparing and reviewing the process and get it documented.

Delivering end to end functional solution for the occurring issues of the business

on time.

Page 4

Timely Monitoring of the resources and a effective process model followed within

the team was resulted in 100% adherence

As a Team Lead, Lead the team as an escalation point of contact from Offshore.

Having command over all the onsite/offshore activities, driven the team in a multi

-vendor environment with high challenges, completely following the process in the

Change Management and ITIL policies.

Managed a team of 6 members team through remote location which team members

located in Bhubaneshwar, and Vizag (India) in P0/P1 SLA based critical

environment. Co-ordinated with various support teams like DBA, OS, Web,

Windows, Network, Architect teams, Change Management Teams, Various

Support/Development teams in a full pledged elegant way thus ensuring quality

support delivered on time.

Oversee & assist the various development teams with the testing & verification

of successful migration of all objects to the new environments

Managing Cognos Workgroups tickets through Change Management Ticketing

Portal called Service Now and ensure all tickets are closed within the SLA and

provide valid justification for any overdue tickets to the business.

Coordinating with IBM Cognos BI vendor with various Service Request PMR

tickets Assist with patch and break-fix module Installation, configuration, and

application upgrades.

Planning outages for application maintenances

Support the Cognos Technology Owner with the necessary tasks determined for

disaster recovery operations.

Awards and Achievements

• Certified in 3 IBM Cognos BI vendor

certification : o IBM Cognos 10 BI

Author

o IBM Cognos 10 BI Administrator

o IBM Cognos 10 Metadata Developer.

• Got various appreciations from the customer for his indepth technical knowledge,

good communication skills and ability to work under pressure.

• Recipient of Awards such as Bravo Award & the Pat on Back Award for outstanding

contribution to the project which includes resolving any complex technical issues within the SLA

with a very good positive attitude and meeting all the customer expectations.

• Was awarded by the Tech Mahindra Learning Head with the Certification of

Appreciation for contribution as an technical faculty for Cognos to one of the entry level

program with the audience of around 40 associates.

Education

BACHELORS OF ENGINEERING [BE (HONS)] MAY 2010 *PANJAB UNIVERSITY, CHANDIGARH

(INDIA)

Honors degree in Engineering and passed with 70.55% percentage

*University Ranked between 226-250 in Times Higher Education's (THE) World University

Rankings 2013-14 and 1st in India .

Page 5

12TH GRADE 2006 DAV SENIOR SECONDARY SCHOOL CHANDIGARH INDIA

• Major: Physics, Chemistry, Mathematics

• Passed with 75.4% percentage.

• Central Board of Secondary Education (CBSE) INDIA

10TH GRADE 2004 POLCIE DAV PUBLIC SCHOOL JALANDHAR, PUNJAB INDIA

• Passed with 87.2% percentage.

• Central Board of Secondary Education (CBSE) INDIA

Personal Information

NAME MR ABHISHEK ARORA

TH

8 SEPTEMBER 1987

DATE OF BIRTH

EMAIL ID EMAIL ID ***********@*****.***

CORPORATE EMAIL ID ********.******@************.***

LOCATION Cincinnati, Ohio USA

MOBILE 1-913-***-****

CONTACT NUMBER

MARITAL STATUS SINGLE

NATIONALIT

Y INDIAN

VISA & Work Permit details

PASSPORT NO. G8835724

NATIONALITY INDIAN

TYPE OF VISA H1-B WORK PERMIT

I hereby declare that all the information provided above is correct to best on my

knowledge.

Abhishek Arora Place: Cincinnati OH

Page 6

Contact this candidate