SUMMARY:

• Full Stack Developer using new and existing technologies to deliver and support technology solutions.
• Team Lead, Solution Architect, System Integrator and Developer with a proven record of success in all aspects of system delivery from definition to analysis to build to support.
• Multiple successes in Data Warehousing including database design, development and support of ETL processes, load and query performance tuning, and reporting / BI integration.
• Effective as a manager and individual contributor.
• Proven ability to act as a strategic technical advisor to senior management and executives along with the ability to effectively work with all levels within an organization.

TECHNICAL SKILLS:

Areas: Data strategy and architecture planning/delivery, data and software analysis/modeling, Enterprise Integration (SOA, Web Services, SaaS), Team(s) management, Technical Delivery

Technologies: C#, C++, Core Java, SQL Server, Sybase, Oracle, Perl, Unix Scripting, HTML

Vendor Tools: Sharepoint development, BI tools (Power BI, PowerPivot, Sharepoint BI), Autosys, SSIS/SSRS, MS Access, Microsoft TFS development.

SaaS: Salesforce - Visualforce, force.com, CPR PowerClerk, CEC Shared Solar CSP

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Tech Lead / Consultant

Responsibilities:

• Architect, design, document and at times build solutions integrating Confidential systems to two instances of Salesforce.
• Work closely with Product Owners and as a technical Product Owner following the Agile development methodology.
• Work very closely with the business to help understand requirements to help build out the Product Backlog, groom stories and provide guidance to our development teams.

Confidential, Charlotte, NC

Technical Delivery Manager / Solution Architect

• Architect the integration of multiple SaaS implementations (Salesforce, CPR PowerClerk, CEC), internal data warehouses and reports/spreadsheets as source systems of record to the data mart.
• Design and build ETL processes - using REST services and Java to extract source data, SSIS to populate the warehouse.
• Transform the data mart into a final system of record to the Confidential data warehouse for DET data.
• Create technological and operational processes to support this solution.
• Responsible for project management and oversight of a team of analysts, architects and developers.

Confidential, Charlotte, NC

TDM / Consultant

• Hands-on development, population and support of stage and final data warehouse solution. Heavy MS SQL development extracting data from sources such as LOANIQ.
• Create project artifacts including BRD Certification project Impact Assessment, HLD, LLD, development, QA and integrated test plans.
• Manage the development of an HTML5 UI to maintain and embellish data.
• Key Relationship Manager between business sponsors, SME’s and technology.

Confidential, Charlotte, NC

TDM

• Responsible for the end to end delivery of the Confidential Mobile Banking (Android and iOS) application.
• Follow waterfall methodology while identifying areas of growth and improvement.
• Coordinate effort across Business Analysts, Technical Architects, System Architects, multiple internal development teams and external vendors to ensure delivery of quality releases (Google Play, Kony, FIS and Apple Store).

Confidential, Charlotte, NC

TDM / Consultant

• Lead a team of architects, analysts and developers (both onshore and offshore) to build and integrate a vendor connector into the Oracle Identity Management (OIM) platform.
• Responsible for people and project management to deliver a quality, bug free product following a waterfall methodology.
• Work included creating and/or reviewing project documentation such as BRD, Impact Assessment, HLD, LLD, test plan and project plan. Face off to business partners to gather, clarify and document system requirements. Responsible for all project communications to Senior Management.
• Access Management is an internal enterprise wide solution for maintaining access rights for 300,000+ users.

Confidential, Charlotte, NC

Consultant

• Participate as the team manager on two merger related projects. Responsible for producing the Functional Requirements, Technical Detail Design, High Level and Low Level architecture along with managing the development team to code and test the changes.
• Manage a small development staff for these projects. Act as Scrum Master, participate in design and code reviews, and perform Java coding and database development as required.
• Wholesale Lockbox is an externally facing Web based application allowing customers to review checks and statements online.

Confidential, Charlotte, NC

Consultant

