Post Job Free

Resume

Sign in

Customer Service Sql Server

Location:
New York, NY
Salary:
Negotiable
Posted:
June 04, 2015

Contact this candidate

Resume:

*

KELVIN OHENE ANIM-WIAFE

*** ***** ****, *** ***

NORTH BRUNSWICK NJ, 08902

Cell :732-***-****

Home Number :732-***-****

Email:acp1hl@r.postjobfree.com

Objective: To obtain a position where I can utilize my technical skills / management

/supervisory / training.

Education: William Paterson University, Wayne New Jersey

Public Health / Psychology Majors (2009/2013)

Anthem Institute, North Brunswick, New Jersey

Computer Networking and Security (2007 / 2009)

Achievements: Dean’s list for Scholastic Achievement from African African-American Faculty

& Staff Associations.

Position Held: President of the African Students Organization (UASO) (January 2011-2012)

Technical Skills

Excellent Excel skills, Word and Outlook

Skilled in creating and analyzing data with SPSS programming system using Anova, T-

test and Post Hoc test. (Applied Statistics)

Cisco Routers and Switches configuration and troubleshooting eg, VlAN, VlSM, ACL,

password encryption and Recovery.

Linux: Suse, Fedora Core2,administration and configuration Knoppix Live CD

troubleshooting

Microsoft Client Operating Systems including XP, 2000 Professional, Windows 9.x and

DOS

PC hardware installation, troubleshooting

2

Windows 2003 server Administration including DNS, DHCP, Certificate services, RRAS,

RIP, VPN

Windows 2003 Active Directory Services including management of network objects,

group policy deployment.

Exchange 2003 Installation and configuration, OWA, Outlook configuration

TCP/IP addressing and troubleshooting including subnetting, troubleshooting tools

Computer Forensics training with FTK and Drive Spy

Network Security Concepts including MD5 hash, intrusion detection, firewall

configuration.

Work Experience

Company: Credit Suisse Bank - One Madison Avenue, New York, 10010. March, 2008 –

October, 2010

Information Technology

Business Area: Technology Infrastructure Services

Installing and configuring computer hardware operating systems and applications;

Providing support, including procedural documentation and relevant reports;

Following diagrams and written instructions to repair a fault or set up a system;

Supporting the roll-out of new applications;

Setting up new users' accounts and profiles and dealing with password issues;

Continuously on a task until completion (or referral to third parties, if appropriate);

Prioritizing and managing many open cases at one time;

Rapidly establishing a good working relationship with customers and other professionals,

e.g., software developers;

Testing and evaluating new technology;

Conducting electrical safety checks on computer equipment.

3

Responsible for technical support for the trade flow.

Microsoft word, Excel, PowerPoint, Microsoft office Access, Desktop Support and

Computer troubleshooting.

Servicing printers, replacing lower voltage power supplies, clearing paper jams.

Replacing maintenance kits for all kinds of printers and printer cartridges also mapping

printers to servers with ip addresses.

Building and configuring computers for various departments and general computer

troubleshooting and repairs.

I determine and research user questions and resolve information system problems.

William Paterson University; 300 Pompton Road, Wayne NJ. November 2010 – August, 2011

Receptionist

Work at the Vice President and Dean’s office to help organize orientation, manage advisement

files and assist students.

Customer service skills, good communication with student who brings their problems to the

office.

Organization of inventory and answering phone calls.

Use of Excel, Power point, Microsoft Access and Microsoft Word to access documents and

send emails.

Cloudeeva Inc, 104 Windsor Centre Drive, Suite 300, East Windsor, NJ 08520. September, 2011 –

October, 2012

4

MS SQL Server Developer/SSRS/SSIS

The project is primarily aimed on tracking down the information of various customers and type of

plans at different locations. Worked with different data sources, databases to build SSIS packages.

Organized database from different firm sources to a single destination like SQL Server 2008R2.

Responsibilities:

Interacted with the users for understanding and gathering business requirements.

Designed a complex SSIS package for data transfer from three different sources to a

single destination like SQL Server 2008R2.

Implemented data views and control tools for guarantee data transformation using SSIS.

Successfully deployed SSIS packages with defined security.

Developed logical database and converted into physical database.

Proficiently created Reports based on the requirements using SSRS 2008.

Involved to write complex T-SQL queries and Stored Procedures for generating reports.

Defined parameters for parameterized Reports, and designed drill down, drill through,

cache reports using SSRS.

Designed and developed various Service Management Reports

Developed various Charts and Graphs like bar charts, line charts, pie charts etc. by using

chart experts for BI needs.

Involved in processing Report Subscription and created ad-hoc reports.

Successfully worked with Report Server and configured into SQL Server 2008.

Extensively worked with OLAP cubes to generate drill through reports in SSRS.

Responsible to monitor performance and optimize SQL queries for maximum efficiency.

5

Involved in the analysis, design, development, testing, deployment and user training of

analytical and transactional reporting system.

Used stored procedures, wrote new stored procedures and triggers, modified existing

ones, and tuned them such that they perform well.

Tuned SQL queries using execution plans for better performance.

Environment: MS SQL Server 2008R2, MS SQL Server 2008Rw Reporting Service, MS SQL

Server Integration Services 2008R2, BIDS, T-SQL, Windows XP.

WB Mason 21 Commerce Dr, Cranbury, NJ 08512, NJ. December 2013 – Present

Bulk Trainer

Bulking and setting up company products for shipment.

Responsible for items to be shipped to the right customer.

Training and supervisory of new employees in the company.

Christ Pentecostal Church Int’l, 1501 Livingston Avenue, North Brunswick NJ. October

2012 – Present

Technical Support

- Monitoring and maintaining computer systems and networks;

- Troubleshooting system and network problems and diagnosing and solving hardware or

software faults;

- Replacing parts as required.

6



Contact this candidate