SUMMARY:

• Overall 11+ years of Total Experience in extensive IT Industry
• Strong Skills with Actuate e - Report Designer Professional, Actuate e-Spreadsheet and Actuate i-Server, Actuate BIRT, Eclipse BIRT, Crystal Reports, Actuate Analytics, Jasper Reports, Oracle SQL, PL/SQL JSP, Struts, Java, Web-Services
• 3+ years of experience in Clarity CA-PPM implementation Clarity PPM 8.x,10.x, 13.x versions
• Expertise in developing applications using WebServices (SOAP,RESTFUL), Core Java, JDBC, Servlets, JSP, HTML, Java Scripts and develop Jasper Reports, Birt, e.Reports.
• Creation and customizations of Portlets, Portlet Pages, N-SQL Queries, Objects, Reports and Jobs creation & scheduling.
• Possess very good Functional knowledge in various modules of CA PPM - Studio, Project Management, Resource Management, Timesheet Management and Financial Management.
• Experience in writing queries using Oracle, MYSQL and worked on Data Extracts.
• Experience in developing Portlets like Drill down, Hierarchical portlets, Interactive portlets (Dashboards).
• Experienced on Report conversions (Actuate to Crystal) and (Actuate to Jasper).
• Experience in using GEL Script for implementing business workflows in CA Clarity
• Experience in using XOG for Data Migration and Configurations.
• Experience in using Clarity Studio for configuration and development
• Experience in working with Time Management modules
• Good Knowledge of HTML/CSS, Java script.
• In depth knowledge in Data Administration, Implementation and Customization of Clarity using Clarity Studio, Oracle, NSQL, and XOG.
• Responsible for all Jasper static reports, domains, and Ad Hoc Views.
• Involved in configuring, deploying applications using Apache Tomcat on Windows platforms.
• Hands on experience in design, development and implementation of applications on Client/server environment using Cognos 8.X, Framework Manager, Query Studio, Report Studio, Analysis studio
• Expertise in Actuate Reporting to develop and manage the actuate reports, installation and Encyc volume backup.
• Extensive hands on experience in developing Data Warehousing/BI applications using BI tool
• Designed and developed Sub reports, Drill Down reports, Dashboard using Jasper
• Proficient in writing SQL queries, Cursors, Sub programs like Procedures, Functions, Packages and Triggers in PL/SQL blocks and Performance Tuning.
• Strong experience with XML, XSL, XSLT, XPATH.
• Ability to learn new technologies quickly

TECHNICAL SKILLS:

Languages: Java 1.5/1.6/1.7, Actuate Basic Code, PL/SQL

Java Technologies: JSP, Servlets, Struts, Spring MVC, JSTL, Restful Web Services, Soap UI

Operating System: Windows Family XP, 2010, 7

ORM: Hibernate

Application Server: Tomcat,IDE Eclipse

RDBMS: Oracle 9i/10g, My SQL, SQL Server 2014, DB2, Sybase

XML: SAX, DOM, XSD

Building Tools: Ant, Maven

Reporting Tools: Actuate e.Report Designer,BIRT,Jasper,Cognos,MicroStrategy

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

Jasper & Actuate Report Consultant

• Worked on GEL scripts to customize the clarity as per the business rules
• Worked on creation of various Portlets and Portlet Pages
• Generated Complex reports, which takes information from different data source.
• Created objects, object views, lookups, processes, and portlets to implement changes defined in the functional design.
• Created specs and developed the custom reports in Jasper Reports
• Developed executive dashboards to display the financial information. Dashboards show the financials at project level, program level, application level and department level.
• Conversion of Actuate reports to Jasper reports
• Overridden various methods like On Read, Fetch, Start, Obtain Select and On Row to get the right functionality.
• Have strong skills in Clarity Admin Configuration, implementing customized process / workflow, NSQL, GEL Script, XOG,Studio Configuration
• Configure Charge Codes and Input Type codes for identifying Capital and Expense projects
• Configure financial module in Clarity.
• Developed Data Extracts
• Integration / XML Open Gateway - Design interface using XOG and GEL Script for external system

Jasper Report Consultant/Architect

Confidential, NY

