We provide IT Staff Augmentation Services!

Ca Ppm Clarity Report Developer Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • 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.

We'd love your feedback!