Sql Server Software Developer

Curriculum Vitae

Name: Rahul Randive

Experience summary

* ***** ** ******** ********** in Software Engineering. I have been involved in design and development in different application domain involving different technologies varying from Internet programming to traditional database application on Windows platform. Expertise with ASP.NET, VB.NET, C#, Java Script, HTML, Ajax SQL Server 2000, 2005, 2008, Crystal reports. I have actively participated in all phases of Software Development Life Cycle including analysis design, coding, testing, implementation, data migration, documentation (using Microsoft Office, PowerPoint, and Excel), maintenance and support.

Technical Skills

Operating Systems

Windows 2003 DOS

Windows 7

Languages

C#.net,vb.net

Windows programming

Microsoft Visual Studio 2005/2008(.net framework 1.1/2.0/3.5,4.0)

Tools

Microsoft Visual Studio 2005, Crystal Report 11 / 2008,SSRS,SSIS

RDBMS

SQL Server 2000/2005/2008

Scripting

JavaScript, HTML,ASP.NET & VB.NET,C# .net

Methodology

Object Oriented Programming

Work Experience(Present): 15/02/2016 – Till date, New Mumbai

Company Name: ASM Technologies Pvt Ltd (New Mumbai, Bangalore (India)).

Designation : Sr. Software Engineer.

Client : Reliance Info tech (India)

Project Details:

Application 1: REP: Reliance is the India’s largest manufacturer, with thousands of different Industries operating in India. Its core Industries includes Petroleum refining and retailing is the second link in Reliance's drive for growth and global leadership in the core energy and materials value chain. With state-of-the-art petrochemical plants, RIL has ensured that growth always remains on a fast-track. They are now one of the world’s leading producer of petrochemicals and continue to set global benchmarks.

Application 2: Reliance JIO: Provider of mobile telephony, broadband services, and digital services in India. It offers data and voice services with peripheral services like instant messaging, live TV, movies on demand, news, streaming music, and a digital payments platform. JIO owns spectrum in 800 MHz and 1,800 MHz bands in 10 and 6 circles, respectively, of the total 22 circles in the country, and also owns pan-India licensed 2,300 MHz spectrum.

Responsibilities:

REP application Support/Development and up gradation of existing modules.

Resolution for the day to day issues related to REP application e.g. employee attendance data mismatch, Analysis of monthly report data with employee information, sending employees basic information to the JIO centre across branches for authentication etc using web-service.

Discussing issues and incidents raised by users across various branches.

Implementation of new requirements in the applications, testing of bug fixes. Testing in development, UAT, and Production environment.

Manage the issues based on REP/ Reliance JOI applications & analyzing the issues and provide the solutions, discussions with team members and senior management.

Maintain documentation for newly developed/existing modules in the application. Involvement in data migration activities as and when required.

Technologies Used: Visual studio 2010, C#.net, VB.Net, SQL Server 2008, 2012, JavaScript, SSRS

Other Technologies: Crystal Reports, SAP is also used in above all the applications.

Work Experience (2): 10/04/2013 – 13/07/2015, Mumbai

Company Name: Travelex India P Ltd (Malad, Mumbai).

Designation : Software Engineer.

Client : Travelex Currency Online, Retail Trading System (UK, USA/Aus/Canada)

Project Details:

Application 1: Retail Trading System (RTS): Travelex is the world’s largest foreign exchange specialist, with over 1000 retail branches, and 964 ATMs operating in 23 countries. Its core service is retail foreign exchange, through which they deliver outstanding value, seamless execution and unparalleled service for travelers and international businesses alike. Travelex offers a wide range of products and services to all its customers. Few of their major products and services include online reservation of Foreign Exchange, Travelex Rate Advantage, Western Union Money Transfer, Great Savings Campaign, ICICI Travel Money cards etc.

Application 2: Foreign Currency Services (FCS): Travelex Retail Foreign Exchange is one of the largest specialized foreign exchange businesses in South Africa. The company is licensed by the South African Reserve Bank to trade in certain foreign exchange products and services. Travelex is the world’s leading foreign currency exchange specialist, best known for supplying travelers their currency online, in airports, railway stations and city locations.

