Post Job Free

Resume

Sign in

C# Sql Server

Location:
Houston, TX, 77299
Posted:
September 14, 2023

Contact this candidate

Resume:

Objective:

To utilize my knowledge, skills & ability towards growth of an organization that provides ample opportunity to learn and to contribute.

Profile Summary:

Have 10 Years of Experience in Software Industry as Software Programmer in RPA (Robotics Protect Automation) - UI Path, Blue Prism, C#, ASP Dot net, SQL Server, Web Services, WCF, WPF technology.

RPA UI path and Blue Prism Certified and Working knowledge of both tools.

Experience in creating database objects including creating Database Tables, Constraints, Procedures, Functions, Triggers, Indexes, Views scripts.

Conversant with coding, designing architecture, testing at programming level, documentation, and implementation.

Presently working in Atos India Pvt. Ltd. Pune

Sound knowledge of SDLC (Software Development Life Cycle).

Fast Learning & Problem-solving attitude.

Highly committed individual.

Self-motivated and an excellent team player.

Devram Prafull Ravindra

Mobile No: +91-976*******

Email ID: adzpfp@r.postjobfree.com

Computer Skills:

Operating Systems:

Windows 2000/XP/windows10, windows7, UNIX

Tools/Applications:

Ui Path, blue Prism, Automation anywhere, MS Visio, MS Office, Excel Macros,

Front End:

C#, .Net, VB, ASP. Web services, WPF, WCF, AJAX, Automation Robotic tools IDE

Back End:

SQL Server 2005/2008, MY SQL, MS Access

Other:

C, C++, VB 6.0, HTML

Reports:

Crystal Report / Microsoft Reports

Platform:

Visual Studio 2005 / 2008 / 2010

Employment History:

Company (Current): Birlasoft Pvt. Ltd. Pune

Designation: Architect and Team Lead

Duration: Oct 2022 – Present

Location: Pune (Hinjewadi), India.

Company (Previous): EInfochips Pvt. Ltd. Pune

Designation: Team Lead

Duration: Apr 2022 – 12 Aug 2022

Location: Pune (Magarpatta)

Company: Atos India Pvt. Ltd. Pune

Designation: Team Lead

Duration: Jun 2015 – Apr 2022

Location: Pune (Hinjewadi)

Company: Cyber Technology and Software Ltd.

Designation: Sr. Software Engg.

Duration: Jun 2014 – Mar 2015

Location: Mumbai (Wagale Estate)

Company: Mobien Technology Pvt. Ltd.

Designation: Sr. Software Engg.

Duration : Sep, 2012 – Jan 2014

Location : Pune (Shivaji Nagar, Pune)

Company: Sela Technology Pvt. Ltd.

Designation: Software Developer

Duration: Sep 2011 – May,2012

Location: Pune (Commor Zone IT Park Yerwada, Pune)

Company: Aarohiinfo Technologies Pvt Ltd (ATPL)

Designation: Software Engineer

Duration: Jun 2010 – Sep 2011

Location: Pune (Wakad, Pune)

PROJECTS

BSWH- PACCAR

Client: BSWH- Baylor Scott & White Health

Duration: July 2020 – Date

Role: Architect and Sr. developer

Team Size: 3

Description: PacLease plans to automate its AP process using their existing UiPath Platform for invoices received in the US region. Birla Soft have identified 22 vendors in scope of the current automation. These vendors cover 85% of the annual invoice volumes.

Responsibilities: Was responsible for requirement Analysis, Design database as per process dispatcher, development of workflows, code review and deployment on production server.

Testing: Unit testing, SIT, UAT done for the required changes in various Modules.

Environnent : UI Path RE Framework, SQL Server, Client machine

BSWH- Baylor Scott & White Health

Client: BSWH- Baylor Scott & White Health

Duration: July 2020 – Date

Role: Architect and Sr. developer

Team Size: 3

Description: BSWH activity is performed by 5 persons daily and total time spent is approx. 8 hrs. This includes monitoring of following six activities:

HR Activities and monitoring – MSS and Onboarding

