Business Intelligence Sql Server

SUBASH YELETI

• United States • +1-214-***-**** • **************@*****.***

www.linkedin.com/in/subash-yeleti

Professional Summary

Over 8+ years of IT Experience as Senior SQL Server Developer, Business Intelligence Developer and in ERP systems.

8+ years of experience in Designing and Development of Business Intelligence applications with Power BI, Report Builder, SSIS, and SSRS Advance analytical tools.

7+ years of experience in enterprise data management areas like data governance, data quality, and metadata management.

4+ years of experience in leading the team towards the implementation and successful delivery of complex data engineering, Business intelligence, and ERP implementation projects.

Proficient in implementing ERP functionalities, including Dynamics 365, and migrating legacy systems to cloud-based architectures. Extensive experience in Waterfall, Agile, and SCRUM Methodology.

Skilled in Azure Data Factory, Azure Data Bricks, and CosmosDB for building data pipelines and managing large datasets.

Eexpertise in administering SQL Server (2022, 2019, 2017) with a focus on backup/recovery strategies, security configurations, disaster recovery planning, query optimization performance tuning, index optimization, and normalization.

Expertise in creating interactive dashboards and reports using Power BI and Power Apps training for self-service analytics.

Extensive experience in Agile and SCRUM methodologies for delivering data projects aligned with business objectives.

Proven ability to deliver actionable insights through predictive analytics, data visualization, and advanced reporting tools.

Successful track record of leading teams in BI and ERP implementation projects with effective stakeholder collaboration.

Hands-on experience in the healthcare domain, integrating electronic health records (EHR) and ensuring compliance with industry regulations. Integrated databases like MSSQL, SYBASE, AZURE SQL and developed ETL solutions using SSIS.

Skilled in migrating and managing SAP datasets, enabling seamless integration with modern ERP solutions for enhanced performance. Expertise in implementing and Ramco ERP, including finance, procurement, and operational modules.

Delivered banking analytics solutions, processing large-scale credit card and loan data for risk assessment and fraud detection. Skilled in data warehousing tools, data mapping, unit testing, migration, conversions, and process documentation.

Proficient in creating customized dashboards, Drill-down, Drill-through, Sub-Report, Linked Report, and Parameterized reports using Power BI for healthcare and banking sectors, providing real-time insights to improve decision-making

Proficient in developing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Ad-hoc reports using Business Objects and SAS programming.

Expertise concepts like Date Time transformations, Transparent Data Encryption, Grouping sets, MERGE operator, Filtered Indexes, Data Profiling, SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS) and SSAS.

Experienced with SQL Server 2019 and below, focusing on SQL Queries, Stored Procedures, Triggers, SSIS, PLSQL Packages, Data cleaning, indexing, Data Definition Language (DDL), Data Manipulation Language (DML).

Highly proficient in the use of T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, TSQL joins and query writing.

Experienced with creating reports by connecting data from different sources to Power Bi, DAX functions, M Language and using geographical visualizations as per the customer and project requirements.

Good understanding of business requirements, Data warehouse schema (Star Schema, Snow Flake Schema) and mapping rules for the implementation of simple to complex ETL designs.

Expertise in all phases of the Software Development Life Cycle (SDLC) including analysis, Physical and Logical design, code development, testing, implementation, and maintenance of Business applications with Dimensional Data Warehouse.

Migrated legacy systems to a cloud-based architecture using Azure Data bricks for enhanced data processing and Py Spark for distributed data transformations. Trained users on Power Apps, non-technical staff to build apps independently.

Applied Data Analytics in Azure platforms such as Azure SQL Data warehouse, Azure Data Factory (ADF), Azure Storage account etc. for source stream extraction, cleaning, consumption, and publishing across multiple user bases

Developed automated workflows for routine database maintenance tasks, including monitoring, backup scheduling, and data integrity checks, reducing downtime and operational overhead.

Proficient in project management, stakeholder engagement, and delivering actionable insights to drive business growth and efficiency. Additionally, possess a strong track record of successful project implementation and delivery.

Experience in Data Modeling, Entity relationship diagram, development/normalization, physical database schema design, Data Base Back up, Data Base administration, and Monitoring the Data Bases.

Excellent skills in Log Shipping, Transnational, Snapshot Replication, Database Backup, Linked Servers, DTS.

