Pankaj Ladi

acg37p@r.postjobfree.com

201-***-****

Professional Summary

9+ years of Technical Consulting experience in Data Warehousing/Business

Intelligence

Client Management: Manage day to day interactions with clients and

sponsors and provides qualitative and quantitative information on regular

basis

Delivery: Manage and deliver components of client engagements that

identify, design, and implement technology and creative business solutions

for large companies. Responsibilities include, among others, managing

teams in the identification of business requirements, functional design,

process design (including scenario design, flow mapping), prototyping,

testing, training, defining support procedures. Involved in identifying and

developing the Value-Adds in parallel to the regular developments.

People Development: Perform role of counselor and coach; provide input and

guidance into the staffing process; actively participate in staff

recruitment and retention activities; provide leadership and support for

delivery teams and staff in local office.

ROLES/EXPERTISE Summary

Solid Analytical, Architectural, IT Project Life Cycle (SDLC, AGILE)

experience with lead roles

Expertise in cross functional integrations, dealing with large database

Architectures, EDW, ODS, Data Marts and Data Mapping, Transformation and

Loading in complex and high-volume environment.

Deep knowledge of different types of Data Warehouse (Kimball/Inmon

Methodology) and Business Intelligence solutions and relational &

dimensional modeling, Star & Snowflake (Fact Tables, Slowly Changing (Type

1, 2 & 3) & Hierarchial Dimensions) schema designs

Strengths include Project Management, Effort Estimation, Data and System

Analysis, Performance tuning & Process Streamlining, Planning/Scheduling

and Quality Practices in addition to strong technical knowledge on Data

Migration, Data Warehousing and Business Intelligence

Has managed and executed all phases of a Data warehouse project life cycle

during the tenure that includes Scope Study, Requirements Gathering,

Architecting, Design, Development, Implementation, Quality Assurance,

Application Support for end-to-end IT solution offerings in

Datawarehousing, OLAP & BI space

Proficient in analyzing and translating business requirements into

technical requirements and architecture

Strong data modeling and data analysis skills, ETL tool (AbInitio)

expertise, SQL Programming and development knowledge

Use of consultative techniques to help customer understand how business

processes can be improved and how BI technology can be employed to that end

Using BI product expertise, build demonstrations, proof of concepts,

prototypes to deliver a high-value solution, assessment of various activity

to improve the quality of deliverables

Experience in leading and managing teams. Handled multiple roles - Data

Modeler, Data Analyst, ETL Designer, AbInitio Lead, Cognos/Business Objects

Designer, Onsite Coordinator, Team Lead

Proven experience in Designing (High-level and detail designs), Configuring

solutions using Ab Initio, Cognos, Business Objects

Excellent work base experience in handling different Data Sources/Targets

like Teradata, Oracle, MS SQL Server, DB2, Flat Files, XLS, XML, COBOL and

mainframes files

13. Strong hands-on experience in handling the Partitions, Multi Files

(MFS), Serial files, ICFF files

14. Experience in Building and Designing of Ab Initio Reusable Components,

Utilities which can be leveraged across projects

15. Experience in advanced features like ACE, BRE, PDL and Meta-Programming

16. design and presented Ab Initio reusable framework

17. designed and presented Ab Initio Based Quality Assurance (AQA)

framework

18. Proficient in writing UNIX Shell Scripting, SQL, PL/SQL and job

scheduling tools like CA7/Autosys

19. Experience in Building and Design of Business Objects Universe and Web

Intelligence (WEBI) reports

20. Experience in Building and Design of Cognos Framework Model and report

studio reports

21. Created Ad-Hoc reports using Query studio and Trained power users to

use Query Studio for Ad-Hoc reporting

22. Good knowledge of BIGDATA (Hadoop HDFS and MapReduce) and Data

appliances like Teradata

23. Excellent Problem Solving/handling Capabilities. System Performance,

Release Management, Change Control management, Defect management and

Root Cause analysis.

Technical Skills:

ETL Tools Ab Initio (CO>OP 3.0, GDE 3.1), Ab Initio EME,

Conduct>It, BRE/ACE

Database Teradata, Oracle, MS SQL, DB2, & MS-Access

Operating Systems Co>Op 3.0, Unix, Linux Redhat, Windows

OLAP Tools Cognos, Business Objects, TeaLeaf

Cognos 8.2, 8.4, Report Studio, Query Studio, Framework

Manager, Go Dashboard, Event Studio and Metric Studio,

Impromptu 7.x, Cognos Powerplay, Cognos Upgrade Manager

Business Objects XI R2, Web Intelligence (WEBI), Desktop Intelligence

(DESKI), Designer, Xcelcius, Enterprise performance

