Uploaded File
add photo
Nirmala
nimmu.d07@gmail.com
971-772-8173
Portland, OR 97299
OTIS Elevator
12 years experience W2
0
Recommendations
Average rating
49
Profile views
Summary

  • Having 9+ years of experience in development of Data Warehousing projects using Business Intelligence Tools like Tableau 9.0, SAP BO 4.0/4.1, SAP Business Objects Explorer, SAP BO Mobile BI, Dashboards, Design Studio, SAP Lumira, Analysis OLAP, Business Objects 6.5/XI R2/R3, BI Testing, SQL Server 2008/2012,SQL Server Analysis Services (SSAS).
  • Design/Implementation for new requirements and functionalities for the Tableau Dashboard.
  • Upgraded Tableau Server from Tableau 8.1.6 to Tableau 9.0.3 version.
  • Good knowledge in configuration and administration of Tableau Server.
  • Migration of existing Excel Dashboards to Tableau – Challenges involved with features available in excel and not present in Tableau.
  • Technical hands-on expertise in SAP Business Objects 6.x/XI R2/R3/4.0/4.1, BO Dashboards, Web Intelligence ,Business Objects Explorer ,SQL Server Analysis Services(SSAS), Tableau 9.0.
  • Worked to Established SSO (Single Sign ON) between BO Server and SAP Enterprise Portal / SAP BW server.
  • Prepared system landscape, project plans for Dev, QA and PRD environments. Installed, Deployed and applied service packs for both client and Server products in SAP Business Objects 4.1, 4.0, XI 3.1, XI 3.0, XIR2, Business Objects 6i, 5i on windows platform.
  • Implemented Windows AD (Active Directory) authentication for all BO users.
  • Installed SAP BO 4.0 on Cluster environments for High system availability
  • Reports created on SAP data such as SAP BW cubes on BEX queries.
  • Technical hands-in expertise in SAP BO 4.0, Information Designer, Promotion Management Tool and Life cycle manager.
  • Worked with advanced options such as Hyperlinks, Drill downs and Merged Dimensions in Web Intelligence reports.
  • Used Life Cycle Manager (LCM)/Promotion management/Import Wizard for migrating the BO content from Dev to QA and QA to PRD.
  • Experience in Functionality Test Plan which was used by testing team while doing their testing process.
  • Involved in ETL process using procedures.
  • Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects.
  • Expertise in maintenance, troubleshooting and overall administration of the Business Objects Suite.
  • Worked for prestigious clients like GlaxoSmithKline(GSK),ERICSSON, VODAFONE, TATA COMMUNICATIONS
  • Excellent understanding of Star Schema modeling, Snowflake modeling. Fact, Lookup and Dimensions Tables
  • Proven track record of successful implementation of various project life cycle stages from requirements gathering through implementation and enhancements.
  • Managed and delivered large and complex assignments within time/cost and service level parameters.
  • Experience in client interaction for gathering business requirements.
  • Strong technical, communication, time management and interpersonal skills.
  • Confident, independent, leadership skills, good decision-making abilities.

TECHNICAL SKILLS

Business Intelligence : SAP BO 4.0/4.1/XI R3/R2/6.x, SAP Business Object Explorer, Web Intelligence, SAP Dashboards, SAP BO Mobile Application, SAP BO Analysis for Office, SAP Lumira,Tableau9.0, Voyager, Desktop Intelligence, SSAS and BEX.

Database : Oracle 11g/10g/9i/8i, SQL Server, Teradata

Operating Systems : Windows NT/2000X , Unix and Linux

Testing Tools : BI Testing, Quality Centre

Experience
BI Reporting Consultant 
Manufacturing
Jan 2018 - present
West Palm Beach, FL

