We provide IT Staff Augmentation Services!

Database Developer Resume

Alexandria, VA

SUMMARY:

  • Innovative, team orientated professional with experience in all aspects of database development, data warehousing, data modeling, ETL, Reporting, Master Data Management and Data Analytics
  • Experience developing and delivering high quality solutions using SQL Server 2005, 2008 R2, 2012, 2014, 2016
  • T - SQL
  • Data Warehousing experience using Microsoft BI tools (SSIS, SSRS, SSAS, OLAP Cubes)
  • Database design (OLTP and Data Warehousing)
  • Data Modeling
  • Data Analytics
  • Agile Development
  • Dashboard Development
  • Ability to communicate with and translate for all levels of users
  • Plan and manage projects and deliver them on time

TECHNICAL SKILLS:

  • SQL Programming
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Analytic Services (SSAS)/OLAP
  • Database Design /ERWIN, Visio
  • Data Modeling / ERWIN (Logical and Physical)
  • Performance Tuning
  • Power BI
  • C#
  • HTML
  • QlikView
  • XML
  • Python

EXPERIENCE:

Confidential, Alexandria, VA

Database Developer

Responsibilities:

  • Worked on a CRM Dynamics 365 migration: determined mappings, creating custom views and stored procedures.
  • Worked on CRM Dynamics 365 cloud data by using SSIS and the Kingsway Soft connector.
  • Created SSRS reports: Standard and dashboard.
  • Wrote complex T-SQL code (CTE, Apply, Pivot, XML) to manipulate report and ETL data.
  • Created SSIS packages in VS 2013 and VS 2015.
  • Modeled and designed a SQL Server KPI database to track user meeting attendance.
  • Created a SQL Server database which contained medical abstract XML data feeds.
  • Obtained and worked with Sales Force data.

Confidential, San Francisco, CA

Consultant/BI Developer

Responsibilities:

  • Worked with analysts to determine how to obtain the data.
  • Determined if any data transformations were necessary using their inhouse meta data system.
  • Determined the setup requirements for the in house meta data system.
  • Wrote T-SQL statements to manipulate data as required by the meta data system.
  • Create SQL Server 2014 SSIS packages using VS 2013.
  • Designed a database to contain transaction trade data.
  • Wrote a C# program in VS 2015 to read the transaction data from a PDF; used output streams to transfer data into the database.
  • Tested and debugged deployed SSIS projects/packages before release to QA.

Confidential, McLean, VA

Consultant/Database Developer

Responsibilities:

  • Documented and analyzed a manual health care process; Created process flow diagrams; Code diagram; technical process
  • Met with SME’s to understand the process and collect process improvement recommendations.
  • Obtained necessary data examples. (files, files format requirements, SQLite Code and data structure)
  • Created a new proposed process design; created documentation and presentation documents
  • Met with stakeholders to present the proposed design; Integrated suggestions into the design; Met with stakeholders for approval
  • Created documentation for the new process flow diagrams; Code diagram; technical process.
  • Designed conversion plan to replace SQLite database/code with SQL Server 2014 databases/SISS.

Confidential, Boise, ID

Consultant/Business Intelligence

Responsibilities:

  • Tested and modified the setup procedures for the contractors.
  • Acted as the primary liaison for technical issues between the contractors and the client, Micron.
  • Took on the role of Lead QA Tester with the Micron programmer staff, including debugging of C# code, for the template.
  • Determined from documentation how to input setup values into the template; data sources, lookup sources
  • Manipulate the data as specified; created transformations, added conditional logic; data conversions
  • Acted as the SSIS Technical Lead for the contractors.
  • Adhered to Agile methods; met weekly cycle goals.

Confidential, Monterey, CA

Senior Database Developer

