Visual Basic Management

Alpana Singh

[pic]

**/*-* *** ********, Strathfield, NSW - 2135, Australia ( Mobile +61 4 0369

9787)HHH

Date of Birth : 07 June 1979

Summary Demonstrated achiever with exceptional knowledge of IT System

Analysis and Programming across the globe.

Skilled at learning new concepts quickly, working well under

pressure, and communicating ideas clearly and effectively.

Extensive Information Technology training, including

knowledge of multiple networking environments and business

software packages.

Flexible and willing to go the extra mile for success of my

team.

Education Class X - CBSE Board - St Paul's School, Gwalior,

India (83%) 1995

Class XII - MP Board -Hajareshwar School, Gwalior, 1997

India (82%)

Bachelor of Engineering in Computer Science (74%) 2001

MITS, Rajiv Gandhi University, Bhopal, India

Certifications Sun Certified Java Programmer (95%) - Sun

Microsystems Inc., U.S.A. 2005

Software Quality Testing - SQTL, India

2008

Career History & Accomplishments

System Support Analyst, Macquarie Technology June 2008

Services (Macquarie Bank) Australia. - Current

Create and maintain periodic and ad-hoc reports Date

across all areas of the business, and provide data

for the analysis of the business performance

Maintain and develop enhancements for current

systems such as the WMS, Oracle and other internal

systems

Develop new systems and tools, and enhance existing

ones, in order to improve the operational

efficiency and accuracy of the business

Monitor and maintain the integrity of the data

within all systems within the business and provide

resolution to data-related issues

Monitor and maintain the integrity of the data

within all systems within the business and provide

resolution to data-related issues

Manage and participate in IT projects within the

business

Provide consultation over general or specific

IT-related issues within the business

Provide and manage general in-office IT support

Liaise with Macquarie ISD in relation to bank-wide

IT issues such as network and email access, and

general business infrastructure needs

Requirement Gathering, Design, Development and

Testing of Applications related to warehouse

management systems.

Auditing of business management processes.

Database and Reporting Administrator, Unilever UK Oct

To manage and update AMP's & OPSO evaluator data 2006-May

To ensure complete integrity of data in the above 2007

systems

To create and produce standard and ad hoc reports &

basic analysis of Promotional Evaluation

information in OPSO evaluator

Work with CM Finance and CM teams to ensure all

base data in AMP's & OPSO is correct.

Work with CM Finance and IT to ensure swift

resolution of user and systems issues

Make any development changes required in OPSO

evaluator

Manage any repackaging, testing and maintenance

projects for above systems.

Ensure all personnel are trained and supported in

their use of the above systems

Maintain training documentation and user guides

relating to both promotional evaluation systems and

processes

Liaise with trading execs/AFMS and BGFinance

Provide consultation on Customer Management Systems

& data, Reporting requirements, system information

input and system interface issues.

Database Developer, Equal Brighton And Hove Aug

,Brighton & Hove Council - UK 2006-Oct

Gathering requirements to design and develop 2006

databases from scratch in MS Access.

Design reports and build front-end screens in

Visual basic.

Creating Quarterly reports in Access and formatting

it in excel using VBA depending on the customer

requirements.

Data Analysis

IT Support Analyst, Allied International Credit Jun

Corporation, Phoenix - AZ (USA) 2005-Feb

Gather and analyze the business requirements of 2006

Allied International Credit Corporation (AIC) for

streamlining their business operations.

Design, development, testing and deployment of

software applications. (Java, IIS Server, ASP, MS

Access, Visual Basic, Excel, AS400, Query 400)

Awarded the top Fresher worker award at the AIC

Corporation for all five branch locations across

the world.

Provide IT Support to other branches of the

company(installing hardware and software)

Business System Analyst and DB Administrator, Apr 2003-

Connecticut Department of Environment Protection, Mar 2004

Hartford - CT(USA)

Analyze and map (MS Visio) the business process of

Connecticut Department of Environment Protection

(DEP).

Gather requirements for developing a central

database application for the various activities

within the department. (MS Access, Visual Basic)

Develop the central Backend Database from scratch

and develop the Visual Basic front-end for the

various divisions of the DEP.

Define and implement the various interfaces,

back-up and recovery systems for the central

database.

Lecturer, Government Women Polytechnic College, Oct 2001

Gwalior - India -Feb 2002

Delivered lectures on Object Oriented computed

languages: C and C++, Computer basics and

internals.

Conduct monthly and yearly tests and evaluations.

Lecturer, Sophia College, Gwalior - India Jul 2001-

Delivered lectures on Computer Operating Systems, Oct 2001

Microsoft Office and Advanced Mathematics.

Conduct monthly and yearly tests and evaluations.

Skills

Programming Language: Java 2, Servlets, JDBC, JSP, EJB, HTML,VBA, Query 400,

ASP.NET, XSLT, Visual Basic.

Databases: MS Access, SQL Server 2005, Oracle 10i

Operating Systems: Windows NT, Windows 98, 2000, XP, AS400

IDE : NetBeans, MS Visual Studio 2003

Server : Tomcat, Weblogic, IIS Server

Tools: Microsoft Office Suite, Microsoft Visio, Oracle Sales Analyzer, SAP

R3, Toad, WinRunner, QTP, Oracle Discoverer, Crystal Report

Testing : Test Strategy & Plan creation, Test Case creation and execution.

Memberships & Affiliations

1. MP Government Merit Certificate for securing high position

in Higher Secondary School in 1997.

2. MITS Scholarship from Fall 1998-Spring 2001 for

undergraduate education

3. Ranked 1st in Computer Engineering Dept. 1998

4. Member of Cultural Committee of Madhav Institute of

Technology and Science, India

5. Coordinator of college function in 1999

6. Member of Rotary Club

Vendor Trainings

1. Java 2 Enterprise Edition using Weblogic Server - Sep 2007

(karROX Technologies Ltd.)

2. Advanced Java Programming - Sep 2007 (karROX Technologies

Ltd.)

3. Software Quality Testing - May 2008 (SQTL)

4. Demystifying ISO 9001 - Jul 2009 (SAI Global)

5. BSB51607 Diploma of Quality Auditing - Sep 2009 (SAI

Global)

6. RABQSA-AU Management Systems Auditing - Sep 2009 (SAI

Global)

7. Project Management - March 2010 (AIPM)

Contact this candidate