SUMMARY:

• Having 10 years of excellent experience on Business Intelligence tools like Jasper reports, Jasper Server, Jasper Business Intelligence, Pentaho, Tableau, Splunk, Actuate e Report and Actuate BIRT reports. Got trained from Jaspersoft.
• Very quick learner and passionate about reporting and visualizations using latest technologies that fits.
• Splunk Certified Power User.
• Excellent experience in developing and migrating Jasper reports from BIRT, Actuate e reports, Oracle Reports and crystal reports.
• Excellent Experience in handling Jasper Server including implementation Single Sign On, User Management, adhoc Reports, Views, topics, Domains, tables and crosstabs etc..
• Excellent Experience in creating very complex reports and dashboards using Jaspersoft studio and server using third party tools like D3 charts, High charts, HTML charts, Fusion charts and widgets, vectors.
• Excellent knowledge in writing scriptlet for custom functionality.
• Integrated jasper reports to CA Agile (Rally software), Confluence. Knowledge on CA PPM Jaspersoft and its domains.
• Good Experience in requirement gathering, analysis, design and embed Jasper Reports on a web application using Visualize.js and Iframe.
• Excellent in writing complex queries and stored procedures in MySQL, ORACLE, Postgress and SQLServer.
• Experienced in converting Complex Actuate e Reports to Jasper Reports.
• Experienced in internationalization, virtualization and pagination of Jasper reports
• Experienced in creating sub - reports, drilldown reports, dynamic sorting, dynamic table, cross tables, charts, datasets, barcodes and EXCEL, PDF, HTML outputs of jasper reports with iReport and Jaspersoft studio.
• Experienced in creating stylesheets, various charts, Table of Contents and scriptlet for jasper reports.
• Strong experience in interacting with stakeholders/customers, gathering requirements, existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Excellent experience in business analysis and MS Excel reporting, BIRT reporting, Tableau, python and Talend.
• Having experience in Groovy Grails, Java, JavaScript, Spring, JSF, Web Services, SOAP, JPA, Hibernate, Java Script, XML, HTML, Hadoop, Hive, AWS, Web Services.
• Excellent experience in designing Jasper reports with XML/XPATH2, Java bean, Stored procedure, SQL, EXCEL, Custom Data source and HQL as data sources and converting Actuate e report, Actuate BIRT and crystal reports to Jasper.
• Excellent experience in Installation, configuration, customization and maintenance of Jasper Server in Windows and LINUX Environments.
• Proficient in integrating Jasper Reports into Java or Groovy Grails Applications
• Expertise in reports automation to ensure timely delivery of the reports and also accuracy of the data on the reports.
• Excellent project management skills including planning, scheduling, monitoring and budgeting with experience in requirement gathering, Gap Analysis and Risk Analysis.
• Flexible, enthusiastic and project oriented team player with excellent communication skills and leadership abilities to develop creative solution as per client requirement.
• Good Domain knowledge in Banking and Travel Domain.
• Experienced in Agile Methodology by actively participating in scrum calls and sprint.

TECHNICAL SKILLS:

BI Tools: Jasper Server 6.3, Tableau 10.1

Front End Tools: Microsoft Project, Microsoft Office

Databases: MySQL, Oracle, SQL Server

Reporting Tools: BIRT, Jaspersoft Studio, Pentaho, iReport, Oracle Reports, Oracle Forms, Crystal reports

ETL Tools: Talend, SSIS

Defect management tool: JIRA, Bugzilla

Programming Languages: JAVA, Hadoop, Python, R, Groovy Grails, Splunk, SQL, PL/SQL, XML, HIVE

Web services: CXF, JAX-WS

IDE: Eclipse, GGTS, Sublime

Version Control tools: GIT, SVN, and VSS

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

Management Information & Analytics Lead Developer

Responsibilities:

• Reponsible for the overall management and development of the Jaspersoft reporting associated with CA PPM.
• Involved in gathering requirements from stakeholders and developing reports and dashboards in Jaspersoft and Tableau.
• Involved in developing Jasper reports on PPM data model CLARITY and DWH for CA PPM application and embedding jasper reports into CAPPM application through apis.
• Involved in creating domains, with security models, adhoc views .and reports, users and roles configuration and management of jasper server.
• Involved in development of changes and resolution of issues.
• Involved in converting manual reports to jasper reports.
• Involved in creation of users and roles configuration and management of jasper server.
• Resolves moderate problems associated with the designed programs and provides technical guidance on complex programming.
• Involved in creation portlets, portlet pages custom object and integration of CA PPM to different applications using NSQL, GEL and XOG scripting and clarity Configuration.
• Working in the Project Portfolio Controlling (PPC) team within Group Technology Operating Management to deliver an effective and efficient Operating and Control environment across Group Technology, within agreed operating plans, whilst providing portfolio management services across the firm.

