Nelson Chan

**** **. **** *****

Las Vegas, NV **147

USA

702-***-**** (home)

702-***-**** (cell)

US Citizen

acu0nl@r.postjobfree.com

OBJECTIVE:

Data Analyst

SUMMARY:

Over 10 years of experience managing application design, software development, maintenance and delivery, and T-SQL.

Over 8 years of experience with ETL Data Loads.

Over 6 years of experience with SSIS packages and application servers.

Over 5 years of experience with Business Intelligence Development Studio (BIDS)/Visual Studio.

Extensive experience in computer programming for financial applications

Excellent technical skills and experience in a variety of applications and environments.

Especially good and highly adept at meeting challenges, analyzing and solving problems and completing assignments in a timely and efficient manner.

Exceptionally good understanding and analytical power.

Experience of years regarding Software Development in Account Receivable, Payroll, Finance and Collection Applications.

Experience of years in the field of Software Development Life Cycle to apply to information system development projects ensuring that all functional and user requirements and agency strategic goals and objectives are met.

Strong ability to interface with management and the users.

Very impressive communication skills.

In depth knowledge upcoming technologies.

Ethical, self-motivated, full of energy with the leadership qualities.

Involved in different activities of project such as information meeting, analyzing it, documenting business/functional supplies.

Wrote test-plans and test-cases of business procedure/application.

TECHNICAL SKILL SET:

Operating Systems: Windows 8/7, Vista, Windows XP, UNIX.

Programming Languages: C, C#, Oracle (PL/SQL stored procedures, functions, and triggers), MS SQL 2000, 2005 and 2008 (T-SQL, stored procedures, functions and triggers) SQL 2000 data transformation service (DTS) packages and SSIS (2005 and 2008), Visual Basic, VB.Net, Microsoft Access, VBScript and Visual FoxPro.

Scripting Languages: HTML, ASP, JavaScript, UNIX Shell Scripting, Microsoft Batch Scripting.

Tools: Visio, Ascential Datastage, Crystal Report, Microsoft Excel

ACD Call Center Software: Avaya, Symposium, Aspect.

EDUCATION:

Hong Kong College of Commerce Hong Kong

Accounting Degree

Clark County Community College Las Vegas

Associated Degree in Data Processing

Trinity College and University Sioux Falls

BS in Computer Science

PROFESSIONAL EXERIENCE:

Computer Programmer

Consultant Co Las Vegas, NV 2012 - Present

Ensures completion of project requirements in a timely manner.

Oversees project and software department budgets, managing multiple development projects simultaneously.

Manages code review sessions to ensure that best practices and procedures are implemented while recommending modifications and optimization.

Identifies bottlenecks in development process and facilitate usage of advanced technologies, new tools or enhanced processes.

Facilitates workflow, re-allocate resources, decrease project cycle time and ensure attainment of development goals.

Oversees creation of documentation and technical drawings used as manuals or guides for internal systems or external products.

Environment: MS SQL, Crystal Reports, Ms Excel, Windows 10, Visual Studio

Senior Programmer Analyst

HSBC Credit Card Service Las Vegas, NV 1998 - 2011

Facilitated meetings with users and management staff from different departments to understand system and business requirements. Analyzed current and projected data needs, resources and systems to plan new or modify current enterprise-level applications. Resolved conflicts from varied user needs. Determined applications requirements and define scope and content of new automated systems. Collaborated with programmers and data base specialists to conceptualize and develop new software design.

Prepared detailed specifications, flow charts and diagrams from which programs will be written. Designed data structures and application interface. Built software modifications, and wrote programs using appropriate languages; tested and debugged coded programs to verify proper functioning, data integrity and optimal performance. Determined if new applications meet the business and technology requirements.

Developed data model to support new or modified applications; normalized data. Developed and implemented (Oracle or MS SQL) database design; maintained data dictionary for application in cooperation with database administrators.

Oversaw quality assurance procedures for new applications. Reviewed new application software before implementation for compliance with standards. Coordinated with Information Technology staff to solve problems with system applications. Designed and wrote descriptions and functions of the applications and database code, recovery procedures and intervention methods. Compiled and documented program development and revisions.

Assisted users with existing systems and programs; solved complex software related problems; assisted with data transfers between different platforms. Coached users on newly developed systems and software. Prepared and updated user manuals and training materials.

Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management.

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS or Ascential Datastage.

Extracted, transformed and loaded data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using different connection by creating various DTS or SSIS packages or Ascential Datastage.

Participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.

Environment: MS SQL, SQL Server SSIS, SSIS Packages, Ascential Datastage, MS Access, Ms Excel, CSV, Flat File, Text Format Data, DTS, Flow Charts, Data Modeling, Oracle, Crystal Reports, Windows 10, Agile Methodology

REFERENCE:

Mr. Bob Barnowsky

Home Phone: 702-***-****

Lamin Jabbi

Cell Phone: 469-***-****

Rakash Bisen

Cell Phone: 702-***-****

Contact this candidate