SUMMARY:

• Over Ten years of experience in IT Industry with strong knowledge in Design, Analysis, and Development of Data warehousing and Reporting projects using Crystal Reports, Tableau, Actuate Reporting Suite and RDBMS
• Gained strong experience in Crystal Reports, Tableau and Actuate Reporting Suite with RDBMS like Oracle, MS SQL Server, Sybase, Teradata, DB2, MS Access, and with applications like Salesforce, Siebel and Maximo
• Strong experience in writing SQL, PL/SQL - Stored Procedures, Functions, Views and Triggers for different RDBMS including Oracle and SQL Server for reporting projects
• Expert in designing and building architecture for reporting project implementations for small, medium and complex applications
• Extensively worked on Tableau Desktop connecting to various data sources including Excel, SQL Server, Oracle and DB2 databases
• Good understanding of Tableau Server options for publishing and sharing the reports across various user groups
• Created complex dashboards and stories using several tabular and graphical worksheets and published on Tableau server
• Created reports connecting single and multiple data sources and also invoked stored procedures from server databases using Tableau Desktop
• Gained hands-on expertise in SAP Crystal Reports with proficiency in using advanced Crystal Reports functionality such as Custom Functions, Web Elements, Crystal Formulas, Sub Reports, and Conditional Formatting etc.
• Created various complex reports using Crystal Reports for Salesforce application against SQL Server Database
• Extensively worked on development various types of reports including List, Cross-tab, Chart and Compound reports using Crystal Reports and involved in complete software development life cycle (SDLC) for reporting projects
• Created sub-reports to fulfill the business requirements and linked the sub-reports into main report and also worked on optimizing the report performance.
• Created and Maintained Users, folders, scheduled and published reports to Crystal Management Console
• Extensively worked on Actuate e-Report Designer Professional, BIRT/Eclipse, SQL, PL/SQL and Siebel Tools in development and production environments
• Extensively worked with e nd users and business users to gather the requirements and also involved in the training of end users
• Ability to quickly grasp the data models, analyze the business requirements and produce report designs/specifications
• Excellent communication and interpersonal skills

TECHNICAL SKILLS:

Reporting Tools: Data Modeling, Tableau 9.x/8.x, SAP Crystal Reports 2013/ Dimensional Data Modeling, Star Schema  2011/2008/X, Actuate 11/10/9/8, BIRT/ Modeling, Snow Flake Modeling, FACT and Eclipse 4.2  Dimension Tables

Databases Tools: Oracle 11g/10g/9i, MS SQL Server 2008/ Erwin, Toad, Visio, MS Office Suite, Rapid 2005/2000, Teradata, IBM DB2. SQL

Environments/ ETL Tools:  UNIX, Windows 7/XP/2000, Windows, Informatica Power Center 9.1, Server 2003/2000, HP-Unix, Linux.

Languages:  SQL, PL/SQL, T-SQL, .Net, Java Script, VB Script, XML

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Sr. Reporting Analyst/ Tableau Developer

Responsibilities:

• Participate in analysis, design, programming, test, and documenting of complex reporting activities for GSFDC Salesforce.com project, Actuate migration project and BAU tasks
• Provide SME support on issues/concerns for the Actuate to Crystal Reports and Tableau Migration project.
• Extensively worked on Tableau Desktop to build worksheets, dashboards and stories for internal teams
• Used Custom SQL feature on Tableau Desktop to create very complex and performance optimized dashboards
• Implemented various basic calculations including Custom Aggregations, Custom Calculated Fields, Date Calculations, Conditional Filters, Logic and conditional calculations etc.
• Created reports with various parameters and input controls for more user flexibility in viewing the reports
• Implemented advanced techniques in filtering, grouping and sorting data to meet the specific business requirements using Tableau Desktop
• Provide technical support for the testing for Actuate, Crystal and Tableau reports for various applications as a part of Solaris EOL project including Solaris to Linux migration and Oracle database up gradation to higher version
• Created very complex reports containing highly formatted content and several sub reports for Salesforce and other internal applications using Crystal Reports.
• Created the URL’s for several Crystal complex reports and deployed on Salesforce application enabling reports to be triggered from application
• Created event based reports based on Autosys jobs and configured on Management Console to trigger reports based on success event of Autosys job
• Created reporting specifications and other pertinent, standardized documentation that provides direction to team participants as part of BAU tasks.
• Coordinate with application, middleware engineering, application release and back end teams for various development and testing and production deploy activities
• Extensively worked on development of new actuate BAS and ROD files and Crystal reports
• Developed several sub routines and functions and included in the actuate report design (ROD) and BAS files
• Developed new SQL queries, Stored Procedures and Views and modified existing ones against SQL Server, and Oracle database for use in reports
• Worked on design and development of data load jobs on Informatica cloud environment
• Performed peer review tasks for Actuate, Tableau and Crystal code/unit test case/unit test results
• Coordinated with team members and maintained weekly status reports

