Advisory Project Manager - Data warehouse and Business Intelligence
IBM
Total years of experience :20 years, 4 Months
Client : A leading telecom operator
Portfolio : Data warehousing & Business Intelligence
Activities :
Manage and deliver demands and service request, Engage stakeholders for execution of projects and change requests.
Present in Weekly Governance meetings, Joint Steering Groups and Executive steering comittees.
Performed incident management, Provide resource allocation and leveling for AMS activities.
Work with Subject Matter Experts, Business Analysts and Solution Architects to create estimates, BRS and FRS to enable execution of change requests and / or projects.
Create forecast allocation of resources.
Interact with Client for direction on new demands, provide status reporting and prioritization of current demands.
Work with Operations and various vendors to support infrastructure and migration activities.
Client : A leading credit card provider
Portfolio : Basel II & Basel III - Data Management (DW / BI)
Activities :
Design and Build systems to support the automated capture and consolidation of data from the various business warehouses/systems into a central RWA data warehouse for use within the RWA calculator and other RWA pre-processing as needed.
Also support the implementation of the reconciliation process between the finance data/GL and the risk data stored in the various warehouses, as well as any remediation needed to risk data prior to use within the Basel II calculator.
Work with various sources to gather exposure & master / reference data.
Follow the guidelines of the ePMO setup for the BASEL initiative to achieve strategic objectives.
Assist the staffing for the BASEL team. Ownership of fulfillment of open positions.
Forecasting and Managing project Financials. Present monthly forecast reports.
Monitor and Tracking execution of the project using Microsoft project and CA Clarity. Report status to client week by week.
Conduct method adoption workshops to define the tailoring between the client’s project management systems and IBM's project management methodology. Publish tailoring documents post such workshops. Revisit the Tailoring documents on set frequencies.
Identify metrics to be collected for the projects. Also enable Metrics gathering and submission of the portfolio and individual projects.
Conduct RCA workshops to identify and come up with solutions for issues, encountered. Ensure lessons learnt are documented post project completion.
Environment: Informatica 9.1, Oracle 11, Unix, MicroStrategy.
Project Size: 65
Program : IBM Learning and Knowledge; Asset Harvesting, Knowledge Management.
Activities :
Collaborate with Service lines and Global Delivery accounts for seeking assets estimates
Come up with milestone based project plan for every quarter for assets harvesting
SPOC for all GD asset harvesting related communication, issues, changes etc.
Manage the collection of assets; Maintain a scorecard of all requests and status.
Drive the asset collection aggressively against set targets.
Drive the activity score in PP for all GD KS harvested assets in order to ensure assets and harvesting quality
Coordinate with the GBSC to ensure complete view of assets are included in harvesting efforts
Monthly status reporting of harvesting and wiki maintenance
Client : A leading credit card provider
Portfolio : Global Risk Systems - Accounts Monitor and CBR
Activities:
Responsible for developing project charters and plans.
Responsible for delivery management, metrics management and reporting, work product quality. Engagement with PMO to maintain strategic objectives.
Create and update the requirement traceability matrix, update requirement risk assessment.
Drive the JADR and SAR meetings, engage respective stakeholders.
Responsible for delivery of new and complex high quality solutions to clients in response to varying business requirements.
Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
Working with client counterparts to translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results. Forecasting and Managing project Financials. Present monthly forecast reports.
Monitor and Tracking execution of the project using Microsoft project and CA Clarity. Report status to client week by week.
Conduct method adoption workshops to define the tailoring between the client’s project management systems and IBM's project management methodology. Publish tailoring documents post such workshops. Revisit the Tailoring documents on set frequencies.
Identify metrics to be collected for the projects. Also enable Metrics gathering and submission of the portfolio and individual projects.
Conduct RCA workshops to identify and come up with solutions for issues, encountered. Ensure lessons learnt are documented post project completion.
Environment: COBOL, JCL, DB2, IMS DB/DC, EzyTrieve, Xpeditor, SPUFI, Changeman, BMC tools
Project Size: 32; Teams: 3
Client : A leading credit card provider
Portfolio : MATIC (Merchant Acquisition Tracking Incentive Compensation)
Activities :
Responsible for leading a project team in delivering solution to our customer in the Credit Card sector.
Deliver new and complex high quality solutions to clients in response to varying business requirements
Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
Working with onsite to translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
Environment: COBOL, JCL, DB2, UNIX, Xpeditor, SPUFI, Changeman, BMC, Actuate eSpreadSheets
Team Size : 5
Project Size: 17
Client : A leading credit card provider
Portfolio : Global Network Systems - Network Information Center (GNS NIC)
Activities :
Responsible for leading a project team in delivering solution to our customer in the Credit Card sector.
Deliver new and complex high quality solutions to clients in response to varying business requirements
Responsible for managing scope, planning, tracking, change control, aspects of the project.
Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
Working with onsite to translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
Environment: COBOL, JCL, DB2, UNIX, Xpeditor, SPUFI, Changeman, BMC, Microstrategy, Actuate, Informatica
Team Size : 12
Client : A leading credit card provider
Portfolio : Online Financials and LIFT memo (ECM- AT)
Activities : Although only a limited time period was spent on these applications. I was a part of major release like Large ROC and other smaller releases. Had gained considerable functional knowledge on these applications
Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact
Coordinate and communicate tasks with developers
Ensure that development is performed as per requirements
Work with QA to create test scripts and scenarios for enhancements and customizations to the core product
Communicate activities/progress to project managers, business development, business analysts and clients
Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process
Environment: COBOL, JCL, IMS DB/DC, DB2, Ezytrieve, Xpeditor, SPUFI, QMF, MQ
Project Size : 26
Project:
Finance applications related to Property Accounting, Corporate accounts payable, Inter-company settlements Mechanized Tool Order Systems, Labour Reporting systems, Inventory Budget Reporting Systems, Manufacturing Product and Costing applications, and PeopleSoft General Ledger systems.
Activities:
Interact with Business Users and On-site team members to track the developments in the project. Assigning & Review of different new & ongoing tasks received from Client / Onsite Team. Monitoring and Production support of various Systems & Applications Job Cycles. Analysis and solving problem tickets (Abends).
Includes development and enhancement of the system and also providing 24x7 technical support for the critical applications to ensure smooth business functioning.
Development/Enhancement and testing of On-line and batch application programs. Preparing unit and integrated Test Plans for developed modules according to mentioned ISO and SEI CMMi Level 5 Standards and Procedures.
Also a Part of the NewCo Project. This involved the sales of 14 pants to FORD from VISTEON. IT scope was migration of the assets, retirements, capitalizations and reclassification into different accounts.
Also served as a Project Quality Lead. As a part of this role, was undertaking quality sessions for the team members and ensuring that the team members follow the standards.
Underwent training for Mainframes
- Cobol
- JCL
- DB2
- IMS