SUMMARY:

An analytical, certified, self - motivated IT Professional (Sr. BI Architect, BI Architecture Manager, Sr. Data Warehouse Engineer, Lead BI Developer) looking for a challenging job in Enterprise BI Development. Over 18 + years solid experience in Software Database Design and Development which covers BI, DM, ETL/ELT, EDW, MPP, Big Data, OLTP, OLAP systems, start-up company dream, enterprise wide application, legacy system migration, finance, accounting, sales and marketing, express ordering system, payment gateway industry, operational log, CRM, telecom industry, digital web distribution, HR, Merchandising, Call Center, Retail POS system, Finance BI, Retail BI, HR BI. Performance tuning, production support, and trouble shooting.

TECHNICAL SKILLS:

ETL/ELT Development: SQL, BCP, Bulk Insert, Dynamic SQL Metadata, SSIS, Multi-processing ETL/ELT

Dimensional Data Modeling: Star, Snowflake, SCD. OLAP Cube development. Multi-dimensional and Tabular Cube Development with dynamic row level security

Report & Data Analytics: MS Excel Pivot table, SSAS, SSRS

Database design and development: SQL, Stored Procedures, function, views, triggers.

Relational Data Modeling: Normalization theory.

DBA: Backup/restore, Replication, Performance Tuning, Query Optimization, Index tuning, Profiler and Trace, Log shipping, Agent jobs, Trouble-shooting deadlocks, PowerShell.

Existing system database code migration: (SQL2000-2005), (SQL 2005-2008), (SQL2008-2012), (SQL2014-2016)

Legacy system ETL migration: SQL2000 DTS/Data Stage to SQL/in-house ELT Netezza appliance solution

Oracle Business Intelligence solution: Oracle EBS to OBIEE, ODI, Informatica, OBIEE dashboard reporting.

Design Tools and Source Control: Erwin, Visio, Visual Studio, TFS, Git, and Perforce

Platforms: Windows Server, Linux, Confidential AzureTraining Courses Completion

Languages: Visual Basic, COM, C#.NET, Java, VBA/ExcelObject-Oriented Modeling using UMLBasic working knowledge of .NET Framework, SOAP, RESTful API, HTTP Protocol, Web Services, SOA

WORK EXPERIENCE:

SQL BI Developer and Team Lead

Confidential, Redmond, WA

Responsibilities:

• BI development and maintenance by utilizing technology on Big Data, COSMOS, SCOPE, C#, SQL, OLAP Cube, Cloud, and On-Premise stack.
• Dev Team Technical PM. MS Sales Weekly and Monthly Reconcile Reporting PM.

Sr. BI Architect

Confidential, Bellevue, WA

Responsibilities:

• As a Confidential consultant at Scorecard Systems & BI Team for Consumer and Devices Sales, I have fun to work with large technology group and business domain leader/subject expert to deliver Confidential Retail BI Solution for Confidential Product (Xbox, Surface, Office, Windows, and Accessories)
• Designed and implemented row level OLAP cube security model to compliant with Confidential all MS Sales users and Mercury users credential.
• Launched OEM BI cube (Tabular) and BREMA BI cube (Tabular) w MS Sales OEM row level dynamic security mask on organization related dimension attributes value in 8/2017.
• This is possible the first creature within Confidential on OLAP security.Launched One cube (Multi-dimensional) w Profit Loss(Mars) and MS Sales composite row level security on different geography view.
• Innovated the 3 keys binding bridge out of box solution to resolve security dynamical driven on different measure groups associated with user, permission type, and dimension. It was an innovation back to 12/2014 which solid the BI data platform application compliant with Confidential security policy and continued to grow the team to leverage 20+ source on boarding with stability on HBI (high business impact) data.
• Completed 250+ BI data platform design and development Sprint tasks to deliver BI solution end to end from source system data scrub, to stage, to warehouse, to data mart, and to OLAP cubes.
• Initial monthly business update and quarterly business update close cube automation process.
• Provided data platform team members guidance and solution on urgent production issues and critical trouble-shooting. Led offshore developers for BI development and meeting.
• Main developer for BI data platform FY16 and FY17 fiscal year rollover.
• Set up Power BI gateway and confirmed reporting stability with security compliance.
• Design an enterprise data integration hub for Channel Marketing process to leverage commercial data.
• Agile BI Profit and Loss integration to One Cube. ETL and cube development, row level security model integration.

Business Intelligence Architecture Manager

Confidential, Bellevue, WA

Responsibilities:

• Worked with C-level, VP, directors, and finance team for BI release, requirement gathering, POC, meeting, user acceptance test, and change management process.
• Excellent result driven and customers focus skill.
• Designed, developed, and maintained retail industry enterprise system corporate BI solution.
• Main technology was MS based.
• Delivered 8 releases to production successfully.
• Integrated with PC-POS Confidential system transaction level data with 30 digits scanned barcode parsing.
• Delivered corporate BI solution end to end.
• Designed and developed store, district, region, corporate level security model on OLAP cube.
• Designed and developed business intelligence solution for merchandise and Halloween holiday sales.
• Drill through to detail on item, store, and hourly sales levels in near real-time.
• Maintained OBIEE HR analytics daily ETL process by informatica and DAC.
• Built operational data store for call center. This served the corporate EDW backbone for BI reporting.
• Managed 10 + BI servers and configured them for BI reporting.
• Technology evaluation for corporate BI solution. For example: Columnar DB (HP Vertica), MPP, Hadoop, NoSQL, IBM Cognos, and Tableau.
• Worked with Confidential sales team on Power Map POC project (weather, social media, and stores location)
• Worked with Oracle vendors on Loss Prevention OBIEE project.
• ODI replaced Informatica as integration tool and possible using Golden gate for real time data pump.

