GURUNATH REDDY CHINTHAKINDI

acyfu8@r.postjobfree.com

361-***-****

PROFESSIONAL SUMMARY

Over 9 years of experience working with Microsoft BI Technologies in T-SQL, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS) and Master Data Management. Have strong business knowledge in Healthcare and Financial domain.

Designing the architecture of the data warehouse after understanding and analyzing the legacy databases using Visio.

Experienced in Agile Methodology, SCRUM framework and System Development Life Cycle (SDLC). Experience in SDLC includes Requirement gathering, Analysis, Design, Development, Testing and Implementation of various medium and large-scale client/server applications in a structured development environment.

Experience in designing ETL Packages in SSIS (2005/2008/2012) using various transformations to load Data-Warehouse which involved loading the Data from XML Files, Excel, CSV file, DB2 to MS SQL Server by using MS SQL Server SSIS (2005/2008/2012).

Experience creating Variables and Expressions in SSIS in order to deploy packages from staging to the production environment.

Experience in Performance Tuning, Query Optimization, Indexing, and Normalization.

Extensive experience in building SSIS packages with error handling and package configurations for ETL to load data into staging tables, perform conversion and transformation tasks and generate emails using customized script tasks. Well-versed in usage of SSIS Control Flow items and SSIS Data Flow items.

Experience in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.

Excellent knowledge in SQL queries defining objects like Tables, Stored Procedures, Views, Indexes, Triggers, and user-defined data types and functions using T-SQL.

Experienced in using SSRS to build Sub-Reports, Drilldown reports, Drill Through reports, Parameterized reports and Map reports based on relational or dimensional sources with data visualizations like KPI, gauges, charts and matrixes, with toggle feature; all of which can be delivered on-demand or configured to be deployed according to schedule.

Well-organized and highly-motivated professional with excellent analytical and troubleshooting skills. Ability to work on multiple tasks in a fast-paced environment independently or as part of a team to accomplish critical business objectives.

Well versed in Power shell coding.

Strong communication, analytical and problem-solving skills exhibited by working closely with key players to identify business problems and system solutions.

Technical Skills:

Databases: SQL Server 2012/2008/2005, Oracle.

SQL Server Tools: Enterprise Manager, Query Analyzer, Export & Import (DTS), Business

Intelligence Development Studio, SSMS, ETL Tools, SQL Profiler, SQL Server Agent, DTS Exchange, SSIS, SSRS, SSAS, Master Data Management, Tableau.

Languages: T-SQL, PL/SQL, C#, VB.Net, VB6, VBA and Power Shell

Other Tools: TFS, Performance point, Microsoft Office, Microsoft Visio, Dollar Universe.

PROFESSIONAL EXPERIENCE:

Charles Schwab, Denver CO April 2016 – Till Date

SQL BI Developer

Responsibilities:

Working with project managers and business users to understand the requirements.

Designed the ETL workflow, SSRS reports and Tableau.

Create SSIS packages both design and code to process data to target databases.

Identify and resolve problems encountered during both development and release of the SSIS and SSRS code.

Debugging and troubleshooting the technical issues while implementing the applications.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with the incremental load.

Created packages in SSIS with error handling and worked with different methods of logging in SSIS.

Designed and developed SSIS packages to extract data from different source files – Excel file, Flat file, Access file, CSV file, etc. into SQL Server 2012/2008R2 for further data analysis and reporting.

Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe.

Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

Responsible for data analysis, loading data from Data feed to Data Warehouse tables.

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.

Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.

Prepared ETL Log Reports and ETL Audit Reports in SQL Server Reporting Services (SSRS) for a project manager to check the run status of ETL packages such as ETL name, data flow type, start time, finish time, status, and error message.

Humana Inc., Louisville KY May 2015 – March 2016

SQL BI Developer

CDM and Cgx Project

TCS provides development, enhancement and maintenance support services to Utilization management (UM), Case/Disease management (CM/DM). Currently, a third-party vendor product CCA is being used to manage the UM, CM and DM functions. Since there are over 100 documented gaps and the product roadmap is not addressing the gaps in a reasonable time frame, Humana has decided to encapsulate the CCA functionality in-house.

This Initiative involves, Development of an application to handle the end to end processes of utilization management to address the following business functions.

•.Authorization and Referrals

•.Routing and Referrals

•.Campaign management

•.Member Interventions

•.Clinical profile data management

•.Member View

•.Self-assessments

•.Member Wellness programs

•.Letters and Reminders.

Key Responsibilities:

Designing an ETL and Database solution.

Involved in writing T-SQL Programming for implementing stored procedures and Functions for different tasks.

Used Subqueries, Joins, CTE's and Analytical functions for data retrieval.

Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For-Each Loop Container, Execute SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Look-Up, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.

Worked on data cleansing techniques using lookups, conditional split, and incremental loads.

Worked on Performance tuning for SSIS packages and complex procedures.

Created and managed schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables and maintained Referential Integrity.

Created complex Store Procedures, Triggers, Views, UDFs (User Defined Functions) and other objects to capture, updated and deleted data from OLTP systems.

Performed Data Audits between legacy systems and cleansed the data to move to the data warehouse.

Built SSIS packages to load the Data into Staging, ODS, and dimensional model.

Built customized SSIS packages using C# script Tasks and components.

Worked on dimensional models, built the Star and Snowflake schemas.

Designed efficient schemas by separating OLAP and OLTP workloads and by devoting appropriate resources in building the schemas.

Coordinating with offshore team, explaining the requirements, Assigning Tasks, Reviewing code, integrating the code and make sure there is no issue in the project delivery.

Environment: Microsoft SQL Server 2012, SSIS, T-SQL, Agile, ETL, Microsoft Visio 2003, Microsoft Visual Studio 2010, Business Intelligence Development Studio (BIDS), SQL Server Management studio (SSMS).

AHA (American Heart Association), India February 2014-April 2015

SQL BI Developer

AHA is currently embarking upon a program to re-architect and revamp its Business Intelligence and Data Warehouse capabilities so as to align with AHA’s mission and goals. Through this program, AHA is expecting to enhance its analytics capabilities so as to drive all AHA Business units in improving a better ‘Customer Retention’ as well as ‘Customer Acquisition’. AHA strongly believes that the analytical platform built as part of this program will help AHA Business Units to track all the engagements/activities of the ‘Customers’ irrespective of how Customers are engaged with AHA (be it a conventional channel like Direct Mail or a non-conventional channel like Social Media) and provide a 360 view of the Customers.

Key Responsibilities:

Analyzing requirements, Designing ETL and MDM solution.

Gathered requirements from various head departments and wrote Functional Design Specifications in line with each Business Requirement Document (BRD).

Analyzed source system data that determined the data model and ETL solution that met business requirements.

Implemented MDM Solution.

Worked with T-SQL to create Tables and Stored procedures.

Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables

Responsible for fine tuning of the database, troubleshooting, memory management.

Created and modify all the needed SQL tables and SSIS packages to extract, transform, and load (ETL) the data from several data sources to MS-SQL Server Data Warehouse.

Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions.

Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Identified cause for ETL job failures and rectify the issues

Involved in writing complex Stored Procedures, Functions, Views and Triggers for various business applications.

Extensively worked on retrieving data from Legacy sources, retrieved files on the daily, weekly and monthly basis, and file transfers from one location to other.

Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

Explaining the requirements and Assigning Tasks to the team members, Reviewing code, integrating the code and make sure there is no issue in the project delivery

Assisted with the training of new employees.

Environment: Microsoft SQL Server 2008 R2/2008/2012, SSRS, SSIS, SQL Server Management studio (SSMS), Business Intelligence Development Studio (BIDS), AGILE, Visual Studio 2010/2008, ETL, MDM (Microsoft)

Humana Inc., India May 2010-December 2014

SQL BI Developer

Plan Warehouse Nightly Maintenance package is developed to make the Mainframe and the SQL server database in sync. Input for the package is in the form of text files from the mainframe, where input files have the records which need to be inserted and updated in the database based on the business logic. Once the records get successfully processed, need to prepare the output text files which are compatible with Mainframe and FTPed to Mainframe so that the files can use for comparisons

Key Responsibilities:

Gathered requirements from department managers and turned that information into useful database information.

Worked with Business analysts, Data architects, and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications

Created the Staging tables, successfully migrated old data from legacy system into SQL Server 2008R2 using SSIS Packages.

Tuned and optimized complex SQL queries, stored procedures, and views.

Troubleshoot slow performing queries by using SQL Profiler.

Created promotion request plan documents, ETL standards templates to resolve issues for SSIS jobs.

Write SQL code as needed to support report requests and/or to facilitate other reports.

Environment: Microsoft SQL Server 2008/2008R2, SSIS, SQL Server Management studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008

Accenture Services Pvt Ltd, India May 2006-March 2010

SQL Developer

IPMS stand for Invoice Processing Management system which manages the invoices i.e. consolidates the volumes of all the territories and keeps track of the invoices which user is processing and what is current status of the invoice. The input for this tool is in excel format which is generated from the PRT (all the images will be there in this system). In IPMS tool the Allocation can be done in two ways one is an automatic allocation and the other is manual (depending on the Request) allocation. The customized and drill down reports can be generated and also Graphs can be generated based on the status of Invoices. IPMS also have the workflow, reports and errors for the Auditing Invoices.

Key Responsibilities:

Created the Staging tables.

Writing SQL queries, stored procedures and views.

Debugging and fixing runtime errors during testing

Troubleshoot slow performing queries by using SQL Profiler.

Write SQL code as needed to support report requests and/or to facilitate other reports.

Environment: Microsoft SQL Server 2000.

EDUCATION/COURSES

Bachelor of Technology with specialization in Information Technology, Jawaharlal Nehru Technological University, Hyderabad, India, 2006.

Contact this candidate