James Calvano
Haverstraw, NY
Programming/Query Languages
- SQL/TSQL
- MDX
- Python
- Visual Basic For Applications (VBA)
- HTML/CSS/XML/JSON
Tools
- Github/Bitbucket
- Tableau/PowerBi
- OLAP Tools (Oracle BI, Essbase, Cognos)
- Microsoft Office (Excel, PowerPoint)
Work Experience
U.S. Bank - Global Fund Services
Jul 2022 - Present •
Technical Systems Specialist
Global Fund Services - Central Investor Services - Business Technology Enablement
- Consulting with various internal teams to explore
process enhancement, and process automation
- Exploring the use of data visualization tools as
well as OLAP Cubes (Microsoft SQL Server Analysis Services) to facilitate better business
analysis
- Used Python (Networkx) to automate intrafund
bookings for numerous large and complex private equity legal entity structures
Prudential Financial
Feb 2019 - Jun 2022 • 3.5 years
Technical Systems Specialist
Global Technology - Financial Systems - Technology Enablement
- Documented, designed and developed technology
solutions for Finance Associates (Accounting, Treasury, FP&A) to increase productivity, reduce
operational risk
- Saved 500+ hours of manual Excel work through
rapidly developed automated applications (Rapid Application Development)
- Collborated with business end-users, project
managers as well as development teams
Insight Global
Oct 2018 - Feb 2019 • 4 months
Business Systems Analyst (Contract)
Contract to Hire - Prudential Finanical
The Children's Place
Sep 2016 - Aug 2018 • 2 years
Corporate Financial Analyst
Financial Planning - Corporate Accounting/Finance - Store Finance & Inventory Control
Education
University of Dayton
May 2012 - May 2016
Bachelor of Business Administration - Finance & Economics - Emphasis in Investment Management