Objective

Senior level expert 25 years of IT industry experience specializing in Development projects with VB.Net, Microsoft Access, SQL Server, and Excel - is seeking opportunities for short/intermediate-term consulting or more permanent positions with either startup ventures or a more well-established company with a long-term role in a growing industry. Mark is an extremely solutions-oriented yet people-friendly professional with experience in multiple Data Reporting and IT Support Development roles, including: Data Warehouse/Data Analyst, Microsoft Access Developer, SQL Server Oracle Developer, Business Analysis, Database Applications Design, Development and support, MS Office/Excel Software Development, Visual Basic VBA, VB6, and VB.Net , Networking, and CAD AutoCAD/MicroStation support. Commercial experience includes work in Commercial Residential Real Estate, Health Care/Insurance Industry, Banking, Higher Education, Securities, Management Accounting Systems, Manufacturing, Staffing, Warehousing/Distribution, VAR/OEM Services Support, EDI, and Telecommunications.

Experience

Confidential

Database / Data Warehouse Consultant, Capital Stress Testing via Confidential

• TD Bank is a member of TD Bank Group and a subsidiary of The Toronto-Dominion Bank of Toronto, Canada, a top 10 financial services company in North America. TD Bank, America's Most Convenient Bank is one of the 10 largest banks in the U.S., with approximately 26,000 employees and deep roots in the community dating back more than 150 years. The Bank offers a broad array of retail, small business and commercial banking products and services to more than 8 million customers through its extensive network of approximately 1,300 convenient locations throughout the Northeast, Mid-Atlantic, Metro D.C., the Carolinas and Florida.
• I was initially brought aboard to assist in the maintenance and expansion of an existing EUC MS-Access Database application for the consolidation, processing, and export of corporate Stress Testing data form all business units for both Board of Directors and Federal regulatory reporting requirements, including DFAST, EWST, CCAR, FR Y-9C, FRY-14, etc.,.
• Later I was asked to begin assisting to develop Tableau reporting from the various Stress Testing data generated from the MS-Access EUC Stress Testing Database and other data sources and source bank systems. Data Warehouses.

Confidential

Application Dev Team Lead / Application SME / SR. MS Access Developer Confidential

• Independence Blue Cross is the leading health insurer in southeastern Pennsylvania. With our affiliates, we serve more than 7.5 million people nationwide, including 2.2 million in the region. IBC is an independent licensee of the Blue Cross and Blue Shield Association. This allows us to offer our members the best of two worlds: a more local community focus paired with the stability of the most recognized and trusted health insurance brand and the strength of the nation's most comprehensive health services network.
• I was Hired by UST Global to join IBC as a staff aug placement and specifically take on a maintenance role for an existing Medicare Individual Commissions Processing application in MS-Access 2007.
• My support role was changed into a Technical Design/Lead role in a new project to rebuild the application from scratch in an Oracle / Java environment with some overly tight timelines and with a different development team from another consulting firm. I gave technical direction, including developing very precise technical specifications, to both onshore and offshore resources in a multi-phased release schedule to meet critical business timelines and assure that critical business goals were met.
• The initial project went over budget due to two main factors: the consulting firm did not adhere to the Agile management plan for the development team, adding cost and time to the effort, and the existing Access application had produced even worse data issues than had been understood, so much additional data cleanup was needed.
• A new phase of the project is commencing to adapt the Individual Medicare Commissions application to a new set of core IT system infrastructure, replacing much of the source data feeding the new IMC application, and since the application is now adhering to core IT system architecture standards, another team is expected to do the additional work..

Confidential

Sr. Microsoft Access Developer