Technical Skills

Business Intelligence

T- SQL

Data Analysis

MongoDB

Data Warehousing

SSIS

Data Cleaning

Azure SQL

Power Bi

SSRS

Data Visualization

Agile Methodology

DAX

MIS Reports

Data Processing

SLA

SDLC (Software development life cycle)

Database Management

Enterprise Resource Planning (ERP)

Stakeholder Management

Employment History

GI Group August 2023 – Present

Client : Royal Mail

Role : Sr SQL & Business Intelligence Developer Data Base Administrator

Responsibilities:

Collaborated with the non technical stake holders and gathered and analyzed the Business Requirements, understanding business requirements and finalizing technical & business specifications.

Collected transnational data related to the parcel delivery from different sources such as Azure SQL, MONGO DB and MS SQL(T-SQL) integrated using the SSIS packages.

Designed the Enterprise Data Warehouse (EDW) for the Royal Mail Logistics using the Snow Flake and Star Sachems. Automated the work flow by integrating data from Microsoft Dynamics 365 with the Power Apps.

SQL Server 2019 OLAP database development including KPIs, Data mining, working with slow changing dimensions.

Experienced in C# and JavaScript development for enhancing database-related functionalities.

Developed the Star Schema for OLAP (Online Analytical Processing) operations, and OLTP making it ideal for reporting and data analysis, Data Base Design, DB2, Data Base Administration (DBA).

Migrated parametric Reports, Cross-Tabbed and Sub-Reports from SSRS to Power BI. Optimized Power BI Reports, reducing load times and ensuring faster data refreshes for large datasets.

Developed Custom Dashboards and Reports in Dynamics 365, providing actionable insights into sales, procurement, and customer data.

Collaborated with Stakeholders to implement Dynamics 365 modules for finance, sales, and customer service, ensuring smooth deployment and user adoption.

Developed and implemented a data access layer using Entity Framework Core, ensuring seamless integration between the application and the database.

Involved in Data Cleaning and Data Prepossessing techniques along with the Data Engineers, Data Analyst. Extracted and Transformed Data from Dynamics 365, SQL databases, and Azure Data Factory into Power BI for visualization.

Leveraged CosmosDB as the data store for managing unstructured data from parcel tracking systems, providing faster read access for operational dashboards.

Experienced in Database Tuning, Data base Administration (DBA), DB2, migrate mainframe data to newer relational databases, and applied performance tuning to the T-SQL Stored Procedures.

Gathered and Analyzed Requirements for CRM solutions, aligning business needs with D365 CRM capabilities.Configured and Customized Dynamics 365 CRM to streamline business processes, enhancing operational efficiency.

Gathered the insights that helps in developing, processing the data from the Business users and the Business Analysts (BA).

Proficient in leveraging the Output Delivery System (ODS) to create complex reports, manage output, and produce high-quality PDF/HTML reports in the SAS.

Implemented a parcel tracking dashboard in the Power Bi which helps to increase in the operational efficiency by 20%.

Developed the MIS Reports (Management Information System) by integrating data from different sources using SSIS (SQL Server Integration services) packages and SSRS (SQL Services Reporting Services) and Informatica Tool.

Shared the finding from the Dash Boards with Non technical stake holders and gathered the inputs for designing the reports.

Enhanced decision-making processes at Royal Mail's ATHERSTONE parcel hub, leading to an 8% improvement in operational revenue after implementing temporary employee tracking and monitoring.

Integrated Power Apps with Dynamics 365, SharePoint, and Microsoft Teams to enhance data accessibility and collaboration. Automated Approval Workflows using Power Automate and Power Apps, reducing processing times by 30%.

Optimized HCM application database performance by fine-tuning Transact SQL queries (TSQL), resulting reduction in query response time and improved data retrieval efficiency.

Developed Dash Board for the temporary Employee details and their performance on day to day bases. Which helps the organization to increase the efficiency in work by employees by monitoring on daily bases.

Developed Reports and Dash Board for the Financial transactions made on daily bases using the Power BI tool.

Conducted data analysis and provided insights to stakeholders for decision- making purposes. Demonstrated strategic thinking and proactive problem- solving skills.

Developed the Parcel tracking Dashboard using the Power Bi and SSIS which results in decrease in the operational cost and increase in the efficiency

