PRASANNA REDDY Email: ac0ihg@r.postjobfree.com

Phone: 917-***-****

Professional Summary:

Over 4+ years of IT experience in Database Administration/Database designing and Development using MS SQL Server 2000/2005/2008/2012/2014.

Over 4 years of extensive massaging & analyzing data using MS Excel, Pivot Tables & Charts and VBA.

Expert of MS SQL Server 2005 suite of Business Intelligence products SSRS, SSIS and SSAS.

Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry.

Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as MySQL DBA.

Strong MySQL and SQL Server skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.

Expertise in scripting T-SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designing and implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.

Extensive knowledge of Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.

Experienced in Tableau working with different Enterprise Data sources likes SAP HANA, SSAS Cubes, Hadoop HDFS, Oracle Enterprise Servers and the Extracts (auto/incremental).

Administration, Installation and configuration of a Core Licensed Tableau Server.

Experience in Implementing Change Data Capture (CDC) on databases.

Strong experience in working with BCP, SSIS (DTS, DTSX) packages for Data Integration Services.

Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.

Extensive knowledge of using Package Configuration wizard to configure SSIS packages.

Expertise in creating Property Expressions, Script Tasks for SSIS packages.

Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.

Expertise in creating Report Models for building Ad hoc reports using SSRS.

Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.

Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.

Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.

Expertise in creating Cell Level Security in cubes using SSAS.

Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.

Expertise in creating Dashboard Reports to support end users using SSAS.

Good experience building Star schema and Snowflake schema depending on the business data requirements.

Involved in Full Life Cycle Implementation of Data Warehouse.

Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.

Experience in Diagnosing and Troubleshooting performance issues in sql using DMV’s and DTA.

Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.

Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.

Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.

Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Excellent communication, interpersonal and analytical skills.

Technical Summary:

Operating System

Windows NT/98/2000/XP/2003 server, Windows 7, Unix

Languages

C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL, HTML, XML, VBA

Tools

DTS, SSIS, SSRS, SSAS, Erwin

DATABASE

MS Access, MS SQL Server 2000/2005/2008/2012/2014, Oracle8i/9i/10g

Tools/Utility

Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SQL SERVER BIDS, Visual Studio, SQL Server Data Tools

Software

MS Office, Visio, Microsoft SharePoint Server (MOSS) 2007/2010

Professional Experience:

Client Name: inVentiv Health 04/2016 – Till Now

Location: Somerset, NJ

Role: Sr. SQL/BI (SSIS/SSRS/SSAS) Developer

Responsibilities

Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.

Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.

Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.

Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.

Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.

Managing database clustering on NDB technology.

Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.

Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Created logs for ta load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.

Used XML and environmental variables in the package configuration for Deploying SSIS packages.

Involved in Tabular Data warehouse using SSAS 2014 OLAP databases.

Integrate Azure Active Directory for all user authentication/authorization and organization profiles

Custom Indexed the Document Fields with Different types and modes of Indexing as per the requirement.

Created a script to add indexes to SQL Azure tables.

Responsible for maintaining cubes using SSAS and populate the cubes with the data.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.

Created stored procedures for datasets in SSRS reports to run calculations at database level.

Wrote expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.

Defined Calculated members, named sets, and executed other script commands using MDX expressions.

Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.

Environment: SQL Server 2012/2014, SSIS, SSRS, SSAS, T-SQL, MDX, C#, Excel, Team Foundation Server (TFS), SSMS, Power BI, SharePoint, SQL Profiler,VBA, Visual Studio, SQL Server Data Tools, MySQL 5.1, Windows 7.

Client Name: Summit Financial 03/2015 - 04/2016

Location: Salt Lake City, UT

Role: SQL/BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

Generates various T-SQL scripts using CTE, Store Procedure, Views etc. to access and manipulated data stored in DataMart.

Experience in writing, testing and implementation of the PL/SQL procedure, functions, and packages and Trigger using tools like TOAD.

Updated the statistics info and managed Clustered and Non-Clustered Indices for improved database performance.

Transformation of Data into SQL Server database by development of views, Staging tables and load data into tables using Stored Procedures.

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

Developed SSIS packages to load archive text files to SQL Server using SSIS Fast Load, Concurrent Data Flow Tasks, Expressions, Copy Column, Multicast, Lookup, Conditional Split and SCD Transformations.

Customized MS Dynamics CRM 2011 application based on the business requirement

Designed the web UI using HTML, JQuery, CSS.

Migration of data from Excel source to CRM using SSIS.

Developed helper classes using C-sharp (C#) to simplify ASP.NET MVC application.

Imported contacts from existing application into MS Dynamics CRM 2011 using the WCF service.

MySQL database administration on a large scale MySQL installation.

Experience with MySQL on both Linux and Windows.

Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.

Responsible for Performance Tuning of SQL commands and troubleshooting of Technical problems in SQL Server using SQL Profiler and the Database Engine Tuning Advisor.

Deployed SSRS reports in native and SharePoint mode.

Designed reports using SQL server reporting services (SSRS) and Excel pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports.

Created SQL Server Reports using SSRS. Developed queries for generating Drill-Down and Drill-Through Reports in SSRS. Generated Reports using Global Variables, Expressions and Functions for the reports.

Involved in planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services(SSAS).

Created calculated members, named set, advanced KPI’S for the SSAS cubes.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.

Configured MERGE Replication using Snapshot agent and Merge Agent. Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.

Environment: SQL server 2012, SQL server Management studio (SSMS), SQL server integration services (SSIS), SQL server reporting services (SSRS), SQL server Analysis services(SSAS), VBA, MySQL, SQL server profiler, Microsoft visual studio, Team Foundation server(TFS).

Client Name: Virtusa 09/2013- 11/2014

Location: Hyderabad, India

Role: SQL Developer

Responsibilities:

Designed and created the table schema and stored procedures that will be used in Data QC.

Created complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.

Developed, modified, and optimized existing complex stored procedures, triggers to handle complex business rules, history data and audit analysis.

Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.

Developed physical data models and create DDL scripts to create database schema and database objects.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).

Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.

Extract Transform Load(ETL) development Using SQL server Integration Services(SSIS).

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, Chart and Matrix report).

Generated several drill down and drill through reports using SSRS.

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2008 Enterprise Edition, Oracle 9i, SSIS, SSRS, MS .NET Frame Work, ASP.NET, C#, MS-Access, ADO.NET, MS Project.

Client Name: Asian Paints India Ltd. 12/2012 - 08/2013

Location: Hyderabad, India

Role: Jr. SQL Developer

Responsibilities:

Install, Update, Configure and Maintain the MS SQL Server.

Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.

T-SQL queries for the retrieval of the data.

Used Try-Catch and @@error for exceptional handling.

Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.

Written Various ASP codes for user interactions.

Written Java Script for different validations.

Created Linked Servers to connect OLE DB data sources and providers.

Performance tuning of SQL queries and stored procedures using Index Tuning Wizard.

Scheduling Jobs and Alerts using SQL Server Agent.

Environment: SQL Server 2000/2005, T-SQL, MS-Excel, MS-Access, VB 6.0, Windows XP.

Education:

Master’s in Information Assurance

Wilmington University 2015 - 2016

Bachelor in Technology in Electrical and computer engineering 2009 - 2013

Jawaharlal Nehru technological university

Contact this candidate