We provide IT Staff Augmentation Services!

Bi Reporting Lead Resume

3.00/5 (Submit Your Rating)

Sunnyvale, CA

SUMMARY

  • Over 8.5 years of well - rounded IT experience including experience in areas of Banking/Finance, Healthcare, Retail and IT domains, with core competency in,Tableau, SAP Business Objects and good understanding of D Confidential warehouse technology
  • Extensive experience in Tableau Desktop, Tableau Server and Tableau Public
  • Highly Proficient in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill down and Drop down menu option and parameterized using Tableau
  • Experience in creating filters, Quick filters, D Confidential source filters, global filters, context filters and user filters
  • Expertise in working with demographic and geographic fields
  • Experience in creating aggregates, sets, joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, advanced calculations, pareto charts and parameters
  • Worked on the development of Dashboard reports for the Key Performance Indicators (KPI’s) for the top management
  • Designed and developed various analytical reports from multiple d Confidential sources by blending d Confidential on a single worksheet in Tableau Desktop
  • Experience in building BusinessObjects Universes, retrieving d Confidential using Universes, Personal d Confidential files, Stored procedures and Freehand SQL methods and creating complex, Ad-hoc Web intelligence Reports, Xcelsius Dashboards using the SAP Business Objects and Web Intelligence, Crystal Reports, Migration tool Import Wizard & LCM
  • Extensive business and technical experience in SAP BusinessObjects Architecture with different Application Servers, third party authentications and d Confidential bases
  • Administration work of SAP BusinessObjects: BOE Server configuration. Setting up BO repository objects security and privileges. Deployment of BO Enterprise Servers. BO reports/universes migration using LCM
  • Expert level of D Confidential Integration skills using Informatica Power Center to design, develop, implement and optimize ETL workflows and transformations to move d Confidential from multiple sources including flat files, RDBMS tables into Operational D Confidential Store (ODS), D Confidential Warehouse and D Confidential Marts
  • Developed SQL, PL/SQL queries and stored procedures with TOAD and SQL Developer.
  • Excellent experience in interacting with Business and IT cross-functional teams to gather and document detailed business requirements, ability to understand business drivers and translate them into technical specifications
  • Requirements Gathering and Analysis. Documenting business requirements. Preparing technical specifications, Gap analysis. Strong business analysis experience utilizing Agile, Iterative and Waterfall methodologies
  • Sound knowledge about Metad Confidential and ETL processes and strong familiarization with star and snowflake schemas
  • Expertise in Performance Tuning of overall d Confidential warehouse, d Confidential base, ETL and OLAP tuning coordinating with DBA’s and UNIX Administrator for better performance
  • Delivery of Services and Projects in line with the client's delivery methodology and framework. Facilitate greater alignment between IT and line of business while generating more flexibility
  • Ensuring that services delivered are within timelines and budget constraints and meet the required level of quality. Monitor the projects; provide timely updates and reports to stake holders
  • Provide detailed action plan and ensure issues are resolved in a timely manner and the appropriate corrective actions are implemented
  • Produce various forecasts for various aspects including resource, efforts, budget and utilization. Understand customer’s requirement, identify process gaps if any and facilitate appropriate solutions

TECHNICAL SKILLS

BI Tools: Tableau desktop / Tableau Server, SAP BusinessObjects, QlickView

ETL: Informatica

Markating: Starschema modelling, snowflake schema modelling, FACT and dimension tables, Pivot tables, MS Visio

Databases: Terad Confidential, Oracle, SQL Server, Access, Confidential DB2

Languages: C, C++, Java, SQL, PL/SQL, HTML and XML

Applications/Tools: MS Office suite, Adobe suite, Lotus Notes, Visual Source Safe 6.0, Share point, Ultra Edit, Documentum, HP Quality Center, JIRA, Remedy, Toad, SQL Plus, SQL Developer

Operating Systems: Windows, Linux, Unix

Business Skills: SDLC, Agile, Waterfall methodologies, Requirements gathering, wire frames, team management and documentation

Domain: Financial,Banking, Retail, Healthcare, and IT industry

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

BI Reporting Lead