NOA Process – Notice of Admission in hospital process

Manage Database for Dispatcher (Candidate insertion and manage hires)

Monitor processes and update database once process completed successfully

Communication with business

Responsibilities: Was responsible for requirement Analysis, Design database as per process dispatcher, development of workflows, code review and deployment on production server.

Testing: Unit testing, SIT, UAT done for the required changes in various Modules.

Environnent : UI path RE Framework, SQL Server, Client machine

BMW Cofis Night Monitoring (Australia, JP and NZ Operation)

Client: BMW

Duration: Mar 2017 – Jun 2020

Role: Architect and developer

Team Size: 3

Description: AU Night monitoring activity is performed by 1 person daily and total time spent is approx. 5 hrs. This include monitoring of following six activities:

Sanity Check – Batch Jobs

Sanity Check – Web Sites

Sanity Check - CFS DB Site

Sanity Check – CFS App Server Side

Communication with market

ITSM ticket will be raised in case of any failure

Responsibilities: Was responsible for requirement Analysis, Design, development of workflows, code review and deployment on production server.

Testing: Unit testing, SIT, UAT done for the required changes in various Modules.

Environnent : UI path RE Frame

work, Client machine, C# Dot net for create custom activities

CEE Admin Controlling (Central Eastern Europe)

Client : CEE

Duration : Sep, 2016 – Feb 2017

Role: Team Lead

Team Size: 4

Description: This RPA project is related to Excel and Web Automation. The main purpose of the project is to avoid human intervention for repetitive work like Excel reports and SDM portal Daily monitoring process.

Responsibilities: I was handling the team of 8 people and communicate with the customers for requirements and related stuffs. I am responsible for requirement Analysis, Design, development of workflows, code review and deployment on production server.

Testing: Unit testing done for the required changes in various Modules.

Environnent : Ui Path RE Framework, WEB Portal (SDM), Excel Automation, Dot net environnement for create custom activities

NLAM (Netherland Ministry)

Client: NLAM

Duration: Apr 2016 – Aug 2016

Role: Team Lead

Team Size: 4

Description: This project is related to Automate the SAP processes having citrix remote login. The major purpose of the project is to avoid human intervention for repetitive work like Daily monitoring process of the SAP application.

Responsibilities: Was responsible for requirement Analysis, Design, development of workflows, code review and deployment on production server.

Testing: Unit testing done for the required changes in various Modules.

Environnent : UI path, SAP using citrix

Renault (France)

Client : Renault

Duration : Jun, 2015 – Mar 2016

Role: Team Lead

Team Size: 5

Description: This project is related to estimation tool. basically, Renault user are used this tool for the make actual price of the Renault vehicles

The major purpose of the project is to help executive in strategic decision making for the costing of vehicle. The dashboard will contain thematic map and various charts to make the visualization more interpretive and easier to understand.by Using UI path tool we have created some reports and send it to respective stake holders.

Responsibilities: Was responsible for requirement Analysis, Design, development of workflows, code review and deployment on production server.

Testing: Testing of UI Path RE Framework and code review.

Environment: Ui Path RE Framework using SAP application

RJIL (Reliance)

Client: Reliance

Duration: Jun 2014 – Mar 2015

Role: Sr. Developer

Team Size: 6

Description: The Objective of this project is to develop a dashboard to track the Progress status of differ Reliance Network Indicators like eNode B sites, Commissioning of fiber Network, FTTx etc

The major purpose of the project is to help executive in strategic decision making. The dashboard will contain thematic map and various charts to make the visualization more interpretive and easier to understand

Responsibilities: Was responsible for development of Analysis, Design and code development,

Coded various New as well as old SQL SPs and compact Edition (query) code for modules.

Testing: Unit testing done for the required changes in various Modules.

Environnent : C#, ASP, .Net 4.0, web service, Dojo

NDDB (National Dairy Development Board) Govt. of India

Client : NDDB Gujarat

Duration : Oct, 2012 – Dec. 2013

Role: Sr. Developer

Team Size: 5

