sivamala Pothireddy

Installed the BO 4.X server and client packages across the environments (Dev, Test & Prod) in both Linux and Windows, Upgraded all the environments from 4.1 SP4 to 4.2 SP7 and applied the patch8, Created additional SIA's and configured the BO servers as per the platform landscape, Implemented Oracle, SQL Server and Vertica data sources connectivity with BO, Migrated the BO enterprise content like reports, universes, connections and other dependencies from BO 3.1 to BOBI 4.X environment using Upgrade Management Tool

Participated in the Business and Functional Requirement Document review conducted by Business team to better understand the application requirements, Involved in translating the business questions and business requirements to technical requirements, Creating prototypes and demonstrate to business and stakeholders

Worked closely and interacted with product owners to gather the requirements, Responsible to gather the calculation requirements for various business units from data analysts and business owners, Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements

<p>Research, compile, analyze and report various operational data from multiple source such as Oracle data from multiple sources<br>
Develops requirements from users, retrieves required data, designs report, develops and disseminates reports<br>
Maintains accuracy and integrity of supporting database information<br>
Researches, compiles, analyzes and reports various operational data from multiple sources such as Oracle, Hadoop, SAP BW, HANA views and any other OLAP systems<br>
Meets with the user of the report, determines the requirements, understands where the data is located and designs the process to retrieve the data<br>
Creates queries and reports through the use of reporting tools to create efficiency within the department<br>
Upgraded all the environments from 4.1 SP4 to 4.2 SP7 and applied the patch8<br>
Created additional SIA's and configured the BO servers as per the platform landscape<br>
Implemented Oracle, SQL Server and Vertica data sources connectivity with BO<br>
Configured the OLAP connectivity’s like MSAS and SAP BW with the BOBI landscape<br>
Migrated the BO enterprise content like reports, universes, connections and other dependencies from BO 3.1 to BOBI 4.X environment using Upgrade Management Tool<br>
Created test reports and universes to check the different DB connectivity and performance stress in BOBI 4.X environment<br>
Involved in building BO 4.X Audit schema and Audit reports<br>
Migrated the applications content (universes and reports) from Pilot to DEV to ITG to PRO environment using Promotion Management<br>
Extracts information from databases in a variety of different formats such as DBIV, csv, txt, .xls, XML, FW, SAS, .rtf etc.<br>
Interfaces between raw data sources and front-end reporting services using table linking, embedding, import/export and file conversion techniques<br>
Produce and distributes monthly, quarterly and annual reports etc.<br>
Prepares ad-hoc analysis as requested<br>
Constant Interaction with Offshore counterparts and Offshore team regarding the changes and other development related activities<br>
Participate in department projects as assigned<br>
Research questions related to report information and calculations<br>
Leads and participates in department project as assigned<br>
Ability to perform Tableau administration with system upgrades, patches, performance tuning, issue resolution and debugging</p>

