Resume

Sign in

Data Analyst, SQL Server, Integration, Reporting, ASP.net, Excel

Location:
Apopka, FL
Salary:
72000
Posted:
April 21, 2018

Contact this candidate

Resume:

Kristian Butler

Business Systems and Data Analyst

Apopka, FL 32703

ac47lt@r.postjobfree.com

229-***-****

Senior Business and Data Analyst with 18 years of experience in multiple industries. I have experience with Business Intelligence, CRM, SQL database scripting and querying, and many different front-end reporting skills over many platforms. Database platforms I’ve used are SQL Server, Microsoft Access. Front end skills include Excel, ASP.net, Crystal Reporting, PEGA, SSRS and SSIS. Authorized to work in the US for any employer

Work Experience

Pricing Integration Supervisor

Signature Flight Support - Orlando, FL

January 2017 to Present

• Integrate new acquisitions and assets into database and systems. Analyzed and verified that pricing structures are in line with profitable margins. Worked mostly in an OLTP environment.

• Integrated new software data tools and supervised the database requirements for a seamless transition.

• Integral part of implementing new PEGA System. Verified pricing rules engine for accuracy and speed.

• Mainly optimized SQL queries, develop reports in SSRS and integrating data objects through SSIS.

• Bridged the gap between the Pricing Department and the IT department. Communicated all technical requirements for my department.

IT and Analyst Manager

Greenlayer Sports - Portland, OR

January 2013 to December 2016

• Used our third party e-commerce web ordering system (Volusion) and created a service to upload API data and sync it with our on-site SQL Server 2012 database. Used data for our customized Intranet website.

• Applied SQL Server 2012 database to dynamically create ASP.NET webpages, Excel Spreadsheet, QuickBooks reports, and marketing analysis. . Applied stored procedures, functions and the basic 6 clauses. Also used SSIS and a little SSRS.

• IT Manager’s duties required me to maintain our onsite Microsoft Server 2008 for local security, Hyper-V, SSL Wi-Fi Encryption, and Active Directory. Also took care of all laptops, desktops and peripherals for updates, maintenance and initial deployment.

• Past year and half, I mainly worked on our company’s intranet website (ASP.net) which implemented online sales reports, inventory management control, CRM, Action Item tool, and our Factory Purchase Orders. This was mostly done in VB.Net and our web services were created in C#. Senior Business Analyst

VWR International - Tualatin, OR

April 2004 to July 2012

• Developed and implemented numerous original data-driven reports, including auditing and forecasting for internal and external clients. I was a project manager of many new programs and implementations.

• Support my customer (Intel) with reports, pricing, and custom analytics in order to cut cost and improve profits. Make sure the customer is satisfied and up to date on new products that can help Intel streamline current and future business processes. Integral in expanding our business with Intel Semiconductors from $25 Million in sales in 2005 to $200 Million in 2011.

• I was involved in implementing SAP ERP through SAP Business Objects. I trained at SAP facility in Canada. I was designated as a Super-User and involved in training company employees on how to use SAP BI through Netweaver. Advance knowledge of SAP Bex Analyzer and query developer.

• I received hands on education for Business Objects, Query Designer, Web Analyzer, Bex Analyzer, Report Designer and Broadcaster, and Information Broadcasting.

• Utilized several different database products in order to develop my end resulting reports. Also used several different types of reporting tools to display the end result of data I collected. My database skills include SAP OTC, SAP Bex Analyzer, SQL Server, MS Access, and UNIX. For my reports I utilized advanced MS Excel, Visual Studio, Crystal Reports, Visual Basics and Oracle BIEE.

• Took part in Salesforce.com “Administration Essentials for New Admins” class. I generated campaign and opportunity reports for the sales team for the west coast. Also created CRM dashboards in order to reduce delivery channel costs and help our sales team to reinforce our multitude of brands for life science and laboratory supplies.

• I negotiated pricing from vendors to increase our margins and analyzed pricing to Intel in order to show year over year cost savings. I made sure that our costs from our Vendors were accurately entered since certain customers would receive “Rebates Costs” to give our Sales Team extra gross margin and more profitability to our company.

Information Processing Systems Analyst

Rentrak Corporation - Portland, OR

May 2000 to March 2004

• Originally hired as an Internal Auditor which entailed as a telecommute position. Company transferred me out to Oregon from Florida based on my IT and data skills to manage a new project to track DVD movie transactions for major motion picture studios.

• Hired me to develop a CRM program to analyze millions of transactions that were connected to brick and mortar stores. Used a SaaS (Software as a Service) implementation approach.

• Extensively used MS Excel, MS Access, Oracle, UNIX and a little bit of raw html to develop the CRM reports for delivery to the Internet. I would forecast and track revenue streams, and report any major movements from the standard deviations. Based off the program that our team was building, we were competing with Nielsen ratings to display the total dollars a movie would produce in the theaters.

• Created numerous analytical programs and reports for the Movie Studios to predict proper revenue and distribution cycles.

Education

Bachelor of Science in Finance

University of Central Florida - Orlando, FL

1996 to 2000

Skills

• Extensive computer skills also consisting of Web Applications in the Visual Studio evironment, SQL Server SSIS, SSRS, Stored Procedures, MS Access, MS Excel, SAP BW, Visual Basics, Crystal Reports, UNIX, Oracle BI EE, and some Oracle 11i experience., PEGA (1 year) Links

https://www.linkedin.com/in/kristian-butler-09936966 Additional Information

Other Accomplishments and Skills:

• Detail oriented and proficient with Financial Models and TVM (Time Value of Money).

• Formally licensed with SEC as a Series 7, 63, and 55. Very knowledgeable about financial markets and derivatives.

• Good understanding of General Accepted Accounting Principles (GAAP).



Contact this candidate