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

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

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

Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
Designed and published customized interactive dashboards
Used filters, parameters, sets, groups, BIN etc
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
Assisted in the development, maintenance, and training of consistent processes around responsive requests for internal and external stakeholders
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
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
Good experience in administration, configuration, and maintenance upgrade setting up Tableau Server
Extensively created very interactive dashboards like Drill Dashboards, Master detailed Dashboards; Multi Master Detailed Dashboards, Hiding Dashboard, Sheet Selector Dashboards, and Index Dashboards
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
Extensive experience in taking server backup and Site backup by using TABADMIN
Created interactive dashboards by combining views in Tableau Desktop that was presented to Business Users, Engagement Managers, and End Users
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
Developed Cross Tab, Chart, Line, and Drill down through worksheets in Tableau
Created Complicated Calculation Based LOD (Level of detail) feature
Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring
Worked extensively with Advance analysis, sets to create detail level summary worksheets and dashboards using KPI's
Implemented Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, hierarchies
Generated dashboards using dual axis and blended axis for comparison
Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets
Provided Training to different business users to develop dashboards in workspace and workspace advanced

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

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

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