Sales Project

Professional Summary

. More than three years of professional experience in IT industry

performing different roles.

. Sound knowledge of preparing project documentation, process documents,

user manuals.

. End to End SDLC project experience (i.e. business requirements,

testing, UAT).

. Advanced level knowledge writing complex SQL queries.

. Advanced level experience with MS Excel, MS Access, VBA programming in

MS Access, MS Project, MS Visio, MS Office.

. Higher level understanding of various software development

methodologies (SDLC) including Waterfall, Agile.

. Extensively performed unit testing, regression testing, UAT,

debugging.

. Hands-on experience with developing reports using Cognos reporting

tools.

. Excellent analytical and problem solving skills.

. Ability to multi-task and prioritize tasks efficiently.

. Attention to detail and quality focused.

. Strong follow-up skills.

. Excellent oral and written communication skills and ability to

interact with people at all levels of the organization.

. Ability to work independently as well as a great team player, with a

positive attitude.

Education

Master of Science - Management Information Systems

University of Illinois at Chicago (Cumulative GPA = 3.88)

. Bachelor of Engineering in Information Technology

Ramrao Adik Institute of Technology, University of Mumbai, India

Computer Skills

. Programming/Development Skills - C, C++, Java, HTML, VBA,

ASP(Basic),

JSP,

Servlets

. Databases - IBM/DB2, MS-

ACCESS, SQL, PL/SQL.

. Operating system - DOS, Windows

95/98/NT/2000/XP/Vista, MVS.

. Application Skills - MS Office(Access,

Excel, Word, PowerPoint, Outlook),

Visual Web Developer, SAS, TOAD,

SPSS

Clementine, MS Project, MS Visio.

. IBM Technologies - COBOL, VSAM, CICS, JCL

. Software skills - SDLC (Waterfall methodology, Agile

methodology), Use

case design (UML), data flow

diagrams, flow charts

Work Experience

. Database Administrator

University of Illinois Payroll Dept

Oct 2007 - Oct 2009

V Extensively involved in requirements gathering process involving

talking to end-users

V Create new forms, reports, tables, queries and modify the existing

MS Access databases

V Extensive knowledge of VBA programming: generate automated emails,

mail merges

V Creating macros using VBA programming in MS Access

V Run complex SQL queries off the payroll Oracle database using TOAD

to generate reports

V Analyze data in MS Excel by creating pivot tables, using advanced

formulas (vlookup, hlookup).

V Prepared user manuals, process documentation

. Intern

Microsoft Corp Aug

2008 - Dec 2008

V Collaborated with Business Managers of various units under the

Midwest district to identify issues and key performance indicators,

present solutions to leverage Microsoft's existing portfolio

V Cascaded the scorecard metrics across each Sales team based on the

sales revenue for each sales team

V Performed Gap/Opportunity Analysis on the sales data for each sales

team

V Built a power point presentation recommending the sales team based

on the various graphs, charts drawn from the opportunity analysis

results.

. Analyst Programmer

Syntel Inc (Client: Westfield Insurance)

Aug 2005 - June 2007

V Requirements gathering

V Programming using mainframe languages like COBOL, JCL

V Preparing test plans/test cases based on different scenarios

V Perform unit testing, regression testing

V Provided post-implementation support.

Academic Projects

. VOIP Application Aug 2007-

Dec 2007

V Developed a basic GUI to read IP addresses entered by the users

V Built a "Start Connection" button which initiated the VOIP

application

V This application was programmed using core Java programming

language and consisted of a transmitter and receiver which would

enable the VOIP application.

. Personal Health Application Jan

2008 - May 2008

V Developed a personal health website using JSP, Servlets, which

allows the user to create a personal health profile to measure

their daily vitamin & mineral content.

V It displays food groups and the nutrient content in each food group

(pulled out from the USDA Food Database) and the user can thus add

these respective items along with the quantity of intake.

. Web Data Mining Aug 2007 - Dec

2007

V Performed Data Cleaning, Data Understanding, Business Understanding

V Created a Data Model from the clean data using SPSS Clementine

V Prepared a recommendation for the client, based on the data

modeling results.

References available upon request

Contact this candidate