EXPERIENCE SUMMARY:

• Extensively handled all the products of Actuate Erd pro reports conversion to BIRT, MICROSTRATEGY, JASPER, Business Objects. worked on SDK to customize Actuate reports ERDPRO,BIRT,JASPER,MICROSTRATEGY dashboards and also on integrating the BI layer with existing portals
• Proficient in Core Java, JDBC, SERVLETS, JSP, HTML, CSS, Struts, XML, JAVA SCRIPT, UNIX and Shell Script Technologies.
• Understanding re - writing, and writing of complex SQL queries - Hierarchical Queries, XML Query, Complex outer joins, Correlated Sub-queries, Hints for optimized data retrieval.
• Effectively made use of Database Objects - Tables, Constraints, Indexes, Sequences, Triggers, Views.
• Responsible for Designing JRXML’s and deploying the report’s into Jasper Server.
• Responsible for gathering requirements, design and develop reports using Actuate ERDPRO, BIRT, JASPER Tools.
• Write java code for running the actuate reports using IDAPI (information Delivery API) calls provided by Actuate.
• Development of Database queries and Stored Procedures in ORACLE, DB2,SYBASE,SQL Server based on the requirement of the reports
• Prepare user interfaces in HTML/JSP using Actuate Active portal
• Responsible for Designing the Different reports using multiple I-Report components like Crosstabs, sub reports, Frames, Groups and Bands.
• Created a Jasper Dashboard using internal resources as well as using external URL’s (maps).
• Responsible for developing OLAP schemas and Jasper analysis views. Developing the Jasper Ad-Hoc Reports.
• Excellent analytical and de-bugging skills.
• Experience to work on Client side to analyze the needs and draft the requirements
• Used PL/SQL looping features - with Ref Cursors, External Cursors Bulk Collect, Collections, and Record types.
• Experience with Data-warehousing Concepts - Data Analysis, Data Profiling, Master Data Management, Data Cleansing, Data Transformation, Loading, Data Mart design.
• Good Experience in initiating new initiatives like Agile methodology, Scrum Activities, Test Driven Development
• Good Experience with area of Development, Design, Analysis, Functional Studies, Requirement Gathering, Offshore co-ordination, estimation and Project Management.
• Good domain knowledge in Insurance, Telecom, Capital Market, Core Banking, Corporate Banking Services in Global Payments.

AREAS OF EXPOSURE & EXPERTISE (TECHNICAL SUMMARY):

Languages & Tools: Actuate eRDPro 7, 8,9 & 11 designer and server console, SQL, Crystal Reports designer, Actuate E.Spread Sheet Report Designer, TIBCO Spotfire, Jasper Reports, Eclipse BIRT, BIRT,Core Java, 4D, PHP, Sybase,CSS3, XHTML, XML, JavaScript,jQUERY, JSON, AJAX.

Database: Oracle 9i,10g, PL/SQL,Sybase, DB2 Tools Clarity, Rational Clear Case & Version Control Tool

WORK EXPERIENCE:

Confidential

Oracle PL/SQL Actuate Developer and Jasper Reports Developer

Responsibilities:

• Created different data marts type like MERGE, RANGE, SPOT, SQL, TRANSPOSE and developed IRD reports using reusable components such as Sheet Bursting, Sections, Logos, Report title etc. created reports using concept "NO NAV" to investors subscriptions and withdrawal activity
• Developing Template Based Reports Using BIRT Studio and Publishing Reports to the Report center.
• Developing the Excel reports Using Spread Sheet for the clients ERISA, AIS-MIS, MORGAN-STANLEY etc.
• Created PL/SQL Coding Standards and Best Practices, used by the development team-members.

Environment: Actuate Spread Sheet, IRD Reports, HTML, JSP, Oracle PL/SQL

Confidential, Atlanta, Minneapolis

Oracle PL/SQL Actuate Developer

Responsibilities:

• 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
• Created configuration files to include the libraries ROL in the Actuate reports
• Writing stored functions and developing reports. Calling Procedures, Functions and packages using PL/SQL
• Implementing External Style Templates to make use one style for multiple Reports.
• Performed query analysis and enhanced Query performance.

