OBJECTIVE

Seeking Senior SQL Server and .NET Development position

SUMMARY

Progressive and varied experience in SDLC (software development life cycle) for database applications in diversified industries such as IT Services, telecommunications, and retail companies. Possess excellent communication skills, strong customer support and troubleshooting skills. Recognized as a highly motivated, proactive team player, and problem solver. Other strengths include:

PROFESSIONAL EXPERIENCE

Confidential,Plano, Texas 2009/2 - Present
Senior SQL Server Database Application Developer
As a core developer in a small team within a fast-paced environment, provided solutions according to user requirements in a timely and efficient manner. Involved in full life cycle of software development including requirement analysis, system design, implementation, testing, deployment and production support.
Platform: SQL Server 2005/2008, Windows Server 2003/2008, Visual Studio 2008, .NET 3.5, C#, ASP.NET, ADO.NET, batch file scripting, FTP/Secured FTP

• Interacted with wireless network design engineers for business requirements, designed back-end database tables, indexes, created stored procedures, implemented Gold Standard Audit System using C#, ADO.NET, automated the manual audit process for array value parameters, single value parameters, range value parameters, greatly improved productivity. The Audit System is now providing daily audit of the ATT nation wide wireless network configurations;
• Designed intranet Web applications to upload and format check user input files with online update and validation, and to generate PDF/Excel reports with data extracted from databases, using ASP.NET, C#, ADO.NET, Visual Studio 2008;
• Designed and implemented a component used in web applications to populate data from large user input excel files(more than 20M) with C#, SQL Bulk Copy, ADO.NET and GemBox, extracting 10,000+ records from excel file within seconds;
• Experienced with stored procedure performance tuning using Execution Plan, DMVs and SQL Profiler;
• Provided performance analysis and identified index fragmentation, missing index; implemented nightly maintenance process to de-fragment index pages when necessary and notify users;
• Implemented procedures for database backup, restore and optimization;
• Evaluated and recommended software / 3rd party tool to extract large amount of data from excel files with macros and graphs;
• Created complex stored procedures, functions, views, SSIS and C#.net programs to extract, transform and load data from different data sources, including Excel, XML files and database servers;
• Utilized Common Table Express (CTE), dynamic column Pivot tables, ranking functions, outer joins and sub-queries for complicated data extraction and report generation;
• Experienced with stored procedure performance tuning using Execution Plan and SQL Profiler;
• Migrated databases from SQL Server 2005 to SQL Server 2008;
• Developed reports using Telerik, FarPoint and C#, ASP.NET, ADO.NET;
• Provided back-end data collection and mid-layer (web services) to access databases using C#, ASP.NET and ADO.NET;
• Participated in development of procedures and processes;
• Mentored other team members, provided consultation and advice, contributed to Code-Review.

Confidential,Plano, Texas 2008/3 - 2008/10
Senior Software Developer (Consultant)

• Designed ER diagrams and developed database on SQL Server 2005.
• Involved in database upgrade from SQL Server 7.0 to SQL Server 2005.
• Participated in requirement analysis, technical design for database server upgrade.
• Implemented and tested stored procedure modifications according to SQL Server 2005 Upgrade Advisor Report.
• Provided solutions to eliminate xp_cmdshell usages by using SSIS packages, SQL Agent Jobs and stored procedures.
• Experienced with data modeling and database design, data normalization.
• Designed and implemented credit card account number encryption/decryption application using ASP.NET Web Services, C# and .NET 2.0.
• Redesigned, developed and tested Salon Schedule Book Broadcaster - a windows service application, provided technical design documentations, implementation and unit testing using UML, C#, .NET 2.0, TCP/IP sockets, asynchronous and multi-threading technology.

Confidential,Plano, Texas 2005/4 – 2008/2
Software Engineer
Participated in system design, development, modifications, enhancements, and ongoing production support for an enterprise Data Warehouse system ( Enterprise Information System). The system extracts data from DB2 database, text files and mainframe hosts and loads them to SQL Server data warehouse using different Data Transformation Service (DTS) packages, ADO.NET, C# and provides reports using SSRS from both relational OLTP model and multi-dimensional OLAP SSAS cubes. Our team is also responsible for scheduling the packages using Batch files and SQL Agent jobs.

• Redesigned, implemented, unit tested database schema, stored procedures and DTS packages for CaseMix module, applied multi-dimensional Snowflake schema, reduced system runtime by more than 30%;
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
• Designed and created different ETL packages to migrate data from DB2 database and flat data files;
• Implemented scheduled polling for proactive incremental data extraction in SQL Server 2000 environment using SQL Agent;
• Configured SQL mail Agent for sending Automatic emails on Errors.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Created schema, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Designed and developed reports through SSRS;
• Provided solutions for customer requested automation and feeds using ASP.NET, .NET development for Microsoft Office, C#, greatly improved productivity and efficiency;
• Implemented and documented major changes for Labor Adjustments modules using C#.NET, ADO.NET, OLEDB;
• Interacted with client and application teams, coordinated monthly production release schedules, implemented production deployments;

Confidential,Irving, Texas 2002 – 2004
Application Developer
Lead designer and developer for Enterprise Information Support System, a company-wide operational data integration and report generation system that is capable of extracting corporate data from different systems and providing the single version of the truth reports in a timely and cost-effective manner (ER Diagram, T-SQL, SQL Server DTS package, Stored Procedure, Trigger, OLAP, Crystal Reports, Excel)

• Conducted data modeling and database design using ER diagram;
• Automated the enforcement of data integrity by utilizing triggers and constrains, reduced maintenance cost by over 50%.
• Streamlined and automated the report generation processes for improved efficiency using SQL Agent job scheduler, batch files, and DTS packages.

Confidential,Texas 2000 – 2002
Software Engineer (contractor)
Core Designer for FDBAudit, a remote database synchronization subsystem used in Redirect Server of WorldCom’s next generation product Voice over IP (C/C++, IDL, CORBA, Oracle, Rational Purify, UML, Rational Rose, UNIX, Perl, Korn shell scripting, ClearCase).

• Designed interface between FDBRemote and upper level subsystem using CORBA IDL, and prototyped the interface with C++ code.
• Utilized Rational Purify to debug run-time memory leak/corruption and took appropriate action to ensure availability of resources, reaching a new milestone one and half months earlier.

Confidential,Irving, Texas 1996 – 2000
Application Developer

• Designed and implemented backend data communication applications between Aegis’ DG system and Fortune 500 American Express’ system using C / C++, IBM-HLLAPI, SNA3270 and Client/Server programming. Increased the reliability of the backend communication server by over 30%.
• Developed Customer Relation Management projects for the company\'s major client. Responsible for the whole development life cycle including business analysis, application design and implementation (used C/C++, ESQL, Informix-4GL), testing and maintenance. Received recognition Award from American Express for top quality application delivery.

EDUCATION
MS in Computer Science.