Summary
Overview
Work History
Education
Skills
Timeline
Generic

Tharun Varikoti

Herndon,VA

Summary

9+ years of experience in Database Design, Development, Implementation and Support using Database Technologies (SQL Server-SQL, AZURE) in both OLTP, OLAP and Data warehousing environments. Proficiency in Microsoft Business Intelligence technologies like SSIS and SSRS. Expertise packages to ETL using SSIS, designed packages for tasks and transformations Data Conversion and Pivot tables. I am skilled in performing data transfer between different systems (Excel, Flat Files, XML File, JSON, OLTP DB) and SQL Servers as part of Data migration and Data Maintenance. Various SharePoint administrative activities like, SharePoint security implementation and PowerShell based automation. Experienced in InfoPath, Power App, Nintex form in designing, developing, and denning data structures of electronic form and integrating within the SharePoint platform. Involved in Performance tuning by checking the loads on Index’s by using SQL profiler and Tuning advisor. Used transformations like SCD, CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Worked on star schemas, snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies. Strong development skills with Azure Data Lake, Azure Data factory, SQL Data warehouse and Azure storage explorer. Implemented Copy activity, Custom Azure Data Factory pipeline activities for on-cloud ETL processing. Experience in developing Power BI reports and dashboards from multiple data sources using data blending. Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.) Conversant with all phases of SDLC involving Systems Analysis, Design, Development, and Implementation. Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing. Hands-on experience in designing and developing cloud solutions based on Microsoft Power Platform using Power Apps, Power Automate, Power BI, Power Apps Portal and Common Data Service (CDS). Experienced in Power Automate Working with services, triggers, actions, conditions, parallelism, and loops. Working with services, triggers, actions, conditions, parallelism, and loops - Run a ow on a schedule, calling custom business services - Using approval options, observing owes, Team Flows Extending Power Apps with Flow - Extending Flow with Power Apps. I worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key Foreign Key Relationships, extraordinarily complex joints and SQL Scripts for Views and Materialized Views. Worked in Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spreadsheets, graphs, and dashboard reports.

Overview

11
11
years of professional experience

Work History

SQL BI Developer/Power BI Developer

Department of Buildings
Washington, DC
10.2022 - Current
  • Created/Modified Stored Procedures using T-SQL and SQL
  • Created and modified existing SSIS packages for extract and load the data from MIT files to SQL Server
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
  • Responsible for creating datasets using T-SQL and stored procedures
  • Implemented several DAX functions for various fact calculations for efficient data Visualization in Power BI
  • Designed complex data intensive reports in Power BI
  • Created Power BI reports by using Joins in Multiple tables from Multiple databases using complex SQL queries
  • Converted existing Nintex workflow and form using PowerApps and Microsoft Power automate (Flow) to improve Business process
  • Designed Anaplan models for business forecasting, budgeting, and scenario analysis
  • Implemented PowerApps Role Based Security using SharePoint Group & Flow
  • Automated Contract Expiration Notification System using Microsoft Power Automate
  • Used JSON to run an ow for selected document type in SharePoint list and library
  • Built workflows in Anaplan to automate business planning processes, improving operational efficiency
  • Created several packages in SSIS
  • Scheduled the packages to keep extracting the data from OLTP at specific time intervals
  • Integrated Anaplan with external data sources using Hyper Connect for seamless data synchronization
  • Created a new application to consume JSON objects through Web APIs provided by the Ease Central Web hooks consumed by Web API services to automate the payroll process for employee demographics
  • Implemented Row-Level Security (RLS) to control data access based on user roles and permissions
  • Environment: MS SQL Server 2019, Visual Studio 2022, Azure SQL Server, Azure Data Lake, Power BI Desktop, JSON, Anaplan, RLS

Production Engineering

