Project Sql Server

Thomas A. Marasco

*** ******** *****

Evans, GA *0809

C: 716-***-**** e-mail: ******.*.*******@*******.***

H: 706-***-****

Information Technology Manager with solid management, leadership, project management, and technical skills. Effective in communicating with all levels of senior management and end-users. A hard-working, dependable professional.

TEKsystems, Durham, NC November 2016 –

January 2017

Security Threat Modeling Analyst / Architect November 2016 –

January 2017

At TEKsystems I de-architected applications for the Fidelity Threat Modeling Team. The team used the STRIDE Threat Model to determine the threats. I worked for a client in which I was part of a team that reviewed multiple applications to determine if the following threats could be made against them:

Spoof the identity of a user

Tamper with the application data

Repudiation / Non-repudiation

Information Disclosure

Denial of service (DOS)

Elevation of privileges without consent

Additionally, I worked with a Penetration Testing team to guide them through the penetration testing of the applications. Finally, a Security Threat report was created for each application by the Fidelity Threat Modeling Team.

NIIT Media Technologies (NMT), AUGUSTA, GA April 2015 -

December 2015

Senior Solution Architect April 2015 -

December 2015

At NMT, I was a Solutions Architect for the web advertising and classified ads published on the web by various newspapers in the Morris Publishing Group using the Drupal 7 environment for the content management system. I had to work with a vendor as I architected the Real Estate Classified ads for ten newspapers. The vendor of choice was Adicio as they have strong knowledge and great software for the Real Estate vertical. I oversaw this project from architecting through to deployment.

Additionally, I architected ten Employment Websites for the Morris Publishing Group with the vendor Adicio as they have strong knowledge and great software widgets for integrating with any website. I worked on this project from architecting through to deployment.

Finally, I architected seven Classified Automobile websites for Morris Publishing Group. The vendor of choice was MotoMiner as they have a superior website for the automobile shopper. The solution was hosted in the cloud by MotoMiner. The great part of this solution was that MotoMiner provided the website in the cloud and NMT had the ability to customize the web pages according the each newspapers branding. I worked on this project from architecting through to deployment.

The three projects I worked on for the Morris Publishing Group were for a twofold reason. First they needed to attract more potential customers to their websites and for increased revenue generation through selling ads for the websites.

TATA CONSULTING SERVICES (TCS), CINCINNATI, OH March 2014 –

July 2014

Senior Solution Architect March 2014 –

July 2014

At TATA Consulting Services, I worked on the Merchant Credit/Debit Card enhancement project that made the merchant system reporting application separate from the application’s internal reporting system. Previously, merchants had the ability to view reports that they did not need access to.

FIDELITY INFORMATION SERVICES (FIS), JACKSONVILLE, FL August 2012 –

October 2013

Senior Solution Architect August 2012 –

October 2013

At Fidelity Information Services (FIS) I was a Senior Solution Architect responsible for Architecting and Designing various solutions that range from customer facing applications, customer facing web applications, non-customer facing applications, and bank acquisitions. On my most current project I was part of a team that worked on the Oriental Bank acquisition by BBVA Puerto Rico Bank. My responsibilities included architecting enhancements to BBVA’s Business Web Banking application and architecting the replacement of the wire transfer system. The solution followed the SDLC (Software Development Life Cycle) to successfully implement the applications. I am very effective at working across the organization to insure that the solutions to be delivered exceed expectations.

Additionally, I was responsible for defining, maintaining and extending the functional product architecture for FIS’ suite of Financial Services Applications. Define and maintain a product architecture that offers flexibility to FIS Product Strategy and Product Management to configure product and services solutions that meet business requirements of clients in the marketplace. Deliver the concepts defined in the Open Financial Architecture roadmap in the form of a library of high-level functional component models made up of interoperating application subsystems, which can be flexibly combined into various product and service solutions based on marketplace and business needs. Define the high-level structure of a product solution by mapping marketplace and business requirements to application system components. Arrange functionality of application components, assign component responsibility, define component interaction and correlate the application system components to a product solution as defined by the requirements. This process includes the resolution of those requirements best met by existing or enhanced application components and those which will be addressed by new application subsystem components (to be built, purchased, or otherwise leveraged from an external vendor).

Solutions Architect of the following applications:

oBusiness Web Banking System: As part of BBVA Puerto Rico Bank’s acquisition of Oriental Financial Group, I was the lead Solution Architect for the Business Web Banking enhancements. The enhancements were required to bring parity for Oriental Bank’s Business Web Banking customers. The major features added were: real time wire transfers, account aggregation from other financial institutions a customer has accounts added, enhanced reporting, viewing deposit tickets and check images, and a Lockbox Presentment report containing lockbox totals and details for display to customers.

