TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP/7/2000 Server, UNIX, Sun Solaris

BI/DW Tools: SAP Net Viewer BW 7.3/7.0, SBOP Analysis edition for MS,SAP BO BI 4.0/4.1(BI Launchpad, CMC),UDT 4.1,IDT 4.1,Dashboard(Xcelsius) designer 4.1, Web I 4.1, SAP BODS 4.0, BOXIR3.1, BOXIR2, PMDM, Actuate

Reporting Tools: BEx Designer, BEx Analyzer, CRforEnterprise, Crystal Reports 2013/2011/2008, CRXIR2, Qlikview, Actuate.

Project Management Tools: Software Design Life Cycle (SDLC), Agile, SCRUM, Joint Application Development (JAD)

Data - modeling Tools: Erwin 3.5/4.0.

Languages: Shell Scripting, C++, SQL, PL/SQL, C/C++, VBA, JAVA/J2EE, XML, UML, HTML, DHTML, UNIX

ETL Tools: SAP BO Data Services, Informatica Power Center/Power Mart 7.1/6.2/5.1

Web Technologies: MS front Page, Adobe Dreamweaver CS3.

RDBMS: ORACLE 9i/10g/11, SQL Developer 1.5.3 & TOAD, MS SQL Server 2000/2005, MS Access, Sybase12.0

PROFESSIONAL EXPERIENCE:

Confidential - New York, NY

SAP-BO Business Analyst

Environment: SAP Net Viewer BW 7.0/7.3,BEx Toolset (BEx designer, BEx Analyzer), SAP BO Data Services, SAP Business Planning & Consolidation, SAP BO BI 4.0/4.1, (CMC, BI Launchpad, IDT, Web I, Dashboard designer), SBOP Analysis for MS edition, Oracle10g

Responsibilities:

• Supervised and contributed to the Agile-based BI implementation that consisted major rollout of the client’s Salary Planning and upgradation System.
• Simulated and tested the business workflows for conducting the Proof of Concept(PoC) implementation of SAP BO Business Planning & Consolidation ( SAP BPC)
• Conducted analysis and presentation to the senior management on Enterprise Performance Management(EPM) tools required for Budgeting,Planning and Consolidation.
• Defined the KPI framework for development of Xcelsius Dashboards based on cost-center performance and salary-benefits structure of employees.
• Designed 4 SAP BW Infocubes and modified 2 Infocubes to include the desired characteristics and key figures.
• Created 2 .unx universes based on SAP Infocubes created off the OLAP connection in IDT.
• Responsible for development and testing of 18 Web I reports using BICS connector based on BEx queries.
• Resolved the BEx query hierarchy issues in 6 Webi reports using the treeview-control and break formatting.
• Designed the layout and structure of 6 Dashboards based on OLAP universe created off BEx queries.
• Designed and tested 22 BEx queries with hierarchies,hierarchy node variables, structures and calculated key figures using BEx designer and BEx Analyzer
• Modified 8 existing batch jobs and created 2 new jobs for the weekly and monthly ETL data load activity using the SAP BO Data Services(SAP BODS) developer.

Confidential - Nashville, TN

SAP-BO Senior Developer

Environment: SAP Net Viewer BW 7.0, BEx Toolset (BEx designer, BEx Analyzer), SAP BO BI 4.0, Business Objects Enterprise XIR3.1 (CMC, CCM, CMS, Designer, Desk I, Web I, Xcelsius 2008), Oracle 10g and 11iResponsibilities:

• Lead the team of Business Objects developers and liaised with the Business User group to finalize the business requirement and convert into technical specification by authoring the System Requirements Specification document.
• Accountable for timely delivery of Business Objects reports as per best practices for coding and development activities outlined by the company policies.
• Designed 3 complex .unx universes based on Financial, Sales and Marketing activity using Information Design Tool (IDT 4.0) and converted 5 .unv universes from BOE XI 3.1 to IDT .unx files.
• Resolved object qualification errors, custom SQL errors and object security issues in the 5 .unx universes that were converted from .unv format
• Created 2 OLAP universes based on SAP BW Infocubes and resolved the issue of flattened hierarchy by defining a custom hierarchy Confidential universe-end
• Designed 12 Web I reports using calculations, variables, breaks, sorting, filters, alerts and prompts
• Designed 18 BEx queries in the BEx designer based on Sales metrics and region-wide distribution of dealer supply-chain.
• Created 4 KPI dashboards for forecasting and analysis of the Sales performance for the sales representatives.
• Managed the universe development life cycle between Dev,QA and production environmnets.

