Work with business partners to come up with data solutions that meet their business needs in Commercial Banking. Define existing processes and identify measurable opportunities for improvement. Act as business advocate / liaison with IT departments. Maintain awareness of industry trends around data and software. Provide and or support cost benefit analysis. Define strategic approach for delivery. Prioritize functions and features to be delivered. Negotiate the optimum solution within the constraints of the effort. Limit and avoid tech debt where possible. Look for and negotiate the win win outcome between IT and business partners. Lead Product Manger over in-house development of new Collateral Management System.

- Developing AI to analyze endurance athlete performance data. Responsible for: identification; gathering and compilation of data; development of statistical formulas (KPI - regression algorithms / classification algorithms) to analyze the data and provide automatic athlete analysis / automatic recommendations for training improvements for strategic goals; creation of dashboards and pivot table reports presenting the data.- USATF Level 2 certified Endurance Coach.- Help manage setup and hosting of events. - Prepare training plans.- Work with local government authorities on obtaining permission / getting support.- Design running trail courses using GIS.- Create presentations in PowerPoint / Word.- Supervise volunteers.

Senior Product Owner in big data warehousing for commercial trade data around securities. Develop SQL queries, analyze data for data quality, gather data requirements, data lineage, develop data models, support MDM, build operational reports in Power BI including defining KPI. Lead team through Agile process as Scrum Master / Senior Product Owner. Wrote and groomed stories.

Senior Product Owner in big data warehousing for commercial trade data around securities. Develop SQL queries, analyze data for data quality, gather data requirements, data lineage, develop data models, support MDM, build operational reports in Power BI including defining KPI. Lead team through Agile process as Senior Product Owner. Wrote and groomed stories.

- Freelance consultant at Investment Company (Real Estate).- Advise on technology / vendor solutions; capture requirements; negotiate scope; estimate work; generate invoices; manage account receivables / account payables. Maintain information in Word / Excel / QuickBooks.

Worked on payment gateway team at local bank.Refined backlog; worked with dev team to define scope of sprint; wrote up user stories; documented business process. Researched XML layouts for processing of commercial financial wires (XML ISO 20022 pacs / pain) to establish data mapping and data sources required. Ensured compliance with storage / sharing of personal customer information. Trained upstream data providers on data elements needed to interface with payment processing API and transaction status messages.

- Tasked with identifying for backlog business analytical data (Key Performance Indicators (KPI) / Key Risk Indicators (KRI)) that needed development. Software supported all teller functions such as: Deposits; Payments; Account Lookups etc. Objective was to identify teller transactions that had not processed per SLA or showed business risk.- Reviewed backlog requirements for Anti Money Laundering / Know Your Customer.- Obtained documentation for proof of SOX compliance for new Key Financial Application.

- For customer payments ecommerce web site / mobile app, improved data analytics validation / definition. Using data mining and process improvement, redesigned analytics process to better manage validation and understanding of analytics data being captured by vendor. Mined existing vendor data into a multiple tabular Excel spreadsheet (with VLOOKUP) that clearly showed the event, what was captured at time of event and organized by customer task. I also identified gaps in the vendor’s delivery against specifications. Designed new process so that it was easy to validate, could easily grow and be modified as needed. Trained data consumers in the use of the new process. - Performed data analysis of application data for integrity (DQ) issues – using TOAD / SQL. Mined data from a prior application’s database that had not been migrated. Had to identify keys that could be built from different table structures to allow me to cross check the data between the two databases via SQL queries that I wrote.- Lead analyst for software vendor selection of data management solution for geospatial data (including UAS (Drone) / Manned Aircraft). Studied existing company documentation to identify / document data flows. Led review sessions local / remote (group of up to 10 people) to finalize RFI content. Post RFI, developed use cases (in Visio) for data file management work flow process along with data search / automatic alert reports (such as perimeter encroachments). - Product owner for encroachment web application (in-house developed web app. that interfaces with GIS data). Used to log encroachments on company right of ways along with status; paperwork and associated images (drone; aerial; satellite; on site).- Created RFI for real time data collection of asset status - vehicle telematics / portable building security / vehicle information. Led the local / remote requirements sessions (group of 10 people).

- Led requirement gathering / elicitation sessions (with vendors / 3rd party resources) for capturing of Anti Money Laundering (AML) data from Equipment Finance Group web application. In Agile environment, was responsible for capturing product backlog requirements / user stories for new customer call center support tool (web app.) for customer web / mobile interactions. Tool allowed support staff to filter customer actions by ecommerce activity (such as payments / deposits) and channel. Required identification of mobile / web customer tracking data (KPI / KRI) needed. Involved with sprint planning, daily standups / scrums. - Worked with 3rd party vendor offshore development and testing teams.- Involved with QA defect resolution using HP ALM tool.

- Product owner for subscription based (ecommerce) web application for business (B2C) and consumers (C2C) to manage their messages on Twitter / Facebook. Worked with offshore development team. Managed backlog in Target Process for new functionality / features. Designed Google Analytics approach for validating value of release and identifying new requirements for backlog. Validated enhancements to the subscription / payment process. Technical writer for online user instruction documents (wiki’s) in Zendesk.

