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