Data Manager

SATHWIK REDDY

802-***-****/****************@*****.***

SUMMARY

Experienced Business Intelligence developer with nearly seven (7) years of expertise in areas of analysis, design, development, testing and implementation of SQL Server Databases and Business Intelligence solutions using Microsoft BI suite (SSIS, SSRS, SSAS) tools in Data warehousing applications

Proficient in Data analytics: supported decisions for high-priority, enterprise initiatives involving IT development, customer service improvement, and organizational realignment

Extensive experience with T-SQL, writing stored procedures, triggers, functions, tables, views, indexes and relational database models

Expertise in developing SSIS packages to Extract, Transform and Load (ETL) data into the Data warehouse from heterogeneous databases such as Oracle, PostgreSQL and SQL Server

Expertise in creating and managing event handlers, package configurations, error handling, logging and user-defined variables for SSIS packages

Experienced in managing and automating Control flow, Data flow, events and logging programmatically for SSIS packages

Scheduled jobs for SSIS packages, sending alerts using SQL Send Mail Task

Proficient in error handling using event handlers and providing custom logging for SSIS packages

Developed and deployed complex drill-down reports, parameterized reports, cascaded reports, and dynamic reports using SQL Server Reporting Services (SSRS)

As a member of production support team, provided 24/7 on call support to business users for issues related to source system data issues and data fixes on the data warehouse

Strong knowledge of Data warehousing, OLAP, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables

Worked with various databases like Oracle, MS SQL Server & Amazon Redshift

Created the unit and functional test cases using Python test scripts

Expertise in using TFS, Visual Source Safe (VSS) and Source Tree as a tool for repository of codes and version control, branching and merging into production

SKILLS

Development Technologies

T-SQL (2008-2016), PL/SQL, Power BI, PostgreSQL, Dynamic SQL, C, C++

Databases

MS SQL Server 2016/2012/2008R2/2008, PostgreSQL, Oracle 12c

DWH/BI Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft Visual Studio, Tableau, PowerBI, Pentaho Report Designer (PRD), SQL Server Agent, SQL Server Management Studio

Version Control

Team Foundation Server (TFS), MS Visual Source Safe (VSS), GIT Source Control.

Operating Systems

Windows 8/7/Vista/XP/2003/2000

EDUCATION

Master of Science from Wright State University, Dayton, OH

Bachelor of Science, Jawaharlal Nehru Technological University, Hyderabad, India

EXPERIENCE

May ‘16 – Present MS SQL Server/SSIS/SSRS Developer, Department of Child Services, State of Indiana, Indianapolis, IN

The MaGIK Data Analysis, Research and Reporting team works closely with child welfare program leadership (DCS executive and/or policy staff, and other involved state agencies) to analyze the voluminous data currently being collected and to identify the process that can be displayed in regular management reports so that staff at all levels of the organization can regularly assess their performance and use data to develop and test questions about practices that improve safety and permanency outcomes for children and families. The data from these projects are usually prepared for release to an external source, such as federal agencies, local governmental agencies, social service organizations, legislative service agencies, other state agencies, state contractors, the Governor's Office, advocacy groups, etc.

Analyzed business requirements and developed process to ensure all components of the application are integrated correctly by working with Product Owners and Business Analysts

Developed various T-SQL Tables, Store Procedures, Triggers, Functions, Views, indexes etc. for reporting databases

Optimized the performance of queries with modifications in SQL queries, removing unnecessary columns, eliminating redundant/inconsistent data and creating indexes where ever necessary

Performed key role in understanding the business requirements and designing and loading the data into data warehouse (ETL)

Designed SQL SSIS Packages to perform Extract, Transfer and Loading of the data from various sources like PostgreSQL database, Excel spreadsheet, and flat files into SQL Server for further data analysis and reporting

Created configuration files in SSIS packages and performed incremental data load packages in SSIS

Automated the SSIS jobs thru SQL Server Agent for daily, weekly and monthly loads

Performance tuned the Stored Procedures used in SSIS Packages and SSRS Reports

Developed reports using SQL Server Reporting Services (SSRS) based on the business logic by implementing efficient stored procedures

Creating Drill-down, Drill-through, ad-hoc and sub-reports, navigation reports (Hyperlink) using SSRS and created POC’s for visualizations in Power BI

Generated database monitoring and data validation reports with SQL Server Reporting Service (SSRS) in report writing according to business requirements

Deployed SSRS reports to 2012/2016 Report Manager and exported them to desired formats including Excel and PDF for end user access

Worked with DBA team to migrate from SQL Server 2012 to 2016

Supported application development team with any database issues, updates or new releases and deadlock issues, best practices in structuring T- SQL Queries, and debugging

Managed source code, keeping track of project deliverability such as defects, requirements, tasks and versioning control using TFS (Team Foundation Server)

Participated in reviews of issues related to SSRS reports and troubleshot those issues, fixing, testing and deploying them

Created dashboard reports using SSRS by accessing cube (SSAS) environment

Member of production support team which provided 24*7 on call support for any production incidents

Environment: MS SQL Server 2012/2016, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T- SQL, PostgreSQL, MS Excel, MS Word, Visual Studio 2012/2016

Oct ’15 – Apr ’16 SQL Developer, IvyTech Community College, State of Indiana, Indianapolis, IN

Ivy Tech Community College of Indiana is the state's largest public postsecondary institution and the nation's largest singly accredited statewide community college system. It is accredited by the Higher Learning Commission and a member of the North Central Association.

Developed complex SQL queries involving multiple tables for implementing the business rules and transformations

Facilitated query optimization and performance tuning of databases

Developed and implemented the application code in Oracle PL/SQL and Postgres SQL

Created temporary tables to speed up queries and assist in debugging the complex queries

Designed and maintained a wide variety of reports including finance, financial aid, human resources, advancement, accounts receivable reports used by different departments within the college using Pentaho Report Designer

Imported data into the database using Pentaho Data Integration

Installed and used Python to validate the data set by verifying that the expected record granularity is achieved and used other validation methods to verify that expected results are accurate

Worked with various delivery mechanisms of reports including Email /PDF/Excel/HTML/CSV

Uploaded reports to the Report Manager and published reports to a Pentaho BI-Server for end user access

Monitored and supported the existing reporting environment

Prepared unit test cases, design documents and migrated code to higher environments using version control GIT Hub

Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements

Documented all work so that the end user can easily understand the flow of the processes

Environment: Pentaho Reporting Designer 5.4, Pentaho Data Integration, PL/SQL, PostgreSQL, Amazon Redshift, Oracle 12c, Navicat, Sourcetree, GitLab, MS Excel, HTML, CSV, PDF, Python 3.4, Sublime Text, Windows Server 2007

Jan ’15 – Sep ’15 MS SQL Server/SSIS/SSRS Developer, Accordant Health Services, CVS Caremark Company, Greensboro, NC

Accordant Health Services, a CVS Caremark Company is a recognized leader in delivering disease management and case management services for people with rare chronic conditions. This was a specialized program to help them manage their rare chronic illness. All Clinical Programs are developed under Accordant Care management System, and assessment workflows are designed for clinical assessments. The project focus was developing a complete information and decision support system for patient care management.

Used Joins, sub-queries, stored procedures and indexes for complex queries involving multiple tables from different databases

Designed SSIS package to load data from different sources (SQL Server, Flat Files, Excel source files, XML files etc.,) to SQL Server database using SQL Server Integration services (SSIS)

Developed ETL packages to initially load data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into archive tables

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary

Created SQL Agent Jobs to schedule jobs for extracting data from different source systems using SSIS packages. Stored Procedures were used within these packages to aggregate the data

Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format

Ensured all code and versions were properly maintained in VSS while migration was in progress

Generated various Drill-through reports, parameterized reports, sub-reports, and linked reports using SSRS

Used TFS (Team Foundation Server) to maintain secure code, SSIS packages and SSRS reports created in a multi-team environment

Environment: MS SQL Server 2008R2/2008, T-SQL, MS Excel, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio, Visual Source Safe (VSS), SQL Server Analysis Services (SSAS), Windows Server 2007

June ’11 – Aug ’13 SQL Server Developer, State Bank Shares Corp, Mumbai, India

State Bank shares Corp. is the holding company for State Bank of India, the second largest banking institution in India. My responsibilities were to develop, implement and maintain all databases including stored procedures, triggers and complex queries, which included the administration of various bank databases in both development and production environments.

Environment: MS SQL Server 2008R2/2008, T-SQL, SSIS, SSRS, SQL Profiler, Query Analyzer

Contact this candidate