Description: Information Network for Animal Productivity and Health (INAPH) is a client-server application software package. It has been developed by NDDB to provide a live demonstration of the use of information and telecom technology tools to increase production and productivity of dairy animals in the country. The INAPH software application has the following components:

a.Admin Application –Windows application featuring complete Administrative functions such as creation of service provider organization, role-based users and allocation of villages.

b.Desktop Main Application – On-line Windows application featuring the complete functionality both for data collection and operational reporting. Client requires internet connection with central server.

c.Laboratory Application – On-line Windows application featuring the complete functionality of Feed Sample Analysis, Milk component Analysis and Pathology Analysis.

d.PDA Application – Off-line Device application having a subset of the overall functionality primarily for field data collection and field reporting requirements.

e.Analytical Reporting –Web application with data warehousing for generation of reports. The Analytical Reports can be viewed using Web Browsers (Internet Explorer, etc.).

f.SMS Application –Windows service application residing on Web server for generating multi-lingual text message with registered mobile numbers of dairy farmers from transaction database.

Responsibilities: Was responsible for development of Analysis, Design and code development, Did various MSSQL

reports, Coded various

New as well as old SQL SPs and compact Edition (query) code for modules.

Testing: Unit testing done for the required changes in various Modules.

Environment: C#, ASP, .Net 3.5, WPF, SQL server and SQL Server compact Edition, Ajax

Scheduled Email Report

Client: EPRS

Duration: May 2012 to Aug,2012

Role: Sr. Developer

Team Size: 3

Description: This is web base project developed for getting daily reports of all vendors with all daily status automatically. I have developed one-win service to send daily report through email to the management team and sales team. This project is handling the daily scheduled report for invoice, retailer information, and Distributer information basket wise with validations.

Process Scheduled Report.

Get Details from Scheduler table.

Get Report data from executing sp.

Send email after creating attachment from csv file at runtime.

Update Scheduler after sending email.

Perform validations during all tasks.

Responsibilities: Was responsible for development of various MySQL reports for cross-comparison with the various

Reports produced by various other systems for validating the data integrity.

Did Analysis, Design and code development, Review, Performance tuning and query optimization

Using MySQL on Windows7 under cloud environment.

Analysis: Study all the concepts of cloud technologies.

Design: Prepare for design flow and design all forms (UI design) Into WPF

Development: Coded various Program modules which modules are mention above as well.

Testing: Unit testing done for the required changes in various Modules.

Environment: C#, ASP, .Net 3.5, Win Service, WPF service, WPF, MySQL, Ajax

SES Library using Amazon cloud

Client: EPRS

Duration: Jan 2011 to Apr 2011.

Role: Sr. Developer

Team Size: 2

Description: This is web-based project developed for Sending the email. By using this project user can send single email or more than emails with or without attachment.SES means Simple Email Service which is provided by Amazon for sending attachment email it requires file path to attach so I am using the s3 bucket and make URL for each email.

Process Scheduled Report.

Get Details from Scheduler table.

Get Report data from executing sp.

Upload data on s3.

Send email after creating attachment from s3 file at runtime.

Update Scheduler after sending email

Responsibilities: Was responsible for development of various MySQL reports for cross-comparison with the various

Reports produced by various other systems for validating the data integrity. Did Analysis, Design and

code development, Review, Performance tuning and query optimization using MySQL on Windows7

Under cloud environment.

Analysis: Study all the concepts of cloud technologies.

Design: Preparation of Technical Design Reports.

Development: Coded various new as well as old MySQL Program modules.

Testing: Unit testing done for the required changes in various Modules.

Environment: C#, ASP, WCF Service, .Net 3.5, MySQL

Vodafone Kerala

Client: Vodafone

Duration: Nov 2011 to Dec 2011.

Role: Sr. Developer

Team Size: 2

Description: This is web-based project developed for Vodafone Kerala. By using this project user can send single SMS and bulk SMS. Operator can map mobile numbers with group. And Authorized mobile no. with Sender ID. User sends SMS in particular format to 57575### after that our application get all parameters validate it and send to recipients.

Login

Change Password

