SUMMARY

• 9 years of Data warehousing and Business Intelligence experience using Actuate eRD Professional, SAP Business Objects XI Enterprise suite (4.0, XIR3.1, XIR2, Xcelsius 2008, Crystal 2011, 2008) using Desktop Intelligence, Designer, Web Intelligence reporting.
• Extensive Knowledge in all phases of Software Development Life Cycle (SDLC) (Waterfall & Agile/Scrum) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like Windows NT/2000/XP/98.
• Extensive database architecture and design skills working on high performance solutions.
• Expertise in Actuate eRD Professional 11.x, 9.x, 8.x, 7.x.
• Experience in Configuration, Monitoring and Management of Actuate and Cognos BI tools on Windows platforms.
• Good experience with SAP BI 4.0 in building efficient and user oriented universes using Designer, IDT (UNX), retrieving data using Universes, Personal Data files, Free Hand SQL Methods and creating adhoc and canned reports using BI Launch Pad, Web Intelligence 4.0.
• Expert in writing canned reports, complex ad - hoc reports using SAP BOBJ Desktop Intelligence (DESKI), Web Intelligence (WEBI), Designer, Import Wizard, Web Intelligence Rich Client, QaaWS, Publishing Wizard, BI Web Services, BI Widgets, Business View Manager tools and profound knowledge on working with Crystal Reports.
• Strong experience in creating Ad-hoc queries, List Reports, Cross-tab Reports, Standard Reports, Dashboard Metrics, Chart Reports, Map Reports, Financial Reports & Repeater Table using Query Studio, Report Studio & Analysis Studio containing functionality such as conditional formatting, prompts, bursting and drill-through.
• Experience in migrating and converting DeskI reports into WebI reports/ Crystal Reports.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drill Down, Filters, Ranking, Sections, Graphs and Breaks.
• Experience with Central Configuration Manager (CCM) and Central Management console (CMC).
• Implemented and migrated XI Release 2 reports/ 6.5 Reports to XI Release 3.1 environment.
• Implemented Live Office, Created performance Dashboards (Xcelsius and Dashboard manager) and scorecards across multiple domains in XI R2 and R3.1.
• Experience with Oracle and SQL Server, in writing, testing and implementation of PL/SQL, stored procedures, and functions at Database level.
• Experience on Data Modeling techniques employing normalization and Data warehousing concepts like Star/Snowflake schema modeling.
• Proven analytical capabilities in understanding and delivering solutions to meet end-user needs.
• High degree of proficiency in gathering user specifications from business users and preparing detailed user specification documents.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. User oriented with a strong desire to learn client's business requirements and processes.

TECHNICAL SKILLS

BI Tools: Actuate eRD Professional, Actuate Management Console, Actuate Report iServer, Actuate iPortal, SAP Business Objects 4.0/XI R2/R3.1/6.1/5.1 (IDT, Universe Designer, BI Launch Pad, DESKI & WEBI), BO Explorer, BO CMC, Business View Manager, Upgrade Management Tool, Crystal Reports 2011/2008/9/8.5/8.0, SAP BI 7.0, Dashboards/Xcelsius 2008, Cognos 8.x Business Intelligence Platform

RDBMS: MS SQL Server 7.0/2000/2005/2008, IBM DB2, Oracle 11g/10g/9i/8.x

Languages: Java, C, Visual Basic, Cognos Scripting Language, JSP, ASP, CGI, VB Script, SQL, PL/SQL, HTML, XML

Operating Systems: Windows XP/NT/2000/2003 Server

Web servers: IIS 5.0/6.0, WAS 7.0, APACHE-TOMCAT

Data Modeling: Star-Schema Modeling, Dimensional Modeling, Snowflakes Modeling

Source Control: Tortoise SVN

Testing Tools: HP Quality Center 11.x, Test Director, Test Manager, Rational Robot

Project Management: MS Project, MS Access, MS Visio and MS Excel

PROFESSIONAL EXPERIENCE

Confidential, Fort Wayne, IN

