Business Analyst / Data Migration Consultant Resume Rockville, MD - Hire IT People

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.

We provide IT Staff Augmentation Services!

Business Analyst / Data Migration Consultant Resume

Rockville, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship