SUMMARY:

• Extensive experience in developing Jasper reports. Jasper Server, iReports, Jasper Server customization
• SDLC experience with end to end reports migration implementation.
• 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 4.5
• Design, develop and deploy user friendly and rich looking Financial and Billing reports using Oracle PL/SQL, Analytic Functions, SQL, iReport and deployed onto Jasper Server.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• DWH/BI stack experience from analyzing requirements to implementing solution.
• Firm Experience in E - R Modeling, data warehousing, dimensional modeling, ETL, Reporting
• 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.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning & Optimization of SQL statements and implemented security setup using Active directory integration.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications
• Worked with query tools like Toad, SQL*Plus, SQL Developer and Proficient knowledge in HTML and JavaScript.
• 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
• Participated in all Business Intelligence activities related to data warehouse, ETL and report development methodology.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
• 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.
• Firm experience in Perl Scripting & UNIX Shell scripting Perl/sh/awk.
• Experience in Business Intelligence (BI) solution design, development & process documentation to produce required reporting & analytics deliverables using Tableau BI Software
• Strong Knowledge of Data Warehousing concepts, RDBMS and Dimensional modeling primarily Star & snowflake schemas.
• Experience in Analysis, Design, Development, Customization and Implementation of Business Intelligence Projects
• Committed to excellence, Problem Solving skills, Troubleshooting and Decision Making skills

TECHNICAL SKILLS:

Reporting Tools: Jasper Server 3.1, 3.7, 4.0.2, 4.5, iReport, Tableau 6/7/8.0

ETL Tools: Informatica, Data Services Integrator

Languages: JAVA, C, C++, VB6.0, SQL, PL/SQL, FOXPRO

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

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

Databases: Linux Oracle 9i/10g/11g, SQL Server 2008, MS Access, Teradata

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

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

PROFESSIONAL EXPERIENCE:

Confidential,New York,NY

JASPER DEVELOPER/ANALYST

• Worked on optimizing jasper server with known configuration settings
• Customizing the implementation of existing jasper implementation
• Generating ADHoc view according to the required domains
• Write documentation on reports based on creating reports managing server domains etc...
• Analyze the functional & technical requirements and of the project.
• Create new Users, Roles and manage Jasper Server Repository.
• Create new Input Controls; Drop down lists, resource bundles on the Jasper Server.
• Designed and developed user friendly Financial and Billing reports using 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 6.1.1/6.0.1, Jasper Analysis, iReport 5.6.0, SQL, PL/SQL, MySQL 5.0.27, Jasper Analysis, Java, Sun Solaris, Unix Shell Scripting

Confidential,New Brunswick, NJ

JASPER ARCHITECT

• Upgrade existing Jasper reports from version 3.1.1 to 4.5
• Proposed changes to the existing Database Architecture as per requirements and Involved in redesign of database.
• Designed, developed, and supported Confidential reporting system for company management and employees that provided staff with much analytical abilities.
• Designed & developed Adhoc reports, Summary Reports, KPI's, performance reports, Complex reports with many sub reports and evaluation conditions Jasper Server and iReport 4.5
• 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.
• Used Hummingbird Exceed to connect to the UNIX server.
• Developed XML Schemas to create OLAP Cubes for analysis of complex data in different dimensions using Jasper Analysis.
• Designed test cases and participated in testing of data warehouses.
• Used SDLC with end to end reports migration implementation.
• Upgrade financial reports as per specifications of different Fund Managers and Investment Advisors.
• Incorporated IT services management changes into Jasper & real-time feed processing using ETL.
• Extensively performed Unit Testing & Integration Testing with different test cases.
• Manage & mentor 2 junior developers on Jasper Reports 4.5, 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
• Designed Fact and dimension tables and handled slowly changing dimensions.
• Create new Tables, Indexes, Views, Materialized Views, table Partitions as per the requirement.
• Create SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.
• Extensively used PL/SQL Collections, BULK Collect, Table Types, And Record Types, UTL FILE
• 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 Server 4.5/3.1.1/1.3.0, Jasper ETL, Jasper Analysis, iReport 4.5/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, Unix Shell Scripting

Confidential

ORACLE DEVELOPER

• Interacting with the business users to understand the functionality and their requirements.
• Designed and developed custom packages, procedures, Triggers using PL/SQL.
• 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 ga thering, 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 and data quality checks using Unix 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.
• Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.
• Extensively used Bulk Collections to insert and update huge amount of data into target databases.
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.
• Created and maintained PL/SQL scripts and stored procedures.
• Coded many generic routines (as functions), which could be called from other procedures.
• Created user defined Exceptions while handling exceptions. Wrote stored procedures, Functions and Database triggers using PL/SQL.
• Conducted training sessions for the end-users.
• 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, UNIX.