SUMMARY

• Over 10 years’ experience in Information Technology with proven ability to implement SAP Business Intelligence solutions aligned with business objectives and innovative analytical reporting. Capable of managing numerous projects while leading cross - functional teams and competent in all aspect of Business Objects Development, implementation, Deployment, Testing and Migration.
• Strong knowledge and extensive experience in developing business intelligence solutions utilizing SAP Business Warehouse, Business Objects, SAP Mobile BI and Enterprise Data warehouse (relational and OLAP) Tableau and Qlikview.
• Implemented Enterprise Business Intelligence Systems for diverse group of clientele such as HealthCare, Automotive, Financial, Telecom, Government, and Manufacturing.
• Experience Develop and Design of interactiveTableau Dashboard reports.
• Installed Tableau Desktop and Tableau Server on distributed environments.
• Experience in Publishing Tableau data sources and workbooks to the Tableau Server.
• Experience in creating Dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Experience in creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data using Tableau.
• Experience in InstallingTableauServer on primary and Worker environments
• Experience in publishing Tableau dashboard to a central location for portal integration.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableauserver logons.
• Experience inTableau Server Management like clustering, load balancing, user management.
• Experience in implementing Tableau Security.
• Experience in migration, scheduling and backups in Tableau.
• Experience in Connecting Various Data sources using Tableau.
• Experience in Configuration, patching and upgrading of the Tableau tool across the environments.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data using Tableau.
• Full life cycle implementation of Business Intelligence projects using Business Objects (Universe, WebI), SAP Mobile BI, Dashboards/ Xcelsius (qaaws, live office, BI services, and Query browser), Crystal Reports, and SAP BW (BEX and InfoCube).
• Good Knowledge in BOBJ Reporting (Universe, WebI, Explorer, and Dashboard) consuming data from SAP HANA.
• Good Knowledge in Data Provisioning from ECC and Relational databases using BODS.
• Good knowledge in different ETL tools like BO Data Services, BO Data Integrator, Informatica and SSIS.
• Experience in operational reporting using SAP Crystal Reports for Enterprise (CR4E/2011/2008/XI).
• Experience in interactive reporting using Web Intelligence Rich Client (WebI).
• Expertise in Business Analytics/KPIs using BOBJ Xcelsius 2008 and Dashboard Designer.
• Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).
• Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building qvd’s and qvw’s.
• Hands on Experience with QlikView Architecture in development and deployment.
• Expertise knowledge in Set Analysis, Advanced aggregations, synthetic keys and circular references
• Hands on experience on implementing QlikView hierarchies using QVD approach
• Experience in setting up server, publisher configurations and security/ authorization at different levels.
• Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in QlikView and DW concepts.
• Excellent Technical, Interpersonal and solid communication skills with the ability to interact with end-users and managers and Experience in requirement gathering and Training End-users.
• An enthusiastic, project-oriented team player with leadership skills and with an ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

SAP BI/BOBJ Tools: Business Objects XI 4.1/ 4.0 / 3.1/ R2/6.5, Information Designer Tool, BI Launch Pad, Analysis for OLAP, Universe Designer, Web Intelligence, DeskI, XCelsius2008, Dashboard Designer, Central Management Console (CMC), CCM, InfoView, Scheduler, BEX, BICS, QAAWS, Live Office, Query Browser, Crystal Reports 2008/2011, Import/Export Wizard and Life Cycle Manager (LCM).

BI Analytic / Reporting Tools: SAP Xcelsius, Dashboard Designer, HANA Studio, SAP Mobile BI, BODS, WebI, Crystal Reports, CR4E, OLAP Analysis, Business Explorer (BEX), BO Explorer, Tableau and QlikView.

ETL/Data Provisioning Tools: InformaticaPowerCenter, Business Objects Data Integrator, Business Objects Data Services (BODS), and HANA Studio

