SACHIN R EKBOTE

Mobile: 945-***-**** ~ Email: adwjap@r.postjobfree.com

Seeking assignments in Software Development as Project Leader/Team Leader with leading organisations in the IT sector

SNAPSHOT

Dynamic, competent and result-oriented professional with over fifteen years’ experience in development and implementation.

Working with Atos Syntel Inc as Technical Engineer.

Adept in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex Information Systems Management.

Well versed with .Net Framework, ASP.Net MVC, Web/WCF services, Console, VB6, SQL server 2016, SSIS, Postman, Fiddler, SOAP, Internet Technologies, Scripting Languages and Third-Party Tools. etc and relevant experience in .Net is 8 years.

AZ-900(Azure Fundamentals) certification

AZ-204(Azure Developer) certification

In depth expertise in all aspects of the SDLC including requirement analysis, design, development, troubleshooting and debugging.

Proficient in grasping new technical concepts and utilizing them in an effective manner.

Successfully executed various projects.

Strong collaboration, team building, interpersonal, communication skills with proficiency at grasping new technical concepts quickly & utilizing the same in a productive manner.

AREAS OF EXPERTISE

Managerial

Involved in large-scale Project / Program Planning, Execution and Management, in tune with the core business objectives.

Implementation of project plans within pre-set budgets and deadlines.

Process vision and design, enhancement strategy and transition strategy

Managing resource allocations and setting up of communication channels across the various horizons of the organization structure.

Technical

Operating Systems : Windows (XP, 7, 10).

Programming Languages : ASP.Net, C#.Net, VB.Net, node js, Classic ASP, Angular js, MVC, VB6

Services : Windows, Web/WCF

RDBMS : SQL Server2008, SQL Server2008 (R2), MS-Access, Oracle 9i

Internet Technologies : HTML 4.0/5, CSS 2.0/3.0, Bootstrap, JQuery

Scripting Languages : Java Script, VB Script

Source Control : SVN, TFS, Azure GIT

Utilities : SSIS, RoboHelp office 9, Data Reports, Crystal Report, Chart Director

: HMI programming, Labelworks 2.0, Version 1, Squids

Functional

Project Management

Developing plans & schedules, resource allocations as per budgets, manpower deployment and team meetings for individual projects.

Interacting with customer as well as team for requirement gathering, risk assessment, finalisation of technical specifications.

Interacting with team members to ensure smooth progress of project work.

SDLC

Participating in design and coding of Software Applications.

Mapping requirements; participating in the finalization of product specifications and selection of techniques.

Conducting system study and coordinating with team members for System Design & Integration, Application Maintenance, etc.

Handling various technical aspects like software design, coding of modules, monitoring critical paths & taking appropriate actions.

Supervising smooth implementation of the project and extending post-implementation, application maintenance and technical support.

CAREER HIGHLIGHTS

Current Employer

Atos Syntel Inc

Technical Engineer

Title : HealthPlan (DC-SSIS) Migration of current process into SSIS

Client : BSWH, USA

Role : working at onshore as Technical Engineer that includes Analysis, design and

Development, work, web service calls in SSIS, optimise Stored Procedures, existing queries understand current process in DC, qa/production deployment, create sql jobs

Platform : SSIS, C#, SQL Server, web services, DataConnect Tool, console application

Key Role: Analyse DC process, understand the existing logic and implement in SSIS, file operations using C#, Read, process and upload xml files, CRUD operations, web service calls, unit testing, convert inline queries to stored procedures, optimisation of existing stored procedures, Documentation, demo to the operational team, deployment to qa/production, sql jobs etc

Title : RFA (Request For Access) web based application for requesting access

Client : Humana, USA

Role : Analysis, Programming and Test/Qa deployment using pipeline, Sonar qube fixes,

Drive Production turns, Requests through SNOW

Platform : Asp.Net MVC using C#, Angular js, SSIS and SQL Server, design patterns

Key Role: Analysis and development of various assignments like form builder, criteria builder, Individual forms, Creates ART(s) for sending to EIPM-SNOW etc. Unit testing, Documentation, Test cases and deployment

Title : PIMS (Provider Information Management System) WCF service for provider

Client : Humana, USA

Role : Analysis, Programming and support

Platform : C# .Net, WCF, Windows, ASP Dot Net 4.0, SQL Server, SSIS, console application

Key Role: applied security fixes, Unit testing, Code Review from offshore and onsite, SSIS migration (VS 2008-2017), Modification and development of SSIS packages, polly implementation, Vault token, virtual offices stories for new provider, address change case, Refactor stored procedures

Title : CCP/GCP application (VB6/classic asp based portal)

Client : Humana, USA

Role : Analysis and Programming

Platform : C# .Net, WCF, VB6.0, Classic asp, WPF, ASP Dot Net 4.0, DB2