<p>Involved in requirement gathering/analysis, Design, Development, Testing, UAT and Production rollover of Reporting and Analysis projects<br>
Design and Develop Business Intelligence applications using MS technologies (SSAS, SSIS, SSRS) and Tableau<br>
Experience with Data Extraction, Transformation and Loading using ETL tools like SSIS, In-depth knowledge of industry standard ETL and BI tools<br>
Extremely working on complex applications and problems<br>
Capable of working on extremely complex applications and problems<br>
Analyzed and amend software/configuration errors in a timely by making appropriate changes as per the technical and functional requirements<br>
Conform to established company coding standards, follow standard company deployment and SDLC process<br>
Analyze and improved performance of software programs, determines configuration requirements for systems, analyzes requirements for data exchange between applications and other company’s third-party systems<br>
Guides or directs work of others who may perform similar or related work<br>
Document configurations, programs and subsequent revisions, inserting comments in the code/documentation<br>
Created detailed Functional Specifications Documents, including data samples, use cases, key project assumptions, report samples, data flows and data models<br>
Leveraged Tableau built in graphical capabilities to create Bar-charts, Tree-maps, Heap Map, Geo-maps, and Area-charts<br>
Interfaces between raw data sources and front-end reporting services using table linking, embedding, import/export and file conversion techniques<br>
Used Tableau and SSRS to create visual interactive dashboards, workbooks and stories for better decision making<br>
Created Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI)<br>
Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop<br>
Used Sets, Bins, Parameters, Aggregate Functions, Filters, Action in Tableau<br>
Used Tableau Desktop to analyze and obtain insights into large data sets<br>
Publishing the Worksheets, Dashboards and Stories on Tableau server to share it with multiple BU's<br>
Created visually compelling, actionable interactive worksheets and dashboards for the clients to analyze various KPIs<br>
Prepared migration and resource utilization plan and matrices to migrate Reports build in SSRS to Tableau<br>
Build several proofs of concepts dashboards in Tableau and SSRS to lay framework of analytics<br>
Developed Tableau reports including highlight tables, stacked bars, side by side bars, symbol maps, filled maps, heat maps<br>
Creating Excel Templates and Provide timely status reports and metric<br>
Using Excel Pivot table to manipulate large amount of data to perform data analysis, operation reporting, ad hoc queries and analysis<br>
Used Tableau and Excel Analysis to create KPI and scorecard to improve corporate profitability<br>
Using Excel Pivot table to manipulate large amount of data to perform data analysis, operation reporting, ad hoc queries and analysis<br>
Review the reports developed by peers and guide them whenever required and basically point of contact for reporting module<br>
Performed UAT review with Business Users and Business Intelligence Directors<br>
Conducting Performance tuning, applying user and row level securities<br>
Excellent knowledge in designing and developing dashboards using Tableau by extracting the data from multiple sources (Flat files, Excel, Access, Oracle, Hadoop)</p>

<p>Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects<br>
Designed and published customized interactive dashboards<br>
Used filters, parameters, sets, groups, BIN etc<br>
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop<br>
Assisted in the development, maintenance, and training of consistent processes around responsive requests for internal and external stakeholders<br>
Provided assistance to the Health Services Informatics Manager, such as assigning work, attending meetings, preparing talking points and briefings for executive management, and reviewing agency data publications<br>
Extensively used advance chart visualizations in Tableau like Dual-Axis, Box-Plots, Bullet-Graphs, Tree-maps, Bubble-Charts, Pie-Chart, Gantt-Chart, Histograms, Waterfall charts, Funnel charts etc. to assist business users in solving complex problems<br>
Good experience in administration, configuration, and maintenance upgrade setting up Tableau Server<br>
Extensively created very interactive dashboards like Drill Dashboards, Master detailed Dashboards; Multi Master Detailed Dashboards, Hiding Dashboard, Sheet Selector Dashboards, and Index Dashboards<br>
Found efficient ways to maintain the accuracy of the core information content that is being communicated, while at the same time presenting graphs and tables visually, and aesthetically<br>
Extensive experience in taking server backup and Site backup by using TABADMIN<br>
Created interactive dashboards by combining views in Tableau Desktop that was presented to Business Users, Engagement Managers, and End Users<br>
Utilized Tableau visual analytics and best practices like performance improvement, Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and of complex dashboards/reports<br>
Developed Cross Tab, Chart, Line, and Drill down through worksheets in Tableau<br>
Created Complicated Calculation Based LOD (Level of detail) feature<br>
Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring<br>
Worked extensively with Advance analysis, sets to create detail level summary worksheets and dashboards using KPI's<br>
Implemented Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, hierarchies<br>
Generated dashboards using dual axis and blended axis for comparison<br>
Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets<br>
Provided Training to different business users to develop dashboards in workspace and workspace advanced</p>

