Summary

• Highly motivated and experienced MS SQL Server Developer/DBA with extensive design, analytical, problem solving skills.
• Technological Proficiencies
• Database: SQL Server 7.0 /2000/2005/2008, ORACLE
• Programming: SQL,PL/SQL, T-SQL, Pro C, HTML, Visual Basic 6.0, Active Report.Net
• Oracle SQL Tool: TOAD, PL/SQL Developer
• Data Modeling Tool: Visio, PowerDesigner

Work Experience

Confidential

Provide SQL Server database administration and architecture support in addition to providing development support for customer web site and reporting application. Work with developers to design new tables to support new features of the system. Provide query performance and tuning, server objects such as tables, views, procedures and indexes. Participate in database design and develop SQL stored procedures, functions and jobs for business application. Use SSIS to transfer customer data into Vnomics database.

Confidential

• Rochester Genesee Regional Transit Service provide public transportation over Monroe and nearby 7 counties. My main objective is to implement the TIDE Technology Initiatives fro Driving Excellence related initiatives. This program intends to provide a technology foundation for the next decade of customer satisfaction and operational excellence.
• Provided technical direction for the development, design and system integration from gathering requirement phase through implementation. Interviewed vendors, reviewed RFP and made recommendations on software in support of business.
• Worked with users and vendors to implement 3 new systems at the same time and manage technical risks throughout the project. Had a thorough understanding of each system and the data structure and worked with the vendors to integrate all the systems. This included creating new procedures and complex sql queries, views, triggers and used SSIS to transfer data among systems. There were a mix of systems using Oracle 10g, SQL Server 2000 and SQL Server 2005. Plan and co-ordinate data migrations between different ERP systems.
• Provided database administration and support to all the newly implemented systems.
• Created required reports to support business needs. The reporting tool is crystal report.

Confidential

Confidential is a start up company providing web site design and hosting for small retailers. The database infrastructure is based on SQL Server 2005. Duties included designing and implementing database, writing new stored procedures and queries and modified existing queries to improve performance. Designed and implemented SSIS packages to transfer data from different outside sources to SQL Server.

Confidential

• Designing, developing new projects and supporting the current data warehouse, using the SQL Server 2005 as platform to capture the retail volumes of the each alcohol brand sold. The source data came from Oracle, DB2 and text files from outside vendors.
• Working collaboratively and effectively with the reporting team, using Cognos 8 to create the reports from the data warehouse. Helping them to create views or SQL statements. Acting as primary database administrator, reviewing existing data model, procedures and DTS packages to identify opportunities for performance tuning and improving daily loading process.

Confidential

• Involving in all stages of developing a new Private label reporting system, which included gathering requirements, designed database model, developed procedures and DTS packages, deployed and implemented into production.
• Working with DBA group to improve the performance of the stored procedures and DTS packages, also created backup plan and job schedules and process to restore the database when the system had a problem.

Confidential

• Gathered information from the Origination system Oracle based and Diploma system Mainframe based with VSAM files and loaded the data into SQL Server 2000 database. Designed and turned the reporting database. Worked with customers to determine requirements and generate reports using Actuate Report as reporting tool.
• Re-designed and built new DTS Packages to transfer data from Oracle to SQL Server 2000, which included building new tables, stored procedures and views. Updated the reports, which were written in Visual Basic to use the new database.

Confidential

• Gathering user requirements created or modified existing database to support the project. Developed stored procedures, DTS Packages, triggers, and queries for reporting and administration tools for internal customers.
• Creating deployment plan and installation scripts for new tables, indexes and stored procedures. Managed security and assigned user permission to determine who would access the application that needed the database.
• Handled performance tuning at the query and index level. Used execution plan to determine where the indexes could be built to improve performance. Used profiler to determine where poor running queries were.

Confidential

• Implementing Oracle ERP manufacturing system to replace the legacy system. Designed and built a data warehouse using Oracle database based on star schema to store daily transaction data. The ETL process was written in PL/SQL.
• Using Oracle Discovery and Oracle report to generate reports for customers.

Confidential

• Developed the Web for Executive product including both BANNER and PLUS system. Worked with business analyst to determine business requirements and rules. Worked with DBA to architect and build the data warehouse using Oracle database based on star schema. Developed the ETL skills to load and cleanse data using SQL Loader and PL/SQL. Created meta data tables. Designed and developed the web user interface to display OLAP data using PL/SQL and JAVA program.
• Developed the Plus2000 Web for Students product, which allowed students access their data on the web. The product used a 3-tier architect, which included the main frame as the server, TouchNet software as the communication middleware and the web page as the client. This software provided an interactive Web interface for student application, class registration and academic overrides. The system was able to pass data from the host system to the web page as well as received data to update the host. Designed and developed client web pages using HTML. The web pages were tested in multiple platforms using UNIX and NT as the web server.
• Tested and maintained the EPOS voice response systems for both BANNER and PLUS. Designed, tested and maintained the kiosk system for BANNER using Pro-C and UNIX as hardware and PLUS using COBOL and VAX and IBM as hardware.