We provide IT Staff Augmentation Services!

Business Analyst / Data Migration Consultant Resume

Rockville, MD

SUMMARY:

Business Data Analyst with Programmer/Application Development skills. Managing corporate business data information projects, vast application development via automation, database development, SQL, MS Access/Excel/VBA, Power BI & Tableau. 10+ years Business Analyst, Data Information Management & Programming skills

TECHNOLOGY SKILLS:

  • MS Access/Excel VBA Automation Application Development (expert/guru level).
  • Microsoft Power BI, Tableau Data Visuals & Report development.
  • MS SQL Server, SSMS & SSRS report development.
  • SQL Query Development. Business Objects, ODBC database connectivity.

EMPLOYMENT BACKGROUND:

Confidential, Rockville, MD

Business Analyst / Data Migration Consultant

Responsibilities:

  • Working as the Primary SME consultant overseeing the data migration from Microsoft Dynamics to a Salesforce CRM application.
  • Writing advanced MS Excel VBA macros, Vlookup formulas, PivotTable reporting and scripting automation to flag variances between Salesforce and Dynamics extracts.
  • Validating and reconciling data extracts used to manage Confidential Membership data for Pharmaceutical organizations worldwide.
  • Manager/Business Executive, (Retail Publication Business)
  • Shutdown of personal business, close out inventory, bookkeeping
  • Tax Preparation, completed Business Shutdown

Confidential, Fremont, CA

Business Analyst / Data Modeling

Responsibilities:

  • Managed Data Mapping and Data Migration programming via MS Excel VBA application development.
  • Performed vast Data Analysis using advanced MS Excel practices to reconcile data discrepancies, cleaning data extracts (csv files, text files, spreadsheets).
  • Managing and automating the ETL process to load Confidential ’s work order history files into Oracle/SQL enterprise databases.
  • Formatting and assigning data types to relational database extracts.
  • Extensive VBA Programming and Application Development.
  • Manager/Business Executive, (self employment, personal business)
  • Inventory management, bookkeeping and Tax Filing

Confidential, Milpitas, CA

Business Data Analyst

Responsibilities:

  • Data reconciliation and analysis of Confidential ’s Fixed Assets Management System.
  • SQL query development with MS Access, Oracle databases systems.
  • MS Access database development (forms, queries, reports, VBA coding).
  • Created front - end GUI forms synched to backend Oracle & SQL databases.
  • Normalized data tables, creating relational database schemas.
  • Automating the import/export (ETL) of CSV data files into MS Access databases.

Confidential, San Jose, CA

Business Data Analyst

Responsibilities:

  • Independently developed a MS Access data warehouse from scratch to manage Adobe’s fiscal Sell Thru Data for all Adobe software products sold.
  • Extensive MS Excel VBA automation, MS Access database development, SQL programming and SAP reporting and analysis.
  • Connecting MS Excel pivot table templates with MS Access backend databases.
  • Data analysis, data scrubbing and validation to sanity check database extracts.

Confidential, Milpitas, CA

IT Analyst (Sales Business Development)

Responsibilities:

  • Managed complex Sales Pricing Tool to forecast the cost, pricing, discounting and profit for the sales of Confidential hardware/software products.
  • Extensive MS Excel VBA programming and automation.

Confidential, Mountain View, CA

Database Programmer/Developer

Responsibilities:

  • Developed a MS Access database to manage layoffs and divestitures.
  • Extensive MS Access development, VBA Programming and ETL tasks.
  • Developing front end GUI forms, queries and reports in MS Access.
  • SQL ODBC connections, ADO database connections via VBA.

Confidential, Milpitas, CA

Database Programmer/Developer

Responsibilities:

  • I developed an application to forecast the Total Cost of Ownership (TCO) for deployment of Confidential ’s IP telephony network solutions.
  • Develop reports, charts, graphs in MS Excel and MS PowerPoint.

Hire Now