• Headquartered in Carlisle, PA, Ahold USA's Financial Services arm is a wholly owned subsidiary of Ahold USA, a company that employs about 120,000 people in the northeastern USA marketplace and is principally engaged in the Retail Grocery business under the store names: Giant, Stop Shop, Martin's, and Peapod..
• I was brought into their existing database upgrade effort to help them meet a company-wide implementation plan deadline for upgrading their computers from Windows XP/Office 2003 to Windows 7/Office 2010 with an expected implementation date of May 8th, 2013. We had migrated several of their 50-odd MS-Access database applications for the Accounts Payable department when their entire implementation plan was changed, altering the deadlines and extending their time for the upgrades resulting in not requiring further outside assistance with the project.

Confidential

Sr. Microsoft Access Developer

• company that employs about 120,000 people worldwide and is principally engaged in the research, design, development, manufacture, integration and sustainment of advanced technology systems, products and services.
• Headquartered in Bethesda, MD, Lockheed Martin is a global security and aerospace
• I was hired to replace an Intern who was returning to school and to complete a database project already underway. The project is to create an MS-Access planning tool for forecasting projected labor requirements over the next 12 months. The new project will replace an existing MS-Excel-based spreadsheet solution with a more robust and accurate database model.

Confidential

Sr. Microsoft Access Developer

Confidential., a minority owned Software Company, specializes in custom software solutions, offering expert-level services in .Net projects, SQL Server Design, Architecture, Development Hosting, Sharepoint Development, and service from industry-recognized Microsoft Access MVPs and a professional development team that specialize in MS-Access projects.

• I was hired as an expansion team member into the core MS-Access development team to work alongside Juan Soto, and Ben Clothier, both of whom are industry-recognized MS-Access MVPs and acknowledged experts in the MS Access developer community.
• I worked on multiple projects for several clients, including a non-profit customer, a Millwork company, a Real Estate / Title Services company with multiple locations, and other additional support tasks with other IT Impact clients.

Confidential

Consulting Sr. Microsoft Access Developer

• The Pennsylvania Department of Public Welfare Bureau of Information Systems is the state governmental agency which oversees multiple state governmental functions, including the Office of Children, Youth Families as well as Medical Assistance and Mental Health Substance Abuse Services, among other offices and services.
• I was contracted to work under the auspices of the Bureau of Information Systems to perform maintenance support tasks as well as plan for redevelopment of an MS-Access application used at multiple campus locations of the Pennsylvania State Mental Hospital network. The application was developed at one hospital and copied to other hospitals. Multiple parallel versions, and a transition to using off-site SQL Server database server farm caused multiple performance and scalability issues across the application.
• I was also tasked to develop plans and procedures to roll it out to remaining hospitals as an intermediate step to implement a full medical records system across the statewide system in coming years.

Confidential

SQL Server Programmer/Analyst / PHP Developer

• Paytime Paroll provides payroll processing services including tax payments, tax and benefits reporting, and 401K processing services for over 1000 client companies primarily in the Central PA Region and beyond.
• I was hired to perform support and programming services mostly to handle the workload of bringing customer accounts into compliance with the new Pennsylvania Act 32 requirements.

Confidential

Consulting VB.Net MS-Access Developer

• Sovereign is now part of Santander Group. Serving 80 million customers in 40 countries, Santander was named Best Bank in the World in 2008, offering a broad array of financial services, including retail, business, and corporate banking cash management capital markets private wealth management and insurance. Sovereign successfully expanded into New England in 2000, and the New York area in 2006. The expansion into New England included approximately 12 billion in deposits, 8.1 billion in loans, 281 branches, and 550 ATMs from FleetBoston Financial, which was the largest branch acquisition in banking history. Today, Sovereign offers more than 750 branches and 2,300 ATMs from Maine to Maryland.
• Performed multiple development and operations tasks to support a VISA to MasterCard migration for the banks entire portfolio of Debit cards over 1.5 million and ATM Cards, interacting with multiple back-end production systems: FISERV, 5th/3rd, and PCAS a Santander internal system , including a custom VB.Net validation application and multiple MS Access and SQL Server databases as well as their Informent data warehouse Oracle . This migration process was also taking place during a large system-wide migration from one set of Vendors' legacy external systems to an internal Santander-based set of systems, so interaction with multiple systems and data stores utilizing multiple workflow and dataflow processes was required to successfully complete the Visa-to-MasterCard conversion project's multiple phases.