Key Role: Analysis of asp pages. App Scan Defects (XSS, XFS, and SQL Injection). Unit testing, Documentation, Test cases and deployment. SIT, UAT and Regression Testing of an application. Code changes etc.

12-Dec-2016 to 30-Jun-2017

vRythms Software Pvt. Ltd.

Sr. Software Developer

Key Role: Worked on USA job posting sites (NPPA, MDSearch) in Healthcare domain. Completed given assignments that includes UI based changes (CSS, JS, HTML), making corrections in the bulk job upload xml files, upload xml, pdf, csv files, add images, video url, manage jobs and functionality related issues etc.

Worked on web base application. Completed given tasks, done API documentation using swagger documentation Tool.

05-NOV-2004 to 21-JAN-2016

ez consultants

Sr. Software Developer

Key Role: Developing projects by Interfacing with Analog and Digital devices viz. Barcode Scanners, Barcode Printers, various marking (Engraving) machines, Digital gauging instruments, Weighing machines, Temperature Controller, Vibration Analyser, TESA, Server communication, PLC, Excel Automation, Read/Write XML files, Protocols such as TCP-IP, UDP, FTP and Modbus and customised protocols and Add-on cards like Advantech, National Instruments and Moxa card (N-Port Serial Card).

Various types of almost 400 projects have been implemented and running successfully all over India by me or under my leadership.

Web Applications using ASP and C#.NET

Title : Machine Breakdown History and Analysis Software

Client : KOEL

Role : Analysis, Design, Programming

Platform : ASP Dot Net 4.0, MS-SQL Server 2005, Windows XP, Chart Director

Duration & TS : 3 Months & 3 Members

Highlights This software keeps breakdown details of all machines on various lines at the shop floor. Software allows user to enter breakdown details like on which line the breakdown occurred, the machine, the production manager concerned, Breakdown fault type, Fault description, Breakdown date, time, status, Breakdown acknowledged by, man power details and Spare details etc.

Software has facility to show Planned Maintenance Activity (Report) by allowing user to enter the planned maintenance activity details viz. on which machine maximum breakdown occurred, the production manager concerned, Breakdown problem type, Reason for planned maintenance, Activity planned and Work done date, status, Details of activity planned, Details of action taken, Component replace details, Line manager and Unit manager acknowledged by etc

Based on the data various graphs (Uptime, Frequency, MTBF, MTTR) and line/machine wise customized reports along with export to excel facility shown to user.

Title : Truck Transport Billing Software

Client : Punya Transport Corporation, Banswara

Role : Analysis, Design, Programming

Platform : ASP Dot Net 4.0, MS-SQL Server 2005, Windows XP

Duration & TS : 4 Months & 3 Members

Highlights This software is designed to keep all log of truck transport for single / multi location. Various master entries like company, client, consignee, consignor, source, destination, material and driver are made.

Prepare GR entries for final destination, per destination for particular truck trip.

Prepare challan entries by grouping GR nos. Invoice generation of grouped challans.

Maintain Truck Log book, payment updates. Maintain Truck servicing, Fitness, major parts keeping details and various reports etc.

Title : Reporting Tool software

Client : Ordnance Factory (Khamaria), HV Commercial (MP)

Role : Analysis, Design, Programming

Platform : ASP Dot Net 4.0, MS-SQL Server 2008, Windows XP, Chart Director

Duration & TS : 3.5 Months & 3 Members

Highlights Customised Reporting Tool software is developed as per requirement. Data from two individual stations is stored in SQL Server 2008 database. The two individual databases generated for each station. Provision made in the software to select any database for viewing Reports and Graphs.

Data is retrieved based on (Part, Parameter, Operator, Event, Batch, Shift and Date/Time). Reports like Parameter, Consolidated, Summary and Event are generated. Various SPC graphs (Average, Sigma, Histogram, XMR and Pie)and parameters(Cp, Cpk, Pp, Ppk, Sigma) shown. Also a special report generated against a query string passed from client station.

Windows Applications using VB.Net

Title : Crank shaft (2 to 6 Cylinder) Measuring System and SPC Analysis

Client : MSIL, BFL, MFL and AIWL

Role : Designing, Programming and Implementation.

Platform : VB.NET, SQL Server 2008, Windows XP

Duration & TS : 8 Months & 3 Members

Highlights The software is designed to measure the selectable parameters like outer diameters, Taper, Ovality, circularity and Spheriocity on three(selectable) locations at selectable (x, y) positions for various crankshaft parameters viz. Pin, Journal Damper, GEOS, FEOS, FEGM, and GM according to the location settings. Showings run charts and event entry for each parameter. Calculates average and grades as per the formulae given. After completing measurement cycle Inspection Report is generated and auto save in excel format at predefined settable path and sending whole data to marking machine and updated job status in SAP table.

Measurement procedure performed using Manual, Auto dumping and using sensors.

Various SPC graphs, Process Capability, Attribute charts, normality test, Scatter plot and customized reports are generated as per requirement.

Title : Piston Measurement and SPC Analysis

Client : SPL, IPL, MPL

Role : Programming and Implementation.

Platform : VB.net, MS-Access, Windows XP

Duration & TS : 8 Months & 3 Members

Highlights Main objects in the software are 1)Gauging 2)Weighing 3)Marking 4)PLC communication 5) Temperature Monitoring. The software is designed to interface with Mechanical fixtures Using Add-on cards (Advantech 1711) and measure the various parameters like ID, OD, Height, Thickness using normal, Reference and Relative measurement. Selectable Marking (selectable data) and weighing options Software interface with PLC and Temperature Sensor using Modbus (serial protocol)

Various SPC graphs and customized reports are generated as per requirement.

Title : Cylinder Bore Measurement using Thin Client-Server Architecture

Client : MSIL

Role : R&D, Designing, Programming

Platform : Visual Basic Dot Net, Oracle 9i, Windows Server 2003

Duration & TS : 8 Months & 4 Members

Highlights Key functions of the software are 1) Thin Client PC located on the shop floor 2) Application Server having Windows Server 2003 3) Database Server for data storage. The software is installed in the application server. By using MS RDP (Remote Desktop Protocol) created users for each client PC.

Operator at the shop floor measures respective cylinder bores by interfacing with digital gauging instruments. Software acquires digital data and stored in the database which resides on database server. Simultaneously Software displays online charts and calculates SPC parameters on the screen. Software also checks the violation regarding statistical alarms and SPC rules. If violated then displays error messages to the operator.

A Reporting tool is developed to view all parameter wise and MIS reports and SPC graphs to the authorised person in the plant/shops/stations.

Windows Applications using VB 6.0

Title : Bullet Cup Measurement System and SPC Analysis

Client : Ordnance Factory

Platform : Visual Basic 6.0, MS-Access, Windows XP

Role : Designing, Programming and Implementation

Duration & TS : 2 Months & 2 Members

Highlights The software is designed to interface with Mechanical fixtures Using Add-on cards (Advantech 1711)and measure the various parameters like Dome Thickness, Wall Thickness and External Diameter of the 5.56 GM bullet cups and the analysis is done according to SPC theory by providing various spc charts and customizing reports.

Title : Electrics motor plate marking software

Client : LHPL

Role : Designing, Programming

Platform : Visual Basic 6.0, MS-Access, Windows XP

Duration & TS : 2 Months & 2 Members

Highlights The software is interfaced with marking machine using MK-100 serial communication protocol. Auto generates serial no according to product code. Reads data from FoxPro file or excel sheet located on server. Providing marking data to the marking machine, marked on the motor plates. Customized reports are generated as per requirement.

Title : Shim Selection and Shim Verification Software

Client : TML, MFL, JCB, CIL, NHA

Role : Designing

Platform : Visual Basic 6.0, MS-Access, Windows XP

Duration & TS : 2 Months & 2 Members

Highlights This software calculates component shim by using settable formula (combination of various parameter readings).derive shim no. depending on the shim tolerances and sends respective shim signal to PLC. The Operator takes a shim from the stack and verifies the same. If shim reading matches with the calculated shim then this shim is fitted with the component else operator tales other shim and verifies. This process continues until shim verification is completing.

Software communicates with PLC using MODBUS protocol and acquires data by using add-on card. Various graphs and customized reports are generated as per requirement.

Other projects

Profile Plot software

Bhushan Steel(Khopoli,ACG(Mumbai)

Brake disc measurement with Fourier and SPC analysis.

MKL, Delhi

Cylinder Block measurement

JDEPL, Pune

Nut-Runner/Liner pressing parameters Display software

Craftsman Automation, Chennai

Marking software having MES server connectivity

TML, Sanand

Shaft checking (Auto gauging)

PCL, Solapur

Piston Measurement (Auto gauging)

FML, Bangalore

Crank Case Measurement

KOEL, Pune

Commenced career with Indian Engineers from Dec’03 – Oct’04 as Trainee Engineer

EDUCATION

Bachelor of Engineering (Electronics & Telecommunication)

Gangamai College of Engineering, Dhule, North Maharashtra University in 2003 (Secured 63.28%)

Diploma in Electronics & Radio Engineering (DERE)

Cusrow Wadia Institute of Technology, Autonomous (Semi – Govt) in 2000 (Secured 74%)

PERSONAL VITAE

Date of Birth : 1st December, 1979

H1B Visa : 30-SEP-2023

Permanent Address : Mission Gate Apts. 8024 Ohio Dr Apt 5312 TX-75024

Contact this candidate