Candidates About

Uday Mandava

Summary:

• Around 9+ yrs of experience in Analysis, Design, Development, Testing, Implementation and Production support (24*7) in Tableau Developer DW/BI applications with Roles Tech Lead, Senior SAP Business Objects developer, and Informatica Developer.
• Experience with SAP BOBJ 4.2/4.1/4.0/BOXI R3.1/R2/6.5, Universe Design Tool & Information Design tool, Designer, BI Launch pad, Web Intelligence Rich Client, InfoView, Live Office, Desktop Intelligence,  upgrade management tool, Central Management Console, Crystal Reports, Xcelsius, Dashboard Design.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8.x/9.x/10.x.
• Experience with ETL process using Informatica Power Center 9.x/8.x/7.x Power Exchange, Designer (Source Analyzer, Warehouse designer, Mapping designer, Metadata Manager, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema, Also have vast experience in slowly changing Dimensions and Meta data management. Good Understanding of Data Modeling concepts, Erwin – Forward & Reverse Engineering, Dimensional Data Modeling –Bill Inman, Kimball.
• Experience in Understanding Business Requirements, Technical Design, Estimation and Project Management activities, also have experience in Reqpro and Rational Tools.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.
• Used Live Office and QAAWS (Query as a Web Service) to feed live data into Xcelsius 2008 (both Dashboards & Scorecards).
• Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.
• Complete Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
• Extensive experience in Preparing Flow Charts, Analysis Reports, Technical Design documents, Profiling.
• Proficient experience in designing SQL’s using Oracle, Teradata, SQL Server, DB2, PL/SQL and working with flat files.
• Extensive knowledge in various reporting objects like Facts, Attributes, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters in Tableau.
• Experience in understanding Fact Tables, Dimension Tables and Summary Tables.
• Experience including analysis, modeling, design, and development of Tableau reports.
• Experienced on Tableau activities, Multidimensional database and writing SQL queries.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.
• Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Created and updated server architecture for scheduling tasks.
• Analyzed and resolved performance and server based issues.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Creating user’s groups projects Data connections settings as a tableau administrator.
• Handled Tableau admin activities granting access managing extracts and Installations.
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server and Worked on integrating data from XML files, flat files like fixed width and delimited.
• Created UNIX shell scripts to run the Informatica workflows, FTP and controlling the ETL flow. Have worked and User scheduling tools like WLM, Control M.
• Expertise in Teradata query tuning (Reduce skews), Database tuning and in Informatica Power center to identify bottlenecks, tune and remove bottlenecks. Query Rewrite, tuning Mappings and Sessions.
• Have expertise in Industry’s best practices, Coding standards. Preparing User Manuals, Presentations, Bug Fixing, Troubleshooting, Root Cause analysis and Solution Development.
• Experience in Peer-reviewing the Codes Results Transformations and Performance as part of System Integration Test (SIT) and User acceptance Test (UAT)
• Have good experience in Managing Team Offshore and Onshore to Coordinate Work.
• Good communication skills, documentation skill interpersonal skills, self-motivated, quick learner, team player.

Skill Set

           ETL Tools                                                  : Informatica 9.1/8.6.1/8.1.1/7.1.2

          Reporting Tools                                  : SAP Business Objects 4.2/4.1/4.0/3.1/XIR2/6.5, Tableau 10.x/9.x/8.x.

           Database                                                  :  Oracle, DB2, Teradata v 13/v12/v2r5, SSAS.

           Database GUI                                         : Teradata SQL assistant, TOAD, SQL Developer, Mainframe DB2.

           Programming Languages                   : PL/SQL, UNIX Shell Script, JCL, COBOL, Ezetrieve, VSAM

           Operating Systems                              : UNIX, Windows NT/2000/XP/7, OS/390, ZOS (Mainframes)

           Development Tools                            : Endeavor, File manager, DVO and debugger

Professional Experience

CAMBRIA, Belle Plaine, MN                                                                                                                                       OCT 2017 – Till Date

Senior Tableau Developer / Senior SAP Business Objects Developer & Crystal Reports Developer          

Responsibilities:

·         Building, publishing, scheduling reports and dashboards using Tableau server.

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.
• Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
• Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
• Extensively used data blending, embedded functionalities in Tableau.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.

• Create, customize & share interactive web dashboards with simple drag & drop method and access them from any browser.
• Created Rich dashboards using Tableau Dashboard 10.3.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Extracting the data tables using custom generated queries from Excel files, SQL database and providing extracted data as an input to Tableau.
• Provided 24/7 production support for Tableau users and conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Created SQL Queries for testing the tableau Dashboards.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Developed Universe as per the Business requirements.
• Resolving the loops using Contexts and Alias and checked the cardinalities, Integrity of the Universes.
• Worked very closely with upper management to get detailed information on what information they require in each report.
• Created Universes, Reports, and Linked with existing Universe, Resolved Loops and Traps.
• Developed and created classes with dimension, detailed and measure object and specified hierarchies.

·         Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins. Thus Considering best business Practices using Web intelligence Rich Client.

·         Developed a complex provider scorecard dashboard with multiple tabs using dynamic visibility. This dashboard shows the high-level information of rolling 12 months of provider performance data varying across different areas like productivity, machine utilization, compliance and quality. The dashboard also has the capability of drilling down to the detail data on to the detail webi reports.

·         Designing SAP Business Objects Universes and reports based on the Specifications.

• Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes meeting User Needs and Requirements from both technical and strategic views of an organization.

·         Extensive experience in SAP Business objects which include Web Intelligence (WebI), Universe designer, SAP Business objects dashboards, Crystal Reports.

• Developed complex reports in Crystal Reports from multiple data sources like Universes and SQL queries.
• Created complex Crystal reports with standard sub reports, cross-tab reports, formulas, Running totals, Grand totals and calculations. Also, added sorting, grouping and summarizations to Crystal Reports.
• Created the Reports using the Universes as the main Data providers and wrote complex queries including Sub Queries, Case and Decode functions, using Crystal reports.
• Actively involved in with ETL team to get right data to create crystal and BO reports.
• Worked as an IT support to solve issues/tickets related to SAP Business objects/Crystal reports.

• Involved in-group meetings to analyze business requirements by close interaction with the Users and Business Analyst team.

Environment:  Tableau desktop 10.3, Tableau Server, SAP Business objects 4.2, Designer, Web Intelligence,

                                Crystal reports 2016, Oracle, Windows XP, SQL, PL/SQL, Oracle, MS-Excel, Microsoft SQL Server.

Mayo Clinic, Rochester, MN                                                                                                                                       FEB 2017 – OCT 2017

Senior Tableau Developer / Senior SAP Business Objects Developer & Crystal Reports Developer

Responsibilities:

·         Building, publishing, scheduling reports and dashboards using Tableau server.

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.
• Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
• Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
• Extensively used data blending, embedded functionalities in Tableau.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.

• Create, customize & share interactive web dashboards with simple drag & drop method and access them from any browser.
• Created Rich dashboards using Tableau Dashboard.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Extracting the data tables using custom generated queries from Excel files, SQL database and providing extracted data as an input to Tableau.
• Provided 24/7 production support for Tableau users and conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Created SQL Queries for testing the tableau Dashboards.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.

·         Extensive experience in SAP Business objects which include Web Intelligence (WebI), Universe designer, SAP Business objects dashboards, Crystal Reports.

• Developed complex reports in Crystal Reports from multiple data sources like Universes and SQL queries.
• Created complex Crystal reports with standard sub reports, cross-tab reports, formulas, Running totals, Grand totals and calculations. Also, added sorting, grouping and summarizations to Crystal Reports.
• Created the Reports using the Universes as the main Data providers and wrote complex queries including Sub Queries, Case and Decode functions, using Crystal reports.
• Actively involved in with ETL team to get right data to create crystal and BO reports.
• Worked as an IT support to solve issues/tickets related to SAP Business objects/Crystal reports.
• Created various Dashboard reports to measure the performance of several marketing programs.
• Created and developed Analytics and Alerts for individual Dashboards, specific to functional heads.

• Involved in-group meetings to analyze business requirements by close interaction with the Users and Business Analyst team.
• Developed Universe as per the Business requirements.
• Developed and created classes with dimension, detailed and measure object and specified hierarchies.
• Resolving the loops using Contexts and Alias and checked the cardinalities, Integrity of the Universes.
• Worked very closely with upper management to get detailed information on what information they require in each report.
• Created Universes, Reports, and Linked with existing Universe, Resolved Loops and Traps.
• Developed and created classes with dimension, detailed and measure object and specified hierarchies.

·         Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins. Thus, considering best business Practices using Web Intelligence Rich Client.

·         Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.

·         Developed a complex provider scorecard dashboard with multiple tabs using dynamic visibility. This dashboard shows the high-level information of rolling 12 months of provider performance data varying across different areas like productivity, machine utilization, compliance and quality. The dashboard also has the capability of drilling down to the detail data on to the detail webi reports.

·         Designing SAP Business Objects Universes and reports based on the Specifications.

• Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes meeting User Needs and Requirements from both technical and strategic views of an organization.

Environment:  Tableau desktop 10.0/9.0, Tableau Server, SAP Business objects 4.1, Designer, Web Intelligence, Crystal      

                            reports 2011, Oracle, Windows XP, SQL, PL/SQL, Oracle, MS-Excel, Microsoft SQL Server.

Department of Transportation, Madison, WI                                                                                                      Feb 2015 – Feb 2017

Senior Tableau Developer/ Senior Business Objects Developer

Responsibilities:

·         Building, publishing, scheduling reports and dashboards using Tableau server.

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.
• Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
• Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
• Extensively used data blending, embedded functionalities in Tableau.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Extensively involved in user acceptance testing (UAT).
• Performed Parallel Testing which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.      

·         Interacted with business Users and Managers in gathering SAP Business requirements.

·         Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.

·         Creating, developing, maintaining and testing the Universe for running the queries against the Database using Designer.

·          Involved in the designing and Building of Universes, Classes and objects.

·         Created Derived tables in the Designer to enhance the capabilities and performance of the universe. 

·         Resolved loops and Traps using Contexts and Aliases while designing Universes. 

·         Worked with database connections, SQL joins, cardinalities, loops, aliases, views, parsing of objects and hierarchies.

·         Check the integrity of the Universes, and export the universes to Repository for making available to users.

·         Customized Universe Level Prompts as per Functional Requirements. 

·         Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes Meeting User Needs and Requirements from both technical and strategic views of an organization.

·         Developed new set of standard Web Intelligence 4.1/3.1 reports against the new universe. Completed ad-hoc data requests as required.

·         Set up Universe level conditions to restrict data based on report requirements.

·         Analyzing system functionality requirements, documents and scope of the work.

·         Converted business requirements in business/technical requirement documents.

·         Created Repositories, Users & assigned the security in the Multi-Team Environment.

·         Extensive experience in SAP Business objects which include Web Intelligence (WebI), Universe designer, SAP Business objects dashboards, Crystal Reports.

·         Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins. Thus, considering best business Practices using Web Intelligence Rich Client.

·         Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports. 

·         Expertise in Resolving the Daily issues in the Daily Doc Production Environment.

·         Scheduling and publishing reports onto WEBI to different destinations

·         Trained end users in understanding the reports.

·         The project involved in the development of reports using SAP Business Objects Web Intelligence to cater Ad-hoc reporting needs. 

·         Involved in the testing and migration process of SAP Business objects 3.1 to 4.1.

·         Developed a complex provider scorecard dashboard with multiple tabs using dynamic visibility. This dashboard shows the high-level information of rolling 12 months of provider performance data varying across different areas like productivity, machine utilization, compliance and quality. The dashboard also has the capability of drilling down to the detail data on to the detail webi reports.

·         Created Standard Reports utilizing all the features on Web Intelligence in BO like Optional Prompts, Functions, and Alerters etc. 

·         Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports. 

·         Extensively worked with formatting the reports according to the user requirements. 

·         Extensive experience in SAP Business objects reporting in the context of developing the Universe using the Universe Designer and the Analytics using Xcelsius and Webi.

·         Good knowledge in creating Xcelsius Dynamic Dashboards and valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors.

·         Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).

