Sridhar Adduri

Sr BI Developer

Saint Charles, Missouri, United States ad467j@r.postjobfree.com 314-***-**** https://www.linkedin.com/in/sridhar-adduri/

SUMMARY

*Over 12+ Years of comprehensive experience in Data Analysis, Business Analysis, Quality Auditing, Effective Reporting, Project Management and various applications in the environment using BI tools.

*Expertise in creating data models & executive dashboards through continuous collaboration with various levels of Business stake holders using Power BI, Tableau & MicroStrategy.

*Created Power BI dashboards, scorecards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

*Sharing Content via Power BI Apps.

*Worked with Google Cloud (GCP) Services like Compute Engine, Cloud Functions, Cloud DNS, Cloud Storage and Cloud Deployment Manager and SaaS, PaaS and IaaS concepts of Cloud Computing and Implementation using GCP.

*Experience in analyzing the BI needs, interpreting business user requirements and translating them into reports.

*Incorporated UI/UX best practices to improve the overall user experience, leading to increased adoption and usage of the analytics platform.

*Good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software, and product.

*Strategic planner with expertise in formulating business continuity plans, identifying and adopting emerging trends to achieve organizational norms and profitability forms.

*Implemented different software methodologies like Agile and waterfall in different projects.

*Extensive experience in visualizing the design of the system by UML, Class diagrams, ER Diagrams and Wireframes.

*Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business users and developers.

*Proficient in Data Flow Diagrams and Flow Charts.

*Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema.

*Hands on experience in developing SQL for data analysis and testing script.

*Developed SQL queries for data extraction, analysis and reporting.

*Working closely with UAT personnel to both ensure that their needs are met, and to provide sufficient understanding for the UAT test teams to own the automated system by the end of the project.

*Proven experience in Optimization/Performance tuning of complex reports/queries/ETL's in quick turnaround time by dissecting the execution plans across all database platforms.

*Used Visio to carry out the business modeling and object modeling effort to develop the business architecture for the application for rapid and controlled Application development.

*Sound knowledge and experience in Data Warehousing concepts such as Dimensional Modeling, Star Schema, Snowflake Schema, Data Marts, OLAP, Fact and Dimension Tables.

*Experienced in performance tuning of Web & Mobile Dashboards for better user experience.

*Created variety of dashboards including Operational Analysis, Offer & Campaign Analysis, Sales Analysis, Executive Summary, Financial Summary & KPI Dashboards.

*Worked on performance tuning of various MicroStrategy Reports in MicroStrategy Desktop by tuning the VLDB properties and by various design techniques.

*Expertise in using Pass - Through functions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.

*Experience in working with MicroStrategy Security model including Users, Groups, Security Roles and Security filters.

*Excellent analytical skills with interpersonal, communication and organizing skills.

EXPERIENCE

Sr Data Engineer/BI Developer

Maximus December 2019 - Present

Project: SOA PAX.

Worked as a Data Engineer/BI Developer for SOA-PAX at Maximus. SOA-PAX deals with Call Center Data and developing Agent Quality/Quantity insights. This also includes Agent Feedback/Sentiment Analysis, Call Flow Analysis & supporting Data Science Teams.

Responsibilities:

*Build, schedule and maintain Data Pipelines using Stream sets.

*Ingest Parquet Files into Snowflake via Stream sets.

*Designed and developed dashboard and tiles using Power BI site as well as Reports and Data Models using Power BI Desktop.

*Convert existing manual Excel/Access/Power BI datasets/reports into SQL Server/Analysis Services/Power BI solutions.

*Worked on Docker Container to deploy the code and the Kafka Jobs were executing on Docker and Multiple docker images were developed and deployed.

*Scheduled data refresh utilizing on-premises power BI gateway with Power BI services.

*Strong experience in Scripting, developing and designing Dashboard in Power BI (SAAS).

*Worked on the framework to load the s3 bucket data into Snowflake and vice versa.

*Developed validation framework using Python to validate the source data vs Snowflake data to make sure jobs are running perfectly.

*Collaborated with UX/UI designers and cross-functional teams to ensure seamless integration of Power BI analytics into larger user-facing applications.

*Leveraged UI/UX principles to craft compelling data stories, effectively communicating insights to non-technical stakeholders.

*Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

*Built Power BI Apps for sharing Content showcasing Medical Director's Quality and Quantity Dashboard .

*Experience with multi-tenant SaaS based solutions a plus.

*Created Lambda Functions to copy the incoming file from one s3 bucker to other.

*Worked on the framework to load s3 data into Snowflake using Stream sets Ingestion.

