Candidates About

Steven Gary Spanks

OBJECTIVE

To obtain a full time BI Developer / Analyst Position

EXPERIENCE

9/2016 – 1/2018  La Jolla Group Inc. Irvine/ California

Business Intelligence Analyst

- Learned new technologies (Full Circle, lectra PLM) quickly in order to create new interfaces as needed.  

- Created T-SQL ad-hoc reports in a timely manner. 

- Created interfaces using multiple tables within multiple databases in different servers.

- Creating stored procedures within SQL Server 2012/2016 environments.

- Documented data dictionaries, reports and entity relationship diagrams.

- Created SSIS ETL processes to import traffic counts into database for reporting purposes.  Also, created web sales daily data feeds to shopify using SSIS.

- Responsible for design, development, test and migration of business critical reports using Qlikview and SSRS.

12/2015 – 8/2016  Pacific Sunwear Inc. Anaheim/ California

Business Analyst

- Liaison support between the vendors, marketing, ecommerce, POS and Relate CRM in developing the omni channel loyalty program.

- Helped gather requirements, create requirement documentation, function design docs, process flows, test cases and sign off for PACSUN’s VIP loyalty and personalized offers programs.

- Created T-SQL queries to research and help testRelate’s CRM application.

- Responsible for requirements, KPIs, design, development, test, UAT and migration of business critical reports using MicroStrategy and IBM showcase for operational, analytical reports, charts, graphs and maintained dashboards for store and ecommerce support.

9/2012 – 11/2015 United LC CapitalLLC Inc. Vernon/ California (previously named Love Culture Inc went intoBankruptcy  in  9/2014)

Retail – SR Business Systems BI Analyst

- Created Stored Procedures within Smartlook reporting tool showing inventory, sales, shipments, transfers, purchase orders, price changes, and RTVs.

- Created and automated ecommerce data feed using Stored Procedures within SSIS.

- Learned new technologies quickly in order to create new interfaces as needed.  

- Developed, automated and supported processes using ODBC, OLEDB, SSIS, T-SQL, NSB pipeline administrator. 

- Used Excel’s Power Pivot and data analysis expressions to createflash sales reports in a timely manner. 

- Helped support VB 6 Ecommerce, Epicor interface application.

- Responsible for design, development, test and migration of business critical reports using SSRS and Epicor’sSmartlook.

2/2007 - 7/2012 Quiksilver Inc. Huntington Beach/ California

Retail - IT Business Systems Analyst

- Learned new technologies quickly in order to create new interfaces as needed.  

- Created T-SQL ad-hoc reports in a timely manner. 

- Created interfaces using multiple tables within multiple databases in different servers.

- Creating stored procedures within SQL Server 2000/2005 environments.

- Created/parsed XML using Tibco designer 5.5 and stored procedures to create/modify purchase orders and transfers.

- Documented data dictionaries, entity relationship diagrams and data flow diagrams.

- Responsible for design, development, test and migration of business critical reports using Qlikview, Cognos, Crystal Reports, SSRS and NSB Smartlook.

11/2003 - 2/2007 Washington Mutual Bank. Irvine/ California

Technical Analyst I

- Creating stored procedures, functions and triggers within SQL Server 2000 environment.

- Responsible for updating, deleting and inserting records within the SQL Server 2000 production and SIT environments during monthly releases.

- Parsed XMLs using stored procedures into different tables for automated Crystal Reports.

- Responsible for design, development, test and migration of business critical reports using Crystal Reports 8.5.

- Coding using T-SQL, PL/SQL and scheduling jobs/verifying configuration.

- Worked within a teamwork environment using agile methodology.

9/1999 - 7/2003 Nike Inc. Beaverton/ Oregon

Business Systems Analyst

- Built Data Warehouse from Oracle, Teradata and SQL Server data sources for their USA Delivery Logistics reports.

- Contribute to US delivery logistics system architecture reengineering activities.

- Provide written documentation and presentations to train end users how to use new reports.

- Responsible for design, development, test and migration of business critical reports using Brio Explorer 6.2, Access 2000, SAP BW's Infoset and BEx reporting tools.

- Responsible for business requirement analysis and source system analysis.

- Coding using PL/SQL, T-SQL, VBA, Java Script, SQL Navigator, TOAD, scheduling jobs/verifying configuration.

- Worked within a teamwork environment.

6/1998 - 10/1998 Freightliner LLC VIA Diamond Consulting Services Portland/ Oregon

 Programmer/ Analyst Intern

-Analyzed, modified, tested and implemented COBOL programs.

-Worked with users to correct claims w/ duplicate serial numbers.

-Used TSO and IMS/DB2 production databases.

-Modified JCL jobs and researched abends.

EDUCATION

6/1998 Oregon State University US-Oregon-Corvallis

 Bachelor's Degree

 Major: MIS

Minor: Pre-Law Studies

Earned 100% of Education Cost

SKILLS

Programming: Visual Basic 6.0, C, COBOL, VBA, Java Script, C#, Java, Visual Studio 2010

Productivity Tools: Tibco Designer, SSIS, DTS Packages, TortoiseCVS 1.6, Remedy 6.3, Test Director 8, iderasql diagnostic manager 6.6, Load Runner 7.8, TOAD, XDoctorGUI 1.0, SSRS, SSAS, Qlikview, Tableau, MicroStrategy, NSB SmartLook 5.0, Brio Explorer 6.2, Crystal Reports 8.5/9, MS Project 98/2000, MS Office 2016, Visio 2000, Visual Safe Source 2.0, ISPF, Expediter, ECM2.

Systems Analysis: Data Flow Diagrams, Entity Relationship Diagrams, Project Dictionaries, Structure Programming.