management

TeaLeaf Tealeaf 8.8, Events, Alerts, Realitea Viewer and Replay

rules, Capture Server

Other Tools Tortoise SVN Version Control, SQL Developer, AQT,

Autosys, Microsoft Share point, Quality Center

Languages C, C++, C#, SQL, PL/SQL, T- SQL, Unix Shell scripting

Other skills: Autosys Scheduling, SQL Server Agent, Microsoft Office

Project, Visio, Office

Domain Banking, Finance, Insurance & Life Science

Clientele Schering Plough, Washington Mutual, The Travelers

Education

1. Completed Bachelors in Computer (BE) from Sardar Patel College, Mumbai

University

Professional Experience

Ernst & Young Hartford, CT

Sep 2014-Current

Sr Consultant

Project & Role Descriptions

The project involves Building an Enterprise Data Warehouse (EDW) for

Personal Insurance property and auto line of business

Responsibilities:

2. Solution design document creation for EDW

3. Data analysis of Guidewire Insurance Suite Policy Center, Billing Center

and Claim Center

4. Data mapping from Guidewire Insurance Suite

5. Data mapping to Teradata FSDM

Tools and Technology: Teradata, SQL Developer, SQL Server, Teradata SQL

Assistant

Travelers Hartford, CT

Apr 2012-Sep 2014

AbInitio Tech Lead/Architect

Project & Role Descriptions

The project involves Building a Data Marts for Business Insurance-Work

Management subject area

Responsibilities:

6. End to end delivery of two data marts: Operations Data Mart and

Workstation Data Mart

7. Logical Data Model design

8. Develop ETL reference architecture (reusable framework), presented

reusable framework in organization

9. Establish and enforce technical standards for deliverables of project

10. Determine the optimal approach for obtaining data from diverse source

system platforms and moving it to the BI

11. Estimate system capacity to meet near- and long-term processing

requirements

12. Develop and manage the BI dependency plan, job scheduling and cycle

management

13. Define and get agreement with support and IT operations personnel on

service level agreements

14. enhancements, change management, production support

15. Hands on AbInitio development

Tools and Technology: AbInitio GDE 3.1, PDL, BRE, Autosys, Oracle,

Teradata, SQL Developer, SQL Server, Teradata SQL Assistant

Travelers, Hartford, CT

Jan 2010- Mar 2012

AbInitio Tech Lead

Project & Role Description

The project involves Building an Operational Database for Catastrophe

Division

Responsibilities:

16. Conduct requirement gathering sessions

17. Gathering requirements and preparing Technical Specification/Mapping

Document

18. Design of logical data model for Operational Database

19. ETL High Level Design

20. Review of Low Level Design

21. Code Review

22. Technical project ownership

Tools and Technology: AbInitio GDE, Autosys, SQL Server

Travelers, Hartford, CT

Hadoop Talend Integration POC

Project & Role Description

Proof of concept for integration of Talend (ETL tool) with Hadoop

Responsibilities:

23. Installation of Hadoop and Talend on single node cluster

24. Execution of POC using Talend and Hadoop

Tools and Technology: Hadoop, Talend

Travelers, St Paul, MN

Dec 2009-Dec 2009

Cognos Designer

Project & Role Description

The project involves information delivery using Cognos for Change

Management Process

Responsibilities:

25. Understanding scope

26. Conduction Business Requirement gathering sessions

27. Preparing detailed technical specification documents

28. Test case strategy document

29. Provide guidance to offshore team for solution delivery

Tools and Technology: Cognos 8.4

Travelers, Hartford, CT

Sep 2009-Dec 2009

Cognos Designer

Project & Role Description

The project involves:

New report development in Cognos 8.4

New package development in Cognos 8.4

Implementation of Dashboard using Cognos 8.4

Responsibilities:

30. Gathering Business Requirements for New models.

31. Interacting with Development and Management Teams.

32. Built models using Framework Manager

33. Test Strategy

34. Developed standard Templates and conducted training to Users on Cognos

8

35. Use of tools such as event studio, analysis studio, go dashboard

36. Cube development and deployment using transformer

37. Developed Standard Reports, Charts, Drill through Reports using Cognos

8

38. Scheduling and Distributing Reports through Schedule Management in

Cognos Connection.

39. Responsible for reports management using Cognos Connection portal to

administer security, deployment, organizing, scheduling and distributing

reports

40. Responsible for package migration across environment

41. Involved in performance improvement

42. Assisted users in troubleshooting ad-hoc reports

43. Mentoring offshore development team

Tools and Technologies: Cognos 8.4: Report Studio, Query Studio, Framework

Manager, Go Dashboard, Event Studio and Metric Studio

