SUMMARY

• US Citizen, Overall, 7 years of experience in various capacities as a SAP Business intelligence BO developer.
• Possess excellent problem solving, organizational, and communication skills.
• Expert in understanding clients’ needs and requirements through interacting with data analysts and end - users.
• Proficient in design and develop processes utilizing best standards.
• Have excellent presenting capabilities, confidence when presenting technology to customers or to a group of analysts.
• SAPBI/BOBJ Consultant with 6 years of experience in information technology, with knowledge in complete lifecycle of software products involving Analysis, Design, Development, Implementation, Testing and Support for various data warehousing applications including experience in using DSS/OLAP (Data Warehousing) tools i.e. SAP BI/BOBJ XI 3.1, BOBJ 4.1, Web Intelligence/ BI launch pad
• Worked with Clients to identify and resolve business problems, gaps and implementation issues. I have been involved in functional solutions that includes, gap analysis, setups, test script and documentation
• Business requirements gathering, GAP Analysis, Test Plan Preparation, Unit testing, Functional Architecture, System Integration Testing, and UAT, proficient in implementation and setups. Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Refined planning and organizational skills that balance work, team support and responsibilities in a timely and professional manner.
• Performance tuning, testing, migrating to production and post-production support.
• Knowledge in Native HANA hands-on development experience with PL/SQL. Creating SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views)
• Proven ability to work in cross-functional teams with high sense of ownership and strong customer focus.
• Strong knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, security management and production support in BI.
• Experience with Data Warehouse concepts, and methodologies, as well as strong knowledge with star schema and snowflake schema data models.
• Experienced using BEx Query Designer.
• Extensively worked on designing and developing complex universes with multiple fact tables and several hundreds of objects as per the universe design best practices.
• Universe development experience on Oracle 9i/10g/11g/12c and MS SQL Server 2008/2012/2014.
• Competent in handling all levels of data warehouse life cycle, including requirements gathering, analysis, preparing business specifications, designing technical specifications, and system requirement specifications.

TECHNICAL SKILLS

Reporting Tools: Business Objects 4.1/4.2 Crystal Report 2008,2011, Xcelsius 2008, Dashboard, BEX Query Designer, BEX Analyzer, Performance Management and Business View Manager, Tableau 10

Web Servers: IIS 6.0/5.0, Apache Tomcat 5.0.27/4.1, Web Logic 8.0 and Web Sphere

ETL Tool: Business Objects Data Services 4.1

Operating Systems: Windows 10/8.1/ 7/Vista/XP/2000/98, MS-DOS, UNIX, Solaris, Linux

Database: Oracle 12c/11g/10g/9i, MS SQL Server 2008, 2012,, DB2, Toad 8.5 graphical inter phase, SQL Developer

Languages: C++, SQL, JAVA SDK, ASP.Net, TSQL, PL / SQL, HTML5, Python

IDE & Packages: SQL Navigator, Visual Studio 2010/2008, Eclipse, share point, MS Office, Excel & Visio

Corporate Training: SAP Business Object 4.1 & SAP HANA 1.0 SPS04

PROFESSIONAL EXPERIENCE

Confidential

Senior Business Objects Developer

Responsibilities:

• Involved in all phases of development including requirements gathering, analysis, designing Business Intelligence platform, coding, testing, implementing and maintaining the universe and reports until the warranty period.
• Created report mockups through end-user meetings and analysis of system requirement documents.
• Extensively worked with end-users, business analyst and data architects to come up with an optimized data model, which is report-centric. Have worked on both normalized and de-normalized data models depending on the requirement.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables and created classes, sub-classes and objects as per the organization standard
• Defined contexts, aliases and used multi parse SQL in the universes to address loops, chasm traps and fan traps, which support Ad-hoc and canned reports.
• Used Index awareness, aggregate aware and aggregate tables for optimized query performance.
• Applied Row level, Object level security in the universe to make the sensitive data secure.
• Created Multiple Custom Hierarchies for several groups to provide drill across functionality.
• Used functions like select, where and prompt function to create prompts, which helps the user to select the values dynamically.
• Created complex Webi reports by merging objects from different data providers using Merge Dimension Option.
• Extensively used Variables, Sub-queries, merged dimension, Input Controls, Context Operators (In, For Each and For All), and Drill down, folding/unfolding, Breaks, Sections, Ranks and Alerters in the creation of reports.
• Used BI Launch Pad/Info View for scheduling different reports and developing Web Intelligence documents.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per business requirements.
• Used IBM Clear Quest to update defect status to the testing team or re-assign to the appropriate development team leads.
• Written user training documents for basic implementation Design and create User guide and Training Guides.
• Post- Go live issues were fixed, new post - production requests and change requests (CR’s) were implemented.
• Involved in creating Business Requirement Document (BRD), System Requirement Document (SRD), Logical Application Design Document (LAD), Physical Application Design Document (PAD) and Traceability Matrix.
• Involved in the upgrade of Business Objects Enterprise platform from XI 3.1 to XI 4.1 and resolved the defects caused after migration on the reports and raised tickets with SAP.
• Extensively worked with Teradata SQL Assistant to perform Unit testing and data analysis during report development and cross check the data accuracy, validation and the performance of the reports in development, system test and Production.
• Involved in user training sessions and assisted in UAT (User Acceptance Testing).
• Developed dashboards that used Opendoc functionality to link a dashboard to a Webi report in BOE
• Created reports using Crystal Reports with Standard, Summary, and Cross Tabs and Grouping.
• Used conditional formatting as per user requirements in crystal reports.
• Resolved tickets to support production environment, Modified and tweaked report content and distributed reports in multiple formats such as Excel and PDF.
• Attending daily meetings with team and other project members

Environment: SAP BOBJ Enterprise XI 3.1 SP3/ SAP Business Objects Business Intelligence 4.1, BI Launch Pad (Info View), Web Intelligence, Crystal Reports 2008, Xcelsius 2008 SP3, QaaWS, Live Office, Import Wizard, Oracle 10g,SQL,PL/SQL.

Confidential, Indianapolis, IN

Senior Business Objects Consultant

Responsibilities:

• Used BI/BOBJ XIR3 to build universe and reports.
• Developed universe in BOBJ XIR3 for the Sales and Marketing Department to Analyze Sales and enable Marketing Team to make informed decisions
• Full project life cycle (requirement gathering to implementation phase).
• Consulting with business clients, creating Tableau dashboard reports, collaborating with developer teams, using data visualization tools, and using the Tableau platform to create business intelligence visualizations
• Linked reports in Business Objects Developed complex reportsd. Prepared the following - Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.
• Created user groups and managed access privileges using Business Objects CMC.
• Responsible for Business Objects repository and Web intelligence maintenance and tuning.
• Extensively used Designer to design various universes for different business groups. Created complex reports using cascading prompts, decode objects etc.
• Customized Business Objects web interface (intranet) to access the enterprise reports.
• Developed various Charts, Graphs and drill down reports
• Extensively used Toad to verify if the data pulled by the report is correct compared to the database data and also to verify if the joins used in designing the universe are correct.
• Generated Custom variables, groups and formulas in Business Objects.
• Generated Reports on different data sources such as Business Objects Universes, Stored Procedures etc
• Worked on User/System report documentation, user training and testing developed reports for final deployment.
• Worked on creating groups, conditions, filters ranking in reports
• Scheduled the weekly, monthly, quarterly reports using business objects
• Worked on improving performance of reports with aggregate aware and using indexed columns in reports.
• Build a Dashboard using Xcelsius 2008 for Business analysis.
• Made use of flash variables to link Master detail dashboard.
• Created users and groups in CMC.
• Created folders and granted rights for the different user groups.

Environment: SAP BI/BO Enterprise I 4.1 SP2, BI Launch Pad, Web Intelligence, Design Studio 1.3, SAP Design Dashboard 4.1, BW 7.4, UDT-IDT SAP Business Objects 4.1/4.0/3.1/3.0/ XI R1/R2/6.5.1/6.1 Web Intelligence/ Launch pad/ Info view, Information Design tool, Universe Designer, Explorer, SAP Lumira, Crystal, Xcelsius 4.5/2008, Broadcast Agent, Auditor, Application Foundation 5.x, Live Office, QAAWS, BI 7.0, 7.3, BEX Query Analyzer, Tableau