Responsibilities:

  • Refactored and managed a large complex code base in SQL Server r2 for a major e-commerce system.
  • Managed all aspects of data activity on VLDB databases including: data object generation, warehouse processing and reporting.
  • Created a T-SQL rules engine for data validation for easier ETL loading.
  • Optimized and redesigned SEO (Search Engine Optimization) T-SQL ETL processes; some process decreased processing time by 300%.
  • Worked on converting and refactoring T-SQL ETL processes to SQL Server 2008r2 SSIS packages and updating existing SQL Server 2005 SSIS packages to SQL Server 2008r2.
  • Refactored SEM (Search Engine Marketing) financial reporting system: Standardized data element definitions, built consensus on formulas and systems of record. Integrated and managed the conversion of existing SSIS and SSRS projects to SVN (source control system).
  • Created a reporting system on a VLDB which received at least 1.5 million records a day; designed a data mart; wrote SSIS packages and T-SQL procedures to populate the data mart; created a SSRS reporting system.
  • Wrote ASP.Net interface for SSRS reports.
  • Created complex SSRS reports using OLAP cubes as the data source
  • Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and provide optimal solutions.
  • Served as a key member of the business analytics team which was responsible for the ROI of a $20M/ year internet advertising budget.
  • Created C# scripts for ETL packages to apply business logic and complicated processes.
  • Aided in the new enterprise data warehouse design.

Confidential, Mountain View, CA

Principal Developer/ETL Developer Lead

Responsibilities:

  • Created the SQL Server 2012 SSIS development environment for the online sales analytics group.
  • Set standards for SSIS development.
  • Planned and calculated manpower resource allocation for a new comprehensive data warehouse ETL project; Designed the ETL processes which included several diverse sources and created the SSIS template to be used in the packages.
  • Created a standard template for use by the other SSIS developers.
  • Worked with business units to identify their needs and developed solutions using the AGILE development method; participated in weekly sprints and daily scrum meetings with SMES and business owners.
  • Created an in house library of utilities using C# and T-SQL for use in SSIS packages.
  • Created XML process to load updated data into a kiosk every 15 minutes which consisted of loading XML data into tables; Queried tables and creating updated XML for use in a metrics kiosk; Updatedw XML was created every 15 minutes 24/7.
  • Worked with analysts to obtain data for the reporting/analysis needs.

Confidential, San Francisco, CA

Consultant/Database Developer

Responsibilities:

  • Planned, designed, and implemented complex database objects, such as partitioned tables, stored procedures, views and functions in SQL Server 2008
  • Developed several SQL Server 2008 SSIS packages that performed complicated extractions from a corporate Oracle data warehouse.
  • Wrote T-SQL procedures which inserted data into the partitioned tables in the SQL Server 2008 data warehouse which decreased loading time by 40%.
  • Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
  • Aided in the implementation and design of an Entity Framework for a C# Analytic application.
  • Used the sync framework in the data tier to access the database.
  • Worked with analysts to obtain data for the reporting/analysis needs.

Confidential, San Francisco, CA

Senior Application Software Engineer

Responsibilities:

  • Created migration modules for a mainframe to SQL Server 2005 conversion.
  • Performed quality assurance and testing of SQL server environment.
  • Designed and implemented a reconciliation module for the migration.
  • Identified data issues and provided recommendations for resolutions to ensure optimal performance

Confidential, Rancho Cordova, CA

Database Manager

Responsibilities:

  • Managed the database operations for a midsized financial services corporation.
  • Managed the development staff and allocated project resources.
  • Developed and maintained financial compliance reporting modules (including securization reporting) in SQL Server 2005 T-SQL and SSRS.
  • Worked with users at all levels throughout the organization to obtain the design requirements, determine analytics and create effective solutions.
  • Architected several databases using the UML design process; both OLTP and Data Warehouses databases.
  • Created logical and physical schemas with ERWIN and Visio.
  • Worked with application developers to design all types of data objects such as stored procedures, triggers and functions.
  • Maintained large application code base.
  • Created project plans and timelines and ensured that the due dates were met.
  • Ensured best practices were applied so that the integrity of data was maintained; maintained meta data management.
  • Worked with analysts to obtain data for the reporting/analysis needs.
  • As Database Architect, I created the logical and physical designs for a REO/Mortgage Default Tracking System using the UML methodology.
  • Worked with the application developers and created the data objects such as stored procedures, views, triggers and functions for the Default application.
  • Managed the backend development and integration.
  • Managed resource allocation; staffing and materials
  • Database coding; database sizing
  • Front end code integration
  • Database hardware requirements

Hire Now