PROFESSIONAL SUMMARY

• Experience with Industry for over 7 + years on SAP BI, Business Objects, OBIEE and R/3 with experience in deployment and developing business processes and system solutions for Financial, Pharmacy, Retail, Manufacturing verticals.
• Experience in Business Objects XI 4.0/R3/R2/R1/6.5/6.1/6.0/5.1,CMC, Designer, Info view, Web - Intelligence XI/6.0/2.7,Supervisor, Auditor, Application Foundation Dashboard Manager, Application Foundation 6.0/2.5 & Dashboard Manager, Business Objects Reporting, Business Objects SDK, Web-me SDK, OLAP, OLTP, Broadcast Agent, Publisher.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
• Expertise in working Crystal Decisions, Crystal Reports 7.0/8.0/9.0/10/XI/XIR2, Crystal Xcelsius.
• Worked in ETL with Different Versions of SAP Data Services Including BODS 4.0.
• Worked extensively with Data migration, Data marts, Data cleansing, Data profiling, ETL processes, Data mining, Data audits and Web reporting features for data warehouses.
• Creating Scripts, Jobs, Workflows, Data Flows and Executing jobs with Data Integrator Designer.
• Loading Data into Target using flat files and from database tables used as source files.
• Expert in tuning teh performance of SQL queries and ETL process.
• Expertise in Universe designing, developing and generating Complex Reports, Adhoc Reports, Dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Worked with Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based reports, drilling reports, analysis reports, data reports along with LOV.
• Working Experience on creating dashboards using Crystal Xcelsius 2008/4.5/3.0 by importing data file to create teh visualization utilizing QAAWS.
• Expertise creating Executive dashboards for teh upper management showing summary metrics for teh Key performance Indicators (KPI’s).
• Experience in creating mobile reports and dashboards for teh Ipad and android.
• Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc.
• Proficient and sound noledge with Planning, Multidimensional data modeling using extended star schema, Design Implementation, and User Training of SAP Business Information Warehouse.
• Trained Users in report development and running ad-hoc queries in business objects.
• Creating, Developing, distributing, migrating and modifying Universes in Business Objects.
• Migrated Business Objects environment from Business Objects Enterprise 6.1 to XIR2 and also from XIR2 to XIR3

TECHNICAL SKILLS

Operating Systems: Windows 95/ 98/ 2000/ 2003/ XP/ NT, DOS, Unix.

Programming Languages: C, C++, VB, Java and C #.

Web Technologies: HTML, XML, XSLT, DHTML, SOAP, UDDI, and XSD.

Script Languages: Java Script, VB Script, and AJAX.

SAP Tools: BI 7, BW 3.5 and BPC 4.7, Business Objects XI/6.x/5.x (Supervisor, Designer, Business Objects, Web Intelligence 2.x/6.x/XI, Broadcast Agent, BO SDK, Webi SDK, Business Miner, Info view 1.0), SAP SPM, Crystal Reports, SQR, Desktop Intelligence, Info View, Broadcast Agent, and CMC.

SAP R/3: SAP ECC 6.0, 4.6C, 4.7, Modules: FI-CO, MM, SD, and APO

Packages: Microsoft Project, MS-Word, MS-Excel and MS-PowerPoint.

Databases: Oracle, DB2, MS SQL Server 2000/2005/2008,Teradata, Sybase, MS Access, SAP HANA 1x.

Version Control Tools: Microsoft Visual Source Safe, Clear Case, Clear Quest.

ETL Tools: Informatica1.7 to 7.1, Data Stage, AbInitio

Reporting Tools: Crystl Reports, SQL Reporting Services, Active Reports.

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

Sr. SAP Business Objects Developer

Responsibilities