Confidential - Middletown, NJ

Sr. Business Objects Administrator

Environment: Business Objects Enterprise XIR3.1 (CMC, CCM, CMS, Designer, Desk I, Web I), XIR4.0, Qlikview,Oracle10g, Xcelsius 2008, Microsoft SQL Server 2000/2005/2008, Netezza, SAP BW (OLAP/MOLAP), Apache Tomcat and TOAD and Windows 2000 Server.

Responsibilities:

• Supervised the team of Business Objects Report Developers who developed reports for time sensitive releases.
• Install, Maintain and Trouble shoot the Business Objects Enterprise Servers.
• Responsible for 24/7 call support line for Management reporting and Production Management tickets.
• Designed 12 complex Universesfor 5 different programs such as Auditing, Marketing, Finance, Investments and Insurance.
• Trained and created Super User documentations and best practices for administrators and developers to use for various departments.
• Defined hierarchies in BOBJ to provide the users with drill down option and predefined conditions within reports.
• Designed and recommended changes to the datawarehouse schema’s as needed along with implementing security features to secure data.
• Develop the Stored procedures and Views to be able to customize the report according to specifications.
• Responsible for synchronizing Reports, Folders, User Security on Dev, UAT and Pre Prod environments with Production Environment
• Responsible to work with Business Program Managers and Power Users to finalize any reports requirements.
• Designed, Developed and Implemented 75 plus reports for 3 departments on Production
• Interacted with the Multiple Program Managers to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.
• Worked with Performance Manager to go beyond basic Dash boarding to provide advanced goal management and score carding capabilities, as well as guided analysis of metrics.
• Implemented 20 plus new internal security groups and folder structure to handle security for 5 different programs
• Converted 200 plus Deski reports to Webi using Report Converstion Tool and fixed all the migrations issues.
• Extensively worked on Classes, Objects Loops, Fan Traps, Chasm Traps, Cardinalities, Contexts, Aliases, Derived Tables, Hierarchy, Conditions, Drilling functionalities, Sectioning, Ranking, Filtering, Queries, Slice and Dice, Drill down, Prompts, Functions, Formulae, Complex filters, Alerter, Merge Dimensions, User Defined Objects (UDO), multiple Data Providers, Ranking, Local Variables, LOV’s, @Functions.

Confidential - OWINGS MILLS, MD

Sr. Business Objects /Crystal reports Developer

Environment: Business Objects XIR2 (CMC, CMS, Designer, DESKI), 6.1/6.5.1 (Supervisor, Designer, Reporter), Web Intelligence, Desktop Intelligence, Info View, Toad 9.0, Import Wizard, Conversion Tool, 3-Tier BO, Broad Cast Agent (BCA), Crystal Reports 2008, Xcelsius 4/5, Oracle 9.1,qlikview Teradata V2R6.0, SAP BW (OLAP/MOLAP), Microsoft SQL Server 2000/2005, Windows 2000/XP Server Universe Design and Migration BO6.5.1 to BOXIR2:

Responsibilities:

• Hosted Weekly & Monthly Project planning sessions with Project Managers, Business Analysts and team
• Members to analyze business requirements and outline the proposed solution.
• Worked on Installation and Configuration of Business Objects XIR2 Enterprise Suite in the development environment.
• Extensively worked on Joins, Universe Prompts, Loops, Fan Traps, Chasm Traps, Cardinalities, Contexts, Aliases, @Functions, Derived Tables, Hierarchy, Conditions, Drilling functionalities, Sectioning, Ranking, Filtering, Queries, Slice and Dice, Drill down, Prompts, Functions, Complex Formulae, Complex filters, Global Filters, Alerters, Merge Dimensions, User Defined Objects (UDO), Multiple Data Providers, Ranking, Local Variables and Customized LOV’s,
• Involved in migration from existing 6.5/ 6.5.1 systems to BO XIR2 in Development Environment.
• Migrated Users/Groups, documents (Web I and Desk I), Universe, Document, and folders and objects using Import Wizard.
• Added/deleted, enabled/disabled various BO servers using Central Configuration Manager.
• Created users/ groups and defined their roles and set privileges using the CMC.
• Used the schedule manager to schedule reports in the Web I module of XIR2.
• Interacted with Business Users to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Reports.
• Installed & Configured Business Objects Enterprise XIR2 on Windows 2000 server and created Repository.
• Worked in the development team on the new change requests, fixing defects in Business Objects reports and enhancements from the business.
• Created new reports using both Desk I and Web I in Business Objects XIR2 and validated the reports.
• Converted .rep reports to .wid reports using the report conversion tool.
• Involved in building, Testing and Tuning Simple and Complex Full Client and Thin Client Reports.
• Worked with Complex filters, alerters and user defined objects (UDO).
• Created reports in Web I from multiple data providers and synchronized the data using the merge dimensions feature.
• Worked as a team in developing business objects Crystal XCelsius Dashboards.
• Exported business object reports to Web Intelligence 6.5.1 to be viewed by all users on the Internet.
• Worked on Microsoft and Business Objects Interoperability using SharePoint and Business Objects XI Portal Integration Kit thus helping to View and Manage Information within a Single Interface.
• Also used different data sources like free-hand sql, personal data files creation of various reports.

