Sr. Programmer Analyst Resume
Houston, TX
SUMMARY:
- Sr. IT Professional with extensive background in project management, technical lead, enterprise applications production support, business analyst, process analysis, integration, application solution design, development, and implementation.
- Adult Learning training to instruct end users on best practices to reducing Cyber Risk in the workplace.
- Developed backend process with .NET, T - SQL, Stored Procedures, SSIS, SSAS, Crystal Reports for Active Directory integration, Access Management Systems, Internal Cafeteria Pay System and other backend system processes.
- Developed ASP.NET Web Forms for intranet application utilizing JavaScript, CSS, VB.NET, SQL Server 2008 R2, IIS 6.0 Server 6/7, PL/SQL, T-SQL, SDK, API, Unit Testing and object-oriented design.
- Supported/Managed; Oracle 8i and SQL Server Databases 2008 R2, FTP access, PERL and VB.NET scripting/web app.
- Utilized Visual FoxPro 6.0-8.0 with Window’s API, COM, ActiveX, DLL, OLE, DDE, JavaScript & HTML to integrate to DOS, Windows, Mainframe and Web based systems.
SKILLS:
- System Design
- Project Management
- Change Control, Risk Management
- Quality Control
- Customer Service
- New Product Implementation
- Major Conversions
- Problem-Solving Skills
- Information Security Systems and Training
- IT- Confidential
- EDI
COMPUTER SOFTWARE KNOWLEDGE:
Window 2008 Server, Window 10-7 Professional, UNIX Oracle Solaris 11, Visual Studio 2015, 2012, 2010,2008,2005, Visual Basic.Net, ASP.NET, Window API, COM, ActiveX, DDE, OLE, ODBC, SQL Server 2016, 2014,, 2008R2,2005, Oracle 9i /10g/11i, JQuery, PL/SQL, Confidential Welcom Home, Confidential Open Plan, Dreamweaver, ARCGIS 10.1, SSRS, SSIS, SSAS, Apache WEB Server, Primavera, HTML/5,CSS, CGI/Perl, JavaScript, Confidential Cobra, Confidential WelcomRisk, Microsoft Project 2010, MS Project Server 2010, Internet Explorer, Geographical Information Systems, Microsoft Office, Microsoft Visio, Lotus Notes, MS Outlook, ANSI X-12 EDI, Automate 6 - Job Automation/Scheduler, FileZilla Client, WinMerge, Putty, Ultra VNC Client/Server, Schedule Task, SQL Developer, SQL Management Studio, pgAdmin 4, GoXML Mapping Tool, EDI: 301,309,315,322,350, 810, 850,855,997, Knowledge of Virtual Machine- VMware, VCenter, T-SQL, VB Script, GOXML, CMDB, NIST, SANS, ISO, Data Masking, PKI, OWASP, AES, 3DES, RSA, SHA, Informatica, Amdocs Valex xChange CRM, Brio, STOREDIQ, CA ITSM
PROFESSIONAL EXPERIENCE:
Confidential, Houston, TX
Sr. Programmer AnalystResponsibilities:
- Confidential providing IT support services, training and consulting to small to medium size businesses.
- Supporting and monitoring backend Apache web server & processes running on Oracle Solaris 11 production server, VB. Net applications, pgAdmin 4 databases, PostgreSQL, SSHNet and customer support to Broadband Service environment.
- Conducted basic through intermediate Excel 2013 training.
Confidential, Galveston, TX
Sr. Programmer Analyst
Responsibilities:
- Support IT Confidential Department providing technical expertise, project lead/management, execution and support in a cross disciplinary team implementing, customizing and integrating enterprise sustainability management information systems tasked to support over 85 various applications.
- Systems supported involved with Chargeback/Allocations, eDiscovery, Data Masking, ITIL applications, Application Security, Physical Security, Governance, Stored IQ, and Splunk.
- Sr. Technical Project resource leading a team of up to 15 plus internal and external resources in the installation and implementing of Stored IQ into the production Unix environment for eDiscovery and PII.
- Experience coordinating vendor solution delivery and partnering effectively with vendors to meet business needs.
- Developed Queries and Stored Procedures and analytical reports in Crystal Reports.
- Developed backend process with .NET, T-SQL, Stored Procedures, SSIS, SSAS, Crystal Reports for Active Directory integration, Access Management Systems, Internal Cafeteria Pay System and other backend system processes.
- Developed scripting to populated Microsoft System Center CMDB Database with metadata to provide input into NICUS MPWR for analytics and charge backs analysis.
- Experience with enterprise level security assessments.
- Developed diverse technical integrations using various technologies and processing environments.
- Proven ability to present and discuss highly complex technical information to users with varying technical expertise.
- Precipitated in Change Management and peer review to verify and confirm changes before moving into the production environment.
Confidential, Houston, Texas
VBA Programmer
Responsibilities:
- Contract developer tasked for maintenance development on complex MS Word document templates using VBA/XML and Macros.
- Automated the editing of documents for format, style, grammar/spelling, headers/footers and body to increase the efficiency of OIL Industry Plant Processing Documentation Developers.
- Modified MS ribbon to include new functionality of customized VBA code utilizing Office SDKs and API.
Confidential, Houston, Texas
Team Member
Responsibilities:
- Knowledge of Host security, platform architecture, network perimeter security, intrusion detection/prevention, application security modeling, physical security, systems integrity, and disaster recovery.
- Experience with threat modeling and vulnerability assessment.
- Knowledge of data protection mechanisms including an understanding of cryptographic algorithms such as AES, 3DES, RSA, SHA, etc.
- Solve problems, test approaches, and research solutions in the categories of computer network operations, information systems security, vulnerability discover and information assurance.
- Working knowledge of industry standards and frameworks (NIST, SANS, ISO).
- Implement technologies and communication infrastructure to manage and act on cyber threat to IT and national security systems.
- Use predictions and case management to analyze security events, incidents and processes and protocols.
- Manage investigative labs as teams to understand root cause of an incident and recommend appropriate remediation plan.
- Knowledge of server security, including web servers, app servers, PKI, COBIT, OWASP top 10, etc.
- Adult Learning training to instruct end users on best practices on reducing Cyber Risk in the workplace.
Confidential
Contract Developer
Responsibilities:
- Providing maintenance development on IRON SPEED generated .NET Vendor Application modifying and correcting reports and other issues.
- Utilize DBA skills to install multiple instances of SQL Server 2008 R2 and Migrated database from current legacy server to Blade server replicating current SQL Server 2005 production environment.
- Prepared Scope, Requirements and Process Diagram for new application development of a Uniform Management System and an application to utilize GIS to track location for trash, road hazards or other maintenance issues to be reported via a web application.
- Technology supported: SQL Server 2008 R2, Crystal Reports, SSRS, VB.NET, JavaScript, CSS and IRON SPEED, IIS 6.0.
Confidential
MS Project Analyst
Responsibilities:
- Consulted with Operations staff to determine tasks for master Work Breakdown Structure for each Project.
- Created dependencies for all tasks.
- Added resources to each task.
- Added master WBS for new projects to MS Project.
- Published Projects to MS Project Server.
Confidential, Houston, TX
SR. Programmer/EDI Analyst
Responsibilities:
- Managed, Developed and customized automated processes and procedures for the support of pre and post processing of ASCX12 transaction sets for 301,309, 315,322, 350,810, 850,855, 977 and UIIA EDI data on AIX and Windows Servers in Production Environment.
- Supported NAVIS EXPRESS and the pre-implementation of NAVIS N4 (TOS) terminal operation systems.
- Responded to daily support and resolutions of in-house, external clients and Customs (CBP) EDI issue.
- Strategically designed and implemented in-house information systems and networked software architectures that support core organizational EDI functions assuring their high availability and intersystem integration.
- Analyzed EDI specifications, monitor inbound and outbound EDI transactions.
- Troubleshooted and help assure quality and maintenance of the EDI Process.
- Prepared Environment for pre-implementation of NAVIS N4 to duplicate current production environment
- Prepared N4 that included; Java, XML Data Mapping of EDI, file structure, FTP, scripts and command files.
- Supported EDI software on a 24/7 basis when required and Special Projects when required.
- Developed ASP.NET Web Forms for intranet application utilizing JavaScript, CSS, VB.NET, SQL Server 2008 R2, IIS 6.0 Server 6/7, PL/SQL, T-SQL, SDK, API, Unit Testing and object-oriented design.
- Supported/Managed; Oracle 8i and SQL Server Databases 2008 R2, FTP access, PERL and VB.NET scripting/web app.
- Member of Confidential (Terminal Operator and Port Authority Subcommittee for EDI Standards) and subcommittees.
- Precipitated in Change Management and peer review to verify and confirm changes before moving into the production environment.
Confidential, Akron, OH
Web Developer
Responsibilities:
- Developed a functioning mockup of custom addition to Life Skills application according to change document specifications and client’s requests, as a contract Team member of Sr. Developers and Business Analyst.
- Utilized Visual Studio 2008, C#.NET, JavaScript, CSS, ASP.NET, Web Forms, Team Foundation Server (TFS) 2008, T-SQL.
- Developed use cases, workflow, screen mock-ups, and conversion requirements and performed Unit Testing.
Confidential, Cleveland, OH
Solution Developer/ Analyst
Responsibilities:
- Assisted in the upgrade to Tomoye Ecco 2.0 by developing CSS style sheet for custom presentation of their SharePoint ready Community Portal with CSS, JavaScript and, VB.NET.
- Tasked to complete enhanced customize reporting of the Community usage from the Tomoye Ecco system on Top Users, Community Activity and Lifetime Usage analysis with Access VBA and SSRS.
- Converted and verified fifty plus Access VBA applications and databases to Access 2007.
- Developed other reporting applications providing pertinent management information as needed with SSRS, Access, T-SQL and VB.NET 2005, Visual Studio 2005.
- Communicated status via Lotus Notes via Microsoft Office, Word, Excel and Power Point documents.
- Gathered business and technical requirements by interviewing users, analyzing documents and use cases for new customer reporting application.
Confidential, North Ridgeville, OH
Solution Developer/Analyst
Responsibilities:
- Completed a failed development project and reassured client confidence.
- Developed a value base pay system to track employee’s pay and work rating against skill testing and supervisor evaluations utilizing feature of Access VBA 2007 & Access VBA 2000.
- Prepared new scope, project plan, requirements and new list of deliverables to complete the project on time within new budget.
- Interviewed client to prepare uses cases to gather development and test requirements by analyzing the business needs.
- Developed new WBS in Microsoft Project with timelines, milestones and package implementations plans.
- Communicated with client for verification and sign off at the end of each development process milestone to reflect requirement document.
- Finished product saved managers an average of 20 hours per month.
Confidential, Akron, OH
Solution Developer/Analyst
Responsibilities:
- Converted VB6 and ASP legacy application to VB.NET, JavaScript and ASP.NET 2005 in preparation to create new SAAS application for Supply Chain Visualization as a member of developers.
- Prepared research for new product resulting in preliminary product scope statement.
- Developed prototype of new information processing application. Helped collect functional requirements and prepared business requirement documents using Enterprise Architect 7. 0.
- Prepared systems model diagram including processes, enterprise architecture, functions with other Microsoft software (MS Dynamics & BizTalk) and systems including GPS vehicle tracking with GIS visualization.
- Utilized Enterprise Architect to prepare use cases, class diagrams and database structures for new ASP application from existing standalone applications that will be converted into the new web based application.
- Prepared UML with Enterprise Architect 7.0.
- Assisted in process flow modeling; conducted and participated in sessions with system users; helped with design walkthroughs with stakeholders for base lining architecture.
Confidential, Cleveland, OH
Solution Developer/Analyst
Responsibilities:
- Primary NET Developer on the SPORT Upgrade Project to push out latest version of Saleslogix to remote Sales Agents.
- Developed VB.Net Scripting as part of the automated process to implementation of the installation of individual Sales Agent database for Saleslogix to over 500 remote PCs
Confidential, Houston, TX
Project Management Software Support Analyst
Responsibilities:
- Provided Product Support of Confidential ’s Project Management Software Suites. Worked remotely from home office.
- Primarily responsible for Confidential ’s Cobra Earn Value Management, Welcom Home and Open Plan Software’s.
- Strategically utilized leadership, communication and motivational skills to ensure CSI help desk centers were rendering quality service and achievement levels of service were being met.
- Supported clients in Windows environment with data base systems of Oracle, PL/SQL, SQL Server, T-SQL, .NET and FoxPro.
- Knowledgeable of competitor’s software for integration resolution of data including Microsoft Project, Project Server, Primavera (P3) & wInsight.
- Utilized WebEx for client communications to remotely view, diagnose and resolve problems online.
- Used Clientele and RNT CRM solutions to support customer service in the tracking of issues.
- Reviewed issues with client’s custom applications integrating with Confidential applications developed in Visual FoxPro, ASP.NET, LINQ, JavaScript, CSS, C#.NET and VB.NET
- Used the following communication documents: Word, Excel, Microsoft Project.
Confidential, Houston, TX
Application Support/Business Analyst
Responsibilities:
- Provided enterprise application support and management to production environment for an ASP (Application Service Provider) for Enterprise CRM system.
- Analyzed, designed and tested the migration of system enhancements from change control documents including reports, forms and processes.
- Created and executed test plans for functional and system testing
- Implemented projects and new functionality rollouts and upgrades of application server software for Oracle, Informatica, MicroStrategy, Brio, on clients Windows and Unix servers.
- Supported Valex xChange CRM and IBM Epiphany CRMs. Utilized T-SQL & PL-SQL.
- Coordinated patches and upgrades of Amdocs xChange CRM and Oracle.
- Maintained Windows and Unix Server, script files, schedule and unscheduled shutdowns, monthly maintenance and upgrades.
- Coordinated with project management and team leads on requirements, test plans, test cases, progress and documentations.
- Participated in Change Management and peer review to verify and confirm changes before moving into the production environment.
- Supported On-Call for SAAS for 24/7/365 uptime with other support team members.
Confidential, Houston, TX
Database Administrator/ DBA
Responsibilities:
- Designed and developed database structure, indexes, stored procedures, triggers and functions for development and reporting.
- Managed and supervised provisioning of all telemarketing data to thirty plus on and offshore call centers for campaigns by utilizing Visual FoxPro 8.0, T-SQL, reports and applications.
- Negotiated and prepared Service Agreements and other Letters of Agreements to Off Shore Calling centers for Telemarketing Campaigns.
Confidential, Houston, TX
Developer/Project Lead
Responsibilities:
- Maintained Confidential ’s Vector and StrataDial CRM telemarketing call center software.
- Assembled requirements and specifications for Design Document for Customized Integration with Genesis Accounting software, Goldmine Sales & Marketing CRM, Calyx Point Home Loan Processing software and other custom application integration with web sites. Develop according to SOW with milestone to review with client during SDLC.
- Assembled requirements, specifications, design document, development and implementation for customized integration.
- Utilized Visual FoxPro 6.0-8.0 with Window’s API, COM, ActiveX, DLL, OLE, DDE, JavaScript & HTML to integrate to DOS, Windows, Mainframe and Web based systems. Such as: Check and credit card processing, ACH, Personal Credit retrieval to application via the web, Web to database and database to web application, etc.
- Integrated Confidential CRM Telemarketing software with client specific solution for processing and reporting needs with custom and off the shelf software. Utilized SQL, T-SQL and PL/SQL.
- Prepared scope, project plan, requirements, time, resources and list of deliverables for all custom development.
- Developed WBS with timelines, milestones, client verification and sign off to verify development processes including change control.
Confidential, Houston, TX
Consultant/Programmer Analyst
Responsibilities:
- Designed programs for business applications utilizing gathered requirements from uses cases development and testing.
- Provided hardware and software support for small to medium size businesses.
- Designed, Developed and implemented customized software applications with Visual FoxPro 6.0 from contracted agreement.
- Prepared Statement of Work, project milestone and tracked progress with Microsoft Project to review with client during SDLC.
- Communicated with Lotus Notes, Microsoft Mail utilizing Microsoft Office Word, Excel, Power Point and Microsoft Project.
- Prepared scope, project plan, requirements, time, resources and list of deliverables for all custom development.
- Developed WBS with timelines, milestones, client verification and sign off to verify development process.
- Attended project planning meetings associated with new software application infrastructure integration to create Use Cases to gather requirements for development.