Environment: Jasper Server 6.2, JasperSoft studio 6.2, Tableau 10, ORACLE, CA PPM, Java, Spring, Hibernate, GIT, JIRA and PL/SQL.

Confidential, New York City, NY

Application Architect

Responsibilities:

• Creating, troubleshooting and customizing very complex Jasper interactive dashboards, decks using custom visualization, phantom.js, d3.js scriptlets, sub reports, cross tabs using third party tools like D3 charts, High charts, HTML charts, Fusion charts and widgets, vectors.
• Customizing the jasper server UI and custom features and Excellent Experience in creating very complex reports and dashboards using Jaspersoft studio.
• Implemented single sign on and custom configurations.
• Created reports using different data sources like JSON, XML, Excel and custom datasources.
• Integrated Jaspersoft visualizations into Confluence and CA Agile Central.
• Created very complex gnat fusion charts and widgets, high charts in Jasper.
• Created reports using different sources like Hadoop, rest API, SQL server, Teradata.
• Created domains, topics and user management in Jasper server.
• Automated most of the manual reports and decks and email notifications using JasperSoft with custom triggers.
• Create a fluid end-end vision of data flow between applications and streamline the entire flow.
• Involved in developing KRIs (Key Risk Indicators) as alerts using SPLUNK SPL from cornerstone and pushing to structural databases.
• Involved in creating interactive dashboards Tableau and Splunk reporting and visualization.
• Involved in creating stored procedures to pull the data from Reporting DB.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Collaborate with teams and management to devise a data strategy that addresses requirements
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Jasper Server
• Created service ids and jndi datasources, domains.
• Created reports using JSON, XML, Excel and custom datasources.
• Involved in writing script lets for custom calculations in application.
• Resolves moderate problems associated with the designed programs and provides technical guidance on complex programming.
• Involved in testing the procedures for report development and handled the performance issues effectively.

Environment: Jasper Server 6.3, JasperSoft studio 6.3, Tableau 10, Splunk, Hadoop, Hive, Splunk, R, Python, PySpark, CA Agile Central, GIT, Bit bucket, Confluence, SSIS, ASQL SERVER 2012 and PL/SQL.

Confidential

Senior Jaspersoft Consultant

Responsibilities:

• Involved in integrating jasper reports plugins and writing services to integrate into application.
• Involved in creating a data warehouse for complex Jasper reports.
• Involved in creation, execution, scheduling of triggers to populate date to the reporting DB.
• Involved in creating stored procedures to pull the data from Reporting DB.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects and Reports.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Used scripts to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in creating Jasper Reports.
• Implemented virtualization, pagination and internationalization of jasper reports into the application.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters
• Applied spring security features at role based reports level security, to make the sensitive data secure.
• Involved in writing script lets for custom calculations in application.
• Created complex jasper reports with sub-reports, barcodes, dynamic grouping, and parameters and sorting.
• Created report stylesheets according to the templates with effective EXCEL, PDF and HTML report outputs.
• Involved in creating Stored Procedures, tables, and views for applications.
• Resolves moderate problems associated with the designed programs and provides technical guidance on complex programming.
• Actively participated in clarification meeting with the customers
• Involved in testing the procedures for report development and handled the performance issues effectively.

Environment: Groovy Grails 2.2.4, Jasper reports 5.6, AWS, SQL SERVER 2012, GGTS, Sublime, and PL/SQL.

Confidential

Developer

Responsibilities:

• Involved in developing jasper reports module in to a ecommerce application.
• Involved in Credit Card tokenization API which masks the credit card as per PCI standards.
• Developed web service API to integrate with data cash API and PayPal payment gateway etc.
• Involved in developing Client API to test the services.
• Involved in developing DB design and PL/SQL scripts in order to capture the payment gateways success/Failure response for audit purposes.
• Involved in developing the SPS Admin module to generate reports on the audit database.
• Implemented SSL.
• Involved in DB design, writing procedures and complex quires.
• Involved in creating various jasper report for the admin module and its user-role management.
• Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation.
• Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.
• Develop, derive and clarify functional specifications and Use cases.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications reports.
• Assisted the DBA in converting the logical models to physical.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Importing source definitions. Creating and importing target definitions. Creating the table targets.
• Tested all the business application rules with test & live data and automated.
• Developed & modified database Stored procedures and Functions.
• Developed Oracle Reports and forms
• Involved in testing and fixing bugs on test and On-line data.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Tomcat 6.0, Ant, apache-maven-3.0.3, Spring JDBC, CXF -2.5.6, Oracle11g, Oracle Reports, Eclipse 3.6.0, PL/SQL.

Confidential

Sr. Developer/ Sr. Data Analyst

Responsibilities:

• Involved in developing Twitter and Facebook apps to fetch those data to the application.
• Developed Scheduler to schedule backup of data to log files.
• Involved in using Spring Social Plug-ins into the application to get the data
• Installed Hadoop, Hive.
• Pushing the data into HDFS.
• Developed jasper reports by querying using HIVE-QL queries.
• Responsible for preparation of Test Strategy document.

