BI Developer/Reporting Manager Resume

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer/Reporting Manager

Responsibilities:

Build SQL Database, ETLs in SSIS, Power BI Reports.
TFS Data validation and accuracy.
Build and automate jobs to pull data from several sources.
Revenue and month end reporting for top management.
Understand new business reporting requirements and designed and build process to get data.

Technologies & Tools: Excel, SQL Server, SSIS, SSRS, Power BI, MS Sales, DAX

Confidential

BI Developer/ Reporting Manager

Responsibilities:

Responsible for data validation and transaction processing of approximate 4 Million transactions every month.
Database administration for Mobile operator billing, China Xbox, China Reseller, Lakeview Databases.
New mobile operator onboarding, testing and data quality and integration.
Month, quarter and yearend financial reporting.
Facilitate annual audit and make improvements in system as per audit report.
Update monthly scorecard and dashboard.
Ad hoc report requirement gathering and automation

Technologies & Tools: Excel, SQL Server, SSIS, PowerPoint, SAP, SSRS, Cosmos, Power BI, DAX

Confidential

BI Developer / Financial Reporting

Responsibilities:

Automate ad hoc and recurring financial reports.
Design and automate reporting and reconciliation process for two new payment methods; AliPay and Currency Store Value.
Work with Finance team to understand business requirements and build prototype for technical team for reporting automation.
Database administration for server and data migration.

Technologies & Tools: Excel, SQL Server, SSIS, PowerPoint, SAP, SSRS, DAX

Confidential

Financial Analyst

Responsibilities:

Present recommendations to management for planning and decision - making.
Develop reports that identity budget and spend trends, provide insight into operational opportunities.
Develop and prepare financial presentations for the leadership team.
Prepare various ad-hoc requests.
Recover $1.2 M by identifying overcharges in hosting partner bills and corporate depreciation report.
Automated various financial reports that cut time span by 60%.
Reorganized hosting partner billing system that allows to receive accurate bill for the financial month and make necessary corrections if required.

Confidential

Business Analyst

Responsibilities:

Developed and automate major sales reports and sales analysis models for senior management including director of sales, director of production, finance manager and regional director of sales to analyze $60M sales every month.
Developed and automated monthly scorecard for monthly sync meetings for top management to review the world wide and regional sales in depth. This report indicates actual & budgeted revenue by worldwide and region, variance analysis, forecasted revenue for future, promotional budget, tier analysis, growth rate by month, quarter and year along with project growth for the rest of the year.
Produced master sales by distributors report by pulling data from SQL database and rearrange it in excel by using Power pivot, pivot table, v-lookup and complex formulas.
Produced sales analysis report by region, distributors, product, pricing level, and country and product distribution to help sales director in analyzing distributors performance against KPI’s.
Developed regional scorecard to analyze distributor’s performance by country & product family group. A grate tool for regional managers to understand sales trends, making projections, decision about promotional budget, price allocation, offering special royalties’ programs.
Automated the sales out reporting system that cut time span by 60%.
Produced Ad-hoc reports like variance analysis, sales analysis by customer, regional sales comparisons, data troubleshooting etc.
Documented and maintained data dictionary, developed data flow chats, prepared presentations for top management, automated and set validation criteria for various reports.
Produced power point presentations for Director of Sales for World Wide MS Embedded Sales partner’s conference.

Technologies & Tools: Power Pivot, SQL Server 2008, MS Excel, OEM-CRM

Confidential, Bellevue, WA

Senior Financial Analyst

Responsibilities:

Developed management tools to measure and analyze financial and operational information (e.g. financial ratios, key performance indicators, sales forecasting platforms, annual budgeting models, product pricing, job costing, financial and management reports).
Prepared complex financial models in Excel.
Automated accounting and financial reporting system to speed up the processing of critical information.

Technologies & Tools: SQL Server 2005, MS Excel, QuickBooks Pro 2011, MS PowerPoint

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship