Summary
Overview
Work History
Education
Skills
Certification
Additional Information
Accomplishments
Software
Interests
Timeline
Generic

Mahesh Gopane

Technical Architect
Pune

Summary

Over 11+ years of extensive work experience as a SQL Server Developer and in-depth proficient experience in Microsoft Business Intelligence stack, OLTP, Operational Data Source (ODS), Tabular & Multidimensional Modelling, Performance Tuning, Data warehouse, OLAP and Database technologies. Demonstrated expertise in designing, developing, and deploying Business Intelligence solutions using SSIS and SQL. Experience in installation, upgrade, and configuration of Microsoft SQL Server databases. Over 7+ years of extensive experience in T-SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server 2012/2014/2016/2017. Broad experience in Query Optimization and performance tuning of TSQL stored procedures, functions, SSIS packages. Over 6+ years’ experience in utilizing ETL tools, including SSIS, DTS and ETL Package design. Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages through scheduler such as Autosys and SQL Server Agent. Experience in development of coding in VB.NET, C# while working with SSIS. Interaction with the Users and Business Analysts for better understanding of business & reporting requirements.

Overview

20
20
years of professional experience
8
8
years of post-secondary education
1
1
Certification
1
1
Language

Work History

Technical Architect

Hexaware Technologies Pvt Ltd
Pune
04.2020 - Current
  • ITRDB: - ITRDB is a data warehousing project, must extract and upload various data sources like SQL DB, Oracle DB, Excel files and .csv files
  • Mostly this project developed in SSIS, SQL and PowerShell Scripting
  • Chargeback: - Chargeback project is invoice processing tool which developed in Access database as user interface with VBA and SQL database in backend
  • SirionLab: - SirionLab is a new project and implemented 10 user stories and deployed in production, this project is about file transfer from shared location to SFTP server
  • Used technologies are PowerShell Scripting and WINSCP tool
  • Byte: - Byte project is fetching data from a mercury site on hourly basis stored in a production with date stamp and trigger the SSIS package to process that file and load to the SQL database
  • (Decommissioned in Jun 2021)

Sr. Analyst

Deutsche Bank Group
Pune
01.2003 - 10.2019
  • MRO Project: - It was the manual data upload process based on Excel VBA and it was time taking process, after implementation of MRO project load process in SSIS it reduced the data upload process and accuracy level of data also it is file watcher job (Event base trigger)
  • If file is available at specific folder the SSIS job trigger for load file to database
  • MRPOC Project: - Automated the audit process and upload data in SQL Database with batch processing and SSIS to create a reporting template
  • EC Distribution Tool: - The Estimated capital distribution process was very critical and manual, due to manual work increase the chances of manual errors
  • With the EC-DT (EC Distribution Tool) which reduced the human intervention and increased the accuracy level as well as reduced the effort time from 3 days to 15 min.

Sr. Technical Associate

Sage IT Pvt, Hexaware Ltd
Pune
06.2019 - 10.2019
  • Integrity: - Automated consolidation of bank statements of various Vendors payment from web portal and upload the downloaded statements in respective integrity database with SSIS and sending payment confirmation to banks and vendors
  • MoM Tool: - Every team member needs to report their weekly activity task to his/her line manager
  • It was a manual email process which taking 3-4 hours to consolidate and report to Manager for this problem statement
  • MOM is an automated tool which capture respective associate activities on daily basis and report in proper manner and it reduce the error level.

Sr. Technical Associate

Sears IT & Management Pvt
Pune
04.2018 - 01.2019
  • Stack Ranking: - Automated Data Consolidation, Data modeling and Data load in respective SQL Database with SSIS solutions while loading data in database need to calculate Stack Ranking based on weighted parameters and prepare outlier report from comparison between current and last 2-months stack ranking outliers report
  • Graph Update Utility: - Update and refresh all or selected graphs from reporting templates
  • Best Practices Utility: - Every report needs to follow redefined rules of data format and structure before publishing report to higher management that we handled with VBA based tool
  • Contact Index: - Client required every week status report of supplier base order and enquiry
  • We need to integrate 3 database data in one database with SSIS we integrated required information from 3 different sources to one database and created Contact Index view report.

VBA Developer

US Tech Solution Pvt. Ltd
Pune
07.2017 - 03.2018
  • Parts CPI Report: - This was the daily published report, while preparing manually it takes 3 hours, after automation it takes 5 min Used technology is VBA
  • Daily Work Allocation (Queue Management Tool): - Every day TL needs to assign work for a day to all associates manually and he was spending 2-3 hours per day with Daily Work Allocation tool he needs to click few buttons from tool work allocation get completed
  • VBA utilities with Personal workbook: - Created VBA utilities which reduce manual work like,
  • Table Format with Repotting formats of values and Text, Extend Chart Data, Sort Data in a Repotting Format, Insert Multiple Columns in one click and Insert Multiple Rows in one click
  • Profit Plan calculate tool: - Automated process of Data Consolidation, upload consolidated data in SQL database
  • The relational database should update while make changes in Master PP file.

VBA Developer

