We provide IT Staff Augmentation Services!

Sql Developer - Consultant Resume

Bellevue, WA

SUMMARY:

IT professional with 10+ years experience in database development, report development and analytics. Experience with Teradata, SQL Server, and Oracle databases. Extensive experience with Business Objects, Crystal Reports, and SAS building reports and data extracts.

CORE EXPERTISE:

  • Teradata Developer
  • SQL Server Developer
  • Business Objects Developer
  • SQL Developer

TECHNICAL SKILLS:

Software: Visual Studio 2008 - 2015, Business Objects (v5/XI), Confidential Office

Languages: SQL (Teradata), SQL (SQL Server), SQL Server Mgmt Studio, Crystal Reports (v10/v11), Publisher, SQL(Oracle), PowerShell (beginner), Teradata SQL Assistant, Microstrategy, COSMOS (beginner), C# (beginner)

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

SQL Developer - Consultant

Responsibilities:

  • ETL development using SSIS, Import/Export Wizard, and BCP utility.
  • Data transformation using SSIS, stored procedures, functions and views.
  • Load automation using SQL Agent. Maintenance and tuning of SQL Server tables, views, procedures, and queries to enhance efficiency of data import and extraction.
  • Creation of load audits and data quality checks to alert for troubleshooting.
  • Completed ad hoc reporting requests as assigned.

Confidential, Bellevue, WA

Developer III

Responsibilities:

  • Acted as backend development lead for SORT (Sales Operations Reporting Tool), working with web developers and analyst team to produce quality Retail and TPR reporting to an audience including store managers and C Level executives.
  • Acted as database owner responsible for Dedicated Care reporting tool, including all database architecture, development, maintenance, reporting, and Sharepoint maintenance. Took the tool from one group at a single call center to nationwide deployment.
  • Developer on high profile project to provide new reporting for executives including creation of a new database, processes, and reporting.
  • Support the Retail business by monitoring, maintenance, and development for the retail daily pulls to ensure data is correct and fits the business needs.
  • SME for all Teradata EDW related requests and activities for multiple departments.

Confidential, Seattle, WA

Senior Data Analyst - Consultant

Responsibilities:

  • Data loads, data sourcing and requirements gathering, development and maintenance of tables and views to support Marketing needs.
  • Ad hoc reporting as requested.

Confidential, Seattle, WA

Senior Software Development Engineer

Responsibilities:

  • ETL development and maintenance of tables and views in the Business Intelligence Teradata Warehouse.

Confidential, Bellevue, WA

Business Intelligence Software Developer

Responsibilities:

  • Acted as development lead for Marketing Segmentation project, coming in on time and under budget.
  • Member of development team for Retail Reporting project; updated scripts supporting Crystal Reports store management uses to track visits and sales.
  • Developed code fixes to correct data quality issues.
  • Streamlined access to data for technical and business customers by leading a team; analyzing required data; building a SQL Server repository, developing and maintaining DTS Packages and Perl scripts; creating automated Crystal reports and a web portal.

Confidential

Business Intelligence Systems Analyst

Responsibilities:

  • Research data issues logged into Remedy application, isolate issues, and document problem, possible solutions and test requirements; work with developers, testers, and application support to implement the solution.
  • Researched, documented, and led implementation of 50+ tickets per year.

Hire Now