Todd McLaughlin
Sr Data Analyst at Trellance- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Sarah Witt
Todd and I worked on the same team for 2.5 years. During our time as teammates he was extremely professional and performed his duties with skill. He takes pride in developing expertise in any project he is supporting and is technically savvy. Todd would be an asset to the workplace.
Sarah Witt
Todd and I worked on the same team for 2.5 years. During our time as teammates he was extremely professional and performed his duties with skill. He takes pride in developing expertise in any project he is supporting and is technically savvy. Todd would be an asset to the workplace.
Sarah Witt
Todd and I worked on the same team for 2.5 years. During our time as teammates he was extremely professional and performed his duties with skill. He takes pride in developing expertise in any project he is supporting and is technically savvy. Todd would be an asset to the workplace.
Sarah Witt
Todd and I worked on the same team for 2.5 years. During our time as teammates he was extremely professional and performed his duties with skill. He takes pride in developing expertise in any project he is supporting and is technically savvy. Todd would be an asset to the workplace.
Experience
-
Trellance
-
United States
-
Financial Services
-
100 - 200 Employee
-
Sr Data Analyst
-
Jun 2022 - Present
-
-
-
The Axiom Group
-
United States
-
Financial Services
-
1 - 100 Employee
-
Director of Business Analytics
-
Feb 2022 - Jun 2022
• Reporting revenue of trend analysis for collection accounts. • Present monthly analysis reporting on revenue potentials and losses to executive level management. • Propose process and operational enhancements. • Draft all documentation addressing Standard Operating Procedures, Process Flows, and Procedures. • Support all departments on data concerns and operational concerns. Skills • SQL Server Management Studio • Tableau • MS Office Suite • PowerBI • Reporting revenue of trend analysis for collection accounts. • Present monthly analysis reporting on revenue potentials and losses to executive level management. • Propose process and operational enhancements. • Draft all documentation addressing Standard Operating Procedures, Process Flows, and Procedures. • Support all departments on data concerns and operational concerns. Skills • SQL Server Management Studio • Tableau • MS Office Suite • PowerBI
-
-
-
Trellance
-
United States
-
Financial Services
-
100 - 200 Employee
-
Data Analyst
-
Jul 2020 - Feb 2022
• Data analysis supporting credit union financial resolutions with multiple products and account types such as Mortgages, Checking and Savings accounts, and various Loan type scenarios. • Troubleshoot any out of balance scenarios that are present and banking reconciliation. • Quality assurance testing of programmatic solutions with regards to account management. • Proficient with Jira IT Ticketing Management software to track internal and external project timeframes. • Interface TestRail TestCase Management software to adhere to SDLC project lifecycle methodologies. • Analyze, test and provide input on programmatic design specifications to ensure client expectations are resolved.
-
-
-
Insight Global
-
United States
-
Staffing and Recruiting
-
700 & Above Employee
-
Information Technology Business Analyst
-
Mar 2020 - Jul 2020
• Business Systems Analyst adhering to the Agile Scrum methodology. • Experienced using SQL scripting for data mining to interpret result sets into usable reporting to provide feedback to clients and management. • Documenting data mapping for from multiple reporting sources. • Business Systems Analyst adhering to the Agile Scrum methodology. • Experienced using SQL scripting for data mining to interpret result sets into usable reporting to provide feedback to clients and management. • Documenting data mapping for from multiple reporting sources.
-
-
-
XeoHealth Corporation
-
United States
-
Information Technology & Services
-
1 - 100 Employee
-
Data Analyst
-
Aug 2018 - Jan 2020
Business Systems Analyst / Data Analyst Middletown, Maryland XeoHealth Corporation / August 2018 to January 2020 • Business Systems Analyst adhering to the Agile Scrum methodology. • Data Analyst specialist with EDI X12 health care claim submissions and HIPPA regulations. • Troubleshooting health claim inquiries and with resolution management. • SDLC quality assurance testing of programmatic enhancements with claim management. • Proficient with Jira IT Ticketing Management software to track internal and external project timeframes. • Interface TestRail TestCase Management software to adhere to SDLC project lifecycle methodologies. • Analyze, test and provide input on programmatic design specifications to ensure client expectations are resolved. SKILLS • MS SQL Server Management Studio • Proficient with MS Office Suite (Word, Excel, Access, PowerPoint, Projects, Outlook.) • SharePoint • Jira IT Ticketing Smartsheet • Testrail Test Case Management Software • HIPPA X12 837 EDI
-
-
-
First Data Corporation
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Senior Business Systems & Implementation Analyst
-
Jul 2004 - Jun 2018
2004 – 2018: Senior Business Systems & Implementation Analyst•Proactively identified and solved complex problems impacting operational management and business direction by delivering financial reporting producing on average of 80+ weekly analytical solutions based on a variety of parameters to support business demands.•Delivered an exceptional level of service to each customer by listening to concerns and answering questions.•Wrote Business Requirement Documents for small and major scale corporate projects.•Created communication strategies to meet merchant objectives to senior and executive level management.•Documented project updates to management on merchant progress, at-risk merchants and merchant forecasting by developing dynamic formal dashboards to communicate monthly financial results and forecasting to senior and executive level management.•Executed ongoing implementations for the Revenue Sharing Alliance Spring and Fall Association Compliance Release merchant rate adjustments at the individual account level for over 600,000 merchant accounts within the RSA bank platforms to meet Compliance requirements while generating in excess of $40mm in projected revenue year over year.•Provided outstanding service and support to internal and external customers by engaging closely with all First Data business units such as Business Track, eSalesForce.Net, Cross Sales, Retention, and Marketing supporting all revenue generating initiatives and reporting are met on a timely and cost effective basis while addressing any concerns and provide solutions.•Oversaw numerous corporate projects from conceptualization to completion leveraging product development lifecycle analytics (SDLC), reporting, documentation and specifications supporting financial software for eCommerce hardware solutions and services of corporate supported credit card terminals and the Clover™ suite of applications for vendor processing.
-
-
Programmer Architect
-
Nov 1996 - Jul 2004
1996 – 2004: Programmer Architect•Mainframe developer designing the FSAMS (Financial Services Automation Management System).•Designed multiple in house applications using Visial Basic suite utilizing ODBC connection for SQL Server database connectivity.•Designed multiple intranet web based applications using Microsoft DotNet environment with an ODBC connection to SQL Server databases.•Main front line support for all system wide applications during Y2K transition.SKILLS • COBOL, JCL, MVS, SyncSort• MS Visual Basic off host application development • MS Visual InterDev application development for Intranet programs • JavsScript, HTML, ASP, MS DotNet, Visual Studio • MS SQL Server Management Studio, Oracle SQL, DB2 • Proficient with MS Office Suite (Word, Excel, Access, PowerPoint, Projects, Outlook.) • SharePoint
-
-
-
United States Marine Corps
-
United States
-
Armed Forces
-
700 & Above Employee
-
Corporal
-
Jan 1985 - Dec 1992
1985-1987: Administration Assistant (Lance Corporal, E-3)• Answered phones to direct callers, schedule appointments and provide general office information.• Performed all administrative duties as required and directed by the Commanding Officer supporting the oversight of TME-32 Office.• Supervised daily purchasing and managed all supply inventories.
-
-
Corporal - Combat Support/Operation Desert Storm
-
Jan 1991 - Jun 1991
Camp LeJeune, North Carolina1991-1991: Combat Support: Operation Desert Storm (Corporal, E-4)• Recalled to active duty supporting Operation Desert Storm• Awarded National Defense Service Medal• Honorable Discharge Jun 1991
-
-
Corporal - Administrative Assistant to Commanding General
-
May 1987 - Dec 1989
Kaneohe Bay, Hawaii1987-1988: Administration Assistant to the Command General (Corporal, E-4)• Performed all administrative duties as required and directed by the Commanding General and Chief of Staff.• Responsible for all protocols involving a Flag Grade Officers to include transportation security.• Awarded Good Conduct Medal.• Received Letter of Appreciation by the Command General.• Received Certification of Appreciation by the Commanding General.• Honorable Discharge Feb 1989
-
-