Responsibilities:

  • Playing role as a Senior Terad Confidential Report and tableau developer; responsibilities as below:

    The Project involved marketplace integration reports and dashboards

  • Involved in reviewing business requirements and analyzing d Confidential sources from Excel/Terad Confidential for design, development, testing and production rollover of reporting and analysis projects within Tableau Desktop.
  • Preparing Analysis and Design document
  • Analyzing the business requirements & design document for the development of reports
  • Responsible for Developing of Tableau dashboards for business users
  • Use d Confidential visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their D Confidential
  • Designing the Reports as per client Requirement and created the reports using Excel file and Oracle d Confidential base.
  • CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making
  • Created demos inTableauDesktop and published ontoTableauServer.
  • Worked on motion chart, Bubble chart, Drill down analysis usingtableaudesktop.
  • DeployedTableauDashboards and worksheets in clustered environment.
  • Documented a whole process of working withTableauDesktop, and evaluating Business Requirements.
  • Provided support forTableau for various end users.
  • Interacted on a day to day basis with several different groups in order to achieve a common deliverable.
  • Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries
  • Hands on experience to extract, manipulate and built complex formulas inTableaufor various business calculations.
  • Involved in resolving reporting issues and design issues throughout the reporting life cycle.
  • Coordinating the work between onshore and offshore
  • User support for any ad-hoc issues/ queries
  • Managing PROD report schedules on enterprise level
  • Perform peer check on new developed reports
  • Technical to business users
  • Documenting business functional requirements. Preparing technical specifications

Environment: Terad Confidential 13, Tableau 8.1

Confidential, Long Beach CA

BI Reporting Lead

Responsibilities:

  • The Project involved ICD-10 Remediation for CCL and BO reports
  • Preparing Analysis and Design document.
  • Analyzing the business requirements & design document for the development of reports
  • Converting CCL & BO reports from ICD-9 to ICD-10 CM codes
  • Responsible for Developing of BO WEBI Reports for business users
  • Responsible for Users & Users groups creation in CMC & setting up of Security & Rights Management
  • Coordinating the work between onshore and offshore
  • User support for any ad-hoc issues/ queries
  • Managing PROD report schedules on enterprise level
  • Perform peer check on new developed universes /reports
  • BI4.1 Universe and WebI Report testing
  • Preparation of Documentation like Source BO white papers, User Manual, Test Logs etc.
  • Managing group and user permissions for the reports on Enterprise
  • Creating Access Levels as per the business requirements and assign to groups as applicable
  • User support for any ad-hoc issues/ queries
  • Managing PROD report schedules on enterprise

Environment: SAP BI 4, CMC3.1, Web Intelligence, Cerner Discern Visual Developer 2012

Confidential, Columbus, OH

BIConsultant & BO Lead

Responsibilities:

  • Worked as a BO Developer, BO Report Tester and Tableau Developer; responsibilities as below:
  • The Project involved in Migrating their existing BO universes and reports BO 6.5 Environment to SAP BO 3.1 Environment
  • Preparing Design and understanding document. Designing High level and Low level design document and unit test plan
  • Analyzing the business requirements & design document for the development of repository
  • Converting universes and reports to new d Confidential base. Validating the change
  • Responsible for Developing of BO Universes & WEBI/DESKI Reports which are extremely complicated and go against multiple d Confidential providers, linked Universes, etc.
  • Formatting of reports as per the Users requirements using Functions available in Web Intelligence XI 3.1, also the conversion of DeskI to WebI in XI 3.1 environment
  • Responsible for Users & Users groups creation in CMC & setting up of Security & Rights Management
  • Responsible for Promoting (Reports, Universes, connections etc.) from DEV to UAT & then to Production Environments via Import Wizard
  • Preparation of Documentation like Source BO white papers, User Manual, Test Logs etc.
  • Coordinating the work between onshore and offshore
  • User support for any ad-hoc issues/ queries
  • Managing PROD report schedules on enterprise level
  • Perform peer check on new developed universes /reports
  • BO3.1 SP4 migration to BI 4.1 SP2
  • BI4.1 Universe and WebI Report testing
  • Created various highly interactive dashboards and d Confidential visualizations reports for Ad sales and Program Finance Departments.
  • Involved in new KPI generation for Scorecards.
  • Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker plot, Stacked Bar.
  • Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.
  • Created conditional filters to filter the d Confidential on dashboard.
  • Creating Parameters for desired functionality.
  • Identify new metrics and enhance the existing KPI's.
  • Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Environment: LaunchPad 4.1, Web Intelligence 4.1, Universe Design Tool, Information Design Tool, CMC3.1, InfoView3.1, Terad Confidential 13/14, Tableau 8

Confidential of New York Mellon

Sr. BO Consultant/BO Administrator/BO Developer

