RUPA KOMIRELLI

Data Engineer, 727-***-**** ad2mz5@r.postjobfree.com www.linkedin.com/in/rupa-komirelli CAREER OBJECTIVE

Hard-working professional with 5 years of experience and a proven knowledge of database development, programming, and database design. Aiming to leverage my problem solving and critical thinking skills to successfully support your company in a SQL Developer/Analyst role.

EXPERIENCE

Mileway April 2021 - Present

Sr Data Engineer Clearwater, FL

Collaborated with application developers to build an in-house application and wrote T-SQL code to transform data according to Yardi spec lowering load on Mileway data team.

setup ADF pipelines leveraging linked services, integration runtimes, data flows etc to Automate daily data load processes.

Provisioned and populated Azure SQL databases and on-prem SQL Server across multiple environments.

Provisioned and used azure storage accounts as part of ADF data loads.

Maintained source code as database projects utilizing Visual Studio, GitHub and git.

Developed Logic Apps to Automate notifications of process completions in Teams and email.

Collaborated with Business analysts suggesting improvements to business requirements.

Developed reports on Yardi using Yardi SQL on Yardi Portal according to client requirements. JP Morgan & Chase December 2011 - January 2013

SQL DEVELOPER/ANALYST Tampa, Florida

Developed original code and throw away code such as unit test stubs leveraging various SQL implementations such as stored-procedures, functions, pivots, joins, and other aggregation functions.

Collaborated with project team suggesting and improving business requirements and communicated same to offshore team.

Oversaw daily maintenance tasks such as daily/Monthly processes and also maintained code integrity by performing performance tuning using indexes, constraints, etc.

Handled code promotions from development environments to production environments leveraging visual studio.

Handled administration tasks such as managing users, roles and permissions and also built SQL jobs to maintain data quality.

Built load processes to move data from various new data sources into central data warehouse.

Developed complex SSIS packages using proper control and data flow elements, transformations such as derived columns, sort, merge, foreach containers while pulling data from SQL Server 2008 to SQL Server 2012 per business requirement.

Designed parameterized and cascading parameterized reports, charts, graphs and drill down and drill through reports leveraging SSRS and high performance queries.

Caraaka Public Web Services Pvt. Ltd March 2008 - November 2010 Jr SQL DATA ANALYST Hyderabad, Telangana

Built new tables, wrote stored-procedures and some user defined functions to address seamless integration of application code based on C# and asp.net.

Defined Check constraints, Business Rules, Indexes, and Views to reduce data integrity issues and increase query performance by 80%.

Managed users, roles and groups and handled database security.

Managed subscriptions including data driven subscriptions for SSRS reports.

Developed Sub Reports, Matrix Reports, tabular and parameterized Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).

ADDITIONAL SKILLS

Azure SQL, SQL Server 2008/2012/2016

ADF,SSRS, SSIS, SQL Agent

Windows XP/7/10/11, Windows Server 2003/2008/2012

Business Intelligence Studio 2008, Visual Studio 2010/2012/2019/2022 Github, Github Desktop

TSQL, MYSQL

EDUCATION

December 2012

Master of Science in Software Engineering

August 2007

Bachelor of Technology in Information Technology

Contact this candidate