SUMMARY:

• About 12 years of IT experience in the Analysis, Design, Development and Implementation of Data Warehousing Systems using Business Objects suite, Business Intelligence BI/BW 7.0, BEx Queries, Crystal Reports, SAP HANA 2.0,Tableau Desktop Dashboarding 9.0, SAP Lumira, ETL tools including Informatica, BO Data Services, Data Stage and data bases including Teradata, Oracle, MS - SQL Server, IBM DB2.
• Extensively worked an have hands on experience in Business Objects BO XI 4.1/ XI 3.1/XI R2/6.5 using various tools like IDT, Universe Designer, BI launch pad/Info view, Web-Intelligence, Web I Rich Client, DESKI, Crystal Enterprise 2008/XIR2/10, XCelsius 2008, Live Of-fice, QAAWS, DashBoard Designer, Tableau Desktop 8.1/9.0 SAP Lumira, CMC, Import Wizard, Promotion Manager.
• Proficient in managing all phases of data ware house life cycle, including requirements gathering, data analysis, preparing Business specifications, designing technical/ software requirement specifications, Universe designing, developing reports, performance tuning, testing, migrating, production support
• In Depth understanding of Data Warehouse concepts, OLAP, Star schema, Dimensional Modeling, Physical & Logical Data Modeling, Fact & Dimension tables
• Strong experience in Design, Development, Deployment, and testing of Universes using Business Objects Universe Designer against Relational databases (Teradata, Oracle, MS SQL Server, DB2 sources) and SAP BW/BEx query sources
• Good working knowledge on SAP BI/BW 7.0 with exposure on BEx queries, BEx Analyzer and Info cubes
• Good understanding on the Business Objects Enterprise Architecture CMS, Web component Adapter, I/O File repository server, Web Intelligence server, List of values server, Report Job server, Event server, Page/Processing server, Cache server and RAS
• Designed and Developed multiple dashboards and stories using Tableau
• Experience in the users on creating Adhoc reports and the WebI tool navigation
• Good understanding on the ETL Jobs, workflows and Concepts in Informatica and Datastage
• Expertise in working on SQL with Databases like Teradata 14.0, Oracle11g/10g/9i, MS SQL Server 2008/2005, IBM DB2 V8
• Diversified experience working on Implementation of Business Objects, Crystal reports in Manufacturing, Financial, Banking, Publishing & Media, Communications and Public sectors
• Proven ability to work in cross-functional teams with high sense of ownership and strong customer focus. Highly efficient, committed in demanding and rapidly changing environments
• Excellent communication, interpersonal, analytical skills and a good team leader / member
• Ability to effectively multitask, meet deadlines, quickly adapt to different project environments

TECHNICAL SKILLS:

BI Tools: Business Objects XI 4.1/4.0/3.1/R2/6.5, IDT, Universe Designer, Desktop Intelligence, BI Launch pad/Info view, WebI, Import Wizard,Publishing Wizard, Promotiona Manager, CMC, Live Office, QaaWS, XCelsius 2008/4.5, Tableau 9.0/8.1, SAP HANA Studio 2.0.9, SAP Lumira, Dashboard Designer, BEx Designer, BEx Analyzer, Crystal Reports 2008/XI

ETL Tools: Datastage 8.5, Informatica 9.1/8.5, BO DS XI 4.0/3.1, SAP HANA Studio

RDBMS: Teradata 14.0, Oracle 11g/10g/9i/8i, MS SQL Server 2008/2000, IBM DB2 V8

Programming Languages: SQL Queries, PL/SQL

Front End Tools: Teradata SQL Assistant, TOAD and SQL Developer

Operating Systems: WIN XP/2003/2000, UNIX

ERP: SAP R3, SAP BW/BI 7.0

PROFESSIONAL EXPERIENCE:

Confidential, Peoria, IL

SAP Business Objects Reports/Dashboards Developer

Responsibilities:

• Extensively supporting all Bobj Adhoc requests/issues in 3.1/4.1 for entire Confidential users
• Extensively supported enhancing the GSND AdHoc universes and reporting requests
• Worked on Agile methodology in resoving Adhoc requests from user groups
• Developed Cross Tab, Chart, Line, and Drill Through Reports in Tableau desktop. Generated tableau dashboards with forecast and lines
• Effectively used level of detail (LOD) calculation for complex logics
• Used different Mark types and Mark properties in views to provide better insights into large data sets. Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Extensively used filters, parameters, sets and used Actions fatures to dynamically switch worksheets and display the results in tableau dashboards
• Prepared Annual forecast charts for different Global hierarchies blending data from Business Objects reports and some file based data using Excel sheets
• Published the Dashboards for the end users and shared the work books with the end users by exporting data
• Worked on several dashboards using Bobj Dashboard designer like, Inbound Receivings, Demands Snap Shots by Plant, Production Order Variace, facility Performance metrics
• Worked on SAP Hana studio, updating the existing HANA models snd effectively using them to create underline BOBJ IDT, reports and dashboards
• Worked on the performance improvements of the SDW reports in Webi 4.0/ 3.1
• Extensively worked on the Universe Developments in Bobj IDT4.0/Bobj 3.1 working on creating new IDT/Universes and modifying/enhancments of the exisiting IDT/Universes
• Tuned the object definitions in the Universes. Modified the existing reports and improved the run time performance of the reports
• Created and modified the Web I reports per new business requirements
• Supporting GSND users on Adhoc Bobj reporting requests
• Worked on SQL assistant to unit test the data
• Supported the business users in resolving the issues in report run time
• Created dynamic dashboards and stories on top of Teradata views using Tableau desktop
• Effectively used the different charts/Maps. Extensively used the filters, parameters and calculated fields to view aggregated data in the Visuals
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt Chart, Histograms, Water Fall charts, bar charts, maps to assist business users in solving complex problems
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Analyzed the technical documents, performed the gap analysis and revised the techincal specifications based on the business requirements
• Created BEx queries and generated Bex reports using the BEx analyzer
• Created the Universe on top of the BEx queries in BObj 3.1.
• Extensively worked on developing the Webi reports based on the Mach1 requirements.
• Closely worked with the Business Analyst while validating the reports till production release and supported in resolving the production and post prosuction issues.

Environment: Business Objects Enterprise XI 4.1/3.1, IDT, Universe Designer, BI Launch pad/Info View, Web I, Teradata 14.0, Data Stage 8.5, Tabelau 9.0/8.1, SAP HANA 2.0.9, SAP Lumira

Confidential, Hartsville, SC

SAP Business Objects/Dashboard Developer

Responsibilities:

• Analyzing Business requirements and data specifications for Business Objects Web I Reports
• Understanding functional requirement specifications and create detail level documentation
• Involved in adding classes and objects in the Universe as and when necessary for the new canned reports
• Coding, designing the queries, developing reports based on the user requirements
• Track the issues and document the development process for program s
• Communicate with Subject Matter Experts to resolve or clarify any issues that are raised during the development process
• Working on the Web Intelligence 4.0 reports to meet the requirements
• Unit testing the report data by comparing the data from the report with the SQL Query outputs from the SQL Server database and validate the results
• Providing estimates for development efforts for the new reports and change requests on a time to time basis
• Extensivley used Webi 4.0 accesing the views from the SQL Server database and generated charts with Quick filters, Report parameters
• Worked closely with the end user analyzing the report results

Environment: Business Objects Enterprise XI 4.0, Designer, BI Launch pad/Info View, Web I 4.1, MS SQL Server 2008, MS Share point, Windows XP

Confidential, Austin, TX

SAP BO Developer

Responsibilities:

• Participated in the daily Agile scrum calls, weekly planning meetings for the Confidential project
• Prepared wireframes (Report mockups) based on the stories discussed as per report standards
• Created Test cases manually using the Confidential & Confidential internal tool called Test link
• Followed the test driven Agile methodology, written SQL Queries in SQL Editor based on the report requirements and uploaded them in the Test cases
• Worked on BO 3.1 Universe enhancements, updating the tables, adding new tables, Joins, detecting loops. Created additional contexts, new dimension and measure objects in the Universe
• Implemented aggregated awareness function in the Universe measure objects using the yearly, monthly and daily aggregated tables. Exported the Universe into the repository
• Prepared detailed documentation on the Universe updates like a technical design specification before report development and deployed it into the share point with the latest versions
• Worked on development of Circuit Utilization Web I reports for Confidential project, developed in Info View/BI Launch Pad in BI 3.1/4.0
• Extensively worked on Open Doc syntax for hyperlinks in the reports for navigating from Parent to child reports
• Extensively used the Web I functions like User Response, Relative Dates and used Variables
• Worked closely with the central command team in resolving the issues and getting the results as expected
• Closely worked with the ETL team, the Data Architects and the Database Administrators to resolve the performance issues on the reports run time and performance tuning

Environment: Business Objects XI 4.0/3.1, Universe designer, Business intelligence Launch pad, Web I, Info View, CMC, Informatica 9.1, SQL Developer, Oracle 11g, Windows 7, I.E. 8

Confidential, Eagan, MN

SAP Business Objects /Tableau Consultant

Responsibilities:

• Identified the KPIs required in the Xcelsius dashboard. Extensively worked on the design layout of the DW status and Executive dashboards for the load status information and the performance information of the Key metrics for the Executives
• Responsible for designing and development of Crystal/Web I reports from SAP BI/BW and the relational data sources
• Closely worked with the Business Analyst, BI lead and the Warehouse architect in understanding the BRS and SRS documents based on the business requirements
• Performed the gap analysis to understand the feasibility in designing the dashboard layout per business requirement
• Worked on the development of workflow reports using Web I reports in XI 4.0
• Used Tableau source data connections to access the underlined views from Oracle database
• Performance tuning of reports and resolving issues in the database views
• Involved in testing the SQL Scripts for report development, reports, Dashboards, Scorecards and handled the performance issues effectively
• Created custom calculated fields, effectively used parametrs and sets to dynamically display the measures and KPIs
• Presented the data in hierarchy mode by dynamically seleting the filters
• Interacted with the users for troubleshooting the problems in the reports, dashboards
• Published the dashboards into the server. Scheduled the published dashboards to run on daily basis and present the updated data

Environment: SAP R3, SAP BI/BW 7.0, Business Objects XI 4.0/3.1, Universe Designer, BI Launch pad, Web I, Informatica 9.1, SQL Developer, Crystal 2008, Xcelsius, Oracle 10g R2, Windows XP

Confidential, Minneapolis, MN

Business Objects Consultant

Responsibilities:

• Migrated the existing reports from BOXI R2 to BOXI 3.1 using Import wizard
• Worked extensively on CMC and reassigned all the GROUPS and USERS and mapped to the Folders. Implemented Folder level security for these GROUPS and USERS
• Interacted with Business users, Business Analyst, gathered business requirements, and presented the proof of concept
• Performing requirements analysis, design, and technical delivery of critical business reports for decision support in the data warehouse sitting on top of Oracle data base
• Responsible for designing and development of Universes from relational database sources in BO XI 3.1
• Designed and built Universes using Designer, created and modified Web I, Crystal reports from the underlying Oracle and SQL server databases for different business modules
• Designed the logical semantic layer using the Universe designer tool by defining joins, cardinalities between tables and applying contexts and aliases to remove cyclic dependencies (Loops/traps)
• Resolved complex loop issues by creating multiple contexts and aliases to remove cyclic dependencies in the universes
• Worked on custom hierarchies in the universe level to enable scope of analysis and various drill options during reporting
• Worked on universe level filters to restrict the data Confidential Universe level. Applied filters on the objects. Created derived objects in the universe
• Created Derived tables for improving performance and used short cut joins to resolve join problems
• Worked extensively on the Web I functions like multiple queries, combined queries, report and block filters, and various reporting cosmetic options like section, breaks, ranking, sorting and formatting options
• Designed reports that include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts
• Developed different types of standard reports with drilling capabilities in tables, cross-tab and charts with complex calculations, Variables, Breaks, Sorting, and Alerters
• Created Periodic reports: daily report, weekly, monthly and annual reports, till and employee reports