Environment: SAP Crystal Reports 2013/2008, Tableau 9.2/8.x, Actuate 11, SQL Server 2008, Oracle 11g, DB2, Informatica Cloud, Salesforce.com, Toad, Autosys, Windows and AIX

Confidential, Scottsdale, AZ

Sr. Reporting Developer/ Tableau Developer

Responsibilities:

• Worked on requirements analysis and estimation of development efforts for the project
• Extensively worked on development of new Crystal report (.rpt), Tableau workbook(.twb) and Actuate BAS and Report Design (ROD) files
• Created number of formulas, running totals conditional display of fields for complex calculations and used them in Crystal sub reports.
• Created complex Crystal reports by invoking stored procedures against Oracle database
• Created very complex Crystal reports with up to 27 sub reports all linked with parameters
• Created new templates and modified the existing report design files using Crystal as per the requirements
• Developed various reports including Rebate, Market share, Exclusion, Summary and Details dashboards using Tableau Desktop
• Worked with Data Extracts to create Tableau dashboards and scheduled extract updates at regular intervals for Invoice Team
• Built complex calculations to manipulate data and published final dashboards on Tableau server
• Implemented various options in connecting and working with data including joining multiple tables from single data source, Custom SQL, data blending and performance considerations etc
• Implemented advanced techniques in filtering, grouping and sorting data as per user requirements using Tableau Desktop
• Developed several sub routines and functions and included in the Actuate ROD and BAS files
• Created the Actuate Library (ROL) files and included in the framework for use in the report design files
• Developed different types of reports using Actuate components like Parallel section, Sequential section, Conditional component, Memory Data Sorter, Dynamic Text controls etc
• Used Single Input Filter, Multiple Input Filter, Charts and other components of eRDPro extensively
• Overridden the various methods on Actuate side like Fetch Method, Obtainselectstatement method, BuildFromRow method, OnRow Method etc. to meet the requirements
• Developed new SQL queries and modified existing ones against DB2 database for use in reports
• Performed admin tasks for Crystal reports including Monitored failed reports, exporting reports in Excel, PDF and saved on Shared Network drive, e-mailed to users as per the requirements.
• Created detailed unit test case and unit test results documentation for the actuate coding tasks
• Worked on tasks assignment to other team members and co-ordination of team
• Performed peer review tasks for Actuate code/unit test case/unit test results
• Coordinated with offshore team and maintained weekly status reports

Environment: Crystal Reports 2008, Tableau 8.x, Actuate 11, BIRT, DB2, GDX, JAVA, Informatica 8.x, Toad for DB2, Citrix, Share Point, Windows, and AIX

Confidential, Rochester, NY

Sr. Reporting Analyst/ Tableau Developer

Responsibilities:

