Sql Server Manager

PROFESSIONAL PROFILE

Over ** successful years in Information Technology with full life cycle

development, system integration and development of in-house application

systems.

Experienced in the analysis of complex Information System involving

software system design, development, maintenance, testing,

troubleshoots application, system administrator and some DBA tasks.

Experienced in the Telecommunication, Internet, Banking industry.

Proficient in supporting various DB Design/SQL, .Net Applications,

Object Oriented Programming, Java Application/RAD, HTML/XML.

Excellent programming and trouble shooting skills.

Experienced in using business, technology and application domain

subject matter expertise to analyze and translate business requirements

into technical system specifications and data specifications in various

documentations such as Standard Operation (SOP), System Requirements,

Transition Document, Implementation Plans, or/and Support Guides

TECHNICAL SKILLS

Languages PL/SQL, SQL*Plus, T-SQL, ASP, VB, VBA, VB Scripts, Java, Oracle

Developer 2000, C (Pro C, Quick C, C+, C HTML, XML, Clipper,

FoxPro.

.Net (C#, VB)

PL/SQL, other SQL Languages.

Report/Test Crystal Report, Oracle Report, R&R Reports Writer, Excel VBA, MS

Tools Access Report, SQL SSRS

Mercury Test Director, Quick Test Pro, Rational Rose.

Designing Tools Visio, Erwin.

Operating Windows 7/Vista/XP/2000/NT/98, HP Unix.

System

Databases SQL Server 2005/2008, Oracle 7x/8x/10G, MS-Access, FoxPro,

Sybase, LDAP, Dbases.

SQL Server SSIS, SSRS, SSAS

GUI VBA, Visual Basic, Access, Oracle Developer 2000.

Software Visual Studio 200*-****-****, IBM RAD 7

WORK EXPERIENCES

PRICEWATERHOUSECOOPERS, Washington, DC - 08/2008 - 01/2011

Sr. Associate, Application Technical Support

Troubleshoot/Maintain/Deploy/Support following Tax Applications to fix

issues such as: calendar date/month/year do not display properly,

wrong publication data, duplicate publication issues, selection of data

inaccurate/ not enough, publication scheduled started at wrong

date/time, VBA Excel Spreadsheet do not properly received and

processed, wrong format of VBA Excel Data Spreadsheet, personal

Publication subscribed do not display correctly and properly,

Publication displayed on the web page had wrong margins, customer SSN

do not match which lead to error in display for current selected tax

year documents, reports did not produce correct total numbers of data

selection, reports did not select correct data, VBA formulas did not

work properly and/or deleted accidentally by the users, automated

production job did not start or did not finish properly, change of name

for Production Servers (special project to facilitate the transition to

new data center) in all config files and .Net application codes,

Customer updated wrong selection of data, create/maintain users and

rights, Web pages did not display properly/correctly, Production

Servers locked and not responding to Users' request, Publication Owner

could not schedule for current week publications or select correct data

set for a publication scheduled, Admin Users could not manage

Publication/ Users/ Scheduled Tasks from front end website/web pages,

News panel did not display properly or could not find sources,

Publication Mail Servers stucked causing Production Batch Jobs stopped

and accumulated which slow down websites ...etc

.Net Applications: ClientLinks (Tax Subscription Management

system for Tax Practice), Tax Research Ascender (Tax Research

Tools across different Services platforms), Partner Allocation

System (PAS is a Microsoft Windows-based software application

that accounts for and allocates items of income, expense, gains,

and losses among Partners in a series of Partnerships), Tax

Engagement Letter (TELetter), Tax Equalization (TEQ), iPAC My

Briefings, UPAS Bridge, Resources EveryDay, PTMS (Property Tax

Management System) .net applications

SQL SSIS: Manage/Setup/Update/Troubleshoot Automated Production

Jobs for ClientLinks and Tax Research Ascender applications

SQL SSRS: Manage PFS Calculation Tools (Personal Financial

Services planning tools), TFS Reports Builder (web-based tool to

monitor DMS Usage, Project Status and Timelines), KM Metrics

(Knowledge Management Metrics report tools) Reports website,

create/maintain and allow users right to various reports

Other Excel VBA based applications such as IAS TDO, PFS Tools,

fActuary ...etc... Perform ETL process to import and process

production tax data from various VBA Excel Spreadsheet into SQL

Server DB.

Maintain, modify and troubleshoot XML content data models and

XML schema when needed

Perform research and analysis to troubleshoot, identify the root cause

and provide a complete resolution to production support issues.

Write enhancement codes to fix supported .net/VBA Applications and

other SQL Server/Crystal/Access/VBA Reports issues.

Build and deploy .net Applications' enhancements to stage and

production environment after received request from Developer Teams.

Use business, technology and application domain subject matter

expertise to analyze and translate business requirements into technical

system specifications and data specifications in various documentations

such as Standard Operation (SOP), System Requirements, Transition

Document, Implementation Plans, or/and Support Guides.

Maintain and update use cases, site maps, navigation models,

technical specifications, user interface specifications, screen

mock-ups/wireframes, lender briefs, release notes, and other

system documentation as required.

Based on current issues/handicaps of the supported applications,

prepare different analysis artifacts for new

features/enhancements to Business and Technology partner.

Perform detailed analysis of new features/enhancements in

response to business policy changes.

Use business, technology and application domain subject matter

expertise to identify impact of changes to cross-functional

areas and to prepare/submit a more effective and more efficient

performance improvement process.

Participate in various testing (smoke, regression, unit, performance,

details and complete different testing reports accordingly for

various bug fixes, Move-In Production of current or new Applications

using Quality Center.

Provide Admin Level supports using HP Service Manager Ticket System 7.0

SUNRISE SENIOR LIVING, McLean, VA. -3/2007-3/2008

System Analyst - Production Support

Maintain and support MERLIN (Management, Expense, Revenue and Labor

Information) using VBA, VB Scripts, ASP, T-SQL on SQL Server 2000

Relational Database

Perform database configuration and management

Troubleshoot/Enhance Merlin files using Excel/VBA

Troubleshoot systems and applications to identify and correct

malfunctions and other operational difficulties

Design/Develop new enhancement for Merlin files using VBA

Develop Automate Production jobs using T-SQL, VB Scripts/DTS

Packages on SQL Server 2000

Run Daily/Weekly Merlin Operations

Setup/Manage User Account, Communities, Access and other

miscellaneous daily User Support

Maintain and support FLASH REPORTING PORTAL (The portal is used to

capture occupancy and sales information from the field for weekly

reporting)

Setup/Manage Communities access

Update FLASH Reporting Portal to display new retrieved data

using VB Script/ASP

Enhance FLASH Reporting Portal future release using VB.Net/XML

Maintain/Enhance/Develop Automate Production jobs using VB

Scripts/DTS

Maintain and support FOCUS (Unified front-office system integrates all

Sales and Marketing information and workflow) systems using PIVOTAL

Enterprise Manager, eRelationship Enterprise Manager and eRelationship,

SQL Server Enterprise Manager, SQL Server Query Analyzer

Setup Test environment, update Production and Test environment's

BM (Business Modules) updates

Manage/Setup/Update/Troubleshoot Automated Production Jobs using SQL

Server DTS (Data Transformation Services) Packages/VB scripts

Provide 2nd and 3rd tiers level supports using BMC's Service Desk

Express Magic Ticket System

Participate in Test and Implementation for various Move-In Production

new/current Applications from current SQL Server 2000 to new SQL Server

2005 Projects.

Create/Update various documentations such as Functional Specification,

System Requirements, (Initial) Technical Proposal, various type

Flowcharts, Implementation Plans, and User Guides.

JCWS/IAPWS, Alexandria, VA. 06/2003-03/2007

Quality/IT Supervisor

Contribute to design/develop enhanced Automated PTOSS Billing and

Production System using VB Scripts, VBA/ Access/ Crystal Reports via

Visual Studio 2005.

Tested and reported the PTOSS System using Mercury Test

Director.

Performed ETL process to import data from previous year data

(from Excel Spreadsheet) into Access DB.

Wrote and enhanced test plans, test scripts. Test software upon

Test Plans.

Responsible to collected requirements from USPTO Officials and

translated into Technical and Contract Requirement Documents. Main

task involved in working on the conceptual redesign and documentation

of IAPWS system. Conducted presentation of the conceptual IAPWS design

to USPTO Officials and personnel.

Build and produced daily/weekly/quarterly/yearly Quality Summary

Report (QSR), GAP Analysis, Trend Analysis, Monthly Activity

Report (MAR), PTOSS and Employees Production Performance

Analysis Report, Internal and External Errors Report based on

daily production data, applications and mails received from

Applicant.

Performed analysis on various production and error data, provide

Trends Analysis, Root Cause Analysis and propose Solution to

solve the problems. Log and Reports Issues, Root Cause,

Corrective and Preventive Actions using CATSWeb.

Setup PTOSS Quality Strategic Plan, Quality Goals, Interim

Performance, and Timeline.

Lead team of 12 persons to conduct and maintain the continuing ISO

9001:2000 Certifications and the ISO 14001/18001 Compliance Program for

PTOSS Contracts. Standardized company's documentation (Forms/BPs/WIs)

according to ISO 9001 requirements.

Acted as Livelink Administrator to manage user and right to

access document and data in Livelink.

Reviewed, approved and uploaded to Livelink for document control

all documents, standards, operating policies and company

procedures.

Used Livelink to load Project Contract Requirements and Delivery

Status, and other ISO 9001 objectives of evidences to support

Project ISO 9001 Requirements.

Implemented and following Process Improvements for PTOSS to

improve services/process to satisfy increasing expectations from

USPTO Customer.

Equant /Global One, Herndon, VA. - 11/1998-2/2002

Sr. Software Engineer

Tested and reported in-house online WebALC System (version 2) using

Mercury Test Director.

Wrote/enhanced/updated test plans, test scripts. Tested

programs/systems upon Test Plans.

Created new system proposal and functional specifications documents

using MS Word, Oracle Forms, Oracle Designer, Erwin, MS PowerPoint 97.

Interacted with the Business Analysts to understand the requirements

and translating into Design Specifications.

Developed Access Database for new US Sale and Service Unit (US SSU).

Manipulated the system to Oracle using Oracle Designer, Visio 5.

Developed new front-end user for US SSU using VB6/Oracle PL-SQL/Crystal

Reports 8.0/Visual Studio to import customer and invoice data monthly

from four different systems, to calculate taxes and to produce reports

for all customer invoices.

Wrote detailed system requirement, functional design, test, and

user documentation for US SSU.

Acted as primary POC between engineering development and

operations.

Designed, and converted the US SSU System from VB6/Access to

VB6/Oracle environment.

Performed ETL process to import data from interim Access DB into

new relational Oracle DB.

Tested and reported the US SSU System using Mercury Test

Director.

Build and produce daily/weekly/monthly/quarterly/yearly Sale

Summary Report (SSR), Call Summary Report (CSR), Customer Call

Trend Analysis (CCTA), based on daily Customer Detail Call Data

and Sale Detail Data received from various Sale Offices

worldwide.

Designed and developed new front-end user menu for TCS (Travel Card

System) clients using ASP/Visual Basic 5.0/ Crystal Reports 8.0/Oracle

Reports and Oracle database to replace the legacy TCS using

Clipper/Dbase/Access database.

Tested and Tracked Test Report for the interim and new TCS

System using Mercury Test Director.

Design and create new relational Oracle and Access database,

created tables - established relationship between new tables

(determined primary output keys and foreign keys)

Perform ETL process to import/export data from legacy Dbase into

interim Access DB then into Oracle DB

Created and reviewed DDLs involving tables, views, triggers, and

stored procedures to new Oracle database. Other tasks included

performing data preparation for implementations and releases as

well as granting user access and privileges.

Build and produced monthly/quarterly/yearly Customer Call

Summary Report (CCSR), Customer Call Trend Analysis (CCTA),

based on daily Customer Detail Call Data and Sale Detail Data

received from various Sale Offices worldwide.

Enhanced actual programs using Clipper/Dbase III

Led team of 5 persons to provide operation support for Travel

Card System

EDUCATION SUMMARY

SQL SSIS, SSAS, SSRS - July 2009

.Net XML Web Services - May 2008

Oracle 10G, Crystal Reports v8 - Jan 2006

VBA, VB Script - January 2005

VB.NET - July 2005

Visual Basic 6.0 - Jan 1998 - Dec 1998

LDAP (Lightweight Directory Access Protocol) v3 - Dec 1999

Crystal Reports v7 - Oct 1999

Oracle 8.0 Application Developer and DBA programs - Jan 1999 to Aug

1999

Professional Diplomat in Computer Science (B.S. equivalence) - May 1992

Contact this candidate