• Implemented GUI screens using JSP, Servlets, Core Java, J2EE, JDBC
• Responsible for coding the logic in servers to pass the information from frontend to backend.
• Granting specific privileges and roles to the users.
• Responsible for Designing the Different jasper reports using multiple I-Report components like Crosstabs, sub reports, Frames, Groups and Bands..
• Perform Report query transformation queries on the staging data and publish to Hbase and hive.
• Experience in developing reports such as Standard, Parameterized, Linked, Chart, and Crosstab and Sub-reports using Jasper Reports.
• Generate PDFs for the reports like Pie-Chart, Bar-Chart, etc.
• Created Single Select & Multi Select parameters in Jasper Server and assigned to the target reports.
• Worked on multiple Projects for Jasper reports.
• Rewrite the existing queries to perform better using analytic functions
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables to other teams and to eliminate the complexity of the large queries.
• Organized the releases based on the business priorities, estimates, and timelines set for the release. And also coordinated efforts for QA, UAT testing.

Confidential,ATLANTA,GA

TRIRIGA BIRT Report Developer

• Responsible for implementing Rest web services.
• Report development using studio Report Designer Professional
• Implemented cascading parameter, joins, cross tab reports
• Prepared complex SQL Queries, PL/SQL packages for data retrieval.
• Developed Stored Procedures, Packages, and Functions using PL/SQL to implement day to day modified business rules into the current system.
• Responsible for Designing the BIRT Reports
• Provide the range of Input Parameters Conditionally in the Obtain Select Statement Method
• Tuned Several Complex SQL Queries - improved performance, by reducing time between 50% up to 5%.
• Used Multiple Input Filters, Memory data sorter, Nested Reports, Sequential / Parallel Section, Use of Actuate Foundation Classes, Sub classing and customizing Frames and Data Controls
• Provide the range of Input Parameters Conditionally in the Obtain Select Statement Method
• Generated Complex reports, which takes information from different data source.
• Overridden various methods like On Read, Fetch, Start, Obtain Select and On Row to get the right functionality.

Confidential

JAVA & Jasper Report Developer

• Implemented the project using the Spring MVC framework.
• Built prototype of jasper reports, actuate e.spreadsheet reports using IRD tool with scripted Charts and Graphs for highly complex reports.
• Developed the configuration files and the class’s specific to the spring and hibernate.
• Created Dynamic Web Pages using JSP, CSS, and JQuery. Developing dynamic menu using XSLT which will run on XMLs in order to transform to required form.
• Implemented configured those JRXML objects in springconfigurationfile.
• Developed Web Service client to consume the Web Service.
• Converted the actuate reports to jasper reports which Uses components Multiple Input Filters, Memory data sorter, Nested Reports, Sequential / Parallel Section, Use of Actuate Foundation Classes, Sub classing and customizing Frames and Data Controls
• Analyzing the requirements assigned by client.
• Migration of Actuate Reports to Jasper Reports.
• Experience in developing reports such as Standard, Parameterized, Linked, Chart, and Crosstab and Sub-reports using Jasper Reports.
• Implemented GUI screens using JSP, Servlets, Core Java, J2EE, JDBC
• Responsible for coding the logic in servers to pass the information from frontend to backend.
• Granting specific privileges and roles to the users.
• Responsible for Designing the Different jasper reports using multiple I-Report components like Crosstabs, sub reports, Frames, Groups and Bands.
• Handled SQL tuning and assisted developers with coding on PL/SQL

Report Developer

Confidential

• Communicating with different users across globe and ensure the right level of service has been delivered.
• Resolution for the Financial Calls and Assigning with jasper report.
• The project also does some legacy data migration from the Niku to the clarity system.
• Creation of custom objects, attributes, lookups, sections, links, subpages.
• Worked on GEL scripts to customize the clarity as per the business rules
• Worked on creation of various Portlets and Portlet Pages
• Jasper Reports development.
• Developing Adhoc and Standard reports using reporting.
• Conversion of Actuate reports to Jasper Reports.
• The report Development in Method of the QA,UAT,PROD instructions on Report Templates with NIKU Libraries.
• Have strong skills in Clarity Admin Configuration, implementing customized process / workflow, NSQL, GEL Script, XOG,Studio Configuration
• Configure and create custom Portlet / Queries/ Portlet Pages / Project Dashboards / User Dashboards
• Design and develop multiple Grid, Hierarchy, Grape and HTML Portlets.
• Design and develop Portlet Pages for Project, Idea and Portfolio object
• Integration / XML Open Gateway - Design interface using XOG and GEL Script for external system

Confidential,New York

Actuate&& Jasper Report Developer