Send SMS

Insert facility to Sender ID

Insert facility to mobile number

Insert facility to Group name

Mapping facility to Sender ID

Mapping facility to Sender ID

Responsibilities: Was responsible for development of various PL/SQL reports for cross-comparison with the various

Reports produced by various other systems for validating the data integrity. Did Analysis, Design and

code development, Review, Performance tuning and query optimization using SQL,

PL/SQL on Windows NT environment.

Analysis: Preparation on web services and WPF Design.

Development: Coded various new as well as old application modules.

Testing: Unit testing done for the required changes in various Modules.

Environment: C#, ASP, .Net 3.5, WPF, Web Services, SQL Server, Ajax

HSBC SMS survey

Client: HSBC Bank

Duration: Aug 2011 – Oct 2011

Team Size: 3

Description: This is web-based project developed for HSBC for send SMS to customer after completing the communication between customer and Tele caller and get response in particular by the customer in format e.g. Yes or No.

Login

Change Password

Send SMS (Push SMS)

Receive SMS (Pull SMS)

Role: Developer

Responsibilities: Extensively created database procedures, functions and triggers using PL/SQL.

Written complex stored procedures and triggers and optimized for maximum performance.

Environnent : C#, ASP, .Net 3.5, SQL Server, Ajax

Ordnance Depot

Client : Ordnance Depot Talegaon Dabhade (Pune)

Duration : Mar, 2011 – July. 2011

Team Size: 3

Description: This is semi ERP software. This project is responsible to manage manufacturing

Company & courier management for medical company.

This software is interacting with CRM Module, Visual aids Different modules have developed:

Login

Master

Inventory management

History of AMC.

Patient Management.

Different forms of AMC.

Reports

Reporting: It contains crystal reports for all modules.

Role: Developer

Responsibilities: Extensively created database procedures, functions and triggers using PL/SQL.

Written complex stored procedures and triggers and optimized for maximum performance.

Environnent : C#, ASP,.Net 3.5, SQL Server, Ajax

Website

Client: www.arkeysons.com

Duration: Jan 2011 – Feb 2011

Team Size: 2

Description:

I have worked in www.arkeysons.com website based on Military Apparatus. We are providing a good look of this website. This website includes all information related with military apparatus like Bullet Proof Jackets, Helmet, Bullet Proof Suit, Disrupters, etc.

Reporting: It contains crystal reports for all modules.

Role: Jr. Team Member

Responsibilities: All Phases of SDLC (requirement analysis, design, coding, unit testing, Deployment).

Created Stored Procedures for data transformation purpose.

Testing: Unit testing, Integration Testing and System testing of PL/SQL Procedures.

Environnent : C#, ASP, .Net 3.5, SQL Server, Ajax

Oxygen

Client: Oxygen Health Care PVT Ltd

Duration: Jun 2010 – Nov 2010

Team Size: 4

Description: This is semi ERP software. This project is responsible to manage manufacturing Company & courier

Management for medical company. This software is interacting with CRM Module, Visual aids Different

modules have developed:

Login

Master

Inventory Management

Purchase

Sales

Courier Management

Reports

Reporting: It contains crystal reports for all modules.

Role: Jr. Team Member

Responsibilities: All Phases of SDLC (requirement analysis, design, coding, unit testing, Deployment). Created Stored

Procedures for data transformation purpose. Worked on database connections, SQL joins, views,

Coordinate with testers and helped in the process of Integration testing.

Environnent : C#, ASP, .Net 3.5, SQL Server, Ajax

Personal Information:

D.O.B:

02nd May 1986

PAN #:

APFPD8344C

Passport #:

k6773512

Contact Address:

1st floor Matoshree Building, Karmabhoomi nagar, Lohegaon, Pune

Permanent Address:

At post: Sirsaw Taluka: Paranda District: Osmanabad, MH, India.

Languages:

English, Hindi, Marathi

Strength:

Hard Worker, Optimistic Attitude, Adaptable and Passionate to acquire knowledge.

Date: - - 201 Signature of Candidate



Contact this candidate