Databases: SQL Server 2000/2005/2008 , MS Access 2002/2003/2007/2010 , Oracle 8i/ 9i/10g/11g, PLSQL,MySQL, SAP ECC, Teradata

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Senior Business Intelligence Solution Designer

Responsibilities:

• Interviewed users to identify problems, reporting requirements and problems in existing systems design.
• Collaborated with Business Intelligence team to learn current processes and practices.
• Developed and Designed interactive Tableau Dashboard reports.
• Designed Dashboards with Drill Down and Drop down menu option and Parameterized using Tableau.
• Installed Tableau Desktop and Tableau Server on distributed environments.
• Published Tableau data sources and workbooks to the TableauServer.
• Designed Dashboards using calculations, parameters in Tableau.
• Created Dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data using Tableau.
• Installed TableauServer on primary and Worker environments
• Connected Tableauserver to publish dashboard to a central location for portal integration.
• Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions using Tableau.
• Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableauserver logons.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data using Tableau.
• Creating Dashboards using Dashboard designer 4.0.
• Creating reports using web intelligence4.0
• Using Universe Query and BI Web services Method to populate the data in to Dashboard.
• Creating Business Objects Universes with Information Design tool.
• Objective of the Project is to create detailed documentation of the existing QlikView code with respect to transformations, QVDs, expression, data sources
• Generated new QVD files from the EDW by writing scripts in Qlikview applications.
• Applied metrics in the data via QlikView scripts and transformed QVDs to cater the business needs.
• Designed and Developed QlikView dashboards meeting the business requirements.
• Gained understanding of the QlikView scripts - Load statements, Joins, Concatenate, variables, QVDs used and so on. Created detailed documentation of the multiple layer QVD structure that gave understanding to the team on how the data is flowing in QlikView dashboards.

Environment: Business Objects4.0,QlikView 11.x, QlikView Server/Publisher, SQL ServerMS EXCEL, Tableau9

Confidential, SFO, CA

Senior Business Intelligence Solution Designer

Responsibilities:

• Interviewed users to identify problems, reporting requirements and problems in existing systems design.
• Collaborated with Business Intelligence team to learn current processes and practices.
• Objective of the Project is to create detailed documentation of the existing QlikView code with respect to transformations, QVDs, expression, data sources
• Generated new QVD files from the EDW by writing scripts in Qlikview applications
• Applied metrics in the data via QlikView scripts and transformed QVDs to cater the business needs.
• Designed and Developed QlikView dashboards meeting the business requirements
• Gained understanding of the QlikView scripts - Load statements, Joins, Concatenate, variables, QVDs used and so on. Created detailed documentation of the multiple layer QVD structure that gave understanding to the team on how the data is flowing in QlikView dashboards
• Created a brief document on how the QlikView statements, functions work so that even a novice user/developer can gain understanding of the QlikView scripts.
• Fine-tuned Qlikview jobs for faster and better loading of data
• Worked on extensively to cluster QlikView Server environment
• Worked on QEMC configuration on Qlikview server

Environment: QlikView 11.x, QlikView Server/Publisher, SQL Server, MS EXCEL.

Confidential

Senior Business Intelligence Solution Designer

Responsibilities:

• Developed and Designed interactive Tableau Dashboard reports.
• Designed Dashboards with Drill Down and Drop down menu option and Parameterized using Tableau.
• Installed Tableau Desktop and Tableau Server on distributed environments.
• Created Dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data using Tableau.
• Installed Tableau Server on primary and Worker environments
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.
• Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations using Tableau.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data using Tableau.
• Creating Dashboards using Dashboard designer 4.0.
• Creating reports using web intelligence and crystal enterprise 4.0
• Using Universe Query and BI Web services Method to populate the data in to Dashboard.
• Working with OALP for Analysis.
• Creating Business Objects Universes with Information Design tool.
• Creating Business Objects Universes against Bex Queries using universe Designer.
• Created Universe using Info cubes, Bex queries and Multiproviders as data source.
• Created Webi reports and Crystal Reports Using BICS Connection
• Created Dashboards in Dashboard Designer using Universe Query and BICS Connection
• Involved in requirement Gathering Sessions with the Business Users.

Environment: Business Objects 4.0/4.1, Dashboard Designer, Business Objects Explorer 4.0, OLAP for Analysis, Crystal Enterprise 4.0, SAP BW7.0, Tableau8

Confidential, Atlanta, GA

Senior Business Intelligence Solution Designer

Responsibilities:

• Developed and Designed interactive Tableau Dashboard reports.
• Created Dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data using Tableau.
• Installed TableauServer on primary and Worker environments
• Connected Tableauserver to publish dashboard to a central location for portal integration.
• Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions using Tableau.
• Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations using Tableau.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data using Tableau.
• Worked as a Senior Business Objects Solution Designer for Equipment Dashboard, Segmentation reporting and Asset Utilization Reporting Projects.
• Creating Dashboards using Dashboard designer 4.0.
• Creating reports using web intelligence and crystal enterprise 4.0
• Using Universe Query and BI Web services Method to populate the data in to Dashboard.
• Created Universe using Info cubes, Bex queries and Multiproviders as data source.
• Creating Business Objects Universes against Bex Queries using universe Designer
• Created Webi reports using BICS Connection
• Created Dashboards in Dashboard Designer using Universe Query and BICS Connection
• Working with Business Objects Explorer 4.0 for Segmentation Project.
• Working with Exploration views in Business Objects Explorer 4.0.
• Working with OALP for Analysis.
• Creating Business Objects Universes with Information Design tool.
• Involved in requirement Gathering Sessions with the Business Users.
• Created and Export the dashboards into SAP Mobile.

Environment: Business Objects 4.0, Dashboard Designer, Business Objects Explorer 4.0, OLAP for Analysis, Crystal Enterprise 4.0, Teradata13, SQL Server2008, SAP BW 7.3, Tableau

Confidential, New York, NY

Team Lead/Senior Business Intelligence Solution Designer

Responsibilities:

• Worked as a team lead for the Speaker Operations Project and communicating with the offshore team members.
• Involved in requirement gathering working sessions with the users
• Designed Report Design Documents and Universe Design Documents According to the Confidential Standards.
• Involved in validating the Requirement Tractability matrix Document with Business Analyst.
• Worked closely with the ETL Developers to get the data according to the reporting requirements
• Designed Universes for Speaker operations reporting system.
• Created Classes and Objects for Speaker Operations Universe and Reports like Program Activity reports, Program AttendancesReports, Compliance Reports and BU certification Reports and ad-hoc reports.
• Created summary and detail reports as sections using Business objects Web Intelligence.
• Created summary and detail reports with opendoc using Business objects Web Intelligence.
• Created Input Controls in Web Intelligence for users to filter the data.
• Used different functionalities of WEBI like Breaks, Sorts, Filters, and Sections and drill down in creating complex reports.
• Worked on different types of joins and resolving join problems such as Loops, Chasm trap and Fan trap.

Environment: Business Objects XIR3, Web Intelligence, Xcelsius 2008, Oracle 11g/10g, Informatica

Confidential, Sacramento, CA

Senior Business Intelligence Solution Designer

Responsibilities:

• Generated Reports for Penalties and Interest data using Crystal Reports 2008.
• Created a substantiation report for penalties and Interest using crystal reports 2008.
• Developed functional design specifications for Report development objects.
• Developed functional design specifications for VDF (voluntary Deduction File) and F496 File Layouts.
• Meeting with functional people and gathered requirements and developed FDS for Report development objects.
• Created functions and various parameters according to the requirement using crystal reports 2008.
• Created Table Structures in SAP ECC for Penalties and Interest Data.
• Created sub reports and pass through parameters from main report to the sub reports.
• Created Cascading dynamic parameters using crystal reports 2008.
• Using the functionalities like grouping and sorting according to the requirements using crystal reports 2008.
• Was responsible to develop customize reports requested by Clients.
• Worked on performance tuning of queries for faster execution of reports.