Goldman Sachs
Salt Lake City, UT
02.2022 - 10.2022
  • Perform risk management of newly added features to the project/application, measure project performance using appropriate systems, tools and techniques, Gap analysis, Efficiency analysis, SLA/Effort revisit, periodic reporting of ready for business, Bill of service and Health, Create and maintain project document
  • Formulate technical action plans for analyzing and resolving recurring problems, provide fault isolation and root cause analysis for highly complex and large Technical issues, review impact analysis done by team, prioritize issues and ensure SLA adherence
  • Work with other groups including vendors to find complete and long-term solutions
  • Provide User Support to the global users of the Application
  • Problem solving, trouble shooting and providing on time resolutions to user Queries
  • Providing support during User Acceptance Testing, Regression Testing and Production Implementation
  • Improving the performance of these applications and bringing down the overall costs
  • Developed and Published reports and dashboards using Power BI and written DAX formulas and expressions
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
  • Responsible for creating datasets using T-SQL and stored procedures
  • Adding value to the incident management process with technical/product/domain knowledge
  • Working on creation of a repository of team’s collective knowledge on technology, domain and process
  • Own escalated cases from the team and ensure that they are resolved as per SLAs and quality expectations
  • Works with application users real time to provide help and resolving application issues in their daily workflow and tasks
  • Co-ordinate with the application team for technical issues, performance improvement, data assurance in application
  • Drive Knowledge Transfer and enablement sessions within the team on both existing applications and new technology
  • Measure project performance using appropriate systems, tools and techniques
  • Perform risk management of newly added features to the project application
  • Create and maintain project documents used across the Team

SQL BI Developer/Power BI Developer

Molina Health Care
Long Beach, CA
01.2021 - 02.2022
  • Company Overview: Molina Healthcare has been a leader in providing quality healthcare to those who depend on government assistance
  • It serves as a health plan providing a wide range of quality health care services to families and individuals who qualify for government-sponsored programs, including Medicaid and the State Children's Health Insurance Program (SCHIP)
  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers
  • Wrote efficient stored procedures for the optimal performance of the system
  • Monitored performance and optimized SQL queries for maximum efficiency
  • Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data
  • Created indexed views and appropriate indexes to reduce the running time for complex queries to keep track of data manipulations using Audit functionalities
  • Developed and exposed internal RESTful APIs to automate data exchanges between internal applications and external systems
  • Generated custom and parameterized reports using SSRS
  • Created reports that call sub reports in SSRS
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
  • Responsible for creating datasets using T-SQL and stored procedures
  • Designed and developed Power BI graphical and Visualizations with business requirement documents and plans for creating interactive dashboards
  • Utilized Power BI Service to publish, share, and collaborate on interactive dashboards across business units
  • MDX programming, DAX expressions, analysis and business forecasts
  • Created several packages in SSIS
  • Scheduled the packages to keep extracting the data from OLTP at specific time intervals
  • Developed and managed ETL pipelines using SSIS to extract, transform, and load data into the data warehouse
  • Optimized Power BI reports for large datasets, using techniques like Direct Query and aggregating data models
  • Used various transformation tasks to create ETL packages for data conversion
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
  • Implemented Angular JS Controllers to maintain each view data
  • Implemented Angular Service calls using Angular Factory
  • Migrating SQL database to Azure Data Lake, Azure SQL Database and Azure SQL Data warehouse and controlling and granting database access and Migrating On premise databases to Azure Data Lake store using Azure Data factory
  • Developed and exposed internal RESTful APIs to automate data exchanges between internal applications and external systems
  • Designed and normalized SQL database schemas for efficient storage and retrieval of large datasets
  • Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment
  • Responsible for rebuilding the indexes and tables as part of performance tuning
  • Used SQL Server Agent for scheduling jobs and alerts
  • Performed Query optimization & Performance Tuning
  • Molina Healthcare has been a leader in providing quality healthcare to those who depend on government assistance
  • It serves as a health plan providing a wide range of quality health care services to families and individuals who qualify for government-sponsored programs, including Medicaid and the State Children's Health Insurance Program (SCHIP)
  • Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, Crystal Reports, Tableau, Visual studio, Business Intelligence Development Studio (BIDS), Cubes, T-SQL, MS Visio, TFS, SharePoint, Power BI MS Excel, Microsoft windows server, Visual Studio IDE

SQL BI Developer