Environment: Facebook APIs, Twitter4j, Hadoop-2.0, Hive-0.90, Tomcat 6.0, apache-maven-3.0.3, Spring 3.5, Spring-Social-1.0.2, MySQL, Eclipse 3.6.0, i-report-3.5.0, HiveQL, Cygwin.

Confidential

Jasper Report Developer

Responsibilities:

• Involved in analyzing and understanding the Actuate e report.
• Migrated Actuate e reports to Jasper Reports.
• Involved in estimation, requirement gathering, Gap Analysis and Risk Analysis.
• Designed jasper reports with dynamic data source.
• Created scriptlet, internationalization and table of contents.
• Created Java Bean data source for the reports.
• Report level total, group-level total calculations for the reports.
• Effectively migrated very complex Actuate e reports to jasper reports.
• Involved in testing the created reports and preparation of Test Strategy document.
• Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.

Environment: Jasper reports, jasper server, java, XML, JRXSL and Oracle.

Confidential

BI Developer

Responsibilities:

• Involved creating jasper reports and integrating jasper apis to the applications.
• Involved in gathering the various requirement matrices from the business analysts.
• Designed a POC to present the client, how the reports look on dummy database.
• Converted the requirements into design.
• Involved in designing, developing, debugging and testing of reports.
• Created very complex HTML and PDF Jasper Reports with dynamic drill- down of the data in the report using sub reports and hyperlinks.
• Customized the report plugins for effective html, PDF and Excel report Outputs.
• Developed the Reports Module and involved in integrating the jasper reports to the travel module.
• Embedded the jasper reports into the application using IFRAME.
• Designed the criteria selection screens in JSF.
• Involved in writing complex SQL scripts for the reports.
• Involved in pushing customer data to the GO LIVE Database.
• Involved in testing the scripts and the reports.
• Involved in back end service part and UI part of most of the Travel administrative screens
• Involved in developing the CRUD operations of the screens.
• Involved in generating CXF- web-services
• Developed the Reports Module and involved in integrating the jasper reports to the travel module.
• Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing using Bugzilla software.
• Verifying installed systems to ensure that they adequately meet user requirements.
• Involved in writing Test Cases, procedures, reports and approval of software release.
• Assisted in project management activities like planning, development, task allocation, project execution
• Provided full project life cycle flowcharting, analysis and documentation.
• Deployment of defect free code while managing the timeline set for the project.
• Identified Various Business and Data Test Scenarios and assisted in the preparation of extensive set of validation test cases to verify the data.

Environment: JBoss-5.1.0, Tomcat, apache-maven-3.0.3, spring 2.5.6, JSF-2.0.2, jasper reports, Oracle10, Eclipse 3.6.0, SQL, Hibernate.

Confidential

Deputy IT & MIS Manager

Responsibilities:

• Involved in understanding the banking domain and Micro Finance Domain.
• Involved in entire streamline of excel reports to Jasper reports in the company to various departments and the managements to reduce the dependency on IT Department for data.
• Created BIRT Reports for a Core Banking Solutions application by gathering the requirement s from various department of the organization i.e., Operational, Financial, Accounting Departments. Also for end users.
• Migrated BIRT reports to Jasper reports.
• Deployed the reports created to the application.
• Moved jasper reports from the core banking solution to a Jasper Server for better performance of the reports.
• Involved in creating a data warehouse for Reporting server by replicating the Production MySQL Database.
• Involved in installing the Linux OS to the production box and jasperserver, implemented ssl on moved to data center.
• Installed Jasper Server in the Linux server and customized the UI as per the company requirements.
• Created different data sources, users and their roles according to their departments and designations.
• Created adhoc reports, domains and topics as per the requirement of concerned departments, so that they can create and play with data for their analysis purpose and for future reference.
• They can run the adhoc reports and export the data to the required format.
• Some Reports are schedule to email to the users email at scheduled time.
• Involved in identifying and correct the production data errors and jasper server exceptions.
• Involved in Jasper Server training by Jaspersoft and Acted as a point of contact to Jaspersoft.
• Identified Various Business and Data Test Scenarios and assisted in the preparation of extensive set of validation test cases to verify the data.
• Involved in testing and fixing bugs on test and On-line data.
• Involved in writing very complex SQL queries, triggers and procedures.
• Involved in converting Oracle Reports to Jasper Reports.
• Involved in business analysis and management meeting with PowerPoint presentations.
• Used SQL queries to analyze and validate data.
• Coordinated Defect Meetings with Business and Technical team.
• Participated in Daily stand up meetings with other project team members.

Environment: Java, struts, i-report-3.5.0, Jasper Server 3.5.0, Eclipse, BIRT, MySQL, Pentaho, LINUX, Oracle Reports and crystal reports.