oWire Transfer System Replacement: As part of BBVA Puerto Rico Bank’s acquisition of Oriental Bank, I was the lead Solution Architect for the Wire Transfer system replacement. The wire system replacement was required to bring parity for Oriental Bank’s customers. The old wire transfer system was a batch driven system whereas the new system is real-time based. The additional features provided by the new wire transfer system were: processing international wire transfers, processing future dated wire transfers, and enhanced reporting.

oSalesforce.com: As part of BBVA Puerto Rico Bank’s acquisition of Oriental Bank, I was the lead Solution Architect for the SalesForce.com application. This is a vendor package that resides in the “cloud” and is used for customer mining and cross-selling of bank products. The back-end of the system is hosted by Salesforce.com.

M&T BANK, BUFFALO, NY November 2004 – July 2012

ASSISTANT VICE PRESIDENT; Development Manager July 2006 – July 2012

At M&T Bank I was responsible for Architecting and Designing customer facing web / mobile applications. On my most current enterprise project I was credited with re-architecting a solution after identifying gaps in the original design that would have significantly impacted the banks web customers. The solution followed the SDLC to successfully implement the application.

Responsible for the management of all activities related to the successful planning, documenting, testing and implementation of all work performed by the development team, whether by the request of the client, internal to the department or the result of a problem relating to an application. Provide detailed direction and perform specialized analysis and research of systems modifications to solve any scope problem or enhancement. Major responsibilities include:

Managing and overseeing the execution of project plans for any scope; ensuring adherence to all department and technology standards and procedures, including all documentation requirements

Assigning resources and monitoring progress of all assignments; ensuring completion of schedules; short and long term FTE planning

Overseeing application development and testing efforts, including the review of specifications, preparation and execution of testing; sometimes called upon to coordinate the completion of integrated testing efforts

Translating requirements to assist staff in preparing detailed specifications for system enhancements; recommends designs based on business requirements; identifying issues and concerns

Acting as a client liaison to review priorities and manage the overall client queue; building rapport within the organization; effectively communicating and developing a professional level of cooperation across the organization

Maintaining efficient operation and effectiveness of supported applications; recommending new technology, policies or processes to benefit the organization and improve deficiencies; leading technical evaluations of vendor software

Completing status reports and presenting projects, status, or activities to senior management

Demonstrating a strong understanding of the business environment and needs within my area of responsibility; ability to understand technical, business, and operational impacts of a project or problem

Job growth and career development of staff members by providing training plans, guidance, and sharing knowledge

Completing performance appraisals, promotion, and salary recommendations for underlings

Preparing cost center budget

Recommending and initiating new policies and procedures, to improve the performance and effectiveness of the department

Technical owner/Systems Architect of the following applications:

oMobile Web Banking System: This system evolved from the Mobile Banking Text System; this phone-based web-browser system enables customers to get account balances, transaction history, and transfer funds for checking, saving, and credit card accounts, and mobile check deposit for business banking customers; also includes M&T Bank and ATM locator; vendor product with extensive in-house developed data connector services

Technical Environment: This system runs on an appliance provided by M&T’s vendor at M&T’s data center; the application is JAVA 1.6 based and utilizes a SQL Server 2005 database; it also has connectivity to M&T’s Online Banking system and leverages it as the system of record which was my recommended design as it produced a seamless customer experience, as no matter the channel used (mobile or web), the information presented to the user is the same; also, using the aforementioned solution eliminated the need for additional employee training for servicing the customer; the application is load balanced utilizing NetScaler; M&T’s Online Banking is written in .NET utilizing frame work 3.5; the web services created for connectivity with Mobile Web Banking are written in .NET 3.5 and leveraged the SCRUM Agile methodology for developing the web services. Native applications were written for iOS (iPhone) and Android phones as well and are published on the iTunes Store and Google Play respectively. Web versions of the application were written for the iPhone Safari browser, Android Chrome browser, and phones with a generic browser.

oTeller Automation System: This system is used enterprise wide at retail/commercial locations to accommodate a variety of transactions performed by tellers to efficiently serve the customer; reduces the amount of paper that must be sent to the back office for processing; integrates with many other systems to complete transactions; vendor product with extensive in-house developed enhancements

Technical Environment: This is a thick client application that utilizes IBM’s MQ server for transmitting data between the application and many backend mainframe systems. System enhancements are performed using the vendor’s proprietary scripting language that is PASCAL like as well has making external call to C/C++ DLLs

oSales & Incentive System: This system is used to pay incentives to all eligible employees within the Retail Banking footprint; inherited by the Bank from a previous acquisition (in-house developed); supported by offshore developers

