Data Analyst

Mikhail Osterfeld

Brooklyn, NY ***** *** – *** - 8878 **********@*****.*** https://www.linkedin.com/in/mikhail-osterfeld-10969032/

Experienced Knowledge Professional

Experienced high-tech knowledge worker; core competency is rapidly learning and applying new skills, data integration, ETL, developing new and creative analytical solutions to complicated problems.

Key Skills: ETL/ELT: Java, SQL, Talend Data Analysis: Excel, VBA

Data Visualization, CRM and Reporting: Excel, Raiser’s Edge

QA Testing, Validation & Verification: Java Team Leadership: Agile, Waterfall

PROFESSIONAL EXPERIENCE

ETL Team Leader Capgemini Jan 2019 – Jul 2020

Technical leader in charge of a 4-person Agile data integration code development team, then project leader of an 8-person interdisciplinary project team with onshore and offshore members, including developers, architects, system administrators. Project value in excess of $500,000, operating on tens of gigabytes of data.

Project involved highly complex ETL/ELT, GDPR-compliant data masking and data mining of multi-GB data sets using Talend Open Studio for Big Data to integrate data in MySQL, SQL Server (T-SQL), Dynamo DB, Cassandra. Integrated complex transformation of JSON and Google Protocol Buffers, protected by strong encryption at object level (AES, RSA).

Led initiative to develop and field de facto custom multi-threaded Java application for data integration/ETL, turning Talend Open Studio into a rapid prototyping Java IDE. Integrated normally unsupported technologies (object-level encryption, Google protocol buffers) with Talend.

Deployed application on AWS EC2 for multi-threaded execution of integrated data mining+ETL task, processing 16,000,000+ complex customer accounts intricately linked across 3 databases on 2 systems in the space of 6 days.

Promoted and given 8% pay raise within the first year due to exemplary performance.

Database Controller FIDF Jun 2015 – Jan 2019

Primary day-to-day manager of the Raiser’s Edge database, responsible for data extraction, transformation and load (ETL), data hygiene, data integrity and data access control. Integrated all bulk data uploads into the DB using RE’s data import/ETL component.

Primary operator of the database help desk. Responded to two thirds of all help requests.

Responsible for generation of 300+ custom ad-hoc reports using Raiser’s Edge query system and/or SQL query data, followed by MS Excel post processing with advanced functions, pivot tables and VBA code as needed. Built data visualizations and Raiser’s Edge dashboards on demand.

Primary trainer for new employees requiring Raiser’s Edge onboarding.

Inventory Manager The Ambulance Network Dec 2014 – Jun 2015

Implemented tracking and management process for vehicle inventory and vehicle production queue.

Managed website and online advertising.

Began business development activities oriented toward exporting vehicles to Belize and the Ukraine.

Operations Research and Systems Analyst JIEDDO Oct 2011 – Jul 2013

Operations Research and Systems Analysis (Data Analyst) position in support of US military operations in Afghanistan. Forward deployment to Afghanistan, May 2012 – June 2013.

Developed analytical reports and visualizations to influence senior leadership and provide critical information to customers. Used SQL-based tools for data extraction, Visual Basic for Applications (VBA) and Excel functions/pivot tables as needed for data transformation/analysis. Visualization was via Excel and PowerPoint.

Organized and supervised field testing of equipment (mine detectors, captured enemy devices). Created test reports and analyses based on test results. Reporting briefed to top leadership at theater level, immediately affecting operations nationwide and informing financial decisions in the multi-million-dollar range.

Completed over 100 small projects and several large ones.

Analyst Cortana Corporation Dec 2008 – Oct 2011

Full cycle software development in Java with test-build-test paradigm on 6-month cycles (some accelerated cycles to meet urgent customer requests), using Eclipse IDE. Software testing lead, in charge of all software testing for a custom piece of national security software.

Performed Quality Assurance / Quality Control (QA/QC): semi-automated software testing using purpose-designed suite. Designed all tests and use cases, wrote over 90% of test suite code (all in Java).

Performed requirements validation and verification (V&V): performance benchmarking IAW contract specifications.

Conducted algorithm development: Java-based development of new functionality beginning with vague customer request and ending with the business logic of a fully-functional algorithm, and associated use cases for customer consideration.

System of Systems Analyst SAIC Jan 2005 – Nov 2008

Systems engineering position on Future Combat Systems (FCS) program, worked on the design of the battle command system.

Conducted requirements management, requirements elicitation, requirements flow-down.

Acted as lead analyst and/or participant in various trade studies (6 major studies, numerous minor ones).

Contributed to top-level system design, authoring over 200 documents.

Army Officer US Army May 2000 – Feb 2005

Armor Branch: Scout and Antitank Platoon Leader, Squadron Intelligence Analyst.

Wartime Service: Operation Iraqi Freedom, April 2003 – July 2004. Acted as primary advisor on political, cultural and security issues to the military governor of the Tisa Nissan district of Baghdad (pop. ~1.5 million) and the city of al-Kut (pop. ~250,000).

EDUCATION

Carnegie Mellon University, Pittsburgh, PA, Master of Science in Electrical Engineering, May 2000

Carnegie Mellon University, Pittsburgh, PA, Bachelor of Science in Electrical and Computer Engineering, May 1998.

LANGUAGES

Russian (native speaker)

English (native-equivalent proficiency)

Contact this candidate