• Created detailed technical specification documents for all Actuate, Crystal and SSRS reports for MaxMC, AnyDoc and Facets applications interacting with business analysts and end users
• Developed all reports using Actuate Designer Professional and Crystal Designer with Oracle, SQL Server and Sybase databases at backend
• Developed various reports including Rebate, Market share, Exclusion, Summary and Details dashboards using Tableau Desktop
• Override several methods including SuggestRoiMethod, Start, Finish, OnRow, ObtainSelectStatement, New and Fetch methods
• Developed different types of reports using Actuate components like Parallel section, Sequential section, Conditional component, Memory Data Sorter, Dynamic Text controls etc
• Used Single Input Filter, Multiple Input Filter, Memory Data Sorter, Charts and other components of eRDPro extensively
• Worked with Data Extracts to create Tableau dashboards and scheduled extract updates at regular intervals for Invoice Team
• Developed both Parameter and Non Parameter reports for business users
• Extensively used various library objects for implementing standard report features and created new library objects
• Developed temporary and permanent tables in Oracle and used for reports
• Developed packages and stored procedures using PL/SQL and called from Actuate reports
• Worked on performance tuning of SQL queries for better performance of reports
• Developed various reports like Cardiac, Transplant, Diabetes, Asthma, Medical Director etc for the end users as per their requirements using Oracle and Actuate reports
• Dynamic Text Controls are extensively used for Appendix, Appeals and Notes sections of reports
• Performed administrative tasks on Actuate server like adding new users, creating testing environment for the users, scheduling the jobs, monitoring the server performance etc
• Extensively worked on migration of all Actuate reports to Crystal and SSRS reports.
• Created very complex Crystal reports using several sub reports and complex formulas
• Developed new Crystal reports mirroring existing Actuate reports in format and pointed to the existing data sources including views, temporary tables and stored procedures
• Developed new Crystal and SSRS reports with and without parameters for internal teams
• Performed unit testing of all the database objects and report functionality
• Created the test case and implementation documents

Environment: Crystal Reports 2008, Actuate 10/9, BIRT, Oracle 10g, Informatica 8.x, SQL Server 2005, SSRS 2005, Sybase, PL/SQL, SQL, MaxMC 9.03, Facets, Any Doc, Macess, Windows, Unix

Confidential, Atlanta, GA

Sr. Reporting Analyst

Responsibilities:

• Designed and developed technical documents, design specifications, flowcharts, project follow up and status check with other team members
• Created new Actuate Reports and Queries and integrated with Maximo Applications
• Developed several new reports using Actuate Designer Professional and integrated with Maximo Applications
• Customized the standard Actuate reports for various Maximo Applications like Item Master, Inventory, Assets, Purchasing, Contracts - Master Contracts, Purchase Contracts etc
• Extensively worked on hot fixes and bugs for existing Actuate Reports
• Developed both Parameter and Non Parameter reports for business users
• Designed different types of reports like Detail, List/Overview, Dynamic Layout and Queries
• Validated the Crystal Reports by writing queries against the transactional system
• Customized the formatting of the Crystal Report using formula's at the section level
• Customized the existing Integration Objects, Integration Points, Endpoints, Interfaces, and External Systems for integration of Inventory applications with Biz Talk
• Performed testing of Outbound Integration processing from Maximo to Biz Talk
• Troubleshoot the errors by analyzing the Maximo and MEA log files
• Monitored the JMS Queues for XML error files and resolved the errors
• Prepared the detailed test cases and technical documentations for the Integration processes

Environment: Actuate 9, Crystal Reports XI, Maximo 6.2, MEA Oracle 10/9i, PVCS, Windows, Toad, Web logic 8.0, Java, J2EE, and Eclipse

Confidential, Holtsville, NY

Programmer Analyst

Responsibilities:

• Worked with business users and prepared the functional specification documents and flowcharts for various new requirements
• Designed ten new Report Object Design(ROD) files and customized several existing templates for reports using Actuate Designer Professional and e-Spreadsheet Designer
• Developed library framework for reuse in the Actuate Reports
• Extensively used various library objects for implementing standard report features
• Tested the reports on development and production servers for complete report functionality
• Created different types of reports in Eclipse/BIRT environment including Simple Listing, Grouped Listing, Chart and Listing and Dual Column Listing and Dynamic Layout reports
• Written Packages, Procedures, SQL queries for complex and simple reports with Oracle database at the backend
• Worked on performance tuning of SQL queries and stored procedures for existing reports
• Overridden the various methods on Actuate side like Fetch Method, Obtainselectstatement method, BuildFromRow method, OnRow Method etc.
• Developed different types of reports using Actuate components like Parallel section, Dynamic Text control, Sequential section, Conditional component, Memory Data Sorter etc
• Performed administrative tasks on Actuate server like adding new users, creating testing environment for the users, scheduling the jobs, monitoring the server performance etc.
• Worked on conversion of existing Actuate reports to Crystal reports and involved in regression testing of new Crystal reports
• Prepared detailed documents for technical specifications, test cases and implementation process
• Worked on production support for all existing reports on two Actuate Servers installed on Windows
• Worked on FTP to transfer large files from UNIX server to local directories for data processing
• Implemented the newly developed reports on production server and created the schedules as per requirements
• Coordinated with offshore team during development and implementation of reports.

