Summary
Overview
Work History
Education
Skills
Affiliations
Certification
Timeline
Generic

DINESH KUMAR KONDUGARI

Fitchburg,United States

Summary

  • Around 7.5 years of IT experience in database development, administration, data analysis, system analysis, design, development, and support of MS SQL Server 2008, 2005, and 2000 in production, testing, and development.
  • Experience with the software development life cycle (SDLC), Agile/Scrum, and project management methodologies. Capable of handling responsibilities independently as well as being a proactive team member.
  • Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis, and documentation.
  • Experience coordinating with users to gather source data files, define data elements, business rules, data, and process flow documentation, and prepare high-level and low-level design documents.
  • Experience installing and configuring Microsoft SQL Server 2000, 2005, 2008, 2008 R2, and 2012. Hands-on experience in monitoring SQL Server performance tuning in SQL Server 2000, 2005, and 2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
  • Knowledge of relational database management systems.
  • Experience in database backup, recovery, and disaster recovery procedures. Experienced in creating and using stored procedures, triggers, views, user-defined functions, sub-queries, and joins for complex queries involving multiple tables and exception handlers.
  • Proficient in SQL Server and T-SQL (DDL and DML) table construction and database table normalization and denormalization techniques.
  • Experience in creating and updating clustered and non-clustered indexes to keep up SQL Server performance. Experience creating and managing index fragmentation to improve query performance.
  • Experience in Performance Tuning and Query Optimization.
  • Install and configure SQL Server 2005, 2008, and 2008 R2 on virtual machines. Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and data migration and transformation from Oracle/Access/Excel sheets using SQL Server SSIS.
  • Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.
  • Experience in Error, and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archiving Data files from different legacy systems using SQL Server 2005/2008/2012 environment, deploying the data, and scheduling the jobs to execute these tasks periodically.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
  • Having experience in Database administration like creating the roles, and users and giving the permissions for the database, tables, functions, etc.
  • Have good experience in creating SQL Server Analysis Projects using SQL Server 2000, 2005, and 2008.
  • Good knowledge of working with facts, dimensions, and multi-dimensional cubes. Experience in creating Ad hoc reports and reports involving complex datasets and querying the database for business intelligence.
  • Expertise in developing parameterized, chart, graph, linked, dashboards, scorecards, drill-down, drill-through, and cascading reports using SSRS.
  • AWS experience – having two years of experience with SQL server migration to AWS AlwaysOn from standalone and vice versa
  • Well-versed in determining the correct size and making configuration changes.
  • Create profiles, permission sets, and roles and assign them to users, create new users and manage user privileges.
  • Knowledge of networking concepts and object modeling technology
  • Good interpersonal, analytical, and communication skills.
  • Experience in Object Oriented Analysis concept implementation, design, and programming technical skills.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Software Developer

Oxford Global Resources Inc
Beverly, MA
01.2023 - Current
  • Installation, Configuration, Maintenance and Administration of MS SQL Server 2008 R2.
  • Responsible for creating T SQL scripts to create report models. MS SQL performance tuning. Trouble shooting problems by using SQL server profiler. Developed and document disaster recovery plan.
  • Involved in Setting up Log shipping, database mirroring and Involved in Creating Back up Strategy.
  • Involved in Designing (Logical and Physical) of Customer Database.
  • Created & managed the Database Users, Login, Roles, Profiles and Security.
  • Automated Backup/Restore Jobs as well as reduce the Backup/Restore time up to significant amount
  • Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using MS SQL.
  • Creation of Jobs, Schedules, Alerts using MS SQL Server Agent and Notifications using SQL Mail Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle DB to MS SQL server. Worked as MS SQL Server administrator.
  • Worked on performance tuning of Database and Query tuning.
  • Involved in resolving blocking and dead lock Issues by using MS SQL commands Using T-SQL.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other TSQL code to implement business rules.
  • Designed Handshaking architecture for overall data transfer from the OLTP to Staging area and finally into OLAP with SSIS and T-SQL stored procedures. Worked on existing OLTP system(s) and created facts, dimensions, data models, star schema representation of the OLAP databases.
  • Developed, deployed, and monitored SSIS Packages including upgrading SSIS using upgrade advisor. Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
  • Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages, Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.

