SUMMARY:

• Over 11 years of experience in Java/J2EE and Open Source Business Intelligence (Report) Developer (TRIRIGA, BIRT, iReport,Jasper Studio, Actuate Reports and Business Intelligence & Reporting tools such as Actuate Erdpro, Birt, Crystal Reports, and Jasper Reports 6.0).
• Over 4 years of Technical Lead experience leading the multiple projects.
• 2+ years of experience in Clarity CA - PPM implementation Clarity PPM 10.x, 13.x versions
• Expertise in developing applications using Web Services (SOAP, RESTFUL), Core Java, JDBC, Servlets, JSP, HTML, Java Scripts and develop Jasper Reports, Birt, e.Reports.
• Responsible for all Jasper static reports, domains, and Ad Hoc Views.
• IBM TRIRIGA Application Developer with 1 year 10 months of professional experience.
• Expertise includes configuring, testing, implementing, and documenting TRIRIGA Applications.
• Extensive hands on experience in developing Data Warehousing/BI applications using BI tool Actuate 8, Actuate/ Open Text 10/BIRT.
• Significant experience in managing complex requirements and working with development team (on-site and offshore) to configure and implement different TRIRIGA Applications as per project tasks as required. Basic knowledge in designing and developing Crystal/BIRT report and Data Migration
• Expertise in developing the complex reports using jasper reports/ Dash Boards.
• Involved in configuring, deploying applications using Apache Tomcat on Windows platforms.
• Experienced in developing web applications and interactive software products using JSP, Servlets, JavaScript, Angular JS, HTML 5, CSS, AJAX, JSON, Core Java, J2EE, and JDBC.
• Have worked in development, integration and configuration of Jasper reports, BIRT Reports on client portal by using RESTFUL calls
• Design, develop and deploy user friendly and rich looking Financial and Billing reports using Oracle PL/SQL, Analytic Functions, SQL, and I-Report and deployed onto Jasper Server.
• Experience in identifying performance issues, debugging and performance tuning.
• Designed and developed Sub reports, Drill Down reports, Dashboard using Jasper
• Experience on Oracle, SQL and PL/SQL, MongoDB, Sybase, MySQL,H2DB
• Proficient in writing SQL queries, Cursors, Sub programs like Procedures, Functions, Packages and Triggers in PL/SQL blocks and Performance Tuning.
• Performance tuning which includes rebuilding indexes, analyze tables, partitions.
• Well acquainted in SQL sub queries, applying constraints, creating views and indexes.
• Proficient in analyzing client's business process and delivering the accurate solution to in corporate the same business logic in software product.
• Very Good Knowledge in developing & customizing the product using Oracle PL/SQL Programming as per requirement analysis.
• Good Experience with area of Development, Design, Analysis, Functional Studies, Requirement Gathering, Offshore co-ordination, estimation and Project Management.
• Ability to learn new technologies quickly

TECHNICAL SKILLS:

Reporting Tools: Jasper,Microstrategy,BIRT,SSRS,Tableau,ErdPro

Scripting Language: JavaScript, Angular JS

Programming Languages: Java, JSP, Servlet, Unix Shell Script, Actuate Basic Code, Angular JS

Procedural Languages: SQL.PL/SQL

Special Technologies: REST ServicesDatabases: Oracle8.0/9i, DB2, Sybase, SQL Server

Application Server: Tomcat 5,7

SCM Tools: MS Visual SourceSafe, Win CVS, Clear Case, SVN

Operating System: WINDOWS 2000, Windows XP, Unix

PROFESSIONAL EXPERIENCE:

BIRT && Jasper Report Consultant

Confidential,Weehawken,NJ

Software Used: Jasper Studio, TOAD, Hive, SQL, Birt, WebServices,Java,Spring

• 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 and developed the custom reports in BIRT Reports
• Experience in developing reports such as Standard, Parameterized, Linked, Chart, and Crosstab and Sub-reports using Jasper Reports.
• Developed executive dashboards to display the financial information. Dashboards show the financials at project level, program level, application level and department level.
• Communicating with client in various phases while developing the report.
• Developed Jasper reports from scratch.
• Developed SQL Queries for creating Reports and Portlets.
• Developed Gel Scripts for Workflows.
• Wrote stored procedures and complex SQL query, pertaining to the report development.
• Organized the releases based on the business priorities, estimates, and timelines set for the release. And
• Provides leadership and work guidance to less experienced personnel.
• Self-learning of UX platform
• Ensure that everyone within PPC MI team is familiar with JIRA and is using it to track defects

BIRT && Jasper Architect

Confidential,NEWYORK,NY

Software Used:Jasper Studio, TOAD, Hive, SQL, Birt, WebServices,Java,Spring,PEga,HTML,CSS

• 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.
• Experience in AWS Cloud platform and its features which includes EC2, AMI, EBS, AWS SQS and AWS S3.
• 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.
• Handled SQL tuning and assisted developers with coding on PL/SQL
• Supporting with deployment team to accomplish the production deployment.
• Creating Cascading, Multi-select Parameter and Static and Dynamic Filter.
• Implementing Join dataset and Union dataset, Data cube with cross tab.
• Development of tabular reports Using BIRT.
• Creation of dashboards using HTML5 charts and tabular data in i-Portal
• Calling of reports from java application using JSAPI and standalone links.
• Used JSP Tag Libraries (JSTL) to implement the logic inside the JSPs.
• 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.
• Designed new tables to integrate with the existing schemas and created constraints, indexes, sequences and synonyms.
• Created specs and developed the custom reports in BIRT, Jasper Reports

PL SQL && TRIRIGA BIRT Report Developer

Confidential,ATLANTA,GA

Technologies: Java, JSF, JSP/Servlets, HTML/CSS, JavaScript, CSS,Oracle,BIRT,TRIRIGA Web services, Maven, SVN,Oracle,SQl,PL/SQL,Vertica Hp,Jasper

• 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
• Designing Workflows, reports and query in TRIRIGA, designing Form.
• Implemented GUI pages using AngularJS, HTML5, BOOTSTRAP, and CSS.
• Responsible for coding the logic in servers to pass the information from frontend to backend.
• Developed Java code for enhancing features.
• Unit testing using JUnit

JAVA&&Jasper Report Developer

Confidential

Technologies: Java, JSF, JSP/Servlets, HTML/CSS, JavaScript, CSS,Oracle,Pega,Jasper Studio, Web services, Maven, SVN,Oracle,SQl,PL/SQL,Actuate E.Spread Sheet,Jasper,IRD

• 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.
• Developing jasper reports consisting of following features:
• Report creation using sub report functionality.
• Creation of chart report with dynamic color changing functionality using Scriplet.
• Formatting of value expression using Scriplet etc.
• Experience in developing reports such as Standard, Parameterized, Linked, Chart, and Crosstab and Sub-reports using Jasper Reports.

BIRT Report Developer

Confidential

• As a Programmer/Analyst was involved in analysis and requirement gathering.
• Used JAVA, JSP, JavaScript to develop presentation layer using MVC architecture.
• Experience in developing reports such as Standard, Parameterized, Linked, Chart, and Crosstab and Sub-reports using BIRT Reports.
• Developing Adhoc and Standard reports using Birt reporting.
• 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
• Did Presentation-tier development and support using Java scripts, JSP/Servlets for client side validations.
• Writing and invoking the struts calls.
• Parsed JSON data and displayed it in the front end screens using JQuery.
• Responsible for creating BIRT common Library objects
• Developed complex reports using BIRT reporting tool, enabling client to view consolidated data in one integrated report.
• Provided application consulting on different TRIRIGA modules such as Operations and Maintenance, Real Estate Lease and Project Management, helping client fully leverage product.
• Work with business to develop requirements for BIRT Report design
• Developing new BIRT Reports. Create reports with scripted Charts and Graphs.