Technical Environment: This is a ColdFusion based application; all data is housed in SQL Server 2000 but is currently being upgraded to SQL Server 2005; the web application runs on two Windows 2003 servers and is load balanced with NetScaler; there is also a thick-client admin application written in Borland Delphi

oSmarterPay System: Vendor package that interacts with multiple systems at the Bank; calculates the credit worthiness of deposit account customers using a proprietary algorithm

Technical Environment: This is a JAVA 1.6 based application that uses a SQL Server 2005 database running on Windows Server 2003; the application and database are on the same server to increase performance; the system utilizes SQL Reporting for web reports that are available to the users. The system used data extracted from the Bank’s core banking system to create files for the application. The data was extracted from the DB2 mainframe and had to be analyzed by me to determine what data would be imported into the application from the core banking system. Additionally, the application produced a file by SQL Server using SSRS (SQL Server Reporting Services) to be imported by the core banking system and the data had to be analyzed by me to determine what fields the data would be mapped to

oiCom System: Vendor package that automates cash shipments to/from retail branches and ATM’s and manages the Bank’s central vaults; proprietary algorithm leveraged to minimize shipments saving the Bank courier costs

Technical Environment: This is a vendor provided systems that was developed using JAVA 1.6; its system of record is SQL Server 2005 and utilizes COGNOS for reporting; there are 2 web servers load balanced through NetScaler; COGNOS runs on a dedicated server with connectivity to the SQL Server 2005 database. The data was extracted from the DB2 mainframe and had to be analyzed by me to determine what data would be imported into the application from the core banking system. Additionally, the application produced multiple files by SQL Server to be imported by the core banking system and the data had to be analyzed by me to determine what fields the data would be mapped to. The data files were shared with the cash shipment vendors to identify each of the branches currency requirements.

Technical manager for the following:

oOnline Banking Bill Pay Replacement: This project involved replacing M&T’s Online Banking Bill Pay service provider with FIS’ Web Bill Pay service; included changes to the web user interface as well as web-service calls to FIS’ Payee Look-up; included changes to back-office processing for stop-payments and reconciliation

Technical Environment: M&T’s Online Banking system is provided by a vendor and is a .NET application running on the .NET 1.1 Framework; it utilizes a SQL Server 2005 clustered database for redundancy and failover; there are three web servers running Windows Server 2003 that are load balanced utilizing NetScaler; M&T has the ability to make coding modifications for the non-core code for the application and the application is enhance by M&T technicians regularly to support the business.

BANKING OFFICER; Project Manager November 2004 – July 2006

Responsible for project management of the client/server mortgage origination system, Harvest Migration Project, and creating the Disaster Recovery Plan for the Mortgage Origination system. All solutions followed the SDLC to successfully implement the application.

Project manager for the following:

oMortgage Origination System Web-Enablement: This project was initiated to add a web-user interface to the existing mortgage integration system. The mortgage origination system was only used by Bank personnel to create a mortgage applications based on paper applications received from loan officers/brokers. The web interface enabled loan officers/brokers to originate mortgages electronically reducing back-office personnel at the Bank.

Technical Environment: The web user interface was written in JAVA 1.5 and connects to the mortgage origination system utilizing web services created by the mortgage origination vendor; the web services were written in Progress as Progress is the database/application language the mortgage origination system was written in

oHarvest Migration Project: This project was initiated by the Bank’s internal audit department due to the need to ensure the custom code developed by the Bank was secure and versioned properly as well as ensuring there was a separation of duty between developers and implementers. While a seemingly easy task, the thirty-two thousand plus separate code modules produced some challenges for source control that were overcome by careful planning and execution. There were many interdependences with other applications for this project that had to be documented for the developers to use when making modifications to the system.

Technical Environment: Harvest is a source code repository and executable delivery application purchased from Computer Associates

oDisaster Recovery Plan Project: This project was initiated by the Bank’s business continuity department due to the lack of a disaster recovery plan for the system. Once the recovery time objective was established by my business partner with my assistance, I worked with the various functional and technical areas within the Bank to create the procedures to rebuild and test the system including making the system current.

Technical Environment: The Disaster Recovery Plan Repository is a vendor product that is used by M&T as the system of record for all disaster recovery plans

BANK OF AMERICA MORTGAGE, GETZVILLE, NY February 2000 – November 2004

ASSISTANT VICE PRESIDENT; Senior Developer

Responsible for the management of all activities related to the successful planning, documenting, testing and implementation of all enterprise projects I lead using the SDLC, whether by the request of the client, internal to the department or the result of a problem relating to an application. Performed specialized analysis and research of systems modifications to solve any scope of problem or enhancement. Major responsibilities included:

Managing and overseeing the execution of project plans for any scope; ensuring adherence to all department and technology standards and procedures, including all documentation requirements