Business Intelligence Report Developer

Responsibilities:

• Understanding Business requirements for reports and preparing documentation based on the requirement.
• Design and develop technical documents, design specifications, project follow up and status with other team members.
• Developed Report templates and libraries for reusability
• Extensively worked with new designer tool IDT 4.0 using Projects/Shared Projects, Data Foundation, Business Layer and Security Profiles.
• Detected/resolved data Cardinalities and loops, checked integrity of ‘Data Foundation’s in ‘Information Design Tool’.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users.
• Based on User request, disabled LOVs & maintained Date format for some specific Time Change Objects.
• Maintained Business Layer with multi Data Foundations by using Advanced Parameter option & created folders based on User requirements.
• Created complex Condition Objects for easy reporting, Aggregate-Aware and Index Aware objects for better performance.
• Defined hierarchies and created drill down reports through to the most granular level for Data analysis.
• Created complex WebI reports by linking objects from different data providers and using Merge Dimension Option.
• Implemented various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select to filter the data as well as to improve performance.
• Created different types of reports such as Master/Detail, Cross Tab and Chart, use of Filters, use of Alerters, Conditions, and Calculations
• Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc. Used breaks for white spaces and sections for better navigability.
• Involved in implementing Folder level security in BI Launch Pad and Implemented Row Level and Column Level Security as per user roles with BO Admin.
• Involved in performance tuning of XIR4 WebI reports.
• Participated in review of Existing universes and their modifications to meet the user reporting requirements.
• Linked reports using Open Document Syntax to link master report to detail report by creating hyperlink objects in the Universes and Reports.
• Extensively worked with CMC (Central Management Console) in implementing various levels of security for users and user groups.
• Extensively involved in providing gap analysis between the existing legacy system and current ODS to help the core management team to take decisions for better Business Intelligence Solutions.
• Involved in the conversion of Clients DeskI/Crystal Reports into WebI Reports.
• Involved in the conversion of multiple DeskI reports into Crystal Reports.
• Involved in the creation multiple Crystal reports.
• Involved in performance tuning of Crystal reports.
• Involved in upgrade of the Client’s Crystal reports from an earlier version 2008 to the current version of Crystal 2011.
• Creation of formulas, filters, parameters, alerts, running totals, cascading prompts in crystal reports.
• Using of static and dynamic parameters.
• Creation of reports with Bar Charts, Line Charts, Cross tab reports.
• Creation of complex reports which includeSub Reports, Complex Formulas.
• Used several functionalities of crystal reports such asSection Expert, Record Sort Expert, Group Expert to sort and group the record data.
• Created multiple Universes using ‘Derived’ tables concept and created Crystal Reports using the same Universe.
• Designing and implementing Actuate Standard Development Framework.
• Database modeling, writing stored procedures and queries as per business requirements.
• Designing and development of 60+ reports, granting server access permissions to the clients.
• Customized Actuate Reporting portal for the End Users.
• Fine tuning of queries extensively to increase the performance of the reports.
• Proper planning of Actuate roles, Page Level Security report development.
• Involved in administration tasks such controlling user access, scheduling reports and events.
• Scheduled different reports to run at periodic intervals of time.
• Involved in the implementation of Actuate RSSE frame work.
• Developed Actuate class(s) to submit jobs and to convert reports (.roi) into PDF and Excel formats.
• Involved in various testing phases during Development, QA, UAT, Pre-PROD.
• Developed web interface for Users to call the filter the parameters and execute reports.
• Involved in upgrade of the Client’s Actuate reports from an earlier version 9.3 to the current version of Actuate 11.
• Worked as Tech Lead for certain mini projects (Fast Track work).
• Involved in Production Support activities.
• Involved in users training, providing technical support and resolved issues like bug fixing.

Environment: Actuate eRD Pro 8.x, 9.3, 11; Actuate iPortal, WAS 6.x, 7.x, Oracle 10G, 11G, IBM DB2, TOAD, SAP Business Objects 4.0 (R4) & XI R3.1, Business Objects Data Services 4.0/3.2, Crystal Reports 2011 & 2008