Gap Inc.
San Francisco, CA
09.2019 - 01.2021
  • Company Overview: The Gap, Inc., commonly known as Gap Inc
  • Or Gap, is an American worldwide clothing and accessories retailer
  • Mainly Focused to Work on Gap Inc
  • And Old Navy Migration and Separation
  • Manage new demand for Business Intelligence projects at Gap Inc
  • I am also a senior reporting architect, whose duties include overseeing BI projects, working with the business to find new and better ways to get information to the user community, and working with DBA's, Data Architects, and ETL resources to develop technical solutions
  • Responsible for gathering/refining requirements from the business for developing dashboards
  • Worked on Software life cycle development involving in all stages of development
  • Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other T-SQL code and SQL joins for applications
  • Created Grouping, sorting columns and writing expressions according to the business requirements
  • Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions
  • Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports
  • Created, Implemented, Modified the visualizations in Power BI reports and Dashboards on client requests
  • Created SQL Server Reports and developed a query for generating drill down and drill through reports using SSRS
  • Generated Reports using Global Variables, Expressions and Functions for the reports
  • I identified and worked with Parameters for parameterized reports in SSRS 2012
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS
  • Developed datasets to perform reporting and including interactive drill down reports, report models and ad-hoc reports
  • Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded, and sub-reports using SQL Server Reporting Services SSRS
  • 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
  • Building, publishing customized interactive reports and dashboards, report scheduling using SSRS 2016
  • Responsible for scheduling the subscription reports with the subscription report wizard
  • Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters
  • Performed Unit Testing of the developed component and windows forms and worked closely with manual testers and automation testers, User Acceptance testers for ensuring the desired functionality is achieved
  • The Gap, Inc., commonly known as Gap Inc
  • Or Gap, is an American worldwide clothing and accessories retailer
  • Mainly Focused to Work on Gap Inc
  • And Old Navy Migration and Separation
  • Manage new demand for Business Intelligence projects at Gap Inc
  • I am also a senior reporting architect, whose duties include overseeing BI projects, working with the business to find new and better ways to get information to the user community, and working with DBA's, Data Architects, and ETL resources to develop technical solutions
  • Environment: MS SQL Server 2012, MS SQL Server Reporting Services, SQL Server Analysis Services, Power BI

SQL Developer

AAA
Mount Laurel, NJ
06.2016 - 08.2019
  • Company Overview: The main project is to introduce more features like roadside services, Mobile battery services, online garage, etc
  • Mainly we worked on Insurance Coverage and tools and Financial Services
  • Analyzed data contained in the corporate database and identify data integrity issues with existing and proposed systems
  • Maintain historical data in data warehouse used ETL to implement the slowly changing transformation
  • Interacted with customers to analyze business needs
  • Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond
  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Views, Cursors, CTE's, schemas, used DDL, DML commands
  • Generated multiple Enterprise reports using SSRS from OLTP and OLAP and included various reporting features such as group drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc
  • Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules
  • Effectively used various properties in SSIS package to improve performance
  • Involved in ETL data from Excel, Flat file, to MS-SQL Server by using DTS and SSIS services
  • Worked with SQL views for the data to interact with Crystal reports in the applications
  • Created migration documents and Migrated Crystal Reports to SSRS
  • Used various SSIS tasks such as conditional split, derived columns, which did data scrubbing, including data validation checks during staging before loading data to data warehouse and data marts
  • Created Drill Down, Drill Through, linked, matrix, Charts, lists, Sub reports using SSRS and managed their subscriptions
  • DBA activities like creating users, roles and granting and revoking privileges
  • Deployed and uploaded the SSRS reports to Report Manager and organized them into folders for the end users and involved in enhancements and modifications
  • Generated ad-hoc in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning
  • Used JIRA, TFS for defects, Bug tracking and Project Management
  • The main project is to introduce more features like roadside services, Mobile battery services, online garage, etc
  • Mainly we worked on Insurance Coverage and tools and Financial Services
  • Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, Crystal Reports, Tableau, Visual studio, Business Intelligence Development Studio (BIDS), Cubes, T-SQL, MS Visio, TFS, SharePoint, Power BI MS Excel, Microsoft windows server, Visual Studio IDE

