Summary
Overview
Work History
Education
Skills
Timeline
Generic

AAKASH MUDHELLI

Burnaby,BC

Summary

  • Business Analyst with 4+ years of experience in developing and implementing the web applications and data warehouse & BI solutions.
  • Extensive experience in writing complex T-SQL statements, Database development, Engineering ETL pipelines, Power BI, Tableau and developing interactive reports.
  • Specialized in ETL design and Data Warehouse development & maintenance. Experienced with all stages of the Data life cycle, worked on projects supporting critical applications on-premises and Azure cloud environments.
  • Experience working with Data modelling, ETL workflow, infrastructure automation and enabling continuous integration and continuous delivery of Business Intelligence solutions. Facilitate the UAT with business stake holders.
  • Experience working on Azure and using tools like Azure Data Factory, Integration Runtime, Azure SQL, Azure Web Jobs, Azure Active Directory Integration and Azure Storage.
  • Experience in making Power BI reports using Slicers, DAX formulas, Measures, Page level and Report level Filters.
  • Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
  • Participate in the creation and implementation of data solutions in the cloud by using platforms like Microsoft Azure, Amazon Web Services (AWS), and Google Cloud Platform (GCP).
  • Experience in constructing Stored Procedures, Replication, Index, Functions, Triggers, Cursors, Tables, Views, Relational database Models, and Data integrity.
  • Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like Constraints (Primary key, Foreign Key, Unique, Default).
  • Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools such as SSIS. Experienced using SAML for exchanging authorization.
  • Expertise in Microsoft Business Intelligence Tools including Integration Services (SSIS) and Reporting Services (SSRS).
  • Experience in developing the end-to-end solutions in Agile and V models. Experience with building CI/CD workflow for SSIS deployments using Jenkins and PowerShell.
  • Experience with project management tools such as Jira and Confluence.
  • A highly organized and collaborative professional with project management skills, strong analytical skills, capable of creating and maintaining effective systems to streamline processes and drive productivity.
  • Skilled in analyzing complex concepts and translating them into actionable insights for cross-functional teams.
  • A bilingual communicator with excellent presentation skills, adept at delivering compelling data reports and effectively engaging stakeholders.
  • Demonstrates a curious and innovative mindset, consistently researching and implementing new approaches to enhance business acumen and drive creative problem-solving.
  • An adaptable team player with strong critical thinking abilities, excelling in cross-functional environments.
  • Possesses a keen attention to detail and the ability to analyze information from diverse sources, resulting in effective communication and informed decision-making.
  • Skilled in collaborating with cross-functional teams to drive successful project outcomes and facilitate effective communication.
  • Proficient in project planning, risk management, and resource allocation, resulting in streamlined processes and timely deliverables.

Overview

6
6
years of professional experience

Work History

Business Systems Analyst

TD Bank
10.2022 - Current
  • Responsible for drafting business requirements, creating functional and technical specifications documents
  • Co-ordinate with business stakeholders, conduct review meetings and plan the resources required for the project for the deliverables expected
  • Validate the solution functionally and technically, review the test cases, test validation and Bug reviews
  • Co-ordinate the meetings, provide and clarify the technical specifications
  • Create the UML diagrams required for the case flow
  • Create the data validation, test data for testing
  • Review the data flows, Extract, Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics
  • Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks
  • Analyze, design, and build Modern data solutions using Azure PaaS service to support visualization of data
  • Understand current Production state of application and determine the impact of new implementation on existing business processes
  • Designed an end-to-end analytical landscape involving Power BI dashboards connected to backend SQL Server 2016
  • Create and manage Reports subscriptions and schedules SSRS reports
  • 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
  • Troubleshooting reports issues, ETL job failures, optimizing query performances
  • Expertise in standard workflow rules, page layouts, Record Types, Approval Processes, Assignment rules, Validation rules, bulk Triggers, etc
  • Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012/2014/2016
  • Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
  • Created, Maintained & scheduled various reports in Power BI like Tabular Reports
  • Developed comprehensive documentation including functional process guides, business cases, and test scripts to ensure seamless implementation of enterprise systems and support efficient operational processes
  • Leveraged strong business analysis and project management skills to drive business efficiency and successfully manage competing priorities in complex, cross-functional environments
  • Built and maintained strong customer relationships by providing exceptional support, creating user-friendly guides and training materials, resulting in improved user adoption and satisfaction
  • Environment: cloud (AZURE), ETL, Windows Server 2016, 2012 R2, 2012, 2008 R2, 2008 and 2003, SQL Server 2017/2016/2014/2012/2008 R2/2008/2005, SQL Query Analyzer, BI Data Tools (SSRS, SSIS, SSAS), SCOM.

Business/Data Analyst

AU Small Finance Bank
01.2018 - 08.2021
  • Worked with various business stake holders to draft the business requirements, work, and co-ordinate with business analysts for creating test data on database
  • Co-ordinate with the business and stake holders for review meetings, provide the status and plan the deliverables in scrum meetings
  • Responsible for drafting the business requirements (BRD’s) and System Specification documents
  • Create data mapping, Data Schema validation
  • Design the physical and logical design of database and Data warehouse
  • Brainstorm the ideas of ETL strategy and co-ordinate for the design of dimensions and Facts
  • Clarify the logic required for measures and explain the logic to developer to implement the measures as part of ETL
  • Review the performance and data quality for SSIS packages
  • Review the security to SSIS packages using different protection level options
  • Generated dynamic reports for flexibility and ease using cascading parameters and filters
  • Deployed the SSIS packages to SQL server and different file system locations, using save the copy of package option, deployment utility option and package installation wizard
  • Generated Power Bi reports using Slicers, DAX formulas, Measures, Page level and Report level Filters
  • Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database using SSIS 2008 for Data transformation
  • Responsible for providing the data extracts as required by the teams and business analysts for marketing Initiatives
  • Responsible for executing scripts for database deployments in PROD/QA
  • Granting access to the database objects as required
  • Responsible for maintaining the data warehouse jobs, troubleshooting the failures, reports connectivity issues
  • Created Dashboards, KPI’s and reports using SSRS and Power BI
  • Developed and implemented data-driven solutions using data structure and statistical analysis techniques
  • Maintained high levels of confidentiality and ensured data privacy in accordance with established protocols.

Education

Bachelor of Business Administration -

Osmania University

Master’s - business administration (Business Analytics

University of Canada West

Database SQL Server 2008 R2, 2012, 2016, Azure SQL Reporting tools Power BI Desktop, Power BI Report Builder, SSRS,PowerPivot for Excel - undefined

Skills

Database

SQL Server 2008 R2, 2012, 2016, Azure SQL

Reporting tools

Power BI Desktop, Power BI Report Builder, SSRS,PowerPivot for Excel

Analysis tools

SQL Server Analysis Services (SSAS)

Cloud technologies

Azure Data Factory, Azure BLOB Storage, Azure datalake analytics, Azure databricks, Azure SQL, Azure DW

Languages

SQL, T-SQL, Python

IT process

Software Development Life Cycle (SDLC), Agile

Timeline

Business Systems Analyst

TD Bank
10.2022 - Current

Business/Data Analyst

AU Small Finance Bank
01.2018 - 08.2021

Bachelor of Business Administration -

Osmania University

Master’s - business administration (Business Analytics

University of Canada West

Database SQL Server 2008 R2, 2012, 2016, Azure SQL Reporting tools Power BI Desktop, Power BI Report Builder, SSRS,PowerPivot for Excel - undefined

AAKASH MUDHELLI