Environment: SQL Server 2005, Toad, Win 2003 Server, Actuate Erdpro 9, Server 2008 R2, SERVLETS, HTML,JSP

Confidential, SANFRANSISCO

BIRT/JASPER Report Developer/ PL/SQL/Front End Developer

Responsibilities:

• 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 in birt reports.
• Used Drill through definition to link two or more reports.

Environment: BIRT, TEST HARNESS, MS Office Suite,Oracle SQL ServerR2, MS Excel, SERVLETS, HTML, JSP

Confidential

Report Developer/Programmer Analyst - PL/SQL/Front End Developer

Responsibilities:

• Involved in the gathering of business requirements and translating them to the report specifications for the conversion of Actuate Reports to Jasper platform.
• Optimized the SQL queries to improve the performance of the Online Services system.
• Interacted with business users and analysts to clarify requirements and resolve defects.
• Developing and deploying the report’s into Jasper Server.
• Responsible for Designing the Different reports using multiple i-Report components like Crosstabs, sub reports, Frames, Groups and Bands.
• Interact with business users and gather functional requirements.
• Design an efficient and maintainable framework for reports development.
• Develop the jasper reports and analyzed complex reports in eReport Designer Professional.
• Deploy and test the reports and package them for production deployment.
• Created a Jasper Dashboard using internal resources as well as using external URL’s (maps).

Environment: Actuate Reporting System (v7, v8, v9), J2EE, Web Services, Sybase, Autosys Scheduler, Jasper Reports Server pro 5.1.0, I-Report Pro 5.1.0

Confidential

Report Developer/Programmer Analyst - PL/SQL

Responsibilities:

• Involved in performance tuning of stored procedures to reduce program execution time and optimize memory usage.
• Used nested table, Bulk collect and advanced PL/SQL techniques for faster performance.
• Overridden various methods like On Read, Fetch, Start, Obtain Select and On Rowto get the right functionality.
• 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
• Created configuration files to include the libraries ROL in the Actuate reports.
• Load application tables from various warehouse tables.
• Created different types of objects attributes, metrics, filter’s, Prompts, Custom Groups, Consolidation, Hierarchies and Transformations and also created security model for all users using MICROSTRATEGY Desktop.
• Troubleshoot and tuned MICROSTRATEGY reports by analyzing the generated SQL to determine data issues, incorrect fact tables, incorrect joins insufficient data and wrong results coming from database.
• Done appropriate unit level testing of work products and the management of the Review of the code to ensure client standards with Data validation and verification.
• Gathered reporting requirements from business end users/clients, documented requirements.

Environment: Actuate ERDPRO, ESPREADSHEET, Micro-Strategy,Oracle SQL ServerR2, MS Excel, SERVLETS, HTML, JSP, IMR, PMR, CMR, Manage now, Service Now etc.

Confidential

Actuate Report Developer/Programmer Analyst - PL/SQL

Responsibilities:.

• Involved in Actuate Server Administration activities like scheduling Actuate Reports, Configuring Actuate Server for Automated email notifications with attachments (ROI, PDF).
• Tuned Several Complex SQL Queries - improved performance, by reducing time between 50% up to 5%.
• Developed several re-usable SQL queries - which are used by many developers in their code.
• Using this Actuate, we can generate the reports from the static Actuate server rod, rox files to dynamically executable reports, which are web based.

Environment: Oracle 9i PL/SQL, Actuate 7 Reporting Tool, Crystal Reports, TOAD, PL/SQL Developer MS-VSS Clarity Applications.

Confidential

Report Developer/Programmer Analyst - PL/SQL

Responsibilities:

• Developing of PL/SQL packages, stored procedures and function
• Performed extensive back-end database testing, to confirm error free transfer of data between the front end and back end.
• Worked on page designing using HTML, Skins, Themes and CSS.
• Coded the web pages (Admin pages, Manage/View/Edit Odds pages) using HTML, JavaScript and middle tier components in java.

Environment: s: Actuate ERDPRO, Oracle, JAVA, HTML, JSP