Confidential

Sr. Microsoft Access Developer

• Ahold is an international retailing group based in the Netherlands, with powerful consumer brands in Europe and the United States. The foundation of our company is selling great food this is what Ahold is known for and is their core business. Ahold provides customers with great value and a convenient and innovative shopping experience with a wide range of products and healthy choices.
• Inventory Accounting group: Built a custom tool for performing mini data warehouse/data mining queries across multiple large weekly inventory transaction MS-Access database files built from scraping massive inventory transaction reports from mainframe source data - including the ability to span multiple MS-Access database files with the results from these queries. This system could accommodate source data and result data in aggregate sizes well over the 2GB MS Access database size limits and performed quite well over these large datasets, reducing what previously took hours of work to a few minutes.
• Inventory Accounting group: Constructed an automated database for building consolidated weekly inventory transaction and shipping summary status reporting across multiple business units and warehousing back-ends with the ability to accept data from multiple external sources, including email.

Confidential

Data Analyst

• The AmeriHealth Mercy Family of Companies comprises the largest organization of Medicaid managed care plans in the United States, touching 6.5 million lives nationwide. Amierihealth is the nation's expert and industry leader in the delivery of quality health care to low-income populations covered by publicly funded programs, including Medicare, Medicaid, and State Children's Health Insurance Programs.
• Performed data reporting and analysis using Microsoft Access against an Oracle-based Data Warehouse for various Members, Providers, and Claims data requests on both a scheduled and ad-hoc basis for multiple in-house data customers.
• Soon after starting this assignment, the company failed to negotiate renewed contracts with 2 major hospitals in their regional service area, resulting in a decrease in workload.

Confidential

Microsoft Access/Excel Developer via Sapphire Technologies

• Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management, and other financial and risk management products and services.
• Contracted by the Bank of America as a consultant to develop an improved add-in-based security system for MS Access database applications capable of withstanding the efforts of ethical hackers/security auditors. Unable to complete assignment within required time because of a temporary health issue.

Confidential

Consulting Microsoft Access/Excel Developer

• Foot Locker, Inc. is an international retailer of footwear through its large network of retail outlets throughout the United States, Europe, Canada, Australia, New Zealand, Puerto Rico, the Virgin Islands and Guam. Foot Locker operated 1,218 stores in all 50 states at the end of 2009 under the names: Kids Foot Locker, Lady Foot Locker, Footaction, Champs Sports, Footlocker.com/Eastbay, and CCS, among others. In addition to the retail business, other key business units include: Real Estate, Marketing, Global Sourcing, and Distribution/Logistics.
• Develop an Access database application from an existing Excel-based Retail Lease Management system including Database Design, UI development, import/update process development, and data migration from Excel and other corporate data sources.

Confidential

Consulting Sr. Microsoft Access/Excel Developer

• Highmark, created in 1996 by the consolidation of two Pennsylvania licensees of the Blue Cross and Blue Shield Association, provides millions of people with the security of quality health insurance as the largest health insurer in Pennsylvania. Based in Pittsburgh, Highmark serves 4.8 million members in Pennsylvania and West Virginia through the company's health care benefits business.
• Highmark's Executive Managers overseeing the Project Management Team required several improvements in the quality and availability of summary Project Team progress reporting from multiple project managers and implementation of new Project Issue Escalations and Resolutions reporting.
• Consulting role to enhance and expand an existing mixed Excel/Access Project Management Dashboard and Reporting application.
• Expand the Reporting capabilities to reflect new Issues Tracking metrics.
• Devise means of correcting for technical limitations of Excel arising from generation of large status reports in excess of several hundred pages.

Confidential

Consulting Sr. Microsoft Access Developer .

