Objective:
To increase the quality of data and processes in just-in-time, six-sigma, and transactional environments and to assure process capability and integrity.

Qualifications:
Certified Six Sigma Green Belt
Certified Quality Technician - ASQ
Certified Mechanical Inspector - ASQ

Employment History:

Confidential, November 2010 - Present
Job Title: SQL Server Database Administrator

Job Functions: Perform backups, log shipping, mirroring, query tuning, index optimization, and other tasks related to Database administration on sql server 2005 Servers.
Create SSIS packages for ETL processes and file system manipulation
Design database schemas for new projects
Review and modify previously existing processes for efficiencies

Confidential, September 2007 - July 2008, April 2009 - May 2010
Job Title: SQL Server Database Administrator/Database Engineer

Job Functions:
Managed forty-four production and ten development SQL Server 2005/2000 servers and one 2008 dev (CTP) box.
Established Log Shipping and Mirroring
Replaced/Implemented Transactional replication (from merge)
Created various archival processes
Data Warehouse Integration
SSRS Administration and development
Created File management processes (flat files, spreadsheets)
Wrote procedures and SQL statements/jobs for Auditing machine and job configurations
Implemented SSIS over DTS and converted packages
Established machine load/stress testing procedures
Wrote Stored procedures for applications as well as management
Gathered information from Dynamic Management Views into central repository
Used Idera SQL Diagnostic Manager, SQL SAFE (for backups), and Lumigent AuditDB (for log scraping/ field value auditing)
Business Objects XI and Crystal Reports report creation and administration

Confidential, May 2007 - September2007
Job Title: Database Administrator

Job Functions:
Develop stored procedures, DTS packages, and functions in T-SQL on a 40 server, 120 database environment (SQL Server 2000/2005).
Perform replication and log shipping functions for various banking and other service databases;
Optimization functions including server space management and clustering/re-indexing, tracing queries, creating custom jobs and monitoring multiple databases' performance statistics and providing maintenance work where necessary
providing deliverables to Sr. management for projects including Customer Profitability Analysis as well as regulatory information requested by the Government's agent.
Used Business Objects Data Integrator for some ETL operations, DTS for most, and SSIS for a few new processes.

Confidential, September 2006 - May 2007
Job Title: Database Administrator

Job Functions: Administrator for four client benefits and claims data databases across the United States based on SQL Server 2000/2005.

• Perform all tasks related to database administration as well as development in VB script (maintenance plans, backups, log shipping, archival, trigger management)
• Utilized DTS for data migration and manipulation
• Provide Ad hoc and customary support for metrics in all geographic areas
• Provide Analysis of business metrics and present results to senior management
• Implementing Paperless environment based on automation of workflow and reduction of paper business requirements

Confidential, February 2005 - September 2006
Job Title: Business Analyst/Research and Analysis Supervisor

Major Milestones: Contributor: 2006 Texas Medicaid Provider procedures
manual;

Multiple claims processing automation initiatives regarding edit/audit
efficiencies, workload distribution, and manual rework/workaround
refining/improvement.;

Participated in over 120 service requests related to claims processing
system or new process creation;

Directed implementation of Activity-Based-Compensation (ABC) program
within claims services area; Performed all analysis related to production,
quality, payment rates, etc.

Job Functions: Perform analysis, planning, establishment of requirements,
functional modeling, development of procedures, development of functional
architectures, databases, and other data as required by management for the
claims services group.

Provide direction to quality assurance and research personnel with regards
to claims processing and program policy.

Provide instruction to key personnel as necessary on Six Sigma and quality
tools

Provide SQL query research and statistical production reporting using
Microsoft Office, Business Objects, iSQL* Plus, and TOAD software.

Created various databases housing claim specific information (Access, SQL Server 2000, Oracle 10g)

Created master QA database for housing adjudicator quality information (Oracle)

Perform analysis of user needs to determine functional and cross-functional
requirements for claims adjudication.

Perform allocation to identify required tasks for service requests and their
interrelationships.

Root Cause - Corrective Action program analysis and associated graphs and
charts

Interfaces with other departments in representing the customer in the course
of conducting interoperability assessments and implementation of
interoperability and supportability procedures.

Confidential, April 2004 - February 2005
Job Title: Supplier Quality Engineer.

Job Functions: Business Improvement/Supplier Quality Assurance
To date with this company I have been a member of three projects, two which
I have initiated, which have been responsible for the following:

Refining a pre-established return material authorization process that was
yielding a loss of $136,000 a year into a lean process that has reduced
cycle time on processing by 20% due to automation and yields a cost
avoidance of 130,000$ a year with most incoming RMA's being profit centers
(rework for outside customer).