Responsibilities:

  • Worked as a BO Administrator, BO Developer, Xcelsius Dashboard builder, BO Report Tester and responsibilities as below:
  • The Project involved in Migrating their existing BO 6.5 Environment to SAP BO 3.1 Environment
  • Designing BusinessObjects Security Model, creating Users/Groups within CMC as per the security Model & Managing group and user permissions for the reports on Enterprise
  • Creating Access Levels as per the business requirements and assign to groups as applicable
  • Preparing Design and understanding document. Designing High level and Low level design document and unit test plan
  • Analyzing the business requirements & design document for the development of repository
  • Responsible for Developing of BO Universes & WEBI/DESKI Reports which are extremely complicated and go against multiple d Confidential providers, linked Universes, etc.
  • Formatting of reports as per the Users requirements using Functions available in Web Intelligence XI 3.1, also the conversion of DeskI to WebI in XI 3.1 environment Responsible for creation of Xcelsius 2008 Dashboards on top of these WebI Reports using LiveOffice
  • Responsible for Users & Users groups creation in CMC & setting up of Security & Rights Management
  • Responsible for Promoting (Reports, Universes, Dashboards, Users etc.) from Dev to TEST to UAT & then TO Production Environments via Import Wizard/LCM
  • Responsible for managing the schedules using Instance Manager
  • Preparation of Documentation like Source BO white papers, User Manual, Test Logs etc.
  • Presented the QAAWS tool reporting and developing Web services. Using QAAWS tool and suggesting different ways of consuming the web services in Crystal Reports and Xcelsius Dashboards
  • Regularly monitored the server for any problems
  • Configured different destinations for scheduling developed a script for copying the user ps and cascading it
  • Deployment of BusinessObjects Enterprise XI 3.1 on the Test Environment for the entire Team
  • Providing BusinessObjects applications s to end users

Environment: CMC3.1, InfoView3.1, LCM3.1,Web Intelligence XI3.1, Import Wizard, MS SQL Server 2005/Oracle 11g, Apache Tomcat 5.5; BI Widget, Live Office 3.1, QaaWS, Xcelsius 2008, Windows 2003 Enterprise Server

Confidential

Sr. BO Consultant

Responsibilities:

  • Developed and updated documentation, including business process flows, materials, functional specifications, and test cases
  • Design and build WEBI Reports, Xcelsius Dashboards and Universes for clients. It involves day to day Client interaction to understand the specific details of the requirement and meet stringent deadlines
  • Formatted the Reports as per the Users requirements using Functions available in Web Intelligence XI 3.1
  • Developed many reports which are extremely complicated and go against multiple d Confidential providers, linked Universes, etc.
  • Responsible for Users & Users groups creation in CMC & setting up of Security & Rights Management
  • Online Resolution for Reporting issues using WebEx Technology
  • D Confidential reconciliation between Source and Target for the different sources
  • Managed group and user permissions for the reports on Enterprise
  • Regularly monitored the server for any problems
  • Configured different destinations for scheduling
  • Developed a script for copying the user ps and cascading it
  • Deployment of BusinessObjects Enterprise XI 3.1 on the Test Environment for the entire Team and have successfully migrated the BO 6.5.4 version to BO XI 3.1

Environment: SAP BusinessObjects enterprise XI3.1, Web Intelligence R2/ XI 3.1, BO XIR2 Enterprise, Xcelsius 2008,BI

Confidential

BO Consultant

Responsibilities:

  • The Project involved in Migrating their existing CE10 Environment to BOXIR2 Environment
  • Responsible for creation of BO Universes & WEBI Reports on top of SAP BW Cubes & Bex Queries
  • Responsible for creation of Xcelsius 2008 Dashboards on top of these Webi Reports
  • Responsible for Users & Users groups creation in CMC & setting up of Security & Rights Management
  • Responsible for migration (Reports, Universes, Dashboards, Users etc) from Dev. to Testing & then to Production Environments through Import Wizard
  • Preparation of Documentation like Source Confidential Doc., User Manual, Test Logs etc
  • Presented the QAAWS tool reporting and developing Web services. Using QAAWS tool and suggesting different ways of consuming the web services in Crystal Reports and Xcelsius Dashboards
  • Managed group and user permissions for the reports on Enterprise
  • Regularly monitored the server for any problems
  • Configured different destinations for scheduling
  • Developed a script for copying the user ps and cascading it

Environment: Business Objects XI3.1,Xcelsius 2008,Live Office XI3.1, SAP ECC 6.0, SAP BI 7.

We'd love your feedback!