• HESS's Energy Trading Group had undertaken a new Demand Response Servicing line of Business in 2008 and was using an inadequate Excel-based tracking system for various customer and Administrative data. An entirely new system was needed to properly track and administer the various programs' handled by the Line of Business and those programs' complex and changing requirements over time.
• Hess Corporation is a leading global independent energy company, engaged in the exploration and production of crude oil and natural gas, refining and in marketing refined petroleum products, natural gas, and electricity. The Company operates about 1,360 Hess branded sites in 16 states along the East Coast of the United States, and operates refineries and distribution facilities along the eastern seaboard as well as jointly operating one of the largest crude oil refineries in the world in the Unites States Virgin Islands.
• Perform a full Business Analysis of the existing information and requirements.

The IT Department Managers and the Energy Trading Group Managers initially had widely differing viewpoints on the scope and complexity of the requirements and necessary scope of work for this application. The Energy Trading Group's managers viewed it more as a simple project, but the IT Managers viewed it as more complex than the Energy Trading Group's managers expected. At the commencement of the work, it immediately became apparent that the IT Managers were correct, and a complete Business Analysts was needed to properly define the tasks and data structures to meet the real needs of the new Demand Response Servicing group. This required interviewing the group members for their input on their tasks and the rules governing their work, development and approval of multiple new Use Cases, as well as determining proper data structures for handing both their required data elements as well as the changing relationships between them over the lifetime of their business process.

Confidential

• Define Data Interfaces: HESS Corp. has both an extensive IT Infrastructure and relationships with multiple external servicing contractors who perform certain monitoring installation and engineering work on behalf of HESS's Demand Response group at their customer premises locations. The Data requirements and interchange specifications for properly handling this data flow had to be designed and implemented.

• Determine Data Sources and level of effort for Production Data migration and Implementation: Differences in the customer-related data between the existing Excel data system and the corporate IT infrastructure needed to be identified and resolved, and a migration/replication infrastructure created to assure that future customer-related data remained in synch with the existing IT infrastructure where appropriate. In addition, a plan for migrating the Excel data into the new server-based data model needed to be defined and developed. An entirely new SQL Server database was defined and built as the back-end data store expressly for this new Demand Response MS Access application.

• Handle Ongoing need to adapt to changing data requirements. The Demand Response Group works with programs from multiple electrical industry regional grid management authorities, and subscribes their customers to those various programs as defined by the regional grid management authorities - with varying requirements and data elements particular to each authority and their specific Demand Response Energy Management program. These particular program requirements are also subject to changes over time. Therefore, in order to facilitate the necessary flexibility, a totally new template-based approach to manage the information and data flow over time for the various and changing Demand Response programs was devised.

• Development, Testing and Implementation. The actual software development effort was undertaken in parallel with the above analysis, design, and specification-making efforts due to the budgetary and time constraints placed on the entire project effort. The entire project was thus handled in a more agile manner as opposed to more typical predictive or waterfall methods that HESS's IT projects typically follow. As the clock and budget for the project reached its end, all the core operating components of the new system were fully developed, tested, and working. However, approximately 10 -15 of the overall system's additional features, primarily those needed to interface with vendors other systems and to build additional reporting functions, caused the final implementation to be delayed into the next year. Final development and implementation efforts were taken offshore for completion due almost entirely to budgetary concerns.

• Design and Program Documentation. Since the project required extensive analysis and design work and since it became clear that the completion of the project would occur in a new year and in new hands, extensive documentation of the design, methodologies data schemas, and interfaces used in the system were prepared to facilitate future work.

Confidential

Consulting Microsoft Access Developer

• DaVita provides dialysis services for those diagnosed with chronic kidney failure, a condition also known as chronic kidney disease CKD . DaVita has over 1,500 outpatient dialysis facilities and acute units in over 700 hospitals. DaVita is located in 43 states and the District of Columbia, serving approximately 115,000 patients.
• Short-term opportunity to augment in-house staff for a specific set up updates to an existing Microsoft Access application. Changes in regulations or other business rules resulted in the need to make changes in multiple databases and applications in a compressed timeframe. This assignment included the responsibility to modify database schema, make related User Interface improvements, and create some data flow interfaces to/from other systems.

