SUMMARY:

• Passionate IT professional with a holistic view of systems, processes and automation.
• An agile team leader / player with strong problem recognition / resolution skills, data analysis, customer focus, diverse technical background, process automation, support of complex systems and a willingness learn and train others.

TECHNICAL SKILLS:

Languages: SQL / T - SQLSSISSSRSETLExcelPowerShellC#VBUNIX ScriptingC

Tools: SQL Server 2016 / 2014 / 2008 R2SQL Server Management StudioSQL Server Data Tools (SSDT)MSFT Web Performance / Load TestingMSFT Team Foundation Server (TFS)HP ALM / UFTVisual Studio 2010 - 2017 / MSTestOWASP ZAPWCFStorm

Databases: SQL Server 2016 / 2014 / 2008 R2MSFT AccessOracle

Operating System: Windows Server 2012 / 2008Windows 10 / 8.1 /7UNIX - Solaris / Redhat

PROFESSIONAL EXPERIENCE:

Confidential, Texas

Test Automation Engineer

Responsibilities:

• Maintain and run all QA and Production UFT scripts for the EPS portals. Where possible, the scripts utilize external/shared VB functions across QA and Production scripts, embedded datatables and HP’s UFT object repository.
• Established high-water run rates for production and DA load testing. Developed SSIS packages to parse and load key attributes from over 2000 IIS, application and reporting logs. Run rates were established per application/webservice by hour.
• Implemented a security reporting process that reports on all users with access to any of our 140+ non-production servers. The report utilizes an SSIS solution, that scans all the servers in less than 15 minutes. The SSRS reports provide external auditors with a concise security report which meets audit requirements.
• Run and maintain Visual Studio 2015 Performance Tests. Initially consolidated multiple versions of the load/web tests into one TFS repository. The tests are run and the results compared to ensure our fail over systems meet or exceed the performance levels of production.
• Updated all UFT portal scripts to use a shared login routine. Previously, all the scripts used the same but slightly “different” logic to handle logins. The common login routine keeps all ID’s and passwords in one location and simplifies maintenance.
• Developed an SSIS/SSRS solution to scan and report on the patch status of over 140 Microsoft systems dispersed around the country. The ETL process is hosted on a SQL 2014 Server. A SQL agent job tracks the start and end of each system’s scan and then loads the information via SSIS and produces consolidated security reports via SSRS.

Advanced Technical Business Analyst

Responsibilities:

• Remotely installed and configured SQL Server 2008 R2, Microsoft Reporting Services, security, FTP and the ARCU portal on over 25 client servers.
• Provided support for over 60 clients across the United States.
• Managed system installs including setting client expectations, setting milestones, tracking issues, escalating issues and providing status reports to clients and ARCU management.
• Worked with customers to understand issues, research to determine root cause and provide resolutions.
• Remotely trained all ARCU clients on Microsoft Reporting Services and using the ARCU Portal.
• Improved report performance by caching datasets, improving parameter usage and tuning SQL views.
• Developed reports for ARCU using SQL stored procedures, SSRS data sets and Report Builder.

Team Lead / Senior Programmer Analyst / Advanced System Engineer

Responsibilities:

• Lead a team of System Engineers/Analysts that supported the asset management system, SQL databases, Windows servers and UNIX servers for multi-billion dollar client— Confidential .
• Created and maintained a Visual Basic application using standard forms/sub-forms and visual basic code. The application saved approximately $350,000 annually by increasing user productivity and automating system updates. The application enabled users to submit batch changes to the production system and monitor the status of their batches. The application utilized a Microsoft SQL database and synchronized file transmits (FTP) between Windows and UNIX platforms.
• Managed the Inventory Database project activities with the internal EDS customers including quantifying requirements, determining priorities, setting project schedules, assigning work activities, monitoring project status, minimizing delays and communicating project status to our customers.
• Analyzed Chargeback specifications to determine requirements for pulling monthly billing feeds.
• Served as the primary technical analyst in identifying the downstream impact of changes made to the Inventory Workflow system.
• Analyzed existing file processing and worked with a 3rd party vendor to reduce weekly interface processing from two days duration to 15 minutes.
• Presented weekly status reports to the Confidential Account’s user community detailing system activity such as user load, transactions processed outages, resolutions, scheduled maintenance and upcoming release schedules.
• Reviewed the causes of system outages and minimized the impact of the outages by developing UNIX scripts to monitor the health of the Remedy system and send notifications of outages or if outages appeared imminent.
• Reduced weekly Microsoft SQL cycle runtime by 80% (from 20 hours to 4 hours) by tuning Microsoft SQL database file locations, tuning SQL queries and adding appropriate indexes.
• Enhanced data integrity, disaster recovery capability, and data visibility by migrating over 100 million inventory records from multiple CSV files, Excel spreadsheets and Access databases to a Microsoft SQL database server with full database backups and user roles.

Team Lead / Advanced Systems Engineer

Responsibilities:

• Analyzed midrange services and costs and helped establish billing rates by reaching consensus with the customer on the mid-range services provided and where each service belonged in the service tiers.
• Worked with SAs and DBAs to help inventory all the midrange systems and the services provided.
• Analyzed requirements for the midrange inventory and designed a web tool to facilitate inventorying servers and services and track changes to the services.
• Worked with EDS executives to establish billing rates and service tiers for the midrange systems.
• Evaluated the fiscal viability of a 1.5 million dollar development project. Ultimately recommended its closure based on effort spent and remaining tasks.
• Trained over 200 new hires on program design, standard system development life cycles (SDLC), C, UNIX, database concepts and testing methodologies to EDS programmer trainees.
• Managed production support for the Memorex/Telex Account. Managed the project plans, reviewed change requests, set priorities, assigned tasks to team members, communicated project/task status and minimized delays.
• Ensured standard life cycle (SLC) practices were followed in supporting the EDS developed programs on the Memorex/Telex Account.
• Create a help desk application for the Memorex/Telex Account using Microsoft Access and Visual Basic.
• Led a team to reduce paper usage and automate balancing procedures on the Neodata Account, ultimately resulting in a savings of over $200,000 annually.
• Analyzed Neodata’s usage of CA-Dispatch, documented the business requirements. Designed and developed a report distribution system that handled distribution of over 10,000 reports nightly, including printing and archival of all mainframe reports.