Responsibilities:

  • Design/Implementation/coding for new requirements and functionalities for the Tableau Dashboard.
  • Development of Ad hoc Dashboards for Quick Analysis on very large volume of site and Transnational data sets.
  • Migration of existing Excel Dashboards to Tableau – Challenges involved with features available in excel and not present in Tableau.
  • Good knowledge in configuration and administration of Tableau Server.
  • Work with business teams in understanding the KPI and build the data for the KPI. Present the data in different visualizations/drill down, hierarchy and filter option.
  • Migration and Development of Wallet KPI Dashboard, Payment KPI, Business On boarding from MS Excel to Tableau
  • Release Reports and Dashboard into Development using the Tableau Dashboards.
  • Work with Data Technology (Data Management) Team to prepare back end to support Tableau Reports. Creation of Data space, granting and revoking user access and scheduling the queries.
  • Interacted with client to attain good business designs and product reviews.
  • Analysed the Business functionalities and studied for their feasibility and possible extent of report development solutions through the Reporting tool BO 4.0 using Web Intelligence.
  • Expertise, Administrated and worked on SAP BO 4.0/ SAP BO 4.1 Admin.
  • Prepared system landscape, project plans for Dev, QA and PRD environments. Installed, Deployed and applied service packs for both client and Server products in SAP Business Objects 4.0 on windows platform and migrated from SAP BI 4.0 to 4.1.
  • Worked on Different tools like Explorer, Information Designer, Promotion manager, Analysis Office and Dashboards.
  • Extensively used upgrade management tool to migrate reports from BOXI R3 to SAP BO 4.0
  • Installed latest and updated patches on BO systems to provide client with more stabilised environment that improved BO operations.
  • Implemented and installed Mobile BO Server such that all the reports generated is viewable through Mobiles
  • Provided extensive Support to developers for developing BO Reports also provided in-house training on SAP BO4.0 and BOXI R3.
  • Worked with daily/weekly/monthly and quarterly Reports such that we make sure business users have the correct data.
  • Maintained, fixed and resolved the issues when occur during report generation with permanent solutions.
  • Worked and created with different design layouts like Cross Tab, Vertical, Horizontal and Master Detail etc.
  • Generated and maintain the BO reports (Web Intelligence, Dashboards, Analysis Office and Explorer) and published to SAP Enterprise Portal, FTP server and BO Repository.
  • Prepared various Technical documents like creation of BO-Universe Fact-Dimension Matrix document, Data Element Sheet, IPS Universe Design document, Universe Dimension and data tables mapping document and updating the Report Functional Specification Document etc.
Tableau
Remove Skill
Tableau Developer
Chemicals/Pharmaceuticals
Jul 2014 - Dec 2016
London, AR

Responsibilities:

  • Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Created Rich dashboards using Tableau and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Created metrics, attributes, filters, reports and dashboards, created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Working as Tableau Server Administrator and Tableau desktop developer.
  • Installed and configured Tableau Server and Tableau Desktop.
  • Upgraded Tableau Server from Tableau 8.1.6 to Tableau 9.0.3 version.
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
  • Working with User for requirements and part of the team developing the software.
  • Published Tableau workbook to cloud and scheduled the refreshing of data.
  • Specialized in analyzing the incremental refresh scenarios.
  • Created Global Filters and applied for all the views in the dashboard.
  • Created Data Source and published into the server for other users.
  • Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
  • Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
  • Created Tableau scorecards, dashboards, Heat maps using show me functionality.
  • Worked in Ticket solving with in SLA’s (Service Level Agreement)
  • Involved in creating and updating Operational Manual document
  • Scheduled and Involved in technical discussion with the team members to find the gap between the business requirement and technical functionality
  • Worked with daily/weekly/monthly and quarterly Reports such that we make sure business users have the correct data.
  • Maintained, fixed and resolved the issues when occur during report generation with permanent solutions.
Data Visualization SQL Tableau Tableau Desktop Tableau Server
Remove Skill
Technical Consultant
Information Technology
Feb 2010 - Jun 2014

Responsibilities:

  • Analysed the Business functionalities and studied for their feasibility and possible extent of report development solutions through the Reporting tool BO XI R3 using Desktop Intelligence.
  • Involved in interacting with users to gather certain specific information while generating ad-hoc reports.
  • Designed OLAP Universe design using bex queries, Created universe objects like Dimensions, Details and Measures, Conditional Objects and Prompts Functions to meet the requirements.
  • Installed the patches and service packs for SAP BO 3.1 and applied SAP integration kit on server and client tools.
  • Desktop Intelligence – Worked Building reports in Desktop Intelligence using the Report Functional Specification Document. Enabled the user to conveniently enhance the presentation of reports having the functionality of User friendly and have a look & feel of BO-Reports to view them using web links.
  • Involved in Functionality Test Plan which was used by testing team while doing their testing process
  • Involved in technical discussion with the team members, and find the gap between the business requirement and technical functionality.
  • Prepared various Technical documents like creation of BO-Universe Fact-Dimension Matrix document, Data Element Sheet, IPS Universe Design document, Universe Dimension and data tables mapping document and updating the Report Functional Specification Document etc.
  • Directly coordinated with user to gather the new requirements and working with existing issues.
  • Implemented Windows AD (Active Directory) authentication for all BO users.
  • Installed SAP BO 4.0 on Cluster environments for High system availability
  • Installed SAP BI 4.0/4.1 Mobile applications
  • Implemented ETL mapping with performance techniques
  • Supported to other developers for developing BO Reports and provided in-house training on BOXI R3.
  • Involved end to end implementation of AE Reports project
Project Management SAP SAP BI SAP BOBJ
Remove Skill
BO Developer
Telecommunications
Jul 2009 - Jan 2010