• Worked closely with business to help them come up with their desired visualizations.
• Architected and developed teh dashboard. Worked with teh team on teh type of data sets to create in order to feed into teh dashboards.
• Responsible to provide signoff for transition from implementation partner and provide reverse KT to client.
• Involved in teh Designing of dashboards using QWAAS, BIWS & BICS connections to generate dashboards for Live Data.
• Developed Innovative mobile reports and dashboards according to teh users requirement with row level security.
• Developed .unxfile using 3 layer architecture (.cns,.dfx,.blx) stored in Project with IDT tool.
• CreatedSecured (.cnx) connectioninIDT(Information Design Tool)
• DesignedData Foundation (.dfx)using multiple data sources using IDT.
• Involved in installation and configuration of BO Enterprise XI 4.0 components, BI LaunchPad, Dashboard Designer, Crystal Reports for Enterprise, Live Office, Interactive Analysis, Advanced Analysis for Microsoft office.
• Created universes for supporting teh new External Customer Reporting requirements.
• Created SAP Bex Queries exclusively for building Dash Boards according Business user Requirements.
• Added teh classes and objects in teh universe as and when necessary for teh new reports.
• Extensively used teh Sections, Breaks, Hyperlink and Alignments of teh objects in teh reports to match teh business reporting templates.
• Created Derived tables in teh universe to come up with complex data set that was required for complex reports.
• Created many complex canned reports with multiple data providers but showing all teh data in one table by merging teh common dimensions between teh data providers.
• Created Complex and Multi Dimensional reports using Master/Detail, Cross Tab, Slice and Dice, and Sub Queries.
• Developed reports using combined queries with UNION functionality.
• Created complex formulae in teh Web me report to dynamically change teh column that need to be displayed in teh table depending on teh prompt values.
• Used advanced functionalities like Optional prompts, Hyper-linking. Used one query data element as filter in another query to get teh respective data.
• Tested teh report data by comparing with teh data from teh report with teh SQL outputs from teh database to ensure teh quality of reports generated.
• Designed Test cases for SIT and UAT of Universe and Throughput Variance Reports for end users.
• Ensured teh quality and timely delivery of all teh important complex canned reports.
• Involved in migration and testing of Objects to PROD environment from DEV through QA environment using Import Wizard.

Environment: SAP Business Objects Enterprises 4.0, XI3 Suite (Central Management Server, Central Management Console), Designer, BI launch pad, Reporter, Unit Test, Crystal Report, Web me, dashboard designer Bex Analyzer, BICS, BIWS .

Confidential, Newark, NJ

Sr.Business Objects Developer

Responsibilities

• Understanding teh business requirements of teh client and preparing teh technical and functional specification documents.
• Acting as a bridge between offshore development teams and client to address and teh issues and methodology to follow for root cause analysis.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about teh financial system for Business Objects Universes and Reports.
• Provided technical documents and updated with recent changes and test cases.
• Managed Security for various reports and Universe in teh Development, Test, Stage and Prod Environments using Central Management Console (CMC).
• Installed teh data cleansing package after teh installation of teh BODS on Linux server as well as on BODS client machine.
• Created teh Data cleansing package and seeded all 13 dictionaries into teh repository and configured teh data cleansing repository to use all data cleanse transformations.
• Managed user rights for BO Applications like Web Intelligence, Designer for Different Group Users in teh Central Configuration Manager.
• Migrated users/groups, Universes, Reports, Access Level From one environment to other using Import Wizard and Life Cycle Manager (LCM)
• Created detailed reports with Drill-down capability using Interactive Analysis, worked on Ad hoc Query, Reporting, and Analysis.
• Created multi-layered dashboards for Finance and Accounting, Sales, Merchandizing and Marketing and Operations.
• Generated WEBI reports with Universes created in Business objects Designer as teh data providers with various functionalities that displayed data even in a graphical Format.
• Extensively worked with teh performance issues at Query Level and Report level by Creating Prompts, Creating derived tables and also making teh customized Query to teh Report generated Query.
• Responsible for optimization of Report queries, designed complex formulated metric objects with aggregate awareness; defined contexts for different aggregate fact tables; defined cascading prompts, created predefined filters, created user defined objects and built custom dynamic LOVS.
• Developed Web Intelligence and InfoView with advanced features like drill down and drill filters.
• Created Web Intelligence documents and published them to corporate documents to share teh resources between teh user communities.
• Created New Universes and modified teh existing Universes and used @functions like @select, @where and @prompt in teh process of building teh universes.
• Created different types of complex reports such as Master/Detail, Cross Tab and Charts.
• Responsible for creating teh Complex Crystal Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports).
• Worked extensively with Xcelsius 2008 and created innovative Dashboards for teh existing Summary level Reports using QAAWS.

Environment: SAP ECC 6.0, SAP BI 7.2,Business Objects Enterprises 4.0, XI3 Suite (Central Management Server, Central Management Console, Import Wizard), Designer,DB2, Info-View, Reporter, Unit Test, Crystal Report, Web me, Xcelsius,QAAWS, Teradata, SDK .

Confidential, SC

Business Objects Developer

Responsibilities

