Ramakrishna Bathini Contact no: 9044347258

SQL/SSIS Developer Email: ramkidec11@[Link]

SUMMARY
Having 12+ Years of strong experience in T-SQL Programing, Data Integration, Data Analysis, ETL workflows,
integration services (SSIS -ETL), pipelines using ADF and Azure Databricks with reporting services (SSRS)
PowerBI.
 Performed data migration from legacy systems to on-prem SQL Server environments using SSIS and
T-SQL.
 Created SQL Server objects like tables, stored procedures, views, joins, set joins, indexes, and functions
using T-SQL Programming.
 Have extensive experience in creating pipeline jobs, scheduling triggers, mapping dataflows using
Azure Data Factory and using key vaults to store credentials
 Created pipelines in ADF using linked Services/Datasets/Pipeline to extract, transform and load from
different sources like Azure SQL, Blob storage, Azure SQL Data warehouse.
 Used Spark and PySpark SQL to process data through ADLS and DBFS in Azure Databricks.
 Having good knowledge of performance tuning, and query optimization by creating useful indexes and
avoiding the expensive logical and physical operators.
 Designed indexes to tune the ETL process performance.
 Proficient in writing Spark SQL using complex syntax and logic like analytic functions etc.
 Used Python/Pyspark scripts in Azure DataLoads into DBFS.
 Used tools such as displaying estimated execution plan, Set Statistics Time On, and other tools to
analyze the execution plan and delayed queries.
 Extensive Experience in writing new complex Stored Procedures, Functions, Types, Triggers & Views
 Having good knowledge of analyzing the business logic of existing SPs, UDFs, TRG, and Views were
updated with the new implementation of business logic.
 Experience in data modeling by using normalization techniques and building referential integrity.
constraints in OLTP database servers.
 Temporal tables and CDC tables configuration on different versions of SQL server for change data
capture.
 Extensive knowledge of dimensional data model, star schema and Snow Flake schema and Kimball
Methodologies.
 In depth knowledge of Dimensions, Facts, Slowly Changing Dimensions, Conformed Dimensions,
Metadata
 Created clustered indexes and non-clustered indexes on the columns.
 Created SSIS packages for data extraction ETL from diff. sources to diff. destinations like SQL servers,
Db2, Teradata, Oracle, Excel, XML CSV, and text files.
 Good experience in using SSIS transformations like data conversion, derived column, lookup, merge
join, merge, union all conditional split, OLEDB Command, aggregate, sort, multicast, row count, row
sample, SCD, etc. in SSIS packages.
 Developed SSIS packages with various tasks like – FTP, File System, E-mail, For-each-loop, Execute
Package, Data Flow task, Execute SQL task, Custom Script Task, Analysis Services Task, Data Mining
Task.
 Experience in building snowpipe.
 Indepth knowledge of snowflake Database, Schema and Table structures Used to log all the events of
executables using SSIS logging feature in SQL server table and log the package details also in the SQL
table which is useful for error handling and auditing.
 Extensively used reporting services to develop the tabular, matrix, gauge, dashboards, sub-reports,
parameterized reports, drill down & drill through SSRS reports as per the business requirements.
 Strong skills in PowerBI visualizations using formulas, charts, DAX commands.
  Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images,
Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary
report and dashboards using KPI’s.
 Experience in GIT and TFS as source control tools

TECHNICAL SKILLS
 SQL SERVER INTEGRATION SERVICES, AZURE DATA FACTORY,
MICROSOFT FABRIC
Expertise
 SQL SERVER, DATA AUTOMATION
 XML, JSON, POWER BI, TABLEAU, SSRS, SSAS, REPORT BUILDER, ACCESS
 TSQL, PYSPARK, PYTHON, DAX
 JIRA, GIT, TFS

EDUCATION

UNIVERSITY OF NORTH FLORIDA (JAN 2010 – DEC 2011) MS

CMR INSTITUTE OF MANAGEMENT, HYDERABAD (MAY 2005 – JUN 2009) B. Tech

