SUMMARY:

• Dynamic and result - oriented consultant with 6 years of clarity experience with proven expertise with various modules and accelerators of CA Clarity PPM.
• Extensive design, development, installation, implementation, customization, enhancement, administration, maintenance, scope & requirement gathering, production support & providing innovative solutions for Clarity PPM.
• Excel in demanding, high-visibility and high pressure environments.
• Related experience includes working on all Clarity PPM versions with an emphasis on XOG, GEL Script, Data Model, Clarity Studio, Process Management, Clarity Author, Workbench, MS Project, MS Share Point Integration, NSQL, Portlets, Business Object and Custom Interface design and development
• Created extensive Lookups, Menus, Sections, etc using Clarity Studio
• Development of custom Portlets
• Defined and developed Clarity custom processes with action items, system actions, notifications and database manipulations using GEL scripting.
• Installation and configuration of XOG client and migrating different instances.
• Experience in writing gel scripts for processes
• Generated requisitions, created resources, allocated resources, created roles and calendars.
• Advanced knowledge in most CA Clarity modules including project management, resource management, financial management, timesheet and time reporting.
• Integrated CA Clarity with Actuate and Business Objects (BO) reporting tools using ODBC and Oracle client.
• Setup times slices and Data marts.
• Developed medium and complex queries using PL/SQL and converted them into NSQL
• Written stored procedures, triggers, functions and other DB components

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Gel Scripting, XML, HTML

Clarity PPM Tools: CA Clarity (7.5.3, 8.1.2, 12), GEL Script, XOG (XML Open Gateway), NSQL

Databases: SQL Server 5.x, Oracle 9i/10g

Operating Systems: Windows NT/95/98/XP.

Technical Functional: Portlet and portlet page configuration Requirement Analysis, Custom object design and implementation Resource Management

Implementation: Interface to external system Demand Management

Development: OBS /group analysis and creation Project Management, Process design and implementation Finance Management, Installation, configuration and update Portfolio Management

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

CA Clarity Developer

Responsibilities:

• Created functional designs for implementing the Clarity modules project Management, Demand Management, Portfolio Management, Resource Management, Process Management and Service Management.
• Created objects, object views, lookups, processes, and portlets to implement changes defined in the functional design.
• Developed executive dashboards to display the Project information. Dashboards show Project releases, lifecycle, release by area and release by request type.
• Fine tuned the portlet queries to show the data within the time limit defined as TracFone standard.
• As a functional consultant, helped business users with questions related to usage of tool and questions around business processes and Consultant timesheet
• Designed and developed multiple processes using the GEL Script. One such example is process created for sending external emails with attachment to vendors outside TracFone.
• Created process flows to send reminder emails for resource managers to approve the timesheet and PO extensions for consultants.
• Created Portlet to display aging action items and average approval time.
• Worked on two upgrade projects 8. .0.6 and 12.0.6 to 12.1.1. Lead the efforts for upgrading the tool to version 12.
• To ensure the availability of the clarity application created procedures to monitor the clarity system all the time.
• Organized the releases based on the business priorities, estimates, and timelines set for the release. And also coordinated efforts for QA, UAT testing.
• Expert in creating the XOG files required to move the configuration changes across the Clarity environments.

Environment: XOG, Gel Scripting, NSQL, SQL, Oracle 10g, Business Objects.

Confidential, Long Island city, NY

CA Clarity Consultant

Responsibilities:

• Created functional designs for implementing the Clarity modules project Management, Demand Management, Financial Management, Portfolio Management, Resource Management, and Service Management.
• Created objects, object views, lookups, processes, and portlets to implement changes defined in the functional design.
• Created specs for the custom reports in Actuate, Cognos.
• Developed executive dashboards to display the financial information. Dashboards show the financials at project level, program level, application level and department level. And also developed multiple portlets to show the information in a format more useful to end users. Fine tuned the portlet queries to show the data within the time limit defined as Confidential standard.
• As a functional consultant, helped business users with questions related to usage of tool and questions around business processes.
• Designed and developed multiple processes using the GEL Script. One such example is process created for populating the project health indicators based on the updates to the project.
• Designed and developed jobs that creates/updates the cost plans, budgets at different points planning/forecasting phases. E.g. updating the costs in the cost plan(s) if rate associated to the role changes in a year, approving the budget automated way at the end of the planning cycle, assigning the Actuals as forecast at the end of every month.
• Worked on two upgrade projects 7.5.3 to 8.1.3 and 8.1.3 to 12.0.3. Lead the efforts for upgrading the tool to version 12.
• To ensure the availability of the clarity application created procedures to monitor the clarity system all the time.
• Organized the releases based on the business priorities, estimates, and timelines set for the release. And also coordinated efforts for QA, UAT testing.
• Expert in creating the XOG files required to move the configuration changes across the Clarity environments.

Environment: XOG, Gel Scripting, NSQL, SQL, DBMS SQL Gen, Oracle 10g, Actuate, Cognos.

Confidential, Denver, CO

Clarity Consultant

Responsibilities:

• Worked on in CA Clarity (Niku), Oracle, Actuate Reporting and performed software analysis, design, development, requirements gathering, analytical decision-making, and project management.
• Worked on the Clarity Upgrade from Clarity 7.5.3 to Clarity 8.1 and Clarity 8.1 to Clarity 8.1.3
• Worked extensively on XOG, Clarity Processes, Actuate Reports & Jobs, Portlets, NSQL, Gel Scripting and Oracle 10g
• Created and executed Load Runner performance scripts on Clarity application to analyze the
• Performance impact of upgrades and major changes on the system.
• Employed XOG utility to ensure changes/data credibility between development environments. Design and implement CA Clarity real-time bi-directional integration with multiple existing systems using SOAP (XOG WSDL).
• Automate project management processes using single and multi-threaded Clarity workflows and very detailed/complex GEL scripting.
• Designed database SQL queries, Stored Procedures, views and triggers.
• Arranged and attended requirements meetings including JAD sessions with various internal customers.
• Provided first level support to business users & executives.
• Worked on Oracle analytical SQL, Procedures and Functions for very complex ad-hoc reporting.

Environment: Clarity (CA tool), Oracle 10g, Actuate, Load Runner

Confidential

Clarity Consultant

Responsibilities:

• Worked on in CA Clarity (Niku), Oracle, Actuate Reporting and performed software analysis, design, development, requirements gathering, analytical decision-making, and project management.
• Extensively worked on support and maintenance projects which involve fixing run time issues.
• Worked extensively with all levels of user groups for requirement gathering, JAD sessions, periodic user and ad-hoc reporting.
• Provided first level support to business users & executives.
• Worked on Oracle analytical SQL, Procedures and Functions for very complex ad-hoc reporting requirements.
• Design and implement CA Clarity objects, sub-objects, processes, database triggers, reports and portlets,
• Setup time slices, data marts and financial matrices.
• Used custom GEL scripts to automate the Product Development and Management (PDM) process in Clarity.
• Designed and implemented SQL/ NSQL real-time reports.
• Expertise in designing and developing Executive Dashboards within Clarity.
• Experience in developing and implementing reporting templates and procedural documentation.
• Design and Develop Technical and End User documents.
• Extensively use XML Open Gate (XOG) to move release changes, enhancements and break-fixes.
• Streamlined the project processes by creating the trackers/Checklists like 'CR tracker', 'Daily Assignment tracker', 'Query Log', 'Risk/Issue Tracker', 'Code Review Checklist‘ and 'Document Review Checklist‘ apart from release documentation and keeping system documentation updated.
• Coordinated efforts for QA, UAT testing.

Confidential

Programmer/Developer

Responsibilities:

• Coding extensively using PL SQL for functions and stored procedures which decide the logic for hp ppm workflow objects.
• Testing, Debugging and bug fixing for enhancements.
• Client interaction from requirement gathering to development and delivery to production. Development of HP-PPM objects like Request Types, Workflows, Portlets and Reports.
• Testing, Debugging and bug fixing

Environment: PL/SQL, HP-PPM Product Suite