SUMMARY:

• Seventeen years’ experience at the Confidential, Confidential and Confidential in all phases of the SDLC.
• Four years’ experience with MS SharePoint 2013 and SharePoint Online including administration.
• Three years’ Agile development experience including KANBAN and SCRUM.
• Confidential eCommerce Interfaces with web services (IT Workbench) to Confidential systems expressTRAK, CABS, CRIS.
• Expert at MS Office and O365 including Visio, Excel, Access, PowerPoint, Project and Project Place
• Good understanding of database query and ETL with PL/SQL, T - SQL, SQL Developer, TOAD, and MS Dynamics.
• Confident in high-pressure, fast-paced IT environments. Recognized problem-solver.
• Possesses a wide range of knowledge and skills necessary to debug, analyze, track and quick fix IT issues.
• Strong website UX skills - analysis, design, storyboarding, wireframing and business process workflows.
• Has a consulting mindset, a get-it-done attitude, and can hit the ground running.
• US Citizen with current Public Trust (Confidential) clearance.

TECHNICAL SKILLS:

Programming and Applications: SharePoint 2013 and SharePoint Online, Visual Basic, Java Script, Visual Studio, ASP.NET, XML, ANSI-SQL, PL-SQL, HTML5, CSS, Adobe Acrobat DC and MS Office 2013 and MS Office 365 (Excel, Word, Power Point, Project and Visio) including macro programming and data analysis (pivot tables and charts including Excel 2013 Power Pivot and Data Analysis Expressions), Team Services for Visual Studio.

Databases: Oracle 11g, PL-SQL and T-SQL, MS SQL Server 2104 and Enterprise Manager, MS Access 2013

Networking & System Admin: WebLogic Server 12c, Apache and Microsoft IIS e-Commerce: Oracle Business Intelligence, Discoverer and Report Builder, Team Forge, HP Quality Center

Operating Systems: Microsoft Windows 7-10 and server, UNIX (Red Hat, etc.), light MVS mainframe

Cyber Security Tools: Web Inspect, BURP, MS Baseline Analyzer (port and protocol vulnerabilities scanners)

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

IT Business Intelligence Analyst II, IBM Business Process Improvement Center of Excellence

• Implement SharePoint 2013 workflow application for the Office of the Secretary to be used as a business intelligence tool for document sharing and workflow management.
• Manage SharePoint 2013 application through SDLC phases including requirements, analysis, design and testing.
• Manage client relationships with federal employees at all levels, including attorneys, paralegals, support staff and SMEs; performed training, gathered feedback, and conducted root cause analyses of application issues.
• Write documents to Federal compliance such as SOPs, DRPs, BRDs, LOEs, user guides, business cases, process narratives, process maps and test plans.
• Triages issue resolution for the new SharePoint application using Service Now ticketing system.
• Applied AGILE tools such as test-driven development, user stories, visual project management and KANBAN.

IT Business Analyst and Project Lead, Federal Systems

• Successfully led team to transform a manual (paper) process into a case management business intelligence web application for U.S. EPA; this is a proprietary business intelligence tool used by scientists for grant applications and other purposes.
• Worked with Grants Case Management (GrantsSolutions.gov) for US HHR and HUD.
• Responsible for all phases of the SDLC and implementing AGILE process, AWS with JAVA, Oracle and Web Logic.
• Performed customer relationship management with executives and government employees.
• Researched and remediated security vulnerabilities using Web Inspect and BURP.
• Owned requirements, design, user manuals, communications, modeling and wireframes, use cases, test - - cases, test scripts, usability, non-functional specifications, defect tracking, data security and production deployment.
• Performed tier two help desk support and user training for this application including password resets, while collecting and triaging information for the development team to resolve issues.

IT Business Analyst and Software Coder, e-Commerce Team

• Advanced data mining, retrieval and reporting using MS VBA (Access, Excel and Word). Application design and development to run DB extracts, export results to Excel, format in Word document and email the report.
• Researched and wrote Proof of Concept for automating tests using QTP and Selenium IDE.
• Coded with VB.NET Framework and Java Script.
• Data scrub DB to support seasonal demand from customers, e.g. update shipping method for speedier delivery.

Software Engineer III, IV and V (progressive promotions) and IT Business Analyst

