Jonathan Gin Email & Phone Number

Whittier, Ca, Us

Santa Monica, California, Us

⦁ Increase business engagement of ICs by mentoring to stretch skills, identify and combine areas of interest with potential added business values, and focus on how their work impacts other stakeholders with an emphasis of improving their experience through automation or increasing efficiencies.⦁ Provide candid business and industry insights from internal and external business sources to allow stakeholders to make better informed decisions on current and future plans. ⦁ Generate Summarized Take Action Briefs to Cross Department Leadership to manage production and data anomaly incidents. Increase reaction and decision time by setting optional approval guidelines while providing a consolidated living document of impactful changes being made for auditing and Knowledge Transfer run books to our tech, sales, finance, customer service, legal, and tax departments.⦁ Quickly parse through Daily Production Incident Intakes to identify One-Off Data Sanitizations, Root Cause Analysis, Cross Departmental Impact, and Stand-Up Recurring Bulk Data Updates until Permanent Fixes can be established. Required advanced knowledge of mixed tech stack Platform (AWS/GCP), Frontend (React/C#), Backend APIs (JavaScript/TypeScript/C#), and Database (Snowflake/MSSQL/Firestore). Trace user journies via Noibu to identify and resolve user issues.⦁ Collaborate daily and monthly with other leadership members of the Tech Department to make high level strategic operational decisions.⦁ Groom, prioritize production work tickets, and run Agile Standups with our Platform Team. Bridge data issues and fast follows due to e-commerce system re-platform.⦁ Own Compensation System and adjacent downstream system impact. Perform maintenance, reporting, new feature enablement, CCPA/security access requests, and SME communications with Data and other business stakeholders.

Santa Monica, California, Us

⦁ Stand up AWS RDS snapshots to run parallel Commission Processing to provide Financial Impact Analysis and Commission Deltas.⦁ Became sole Product Owner and Subject Matter Expert of Commission System when team of contractors responsible for maintenance and upgrades contract ended. Perform commission server maintenance in both Drafts and Production, responsible for sales attributions, commission calculations, and payments.⦁ Took over Key Roadmap Tech Project for 2023 estimated to save $2M that was originally scoped and estimated to be delivered with low to mid confidence at the end of Q2. Rescoped project delivery timeline, work stories, estimates, and delivery risk confidence by taking over key work development, unblocking parallel development resources, coordinate scope and product deliveries with mobile team and hit business target requirement to launch at start of Q2.⦁ Contribute to new direct sales feature to identify and deliver intelligent take action dashboard and reports to our sales team that increased customer engagement by 86% in the first quarter of 2023.⦁ Data Governance Task Force to enforce data integrity, security, compliance, pipelines and Looker reporting flows for our data lake.

Santa Monica, California, Us

⦁ Quick contributor - Code to Production within first month. Subject Matter Expert of core database domain within first quarter.⦁ Dedication to Excellence - Exceeded expectations on all annual reviews by delivering all projects and work in a timely manner. ⦁ As a contributor to company culture, was a member of the Workplace Task Force to identify and make recommendations to C-Suite Leadership Team to address Organizational Health Survey scores. All recommendations were approved for implementation. ⦁ Identify and synchronize environment differences between MSSQL Prod and Drafts. Restructure and reorganize MSSQL database objects in GitHub to be able to track versioning of Database objects. Increase query performance by optimizing queries and indexing. Institute best security practices by securing query parameters.⦁ Internal Subject Matter Expert for the Commission System and provided Knowledge Transfer Handoff to Outside Contractor Team to own legacy commission system. ⦁ Provide rotational technical On Call Support to e-commerce and backend sales team web application triggered through New Relic and PagerDuty.⦁ Extend backend sales team web application report capabilities by improving data accuracy, increasing performance, and extending functionality by adding new data features and filters.⦁ Support legacy commission platform written in C# .NET Core and CRM website written in JavaScript/TypeScript/React/Node.js front end. Utilizing both RESTful APIs and GraphQL APIs.

Baltimore, Maryland, Us

Architect and develop solutions for Big Data ETL processes. Provide support to our internal Finance Modernization Team of actuaries for fiduciary financial data modeling.• Architect and develop a new enterprise Python 2.6 application to extract large actuarial data from MSSQL, Oracle, and Hadoop, transform into various custom formats with both direct or custom file load into multiple third-party actuarial modeling systems. • Architect DevOps strategy to automate and orchestrate operational pieces through BMC Control-M with automated issue triaging.• Use SDLC best practices with Jenkins to automate code elevation between environments, BitBucket for source code repository, and JIRA to track project tasks and defects through Agile project management practices.• Coordinate and work directly with business users to write technical business requirements, design solutions to meet long term Service Level Agreement requirements, identify discrepancies in upstream data or missed technical requirements, and establish various financial controls to ensure data integrity between any potential record manipulations.• Contribute to development of C# Core/Azure application to replace 30+legacy SSIS packages.• Provide complex SQL queries to aid in data analysis, data correction, and technical requirement research.• Provide production support upon request for legacy support of financial administration systems, including operational aspects of contract/broker record keeping, contract commissions/charges/fees, partner reports, governmental regulatory reporting, DTCC settlement files, cross administration system reconciliation, new product offer consultations, and account ledgering. • Create recorded on-hands training sessions with off shore resources to transfer production support resources and to increase product enhancement productivity.

Baltimore, Maryland, Us

Coordinate with actuaries to integrate SDLC compliant business logic workflows using a third-party software for data modeling, data integrity controls, and loading into actuary systems.• Assigned late in project to re-evaluate project solution and get project back on track. • Redesign and optimize solution package into bulk SQL stored procedure transformations and reduce operational time from hours to minutes to meet data delivery requirements.• Coordinate with actuaries to design modular and reusable Alteryx workflows that meet SDLC requirements as well as operational automation using BMC Control-M.

Baltimore, Maryland, Us

• Assist in Single Sign On project to consolidate users via IBM ISAM and coordinating with web designers to take user registration/login/password recovery Zeplin wireframes. Technology stack using jQuery, JAVA, Spring, and Maven for deployment.• Provide on-call end of day production data support of financial processing and reduce downtime and non-critical support escalation callouts by documenting common issues, solutions, and identifying long term fixes to issues. Required working and analytical knowledge of PowerBuilder 6.5, PowerShell, C#/VB.NET, BMC Control-M, Oracle and MSSQL. • Provide application support to web application written in Adobe flex to manage contract pricing configurations and identify and fix data issues.• Assist in design, development, and enhancement of various internal VB ASP.NET 3.0 web applications for managing partner selling agreements, tracking various internal service metrics, calculating and paying sales, service, and broker commissions.• Optimize SQL stored procedures and queries to reduce operational run times from hours to minutes for time sensitive reports and financial operations.• Assist in designing operational process of submitting Form 5500s by creating an operational import process into a third party software reducing creation and submission time from weeks into days while also reducing errors created by manual input.• Design business tools to manage DTCC NSCC file transmissions allowing business partners to receive automated payment through a clearing house with minimal development and QA resources required.• Convert custom core business functionalities from legacy application written in PowerBuilder 6.5 to a VB.NET web application to support upgrades to IT infrastructure.

• Develop and convert a VB.NET Dutch Auction website for surplus supplies into a PHP/MySQL web application. • Enhance custom internal accounting application by updating existing functionalities, patch business logic bugs, and optimize backend SQL stored procedures.

• Installed and operated 11 public Wi-Fi hotspots in restaurants, hotels, casinos, and coffee shops across the Western US• Designed and installed in downtown Culver City one of the first public Wi-Fi hot zone.• Incubated by FAME Renaissance and received training in all aspects of business operations.

Anaheim, Us

Computer Engineering And Computer Science

Education record