Confidential - NYC, NY

Business Objects Designer

Environment: Business Objects 5.1/6.5, Oracle 9i, MS Access, SQL, Toad, WEBI 6.5.1, Broadcast Agent, Business Objects 5.1.4 (Supervisor, Designer, Reporter), Web Intelligence 2.x (ZABO, Broad Cast Agent), Broadcast Agent, Oracle 9i, PL/SQL, SQL Windows NT.

Responsibilities:

• Involved in production Support and giving training to the users.
• Involved in migration from Business Objects 5.1 to Business Objects 6.5
• Involved in creating repository and setting up of groups and users for BO users.
• Exporting the Reports to the Broadcast Agent and Used the Broadcast Agent to Schedule, Monitor and Refresh the Reports.
• Upgraded Business Objects universes and reports from version 5.1 to version 6.5.
• Constantly worked with Business Users to gather, analyze and record requirements / specifications.
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae’s etc.
• Resolved loops, chasm traps and fan traps using contexts, aliases and integrity checks.
• Maintained and modified existing universes by creating the Business Objects data model, selecting/joining tables, indicating cardinalities, created aliases, contexts to resolve the loops, used aggregate aware function and created the objects which are grouped into classes based on Business Functionality.
• Used various join methods like Equi-join, Theta-join, Outer-join in designing the universes.
• Involved in building, Testing and Tuning Simple and Complex Full Client and Thin Client Reports using Business Objects functionalities like Filters, Sorting, Ranking, Alerts, Queries, Slice and Drill down, Prompts, Functions, Formulae and multiple Data Providers.
• Created Master Detail and Cross Tab reports.
• Worked on the Master, Kernel and Component approach during the linking of universes.
• Scheduling reports from the Broadcast Agent Server to only requested users.
• Created Web Intelligence documents and published them to corporate documents.

Confidential - SFO, CA

Sr. Business Objects /Crystal Reports Developer

Environment: Business Objects XI3.1/XI R2, Business Objects Universe Designer, Infoview, WEBi, Import Wizard, Crystal Xcelsius, Live Office, QAAWS, SAP BW, SAP BI 7.0, SAP Netweaver, SAP Front End, SAP Integration tool kit for BO, SAP Business Explorer (BEx Query designer, BEx analyzer), Life Cycle Manager, Central Management Console, Informatica Power Center, Oracle10g, PL/SQL, SQL Server 2005, Windows, Unix.

Responsibilities:

• Worked with Crystal Report XI for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Scheduled crystal reports and Implemented dynamic cascading prompts
• Designed crystal reports with dynamic content & Custom UI.
• Designed Universes based on the data marts existed in the Data warehouse and to be used them as a source for the reports.
• Created BEx Querries and customized with variables and filters Confidential webI level.
• Created WebI reports as well as Deski reports from OLAP universes those were built from SAP BW data.
• Installed and configured SAP Front end tool and Integration kit on my machine.
• Exported universes, reports and dashboards from one environment to other using Import wizard and Life cycle manager.
• Created few reports and presentations using SAP Business Objects Advanced Analytics 1.0 tool.
• Involved in KPI meeting discussions and prepared the KPI matrix as per as the client requirements.
• Created Dashboards using Xcelsius with Live office and QAAWS and used most of the components.
• Created Dashboards to monitor business performance, insightful analytics, and role based dashboards with Crystal Xcelsius.
• Involved in the migration of Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing).
• Customized reports by adding prompts, Filters, Calculations, Summaries and Functions.
• Created custom List of Values (LOVs) for better understanding of prompts by the end user.
• Created complex variables, breaks, sorts, filter and conditions for various reports in Business Objects XI 3.1 environment.
• Support the quality assurance/quality control process for CTDN data.
• Responsible for service level Metrics
• Develop a Business Objects Universe for a portfolio management tool.
• Created complex reports involving for the development of Drill reports, master-detail Reports, Linked reports and cross-tab reports.
• Implemented Row Level Security on Business Objects documents.
• Managed Users, Groups and their access privileges on the Universe and Report documents stored in central Repository database.
• Develop and publish new reporting solutions according to specifications identified and approved by the IT business
• Did Performance tuning of the reports, optimization of queries and fixing data issues in the developed reports.
• Develop, deploy and maintain reporting operations using the Business Objects Reporting Java SDK.
• Worked on Informatica Power center while tuning and to resolve data issues of the BO reports performance and data loading.
• Written PL/SQL stored Procedures and Functions to capture the changed records in the source systems and loading them into EDW using TYPE 2 Slowly Changing Methodology.