*Build and Maintain data in Snowflake to support Data Science Teams.

*Analyze, Review, and build POC's for any new tools to be introduced in the Org.

*Design architecture and development including BI, database, ETL, application, and system.

*Analyze requirements to design and develop optimal solutions.

*Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

*Develop new application software specifications and construct application code.

*Maintain existing application software specifications and technical documentation.

*Follow quality assurance standard to be used during design, development and implementation phases.

*Support systems in test and production environments and assist with problem resolution/debugging.

*Support and maintain existing applications and develop enhancements to existing software.

Sr BI Developer

Centene Corporation December 2016 - December 2019

Project: Medical Director and Utilization Management.

Worked as a Bi Developer at Centene Corporation. Every Healthcare Claim goes through a streamlined review process. Claims need to qualify under certain criteria InterQual, Manual etc. to get approved. Worked on showing both Quality and Quantity of work done by Advisor and Clinical Reviewers.

Responsibilities:

*Designed and Developed ETL pipelines in and out of data warehouse using combination of Python and Snowflake's Snowsql. Wrote SQL queries against Snowflake.

*Designed, developed, and tested the ETL strategy to populate data from multiple source systems.

*Designed SSRS reports for in depth business analyses.

*Designed expressions to calculate, group, filter, parameterize, and format report contents.

*Proficient in analyzing diverse data sources to understand their structures, content, and relationships.

*Skilled in collaborating with stakeholders to gather requirements and define data ingestion strategies.

*Experienced in developing source-to-target mappings to document data flows and transformations.

*Proficient in implementing data standardization processes to ensure consistency and quality across the data lake.

*Capable of designing and maintaining data models to support efficient storage and retrieval of data.

*Skilled in performing data profiling and analysis to identify anomalies, trends, and patterns.

*Experienced in working closely with data engineers to develop and optimize data pipelines for ingestion and processing.

*Capable of conducting data validation and reconciliation to ensure accuracy and completeness of the data lake.

*Proficient in documenting data lineage, metadata, and data governance policies to support compliance requirements.

*Experienced in providing technical expertise and guidance to cross-functional teams on data lake best practices.

*Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

*Built Power BI Apps for sharing Content showcasing Medical Director's Quality and Quantity Dashboard.

*Implemented SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-Threading Concepts with Synchronous and Asynchronous transactions.

*Designed SSRS reports for in depth business analyses.

*Structured and integrated internal and external data with SQL, Oracle & Teradata as data source to expand the data universe utilized by Compliance & Utilization Management, HIPPA Data dashboard and other business control report POC's using SSIS, SSRS, POWER BI/Tableau.

*Data modelling & maintenance of DataMart objects including performance Tuning, Indexing & Query optimization for improved performance and availability of reports.

*Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.

*Designed expressions to calculate, group, filter, parameterize, and format report contents.

*Provided production support for Data Warehouse issues such data load problems, transformation/translation problems etc.

*Integrated on premise infrastructure with public cloud (AWS) infrastructure.

*Translated requirements for BI and Reporting to Database design and reporting design.

*Automated data pipelines using cloud based and on-premises technologies.

*Worked extensively in creating MicroStrategy Application Objects such as Compound Metrics, Level Metrics, complex Filters, Custom Groups, Consolidations, and nested Prompts.

*Created and modified attributes, facts, hierarchies, and transformation objects as part of the development work for a project. Employed various schema modeling techniques like compound attributes, heterogeneous mapping, role attributes by aliasing the tables and other techniques.

*Ensured proper relationships were established between the attributes to avoid any improper SQL query joins.

*Ensured that the logical sizes of the tables were properly set to facilitate the selection of the right tables by SQL engine for a given query.

*Created Logical views in MicroStrategy for complex report creation scenarios. Used free form SQL editor for complex report creation.

*Developed scorecard and dashboard that provide users a highly graphical, summary view of key metrics. Created Advanced Dashboard with panel stacks, complicated grid and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash and Interactive modes.

*Create Drilling paths and implemented those into reports so that user can Drill across different System and User hierarchies.

*Worked with MicroStrategy Object Manager to move objects among the Development, Test, and Prod environments.

BI Data Analyst

Cognizant Technology Solutions November 2013 - July 2015, IN

Client: United HealthCare. Project: Claim Processing.

Worked as an EDI analyst in cognizant. United Healthcare Community currently supports the claims payment systems of Facets. Due to the multiple claims platforms, United Healthcare Community has selected TriZetto’s Facets claim platform as the claims management system for all of Community and State. FACETS application is one part of the Community and State Strategic Platform (CSP) and is the Community and State Franchise model. These projects involve providing independent testing services to test the Membership processing through EDI 834, Providers, and Claims processing via EDI 837, Billing, Reports and Letters, Various Inbound and Outbound interfaces for Provider, Membership, Billing and Claims functionalities.

