Software Engineer Sql Server

MANOJ WAGHMARE

Email: ********.*****@*****.***

Mobile: +1-615-***-****

Linked In: linkedin.com/in/manoj-waghmare-95215a9

EXPERIENCE SUMMARY

Over 20+ years of professional experience in SQL development, over 13+ years of experience in Business Intelligence development and over 5+ years of experience in Microsoft Azure and Python.

Extensive Experience in Azure Data Factory, Azure Function App, Azure Logic App, Azure Cosmos DB, Azure DevOps and Python

Extensive experience in developing applications using Visual Studio Code, GitHub, Postman, Docker, DBeaver and Microsoft Azure Storage Explorer, Power BI Desktop and Visual Studio 2022.

Extensive Experience in SQL Server, SSIS, SSRS, SSAS and Power BI

Experience in PySpark, Databricks

Possess H1-B Visa for United States valid up to Apr 2027.

EDUCATIONAL QUALIFICATION

Master in Computer Application (MCA), Amravati University, Maharashtra

Bachelor of Science (B.Sc.) in Computer Science, Amravati University, Maharashtra

CERTIFICATIONS

Microsoft Certified – Azure Fundamentals (AZ-900)

TRAININGS

Completed “Azure Data Engineer Associate” course on Udemy

Completed “Databricks Certified Data Engineer Associate” course on Udemy

Completed “Essentials of Microsoft Fabric” course on Udemy

Completed “Azure Developer Associate” course on Udemy

Completed “Certified Associate Python Programmer” course on Udemy

Completed “A Crash Course in PySpark” course on Udemy

Completed “Generative AI for Beginners” course on Udemy

Undergone Training on Amazon Web Services (AWS)

Undergone Training on Talend ETL tool

Undergone Training on MS SQL Server Reporting Services (SSRS)

Undergone Training on Enhancements in MS SQL Server 2012

Undergone Training on Performance Tuning in MS SQL Server 2012

Undergone Training on SSIS Performance Tuning

Undergone Training on Image Management

PROJECT EXPERIENCE

Synechron Inc, USA Mar 2018 to till date

Synechron Technologies Pvt. Ltd., Pune Aug 2011 to Mar 2018

1. Project: Back Office ETL (USA) Aug-2020 to till Date

Client: Asurion US

Role: Lead – Software/Subject Matter Expert (SME)

Description: Future State Framework: - It is a cloud-based application that provides an automated data solutions to reduce manual efforts, decrease time-to-market, and empower line-of-sight business users to own their data processes. This framework has been built to simplify data integration from Asurion vendors for both ETL developers and business end-users. It also contains Communication application which is designed to create and send reports and notifications within the ETL framework. It is a fast and stable business process system capable of scheduling automated processes and responding to external events (APIs).

Responsibilities played during this project:

Technical discussion with Solution Architect to gather information for development, enhancements & bug fixes.

Involved in all phases of the life cycle of the project including requirement gathering, design, development, unit testing and deployment.

Used Microsoft Azure Dev-Ops tool to track the work through a predefined workflow.

Attend Sprint planning and business meetings to understand the Business requirement for ETL projects.

As a Subject Matter Expert work and design ETL/Azure Solutions for all the projects in scope and prepare High Level Design documents.

Daily coordination with Asurion business, IT, Offshore Delivery leads, Development and SQA teams to keep track impediments, progress about the project delivery.

Developed Durable functions using Azure and Python to write stateful functions in a serverless compute environment.

Work with SQA team and other teams to support Integration Testing and provide SQA Signoff on time for project deliveries.

Work with Change, Release management, ETL Operations and SQL DBA team to review the RFC’s and request scheduling as per the project delivery timelines and client commitments.

Review Deployment artifacts and support deployments to Production for smooth project release.

Support production incidents and provide Interim Solutions, Hotfix, Root Cause, Action items and preventive actions to stop recurring production issues and minimize the customer impact.

Environment: MS Azure, Azure SQL Server, Durable Functions, Azure Functions, Azure Logic App, Azure Cosmos DB, Python, Power BI, Azure Dev-Ops, GitHub, Azure Databricks, PySpark

2. Project: ETL (USA) Jan-2013 to Aug-2020

Client: Asurion US

Role: Lead – Software/Subject Matter Expert (SME)

Description: Intelliset is a Web based application that provides a graphical user interface for filling Mobile Insurance Claims. Subscribers calls Asurion Call Center and provides the necessary information to CSR. The CSR files the insurance claim based on this information. The application is highly performance intensive and involves multiple business flows for each service provider (Verizon, AT&T, T-Mobile, Sprint PCS etc.). Some of the functionalities included in iCare are filling new claim, checking the claim status and resuming the existing open claims. iCare is integrated with various multiple third-party components/API’s to enhance the user experience and these include: Paypal for processing payments and EAS for address standardization. Exact Target is a third-party API to send out the email notifications to subscribers which includes Claim Approval, Shipped, Delivered and Post Claim Surveys. Intelliset also utilizes iCare claim processing engine, which is built on Microsoft .Net, TIBCO Technologies and is based on the SOA structure.

Responsibilities played during this project:

Work as ETL/SSIS Sr. System Analyst for the clients (Verizon, T-Mobile etc..) still in Legacy platform.

Attend Sprint 0’s and business meetings to understand the Business requirement for ETL projects.

As a Subject Matter Expert work and design ETL/SSIS Solutions for all the projects in scope.

Prepare High Level Design documents for ETL/SSIS.

Attend Sprint preplanning and planning meetings, Handover Design, review LOE’s, Design reviews and development handover to offshore ETL development and SQA teams for development, testing and implementation.

Daily coordination with Asurion business, IT, Offshore Delivery leads, Development and SQA teams to keep track impediments, progress about the project delivery.

Work with SQA team and other teams to support Integration Testing and provide SQA Signoff on time for project deliveries.

Review Deployment artifacts and support deployments to Production for smooth project release.

Work with Change, Release management, ETL Operations and SQL DBA team to review the RFC’s and request scheduling as per the project delivery timelines and client commitments.

Provide production support for all ETL/SSIS project launches and processes.

Support production incidents and provide Interim Solutions, Hotfix, Root Cause, Action items and preventive actions to stop recurring production issues and minimize the customer impact.

Environment: SQL Server 2012 / 2008, SSIS, T-SQL, ASP.Net, C#.Net

3. Project: Trinity May’12 to Dec’12

Client: Asurion, Japan

Role: Developer

Description: The Procurement team sets matrix for maximization of CSAT, optimization of inventory, cost cutting, and less AHT. Also, matrix forecast is one of the most important factors for highly accurate demand forecast. Matrix operations are 100% manual work from calculation to evaluation to register into applications. A risk of human error has become a critical problem as well as it has made it more difficult to correspond to expansion or improvement of business models such as tiered pricing. Volume of data has technically reached a limit almost to perform operations with Excel. User needs to wait for ten minutes to calculate an Excel sheet, five minutes to save an Excel file, and an Excel file often freezes during calculation.

Responsibilities:

Interacted with Business Analyst (BA), and gathered the requirements

Wrote T-SQL, stored procedures, functions, views, and triggers

Created MS SQL Server jobs

Designed and developed SSIS packages in SQL Server Integration Services (SSIS), and modified the existing SSIS packages

Designed and developed reports in SQL Server Reporting Services (SSRS)

Wrote unit test cases, and captured the evidences according to the unit test cases

Environment: MS SQL Server 2008, SSIS 2008, SSRS 2008, Business Intelligence Development Studio (BIDS) 2008, Team Foundation Server 2008

4. Project: Master Program Nov’11 to May’12

Client: Cover-All

Role: Developer

Description: The objective of this Master Execution Process is to manage the execution of the NextGenBI product from source system(s) to the cube through the use of metadata tables. This process will control the ETL load process in a logical manner as well as the execution layer to handle the order of events and parallel processing if necessary.

Responsibilities:

Interacted with client, and gathered the requirements

Designed and developed SSIS packages in SQL Server Integration Services (SSIS)

Tested SSIS packages

Environment: Business Intelligence Development Studio (BIDS) 2008, MS SQL Server 2008 R2, SSIS 2008

5. Project: Ironshore Support Nov’11 to May’12

Client: Ironshore

Role: Developer

Description: Cover-All's NextGen Business Intelligence Suite provided business users the ability to easily report, analyze, interrogate, and manipulate any aspect of your business performance, when you want, how you want, and where you want, irrespective of underlying systems or technology. The fact is that BI initiatives for an organization should be strategically aligned with the business problem. Starting with a blank sheet of paper will risk success of these initiatives very early on. These initiatives rush into delivery with only a limited understanding of the complexity of insurance data which places massive constraints on the extensibility of the solution.

Responsibilities:

Interacted with client, and gathered the requirements

Understood the existing SSIS packages

Modified the existing SSIS packages according to the requirement

Tested SSIS packages

Environment: Business Intelligence Development Studio (BIDS) 2008, MS SQL Server 2008 R2, SSIS 2008

6. Project: DTS to SSIS Migration Sep’11 to Nov’11

Client: Gainsco Insurance

Role: Developer

Description: This project is developed for a client, Gainsco Insurance. In this project, we have migrated DTS packages that were developed in SQL Server 2000 to SSIS 2008. Re-designed those DTS packages into SSIS packages and also used advance features of SSIS such as XML configuration setting, checkpoint, and logging in this project.

Responsibilities:

Interacted with client, and gathered the requirements

Understood the existing DTS packages

Developed SSIS packages in SQL Server Integration Services (SSIS)

Tested SSIS packages

Environment: Business Intelligence Development Studio (BIDS) 2008, MS SQL Server 2008, SSIS 2008, AS/400

PMAM IT Services Pvt. Ltd., Mumbai Sep’08 to Aug’11

1. Project: Global Surety Application Jan’10 to Aug’11

Client: HCC Insurance Holdings Inc. (HCC), Texas, USA

Role: Developer