Environment: Power Bi Desktop, Report Builder, Power Bi Server, Power Pivot, Power Apps, Power Automate, ADF, Power View, Power Map, DAX, SAS,ETL, SSIS, SSRS,Oracle SQL, Power Query, Python, CosmosDB, SQL Server 2022, 2019, 2017, Azure Data-bricks,SQL, TSQL, Oracle, MS Excel, Windows 11.

Virtual Tech Services, (India) January 2020 – August 2023

Client : Capital One

Role : Data Engineer

Responsibilities:

Developed and optimized ETL processes to extract data from multiple sources, including relational databases like TSQL Server, Azure SQL, and No SQL databases such as MongoDB, integrating them into centralized data warehouses.

Gathered data from the API using the python and stored in the MongoDB for the Data Cleaning process.

Applied Data Cleaning or Data Prepossessing using the Python libraries such as Numpy, Pandas etc,…

Applied Exploratory data analysis and implemented different types of regressions algorithms on the data.

Designed and deployed real-time streaming data pipelines using Apache Kafka for ingesting high-velocity transitional data from credit card applications.

Transformed raw credit card application data into structured formats, facilitating advanced Analytics and reporting for credit risk assessment, customer segmentation, and fraud detection.

Integrated different databases through SSIS packages, applied data cleaning techniques, Data Base Back up, Data Base administration (DBA), conducted data profiling and mapping to uphold high data quality standards.

Formulated data models employing a star schema for optimal performance, and developed Power BI dashboards based on client specifications, facilitating agile methodology data-driven decision-making processes.

Designed and implemented robust data pipelines using SSIS to process and transform large volumes of credit card transaction data, ensuring high data quality and integrity.

Implemented Py Spark pipelines on Azure Data-bricks to process large datasets efficiently, ensuring timely data ingestion and processing for credit risk assessment.

Migrated parametric Reports, Cross-Tabbed and Sub-Reports from SSRS to Power BI.

Designed and optimized data models and schema for data warehouses, ensuring efficient query performance, scalability, and alignment with business objectives.

Implemented scalable data processing solutions on cloud platforms like Azure, Database like Azure SQL and Data Factory to support both real-time Analytics and batch processing.

Experience in designing, implementing, and executing test cases. Assist business users with using published reports, dashboard and performing ad hock data analysis.

Experience automating repetitive tasks and reports using SAS batch scripts and job scheduling tools.

Integrated Different databases using ETL Tools like SSIS and Informatica for the Enterprise Data Warehousing.

Consolidate data from multiple sources and build finance data market for generating financial dashboards and reports.

Worked closely with cross-functional teams including data scientists, software engineers, and business analysts to deliver data solutions that support credit card application processing and strategic decision-making.

Optimized data processing workflows and queries to reduce latency, improve performance, and ensure the data platform could scale to meet increasing demands.

Developed TSQL Stored Procedures, Functions, Triggers, for the retrieval of the Data from the Oracle SQL Data base and the reports development.

Migrated legacy data access code to Entity Framework Core, improving maintainability and scalability.

Collaborated with cross-functional teams to design and implement scalable database access using Entity Framework Core.

Used Different types TSQL Joins like inner, left, right, cross join for joining different types of tables and the data retrivals.

Experienced using version control tools such as Git with SAS for managing code changes and collaborating with teams.

Engaged with stakeholders to gather requirements, provide updates, and ensure alignment of data engineering efforts with business goals, contributing to successful project delivery and implementation.

Consolidate data from multiple sources and build finance data market for generating financial dashboards and reports.

Applied Data Cleaning and Data Modeling for Developing the Credit Analysis Dash Board using the Python Dash Library.

Environment: Python, Python Libraries,Py Spark,Oracle SQL,Power BI, Power BI Desktop, Power BI Service, DAX,SharePoint, Microsoft Office, SAS, Azure SQL, Azure Data Factory (ADF),MongoDB, SQL Server 2019, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),SQL Server Analysis Services (SSAS 2019), T SQL, SQL Pro-filer, MS Excel, Excess, Windows 10 Professional.

TVS SUDARAM Brake Linings LTD, (India) July 2019 – January 2020

Designation: SQL & BI Developer Data Base Administrator

Responsibilities:

Coordinated with the business users and gathered the functional requirement from the stake holders and company users for developing the Customized ERP.

