Senior Programmer Analyst Resume
Jacksonville, FL
SUMMARY:
- Highly qualified senior level technical consultant offering over 20 years of software development and management experience. This experience also includes senior level business and software analysis within several business areas including Banking, Credit Card Industry / Retail, Customer Service, Data Communications, Travel Technology / Retail, Sales / Marketing, Engineering / Operations, Reassurance, On - line Development, and Information Technology (IT).
- Software Engineering
- Business Intelligence / OLAP
- Multi-Dimensional Expressions (MDX)
- Data Warehousing
- Database Design and Development
- Project Management
- Web Application Development
- EnterpriseReporting
- .Net Development
- Office Web Components
- Business Analysis
- Technical Writing
TECHNICAL SKILLS:
Technical: ACCESS, Active Directory Agile Scrum Methodology ASP & ASP.NET (1.0-4.0) Assembler Language (Series 1/Intel/Motorola) Audacity Authorware Professional C, C++, C# CGI Clarify eFrontOffice Clear Basic (Clarify) ColdFusion/Dreamweaver COM/DCOM CSS Director EDX/EDL ETL HTML/DHTML InstallShield IIS InterDev JavaScript Mathematica MS Office MS Project MS SQL Server (6.5-2008) NET Framework (1.0-4.5) Oracle (8i-11g) Pascal PERL Prolog Regex Ruby SSIS/SSRI Technical Writing (Editor/Writing) Telerik TFS LINUX, UNIX VB, VB.NET, & VBScript Visual SourceSafe Visual Studio ( ) Windows 2008 Server, Web Services WebTrends XML/XSL
PROFESSIONAL EXPERIENCE:
Senior Programmer Analyst
Confidential, Jacksonville, FL
Responsibilities:
- Responsibilities include working closely with customers, business analysts and team members to understand business requirements that drive the analysis and design of quality technical solutions. The solutions have to be aligned with business and IT strategies and comply with the organization’s architectural standards.
- This analysis includes life cycle and responsibilities also include the skill set for designing, coding, testing, implementing, maintaining and supporting applications. Overall responsibilities include participation in component and data architecture design, performance monitoring, product evaluation and buy vs. build recommendations.
Senior Programmer Analyst
Confidential, Sacramento, California
Responsibilities:
- Hired to design and develop components of a voting transaction simulation test system capable of providing and handling responses to a number of web services used by a number of states to transport data between Confidential ’s voter management application and actual state voter management databases.
- Extensive knowledge of Web Services, SOAP protocol, MS SQL Database stored procedures and triggers was important due to the overall complexity of the testing system’s architecture. The development was completed in C# and there were some applications originally developed in VB.Net requiring retrofit into C# applications.
Senior Programmer Analyst
Confidential, Sacramento, California
Responsibilities:
- Designed, documented, developed and implementation of an automated fault-tolerant application written in C#.NET and MS SQL 2008. Data was received on a daily basis from 75+ vendors that Lumens sells products for on their commercial Internet presence. Data feeds are sent or pulled from vendors through EDI, FTP, and MS Exchange.
- Data received via FTP and MS Exchange were received as .CSV, .TXT, .XLS, and .XLSX file types. The data was moved utilizing additionally scheduled MS SQL stored procedures and disseminated to various systems responsible for accuracy and quantities of products sold on the Lumens commercial web site. Statistics were created on-the-fly as each vendor file was processed. Measures on these statics were reported to upper management helping them gauge vendor pricing and volumes for all available products sold.
- A separate UI was developed in ASP.NET utilizing access control through Active Directory. This application provided access to all aspects of the data amassed by the application for internal use by Vendor Merchants and Upper Management.
Business Intelligence Specialist (Financial contract)
Confidential, Roseville, CA
Responsibilities:
- Responsibilities included the definition, implementation and support BI reporting using an Italian made BI Management tool called Tagetik which sat on top of Microsoft Excel. These responsibilities included the development of native Tagetik reporting, conversion of existing reports written in Business Objects and updates to existing reporting as new methods are researched and proven.
- Suggestions for improvement were made on an ongoing basis with internal Bank as well as Tagetik's support and development staff. Issues encountered with Tagetik were maintained and reported to help ensure a minimization of future issues.
Consultant / Systems Analyst (contract)
Confidential
Responsibilities:
- Acted as a liaison between the business partners and technology. Worked closely with business partners and Application Development to analyze and design an end-to-end design for an in-house Enterprise level mortgage application. This included the creation of associated high-level business requirements functional specifications per changes required in different Federal Loan Programs. Supported the Technical Project Solutions Group in integrating technical processes throughout the Project Life Cycles and played a key role for a successful project implementation including the completion and ownership of a the approved design including required data mapping, system process flows and use cases.
- Identified and assessed project risks which may have impacted project success and communicates to this information to Program Management in a timely manner. Supported Application Development, QA and Business Partners in testing phases of the project and during post implementation validation. Made recommendations for changes to MS SQL Database to handle to support numerous changes requested by the Underwriting Department.
Consultant/Senior Programmer and Systems Analyst (contract)
Confidential
Responsibilities:
- Responsible for project analysis and development of a real-time WinForm application capable of handling transaction data sent via multiple communication protocols related to the power and renewable power industries. Performance being a major consideration required the additional development of an internal database mechanism capable of maintaining data pass thru between protocols and other internal database structures. The WinForm application was then converted to a .NET 4.0 web application to allow remote management of the application. TFS by the project manager to set up development streams for development. TFS was also used by multiple development staff to lock files once projects were completed, tested and builds completed. We also used the ticketing functionality to report issues to developers in order to manage development fixes.
- Performed a complete analysis and mapping of a national food manufacture's BI Reporting system and structure. Identified problem areas and described code changes in ETL Data Flow, Stored Procedures, Indexes and various table schema changes, necessary to meet project goals for accuracy and performance. Completed changes to data extraction processes (ETL scripting using C#). Provided on-going maintenance. Additional changes were made to Data Cubes to handle new types of reporting and data feeds to the Data Farm.
- Responsible for upgrading and improving performance of international reporting system. Upgraded in-house data extraction applications from VB6 to C#. Eliminated issues within stored procedures written in Oracle PL/SQ and simplified through development of new packages taking advantage of backend processing. Discovered and made changes to data transport application to eliminate data disconnect during data updates to international locations.
Project Manager/System Analyst
Confidential, St. Louis, Missouri
Responsibilities:
- Responsible for COT software related to International Letters of Credit, streamlined and modernization of Enterprise Loan Processing System, Online Banking, and Mortgage Infrastructure. Worked in concert with all departments to achieve unique solutions. These departments included Network, Server and Database Infrastructure and support. Supported departmental development staff as a DBA by performing database operations such as backups, production to test data synchronization, development of Stored Procedures and DTS packages, as well as, data tuning. Produced many types of reporting using
- Crystal Reports and eventually Reporting Services 2005. Worked as a mentor to teach development staff proper development methodologies for .NET VB.NET and C#. Used Team Foundation Server when it first came out as a method of creating, and managing development projects. This became a part of our internal methodology. Worked with upper management, as well as, project managers to develop for development staff on testing of new projects developed in .NET.
Systems Analyst/Senior Programmer
Confidential, St. Louis, MO
Responsibilities:
- Analyzed the customer's ERP process and proposed a conversion plan to allow them to migrate from ASP, VB, to .NET 2.0 technologies, as well as recommended and performed updates to their XML Transport Layer linked to an AS400 database.
- Additionally, an entire Windows CE application was rewritten to include a new stock exchange method for data integration from the ERP system into the Stock-to-WIP inventory disbursement located as part of the AS400 database.
Systems Analyst
Confidential, Evansville, IN
Responsibilities:
- Hired to develop a conversion plan from VB6 to a .NET 1.1 architecture including VB.NET. The analysis included going through a large existing ASP/COM infrastructure and rewriting many of the COM objects into Web Services to allow a more distributed architecture.
- Other recommendations in the project plan included offloading application processing where ever feasible to the SQL2000 backend. As backend processing increased so did the overall performance of the converted ASP.NET client-side application.
Senior Programmer Analyst
Confidential, Miami, Florida
Responsibilities:
- Contracted to analyze existing methods of investigative data retrieval using a mixture of applications and manual operations. Responsibilities included the creation and management of a three person development team to complete the resulting designed multi-tiered data integration solution using a combined WinForm / ASP.NET application written in C#. The data tier to automated data retrieval from sources including Miami-Dade Country as well as, paid government and commercial data resources.
Director of Systems Development
Confidential, Miami, Florida
Responsibilities:
- Recruited by the CEO to build an advanced team of 14 .NET developers from all over the US. Partnered with company management, headquartered in Virginia, as well as, the upper management from all the major cruise lines to design, develop and implement software and database solutions thereby modernizing existing antiquated reservation and data management systems.
- The products developed included the first reservation engine developed solely developed in C# and was sold and adopted by a number of the participating major cruise lines. Enhanced existing applications with built-in access control opening the door for sale to travel agencies nationally. Worked as a mentor and team lead for all projects developed in the Miami Travtech facility.
Systems Analyst
Confidential, Boca Raton, FL
Responsibilities:
- Hired to investigate and implement improvements to Fiber Optic supply chain management, business processes and product development established by local and global Engineering, Logistics and Manufacturing groups.
- Responsible for the redesign of the CRM solution originally developed using Clarify eFront Office. Completed the development of a ColdFusion application for Fiber Optic data manipulation which provided the capability automatic data retrieval from email sent by Field Engineers, interfaced with Mathematica and reports sent to Engineering and management.
Director of Systems Development
Confidential, Delray Beach, Florida
Responsibilities:
- Lead a 41-member development team consisting of business analysts, project leaders, writers, graphic artists and programmers focused on designing and developing internet and desktop applications for the cruise industry. Mentored development staff on new techniques for software and database development. Successfully re-designed both the company's desktop solution and commercial internet website to streamline cruise purchases (traffic: 3 million plus visitors per month).
Development Trainer/Senior Programmer
Confidential, Boca Raton, FL
Responsibilities:
- Hired to design and develop a new architecture and infrastructure framework to facilitate the company’s desire to offer distance learning tools and applications to broaden and support the customer base for a leading provider of access control and integrated management systems.
- Trained and managed a team of 3 developers to handle the additional workload related to web site and development. The applications developed were the first of their kind in the Access Control Manufacturing business.
Data Encryption Programmer
Confidential, St. Louis, MO
Responsibilities:
- Created a database engine written in IBM Series 1 Assembler to handle the intri Confidential es associated with the maintenance of a Global Encryption Key distribution and synchronization of Encryption Key servers located in St. Louis and New York City.
- Discovered a bug in the Confidential Encryption Algorithm (Military Level Encryption) saving $1.2 Million during encryption hardware acceptance phase.
Owner/Senior Programmer
Confidential, St. Louis, Montreal, Miami
Responsibilities:
- Created a multimedia business originally to develop large Computer Based (CBT) applications for Fortune 500 companies across the U.S. and Canada. With the advent of the internet this company's products expanded to mesh CBT and other technologies with the internet.
- Clients included Confidential, Newbridge, Confidential, Confidential, Confidential, and Facts and Comparisons (the World's largest drug publishing company.
Confidential, Semi Valley, California
Responsibilities:
- Acted as a liaison between the business partners and technology. Worked closely with business partners and Application Development to analyze and design an end-to-end design for an in-house Enterprise level mortgage application. This included the creation of associated high-level business requirements functional specifications per changes required in different Federal Loan Programs.
- Supported the Technical Project Solutions Group in integrating technical processes throughout the Project Life Cycles and played a key role for a successful project implementation including the completion and ownership of a the approved design including required data mapping, system process flows and use cases. Identified and assessed project risks which may have impacted project success and communicates to this information to Program Management in a timely manner. Supported Application Development, QA and Business Partners in testing phases of the project and during post implementation validation.
Power Company and Renewable Energies Application Development
Confidential - Sacramento, California
Responsibilities:
- Responsible for project analysis and development of a real-time WinForm application capable of handling transaction data sent via multiple communication protocols related to the power and renewable power industries. Performance being a major consideration required the additional development of an internal database mechanism capable of maintaining data pass thru between protocols and other internal database structures. The WinForm application was then converted to a .NET 4.0 web application to allow remote management of the application.
- TFS by the project manager to set up development streams for development. TFS was also used by multiple development staff to lock files once projects were completed, tested and builds completed. We also used the ticketing functionality to report issues to developers in order to manage development fixes.
Food Manufacturer
Confidential - Sacramento, California
Responsibilities:
- Performed a complete analysis and mapping of a national food manufacture's BI Reporting system and structure. Identified problem areas and described code changes in ETL Data Flow
- Stored Procedures, Indexes and various table schema changes, necessary to meet project goals for accuracy and performance. Completed changes to data extraction processes (ETL scripting using C#). Provided on-going maintenance.
Actuarial Development
Confidential, St. Louis, Missouri
Responsibilities:
- Responsible for upgrading and improving performance of international reporting system. Upgraded in-house data extraction applications from VB6 to C#. Eliminated issues within stored procedures written in Oracle PL/SQ and simplified through development of new packages taking advantage of backend processing. Discovered and made changes to data transport application to eliminate data disconnect during data updates to international locations.
Confidential, Boca Raton, Florida
Responsibilities:
- Hired to investigate and implement improvements to Fiber Optic supply chain management, business processes and product development established by local and global Engineering, Logistics and Manufacturing groups. Responsible for the redesign of the CRM solution originally developed using Clarify eFront Office. Completed the development of a ColdFusion application for Fiber Optic data manipulation which provided the capability automatic data retrieval from email sent by Field Engineers, interfaced with Mathematica and reports sent to Engineering and management.