Responsibilities:

Retail Trading System (RTS) application support/Development and up gradation of existing modules.

Resolving day to day incidents related to RTS system e.g. sanctioned checking (Web Service calls to third party applications), Customers Cash Passport related issues at various sites.

Updating Data Control teams (DBA’s) about amendment of Cash Passport balances at specific sites.

Interaction with UK, Canada, Australia customers/users for discussing issues and incidents raised by them.

Initial testing of bug fixes/development. Testing in DEV, UAT, and LIVE environment.

Implementation of newly developed modules/Pages in all applications

Handling daily Incidents based on various RTS/ FCS applications & analyzing the issues and provides the solutions, update incidents on the current status.

Technologies Used: ASP.Net 2.0 /3.5 Framework, Visual studio 2008, C#.net, VB.Net,

SQL Server 2000, 2005 Ajax, JavaScript, SSIS, SSRS

Other Technologies: Java, Crystal Reports, SAP is also used in above all the applications.

Work Experience (3): 29/06/2010 – 29/03/2013, Mumbai

Company Name: CapGemini India (P) Ltd. (Vikhroli, Mumbai).

Designation : Consultant.

Client : Premier Foods (P) Ltd (UK).

Project Details:

Application 1: TAMSS (Trade and Marketing Spend System)*

Description : TAMSS is a web-based system that provides a number of core business processes for

Premier and is able to deliver a full month end from one system. It provides the

Following processes:

A single disciplined model for the company.

Excellent Control and Auditing capabilities.

Full Visibility throughout its processes.

A proven system coupled with processes that work for the business.

Core Industry Software and System Knowledge.

Application 2: OMS (Obsolescence Management)*

Description : OMS is an application to identify Loss areas within product, item and a solution to

Minimize the losses JBA and other system handles Out Of Demand Product and

Material not used in 16 weeks,26 weeks. This data is captured in OMS

There are approximately 50 users’ who use OMS at site and head office.

Following are the Processes of OMS:

Tracker system: Find out Targeted vs. Actual Production to minimize losses

RADAR report: Pulls out data from tracker system, out of date.

Already OOD No demand from projects to determine loss. A proven system coupled with processes that work for the business.

Along with the above applications and subsequent Management Reports a small suites of site specific reports have been introduced to complement and to more effectively manage long term issues.

Application 3: Sigmaweb*

Description : SigmaWeb Application gives visibility of loads and orders to selective Premier Hauliers

That is module for premier foods e.g. vehicle booking time for arrival of vehicle

To Premier dispatching site as well as Customers dispatching site. It provides the

The following processes:

Visibility of Orders - instruct Premier how orders should be made up.

All orders updates within SigmaWeb are forwarded to Solar where applicable and further sent onwards to SAP.

Visibility of Loads - This permits Hauliers to override the previous system generated vehicle booking time for arrival of vehicle to Premier dispatching site.

Permits a portal allowing Hauliers to reconcile orders they are responsible for.

There is a single FTP receive process currently in place that receives sub contractor codes associated to Loads from Roadways hauliers and Roadrunner software. This is controlled by a windows application.

FPT file is received by SigmaWeb which is sent by Load Runner (Software) which contains Load Number, Loader Name etc. If FTP file is not received by SigmaWeb then Email is sent to Premier Help Desk for resolving issue.

Application 4: Prime KPI*

Description : Prime KPI Application is used to record production efficiency for Premier Foods.

It provides the following processes:

KPI’s to measure the efficiency of each individual site.

Produce reports for analysis. The upload data can be viewed in several reports

On the system. These reports display the data over a different time period and allow for it to be broken down into divisions or groups where relevant.

The reports produced are Period overview, Annual overview, OEE reports (Weekly OEE report, Period OEE report)

There are essentially two main parts to the KPI application Upload Spreadsheet: This is where users can upload a set of figures for their sites respective weekly upload. This is a spreadsheet in a clearly defined format.

Reports: The upload data can be viewed in several reports on the system. These reports display the data over a different time period and allow for it to be broken down into divisions or groups where relevant.

Responsibilities:

Application maintenance, providing current bug fixes for all applications as well as creating new modules, handled Database Design, Stored procedures, SQL jobs, and Application Design coding and testing.

