Service Sql Server Manager Years Experience .Net
Resume:
Charlotte Lu
Email: ************@*****.***
===================================================
SUMMARY
* 8+ years experience of database application (Oracle and SQL Server)
* 5+ years experience of in-house application programming (C#, VB.NET, XML, XSD, XSLT, and Web Service)
* 4+ years experience of web development (ASP.NET, ASP, JavaScript, AJAX, HTML, DHTML, and CSS)
* 3+ years experience of Microsoft BizTalk 2006 R2 (Schemas, Maps, Orchestrations, BRE, Deployment, Administration and Operations)
* Self-motivated and results-driven
TECHNICAL PROFILE
Strong computer software development background including experience and training since 2000. Quick to master new technology. Able to increase productivity by quickly analyzing client needs.
* Programming: ASP.NET, VB.NET, C#, C++, C, SQL, Oracle, PL/SQL, XML, PHP, ASP, VBScript, JavaScript, AJAX, HTML, DHTML, CSS, MS BizTalk Server
* Environments: Windows, Unix
* Databases: SQL Server, Oracle, MS Access
* GUI Tools: MS Visual Studio 2005, MS Visual Source Safe, MS SQL Server Enterprise Manager, Oracle Enterprise Manager, TODA for Oracle IIS, MS VPC
WORK EXPERIENCE
G&A IT Solutions and Services Cincinnati, Ohio
System Analyst Oct-07 to Present
Major Projects
1. G&A Service Access and Astea Alliance BizTalk Integration Lighthouse Project
* Customer
* Employee
* Product
* Vendor
* Site
* ServiceOrder
* MiscReceive
2. Enterprise Integration Web Portal
* Transaction Searching
* Transaction Reporting
* Error Reporting
* Reuters Maintenance
* FAQ
3. Microsoft Visual Studio 2005 C# Applications
* BizTalkStatusChecking Window Service
* SAPBizTalkStatusChecking Window Service
* Cleanup AcK Files Window Service
* Restart Applications Window Service
* MetLife FlatFile Separator Window Service
* ERSFlatFileSubmissionService Window Service
* BtIntDailyErrReportingService Window Service
*SAP.ACKclasses
4. A&G SAP, Astea Alliance, Clarify, and BizTalk Integration Project
* MetLife
* Employee
* MiscReceive
* DirectTransfer
* VendorReturn
* Product
5. BizTalk Development, UAT, and Production environment setup
* Install Microsoft .NET Framework
* Install Microsft Visual Studio 2005
* Install IIS, SharePoint
* Install Microsoft SQL Server 2005
* Import Database tables, data, and stored procedures
* Install Oracle 11g Client
* Install and configure Microsoft BizTalk 2006 R2
* Install and configure BizTalk Applications
* Configure SSO
* Deploy/Undeploy and configure BRE
* Install SAP GUI
Expertise:
1. MS Visual Studio 2005
* BizTalk application development, test, and deployment
* ASP.NET Web development, test, and publishing
* C# application development and test - Windows Service, classes, and Web Service
2. BizTalk 2006 R2
* Schemas: Flat File Schemas, XML Schema, Envelopes, Web Service Schemas, Promoting Properties, Property Schemas.
* Document mapping: Functoids, External Assembly, Inline C#, Inline XSLT Template, Inline XSLT call Template
* Messaging: Receive Ports and Locations, Send Ports, Pipelines
* Orchestration: Shapes, Binding, Call External Assemblies, Exposing a Schema as A Web Service, Catching
* Business Rules Engine: Create Business Policy, Test Rules, Create Facts, Calling
BRE, Deploy and Undeploy BRE
* Adapters: Configure File, HTTP Sends/Receives
* Deployment: Exporting/Importing Applications, Deploying from Visual Studio, Enlisting and Starting Send Ports and Orchestrations
* Administration and Operations: Troubleshooting, Debug Orchestration, Debug Viewer, HAT, BAM Portal, BizTalk ExplorerOM, System Management
4. MS SQL Server 2005
* Create Database and Tables
* Create Stored Procedures, functions, triggers and Transact-SQL
* Call Stored Procedures from ASP.NET web pages and C# applications
* Maintain and improve database performance by using DTA, SQL Server Profiler, purging, and indexing
* Import and Export data; Create, save, and run Packages using Integration Service
Job Description:
* Design, develop, test, and debug applications independently and work with other team members
* Increase administrative productivity by using ASP.NET Web portal and C# Windows Service to monitor BizTalk application operations
* Improve ASP.NET Web site performance by configuring, coding, and database tuning
* Analyze user requirements and made custom enhancements for applications and tools
* Analyze business requirements; modify database and application accordingly to meet those requirements
* Create documents and user guides
* Support internal users and external customers
Fujitec America Cincinnati, Ohio
Programmer/Analyst Jul-06 to Oct-07
Major Projects:
1. Customer Contact System for Sales and Collections
2. Purchase Order System Drill-down to Receipt and Invoice
3. Action Tracking System
4. Customer Contract Management System
5. eShop Scheduling System
6. PDA Inventory System
7. Vision Map System
8. Repair Order/Service Maintenance Estimate Display System
Expertise:
1. MS Visual Studio 2005
* Developed, tested and published ASP.NET Web
* Generated reports by using Microsoft Reporting Services
2. TODA for Oracle
* Created Database and Tables
* Created Stored Procedures, functions, triggers and Transact-SQL
* Called Stored Procedures from ASP.NET web pages
* Maintained and improved database performance by purging and indexing
Job Description:
* Developed, tested, and debugged Web applications independently
* Increased administrative productivity by using SQL tuning and client scripting
* Analyzed user and business requirements and made custom enhancements for applications to meet those requirements
* Wrote documentation and trained users
EDUCATION
* BS with Distinction (GPA 3.81/4), Computer Information Systems, Purdue University, W. Lafayette, Indiana, 2002
* MS BizTalk Server Training, Cincinnati, Ohio, 2005/2008
* MS SQL Server 2005 Training, Cincinnati, Ohio, 2005
* Certificate in MS 5798 “ Concentrated Web Development with C# 2.0 and ASP.NET 2.0, Mason, Ohio, 2006
Contact this candidate