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.•Interfaced with outside vendors, consultants, industry representatives, and procurement for multi-year projects and programs.•Maintained organization process assets, artifacts, policies, standards, and procedures for core applications.•Directed analysts, and other architects, on special integration and assessment projects.•Managed outside support contractors and consultants to ensure adequate system coverage.•Drove impact assessments, owned change requests, and presented stakeholder requirements to program management teams and steering committees.•Represented company interests by networking at seminars, events, subsidiary site visits, and industry appearances. •Led the forty-member digital task force team, presiding over company data migration, system updates, and workflow process mapping.•Worked the data integration and automation side of the Southeast Energy Market project.•Strategic technology, initiatives, and governance representative to the change advisory board, compliance, and audit departments.•Managed special projects and initiatives requiring business and technical expertise.Technical tools utilized: SAP R/3 ECC, SAP S/4 HANA, Signavio, Aris, Allegro, C#, Visual Studio, Microsoft SQL Server, Excel, PowerPoint, Visio, SharePoint

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•Updated system ETRM inputs; maintaining PI data integrity upstream•Analyzed system requirements, developing RFI’s, RFP’s and SOW for system upgrades and replacements•Operated as technical lead for the transition to a new cloud-based trading and risk management reporting platform•Performed Database management and warehousing of critical trade data•Developed a technical education program to instruct personnel in software programs, forecasting and marginal calc procedures, utilizing video, screen capture, and audio recording•Acted as lead technical liaison between CSU and Amazon Web Services, coordinating the migration to EC2 & RDS•Administrated SharePoint sitesTechnologies Utilized: FIS/SunGard Aligne, Powercosts, Inc., Allegro, GenOps, PowerShell, Crystal Reports 13, SQL, XML, Visual Studio & .Net Framework, C#, Python, Java, BeanShell, TOAD, Oracle, SQL Server, PI, Amazon Web Services, SQL Developer, Oracle Data Visualization Desktop, Adobe Premiere, Shotcut Video Editor, OBS Studio, Microsoft Power BI, ServiceNow, Eclipse IDE, and Apache Subversion

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.•Authored change requests, release requirements, impact analyses, and tested software upgrades (including regression testing) for company CRM and Citrix portals.•Lead support response for API/XML connectivity, and technical issues with the Texas energy market.•Developed suite of automated data analytics reports and business analysis tools for Web Content, influential in executive decisions.•Performed ad hoc reporting for company website and mobile app platforms, using Splunk and Google Analytics.•Acted as Lead Analyst for the company’s Enterprise Content Alignment, metadata, and transition to Amazon Web Services programs.•Administered department SharePoint pages and dashboards•Used VBA and SQL to build analytics tools, parse generation data, and to populate market-facing RFI’s•Assisted market participants in setting up and testing their SOAP-based API/XML telemetry•Presented technical change requests and nodal protocol revision requests to Client Services staff

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.•Automated customer usage profile calcs, P&L reports, and budgeting models using VBA•Presided over Limits Reporting and Hedging Compliance, in accordance with established Risk policy

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•Built dashboards, operational controls, and pricing templates for trading and settlements desks•Reconciled data in the Green Book with ERCOT, PJM, and NYISO tracking systems•Ensured compliance with Risk limits policy and Sarbanes-Oxley requirements•Validated deal entry and counterparty invoices•Managed credit risk reporting•Principal analyst for data analysis and reporting for the commercial and trading arm of the company

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.•Created training tools and technical documentation for department•Produced cash month, profit/loss, and other financial reports•Performed quarter end auditing of physical and financial trade models•Maintained the forward price curve, treasury curve, and index settlement databases; issued historical data reports for inter-departmental ad hoc requests•Implemented transmission link capacity, tariffs, scalars, and general updates for existing models•Built validation and analysis tools in VBA, and modelled long-term complex contracts•Conducted daily VaR stress tests to assess the risk of significant price movement of non-linear positions on the volatility of future earnings•Presided over credit exposure, stop loss, and risk management reporting to Front Office

•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•Researched competitor promotions and interest rates

•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•General support for database and data loading technical issues•Created scripts to aid in loading licensing data •Supervisor for special call center data acquisition projects (8-12 employee teams)

•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