SUMMARY

• Expert in handling various BI projects reporting tools && COE(center of Excellence): Actuate Erdpro,BIRT,Jasper, I - Report, (CAPPM Clarity) and Crystal reports
• Overall 13+ plus years of experience in leading all phases of diverse technology projects.
• Experience as a software engineer in developing web based applications using core java advanced java using JSP, Servlets, JavaScript, Angular, Spring Boot, REST, JPA Hibernate,HTML.
• 4 years of experience working in developing Clarity CAPPM Application .
• Experience in working wif Clarity CAPPM, Jasper Report development provided by Confidential Corporation.
• Extensive experience in writing stored procedures, functions, cursors, packages and triggers, using SQL&advanced PL/SQL for various conversion programs.
• Experience in conversion of Actuate Erdpro,BIRT Reports,Crystal Reports,SSRS to Jasper reports.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Sorting teh data
• 3+ years of Developing and Suport and configure wif Jasper Server,Actuate I-Server and Jasper Repors Jobs and PORTLETS using Confidential CLARITY 7.0, 12.x,13, 15x,front end for PPM wif Production.
• Strong Knowledge in Jasper reports,Jasper Server,Scriplets, Phantom JS configurations,Scheduling teh reports.
• Experience into Create and configure and Deploy to teh Portlets and DashBoards,XOG and XML,NSQL into teh Clarity ppm into teh BLOB etc.
• Experienced in creating various Parameterized, Cascaded, Linked, and Drill-through and Drill-Down reports.
• Developed Jaspersoft Dashboards wif Crosstab, Bar Chart, Pie Chart, Table components and enabled Drill Down functionality, Hyperlink etc.
• Developed ComplexJasper Reportsdat consumes SubReportsand exported to various formats such as PDF, EXCEL, and XLXS.
• Well acquainted in SQL sub queries, applying constraints, creating views and indexes.
• Proficient in analyzing client's business process and delivering teh accurate solution to in corporate teh same business logic in software product
• Designed and developed AdhocReports, Claims Processing, Summary & PortfolioReports, KPI's, Inventory, Financial and BillingReportsetc
• Having experience to integrate verified code using Version controlling tools such as GIT, SVN and build tools like Maven.
• Experience in DailyScrum, Sprintplanning, grooming, Demo, retrospective
• Good Experience wif area of Development, Design, Analysis, Functional Studies, Requirement Gathering,Offshore co-ordination, estimation and Project Management

TECHNICAL SKILLS

Reporting tools/Conversion: Actuate Erdpro,Birt,Jasper,SSRS

Java/web Technologies: SpringBoot,Java,JSP,Servlets,Struts,Angular

Database: Oracle/SQL/DB2

Web Services: Soap,REST services

IWMS: TRIRIGA,TRIRIGA wif BIRT

Clarity CAPPM: Clarity wif Jasper Report

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead

Environment: Crystal Reports,Jasper Reports,Oracle, SQL Server, Clarity 15X and Windows XP Professional

Responsibilities:

• Involved in analysis and requirement gathering.
• Worked for Clarity PPM support application as Jasper Report Expert and Application support wif 6 Team Members using Oracle Database.
• Independently handled activities like investigation of issues related to various kinds of Project Management Jasper Reports, Jasper Server related issues and Oracle Procedures.
• Daily Monitoring teh ITSM tickets and assigned related tickets to our own queue for further resolution if needed call wif end user.
• Daily reporting to Project Manager about teh Status of ticket resolution. Our objective was to provide L3 kinds of support and route teh tickets to L2 support team if any change required in system.
• Experience in developing reports such as Standard, Parameterized, Linked, Chart, and Crosstab and Sub-reports using Jasper Reports.
• Create custom data sources using java to connect to different APIs to get data in JSON format and modify them to meet teh report requirement
• Preparation of teh documents after workshops.It involved complex calculations and different layouts combined in a single report using teh subreports.
• Developed queries and complex reports and chart reports.
• Created Parameterized and cross-tab reports wif Oracle queries.
• Involved in API development using REST Services for teh reports. iFrame and Visualize.js
• Schema design, report design, modelling and dashboard creation
• Used Web API and building Restful services.
• Used Hibernate for all CRUD operations.

Confidential, NJ

Responsibilities:

• Involved in Validating teh new build application and testing in much efficient and accurate manner wif proper documentations.
• Worked on Application development and data model on all new changes to teh Crime center portal and fix Jasper Reports moved to development server.
• Developed teh Jasper Reports for teh new reports and embedded teh reports to applications. supporting teh production deployment of Jasper Reports, Dashboards.
• Developed front end screens html,jsp using AngularJS and backend technologies using Servlets.

Confidential, NJ

Responsibilities:

• Understood various methods,BAS files,Libraries and implemented overriding on Create,onrender,Before.
• Converted teh existing EZPASS, TOLLPLAZA,GSP,Turnpike related Actuate reports, BIRT reports to Jasper Reports.
• Created tables, SQL queries, joins, integrity constraints and views for multiple databases, using SQL Developer.
• Helped converting Actuate reports to BIRT Reports, wif development of Angular Js-Java framework, which processes UI inputs according to business and generates query dynamically for report execution wif teh processed parameters.
• Performed Queued Long Running BIRT Reports to improve teh performance of BIRT Reports.
• Created Parameterized and cross-tab BIRT reports wif queries.

Confidential, NY

Jasper Report Developer

Environemnt: JAVA, J2EE, Angular JS, HTML,CSS, REST Web services, Spring Boot, Oracle,Maven build tool

Responsibilities:

• Involved in design of Angular pages to display Forms.
• Created and assisted users in dashboard development
• Defined best practices for Jasper reports development. iFrame and Visualize.js
• Converted existing crystal Reports, Business Object Reports to Jasper Reports.
• Worked on complex queries needed for Reporting in Oracle and Teradata.
• Involved in writing SQL queries for accessing backend.
• Worked in developing Spring Boot, Rest Template related backend services.
• Generate teh jasper Reports
• Create custom data sources using java to connect to different APIs to get data in JSON format and modify them to meet teh report requirement.
• Develop new jasper report parameter screens using JAVA and angular JS to provide UI for teh jasper reports and deploy them in teh framework.
• Involved in API development using REST Services for teh reports.
• Created objects, object views, lookups, processes, and portlets to implement changes defined in teh functional design.
• Created specs and developed teh custom reports inJasper Reports
• Developed executive dashboards to display teh financial information. Dashboards show teh financials at project level, program level, application level and department level.
• Developed multiple portlets to show teh information in a format more useful to end users
• Fine tuned teh portlet queries to show teh data
• Testing and deployment of completed reports on to teh Jasper Server.

Confidential, ATLANA

Responsibilities:

• Experience in developing reports such as Standard, Parameterized, Linked, Chart, and Crosstab and Sub-reports using BIRT Reports.
• Overridden various methods to call dynamically query at run time using on before factory, on prepare, open, Initialize, on Create, On Render, On-Fetch methods in BIRT
• Involved in creating UI pages using JavaScript and Angular JS and JSP, CSS, HTML.
• Involved in Writing a JSP, Java etc for Modification of a Partial pages to teh specific Groups.
• Good Knowledge on Scheduling Reports in I-SERVER.
• Created Parameterized and cross-tab BIRT reports wif TRIRIGA queries
• Participated in Daily Catch up call

Confidential, SFO

Responsibilities:

• Interpret functional specifications, create technical specifications and has teh ability to deliver quality code to specification.
• Teh report Development in Method of teh Production, Report Templates wif Confidential Libraries.
• Create and configure teh PORTLETS, DASHBOARDS.
• Designing Graphs and implementing Drill downs and Sub reports, Crosstab Functionality.
• Understand teh functionality of Actuate Erdpro reports replicate teh same in Jaspersoft.
• Developed Jaspersoft I-Reports wif Crosstab, Bar Chart, Pie Chart, Table components and enabled Drill Down functionality, Hyperlink etc.
• Verifying look and feel of teh report and portlet.
• Experience in developing Portlets like Drill down, Hierarchical portlets, Interactive portlets (Dashboards).
• Created specs and developed teh custom reports in Jasper Reports.
• Worked on GEL scripts to customize teh clarity as per teh business rules
• Worked on creation of various Portlets and Portlet Pages
• Creation of Adhoc,Dashboards,Jasper reports and publish teh templates in JasperServer. development and support using Java scripts, JSP/Servlets for client side validations.
• Prepared complex SQL Queries, PL/SQL packages for data retrieval.
• Involved in all phases starting from Requirement Analysis, Design, Coding
• Created and modified PL/SQL procedures, packages, functions, tables, views, materialized views, sequence, nested tables, collections, rebuilding indexes and triggers using PL/SQL in SQL Developer and TOAD environments..

Confidential

Clarity Jasper Report Developer

Responsibilities:

• Interpret functional specifications, create technical specifications and has teh ability to deliver quality code to specification.
• Teh report Development in Method of teh Production, Report Templates wif Confidential Libraries.
• Create and configure teh PORTLETS, DASHBOARDS.
• Provide teh range of Input Parameters Conditionally in teh 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 Rowto get teh right functionality.
• Tune report SQL’s and report design’s for optimum performance
• Teh report Development in Method of teh Production, Report Templates wif Confidential Libraries.

Confidential

Responsibilities:

• Involved in teh gathering of business requirements and translating them to teh report
• Extensively used Cursors, Ref Cursors, data types and Collections in packages and procedures
• Interact wif business users and gather functional requirements.
• Convert teh existing actuate eRDpro Reports to Ireport Designer
• Developing new Reports using eRDPro (Actuate e reporting tool) / enhancing existing reports to conversion to jasper reports as per requirement.
• Implementation of Scriplet for teh common functionalities..
• Worked wif JavaBeans, DAO and services.
• Designed JSP s as per teh requirement
• Developed Jaspersoft Reports wif Crosstab, Bar Chart, Pie Chart, Table components and enabled Drill Down functionality, Hyperlink etc.
• Developed Complex Jasper Reports dat consumes Sub Reports and exported to various formats such as PDF, EXCEL, and XLXS using Jasper Excel Export Properties

Confidential

Responsibilities:

• Generated Complex reports, which takes information from different data source.
• Write java code for running teh actuate reports using IDAPI (information Delivery API) calls provided by Actuate.
• Overridden various methods like On Read, Fetch, Start, Obtain Select and On Rowto get teh right functionality.
• Designed JSP s as per teh requirement
• Written Service Interfaces and their implementations.
• Analyze and implement user interfaces using Struts frameworks
• Performing teh server side validations by using validation rules
• Involved in teh coding to persist data spring JDBC

Confidential

Responsibilities:

• Involved in development of Java Classes, Servlets and JSPs using Portal
• Working on Servlets, JSP, Struts, JDBC and Java script under MVC Architecture
• Developing of PL/SQL packages, stored procedures and function
• Designed Libraries and Report Templates which is used by other reports
• Overridden various methods like On Read, Fetch, Start, Obtain Select and On Rowto get teh right functionality.
• Used Multiple Input Filters, Page Level Security, Memory data sorter, Nested Reports, Sequential / Parallel Section, Use of Actuate Foundation Classes, Sub classing and customizing Frames and Data Controls
• Created configuration files to include teh libraries ROL in teh Actuate reports.
• Created users, roles and given privileges and maintaining teh report executables using Actuate Management Console