Confidential

Consulting Microsoft Access Developer

• Nationwide Better Health was created from within the Nationwide group of companies in 2006 under the idea that helping employees and employers prevent sickness, or minimize its affects, is better for the employees, their employers, and for everyone's healthcare costs. Nationwide Better Health provides a set of integration services designed to help employers and employees better manage and benefit from their health care and prevention efforts with equal attention to reducing costs and quality of service and outcomes.
• Developed a database application for a new Employee Benefits Coaching line of business. The stated requirements were to use Microsoft Access 2003 as a front-end into an Oracle back-end data store, and that the application was to be utilized in a WAN Environment. This application was specifically intended to perform as a stop-gap measure until another existing application platform could be extended to handle the same business requirements.

• Overcame significant hurdles with specified project support personnel becoming unavailable at various points throughout the assignment, a lack of some timely decision-making from senior management, and several technical challenges. A carefully engineered Microsoft Access application which met all main objectives was delivered on time and within budget. Further, it easily met performance and reliability expectations despite our having used Microsoft Access within a WAN environment something which is never recommended .

• Utilized the Oracle Migration Workbench suite of tools to assist in generating Oracle and Access Schema and loading data into the environment for testing and implementation

Confidential

Senior Microsoft Access Programmer / Analyst

The Hershey Company is the largest producer of quality chocolate in North America and a global leader in chocolate and sugar confectionery. Headquartered in Hershey, Pa., The Hershey Company has operations throughout the world and more than 12,000 employees.

• Performed as both a Technical and database support as well as developer role for a large-scale SAP-based multinational manufacturer. Many database applications were built to fill productivity gaps in the SAP environment or were intended as temporary bridge applications between older legacy systems and as yet undeveloped future custom SAP extensions.
• Hundreds of Access and Excel applications were built and supported across multiple departments, geographic regions, and IT technologies. Continuous development and ongoing support for several dozen different databases and applications was performed regularly.

Confidential

Consulting Microsoft Access Programmer/Analyst

• Since 1987, LMS has been a leading staffing authority for temporary, temporary to hire and direct hire placement to the Legal, Healthcare Dental and Accounting professions for the south-central New Jersey and south-eastern Pennsylvania regions.
• Completed a short-term 2 week assignment to make improvements combining two separate, previously unrelated and independent internal Microsoft Access VBA/database applications. The assignment included adding features capabilities, making data schema modifications to merge two differing datasets into the new combined application.

Confidential

Sr. Programmer / Analyst

• Harrison Career Institute was a career training school who's primary customers were inner-city minority students seeking an improved career path. The school had expanded to serve 13 locations in NJ, PA, DE, and MD and was preparing to expand further when the federal Department of Education acted to expel the company from eligibility to collect student loan funds. This soon forced the company to stop doing business and close all campus locations.
• Created a Student Financial Records Management System in Visual Basic 6 and Microsoft Access 2002. The system employed an object-oriented design and implemented polymorphism via interface inheritance so a generic transaction posting engine could handle multiple specific transaction types from different sources. Efforts were underway to migrate this application to a SQL Server Back-End with a VB.Net/ASP.Net front-end in its next version scheduled for 2006.
• Developed new or enhanced existing Access Excel VBA-based database and Application systems for custom reporting and data control applications Purchasing, Student Records Management, Auditing controls for multiple business units, including Schools, Collections, and Wholesale Distribution units.

Confidential

