Resume

Sign in

Sql Server Engineer

Location:
Beaverton, Oregon, United States
Posted:
December 02, 2016

Contact this candidate

Specific Job Title

Database Administration Web Development Software Engineering

Qualifications Profile

Performance-focused and highly analytical professional, with extensive experience in the design and development of web and client/server business applications through Microsoft technologies. Adept in software life cycle, user interface development, database management, application conversion and migration, unit and system testing, bug fixing, and debugging. Recognized for keen attention to detail, adherence to standards, and broad-based technical knowledge; along with the ability to work on critical systems under time constraints and within fast-paced environments. Effective at establishing relationships and working collaboratively with various individuals from all levels and backgrounds.

Technical Acumen

Languages:

C#, ASP.Net, ASP, ADO.NET, VB, XML, HTML, XSLT, T-SQL, Bash and .Net based CMS

Databases:

SQL Server 2000, 2010, 2012 and Microsoft Access 2000/97

Platforms:

Windows 2000/2003 Server, 2016, 2008, 2008R2 Windows NT 4.0, Windows 95/98/XP, MS-DOS 4/5/6, Linux and AZURE

Tools:

GIT, Subversion/SVN, CVS, Visual SourceSafe, Visual Studio 2003, 2010 and 2015, .NET Framework 2.0, 4.0, and 4.5, MVC, SQL Enterprise Manager, SQL Server 7.x/2000, 2012 Tools, Microsoft Office 97/2000/XP, JIRA

Application Server:

Internet Information Server 5.0/6.0/6.1/7.0

Summary of Experience

Converting .Net web based application to Orckestra Content Management System (Open source .Net based web contentment management system) .NET based web application.

Installed VM, Orckestra CMS, ASP.NET and Git to AZURE. Implementing CMS to AZURE.

Played leadership role to design, development, and test and to ensure that HWDB is an easy-to-use, solid, well-performing, highly-featured HW inventory system in support to the CPS Team in maintaining and tracking inventories and other lab facilities with the stable 1.4.7 HWDB on the production site.

Executed system-level certifications for all POR OSes across all 2015 Data Center Group (DCG) platforms including Brickland-R, Greenlow, Grantly-R, Groveport, Purley, and Harrisonville.

Offered hands-on support to the CPS(Chipset Platform and Software) Team through the following initiatives:

Conversion of Access HVI to new application to HWDB web-based application in C# and ASP.Net; Used Scrum; and

Design and develop front and backend for HWDB, along with table’s relations and performance which were migrated from one database to another and from old version to new. Provide training to users and create documentation.

Support database requirements in multiple environments (development, validation and production site) for CPS Team

Responsible for the development of database objects using Jira, ER Diagram using Visio, Data analysis and SQL codes

Migration and integration of data between databases, from one version to another and in the Production site by using SSIS tool to perform the ETL operation.

Development of additional database maintenance plan for backup and recovery;

Executed Microsoft WHQL (This test process consists of running a number of automated tests) testing. Reviewing the results and then submitting the results. Which was included HCK and HLK testing on Intel Platforms.

Performed various responsibilities including:

Migration to new table structures and application of additional new relationships in SQL to accommodate key feature enhancements; Analyzed XML files for data import and export.

Design and development of Access database and application; Converted FoxPro application to Access Application

Executed unit testing and black box and white box testing on web based application.

Validation with AutoEye tool to capture and analyze video streams;

Wrote one Bash shell script for Nightly run and Documented test Prerequisites in Twiki System

Utilization and maintenance of bug database to encode bugs. Fixed bugs and created reports for different versions.

Converted two Cold fusion applications to .net web based Application.

Had major role in creating Crystal reports and All Shazam report to Crystal reports.

Have experience with Customer support for the back and front end. Depending on the user requirements implemented the back end (SQL Server) physically for HWDB Application at Intel.

Have worked with Multnomah County, ATSI, PPS for the Customer success/support and with other professionals Services teams.

Utilized C# to design and develop user interfaces and middle-tier components; as well as to convert Cold Fusion application to web-based and windows application and two Cold Fusion projects to C#.Net applications.

Drafted several stored procedures and views to create reports, transfer data between tables and from SQL server to Excel files, and clear-up tables; as well as using SQL Server 2012 and Crystal Reports for data analysis.

Performed validation tasks on multiple Linux distributions including Ubuntu, SLES, and Red Hat; as well as various graphics sub drivers including Open VG, Open GL, and DFB of Intel Sodaville (CE4100), Groveland (CE4200), and Berryville media.

Provided assistance to Human Resources, Criminal Justice Division, Budget, Sustainability, and Public Affairs Office in creating channels, sub-channels, articles, forms, and channel-contents; as well as editing their contents on their requirements in Content Management System (CMS).

Earned selection to serve in the lead role on Graphics Sub Driver Stereo (3D) validation.

Made major contribution to the development of CPS Team’s web-based HVI Database through the design, development, testing, and debugging of ASP.Net and SQL Server code.

Work History

Boly:Welch(Client eFoodhandlers), Portland, OR

Consultant 2016-Present

Intel Chipset Platform Software Group/Cloud Platform Group, Hillsboro, OR

Software Validation Test Engineer/Application Analyst 2012–2016

Multnomah County (GIS/Web), Portland, OR

Development Analyst 2005–2007

Aivea Corporation, Portland, OR

Software Design Engineer 2004–2005

State of Oregon, Health Department, Portland, OR

Information Systems III 2001

ATSI, Portland, OR

Consultant 2000–2001

Portland Public Schools, Portland, OR

Programmer–Human and Payroll Department 1999–2000

Comsys Information Technology Services, Portland, OR

Programmer 1998–1999

Education

Bachelor in Science

Calcutta University, India

Diploma in Computer Applications

Computer Professional Advancement, Calcutta, India

Associate of Applied Science in Computer Information Systems (CIS)

Portland Community College, Portland, OR, USA

Career Pathway Certificate in Computer Information Systems (CIS): VB.Net App Programming

Portland Community College, Portland, OR, USA

Professional Development

People Soft Development

Awards and Honors

Intel Corporation: Direct Report Recognition (2) Fellow Employee Recognition Direct Report Recognition



Contact this candidate