Technologies: Java, JSF, JSP/Servlets, HTML/CSS, JavaScript, CSS,Oracle, Web services, Maven, SVN,Oracle,SQl,PL/SQL,BIRT, TRIRIGA

Confidential,Chicago,IL

Java Developer

• Involved in SDLC Requirements gathering, Analysis, Design, Development and Testing of application
• Providing best design when the Crystal report design can be achieved with Jasper tool.
• Testing of the report for all the scenarios.
• Developed Gel Scripts for Workflows.
• Preparation of unit test cases, exceptions, User guide and deployment documents.
• Deploying reports in dev and test environments.
• Developed SQL Queries for creating Reports.
• Overridden various methods to call dynamically query at run time using on before factory, on prepare, open, Initialize, on Create, On Render, On create, On-Fetch methods in BIRT
• Developing conditional reporting with different styles. Extensively worked on chart interactivity.
• POCs for developing Actuate BIRT reports:
• Export button in report for different outputs.
• Dynamic setting of data value to legends.
• Vertical alignment of a text in a control.
• Displaying only a single point of a series in chart etc.
• Developing new BIRT Reports. Create reports with scripted Charts and Graphs.
• Involved in design of JSP pages to display Forms.
• Coding implementations of Data storage and Retrieval.
• Wrote SQL stored procedures, used JDBC to connect to database.
• Involved in developing various Servlets.
• Tested and validated the application on different testing environments.

Environment: Java (JDK 1.2), Core Java/J2EE, Servlets, Struts, Hibernate, Oracle, PL/SQL, JDBC, Apache Tomcat, Windows,Actuate Erdpro reports.

Confidential,New York

Report Developer

• Involved in the requirements gathering and reviewing the SRS and HLD and LLD’s.
• Analyze, design, and develop technical solutions based upon user specifications.
• Performing complex technical assignments independently, as well as, in large team settings.
• Interactions with Rest and SOAP calls.
• Used Web services - WSDL and SOAP for testing.
• Used soapUI for load testing the Web Services. developed using AGILE methodology.
• Developing of PL/SQL packages, stored procedures and function
• Worked on page designing using HTML, Skins, Themes and CSS.
• Extensively worked on Oracle SQL and PL/SQL procedures and packages to improve the performance
• 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.
• Creation of chart report with dynamic color changing functionality using Scriplet.
• Formatting of value expression using Scriplet etc.

Environment: Struts 1.3, JSP, Servlets,, XML, Web Services, Java Script, Tomcat, Java Mail API, Filezilla, CSS,Oracle, Jasper Studio, Web services, Maven, SVN,Oracle,SQl,PL/SQL,Actuate Erdpro,BIRT, SSRS 2012, SSIS, SQL Reports

Confidential

Java&&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.
• Using parameter functionality, created sub reports / drilled reports per customer need.
• Used web-service, SQL and POJO class as data source for the BIRT reporting
• Creating Cascading, Multi-select Parameter and Static and Dynamic Filter.
• Implementing CSS Style Sheet and Templates to make use one style for multiple Reports.
• Implemented Join dataset and Union dataset, Data cube with cross tab
• 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.
• Used JAVA, JSP, JavaScript to develop presentation layer using MVC architecture.
• Experience in developing reports such as Standard, Parameterized, Linked, Chart, and Crosstab and Sub-reports using Jasper Reports.
• Did Presentation-tier development and support using Java scripts, JSP/Servlets for client side validations.
• 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.
• Implementing Join dataset and Union dataset, Data cube with cross tab.
• Development of tabular reports using BIRT.
• Creation of dashboards using HTML5 charts and tabular data in iPortal
• Calling of reports from java application using JSAPI and standalone links.

Environment: Struts 1.3, JSP, Servlets,, XML, Web Services, Java Script, Tomcat, Java Mail API, Filezilla, CSS,Oracle, Jasper Studio, Web services, Maven, SVN,Oracle,SQl,PL/SQL,Actuate Erdpro,BIRT, SSRS 2012, SSIS, SQL Reports,