Extraction and transfer of all electronic documents from First Republic Bank (FRB) to JPMC to meet regulatory (FDIC) requirements and continuing business functionality.

• Participated in design and utilization of custom application to extract and deliver over 257 million digital documents along with metadata for load into JPMC document repository.

• Extensive SQL analysis of OnBase database regarding document metadata and keyword values.

• Developed Bash shell script for SFTP transfer of files between FRB and JPMC.

Subject matter expert for Statements and Notices of Core Transformation Project

• Designed, developed, and managed all aspects of data file transmissions from FIS to Broadridge print vendor for print and online presentment of Deposit and Loan Statements and Notices.

• Python script development for data manipulation prior to transmission to third party vendors for printing.

• Worked closely with Business Analysts and third party vendors to gather and translate business requirements into technical solutions.

Analyzed, designed, developed, implemented and supported the Enterprise Document/Content Management & Classification Systems (OnBase, Monarch, & Ephesoft).

• Hyland OnBase development and system administration involving Workflow, Document Import Process, and Document Type/Keyword creation.

• Created Unity Workflow Scripts and Windows Services written in C# for preprocessing data.

• Development and maintenance of custom integration between OnBase and DocuSign via API calls to retrieve and load envelope data.

• In-depth knowledge in analysis, design, prototyping, testing, security, developing/enhancing applications, production support, problem solving, including requirements gathering, estimating effort, documentation, access management, business continuity, and disaster recovery

• Investigation and root cause analysis of software and system defects; resolved issues with production systems.

• Key member of both Data Analytics Engineering team and Front End User Interface development team.

• Programed stored procedures in PL/SQL on Oracle 10g/11i for use in custom ETL process.

• Utilized Big Data NoSQL storage such as Hadoop, Hive, and Elasticsearch with Kibana 6.2 to develop KPI dashboards for various Analytics apps (Power Quality and Asset Topology Manager).

• Incorporated QlikView 11.2 reports into Analytics Equipment Load Management product.

• Replaced QlikView reports with Elasticsearch/Kibana (ELK) dashboards in Equipment Load Management product.

• Developed Birt 4.6 reports delivered via web server for integration into EnergyIP application that queries Hive and Oracle databases via JDBC connections.

• Contributed to data modeling design involving various database technologies (SQL databases and NoSQL databases) to improve data reliability and quality along distributed systems and varied hardware.

• Developed NextGen UI utilizing JavaScript and LitElement Web Components in a custom framework.

• Utilized Highcharts JS for charts, Leaflet library for maps, and Vis.js library for timeline charts to deliver interactive front end web based applications employing RESTful APIs and JSON request/response.

• Collaborate closely with User Experience team and Product Managers to deliver high quality code based on UI spec and within requested timeline.

• Tracked bugs and stories via Jira and managed change control using Perforce in an Agile development environment.

• Involved with full software development life cycle including Architecture, Unit Testing, and Documentation.

• Employed Agile Methodologies with two week scrum along a Continuous Integration/Continuous Deployment (CI/CD) pipeline.

• Created and maintained new reports within custom made reporting framework utilizing JAVA, XML, and SQL for Business Analytics.

• Responsible for monthly financial reports and reconciliation reports delivered to internal finance department and third party partners.

• Automated reports delivered via email utilizing bash shell scripting for marketing team.

• Software programming of feature enhancements for custom made reporting framework.

• Performed any ad-hoc query requests and data delivery on a timely basis.

• Utilized Crystal Reports to develop complex and dynamic reports.