Database Developer Resume Everett, WA - Hire IT People

SUMMARY:

Experienced BI Developer with skill sets and proficiencies in the areas of SQL Server, Business Intelligence, Data warehousing, Reporting Services, Integration Services, and Analysis Services; has a degree in Business Administration with Finance concentration and knowledge in the areas of T - SQL, MDX DAX, PowerPivot and Power BI; Demonstrates critical thinking, problem solving / troubleshooting / analytical & research skills
Utilized Microsoft BI tools and components to support the Enterprise data warehouse and end-users - Reporting services: Report design, deployment and administration in SQL Server 2008 R2 / 2012 & Integration services: SSIS package design and deployment in SQL Server 2008 R2); Database Developer & Report Designer - implemented code changes in database, wrote SQL queries and designed reports to meet business objectives - monitored and executed SQL Agent jobs; developed and migrated reports created in Actuate to SSRS; experienced in gathering user requirements, data modeling & query development in SQL Server / Oracle and report development in SSRS

TECHNICAL SKILLS:

RDBMS: SQL Server 2008 R2 / 2012 / 2014, Database Backup & Restore using T-SQL script & SSMS; SQL Agent, Views, Stored Procedures, Cursor

Cube design and deployment: SSAS

OLAP, Reporting & ETL Tool: SSAS, SSRS, SSIS

SSIS data extraction components: FTP/Web services/XML Task, Lookup, Conditional split

Database programming T: SQL

Query optimization: SQL Server Database Tuning Advisor & Materialized Views

Data Visualization / Dashboards: Power BI, SSRS, Report Builder, Excel Pivot Table

. NET C#, Asp.Net, Ado.Net, Html 5,Css, JavaScript

Data Modeling SQL Server & Oracle SQL Developer

Data warehousing / BI Solution: Microsoft Visual Studio 2012 / 2013 & SQL Server 2012, 2014

Workflow development, communication & collaboration Bitbucket, Sourcetree & Jira, SharePoint, Outlook, & Skype

PROFESSIONAL EXPERIENCE:

Confidential, Everett, WA

Database Developer

Analyzed requirements and addressed the reporting needs for the Finance, Human Resources, and Public Works departments - created new reports and migrated existing reports from MS Access and Actuate to SSRS (tested, debugged and documented the migration workflow)
Acted as a SQL & Report Developer - Developed SQL dataset and extracted data from Oracle data source to build SSRS reports
Migrated 25+ Actuate reports and Information objects to SSRS that included user-friendly features such as drop-downs / cascading parameters, sub-reports and repeating row-headers; utilized VB.NET expression language for report formatting
Scheduled cache refresh plans and subscriptions and optimized performance and timely delivery

Confidential

BI Developer

Created a SQL reporting table for the Finance department that represented a weekly gross revenue budget for each product and B2B customer based on annualized source data for FY 2017 in an Excel spreadsheet - utilized T-SQL cursor and SSIS to meet this requirement
Scheduled SSRS cache refresh plan and subscriptions for the Finance and Sales teams
Examined and fixed SQL Agent job failures
Debugged and re-deployed SSIS packages to Integration services server in a SQL Server 2008 R2 environment
Executed SSIS packages accomplish data loads from Excel /csv files to SQL Server
Resolved 30+ Help Desk tickets related to Finance / Sales department reporting issues, SQL Agent jobs and SSIS packages

Confidential, Redmond, WA

Associate

Gates Project - Created a stored procedure that copies data from source to destination that was deployed in production server as a SQL Agent job step
Tested for data consistencies across the Staging, Dbo and Star schema tables using SQL
Performed UAT testing (meta data consistency between upstream Microsoft UAT & Beyondsoft UAT servers using SQL); tested, executed and deployed SSIS packages successfully to Development & Production servers; tested and debugged SQL Agent jobs
Microsoft Learning Project (MSL) - Utilized data modeling and SQL to examine Entity relationships
Contributed toward migrating enterprise database from (legacy Feedstore to DataMall); ran API queries to pull tables from cloud publisher to client subscriber
Performed data consistency checks after code changes in SQL Server and client side SharePoint Excel pivot tables; utilized VLOOKUP and CountIF functions in Excel
Performed updates on Windows 2012 server and VM’s
Contributed to workflow development using Bitbucket, Sourcetree & Jira to create and track progress of tasks and issues
Documented code changes on Bitbucket and SQL Server and also contributed to internal online knowledgebase on Confluence