SUMMARY:

• IT Professional with 7+ years of experience in Software Analysis, Design, Development Integration, Testing, Migration, troubleshooting, Production support, and Implementation of Business Intelligence (BI) and Database Applications.
• Extensive experience in developing Jasper reports. Jaspersoft Studio 6.0/5.5.0, Jasper Server, IReports Designer 4.5 Jasper Server customization.
• Designed and developed Adhoc reports, Asset Allocation, Portfolio Summary and Portfolio Activity, Transactional summary and detailed, Calendar Year and Trailing year returns performance reports, KPI's, Complex reports with many sub reports and evaluation conditions using Crystal Reports, Jasper Server and Jaspersoft Studio.
• Designed and developed various Jasper reports such as Crosstab, Table, HTML5 based Chart reports using Jaspersoft studio are deployed in Jasper Server.
• Exported the Jasper reports to various formats such as PDF, EXCEL, CSV and XLSX as desired by the client requirements.
• Created various datasets and consumed in developing Table, Crosstab, Chart components etc. to explore the data for the decision making.
• Involved in Jasper Admin Activities such as creating roles, users, assigning appropriate privileges
• Created various reusable resources in Jasper Server such as input controls, data sources etc.
• Tested the Jasper Reports in various testing environments including Unit Testing, System Testing, and User Acceptance Testing (UAT).
• Solid experience in data warehouse Design, Data Modeling, ETL and Reporting.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Worked with query tools like Toad, MySQL Workbench, SQL Developer and Proficient knowledge in HTML and JavaScript.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Designed and developed the Extraction, Transformation, and Loading (ETL) program to move data from source to target, mapping source data attributes to target data attributes.
• Have extensive experience in Performance tuning by analyzing the execution plans of the query.
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors, Ref Cursors, Dynamic SQL, Oracle Analytical Functions, Exception Handling, Materialized views and views for processing data and enforcing referential integrity.
• Created materialized views like primary key, rowid, and sub query materialized views.
• Strong in writing Stored Procedures and SQL queries and strong understanding of the Oracle database, related utilities and tools and proficient in data loading/extraction using SQL*Loader.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail - level data analysis.
• Experience in Business Intelligence (BI) solution design, development & process documentation to produce required reporting & analytics deliverables using BI Software.
• Committed to excellence, Problem Solving skills and Troubleshooting and Decision Making skills.

TECHNICAL SKILLS:

Reporting Tools: Jaspersoft Studio 6.0/5.5.0, Jasper Server, iReports, Tableau 6/7/8

Languages: JAVA,C++,SQL,PL/SQL, Python

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, iSQL*Plus, SQL*Loader, Oracle procedure Builder

Development Tools: Developer 11g/10g/9i/6i/2000 Release 1 & 2, Reports 10g/9i/6i, Forms 6i/9i/10g

Operating Systems: Windows 98 / NT / 2000 / XP, UNIX

Scripting Languages: Java Script, UNIX Scripting, HTML, XML

Databases: Oracle 9i/10g/11g, SQL Server 2008, IBM DB2, MS Access

BigData Skills: Hadoop Development Framework (Mapreduce, YARN, PIG, HIVE, HABASE, Oozie, Zookeepr, Scala and Flume)

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Sr. BI Reports Analyst

Responsibilities:

• OLAP schemas are analyzed in the dev environment using Jasper OLAP workbench for production issues and suitable solutions are provided.
• Agile methodology worked closely with product owner, key account personnel and DW team.
• Redesigned some of the existing OLAP schemas to match sponsor requirements.
• New OLAP cubes designed for the Insurance companies. OLAP views generated using MDX queries.
• Suggested DW changes to implement data security features for the existing OLAP cubes.
• Migrated customer facing and intranet systems to Amazon AWS (Amazon web services) cloud computing.
• Analyzed Topic reports and created new topic reports as per the sponsor requirements.
• Helped the team leader with Jasper Admin Activities such as creating roles, users, assigning appropriate privileges.
• Created various reusable resources in Jasper Server such as input controls, data sources etc.
• Involved in QA testing of modified OLAP views and other Jasper Reports in Jasper QA server.
• Create new Users, Roles and manage Jasper Server Repository.
• Developed XML Schemas to create OLAP Cubes for analysis of large data sets in different dimensions.

Environment: Jasper Soft Studio 6.0.1, Jasper Server 5.5.0, Jasper OLAP, iReport Designer 5.6.0, MySQL workbench 5.2, LINUX, Shell Scripting, AWS.

JASPER DEVELOPER

Responsibilities:

• Upgrade existing Jasper reports from version 3.7 to 5.2.
• Proposed changes to the existing Database Architecture as per requirements and Involved in redesign of database.
• Worked closely with architect, technical lead and other team members on design and development tasks in providing Jasper Reporting solutions.
• Interact with internal and external clients in report writing and analytical efforts via corporate sponsored projects or production support requests routed through request management system.
• Designed and developed various Jasper reports such as Crosstab, Table, and HTML5 based Chart reports using Jaspersoft studio and Deployed in Jasper Server.
• Exported the Jasper reports to various formats such as PDF, EXCEL, CSV and XLSX as desired by the client requirements.
• Created various datasets and consumed in developing Table, Crosstab, Chart components etc. to explore the data for the decision making.
• Involved in Jasper Admin Activities such as creating roles, users, assigning appropriate privileges.
• Created various reusable resources in Jasper Server such as input controls, data sources etc.
• Tested the Jasper Reports in various testing environments including Unit Testing, System Testing, and User Acceptance Testing (UAT).
• Scheduled the Jasper Reports on daily basis and periodically to the business users as per the business requirement.
• Design, develop and deploy user friendly and rich looking Financial and Billing reports using iReport and deployed onto Jasper Server.
• Modified existing ETL processes as per new requirements.
• Create new Input Controls, Drop down lists, resource bundles on the Jasper Server.
• Create new Users, Roles and manage Jasper Server Repository.
• Created Book of reports which enables users to select reports runtime dynamically.
• Widely used report expressions or variables for developed jasper reports.
• Developed XML Schemas to create OLAP Cubes for analysis of complex data in different dimensions using Jasper Analysis.
• Designed and developed Jasper reports with complex String manipulations, building of Maps or Lists of objects in memory or manipulations of dates using 3rd party Java APIs.
• Upgrade financial reports as per specifications of different Fund Managers and Investment Advisors.
• Used TortoiseCVS control version for synchronizing the up-gradations.
• Incorporated IT services management changes into Jasper & real-time feed processing using ETL.
• Manage & mentor 2 junior developers on Jasper Reports, assign tasks & review day-to-day tasks.
• Coordinated with the team of java developers to accomplish complex financial calculations.
• 24/7 on call production support.
• Migrated customer facing and intranet systems to Amazon AWS (Amazon web services) cloud computing.
• Create new Tables, Indexes, Views, and Materialized Views, table Partitions as per the requirement.
• Create SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.
• Involved in POC for evaluating Tableau for Visualization solution.
• Involved in designing and developing Tableau Dashboards with various report elements such as highlight tables, stacked bars, side by side bars, symbol maps, filled maps, heat maps.
• Participated in project sessions and generated Daily reports, Weekly Reports, Monthly Reports as per the end user and senior management requirements.
• Worked with tableau developers in developing complex tableau workbooks, tableau dashboards and published in Tableau Server.

Environment: Jasper Soft Studio 5.5, Jasper Server, Jasper ETL, Jasper Analysis, iReport Designer 3.7.1, Oracle 10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Toad, MySQL 5.0.27, ITSM, Jasper ETL, Jasper Analysis, Java, Sun Solaris, Unix Shell Scripting, AWS

JASPER DEVELOPER

Responsibilities:

• Analyze the functional & technical requirements and of the project.
• Create new Users, Roles and manage Jasper Server Repository.
• Designed and developed Summary Reports, KPI's, performance reports, Complex reports with many sub reports using Jasper Server and iReport.
• Upgrade financial reports according to the specifications of different Fund Managers and Investment Advisors.
• Migrated customer facing and intranet systems to Amazon AWS (Amazon web services) cloud computing.
• Designed and developed Adhoc reports, Asset Allocation, Portfolio Summary and Portfolio Activity, Transactional summary and detailed, Calendar Year and Trailing year returns performance reports, KPI's, Complex reports with many sub reports and evaluation conditions using Crystal Reports, Jasper Server and iReport Designer.
• Create new Input Controls, Drop down lists, resource bundles on the Jasper Server.
• Designed and developed user friendly Financial and Billing reports using Oracle PL/SQL, Analytic Functions, SQL, iReport and deployed onto Jasper Server.
• Developed Cash reconciliations and Securities reconciliations reports.
• Created batch jobs for the data cleansing and generation of summarized reports.

Environment: Jasper Server 3.1.1/1.3.0, Jasper ETL, Jasper Analysis, iReport 3.1.1/1.3.0, Oracle 10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Toad, MySQL 5.0.27, ITSM, Jasper ETL, Jasper Analysis, Java, Sun Solaris, SQL Server 2008, Unix Shell Scripting, AWS.

ORACLE DEVELOPER

Responsibilities:

• Interacting with the business users to understand the functionality and their requirements.
• Loaded data into Oracle using PL/SQL, Dynamic SQL UTL FILE, SQL* Loader and extensive use of External Tables.
• Designed the packages and procedures for getting the data from Source systems to ESA (Enterprise Staging Area) and from ESA to EDW(Enterprise Data Warehouse).
• Extensively worked on Oracle Packages, procedures and functions using PL/SQL, SQL, SQL Navigator and PL/SQL Developer.
• Performed unit testing on the developed code to ensure that its bug free and handled Production issues and manage the same in issue log.
• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Designed Technical design document based on the business requirements.
• Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Created Materialized Views for extracting the data from remote database.
• Preparation of wrapper scripts for all the database processes & data quality checks using Shell scripting.
• Wrote complex SQL queries to extract data from various source tables of data warehouse.
• Created various Function Based Indexes to significantly improve performance.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.
• Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems.

Environment: Oracle 10g, PL/SQL, Report Builder 10.1.2.0.2, Toad 7.5.2.0, MySQL 5.3, UNIX.