Bi Analyst Ii
Current• Over 15 years of experience in creating, designing and developing several sales, marketing, financial and procurement applications, including 7 years of experience in the BI analysis and BI tools applications, successfully directing, designing and managing sales, marketing financial, science applications using MicroStrategy and Power BI.• Writing queries and data analysis modules to help to find missing data, input errors.• Automated several Excel process to exchange data between large excel files and SQL databases and created several pivot tables to summarize data from large worksheets.• Optimizing data exchange between departments and banks, credit cards companies and suppliers.• Converting manual entries into automated processes. Excel automations and VBA macros.• Writing data analysis and data exchange between different databases and platforms such as MS SQL, Oracle, IBM DB2 and DB3.• Wrote Sarbanes-Oxley IT controls, SOPs, user manuals and applications and installations documents, “how to” documents for the finance and purchasing departments. • Improved data and system performances for user’s satisfaction. • 2016 - Awarded “National Collaborator” by Seattle Genetics Sales and Marketing departments.• Developed a “passion” in finding and solving problems within SQL tables, views and programs.