Environment: Business Objects XIR3, Web Intelligence, Crystal Reports 2008, SAP ECC 6.0, SAP PSCD

Confidential, St Louis, MO

Senior Business Intelligence Solution Designer

Responsibilities:

• Designed Universes for Consumerology and Research Lab for developing dashboards for Research Users.
• Created Universe Using Freehand SQL(Derived Table) As a Fact table.
• Created Classes and Objects for universes and Dashboards like Consumerology Operational dashboard and web testing tally report dashboard.
• Created reports & dashboards using Xcelsius, Web Intelligence
• Worked on different types of joins and resolving join problems such as Loop, Chasm trap and Fan trap.
• Used different functionalities of WEBI like Breaks, Sorts, Filters, and Sections in creating complex reports.
• Worked with Live Office and QAAWS for automation of Dashboards using Xcelsius.
• Involved in publishing the dashboards to thePortals.
• Worked on performance tuning of queries for faster execution of reports.

Environment: Business Objects XIR3/XIR2, Web Intelligence, Crystal Xcelsius 2008, Query As A Web Service, Live Office, Teradata 12.0

Confidential, Albany, NY

Business Objects & Business Intelligence Developer

Responsibilities:

• Designed Universes for Site manager reporting system and Order processing.
• Created Classes and Objects for universes and Reports like Construction reports, MaterialReports, standard and ad-hoc reports.
• Created reports & dashboards using Xcelsius, Web Intelligence & Crystal reports from multiple data sources.
• Involved in the troubleshooting of Universeschema with loops, chasm traps,fan traps and cardinality problems and checked Integrity of the Universes.
• Worked with Report Conversion Tool to convert DESKI reports to WEBI.
• Created DESKI Reports using PL/SQL Code.
• Created Universe Against PL/SQL Code.
• Generated the Business Objects reports using complex queries, Master/Detail, Cross Tab, Slice and Dice and Sub queries.
• Created various reports like the Combined Queries, Drill Down, Master Detail, Cross tab and Chart to make the reports easier for analysis.
• Created Scorecards, Metrics, Goals, and Alertsby using Performance manager and dashboard manager (EPM).
• Used different functionalities of WEBI like Breaks, Sorts, Filters, and Sections in creating complex reports.
• Worked with Live Office and QAAWS for automation of Dashboards using Xcelsius.

Environment: Business Objects XIR3,Crystal reports XI, Web Intelligence, Desktop Intelligence MS Access, SQL, Oracle 10g, and Crystal Xcelsius.

Confidential, Norfolk, Virginia

Business Objects & Business Intelligence Developer

Responsibilities:

• Generated Reports for purchasing and Fleet Management data using Crystal Xcelsius.
• Developed Vessel Management universe and Metric Universe for reporting with DESKI, WEBI, Performance and Dashboard Manager.
• Worked with Cognos report developers to convert the Cognos reports into business objects Reports
• Created filter objects, and formatted objects and measures within the universe for faster report generation.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Good knowledge on BW Data Architecture, Extended Star Schema models, and OLAP system.
• Worked with Live Office XIR2 and QAAWS for automation of Dashboards.
• Created Scorecards, Metrics, Goals, Alerts, Rules, used Dashboard Builder and Strategy Builder.
• Responsible for Creating Complex and Multi Dimensional reports using Master/Detail, Cross Tab, Slice and Dice and Sub queries.
• Created DESKI Reports using PL/SQL Code.
• Created Universe Against PL/SQL Code.
• Used Alerts, Filters, Breaks, Sorts and Ranks in the reports
• Worked with Web Intelligence XIR2, SQL Server 2005, Oracle and Info view.
• Created reports using Crystal XI by using universe or Business view as the data source
• Trained end users on WEBI, Scorecards and Xcelsius Dashboards.

