SUMMARY:

• Learning new software applications related to data visualization, data modeling, KPI, ETL.MS Power BI Desktop: Import data from various data sources and file formats.
• Create data dynamic visualization dashboards, KPI’s and reports using charts, guages, slicers.
• Create measures and custom calculated fields using DAX functions.
• Create relational data tables using Power BI and custom scripts using Power Query M language.
• MS Power Query for Excel: Same as Power BI except for except for data visualization and M functions.
• Manipulate data using M language for ETL and data modelling for Power Pivot table.
• Create custom M functions and calculated fields.
• MS SQL Server 2008r2 & 2014, SSMS and SSRS: Import SQL database to create queries and views.

PROFESSIONAL EXPERIENCE:

Confidential,CA

Accounting Analyst

• Data scrubbing of raw source data utilizing advanced Excel/Macro techniques, MS Access and VBA.
• Normalize flat files and spreadsheets for conversion to data tables used in MS Access database.
• Identify anomalies and trends during data validation.
• Reconcile Oracle G/L to Legacy reports and trial balances for Asia and Mexico manufacturing plants.
• Technical Environment: MS Office (Office365) 2016, MS Excel 2016, MS Office Professional 2013, MS Excel 2013,

Confidential,CA

Data Analyst

• Data scrubbing of raw source data utilizing advanced Excel/Macro techniques, MS Access and VBA.
• Normalize flat files and spreadsheets for conversion to data tables used in MS Access database.
• Identify anomalies and trends during data validation.
• Technical Environment: MS Office Professional 2013, MS Excel 2013, MS Access 2013.

Confidential,CA

Sr. Accountant

• Prepare journal entries and account reconciliations.
• Assist in performing the month - end close process.
• Perform detailed variance and account analysis.
• Analyze programming contracts and company initiatives.
• Utilize the subscriber billing system to troubleshoot issues.
• Prepare tax and audit schedules.
• Perform ad hoc analyses.
• Interact with other department business managers to improve processes.
• Technical Environment: MS Office Professional 2010, MS Excel 2010, SAP R/3, SAP BW, TM1, BlackLine, Burns,

Confidential,Los Angeles,CA

Participations Migration Analyst

• QA review of converted Excel files.
• Modify converted files to eliminate errors.
• Link various worksheet tabs with data input pages.
• Test buttons/scripts/macros and make any necessary adjustments.
• Verify final Excel product.
• Provide support and troubleshoot Excel problems for operations groups as necessary.
• Maintain record of file conversion process and status of files handled.
• Technical Environment: MS Office Professional 2013, MS Excel 2013, VBA, LOTUS 123.

Confidential, Los Angeles,CA

Database Analyst

• Create automated MS Access application to track project status for project managers in Product & Promotions
• Management Operations division using Queries, Forms, Reports, Macros and VBA programming.
• Technical Environment: MS Office Professional 2010, MS Access 2010, MS Excel 2010, VBA.

Confidential,CA

Excel/VBA Expert

• Create automated Excel application to track project status for project managers in Product Development division using macros, VBA programming and custom user defined functions.
• Create dashboards for Product Development executive management using advanced Excel to report KPI’s which includes charts, graphs, VBA programming, macros and other methods.
• Technical Environment: MS Office Professional 2010, MS Excel 2010, VBA.

Confidential, Los Angeles, CA

Data Analyst

• Create marketing metrics report incorporating the design of user interfaces utilizing advanced Excel formulas, VBA programming and user form controls.
• Automate marketing metrics reporting template utilizing VBA programming.
• Technical Environment: MS Office 2013, MS Excel 2013, VBA.

Confidential, Los Angeles, CA

Data Analyst

• Data validation for campus wide system conversion.
• Data scrubbing of raw source data utilizing advanced Excel/Macro techniques, MS Access and VBA.
• Convert legacy CSV and Excel flat files into MS Access data warehouse for querying by creating VBA macros and other techniques.
• Automate UCAPT Word template with Excel template utilizing VBA programming.
• Create MS Access database to track faculty tenure data.
• Create user instruction manuals.
• Technical Environment: MS Access 2010, MS Excel 2010, VBA.

Confidential, Los Angeles, CA

Data Analyst

• Document MS Excel macros and procedures used in reconciling prior provider data.
• Transform, remap and reformat prior provider data to Transamerica’s format to be uploadable.
• Modify/troubleshoot existing MS Access and Excel VBA macros for improved efficiency.
• Create user instruction manuals.
• Technical Environment: MS Access 2007, MS Excel 2007, VBA.

Confidential,Los Angeles, CA

Data Analyst

• Document and create process flowcharts for Excel macros used in financial reports.
• Modify existing Excel VBA macros for improved efficiency.
• Design Excel application to create budget templates utilizing Excel VBA macros.
• Create P&L variance analysis templates utilizing Excel VBA macros for process improvement and reporting.
• Create user instruction manual.
• Technical Environment: MS Excel 2010, VBA, Lawson.