Seeking Senior SQL Server and .NET Development position 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:
*Strong Verbal and Written Skills *Highly Analytical and Well Organized
*Data Normalization for OLTP *OLAP Star and Snowflake Schema
*DTS and SSIS for ETL *Report Design and Development
*Object Oriented Analysis and Design *.NET Development
Databases: SQL Server 2000/2005/2008 R2, DTS Package, SSIS, SSRS, SSAS, SQL Server Management Studio, Enterprise Manager, SQL Server Profiler, Informix, Informix-4GL, Oracle, C/ESQL, dBASE IV
Tools: Visual Studio 2003/2005/2008, ADO.NET, ASP.NET, UML, Visio, VSS, SSRS, Crystal Reports, ODBC, Rational Rose, and ClearCase
Operating Systems: Windows Server 2000/2003/2008, UNIX (Sun / Solaris), Linux, and DOS
Protocols: CORBA, TCP/IP, IPC, SIP, VoIP, SSL
Senior SQL Server Database Application Developer, 02/2009
to Current Ericsson – Plano,
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.
Environment: SQL Server 2005/2008, SSIS, SSRS, Windows Server 2003/2008, Visual Studio 2008/2010, .NET 3.5/4.0, C#, 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;.
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 Expression (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, 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.
Created ETL packages using SSIS to download files from SFTP server (utilized Winscp through Execute Process task), extract data from CSV files, and load it to SQL Server database, included error handling and data integrity constraints enforcement;.
Developed reports using SSRS, Telerik, FarPoint, and C#, ASP.NET, ADO.NET;.
Installed and Configured SQL Server 2008 R2 database servers, migrated databases from SQL Server 2005 to SQL Server 2008 R2;.
Configured and administrated SQL Server 2008R2 Reporting Services server users;.
Implemented procedures for database backup, restoration and optimization;.
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;.
Evaluated and recommended software / 3rd party tool to extract large amount of data from excel files with macros and graphs;.
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.
Senior Software Developer (Consultant), 03/2008
to 10/2008 JC Penney – Plano,
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.
Software Engineer, 04/2005
to 02/2008 Perot Systems – Plano,
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;.
Application Developer, 01/2002
to 01/2004 AEGIS COMMUNICATIONS GROUP – Irving,
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.
Software Engineer, 01/2000
to 01/2002 MCI WorldCom – Richardson,
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.
Application Developer, 01/1996
to 01/2000 AEGIS COMMUNICATIONS GROUP – Irving,
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.
MS: Computer Science,
University of North Texas - Denton,
Texas Computer Science
BS: Computer Science,
Hunan University - Changsha Computer Science