Confidential, Columbus, OH

Lead BO Designer /Report Developer

Responsibilities:

• Involved in gathering business requirements, functional requirements & data specifications.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the Reporting needs.
• Written Stored Procedures and Views, to extract data based on the Business requirement with Oracle 9i/10g as the backend.
• Responsible for Designing Universe in Business Object XIR2 to get the Data from different sites in order to make the transactions to be Global.
• Converted Clients DeskI reports into WebI reports as part of ‘Web’ project.
• Extensively worked on performance issues on the Universe and the WebI Reports.
• Implemented aggregate awareness, created cascading prompts to make Reports confined to a particular case as per business requirement.
• Implemented various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select to filter the data as well as to improve performance.
• Generated sub Reports, linked and unlinked Reports, Reports on demand.
• Resolved Loops and Traps using the functionality of Aliases and Contexts.
• Performed Server Management tasks (with the help of BI Admin) using Central Configuration Manager (CCM) and Central Management Console).
• Created complex reports by linking data from Multiple Data Providers, using Free Hand SQL and functionalities like Combined Queries.
• Involved in testing the code and analyzing the report based on the clients specifications and moved the entire code into UAT and then into Production with no errors.
• Involved in tuning Complex SQL and Pl/SQL using Explain Plan and Hints.
• Responsible for creating scorecards using performance manager.
• Worked with ETL Development Team for extracting data from Legacy system, perform Transformations as per the requirement and Load the data into existing Oracle DB.
• Database modeling, writing stored procedures and queries as per business requirements.

Environment: Business Objects XIR2 (DeskI, WebI), BO XIR2 SDK Dashboard Builder, Performance manager, Informatica 7.x, Erwin Data modeling, Oracle 10g

Confidential, Charlotte, NC

Business Objects Developer

Responsibilities:

• Interacting with Business Users and Business Analysts to understand and document the requirements and Built Universes for end user reports generation using Business Object 6.5 designer.
• Worked with universes and Free Hand SQL as the main data providers.
• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompts and Drill filters.
• Created Classes, sub classes, Dimension objects, Measure objects in multiple universes, Check the Integrity of the Universes and exported the Universes to Repository for making available to users.
• Resolved Loops and Traps using the functionality of Aliases and Contexts.
• Used the Slice and Dice feature, set variables, alerts and group values in the reports.
• Used the Drill Down/Up function to analyze data and created multiple charts in Reports.
• Created, managed and formatted standard reports, master/detail reports and cross tab reports using Report Manager.
• Created Report Templates for consistency in the look and feel of the reports.
• Created reports using Web Intelligence and published reports using Broadcast Agent Publisher.
• Created formulas as variables, so that variables can be used for different purposes.

Environment: Business Objects 6.1, WebI 2.7, Oracle 9i, PL/SQL, DB2, MS- Access, Lotus Notes 6.5, UNIX (AIX 5.2)

Confidential, NJ

Crystal Reports Developer

Responsibilities:

• Connecting to the backend of Oracle database using thedatabase expertin the Crystal Reports.
• Creation of joins between the tables according to the requirement.
• Creation of formulas, filters, parameters, alerts, running totals, cascading prompts in crystal reports.
• Using of static and dynamic parameters.
• Creation of reports with Bar Charts, Line Charts, Cross tab reports.
• Creation of complex reports which includeSub Reports, Complex Formulas.
• Writing of theSQL Commands, Stored Procedures and Viewsand using them as the data sources in the front end ofCrystal Reports.
• Used several functionalities of crystal reports such asSection Expert, Record Sort Expert, Group Expert to sort and group the record data.
• Involved in performance tuning of various Crystal reports.
• Validating of Reports data by running the SQL queries in the backend database and making sure the data is as expected.
• Involved in Analyzing, Developing, Implementation & testing phases in the project.
• Involved in presentations and project documentation.

Environment: Crystal Reports XI, Oracle 9i, PL/SQL, Windows XP