Project Manager
Resume:
Pankaj Ladi
**********@*****.***
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