Re-engineered a First Article Inspection process that yielded 1,283
incomplete/incorrect FAIs into a process that automatically flags these FAIs
in the ERP systems to indicate shipping status and inspection required;
Process was further refined to include new procedures for supplier
submissions and customer submissions as well as cycle time reductions due to
automation in processes. Total cost avoidance and savings totals 106,000$.

Establish a Material Review Board (MRB) for discrepant material; Previously
none existed and company was scrapping at a rate of 410,000$/yr. Now product
is efficiently dealt with in 48hrs and MRB inventory costs stay below goal
of 50,000$. Estimated scrap rate for year is natural variation of scrap
estimated to be 30 - 45,000$. All of these projects were initiated using six
sigma/lean tools and methodology.

Total Roll-up cost savings/avoidance ~ $646,000.

Review Incoming First Articles from suppliers and submit First articles to
customers

Perform document review and archival for quality department via
AGILE/ORACLE(ERP)/Internal devices.

Respond to internal discrepancies in assembly pertaining to outside vendor
product.

Member of Material Review Board (MRB) dealing with discrepant material from
internal as well as external suppliers for disposition.

Interpret blueprints as necessary for assembly/production personnel.

Generate new Operating methods and procedures as well as review existing
procedures for efficiency.

Member of six-sigma team investigating all internal processes for efficiency
statistically by using SPC and pareto analysis.

Member of Global Supply Chain Management group dealing with outside vendors,
procurement and logistics.

Confidential, May 2003 - December 2003
Job Title: Quality Assurance Auditor
Purpose: Meet or exceed all customer requirements through the on-time
delivery of high quality products developed through technical innovation,
continuous improvement, and a high level of employee involvement in a
just-in-time environment.
Functions:
Audit Business groups and departments based on ISO 9000 requirements.
Perform routine and non-routine audits of TSOP assemblies, systems and
related processes.
Perform routine audits of individuals to conformance with quality
requirements and procedures.
Perform machine qualification audits for manufacturing processes.
Generated appropriate information to be recorded on various data sheets.
Generated Non-conformance material reports and assisted with other quality
engineering functions.
Windows 95/98/XP, Office, and MS-DOS fluent.

October 2001- March 2003
Confidential
Job Title: Quality Control Technician.
Purpose: Responsible for inspecting Receiving, in-process, and finished
goods for conformance to Quality Assurance standards
Functions:
Participated in six-sigma teams to improve process flows and lean
manufacturing situations.
Performed SPC and pareto statistical analysis of said processes and
deviation.
Perform required inspection processes to approved procedures utilizing fixed
or variable measuring instruments to engineering drawings and
specifications.
Primarily inspected special, prototype and custom products as well as
tooling and process development pieces. Perform Visual inspection of surface
finishes to verify conformance to standards
Perform checks of product and documentation to verify proper machine set-up
and process operation
Document completion of inspection operation and record results on
appropriate data sheets.
Responsible for assuring equipment calibration and service prior to usage on
a shop-wide scale.
Inspect product packaging and labeling
Write Document Change Orders (DCO\'s) and Discrepant Material Reports (DMR\'s)
as required
Operate a Computer for various needs
Equipment/Machines Utilized:
Matsuura CNC Lathes
Fadal CNC milling machines
Zeiss-Numerex Coordinate Measuring Machine (CMM)
IMS Impact Coordinate Measuring Machine with Virtual DMIS programming
language.
Utilized CMM machines manually as well as with a compiled program to
obtain various dimensions.
Optical Comparator (1Ox to 100x magnification)
Various Hand tools (Micrometer, Calipers, profilometer, Gage blocks and ring
gauges, etc.)
Fluent in PC knowledge of MS-DOS, Microsoft Windows 3.1 to XP and other
associated programs.

August 2000 - August 2001
Confidential
Job Title: Production Engineering Technician/Machinist
Purpose: The Fabrication of Automobile Radiators, Oil compressor coolers,
tube and shell coolers, and other various heat-exchanging elements.
Functions:
Operated Various CNC and manually controlled machines on top of Computer
Aided Drafting and Design (CADD) and Computer Aided Manufacturing (CAM)
software.
Oversaw processes in the fabrication shop as well as the final assembly
shop.
Operated a Forklift for material movement purposes
Batched out raw material for usage in production efforts
Inspected in-process and final assembly work for conformance to requirements

Equipment/Machines/Software Utilized:
AutoCAD R13 through AutoCAD 2000.
Stryker FabCAD 2000 (CAM software)
DynaCADD 98
Workstation Pro
Wiedemann Motorum 5000 Pneumatic Punch Press with plasma cutting
capabilities (CNC operated) Accupress press brake (manual/CNC)
Shear
CNC operated 3 axis Milling Machine
Various hand shop tools
Manual lathe and drill press
Yale Forklift