Software Engineer Sql Server

PRABHA SUNDARARAJAN

**** ******* ****** ** : 440-***-**** (H)

Avon, OH-44011 *********@*****.***

PROFESSIONAL PROFILE:

o A dynamic, results oriented Software Professional with experience in design, development and implementation of Commercial Web based / Client Server applications.

o Extensive experience in ASP.NET (VB.NET, C#), ASP, XML, VB6.0, Crystal Decisions/Reports, MS Access, Oracle7.0 / 8i, SQL Server6.5/7.0/2000/2012, Activex, ADO, OLAP Services.

O Developed the applications as well as testing those for production and live environments

EDUCATION:

Master Of Computer Applications, April 1995

Thiagarajar College of Engineering, India

Batchelor of science in Physics April 1992

Madurai Kamaraj University, India

CERTIFICATION:

SkillDrill Certification Program : Active Server Pages 3.0 Development

XML Certificate (eCertifications) : XML Programmer

Microsoft Certifications :

MCP Exam : 70-176 - Designing & Implementing Desktop Applications with Microsoft Visual Basic 6.0

MCP Exam : 70-175 - Designing & Implementing Distributed Applications with Microsoft Visual Basic 6.0

MCP Exam : 70-027 – Implementing a Database Design on Microsoft SQLServer 6.5

MCP Exam : 70-028 – Administering Microsoft SQL Server 7.0

TECHNICAL SKILLS :

Technology : ASP 2.0/3.0,PHP, .NET (ASP.NET,ADO.NET,C#,VB.NET),XML, MTS 2.0, MSMQ,

Wordpress,Bluehost

BizTalk Server 2000,IIS 5.0,COM+, PWS,Commerce Server 2000,ActiveX Components, XSL,XSLT, MS Visual Studio Express 2012, MVC 4

Scripting Languages : VB Script,Java Script,PHP 5.6,Angular JS,Bootstrap

GUI : Visual Basic 6.0/5.0

Hardware : Pentium, RS/6000

Operating System : Windows 2000, Windows NT 4.0, Windows 95/98, Unix, Sun Solaris

Databases : SQL Server 7.0/6.5/2000, Oracle 8i/8.0/7.0, DB2, IMS, MS Access,Mysqldb

Tools : Crystal Decisions (v8.5)/Reports 6/4.5, S-Designer 5.0, VSS,

Visual Interdev 6.0,HTML Help Workshop,TOAD, XSLT Tester,Microsoft Visual Studio .NET, debugger,JSFiddle

Source code control : Visual Source Safe,Wordpress file manager,BlueHost

Web Services : SOAP, Stripe API,JSON

Hosting Service : Github

LinkedInProfile : https://www.linkedin.com/in/prabha-sundararajan-70a01010/

EXPERIENCE:

Senior Software Engineer Haiti Project

Haiti Now, Miami Beach, FL

https://haiti-now.org/donate

https://www.haiti-now.org/new/donate/

Currently working on a non-profit organization Haiti-now for

designing and implementing custom Donation forms for One time and/or monthly payments using Html,php (server side coding)

integration with stripe server for submission to create customers,subscriptions and charge customers based on the donation amount for different kinds of credit cards using Stripe API and server side PHP coding.

Php 5.6,wordpress, javascript,Stripe, stripe dashboard,Stripe API,jsfiddle,jquery

Senior Software Engineer Global Higher Education

Completed Login and Registration modification for Non Profit company

http://www.gheo.org/

Php 5.6,wordpress,mysql db,javascript

Personal Website Hospital Management System

https://github.com/psrirajan/hospital

Developed a website using asp code,access database

Senior Software Engineer for Accenture

Microsoft, Hyderabad India

Projects

As senior software Engineer was the lead developer on the following projects

o URL Migration

o Edison Migration Framework changes

o Partner source : This is a portal available for Microsoft Certified Partners and Microsoft Business Solutions competitors. It provides up-to-date tools that help Microsoft partners increase sales, improve skills, and deliver superior service and products to customers.

o Customer source : This is a secure customer Web site from Microsoft Business Solutions where business get their customized information such as technical support, product updates, product downloads, training, events and more.

o Voice

o Microsoft Business Solutions http://www.microsoft.com/BusinessSolutions/default.mspx,

o CMS: Creating contents for Microsoft products using CMS Publisher, Author, Editor etc.

O Tested the system for production and live environments after making changes in the code.

Programmer/Analyst

CSX Corp, Addison, Texas

As a Programmer/Analyst, primary responsibilities included:

o Execution of Db2 stored procedures and creation of XML output using dbtools component .

o Creation of summary reports as RPT format using Crystal Decisions (v8.5)

o Creation of formatted report outputs using XML data and XSLT1.0, XPATH query.

o Testing the XSLT Stylesheets using XSLT Tester

o Processing the reports to MSMQ to generate the output through printer.

o Integration of the generated reports with .NET environment to get email link in either PDF or Excel format

o Schedule the reports using Report manager process developed in ASP, .NET environment.

Programmer/Analyst

Texas Instruments, Dallas, Texas

o As a programmer Analyst was responsible for the development and maintenance of web based Online Teaching application “Professional Development” (http://edresources.ti.com). This online resource Provides training for educators who are interested in enhancing the teaching and learning of mathematics and science through appropriate use of handheld technology. The programs offered are designed to keep teachers abreast of new developments in technology and new teaching methodologies using TI's wide range of educational technology, including graphing calculators and data collection devices.

o Lead developer of the PD Content Collection system, a system that collects and maintains the contents uploaded by the author using ASP SmartUpload and making it available for authorized users to download to their computers.

o Lead developer of Web store(http://epsstore.ti.com), which is a eCommerce site for the Educational & Productivity Solutions division of Texas Instruments. The site supports the sale of calculators, activity books, accessories, flash and computer software to both consumers and businesses worldwide. Most of the software sold is available for download directly from the site. The Store is also used to register attendees for seminars, gather customer information and distribute free software.

o Used Microsoft’s BizTalk Server 2000 for the document transmission and the

business process orchestration required to implement and integrate this system.

o Developed COM+ Object using Visual Basic for BizTalk Server 2000 Implementation

o Worked on Data Caching for improving the performance of the application

o Developed different forms of search for users to search required data

o Used XML, XSL with ASP for developing the web pages

Software Engineer

Integrated Enterprises Inc (IDE), Concord, MA, USA

IDweb is the first Internet-based development chain management (DCM) software that helps to align product development projects with business strategy. The system provides information to intelligently manage projects according to company’s criteria and measurements.

As a Software Engineer responsibilities included

o Development and maintenance of Idprojectview modules

o Responsible for the development of new features of IDresources module (R2.5) and resolution of

issues and fixing the errors in the earlier version as well as for other versions of Idweb.

o Involved in features testing and regression testing in the new feature Executive calendar of IDpipeline in IDeR2.5 in IE 5.0, Netscape navigator 4.7, SQL Server & Oracle databases. The Executive Calendar will provide the ability for an executive team member to actively manage their projects and track the progress.

O Used ticketing system for testing purpose to meet customer requirements

O Did manual and automated unit testing to check whether the code was working or not. Also did production and live testing by changing the urls of the production and live environments and pointing to different databases.

Software Engineer

SoftecRetail Systems Inc, Atlanta, GA, USA

OnTrak is one of the products developed by SoftecRetail Systems, Inc. This package is mainly designed to work with existing warehousing for retailers. Using retail industry standards, this system provide processing of warehousing shipments. System consists of components like system setup & maintenance, appointments, scheduling, Quality Assurance, inquiries & reports.

As a Software Engineer responsibilities include

o Design interfaces between different systems such as Access data base, DB2/400 and SQL server data bases

o Validate user input against the DB2/400 database before submit the batch process in AS/400.

o Create web based reports using crystal reports 8.0

Programmer Analyst

Beechwood Computing Ltd, Santa Clara, CA,USA.

As a Programmer analyst designed and developed the product ‘Discover System’ consisting of two main modules, Toolkit and Executive Information System. While the toolkit handled the creation and maintenance of models, the Information system module handled report and chart creation.

o Used Visual Basic 6.0 to design the user interface and the business logic and SQL Server 7.0 for the data services and the connectivity provided by ADO 2.1 library.

o Used S-Designer for conceptual and Physical data modeling.

o Used Third party controls including Farpoint Spread 3.0 and Pinnacle Graphics Server

o Used Visual Source Safe to track changes made to the system.

o Used MDX Queries for viewing the multidimensional data and customized the formulas which are used for calculations

Beechwood Computing Ltd, Santa Clara, CA,USA

Central Reservation System (CRS) allows for companies and Travel agents to process their online Bookings and Cancellations. CRS comprises Master, Package Tariff, Transaction and Reports modules.

Masters consists of Company, Room Type, Travel agent information.

As a Programmer analyst

o Developed reservation module with passenger details such as name, arrival date, departure date, room type, rate etc

o Coded Reservation module to allow individual hotels to upload the room statuses of each hotel to the centralized Server on a regular basis via internet that was previously updated through faxes.

o Reports module provide the user the capability to view and print daily, monthly or Yearly activity reports.

Programmer

Solutions 2000 International (Specialized Software), Worcester, MA (Apr 1998 – Oct 1998)

As a Programmer on Nationwide insurance, primary focus was in providing millennium date change services, consulting and software maintenance support. Principal responsibilities involved

o renovating and testing software programs using JCL and IMS databases

o Modifying the dates for year 2000 (from MM/DD/YY to MM/DD/YYYY ) that were in COBOL language

Programmer

DSRC, Chennai, India

As a programmer, was in charge of creating and maintaining the payroll management system which provided the employee details and their related transactions including loans, salary processing, educational upgrades, vacation records etc.

Main responsibilities include

o Process transactions like employees monthly salary, loan information etc.

o Use stored procedures and triggers to maintain data integrity.

o Use SQL Server to generate pay slips on specified dates by taking into account the grade, schedule and status of the employee.

o Generate reports such as monthly salary information, pay slip, PF statement using Crystal Reports.

Contact this candidate