• Heavy ETL environment collecting and normalizing investment data for reporting, research and portfolio management.
• Support 13 applications which build and deploy 5 Oracle Data Warehouses that house the BOA Corporate Investments $1 trillion portfolio using Informatica, Autosys and Perl.
• Ongoing work includes defining services needed across Corporate Investments including building, staffing and supporting services such as Production Management, User Management, DR Recovery and Testing, and providing Level 1 - Level 3 support.
• Developed a Dashboard used for real-time monitoring of ETL processes and system availability using C# .Net and Oracle.

Confidential, Charlotte, NC

Consultant

• Hands on day-to-day development and enhancement of the Ion Anvil Repo trading system. Development work accomplished using mainly C++, Unix scripting, Perl and Sybase queries and stored procedures.
• Responsible for managing all projects and setting the priority and direction of technology related to the Repo Trading business. Interfaced daily with the repo traders and middle / back office staff to understand their needs and issues.
• Developed and enhanced interfaces to the Security, Customer and Pricing Data Warehouses to support Repo trading.
• Created multiple ETL processes to capture data from upstream systems such as the security master and pricing master databases, and to provide data to downstream systems such as the firm’s books and records system.

Buddy Systems

Owner

• Developed a CMBS FAS91 reporting system using VB.Net, SSIS and MS SQL Server.
• DBA for upgrade from SQL Server 7.0 to SQL Server 2005.
• C#.Net development work for BB&T Debt Capital Markets while to Scott & Stringfellow staff.

Confidential, Charlotte, NC

Technology Lead

• Designed and built a Data Warehouse to support Whole Loan Trading using SSIS and MS SQL Server. Created ETL processes to support the warehouse.
• Architected and helped build a C#.Net SOA framework to support a diverse set of applications and users including Front, Middle and Back Office personnel. Applications developed included P+L Reporting, TOB Trading, Whole Loan Purchase, Loan Housing and Remarketing. The SOA framework and these applications used the data stored in the Data Warehouse.
• Designed and built a position database, extending the capabilities of the Data Warehouse to support P+L Reporting, Cost of Carry Calculations and Position Management. These applications gave management and traders a complete view of their P+L for the first time.
• Managed the outsourcing of a set of applications to support the Tender Option Bond (TOB) traders, built using the above framework. Doubled the TOB program and created a new external client business with a predicted list of 20+ new clients in 2008. Extended the Data Warehouse to support TOB.
• Built a set of applications to support RMBS Whole Loan trading. Warehoused loans from origination to securitization or until sold. This platform enabled traders to competitively bid, buy and securitize or sell whole loans as well as to market a FAS 91 accounting system. FAS 91 reporting to external clients added $600,000 of revenue in 2007.

Confidential, Charlotte, NC

VP

• Integrated, supported and managed MBS Expert mortgage allocation system and the Anvil Arts repo system. MBS Expert reduced fail costs to 10%. Arts installation set the Anvil record as the quickest successful deployment. Developed interfaces to the Security, Customer and Pricing Data Warehouses using C++ and Unix scripting.
• Installed and integrated the Imagine Backoffice system for Equities and Phase3 for Fixed Income, eliminating many manual processes. Developed interfaces to the Equity Data Warehouse using Perl and Unix scripting. Developed interfaces to Phase3 using C++ and Sybase.
• Participated in a team that built and maintained a Security Master and Pricing Master Data Warehouse using Perl, C++, Autosys and Sybase. This Warehouse is still in production after 15 years of use.
• Built services to supply security and pricing information to multiple consumers. Developed multiple applications, including Low Floater and Agency Pricing, to build and maintain security and pricing information which eliminated redundant and inconsistent data within the warehouse. These applications were developed using C++, Unix scripting, Perl, VBA and Sybase.
• Team management - individual contributor progressing to manage 2 developers.

Confidential, Hartford, CT

Developer

• Designed and built a data warehouse used for Portfolio Management reporting. Housed and maintained $8 billion plus assets split across multiple entities. The warehouse and reports were developed using C and Sybase.
• Developed a management dashboard to view asset performance across entities as well as a combined view. The dashboard was developed using VB and Sybase
• Coded applications to support satellite agencies writing auto insurance. Allowed satellite agencies to transmit new and modified policy information to the home office mainframe system. The applications were developed using assembler.
• Team management - individual contributor.