SUMMARY:

• Information Technology Architecture, Management, Design, Development and Documentation
• Information technology professional with a project portfolio demonstrating initiative, innovation and result - focused solutions systematically aligned with customer objectives.
• Seasoned business analyst, application developer, and project leader with diverse experience producing superior artifacts across all software engineering phases gained from service to pharmaceutical, healthcare, financial, telecommunications, and engineering sectors.
• Top-notch automation architect with a proven, well-honed ability to identify business process improvement opportunities that deliver measurable investment returns.
• Solid information security expertise gained from public and private sector business development campaigns, project management engagements, and hands-on experience implementing security controls for a variety of applications, platforms, and risk profiles.
• Dedicated craftsman with the self-directed work-ethic required to learn and apply what's necessary to provide leading-edge creative technical services.
• Analysis: Elicited, produced, and re-factored functional requirements, user stories, specifications, screen designs, use cases, acceptance criteria, performance metrics, value propositions, prototypes, and other software engineering artifacts in accordance with System Development Life Cycle (SDLC) guidelines.
• Invented a flexible, systematic methodology designed to streamline and integrate analytical processes to target specific needs and build a re-usable artifact repository. This method imports requirements documents and spreadsheets to databases to enable paragraphs to be categorized as various “information objects” which can then be translated and linked to structured descriptions of: functionality, use cases, automation architecture, design notes, test scripts, source code and other elements to: trace, track and filter artifacts; discover and enforce standards with intelli-sense and other interface enhancing features; and utilize a library of functions, formulas and parameters to generate text and deliver targeted capabilities.
• Having honed the research skills necessary to satisfy a curious and constructive nature, I recognize the value of staying abreast of industry, as well as technical developments, and strive to translate understanding to opportunities with particular emphasis on ensuring that my efforts align with business strategy to provide measurable competitive advantage and return on investment.
• Provided a full range of PMO services including: technical solution design and management approach development, process improvement, team capability assessment and sizing, candidate interviews, employee oversight, tracking financials to assess progress and project burn rates, customer reporting, and issue resolution. Supported business development, service delivery, and financial accountability initiatives.
• Oracle PL/SQL for Data Warehouse Extract, Transform and Load (ETL). SQL Plus, SQL Developer, SQL Server. Crystal Reports., DB2.
• Eclipse, Java, Swing, XSLT, JUnit, JBOSS, Linux, shell scripting. Microsoft .NET, Visual Basic, C#, SharePoint, Dynamics CRM, Dynamics ERP.
• Provided solutions for a range of complex processes. Have consistently played a leading architectural role using WinRunner, QuickTest Pro (QTP), and Integrated Development Environment (IDE) I developed in Microsoft (MS) .NET, Visual Basic (VB), and VB for Applications (VBA), MS Access.

PROFESSIONAL EXPERIENCE:

Senior Project Planning Consultant

Confidential, Horsham, PA

Responsibilities:

• Served in a cross-application technical planning and project management and role as a full-time employee for this top-ranked healthcare company.
• The “Consultant” title reflected this position's mission to engage with stakeholders at the start of complex projects involving many integration points in order to plan execution, deploy best practices, and deliver management, architectural, automation and other tools to application project managers, technical staff, and business customers.
• Translated application development, database, automation, cybersecurity, big data, and conceptual modeling expertise to actionable project tasks.
• Developed project strategy, plan, schedule, architecture, security posture, management approach and tools for application development, integration, testing, and automation projects.
• Conducted meetings for planning, solutioning, integration negotiation, defect review, war room escalations, daily scrums, and senior management reporting.
• Designed, implemented and measured process improvement efforts across a variety of IT implementation and management tasks.
• Leveraged corporate initiative to transition to Agile methodology to systematically try, evaluate and deliver process improvements within the framework of Lean Six Sigma guidance.
• Deployed improvements to: transition from document management to information management (i.e. use SharePoint, MS Project and other databases to manage projects instead of documents, spreadsheets, emails and other unstructured forms of persisting and communicating inter-related data); transition to MS Project Online to provide improved SharePoint integration, utilize worthwhile new features, and save on licensing costs; curate shared automation, test script, data flow diagram and other libraries to support artifact sharing, search and reuse among corporate project teams; apply Business Process Management (BPM) techniques to identify, communicate and manage “ISO 9000 type” processes, quality plans, and best practices, as well as identify Agile approaches based on project conditions.
• Developed, implemented and championed MS Project best practices and innovations as part of an initiative I spearheaded to build a center of excellence focused on transitioning project managers and staff toward more effective business process analysis, management, and execution.
• Architected a novel approach to apply structured application programming techniques and syntax standards to develop, manage, and improve human and system processes.
• Designed, developed and documented: healthcare information technology architectures; VBA applications for MS Project, Access, Excel and Outlook; and collaboration applications for SharePoint.

