Michael Leyzerovich Email & Phone Number

San Francisco Bay Area

San Leandro, Ca

Successfully completed data and data flow packages migration for the main production facility for chocolate manufacturer GhirardelliOptimized and migrated old data flow processes from IBM Cognos Data Manager to MS SSISConverted over 200 data flow packages into SSIS in order to meet current BI design standards and best practices.In the process reviewed and re-designed database schemas, table indexes and stored procedures and functions.

Santa Clara, Ca

Analyzed data repositories in SAP CRM, MS SQL Server and MS Excel Identified and eliminated data discrepancies, improved existing and developed new data ETL processesBuilt Tableau dashboards and SSRS reports that helped business teams identify the gaps and delays and improve logistics in spare parts delivery processes for company’s customers around the globeCreated recommendations on redesigning and optimization of the components delivery cycle and the data capture processesTools/Languages used: MS SQL Server, SSIS, T-SQL, MS Excel, Tableau

Palo Alto, Ca

Developed ETL processes and SSRS reports that helped marketing and sales teams analyze usage for internal marketing assets repositoryProvided database administration and support for MySQL databases for internal portals and applications. Managed infrastructure for company’s global web site SAP.com: applications and database day to day operations, reviewed and released code submitted for database changes, performed root cause analysis and resolved various database related issues: execution speed, data discrepancies etc.Tools and languages used: T-SQL (stored procedures), MS SQL Server, SSRS, SSIS, Jira, Chef, Git, MS Excel, MonYog, MySQL 5-5.5, MS Windows Server, Linux RedHat, DBA Cockpit.

Palo Alto, Ca

Developed SSRS reports and ETL processes for large data sets (1.5 billion rows) that helped marketing and sales teams analyze web visitors behavior data for SAP.com and for internal marketing assets repository that led to better visitor engagement and conversion to salesProvided full support for SAP.com’s web analytical system VBIS: installed and administered the system, developed reports, served as a single point of contact for both internal customers and the vendor.Managed infrastructure for company’s global web site SAP.com.Developed requirements and specifications and provided full technical support for internal marketing assets repository.Tools and languages used: MS SQL Server, T-SQL (stored procedures), SSIS, SSRS, MS Excel, Jira, Bash scripting, MS SharePoint, ASP .NET, MS Windows Server, Tomcat Web Server, VSS

Palo Alto, Ca

Designed and developed databases (MS SQL) and web applications for company’s global web site and internal portalDeveloped internal tools that allowed business teams to manage content on the web siteCreated web usage reports using WebTrends SuiteTools and languages used: MS SQL, T-SQL, ASP 3.0, VBScript, JavaScript, CSS, HTML/DHTML, ActiveX, WebTrends, OLEDB, ODBC, DAO, ADO

Walnut Creek, Ca

Developed web-based loan-delivery applications Developed user-friendly web-based interface for content management and layout and content customizationsProvided full technical support for dozens of co-branded partners web sitesTools and languages used: ASP 2.0/3.0, JavaScript, DHTML, VBScript, MS SQL Server

New York, Ny

Created e-commerce WEB-Sites: developed web applications for store listings, search engine, customer registration, administrative access and content managementTools and languages used: ASP 2.0/3.0, JavaScript, DHTML, VBScript, MS SQL Server