SUMMARY:

• SQL SERVER development, ADMINSTRATION, data processing and ANALYSIST with exceptional abilities in Database application development and administration seeking related position.
• Proven track record of aggressively multi - billion records database data processing. Skilled in identifying and prioritizing problems and creating strategic solutions to meet company objective and business requirement.
• Hand-on database programming, administration, application design, development and maintenance with SQLServer 2005 BIDS, SSMS, SSRS, SSAS
• Strored Procedure with SQL, MDX, OLAP, Data Cube.
• XML
• VB/VB.NET/C programming, system maintenance.
• WebFocus report programming.
• Crystal report
• Hand-on UNIX with Shell script.
• Strong trouble shooting skill, independent working ability.
• Familiar to system life circle.
• Fluent Japanese/English/Chinese trilingual skill. Strong communication skill.
• Translate external requirements into a specification and design to expand business opportunities.
• Strong ability of working with multi-task, a good team player.
• Initiate projects with detail planning, budgeting and resource allocation and meet schedule on time.
• Energetic self-starter with creative mind and “can do” attitude. Highly confidence in an entrepreneurial environment.

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Programmer Analyst

Responsibilities:

• A leader role in development and maintenance of multi tier WEB application---MyPiers, an industry leading information intelligence system.
• Create data model accordance with business requirement.
• Build database tables, index and views from data model with SQL2005.
• Develop stored-procedures and functions for applications and for data analysis with SQL2005.
• Develop SSIS to implement data load with SQL 2005
• Design and create OLAP cube in data warehouse with SQL SSAS.
• Configure SSRS reporting server. Create reporting system with SQL 2005 SSRS.
• Create and maintain job schedulers with SQL2005/2008 job agent.
• As a key member working closely with architect manager to implement system design, enhancement and migration in system design and implementation in challenging environment.
• In charge of production of PRG, AMS, etc. Perform large-scale data processing. Transferring data among different platform like SQL, ORACLE, INFORMIX .
• Maintaining production Informix database, updating master tables, monitoring scheduled jobs.
• Performing data analysis and create various report with Crystal Report, SQL Reporting Service, Access and Excel for internal and external users.
• Developed and maintained production application with VB/Access/FTP and Crystal reports
• Work closely with customer support specialist to provide technique support and troubleshooting. Working independently to create operation procedure and other management document to improve work effectiveness and accuracy.

Confidential

IT Engineer, New Jersey

Responsibilities:

• In charge of mainframe banking system daily operation; performed START and END OF DAY operation, data back up and restore.
• Acted as a system administrator to perform user account management, kept close contact with TOKYO office to trouble shooting problems.
• Acted as a help desk to perform computer software, hardware, network support to assist banking business in large Confidential .

Confidential, Staten Island, NY

Director of Operation, Program Director

Responsibilities:

• Acted as a DBA when in charge of development of Group-Zero Balance Service supporting system.
• Performed database configuration, design, monitoring, tuning and daily maintenance.
• Developed and supported Group-Zero Balance Service supporting system with VB 6.0, MS Access 2000, and MS Excel, which created daily and monthly reports and tickets for Group-Zero Balance customers.
• As a team leader, developed an inter-banking transaction reconciliation supporting system with VB 6.0, MS Access 2000 which transfer data to oversea headquarter Office by FTP to import data to Confidential database. Participated in whole life cycle of development. Being in charge of system release and maintained.
• Having been in charge of daily opening and closing operation on Global System for banking business operation. Performed PC technique support and data analysis to business departments.
• Developed Reimbursement Database Management System with SQL2000, VB that enhanced reimbursement process speed, accuracy and reliability. Participated in whole life cycle of system development, including database design to system implementation.
• Worked on Cash Management Service related account analysis. Managed and monitored accounts for customers who subscribed CMS service like ACH, Lockbox, and Cash-Pooling, created reports for each customer.
• Created User Manual and Guide of the Web Application---Cash Management System (CMS). Participated in user training and technique support.
• Developed and maintained several applications like Government Regular Reporting System, Payroll Management System, which were developed with MS Access, SQL 2000 and VB6.0. Participated in business analysis, system design, coding and testing.

Confidential

Application developer

Responsibilities:

• Participated in the development of client-server type system of “Telecommunication Calling/Traffic Information Management System” with C and Confidential for a major telecommunication company of Japan (KDD). Participated in System design, module design, development, system testing.
• Developed B-Shell scripts to accomplish job schedule. Designed and developed common function. Created related document.
• As a key developer in "Data Fusion” software package development project, which is a simulation of environment software for air pollution, using VC++ and Map Object(Third party software). Participated in job analysis, system design, class design, coding, unit test, combine test.
• Developed "Electric Customer Commerce System (ECC)", a three-layer software package using VB, VC++, and Oracle DB, which are widely used as a Customer Service Support System by Credit Company.
• Helpdesk and technique support for a client company.

Confidential

Programmer

Responsibilities:

• Extended existing Landscape Design Support System used by civil engineering Consultant Company, using Confidential and C++ on UNIX. This application were able to present varies design by calculating and simulating on difference condition.
• Participated in developing Satellite Data and Graphics Processing System by using C on UNIX workstation. This system is applied to read satellite data to generate different kind of graphic
• Participated in developing Department Store Customer Management System using FoxBASE on UNIX.