- Worked with business partners to identify detailed business processes / requirements / constraints involved with Transportation Management (Freight Carrier Management) of ordered and returned Coca Cola vending equipment (domestic and international). Developed understanding of the Order to Cash process that drove the need for transportation. Chaired and facilitated 3 day JAD session (with local and remote resources – 27 people) to work through logistic process around transportation (freight carrier selection; freight carrier scheduling; freight carrier payment). Created process flow and system flow diagrams (including swim lanes) in Visio for transportation process.

Creating unique content for AD Revenue based web site.Site focuses on self help for Car Repairs.Editing HTML, CSS, PHP, MySQL.Creating Artwork in Adobe PhotoShop.Improving Search Engine position.

- Data analyst for diversity purchase report. Mined data from credit card transaction data sources and merged the credit card transaction data with known diversity suppliers to report on company diversity purchases.- Part of team that defined data needs / conceptual data model for Smart Meters (Smart Grid). - Designed ERD, conceptual data model for new incident tracking web app. Application used to manage work flow of incidents of damage / destruction to property from initial reporting to final resolution. Design included: details of property damage; parties involved; legal action taken; costs; billing and incident status. - Improved worker efficiency through process improvement by allowing maintenance workers to toggle applications to view / update data for specific point / area on a transmission line by integrating legacy transmission line maintenance app. (client server) with GIS (geographic information system) web app. Previously, workers had to select locations in each application. - Led multi day business workshop to document business processes (Visio) involved with Remote Disconnect and Remote Reconnect of Smart Meters (Smart Grid). Guided business to focus on processes tied to their business environment and to provide performance requirements that IT could use to shape their solution. - Lead BA on access security (physical, software etc.) for access requiring specific documents (such as legal) acknowledged as read for access to be granted / continue. Defined / documented process flow around document review / e signature process and created supporting user stories / use cases. Created rich mockups of web pages and mapped screen navigation. Converted business requirements into BRD / FRD. Designed entity relationship diagram / conceptual and logical data models. Negotiated acceptance / sign off of IT solution by business.

- Business / Data Analyst for creation of web app. / data warehouse that captured P&L numbers from back office spreadsheets into a database which allowed numbers to be drilled down on and P&L numbers at closing to be sent out as texts. Created high level system and functional design documents. Documented service level agreement (SLA) and support document. During my requirement analysis of reconciliation / adjustment data compared to business process (using Excel macros I coded) I identified procedural discrepancies affecting data quality. Raised DQ issues to operational management and educated them on problem identified. Developed and maintained metadata repository. - Generated statements of work for data archival / retention / interfaces with external departments.- Led 3 business analysts (Front, Middle, Back Office) through defining current business process / requirements and comparison of solutions for new FX Trading system. Facilitated and chaired JAD sessions with: Vendors; Business; Networks; Architecture; Development; QA and Support. Handled on / off boarding of resources.

- Project Manager / Business Analyst for creation of web based overdraft tracking app. Replaced existing spreadsheet process. Database with web front end was created that allowed easy reporting / capturing of data. Automatic feed of account information was put into database daily and alerts were emailed out to admins / managers to warn them of new overdrafts. Worked with IT architects to map conceptual data into logical data models. Documented / managed requirements, provided traceability to design, obtained signoff and ensured implementation compliance. Used SQL to extract and analyze data. Trained users in use of new app. - Project coordinator / Financial Analyst for build of new enterprise data warehouse and for Wealth Department merger with SouthTrust. Responsible for: merger meeting minutes; designing / updating / communicating weekly dashboard; requesting / reserving resources (such as meeting rooms) ; maintaining project plan (MS Project); tracking status / issues (13 sub projects); monitoring staff availability; onboarding / off boarding resources (vendor / internal); tracking finances; maintaining licenses; obtaining invoices from vendors and for providing updates to Program Office. Created resource usage report at end of merger using Excel Macros to extract data from time tracking system.

Provided First Responder Emergency Response.Involved with Medical Emergencies, Transportation of Patients to Hospital.Provided patients with pre-hospital care at the Emergency Medical Technician (EMT) level. Rescue of Victims from Traumatic Incidents such as Car Wrecks or Industrial Accidents.Worked with Law Enforcement to provide EMS tactical care in hostile / combat conditions.Emergency responder priority one driving under lights and siren.

Worked with marketing to setup process and procedures to outsource Creative Work.Delegated work to Junior Business Analysts.Developed and reviewed project Business Case ROI against Corporate targets.Created project estimates.Use Case development.Documented process flows (Swim Lanes) in MS Visio.Requirements storage in Requisite Pro.

- Provided 24x7 support of data warehouse. Responded to data issues. Edited load files to resolve problems. Setup job scheduling. Wrote Unix Shell scripts. Gathered data requirements / data processes from business departments. Mapped data to tables. Provided ETL (data extract; data transformation; data load) support. Wrote PL/SQL to load data and extract data. Created work estimates. Delegated tasks. Arranged on-call rotation. Created reports. Wrote specifications and test plans. Redesigned specification templates to be easier to use. Tuned Oracle SQL.- Created reports to check for data quality issues.- Created VB script to convert Excel spreadsheet into load file saving 3 hours labor per month.- Created Korn Shell script to remove duplicates from load file saving 8 hours labor per month.