Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic

Satish Kumar Gande

Nizampet, Hyderabad

Summary

To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

12
12
years of professional experience

Work History

Project Manager (Technical)

Cognizant India Pvt Ltd
08.2021 - Current
  • Carried out day-to-day duties accurately and efficiently
  • Maintained tactical control of project budgets and timelines to keep teams on task and achieve schedule targets.
    Updated customers and senior leaders on progress and roadblocks.
    Oversaw large portfolio of projects to support teams, report progress and influence positive outcomes for key stakeholders.
    Partnered with project team members to identify and quickly address problems.
    Collaborated with business users, technical teams, database administrators and testing teams during kickoff meetings, joint application designing and planning sessions to validate requirements.
    Communicated project plans and progress to key stakeholders and project contributors.
    Accomplished client goals by providing quality technical projects.
    Developed project plans and managed project scope using methodologies to guide projects from conceptualization to implementation and maintenance.
    Collaborated with project owners and team members to set ambitious but achievable goals.
    Managed and motivated project teams to promote collaboration and keep members on-task and productive.
    Maintained project schedules by managing timelines and making proactive adjustments.
    Delivered services to customer locations within specific timeframes
    Developed and implemented performance improvement strategies and plans to promote continuous improvement
    Led projects and analyzed data to identify opportunities for improvement
    Collaborated with team members to achieve target results
  • In Production, Development and Staging Environments along with SQL Server Reporting Services
  • Experience on Azure Data Factory, SSAS Administration and SQL Data warehouse Administration, Database Migration using T-SQL Scripts
  • Worked on Agile Process Model
  • Extensive experience in Installation, Configuration and Updates of SQL Server
  • Designing and Deployment of Reports for End-User requests using Web Interface & SSRS
  • Experience in SSRS reports using SQL Server Business Intelligence Development Studio (BIDS) and creating various types of reports like drill down, Parameterized, Cascading, Table, Matrix, Chart and Sub Reports
  • Distributing reports to users using scheduled subscriptions
  • Hands on experience in SQL Server like creation of Tables, Stored Procedures, Views, Jobs, Cursors and Indexes using SQL Server 2005/2008/2012 with T-SQL
  • Experience in BI Development and Deployment of DTS, SSIS packages from SQL, Excel
  • Experienced in SDLC life cycle for Design, Development and Staging phases of projects with support of Data-Flow, Process Models, E-R Diagrams
  • Administration of user access in Azure SQL Data warehouse and managing permissions assigned to different users and Service accounts
  • Managing SQL DW through Azure Portal- monitoring DWU usage and query performance, number of queries running and status of query completion
  • SSAS: Creating empty shell cubes
  • Creating roles at cube level and adding users to role
  • Granting access to users at cube level and SSAS instance level
  • Looking into issues while processing cubes
  • Creation of Azure Data Factory pipelines for loading data from Azure Blob Storage (source) to Azure SQL Server (destination)
  • Creation of Azure Data Factory pipelines for loading data from Azure SQL Server (source) to Azure BLOB storage (destination)
  • Create linked services to connect to Azure Storage, on-premises SQL Server and Azure Blob Storage
  • Created ADF triggers to make sure ADF gets triggered when file is saved to Azure BLOB Storage.

Technical Lead

Wellsfargo Through Euclid Innovations India Pvt Ltd
10.2020 - 07.2021
  • Lead a software development team comprising of 8 team members
  • Assisted team in Technical aspects of Development

Azure Data Factory Developer

TJX COMPANIES INC, Microsoft
02.2019 - 09.2020
  • Creation of Azure Data Factory pipelines for loading the data from Azure Blob Storage (source) to Azure SQL Server (destination)
  • Creation of Azure Data Factory pipelines for loading the data from Azure SQL Server (source) to Azure BLOB storage (destination)
  • Create linked services to connect to Azure Storage, on-premises SQL Server and Azure Blob Storage
  • Created ADF triggers to make sure the ADF gets triggered when a file is saved to a Azure BLOB Storage
  • Developed SQL Server Stored Procedures that are required for ADF Copy data activities
  • Implementation of the retry logic of ADF as part of the stress test on Azure Data Factory.