Travelers, Hartford, USA

Mar 2009- Sep 2009

Sr. Cognos Developer

Project & Role Description

The project involves:

Migration of reports from 8.2 to 8.4

Migration of cognos packages from 8.2 to 8.4

Migration of cubes from 8.2 to 8.4

Responsibilities:

44. Framework package Migration from Cognos 8.2 to 8.4

45. Verification of Cognos Framework packages

46. Verification of migrated reports

47. Use of upgrade manager for data comparison

48. Involved in Test strategy and execution

49. Deployment of reports and packages across the environment

50. Mentoring offshore development team

Tools and Technologies: Cognos 8.2: Report Studio, Query Studio, Framework

Manager, Event Studio and Metric Studio, Cognos Upgrade Manager

Travelers, Hartford, USA

Jun 2008- Feb 2009

Sr. Cognos Developer

Project & Role Description

The project involves:

Migration of reports from Cognos 7.x to Cognos 8.2

Migration of impromptu catalog to Cognos 8.2

Migration of Powerplay cubes to Cognos 8.2

Responsibilities:

51. Use of impcat2xml to migrate package from 7.x to 8.2

52. Architecture of Cognos Framework packages in 8.2

53. Report, package rationalization

54. Report development using report studio, event studio, analysis studio

55. Cube migration and deployment

56. Performance management

57. Involved in Test strategy and execution

58. Managing, co-coordinating and monitoring the overall delivery of

projects from definition to deployment

Tools and Technologies: Report Studio, Query Studio, Framework Manager,

Event Studio and Metric Studio, Impromptu 7.x, Cognos Powerplay

Travelers, Hartford, CT

Sep 2008- Dec 2009

TeaLeaf Consultant

Project & Role Description

The project involves implementation of TeaLeaf within Travelers Personal

Insurance

Responsibilities:

Design Tealeaf Architecture

Implementation of Architecture

Understand user requirements

59. Implementation of user requirements through tealeaf Events, Dashboard

and Scorecards

Troubleshoot and maintain Tealeaf Application

Tools and Technologies: TeaLeaf

Washington Mutual Bank, Lake Forest, CA

Oct 2006 - Jun 2008

Business Objects Designer

Oct 2006-Dec 2006: Pune India

Jan 2007-Jun 2008: Lake Forest, CA

Project & Role Description

The project involves the development of end end-to-end data warehousing

solution for the Home Loans division of Washington Mutual (WaMu) Bank. The

scope involves the creation of a data mart for different channels of WaMu

such as Consumer Direct, Retail and Wholesale. The data mart resides on an

Oracle database; Informatica is used to develop Extraction, Transformation

and Loading (ETL) for the data mart; Business Objects is used as the

reporting tool.

Responsibilities:

Interacting with business users to obtain requirements for Business Objects

reports and create functional specification for requirements

Responsible for architecture of the reporting solution

Involved in estimation for items such as reports, universe development

Involved in project planning activity

Developing EPM based Analytics and Dashboards

Working as an onsite coordinator for execution of the requirements with the

offshore team - managed team of around 6 people

Lead the universe development effort for the project. Developed two

universes.

Tools and Technologies: Business Objects XI R2- Designer, WebI, Enterprise

Performance Management, Dashboard, Oracle 9i/10g, SQL Developer

Schering Plough, Pune, India

Dec 2005 - Oct 2006

Business Object Developer

Project & Role Description

SP-ODW System Offers sales & marketing reporting facility for Schering

Plough users. System is having more than 250 reports. Scope of project

involves design & development of Universe & Reports. The reports are fully

parameterized. It is centralized reporting System for SP-Users

Responsibilities:

Gathering Business Requirements and developing report using web

intelligence

Maintenance and update of the universe

Understanding of the data and making recommendations to change the data

structure to suit the business requirements of reports

Tools and Technologies: Oracle 9i, SQL Developer, Business Objects Web

Intelligence, Business Objects Designer

Cognizant Technology Solutions, Pune, India

Sep 2005 - Dec 2005

Trainee

Project & Role Description

Application is used to get the stock prices using Yahoo Web service.

Responsibilities:

Gathering Business Requirements and design of UI

Application development using C#

Tools and Technologies: C#, MS SQL Server

Sardar Patel College, Mumbai, India

Jun 2004 - Mar 2005

Student

Project & Role Description

Application helps librarian in maintenance of books, members through use of

Barcode. UI is designed using VB; Microsoft SQL server is used as backend.

Responsibilities:

Design of data model

Implementation of database using the data model

Design of UI interface

Interface implementation for Barcode

Tools and Technologies: VB, Microsoft SQL Server

Contact this candidate