Victoria

732-***-****

addo08@r.postjobfree.com

SUMMARY

* ***** ** ********** ** SQL and SQL-BI suite comprising of SSIS/ SSAS/ SSRS along with professional database design, development, and maintenance of SQL Server 2016/2014/2012/2008r2/2008, Teradata Server database, MySQL Server, and Oracle SQL Server Database.

Diverse background in visualizing BI tools, including Microsoft Power BI and Tableau.

Proficiency in using SQL Server to create complex T-SQL statements, such as Store Procedures, Triggers, Tables, User Defined Functions, Views, SQL Joins, and performance-based query writing.

Steady knowledge in normalizing and de-normalizing tables to maintain referential integrity by using primary and foreign keys.

Solid experience in using TOAD for Oracle to create and manage database items, such as tables, views, functions, stored procedures, indexes, and partition of tables by P/L SQL.

Experience in SQL query optimization techniques, debugging SQL commands.

Expertise in database management techniques including backup/restore, import/export and script generation.

Experienced in installing and configuring SQL Server Database and Oracle Database.

Experienced in System Development Life Cycle (SDLC) methods like Agile and Waterfall.

Thorough understanding and experience in Data Warehouse and Data Mart design, Star Schema, Snowflake Schema concepts and principles.

Expertise in using SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality and creating cubes.

Solid experience in creating SSAS measures and calculated columns with MDX.

Proven ability in utilizing ETL Tools including SQL Server Integration Services (SSIS), SAP BODS, and Talend to transfer data through different systems, such as between different database servers (e.g., Teradata to MySQL), or using heterogeneous databases like Flat Files, Excel, and SQL Server to load data into Data warehouse.

Daily proficient experience in creating complex ETL packages using functions such as Try/Catch, assigning dynamic parameter values, Email notifications, Foreach loops, and etc.

Expertise in creating and scheduling complex SSIS packages for transferring data from multiple sources into SQL Server, Access, and Excel by using SSIS and DTS of SQL Server

Experience in developing and deploying reports using MS SQL Server Reporting Services (SSRS)

Proficiency in developing and deploying various reports like drill down, drill through, Sub reports, and Parameterized reports using SSRS.

Experience in creating ad-hoc reports by using Excel, SharePoint, and Report Builder in SSRS

2012/2008r2/2008/2005.

Experts on delivering efficient and direct to point visualizing business solution through Microsoft Power BI. Give end user dynamic powers over customizing solutions to meet their business needs.

Efficiently load, combine, refine, and clean data from various sources through Power Query. Created relationships, measures, calculated columns, filters, charts with DAX in PowerPivot. Delivered user friendly and informative business intelligent solutions.

Experience on configuring SharePoint farm, managing team site, and creating workflow.

Solid experience working with Tableau to meet clients’ requirements, including creating visuals, building dashboards, and customizing reports.

Proficiency in using Tableau functions including data blending, actions, and parameters to design complex dashboards to give clients’ full understanding of all aspects of information.

In-depth knowledge of .rdl files and converting Stored Procedures and User-defined Functions to new data sets for creating reports in Tableau. Experience with implementing T-SQL and CTE to test Tableau data sets.

Experienced in efficiently working with cross-functional team as a liaison to connect technique team and functional team. Highly skilled working as an individual as well as in a team.

EXPERIENCE

Live Nation NA Los Angeles, CA

Database Engineer Aug 2017 - Current

Design, maintain, and support the main database that hosts more than 35 million customers and over 600 million transactional records. Support marketing team to implement events newsletter, email campaigns, and promo communication.

Build and deploy Business Intelligence (BI) packages and automations among different systems, which eliminates bottleneck from the system and reduces data transferring time by 95%.

In charge of design, develop, deploy, and update all of the 37 US Touring North American marketing ETL packages.

Create and upgrade all BODS jobs compiling to the GDPR and the new CCPA rules that protects customers’ personal information while also efficiently transfer data among systems, such as Teradata, MySQL, SSMS and Salesforce.com.