Confidential, Deerfield, IL

Business Objects Developer

Responsibilities:

• Gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Crystal Reports.
• Involved in designing Universe and migrating existing Desktop Intelligence (Deski) Reports to Web Intelligence (Webi) report.
• Set up the security levels to the users in universe module like row level and object level security.
• Designed and developed the Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of the tables and structures of the Universe.
• Architected and developed financial dashboards (Variance Price Exchange, Daily Sales, Profit and Loss) using best dashboard design practices.
• Created shell script to automate Business Objects Reports since Business Objects Enterprise ware house is running on UNIX.
• Created the BW BEx queries and OLAP Universes on top of the BEx Queries and then generated reports in Web Intelligence
• Worked closely with the project leadership team to document schedules, resource requirements, business requirements, test strategy, and plans for data migration, Involved in migration of reports from BO 6.5 to BO XIR3, Migrated universes, reports and security domain from 6.5 to BO XIR3 Using Import Wizard, Resolved several issues with installation, designing, reporting and migration.
• Used BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Created dashboard reports on ROI, actual and plan cost analysis, profit analysis on operating concern level and profit centre level.

Environment: SAP BI/BO Enterprise I 4.1 SP2, BI Launch Pad, Web Intelligence, Design Studio 1.3, SAP Design Dashboard 4.1, BW 7.4, UDT-IDT SAP Business Objects 4.1/4.0/3.1/3.0/ XI R1/R2/6.5.1/6.1 Web Intelligence/ Launch pad/ Info view, Information Design tool, Universe Designer, Explorer, SAP Lumira, Crystal, Xcelsius 4.5/2008, Broadcast Agent, Auditor, Application Foundation 5.x, Live Office, QAAWS, BI 7.0, 7.3, BEX Query Analyzer, Tableau.

Confidential, Cincinnati, OH

SAP BI Consultant

Responsibilities:

• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Problem resolution and status updating to the Onsite co-coordinator
• Involved in the installation of Business Objects suite, creating the Repository, creating Users, User Groups and assigned privileges to the users using Supervisor.
• Developed the stored procedures to increase the system performance.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Designed and developed universe for report generation.
• Resolved the loops, traps, cardinalities, contexts and checked the Integrity of the Universes.
• Exported the universe to the Repository to make resources available to the users
• Created user defined objects including dimensions and measures for complex financial calculations.
• Used @Functions such as @Prompt to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, charts and alerts for creating Business Objects reports.
• Enhanced reports which included standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Prepared user documentation for hands on training of end user community.

Confidential

Business Objects Developer

Responsibilities:

• Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
• Analyzed user requirements and sorted the best possible ways of representing the data.
• Created Universes, Classes, Dimension and Measure Objects by retrieving the data from various data sources and defining the necessary connections.
• Detected/Resolved data Cardinalities and loops, checked integrity of Universes, created list of values. Resolved Chasm, Fan traps and Loop problems using aliases and contexts in the universe and exported to repository.
• Created reports using Business Objects functionalities like queries, cross tab, master detail reports, formulas, Customized filters to display relevant data, etc.
• Created complex reports using cascading prompts.
• Created variables, formulas and used contexts (in, for all, for each).
• Created reports using Multiple Data Providers, Prompts, break, filter, rank, alerter, Slice & Dice and Drill up/down functionality.
• Tested reports before posting them to the repository (query optimization & performance).
• Migrated Universe/Reports from Development/QA to production.
• Designed and analyzed the reports using Business Objects.
• Designed, developed and maintained a wide dashboard using Dashboard Manager
• Customized the user interface to meet the needs of end users with Business Objects SDK with VBA.
• Creation of prototype dashboards to demonstrate use of Interactive Metric Trends (IMT) for executive-level users.
• Involved in Migrating users, Universes, report objects personal categories, inbox documents.
• Supported Business Objects Administrator in creating users and allocating rights to them.

Environment: BusinessObjects 6.5.1(Designer, Web Intelligence, Info View, Broadcast Agent), Oracle 9i, PL/SQL, DB2, Crystal Xcelsius Pro v4.5, SQL Server 2000, Windows NT/XP Professional.