SUMMARY:

• 15 years of experience in web and windows development in Microsoft Visual Studio VB.NET full stack (with Microsoft SQL Server) and ASP.NET
• 15 years Windows Server, IIS, Linux, RHEL, Apache administration
• 15 years web based applications in Visual Studio VB .NET
• 8 years Capacity Planning for servers/applications
• 8 years design / project management
• 8 years VBA macro development in MS Excel, pivots, formulas, vlookups
• 2 years Network Capacity Planning
• 4 years Agile methodology
• 2 years cybersecurity analyst
• 1 year C#
• Automation in Excel VBA of Allstate rates and proposals for insurance products with over 20,000 users in the field.
• Products included but not limited to GVAP1, GVAP2, GVCIP3, GVCIP4, Canada Accident, L70, Genelco, GVCP3.
• Actively develop automated 30 tools within Excel VBA and Word using various compatible coding language
• Maintained current suite of automated tools while including new upgrades across all tools as necessary
• Develop, design, research, create, and implement routine projects, processes, and policies with minimal degree of negotiation of resources in order to complete project
• Delivered efficiencies by automating high - volume processes using ASP.NET, MS Visual Studio web / win forms development and MS SQL.
• Oversaw parsing of CPU, memory, storage, and network logs to examine and define demand management capacity pool requirements for midrange servers.
• Evaluated business requirements to right-size windows server infrastructure, RHEL, AIX, and Solaris LDOM’s while tracking CPU assets and incidents via BMC Remedy to identify and resolve issues.
• Provided extensive input into a portfolio of global technology projects focusing in the enhancement of performance and capacity in line with industry best practice standards.
• Managed right-sizing of all proprietary bank clouds to drive application stability while reducing waste

TECHNICAL SKILLS:

Languages: Microsoft Visual Studio (Full Stack), Microsoft Office Excel VBA, Microsoft Access, XML, HTML, CSS3, MS SQL, mySQL

Applications and Technologies: Visual Studio VB (VB.NET), XML, CSS3, HTML5, Node js, eeb based applications, Web API, Web Services, SVN, Git, x86 assembler, LISP, MS SQL, mySQL, Windows Event Viewer, Active Directory, MS Excel VBA, MS Visio, MS PowerPoint, MS IIS, Apache Tomcat, Jira, BMC Remedy, Agile methodology

Operating Systems: Microsoft Windows (7, 10, Server 2004, 2016 administration)Unix (AIX capacity monitoring, Linux (RHEL) installation, config, virtualization, admin)VMWare Workstationz/OS, JCL, CICS, ISPF

WORK EXPERIENCE

Confidential

Capacity and Performance Engineer

Responsibilities:

• Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Create VBA programs to automatically update Access databases, encompassing class and program modules and external data queries.
• Wrote my own tools and web applications to have a visualization of server infrastructure shared across Banknof America.
• Efforts where conducted using Agile methodology for iterative incremental development
• Develop GUI interfaces in MS Excel forms, using Open Database Connectivity (ODBC) to connect toMicrosoft SQL Server Relational Database Management System (RDBMS).
• Developed MS Excel macros to verify and compare data pertaining capacity planning tools.
• Extensively use MS Excel VBA in development, focusing on read/write integration to databases for Capacity Planning.
• Process automation via Access VBA macros / ASP.NET / MS Visual Studio / MS SQL: parsing of CPU, memory, storage, network logs to determine demand management capacity pool requirements for midrange servers

Confidential

Cybersecurity Analyst

Responsibilities:

• SIEM and vulnerability assessments for server infrastructure as well as network infrastructure (Akamai, Rackspace) using Qualys, Luna Akamai, Trend Micro, Sonatype, Veracode, Nipper Studio, Rackspace Managed Security.
• Wrote my own tools in VB.NET Visual Studio.NET (web based and Windows forms) to visualize network device dependencies to help identify false positives.
• Source code penetration testing using Veracode and Sonatype to assess security defects and remediation
• Established automation processes for repeatable tasks to reduce work effort required for audit related tasks trough form based MS Excel forms and modules.
• Efforts where conducted using Agile methodology for iterative incremental development
• Effectively communicate and escalate Security related risks and vulnerabilities to business owners based on department, application, or environment
• Serve as the primary resource for Security monitoring, identifying or obtaining response to issues and optimization.
• Includes activities such as setting baselines for monitoring alerts, reducing ‘noise’ from excessive monitoring notifications and creating actionable alerts and reports from MS Excel VBA - Data cleanUp ETL
• Oversee antivirus/firewall/wifi/endpoint security solutions and implementation.