• Business Analyst - led a Confidential Requirements, Analysis and Design team (RAD). Duties included conducting joint application designs, analyzing requirements, writing designs and pseudo-code. Used HP Quality Center for System Development Life Cycle evolution from requirements through deployment and issue definition, root cause identification and remediation implementation and testing. Used Remedy Ticketing System for Tier 3.
• Data Mining - Data retrieval (Oracle, DB2 and SQL Server), reporting, linking and transformation (ETL) into MS Access and Excel, including VBA programming, MS Access SQL and OLE Automation. Extensive coding experience in MS Access and Excel 2013. Share Point Administrator for departmental document sharing site.
• Business Analyst - engaged in all phases of SDLC - requirements through post-production support and maintenance. Highly skilled with both Waterfall and AGILE JAD (joint application development) and JRG (joint requirement gathering) and JRD (joint requirements development) and SCRUM.
• Documentation - Expert at writing user manual, high-level and detail design documentation; also business process modeling diagrams and UML modeling (use cases) in VISIO.
• Cybersecurity - identified security vulnerabilities and remediated vulnerabilities by hardening applications and net architecture redesign to reduce penetration points (SSL certs, HTTPS, SFTP, FTP-S, PCI compliance and firewalls). Developed ACL with roles and access permissions. Performed application vulnerability testing with HP Web Inspect and BURP, both automated and manual. Skilled at security remediation and app redesign to eliminate XSS, XFS, session fixation, cross-site scripting, SQL, Javascript escaping, CSS escaping, and Web Logic filters. Championed web applications through the Confidential security review.
• Project Planning - Advanced project planning skills including OOMs and LOEs and business process, hardware architecture and data flow diagramming. Proficient at MS Project and Excel 2013 for tracking software development including milestones, change controls and gap analysis.
• Tier 3 Call Center Support - included working closely with Reps (call center agents) to troubleshoot and resolve customer issues with ordering and billing FIOS products and services.
• Management - led development teams of 2 to 4 coders and managed trouble tickets and change controls.
• Customer Service - Implemented customer service database to resolve customer complaints by providing data analysis of billing, repair and ordering databases throughout Confidential . Ticket closure time reduced so that 98% of tickets resolved within 48 hours, resulting in $2.7 million in savings and reducing customer complaints by 60%.
• Testing, Bill Validation Tool - Developed a bill testing system to perform regression and progression testing of production customer bills before and after code changes using JAVA (eclipse), Oracle SQL and mainframe JCL and HP AFP Studio (AFP2PDF converter). Also implemented a SharePoint website to coordinate communication and file sharing across throughout Confidential .
• Testing and Defect Tracking Process - wrote automated testing scripts using Telerik Test Studio and HP QTP. Also, used HP Quality Center and JIRA for test execution and test status from development through UAT san SIT. Supported automated reporting (UNIX batch) on outstanding system issues for senior management. e-Commerce, Bundle Qualification Tool - Designed and implemented web app to bundle VZ and Confidential Wireless and Confidential ordering and billing systems to allow customers to view/pay integrated bills (VZ, VZ Wireless and Confidential ) and also to order VZ, VZ Wireless and Confidential products and services. Coded using .NET Visual Studio, Javascript, C#, VB and MS SQL database. The integrated system saved over $15 million annually ($1.25 per bill, 100,000 customers/year).
• Web Reports, vRepair Analytics - Responsible for delivering 50+ web reports daily with high-level metrics and maintaining Web Logic servers for web application used in Confidential call centers to allow customer service reps to record and track repair requests from the initial call to truck roll and follow-up. Coded in UNIX shell script, Oracle SQL, JSP and JAVA.
• Web Development, Confidential - Combined Bell Atlantic and GTE web sites into a single Confidential . Designed, coded and tested Confidential web interfaces for legacy mainframe billing and ordering systems. Coded in ASP.NET, Visual Basic and C# with ORACLE databases.
• Databases – advanced large database retrieval and reporting skills (PL/SQL), including economic and statistical analysis; frequency distribution, daily, weekly, monthly, quarterly, EOY. Strong with Oracle 11g, Report Builder, Discoverer and SQL Developer, also SQL Server Enterprise Manager and Visual Studio integration and Oracle stored procedures. Expert ability to transform raw data from different systems and aggregate it into a clear, comprehensive report or graph and perform statistical analysis (frequency distribution, mean median and mode.
• Hardware – led team of engineers building and maintaining development and test environments for Windows and UNIX for a Confidential data center with over 100 servers and a $2,000,000 budget. Specialty with ERP systems, i.e. re-deploying hardware and software from old-to-new applications. e-Commerce – experienced in B2B e-Commerce including invoice billing and order consolidation for Confidential, Confidential Wireless, Confidential Business and Confidential .
• Programming – Java (eclipse), HTML, Java Script, .NET, Visual Basic, Cold Fusion, C#, ASP.NET, HTML, XML, VB Script, Oracle, MS SQL server and ANSI SQL including coding, architecture, deployment, testing firewalls and data security. Built and maintained IIS, Web Logic and JBOSS web application servers.
• Communication – well versed at all levels of professional communication from onsite presentations to senior management to writing training documentation for the end-user.
• Completed course VMware vSphere: Install, Configure, Manage V5.5 (Storm Wind Inc. August 2014).