DC Consultant

Deloitte Consulting India Pvt. Ltd
08.2017 - 09.2020

SQL Database Administrator

LIFESCAN, INC
12.2018 - 02.2019
  • S & Johnson’s, Create/Modify MS – SSIS packages to re-direct data into the new SupplyChain database
  • Monitor SQL Agent jobs and take corrective actions in the event of a failure
  • Validate data in SQL tables with existing J&J production environment
  • Validate data on Tableau reports with SQL data
  • Data Lineage Analysis
  • SMTP Configuration in DEV & QA
  • Automate user creation scripts and its securable
  • Technical Environment: MS SQL Server, SSIS
  • Project: TAX - GES

Tech Lead

Ecentric Solutions India Pvt Ltd
02.2017 - 08.2017

SQL SSRS Developer

02.2017 - 05.2017
  • Developing reports like drill through reports, charts
  • Publishing, Scheduling and providing security for Reports in SSRS
  • Providing user level, role level and branch level security to all Reports
  • Developed Stored Procedures and T-SQL scripts for performing automation tasks
  • Created the SQL Mail triggering Jobs that triggers the overdue milestone records
  • Involved in Installation, Configuration and Deployment of SSRS Reports using different scenarios
  • Worked on the Data Migration of segregating the data for each individual clients
  • Technical Environment: SQL Server 2008 R2 , Sql Server 2012
  • Project: Tax ECM DT1 Workflow

Senior DBA

Napier Healthcare Solutions
01.2016 - 11.2016

SSRS & SQL Developer, SQL Developer

01.2016 - 11.2016
  • Developed Stored Procedures and T-SQL scripts for performing automation tasks
  • Providing user level, role level and branch level security to all Reports
  • Providing the databases scripts at each and every release
  • Design the database entities and their relational schema as per the requirement specifications provided
  • Support to the client in the health care application data issues
  • Project: Tax ECM DT1 Workflow / Audit Milestone Management System
  • Role: SSRS

SENIOR SOFTWARE ENGINEER

Deloitte, Inc Through Technosoft Global Servies Pvt Ltd
10.2014 - 08.2015

SSRS Developer

10.2014 - 08.2015
  • Developed Stored Procedures and T-SQL scripts for performing automation tasks
  • Involved in Installation, Configuration and Deployment of SSRS Reports using different scenarios
  • Increase the performance by decreasing the duration for report generation
  • Developed the reports like table and Matrix and the grouping of table data
  • Publishing, Scheduling and providing security for Reports in SSRS
  • Providing user level, role level and branch level security to all Reports
  • Implementation of the reports in French
  • Project: Audit Milestone Management System

SQL Developer

10.2014 - 08.2015
  • Developed Stored Procedures and T-SQL scripts for performing automation tasks
  • Created the SQL Mail triggering Jobs that triggers the overdue milestone records
  • Involved in Installation, Configuration and Deployment of SSRS Reports using different scenarios
  • Designed and developed the matrix reports
  • Designed the reports that use pie, bar charts
  • Designed the sub reports that are internally called from the main report using Lists
  • Increase the performance by decreasing the duration for report generation
  • Implementation of the reports in French Language
  • Customized the report to show the View Report button in French
  • Project: NHS (Lee Ah Mooi) / Napier Hospital Information System (HIS) /, Developed Stored Procedures and T-SQL scripts for performing automation tasks
  • Involved in Installation, Configuration and Deployment of SSRS Reports using different scenarios
  • Increase the performance by decreasing the duration for report generation
  • Developed the reports like table and Matrix and the grouping of table data
  • Publishing, Scheduling and providing security for Reports in SSRS
  • Providing user level, role level and branch level security to all Reports
  • Implementation of the reports in French
  • Created the SQL Mail triggering Jobs that triggers the overdue milestone records
  • Designed the reports that use pie, bar charts
  • Designed the sub reports that are internally called from the main report using Lists
  • Increase the performance by decreasing the duration for report generation
  • Implementation of the reports in French Language
  • Customized the report to show the View Report button in French
  • Project: Loan Origination System / Lead Management System / Mortgage Origination Platform

SOFTWARE ENGINEER