PROFESSIONAL EXPERIENCE
ELEVANCE HEALTH, REMOTE (Jul 2023 – Present)
Sr. SQL/SSIS Developer
 FLEX-CARE
Flexcare is a application which manages the different providers and their respective sites. I was part
of the team where we wrote SQL scripts to update the rates of the sites according to the BRD’s. The
sites were grouped into grouper and grouper detail tables where we maintain the referential
integrity.
There would be constant requests to term the records and insert the new rates.
Responsibilities:
 Designed, developed, and maintained robust SSIS packages for ETL processes in an on-
premises SQL Server environment.
 Extensively used joins and sub queries to simplify complex queries involving multiple tables.
 Developed scripts for maintaining administration tasks.
 Used SQL Profiler to monitor the server performance, debug T-SQL and slow running
queries.
 Thorough analysis and testing of database objects & T-SQL scripts before deployment to the
production server.

 Built ETL pipelines using Azure Data Factory and integrated with Azure Synapse for analytical
workloads
 Developed Data modeling for Power BI reporting
 Analyzed SQL scripts and designed solutions using PySpark

 Implemented database access control policies, role-based security, and automated backup
solutions
 Created Database objects – Tables, Indexes, Views, Stored Procedures, and user-defined
functions according to the requirements of the projects.
 Participated in the development, maintenance, enhancement, and support of application.
 Responsible for developing, monitoring and deploying SSIS packages for claims data
 Environment: SQL server 2016, SSIS 2017, GIT

VIDENCE, REMOTE (Jan 2020 – June

2023)
Sr. SQL - BI Developer
 SCIMON Process
Was involved in a project to load data from flat files to MS Server. Created the table structures,
Cleansed the data, checked for referential integrity, and loaded it into Datawarehouse.
Developed various stored procedures, ETLs, and Validation routines as part of this process.
 DQS and MDS
Used MS features - Data Quality Services (DQS) and Master Data Services (MDS) in SSIS workflow.
 Data Marts
Was part of the team that developed DataMart’s (Scimon Dashboard DM and OMOP) as per end
client requirements.
 Azure Data Loads
Researched and implemented various components like pipeline, activity, mapping data flows, data
sets, linked services, triggers, and control flow. Developed and maintained end-to-end operations of
ETL data pipelines and worked with large data sets in Azure Data Factory.

Responsibilities:

 Created complex ETL packages using SSIS to extract data from staging tables to EDW tables
with incremental load.
 Worked with Clinical Analysts on DQS to create the Knowledgebases.
 Performed extensive debugging, data validation, error handling mechanism, transformation
types, and data clean-up analysis within large datasets.
 Integrated DQS with SSIS to create projects and worked on uploading that information to the
KBs.
 Developed SSIS packages with various tasks like – FTP, File System, E-mail, For-each-loop,
Execute Package, Data Flow task, Execute SQL task.
 Created pipelines with GUI in Azure Data Factory V2
 Worked on Databricks workspace user interface, Managing Databricks notebooks, Delta Lake
with Python, Delta Lake with Spark SQL
 Scheduled jobs in Flows and ADF pipelines
 Thorough analysis and testing of database objects & T-SQL statements before deployment to
the production server.
Environment: SQL server 2016, SSIS 2017, ADF, PowerBI, Pyspark, GIT

EXL SERVICE, TAMPA FL (Dec 2017 – Dec 2019)

Sr. ETL Developer
 CR Egress
Developed ETLs to load data from the Oracle server to the MS server. There were about 100 ETLs in
this project to Extract data from individual tables on a nightly basis which would support the billing
queries and data analytics in the MS environment.
 Legacy Data Extracts
Was Involved in a project to extract data from legacy sources. Developed ETLs to extract data for
MCCM-related tables.
 Power BI Reports
Worked on the development of multiple reports for different healthcare programs like MCCM and
DM.
Responsibilities:
  Worked on PySpark and Spark SQL transformations in Azure Databricks to perform complex data
