Ravi Ranjan

Phone – +91-989*******

E-mail – acb3zc@r.postjobfree.com

Skype – ravi.ranjan.j9

Summary

Software Developer with more than 8 years of experience in Implementation, support and maintenance project engagements

Experience in code migration, database change management and data management through the various stages of the development life cycle

Ability to handle multiple projects and deadlines

Collaborative leadership skills

Responsibility of working as a developer with SQL Server on all aspects of database design, development and deployment.

Responsibility of working as a developer with Classic ASP,ASP .net

3.5 years experience in VAS services (SMS) integration and applications.

Strong Experience in Database Design for Complex web and Mobile Application, including writer complex store procedure, function, Trigger and ad-hoc quires.

Strong proficiency with MS SQL Server and its variation among database

Strong experience on Database designing, normalization, optimization and performance tuning.

Experience in advanced SQL programming, problem-solving and analytical skills.

SQL basic administration, Schema designing & building, SQL Programming, SSIS Packages, SSRS

Integrate various external database systems and with other apps/Webservices using Linked servers, DTS, and SSIS,SSRS packages.

Provide technical and data leadership to facilitate and coordinate current and future development efforts that involve any database elements.

Provide guidance and support to performance testing engineers and Operations Database Administrators in database monitoring, troubleshooting and performance tuning.

Support IT and Operations in database monitoring/troubleshooting, capacity planning and performance tuning.

Develop architectural logical design documentation and periodically review for completeness or response to audit or business requirement changes.

Handle common functionalities of database like structure design, writing procedures, view, triggers and backup, recovery, migration etc.

Help write and optimize in-application SQL statements

Expert level skill in writing T-SQL queries, stored procedures, functions, Views and triggers, with an outstanding track record of delivering high quality code in an aggressive.

Excellent configuration knowledge of technical platform like ASP, ASP.Net,SQL Server, Oracle

Develop architectural logical design documentation and periodically review for completeness or response to audit or business requirement changes.

Develop architectural logical design documentation and periodically review for completeness or response to audit or business requirement changes.

Experienced in Application development and implementation Methodologies using SDLC process

Experienced with updating board results into my own asp pages

Extensively worked with the HRMS and inventory

Extensively used the mappings like mobile billings and SMS API

Performed the process of object monitoring and application monitoring

Billing configurations and SMS configurations

Highly experienced in troubleshooting and debugging complex interfaces and resolve issues

Experienced with worked transport from development system to quality

Good team player and collaboration skills

Help developers to optimize queries, stored procedure and database design.

Technical Skills

Languages : Vb script, Classic ASP and ASP.net, Java Script, AJAX, VB 6.0

Operating Systems : Windows XP/Vista/7/8, Windows 2003 Server

Database : SQL Server, Oracle, SSIS and SSRS in SQL Server, MS Access

Work Experience:

1.Worked as Consultant with Atum ITS (http://www.atumit.com) Hyderabad since 10 Nov 2016 to 28 Feb 2017 (Contract Basis)

2.Worked as a Technical Consultant with Fluous Solutions (http://www.fluous.com) (Mumbai), with

Client Andhra Bank Head Office Hyderabad since 8 Aug 2016 to 8 Nov 2016 (Contract Basis)

3.Worked as a Software Developer Cum Faculty with IGNOU Programme Study Centre A-Cube Centre for Excellence Delhi since 5 March 2016 to 31 July 2016

4.Worked as a Senior Software Associate with FUSION INDUS TECSOL PRIVATE LIMITED (Hyderabad), with Client Location NCR corporation (http://www.ncr.com) Gurgaon since 17 Aug 2015 to 29 Feb 2016. (Contract Basis)

5.Worked as a Software Developer with J9 Ventures, Division of Jagran Prakashan Ltd. www.jagran.com, New Delhi since 25 Jan 2012 to 16 Aug 2015.

6.Worked as a Senior Software Engineer with Milestone E-Commerce Pvt. Ltd, Gurgaon [www.milestoneuk.co.uk] from 24 March 2010 to 24 Jan 2012.

7.Worked as a Senior Programmer with ARCS New Delhi [www.arcscrop.com] from 14th Sep 2009 to 20th March 2010.

8.Worked as Software Programmer with Digital Info Solutions Pvt. Ltd. New Delhi [www.digitalsolutions.co.in] from 13th Jan 2008 to 8th Sep 2009.

Projects:

Industry : IT Industry & Development

Project Description/Scope : Implementation

Role : IT Consultant

Duration : 10th Nov 2016 to Feb 2017

Responsibilities/Deliverable:

Provide technical and data leadership to facilitate and coordinate current and future development efforts that involve any database elements.

Implement and maintain the database design

Create database objects (tables, indexes, UDFs, views etc.)

Write database procedures, functions and triggers etc.

Provide guidance and support to performance testing engineers and Operations Database Administrators in database monitoring, troubleshooting and performance tuning.

Understands the ASP,SQL Server standards

Help developers to optimize queries, stored procedure and database design.

Understands the business flows and Technical specifications

Involved in Preparing Technical Specification as well as Technical Solution Documents wherever required

Developed new objects, bug fixing and Monitoring

Order system Applications developing and classic ASP Pages, ASP .net we have developed

We will be connecting ODBC Connections and updating the data into development systems

Work with the architect on database design and implementation enhancements

Creating tables & views in SQL and worked on that tables in development

Performance Monitoring and Tuning in SQL Server, Troubleshooting and debugging

Created some stored procedures, trigger.

Industry : Banking Systems

Project Description/Scope : Implementation

Role : Senior Developer

Type : HRMS

Duration : 8th August 2016 to 9th November 2016.

Technology : Classic ASP, ASP .net with C#, Oracle, MS Access

Responsibilities/Deliverable:

Developed new objects, bug fixing and debugging

Provide technical and data leadership to facilitate and coordinate current and future development efforts that involve any database elements.

Provide guidance and support to performance testing engineers and Operations Database Administrators in database monitoring, troubleshooting and performance tuning.

code migration, database change management and data management through the various stages of the development life cycle

Help developers to optimize queries, stored procedure and database design.

HRMS Applications developing and classic ASP Pages, ASP .net, JavaScript we have developed

We will be connecting ODBC Connections and updating the data into development systems

Work with the architect on database design and implementation enhancements

Creating tables & views in Oracle and worked on that tables in development

Created some stored procedures, trigger

Help developers to optimize queries, stored procedure and database design

Industry : Study Centre

Role : Senior Developer cum Faculty

Duration : 5th March 2016 to 31th July 2016.

Responsibilities/Deliverable:

Developed Software for Student Management System

Provide technical training to development Team Members

Provide technical training to BCA and MCA Student

Industry : IT Industry & Development

Project Description/Scope : Maintenance and Support

Role : Senior Developer

Type : E-Order

Duration : 17th August 2015 to Feb 2016

Technology : Classic ASP, ASP .net with C#, SQL Server, T-SQL,SSIS

SSRS, MS Access

Responsibilities/Deliverable:

Understands the ASP,SQL Server standards

Understands the business flows and Technical specifications

Involved in Preparing Technical Specification as well as Technical Solution Documents wherever required

Developed new objects, bug fixing and Monitoring

Managing and Troubleshooting Security in SQL Server

Help developers to optimize queries, stored procedure and database design.

Handle common functionalities of database like structure design, writing procedures, view, triggers and backup, recovery, migration etc.

Order system Applications developing and classic ASP Pages, ASP .net we have developed

We will be connecting ODBC Connections and updating the data into development systems

Work with the architect on database design and implementation enhancements

Creating tables & views in SQL and worked on that tables in development

Performance Monitoring and Tuning in SQL Server, Troubleshooting and debugging

Created some stored procedures, trigger

Created application using SSIS and SSRS

Industry : Media

Project Description/Scope : Development

Role : Developer

Type : Value Added Service (SMS)

Duration : 25 Jan 2012 to 16 Aug 2015

Technology : Classic ASP, SQL Server, T-SQL,SSIS,SSRS, MS Access

Responsibilities/Deliverable:

Around 2000 Mobile SMS services (VAS services) on 57272 like PNR status, Result of Board (C.B.S.E. and state board) exam of 10 and 12, Subscription for various services on mobile like CRI, LUV etc. Mobile Billing Integration, Miss Call Services, Bulk SMS Services

Knowledge in software development, tools and frameworks, with special focus on VAS application development

Mobile Billing configurations and SMS configurations

Monitoring whole ASP, ASP .net Pages and monitoring

Strong Experience in Database Design for Complex web and Mobile Application, including writer complex store procedure, function, Trigger and ad-hoc quires.

Data warehouse Support

Performance Monitoring and Tuning in SQL Server, Troubleshooting and debugging

Managing and Troubleshooting Security in SQL Server

Help developers to optimize queries, stored procedure and database design.

Handle common functionalities of database like structure design, writing procedures, view, triggers and backup, recovery, migration etc.

Handle common functionalities of database like structure design, writing procedures, view, triggers and backup, recovery, migration etc.

Focuses self and team on tasks with action-oriented collaboration

Analyzing, Designing and Implementing the interfaces to new requirements and already existing interfaces

Changing mappings as per the new requirements

Involved in analyzing Code and Technical specification document review

Checking the configurations like connections to the SQL server during the initial stage of build phase

Fixing the issues as per the severity within the deadline time as a part of application support

Daily monitoring whether the production system is up and running

Interacting with process team technical team and ASP, SQL Server developers to ensure complete end to end performance testing

Prepared technical design specification based on new requirements

Mostly worked on VAS technology objects

Work with the architect on database design and implementation enhancements

Primary on day to day schema changes and database maintenance

Creating tables & views in SQL and worked on that tables in development

Created View, Stored procedures, trigger

Monitoring whole SQL Server Query for space and performance tuning

Created application using SSIS and SSRS

Industry : E Commerce http://www.choiceshops.co.uk

Project Description/Scope : Development

Role : Senior Developer

Duration : 24 March 2010 to 24 Jan 2012

Technology : Classic ASP, ASP .net with C#, SQL Server, T-SQL, MS Access

Responsibilities/Deliverable:

Convert from classic asp to asp.net user end and admin. This project has multiple domain and one admin control. Generating different types of admin/supplier reports as well as product, category, optioncategory products and cross sell products, template controls.

code migration, database change management and data management through the various stages of the development life cycle

Monitoring whole ASP Pages and monitoring

Monitoring whole SQL Server Query for space and performance tuning

Help developers to optimize queries, stored procedure and database design.

Handle common functionalities of database like structure design, writing procedures, view, triggers and backup, recovery, migration etc.

Analyzing, Designing and Implementing the interfaces to new requirements and already existing interfaces

Changing mappings as per the new requirements

Involved in analyzing Code and Technical specification document review

Checking the configurations like connections to the SQL server during the initial stage of build phase

Fixing the issues as per the severity within the deadline time as a part of application support

Daily monitoring whether the production system is up and running

Interacting with process team technical team and ASP and SQL Server developers to ensure complete end to end performance testing

Prepared technical design specification based on new requirements

Mostly worked on E commerce technology objects

Work for JavaScript for validation checking of pages.

Industry : E Commerce www.framesdirect.com

Project Description/Scope : Development

Role : Developer

Duration : 14th September 2009 to 20th March 2010

Technology : Classic ASP, SQL Server, T-SQL, MS Access

Responsibilities/Deliverable:

Frames Direct (www.framesdirect.com) is a leading provider of all kinds of glasses like eyeglass, sunglass, contact lenses and prescribed sunglass inspite of this like swimming glass, sport glass, baby glass.

It is a huge website and I worked on several modules like Google Checkout, URL Rewriting, Clean up HTML on various Pages, Code optimization, Auto Emailing Utilities, Create DTS Package in SQL

Monitoring whole ASP Pages and monitoring

Analyzing, Designing and Implementing the interfaces to new requirements and already existing interfaces

Changing mappings as per the new requirements

Involved in analyzing Code and Technical specification document review

Checking the configurations like connections to the SQL server during the initial stage of build phase

Fixing the issues as per the severity within the deadline time as a part of application support

Daily monitoring whether the production system is up and running

Interacting with process team technical team and ASP/SQL Server developers to ensure complete end to end performance testing

Prepared technical design specification based on new requirements

Performance Monitoring and Tuning in SQL Server, Troubleshooting and debugging

Mostly worked on E commerce technology objects

Industry : CA Forms

Project Description/Scope : Development

Role : Developer

Duration : 13th Jan 2008 to 8th September 2009

Technology : Classic ASP, SQL Server, T-SQL, MS Access

Project

MIS (- AAYUSH Magazine Publishing)

Technologies Used: Classic ASP, SQL Server, MS Access

Description: Customize MIS for AAYUSH PUBLISHING is designed to manage its all Management Information System activity like Client, Vendor, Agent, Magazine, Advertisement, Sale, Generate Invoice, Debit Note, Credit Note, Ledger Report.

The MIS Application is spread over modules as follows:

1.Member Login

2.Setup

3.Master

4.Transaction

5.Management Reporting

6.Utilities

Inventory Management System (Oriental Exports, International)

Technologies Used: Classic ASP, SQL Server, MS Access

Description: Customize Inventory Management System for Oriental Exports International is designed to manage its all Inventory Management System Information System activity like Client, Vendor, Agent, Item, Sale, Purchase, and Generate Invoice.

The Inventory Management System Application is spread over modules as follows:

1.Member Login

2.Setup

3.Master

4.Transaction

5.Management Reporting

6.Utilities

MIS ( INDO PACIFIC AVIATION LTD)

Technologies Used: Classic ASP, SQL Server, MS Access

Description: Customize MIS for INDO PACIFIC AVIATION is designed to manage its all Management Information System activity like Employee, Vendor, Aircraft, Client, Bill TRANSACTION, Client Aircraft expense, Vendor expense, Ledger Report, Generate Invoice, Debit Note, Credit Note, Company Own Expense.

The MIS Application is spread over modules as follows:

1.Member Login

2.Setup

3.Master

4.Transaction

5.Management Reporting

6.Utilities

MIS (B.R. & Company LTD)

Description: Customize MIS for BR Bidi Company is designed to manage and link between products, clients, sales representatives. It is designed to have sales, purchase, stock Report for Management Information System.

Different modules of MIS are:

1.Member Login

2.Setup

3.Master

4.Sales

5.Production

6.Purchase

7.Printing

8.Management Reporting

9.Utilities

Payroll Management System for Anil K Goyal & Associates

Technologies Used: Classic ASP, SQL Server, MS Access

Description Anil K. Goyal & Associates is a registered chartered accountancy firm established in 1983.It is an accounting and consultancy firm providing a comprehensive range of business advisory services to a wide range of corporate clients within and outside India.

Objective: Develop a intranet web application with following functionalities:

1.Stores new Company record.

2.Stores new Employee record.

3.Stores Employee Allowance, Attendance record.

4.Generate Employee CTC Report.

5.Generate Employee Attendance Report.

Responsibilities/Deliverable:

Monitoring whole Account base Pages and monitoring like Inventory, MIS

Analyzing, Designing and Implementing the interfaces to new requirements and already existing interfaces

Changing mappings as per the new requirements

Involved in analyzing Accounts and Technical specification document review

Checking the configurations like connections to the SQL server during the initial stage of build phase

Fixing the issues as per the severity within the deadline time as a part of application support

Daily monitoring whether the production system is up and running

Interacting with process team technical team and ASP developers to ensure complete end to end performance testing

Prepared technical design specification based on new requirements

Mostly worked on Accounting technology objects

Performance Monitoring and Tuning in SQL Server, Troubleshooting and debugging

Education:

Masters in Computers and Applications from Karnataka State Open University

Advanced Diploma in Computer Applications from Indira Gandhi National Open University

Bachelor of Computer Application from Indira Gandhi National Open University

12th from Bihar Intermediate Education Council

10th from Bihar School Examination Board

Personal Profile:

Date of Birth - 21 Nov 1981

Father's name - Sri Mewa Lal Prasad

Marital Status - Married

Nationality - Indian

Address - 514, Sai Bhawani Apartment, Ganga Block, Ramanthapur, Hyderabad- 500013

Contact this candidate