WORK EXPERIENCE:

Sr. SQL Developer

Confidential - Seattle, WA

Responsibilities:

• Architected SOA framework, implements secure transactional enterprise data flow.
• Converted business requirements into agile engineering solution servicing business for 2 years without interruption.
• Using SQL Server instance designed databases and data services and implemented enterprise data center.
• Designed suite of CLR compression procedures for packaging of blobs without leaving SQL Server database.
• Implemented secure blob storage using SQL Server data encryption for large blobs.
• Implemented SQL Server Broker based robust data transfer handling, optimized for low bandwidth intercontinental network.
• Implemented Business Continuity and Recovery using Confidential SQL Server Always On technology. In addition:
• Crafted crypto routines in C++ handling highly sensitive operations.
• Designed suite of unit tests to exercise end - to - end architecture functionality.
• Documented system end - to - end
• Implemented system from the ground up, extending enterprise vision of data center as pizza boxes based suite of distributed networked machines.
• Implemented all components as scalable and configurable using configuration files for IIS based components and environment database service extended by data bus database.

Sr. SQL Server DBA

Confidential - Seattle, WA

Responsibilities:

• Designed new procedures, functions, SSIS packages for the databases encompassing Confidential Interactive with millions of user transaction load on - line service.
• Performance tuning for the company wide Transact-SQL lifting performance.
• Designed Data Mart and set of key metrics for tuning SQL Server based on SQL Server 2005 Profile trace collection.
• Cross team collaboration, bug fixes and interface development.
• Extended coverage for the Unit Test infrastructure of the product.
• Tools used: Visual Studio, SSMS, SSIS, SSRS, and overall SQL Server versions 2005, 2008, and 2012.
• Identified Transact - SQL changes for upgrade to SQL Server 2012.

Sr. SQL Server Developer

Confidential - Seattle, WA

Responsibilities:

• Redesigned procedures for bug fixes.
• Designed new tables, procedures, and triggers.
• Troubleshooting and debugging of production issues including database code and Web Services / Web Site ASP.NET.
• Bug fixes for build routines for SQL Server database.
• Designed modules tracking system usage using Server level triggers for SQL Server 2008.

Sr. SQL Server / .Net developer / System integration

Confidential - Redmond, WA

Responsibilities:

• Responsible for tooling and implementation of enterprise deployment.
• Designed services, infrastructure, and custom deployment package for automated backup and deployment of high value business objects - business rules.
• Researched Business Rules as a feature of Confidential Master Data Services. Found in depth capabilities at automation of backup, deployment and difference analysis between backup and deployed set. Convinced manager, and was given it back as a project to implement.
• Implemented automated deployment for table partitioning to scale up application. The key deliverable, set of reports, was built on top of existing well-honed infrastructure. However the implementation had a key difference. One of the key reports was built on top of a metrics consisting of hundreds of thousands of rows, as opposed to more common few thousand rows. This sunk performance and threatened deliverable. Automated deployment for partitioned database played key difference in speeding up queries. Performance change impressed on management team.

Sr. SQL Server / .Net developer

Confidential - Redmond, WA

Responsibilities:

• Architectural presentation using Visual Studio 2010 Ultimate edition ALM tools for data visualization to our team high level business managers.
• Designed features, bug fixes, level 3 production support for one of the critical IT company services.
• Infrastructure deployment automation scripting, with focus on database features.
• Designed new search algorithm, indexing data service, for historical data archive. Result was 5 seconds search response where prior implementation stopped working some time ago due to accumulated records.

Sr. SQL Server / .Net developer

Confidential - Redmond, WA

Responsibilities:

• Debugging for WCF services communicating with 3rd parties for product catalogue and opportunity service for OEM.
• End-to-end support for WCF services and integration into OEM infrastructure of WCF services.
• Designed Web Application front end modules communicates through WCF service with enterprise mission critical systems.
• Bug fixes and feature design for Web Application tightly integrated with company logistics and financials.

SQL Server Developer Lead

Confidential - Redmond, WA

Responsibilities:

• Design, and implementation of new functionality, hot fix and end-to-end product support for data intensive VLDB database, Data Warehouse. Led first iterative release with 6 hotfixes.
• Released new ETL line for the product designed with DTS and Transact-SQL.

SQL Server DBA

Confidential - Olympia, WA

Responsibilities:

• Design of SSRS based reports to monitor system health.
• Integration of environment using SOA approach with SQL Server SSIS packages written in C# querying enterprise services to supply daily status.
• Design of test plan and test cases for data integration.
• Platform performance evaluation from SAN to SOA.
• Application end-to-end performance tuning.

Sr. Design Engineer

Confidential - Seattle, WA

Responsibilities:

• Scaling up for Biz Talk server 2006 R2. In corroboration with development team designed and troubleshooting for Orchestration, main Pipeline serving company business critical application. At the start we were unable to move through 150 MB strong messages due to failing XML parser, causing internal Biz Talk server Web Service to silently fail. Exposed this limitation and provided solution.
• Biz Talk solution was implemented and integrated, B2B architecture segment was transmitting messages from partner site of any size free of issues.
• Designed suits of test cases based on project documentation.
• Implemented test automation harnesses in scripting languages, including Jscript, Excel, VBScript and C# covering

Software design engineer in test

Confidential - Redmond, WA

Responsibilities:

• Design of automated backup software running on tenth of servers concurrently both, to back up valuable data and restore group of servers to a known state.
• Design of test harness in c# using Mia ( Confidential UI harness) to drive back - end (web-services) through application calls. End - to end functional verification of features and bug fixes.
• Extraction of mission critical code modules from service architecture and design of harnesses for coverage test to exclude fault conditions at “design” phase before bugs impact application.
• Focus on impact test rather than quantity of logged issues.
• Design of test plan for service based telecom application.
• Troubleshooting of new modules for Bea Web - Logic written in Java for WCF based web service.
• Design of service JDBC upgrade layer to support new features on the back - end.
• Design of test cases, ongoing support of application running in lab for fault detection, troubleshooting, test, and resolution for the application layer running on Bea WebLogic.
• Design of test plan, test cases, troubleshooting of complex multi - layered application deployment.
• Code review for middle layer application code in Java with focus on performance.
• Design and planning of performance for multi - layer application, including analysis of transactional throughput from Web - Service call to database function at the planning phase. Design of high performance modules to support acceptable level of performance. Design and execution of test harnesses to support acceptable level of performance on the ongoing bases.
• Simplification of application tiers through redesign of service architecture. From disjoin per / transaction type service to Enterprise dispatch / back - end service architecture unloading bandwidth from unnecessary chatter and implementing caching where suitable.
• Significant input in application logging design.
• Designed test plan and responsible for the database test. Covered
• Setup, configuration and integration of all systemic level components at the database layer.
• Application reporting
• Performance and scalability.
• Ran Lab services supports entire test team.
• SQL Server subject matter expert.
• Pager duty team, design of hotfixes for production issues.
• Designed and executed end - to - end functional test for web service based telecom application.
• In close partnership with development group worked on implementing new core services of application making it resilient to failure, recoverable, and sustainable for an media rich application serving thousands of concurrent users on Internet.
• Decision making for hardware resource needs and optimization, input in database physical schema to improve performance.
• Designed set of KPI reports using Confidential Reporting Services and SQL Server Analysis Services on SQL Server 2000/2005 for real time application assessment in terms of number of concurrent users, delta of user activity. Designed ETL for real time report data gathering.
• Cross team collaboration to help test products for other teams and products People from other projects with complex requirements came and got help they needed to succeed on their projects. The assistance was from hosting databases on failover cluster to executing actual failover as well as design of appropriate test cases so that product can be thoroughly verified to work as expected under failover conditions.
• Designed long term plan for improving database testing and overall testing of the product including tools and methodologies.

Technologies used: Windows Server 2003 Enterprise Edition, BEA Weblogic Inc. SQL Server 2000 and 2005,; programming languages C#, Transact - SQL, Java, C++, XML, Perl, VBScript, Jscript, Powershell.

Software Test Engineer

Confidential - Redmond, WA

Responsibilities:

• Responsible in test for verification and technical implementation of aspects related to SQL Server for critical application release. Migrated platform from desktop level application to enterprise level scaling and performance. ETL time shrank from 10 days to 2.5 days with data volume increase 2X on the same. ETL error incidents were eliminated. The re - design proved to be the best from a number of competing designs and was accepted as competition winner as the result of our team effort.
• Led test cycles for mission critical application components including
• VLDB source Data Warehouse data validation.
• ETL cycle / performance oriented release.
• Application Server Full Functional Test coverage.
• Query performance tuning.
• Designed set of tools using C++, Transact - SQL, and Jscript using regular expressions for end to end automated BVT and regression.
• Platform: SQL Server 2000, Epiphany
• Member of selected engineering group dedicated to responding to critical issues in real time, available on 24X7 bases.
• Supported application users on the phone and via e-mail.

Software Design Engineer in Test III

Confidential - Redmond, WA

Responsibilities:

• Designed, developed, and implemented enterprise business intelligence components using DTS, stored procedures, triggers, tables, and views.
• Documented, and verified Critical Recovery Plan for high availability production back - end
• End - to – End suit of test documentation including test plan, test cases, test metrics, and automation using C#, Perl and Jscript scripting languages, Transact – SQL, and XML ( Back – end based on SQL Server 2000. )
• Maintenance, troubleshooting, and user support covering critical paths for entire application. Done so 24 x 7 when needed, working in team settings, with customer on the phone, email, as well as designed solutions and communicated with end user and their IT officers. Responsible for assets of the enterprise, earned commendation by management and respect of my peers for quality, speed, and volume of deliveries.
• Automation methodologies for both, back end and front – end including techniques for data correctness verification, and troubleshooting for performance and security. Both methodologies produced good results, the solutions based on this approach serving in the company in multiple departments from VLDB database to desk top applications at this moment.
• Verification routines covered
• ETL, Data Warehouse, OLTP front end with rich GUI web based interface, VLDB source Data Warehouse
• Troubleshooting and solving issues with email and networking.
• Tune – up for site back – end performance, both analytical data computing and OLTP, used tools.

Software Design Engineer in Test III

Confidential – Redmond, WA

Responsibilities:

• Design of architectural proposal implement delta processing for VLDB real – time reporting Data Warehouse. Proposed solution implemented as a prototype; enables the Real Time Reporting Data Warehouse to support growing source data set for the foreseeable future with current rate of adding new records.
• Due to enabling robust data processing this solution optimizes adding new records and updating existing records so that the data sets at this moment rebuilt in hours are rebuilt in a sub – second.
• The prototype implements data warehouse build journal, enables robust recovery of the data warehouse with the overhead from the point of failure no greater than the failed run.
• The data structures used in the prototype enable further optimizing SQL for the ETL process flow.
• Design and development of pilot project using Confidential Visio for process flow visualization using data driven multi – tier solution. Developed in C# using OOD methodology on the .NET platform including .NET interop assemblies, database designed for SQL Server, and middle tier implemented as a set of components.
• Testing for enterprise reporting framework including verification of complete reporting solution built from scratch.
• Design and documentation for test cases for verification of complete reporting solution.
• Test and test automation for application used for payroll and resource logistics
• Designed and developer test harness in Perl using Active State Perl 5.8 threads. Application is data driven with the web queries stored in database.

SQL Server Administrator/Developer in Test

Confidential – Redmond, WA

Responsibilities:

• Database development, debugging and tuning for procedures, triggers, functions, scripts, packages, and SQL Agent jobs; SQL Server security procedures audit and verification, code review, concurrency and locking issues troubleshooting and resolution, data cleansing, logical and physical database schema design, design and development of real time OLAP reports, test automation, reverse engineering and development of packages as needed in various languages to solve current application need, included RDBMS schema for OLTP/DSS/OLAP, troubleshooting web as well as rich client GUI, design of technical documentation; developed solution integrating LDAP for security, availability and enterprise level integration.
• Release engineer, sign off on complete application life cycle for a critical DSS real time reporting segment, including all phases of design and development for database, front end and integration with the on - line OLTP/SAP system, developed OLAP drill through reports using .NET Confidential Office Web technology using OOD methodology, as well as reports using Excel, and Access Confidential Office applications; back-end physical / logical schema verification and tune – up using Transact – SQL, Erwin, Lumigent Log Explorer; design of pilot applications using next generation of SQL Server - Yukon to verify potential improvements including scalability using direct call from SQL Server in the .NET assemblies.
• Designed and developed stored procedures in .NET compiled languages using .NET interop assemblies as well as web services.
• Performance tune - up for VLDB database, upped performance for DTS package executing ETL process loading Data Warehouse by 150%. Built test cases on functional and / or high level process specifications, resolved concurrency violation for VLDB Database / OLAP Data Warehouse for ERP / CRM financial transactions reconciliation reporting analytical system, built on SQL Server 2000 / On - Line Analytical Service for SQL Server 2000. VLDB consisted of hundreds of tables and thousands of stored procedures and ETL packages.
• Implemented advanced test automation using Transact - SQL Scripts, Erwin and scripting using VB Script / JavaScript.

Database Administrator / Developer

Confidential – Redmond, WA

Responsibilities:

• DBA / SQL Server developer. First task in the position was to fix critical bug in the new version critical production high performance, high availability VLDB database, application would stop responding when more then 5 concurrent users accessed the site. Discovered fix and implemented fix in the code and data structures, after additional tuning SQL Server became 5th performing back – end in the family of MSN web sites with peak performance of 2800 concurrent data fetches during NIP placements.
• Design, setup, and maintenance for Data Warehouse, troubleshooting and data cleansing using ad-hoc SQL and MDX queries. Developed and implemented automated mail application using DTS, VB Script, Transact - SQL, SQL Server 2000, Confidential Excel, and IIS Server 5.0 to clear stalled orders clearing up to $5000 per week; maintained site catalog content; critical personal and financial customer information, designed optimized transfer of data from legacy system into new system using system reverse engineering, original software manufacture design required 1,5 seconds for migration of every existing account, for our user account base of near 1,000,000 it was unacceptable, the custom ETL package written in Transact – SQL moved entire legacy data in 40 minutes.
• Executed successful hands-on disaster recoveries for the live site each under 5 minutes; setup of disaster recovery plan, back - up and archiving procedures, including design of physical schema of the SQL Server, performance gain from the re – design of the physical schema was 400% when moving very large files across WAN – a critical task for catalog content updates received during nightly batch process.
• Developed and implemented file transfer tool with hardened security in C++ using OO development for business partner and our team to secure nightly automated batch. Developed extensions, implemented and integrated catalog using Commerce Server 2000.
• Provided comprehensive site security audit, implemented more than 10 changes in platform kernel setup, later on these proved critical security hardening changes. Practices custom implemented in our project for physical database design and platform security hardening were so valuable that later they were installed as standard practices for the internal product support.
• Redesign and technical documentation for third party vendor application. The difference before and after the re – design
• Old transaction design: each transaction duration 7.5+ seconds, no more then 13 concurrent transactions new transaction design: each transaction duration 1.2 seconds, 100 concurrent transactions on a quad proc Dell.
• SQL Server white box testing, performance tune - up, test tool development and test automation, developed SQL Server database “help db” consisting of DTS package, more then 150 stored procedures, 35 tables; debugged set of data loading system scripts, Transact - SQL scripts for middle tier application logic test, tune - up of middle tier rc Unix stile start - up parameters, suite of SQL scripts automating resolution of performance related issues; developed ASP/IIS5 based web site using set of custom stored procedures / Jscript and VB Script to improve VLDB system capacity monitoring and administration; developed performance visualization tool based on Confidential Excel helped to assess in real time responsiveness of SQL Server for business transaction, each transaction consisted of more then 200+ individual SQL batches.
• Developed automation test routines troubleshooting application functional API layer using functional API specification, custom tool ‘runsoap’ using custom SOAP messages. Harness designed in VB Script, XML, and XSL-T.

Software Developer / Test Engineer

Confidential - WA

Responsibilities:

• Tutoring and setup of junior developers for multilingual development for Japanese.
• Authored self – installable MSI packages using InstallShield.
• Localized self – installable MSI packages for Confidential Demo for MCP/MCSE/MCSD for German, French, and Japanese languages.
• Authored enterprise deployment package using Install Shield 2000 for deployment of distributed application, including Windows Services, SQL Server database, and client. The package was designed to run from centralized network share enabling entire enterprise to manage deployment in a pain-free way.
• Implemented application for Transportation industry.
• Tested “Pricing engine” application running on Informix Dynamic Server On-Line 7.23. Developed and maintained comprehensive suite, about 3 megabytes of SQL code, for test automation in SQL / Transact - SQL. Go to person for installing application infrastructure.
• Debug, version control, documenting, implementation, and release of fixes as appropriate for very complex financial application implemented as a cloud web service as far back as 1995. It communicated via http protocol using raw TCP socket layer programmed using Rogue Wave extensions with Sybase database engine as a service point provider, Oracle as a super back - end, mobile micro database on the client; application offered rich front - end written in C++. Code base of approximately 12 MB including commercial source code libraries.