Reported the Business requirements and planned the implementation of customized ERP.

Collaborated with cross-functional teams to develop business logic for ERP modules using C#.

Enhanced an existing application by refactoring legacy C# code, reducing technical debt and improving maintainability

Led the team of 6 people in the implementation of Finance and Sales Modules for the customized ERP.

Created Database and Database Objects like Tables, TSQL Stored Procedures, TSQL Views, Triggers, Rules, Defaults, user defined data types and functions for the ERP.

Created interactive dashboards and data visualizations using JavaScript for real-time reporting.

Demonstrated expertise in writing complex TSQL queries, stored procedures, and functions tailored for customized ERP systems, ensuring efficient data processing and supporting informed decision-making through data analysis.

Monitored and optimized the performance of data pipelines and database administration (DBA) to ensure efficient data processing and retrieval.

Migrated Meta Data from Tally ERP to the AZURE SQL Cloud for developing the Customized ERP.

Migrated parametric Reports, Cross-Tabbed and Sub-Reports from SSRS to Power BI.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Implemented ETL processes with SSIS to merge data from different sources and migrated data to the cloud server.

Worked on Power BI reports, dashboards and DAX functions to maintain as-is functionality of the reports.

Re-plat forming existing SSRS reports in Power BI and maintaining data warehouse in Azure based data services.

Developed the Power BI Dash Boards using the data from different sources used in the day to day use for the process.

Coordinated with cross functional teams and Consolidate data from multiple sources and build Sales dashboards and reports.

Developed reports using legacy tools like Crystal reports for certain custom reports with specific format requirements.

Trained the Non Technical Stake Holders on the Customized ERP and implemented Customized ERP (Finance and Sales) Domains for the 4 manufacturing units in the TVS Group and trained the end users.

Environment: Tally ERP, Customized ERP, Power BI, Power BI Desktop, Power BI Service, DAX, SharePoint, Microsoft Office, Azure SQL, Azure Data Factory (ADF), Azure Cloud, SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS 2017), Informatica, T SQL, SQL Pro-filer, MS Excel, Excess, Windows 10.

RITSL (RAMCO Group), (India) June 2018 – July 2019

Role : Sr SQL / BI Developer Data Base Administrator

Client : Omega Health Care

Responsibilities:

Managed the integration of Omega Health Care’s data and processes into Ramco ERP, optimizing workflows across finance, procurement, HR, and patient management.

Integrated Power BI with Dynamics 365 and Ramco ERP for seamless reporting and cross-platform analytics.

Performed data profiling on healthcare data, including electronic health records (EHR), to validate the accuracy and reliability of data used for patient care and compliance reporting.

Integrated healthcare data using ETL processes and applied data profiling to ensure consistent, clean data before analysis.

Worked closely with technical teams to identify gaps in data workflows and optimize the ERP system based on business user feedback.

Developed dashboards and reports in Power BI and SSRS to ensure compliance with healthcare regulations (e.g., HIPAA) and standards, providing real-time insights into operational performance and patient care metrics.

Designed detailed dashboards to monitor key healthcare metrics such as readmission rates, average length of stay, and patient satisfaction, helping stakeholders improve care quality and operational efficiency.

Collaborated with healthcare Business Analysts and administrative staff, to gather requirements and deliver data-driven insights that enhanced decision-making and improved patient outcomes.

Migrated legacy systems to cloud solutions, including CosmosDB and Azure Data Bricks, efficiently handling large-scale datasets and supporting real-time analytically.

Integrated data from electronic health records (EHR), insurance claims, and other healthcare systems into centralized databases using ETL processes, automating reporting workflows for accurate, timely insights.

Developed Stored Procedures, Functions, TSQL Queries, Indexes for the RAMCO ERP reporting tools and the reports.

Supported in the implementation of RAMCO ERP Finance Domain technically and functionally.

Environment: RAMCO ERP, MS Excel, SQL Server 2017, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS 2017),SQL Server Reporting Services (SSRS), T SQL, SQL Pro-filer, Power BI Desktop, Power BI Service, Windows 10.

Client : JAMNA Auto Project

Responsibilities:

Successfully led the team to implement RAMCO ERP across 10 manufacturing units for the JAI Group.

Coordinated with the Business Users gathered the business requirements and documented for implementation of RAMCO ERP Finance Module.