Software Design Engineer

Confidential, Bellevue, WA

Responsibilities:

• Finance shared services center BI packs (EPG, CS, CAMSMSP, SMSP reports) development.
• Finance BMO group executive level BI reporting development. Forecast, budget, actual, and adjustment.
• Industry certification: MCTS, MCITP in Confidential Business Intelligence Development and Maintenance.

Senior Data Warehouse Engineer

Confidential, Seattle, WA

Responsibilities:

• Requirements gathering and technical documentation of existing ETL solution (DTS packages, agent jobs, email processing, dimensions and fact tables, data warehouse, data mart, analytics reporting related objects) to S2T mapping, processing flow enhancement documents, merged several source systems to improve extraction process etc.
• Purpose was to deprecate existing ETL system (DTS/Data Stage) to a new large data warehouse appliance - Netezza MPP based ELT solution. We-team made history for the on-hold 4 years critical project success.
• I was proud of my technical documentation as a central lookup for the team.
• Coded 50 stored procedure/UDF to interface with extraction engine integration which was made on (C#.NET/XML) to handle large dataset extracting and loading.

Software Design Engineer

Confidential, Bellevue, WA

Responsibilities:

• Responsible for Confidential finance BI tools and application fiscal year rollover on district industry segment comparison EPG and SMSP.
• Designed and developed finance BI solution cross segment reports (EPG, SMSP, Dynamic) with actual, compensation, quota, forecast, budget data from upstream to downstream SSAS Cube/Excel Pivot table.
• Production support of DW ETL/ELT nightly stream process.
• We met SLA to 95% and up.
• OLAP cube performance tuning (partitioned, design storage). KPI, calculations, MDX

Senior Data Warehouse Engineer

Confidential, Bellevue, WA

Responsibilities:

• Responsible for high volume payment gateway industry OLTP system to OLAP system finance data warehousing design and development.
• Worked with performance data warehouse testing, data quality check, and performance tuning. Data was from HP site scope logs.
• Training course completion: Kimball University ETL Architecture in depth.

Database Developer

Confidential, Bellevue, WA

Responsibilities:

• Responsible for Confidential consulting services reporting tool BI development.
• BI development and existing codes maintenance for forecast and budget tool by excel VBA.
• Web report & tool development for forecast, budget by C#, ASP.NET.

Database/Applications Developer

Confidential, Redmond, WA

Responsibilities:

• Worked on ETL processing for Confidential sales, compensation, and consulting services related data.
• Worked on business investment funds project for database development and automation email system by SQL2005, CDOSysmail. Configured by SMTP.
• Reporting database design and development (SP, UDF, DTS, Distributed Query, OPEN Query, OPENRowset, and Linked Server) for McsReports, BMOForecast, Cost of sales, profit and lost, business investment funds, and SOX related projects.
• Database admin for development and production database.
• Coded reporting tool by MS Access VBA. Built automation reporting process by SQL jobs, SP.
• Developed intranet web application for controller, business owner online finance report by SQL2005, Visual C#.NET, and SQL server reporting services 2005.

Database Developer

Confidential, Seattle, WA

Responsibilities:

• Worked on 300GB database for ETL process by using SQL Server 2000.
• Worked on business intelligence, CRM related database development projects for (call usage, online statement, online billing, summary report, detail report, hierarchy, user profile and preferences, online helps, customization framework, permissions) for telecom clients
• Generated format files, load field data, reporting field data, calculation field data for Load and Reporting systems. Incorporated with dynamic SQL inside SP to generate run time dynamic report for specific client.
• SQL server performance tuning and identified issues by SQL profiler, execution plan, statistics, etc.
• Coded XML, PDF and CSV reports by ASP/COM/SQL.

Data Warehouse Testing Engineer

Confidential, Bellevue, WA

Responsibilities:

• Confirmed Confidential survey historical data warehouse data correctly after ETL process.
• Wrote test plan for unit test to identify the data after loading.

Database Engineer

Confidential, Bellevue, WA

Responsibilities:

• My role was working with the team lead to build out all back-end systems, including the financial engine, online menu management engine, catalog management tools, internal and external web reporting data in both time-zone and local formats, and the cross-server queued-delivery mechanism.
• Business component built by T-SQL, SP, UDF, VB6, COM, SQL-DMO, XML, and ASP.

Software Engineer

Confidential, Seattle, WA

Responsibilities:

• Developed all the VB6/SQL7 applications to support offline digital content delivery, automated CD burning and report printing process.
• Developed complex stored procedures to support business components.
• Worked with senior software engineer on distributed file integration project using Java/JDBC/XML/Swing.
• Web development for Services based (B2B) spot delivery private web site.
• MCP in Designing and Implementing Databases with MS SQL Server