Responsibilities:

*Responsible for requirements gathering, documentation, research, and analysis.

*Analyzed the data and implemented the requirements using Teradata 14.10.0.10.

*Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to Teradata tables.

*Worked on creating Stored Procedures to be able to generate data which will ease the front-end development.

*Created Summary and Detailed reports showing Daily, Weekly and Monthly Snapshots of the Process.

*Analyzed the business requirements and involved in writing Test Plans and Test Cases.

*Ensured all artifacts compiled with HIPAA 5010 policies and guidelines.

*Developed MicroStrategy data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

*Provided Production support to MSTR users and Wrote Custom SQL to support business requirements.

*Extensively used SQL queries to retrieve data from database using SQL Assistant. Tested and modified SQL Packages and Stored procedures.

*Responsible to provided Metrics in the form of Monthly, Weekly and Daily Status Reports.

*Address Production issues to be able to solve and migrate updates.

*Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.

*Created specifications for reports creating from data warehouses.

*Analyzed the business requirements and involved in writing Test Plans and Test Cases.

*Ensured all artifacts compiled with HIPAA 5010 policies and guidelines.

*Converted existing BO reports to tableau dashboards.

*Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

*Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

*Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's.

*Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

*Have good knowledge and Testing experience on Billing and Accounting deliverables.

*Extensively used SQL queries to retrieve data from database using SQL developer. Tested and modified SQL Packages and Stored procedures.

*Responsible to ensure Invoices, ID cards, Member Packets, Letters and various other functionalities are working as expected.

*Responsible to provided Metrics in the form of Monthly, Weekly and Daily Status Reports.

*Responsible to host status calls with project stake holders.

Business Analyst / Data Analyst

Cognizant Technology Solutions July 2012 - October 2013, IN

Client: Google, India. Project: BebaPay.

Worked as an Analyst for a project for Google liaised with third party vendor for their new product 'BebaPay Accounting'. BebaPay is a payment card used for public transit in Kenya. To register a Beba card the individual must have a Gmail account or register at Beba teller location.

Responsibilities:

*Lead and trained a Team size of 37. Awarded as the best Trainer and Star Performer for 2 consecutive years.

*Analyzed and optimized the process to capture Business Requirements and then converted Business requirements into Functional Requirements Specification and Technical Specification. Identified Use Cases from the requirements.

*Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Plan and Web Page Mock-Ups.

*Documented Risk and Fraud analysis at agent level and User level.

*Implemented FMEA (Failure Mode Effect Analysis) among the team to reduce risks and failures.

*Used Quality Metrics to analyze customer's feedback for the product we have designed for them.

*Created dashboards for the management team every week to review quality ops performance.

*Conducted the requirements and design walkthroughs with designers, developers, and management staff.

*Performed Feasibility, Adaptability and Risk Analysis to identify the business critical and high-risk areas of the application.

*Worked with cross functional teams located in different countries.

*Used the google trax and gCases to maintain and track the stakeholders' requested enhancements and changes

*Conducted JAD Sessions with various development teams of the application so that the application meets the business requirements, discuss open issues, and resolve them and discuss change requests.

Business Analyst

GlobalLogic January 2010 - June 2012

Client: Google, India.

Project: GxBo (Get your business online).

Google Get Your Business Online (GxBO) is a program launched by Google in 2011 to aim at increasing the web presence of small and large businesses by providing free advice on search engine optimization and helping business owners update their information on Google for free in countries where technologies are yet to grow.

Responsibilities:

*Gathered requirements from GxBO customers for customization of their website. Interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes.

*Prepared requirements Documentation so developers can easily understand the customer needs.

*Identified Use Cases from the requirements. Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and.

*Deployment Diagrams, Process Flow Diagrams (PFDs) and Web Page Mock-Ups using google sites and thus defining the Business Process Model.

*Assisted in selecting the website template for the customers based on Cost-Effectiveness and Quality with an eye towards the customers can easily customize in future.

*Played a lead role and trained new team members for their transition to this project.

*Established comprehensive communication process across different teams located in different time zones as the project runs 24*7.

*Prepared Functional and Behavioral document that describe the detail design of the application stakeholders requested enhancements and changes.

EDUCATION

Masters in computer information systems - University of Central Missouri • 3.6

Bachelor of Technology - Jawaharlal Nehru Technological University • 3.4

.

Contact this candidate