Sudheer Reddy Kaila
Champaign,Illinois
Summary
Data and analytics professional with 9+ years’ experience in Data Science, Business Intelligence, Software Development, managing research analysts, leading cross-functional teams, data automation & design initiatives in CRM system, building performance metrics and directing prospect identification, constituent profiling & segmentation strategies. I help organizations unveil the power of data by analyzing and providing key insights. Organized and exceptional relationship management and communication/collaboration professional with skills to interact with Business Intelligence, Information Services/Support, IT Enterprise Applications/Architecture, and IT Governance leaders to improve business processes/team workflows and enhance Blackbaud CRM system functionality tools. Proficient in assessing and reporting data to ensure critical decision-making in UI Advancement. Winner of UIF Extraordinary Impact Award (Fall 2020).
Overview
14
14
years of professional experience
Work History
Sr. Business Intelligence Developer
University of Illinois Foundation
09.2016 - Current
- Support three Universities in UI System as a Senior Business Intelligence Developer of Advancement Intelligence team, managing a team of research analysts who have a hybrid role as a researcher, data analyst and liaison to fundraising and functional area teams. Partner extensively with our Enterprise Applications and Information Management teams regarding system functionality needs and our Business Intelligence team regarding reporting and analysis solutions. Invited to weekly Business Intelligence meeting at OVCIA to discuss requests and projects.
- Selected Accomplishments:
- Developed SQL Scripts and stored procedures to create custom lists and reports and ensured that the unit data requests are created and implemented in alignment of Campus needs for data analytics, business intelligence unit needs and goals.
- Worked on multiple Ad-Hoc requests based on requirements submitted by the users by using SQL for the data pull, Power BI and Tableau for visualization requests and SSRS for reporting needs.
- Developed and implemented web based interactive reporting applications and new giving technologies for UOFI System through Apple pay, Venmo, PayPal and social media etc. during COVID by increasing the campaign progress by $11M.
- As a ‘go-to’ Power BI person, I have developed multiple Power BI Dashboards during COVID to track the campaign progress & pipeline gifts and identified more than $6M potential gifts.
- Created data models, tables within Power BI to support efficient, optimized data warehousing and reporting workflows, provided training and support to the end users on understanding the data, using the detail reports in Power BI & TED reports. Helped colleagues troubleshoot with any BI stack & Power BI issues.
- Utilized Power BI to build interactive and visually appealing dashboards and reports and developed visual reports key performance indicators (KPI) scorecards and dashboards using Power BI desktop.
- Work closely with the BI Lead Analyst and “UIF” IT Department to deploy and maintain BI software and metadata repositories together with other BI team members, advice the Associate Vice President regarding the development and the use of new BI products and services.
- High-skilled in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2022/2019.
- Generated Sub-Reports, drill down reports, Drill through reports and Parameterized reports using SSRS.
- Created complex SSIS packages using proper control and data flow elements with error handling. Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
- Loading data from various sources like flat files to SQL Server database Using SSIS Package.
- Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing, and Scheduling the SSIS packages and Jobs using TIDAL.
- Using Tableau server as a front-end BI tool and Microsoft SQL Server as a back-end database designed and developed workbooks, dashboards, global filter page and complex parameters-based calculations.
Programmer Analyst
Siritek Inc.
05.2016 - 09.2016
- As an employee of Siritek Inc., providing services as a Programmer Analyst. Working for TEK Systems as a consultant. Being part of database conversion project, as a BI Developer writing SQL scripts for reports, and responsible for creating reports and analytics using Microsoft reporting services, Blackbaud SDK, and Blackbaud Data Warehouse that are delivered to end-users.
- Selected Accomplishments:
- Created SSIS packages to extract and Scheduled Jobs to call the packages and Stored Procedures.
- Design and tested packages to extract, transform and load data using Server Integration Services (SSIS).
- Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.
- Developed SSIS 2012 Packages that pull data from Oracle, Access, flat files and Excel into SQL server 2014 for further Data Analysis and Reporting by using multiple transformations.
- Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
- Created various database objects tables, indexes, views, stored procedures and triggers, Co-related sub queries, Dynamic SQL queries and implemented referential integrity constraints for enforcing data integrity and business rules.
- Developed various operational Drill-through and Drill-down, sub-Reports, Charts, Matrix reports, Linked reports using SQL Server reporting services.
- Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
- Developed Tasks specs and Report specs using SDK tool.
Programmer Analyst
Global Info Tech Inc.
07.2014 - 05.2016
- As an employee of Global Info Tech Inc., providing services as a Programmer Analyst. Worked for various clients, being part of migration project from MS Access to SSRS reports gathered requirements from Business analysts and Developing SSRS Reports and developing the SSIS Packages to load data from different sources to data warehouse.
- Selected Accomplishments:
- Implemented multiple markets in Molina SC, NJ, TX and DC following the implantation guide and mapping document to enable 837, 835, 999 and 277CA transactions and file formats.
- Well knowledge in understanding an EDI transaction like 834, 837, 835, 999, 277CA and Proprietary file formats.
- Good knowledge in understanding Member, provider, Claims -2300, 2400 and CAS balancing on the files.
- Used AXWAY (B2BI) to conduct HIPAA compliance before submitting files to the state.
- Very good understanding and development knowledge with Facets, MDE application and QNXT Application
- Creating Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers, Parameterized Stored Procedures, Constraints and Roles.
- Involved in Migration project. Migrating of Data and Objects from Oracle to SQL Server. Involved in Database Administration activities like Back Up, Recovery and Security etc. Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS. Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
- Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
- Knowledge and understanding of OLAP and related technologies.
- Created SSIS Packages (ETL) using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
- Used various SSIS tasks such as Conditional Split, Derived Column, which used for data validation checks during staging, before loading the data into the Data warehouse.
SQL BI Developer
Sanguine Software Solutions Inc.
08.2012 - 06.2014
- As an employee of Sanguine Software Solutions Inc, as a SQL BI developer. Being part of development team for CCSC and NSS Dashboard projects. Worked on SQL Server 2008R2 OLAP database development including KPIs, or Metrics working with changing dimensions and worked on ETL design and development for KPIs. Implemented, maintained and enhanced ETL applications to populate data warehouse from different sources.
- Selected Accomplishments:
- Participated in Daily Scrums and weekly meetings with the project sponsors to meet exceptions and deadlines.
- Co-ordinating JAD sessions with client to gather requirements.
- Designed and developed flexible, user interactive and user-friendly UI with rich front-end pages, reusable classes, functions using C#.net, HTML, ASP.net, MVC, CSS, JavaScript.
- Developed dynamic ASPX web pages using ASP.NET, C#, HTML5 and JavaScript. Developed various UI screens and Client-side validations using JavaScript, AJAX and jQuery Consumed WCF Services for exchange of data between systems and implement business logic in C#.net.
- Responsible for designing database tables, Complex T-SQL Stored Procedures, Functions and Triggers in SQL Server
- Used different T-SQL code for creating cursor and handling the data validations.
- Created different types of User-defined functions.
- Applied conditional formatting in SSRS to highlight key areas in the report data.
- Used Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and created various dynamic reports using SSRS and reports.
- Loading data from various sources like excel files, flat files, .csv files to data warehouse Using SSIS Packages.
- Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing, and Scheduling the SSIS packages and Jobs.
- Created SSIS Packages to migrate slowly changing dimensions.
- Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
- Created and Managed OLAP Cubes using SSAS.
Education
Bachelor of Technology - Computer Science
Jawaharlal Nehru Technological University (JNTU)
Hyderabad, INDIA01-2010
Skills
- Business Intelligence Data Management, Data Automation & Global Changes Reporting & Analysis CRM/Relational Database SQL/CRM Query Recruitment, Training, Onboarding & Coaching Cross-functional Collaboration Project/Product Management Manage request queue Data vendor relations Business Process Reengineering
- MS Office Suite Blackbaud CRM 40 Relational Databases CRM-based query nodes Power BI Tableau SQL Server SSRS SSIS ETL Bit Bucket JIRA Confluence GitHub TFS Vault TIDAL Agile MS SQL Server Management Studio MS Visual Basic for Applications, XML Zoom, MS Teams, Skype Business Box, Dropbox, MS SharePoint, Trello
Timeline
Sr. Business Intelligence Developer
University of Illinois Foundation
09.2016 - Current
Programmer Analyst
Siritek Inc.
05.2016 - 09.2016
Programmer Analyst
Global Info Tech Inc.
07.2014 - 05.2016
SQL BI Developer
Sanguine Software Solutions Inc.
08.2012 - 06.2014
Bachelor of Technology - Computer Science
Jawaharlal Nehru Technological University (JNTU)
PROFESSIONAL TRAINING and ACADEMIC ACHIEVEMENT
Trained for Microsoft SQL Server and BI Data Tools SSIS, SSRS and SSAS. Trained for online Blackbaud CRM and SDK. Business Intelligence reporting tool Tableau & Power BI