SUMMARY

• 10 Years on Crystal Report and SSRS SQL Server 2005/2008 development, MS Access report.
• 10+ years on Relational Database Experience (SQL Server/T - SQL, ETL, DTS/SSIS, Oracle, PL/SQL).
• 9+ years on VB6.0, C#, VB.Net, VBA, ASP. Net, ADO/DAO, ODBC, COM, COM+ and HTM, etc.
• Proficient in development of complex T-SQL store procedures, DTS/SSIS package, tables, views, index in SQL Server 2005/2008 and in Oracle database.
• Proficient in Data Exporting, Transferring and Loading in SQL Server, MS Access, Excel, Text, CSV, etc.
• Participate and lead software projects, from design, develop, test, debug, maintain to implementation, in-Depth knowledge of software implementation with coding of embedded client server, Intranet and Internet application as well as re-engineering using many technologies.
• My expertise is to add value to any organization and interested for a challenging position having opportunities to work using cutting edge technologies.

TECHNICAL SKILLS

RDBMS: SQL Server2005/2008, T-SQL, DTS/SSIS Package, Oracle 9i/8/7, PL/SQL, MS Access, etc.

Primary Tech Skills: Crystal Reports 8.5/11, SSRS2005/2008, VB.Net, C#, ADO.Net, ASP.Net, Visual Studio.NET, Visual Basic 6.0, HTML, COM/DCOM, MTS/COM+, VB for Application (Word / Excel, MS Access, PDF), Adobe Acrobat 6.0 Prof., etc.

Development tools: MS Visual Studio, Visual Studio .NET, Access Control

Others Technology: HTML/DHTML, ADO/ODBC, OLEDB, Active-X, n-Tier, OCX, XML/XSL, DBF, CSV, Excel and Text, IIS, MS interDev6.0, Java/VBScript, Photoshop5.0/7.0, etc

Project Mgt. Tools: Microsoft Project, VSS, TFS, SVN, Power Point, MS Office, Outlook, Toad.

Operating System: Windows XP, Windows 2000, Client/Server, Windows NT/95, Unix and Solaris, etc.

PROFESSIONAL EXPERIENCE

Confidential, Plymouth Meeting, PA

Senior Report Developer and SQL Developer

Responsibilities:

• Creating, designing and maintaining a special mortgage reporting system in the both of crystal report v11 and SSRS 2008.
• Performance monitoring and tuning on all reports and SQL Server. Closely work with clients and provide technical support daily based.
• Creation, maintenance and monitoring of ETL (SSIS/DTS) packages in SQL Server 2008 to import the data from all related offices in USA.
• Writing and maintaining the stored procedures in T-SQL jobs. The jobs are included the data analysis, the data identifying, data mapping, reformatting, correcting and transferring
• Develop and enhance a special Mortgage software Destiny with Scheme language based on financial business logic.
• Writing technical documentation describing the development, coding, testing, changes, and corrections.
• Gather requirements from stakeholders, and write functional and technical specifications
• Work closely with the project managers to guarantee timely delivery.

Environment: SQL Server2008, SSIS, DTS package, SQL/T-SQL, Stored procedures, SSRS, Crystal report 11, C#, VB.NET, Scheme language, TFS, XML, XSLT, etc.

Confidential, Philadelphia, PA

Senior SQL Developer and Report Developer Consultant

Responsibilities:

• Portfolio Monitor (PM) project: Maintained the application to assist investment managers in Portfolio Risk Management and oversight by testing and monitoring the requirements related to portfolio holdings, such as percent net asset, market cap, attribute eligibility, etc.
• The project were included the data analysis, the data identifying, data mapping, reformatting, correcting and transferring by using SSIS package, T-SQL, stored procedures, SSRS 2008, C#, etc.
• Custom Statement Project (InesTier and Investran): participated in creating, developing and maintaining the project which was used by the funds of funds, hedge funds and their administrators to support both U.S. domestic partnerships and offshore, unitized investment corporations.
• This project can provide hundreds of the statements by integrate the complex Stored Procedures, SSIS package, SQL server2005/2008, Crystal report v.8.5/10, SSRS2008, Oracle, C#, VB6 and XML, etc.
• SubAdvisor Assets System (SAAS) Project: Maintained the project which was built to automate the calculation of these fees on a monthly basis.
• The primary providers of asset information are Sungard for domestic funds and BBH for global funds.
• The major software and technical were included the stored procedures, DTS package, crystal reports v.10, Visual Studio 2003, etc.

Environment: Crystal Report 8.5, 10 and 11, SSRS2005/2008, SQL/T-SQL, DTS package, SSIS, SQL Server2005/2008, Oracle9i, VB.NET, VB6.0, ADO.Net, ASP.Net, C#, Stored procedures, VSS, ADO, XML, Word, Excel, PDF, DBF, etc