Database Report Analyst Developer

Confidential, Morristown, NJ

Responsibilities:

• Successfully completed all tasks for this short-term contract.
• Designed and developed SharePoint application to track project activities and deliverables.
• This system supported R&D pharmacovigilance efforts to monitor and assure drug safety.
• Provided technical analysis, defect investigation, database, application, and implementation support.
• Developed PL/SQL applications to analyze, cleanse, and optimize the Oracle database.
• Developed automation to set up environments and install applications.
• This tool suite was fully parameterized to enable easy reuse for other requirements suitable for the design pattern implemented.
• Performed validation, testing and anomaly management, and change management tasks in accordance with established system development life cycle procedures and best practices.
• Wrote more than ten technical manuals to document application development, usage, and maintenance.

Tools: Crystal Reports, Oracle SQL Developer, CRLIMS, Enginuity Reports.

Project Manager / Business Analyst

Confidential, Horsham, PA

Responsibilities:

• Provided technical, management and business development for a range of services including: Cybersecurity, Information Assurance, Continuous Monitoring, IT Architecture, Application Development, System Integration, Business Process Engineering, Automation, Performance Assessment, and others.
• Managed projects, provided technical analysis, and reviewed project artifacts.
• Demonstrated subject matter expertise for Military, Intelligence, Security and other customers.
• Developed and wrote proposal technical approach sections for information assurance, vulnerability assessment, and other cyber security projects. Worked with customers on security design, implementation, and compliance. Wrote Information Assurance documentation and CDRLs (DIACAP/RMF). Designed networks to meet policy and implementation requirements (ACAS, SCCs, and STIGs). Evaluated network designs and devices for vulnerabilities. Analyzed attack events, exploit points, and continuous monitoring metrics to design platform hardening, automated response, and other mitigation measures.
• Developed automation to install, configure, and deploy open source security tools, such as SNORT (network intrusion prevention system, capable of performing real-time traffic analysis, packet logging on IP networks, protocol analysis, content searching/matching, and can be used to detect a variety of attacks and probes, such as buffer overflows, stealth port scans, CGI attacks, SMB probes, OS fingerprinting attempts, and much more).
• Designed access controls for web server platforms and network elements.
• Wrote marketing literature including capabilities statements, brochure, white papers, and web site content.
• Evaluated SalesForce and MS Dynamics CRM systems. Selected and implemented Dynamics CRM including installation, external data import, requirements collection, business process design, work-flow development, data model and entry screen customization, and use case-based documentation designed to meet targeted business requirements and augment training.
• Developed user stories, prototypes and proposals to support business development initiatives for providing MS Dynamics CRM and MS Dynamics to customers.
• Designed and developed MS SharePoint applications to manage proposals, coordinate inter-company teaming activities, and on-board employees.
• Managed opportunities, pipeline, partnering, communications, campaigns, capture, proposals, talent outreach, events, and other efforts to help people through developing business, technology and processes.
• Identified projects aligned with our interests. Negotiated bid team terms. Wrote proposals to win business. Prepared and delivered value proposition presentations.
• Wrote documentation and implemented measures to support ISO9000 quality compliance.

.NET and Oracle Developer

Confidential, West Point, PA

Responsibilities:

• Enhanced data entry and reporting applications to meet data source, user access, security, and other specifications.
• Ported VB6 application to .NET. Changed interface, reports, logic, and SQL.
• Automated processes to support testing.
• Developed .NET proof-of-concept that implemented globalization to: enter and store foreign characters directly to databases that support them; and use an encoding / decoding algorithm to store them in legacy databases that do not support globalization.
• Developed PL/SQL scripts that queried Oracle metadata to systematically identify tables, stored procedures, views and other objects impacted by column changes.
• Developed PL/SQL scripts to verify data integrity after structural and content changes.
• Successfully completed all tasks for this short-term contract.

Java Web Developer

Confidential, Allentown, PA

Responsibilities:

• Identified business and application requirements. Resolved maintenance issues, developed new functionality, refactored source code, and developed graphical user interfaces that achieved functional intentions and emphasized usability.
• Developed application to set-up environments in a seamless reliable way that also enabled us to identify existing configurations that needed to be changed. This effort implemented a diverse array of functionality to update database, XML, source code and properties using Java, XSLT, JDOM, Ant, JUnit, Unix shell scripts, PL/SQL and other tools. Delivered with automated tests to validate use cases.
• Developed load test automation (after finding no open source offerings that could readily navigate our interface) to reproduce, diagnose, and verify fix attempts for sporadic disconnect issues that were endangering our service level agreements.

