RAJITHA REDDY Ph. No: 469-***-****

BI Developer (SQL, Tableau, QlikView) E-mail: ac1m8m@r.postjobfree.com

SUMMARY

6+ years of experience in Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2012/2008/2005/2000.

Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.

Involved in Requirement gathering & designing QlikView Applications. Creating and Managing QlikView Reports & Dashboards.

Experienced in creating and using Stored Procedures, Views, User Defined Functions.

Involved in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.

Experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.

Designed and developed extensive QlikView reports using combination of charts and tables, Writing SQL Scripts to load the relevant data in QlikView Applications.

Good knowledge in developing and designing reports through SQL Reporting Services (SSRS) and Excel.

Experience in various reports like tabular reports, matrix reports, and parameterized reports using SQL Reporting Services (SSRS).

Experience in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, and Bar Charts.

Involved in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).

Having experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using Server Integration Services (SSIS).

Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.

Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.

Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning

Can work in a fast-paced environment, Good team player and can work independently.

TECHNICAL SKILLS

Data Warehouse Tools

SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS), SSMS, Business Intelligence Development Studio.

Databases

MS Access, MS SQL Server 2000/2005/2008/2012, Oracle 8i/9i/10g, MYSQL. SQL Server Management Studio (SSMS), SQL Profiler.

Non-Relational DB

MongoDB 2.6/3.2

Reporting Tools

Excel, SQL Server Reporting Services 2012,2008,2005.

BI Tools

Tableau(Desktop/Server/Dashboards)8.3/9.0/10.1, Business Intelligence, QlikView

Languages

C, C++, Java

Web Technologies

Java Script, HTML, CSS

Operating Systems

Windows 2003/2008/2012/2013 Servers

Other Tools

MS Office, MS Excel.

PROFESSIONAL EXPERIENCE

Inventive Health, Franklin, Tennessee May’17 to Till Date

Designation: SQL Server BI Developer(SQL/SISS/SSRS/Tableau)

Project: Clinical Educators Performance

Responsibilities:

-Involved in Analysis, Implementation, Development and production support of the application.

-Imported and Extracted data from various sources such as flat file, access, SQL Server and loaded those data into SQL Server to build various reports.

-Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop 9.0

-Troubleshoot SSIS packages and migration procedures and Document complex SSIS packages and migration procedures.

-SQL Server database modelling, design and development with complex SQL scripts, Stored procedure, Views, Defined Functions, Triggers.

-Designed and developed mappings to load the data from flat file to SQL Server tables for

reporting purposes.

-Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ Dashboards.

-Involved in creating’s reports, creating Stored procedures and improving query performance.

-Developed stored procedures and views for data import and manipulation.

-Configured User row level security for data in the Dashboard.

-Working on analyzing the existing BI infrastructure and coordinating with various teams to install and configure single node Tableau Server.

-Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

-Generated periodic reports, charts based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

-Used SQL Profiler to trace Performance of Queries and to index the Tables.

-Developed software test plans, test design specifications, and test scripts for various test scenarios and Performed Unit Testing for the project.

Environment: SQL Server 2014/12, SQL Server Integration Services (SSIS), Tableau Server, Tableau

Desktop, SQL, SQL Server Reporting Services(SSRS), SQL Server Business Intelligence.

Citi Group, Dallas, Texas Oct ’16–May’17

Designation: BI Developer (Tableau, QlikView, Excel)

Project: Sector Management

Responsibilities:

-Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

-Created data queries and reports using QlikView, Visual Studio, and Excel.

-Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop 9.0.

- Created custom queries/reports designed for quality verification and information sharing.

-Designed and developed SQL Server Integration Services (SSIS)Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.

-Involved in complete SQL Server Integration Services (SSIS)life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

-Involved in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, and Bar Charts.

-Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

-Created SSIS packages for Data Conversion using data conversion transformation.

-Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.

-Designed and created Report templates, bar graphs and pie charts based on the financial data.

-Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.

-Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.

-Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.

-Worked closely with business power users to create reports/dashboards using Tableau Desktop.

-Coordinated with front-end for implementing logic in stored procedures and functions.

-Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.

-Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, Tableau, XML, MS Visual Source Safe and Windows Server 2003.

Pegasus IT, Dallas, Texas Mar’13 – Sept’16

Designation: SQL Server BI Developer (SSIS/SSRS)

Project: Think Finance

Responsibilities:

-Design/Build Extract Transform Load procedures in SQL Server Integration Services.

-Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.

-Troubleshooting ODBC and OLEDB connection issues in SSIS packages.

-Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

-Designed the packages to extract data from SQL DB, flat files and loaded into Oracle database.

-Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.

-Developed user defined financial reports to provide on demand financial data analysis using SSRS.

-Performed data conversions from flat files into a normalized database structure.

-Developed numerous ad-hoc reports using SSRS for day to day financial reporting.

-Written and executed complex queries using SQL Server Management Studio for back end data validation testing.

-Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

-Involved in design, programming, deploy and Unit Testing of requested Reports.

-

Environment: SQL Server 2008 Enterprise Edition, SQL Reporting Services (SSRS) 2008, SQL Server Integration Services (SSIS) 2008, CSS, T-SQL, XML, MS Excel

Mahindra Satyam, Hyderabad, India Sept’12– Jan’13

Designation: SQL Server BI Developer

Project: Western Union

Responsibilities:

-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.

-Generated custom and parameterized reports using SQL Reporting Services (SSRS).

-Created reports that call sub reports in SQL Reporting Services (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.

-Created several packages in SQL Server Integration Services (SSIS).

-Scheduled the packages to keep extracting the data from OLTP at specific time intervals.

-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.

-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.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Agent, SQL Server Integration Services (SSIS) 2008, SQL Reporting Services (SSRS) 2008, C#, T-SQL, Windows 2000/2003 Server, XML, MS Excel, MS Access.

Mahindra Satyam, Hyderabad, India Jan’11–Sept’12

Designation: SQL Server

Project: MoveNetworkSystem

Responsibilities:

-Involved in documenting the code for understandability.

-Participated in creating reports that deliver data based on stored procedures.

-Experience in creating snapshots of static reports and configure subscription.

-Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.

-Involved in developing triggers to audit schema changes at the database level.

-Created sub-reports to present more detailed information about the summary.

-Designed and implemented stored procedures and triggers for automating tasks.

-Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.

-Worked on improving the performance of the system.

-Created permanent tables, temporary tables and table variables.

-Used Query Analyzer to optimize SQL queries.

Environment: SQL Server 2005/2008,MS Excel 2003, MS SQL Query Analyzer, SQL Profiler.

EDUCATION

Master of Computer Applications from Osmania University, Hyderabad, India

Bachelor of Computer Science from Osmania University, Hyderabad, India

Personal Details

Sex: Female

Nationality: Indian

Visa Status: H4 EAD

Languages Known: English, Hindi, and Telugu

Current Location: Franklin, Tennessee (USA)

Contact this candidate