Confidential, Philadelphia, PA

Technical Business Analyst

Responsibilities:

• Pull data from various source (MS Access, PDF, Excel, Word, CSV, DBF, TXT, etc), convert and verify the data, translate billing data concepts and import the data into SQL Server tables.
• Establish and maintain the SQL Server database, create tables, views, stored procedures/functions and DTS packages, and provide business analysis and technical supports.
• Participated in creating, developing and maintaining a large-scale life cycle MS Access project Framework to support business process to review, import, data verify, error check, summary report print and XML file export.
• Framework included the tables, queries, reports, modules and macro.
• Design and develop software by using VB6 to review data and move data between platforms and across the network.
• Documented all screen shots, functions and metadata.
• Prepare and deliver status reports to management.
• Design and generate summary reports to the delivery owner for review using Crystal report and MS excel. Generate XML File and transmit it to the CiT Billing System.
• Performance tuning and integration and testing of modules developed offshore for Confidential .

Environment: Crystal Report 9.0, DTS package, SQL Server, VB6.0, MS Access, VBScript, VSS, ADO, XML, Word, Excel, PDF, DBF, etc.

Confidential, Philadelphia, PA

Sr. Report developer and DB Consultant

Responsibilities:

• Oracle Database work includes: design and implement databases, transfer data between databases, create stored procedures/functions; provide the computer technical support.
• Involved in optimization of key modules in the code using a variation of client side scripting and server side coding. Performed unit testing and feedback. Documented all screen shots, functions and metadata.
• Healthcare Data Collector project: Involved in designing and developing a application by using the VB.Net, ASP.Net, ADO.NET, HTML, CSS and JavaScript, etc for Confidential providers collecting the consumer’s common information included demographics, medical condition, medications, medication details, activities of daily living, mental status, etc
• Resource Directory project: Designed and developed the life cycle project to help Confidential providers easily gather huge organization and consumer’s information, generate related reports and convert to PDF file.
• The application also allows consumers to create Bookmarks, link and URL on the PDF file. Meet with the clients of Confidential to Gather client requirements, define project needs and provide detailed plans.
• PROVIDER system project: Participated in creating and developing and maintaining the large-scale VB project, which stored details of more than 200,000 providers and their services.
• System ran on COM based Three-Tier application.
• Client Demographic system project: Implemented and develop and maintained the 3-tier project. Worked in a team environment to design, analyze, develop and test the application.
• Designed and normalized the Oracle database, wrote stored procedures, help the users of Confidential to create complex queries on the relational database.

Environment: VB6.0, VB.NET, ADO, COM/DCOM, MTS/COM+, Crystal Report 10/9.0, Oracle9i, SQL, PL/SQL, server2000, MS Access, ADO.NET, ASP.Net, HTML, VSS, MS Project, Adobe Acrobat 6.0 Prof., MS Word/Excel and Win XP.

Confidential, Flemington, NJ

Programmer/Analyst

Responsibilities:

• POTW Administration & Compliance System (PACS2000) project: Participated in creating and developing the life cycle, large-scale, N-tier (front end, business Com, data Com and database tier) Client/Server project for a City to help its customers manage compliance, and make informative environmental decisions.
• This project used VB6/Oracle8i under Windows NT server4.0/NT workstation 4.5. As a major developer, my responsibilities include: 1) communicate with manager; 2) direct software developer; 3) participate in creating DLL component files; 4) test project protocol; 5) participate in the installation of NT server/workstation, Oracle8 and SQL Server.
• The following and other techniques are also involved in the project: MTS2.0, ADO 2.0, ODBC, VBA, Stored procedures and Net8, etc.
• Discharge Monitoring of Report (DMR) project: Created the Internet client /server project for Department of Environmental Protection (DEP), Florida.
• The purpose of this project is to increase the effectiveness of DEP through providing a paperless data processing environment: uploading files and downloading files online for customer at local PC.
• The following software products are used in the implementation of this project: ASP, HTML/DTHML, JavaScript, VBScript, COM/DCOM, InterDev6.0, MTS, VB6, Crystal Report, and Photo Shop Pro5.0 was used as the GUI development tools, IIS 4.0 as the Web Server, Oracle8 as the database, and MTS2.0 as the middle ware.
• WDMS project: Involved in the development and maintenance of a large software, which is for wastewater treatment plants to effectively manage a comprehensive Industrial Waste Control program with significant savings on resources and costs, created by using VB5.0, SQL Server7.0/ Access7.0, DAO3.5, Crystal Report7.0, and Erwin, etc.
• Clean Air Information Management Systems (CAIMS) project: Participated in creating the large two-tier software, which designed for air emission calculation and permit/compliance monitoring for batch industry, was released for commercial use. Created by using VB5.0, SQL Server7.0/ Access7.0, DAO3.5, Crystal Report7.0, Document merge (VBA), etc.