Hesam Shoghi
New York,NY
Summary
Analytical leader with 20+ years designing and implementing financial planning, regulatory reporting, and BI frameworks. Expert in data assessment, reconciliation, audit & risk reporting, and dashboard development. Adept at translating complex regulatory requirements into actionable analytical solutions and collaborating with global stakeholders to drive strategic decision-making.
Overview
24
24
years of professional experience
Work History
Senior Analyst, Information Technology
McKissack & McKissack
01.2016 - Current
- Developed and maintained a Power BI forecasting and planning platform to support stress-testing scenarios and improve forecast accuracy; automated reconciliation processes to eliminate repetitive manual work.
- Designed dynamic dashboards and custom VBA macros for MWBE compliance and regulatory reporting, accelerating audit readiness and ensuring data integrity for 300+ subcontractors.
- Spearheaded data quality assurance initiatives, establishing validation rules and monitoring procedures to minimize data errors and enhance report reliability.
- Collaborated with compliance, finance, and operations teams to translate audit and regulatory requirements into technical specifications for reporting solutions.
- Automated multi-stage approval workflows using PowerApps and Power Automate, standardizing submission processes for 130+ users and streamlining request approvals.
- Developed onboarding and event request applications with automated workflows to streamline user onboarding and event coordination.
- Authored comprehensive policy manuals, project management guidelines, and technical nomenclature standards to drive consistency across IT initiatives.
Senior PHP Developer
eMagid
01.2015 - 01.2016
- Developed, tested, and supported custom PHP/PostgreSQL web systems, leveraging jQuery, AJAX, JSON, CSS, and HTML to meet diverse client requirements.
- Utilized GitHub and SourceTree for version control, facilitating seamless team collaboration and code integrity.
- Produced detailed technical documentation and user guides to streamline system handovers and client training.
Systems Analyst
Tilson
01.2011 - 01.2015
- Contributed to Tilson’s Enterprise Software Development team by analyzing existing and proposed systems and designing robust data-processing solutions.
- Developed and tested applications in VB, PHP, MySQL, JavaScript, HTML, and CSS within an MVC framework to satisfy business planning objectives.
- Led QA efforts—creating automated test scripts and troubleshooting environments—to ensure release quality and reliability.
- Configured networks, administered servers, and resolved system issues to support deployments and ongoing maintenance.
- Authored and maintained system documentation, including specifications, user manuals, and CMS implementation guides.
- Managed client Salesforce data through custom reports and Visualforce pages, ensuring accuracy and accessibility.
Web Developer / Support Analyst
Visual Strategies & Associates Inc.
01.2008 - 01.2011
- Developed CMS and e-commerce solutions using Joomla, Drupal, and Concrete5; performed infrastructure security upgrades to maintain high availability and deliver custom reporting dashboards.
Software & Web Application Developer
Carma Developers LP
01.2006 - 01.2008
- Built ASP.NET and VB reporting tools with SQL Server backends to deliver scheduled financial reports to executive stakeholders on time.
Senior Programmer
Calgary Police Service
01.2002 - 01.2006
- Architected VB.NET and ASP/ASPX applications and managed SQL databases to enhance analytical reporting and case-tracking efficiency.
Education
Master Certificate - Music Production & Technology
Berklee College of Music
Boston, MA05.2009
B.S. - Computer Science
University of Saskatchewan
Saskatoon, SK, Canada04.2000
Skills
- PHP, ASP, VBNET, NET, VBA, JavaScript, jQuery, HTML, CSS
- SQL Server, MySQL, PostgreSQL, Access, Dataverse
- Power BI, DAX, PowerApps, Power Automate, SharePoint
- SSRS, Crystal Reports, Business Intelligence & Analytics
- Visual Studio, NetBeans, IIS, WAMP, MAMP, Concrete5, Office 365, TortoiseSVN, Git, SVN
- Technology Strategy & Roadmap Development
- Regulatory & Audit Reporting (Stress Testing, Planning)
- Data Quality Assurance & Governance
- Workflow Automation & Integration; Agile & DevOps Practices (CI/CD)
- Cross-Functional & Global Collaboration; Stakeholder Engagement & Requirements Translation
- Technical Writing & Policy Documentation; Strategic Thinking & Problem Solving; Risk Management & Business Continuity
- Data modeling
- Back end development
- Problem-solving skills
- SQL proficiency for data analysis
Websites
Timeline
Senior Analyst, Information Technology
McKissack & McKissack
01.2016 - Current
Senior PHP Developer
eMagid
01.2015 - 01.2016
Systems Analyst
Tilson
01.2011 - 01.2015
Web Developer / Support Analyst
Visual Strategies & Associates Inc.
01.2008 - 01.2011
Software & Web Application Developer
Carma Developers LP
01.2006 - 01.2008
Senior Programmer
Calgary Police Service
01.2002 - 01.2006
Master Certificate - Music Production & Technology
Berklee College of Music
B.S. - Computer Science
University of Saskatchewan
Similar Profiles
Dami RobertsDami Roberts
Project Controls Specialist at Mckissack & MckissackProject Controls Specialist at Mckissack & Mckissack
Austin BlommeAustin Blomme
Senior CAD Technician at McKissack & McKissack-WashingtonSenior CAD Technician at McKissack & McKissack-Washington
Gabriel GunterGabriel Gunter
Intern Estimator (First Ever Intern) at Mckissack and Mckissack (Black Engineering Firm)Intern Estimator (First Ever Intern) at Mckissack and Mckissack (Black Engineering Firm)
CHRISTINA FANGCHRISTINA FANG
Freelance Web Developer at Self-employeedFreelance Web Developer at Self-employeed
David JenkinsDavid Jenkins
LPN at Harlem Hospital CenterLPN at Harlem Hospital Center