Developed the Enterprise Data Warehousing for the RAMCO ERP, MSSQL Data Base For this Project.

Developed Reports like Trail Balance, Balance Sheet, Sale Register etc… using the SQL and RAMCO MIS tools.

Migrated data from the SAP to the RAMCO ERP. Which helps in maintaining the company data in the single area.

Developed MS SQL Queries, Stored Procedures and functions for the MIS Reports.

Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Migrated parametric Reports, Cross-Tabbed and Sub-Reports from SSRS to Power BI.

Integrated Data from various databases like, Excel, SAP and MSSQL using SSIS packages to develop reports.

Developed T- SQL stored procedures and Power BI dashboards for RAMCO ERP implementation finance domain (FICO).

Coordinated with ERP end users to gather business requirements, and applied data cleaning, analysis techniques, and performance tuning for MIS report development.

Conducted unit testing on the T - SQL code, ensuring optimal functionality, performance, and reliability of database.

Applied Data cleaning and Data Analysis Techniques and performance tuning in developing the MIS reports.

Used mashup (M) language designed to create queries that mix together data for the Power BI Dash Boards Creations.

Successfully implemented RAMCO ERP and Trained the end Users and Stake Holders on the RAMCO ERP Finance Domain.

Environment: RAMCO ERP, MS Excel, SQL Server 2017, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS 2017),SQL Server Reporting Services (SSRS), T SQL, SQL Pro-filer, Power BI Desktop, Power BI Service, Windows 10.

RAMCO Cements Project: January 2018 - June2028

Supported in upgradation of RAMCO ERP from version 2 to version 4.

Coordination with the business users and gathered the requirements for the implementation of RAMCO ERP version 4.

Migrated the stored procedures and functions from MSSQL 2012 to MS SQL2017.

Conducted SQL query unit testing for functionality validation and delivering training to end users and stakeholders.

Integrated data from various databases using SSIS packages to facilitate report development.

Developed SQL Stored Procedures and Functions for the RAMCO ERP for the migrated version4.

Changed and Deployed the reports in the Production server according to the RAMCO ERP version 4.

successfully coordinated with team members to upgrade RAMCO ERP for RAMCO Cements.

Migrated the MIS Reports from Version 2 to Version 4 in the RAMCO MIS tool.

Successfully trained the end users and the stake holders on the RAMCO ERP latest Version.

Environment: RAMCO ERP, MS Excel, SQL Server 2017,SQL Server Analysis Services (SSAS 2017), T SQL, SQL Pro-filer.

ASICO Cement Kuwait Project: June 2017 – January 2018

Role : Engineer - IT projects SQL / BI Developer

Provided offshore team support for RAMCO ERP implementation, resulting in reduction in project implementation time and cost savings.

Developed Stored Procedures and Reports for the RAMCO ERP based on the client requirements.

Understand the functionality of finance domain and developed the MIS reports according the user requirements.

Understand the Business Requirement Document and RAMCO ERP Functionality for the implementation process.

Supported the Onsite Team in implementation of RAMCO ERP Finance Domain and budget management Planning.

Integrated data from multiple databases using SSIS packages, developed stored procedures, and conducted unit testing on SQL code to ensure optimal functionality, performance, and database reliability.

Environment: RAMCO ERP, MS Excel, SQL Server 2017, SQL Server Analysis Services(SSAS 2017), T SQL, SQL Pro-filer.

Cognizance Solutions (Internship) June 2016 – May 2017

Developed Complex SQL Queries, Functions.

Assisted in managing and manipulating databases using SQL, creating queries, updating databases, and ensuring data integrity.

Developed Stored Procedures and User defined Functions.

Coordinated with Senior employees and learned the Data Cleaning and Data Base Backup tasks.

Updated KPI daily and gathered information about the usage of in-house systems.

Environment: MS Excel, SQL Server 2012, SQL Server Analysis Services (SSAS 2012), T SQL, SQL Pro-filer

Certifications

Data Visualization With Power BI Data Visualization With Power BI -- Great Learning -- May 2024.

Azure Fundamentals course -- Great Learning -- September 2024.

Achievements

Managed a team of 8 employees in ERP implementation for the JAMNA Auto Project.

Educational Qualifications

Bachelors in Electronics and Communication Engineering – SRM University

Contact this candidate