CHEPURI PRUDHVEE

Email: adz5oz@r.postjobfree.com

Ph: +1-647-***-****

Professional Summary:

Approximately 4 years of IT experience in development, testing, and production environments with a variety of business domains, including database design, analysis, reporting, and support for MS SQL Servers 2016/2014/2012.

Proficiency using tools like SQL Profiler to script T-SQL queries, complex stored procedures, functions, and database triggers.

Simplified complex queries involving numerous tables by using joins and sub-queries.

Proficiency in designing and managing database objects like constraints, views, triggers, and indexes.

Practical knowledge of query optimization and performance tuning, including the ability to rebuild and rearrange indexes and update statistics.

Experience with system upgrades, monitoring, job scheduling, troubleshooting, and backup and recovery.

Proven track record in creating, setting up, deploying, and securing SSIS products.

Many SSIS products have incremental load implemented.

Practical knowledge of Relational Database Management Systems, such as Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, and Normalisation.

Developing scripts for DR drills and carrying out POC for environments running SQL Server 2016/2014/2012/2008 R2, as well as designing, setting up, and supporting HADR environments employing Clustering, Mirroring, and AG technologies.

Using SQL Server 2016/201/2012 Enterprise Edition, we combined three significant business environments into one infrastructure and established AlwaysOn Availability groups for HADR.

Implemented and designed compression/continuing compression strategy.

SSIS production support experience with error handling, debugging, and logging.

Proficient in using the BCP utility, DTS, and SSIS services to extract, transform, and load (ETL) data from Excel, flat files, Oracle, and MS SQL Server.

Practical experience in creating queries to import data from SQL Server and Oracle servers into Tableau.

Used SSIS to deploy and log different package types.

Proven ability to upgrade and deploy SSIS Packages from development to production servers.

Using SSRS, created and maintained a variety of reports, including dashboards, parameterized reports, drilling down and through reports, and cascading reports. Roles and rights were defined to manage security.

Have knowledge of T-SQL query optimisation, blocking difficulties, and performance tuning.

Designed various Power BI visualizations in accordance with the specifications.

Expert at Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

A team player with excellent interpersonal, communication and presentation skills.

Education –

Bachelors of Computer science Engineering,Hyderabad

PG diploma in Information System Business Analysis.

TD Bank Jan 2021- Current

Role: Data Base Administrator

Responsibilities:

•Involved in implementation and designing of the compression/continuingcompressionstrategy.

•Using query tuning and lockchecking, collectively worked with the programming team for optimal SQL server behavior.

•Implemented design setup and also supported HADR environments by using clustering, mirroring & AG Technologies.

•Collected business requirements from users and translated them as technical specifications and design documents for development.

•Analyzed data and designed the logical and physical models for all projects.

•Created complex T-SQLQueries, StoredProcedures, Functions, Indexes, CTE's, Views, Joins and Triggers.

•Involved in script creation for DR drills and performing POC for SQLserver 2016/2014/2012/2008, R2 environments.

•Accumulated 3 businessenvironments into single environment, implemented Alwayson Availability groups for HADR using SQL server 2016/2014/2012 Enterprise edition.

•Developed SSISPackages and Stored Procedures to load/transform/cleanse data from SQLServer, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.

•Participated in the design and development of the DataWarehouse.

•DesignedSSIS packages for Installment loan POS integration, HI score card, Footwear Restocking, Shopping Recap – IR labs Projects.

•Migrated store Promo Tracker SSRS Reports to Tableau.

•Collect requirements for different executivedashboards, analysis and model flows from various sources to integrate into TableauDashboard

•Provide drill down capabilities by setting up the hierarchies and Action filters in tableau to help the users to dig deeper.

•Experience in Analyze, design and build Modern data solutions using Azure PaaS service to support visualization of data. Understand current Production state of application and determine the impact of new implementation on existing business processes.

•Removed SecurityVulnerabilities from MultiplesMachines on both On Premise and Azure by consistently applying patches and hot fixes

•Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of AzureDataFactory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (AzureDataLake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.

•Experience in publishing the PowerBIDesktopmodels to Power Bi Service to create highly informativedashboards, collaborate using workspaces, apps, and to get quick insights about datasets.

•Export tableau dashboards to server with group level and user level privileges.

•Provide dual axis charts for comparison in tableau which helped in decision making.

•Automated existing store Promo Tracker stored procedures to SSIS Packages using different transformations and SQL Server Agent Jobs.

•Designed History tables to capture name changes, location changes for understanding user behavior and 1099reporting.

•Created checkpoints, packagelogging, error logging and event handling to redirect error rows and fix the errors in SSIS Packages.

•Troubleshoot issues with ETLload (SSIS and Stored Procedures) and Cube processing.

•Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQLProfiler and Database Tuning Advisor.

•Created SSRS reports such as tabular, matrix, charts, dash-board and sub-reports using SSRS R2.

•Developed stored procedures, cascading parameters and custom code for developing complex SSRS reports.

•Created SSRSdashboards using charts, gauges, indicators and data bars.

•Deployed SSRSreports in native and SharePoint mode.

•Created standard and datadrivensubscriptions for weekly, monthly and daily reports.

•Participated in code-review sessions on existing SSRSreport's performance and Dataset query tuning.

•Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.

Environment: SQLServer, SQLServerDataTools (SSIS/SSRS/SSAS), SharePoint, T-SQL, OLAP, Report Builder 3.0, Business Objects, Erwin 4.0

Telangana Solutions, Hyderabad, India Jan 2019 – Dec 2020

Role: Data Base Administrator

Responsibilities:

•Developed SSISpackages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.

•Designed SSIS Packages to transfer data from flatfiles to SQLServer using BusinessIntelligenceDevelopmentStudio.

•Extensively used SSIStransformations such as Lookup, Derivedcolumn, Dataconversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

•Performed datacleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.

•Developed free-form reports using SSRS for consolidatingmultiple reports into single report delivered in .pdf format to the power users.

•Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.

•Performed DatabaseAdministration of all database objects including Tables, Clusters, Indexes, Views, Sequences Packages and Procedures.

•Developedparameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.

•Implementedcomplexbusinesslogic through T-SQL stored procedures, Functions, Views and advance query concepts.

•Created databases and schemaobjects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

•Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.

•Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.

•Integrated Custom Visuals based on business requirements using Power BI desktop.

•Developed complexSQLqueries using stored procedures, common table expressions (CTEs), temporary table to support PowerBI and SSRSreports.

•Developed complex calculatedmeasures using Data Analysis Expression language (DAX).

•Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.

•Successfully redesigned and migrated complex applications from Access to SharePoint and SQLServer 2008 by evaluating database structures and data movements.

•Extensively worked on enhancements and performance issues of the existing data import processes.

•Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering the desired KPI’s in the Cubes.

Environment: MS SQL Server 2008R2/2012/2014, SSIS, SSRS, Management Studio, Visual Studio, Windows 7, MS Office 2010/2013, Windows Server 2008 and Windows Server 2008 R2, Power BI Desktop, Power BI Service.

Contact this candidate