Sql Server .Net
Resume:
FRANKY SULISTIO
**** ***** ******* **, *******, TX 77094
***************@*****.***
EDUCATION
Master of Science, MIS (Business Analysis, Decision Support Systems), Texas Tech University
Lubbock, TX
Bachelor of Business Administration, Finance, University of Wisconsin, Eau Claire, WI
CERTIFICATIONS & TRAINING
Natural Gas, Wellhead to Burnertip by Patterson & Associates
The Basics of Risk Management by Patterson & Associates
Energy Derivatives, Advanced Structure & Marketing by Paradigm Strategy Group, Inc.
Futures, Options & Derivatives by Energy Management Institute
SunGard’s Entegrate, Entegrate Analytics, & Hedge Accounting System by SunGard
Microsoft Certified Solution Developer (VB6 Desktop/Distributed, SQL Server 7)
TECHNICAL SKILLS
Languages: ASP.NET, C#, VB.NET, JavaScript, VBScript, VBA, HTML, DHTML, XML, XSLT, AJAX, LINQ, jQuery Angular, MVC, WCF, WPF, and Visual Studios
RDBMS: SQL Server, Oracle, and SQL Server Reporting Services
ETRM: SunGard’s Entegrate, Analytics, Hedge Accounting System, and Triple Point CommodityXL
Others: ADO.NET, Entity Framework, Oracle ODP.NET, Tibco RV, Tibco Spotfire, and Microsoft TFS
PROFESSIONAL EXPERIENCE
The Frontline Group 05/2017-Present
Independent .Net Contractor
•Develop a complex web-based timesheet system for a law firm using Visual Studios; ASP.NET/C#, Angular, and SQL Server.
•Implement complex business rules in the SQL Server procedures, functions and nightly job schedulers for easier maintainability by the client.
Wood Group Mustang 05/2012-05/2017
Senior Principal Technical Professional
•Developed Common Data Model for BP Greenhouse Gas Reporting and Website utilizing ASP.NET/C#, Oracle Database and Tibco Spotfire Reporting Engine.
•Website was implemented with Windows Authentication, Role Based Security Model, and System Administration Module.
•Designed and developed .NET WPF/C# application to provide data exchange interface from Windows Application to the Toshiba PLC Controller for Yupo.
•Systems enabled the end-users to configure Recipe using pre-defined templates and easy to upload Recipe Systems to Toshiba PLC Controller with multiple error checking phases for completion and real-time notification.
Triad Resources for BP, Apex Systems for United Airlines, Opportune for TVA, Sirius Solution for Shell, Houston, TX 05/2010-05/2012
Independent .NET Contractor
•Provided consultancy services to United Airline Catering Service application conversion efforts from Windows to Web Application technologies, utilizing ASP.NET/C#, WCF, AJAX, jQuery and LINQ.
•Led business analyst and was technical consultant for the Physical Gas Cost Allocation project to ensure that external gas supplier’ invoices reconcile with the internally generated data from CommodityXL and implement custom logics to calculate the WACOG (Weighted Average Cost of Gas) for the monthly gas usage to generate power.
•Provided daily supports and custom application developments for BP North America Gas and Power traders, schedulers, credit, risks, quantitative, and fundamental market research analysts.
•Architected Real-time Cash Trading Manager to enable traders, schedulers and produce services to have common views of existing volumetric and notional positions of Gas Trading Desk portfolios for pre-specified tenors.
Openlink Financial, Houston, TX 05/2008-07/2009
Senior Technical Consultant
•Assisted Project Managers to fix any open and critical issues for the existing clients remotely from the Houston Office.
•Developed application interfaces to enable data flow to and from Endur using .NET web services architecture and windows services components.
Cheniere Energy, Houston, TX 08/2006-06/2008
Senior Application Specialist
•Configured, implemented and integrated packaged solutions in the Energy Trading, Risk Management applications.
•Worked with WCF in the .Net Frameworks throughout projects.
•Developed ETL processes using SSIS as well as Windows services within Visual Studios.
•Supported all users of SunGard’s Entegrate Marketing, Accounting, Scheduling, Credit and Risk systems from Traders, Schedulers, Quantitative Research Group, Credit and Risk Officers to Accountants (Front, Mid and Back Office).
Mustang Engineering, Houston, TX 06/2005-08/2006
Principal Technical Professional
•Was a member of a development group, responsible for development of a web-based environmental monitoring historian and reporting system; The system enables environmental engineers to monitor emissions level accurately and to generate regulatory reporting requirements timely.
•Enhanced WebPFD Display Conversion Modules to enable customers to rapidly maintain and/or design custom web browser interfaces to plant and process data using VISIO and convert them to different industry Process Graphics Tools, such as Web.21, Aspen Process Explorer.
El Paso Energy, Houston, TX 04/2004-08/2005
Principal IT Analyst
•Developed Merchant Energy Portal for El Paso Traders and Marketers.
•Managed LineCost project to assist in reconciling the Southwestern Bell (SWB) bill to internal records.
•Developed billing dispute batch application to verify charges from SWB against El Paso internal records.
Gas Fundamental IT, UBS, Houston, TX & Stamford, CT 08/2000-03/2004
Team Lead
•Developed web based real-time pipeline operational capacity reporting tool utilizing ASP.NET, C# and SQL Server 2000.
•Developed web-based real-time physical/financial deal positioning reports with ASP, COM+, XML, XSLT, JavaScript and Tibco RV.
•Designed and developed a web-based real-time basis curves application for the power and gas traders utilizing ASP, COM+, XML, XSLT and Tibco RV.
•Supported applications using SSAS processes and SQL.
•Involved in the full lifecycle development of EnTelligence, an n-tier web based prospecting tool designed to deliver market information on new and existing Enron counter-parties for all commodities.
•Analyzed data models to develop appropriate views and stored procedures that will maximize web based report performance.
Contact this candidate