Environment: Actuate 9.1/8.0, Crystal Reports X, BIRT 2.2.2, Informatica 8.x, Eclipse, Java, Clarify, Oracle 8i/10g, DB2, Windows XP, UNIX, Toad, DFW, Viryanet, VSS

Confidential, Franklin Lakes, NJ

Programmer Analyst

Responsibilities:

• Designed twenty six templates for reports using Actuate Designer Professional as per the business requirements
• Developed the complex SQL Statements for all twenty six different reports
• Extensively worked on applying security settings and hyper linking functionality for a group of reports falling under Client PNL project.
• Applied security by setting Page Level Option at the design level and privileges and roles at the folder level on Management Console.
• Developed different types of reports using Actuate components like Parallel section, Sequential section, Conditional component, Memory Data Sorter etc
• Created the folder structure, roles and users on management console and applied security settings
• Developed the API’s in Java used for scheduling the reports on server
• Created the report development tables on Teradata and worked on data loading processes
• Generated server side PL/SQL scripts for data manipulation, validation and created various snapshots and materialized views for remote instances on Oracle database.
• Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data conversions.
• Override several methods of sub classed components of AFC to meet business requirements
• Created library objects for reuse among the group of twenty six reports.
• Used Unix platform to schedule the reports on server and monitored the report generation process
• Assisted other team members in customization of Active Portal as per user needs
• Provided support for Actuate Reports on production server
• Worked on Actuate Report Server administration tasks like scheduling the reports, creating new folders, users and roles as well as granting the privileges on development and production servers.
• Documented the report design development, scheduling process and Active portal customization work
• Used PVCS as a report source and version control system

Environment: Actuate 9.0/8.1, Teradata, Oracle 9i, Lawson 9.x, JAVA 5.0, JSP, UNIX, Windows XP, PVCS, SQL Assistant for Teradata, Toad

Confidential, Columbia, MD

Programmer Analyst

Responsibilities:

• Designed simple to complex reports extensively with and without stored procedures
• Worked on Actuate up-gradation process from version 6 to 8 and tested the functionality of new version with the existing complex reports
• Extensively worked on Actuate 8.0/8.1 e-Report Designer Professional with Oracle and SQL Server data sources
• Created Nested reports, Dynamic Layout reports, Drilldown Reports, Parallel, Sequential reports and Cross-tab Reports using Group, Conditional, Sequential, and Parallel sections
• Developed Reusable Components and published them into Libraries
• Used Single Input Filter, Multiple Input Filter, Memory Data Sorter, Charts and other components of eRDPro extensively
• Developed Java Scripts for validation of customized selection screens
• Worked on migration and configuration of reports in between different SQL Servers
• Extensively developed reports with internal and external hyperlinks, graphs
• Developed various database objects like Packages, Procedures, Functions, Indexes to support the reports
• Developed the scheduled reports to run on daily and monthly basis
• Maintained excellent coordination and communication with the Business Analysts and Users
• Worked on the performance tuning of stored procedures supporting the regular reports
• Designed and developed global temporary tables and permanent tables to meet reporting needs
• Prepared easy to understand and comprehensive documentation supporting all the reports developed
• Supported the reports on production by fixing the bugs, simple to complex
• Used Oracle Warehouse Builder for ETL processes

Environment: Actuate 6.0/8.1, Oracle10g, MS SQL Server 2000, Oracle Warehouse Builder, Windows 2000, MKS Source Integrity, Toad, Rapid SQL and JAVA