transformations for business rule implementation.
 Developed Oracle and SQL server stored procedures, data mappings for data importing,
exporting, and parsing, etc.
 Participated in data warehouse builds using on-prem SQL Server, developing SSIS packages for
staging, fact, and dimension loading.
 Developed data quality scripts to validate, monitor and alert on invalid, bad, or no data.
 Maintained and enhanced data mappings.
 Reverse-engineered database linkage to provide database version compatibility.
 Developed reports according to the BRDs.
 Designed and developed stage data model and dimensional data model for the data warehouse.
 Mapped disparate data sources – relational DBs and text files onto target schema
Environment: Azure, SQL server 2016, SSIS 2015,2012, C#, Power BI, GIT

HEALTH INTEGRATED INC, TAMPA FL (Feb 2014 – Dec 2017)

Sr. SQL Developer
 EDI File Validations
Before the files are processed through the BizTalk automation. We created a validation layer to
check for business logic and kick back the invalid files. The validation layers check for duplicate files,
invalid LOBs, and File format erroneous files, and then the data quality check.
 Billing To SQL
For this project, we developed a process to pull billing-related data from the Hadoop database and
load them into the SQL database every month. This data is used to drive the tableau report.
 HRA Data Loads
Worked on importing data from files into tables for Response and Disposition feeds for multiple
clients.
 SharePoint Data Loads
ETLs were developed to extract data from SharePoint and load them into SQL. that provides a view
of key performance indicators and tracking areas required for informed proactive business users.
Responsibilities:
 Developed T-SQL scripts, Views, Functions
 Developed complex stored procedures.
 Involved in daily team meetings.
 Worked on ad-hoc requests regularly.
 Developed ETLs to extract data from SharePoint.
 Developed SSIS packages using C# script tasks.
Environment: SQL Server 2016, 2012, T-SQL, SSIS 2015,12, C#, Jira

OLD CASTLE, ATLANTA, GA (Oct 2013 – Jan 2014)

SQL Developer
 Ariba
Ariba is a completely automated process to get data from the DB2 database into the SQL database
and export them into respective Excel files. Files are transmitted through SFTP. The process involves
numerous stored Procedures using the OPENQUERY command to connect to DB2 and import data
into the SQL database. Then an SSIS process is built on top of it to call those Stored Procedures
sequentially. Once the export is done, a sequence container contains all the dataflow items to
sequentially export those data into respective Excel files. A confirmation email will be sent to the
concerned team about the files being placed on the SFTP for pickup.
 Proof of concept for Tableau
Earlier the data to Tableau was fed from DB2 Database which is loaded heavily. We created the
database and the table structure from scratch and moved the data into the SQL database to support
 the application. The new additional features, user security, and user hierarchy are also implemented
