We provide IT Staff Augmentation Services!

Database Developer Resume

Everett, WA

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

Hire Now