David Lee
Axiom Developer at Botsford Associates- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
Topline Score
Bio
Credentials
-
Advanced Linear Algebra for Computing
edXJun, 2021- Nov, 2024 -
Python 3 Programming Specialization
CourseraAug, 2020- Nov, 2024 -
Full Stack Web Development Certificate
Rutgers BootcampsJan, 2017- Nov, 2024
Experience
-
Botsford Associates
-
United States
-
Business Consulting and Services
-
1 - 100 Employee
-
Axiom Developer
-
Sep 2023 - Present
• Work with a major American bank to support its main reporting tool (Axiom) and reports including Call Reports, Country of Exposure, FR 2052a, FR 2644, FR2900. • Work closely with Client and Axiom developers to create and maintain sustainable regulatory reporting solutions within Controller View. • Design and develop Regulatory solutions on AxiomSL ControllerView framework, while reviewing and optimizing existing code within a BAU setting. • Working within Agile development… Show more • Work with a major American bank to support its main reporting tool (Axiom) and reports including Call Reports, Country of Exposure, FR 2052a, FR 2644, FR2900. • Work closely with Client and Axiom developers to create and maintain sustainable regulatory reporting solutions within Controller View. • Design and develop Regulatory solutions on AxiomSL ControllerView framework, while reviewing and optimizing existing code within a BAU setting. • Working within Agile development methodologies to consistently deliver quality code in a timely manner. • Supporting testers and business users through code promotions and post-implementation • Helping to refine and reinforce good development standards in day-to-day work as well as performing code reviews. • Reviewing business requirements pre-development and working with Client to ensure that specifications can be understood and implemented. • Write design document and technical specifications, identify, track, monitor and communicate possible problems, scope changes, variations and contingencies where needed. Show less • Work with a major American bank to support its main reporting tool (Axiom) and reports including Call Reports, Country of Exposure, FR 2052a, FR 2644, FR2900. • Work closely with Client and Axiom developers to create and maintain sustainable regulatory reporting solutions within Controller View. • Design and develop Regulatory solutions on AxiomSL ControllerView framework, while reviewing and optimizing existing code within a BAU setting. • Working within Agile development… Show more • Work with a major American bank to support its main reporting tool (Axiom) and reports including Call Reports, Country of Exposure, FR 2052a, FR 2644, FR2900. • Work closely with Client and Axiom developers to create and maintain sustainable regulatory reporting solutions within Controller View. • Design and develop Regulatory solutions on AxiomSL ControllerView framework, while reviewing and optimizing existing code within a BAU setting. • Working within Agile development methodologies to consistently deliver quality code in a timely manner. • Supporting testers and business users through code promotions and post-implementation • Helping to refine and reinforce good development standards in day-to-day work as well as performing code reviews. • Reviewing business requirements pre-development and working with Client to ensure that specifications can be understood and implemented. • Write design document and technical specifications, identify, track, monitor and communicate possible problems, scope changes, variations and contingencies where needed. Show less
-
-
-
Natixis Corporate & Investment Banking
-
France
-
Financial Services
-
700 & Above Employee
-
Axiom Software Developer
-
May 2023 - Sep 2023
• Work closely with upstream and downstream systems to integrate the Axiom solution and resolve issues in connectivity, compute and space capacity. • Define methodologies and high/low technical design making best use of Reg Reporting tools and techniques in the client environment for reporting solution implementation. • Understand and translate customer requirements into business and technology solutions on Axiom ControllerView V10 and create documentation for the various support… Show more • Work closely with upstream and downstream systems to integrate the Axiom solution and resolve issues in connectivity, compute and space capacity. • Define methodologies and high/low technical design making best use of Reg Reporting tools and techniques in the client environment for reporting solution implementation. • Understand and translate customer requirements into business and technology solutions on Axiom ControllerView V10 and create documentation for the various support teams. • Drive discussions and provide consultation around functional/application designs and ensure the solution meets the business requirements. • Working closely with the Network and Security Team ensuring the implemented solution meets the required standards. • Plan for continuous monitoring and improvements in performance and process around Axiom CV WorkFlows and troubleshooting Production issues. Show less • Work closely with upstream and downstream systems to integrate the Axiom solution and resolve issues in connectivity, compute and space capacity. • Define methodologies and high/low technical design making best use of Reg Reporting tools and techniques in the client environment for reporting solution implementation. • Understand and translate customer requirements into business and technology solutions on Axiom ControllerView V10 and create documentation for the various support… Show more • Work closely with upstream and downstream systems to integrate the Axiom solution and resolve issues in connectivity, compute and space capacity. • Define methodologies and high/low technical design making best use of Reg Reporting tools and techniques in the client environment for reporting solution implementation. • Understand and translate customer requirements into business and technology solutions on Axiom ControllerView V10 and create documentation for the various support teams. • Drive discussions and provide consultation around functional/application designs and ensure the solution meets the business requirements. • Working closely with the Network and Security Team ensuring the implemented solution meets the required standards. • Plan for continuous monitoring and improvements in performance and process around Axiom CV WorkFlows and troubleshooting Production issues. Show less
-
-
-
Scotiabank
-
Canada
-
Banking
-
700 & Above Employee
-
ETL & Axiom Software Developer
-
May 2021 - May 2023
• Work closely with business users and team to create and maintain sustainable U.S., Canadian, U.K., and Ireland regulatory reporting solutions. • Utilized and maintained the code for a business user facing web application built on Java Spring Framework/Boot, this application allows users to view business data stored in Oracle database tables and make adjustments based on allowed permissions . • Using ETL concepts, automation, Agile development methodologies, Bitbucket version control… Show more • Work closely with business users and team to create and maintain sustainable U.S., Canadian, U.K., and Ireland regulatory reporting solutions. • Utilized and maintained the code for a business user facing web application built on Java Spring Framework/Boot, this application allows users to view business data stored in Oracle database tables and make adjustments based on allowed permissions . • Using ETL concepts, automation, Agile development methodologies, Bitbucket version control, and Jenkins release process to consistently deliver solutions in a timely manner. • Extract required business data using REST API and Elasticsearch, and load this data into temporary Oracle staging tables utilizing Talend software, in addition to using DDL and DML scripts to create and maintain Oracle schemas and tables. • Transform the data within Talend to apply business requirements and logic utilizing Java and SQL concepts, this data is than loaded into main Oracle tables to be consumed by the Axiom CV application for regulatory report generation and submission. • Lead the Development, Design, and implementation of Axiom CV related objects like Axiom Scripts, WorkFlows, Aggregations, Portfolios, FreeFormReports, TabularReports, DataModels, DataSources, and Shorthands. Show less • Work closely with business users and team to create and maintain sustainable U.S., Canadian, U.K., and Ireland regulatory reporting solutions. • Utilized and maintained the code for a business user facing web application built on Java Spring Framework/Boot, this application allows users to view business data stored in Oracle database tables and make adjustments based on allowed permissions . • Using ETL concepts, automation, Agile development methodologies, Bitbucket version control… Show more • Work closely with business users and team to create and maintain sustainable U.S., Canadian, U.K., and Ireland regulatory reporting solutions. • Utilized and maintained the code for a business user facing web application built on Java Spring Framework/Boot, this application allows users to view business data stored in Oracle database tables and make adjustments based on allowed permissions . • Using ETL concepts, automation, Agile development methodologies, Bitbucket version control, and Jenkins release process to consistently deliver solutions in a timely manner. • Extract required business data using REST API and Elasticsearch, and load this data into temporary Oracle staging tables utilizing Talend software, in addition to using DDL and DML scripts to create and maintain Oracle schemas and tables. • Transform the data within Talend to apply business requirements and logic utilizing Java and SQL concepts, this data is than loaded into main Oracle tables to be consumed by the Axiom CV application for regulatory report generation and submission. • Lead the Development, Design, and implementation of Axiom CV related objects like Axiom Scripts, WorkFlows, Aggregations, Portfolios, FreeFormReports, TabularReports, DataModels, DataSources, and Shorthands. Show less
-
-
-
AxiomSL
-
United States
-
Software Development
-
200 - 300 Employee
-
Senior Associate - Application Development
-
Jan 2020 - May 2021
• Work with SQL Server and ControllerView V9 and V10, utilizing ETL Concepts to create regulatory reporting solutions for the U.S. and Canada. • Lead the Development, Design, and implementation of IT applications and applications systems analysis and programming activities that enable the organization’s business processes using Axiom Scripting, Aggregations, FreeFormReports, Portfolios, etc. • Contributed to the execution of the technical roadmap for key programs and product initiatives… Show more • Work with SQL Server and ControllerView V9 and V10, utilizing ETL Concepts to create regulatory reporting solutions for the U.S. and Canada. • Lead the Development, Design, and implementation of IT applications and applications systems analysis and programming activities that enable the organization’s business processes using Axiom Scripting, Aggregations, FreeFormReports, Portfolios, etc. • Contributed to the execution of the technical roadmap for key programs and product initiatives by leading, training, and knowledge sharing with the team. • Monitor and identify performance indicators that can effectively report on the overall progress of projects and systems and effectively mitigate risk and resolve issues. • Ensure that software and products meet and exceed internal standards and customer expectations. • Support the development of applications by evaluating, testing, and recommending system requirements.
-
-
Associate - Application Development
-
Nov 2016 - Jan 2020
• Work with SQL Server and ControllerView V9 and V10, utilizing ETL Concepts to create regulatory reporting solutions for the U.S. and Canada. • Develop, Design, and implement IT applications and applications systems analysis and programming activities that enable the organization’s business processes. • Created and designed ControllerView objects: WorkFlows, Aggregations, Portfolios, FreeFormReports, TabularReports, DataModels, DataSources, and Shorthands. • Monitor and identify… Show more • Work with SQL Server and ControllerView V9 and V10, utilizing ETL Concepts to create regulatory reporting solutions for the U.S. and Canada. • Develop, Design, and implement IT applications and applications systems analysis and programming activities that enable the organization’s business processes. • Created and designed ControllerView objects: WorkFlows, Aggregations, Portfolios, FreeFormReports, TabularReports, DataModels, DataSources, and Shorthands. • Monitor and identify performance indicators that can effectively report on the overall progress of projects and systems and effectively mitigate risk and resolve issues. • Ensure that software and products meet and exceed internal standards and customer expectations. • Support the development of applications by evaluating, testing, and recommending system requirements.
-
-
-
Verizon
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Senior Analyst - Performance Assurance
-
Sep 2014 - Nov 2016
• Leverage Teradata SQL to write queries, create volatile tables, join statements, select statements, unions, and where clauses to extract data and perform further analysis of the data in Microsoft Excel. • Run SQLs to collect internal company data for analysis. • Create standard report guides, pivot tables, and trend reports using Excel to sample and analyze data. • Run internal audits based on data samples to ensure compliance with company policies. • Identify data to assess risk… Show more • Leverage Teradata SQL to write queries, create volatile tables, join statements, select statements, unions, and where clauses to extract data and perform further analysis of the data in Microsoft Excel. • Run SQLs to collect internal company data for analysis. • Create standard report guides, pivot tables, and trend reports using Excel to sample and analyze data. • Run internal audits based on data samples to ensure compliance with company policies. • Identify data to assess risk and help improve operational decision making. • Communicate to management audit results and actions necessary to reduce risk.
-
-
Sales Representative
-
Aug 2012 - Sep 2014
• Meet and exceed quota target for activations, renewals, products and enhanced services. • Propose evaluations and solutions that best benefit the company and the customer. • Manage and grow existing customer base, make cold calls, and manage churn. • Ensure customer satisfaction, resolve issues; process, audit, and reconcile transactions.
-
-
Customer Support Representative
-
Aug 2011 - Aug 2012
• Reconcile cash, follow bank deposit procedures, and perform reporting functions. • Assist in cash management, billing inquiries and asset protection of store inventory. • Ensure that all appropriate documentation and data entry is complete. • Conducted wireless workshops and performed technical troubleshooting.
-
-
Education
-
Georgia Institute of Technology
Master of Science in Computer Science, Computing Systems -
University of Arizona, Eller College of Management
Master of Business Administration - MBA -
Auburn University, Samuel Ginn College of Engineering
Bachelor of Computer Science -
Eastern Michigan University
Bachelor of Business Administration - BBA, Accounting
Community