Description: This project is developed for Surety Service Division of HCC Insurance Holdings Inc. (HCC), a leading international specialty insurance group. This company is providing quality surety service to construction, engineering, and development industries. This is fully integrated Surety management system. It is comprehensive, user friendly and a total solution for all types of surety bonds. It contains modules such as Bail, Non-Bail, Accounting, Claim, MIS and Utilities, Certificates, and Forms. Using this system, we can maintain the complete database of all the surety bonds in a well-organized manner.

Responsibilities:

Interacted with client, and gathered the requirements

Wrote T-SQL, stored procedures, triggers, views, and functions

Developed reports in SQL Server Reporting Services (SSRS)

Designed and developed GUI in VB.NET

Environment: .NET Framework 2.0, Visual Studio 2005, MS SQL Server 2008, SSRS 2008, Remoting, N-tier Architecture, Windows Service, Client/ Server Architecture, Team Foundation Server 2008

2. Project: Credit Insurance System Sep’08 to Dec’09

Client: HCC Insurance Holdings Inc. (HCC), Texas, USA

Description: This project is developed for Credit Insurance Division of HCC Insurance Holdings Inc. (HCC), a leading international specialty insurance group. This company is operating in the field of insolvency protection by providing credit insurance. Credit insurance provides cover to businesses against non-payment of debts owed to them by business customers for goods or services provided on credit terms. All the operations related to credit insurance are managed in this project.

Responsibilities:

Interacted with client, and gathered the requirements

Wrote T-SQL, stored procedures, triggers, views, and functions

Developed reports in SQL Server Reporting Services (SSRS)

Designed and developed GUI in VB.NET

Environment: .NET Framework 2.0, Visual Studio 2005, MS SQL Server 2008, SSRS 2008, Remoting, N-tier Architecture, Windows Service, Client/Server Architecture, Team Foundation Server 2008, SSIS

Doyen Info Solutions Pvt. Ltd., Mumbai Aug’06 to Sep’08

1. Project: Credit Card Billing and Collection CRM May’07 to Sep’08

Client: Barclays Bank

Description: The objective of this project is to create a Windows Application based on Predictive Dialer, which provides the functionality of automatic call distribution to call center agents based on call flow and its pace. Also it should have configured Interactive Voice Response (IVR) system, which should interact with customer during initial few minutes of call to help customer. It provides an efficient way to allow agents in the call center to view customer details, make calls, and appropriately update the outcome of the call. Also, maintain the recording of each call and related information in the database.

Responsibilities:

Developed the application single handedly

Developed upload utility to insert data from raw file to MS SQL Server database

Designed and developed GUI for inbound and outbound CRM

Built a system for automatic escalation to supervisor queue

Built a system for MIS Reports

Environment: Visual Studio 2005, .NET Framework 2.0, MS SQL Server 2005, SSRS, E-Pro Dialer

2. Project: XML Parser for Barclays Bank Aug’06 to Apr’07

Description: The objective of this project is to integrate 2-applications using socket programming by sending data in the form of XML messages. This project works as a mediator between Debt Manager and E-Pro Dialer; it receives the data from E-Pro dialer and sends it to Debt Manager Application in the form of XML messages and vice-versa. This project also includes uploading utility, which read data from fixed length text file and insert into SQL Server database and generates one text file for E-Pro dialer.

Responsibilities:

Developed the application single handed

Developed upload utility to insert data from raw file to SQL Server database

Built a system that reads data from E-Pro dialer, and send it to Debt Manager Application in XML format

Environment: Visual Studio 2005, .NET Framework 2.0, MS SQL Server 2000, Socket Programming, E-Pro Dialer

AB Soft Skills, Nagpur Aug’04 to Aug’06

1. Project: Management Information System Dec’04 to Aug’06

Client: Garware Polyester Ltd., Aurangabad

Description: The objective of this project is to inter link all department of Consumer Product Division of GPL. This project maintains all the information such as purchase order entry, production, packing, and dispatch. The project also includes thermal label printing with bar code as per the format of the customer. Also, three types of replication (snapshot, transactional, and merge) are used to transfer data from one server to another server for report generation.

Responsibilities:

Interacted with client, and gathered the requirements

Wrote T-SQL, stored procedures, triggers, views, and functions

Developed reports in Crystal Reports

Designed and developed GUI in Visual Basic 6.0

Environment: Visual Basic 6, MS SQL Server 2000, Crystal Reports 8.0, Replication

2. Project: Stock Verification using RFID Aug’04 to Nov’04

Client: Garware Polyester Ltd., Aurangabad

Description: The objective of this project is to verify the physical stock using RFDC DOS-based terminal. RFDC DOS-based terminal scans the barcode from the thermal label and update physical status flag of that roll in the corresponding table. RFDC DOS-based terminal is a portable device that is used to read the barcode and it is connected to the base station. The base station server program controls one or more base stations and communicate with the application programs (clients) can run on the same computer as the base station server or on other computers in the same network.

Responsibilities:

Interacted with client, and gathered the requirements

Wrote T-SQL, stored procedures, triggers, views, and functions

Developed reports in Crystal Reports

Designed and developed GUI in Visual Basic 6.0

Environment: Visual Basic 6.0, MS SQL Server 2000, Crystal Reports 8.0, Teklogix SDK 2.3

Contact this candidate