Livecareer-Resume

Business Intelligence Developer Trainer Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica Claire
  • Montgomery Street, San Francisco, CA 94105
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Professional Summary

Highly qualified Business Intelligence Developer focused on translating complex mandates into actionable plans and working systems. Specializing in machine learning and statistical analysis. Ready to bring 8 years of related experience to a challenging new role.

Skills
  • Data Warehousing
  • DevOps Integration
  • Business Intelligence Analysis
  • Requirements gathering
  • Database Management
  • Algorithm implementation
  • Code reviews
  • Database programming
Work History
Business Intelligence Developer/Trainer, 05/2015 to Current
Aeroflow HealthcareArden, NC,
  • Provided SQL Data Warehouse architect and BI solution to clients in industry of pharmaceutical, dental care, manufacturing, and higher education, Directly communicate with business user to translate business requirement into technical plans either ETL process or SQL code.
  • Designed and created Data Warehouse dimension, fact, and bridge tables to support analytical users with balance of data loading efficiency and reporting efficiency.
  • In lead in Analytical Work Bench project to add more than 400 attributes into different layer of data warehouse from Student registration to assignment and final assessment, in the mean time minimize performance burden of data base extension.
  • Created staging, processing and QA environment , and managed the daily job for the data processing across these environments.
  • Used synonyms in the reporting store procedures to channel data into different tables and schemas.
  • Use Solar Wind to analyze more than 30 data warehouse stored procedure actual execution plan and speed up warehouse loading from 5 hours to 3.5 hours.
  • On call duty during night to quickly trouble shoot the overnight ETL packages to ensure Staging and data warehouse ETL finish before 6:30 AM.
  • Created SQL server store procedure to map person with various street address data by utilizing N-Gram algorithm.
  • Created cascading triggers and procedures to dynamically assign MS_Description to view attributes from the underlying dimensional and fact table attributes and DDL trigger to automatically report missing MS_Description.
  • Designed and created logging system to capture copy data statistics and SQL procedures with HTML script to send email notifications with abnormal delete/update in the daily ETL process.
  • Created and implemented SSIS ETL solution to run more than 100 procedures to load the data warehouse with precedence constrains dependencies.
  • Brought task factory Upsert, Delete, and Rowhash to the existing SSIS package to perform incremental load from file based sources, SalesForce, and Oracle DB to staging data base.
  • Designed and created Azure Data Factory pipelines to automate the process of duplicating more than 300 tables from Oracle data mart to Azure SQL Server.
  • Created dynamic SQL procedure and functions to automatically define primary keys of staging tables based on their configuration in Oracle source and convert the tables to standard temporal history fashion.
  • Created Azure Data Factory pipelines and procedures to automatically generate load/delete procedures and SQL table type for more than 300 staging tables.
  • Created Azure Data Factory pipelines to automatically identify able schema drifting, expand Oracle “AnyData” column and rebuild the target SQL table and related artifacts.
  • Designed and created Azure Data Factory pipeline to load data from Oracle environment to SQL with both incremental and full load fashion.
  • Implement deployment process of Azure data factory pipelines from DEV to QA and UAT and optimize more than 10 different triggers that are sharing same integration run time to run smoothly during the daily off work hours.
  • Created pipelines to capture on-going copy data activity error and row redirect data into Azure blob data lake and fetch data into the logging database.
  • Hands on experience of CI/CD deployment pipelines.
  • Utilized Azure mapping data flow to generate row hash on large table to support staging data incremental ETL.
  • Utilized Oracle pseudo key ROW_SCN to perform hourly incremental load within the data mart that has more than 300 tables.
  • Generate provider dashboard on Tableau for each analytical category such as paid amount trending, unique member, and services with specific procedure patterns.
  • Transported OLTP data marts to OLAP environments to support SSRS and Cognos report.
  • Worked closely with client services and analytical team to designed reports with interchanging features based on selection criteria or report detail display such as report layout, margins, color schemes, font selection, border style, padding and chart selection.
  • Modified existing more than 30 SSRS reports based on additional business requirement.
  • Optimized the entire SSRS reporting system for clients by tuning the procedure queries and build indexes in the Reporting system.
  • Document technical notes from ETL to data warehouse in OneNote and performed hands on training to the new developers.
  • Created multiple stored procedures imbedded within asp.net packages to support the company employee logging system.
SQL Developer, 02/2013 to 05/2015
United Way Of AmericaAlexandria, VA,
  • Lead of 7 SQL programmers on building up automated ad-hoc report generation for the client.
  • Worked closely with client management and analytical team to set up technical solution for the client's campaign deliverables.
  • Spearheaded QA process for data delivery and coordinated deployement to Production for these departments as well.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
  • Generated underlying data for SSRS reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
  • Extensively used Joins, union, partition, and pivot to simplify complex queries involving multiple tables.
  • In charge of building views in the database to organize the client’s wellness target metrics with unique ID and foreign Keys.
  • Generated daily, weekly and monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
  • Created Cubes and KPI dashboards to feed client analytical dash board Designed and implemented stylish report layouts and related MS SQL Server Reports and Dashboards using SSRS 2008.
  • Designed and implemented user log in and security in SQL server Wrote SQL procedure for generating standard, and complex parameterized reports in SSRS 2008.
  • Performed dimensional Modeling and created data warehouse using Kimball and hybrid methodologies.
Database Manager, 12/2010 to 02/2013
HAVER ANALYTICSCity, STATE,
  • Analyzed macroeconomic and financial data to enhance investment decision-making of clients in financial services industry.
  • Monitored and analyze key data releases, including unemployment, GDP, inflation and monetary policy actions in various developed and emerging market economies to determine value developments to databases.
  • Perform seasonal adjustments and statistical analysis on time series economic data to ensure integrity and usefulness of data in financial decision making.
  • Developed customized economic data series including exchange rate baskets, inflation-adjusted data and interpolated government bond yields for specified maturities to address client-specific needs.
  • Provided clients with technical and economic consultation by phone and email.
  • Worked with account managers and representatives to address training on company's proprietary analytical tools.
Education
Bachelor Degree: Information System, Expected in
Nanjing University of Science And Technology - Nanjing, China,
GPA:
Master Degree: Computational Finance, Expected in
New York University - New York, NY,
GPA:

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Disclaimer
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

79Average

Resume Strength

  • Formatting
  • Length
  • Personalization
  • Target Job

Resume Overview

School Attended
  • Nanjing University of Science And Technology
  • New York University
Job Titles Held:
  • Business Intelligence Developer/Trainer
  • SQL Developer
  • Database Manager
Degrees
  • Bachelor Degree
  • Master Degree

Similar Resume

View All
Business intelligence developer
Sr. Business Intelligence Developer