into this model.
Responsibilities:
 Wrote T-SQL SSIS code Uploaded the files onto the Secured FTP
 Developed the cmd line scripts used by Win-SCP to Automate the upload process with SSIS.
 Developed ad-hoc reports based on SQL Server database.
 Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
 Developed and maintained complex triggers and views to support business rules.
 Responsible to support the issues with reports on the enterprise environments (Development,
UAT, Test, and Production
 Developed complex stored procedures.
Environment: SQL Server 2008R2, 2012, T-SQL, SSIS 2008R2, SSRS 2008 R2, SFTP, MS Access, MS
Excel, VBA, C#, PGP4Win, WinSCP, SecureFX

WALT DISNEY WORLD, ORLANDO, FL (Feb 2013 – Sep 2013)

Role: - ETL Developer
 Dodger
This is a SQL Server database application. With this application, the contact information is sent to
Good Neighbor Hotels on a selective option basis. The contract is sent every year with the previous
year’s data. After each hotel finished inputting the Room descriptions info it is collected back in the
PDF forms that are incorporated with the mail merge option. This is converted into the .csv Excel
files and fed back to the Dodger database. Which in turn does the transformation and is exported to
Oliver Database in the form of several Excel sheets. The Oliver Database supports the Disney Hotel
Booking system. The complexity in the Dodger database comes in because it uses complex VB scripts
in the transformation process and while exporting the files into Different excel sheets according to
the area it falls under.
 BUDCO
Budco is a completely automated process to get data from VISION-TI, which is a Dynamics CRM
Application into the SQL Server Database. The process required to generate Exception files based on
Disney business rules and attach those files as an email if they are generated on that day. The
Agency and Earmarked files are then generated, free from these exceptions if any. Then these files
must be PGP Encrypted using software that can be integrated with SSIS. The Encrypted files are then
placed on the Secured FTP using SSL connections. Then a confirmation email will be sent to the
concerned team about the files being placed on the SFTP for pickup.
 VISION-TI Reports
Developed 9 finance reports that must be integrated with Microsoft Dynamics CRM. The reports are
based on Disney travel agency and Disney cruise line finance data. Developed various operational
drill-down and drill-through reports using SSRS and report builder. Scheduled reports for daily,
weekly, and monthly reports for executives, Business analysts, and customer representatives for
various categories and regions based on business needs.
Responsibilities:

 Analyzed Dodger application which had some complex requirements.

 Developed T-SQL, Stored Procedures, Functions, and Triggers.
 Travelled to Disney Booking System regularly to analyze the transformation data required.
 Developed SSIS packages to import data from Dynamics CRM.
 Encrypted the text files using PGP4win software and integrated the same with SSIS.
 Wrote T-SQL SSIS code Uploaded the files onto the Secured FTP
 Developed the cmd line scripts used by Win-SCP to Automate the upload process with SSIS.
 Developed ad-hoc reports based on SQL Server database.
 Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
 Responsible to support the issues with reports on the enterprise environments (Development,
UAT, Test, and Production
  Developed complex stored procedures.
Environment: SQL Server 2008R2, 2012, T-SQL, SSIS 2008R2, SSRS 2008 R2, SFTP, MS Access, MS
Excel, VBA, C#, PGP4Win, WinSCP, SecureFX

HEALOGICS, JACKSONVILLE, FL (Feb 2012 – Jan 2013)

Role: - BI Developer
 Center Data Reconciliation
This is a custom Web Application developed within SharePoint using C#. This application is in the
enhancement of the SSIS / Excel-based data integration process. Users enter data in this web form
from 550 locations around the United States. This data is then integrated with the Corporate
Financial database using SSAS, SSIS. Developed reports on finance data.
 Data Processing and ETL Automation
Automated the process of reading DB Backup files from a secure FTP site and restoring the database.
Also the automated process of reading CSV files from a secure FTP site, SharePoint lists from the
SharePoint 2010 portal, text files from a network drive, and performing the ETL to populate
dimensional data warehouse using SSIS 2008R2.
 ETL Auditing
Added logging and auditing to ETL process using SSIS package.
Responsibilities:

 Designed data extraction, transformation, and load processes.

 Developed T-SQL Stored Procedures and packages to perform ETL.
 Extracted. AK, CSV, and TXT files from a secure FTP site
 Developed SharePoint application using C#.
 Developed SSIS packages using C# script tasks.
 Developed SSRS reports based on SQL Server as well as OLAP cubes.
 Automated Database Restore processes and data warehouse processes to processes complete
data warehouse.
 Developed complex and multistage ETL packages using For-each-loop, Execute Package, Data
Flow task, Execute SQL task, Custom Script Task, Analysis Services Task, and Data Mining Task.
 Developed Transformations using Data Conversion, Audit, Derived Columns, Lookups, Merge,
Merge Joins, Slowly Changing Dimension transformation.
Environment: SSIS 2008R2, SSRS 2008 R2, SSAS 2008 R2, Red Gate, Secure FTP, C#, XML, JSON,
SharePoint 2010, Oracle 10G