Sales Sql Server

MARY AGAWU

P. O. Box CE*****, Tema 414-***-****

Email: *********@*****.***

SUMMARY

Microsoft Certified Technology Specialist with expert GUI design background and

•

expert knowledge of VB.NET, VB6, ASP.NET, DTS Packages, SSIS Packages, SQL Server

Management Studio, MS SQL, MySQL, Oracle, HTML, XML, CSS, Crystal Reports,

JavaScript, Visual Source Safe, Visual Studio.Net and very proficient in MS Office

Applications.

Strong Understanding of Object Oriented Programming.

•

Experience with Microsoft project planning.

•

Experience in building Desktop Applications and Web Applications from Design to

•

Deployment.

Experience in building databases from design to deployment.

•

Extensive design and programming skills, hands on experience and expertise

•

demonstrated in instructing courses in design and programming at beginning to expert

levels.

Skilled at building strong team environments and open communications: incredible

•

creativity and ability to acclimate to new technology and situations with ease.

Experience in working remotely.

•

Excellent data analysis skills

•

Excellent writing of business requirement and functional specification documentation.

•

PROFESSIONAL SKILLS

Programming Languages and Tools: Visual Studio.NET, C#, VB.NET, Visual Basic 6,

VBScript, Cold Fusion, HTML, XML, JavaScript, VBA, Visual Source Safe, Crystal Report,

Adobe Photoshop, Dream weaver, Visual Source Safe.

.NET Skill Set: .NET Framework, ASP.NET, Ajax Development, ADO.NET, MVC, and Web

Services

Databases: Oracle, MS SQL, MySQL, stored procedures, triggers, views, functions, DTS

Packages, SSIS Packages and MS Access.

Analysis/Design Methodologies: UML, OOAD, Unified Modeling Process.

EXPERIENCE

Database/Software Developer – working remotely, Accuid Systems, Accra 09/2013 to

present

• Analyzed requirements and designed and developed Database for the biometrics

solutions.

• Designed, created, implemented, maintained advance SQL queries, procedures, scripts

and objects.

• Designed, developed Software and Web applications for capturing biometrics data.

• The applications allowed data entry, editing of the data, bulk importing using MS SQL

and retrieving of the data.

The application allowed producing of reports and printing of reports.

•

Supported the software installations of these applications.

•

Provided technical support.

•

Technology: MS SQL Database, VB.NET, ASP.NET, MS Excel.

Programmer/Analyst, Johnson Controls, Milwaukee, Wisconsin 07/2008 to 02/2013

Incentive Compensation

• Implement sales and management plans, payment and Incentive for payroll processing

of Sales force.

• Support changing and business needs for sales and management plans.

• Support Online Statements for sales and management plans.

• Execute high priorities tasks as defined by the business.

• Provide support for the Sales and Management Admin team.

• Performed Disaster Recovery on applications to ensure timely and efficient recovery in

case of a disaster.

• Worked with business users to gather user requirements and write business

requirement documents.

Technology: VB6, VB.NET, VBA, ASP.NET, Visual Source Safe, Oracle, Unix, MS

Excel.,

Lead Software Developer, ServiceAlliance Application

• Designed new applications that automated the process of generating reports from Oracle

and emailed the reports to users from the distribution list.

• Maintained existing integration applications in Microsoft.NET, Oracle that interfaced with

ServiceAlliance.

• Prepared Installation requirement documents.

Technology: VB.NET, ORACLE, SQL, Excel, VBA, MS ACCESS.

• Wrote complex SQL queries, and scripts.

Programmer/Analyst, Healthfirst New York 10/2005 to07/2008

• Designed, developed and deployed a process (VB.NET, MS Access) which reads input files

in excel, text format used by the various department in the company for tracking workflows.

The input files are then reformatted to a file layout as is expected to be loaded into

Macess.exp (Workflow management system). These are worked on by business users as

workflows. Also in this process some files are created in a XML format to be imported into

Macess.exp as Service forms. The process also when run reads member, provider, and

vendor demographic data from the database which are used to created folder systems in

Macess.exp.Technology: VB.NET 2005, SQL 2000, Excel, VBA.

• Worked with the different object models in Macess.exp. Wrote vbscripts for importing to

Macess.exp. Worked with consultants in Sungard (Vendor for Macess) during the

implementation process.

• Developed a Medical Records Review Administrative Database application for the Quality

Improvement department to collect medical record review data for HEDIS/QARR and

MEDS each reporting year. The database is created according to NCQA requirements and

is audited by Healthfirst’s IPRO auditor. The application allows new encounter claims to be

entered into the database to be extracted as claims. Was fully responsible for the execution

of the project life cycle: database design, conversion and importing existing data, system

architecture, back end and front end development. Team Lead in the project. Technology:

VB.NET 2005, SQL 2000, Excel, VBA, Crystal Report

MS SQL 2000/2005 development: complex queries, stored procedures, triggers, views, and

•

functions for various applications. Provided advanced data and business analysis, day to

day data extraction, data quality checks, preparation of reports and data files for end users

and ad hock reporting and data delivery. Wrote scripts to automate data transfers between

files and databases. Converted DTS packages to SSIS.

Developed web based application using AJAX control toolkit which allows users to maintain

•

an email distribution list.

Designed, maintained new and existing applications in Vb.net, SQL.

•

Worked with users in various departments to gather user requirements and write functional

•

specifications for business users’ signoff before programming.

Interviewed and recommend on potential programmers.

•

Programmer/Analyst, Commercial Credit Counseling Services, NJ 8/2004–8/2005

• Designed, Developed and Deployed a Human Resource Application in VB. NET (Win Form)

with SQL Server 2000 as the database which is used to keep information about employees

in the company, track their personal days, vacation days and also check when they are

eligible for benefits. Also included in this application are a lot of reports which were created

with Crystal Reports. Used a lot of T SQL Statements, Stored Procedures, Views, Triggers,

and User Defined Functions.

• Create and maintain existing computer applications according to user needs using Visual

Basic (Win Forms), Microsoft Access, and SQL 2000 and Crystal Report.

• Discuss requests with users for clarification. Recommend modifications to enhance

usability or expand functionality.

• Work with various departments from system design and analysis to production status

• Perform help desk tasks in support of all user applications deployed in the company.

• Work with other IT staff to obtain department objectives.

Web Developer, Avtech Institute of Technology, New Jersey 6/2003 – 5/2004

• Designed and developed an Online Store using C# on ASP.NET platform with SQL

server2000 allowing Internet visitors to browse the online store and buy products online.

• Used the .NET technologies, and C# as the language to develop a Mobile Web Application

which allowed traveling engineers to access the status of calls made by customers.

• Created a Web Application using VB.NET on ASP.NET platform with SQL server 2000

which stored information about a company. This was password protected and it allowed

administrators to view, add, update, and delete contact information.

• Created and consumed Web Services using VB.NET, SQL Server and JavaScript.

• Created Component Object Models.

Web Designer, Webcrafts Inc. New Jersey 6/2001 9/2002

Designed and developed corporate websites, creating the look and feel to emphasize the

company’s expertise using HTML Adobe Photo Shop, Allaire Homesite, Dream Weaver,

Microsoft FrontPage, Cold Fusion, and Microsoft Access.

Edited and maintained websites using HTML, Adobe Photo Shop, and Allaire Homesite.

Gathered user requirements to produce project specifications and consulted with other

project leaders on user interface related issues.

Spearheaded the promotion of the site via search engine optimization strategies to

increase company name recognition and site traffic.

EDUCATION

Bachelor of Science, Computer Science University of Science and Technology, Ghana,

•

2000

Avtech Institute of Technology, Certificate in Microsoft Visual Studio VB.Net and C

•

Sharp. New Jersey, 2004

CERTIFICATIONS

Microsoft Certified Technology Specialist

Contact this candidate