SUMMARY:

• I am a highly skilled Systems / Programmer Analyst with over 20 years of proven ability to complete complex and challenging assignments under pressure and on time.
• As an exceptional communicator, I have given technical presentations, CA’s Technicon 95 on Building Graphical Databases and the Smart Card Applications and Technologies Conference in Washington DC on Alternate Methods of Smart Card Security.
• I have acted in roles as diverse as Project Manager, Team Lead, Business Analyst and others.
• I have a strong ability to focus in on the heart of the problem and identify workable solutions.
• I also excel in research, analysis and problem solving.
• Salvaged a failing project, completing it in record time and within the original budget.
• Creation of new applications to remove redundancy and eliminate manual processes.
• Wrote the HIPAA compliance guidelines for covered entities.

TECHNICAL EXPERTISE:

Languages: C#, ASP.Net, SQL, LINK to SQL, JSON, Visual Basic, VB.Net, VBA, VB Script, HTML, Classic ASP, XML, JAVA, JavaScript, DHTML, COBOL, MVS/TSO, C/C++, ActionScript, 80xxx/68000 Assembly

Applications Software: Visual Studio 2005 - 2013, Reporting Services (SSRS), SSIS, SQL Server 2008/2014, Oracle SQL, Exchange Server, IIS, SharePoint, WCF, MS Access, MS Project, MS Excel, Visual Age for Java, Adobe Photoshop, Paint Shop Pro, trueSpace (3D Graphics), Crystal XI, ClearQuest, Rational tools, MS TFS, HP Quality Center, Serena, MS Word, Excel, PowerPoint, Outlook, Silverlight 4. I am currently updating my skills with Docker, .Net Core and MVC.

Operating Systems: MS Windows XP, 2000 - Windows 10, TSO/MVS, MSDOS, CARTOS

PROFESSIONAL EXPERIENCE:

Confidential

.Net Developer

Responsibilities:

• Migrated existing applications to Azure AD.
• Set up new application accounts, roles and members.
• Developed a Single Sign - on processes for the Confidential program.
• Researched and implemented SAML2 and OpenID integration processes.
• Developed an in-house application to automatically repair damaged .tiff files.
• X-ray and scanned images handled under IBM s Confidential application often contained errors that prevented them from being viewed in the web browser.
• This application would open the .tiff files, extract the individual images, repair and then recompress them.
• The application is written in C# using Visual Studio 2019.
• Other duties include SQL Server troubleshooting and development, development and deployment of Windows Services, application design and upgrade using SQL Server 2016 and Visual Studio. Newer applications include .Net Core and MVC.
• Responsive mobile website providing analysis tools for the individual investor. Written in C# using Visual Studio. The main ‘engine’ behind the site is a SQL Server backend that extracts data from the 10 million+ records, performs the data analysis and then forwards the results to the UI using JSON. The interface uses Bootstrap with Javascript and JSON for the data presentation of the graphs and charts.
• There are two supporting processes in the application: The first is an ETL process that uses an SSIS package to download daily price data from the vendor. The data is extracted from zip files, formatted and loaded via a multi-threaded process into the SQL Server database.
• Second, an ETL process downloads quarterly financial statements from the SEC. A multi-threaded process opens the .tar files, locates the financial statements, reads and extracts the financial data from the forms then loads the information into the SQL Server database.

Confidential

Business Analyst/Developer

Responsibilities:

• Managed the ground up business analysis of two major projects and several smaller ones. Followed the projects from inception to implementation. The Confidential project is an evaluation program that tries to identify youths most prone to continued criminal activity.
• The Group Homes Placement manages the placement of youths into foster or short term care facilities.
• In these projects, I was responsible for determining the business functional requirements, establishing the technical requirements and designing the business workflow.
• Once the project solutions were established I followed through with code review and unit/system testing to be sure the final product matched the client expectations.

Confidential

Responsibilities:

• Convert Access and Excel reports to SQL Server and built the ASP.Net web application.
• Develop SSIS packages to handle automated report scheduling and database updates
• Created ETL packages to import various Excel and Access data into the SQL database.
• Write complex stored procedures.
• Created several applications to handle creation and management of reports and direct import of Excel spreadsheets into the SQL Server database.
• I developed an Excel to SQL import application that allowed users to drop excel spreadsheets into a drop zone, map columns to the destination table and have the data extracted and stored into the SQL Server 2012/2014 database. This process provides live data to feed the slowly changing dimensions of the Performance Measures Dashboard in near real time.
• I also created complex, multi - level SSIS packages that gathered data from the program offices and other data collection points, updated all tables, generated new reports, scheduled data extraction, conversion to PDF format and then transferred to the print vendor via FTP upload. This was a fully automated process.

Confidential

Responsibilities:

• I built a system to handle the creation, tracking, and management of all reports.
• The utility maintained a database that kept track of changes in report location, security access, report owners, and other functions.
• One of the most complex parts of the utility was the management and coordination of reports between development and production servers.
• This included management of the 32 sitemaps in the tree view.
• This utility also automated the report build processes that would update history tables at the beginning of each month. Reports could be scheduled to run daily, weekly, monthly, quarterly or annually. Data from up to 20 different programs can be combined to provide complex analysis and reporting to meet both state and federal requirements.
• Successfully managed and completed the VS 2010 to VS 2013 upgrade and conversion of existing SSIS packages, reports and programs
• Led the design, development and execution of unit/system testing plans
• Created user manuals and other documentation

Confidential

Software Architect

Responsibilities:

• Performed Business Analysis, functionality and project design for the project.
• Determined current functionality and defined parameters for upgrade to a web based solution.
• Redesign old Paradox database for Oracle SQL database.
• Establish formal business rules and define processes to make the project more compatible with California’s safety inspection process.

Confidential

Software Architect

Responsibilities:

• A short term project to complete an application started by another contractor who was unable to meet the requirements.
• Successfully completed the project on time, rebuilding the user interface, enhancing the database and implementing the required functionality.
• The project was done in C# using Visual Studio 2010, .Net 4 framework and SQL Server 2008 database.
• Project provided import/export interface to the COBOL MVS/VSE Mainframe database.

Confidential

Responsibilities:

• Developed Web and Desktop applications for the world’s largest background check company.
• Worked in a team environment with 14 local and 800 developers in India.
• Large enterprise wide application supporting over 2500 clients.
• System used online applications, auto-submit orders, bulk ordering process, job board support and background user administration systems.
• Provided hot fixes, troubleshooting, new product development and product deployment.
• Done in C#, SQL Server.
• Tools included HP Quality Center, version control via Tortoise SVN, Cisco VPN and Infragistics tools.

Independent Consultant

Confidential, El Dorado Hills, CA

Responsibilities:

• Developed a single sign-on an enterprise wide system, integrating three large medical information companies with millions of clients.
• The databases consist of thousands of tables and stored procedures.
• The technologies included Classic ASP, C# .Net, VB .Net and Web Services.
• The application was to merge the various technologies and make them work seamlessly together as one.
• Technologies used included Microsoft .Net Framework, C# ASP .Net, Web Services (SOA), Windows Communication Foundation (WCF), SharePoint Services (WSS), SSRS and SSIS. The databases are SQL Server 2008 and Oracle 11.