Resume

Sign in

Data Developer

Location:
Acton, California, 93510, United States
Posted:
August 28, 2018

Contact this candidate

Resume:

Lee Granger

EDUCATION

BA in Business Administration, University of California: Irvine, Irvine, CA

AA in Business Administration Santa Monica College

Microsoft Business Intelligence Master’s Program: Setfocus

EXPERIENCE

Gorfaine & Swhartz– Burbank, CA 01//2018– Current

Lead Business Intelligence Developer/ Data Analysis

Developed Schema Design and Backend Data warehouse

Created SSIS packages for ETL process

Partner with business analysts to define, develop, and deliver automated pivot tables and reports.

Created data cleansing, reconciliation and tracking process using SSIS, SQL and VBA

Design/Developed Front-end/Back-end Royalties Tracking database

Design/Developed Front-end/Back-end Audit Tracking database

Establish data source assessment, data mapping, and BI visualization tools

Designed Data Security application

Daily-Data Modeling to produce data source

Dex-Yp.com – Glendale, CA 04/2017– 01/2018

Business Intelligence/Application Developer Data Analysis

Automating manual components using VBA for vertical performance analyses

SQL database design and development.

Partner with business analysts to define, develop, and deliver business reports

Created data warehouse to processes and improve data integrity

Define BI technical architecture and strategy (to map Operations/Marketing/& ERP data holistically)

Establish data source assessment, data mapping, and BI visualization tools

Create complex report sources views and stored procedures

Customized Excel-VBA Financial Analytic Automated Spreadsheet Solutions, including PowerPivot Reports and Dashboards;

Support custom data pulls for metrics using SSIS for data ingestion, manipulation and data warehouse storage.

Creating databases, BI solutions and creating financial applications

Disney Interactive SMCI – Glendale, CA 11/2015 – 03/2017

Business Application Developer Programmer

Duties include SQL database design and development which included designing tables, storing procedures, views and functions.

Create complex queries as sources of reports like: Running Total, Forecast, Current/Previous

Creating Access financial DB front-end application to interface with SQl databases.

Customized Excel-VBA Financial Analytic Automated Spreadsheet Solutions, including PowerPivot Reports and Dashboards;

Create ETL ingest solutions using SSIS for data ingestion, manipulation and data warehouse storage.

Creating databases, BI solutions and creating financial applications

Black Knight Financial Services Data & Analytics – Glendale, CA 10/2012 – 11/2015

Analytics Analyst Application Developer

Managed Data Operation team of 15 in direction of the Data import and warehousing of tens of millions of records daily; synchronizing storage across 12 servers, as well creating and fulfilling customer analytical report request.

Personal duties included:(T-SQL programming, VB.Net-Window Forms, VBA-Access, VBA-Excel, SSIS, SSAS, SSRS, SQL database development)

Developed data mining application for extraction and visualization of Investments by Real Estate Investors

Partner with business analysts to define, develop, and deliver Analytical reports

Created exploratory data analysis (EDA), and confirmatory data analysis (CDA)

PennyMac Loan Services LLC – Moorpark, CA 08/2011 – 09/2012

Analytics Analyst Application Developer

Created Dynamic Excel Reporting tools which utilizes SQL server backend.

Created Excel-VBA apps to auto retrieve, upload and format data delivered to FTP servers.

Created VBA Excel data mapping application with connectivity to SQL DB to access stored procedures.

Created Access-VBA application to Audit forms (data updates) in any Access application

Created Access project to fabricate data based on file names.

Created VBA-Access code modules to connect using both DAO and ADO

Created custom application w/pass through queries to SQL to returning dynamic list items

Created De-Dup VBA Office Automation application, de-duping and preparing tables in Excel and auto uploading to Access database.

Created VBA Regex find and replace module that imports stored procedures for SQL, finds and changes hardcoded connections and IP address.

Created SSIS packages for importing, converting, exporting, and aggregating millions of records.

Created Company Dictionary using SQL extended properties and server audit sql procedures

Instituted Master Data Management using MS Master Data Services

Created VBA Excel parsing application with connectivity to SQL DB.

Used Visual Studio Tools to create automated Office applications; combining spreadsheet pivot and database functionality.

Created Access Project interfaces for SQL databases.

Created complex SQL to produce Fact and Dimension tables for Data Warehouse.

Developed SSIS ETL packages to Cleans, map and upload data to SQL server databases.

Developed SSAS Cubes used as source data for Excel pivot tables and SSRS reports.

Bank of America – Agoura Hills, CA 02/2010 – 08/2011

Software Developer

Designed and developed queries, stored procedures, functions and analytical processes as a foundation for data marts used for financial reporting

Built custom ETL application to cleans, transpose and validate data. •Created SSAS analysis cubes use as data source for summarized reports.

MarketCast – Los Angeles, CA 06/2009 – 01/2010

DB Developer

Built custom ETL application to to ingest nationwide survey data.

The SSIS solution cleans, transpose and validate data.

Created an Access project Front-end interface that included a custom-built SQL query writer to transform user choices into SQL statements.

The application was built using DNS-less connection with custom class modules that connects to SQL databases.

Built custom Excel Add-in that converts foreign language documents and HTML code into a readable survey(s).

Built custom Excel Add-in that upzips zip files, scans local drive, creates staging folders, and updates data to SQL dbs.

FOX – Los Angeles, CA 10/2007 – 06/2009

Software Developer

Created VBA application to Extract, Transform and Load data into a customized Excel interface.

The application is used for drill-down reporting of Nielsen rating statistics.

The solution included an Excel addin to interface with a .Net application(Cognos) that automatically recognizes target file format, OnOpen, and executes based on given parameters.

Responsibilities included: o Creating Excel Reports that automatically format, based on type, using VBA

Creating VLookups & HLookups dynamic formulas

Creating Front-end, Back-End Access Databases

Creating Union, Cross-tab and Select queries

Created Automated shared application between Access, Excel and Outlook.

Created data cleansing application using Excel with auto upload to Access

Created dynamic Excel pivot tables as a source for Access reports

Created Excel Add-ins

Created 5 different types of User interfaces based on login

Voce – Beverly Hills, CA 01/2006 – 09/2007

Sr. Project Manager

Managed all projects for 3 different segments of business initiatives: Business Development, IT development, and Application development.



Contact this candidate