• Designed and implemented oracle based security in Business Objects
• Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL
• Created Custom Hierarchies for several groups
• Was involved in Star Schema customization / Design session
• Oversee daily activities of teh project SDLC process and coordinate activities of team members, ensuring that module goals are met within predetermined time frames. Provide teh first level support to approximately seven groups
• Design and develop teh best practices
• Re-define teh security in XI R2 and implemented teh best security model in XI R2 using new security features
• Optimized teh XI R2 system performance by fine tuning teh XI R2 servers
• Implemented teh minimal customizations of Info View in XI R2
• Co-ordinate with MSI team on Business Objects full client deployment
• Developed reports in Desktop Intelligence & Web Intelligence XIR2
• Participated in designing teh Oracle to Business Objects XI R2 Security Bridge.
• Wrote a full functional specification document for teh security to be implemented in Business Objects XI R2.
• Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius
• Developed General Ledger and Accounts receivable universes using Designer 6.5.
• Developed reports in Web Intelligence. Created complex Universes and report for GL, AP and AR
• Customized Rapid Marts of PeopleSoft GL, AP and AR
• Designed and Developed Xcelsius dashboards / analytics and exported to several formats
• In Xcelsius used single value, selector, mapped, chart, background, collaboration and text components
• Migrated repositories from Development, System Test, Performance Test, UAT, Production, SLA and to Disaster Recovery using migration tool by creating BIAR files and moved it to teh Destination System
• Performed ETL tasks using SSIS (SQL Server Integration Services)
• Help client to deploy Business Objects XI 2.0 on 7 different environments (Development, System Test, Performance Test, UAT, Production, SLA, Disaster Recovery)
• Created KPI visualization for teh client dashboard using Live data (Query As a Web Service) which address teh performance of teh LOB at teh Organization Level
• Used Data Integrator to Import data from various sources into data warehouse

Environment: Business Objects Enterprises XI3 Suite (Desktop Intelligence, Central Management Server, Central Management Console, Import Wizard), Supervisor, Xcelsius, Designer, Reporter, Unit Test, Crystal Report, Web me, Teradata, SDK, Embarcadero DB artisan, UNIX.

Confidential, New York, New York

Business Objects Developer

Responsibilities

• System study, interaction with users, management and designing, coding, testing & implementation of teh system.
• Involved in gathering user requirements.
• Designing, creating, enhancing, testing BO universe, reports.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports using Business Objects Full Client application.
• System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of teh system.
• Designed Test cases for UAT of Reports for end users.
• Created teh full client and Webi reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Used aggregate awareness in universes and Created Reports employing functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.,
• Worked with teh end users to create extensive use cases for teh dashboards.
• Tuned teh reports for better performance using SQL.
• Designed templates for Webi documents and customized Webi Front Page.
• Involved in Business Objects 6.5 Broadcast Agent and Supervisor.
• Mentored other IT staff & Conducted Corporate training for end users on Business Objects XI.
• Linked Webi reports for different hierarchies.

Environment: Business Objects XIr2/6.5, Web Intelligence, Informatica, ZABO, Desktop Intelligence, Unit Test, CMC, Broadcast Agent Server, TOAD, Oracle 10g, Xcelsius, WEBI SDK.

Confidential, Cincinnati, Ohio

Reports Developer

Responsibilities

• Created Report templates, Summary Reports, Parameterized Reports and Cross-tab reports.
• Used Groups, formulas, running totals and summaries in teh reports.
• Building Relationships between different tables according to requirements in database expert.
• Used Reference cursors, Unions, Joins extensively in Stored Procedures.
• Resolved teh Performance issues/Data issues with Reports and Procedures.
• Worked with different universes and used linking of different universes.
• Implemented different level of hierarchies for drill down reports.
• Involved in teh complete Data Warehouse design process.
• Analyzed Data using Slice and Dice and Drill Mode etc and formatting Reports.
• Automated document Scheduling, Publishing and Distribution for Web me and Info view clients, using teh Broadcast Agent for Web-Part Reports
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc.
• Used various Functions like @Prompt, @Where, and @Select.
• Created customized existing reports using cross-tab reports, sub-reports and charts to present information
• Exported Reports into PDF and Excel from Enterprise and resolved formatting issues.
• Used Configuration Manager to configure teh server settings and to start/stop teh services.

Environment: Business Objects 6.1(Supervisor, Designer, Reporter), Web Intelligence, Xcelsius, Broadcast Agent, 3Tier BO, Oracle 9i/8i, MS SQL Server 2000, Windows NT, Unit Test, Windows 2000, Unix and Sun Solaris.