Confidential - ATLANTA,GA.

Business Intelligence /Crystal Reports Developer

Environment: Business Objects Enterprise XI/R1/R2/R3/R3.1 (CMC, CCM, CMS, Designer, Desk I, Web I), Business Objects 6.5 (Supervisor, Designer, Reporter), Web Intelligence 6.5, Info View, Enterprise Performance Manager (EPM), SQL, PL/SQL,Oracle 9i/10g, Crystal Reports 2008, Xcelsius 4/5/2008, Teradata V2R6.1, Microsoft SQL Server 2000/2005/2008, SAP BW (OLAP/MOLAP), Apache Tomcat and TOAD and Windows 2000 Server.

Responsibilities:

• Participated in Project planning sessions with Project Managers, Business Analysts and team members to analyze business requirements and translate these to Technical Specifications for Universes and Business Object Reports development.
• Developed BO Training Manuals for conducting Training Sessions for Internal Program Managers, External Vendors and Auditors.
• Installed & Configured Business Objects Enterprise 6x/XI/R2/R3.1 and created Repository and synchronize the QA, DEV environments with Production on every release and upgrade.
• Converted Full client documents to Web I documents using Report Conversion Tool.
• Responsible to Maintain and Migrate Universe & Reports on Dev, Test, Pre-Prod and Production.
• Lead BO and Crystal Reports Developer team on developing reports, bug tracking, as well as documenting Sign-Offs from Business during every release.
• Managed advanced User Access restrictions using Central Management Console (CMC).
• Defined LDAP Groups using Tivoli security and Enterprise groups to manage Internal and External user security.
• Implemented Vendor security Confidential Universe & report level, in order to simplify the security on CMC.
• Implemented “Single Sign on” on application portal to support Web I report access on company portal.
• Designed and Implemented Security Features such as row level, object level and report level to make output data secure.
• Assisted in developing data models, as well as logical and physical database designs.
• Accessed multiple data sources including Oracle, SAS, Teradata, Web services, and XML using Data Federator.
• Responsible for discussing with business to finalize changes with Application Enhancements and New reports during release.
• Created around 12+ Universes to support 8 new programs on Gas and Electric business.
• Extensively worked on Classes, Objects, Joins, Universe Prompts, Loops, Integrity Check, Fan Traps, Chasm Traps, Cardinalities, Contexts, Aliases, @Functions, @Select, @Prompt, @Where, Derived Tables, Hierarchy, Conditions, Drilling functionalities, Sectioning, Ranking, Filtering, Queries, Slice and Dice, Drill down, Prompts, Functions, Complex Formulae, Complex filters, Global Filters, Alerters, Merge Dimensions, User Defined Objects (UDO), Multiple Data Providers, Ranking, Local Variables and Customized LOV’s,
• Responsible for Universe & Report Testing, Query Optimization, and Performance Tuning during upgrade.
• Created 200 + complex reports using the multiple data providers, multiple prompts and synchronized the data security to create common report for different program users and vendors.
• Created reports to visually represent data using Xcelsius 4/5/2008.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.

Confidential

Crystal Reports Developer

Environment: Crystal Reports XI R1 and R2, Informatica Power Center, Oracle 8i, Windows 2000/XP,Sun Solaris 2.8 (Unix).

Responsibilities:

• Interacted with the Business Users to analyze the business process and gather requirements
• Designed and developed Universes by defining joins, cardinalities between tables, linked the existing Universes using Business Objects.
• Developed Crystal Reports in the form of Master/Detail reports, Cross Tab reports, Sub reports and Charts based on Universes, freehand SQL and Stored Procedure as data sources.
• Created complex reports with formulas and conditional formatting using multiple queries.
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements. Build and test universes and reports catered to end user requests.
• Associate with ETL team to build a data warehouse environment and provide constant updates about the necessary changes required.