.Net Sql Server Oracle Sales Service Data Business
Resume:
Resume of RONIKA KAMDAR
Contact: 201-***-**** Email:
********@*****.***
SUMMARY:
. Over seven years of in-depth experience in all phases of Software
Development, involving Analysis, Design, Coding, Implementation,
troubleshooting and training of high quality business solutions using
object oriented design and analysis methodologies with internet/Intranet,
client/server, and n tier technologies and Support of Web Based
Applications and Window based Applications especially.
. Expertise in ASP.NET, Visual Basic, VB.NET, C#, AJAX, SQL, PLSQL and
various relational databases like ORACLE 10x and SQL SERVER 2005, 2008
. Experience in requirements gathering, systems design and architecture,
coding, database development, GUI development, troubleshooting and End-
User Training.
Technical Skills:
Languages: ASP.NET 2008, VB.NET, C#, HTML,AJAX, DHTML, XML,
ASP 2.0, PL/SQL, Excel/VBA, Java.
Databases: Oracle 10x/9i/8i/x, MS SQL Server 7.0/2000/2005/2008, SQL
Server Integration Services, MS-Excel, MS-Access, FoxPro
2.x, Dbase IV. Stored Procedures, Functions and Triggers in
T-SQL & PL/SQL
Software: Visual Studio 2005/2008, .Net Framework v1.1 to v3.5,
ADO.NET, VB6,ADO, MS DAO, OLE, COM, Visio 5.0., Microsoft
Visual Studio .NET, MS Visual Interdev 6.0, ADO, DAO, and
RDO & ODBC access methods to interact with database, Web
Service, Windows Service MS Office, Windows Presentation
Foundation (or WPF), IBM Message Queue
Scripting Languages: JavaScript, HTML, CSS, AJAX, XML, VBSCRIPT, XSL and
DHTML
Web Servers: IIS 6.0, IIS 7.0 and Personal Web Server
GUI: ASP.NET, VB.NET, C#, Visual Basic 6.x, Visual InterDev 6
Operating Systems: Windows 2003, XP, NT 4.0, Novell NetWare 3.1x,
Winnows 95, MS-DOS, Sun UNIX.
Reporting Tools: Crystal Reports 9.0,8.x., SQL Server 2008 Reporting
Services (SSRS), MS-Office using .Net
application, PDF files, Flat Files, XML, Excel
PROFESSIONAL EXPERIENCE:
Aug 08 - Present
Client: Johnson Controls, Inc.
Milwaukee, WI
Sr. Web Developer/.Net Developer
Sales and Marketing Information System
Job Profile:
. Working on various web, windows and Console based applications for Sales
and Marketing Department using ASP.NET, VB6, VB.NET, C#, AJAX, HTML, XML,
SQL Server 2008, Oracle 10.2 including requirement gathering, designing,
developing, coding and trouble shooting.
. Writing and implementing complex and sensitive server based application
to import and export data exchange and migrating between two servers
(Siebel and SQL server 2008) using XML and sending and receiving data
using IBM Message Queue. Application is on .NET Framework and uses VB6,
VB.NET and C#.
. Implementing Web based application for productions troubleshooting and
data validations check in ASP.NET 2008 and AJAX, Html, XML, SQL Server
2008.
. Writing Design documentation using Cases, Activity Diagrams, Class
Diagrams. Also writing User's Manual for using web application.
. Working with application configuration file to securing application and
user authentication and writing log file for errors. Writing different
Excel based reports. Writing VBA functions to format the reports. Have
also worked on writing reports using SQL Server 2008 Reporting Services
(SSRS) and have prepared UI in WPF and XAML.
. Fixed errors and bugs, added new features and enhancements to existing
application, provided on going support and maintenance to the
applications. Working on current application for data exchange on daily
based server application.
Responsible:
. Have Developed Console Based VB.NET, VB6 and C# Application for daily
run on server to exchange data between Seibel database and SQL Server
2008 database using XML and IBM Message Queue.
. Extensively work on N-Tier architecture designed to exchange data from
SQL SERVER 2008 to .Net Application and then data converted into XML,
send across to the IBM Message queue (Web Spheres) and then data send to
Fusion server and finally it was stored into Siebel database.
. Design and implemented Window / Web based applications with GUI
Development using VB.NET, ASP.NET. C#, Used ADO.NET for database
connectivity to get data from SQL SERVER 2008 and Oracle.
. Have also used ADO & ODBC access methods to interact with SQL DB, worked
on built in API (Library) written in VB6 to retrieve and store
information in SQL Server 2008 and Oracle in VB.NET application. Created
Record Set Object to get data manipulation. Have also used Microsoft
Enterprise Library to implement functionality in .net application.
. Have used Saratoga Systems (third party tool/API) to connect to the
database SQL Server 2005/8 and have performed different transactions on
database using VB.NET. Have implement facility to send Email messages to
associate persons on event of errors or process submission etc. Have used
security verification to restrict non authorized person to use several
options on website.
. Write Stored Procedures, SQL Packages, SQL functions, and Queries to get
the desired output at the front end. Write triggers, sub queries, joins,
transaction related queries.
. Created class libraries for Insert, Update, Delete functions and
validating data functions using built in VB6 APIs And ADO.NET in
VB.NET and C#.
. Responsible for Trouble shooting, Debugging, Point to Point Testing,
Quality Testing, User Acceptance testing, Server Deployments of
applications and settings, End-User Training, Preparing User Manual, and
User Documentation. Technical and design specification documentation.
Environment: NET Framework 2008, VB.NET, C#, Microsoft Enterprise
Library, Visual Studio 2008, SQL SERVER 2005, ASP.NET, VB6, Windows
Service, AJAX, PL/SQL, Saratoga Systems, Quick Soft SMTP, ODBC, ADO, IBM
Message Queue, Easy Byte (Convert RTF to HTML), VBA, Excel 2003, XML, Flat
Files, Web Service, Excel Reports, Crystal reports, Windows XP/NT
Oct 06 - Jul 08
Client: Bristol Myers Squibb Co.,
Princeton, NJ
Programmer Analyst
Compound Management Applications (CMA)
Job Profile:
. Extensively worked on various web based and windows based applications
for Compound Management group using ASP.NET 2.0, VB6, VB.NET 2.0, C# and
Oracle 10.2, SQL Server 2005 including requirement gathering, designing,
developing, coding and trouble shooting.
. Created test scripts by giving various scenarios to test for the QA team.
Added browse feature to search and export feature to Excel and PDF
formats using VB6, VB.NET.
. Have implemented Web Service using VB.Net, C# and referenced it to the
current Web Application in ASP.Net to retrieve information and displayed
on web page. Worked on Window service which tracks on system database and
will generate actions on certain conditions.
. Developed Oracle - PLSQL based complex store procedures and user defined
functions to effectively merge data from different sources to create the
user friendly display on the web.
. Writing various JavaScript functions to validate user input on web
application using HTML and CSS to give format design the web pages.
. Implemented the database changes creating and modifying the table
structures, implementing constraints on the table schemas, developing
complex user defined functions, stored procedures and cursors to provide
user friendly interface.
. Provided security features such as authenticating and validating
application users and access privileges as per the user level to increase
safe secure usage of web application.
. Provided automated Email features to provide information to system users.
. Worked on Windows based application e g. Barcodes reading/Scanning
systems using PDA, Order System where chemists can place the orders of
Dispense the tube/ racks, Solubilization of tube/racks, Shipping tubes
/Racks to internal branch of BMS and received email on Shipment received
and pick up, also email system send emails when chemist would fail
/cancel task from the system.
. Currently participating in development, enhancements and troubleshooting
Compound Management. Fixed errors and bugs, added new features and
enhancements to the application, provided on going support and
maintenance to the application.
. Providing ongoing support for various applications including interacting
with users and troubleshooting and fixing and modifying the applications
as per the requirements.
Responsible:
. Create GUI Development Design using VB6, VB.NET, ASP.NET. C#, Used
ADO.NET for database connectivity to get data from ORACLE Database.
. Automate Email System which sends html message. worked with Window
Service using VB.NET
. Write Stored Procedures, Oracle Packages, Oracle functions, and Queries
to get the desired output at the front end. Write triggers, sub queries,
joins, transaction related queries to perform different functions on
system. Use AJAX, SMTP, Web Service on ASP.NET web application to do
several task like sending emails, update progress while process is
running, used web service to get real time weather forcast.
. Created class libraries using built in APIs and ADO.NET in VB.NET.
. Involved in generating, designing and developing Reports using Excel in
VB.NET.
. Extensively work with ADODB, ODBC connection with ORACLE Database to
interact with VB.NET application. Have used built in API created in old
VB6 Code and used with ADODB connection and store information in ORACLE
10g DB. Have used Record Set Object to get data for Validation.
. Responsible for End-User Training, Preparing User Manual and
Documentation.
Environment: NET Framework 2005, VB6, VB.NET, C#, Oracle10.2, TOAD for
Oracle (Quest Software 9.01), Visual Studio 2005, ASP.NET, Windows Service,
AJAX, SMTP, GIS [Google Map], Web Service, Excel reports, Crystal reports,
Component One for .Net 2.0, VBA, Excel 2003, html, XML, Windows XP/NT
Jan 05 -Sep 06
Employer: H J Doshi Institute, India
Computer Programmer
Online Registration System
This is off shore smart web-based enrollment system, where users can use
their users ID# and PIN to log in and obtain grades, current schedules,
register for classes, pay tuition fees via credit card etc. Developed new
web applications and supported existing web applications on the Microsoft
web server platform using Visual Studio 2005 with SQL Server 2000 and
Oracle back-end databases.
Job Profile:
. Function as Engineering Lead for the analysis, design and implementation
of User Wire frames and projects.
. Design the architecture of application. Create GUI Development Design
using ASP.NET and style sheet.
. Extensively worked on Visual Basic.Net, C#, Developed on .Net Platform
with 3-tier architecture: presentation layer, business logic layer and
data access layer. Provide software support for existing applications on
a rotating basis. Assist junior Software Engineers
. Documenting both design and code. Training end users and compiling user
manuals. Create Classes to generalize the code. Expertise with the 3-
tiered web-based architectures with strong object oriented analysis.
. Used VB6, VB.NET at server side and Java Script for client side. Involved
in generating, designing and developing Reports using Crystal Reports
9.0. Used ADO.NET for database connectivity to get data from SQL Server.
. Write Stored Procedure and Queries to get the desired output at the front
end. XML and XSLT for data access and data look.
. Responsible for End-User Training, Preparing User Manual, and User
Documentation.
Environment: NET Framework, ASP.NET, VB.NET, C#, XML, XSL, SQL Server
2005, Oracle9i, Visual Studio 2005, Crystal reports, T-SQL, Java Script,
CSS, HTML, Windows 2000/NT
Jul '03 - Aug '04
Employer: Oshwal Education Trust, India
Programmer
Material Transaction System (MTS)
Window based application for Material (Books) Transaction management system
for the Organization. This project was designed for full computerization of
the library.
Job Profile:
. Defining the business logic for the project. Migrating data and
applications from legacy applications.
. Presenting the detailed flow of the project depending upon the state laws
and business logic.
. Coding business objects for the business rules engine module in VB6,
VB.Net.
. Developed on .Net Platform with 3-tier architecture: presentation layer,
business logic layer and data access layer.
. Designed and Developed UI, User Controls, Custom Controls and Client-
Server side Validation Controls using ASP.NET and JavaScript.
. Working with MS Win Forms application development using Visual Basic .Net
Extensively worked on Visual Basic.Net, ASP.NET Development of
components using XML, XSL and XSLT for data transformation.
. Creating web reports using Crystal reports in ASP.Net.
. Connecting to the backend through ADO.Net for interacting with database
objects.
. Created a common data provider, which connects to DB2, Oracle 9i and
other OLE DB databases.
. Involved in PL/SQL programming for Oracle 9i for creating packages,
triggers, functions and stored procedures. Production support for the
project in live environment.
. Involved in generating, designing and developing Reports using Crystal
Reports 9.0.
. Designed and implemented Oracle and PL/SQL.
Environment: VB.NET, ASP.NET, Oracle8i, SQL Server 2000, Crystal Report
.NET, VB6, HTML, COM, XML, XSL, XSLT, DHTML, Windows 2000.
Jan '02 - Jun '03
Employer: RTech Software Consultancy, India
Application Developer
Client: Krishna Mortgages Private Ltd
Responsible for the analysis, design, coding, debugging, development and
implementation of Loans management system for mortgages, customization of
in-house products, generating complex reports and enhancements to existing
processes to meet front-to-back office software requirements. Interfaces
with all facets of mortgage-backed securities trading and mortgage loans
processing.
Job Profile:
. Identifying the business needs & accordingly designing the work flows for
various processes.
. Design the application architecture to develop GUI. Developed Desktop
application using VB 6.0
. Front end is consisting of generation of GUI using customer requirements.
VB 6.0 is used for Front-end.
. MS Access and SQL SERVER are used to store sorted result in tabulated
form in the back end.
. Development of macros for Word and Excel for data transfers between MS
Access 97 and SQL Server Word and Excel and Crystal reports for Reporting
purpose.
Environment: Visual Basic 6.0, Crystal Reports existing Microsoft
Access, SQL Server, DB2, Windows NT, Excel.
Client: ACNielsen ORG-MARG Private Ltd
Responsible for the analysis, design, coding, debugging, development and
implementation of web based Recruitment System. Objective of proposed
system is to maintain Employee Databank of Organization, Manpower
Indenting, Online Resume Submission and Conducting Test for the Short-List
Candidates.
Job Profile:
. Design the application architecture to develop GUI. Front end is
consisting of generation of GUI using customer requirements. VB 6.0 is
used for Front-end.
. ORACLE 8i/PLSQL is used to store sorted result in tabulated form in the
back end.
. Developed complete business information systems in Visual Basic and Excel
with Oracle backend.
. Participated from concept to coding to error proofing. Using RDBMS data
base design concepts.
. Designed a VB front end to an existing network reports database-using ADO
for live previewing and editing of data. Sales forecasts are now produced
three days after month-end instead of five days and a single Oracle
procedure replaces the tedious editing of over 30 monthly sales reports.
. Triggers are used for updating, inserting and deleting data into table.
Environment: Visual Basic 6.0, Crystal Reports, Oracle 8i, PL SQL,
Windows NT
Client: Indian Airlines booking center
Window Based Application for Ticket Reservation for different Flights and
cancellation of Reservations. Issuing Tickets and other Reports. The
project has the options for booking for the facility and viewing the status
of their booking.
Job Profile:
. Developed Commercial software for Ticket booking for Indian Airlines.
. Front-end tool used is VB6, VB .NET. For the back end SQL Server 2000 is
used.
. Developed Complete Application Using Visual Basic.NET
. PWS (Personal Web Server) is used to run ASP script.
. Using session we can get to know when the application starts and when it
ends.
. Design the application architecture to develop GUI.
. Crystal Reports .NET is used to generate reports.
Environment: ASP, MS-Access, MS SQL Server 2000, VB.NET, Crystal
Report.NET, Windows- 2000 etc.
Client: Prime Brass Manufacturer, India
Job Profile:
. Developed complete business information systems in Visual Basic and Excel
with Oracle backend.
. Participated from concept to coding to error proofing. Using RDBMS data
base design concepts.
. Designed a VB front end to an existing network reports database-using ADO
for live previewing and editing of data. Sales forecasts are now produced
three days after month-end instead of five days and a single Oracle
procedure replaces the tedious editing of over 30 monthly sales reports.
. Crystal Reports is used to generate reports.
Environment: Visual Basic 6.0, ADO, Oracle 8i, PL SQL, Excel, Crystal
Report and Windows NT.
EDUCATION:
Masters in Computer Applications from India, Dec '02.
Masters of Commerce - Finance from India, May '02.
Bachelors of Commerce from India, May '97.
TRAINING:
Enterprise development using ASP.NET and VB.NET ACT Computer Education,
India, Sep '04.
Advanced Java Programming with EJB and JSP Boston Institute Mumbai - India,
Feb '03.
Diploma in RDBMS using Oracle 8 with Visual Basic 6 SSI Institute of
computers, India, Aug '00.
Contact this candidate