Handling daily tickets based on various applications & analyzes the issues and provides the solutions, update tickets on the current status.

Interaction with UK customers/users for discussing issues and tickets raised by them.

Initial testing of bug fixes/development. Testing in DEV, UAT, and LIVE environment.

Implementation of newly developed modules/Pages in all applications

Technologies Used: ASP.Net 2.0 /3.5, 4.0 Framework, Visual studio 2008, C#, MVC Ajax, JavaScript, SSIS, SSRS, SQL Server 2005,

Other Technologies: AS-400, JBA, SAP, Solar System is also used in above all the applications.

Work Experience (4): 1/12/2007 – 25/06/2010, Mumbai

Company Name: Zillion Technologies (P) Ltd.(Andheri,Mumbai)

Designation : Software Developer

Client : Bigshares Services (P) Ltd

Project Detail:

Application Name: StarCoin*

Team Size : 5

Description : This project handles the share transactions of share holders.

Responsibilities : worked on module like all types of Masters like Transfer/split/Consolidation of

Shares and Reports etc.

I.e. Share Holder Personal Information & Share Details.

Handled Database Design, Stores Procedures, Application Design, Coding

and Application Testing.

Description: - This Project is developed to automate the following operations of Share Security

Management of Bigshares Services (P) Ltd.

Sql Server: Designing Tables, Stored Procedures.

Registering transfer of shares in the physical / Demat form.

Registering change of Address, Power of Attorneys, etc.

Interaction with Stock Exchanges, SEBI & other statutory bodies.

Dematerializing / Rematerializing share certificates.

Integrated electronic beneficiary positions with the physical shareholding.

Dispatching all corporate communications to the shareholders.

Dispatching share certificates, refunds or value warrants.

Reconciliation of refund / value payments.

Uploading data from depositories(NSDL & CDSL),for crediting shares electronically

Technology Used: ASP.Net 2.0 /3.5 Framework, C#,SQL Server 2005,JavaScript,CrystalReport 2008

Work Experience (5)

Company Name: Immaculate Integrated Technical Solutions (IITS) [Mumbai]

Work Duration : 2006 Nov – 2007 Dec

Designation : Software Developer

Client : Intime Spectrum Registry [Bhandup, Mumbai]

Project Detail:

Application Name : CartNet*

Team Size : 8

Description : This project handles the share transactions of share holders.

Responsibility : Creating module like all types of Master, Transaction and Reports.

I.e. Share Holder Personal Information & Share Details.

Handled Database Design, Stores Procedures, Application Design, Coding

And Application Testing.

Description: - This Project is developed to automate the following operations of Share Security

Management of Intime Spectrum Ltd.

• Sql Server: Designing Tables, Stored Procedures.

• Registering transfer of shares in the physical / Demat form.

• Registering change of Address, Power of Attorneys, etc.

• Dividend distribution of reconciliation.

• Interaction with Stock Exchanges, SEBI & other statutory bodies.

• Dematerializing / Rematerializing share certificates.

• Integrated electronic beneficiary positions with the physical shareholding.

• Dispatching all corporate communications to the shareholders.

• Dispatching share certificates, refunds or value warrants.

• Reconciliation of refund / value payments.

• Uploading data from depositories (NSDL & CDSL),for crediting shares

Technology Used: ASP.Net 2.0 Framework, C#, SQL Server 2000/2005, JavaScript,

Crystal Report 2008

Other Qualifications: Web & Application Development Visual Studio .Net 2003,Sql Server 2000

(St.Angelos Computer Institute) [Vashi, Mumbai]

Hobbies : Reading, Playing Outdoor Games & Chess

Place : Panvel, Navi Mumbai

Personal Information:

Date of Birth : 31st March 1974

Education : T.Y.B.Com

E-Mail : act7gk@r.postjobfree.com, act7gk@r.postjobfree.com

Cell No : +91-992*******

Residential Address:

Flat no-15, PL6-A-6

Sahyadri Apartments, Khanda Colony

New Panvel -410206

India, Maharashtra

Thanks & Regards

Rahul.c.Randive

Contact this candidate