·         Worked on installation and configuration of Business Objects 4.1 Enterprise Suite (Desktop Intelligence, Central Management Server, Central Management Console, Auditor and Dashboard Manager).

·         Created Multiple Objects through Central Management Console in various formats including MS Excel, Word and Adobe Acrobat.

·         Administration of Business Objects Enterprise using Central Management Console (CMC), Central Configuration Manager (CCM), and Publishing

Environment: Tableau 9.0/8.1, Tableau Server, BO XI 3.1/4.1, Informatica, DB2, Windows Server 2008/2012, Oracle,

                                Microsoft SQL Server, MS-Excel.

Anthem Inc. Albany, NY, USA                                                                                                                                    March 2013 – Feb 2015

Senior Tableau Developer/ Senior Business Objects Developer

Responsibilities:

• Responsibility as Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
• Extensively used data blending, embedded functionalities in Tableau.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards with simple drag & drop method and access them from any browser.
• Created Rich dashboards using Tableau Dashboard.
• Used data sources like SQL, Oracle, Sales force, SSAS cubes and files to generate reports in Tableau

• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for

      analysis purposes using SQL Server Analysis Services SSAS 2008.

• Based on DW data, created SSAS Cube to analyze data in Excel, as well as for reporting purposes in Tableau.

• BOBJ Developer include building business intelligence and data warehousing solutions. Assist clients in defining report requirement, project scope and resources.