<p>Requirement gathering on from claim Analysts and managers<br>
Responsible for preparing technical specs, analyzing functional specs, development, and maintenance of application<br>
Shell scripts modification whenever required<br>
Understand the requirements (both functional and non-functional) by going through the specifications and inputs from Clients<br>
Developed Cross Tab, Chart, Line, and Drill down through worksheets in Tableau<br>
Constant Interaction with Onsite counterparts regarding the changes and other development related activities<br>
Analyzing the existing legacy data<br>
Develop the data model for migrating the legacy data to SQL Server Tables<br>
Implementing the business rules for the migrating the data from Legacy data to Dynamics CRM Tables (SQL Server)<br>
Preparing the mapping documents for migrating the legacy data to Dynamics CRM database (SQL Server)<br>
Building SSIS Packages for loading data from Legacy data to SQL Server staging tables<br>
Building the SSIS Packages for loading the data from SQL Server Staging database to Dynamics CRM Tables<br>
Implementing the best practices for increasing the performance of the SSIS Packages while loading data to Dynamics CRM Database<br>
Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments<br>
Created and maintained complex universes supporting multiple levels of hierarchies for drill down and drill across reports<br>
Troubleshooting if any issues with Reports (Technical support to Users)<br>
Running Integrity Checks on all Universe (including Test once) to ensure through parsing (Syntax/Sematic Checking)<br>
Discuss performance issues with DBA<br>
Monitoring Daily basis, Weekly and Monthly data loadings and quickly responding for any jobs failure<br>
Developing new packages as per client requirements and modifying the existing packages to increase the performance<br>
Done the Modification in existing packages to fix the issues<br>
Handling support incidents within resolution period</p>

<p>Monitoring Daily basis and Monthly basis jobs and quickly responding for any jobs failure<br>
Generating the sales reports for different medicines based on region level<br>
Developing new packages as per client requirements and modifying the existing packages to increase the performance<br>
Migrated and Conversion large volumes of data from legacy systems to oracle Database<br>
Implemented Incremental conversion in Informatica designer<br>
Created Mappings by using the Transformations such as: Source qualifier, Aggregator, Expression, Router, lookup, Filter, Sequence Generator, and Update Strategy<br>
Created interactive dashboards by combining views in Tableau Desktop that was presented to Business Users, Engagement Managers, and Senior Executives<br>
Flow Management into multiple targets using Router<br>
Used Informatica Workflow Manager to create Batches, Schedule & Monitor Sessions<br>
Used Debugger in Informatica<br>
Involved to improve the performance of mapping<br>
Prepared mapping documentations and Unit Test cases for each mapping<br>
Created Folder, Folder access to the users, Deployment groups, Labels, Managed the version control and moving the code to different environments from Repository Manager<br>
Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center<br>
Handling support incidents within resolution period</p>

<p>Created numerous Alerts that are executed based upon certain conditions<br>
Interacted with Users and Business Analysts to understand and document the requirements and translate these to technical specifications for designing<br>
Universes and Business Object Reports Development of reports for the given requirements<br>
Involved to improve the performance of mapping<br>
Preparing Mapping documentations and Unit Test cases for each mapping<br>
Created Folder, Folder access to the users, Deployment groups, Labels, Managed the version control and moving the code to different environments from Repository Manager<br>
Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center<br>
Unit testing the incorporated changes to verify whether they satisfy the new requirements and do not hamper the existing functionality<br>
Preparing the Test Plan, to describe the scenario for Testing Requirements and preparing the Test Results Documents for Verification of the code changes<br>
Reviewing the code changes for other modules in the team, as part of the internal processes followed<br>
Designed Universes using BO XI R3 designer<br>
Implemented various types of joins, defined cardinalities and resolved issues like loops & traps by creating aliases and contexts<br>
Created Classes (Sub classes), Objects, Prompts and Predefined conditions and custom Hierarchies for drill purposes<br>
Designed and Developed Web Intelligence Reports as per the user requirements<br>
Implemented different functionalities like Sections, Breaks and alerts<br>
Involved in testing the reports & universe<br>
Created user Prompts, Conditions and Filters as per the requirements of the end users<br>
Creation of Data Synchronization for objects which come from multiple data providers<br>
Developed Dynamic and Static Xcelsius Dashboards by Using QAAWS, Live Office, as per requirement</p>