Sql Server Management
Resume:
Jason Johanneck
Email: abpqav@r.postjobfree.com
Address: *** ***** *** ** #***
City: Bellevue
State: WA
Zip: 98004
Country: USA
Phone: 425-***-****
Skill Level: Experienced
Salary Range: $80,000
Willing to Relocate
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
Jason Johanneck
abpqav@r.postjobfree.com
Objective: Business Analyst
Software Development Overview
SQL Server BI Tools:
T-SQL, Stored Procedures, SSIS, OLAP Cubes, SSRS, SQL Server Management Studio, Microsoft Visual Studio, Excel Pivot Tables
Programming Languages:
T-SQL, some MDX, HTML, Java-Script, AS400 Cobol, Microfocus Cobol, i-Series CL
Platforms: SQL Server 2008, SQL Server 2000, i-Series (DB2), Vax/VMS, Unix
Professional Experience
Expeditors International of Washington August 2012 - Current
Cobol Developer - Transportation
Microsoft via Aditi Consulting June 2011 - June 2012
Business Analyst - Xbox Live Business Intelligence Group
* Perform analysis of Xbox Live email marketing campaigns using complex SQL joins on tables across multiple databases.
* Maintain Excel Power Pivot tables for campaign efficacy reporting.
* Perform daily monitoring of marketing campaigns following support protocols for error triage.
* Create and maintain custom SQL views to implement business rules for identifying Xbox Kinect games and users.
University of Washington Professional and Continuing Education Dept. January 2012 - June 2012
Teaching Assistant - UW Data Warehousing Course.
* Winter Quarter 2012 - Planning, Designing and Implementing ETL Solutions.
* Spring Quarter 2012 - OLAP Cubes and Reporting Services.
Zones . March 2011 - May 2011
Cobol Developer on HP3000 migration project
State of Washington - Labor Market and Economic Analysis group August 2010 - February 2011
SQL Developer for Washington State Green Jobs Grant team.
* Created automated SSIS tools to extract and collect labor market information into data marts for advanced analysis.
* Developed OLAP cubes from data stores to improve access to employment statistics by local area economists.
* Built SSRS reporting interfaces for agency staff to display quarterly census of wages and employment data over customized time periods.
Bowne Business Marketing and Communications March 2005 - July 2009
As an Applications Developer supporting direct marketing campaigns:
* Collected data on customer activity from multiple data sources into central marketing databases on AS/400 platform.
* Developed and maintained customer inquiry fulfillment applications using iSeries CL and Cobol.
* Executed and maintained custom built ETL solutions for multiple clients adhering to business requirements for data integrity.
* Analyzed and documented client marketing fulfillment systems using Visio to align IT processes to clients business rules.
* Created and executed ad-hoc reports to analyze customer buying habits based on demographics and geography.
* Tracked marketing campaign activity to support senior management ROI analysis.
DHL/Danzas Air & Ocean March 1995 - July 2004
As a Systems Analyst configuring inventory management systems:
* Consulted with project leads, program managers and programmers from Infosys to migrate Danzas inventory management applications to a remote DHL data center.
* Worked with business development managers, client contacts, end-users and other systems analysts to build customized inventory management applications.
* Migrated mainframe warehousing applications to web based interface using Cold Fusion server scripting, Javascript, T-SQL and HTML.
* Collaborated with other programmers to define program interfaces and data feeds between mainframe systems and client applications.
* Successfully trained staff and end users in both mainframe and PC based purchase order tracking systems.
* Performed on-going support and maintenance of purchase order tracking applications.
* Communicated with clients to define reporting needs and then delegate reporting requirements to programmers.
As a programmer/analyst creating shipment tracking and pricing applications:
* Worked with Cold Fusion contractor and SQL DBA's to create shipment tracking application using Cold Fusion scripts, T-SQL sprocs and HTML.
* Created SQL DTS Packages to import shipment data from a remote Sybase databases to a local SQL Server databases.
* Wrote advanced SQL Stored Procedures to upload customer shipping data at regular intervals.
* Designed and implemented freight management and accounting reports for senior management.
* Developed and maintained applications to create EDI 214 shipment status messages. Worked with EDI Trading Partners and VAN's to establish EDI links. Monitored status of outbound EDI messages and resolved transmission and translation errors.
Education
University of Washington, Seattle, WA
Bachelor of Arts in Business Administration
Information Systems Concentration
SQL Server 2008 Business Intelligence Certification Training
Cascadia Community College, Bothell, WA
* Learned relational database design concepts including normalization, indexing structures and referential integrity.
* Extensive hands-on training creating Microsoft T-SQL scripts, batches and stored procedures.
* SSIS Package development, debugging and deployment techniques.
* Creating, building and deploying OLAP cubes.
* Creating KPI's, cube partitioning and storage.
* Exercises building MDX script expressions and querying OLAP cubes.
* Covered Report Server Architecture and how to design, create and render SSRS reports.
Contact this candidate