Sai Teja Sri Bathina

SQL & SSIS Developer

Chicago, IL 60060

Phone: +1-630-***-****

LinkedIn: https://www.linkedin.com/in/sai-teja-sri-bathina

Email: ad0tdq@r.postjobfree.com

SYNOPSIS

Having 10 years of IT experience in Database Management, ETL, and Reporting Tools to implement solutions for Business Intelligence. Skilled in design, upgrading, and implementation of SSIS, SQL Server, Tableau, Power BI, SSRS.

Experienced in understanding business rules and data management and sourcing data from multiple source systems.

Experience in extracting file management from sources SAP, SQL Server and different files.

Designed and implemented efficient database structures to enhance data organization and retrieval.

Proficient in SQL with a proven track record of writing complex queries, stored procedures and optimizing database performance.

Proficient in End-to-End design of Business Intelligence solutions to meet global and regional reporting needs.

Developed and implemented indexing strategies to enhance query performance for fast data retrieval.

Collaborated with data suppliers to establish data quality standards and processes, ensuring the accuracy and reliability of incoming data.

Implemented data partitioning strategies to manage large datasets efficiently, improving data access and management.

Interacted with consumers to gather requirements and feedback, customizing data views to meet their specific needs and enhance data utilization.

Created and maintained database schemas to ensure data integrity and compatibility with application requirements.

Preserved robust backup and recovery measures to secure data and ensure business continuity in case of failures.

Involved in UAT testing of report code to ensure fulfilment of requirements and accuracy.

Played a key role in supporting divestitures and acquisitions by facilitating the smooth transfer of data, both outbound and inbound to ensure business continuity and data integrity.

Extensive experience in implementing Complex queries using SQL server and create SSRS reports for data utilization to the business to make data easier to understand.

Ensured strict adherence to audit and compliance requirements, maintaining data security, integrity, and regulatory compliance at all times.

Drove the standardization of data processes and automation of routine tasks, leading to increased efficiency, reduced errors, and enhanced data consistency.

A thorough and proven understanding of Business needs in terms of creating reports using Tableau and Power BI tools.

Experience in Performance tuning scripts in Stored Procedures to extract large datasets.

Participated in on-call support rotation to address and resolve data-related issues outside of regular working hours, ensuring uninterrupted data operations.

SKILLS

Database Tools: MS SQL Server

SQL Server Management Studio

Database: SQL Server 2017, SQL Server 2016, SQL Server 2016, SQL Server 2008R2.

ETL Tools: Data Transformation Services Import& Export

SQL Server Integration Services (SSIS)

Reporting Tools: Tableau

Power BI

SQL Server Reporting Services (SSRS)

EDUCATION

Bachelors in technology from JNTUA, India in 2012.

WORK EXPERIENCE

Client: Kennametal

Industry: Sales and Manufacturing.

Role: Senior Analyst (Data Engineering Team)

Duration: Apr 2021 – Sep 2023

Description: The aim of the project is to migrate the database and reports from SAP HANA systems to Microsoft SQL Server by building a proper Star schema data model for their reporting to analyze the business and to take corrective decisions to improve the business across the globe.

Responsibilities:

Implemented strategies to ensure the stability of daily data processing jobs, reducing downtimes and improving overall system Performance.

Played major role in resolving Production ETL failures.

Execute SQL queries to perform backend database testing and verify user data.

Created T-SQL Procedures using temp tables, cursors, sub queries and functions

Identified and leveraged opportunities for implementing new capabilities and automation within data processing workflows, improving efficiency and reducing manual tasks.

Maintain Effective communication with customers from all departments for system development, Implementation and problem resolution.

Worked on building the Audit Framework process that maintains the logs of all the operations (Inserts, Updates, Deletes) related to the ETL Process and notifying through email in case of any data mismatches between source and target data.

Work Closely with Leadership to understand report needs and collect business requirements to develop data elements.

Mentored and developed junior team members to increase productivity.

Establish subscriptions to reports for the convenience of business users.

Created Different tableau reports using Live and Extract Connection.

Involved in developing weekly, daily, monthly, yearly Tableau reports and sending the reports according to the business requested format.

Specify permissions for Tableau workbooks, this includes setting up who can see or modify data, dashboards, and reports. You can set these permissions at the workbook.

Proficiency in rapidly creating precise ad hoc reports.

Participated in code reviews and version control processes to maintain code quality and foster collaboration among team members.

Client: Kennametal

Industry: Sales and Manufacturing.

Role: Analyst (Data Engineering Team)

Duration: Apr 2019 – Mar 2021

Responsibilities:

Understand and meet business needs and extract the reports from SQL Server management using Custom SQL queries or views and send to the business.

Performed analysis of source data to assess the report quality.

Experienced in SQL server Joins, Views, Indexes, Stored Procedures work within the overall data Engineering program and data related tasks.

Experience in developing drill down, cascading, parameterized, Drill through, sub reports using expressions and functions using SSRS.

Maintained reports and dashboards in tableau and power BI based on business needs.

Responsible to write the critical and very complex SQL Scripts/Stored Procedure to pull the data from OLTP to traditional data warehouse.

Optimized ETL jobs for performance by analyzing query execution plans and making necessary adjustments.

Implemented error handling mechanisms and data validation checks to ensure data accuracy and reliability.

Client: Kennametal

Industry: Sales and Manufacturing.

Role: ETL Developer (Data Engineering Team)

Duration: Apr 2016 – Mar 2019

Responsibilities:

Involved in migrate the database and reports from SAP HANA to SQL server.

Used Control Flow elements like For Each loop and Sequence container, Execute SQL Task, Execute Package Task, Script Task, File System Task and Send Mail Task.

Responsible to monitor jobs and take actions as per severity.

Responsible for develop, deploy and monitoring SSIS packages for ETL Processes and created scheduled jobs through SQL server job agent as per the requirement.

Involved in various internal daily stand-up meetings and updating the daily activities task items to leads.

Experience in SSIS designing packages using Control Flow tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL task, File System Task and Data Flow Task.

Created Stored Procedures as part of ETL pipeline.

Extracted data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations. Created the mappings using Data Flow transformations such as the Derived Column, Conditional Split, Pivot, Lookup and SCD etc.

Client: Automotive Manufacturer Pvt Ltd.

Industry: Sales and Manufacturing.

Role: ETL Developer

Duration: Jul 2013 – Mar 2016

Description: Providing and supporting ETL solutions for sales and manufacturing data.

Responsibilities:

Developed Mappings to extract data from source/stage and transferred aggregated data into summary tables as per specs using Pentaho ETL Tool.

Obtained initial requirements from the users of various departments and corresponded with them throughout the process.

Created DDL scripts to create database schema and database objects like tables, stored procedures, views using T-SQL.

Involved in creating ETL Flows using multiple transformations to load data into the staging & data warehousing layer.

Scheduling email alerts at each stage of ETL process as part of monitoring using Linux shell scripting.

Responsible to monitor jobs and take actions as per severity.

Responsible for develop, deploy and monitoring SSIS packages for ETL Processes and created scheduled jobs through SQL server job agent as per the requirement.

Extensively used Extract Transform Loading (ETL) tool of SQL server to populate data from various data sources.

Experience in loading files to SQL server using transformations in SSIS.

Worked closely with database administrators to optimize query performance, manage database connections, and ensure data integrity.

Contact this candidate