Solutions Consultant Resume
UsA
CAREER OBJECTIVE
To pursue a challenging position with an organization that provides ample opportunities to learn, contribute and grow along with them.
EXPERIENCE SUMMARY
- Six years plus of experience in Offshore/Onsite on various initiatives encompassing Project & Portfolio Management Process Definitions and Implementations, Process Optimizations, Business Analysis, Requirements elicitation, Effort Estimations and Reporting Solutions.
- Expertise on various modules of HP Project and Portfolio Management product suite like Portfolio Management, Project Management, Demand Management, Financial Management, Time Management, Resource Management, Program Management and Deployment management
- Working experience on CA Clarity tool and related modules.
- In-depth knowledge on various software methodologies and working knowledge of various Project Management frameworks.
- Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming.
- Expertise in development of reports in SQL, JSP and product based technology, which helped customers to meet their reporting needs. These reports provided visibility and catered to the needs of various stake holders.
- Extensive experience in identifying performance issues, debugging and performance tuning using SQL Trace, Explain plan, Indexing.
- Utilizing the Process Knowledge and technical credentials, has contributed in digitizing V Model and SCRUM methodologies in HP PPM.
- Exposure to VSS, Perforce, Clear case and Business Objects.
- Good interpersonal and communication skills, commitment, result oriented, hardworking with a quest and zeal to learn new technologies and undertake challenging tasks.
- A highly strategic planner, adaptive worker, dynamic team player and a trusted mentor with excellent interpersonal skills to work across geographies.
- Involved in technology upgrade related activities in HP PPM.
PROFESSIONAL EXPERIENCE
Previous Organization : Confidential,India
Duration : September 12, 2005 – April 30, 2012
Designation : Solution Consultant
TECHNICAL SKILL SET
Primary Skill:
HP PPM 6.0/7.0/7.1/7.5 / 8.0/9.1, Clarity V12.1.0,PL/SQL
Language:
SQL, PL/SQL, C/C++, Visual Basic 6.0, JAVA,ASP
Web Programming:
HTML, DHTML, JSP, XML, MS Front Page 2000, Adobe Photoshop,
Edit Plus Editor, SOAP
Packages:
MS Office
Databases:
Oracle 9i and Oracle 10g
Operating System:
Windows 9x, 2000, XP, Microsoft DOS & UNIX
Tools:
Maximo, FlowBrix, Business Objects - Crystal Reports, PL/SQL
Developer, TOAD, Primavera, VSS, Clear case and Perforce
CERTIFICATIONS AND TRAININGS
- HP PPM Product Specialist
- IBM Certified Specialist - Rational Unified Process v2003(RUP)
- IBM Certified Deployment Professional - Maximo Asset Management V7.1
- Certified with Perforce Administrator level
- ITIL - Information Technology Infrastructure Library Foundation
- Software Configuration Model
- Review and Testing
- Trained in Business Objects
- Emerging Leaders Program – Level 1
- Emerging Leaders Program – Level 2 (Hand’s On Leaders Program)
- Creativity workshop
ACCOLADES
- Recognized with “Feather In My Cap” Award for performance excellence in 2007.
- Recognized with “Feather In My Cap” Award in 2009.
- ‘Sudoku’ Runner-up; an event organized at the organization level.
EDUCATIONAL QUALIFICATIONS: MS , B.Sc
PROJECT EXPERIENCE(s)
Project Name
CA Clarity Implementation
Client:
Confidential, US
Description:
Clarity V12 implementation primarily consists of Project, Resource, Demand and Financial Management. There are several processes and portlets are developed. Customized reports provided the in detail of data. Security model has been setup based on group and there several interfaces implemented for HR feed project detail.
Role :
Solutions Consultant
Team Size:
2
Technology:
CA Clarity V12.1.0, PL/SQL and Gel Script
Responsibilities:
- Requirements Elicitation, Analysis and preparation of Functional Specifications.
- Design processes and associated objects.
- Solution design and configuration of various entities in Clarity.
- Minor enhancement of clarity objects, custom jobs and reports, Portlets and Executive Dashboards
- Workaround for issues related to Product
- Resolution of all incidents related to Project Management, Time Management, Resource Management, Capacity planning
- Create or update SQL function, Procedures and trigger based on business requirement
Project Name
HP PPM implementation
Client:
Confidential, in Europe
Description:
This project uses HP PPM 8.0 for implementing Portfolio Management solutions and aims to bring in one version of truth through various reports. The scope was to implement Demand Management, Project Management, Resource Management and Time Management.
Role :
PPM Consultant – Team Lead
Team Size:
3
Technology:
HPPPM 8.0, PL/SQL, JSP, XML, UNIX, and HTML
Responsibilities:
- Coordinating with Offshore for their understanding on Requirements and developed the Functional Specifications and Technical documents for all work streams
- Configuration of workflows, Sub workflows. Build Custom Reports and Portlet Configuration, Setting up Dashboard for Multilevel Roles
- Governs the entire Project Portfolio Lifecycle from Proposal Initiation, justification, and review, execution, deployment, and benefits realization.
- Visibility into resource supply-and-demand and resource skill levels to gain the insight to use valuable resources more wisely and improving overall productivity.
- Real-time visibility into project resources, processes, status, and dependencies to improve communication and productivity
- Consolidated reporting for better visibility and control
- Assignment of tasks to team members; monitor and assist in activities and get them to closure.
- Identify enhancement areas and configuration of approved enhancements.
- Monitoring Server and database and performing all the routine maintenance activities
- Working with PPM Support to troubleshoot problem faced in HPPPM.
- Analyze the data and update it accordingly for various projects so that all graphs related to projects, budgets, cost, resource staffing etc have same look and feel as in previous version of fast tour
- Recommendations to configure PPM 9.0 to support the high level requirements
- Testing the Objects and configuration against the requirements.
- Deploying the Objects to Production.
- Presenting Demo of the completed Work.
Project Name
HP PPM Enhancements & Support
Client:
Confidential, in US
Description:
The bank was a leading securities firm in southern California providing investment services to individuals and large organizations. This implementation involved gap analysis in the existing PMO processes, define the to-be processes based on discussions with the senior management and digitization of these processes using HP PPM. This is an enhancement initiative across various modules like Demand, Portfolio, Project, Program, Time and Resource Management modules of HP PPM.
Role :
PPM Consultant
Team Size:
5
Technology:
HPPPM, PL/SQL, JSP, XML, UNIX, and HTML
Responsibilities:
- Requirements Elicitation, Analysis and preparation of Functional Specifications.
- Day to day interaction with various stake holders like customer’s PMO team, finance and other groups to study the existing procedures, processes and controls and perform the process re-engineering to remove the bottlenecks and improve the efficiency.
- Configure process flows; develop custom reports and migration of code across different environments.
- Development included configuration of Request Types and Workflows, development of JSP Reports, and Portlets
- Configure the PFM Proposal and Project Process as per the requirement.
- To have an automated Status Reporting process.
- Development, Peer Review, Unit Testing and Integration Testing
- Tracking change requests and enhancement requests in the current process
Project Name
Software Development Lifecycle Model
Client:
Confidential, Internal
Description:
This involves in development of intellectual property in PPM product suite, aligned with Software Development Lifecycle Models like V-Process, SCRUM and RUP.
The Process Model’s are created with the aim of improving the efficiency and effectiveness of software development.
Role :
PPM Consultant
Team Size:
3
Technology:
HP PPM 7.5, PL/SQL, and UNIX
Responsibilities:
- Preparation of Functional and Technical Specifications.
- Developed Complex PL/SQL functions and procedures to implement the required business logic in V- Process, SCRUM & RUP Workflows.
- Testing the Objects and configuration against the requirements.
- Custom Portlet Configuration, Setting up Dashboard for Multilevel Roles
- Developed Shell Scripts to upload user data from CSV file to staging table, to automate error handling, to execute PL/SQL Procedure.
- Developed a Technical Design Document for all the work streams.
- Testing & Deployment, End user Training
Project Name
PPM Implementation
Client:
Confidential, in US
Description:
This project includes the Automation of User creation and tracking the open issues/Product issues. Also included the support with HP PPM Modules
Role :
PPM Consultant
Team Size:
1
Technology:
HPPPM 7.1, PL/SQL, XML, and Microsoft Project Plan
Responsibilities:
- Worked in Client location to design the requirements and map data from a legacy system into ITG
- Imported project through Microsoft Project Plan and imported PPM Users through an automated process
- Worked with Mercury Support to troubleshoot problem faced in HP PPM.
- Resolution of all incidents related to Project Management, Time Management, Resource Management
- Configure Workflows, Request Header Types, Request Types and build custom PPM Portlets and dashboards
- Testing the Objects and configuration against the requirements.
Project Name
Organization Performance Management System(OPMS) Phase – 2
Client:
Confidential,
Description:
The quantitative process management at all levels of the organization by implementing HP PPM tool that will optimize OPMS using integrated Program & Project Management (PPM) modules of HP PPM Center. Under this project it upgraded the existing work plan, dashboard and report that had been developed in Phase - 1.
Role :
PPM Consultant
Team Size:
2
Technology:
HPPPM 7.0, PL/SQL, JSP, XML, and UNIX
Responsibilities:
- Worked in Client location and analyze the data and update it accordingly for various projects so that all graphs related to projects, budgets, cost, resource staffing etc have same look and feel as in previous version
- Understand the previous code and make recommendations on the part of functions that need to be addressed from the backend as stored procedures and the ones from front end.
- Create or update SQL function, Procedures and trigger based on business requirement.
- Developed a Technical Design Document for all the work streams.
- Configuring high level executive Reports build in PLSQL and JSP
- Custom Portlet Configuration, Setting up Dashboard for Multilevel Roles
- Workaround for issues related to Product
- Monitoring Server and performing all the routine maintenance activities.
- Presenting Demo on completed work
- Testing & Deployment, End user Training
Through this project, the user was provided with project dashboards which gave schedule and effort metrics, automatically derived from the Project Management module that are running based on the organizational units. The reports were also providing for the better performances.
Project Name
Organization Performance Management System(OPMS) Phase – 1
Client:
Confidential,
Description:
This project provided the user with metrics information with respect to the organization’s process. Include all metrics and divisions where it is used by manager level. The modules are developed for multi-level roles.
Role :
PPM Consultant
Team Size:
2
Technology:
HPPPM 6.0/7.0, PL/SQL, JSP, XML, and UNIX
Responsibilities:
- Worked in Client location to understand the functionality and requirements.
- Prepared all necessary documents for POC (Proof of Concept)
- Responsible for setting the Dev / Staging and Production Setup for HP PPM
- It required a tremendous amount of research on new features of PPM 7.1 and how could those features be incorporated for the clients existing implementations.
- Preparing the checklist for the pre-Upgrade and Post – upgrade activities
- Preparing a manual for the change in process after upgrade including the new features of PPM 7.1
- Customizing the implementations to be compatible with PPM 7.1
- Successful Upgrades to Three Instances (Dev, Test, Production region) of ITG
- Installing Service Packs
- The HRMS integration with HPPPM was provided to import users. Here HPPPM includes an open interface for importing user information. This open interface can import user models from third-party systems including LDAP databases, internally developed systems, or human resources systems
- Configuring high level executive Dashboards and Reports
- Testing & Deployment, End user Training
Project Name
Software Process Improvement
Client:
Confidential, Software Process Improvement
Description:
Through this project the Wipro’s Rapid-Q was enhanced and placed in for all employees in organization. Also an Audit tool was developed for the auditing purpose which used the Wipro’s workflow tool, Flowbrix.
Role :
Project Engineer
Team Size:
3
Technology:
JAVA,HTML,MS Front Page, Adobe Photoshop, ASP, Flowbrix, VSS
Responsibilities:
- Understand on the SDLC Process and involved in enhancement of Rapid-Q
- Configuration of new objects for new enhancements in Rapid-Q
- Analysis on customer requirements for Audit tool
- Involved in developing an Audit Tool
- Had detailed training on Rational Unified Process and other process like ITIL, CMMi
Project Name
Software Development Lifecycle Model
Client:
Confidential, Internal
Description:
This involves automation of standard Software Development Lifecycle Model (V Model), which is in compliance with CMMi-3. This has been implemented in HP PPM 6.0.The V Process Model is created with the aim of improving the efficiency and effectiveness of software development.
Role :
Project Engineer
Team Size:
3
Technology:
HPPPM, PL/SQL, and UNIX
Responsibilities:
- Preparation of Functional and Technical Specifications
- Custom Portlet Configuration, Setting up Dashboard for Multi-level Roles
- Designed and configured the complex process into the workflows, Sub workflows and Request Types
- Developed Complex PL/SQL functions and procedures to implement the required business logic in V- Process Workflows
- Handled User Administration which includes Security and access grants
- Preparation of WebX Demo and presentations for the Client
Project Name
ITG Implementation
Client:
Confidential,
Description:
The client is provide with the automated processes of their POC, internal IT demand control, change control, new Organization unit creation and user creation. The test cases are prepared and tested with all scenarios for the client.
Role :
Team Member
Team Size:
3
Technology:
HPPPM 6.0, PL/SQL, and UNIX
Responsibilities:
- Understanding the functionality and requirements for mapping data from a legacy system into ITG
- Handled User Administration which includes Security and access grants
- Participate in design discussions for integrating open systems and stored procedures
- Involved in Peer Review, Unit Testing, Integration Testing