Lead the one-year long project of building up the Email Report, which is viewed by top management for finance and operation purpose. Over 2,000 lines of SQL queries, 16 tables and views, 4 stored procedures, and 2 automation were developed and run to calculate statistical and analytical columns, such as total revenue, that feed into Tableau reports.

Create and maintain Salesforce Data Extensions and Audience Builders which feed for marketing campaigns such as Welcome Email, On Sale Reminder, Post Show High, which reach to over 20,000 customers weekly.

Troubleshoot and debug on data quality on database items and live reports to ensure customers’ preferences are being honored.

Initialize and vocalize on good documentation in the Development Team. Create Confluence pages for each task and project which help to efficiently communicate about data type and format requirements with other teams (seeing at least 50% time cut on data requirement), and also save time for later reference.

Collaborate and communicate with other teams in the organizations, and third-party venders from Salesforce, Blueshift, and Databricks.

Environment: MS SQL Server, Teradata Server, MySQL Server, SSMS, MySQL, T-SQL, SAP BODS, Talend, Salesforce Marketing Cloud, AWS, Excel, JIRA, Asana, Rundeck, Confluence

LAUSD Los Angeles, CA

Database Developer Aug 2016 – Jul 2017

Develop and maintain database that supports 732,800 students from all LA county’s public school with T-SQL and PL SQL in different databases.

Strong and practical SQL skills (T-SQL and P/L SQL). Efficient on writing advanced SQL enhancement and clean-up scripts for 300+ lines which address multiple tables with at least 1M rows within tight time span (avg. 2 weeks). Improve scripts performance by using Execution Plan and SQL Profiler.

Daily hands-on experience on Microsoft Business Intelligence tools, including SSIS and SSRS, implementing with Visual Studio and TFS. Create Logs for each step and each run of SSIS packages, apply vary tasks including Data Flow Task, Containers, Email sending, etc., data transformation tasks such as Data Conversion, Look Up, Conditional Split, analyze and diagnose on package running performance, deploy packages under Package Deployed Model, and schedule SQL Server Agent Jobs on both Development Server and Production Server.

Design and deploy live reports (SSRS and Excel) and dashboards (PowerBI and Tableau) that support senior management on budget control. Create SSRS reports such as drill-down, drill- through, parameterized, and linked reports.

Initial/ upgrade existing Loading packages (from SQL Server to Oracle Server) with Attunity for Oracle. This upgrade largely saves time and CPU space from 300M rows/30 hours with parallel DFTs to loading the same amount of data with only 1 DFT in 2 and half hours, in other words, the upgrade saves CPU space by 99% and loading time by 91.6%. Map configuration files in onfiguration database to ensure smoothly upgradation.

Perform debugging and troubleshooting for TFS Bugs (Tasks include scripts or interfaces). Have researched on and solved the Data Conversion Task failure which involves 2 interfaces loading half million rows from SQL Server to Oracle Server daily.

Productively work in both Waterfall and Agile production methodologies. Self-schedule work plan for multiple tasks to meet tight development cycle (2 weeks from Initial Meeting to Feature Freeze date) and always with elasticity for business owners’ side requirement change and/or ad hoc requirements. Always deliver applications on time.

Hands-on experience on documentation creation. Create and review tech specs, developer documents, and impact analysis reports.

Efficiently work/ interact with multiple teams in a cross functional environment with excellent communication skills. To deliver production exactly meeting business users’ needs, work closely with end users, BA team, QA team, and other members from my own team.

Environment: MS SQL Server, Oracle Server, SSMS, Toad for Oracle, Attunity for Oracle, T-SQL, P/L SQL, SSIS, SSRS, Visual Studio, TFS, MDX, DAX, Excel

American Home Patient Nashville TN

Business Intelligence Developer Jan 2015 – Aug 2016

Member of the team that overseeing the merge between American Home Patient and LeanCare. Create financial and operational reports to support higher management’s decision making during the merge. Design Tableau and PowerBI dashboards and the live database behind. Deploy SharePoint dashboards, assigned authentications, and managed accesses.