Responsibilities:

  • Worked as BOXI R2 Administrator and Architecture
  • Involved in Ticket solving with in SLA’s
  • Involved in creating Operational Manual document
  • Involved in technical discussion with the team members, and find the gap between the business requirement and technical functionality
  • Involved in developing various Voyager reports.
  • Directly coordinated with user to gather the requirements and analyse the problem
  • Involved in troubleshooting in ETL Mappings
  • Worked in creating and maintaining Cubes in SSAS
  • Support for other developers for developing BO Reports and provided in-house training on BOXI R2.
  • Interacted with client to attain good business designs and product reviews maintaining the reports.
  • Resolving the issues regarding the reports Prod Environment.
  • Many reports generated are having different design layouts like Cross Tab, Master Detail etc.
  • All the reports are generated in Web Intelligence and can be accessed by the users through Internet browsers.
ETL SSAS Web Intelligence
Remove Skill
BO Developer
Retail
Feb 2009 - Jun 2009

Responsibilities:

  • Created webi reports by using relation universes and used different webi functions like, scope of analysis, sections, breaks, context operators , merged dimension, drill across, custom hierarchies, hyperlinks, alerts, report and query level filters and ranking.
  • Created the crystal reports using Crystal reports 2008 by using the oracle table and stored procedures for designing the report and used business view manager for creating the dynamic prompts and static prompts. Used different crystal functions like running totals, formulas using different functions and conditional formatting, created different and sub report to link to main reports.
  • Created the complex universes and resolved the loops, chasm traps and fan traps by using alias and context and other universe properties. Implemented row, column and object level security at universe level for data security and created custom hierarchies, cascading prompts and universe level filters to get better performance.
  • Used aggregate tables and @aggregate_aware functions to get best performance when different levels of aggregation involved.
  • Followed the best practices and migrated the BO content from BO XI R2 to BO XI R3.1 and re-configured the Business Objects security and performed the server sizing to improve server level performance.
  • Prepared various Technical documents like creation of BO-Universe Fact-Dimension Matrix document, Data Element Sheet, IPS Universe Design document, Universe Dimension and data tables mapping document and updating the Report Functional Specification Document etc.
  • BO XI R2 – Business Objects Report Developer.
  • BO-Web Intelligence - Building reports in Web Intelligence Java report Panel using the Report Functional Specification Document. Enable the user to conveniently enhance the presentation of reports having the functionality of User friendly and have a look & feel of BO-Reports to view them using web links.
  • Used BO Universe as source for the Business Objects reporting and analysis
  • Extensively use of calculations, variables, filters, and conditions, sorting and alerter for creating reports.
  • Maintaining the reports.
  • Resolving the issues regarding the reports.
  • Fixing Defects/Bugs of all WebI Reports based on Production Issues Document.
  • Support – 1 month of Post implementation support from offshore team and continues monitoring of Report Tracking Document to identify and fix bugs.
Crystal Reports Oracle Project Management Stored Procedure Java Web Intelligence
Remove Skill
BO Developer
Information Technology
Mar 2007 - Jan 2009

Responsibilities:

  • BO 6.5 – Universe Designer - Involvement in creating and modifying Business Objects Universes using BO Designer.
  • BO-Web Intelligence - Building reports in Web Intelligence Java report Panel using the User Stories. Scheduling reports Using Broadcast Agent and enable the user to conveniently enhance the presentation of reports having the functionality of User friendly and have a look & feel of BO-Reports to view them using web links.
  • Maintaining the reports.
  • Resolving the issues regarding the reports.
  • To create and run the scripts for loading the live data for 16-network circles of Vodafone Essar Ltd.
  • Used Universes as source for the Business Objects reporting and analysis.
  • Many reports generated are having different design layouts like Cross Tab, Master Detail etc.
  • All the reports are generated in Web Intelligence and can be accessed by the users through Internet browsers.
  • Worked on creating reports to scheduled using a separate tool BCA (Broad Cast Agent) into different periods as per the business requirement. They include daily, weekly and monthly scheduled reports.
  • Generated and maintain the BO reports (Web Intelligence, Dashboards, Analysis Office and Explorer) and published to SAP Enterprise Portal, FTP server and BO Repository.
  • Reports tested for correct data population for the monthly and daily scheduled reports.
  • Extensively use calculations, variables, and filters, conditions, sorting and alerter for creating reports.
  • Involved in interacting with users to gather certain specific information while generating ad-hoc reports
Java SAP Web Intelligence
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Computer science and Information Technology
Ramappa Engineering College
Record has not been verified.
Certifications
SAP Business Objects Certified Professional - Certified on
Skills
SAP
2014
6
Project Management
2014
4
SAP BI
2014
4
SAP BOBJ
2014
4
Tableau
2021
4
Data Visualization
2016
2
Java
2009
2
SQL
2016
2
Tableau Desktop
2016
2
Tableau Server
2016
2
Web Intelligence
2010
2
Crystal Reports
2009
1
ETL
2010
1
Oracle
2009
1
SSAS
2010
1
Stored Procedure
2009
1