Tetrasoft India Private Ltd
08.2013 - 08.2014

IT-DATABASE REPORT WRITING ANALYST

Systems Private Ltd
01.2010 - 08.2013

SSRS & SQL Developer

01.2010 - 08.2013
  • Guide junior developers in developing reports
  • Provide solutions for complex requirements like branch security, user security for data while generating reports
  • Increase the performance by decreasing the duration for report generation
  • Developing reports like drill through reports, charts
  • Design table structure and write stored procedures for dumping data into reports database used for reports
  • Create SQL jobs for executing stored procedures which transfer and manipulate data
  • Publishing, Scheduling and providing security for Reports in SSRS
  • Providing user level, role level and branch level security to all Reports.

Education

BTECH - Computer Science and Engineering

JNTU, Intermediate
Hyderabad
2009

Class 12 -

Sri Aurobindo Junior College(Board of Intermediate
Hyderabad, TG
2005

English Union School (CBSE)
Hyderabad, TG
2003

Skills

Project Management Skills:

  • Team building
  • Decision-Making
  • Planning and Coordination
  • Organization and Time Management

Personal Skills

  • Strong Interpersonal skills both oral and written
  • Good Team working abilities
  • Quick learner
  • Optimism and Passion to succeed

Technical Competencies:

  • Azure Database Administration
  • Azure Data Factory Development
  • DBT Development
  • Microsoft Azure SQL Data Warehouse (SQL DW)
  • Microsoft SQL Server 2005/2008/2012
  • T-SQL Development
  • MS SQL Server Integration Services (SSIS)
  • MS SQL Server Reporting Services (SSRS)
  • Tableau
  • Power BI
  • Operating Systems Windows 95/98/2000/NT/XP, MS- DOS, Microsoft Office 2010
  • Languages C, C, Core Java (SCJP certified)
  • Web Technologies HTML, JSP, Java Script, Joomla, Word Press

Tools:

  • TimExtender
  • Autosys
  • Exmon Administrator (Job Scheduling)
  • SQL Server Management Studio
  • Microsoft Visual Studio
  • Microsoft Visio
  • Team Foundation Server
  • Business Intelligent Development Studio
  • SQL Server Data tools

Personal Profile:

  • Father's Name: Ravi Kumar
  • DOB : 23 January 1988
  • Sex :Male
  • Marital Status : Married

Additional Information

  • Resolved product issue through consumer testing.
  • Supervised team of 9 staff members.
  • Received an Applause Award and Spot Award in Deloitte.
  • Received various awards for commitment to work in the previous organizations.

Timeline

Project Manager (Technical)

Cognizant India Pvt Ltd
08.2021 - Current

Technical Lead

Wellsfargo Through Euclid Innovations India Pvt Ltd
10.2020 - 07.2021

Azure Data Factory Developer

TJX COMPANIES INC, Microsoft
02.2019 - 09.2020

SQL Database Administrator

LIFESCAN, INC
12.2018 - 02.2019

DC Consultant

Deloitte Consulting India Pvt. Ltd
08.2017 - 09.2020

Tech Lead

Ecentric Solutions India Pvt Ltd
02.2017 - 08.2017

SQL SSRS Developer

02.2017 - 05.2017

Senior DBA

Napier Healthcare Solutions
01.2016 - 11.2016

SSRS & SQL Developer, SQL Developer

01.2016 - 11.2016

SENIOR SOFTWARE ENGINEER

Deloitte, Inc Through Technosoft Global Servies Pvt Ltd
10.2014 - 08.2015

SSRS Developer

10.2014 - 08.2015

SQL Developer

10.2014 - 08.2015

SOFTWARE ENGINEER

Tetrasoft India Private Ltd
08.2013 - 08.2014

IT-DATABASE REPORT WRITING ANALYST

Systems Private Ltd
01.2010 - 08.2013

SSRS & SQL Developer

01.2010 - 08.2013

BTECH - Computer Science and Engineering

JNTU, Intermediate

Class 12 -

Sri Aurobindo Junior College(Board of Intermediate

English Union School (CBSE)

Similar Profiles

CREATE PROFILE
Satish Kumar Gande