Sri Harsha Ayyadevara
Omaha,Nebraska
Summary
- 9+ years of experience in US on various roles as SQL Developer, Business Intelligence developer, Power BI developer/admin, ETL, Database Analyst, Data warehouse specialist.
- Strong experience in SQL server, T-SQL, Stored Procedures, Triggers, UDF, BCP, DTS, SSIS packages, SSAS (multi-dimensional & tabular), Snowflake. BI tools like SSRS, Power BI, DAX, Alteryx, Tableau.
- Proficient in developing Data Flow diagrams, Process models, ER diagrams, Dimensional data models, Ad-hoc reports using Business Objects, Crystal reports.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Sr. Power BI Developer
Farm Credit Services Of America
04.2023 - Current
- Designed and developed Power BI reports, Paginated reports, Dashboards, Datasets, Data Flows, Apps (Operational, Strategic & Analytical) including data set ingestion and transformation, Data Modeling, Data Analysis Expressions (DAX) , M Query and used several visualizations(Charts, Bars, Cards, key influencers, KPIs, maps, decomposition tree, Power Apps, Q & A, R script Visual) which helped business make data-driven decisions and eliminate years of manual work by automating the processes.
- Implemented & used several tools and concepts in Power BI like Row-Level Security (RLS), Data connectivity, Data Profiling tools, Performance analyzer, DAX studio, Tabular Editor, Performance Optimization, Object Level Security, Incremental Refresh, Deployment Pipeline, Bookmarks, Drill down, Default Parameterization, Alerts, Bins, Lists, Sensitivity Labels, Quick Insights, Endorsement(Promotion & Certification), XMLA end point, Rest APIs, PBI Embedding, Gateway Configuration, Fabric Administration with Tenant Settings & Capacity Settings.
- Worked extensively on Alteryx, Crystal reports and converted them along with other reports that are built using on-prem data sources like SQL Server, SSAS (both multi-dimensional & tabular cubes) to cloud data warehouse powered by Snowflake.
Senior Database Developer/ BI Developer
InEight Inc.
08.2016 - 03.2023
- Generated Complex Stored Procedures, XML Stored Procedures, Triggers, UDFs, Views, Indexes and dynamic SQL for database development.
- Created ETL packages using various transformations from Excel, Flat files, XML to SQL server by using BCP utility and SQL Server Integration Services (SSIS).
- Designed, build dimensions, cubes with star schema using SQL Server Analysis Services (SSAS), calculation using MDX.
- Developed several types of reports using SQL Server Reporting Services (SSRS), Power BI.
- 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.
- Fine tuned complex database objects using performance tuning techniques and tools and increased performance by at least 45%
SQL Developer/ETL Developer
Modern Woodmen Of America
06.2015 - 08.2016
- Experience in creating SSIS packages using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all and with Error Handling.
- Designed dimensional modelling for data warehouse to generate OLAP cubes and identified measures and dimensions.
- Optimized database objects and reports using Execution logs, Execution plans, Query optimizer, SQL Profiler, Parameterized queries using T-SQL in SSMS.
SQL Developer/Database Analyst Intern
Collaborate Solutions
01.2015 - 05.2015
- SQL Server 2008 R2 RDBMS database development including T-SQL programming.
- Built and maintained SQL scripts, Indexes, and complex queries for the data analysis
- Experience in Database Mirroring, Snapshots, Backing and Restoring
- Created view maintenance process to compare and maintain application data in sync with reporting, weekly db backups and schedule jobs using SQL Agent.
- Worked closely on database tuning, performance planning, backup planning and database administration.
Education
Master of Science - Computer Science
Northern Illinois University
Dekalb, IL05.2015
Bachelor of Science - Computer Science
Jawaharlal Nehru Technological University
Hyderabad, India05.2013
Skills
- MS SQL Server
- Power BI
- SSIS
- SSRS
- SSAS
- PL/SQL
- Alteryx
- Snowflake
- DAX
- Tableau
- Azure Data Factory
- Azure Synapse Analytics
- Azure DevOps
Certification
- Querying data with Transact-SQL - Valid Certificate ID: bf5e6109f5dd40a4a8bce115e90efcfa
- Azure Data Fundamentals (DP 900) - MCID: 992587018, Microsoft Certification number: 1777B4-42CB8J, Credential ID: 8308893AAA924222
- Power BI Data Analyst Associate (PL 300) - MCID: 992587018, Microsoft Certification number: 6BC0B5-A6105Y, Credential ID: 16B810F3A06BB111
Timeline
Sr. Power BI Developer
Farm Credit Services Of America
04.2023 - Current
Senior Database Developer/ BI Developer
InEight Inc.
08.2016 - 03.2023
SQL Developer/ETL Developer
Modern Woodmen Of America
06.2015 - 08.2016
SQL Developer/Database Analyst Intern
Collaborate Solutions
01.2015 - 05.2015
Master of Science - Computer Science
Northern Illinois University
Bachelor of Science - Computer Science
Jawaharlal Nehru Technological University
- Querying data with Transact-SQL - Valid Certificate ID: bf5e6109f5dd40a4a8bce115e90efcfa
- Azure Data Fundamentals (DP 900) - MCID: 992587018, Microsoft Certification number: 1777B4-42CB8J, Credential ID: 8308893AAA924222
- Power BI Data Analyst Associate (PL 300) - MCID: 992587018, Microsoft Certification number: 6BC0B5-A6105Y, Credential ID: 16B810F3A06BB111
Similar Profiles
Genea TorresGenea Torres
Document Retention Specialist at Farm Credit Services of AmericaDocument Retention Specialist at Farm Credit Services of America
Brock NelsonBrock Nelson
RELATIONSHIP OFFICER at Farm Credit Services Of AmericaRELATIONSHIP OFFICER at Farm Credit Services Of America
Brad LichtBrad Licht
Product Owner at Farm Credit Services of AmericaProduct Owner at Farm Credit Services of America