Data Warehouse / Web Developer

Confidential, Allentown, PA

Responsibilities:

• Designed, developed and maintained ETL system, stored procedures, and web-based reporting tools.
• Developed web crawling application to: systematically select data warehouse report option parameters, generate output to multiple formats, handle known exceptions, notify developers to report trapped errors then continue running, and provide other features to exercise thousands of online reports scaled across multiple sessions. This application was well-suited to an automation solution because the manual effort required for comprehensive testing was too high.
• The results it produced went beyond proving what was possible and useful; the tool consistently identified functional gaps, errors, and performance issues which enabled us to discover and rapidly respond to problems in production, as well as execute comprehensive and targeted regression testing in development environments.
• Developed on-demand data load process to resolve recurring production issues by reducing a complex set of development and manual actions to a procedure call. This substantially reduced response time and re-defined the possible with respect to implementing targeted Oracle Warehouse Builder (OWB) functions and generating SQL to create tables, analyze data and simulate production processes.
• Identified and implemented a large table load approach to workaround infrastructure and database availability limitations.
• Designed data remediation scripts that generated SQL fixes to resolve data integrity issues based on systematic data analysis.
• Worked marathon shifts over the course of a few weeks to resolve data load failures resulting from Oracle infrastructure issues.
• Developed a script that re-purposed data load logs to achieve complex analysis objectives required to automate remediation.
• Automated Database Administration (DBA) processes and source code control system functions to streamline deployments.
• Developed PL/SQL library to create and modify database objects with logic that enabled re-run-ability and offered specific functionality determined from usage experience.

Analyst Developer

Confidential, Allentown, PA

Responsibilities:

• Resolved maintenance issues, developed new functionality, refactored source code, and provided graphical user interface designs that achieved functional intentions and emphasized usability.
• Developed the company's first .NET web application, which provided detailed results and management capabilities for the daily Extract Transform and Load (ETL) process.
• Developed a VB.NET web crawling application to systematically select data warehouse report option parameters, generate output to multiple formats, handle known exceptions, notify developers to report trapped errors then continue running, and provide other features to exercise thousands of online reports scaled across multiple sessions.
• This application was well-suited to an automation solution because the manual effort required for comprehensive testing was too high.
• The results it produced went beyond proving what was possible and useful; the tool consistently identified functional gaps, errors, and performance issues which enabled us to discover and rapidly respond to problems in production, as well as execute comprehensive and targeted regression testing in development environments.

Analyst Developer, Automation and Reporting

Confidential, Allentown, PA

Responsibilities:

• Developed, automated and tested data entry, accounting, reporting, and support applications.
• Designed and developed an application automation tool to analyze, sequence and execute complex processes across multiple applications in Windows and Linux.
• The engine was developed in Microsoft VB to execute run, keystroke, mouse-click, screen scrape analysis, and an expanding library of custom functions within a database driven framework. Presented a proof-of-concept presentation of this application and secured approval to port it to Oracle and use it to automate all critical processes in the production life-cycle.
• Developed turn-key end-to-end automation to run daily accounting calculation processes under various configurations; generate and run SQL to load interface files to Oracle; and compare database and file output states to baselines to produce fast turnaround of detailed test results.
• Developed automation to navigate user interfaces, exercise negative and positive tests, enter data, and perform other functions to eliminate significant manual work, communicate complex use cases, and transition toward a more Test-Driven Development methodology.
• Developed applications to translate .xls files received via email from customers to proprietary transaction files for production processing, and for various projects that surfaced throughout the organization on realizing the capabilities of VBA.

Analyst Developer

Confidential, Upper Gwynned, PA

Responsibilities:

• Published, tested and supported internet marketing initiatives including: product.com websites, online video detailing, physician call back, and other applications. Support website availability and performance monitoring.
• Developed a structured architecture to automate: data entry, functional validation, meta-data analysis, web crawling, internet publishing, and other processes.
• Wrote Standard Operating Procedures for System Administration, Problem Solving and Reporting, and Website Testing.
• Implemented load testing to support Linux Migration, Oracle Upgrade, and other initiatives.

Tools: TestDirector, WinRunner, SiteScope, MSAccess VBA, LoadRunner, Documentum, ClearQuest.