• Used Multiple Input Filters, Memory data sorter, Nested Reports, Sequential / Parallel Section, Use of Actuate Foundation Classes, Sub classing and customizing Frames and Data Controls
• Performing complex technical assignments independently, as well as, in large team settings.
• Interactions with Rest and SOAP calls.
• Designing and developing JSP pages to provide user interface.
• Unit Testing against the test cases.
• Used soapUI for load testing the Web Services.
• Developing of PL/SQL packages, stored procedures and function
• Worked on page designing using HTML, Skins, Themes and CSS.
• Involved in coding using Java, Jsp, Servlets & JavaScript
• Involved in the gathering of business requirements and translating them to the report
• Responsible for Designing the Different jasper reports using multiple i-Report components like Crosstabs, sub reports, Frames, Groups and Bands.
• Implementing CSS Style Sheet and Templates to make use one style for multiple Reports.
• Responsible for coding the logic in servers to pass the information from frontend to backend.
• As a Programmer/Analyst was involved in analysis and requirement gathering.
• Developed SQL queries and stored procedures
• Create new Input Controls, Drop down lists, resource bundles on the Jasper Server.
• Create new Users, Roles and manage Jasper Server Repository.
• Created Single Select & Multi Select parameters in Jasper Server and assigned to the target reports.

Confidential, Phoenix

Java & Actuate Report Developer

• Responsible for implementing Rest web services.
• Report development using studio Report Designer Professional
• Understand each of the actuate project using different databases and develop a strategy for up-gradation.
• Manage the Actuate Hub Server to balance the load with different setting as per the need and maintain security.
• Execute the test plan for each of the projects and fix the bugs involved as analyst.
• Communicate and coordinate with all the developers across different projects and analyze different requirements.
• Contact Actuate Support Team and get the fix for some of the components.
• Customize the portals of the applications according the need like running a report as background job but to show the report like immediate report.
• Write java code for running the actuate reports using IDAPI (information Delivery API) calls provided by Actuate.
• Migrating Cognos reports to ACTUATE e.Reports
• Implemented cascading parameter, joins, cross tab reports
• Prepared complex SQL Queries, PL/SQL packages for data retrieval.
• Using parameter functionality, created sub reports / drilled reports per customer need.
• Conversion of Adhoc reports Query studio to Actuate reports
• Conversion of cognos list reports, cross tab reports and chart reports to Actuate e.Reports.
• Involved in understanding of complex reports with the functionalities like prompts, Conditional layouts, Conditional blocks, Conditional variable, Drill through, Render variables, Master-detail
• Worked on writing the test cases for the reports

Confidential

Java Developer Role: Report Developer

• Involved in development of Java Classes, Servlets and JSPs using Portal
• Working on Servlets, JSP, Struts, JDBC and Java script under MVC Architecture
• Provide the range of Input Parameters Conditionally in the Obtain Select Statement Method
• Tuned Several Complex SQL Queries - improved performance, by reducing time between 50% up to 5%.
• Used Multiple Input Filters, Memory data sorter, Nested Reports, Sequential / Parallel Section, Use of Actuate Foundation Classes, Sub classing and customizing Frames and Data Controls
• Provide the range of Input Parameters Conditionally in the Obtain Select Statement Method
• Generated Complex reports, which takes information from different data source.
• Overridden various methods like On Read, Fetch, Start, Obtain Select and On Row to get the right functionality.

Confidential

Clarity& Report Developer

• Interpret functional specifications, create technical specifications and have the ability to deliver quality code to specification.
• The report Development in Method of the Production, Report Templates with NIKU Libraries.
• Create and configure the PORTLETS, DASHBOARDS.
• Provide the range of Input Parameters Conditionally in the Obtain Select Statement Method
• Used Multiple Input Filters, Memory data sorter, Nested Reports, Sequential / Parallel Section, Use of Actuate Foundation Classes, Sub classing and customizing Frames and Data Controls
• Provide the range of Input Parameters Conditionally in the Obtain Select Statement Method
• Generated Complex reports, which takes information from different data source.
• Overridden various methods like On Read, Fetch, Start, Obtain Select and On Row to get the right functionality.
• Tune report SQL’s and report design’s for optimum performance
• Develop XOG templates for loading projects into the application.
• Worked on GEL scripts to customize the clarity as per the business rules
• Worked on creation of various Portlets and Portlet Pages
• Migrate reports from Crystal Reports 2008 To Actuate Reports