Assignment with - Hyundai Kia America Technical Center, Inc. (HATCI)Responsibilities: Programmer Analyst / Technology AnalystDatabase and Patent Technology SupportSupport patent activitiesBuild and enhance tools for data analysisAttend automotive/technology conferencesReview technology and research reports

Performed business analysis and application development. Managed government audit oversight, contracting administration operations and compliance activity. Evaluated DCAA/DCMA requests, RFP/RFQ's, Contracting Terms, IT Systems and FAR/DFAR regulations for impact and risk assessment. Managed IT for the contracts and program office departments; computer equipment, assignment of privileges, organized upgrades, evaluate software and services needs with minimal downtime. Developed data-driven applications writing SQL functions and procedures to capture data, manage integrity and enable real-time metrics and reporting. Lean Six-Sigma Green Belt & lead for department for all continuous improvement.

* Lead in Contracts for DOD Cybersecurity data requirements for management of non-classified data from customer handoff through all levels of the supply chain.* Cross-Function team lead for continuous improvement projects produced savings > $100k, reduced waste, improved workflow, product delivery and team based communication.* Lead in Contracts for enterprise Continuous Process Improvement Team for oversight & management of all enterprise process improvement projects* Maintained critical business functions – company expert for SAM.gov certifications and lead administrator for all CAGE registrations – crucial for government contracting* Responsible for risk assessments, evaluation of FAR/DFAR regulations and oversight of contracting terms and conditions per IT, continuous improvement and certification requirementsCompany representative to industry association Aerospace Industries Association (AIA)

* IT Analyst for Contracts, evaluated technologies - Robotics Process Automation, Business Relationship Management provided estimates for cost of implementation, run-time activities and long-term savings.* Department lead for new software buys, establishing requirements, coordinating with vendors, instructing IT team and evaluation of software proposals* Established disaster recovery steps for Contracts staff, data tools & alternate work locations.* Authored user documentation, training plans, data/process flows and project plans* Conducted training for new employees, system changes and project overviews, software applications, contracting processes for both the department staff and enterprise functional groups* Microsoft SQL Server (MS-SQL) developer - schema design, wrote queries/views, stored procedures, functions; data migration (ETL) via FTP, XML, XLS/CVS, etc. - performance tuning, zero-downtime* Microsoft Access programmer - developed forms, complex queries & functions, macros/modules, complex reports; linked with external data sources MS-SQL, Oracle, XLS, Docx, etc.* Microsoft Office programmer - developed Excel workbooks with VBA, programmed Word files for use in customized reports and forms - negotiations templates, estimating templates, etc.* Front-End Developer: programmed HTML, JavaScript, CSS to use intranet website for reporting with real-time data access, key-performance reporting and department balanced scorecard

Application Development Projects:* Project: Developed Contract Life-cycle Management (CLM) app for proposal management & contract administration. Programmed in Microsoft Access (client) and SQL Server (backend) using VBA and SQL. Integrated for billing, logistics and deliverables; used globally by the US, UK, Canada, Australia for data entry, reporting, ad-hoc queries and real-time metrics.* Project: Customer Relationship Manager (CRM) app to track all correspondence, customer activity - highlighting milestones and event driven requirements with task management. Microsoft Access (client) and SQL Server (backend) using VBA and SQL. Used in the US with a copy developed for Canada.* Project: Electronic Central Files System (CFS) system for storage and accessing legal documents linked to contract and correspondence data records; featured a web-front end linking to the file-system with integration with Oracle Web Center. Comprehensive search tool for types of documents, contract language, terms & conditions, customer correspondence by range, events, persons and organization.

Worked as part of dynamic teams to build marketing campaigns and provide the resulting data analysis. Communicated directly with Ford suppliers and auto-dealers to build marketing tools, capture data and return with analysis, metrics and insights. Goals were to develop new business, improve customer relations, improve business communications. * Developed data models and database applications to support data-driven marketing campaigns.* Lead in project design and technical reviews of customer requirements and product development. Reviewed customer feedback and provided business development ideas or alternative methods for improvements* Documented technical functions, operations manuals, technical package summaries.* Developed the application parameters for use by the quality assurance testers and user acceptance groups.* Coded SQL functions and complex procedures; linked the back-end SQL Server to front end web-based clients. * Participated in strategy sessions for new customer products and how to improve existing customer-based tools.

contract to Bell South (AT&T)Selected to provide database administration and development and to provide network management for the database servers for the team designing the first customer service management system to support the Southeast US region. System requirements mandated a 24/7 uptime and on-call management.* Administered a very large network to manage the customer service call center. This served upwards of 6,000 operators and required continuous uptime and active monitoring. Involved both the hardware server and the SQL server machines. * Monitored massive amounts of data collected per week in a EMC RAID hot swap storage network requiring fiber-optic connectivity for optimal performance.* SQL server required continuous improvement and performance tuning for daily data and reporting requirements.* Developed maintenance schedules and disaster recovery plans. * Worked directly with hardware vendors on performance upgrades and repairs.* Provided input to the data engineers on improving programmed procedures and system interfaces.* Communicate directly with the user community for feedback and troubleshooting.

Hired to develop systems support for large Fortune 500 clients. Developed in house systems to manage support network. > Project: developed Workflow Management System – automated a paper process into a Web based system that tracked work, assigned tasks, tracked productivity and billed clients. Prototyped in MS Access with VBA and an SQL backend.> Project: developed a Contact and Escalation system serving 2000 employees, vendors and contractors to comprise multiple contact data, included auditing for data integrity and secured manager support by selling benefits of lowers costs and improved response times.> Project: Service Interruption Management System (SIMS), a web-based system to track and service global LAN/WAN client issues used in our emergency response center to manage high level and high-profile outages.