James Bostwick, Mis, Pmp Email & Phone Number

Florida, United States

Tampa, FL, US

• Accountable for the overall end-to-end solutions analysis and designs of several critical systems.
• Ensured that system requirements were translated effectively into solutions.
• Oversaw the planning, integration, reporting, and standard development of application architecture.
• Led, coached, and mentored the ETRM technical teams, ensuring the success of system troubleshooting and improvements.
• Developed domain governances and SOX controls for critical, high-profile solutions.
• Proactively worked with executives, business users, and IT to provide roadmaps for future business initiatives.

Colorado Springs, CO, US

• Supported the Energy Trading Risk Management System for the trading desk
• Monitored the Advanced Integration Framework to ensure system connectivity and data flow
• Investigated system errors, republished, and reconfigured deals
• Responsible for the User Management Administration and system security protocols
• Developed customized forecasting and reporting tools in PowerCosts, Allegro, C#, Excel, and VBA
• Automated GenOps inputs and Day Ahead reporting workflows for efficiency

Taylor, TX, US

• Developed SQL queries critical to the analytics of multiple departments.
• Built Cognos reports and data visualization tools that shadowed complex system calculations, so non-technical staff could retrieve data summaries on-demand.
• Created operational tools that streamlined workflows and promoted efficiency.
• Studied “competitor” technologies, and authored reports to management on best practices and recommendations for implementation in-house.
• Gathered business requirements, prepared workflows, documentation, and presentations; trained and supported department staff in the use of all technology-based tools.
• Developed use cases, assisted the organization in technology-related planning and decision making, in accordance with the company’s software development life cycle.

Austin, Texas, US

• Developed Load Forecasting system for energy trading.
• Created suite of Risk Exposure Models and reports for gas and power desks.
• Acted as Lead Developer for all trading tools, models, and hedging/position reports.
• Operated as subject matter expert on industry best practices for Front Office trading and capture of retail and wholesale market transactions.
• Authored electricity and gas scheduling tools, critical to meeting company load obligations.
• Developed stress testing models and hedging strategies to prepare management for worst case scenarios, mitigating company risk and exposure.

Houston, TX, US

• Built the Renewable Energy Reporting system for Front Office trading operations.
• Reported quarterly P&L to the parent company’s Financial Risk Committee and Board of Directors.
• Developed reports for Finance, summarizing tag inventories, inventory outstanding balance, cost of goods sold, and nominal value of quarterly transactional activity.
• Created validation and reporting system for renewable energy trading activity.
• Lead implementation and validation of long-term financial forecasts for trading and settlements reporting structure.
• Managed Risk controls for the Green Tag (REC) program

Portland, Oregon, US

• Technical lead and software support on end of day report runs, position dashboards, and VaR calculations.
• Automated complex contracts, daily report runs, and pricing spreadsheet updates.
• Subject matter expert for Mid-Office production and data analysis
• Trained juniors in Combined Reporting System and Forward Price Curve legacy systems.
• Analyzed daily market volatility, electricity and natural gas price deltas, and overall hedging position
• Developed Transmission Outage Reporting system and Green Tag validation protocols.

• Marcom Specialist & Webmaster for Symmetry Communications
• Webmaster for the U.C.S.F.-Stanford Lysosomal Disease Center
• Programmer & Webmaster for Global Healing (501 3C Non-Profit Medical Organization)
• Lead developer for Newsblog Central

US

• Analyzed marketing promotion effectiveness (response rates, ROI, etc.)
• Managed the marketing database: ETL & data validation
• Developed queries to target potential markets and construct marketing mailing lists
• Created data visualization analytics on customer demographics and account activity
• Handled the back-end analysis of Atlas promotions and mailing stuffers
• Produced monthly metrics for the loan division

• Performed ETL of state accreditation records
• Posted data to the public web portal
• Aggregated state licensing board info for managed strategy reports
• Researched prospective content sources for the website, utilizing state licensing regulatory agencies
• Established relationships with contacts of regulatory committees
• Managed the website contacts database

• Administered web-based surveys: client-facing support, data management and analysis of results for the Western Marketing, and Research for Management Divisions
• Data analytics and reporting for the HealthCare Information Resource Center
• Ad hoc reporting for Management Consultants
• Maintained the contacts database and survey results archives
• Analyzed trends in survey data, deviations from normative data, etc.

Master Of Science - Ms, Information Systems, Enterprise Technology Management

Bachelor Of Arts, Psychology, General Business

Sas Programmer Level 1, Sas

Associate Of The Arts, Music; General Ed.

C++, Asp.Net, Sql & Database Development, Software Design, Engineering