Environment: Business Objects Enterprise XIR3.1/XI R2, Universe Designer, Web Intelligence, Import Wizard, Info view, Crystal Reports 2008, Windows 2003, Oracle 10g r2, MS SQL Server 2005

Confidential, Austin, TX

SAP Business Objects Consultant

Responsibilities:

• Worked closely with Business Analyst, Business Users and Managers for gathering, analyzing, documenting Business Requirements, Functional Requirements and technical Specifications for Business Objects universes and reports
• Worked on designing, developing Business Objects universes using relational databases (IBM DB2) as the data sources
• Used BO Universe Designer for semantic layer, Business Objects Info View, Web I Reports for reporting
• Designed the universes on top of IBM DB2 databases from scratch and exported them to the repository for supporting ad-hoc and canned reports
• Defined cardinalities, created joins, performed check integrity, resolved loops by creating aliases and contexts to remove the cyclic dependencies
• Created different types of reports, like Tabular, Master/Detail, cross Tab using multiple queries
• Used filters, conditions, Prompts, Drill Down, @Functions
• Extensively used breaks for white spaces and sections for better navigation
• Created reports like Quarterly reports, Demographic reports and Metric exception Reports
• Created various Dashboards using ISAS, GSMS data like Confidential Stimulus Contract details, Sub recipient Details, Vendors, Invoices, Voucher Details, Payments details for different vendors
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes
• Migrated the universes from DEV to Acceptance and PROD Environments
• Trained the users on the Ad Hoc reporting and on navigating the Business Objects tool

Environment: Business Objects Enterprise XI 3.1, Designer, Web I, Info View, Business Objects Data Services XI 3.2, IBM DB2 V8, Windows XP/2003

Confidential, Columbus, OH

SAP Business Objects Developer

Responsibilities:

• Performed an Initial Study of the current reporting application, to finalize the data elements required for reporting
• Responsible for analyzing business requirements and developing queries and reports using Business Objects
• Installed and configured Business Objects Enterprise XI 3.1 on the Windows 2003 Server
• Worked on designing Universes and Building of classes and objects
• Resolved loops and traps using Contexts and Aliases while designing Universes
• Proposed to set up Universe level conditions to restrict data based on report requirements
• Worked in development of reports using WEBI to cater Ad-hoc reporting needs
• Created reports using Business Objects functionality’s like prompts, filters, using slice and dice, Drill options, Cross Tabs, breaks, sections/Master Detail and Formulae
• Created Web I Reports using Drill functionality creating custom hierarchies and defining scope of analysis
• Created Complex Web I reports using Open Document functionality to link the different data in the reports
• Migrated reports from Development/Testing environment to Production Environment
• Used report filters, block filters and Conditions to achieve report functionality
• Created Dashboards and Score cards to provide the users with business information using Performance Manager
• Experience working with Xcelsius to display summary-level business data in a rich and interactive format using graphs and different components in Crystal Xcelsius 2008
• Involved in using Xcelsius to transform Microsoft Excel spreadsheet data into interactive flash media files for the Executives
• Connected to the Web I reports and crystal reports using Live Office and imported the data into Live Office spread sheet
• Using Query as a Web Service Wizard (QaaWS) queried directly the Universe Objects, applied prompts for restricting data Confidential the dashboard level
• Worked on Unix shell scripting in moving tables
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes

Environment: Business Objects Enterprise XI 3.1, XCelsius 2008, Designer, Dashboard Manager, Infoview, Web Intelligence, Import Wizard, Qaaws, Xcelsius 2008, Metadata Manager, Informatica 8.5, Windows 2003, MS-SQL Server 2005, Unix shell scripts, Oracle 10g