Nityo InfoTech Pvt. Ltd
Pune
01.2017 - 06.2017
  • Aggregator Project: - Automated Data Consolidation, Transformation and Load in SQL SERVER with the help of VBA and SSIS solution
  • Validation for loaded data and send Statistical report to Management on every Friday
  • (About Project – 75+ Project Managers must update their Projects Status to higher Level Management on every Friday
  • All project Managers store their GPSR File (Global PSR Status Report) at SharePoint before end of the last working day of each week
  • The Aggregator Automation tool will run on Friday night with help of Windows Scheduler and consolidate all GPSR files data in one file that is Aggregator.xls file and the created xls file load it to SQL database with SSIS Package and Send all Statistical report to Management.) (Project Estimated Time was 6 months but completed in 2 Months).

Executive

Atos India Pvt. Ltd
Mumbai
02.2016 - 07.2016
  • Located bottlenecks to streamline existing processes.
  • Introduced new methods, practices, and systems to reduce turnaround time.
  • Collaborated with back-office team members to facilitate seamless business execution.

Process Executive

TCS Pvt. Ltd
Pune
05.2013 - 02.2016
  • Led methodology development to outline basic process parameters for operations.
  • Employed data modeling technologies to simulate business process alterations, ascertaining maximum ROI with minimal associated risk.
  • Coordinated multi-team process initialization, reducing associated redundancies and dependencies.
  • Maintained primary relationship accountability for clients, overall servicing responsibility and client satisfaction to maximize profitability of client relationships.

Customer care Executive

EXL Services Pvt. Ltd
Pune
05.2012 - 05.2013
  • Strengthened customer relationships by listening to customer concerns and giving priority to service requirements.
  • Collected customer information and analyzed customer needs to recommend potential products or services.
  • Developed and implemented customer care policies, procedures and regulations necessary to satisfy customer base.
  • Resolved concerns with products or services to help with retention and drive sales.
  • Used industry expertise, customer service skills and analytical nature to resolve customer concerns and promote loyalty.

Customer Care Executive

Anand Rathi Shares & Stock Ltd
Hyderabad
05.2010 - 05.2012
  • Maintained professional demeanor by staying calm when addressing unhappy or angry customers.
  • Established team priorities, maintained schedules and monitored performance.
  • Planned, created, tested and deployed system life cycle methodology to produce high quality systems to meet and exceed customer expectations.
  • Successfully managed budgets and allocated resources to maximize productivity and profitability.
  • Opened and closed location and monitored shift changes to uphold successful operations strategies and maximize business success.

Education

SSC - Science Education

Latur State Board
Aurad Shahajani
07.2002 - 06.2003

HSC - Science Education

Maharashtra State Board
Aurad Shahajani
07.2003 - 11.2005

B. Com - Accounting And Business Management

SRTM University
Aurad Shahajani
07.2006 - 05.2009

PGMIB - International Business Management

Osmania University
Hyderabad
08.2009 - 05.2011

MCA - Computer Engineering Technology

Chandigarh University
Mohali
07.2022 - Current

Skills

SQL – 2014, 2016, 2017 & 2019undefined

Certification

Microsoft Certified Professional with around 12+ years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2012/14/16/17

Additional Information

  • Personal Information
  • PAN No: - AQTPG1087A
  • Passport No: -R1331419
  • Permanent Address: - Flat No. G-603, Goyal Garima Housing Society, Keshav Nagar Chinchwad – 411033.

Accomplishments


  • Collaborated with team of 5 in the development of ITRDB.
  • Supervised team of 5 staff members.

Software

SQL SERVER, SSIS, Data warehouse,VBA, AZURE ADF, Blob, ADLS Gen2 & Powershell

Interests

Playing cricket

Timeline

MCA - Computer Engineering Technology

Chandigarh University
07.2022 - Current

Technical Architect

Hexaware Technologies Pvt Ltd
04.2020 - Current

Sr. Technical Associate

Sage IT Pvt, Hexaware Ltd
06.2019 - 10.2019

Sr. Technical Associate

Sears IT & Management Pvt
04.2018 - 01.2019

VBA Developer

US Tech Solution Pvt. Ltd
07.2017 - 03.2018

VBA Developer

Nityo InfoTech Pvt. Ltd
01.2017 - 06.2017

Executive

Atos India Pvt. Ltd
02.2016 - 07.2016

Process Executive

TCS Pvt. Ltd
05.2013 - 02.2016

Customer care Executive

EXL Services Pvt. Ltd
05.2012 - 05.2013

Customer Care Executive

Anand Rathi Shares & Stock Ltd
05.2010 - 05.2012

PGMIB - International Business Management

Osmania University
08.2009 - 05.2011

B. Com - Accounting And Business Management

SRTM University
07.2006 - 05.2009

HSC - Science Education

Maharashtra State Board
07.2003 - 11.2005

Sr. Analyst

Deutsche Bank Group
01.2003 - 10.2019

SSC - Science Education

Latur State Board
07.2002 - 06.2003

Similar Profiles

CREATE PROFILE
Mahesh GopaneTechnical Architect