Create and maintain Oracle database objects such as tables, views, indexes, and stored procedures with P/L SQL on TOAD 11. Modify, organize, and reload legacy data to new tables. Also work on partitioning tables to improve database objects’ efficiency.

Develop multidimensional and advanced SSAS models with multiple cubes and schemas. Carefully load fact tables to keep redundancy minimal. Create measures and calculation columns with complex MDX queries. Design SSAS model relationships among tables to build dimensions. Deploy and schedule running, auto-refresh of SSAS projects. Load and check-in SSAS projects to SourceControl to avoid concurrency, maximized team-work effort, and synchronized local and server’s latest version.

Apply business intelligent solution by using Microsoft Power BI. Build profound Microsoft PowerPivot models with varied data sources, such as Oracle Database, MS SQL Server, Access, and Excel files. Transform and automate data sources by Power Query. Apply activities, such as integrate, duplicate, de-duplicate, add primary and foreign keys, and design index to merge and sharp data sources for further analysis.

Create PowerPivot measures and calculate columns with advance DAX queries. Set up filters to give end users dynamic power over information. Design visual and graphic solutions, providing efficient and direct to point information helps end users to make critical operational decisions. Such solutions include PowerPivot Dashboard with drill down categories, Power Chart linked to detailed information, and intelligent timeline empowers end users to see both full picture and details of the business. Deploy Dashboards to SharePoint, assign authentication of the items, and granted access to selected groups of users.

Create SSRS Reports, such as drilled-down, drilled-through, and parameterized reports, with P/L Query to pull data from Oracle Database. Deploy SSRS reports to Report Server. Added reporting items to database through TOAD. Synchronize Report Center with the deployed SSRS reports. Granted access groups to reports.

Work closely with end users with little technical background. Gather them to understand and create data model and benchmarked results with industry average.

Environment: MS SQL Server, Oracle server, Toad for Oracle, SSIS, SSRS, SSAS, PowerBI, Tableau, SharePoint, Source Control, MDX, DAX, Excel

Capacity, LLC North Brunswick, NJ

SQL Server/Tableau Developer Sep 2013 – Dec 2014

Create and maintain database for the company’s daily operation. Use SSIS to extract data of orders, freight schedule, and account payable every day from various sources such as Flat File, Excel, and other Relational Databases, and inserted them into SQL server database.

Develop, modify, and upgrade Stored Procedures based on changes made in operation to maintain data processing quickly and efficiently.

Create views for the most retrieved data sets to make sure every team member has easy access to updated key data sets.

Monitor SQL server database and assisted solving SQL server related issues.

Schedule ETL (Extract, Transform, and Load) process to populate Data Marts.

Summarize, convert, and distribute data based on data values by using SSIS.

Use Event Handler, and Custom Logging to created Logging, Error Handling for SSIS Packages.

Create Gauge Report, Sub-Reports, Drilldown-Reports, Summary Reports, Linked Reports, and Parameterized Reports in SSRS and Tableau for different departments.

Extract data from Flat File, Excel, and Relational Databased to generate reports in Tableau.

Create Tableau worksheets of quarterly financial and operational reports and implemented the business logic by customization. Compile worksheets into dashboards to give clients a clear understanding of

quarterly performance.

Highly involve in configuring Service on Server, member permission, and Configure SharePoint farms, create team sites and monitored workflow. Also configure documents properties and set alerts on files based on requirements.

Embed Tableau views into SharePoint.

Environment: MS SQL Server, T-SQL, SSIS, SSRS, SharePoint, Tableau, Excel, Access

EDUCATION

University of Maryland College Park, MD

M.S. June 2014

Ohio State University Columbus, OH

B.S. May 2013

ADDITIONAL

Language: English (Fluent), Chinese (Fluent), Spanish (Limited Working Proficiency)

Certification: MCSA SQL Server Certification

Skills: SQL, T-SQL, MySQL, SQL Server Management Studio (SSMS), Teradata, Toad for Oracle, SAP Data Service, ETL, BODS, SSIS, SSRS, SSAS, PowerBI, AWS, Salesforce Marketing Cloud, Tableau, Live Report, Dashboard, Asana, JIRA

Contact this candidate