SUMMARY

• 5+ year experience in Power BI/TABLEAU/OBIEE/BO/QlikView dashboard.
• 10+ year end - to-end BI solution design from requirement gathering with stake holders, data modeling, ETL, data warehouse, reporting to deployment to production system.
• 10+ year experience in SQL, PL/SQL, Unix Shell script, Oracle database, MS SQL database, Data Center, IT Infrastructure, PeopleSoft Supply Chain, Finance, HR, ERP, Healthcare, Manufacture, Government, Linux, Unix, Windows & VMware.
• 20+ year diverse experience in IT as Developer, Analyst, DBA & Project Lead.

TECHNICAL SKILLS

• Power BI, Tableau, OBIEE, SAP Business Objects, QlikView, Crystal Reports, SQL, Kylo, Hadoop, Hive, CDW, Snowflake, JSON, ERD, Embarcadero ER/Studio
• ERwin, Sun Solaris, HP AIX, Oracle Enterprise Linux, Oracle Exadata, Oracle 12c/11g/10g/9i/8i/7.3, Oracle Change Data Capture (CDC), Oracle SQL Developer
• MS SQL server 2008/2005/2000 , SSIS, SSMS, Visual Studio, SSAS, Data Warehouse, OLAP, OLTP, MDM, Oracle Data Integrator(ODI), RPD, Informatica ETL
• Informatica PowerCenter, JDBC, ODBC, PL/SQL, PRO*C, C, C++, Perl, Visual Basic, HTML, Idera SQL Diagnostic Manager, Toad, Precise SQL, Grid Control 12c/11g/10g.
• Microsoft 365, Cloud app, ITSM ServiceNow, Splunk, ITIL, Agile Scrum, Agile Sprint, JIRA, SharePoint, SDLC, Yammer, Unix, Linux, Windows, Citrix, Workday
• Clinical Data, PeopleSoft Supply Chain, PeopleSoft Financial, HR, Payroll, Time & Benefit, Health & Welfare, Medical billing, Procurement, Account Payable
• Account Receivable, Inventory, Fixed Asset, ImageNow, eResearch, eRecruit, Oracle Forms & Reports, Data Mining, ClearCase, CA Unicenter, Control-M, 6-Sigma Green Belt.

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer Specialist

Responsibilities:

• Lead advanced analytics data visualization and reporting requirement gathering with various business owner in Supply Chain & Finance.
• Create, review, & analyze complex business metrics, KPI with leadership team, & document FDD, TDD in complicated large data set business environment.
• Design, test, enhance, validate, migrate & troubleshoot hundreds of interactive, complicated dashboards to provide business insights using Power BI, Tableau, Qlik, BO, Azure SQL Server, JIRA, Agile, ServiceNow.
• Implement designs via Power BI, Azure SQL Server DDL / queries / stored procedures, and integration tools like SSIS.
• Write complicated, highly optimized SQL queries across large data sets for data extraction and data quality issue troubleshooting using SSMS, Toad or SQL developer.
• Automate BI solution delivery & alerts.
• Tune report performance using various knowledge and experiences, including report tuning, database tuning, review of BI system architecture.
• Improve dashboard data quality by monitoring, validating, and tracing data end to end.
• Troubleshoot, fix & monitor data warehouse & report data issues.
• Research, evaluate, POC & share Business Intelligence new technology tool, efficient solution, principal, standard, template, process & best practice for organization strategic Business Intelligence direction and planning, including Azure Data Factory, TFS, Big Data, CDW, Snowflake, Hadoop, Hive, Data Lake, AWS, S3, EC2, Redshift.
• Take initiative to learn new technology, mentor Senior or new team member across groups.

Confidential, Ann Arbor, MI

Senior Oracle/MS SQL server/MySQL DBA

Responsibilities:

• Lead data warehouse project to Extract, transform, & load data from multiple data source using Informatica ETL & IDQ, SSIS, Azure SQL server, Microsoft Visual Studio & SSMS.
• Design, review & maintain relational & fact and dimensional data model including using normalization method 3NF & 4NF, STAR schema, Snowflake schema, Embarcadero ER/Studio for data modeling, data governance, metadata management, Agile change management, naming standard, version control and collaboration.
• Architect, setup, design, create, unit test, integration test & deploy large scale data warehouse to support Business Intelligence for multiple subject area like finance, HR, Supply Chain.
• Create, upgrade & patch Oracle & SQL data warehouse databases for DEV/QA/PROD.
• Participate in development life cycle, design, test, deploy & maintain Planview Analytics for project portfolio, resource, process analysis, reporting & improvement including using Tableau.
• Lead project to refresh large data warehouse dataset using Asynchronous Distributed Hot Log Change Data Capture.
• Code, test & tune SQL, PL/SQL script like DDL/DML/function/procedure/view/trigger.
• Proactively monitor & tune database & SQL code performance using 10046 trace, AWR, ADDM, ASH report & Grid Control.
• Analyze data structure & access security, plan, upgrade, test, implement & maintain data structure change & other change following ITIL process.
• Monitor, analyze, troubleshoot, collaborate & resolve data integrity issue, data error, data refresh & data load issues in large complex production systems to meet SLA, including enforcing & following ITIL process for incident, problem, change, release, availability, capacity management using BMC Remedy IT Service Management Suite.
• Review architectural standard like principle, brick & pattern, component of solution architecture, interface between component by looking at business requirement, service level requirement, capacity requirement, security requirement, data requirement, storage requirement & disaster recovery requirement.
• Provide direction on BI, data & database management new technology like big data ecosystem, Azure, AWS, tool, standard, recommendation, process & best practice across team function.