SUMMARY:

• 18 years experience with development, design, optimize and maintenance. 8 years’ experience with Business Intelligence (BI): SSAS\SSIS\SSRS, Online Analytical Services (OLAP). MDX. Cubes, data marts and data warehouse.
• 8 years experience with development, design and maintenance.
• 3 years development experience.
• 12 years’ experience in logical and physical data design, database programming, transformation, conversion, data warehousing, dimensional modeling and star schema.
• 10 years’ experiences in commercial BI reporting applications including Crystal Reports, ASP.NET and SSRS.
• 10 years’ experience in SSIS, Power Center
• C#\Visual Studio.NET: 6 years’ experience in programming c# in Visual Studio
• Java: 2 years programming J2EE, JDK using Eclipse, Tomcat, CVS.
• Apache Spark\Python: 2 - year programming experience.
• AWS: 3 years experience.

PROFESSIONAL EXPERIENCE:

Database administrator and developer

Confidential, Jersey City, New Jersey

Responsibilities:

• Maintenance the big (more than 10 TB) and busy databases servers and make sure them run well all the time.
• Design and maintenance database servers' DR plan by using windows server failover clustering on SAN system.
• Setup and maintenance sql server replication, log shipping and always-on.
• Design and maintenance database servers' separation (separate databases from one server to four different servers by function) also include develop and design communicate programs between different servers by using service broker and change tracking.
• Work with developers to design database objects (tables, views, procedures, functions, triggers...).
• Help and guide users to create efficient queries against on databases.
• Work with Security team to find solution to protect security information (customer address, phone number, Credit card number.,).
• Design and develop database maintenance plan (index rebuilding, performance monitoring, archive old data, database cleanup, database backup, windows and sql server patch installation).
• Design and develop database warehouse by using SSAS, cube.
• Work with system administrators to move all database servers from local data center to AWS.
• Guide and maintenance reporting system (SSRS).
• Develop data transfer ETL between different servers by SSIS.
• Move current data warehouse from SSAS to AWS by using Tableau, python, Redshift
• Build and management dev/UAT/QA database servers.

Technologies Used: Asp.net, C#, SQL Server, Oracle, Mysql, SSRS\SSIS\SSAS, Web ServicePython, Apache Spark, RedShift, AWS, Tableau

Database and software developer

Confidential

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures, functions, packages and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Worked with application teams to develop web-based applications by using T-SQL and PL/SQL.
• Develop ETL work flow to integrate different sources’ data (SQL, Oracle, Teradata) into DATAMART.
• Build report based on customers’ needs.
• Perform quality assurance and testing of database server (Oracle and Sql server) environment .
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Technologies Used: Power Center 8.5, Oracle, Sql server, Teradata, My sql, Asp.Net, SSRS, SSIS, Web Service, Unix, Shell Script, Bugzilla, Redmine.

Database and software developer

Confidential

Responsibilities:

• Design and create database objects: tables, views, indexes.
• Work with ASP.net team to develop web site by coding procedures, functions, triggers.
• Review and modify developers’ procedures and functions.
• Optimize and tune Procedure performance by using best practice.
• Develop report query web interfaces to produce business statistics reports.
• Gather needed data from database for business analysis using SSIS.

Technologies Used: Asp.net, C#, SQL Server, T-SQL, SQL Server reporting service, SSIS, Web Service.

Contract software developer

Confidential

Responsibilities:

• Designed and implemented application “DispatchBoard”.
• Designed and implemented Web application.

Technologies Used: Asp.net 2005, Ajax, Delphi, SQL Server 2005, DTS, Web service and WindowsXP.

D atabase and software developer

Confidential

Responsibilities:

• Oracle and Sql server database maintenance and development.
• Design and implement application “ShipMate”, it provides Invoicing, Sales Ordering and Inventory Control.
• Designed and implemented the ShipMate central database, including tables, views, and procedures.
• Implemented the ShipMate application.
• Designed and developed a web application for intranet user provides on-line invoicing, order entry and query

Technologies Used: SQL Server 2000, Oracle, Asp.Net 2003, Delphi, Rave Report, Java, JDBC, Linux and Windows.

Senior S oftware Developer

Confidential

Responsibilities:

• Design and analyze Search Engine system for Chinese full-text searching based on RDBMS(include Ms Sql, Sybase, Oracle and DB2).
• Communicate with customers to gather the fine requirements for the enhancement of system.
• Implement functionalities and develop modules.
• Design and develop search engine core and interfaces.
• Administrate database.

Technologies Used: Oracle 8.15, Sun Solaris, Ms Sql 7.0, Windows NT 4.0, WebLogic, IIS, Java, C/C++, JavaScript, PL/SQL, Sql, Procedure, Trigger, Exp, Esp, HTML/CGI, DB2, RS6000, Dynamic-Sql, JSP, DTS

Software Developer

Confidential

Responsibilities:

• Develop stock trading application which provides an Electrical Stock trading System for buying and selling stocks.
• Database coding such as: create tables, views, procedures, functions.

Technologies Used: Visual Basic, C/C++, Delphi, Oracle, Sql server, Sybase, Windows95/NT4.0.