Confidential

Cybersecurity and Data Network Capacity Planner

Responsibilities:

• Wrote my own tools in MS Excel VBA, VB.NET, ASP.NET and SQL consolidate massive inconsistent Systems Of Records (SORs) like ITSM, BMC Remedy, Nexus, HP NNMi, Splunk, HPNA and other proprietary SORs
• Efforts where conducted using Agile methodology for iterative incremental development
• Applied the NIST Cybersecurity Framework, SANS and updated internal Access database with results in batch processing using Excel VBA macros
• Wrote tools in Windows forms and Web based applications in Visual Studio VB.NET for SOR data analysis of network components within the network capacity planning arena.
• Member of the Governance Process for the AMER, EMEA and APAC device/interface utilization worldwide working in conjunction with network engineers to implement bandwidth upgrades, reroutes, tunneling and other tactical solutions to mitigate risk of network saturation both domestic and transcontinental
• Employed data analysis trough VB.NET and Access VBA on a daily basis via HP NNMi, HPNA, as well as NDC (a bank tool that uses SNMP and CDP protocols) to mitigate risk of inconsistent information of device configuration between these Systems of Record (SORs).

Confidential

Systems Design Technical Lead

Responsibilities:

• Data analysis employed via MS Excel VBA macro programming and Microstrategies eSmart day to day to consolidate and merge information from different Confidential systems of records in the thousands of records, including server information such as hardware, line of business alignment, application inventory dependencies in the ITSM/BMC Remedy SOR.
• Wrote several tools in VB Visual Basic Visusl Studio .NET to manage data ingestion automation and visualization.
• Efforts where conducted using Agile methodology for iterative incremental development
• In charge of DTL management of projects: coordination of dozens of projects in the design technology space. This included but not limited to Hosting Proposal Documents, High Level Design (visio diagram), Server Build Sheet details, Cost Estimate Workbook and Book of Work with all projects from team.
• Allocated design resources, developed and ensured adherence to design best practices.
• Led the execution of the engineering aspects of the technical solution design via MS Visio and MS Excel VBA
• Reported and tracked design activities, progress and status via MS Excel VBA (forms and modules)

Confidential

Capacity and Performance Engineer:

Responsibilities:

• Use of data analysis (data crunching) to detect and correct inconsistencies in very large and complex SORs
• Data analysis to detect and predict the behavior of server performance and capacity in groupings of servers and entire data centers prior to migration and data center consolidation and decoms
• Data analysis included but not limited to historical metrics of CPU, memory, storage and network utilization of servers. Historical data used to model trends when adding more concurrent users to the application.
• Used deterministic and heuristic algorithms and wrote ad-hoc tools as part of the data analytics. Some included Queue Theory, data pattern recognition, heuristic prediction, genetic algorithms and other Operations Research methods.
• Performed data analysis via Microsoft Access vba macros/ Visual Basic .NET / ASP.NET web applications to deliver capacity reports for midrange servers. Excel VBA macros processed information in the hundreds of thousands of records and dozens of data sources including SQL queries, configuration file parsing and other large excel files.
• Efforts where conducted using Agile methodology for iterative incremental development
• Software developer for LOBs including dashboards, data analysis and UI web applications and windows forms in Visual Studio VB.NET in the GT&O space. T-SQL stored procedures for frontend and backend.
• Instrumental tool and methodology builder for Confidential:
• Created and supported IBM AIX Utility Compute sizing methodology and software tools in .net and MS SQL SSRS for capacity management and performance engineering of frames and LPARs for all LOBs. Member of the AIX UC Governance Board planning strategic direction of AIX virtualization for the bank.
• Created tools and methods based on data analysis in MS Excel VBA / MS SQL and assumed leadership of storage capacity analysis to fill to permanently improve storage capacity planning by automating it. The information and data analysis methodology is still being used across all LOBs to this day.
• Created and supported Oracle Virtual Machine (OVM) by means of complex data analysis analyses that produced the software tools in .net and MS SQL SSRS for capacity management and performance engineering of the physical servers and their LDOMs and Solaris Zones.
• Wrote capacity planning tools in VB.NET/MS SQL and Excel VBA/MS SQL and SSRS/MDX that were instrumental in capacity planning and strategic decision making of server remediation and physical footprint reduction for executive level as well as project managers, chief engineers, design technical leads, system administrators, DBAs and middleware teams.
• Hands-on as capacity in a large number of projects where a capacity planner was required for ad-hoc analysis for all LOBs in small, medium, and large projects
• Coordinated efforts to consolidate massive systems of records (SORs) in Confidential ’s assets systems to ensure business requirements were met. Led projects to translate Business Requirements Documents into Technical Requirements documents, namely BRDs into Low Level Documents (excel sheet template with Requirements) as well as HLDs or High-Level design (MS Visio diagrams) with business stakeholders or BTGs (Buisness Technical Groups) including client facing and technical teams. Used MS Excel VBA, MSSQL, SSRS to consolidate massive SORs. Some of these SORs included but not limited to BMC Remedy, Nexus and other Confidential proprietary SORs.
• Project manager with 6 years experience in delivery of physical footprint reduction: directed as much as 5 projects at the same time and directed design, engineers, developers and system administrators for decom, troubleshooting and massive data center migrations.

