Software/Web Developer Classic ASP,E-Commerce,SQL Server Developer
Resume:
Ravi Ranjan
Phone – +91-989*******
E-mail – *************@*****.***
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