SUMMARY

• 6+ years of related experience in IT or equivalent experience.
• 4 years of experience in CA Clarity PPM in Confidential Software Solutions.
• 2+ years of experience in developing Jaspersoft Reports and CA PPM Developer in Confidential
• 4+ years of experience on Oracle database
• 2+ years of experience on SQL Server, SSIS, SSRS.
• Worked on Clarity integrations for extracting data from different team and load data to have complex, data - intensive reports
• Experience in Design, Development and Implementation for Clarity versions 12.0, 12.1,13.x and 14.x
• Expertise in analyzing requirement and implementing best solutions to the customers.
• Good Knowledge of Clarity Project Management, Portfolio Management, Resource Management, Process Management, Financial Management, Studio, Reporting and Security in Clarity.
• Experience in development and implementation of enterprise applications such as Clarity PPM with partitions, Business Objects.
• Experienced in working with ServiceNow tickets with Clarity.
• Worked on DBA to configure ETL data link in Clarity.
• Scheduled reports in BO (Business Objects) to be delivered automatically.
• Good at analyzing data, developing, Unit testing and deploying to the production environment after the user approval and report design documentation.
• Experience in Customization of Clarity using Clarity Studio, Oracle, NSQL, and XOG.
• Experience in Using GEL Script for Clarity Workflows.
• Worked with BO Universe and CMC Administration.
• Experienced in converting Actuate to Crystal reports.
• Experienced in converting Crystal reports to Jasper reports.
• Strong report writing experience along with designing & development in tools such as Crystal Reports, Tableau, Jasper and others
• Scheduled Jasper reports in Clarity.
• Descent knowledge on Power BI and Qlikview reports (Intermediate).

TECHNICAL SKILLS

Languages: C, C++, Java, JavaScript

Web Technologies: HTML, DHTML, XML, CSS.

Databases: MS SQL Server 2000, MySQL, PL/SQL Developer

Product Tools: PPM (Project Portfolio Management), CAPA - CA Productivity Accelerator.

Reporting Tools: SSRS, SSIS, Actuate designer, Crystal Reports XI R2, 2008, Jasper Reporting, Tableau.

Tool: Related: GEL Script, XML Open Gateway (XOG).

PROFESSIONAL EXPERIENCE

Confidential

CA PPM Clarity Report Developer

Responsibilities:

• Convert Existing Crystal reports in Jasper.
• Develop new Jasper reports.
• Worked on developing Jasper Audit Data for reports in Jasper server.
• Writing SQL server code following organization SQL standards for a report requirement.
• Optimize and rewrite SQL code for existing Crystal report queries.
• Merge and convert Crystal reports into Jasper that are showcasing identical data.
• Created SSIS package for different Business Units for accessing Clarity Database.
• Look into the ServiceNow tickets for new report enhancements from users.
• Worked on ServiceNow Integration to Clarity.
• Worked on Contractor Extension Integration from ServiceNow to Clarity.
• Developed automated emails
• Worked on custom objects and related processes on bringing data from Ideas to Projects and sub-objects.
• Automated emails to Managers from Clarity on the Project status.
• Worked on Project custom object to track the project status for BA Team.
• Worked on Idea enhancements for Intake & Unified Intake teams who work together in Idea level with different perspectives.
• Contact users for the requirements to finalize BRD.
• Created Folders in Advance reporting and provide the security level for all the users dependent on the report data or Business unit.
• Provided Security on Role or User level.
• Provide access to new users and their team members for Advance reporting.
• Provide Support and break fixes the existing crystal report.
• Create objects, Sub - objects and attributes for new Clarity Users.
• Worked on the enhancements received from ServiceNow requests.
• Worked on Creation of Development guidelines for Jasper report development and ServiceNow enhancements.
• Pre-work for Clarity upgrade from V 14.3 - V 15.5
• Developed Tableau reports with Data ware house (DWH) schema in Clarity.
• Created documentation on Tableau and Data ware House ERD.

Confidential

CA Clarity PPM Consultant

Responsibilities:

• Maintained the users/clients request from website to Clarity for installing packages.
• Developed processes to bring User request data from web to clarity
• Develop and modify SQL queries to provide data to different Versions.
• Develop and maintain PLSQL objects.
• Interface to integrate workday application to get resource information into the system and manage them.
• Created custom time sheet module (Objects, Processes) as per the requirements and then move the approved timesheet back to OOTB timesheets
• Modify Clarity objects as per requirement and developed portlet’s.
• Created and updated Financial Transactions as per the changes happened to the resource’s that occurs through Workday. (i.e. If a resource department got changed/updated we move all transactions to new department and negated the old ones)
• Perform Unit testing, end to end testing of every Change request raised.
• Interacting with the client on daily basis to provide the status, re-solution and entertain queries.

Confidential

CA Clarity PPM consultant and Support Tech Lead

Responsibilities:

• Maintained the users/clients request from website to Clarity for installing packages.
• Developed processes to bring User request data from web to clarity
• Develop and modify SQL queries to provide data to different Versions.
• Develop and maintain PLSQL objects.
• Modify Clarity objects as per requirement and develop portlet’s.
• Perform Unit testing, end to end testing of every Change request raised.
• Interacting with the client on weekly basis to provide the status, re-solution and entertain queries.
• Resolving different Level 2 support tickets raised by users.

Confidential

CA PPM Technical consultant

Responsibilities:

• Analyze the technical requirements to validate.
• Developed OOTB Process related Hierarchical NSQL query & portlet’s.
• Developed Access Rights portlet granted through Objects.
• Involved in moving portlet’s and Lookups from one environment to another.
• Unit and Functionality testing of the Components
• Custom Object and Lookup creations using studio as per the specifications.
• Interaction with client and business users, and mentoring team members
• Customization of Clarity as per the business needs using Clarity Studio, Objects, Security Groups and OBSs, Custom Objects, Creating Attributes, lookups, NSQL, Queries, Portlet, Portlet Pages.