Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sri Harsha Ayyadevara

Elkhorn

Summary

  • 9 years of IT experience in US on complete Software Development Life Cycle and Agile Methodologies including
    Requirement Analysis, Design, Development, testing, Implementation.
  • Strong experience in BI tools like SSIS, SSRS, SSAS, Power BI, DAX and Microsoft SQL server along with Alteryx, Snowflake and Tableau reporting.
  • Extensive experience and knowledge in Power BI both in development and administrative roles, also connecting to several data sources like SQL Server, Power BI datasets, Dataflows, Analysis services(SSAS), Excel, CSV, OData feed, JSON, XML, Oracle and Snowflake.
  • Experience in creating measures, calculated columns and performing time series analysis using DAX and Power Query(M Query) in PowerBI.
  • Experience in communicating with stakeholders, Subject Matter Experts (SMEs), and end - users to better understand, analyze, communicate, and validate requirements.
  • Experience in T-SQL (DDL, DML, DB views, Synonyms, Indexes, Temporary column tables, table types, Partitioning), T-SQL scripts (Complex Stored Procedures, DB triggers(DDL,DML,Logon) and User defined functions(Scalar and table valued) and Virtual Data Model (VDM), Core Data Services (CDS), Cursors, CTEs(recursive), Window functions, Error handling, Dynamic SQL and Transactions.
  • Experience in Data Extraction, Transforming and loading ETL by creating packages using various tools such as SQL Server Integration Services SSIS, DTS, Bulk Insert, BCP along with Azure data factory.
  • Experience in developing Custom Reports and different types of Tabular Reports, Parameterized Report, Matrix Reports, Ad hoc reports, and distributed reports in multiple formats using
    SQL Server Reporting Services (SSRS).
  • T-SQL Query optimization, performing tuning of complex stored procedures, SSRS and Power BI reports using several tuning techniques and tools.
  • Experience in working on several Fabric community technologies like Azure Data Factory, Azure Data Lake Analytics, Azure Database, Azure blob storage and Azure Data Warehouse.
  • Expertise in creating Dashboard Reports to support end users using SSAS (Both Tabular & Multi-Dimensional cubes)
  • Experience working on ETL process in Alteryx to extract data from multiple sources(SQL server, XML, Excel, CSV) and schedule workflows.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Sr. PowerBI Developer

InEight Inc.
08.2016 - Current
  • Designed and developed Microsoft Power BI reports and Dashboards (Operational, Strategic & Analytical) including data set ingestion and transformation, Data Modeling, Azure data lake store, Azure Analysis service, Azure DW, Azure data factory, Data Analysis Expressions (DAX) using the appropriate report templates depicting the status of key performance indicators (KPIs) and key risk indicators (KRIs) other important business metrics for an organization to make data-driven decisions.
  • Created Power BI reports and Paginated reports connecting to multiple data sources in SQL, EDW(Both tabular & Multi-dimensional SSAS cubes) and Snowflake.
  • Implemented RLS (Row level security) by creating filters for specific roles in the desktop and assigning these roles to various users and user groups to restrict data access.
  • Extensively used Power Query editor(M Query) and DAX functions like SUM, MIN, AVG, COUNTROWS, DISTINCTCOUNT, IF, OR, SWTICH, ISFILTERED, ISCROSSFILTERED, CALCULATE, CALCULATETABLE, ALL, VALUES, SUMMARIZE, ADDCOLUMNS, ROW in Power BI reports and tabular models.
  • Extensively used custom R-Visuals, Bar & Column charts(Stacked, Clustered), Cards(Single & Multi row), Line, Area, Ribbon, Waterfall, Funnel, Scatter(Bubble, dot plot), Donut & Pie Charts, Map charts(Basic, ArcGIS, Azure, Filled, Tree, Shape, Globe), Slicers, Table & Matrix.
  • Worked on setting up Power BI Environment, Configuring Capacities using Fabric administrator,Power Platform & Premium Capacity Administrator Service accounts, Creating several app workspaces, publishing apps using enterprise level themed reports and dashboards as contents of the app, and setting up Power BI Gateway to connect to On-Prem & Cloud data sources.
  • As a part of Power BI Administration, configured Usage metrics, Users, Audit logs, Tenant settings, Dashboard settings, Power BI Apps settings, Power BI premium and Premium Capacity settings, Enabled/Disabled several Power BI features across organization.
  • Created Power BI datasets which are used for the live connection and DirectQuery data connectivity types for large data sources, also created sharable Dataflows and Datamarts which are used by several insurance and underwriting reports in the company.
  • Deployed and Configured Power BI dataset for Sales and Finance team, implemented incremental refresh on Power BI
    dataset for better performance.
  • Created several types of reports like Recursive Hierarchical reports, Snapshot reports, Linked, parameterized, Drill down and Drill through reports using SSRS for various
    customers.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
  • Created Data Models within Power BI, transformed data with Power Query and Integrated data from various database servers to produce innovative visualization and dashboards. Created Data models in Power BI using design view and MCode.
  • Experience in writing MDX queries for creating calculated measures that fits business logic and while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
  • Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting, and
    scorecard/dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
  • Implemented ETL process in Alteryx to extract data from multiple sources(SQL server, XML, Excel, CSV) and schedule workflows.
  • Optimized stored procedures and SSRS reports to run faster in the application by using query hints and by extensively working on the execution plans using Indexing(clustered, non clustered), scans, seeks and lookups.

BI/SQL Developer

Modern Woodmen Of America
06.2015 - 08.2016
  • Created and maintained new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in SSMS in all environments like development, test, INT and Production environments.
  • Optimized database objects and reports using Execution logs, Execution plans, Query optimizer, SQL Profiler, Parameterized queries using T-SQL in SSMS.
  • Developed various types of reports such a Sub Reports, Charts, Matrix reports, Linked reports, Drill-through and Drill-down reports using SSRS and Report Builder and deployed using Deployment pipelines.
  • Developed various reports including Rebate, Market share, Exclusion, Summary and Details dashboards using
    Tableau Desktop and SSRS report builder.
  • Extensively used various filters while creating Power BI reports in the desktop like Visual, Page, Report and Drill through filters.
  • Created calculated columns, measures, quick measures using DAX and Power query in the Power BI desktop to use for several report visuals.
  • Created Operational, Analytical, Annual, Marketing, KPI and other Ad hoc reports in Power BI desktop, published them on to the Power BI service to respective workspaces, maintained those workspaces by managing permissions to users and user groups both at workspace level and report level by categorizing them into viewers, contributors, members and admins.
  • Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
  • Implemented error & failure handling in SSIS packages using event handlers, Row redirects, check points and used
    logging for monitoring the execution.
  • Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server Analysis Services (SSAS).
  • Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
  • Implemented Alteryx burst reporting to slice and dice the Tableau report filtered by collector and send an email to the collector at a schedule time everyday like a subscription.


BI/SQL Developer Intern

Collaborate Solutions
12.2014 - 06.2015
  • Experience in SQL (DDL, DML, DB views, Synonyms, Indexes, Temporary column tables, table types, Partitioning), SQL scripts (Complex Stored Procedures, DB triggers(DDL,DML,Logon) and User defined functions(Scalar and table valued) and Virtual Data Model (VDM), Core Data Services (CDS), Cursors, CTEs(recursive), Window functions, Error handling, Dynamic SQL and Transactions.
  • Created SSIS packages to Extract-Transform-Load (ETL) from transactional system (OLTP) to analytical system
    (OLAP).
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Optimized performance of Elastic Queries within SQL Code on Microsoft Azure SQL using table hints, query hints and execution plans.
  • Designed, Developed Azure SQL Data warehouse Fact and Dimension tables. Used different distributions (Hash, Replicated and Round-Robin) while creating Fact\Dim.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP and also created data dictionary which are used across the organization for the data mapping.
  • Created and maintained self service schema views in the reporting DBs and imported this data into the Power BI using odata API and APIm calls so that the client can use these application data along with their enterprise data to model & create self service reports and dashboards.
  • Extensively used reporting services (SSRS/Power BI/Paginated reports along with DAX and M Query) to create several Ad hoc reports, deployed them on to the report server and configuring subscriptions and user management.

Education

Master of Science - Computer Science

Northern Illinois University
Dekalb, IL
05.2015

Bachelor of Science - Computer Science

Jawaharlal Nehru Technological University
Hyderabad, India
05.2013

Skills

    ETL,Reporting & BI Tools: PowerBI, SSIS, SSRS, SSAS, BIDS, DTS, Business Objects, Informatica,8x/91, ,DAX, M query(Power Query), Tableau
    Databases: SQL Server 2008R2/2012/2014, MS Access, Oracle
    SQL Server Tools: SSMS, BIDS, Profiler, DTA, Upgrade Advisor, Query Designer
    Languages: SQL, T-SQL, PL/SQL
    Operating System: Windows Server 2003/2008, Windows XP/Vista/7,
    Tools: Alteryx Designer, Tabular Editor, DAX studio, Erwin, Visual Studio 2012/2010/2008 and Report Builder 20/30

Certification


Querying data with Transact-SQL - Valid Certificate ID: bf5e6109f5dd40a4a8bce115e90efcfa


Azure Data Fundamentals (DP 900) - Microsoft Certification number: I102-5231, MCID: 992587018

Timeline

Sr. PowerBI Developer

InEight Inc.
08.2016 - Current

BI/SQL Developer

Modern Woodmen Of America
06.2015 - 08.2016

BI/SQL Developer Intern

Collaborate Solutions
12.2014 - 06.2015

Master of Science - Computer Science

Northern Illinois University

Bachelor of Science - Computer Science

Jawaharlal Nehru Technological University

Similar Profiles

  • Lorraine Zimunya

    Lorraine ZimunyaLorraine Zimunya

    Senior Implementation Consultant at InEight Inc.Senior Implementation Consultant at InEight Inc.

    View Profile
  • NARESH SRIRAMOJ

    NARESH SRIRAMOJNARESH SRIRAMOJ

    Software Engineer 3 at InEight Inc.Software Engineer 3 at InEight Inc.

    View Profile
  • AHMED NABIL HASSAN

    AHMED NABIL HASSANAHMED NABIL HASSAN

    PROJECT DELIVERY CONSULTANT at InEightPROJECT DELIVERY CONSULTANT at InEight

    View Profile
Sri Harsha Ayyadevara