Alex Moody
Brooklyn,NY
Summary
Accomplished Senior Software Engineer with a proven track record at InnoSys, specializing in ETL development and database design. Leveraged advanced SQL queries and agile methodologies to enhance insurance administration systems, demonstrating exceptional business analysis and program planning skills. Achieved significant process optimizations and system improvements, showcasing a blend of technical prowess and strategic insight.
Overview
19
19
years of professional experience
Work History
Senior Software Engineer
InnoSys
Burgas, Bulgaria
12.2021 - 06.2024
- Led the design and implementation of comprehensive database systems for insurance solutions.
- Built ETLs to populate the database from multiple source systems. I used a mix of pure SQL, with SSIS packages being used in some cases where it was advantageous.
- Created and published reports using SQL and SSRS.
- Gathered user requirements for features and reports required from the databases I was administering.
- Implemented a solution to process Lloyd's syndicate messages, ingesting, validating, and enriching the data for entry into the data warehouse.
- Troubleshooting issues related to historic reports and processing.
- Production of actuarial triangle data from the data warehouse.
Technical Analyst Developer
Digital Solution Foundry
Johannesburg, South Africa
02.2005 - 12.2021
- Developed features on the claims and credit control solution.
- Guided solution design, and helped with solution testing.
- Provided user support.
- Analyzed data and logs to track, identify, and fix bugs.
Development Manager
Hollard Insurance
07.2014 - 05.2018
- As the development manager I was involved in all processes within the development lifecycle from acquisition of requirements through the development, deployment, testing and release
- The development team was rapidly expanded to enable both an implementation of a paperless system as well as the implementation of the line of business systems to another four businesses in other countries
- I was tasked with creating, selecting and organizing all the agile teams to support both implementations
- I was deeply involved in all operational aspects of the department all the teams and creating their development workflows
- Managerial Duties:
- Evaluate and select new software applications
- Design and organize the agile teams
- Produce project reporting to stakeholders
- Design and implementation of the software release management processes
- Design and implementation of development processes
- Daily Duties:
- Gather and document requirements with business stakeholders and from the defect backlog
- Technical design the implementation of requirements including:
- Y-frames, mock-ups and demos
- Database design implementation
- Software implementation
- Develop any SQL Queries required
- Deployment of software for testing
- First test and review of requirements
- Run and manage the Agile ceremonies including:
- Planning
- Prioritization
- Stand-up
- Retro and Review
- Produce ad-hoc reports or investigations into transactions interrogating the database directly
- Projects:
- New front end for the insurance claims process
- For this project I managed all facets of the project from conception design implementation and support
- System integration project
- Under instruction from our architect we created a service bus with a hub and spoke integration design
- I was responsible for managing the development team
- Line of business system migration in other Southern African countries
- I was responsible for managing all changes required to the credit control and claims processes for these implementations
- I also was responsible for designing the build and deployment processes for these remote sites
- Development of a new insurance products
- I oversaw the design and implementation of two insurance products
- Applications Used:
- MS SQL Server Management Studio – Used Extensively
- MS Visual Studio – Used to review code, debug, write small ad-hoc procedures
- JIRA – Used daily to manage teams, write requirements
- Bamboo – Used to implement build and deploy processes
- Bitbucket (GIT) – Used to commit any code changes, as well as code reviews
- Excel – Used for reporting
Business Analyst
Etana Insurance
05.2012 - 06.2014
- I arrived at Etana just before a new policy administration was implemented
- I quickly became the go to person for ad-hoc queries and investigations as I was well acquainted with the database structures
- I was responsible for maintaining the claims processing portion of the systems as well as designing and implementing the credit control functions, for which we developed our own application
- It was during this period that I was part of a small team to select a new workflow application
- I was involved from the initial requirement statement through the request for proposal and proof of concept
- I later oversaw the successful implementation of the application we selected in my following role
- Project: Claims :- Business as usual management of the insurance claim system including new features and support
- Created managed and maintained a backlog of required changes and bugs
- Held prioritization meetings to prioritize changes and bug fixes
- Gathered and documented requirements as well as created working mock-ups for development
- Managed development process as well as the testing and deployment process
- Conducted user training
- Project: Credit Control :- The creation of an insurance policy credit control front end followed by the Business as usual management
- Gathered requirements from business
- Documented requirements
- Managed development process with offshore developers
- Tested new features
- Managed the release cycle
- Daily Duties:
- Supported in-house developed credit control system
- Supported the claims management system
- MS SQL Server Management Studio – I used extensively
- Word – I used extensively for requirements
- Excel – I used for reporting and analysis
Business Analyst
Momentum Investments (ex RMB Asset Management)
09.2008 - 04.2012
- During this period, I gained experience as a technical business analyst
- I would work with business teams to directly create solutions
- Working on my own I managed to fully automate all aspects the unit trust fund of fund administration, enabling the administrator to manage double the number of funds
- I gained extensive knowledge of many aspects of the business from portfolio management to corporate actions to credit control
- Project: CGT treatment on corporate action events
- I worked with the tax and corporate actions team to implement the often-complex tax requirements of a corporate action in the portfolio administration system
- The tax code and the nature of corporate actions meant that the system could not handle all events so we would have to process this outside on an ad-hoc basis
- Project: Implementation of an instrument valuations tool
- I worked with business users to provide the requirements to the vendor
- I developed the accounting interfaces required to capture valuations, assisted with the testing and implementation
- Project: Fund Cash flow Forecast
- I documented the current process and proposed changes to the process as well as implemented some automation of reporting and data gathering
- The project improved the forecast and the level of trust in the forecast of the portfolio managers
- Possible overdrafts have been forecast and avoided which will in the long-term increase performance
- Project: System Migration
- I was required to gathering the requirements for the development of the interface with the accounting system to form the Functional specification for the interface
- Project: Automation of Unit Trust Trading Platform
- In this project I gathered and documented the requirements as well as developed the new solution and I performed the required reconciliations for the implementation
- Ultimately, I delivered a solution that significantly reduced the resources required to operate the business and reduced risk by increasing automation and reconciliation capabilities
- Applications Used:
- Excel – I used extensively and intensively for reporting on and the processing of data
- Word – I used extensively for requirements documentation
- Visio – I used extensively for both process engineering and database design
- Linux, Perl, Python – The systems were predominantly linux based so I had some exposure to maintenance on a Linux machine as well as writing some applications in perl and Python
Business Specialist
JP Morgan
10.2006 - 08.2008
- Although I was permanently employed for JP Morgan it was due to a portion of the RMB Asset Management being acquired by JP Morgan
- This deal ultimately fell through with the financial crisis and all employees where seeded back to Momentum
- I represented the international and unit trust departments as a business expert on the system migration project
- I was required to be the expert on the new system and processes as well as to assist in testing and documenting those systems and processes
Education
Master of Commerce - Economics
WITS
01.2008
Bachelor of Business Science - Information Systems, Economics
Rhodes University
01.2005
Matric (IEB) - Six Subjects (HG)
St Stithians College
01.1999
Skills
- Agile Teams' Leadership
- Software Development Lifecycle
- Continuous Integration
- Strategic Planning
- ETL/ELT development
- Advanced SQL queries
- Database design and architecture
- Database development
- Business analysis
- Program planning
- Resource coordination
- Requirements gathering
- NET programming
- Entity framework
- Javascript
- Defect tracking
- Report writing
Hobbies and Interests
- Economics
- Sport
Personal Information
Date of Birth: 05/16/81
Languages
French
Professional
References
References available upon request.
Timeline
Senior Software Engineer
InnoSys
12.2021 - 06.2024
Development Manager
Hollard Insurance
07.2014 - 05.2018
Business Analyst
Etana Insurance
05.2012 - 06.2014
Business Analyst
Momentum Investments (ex RMB Asset Management)
09.2008 - 04.2012
Business Specialist
JP Morgan
10.2006 - 08.2008
Technical Analyst Developer
Digital Solution Foundry
02.2005 - 12.2021
Master of Commerce - Economics
WITS
Bachelor of Business Science - Information Systems, Economics
Rhodes University
Matric (IEB) - Six Subjects (HG)
St Stithians College