• Built a Crystal Reports RAS-based Intranet web site for state-mandated Campus regulatory reporting compliance requirements
• Handled selected requests for SOX-related financial reporting requests directly from the CEO and CFO there were plans to take the company public so we were laying the SOX groundwork to be in compliance when necessary .
• Great Plains Dynamics Installation/upgrade, and ongoing support role, including performing a Scalable SQL->MS SQL Server installation migration upgrade
• Ongoing role as Tier-2 / Tier-3 technical support for handling problems escalated from other IT staff technicians.
• Designed and initiated procurement of corporate-wide WAN infrastructure system including handling documents for quotes, cost analysis, constructing specifications, and field survey notes for all campus locations.

Confidential

Consulting Microsoft Access Programmer/Analyst

Stanley Tools builds and repairs tools primarily for individuals and professionals in the construction and maintenance trades.

• Completed a short-term 2 week assignment to update an existing Repair Ship Workflow Management Access 97/SQL Server application. The task was to revise the system to implement a new fiscal calendar for all functions, especially all reporting.

• Created a custom solution using object-oriented approaches to resolve the fiscal calendaring requirements in a flexible and easily maintainable way. This approach has withstood the test of time as a 2010 follow-up with this client indicated that this solution is still in use and performing flawlessly with no modifications to date, over 9 years later.

Confidential

Programmer/Analyst

• WMT R performs scientific and metallurgical materials testing for customers in the raw materials and related manufacturing industries, including automotive and aerospace applications.
• performed maintenance and support programming and systems analysis work for existing laboratory-equipment-based data extraction, processing, and reporting applications for a variety of Instron hardware in a mixed Windows 9x and VB3/4/6 environment.
• updated various modules for materials testing procedures, interfacing directly with Instron Test frame equipment and extracting real-time test telemetry for reporting.

• Created a new custom Visual Basic 6 reporting application using SQL Server 6.5 and Crystal Reports
• Created Access 97/VBA application for monitoring customer-specific test productivity metrics
• Provided Technical and programming support for EDI system used to exchange order and testing results information to selected clients.

Confidential

Operations Manager

• Integrity Online was one of the first Internet Service Providers providing a content-filtered Family-friendly-ONLY Internet Access Service for retail and commercial accounts. It operated as a regional franchise system on territorial geographic/Telecomm LATA boundary basis. This business failed to generate sufficient revenue to continue operations after 18 months owing largely to a misplaced marketing emphasis on retail rather than commercial accounts.
• Performed the role of Chief Operating Officer, Managed all day-to-day business operations of a family-friendly ISP service including staffing, sales marketing, accounting, and contracts management, among other roles.
• Helped prepare business plans including detailed financial and operations planning documents and analysis of available service territories for both market analysis and operational infrastructure planning and costing purposes.

Network Engineer / Application Support Engineer

Confidential

Performed LAN, Server workstation installation support duties for a VAR in the CAD business, including sales support and preparing quotes and responding to RFPs in addition to standard technical support and on-site client contact work

CAD / Visual Basic Programmer

Confidential

Performed Visual Basic 3/4 and MS Access 2.x Programming and CAD technical support duties for a Center City Architecture Engineering firm

CAD Programmer / Systems Manager

Confidential

Designed developed AutoCAD/AutoLisp programs for Facilities Management applications for this Center City Interior Design firm

CAD Programmer / Network Support Engineer

Confidential

Performed various CAD programming and network technical support duties for a large Center City Architecture Engineering firm

CAD / Database Programmer

Confidential

Built Automated Mapping/Facilities Management software for AutoCAD/AutoLisp /xBase

Computer Center Operations Staff

Confidential

Data center operations staff in a large PRIME minicomputers-equipped data center

Computer Center Operations Staff

Confidential

Data center operations staff in a large PRIME minicomputers-equipped data center

Systems Application Software Experience

MS-DOS, Windows: 3.x-9x, NT, 2000, XP, 2003, Vista, 7 including Microsoft Virtual PC and Microsoft Virtual Server , SQL Server 2000/2005/2008, SSIS, SSRS, Crystal Reports, MS Office 4.x-2007 w/Access Excel VBA, including COM/ActiveX Office Automation, SQL/T-SQL, XML