Confidential

Responsibilities:

• Built and managed and helped hands-on a team 5 developers responsible online game running, configuration, Back End system with Microsoft. NET platform, including ASP.Net, VB. NET and Microsoft SQL Server.
• Developed web based applications in Visual Studio vb .NET for game configuration and reports.
• IIS installation, configuration and support fir the vb.net web applications written in Visual Studio.
• Provided architectural and technical guidance to product development and ensuring that sound software engineering design process and quality practices were followed.
• Provided employee development, coaching, mentoring and team building.
• Analyzed and reviewed the design of the software, including technical reviews and analysis of source code which include in-house developed code, as well as review of technologies provided by 3rd party vendors.
• Responsible for the delivery of products within budget, schedule, quality and corporate guidelines.
• Simultaneously managing the cross-functional, multiple development efforts through conception, planning, testing, certification, implementation, integration and sustaining.
• Analyzed and wrote product requirements, functional / design specifications and test plans.
• Analyzed appropriate technologies, vendor products, competitor's offerings, options for critical design elements and features and determining optimum selection.
• Worked on extremely complex problems where analysis of situations or date requires an evaluation of intangible factors. Exercising judgment in developing methods, techniques and evaluation criteria for obtaining results.
• Represented software development as the primary interface to marketing, procurement and service.

Mainframe z/OS Developer

Confidential

Responsibilities:

• Design and programming of mainframe software for data analysis analyses of massive textual databases using the Cobol language. Most of the programs were used for national credit score computation and domestic market analysis to name just two out of dozens of project types.
• Developed and debugged software using the JCL commands to troubleshoot incorrect outputs and abends.
• Worked closely with senior mainframe developers to get project requirements that included the upstream/downstream of the Cobol application to/from other modules.

Developer VB.NET / MSSQL

Confidential

Responsibilities:

• Designed, implemented, deployed and supported an applications: an appointment system in VB.NET Windows Forms and MSSQL using the Agile methodology which included diagnostics of the pathologies found in the patient’s feet and documented treatments and follow-ups.
• Designed, implemented, deployed and supported an ad-hoc Point of Sales in VB.NET Windows Forms and MSSQL with invoice printing and inventory functionality. The system included balance reports to be sent to the accounting department to apply the corresponding company controls.
• Designed, implemented, deployed and supported a Punch-In/Out system using VB.NET Windows Forms and MSSQL with a low-cost Microsoft fingerprint device that captured the fingerprints of the associates as a mean to check-in at their start of shift and check-out at the end of shift.
• The deployment included hardware procurement process and installation of the Windows OS, configuration and installation of the internet connections necessary for automatically transmitting patient data for backup purposes using SFTP
• All three systems were supported and the staff was trained by myself on all 4 locations.
• All these activities were conducted by myself using the LogMeIn remote desktop software for training and support purposes.