Business Intelligence developer/analyst with 18+ year experience

VLADIMIR SIDOROV LinkedIn profile: https://www.linkedin.com/in/-vladimir-sidorov

Email: ********@*****.*** Tel: 718-***-****

PROFESSIONAL SUMMARY

Expert in business intelligence/reporting/data analytics with emphasis on visualizations: SAP (Crystal Reports, Business Objects: Webi, Deski, Dashboards: Xcelsius, Design Studio, Lumira, Universe Design: UDT/IDT), Microsoft (SSRS, Power BI, Excel Power Pivot). Skillful in self-service applications: Tableau, Qlik.

Strong knowledge of relational database management systems: SQL Server, SSAS, SSIS, Oracle and Teradata. Working knowledge of data warehousing. Proficient in writing complex stored procedures, functions and SQL scripts. Solid knowledge and experience in Transact-SQL (P/L SQL, SQL*Plus).

Proficient in designing Web and Windows based applications (VB.NET/VB6/VBA, C#, ASP, ASP.NET, VBScript, JavaScript, HTML, XML/XSLT, Visual Studio).

Competent in data mining, preparation/cleansing, ETL (Talend tools) and statistics (R, SPSS).

Pro-active and self-starter. Able to work as a team member/leader or as an independent developer. Can also work directly with a client in business analyst role. Inquisitive, apt to permanent self-perfection.

Skillful in research work and analysis, debugging and testing. Creative and results oriented problems solver.

EMPLOYMENT HISTORY

AmeriHealth Administrators Philadelphia, PA November 2011 to December 2017

Sr. Business Systems Analyst

Successfully completed hundreds of complex reporting projects (SAP Business Objects, MS SSRS, Access, Tableau, Excel VBA and Pivot tables/Dashboards). Wrote complex SQL parameterized queries, scripts and stored procedures (also tuned them for performance) for using as data sources for reports, dashboards and other visualizations (used such databases as SQL Server, Oracle, Teradata and Access). Monitored ETL (SSIS) packages, participated in data analysis (statistics, segmentation/clustering etc.) and preparation (data profiling, cleansing, transformation). Performed SAP BO administrative duties (users accounts, security, reports scheduling, back-up procedures, migration/upgrading etc.). Interacted with requestors and end users in business analyst role. Wrote business requirements, technical specifications and user documentation. Developed and performed technical support of various Access and Excel VBA applications and utilities. Initiated and accomplished a few projects which improved business relationships with internal and external customers. Conducted analysis and investigations of complex issues, troubleshooting and fixing in timely and efficient way. As a member of a virtual team collaborated in large enterprise data warehouse projects (gap analysis, data profiling, cleansing, scripting, testing etc.). Demonstrated capability of achieving results with incomplete or missing input documentation. Trained non-technical personnel on Business Objects and other self-service reporting applications (delivered presentations, created tutorials, lead one-to-one and group learning sessions). Guided and instructed junior developers and contractors. Popularized the idea of switching to self-service methodology in reporting (Tableau, Spotfire, QlikView/Sense).

Innovest Systems, LLC New York, NY April 2007 to May 2011

Crystal Reports Application Developer

Worked on complex custom Crystal reports integrated into proprietary web application with SQL server at back end. Redesigned/modified hundreds of existing Crystal reports. Improved user configured methodology in financial statements. Created complex reporting database objects (stored procedures, functions, views, tables, scripts) for all new reports and refactored and optimized them for older releases.

ProcureStaff, Ltd New York, NY February 2005 to April 2007

Reporting .NET Applications Developer

Worked at back-end and front-end in SQL Server 2000/2005 and C# (Visual Studio 2003/2005) multi-developer environment (bound to Perforce source code management tool). As a sole developer created Executive Dashboard (charts with drilldown to detail level data functionality). Wrote reporting stored procedures for all new reports, refactored and optimized stored procedures for older releases. Created SQL scripts for deploying reports related objects to QA, UAT and Production environments.

Neuberger Berman – Lehman Brothers Company New York, NY August 2004 to January 2005

Crystal Reports/Crystal Enterprise Developer

Converted a few front-end applications based on custom .csp pages (Crystal proprietary language) into classic ASP application in CE10 (Crystal Enterprise) server environment.

Orion Consultants – Financial Management Consultants New York, NY January 2004 to July 2004

Senior Application Developer

Re-designed T-SQL reporting views by transforming them into de-normalized tables. That solution significantly improved performance (reduced reports run time from minutes to seconds). Modified, optimized and documented 200+ Crystal reports.

The College Board New York, NY December 2001 to September 2002

Crystal Enterprise developer

Created SQL Server 2K database as a consolidated reporting repository (imported data from Access and Oracle databases and also from text files and Excel spreadsheets using Microsoft Data Transformation Services).

Aptegrity, Inc. Fairfield, NJ September 2000 to October 2001

Internet/Reports engineer

Worked on web portal (used proprietary Epiphany Visual Business Modeling language), assisted in administrative activity: installed SQL and Crystal Enterprise servers, HP Internet monitoring services, created databases, ETL packages, performed performance tuning.

Opticon, Inc. Orangeburg, NY February 1999 to July 2000

Programmer/Analyst

Designed, coded, tested front-ends written in VB6.

Kepco, Inc. Flushing, NY May 1997 to January 1999

Test/Software Engineer

Developed windows applications for computerized testing of programmable electronic devices.

PRIOR PROFESSIONAL EXPERIENCE

Held numerous engineering and managerial positions at various companies in Estonia. Worked in such industries as: Information Technology, Electronics Engineering, Manufacturing, Education, Sales, and Telecommunications. Managed scientific-research and industrial projects.

ACADEMIC EDUCATION

Institute Of Applied Physics, N. Novgorod, Russian Federation

Correspondence Post-Graduate on Control and Instrumentation.

(Research of mathematical models of wide-band digital voltmeters and measurement errors)

Degree - PhD in Electrical Engineering (4 patents and 16 publications)

Advanced post-graduate courses on Patent Law, Moscow, Russian Federation

Patent attorney (examination of inventions in the fields of Electronic and Computer engineering).

Tallinn University of Technology, Tallinn, Estonia

MS in Electrical Engineering

Extended version of the resume will be submitted on demand

Contact this candidate