Senior Programmer Analyst Resume
OBJECTIVE:
A position in analysis, administration, design, programming or reporting of data or systems
SUMMARY:
Success - driven computing specialist with more than twenty years of experience in coding and systems analysis/design including a wide variety of hardware and software applications
TECHNICAL SKILLS:
Languages: ASP, ASP.NET, COBOL, Cobol II, C, C++, C#, CSS, dBase, DHTML, Easytrieve, Easytrieve Plus, FOCUS, FoxPro, CFML, HTML, XML, Java, JavaScript, JCL, SAS, PL-SQL, SQL, Transact SQL, Synchsort, Visual Basic .NET, Visual Basic, Visual Basic Script - VBScript, Visual Basic for Applications - VBA, Visual FoxPro
Windows Software:
Database: Approach, Microsoft Access, Visual dBase, DB2, Paradox, Oracle - SQL Plus / Developer, COGNOS Powerplay, Microsoft SQL Server 2000 - Query Analyzer / Enterprise Manager / DTS / Stored Procedures, Microsoft SQL Server 2008 - Management Studio / Stored Procedures, 3M Analytical Workstation, ADO, ADO.NET, DAO, ODBC, OLE DB
Spreadsheet: Lotus 1-2-3, Microsoft Excel, TM/1 Perspectives
Presentation: Crystal Reports, PageMaker, Microsoft PowerPoint, Microsoft Publisher, ViSiO
Word Processing: Ami Pro, WordPerfect, Microsoft Word
Internet: Macromedia ColdFusion, Macromedia Dreamweaver, Microsoft FrontPage, Microsoft Visual Interdev, Microsoft Internet Explorer, Netscape Communicator, Firefox, WS FTP Pro
Other: Adobe Acrobat, FoxMeyer Quest, Microsoft Office, QuickPay, ETNet 2.5, REMS Property Manager 500, Microsoft Outlook, Novell Groupwise, PKZIP, SPSS, WinZip, Microsoft Visual SourceSafe, RDP
Machines: IBM 4381R24, IBM 3090-400e, IBM ES9121, Micro VAX, IBM, IBM compatible and Macintosh personal computers, Brother word processors, Hewlett Packard, OkiData, and Epson printers, modems, Telxons
Operating Systems: CMS, ISPF, MVS/XA, MVS/ESA, QMF, TSO, VMS, VM/SP, MS-DOS 6.22, Windows 3.1, Windows for Workgroups, Windows 95/98/NT, Windows 2000 Professional, Windows XP, Windows 7, Linux
RELATED WORK EXPERIENCE:
Confidential
Senior Programmer Analyst
Responsibilities:
- Updated ASP Classic code in the HOA Tracker application to exceed original user requirements including the associated stored procedures
- Completed analysis of the Net Present Value Visual Basic Script (VBS) using screen scrapes as a data source
- Created a test version of the extensive Loss Mitigation application
- Configured IIS 5.2 to support these applications
- Remoted into virtual web and database servers using RDP
Confidential
Database Administrator
Responsibilities:
- Wrote code in ASP.NET 3.5, .NET 2008 and SQL Server 2008 using stored procedures to create a new RLD and ESC online system for training, testing and recertification including an e commerce capability
- Practical “hands on” experience configuring and troubleshooting both IIS5 and IIS7
- Created a web-based system consisting of 300 web pages
- Performed client side operations using JavaScript at the key stroke level to prevent incorrect entries into textboxes by users
- Installed SSL certificates to run the entire site using encrypted HTTPS for better security
- Created web-based system consisting of 300 web pages
- Accessed data in this RLD online system via stored procedures using SQL techniques such as joins, REPLACE, CONVERT, temporary tables and table valued parameters
- Instantiated controls in the RLD system such as GridView, ListView, RadioButtonList, LinkButton and Calendar, various Validator controls: RegularExpression or Custom
- Worked with the Confidential AITR and VITA / NG to transition the new RLD and ESC online system into production
- Updated legacy code quickly when VITA/NG gave little notice of a IP address change to minimize downtime which had previously been weeks to only 2 days
- Instituted the use of an English like URL to prevent future IP address changes from causing system downtime
- Detected lost data at Confidential during the statewide SAN outage of 2010
- Increased the RLD certification testing fee when others said that such an increase was “not possible”
- Diagnosed and corrected a security problem involving authentication to insure the stability of the RLD / ESC online system used for certification testing and information
- Developed detailed design specifications for the first phase of the Enterprise Web Site including the data model
Confidential
Database Administrator
Responsibilities:
- Created through VITA and NG database access to provide users with real time information for decision making
- Installed new SQL Servers using SQL Server 2008
- Installed SP1 and SP2 on SQL Server 2008 successfully as the DBA
- Created roles and assigned rights to these roles to provide users’ access to their data
- Performance tuned databases by reducing the number of records by working with users
- Monitored SQL Server servers for performance and changes
- Expertise using T-SQL for both DBA and developer tasks
- Established productive working relationships with users, vendors, peers and management
- Assisted in future capacity planning for the Enterprise Web Site
- Created and Restored databases using manual backups or backups created by the nightly SQL Server Agent job
- Used SQL Server 2008 backup (.bak) files and recovery procedures to weekly provide users access to their data which has never happen previously for a system which has been used since 2004
Confidential
Data Manager
Responsibilities:
- Wrote SQL queries using PL/SQL to provide answers and information to users
- Assisted in the sdlc of current automation project to improve efficiency by developing a user oriented design document
- Worked as a team member to make significant progress on a project to share health related data with the state of North Carolina
- Acted as liaison with the department's providers of computer related services
- Raised departmental awareness of how information technology could be directly applied to the department's information needs
- Conducted a series of meetings to gain direct access to departmental data for the purpose of automated ad-hoc report creation
Confidential
Senior Policy Research Analyst
Responsibilities:
- Collected , processed and reported of facilities related information including institution, campus and room level facts in a data warehousing environment by writing code in HTML, DHTML, ASP, CSS, SQL and VBScript
- Created data transformation packages (DTS) in SQL Server 2000 using advanced Transact SQL to ETL text and Excel files into a data warehouse
- Wrote SQL queries using full outer joins to check incoming data against the information in an existing table to insure that the new data did not contain any new values not already in the existing table