MSBI Developer

RBL Bank
Hyderabad, Telangana
06.2014 - 08.2015
  • Company Overview: This project is based on developing, maintaining, and enhancing back office financial applications originally developed using .NET and SQL Server
  • Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2008 environment
  • Developed, monitored, and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
  • Involved Automation of Back Office project and Migration of SQL
  • Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS
  • Developed application for business to create Internal Rate of Return (IRR) reports for Private Equity using C#.net plugin for Excel, Excel and Access VBA and SQL Server
  • Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails
  • Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
  • Maintained Batch logging, Error logging tables and handling errors using Event handlers
  • Involved in deploying, configuring, and managing reports using Report Manager and Report Builder
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
  • Create Net Asset reports and charts in Excel using VBA
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once
  • Perform reverse engineering in existing legacy financial applications written in Excel and Access VBA to analyze the impact of huge data source migration project coming forth
  • Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler
  • This project is based on developing, maintaining, and enhancing back office financial applications originally developed using .NET and SQL Server
  • Environment: SQL, Tableau, MS Excel, MS Access, SSRS, SSAS, SSMS, BIDS, Windows server, Version Control tool, Erwin, MS Visio, Oracle, C#, Text Pad, Text Editor, T-SQL, Power Designer, DTS, SQL Query Analyzer, Microsoft Outlook, TFS

Education

Masters - Computer Science

San Jose State University
San Jose, CA
12-2016

Bachelor of Science - Computer Science

JNTU H
India
04-2014

Skills

  • SQL Server 2019
  • SQL Server 2016
  • SQL Server 2014
  • SQL Server 2012
  • SQL Server 2008R2
  • SQL Server 2005
  • DB2
  • Teradata
  • SSMS
  • BIDS
  • Visual Studio
  • Configuration Manager
  • Query Analyzer Profiler
  • DTS
  • SSIS
  • SSRS
  • Database Tuning Advisor
  • Shell Scripting
  • Power BI
  • C
  • C#
  • VBNET
  • JavaScript
  • UNIX
  • SQL
  • T-SQL
  • DAX
  • Visual Studio 2003
  • Visual Studio 2005
  • Visual Studio 2008 R2
  • Visual Studio 2012
  • Visual Studio 2019
  • Visual Studio 2022
  • Microsoft NET Framework 46
  • Microsoft NET Framework 45
  • Microsoft NET Framework 3x
  • Windows NT
  • Windows XP
  • Linux
  • Mac
  • Power Designer
  • Visio
  • Visual Source Safe
  • Informatica
  • Tableau
  • MS Office suite
  • ASPNET
  • HTML
  • XML
  • IIS 60
  • Java Script
  • Relational DBMS
  • Client-Server Architecture
  • OLAP
  • OLTP
  • Software Development Life Cycle (SDLC)
  • Agile
  • Waterfall
  • Scrum
  • TFS builds
  • GIT
  • GITHUB Actions

Timeline

SQL BI Developer/Power BI Developer

Department of Buildings
10.2022 - Current

Production Engineering

Goldman Sachs
02.2022 - 10.2022

SQL BI Developer/Power BI Developer

Molina Health Care
01.2021 - 02.2022

SQL BI Developer

Gap Inc.
09.2019 - 01.2021

SQL Developer

AAA
06.2016 - 08.2019

MSBI Developer

RBL Bank
06.2014 - 08.2015

Masters - Computer Science

San Jose State University

Bachelor of Science - Computer Science

JNTU H

Similar Profiles

  • Kanchana Jayasinghe

    Kanchana JayasingheKanchana Jayasinghe

    Technical Officer (Civil) at Department of BuildingsTechnical Officer (Civil) at Department of Buildings

    View Profile
  • Tajmal H. Walker

    Tajmal H. WalkerTajmal H. Walker

    Clerical Associate level III at Department of BuildingsClerical Associate level III at Department of Buildings

    View Profile
  • Tanzy Brown

    Tanzy BrownTanzy Brown

    Program Specialist at Department of BuildingsProgram Specialist at Department of Buildings

    View Profile
Tharun Varikoti