Project Manager Management
Resume:
***********@*****.*** Joe Amal
Senior EDW/BI Manager(Technical & Management)
Executive Summary
Program and Executive Management
Global Team Management
Consulting Management
Vendor Management
Technology Management
Design & Development Management
Architecture Management
Delivery & Implementation Management
End to End Enterprise Data Warehouse(EDW) and Business Intelligence(BI)
Data Strategy(Data Quality, meta
data, data distribution, etc.,)
Integrations
Infrastructure
IT Project Management/Execution
DW/BI Assessments & Roadmap
Develop & Plan Project Strategies
Budget, Cost, Schedule, Scope & Requirements Management
Project Proposal, Stakeholder Negotiations
Resource Planning, Forecasting
Risk & Mitigation Planning, Change Control Management
Communication
UAT & QA Strategy
Implementation Strategy
IT Operations Management
Business Continuity Planning
Disaster Recovery Planning
Onsite/Offsite/Offshore
Relationship / Account Management
Client Relationship Building
Account Management
Support Management
Escalation Management
Operations Support
Implementation/Upgrade Support
Technical Support on Issues
Solutions Provider
Troubleshooting
Outsourcing Strategy
RFP Response
Specifications Development
IT Enabled Consulting
Solution Architect & Strategy
EDW/BI Assessments & Roadmap
Domain Knowledge
Insurance(P&C)
Retail
Financial(Banks & Credit Cards)
Mortgage
Manufacturing and Trading
Government organizations, etc.,
Highly experienced IT professional with decades of proven track record in Information
Technology, Data warehouse, Business Intelligence, System integration, Program, Project
and People Management. Owns and manages project plans to synchronize deliverables with the
development teams across geographical regions, and ensure that objectives are in line with
the company's and client's overall strategies and long-term goals.
Strong Project Management Skills - With efficient Planning, Multi-Tasking, Prioritization,
Organizational, Decision-Making, Negotiation, Risk Management analysis, and Management
skills, achieved On-Time delivery of projects with better accuracy of schedule, budget and
high quality thru Agile and Water fall methodology.
Strong Program Management Skills - Expertise in managing multiple, large-scale complex
projects in a fast paced, high demanding, and extremely dynamic environment from early
concept creation and prototyping through specification, implementation, testing, and
release to Production.
Enterprise Data Warehouse: Expertise in bringing the data from multiple application
systems and integrating into data warehouse using the appropriate ETL tools and setting up
the infrastructure(Software/Hardware/DB/global network capabilities, etc.,)
Solution Architect Skills - Achieved excellence through identification of non-value added
processes through Process Charting, and performed re-engineering of process in EDW&BI.
Business Intelligence(BI): Excellent experience in delivering the reports/dashboards and
build cubes to fulfill the client needs by using the appropriate Business Intelligence
tools.
Technical Management Skills - Strong Technical background to direct, manages, grow, and
lead a team. Excel in partnering with database and application developers to communicate
and translate business requirements into technical specifications.
Technology Selection: Expert in technology selection process to have the right tool in
Enterprise data warehouse and Business Intelligence by defining the evaluation criteria,
pricing options and performing the POC on each shortlisted tool set before gets finalized.
Onshore/Offshore/Offsite Model: Strong in onshore/offsite/offshore business models,
management and sourcing concepts on providing IT solutions with expected quality.
Customer Relationship and Engagement Skills - Takes full responsibility for creation and
adherence to SOWs, SLAs and Project Budget, performance improvement.
Possess Strong Presentation Skills - Effective presentation skills which include
presenting technical/process solutions thru architecture towards the objective of the
project/program.
Effective Communication Skills - Effective communicator with excellent oral, written and
verbal communication skills with almost no ambiguity and exceptional relationship
management skills with the ability to relate to people at any level of business and
management across the globe and significant experience working with customers, project
managers and technical teams for securing & executing concurrent projects.
Strong Support Skills - Quick grasp of the issue and identification of the root cause and
provide a solution while keeping the pressure and at the same time addressing the progress
to the customer as well as the executives to achieve their business goals.
Easy adapting and fast Learner: Easily adaptable to the new environment, domain, process
and technology where it has been proved by working in different domain and technology.
Excellent People Management Skills - Expertise in technical screening, hiring, training
and coaching the team to achieve their goals, help plan their career growth, establish
leadership skills and constant feedback on the performance.
Socialization: Facilitate for socialization with all key stake holders/sponsors from
multiple geographical area to understand the changes on the existing Data management &
Reporting system, impact and benefit to the organization by the proposed Roadmap with the
timelines.
Training Undergone: Project Management Professional(PMP), Agile-Scrum, Lean and Six
Sigma(tested).
Highly experienced IT professional over 21 years of experience of proven International
Technology, Data warehouse, Business Intelligence, Integration of multiple application
systems, Program, Project and People Management. Owns and manages project plans to
synchronize deliverables with the development teams across geographical regions, and
ensure that objectives are in line with the company's and client's overall strategies and
long-term goals.
Strong Program Management Skills - Expertise in managing multiple, large-scale complex
projects in a fast paced, high demanding, and extremely dynamic environment from early
concept creation and prototyping through specification, implementation, testing, and
release to Production. Ability to influence engineers, management, and executives and all
stake holders in the project.
Strong Project Management Skills - With efficient Planning, Multi-Tasking, Prioritization,
Organizational, Decision-Making, Negotiation, Risk Management analysis, and Management
skills, achieved On-Time delivery of projects with better accuracy of schedule, budget and
high quality thru Agile and Water fall methodology.
Solution Architect Skills - Achieved excellence through identification of non-value added
processes through Process Charting, and performed re-engineering of process in EDW&BI.
Enterprise Data Warehouse: Expertise in bringing the data from multiple application
systems and integrating into data warehouse using the appropriate ETL tools and setting up
the infrastructure(Software/Hardware/DB/global network capabilities, etc.,)
Business Intelligence(BI): Excellent experience in delivering the reports/dashboards and
build cubes to fulfill the client needs by using the appropriate Business Intelligence
tools.
Technical Management Skills - Strong Technical background to direct, manages, grow, and
lead a team. Excel in partnering with database and application developers to communicate
and translate business requirements into technical specifications.
Technology Selection: Expert in technology selection process to have the right tool in
data warehouse and BI tools and perform the POC on each shortlisted tool set before gets
finalized.
Onshore/Offshore/Offsite Model: Strong in onshore/offsite/offshore business models,
management and sourcing concepts on providing IT solutions with expected quality.
Customer Relationship and Engagement Skills - Takes full responsibility for creation and
adherence to SOWs, SLAs and Project Budget, performance improvement.
Possess Strong Presentation Skills - Effective presentation skills which include
presenting technical/process solutions thru architecture towards the objective of the
project/program.
Effective Communication Skills - Effective communicator with excellent oral, written and
verbal communication skills with almost no ambiguity and exceptional relationship
management skills with the ability to relate to people at any level of business and
management across the globe and significant experience working with customers, project
managers and technical teams for securing & executing concurrent projects.
Strong Support Skills - Quick grasp of the issue and identification of the root cause and
provide a solution while keeping the pressure and at the same time addressing the progress
to the customer as well as the executives to achieve their business goals.
Easy adapting and fast Learner: Easily adaptable to the new environment, domain, process
and technology where it has been proved by working in different domain and technology.
Excellent People Management Skills - Expertise in hiring, training and coaching the team
to achieve their goals, help plan their career growth, establish leadership skills and
constant feedback on the performance.
Socialization: Facilitate for socialization with all key stake holders/sponsors from
multiple geographical area to understand the changes on the existing Data management &
Reporting system, impact and benefit to the organization by the proposed Roadmap with the
timelines.
Training Undergone: Project Management Professional(PMP), Agile-Scrum, Lean and Six
Sigma(tested).
Employment Summary:
? Currently working as a Senior EDW/BI Practice Manager from Oct'2013 to till date in
Sogeti USA.,
? Worked as a Sr.Project Manager(EDW/BI) from April'2012 to Oct'2013 in Genpact(formerly a
GE owned company)., USA.,
? Worked as a Sr.Manager(EDW/BI) from Oct'2002 to April'2012 in HTC Global Services Inc.,
USA.,
? Worked as a Project Lead(System Integration and Reporting) from Apr' 98 to Oct'02 in
DATAMAS(BAHRAIN) LTD., Kingdom of Bahrain.,
? Worked as a Sr. Systems Analyst from May' 1995 to March 1998 in Pentafour Software &
Exports Ltd., India.,
? Worked as an Analyst Programmer from May' 1992 to Apr' 1995 in Computer Campus., India.
PROFESSIONAL EXPERIENCE
Sogeti USA.,
Oct'13 to Till date
Role : Senior Enterprise Data Warehouse Solution Architect / Senior EDW/BI Practice
Manager
Client: Whole Foods - Texas based Retail(Fortune 500) Company.,
It is a multi-billion dollar($19B) retailer of natural and organic foods with stores in
the USA, Canada, and the UK.
As a Senior Enterprise Data Warehouse Solution Architect, I have taken the overall
accountability for the EDW and BI effort.
Understood, analyzed and assessed the current AS-IS DW/BI architecture, data models, data
integrations, presentation layer(reports and dashboard), functionality and support process
by leading and conducting the interview sessions with Stakeholders.
Defined the High level scope for the Future State and designed the entire architecture for
the Enterprise Data warehouse.
Presented the future vision to the customers, translate their business problems into
practical solutions and put across as per CoE.
Partnered with other application project managers, business analysts, DWH, BI and
analytics leads and architects to create well-defined solutions that are aligned to
client's IT Strategy and leverage common solutions and services, to meet key project
goals.
Designed and supported the strategic direction for the data warehouse environment and
presented the high level road map.
Led architecture for various layers of DW including data hub, ODS, Staging, Post Staging,
EDW, Data Marts and Semantic.
Recommended the ETL tools, evaluation process and pricing options, defined the criteria to
be evaluated, worked with the vendors and Data warehouse team on pre-demo and demo
activities and worked on creating use cases to be tested on each ETL tool and record.
Led the design and supported the initial development activities towards the EDW/BI
Architecture which has been recommended.
Recommended the archiving strategy and the dual load, replication process on Enterprise
data warehouse data and recommended the process towards the Data Quality measurement and
improvement.
Supported the estimation process and project planning and work with the Onsite and
offshore team to get committed to the deliverable.
As a Senior EDW/BI Practice Manager advised and partner with clients on solving their
business problems by leveraging EDW/BI Practice offerings and capabilities which includes
EDW&BI solutions.
Worked closely with the Sales team and Delivery team to manage pre-sales efforts and
engagements in the specified geographical area.
Assisted them by identifying options with recommendations, and/or the implementation of
EDW & BI solutions.
Responsible for generating new business and growing, developing, and managing a team of
consultants for deeper penetration in each account.
Collaborate closely with the Global based EDW/BI practice teams to develop proposals,
presentations, and statement of work (SOW).
Worked with the identified key alliance partners and software vendors to jointly develop
plans on training, opportunities, etc.,.
Client : Ironshore Insurance Company, New York based muti-national Insurance company,
NY,USA Apr' 12 to Oct'13
It is one of the fastest growing insurance company where it provides broker-sourced
specialty property and casualty insurance coverage in Bermuda, U.K., Canada, Ireland,
Australia, Singapore and the U.S.
Role : Senior Manager(BI Practice & Project/Program Management(Waterfall & Agile-Scrum)) /
Senior Enterprise Data Warehouse Solution Architect for Data Management and Reporting
(DMR) Projects/Program
Involved and managed the assessment activities(current, future states and strategic
roadmap) on Data warehouse architect, data models, data integrations, presentation
layer(reports, dashboard, scorecards), functionality and support process with future
plans.
Worked closely with the vendors and the client(sponsors)on tool(ETL & BI Reporting tool)
selection process to serve client's needs.
Understood the requirements of the Projects/Program, defined the scope, defined
activities, estimated activity duration, estimated
the activity resources and leveled the resources across the projects, developed the
Project Schedule and determined the budget.
Managed the EDW/BI team to support the Enterprise Data warehouse, Business Intelligence
and Analytical environments.
Led and managed the team, and delivered multiple EDW/BI projects of the global Data
Management and Reporting (DMR) program.
Involved in the activities towards re-architecting and building the current Global Data
Warehouse(GDW-EDW) and Global Data Marts(Policy, Claims, Reinsurance and Finance) and
integrating multiple global(US, BDA, CA, IRE, AUS and Sing.) application
sources(Submissions, Quote, Policy, Claims, Gross Insurance and Reinsurance) with the
appropriate ETL tools.
Led the activities on creating BI reports and Dashboards with the required business KPIs
to overcome the current challenges and to meet client's business needs by working with the
development and testing team, project leads and managers.
Worked and mentored on designing the new data warehouse and recommended the best practices
and standards to be followed.
Managing client support, resolving the issues/conflicts when necessary, monitoring
on-going project needs and exploring future projects based on client requests for the
above Data warehouse and Business Intelligence projects.
Identified, tracked, managed and resolved project Risks/issues and discuss the major RISKs
on each phases of the project. Track the RISKs and Issues with the key stake holders and
have an agreement with them on resolving those.
Worked with the Infrastructure team on activities like capacity planning, costing,
environmental setups, HA and DR designing process, Virtual/Physical servers decisions and
VDI accesses towards the objective of the Projects/Program.
Mentored to follow the improvement process to have data quality across the system by
performing the data profiling activities.
Involved on walk-thru of the QA and UAT strategy which consist of Entry and Exit criteria
to make sure that they would perform the tests like, end to end functional, role based and
performance tests before the implementation.
Ensured that the team follows the Requirement Traceability matrix where it can trace the
business needs from scope, requirements(business/technical), mapping, design,
code(development), testing(unit, SIT,QA, UAT, PROD) to verify the deliverables.
Conducted status meetings on a periodical manner and present the project status reports to
the management with the variances.
Client: Meijer Inc., Michigan based multi-billion dollar Retailer., MI, USA
Jul' 09 to Apr'12
It is a leading Supercenter located in six states throughout the Midwest, with over 200
stores and 60,000+ employees. As a multi-billion dollar($14B) retailer, It is ranked as
the 13th largest privately held company in the country.
Roles: EDW Solution Architect/ETL-BI Lead, Sr.Project Manager
Responsibility: As a Senior Project Manager(Waterfall & Agile-Scrum) managed and delivered
the following projects to build the reports to have all metrics related to Replenishment
workbench(RWB) and Buyer WorkBench(BWB), promotional demands, sales trends, forecast
quantities, forecast sales, forecast DM, etc., from 'Replenishment parameters' and metric
of market basket to have the consistent definition of customer value, to track changes in
customer behavior over time, to analyze shopping behavior towards the other Brands and Own
Brands and to have the statistics of house hold and about the trips.
Integration of the data into the Enterprise data warehouse from Pricing & Promotions'
system(RWB & BWB) and build reports
Integration of the data from Replenishment Parameter Systems, Plan-O-gram and Market
Basket systems and build reports
Monitored and managed the program/project baseline to ensure activities are occurring as
planned - scope, budget and schedule and managed variances. Ensured that the quality
program/project standards are met as prescribed through the effective implementation or
use of approved processes, methodologies and deliverables.
Communicated including status reporting, risk management by tracking and escalating that
cannot be resolved in the team.
Client: StateFarm Insurance Illinois based Fortune 50 mutual insurance company., IL USA
Oct' 02 to Jun'09
Role : Project manager, ETL/BI lead, Data Architect for Data warehouse and Business
Intelligence(BI)
Developed, Managed, delivered and supported multiple system/data integration, reports and
dash boards which are part of Data warehouse and Business Intelligence(BI) projects. The
application systems/subject areas integrated are like,
Auto, Fire(Premium & loss), Deposits and Mortgages from EDS/ Nexstar/Cenlar source(s),
Mortgage Loans, Mortgage Life Insurance and Homeowners Insurance, Credit Cards (platinum
Cards, Classic Cards and Corporate Cards) and Bank Deposit & Bank products.
Business Events analysis and reports on Auto, Fire, Client, Life, Health, Mutual funds and
Marketing Units
Data Analysis and reports on Enterprise Complaint Handling and Feedback System(ECHFS)-all
insurance lines, Bank, and Mutual Funds.
Mentored and managed the data modeling(logical/physical) activities of data warehouse and
datamarts, building ETLs to extract the data from multiple source systems and databases
and the related activities like data profiling, all testing cycles(Unit, system
integration, QA and User acceptance, performance testing), build reports, cubes, dash
boards and score cards and IPOP activities to have the historical data towards the
reports, business and trends' analysis.
Developed formal project plans to outline implementation approach and monitoring the
Project activities in onsite, offsite and Offshore and proactively identified the risks &
issues in advance, also developed the contingency plans to handle those.
Established reasonable, challenging and clear expectations from the team, and holding them
accountable to meet the expectations by providing good performance feedback to team
members. Also monitored and managed the project/program change through formal change
management processes and stakeholder/customer relationship management including reporting
on variances.
Managed & Coordinated the Development, testing and support team in onsite, offsite and
offshore and provided technical guidance and direction to the Developers / Analysts
towards to achieve the project goal by following the best practices and standards.
Hardware, Software, Tools & Utilities used in the above projects:
Informatica, Datastage, SAP-BO(Business Objects), Microstrategy, Open Text-BI, IBM Cognos,
Teradata and Teradata utilities(Fast Export, Fast Load, Multi-Load, BTEQ, TPump), DB2,
Oracle, MS SQL server, MS Project, SSIS, SSAS, SSRS,TFS, Rational ClearCase, SAS(MF),
Mainframe ETL, IBM-Geneva, BMC Loadplus(DB2),SQL*Loader(Oracle), BMC Remedy, Cybermation
ESP workstation 5.5, Visio Prof., CA Erwin, Cobol, JCL, VSAM, PL/I, CICS, IMS DB/DC, CEDF
, Xpeditor, File-Aid, ISPF/ PDF, strobe, Endevor, QMF, spufi, ES 9000 MVS/ESA, OS/390,
z/OS, Unix
Client: General Directorate of Information Technology(GDIT)., Kingdom of Bahrain
Apr' 98 to Oct' 02
Role: Project Lead(System Integration and Reporting) for multiple government IT projects
of GDIT
PENTAFOUR SOFTWARE & EXPORTS LTD., May'
95 to Mar' 98
Role: Sr. Systems Analyst - Developed, Implemented and supported multiple application
systems.
Computer Campus, India May' 92
to Apr' 95
Role: Analyst Programmer - Analyzed, developed, tested, implemented and supported
multiple application systems.
Technical Summary:
Tools(ETL)
Informatica, IBM-DataStage, SSIS(Microsoft), Mainframe ETL, IBM-Geneva,,
Tools(BI Reporting and Analytical)
Business Objects, MicroStrategy, IBM Cognos, MS-SSRS,, Open Text-BI, SAS(mf), MS-SSAS
Other Tools and Utilities
Teradata utilities(Fast Export, Fast Load, Multi-Load, BTEQ, TPump), MS Project,
Primavera, CA ERwin, BMC Loadplus(DB2),,SQL*Loader(Oracle), CEDF, File-Aid,
CA7, CA11, SPUFI, QMF, STOPX37, ACF/RACF, XPEDITER, CLIST, JES2/, ISPF/PDF, OmegaView,
Endevor, Tivoli, DBRC, Rexx, CLIST, MTS, Developer 2000
Databases/File Systems
Teradata, MS SQL Server, IBM DB2, Oracle,, IMS/DB, Fox pro, Dbase III Plus, VSAM
Operating System
Windows 2003 Server, Windows Desktop 2003,XP, 2008, Windows 95/98, Windows NT 4.0, DOS,
Unix, ES 9000 MVS/ESA, OS/390, and z/OS
Education
* Masters in English, Annamalai University, India, 1995
* PGDCA (Post Gradruate Diploma in Computer Application) from Computer
Campus, India, 1992
* Bachelors of Science (Chemistry), St. Joseph's College, Bharathidasan
University, India, 1990
[pic][pic]
Contact this candidate