• Interacted with the Business users and gathered the business requirements to design and develop Universes & reports.
• Performed analysis, design, develop, testing and Maintenance of IDT & UDT Universes.
• Develop highly complex and formatted Webi reports for internal management.

• Responsibility includes scheduling and monitoring data loads, report processing, supporting report developers, performing requirements gathering and data modeling for system enhancements and future releases, addressing production break and fix issues, managing transport migration process, recommend and implement performance tuning enhancements as needed.
• Building, publishing, scheduling reports and dashboards using Tableau server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.
• Created WEBI reports with Hierarchy prompt, calculation, chart, drill down features, formulas and variables. Created hyperlinked WebI reports with Open document functions.
• Created Info Objects, Info Sources and Source Systems to load data into Info Cubes using Transformation and DTP.
• Prepared of TS (Technical Specification), UTP (Unit Test Plan) and Release Plan Documents.
• Creating users, folders, Categories and groups assigning the access levels.
• Applied security features of Business Objects at row level in the universe to make the sensitive data secure.
• Ensure that the reports produced are accurate, relevant, complete and actionable.
• Effectively handled setting up the objects as Dimension, Detail or Measure based on business rules.
• Extensively used Calculations, Break points, Drill down, @Functions and Formulas, Filters and Alerts for creating Complex Web intelligence reports.
• Implement best practices in reports and universe development.
• Facilitate team with writing technical design specifications for the data flow.
• Developed complex interactive dashboards using Dashboard Design.
• Conduct Training session for Power Users on creating ad-hoc reports and various functionalities of WEBI reports.
• Created Different type of Graphs (Bar, line, Pie chart etc) and Cross Tabs with all sorts of formatting for report level analysis.

·         Performed data investigations and integrity checks and accountable for testing of Reports before sending to UAT.

• Created User conditions and Filters to improve the report generation. Also, used Alerts to improve the readability of the report.
• Design and develop WEBI reports in BO 4.0 to evaluate new feature and functionality to support the future upgrade.
• Developed complex reports in Crystal Reports from multiple data sources like Universes and SQL queries.
• Modified existing reports based on the business user’s requirement changes and successfully pushed them into Production.
• Published reports on Business Objects Enterprise and Configured Info view and Central Management Console. Schedule Reports for the users.
• Creation of executive dashboard volumes, imbalances, accounting details, and customer information related to acquisition.
• Constructed dashboards to review data validation results and Improvement of existing dashboards organization and bug fixes.
• Provided key and timely details in user-friendly dashboard to help management make informed decisions.
• Responsible for interaction with business stake holders, gathered user