Environment: Business Objects XIR3/XI R2, Oracle 10g,SQL Server 2005, Excel, Live Office XIR2, QAAWS, Cognos8

Confidential, Minneapolis, MN

Business Objects & Business Intelligence Developer

Responsibilities:

• Designed and developed new universes and update the existing universes.
• Involved in documenting the updated universes to Report Developers, Business Analysts.
• Good knowledge on BW Data Architecture, Extended Star Schema models, and OLAP system.
• Created Universe using Bex queries as a data source.
• Generated Web Intelligence reports based on SAP BI Universes.
• Involved in design and building BI Objects (Cubes, ODS object, Info Objects, Transformation, Data transfer process, Multi-providers, Info set and data marts).
• Generated Web Intelligence reports based on SAP BI Universes
• Generated dashboards using Crystal Xcelsius.
• Converted WEBI reports into Crystal Xcelsius Dashboards using Live office.
• Worked with Live Office and QAAWS for automation of Dashboards.
• Generated reports using Master/Detail, Cross Tab, Slice and Dice and Sub queries.
• Used Alerts, Filters, Breaks, Sorts and Ranks in the reports
• Good knowledge on Enterprise Performance Management (EPM).
• Created metric dashboard reports using live office, Crystal Xcelsius.
• Provided support for structured test phases such as System Acceptance, User Acceptance, Load Testing and Report Performance.

Environment: Business Objects XIR2, Crystal Xcelsius,Live Office, Oracle 10g,SQL Server 2005, SAP BI 7.0.

Confidential

Business Objects Developer

Responsibilities:

• Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
• Developed Universes using Designer and Business Objects for the reporting solution for Operational reporting System.
• Potential usage of alias, context, and shortcut join concepts to overcome the loops.
• Created Detail and Summary reports for Total text Messages send, Roaming charges, Direct Connect per second, for the frequency Monthly, Daily, and Weekly.
• Created reports that limit the reports to display information for particular measures by designing Complex Filters.
• Created Reports like, Reports by Product, Reports by Time (Year, Quarter, and Month Date).
• Created Complex Reports like Master Detail and Cross Tab.
• Developed Ad hoc reports using Business Objects.
• Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Involved in Importing/Exporting the Universes to repository to make available to the end user.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, and Formulas,Filters&Alerts for creating Complex reports.
• Conducted and assisted user training sessions.
• Used the Broadcast Agent for Scheduling and monitoring the Reports.

Environment: Business Objects XI/6.5, Oracle 8, SQL,PL/SQL, MS SQL Server 2000.

Confidential

Business Objects Developer

Responsibilities:

• Involved in report requirement gathering.
• Designed and maintained Universes and exported them to the repository.
• Created Classesand Objects (Measure, dimension and detail) in the universe.
• Used Designer Module to implement Universes, Joins between Tables, and createdpromptsand queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Developed ReportsUsing Master/Detail, cross tab, Charts.
• Created reports using standard company templates. A few of them were created based on the Department requirements.
• Extensive use of Business Objects functionalities in formatting reports.
• Created user Prompts, conditions and Filtersto improve the report generation. Also used Alerts to improve the readability of the report.
• Creating the reports in Web Intelligence.

Environment: Business Objects 6.5, Web Intelligence, Business objects Designer, Oracle, SQL,PL/SQL.

Confidential

Trainee/Junior Developer

Responsibilities:

• Developed Reports for cash transaction
• Created Tables, Indexes, Views and Sequences.
• Developed Packages for sales of all the products.
• Developed various procedures and functions.
• Developed Tender Notice forms using Form Builder.
• Designed and developed different forms and reports.
• Involved in development of Tables, Stored Procedures and Functions for data Manipulation and data processing.
• Involved in generation reports using Oracle Reports.