Senior SQL Developer

Cognizant Technologies Solutions
Hyderabad, Telangana
03.2018 - 04.2022
  • Contributed to the definition of database requirements; analyzed existing models and reports for opportunities to improve efficiency and troubleshoot various performance issues.
  • Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.
  • Involved in performance monitoring, tuning, and capacity planning. Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
  • Translated business requirements into BI application designs and solutions.
  • Created SSIS package to load data from Flat Files, Excel, and XML Files to Data warehouse and Report Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
  • Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Responsible for the implementation of data viewers, Logging, and error configurations for error handling the packages. Involved in the complete life cycle of creating SSIS packages, building, deploying, and executing the packages in both environments (Development and Production).
  • Created and maintained data flow diagrams for existing and future ETL processes. Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).
  • Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
  • Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, and Drill-down reports using Expressions, Functions, Charts, and Maps, Sorted the data, Defining Data sources and Subtotals for the reports
  • Publishing PDF Reports obtained from the Report Server on to SharePoint Portal
  • Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, a conditional split, and backup and was involved in the scheduling of SSIS packages.
  • Involved in Data Extraction, Transformation, and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
  • Involved in the error handling of SSIS packages by evaluating error logs.
  • Successfully extracted transformed and loaded data into the data warehouse.
  • Created reports using SSRS from OLTP and OLAP data sources and deployed them on the report server Created tabular, matrix, chart, drill-down reports, parametric, cascaded reports, dashboards, and score cards reports (SSRS) according to business requirements.
  • Created reports by dragging data from the cube and wrote MDX scripts. Used SSIS 2008 to create ETL packages(dtsx files) to validate, extract, transform and load data to a data warehouse, and data mart databases, and process SSAS cubes to store data in OLAP databases
  • Improved the performance of long-running views and stored procedures. Improved performance by adding indexes, removing unnecessary columns in the inner views, and adding conditions to get only the required data.
  • Identified slow-performing views, stored procedures, and queries using SQL Profiler, by running simultaneously while browsing the application.
  • Tuned the queries using the Execution plan, to get an index to seek from table scan and index scan. Improved the performance of many queries by 90%.
  • Worked with Erwin data modeling tool
  • Created Database objects including Tables, Views, Stored Procedures, and UDF.
  • Developed User-defined functions, stored procedures, indexes, and Triggers.
  • Extensively involved in writing database scripts.

SQL Developer

Cognizant Technologies Solutions
Hyderabad, Telangana
11.2015 - 02.2018
  • Writing triggers, stored procedures, and functions defining user-defined data types, TSQL, and creating and maintaining physical structures for collateral management and hedging.
  • Working with Dynamic Management Views, System Views for Indexing, and other Performance Problems
  • Create / Manage Table Indexes, Query Tuning, Performance Tuning, and Deadlock Management
  • Defect tracking and closing by using HP Quality Center
  • Design and Deploy SSIS Packages
  • Creating SSIS Packages, Configure SSIS packages for different environments using DTSConfig
  • Produce CSV, and utilize CSV files as part of the ETL Process
  • Used .Net Scripts
  • Produce XML
  • Event Handling, Logging, and Batch Checks for data accuracy
  • Code deployments/configurations/config management in various environments
  • Implement Security, Roles, Logins, and Permissions
  • Extract-Transform-Load data into SQL Server 2008 Normalized database from various sources
  • Maintain Users / Roles / Permissions, Security
  • Scheduling SSIS packages using Autosys, writing JIL Scripts
  • Enhance existing applications to meet new business requirements
  • L3 Production Support on a Rotation Basis Enhance existing stored procedures, views, functions, and database objects to meet additional requirements of the latest releases
  • Capacity Planning DBs, Disk Requirements
  • Deploy the code in various environments.
  • Create and maintain DB Change Log to track the state of the DB in each environment (Dev, Test, UAT, Pre-Prod)
  • Application Testing, Debugging SIT, UAT, Test Clusters, and Test Load Balancers
  • App Testing in Development, Production, DR UML Use Case diagrams, Conceptual Flow Diagrams, and ER Diagrams by reverse engineering the databases using Visio 2003
  • Deploy various reports on SQL Server 2005 Reporting Server
  • Tuning the Databases, Auditing, and Dynamic Management Views
  • Database Capacity Planning, Maintenance Plans, Backup, and Restore
  • Data Modeling, Conceptual/Logical/Physical Modeling
  • Create and maintain a database for Incident, Problem Tracking, Metrics
  • Working with SQL, and T-SQL queries, worked on developing Stored Procedures, functions, triggers, and Views.
  • Design Reports as on Internal User needs
  • Access SharePoint Server using Web Services to deploy reports on Reporting Server
  • Involved in creating tables, stored procedures, indexes
  • Creating and Maintaining users, logins, jobs, job Notifications with packages.
  • Design, Creating, and Deploying various SSIS Packages (for ETL - Extraction, Transformation, Loading)
  • Configuring the Database Mail, Mail Operators using SQL Server 2005
  • Importing Data from various sources like DB2, Oracle, Excel, XML
  • Ensuring Data Consistency, Analyzing the Data
  • Detailed documentation of all the existing and new processes, Create and Update Data Dictionaries Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions

Education

Masters Degree - Computer Science with Data Science Concentration

Fitchburg State University
Fitchburg, MA
05.2023

Bachelor of Engineering - Electronics And Communications Engineering

RMD Engineering College
Chennai
04.2015

Skills

  • Programming Languages: C#, ASPNET, ADONET, Entity Framework
  • Application Servers: IIS
  • Operating Systems: Windows 95/98/2000/NT/XP /2003/2008, UNIX, LINUX
  • Data Base: MS SQL Server 2008/2005/2000/70
  • Web Technologies: HTML, CSS, JavaScript
  • Reporting and Data Warehouse tools: SSRS, SSIS
  • ERP/Cloud technologies: AWS, Azure(learning)
  • Technical writing: Source documentation, Requirements gathering
  • Microsoft Suite: MS Office, MS Word, Powerpoint, Excel, Outlook, SharePoint

Affiliations

· AWS migration work – acknowledged at PCF Client Newsletter – April 2021

Awards from the Manager:

· Sapphire Award –Best Performer for November 2016

· Coral Award – Went the extra mile and provided support – March 2017

· Sapphire Award – Always Striving Never settling – December 2018

· Sapphire Award – Working as One (First parcel delivery go-live) – August 2020

· Sapphire Award – Great job on SQL migration - July 2021

· Bronze Award – Moved to DBA role - August 2021

· Coral Award - Gratitude for your hard work and dedication – September 2021

Certification

  • Certified AWS Solutions Architect, Amazon Web Services - [August 2022]

Timeline

Software Developer

Oxford Global Resources Inc
01.2023 - Current

Senior SQL Developer

Cognizant Technologies Solutions
03.2018 - 04.2022

SQL Developer

Cognizant Technologies Solutions
11.2015 - 02.2018

Masters Degree - Computer Science with Data Science Concentration

Fitchburg State University

Bachelor of Engineering - Electronics And Communications Engineering

RMD Engineering College

Similar Profiles

  • Cian McCarthy

    Cian McCarthyCian McCarthy

    Senior Business Development Manager at Oxford Global ResourcesSenior Business Development Manager at Oxford Global Resources

  • NEIL A. MOCK

    NEIL A. MOCKNEIL A. MOCK

    Civil Engineering Consultant at Oxford Global ResourcesCivil Engineering Consultant at Oxford Global Resources

  • Christian Lee

    Christian LeeChristian Lee

    Account Manager at Oxford Global Resources IncAccount Manager at Oxford Global Resources Inc

  • Teddy Wyatt

    Teddy WyattTeddy Wyatt

    Full Stack Cloud Developer at Oxford Global Resources IncFull Stack Cloud Developer at Oxford Global Resources Inc

  • Daniela Perez

    Daniela PerezDaniela Perez

    Family Supports and Recreation Coordinator at The Arc of OpportunityFamily Supports and Recreation Coordinator at The Arc of Opportunity

CREATE PROFILE
DINESH KUMAR KONDUGARI