Requesting resources and monitoring progress of all assignments; ensuring completion of schedules

Overseeing application development and testing efforts, including the review of specifications, preparation and execution of testing; sometimes called upon to coordinate the completion of integrated testing efforts

Maintaining efficient operation and effectiveness of supported applications; recommending new technology, policies or processes to benefit the organization and improve deficiencies; leading technical evaluations of vendor software

Completing status reports and presenting projects, status, or activities to senior management

Demonstrating a strong understanding of the business environment and needs within my area of responsibility; ability to understand technical, business, and operational impacts of a project or problem

Project management for the following:

oReal Estate Mortgage Investor System: This project was initiated by the investor accounting department to rewrite the existing in-house system from a thick client to a thin client web application utilizing connections to various systems within the Bank to pull and feed data thus, minimizing the necessity to manually key in information. The system generated reports for senior management as well as investors who were invested in particular mortgage securities.

oMax Payments System: This project was initiated by the business upon review of the system with the vendor. The system was used to more efficiently process mortgage payments from customers. This project required that I work with the application vendor and internal application technical owners to integrate the application at the Bank.

Technical manager of the following applications:

oDefault Account Information System: This system was used by the Mortgage Servicing Division to track information about mortgages in default. This application interfaced with the CPI mortgage system to obtain information on mortgages in default. The system provided users with statistical and graphically represented data for tracking purposes. This system was originally built at the Bank and later purchased by First American Title Company to be marketed to other financial institutions.

oReal Estate Mortgage Investor System: As stated previously, this application was used by the investor accounting department to track payments to be made to investors of particular mortgage securities. For reporting purposes, this system integrated with the Default Account Information system to determine mortgages that were in default for reporting back to the investor.

M&T BANK, BUFFALO, NY May 1997 – February 2000

Application Developer

Responsible for analyzing and programming several client/server applications developed within the Bank. The applications worked on were preexisting applications as well as new application development. Major responsibilities included:

Auto Update Application: This application was conceived due to the limited branch network bandwidth of the Bank and the challenges it presented with distributing thick client applications. Before the time of smart application installers such as MSI, the entire application build had to be packaged and distributed. For large applications, typical builds exceeded 1 GB. Distribution over a 56K connection limited the time updates could be distributed. By modularizing the install and leveraging the servers installed at the branches, updating large applications became manageable. The Auto Update application was application independent and worked with any type of files. In the Bank’s environment, executable files, dynamic link library files, Active X files, etc. were bundled in one or more packages to be distributed. The Auto Update Admin application enabled the packages to be created with compression and a unique tag file used to identify what packages changed. Distribution of the packages to the branch servers was accomplished using the Arbiter product. The Auto Update application, run on the branch workstations, would check the tag files to determine if any package required an update and install it.

Doc Prep Document Delivery: This application was created to electronically deliver loan-closing documents to a retail branch office of the customer‘s choosing. Another benefit of the application was the ability to electronically deliver automobile loan-closing documents to automotive dealers whom sold the Bank’s financing to their customers financing vehicles.

EDUCATION:

Canisius College B.S. - Computer Science, 1995

Buffalo, NY QPA: 3.42

Erie Community College A.S. - Computer Science, 1993

Williamsville, NY QPA: 3.62

HARDWARE: Pentium, AMD, Intel 80x86, Sun SPARCstation IPC

PLATFORMS: Windows 10, Windows 8.2, Windows XP, Windows 2000, Windows NT, Windows-95, Windows-98, Windows-ME, Novell NetWare, DOS, OS/2, OS/2 Warp, UNIX, SunOS, Linux, X Window System, OpenWindows.

SOFTWARE: Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft Visio, Microsoft Project, Microsoft Developer Studio Enterprise Edition, Microsoft Visual Studio.NET Professional Edition, Microsoft Outlook, Crystal Reports, Lotus Notes, Novell GroupWise, ClairMail

LANGUAGES: Drupal 7, C++, Visual C++, C, COM, MFC, ATL, Visual Basic, Microsoft SQL Server, Visual C#, Visual Basic.Net, HTML, XML, ASP.NET, Microsoft .NET 2.0, Microsoft .NET 3.5. Microsoft .NET 4.5.

METODOLOGIES Agile methodologies including SCRUM development and Extreme Programming. Additionally, I served as a SCRUM Master, I also have experience in other Standard methodologies including Waterfall, and SDLC.

TRAINING: ITIL Certified, Precision Leadership training, attended training courses for Project Management, Diversity, Leadership, Microsoft Visual C++, Microsoft Visual Basic, Commercial Credit, and Problem Solving Techniques.

REFERENCES FURNISHED UPON REQUEST

Contact this candidate