ALEX SAMCHENKO

OVERVIEW

Results oriented IT professional with a strong capacity to adapt to new situations quickly. Work well under pressure and consistently meets all imposed deadlines. Strong analytical skills and knowledge of database concepts as well as ability to apply professional principles to effectively summarize the data. Possesses excellent inter-personal and communication skills.

TECHNICAL SKILL:

ERP: SAP R/3

Experience with SAP HR module, Query and reporting

Operating Systems:

Windows 95/98/NT4.0/2000/XP/Vista/7/10, Access Database, AS/400

Integration experience

MS Excel 2003/2007/2010/2016(Office 365) advanced Formulas and functions, writing macros/excel programming, Pivot Tables, V-Lookup, etc., SQL,

PowerPoint - assembling and publishing dashboards, hyperlinks, CA Clarity PPM, IBM Cognos, Tableau Server, Oracle Instantis Enterprise Track, Alteryx, HeidiSQL, Teradata Studio Express, MySQL Workbench, Jira, ODBC connectors, MBOX, Cloudera Hadoop, HUE, Amazon Redshift, S3 Browser, STS, ACCPAC(SAGE), HP PPM, D-Rive, QuickBase, JDE (Oracle) and IBP (SAP).

November 2021 – February 2023

Blue Skies Consulting, Princeton, NJ

Data Migration Analyst

•Developing Data Migration and Integration Mapping Documents – Creating functional specs for business verification and technical team development.

•Working with both the business and development team, to clarify requirements and questions.

•Data Migration and Integration Functional Testing – Perform functional unit testing/verification of data migration and integration programs.

•Support project level testing cycles of those same programs for UAT.

•Data Cleansing Activities – Identify and coordinate data cleansing activities required to support the data migration and on-going data integration.

•Data Reconciliations -As defined in the playbook, perform data migration reconciliation procedures as part of key project milestones and ultimate go live.

November 2020 – October 2021

Amneal, Bridgewater, NJ

Senior Supply Chain Business Analyst

•Collecting and analyzing data to help improve an organization's supply chain operations.

•Working cross-functionally with Finance, Sales & Marketing, Procurement, Logistics, IT & Sites to obtain such data and to report monthly and quarterly metrics as well as orchestrating and compiling reports on department initiatives.

•Analyzing information to support Amneal Sales & Operations Planning model.

•Identifying and measuring key metrics to advance internal efficiencies.

•Preparing data sets for demand review, site consensus, & executive S&OP meetings.

•Managing Global Supply Chain metrics reporting and create monthly dashboard.

•Assisting in annual volume budget planning and manage data from global sites.

•Developing and enhancing BI Tools / Reporting for the Global Supply Chain team.

•Collaborating with Global Supply Chain teams to perform make/buy cost analysis and business process improvement analysis.

•Creating and publishing Daily Backorder Reports with duration tracking

•Distributing weekly DSI (Demand Supply Inventory) report.

•Updating master FTS file for reporting.

•Performing adhoc analysis.

April 2019 – November 2020

Amneal, Bridgewater, NJ

Pricing Data Analyst

•Compiling and maintaining Customer/Product data for win and loss tracker.

•Developing competitive intelligence processes to collect and evaluate competitive actions, customer win-loss experience, and other relevant customer relationship measures.

•Assisting with the presentations for the executive management team and the Board of Directors

•Analyzing Win/Loss data to identify patterns, use cases, develop new data Models

•Collecting customer win and loss analysis, survey and call-down programs to sales teams.

November 2018 – March 2019

Dun & Bradstreet, Short Hills, NJ

Reporting Analyst

•Defining success criteria with Project Manager and report on progress on criteria to involved parties throughout project and program life cycle

•Proactively identifying and resolving issues critical to the clients' strategic and operational success.

•Identifying areas of operational and technical change management impacting the status quo

•Setting up and continually managing project and program expectations while managing deliverables with team members and stakeholders

•Analyzing current and past trends in key performance indicators including all areas of revenue, cost of rates, expenses and capital expenditures.

•Working with global project leaders and Cognizant Technology Solutions (CTS) team consolidate work streams to provide centralized view.

•Coordinate status reporting tracking on all issues and risks and provide project visibility to all levels of management.

•Analyzing complex financial information and reports to provide accurate and timely financial recommendations to management for decision making purposes.

•Tracking and reporting on realized revenue. Providing revenue totals and “proof of delivery” for all delivered services/contracts monthly.

•Developing and implementing new processes, procedures, or platforms to improve efficiencies, program outcomes, and reduce costs for programs and campaigns.

•Identifying new ways to build and nurture the sales pipeline, evaluate nurture performance and return on investment (ROI) through lead ratio scoring and segmentation.

April 2018 – November 2018

Johnson & Johnson, Titusville, NJ

Data Analyst

•Managing master data (List of Values, product data, configuration data) within Microsoft Excel and providing user data support globally

•Using Alteryx tool and applications to evaluate HCC&P data sets, making corrections and maintain proper version control and change management

•Scheduling and receiving data modification requests from users

•Managing the data in controlled documents as defined by process

•Preparing, creating and monitoring application change tickets

•Attending status calls

•Validating application changes

•Communicating timelines to requestors

•Developing macros to be used within the data templates, such as the master data and the templates used to upload data to STAR manually.

•Helping define the processes, roles and requirements to manage the master data and configuration data templates.

•Managing project deliverables.

April 2017 – February 2018

Integra LifeSciences, Plainsboro, NJ

Sales Operation Data Analyst

•Responsible for maintaining a database system that supports complex contract pricing plans and obligation.

•Downloading monthly GPO rosters and validating GPO membership to ensure accurate GPO fees.

•Analyzing and reconciling large sets of data (roster/pricing list) in Excel and Access.

•Managing and consolidating customer demographic account information in sales reporting database.

•Partnering with cross-functional team members like marketing and sales operations to provide analytical support

•Developing and modifying contract templates to suit business and customer reads. Ensure proposed changes receive appropriate review and approval.

•Reviewing contracts/documentation to ensure they meet corporate legal guidelines including compliance to the company and Regulatory standards.

•Administering, extending, modifying and terminating contracts

•Preparing sales analytics as needed by corporate accounts and senior sales management

•Processing of contract documents and information for subsequent review and approval by sales

November 2014 – November 2016

Johnson & Johnson, Morris Plains, NJ

ITIS Report Developer/ Data Analyst

•Perform a variety of reporting, data quality, validation and data analysis activities in support of Global Portfolio Management PMO team.

•Creating & modifying reports in Business Objects Web Intelligence, Tableau, SQL, and Excel tools.

•Maintaining scheduled report jobs in Business Objects Web Intelligence and Tableau server.

•Performing ad-hoc reporting using BO Web Intelligence, Tableau, SQL and Excel tools.

•Providing data validation/correction in Clarity PPM, Oracle Instantis Enterprise Track tools.

•Designing and formatting reports to provide consistency and ease of use.

•Reviewing and validating reports for accuracy.

•Developing dashboards & metrics for leadership.

•Creating integrated analyses from multiple data sources like Alteryx, BO Web Intelligence, Teradata Studio Express, Cloudera Hadoop, Tableau and Excel tools.

•Data manipulation in Excel, pulling/validating data with SQL

•Working with stakeholders to gather report requirements.

•Documenting report functions and procedures.

•Administrative tasks related to Business Objects and Tableau server access rights

•Administrative tasks related to SharePoint site maintenance.

February 2014 – October 2014

PSEG, Newark, NJ

Report developer/ Workforce Analytics Analyst

•Responsible for collecting and analyzing HR data and metrics to identify important trends.

•Developing and reporting of analytic summaries.

•Performing workforce analytics (leading/lagging indicators) and other ad-hoc reporting, including consolidating data and preparing reports

•In coordination with HRIS technical resources, developing effective reporting solutions that support business goals and objectives.

July 2013 – December 2013

Verizon, Basking Ridge, NJ

Financial Business Analyst

•Reviewing and processing the daily Financial Transaction Data Report generated in MSS for new employees who require an Activity Type Code assignment.

•Processing client financial code change requests within the ONEHR (Oracle) system (Responsibility Code, Cost Center, Activity Type, and MSS FP&A POC updates for 116 Verizon companies).

•Responsible for proper code updating, client notification of completion, and general assistance with coding questions.

•Designing, maintaining and updating client online request log database for tracking Data and reporting purposes.

•Investigating, resolving and implementing via ONEHR, COGNOS and subject matter experts’ client issues related to all of their coding requests.

•All client requests are handled in a timely manner.

August 2011 – July 2013

Johnson & Johnson, Raritan, NJ

Data/Reporting Analyst

•Provide assistance to members of Global Account Management (GAM) Analytics Team on Ad-hoc projects.

•Responsible for development and distribution of weekly, monthly and quarterly forecast and activity reports to the (GAM) reporting and analytics team using Microsoft Excel.

•Perform ad-hoc data analysis and analytical research, and assist in development of new models and reports.

•Assisting the development of a new metrics reports.

•Responsible for extracting and validating data from various data sources (including IBM Cognos, Clarity PPM and SAP Business Objects - business intelligence) and dashboards as well as posting of reports and presentation to Web Portal.

•Conducted data analysis and presented data in a clear and concise manner

•Using Jira tool to create a workflow, tracking issues and task management

•Responsible for Weekly reports: Clarity Forecast Extract, Intake Metric

•Responsible for Monthly Reports: Catalog Page Hits, AS (formerly Global Services) Demand Metrics, Partner Demand Deck, Forecast Accuracy, Operations Forecast, GPM Project Load, Forecast Portfolio.

•Responsible for Quarterly Reports: Forecast vs. Actual

•Creating query in Web Intelligence for Data Validation.

March 2010 – July 2011

Panasonic Electric Works of America

Sales/Financial Reporting Analyst

•Examined and evaluated the purpose and content of business reports to develop new or to improve current use and control.

•In charge of reviewing reports to determine basic characteristics, such as origin, report flow, format, frequency, distribution and purpose of the report.

•Also part of the team that recommends new reporting methods to improve content and completeness of information in the reports.

•Assisted senior analysts by preparing and issuing instructions concerning generation, accuracy, timeliness and distribution of reports according to new or revised practices and procedures.

•Build/Maintained Access database with Oracle mapped tables (ODBC) to facilitate import/export reporting process.

•Create queries and retrieve data from a database by using SQL

•Provide Point of Sales (POS) and Original Equipment Manufacturer (OEM) sales reports to Reps.

•Provide Point of Sales (POS) and Original Equipment Manufacturer (OEM) Access Database updates to Finance.

•Data preparation for CRM Database

•Extensive use of Excel Spreadsheets, pivot tables, graphs.

November 2006 - December 2008

Linde North America, Inc. (formerly BOC Gases)

Pension Administration and Support

•Reported directly to the Manager of Pension Administration and was primarily responsible for update and maintaining the pension database containing the census data for over 20,000 plan participants.

•Prepared SAP wage reports, employee data information (profile), pay stubs for research and reconciliation.

•Worked with team members for integration and user acceptance testing issue resolution.

•Tracking/updating HR related expenses into database using Excel spreadsheets.

•Assisted and manually enter new hires, terminations, salary adjustments etc. into SAP.

•Filing, copying, document scanning, database backups.

•Performed various special projects, calculations, and analysis requiring the use of several different software packages and systems, including SAP, PeopleSoft, KWASHA (pension system), and Microsoft Office.

Linde North America, Inc. (formerly BOC Gases)

October 2005 - November 2006

Sarbanes-Oxley Data Analyst

•As a member of the Sarbanes Oxley project team was responsible for entering, updating and maintaining process documentation and test plans in the company’s proprietary SOX compliance system (TARDIS). Other responsibilities included running ad-hock reports and performing tests of key controls.

Independent Consultant, Mountainside, NJ

08/2004 – 10/2005

Technical Support Specialist

•Provided Help Desk Support for various home and office systems including operating systems updates, software updates, network password resets, account management, home drive & mail folder cleanup and LAN/WAN connectivity issues.

•Performed troubleshooting for Windows 95/98/XP/2000, Outlook, and MS Office 2000/2003.

Boomerang Medical Transportation Inc., Springfield, NJ

03/2002 – 08/2004

Technical Support Specialist

•Supported users within Medical Transportation Company.

•Maintained and performed troubleshooting for PC’s, printers and related hardware problems

•Assisted in the administration of day-to-day maintenance of Novell, NT and Exchange platforms.

•Installed, maintained and supported Windows 95/98/2000/NT operating systems and PC Anywhere & VPN communication software.

•Independently maintained and repaired equipment. Made recommendations for replacement of equipment.

•Assisted in product evaluations and made recommendations for hardware and software purchases.

PC Help Services, Clark, NJ

06/2001 - 03/2002

Stryker Howmedica Osteonics

Technical Support Consultant

•Trained users in system, network, and software capabilities and functions. Maintained and updated equipment data base files and/or other hard copy records regarding location, type of equipment, features, serial and model number and other identification codes, etc.

•Responded to client inquiries concerning systems operation and diagnosed system hardware, software, and operator problems.

•Recommended or performed minor remedial actions to correct problems.

•Provided updates, status, and completion information to manager, problem request tracking system, and/or users, via voice mail, e-mail, or in-person communication.

•Supported over 2000 users

Lotus Interworks Inc., Piscataway, NJ

02/2001 - 05/2001

Trouble Desk Operator

•Worked cohesively with the technical, sales, marketing and other groups within the Company and the Company's affiliates.

•Set up and administrated User and Group Accounts.

•Implemented user rights.

•Installed and configured network printers and network protocols.

•Managed files, implemented data security procedures and performed backups.

•Installed and supported MS Office Suite

•Implemented NetWare connectivity.

•Managed clients and performed downloads and upgrade to keep software current

•Followed up on and resolved open trouble shooting tickets.

•Exclusively supported 100 local and remote network users.

Bloomfield College, Bloomfield, NJ

10/1999 - 02/2001

Technical Support Specialist

•Implemented a small peer to peer network,

•Performed hardware upgrades (memory, NIC), networked printers, installed software and drivers.

•Created and maintained system policies/profiles, users and other security for end-users.

•Installed and configured applications (MS Office 97/2000, McAfee Virus scan, I.E. 5.0/5.5, Adobe Photoshop 5.0, Norton Utilities 2000 etc.)

•Created user image by using Ghost v.5 program.

•Performed troubleshooting and diagnosed daily problems and attended to them in a quick and timely a manner to minimize downtime.

•Supported over 200 users.

Information Products, Parsippany, NJ

06/1998 - 09/1999

Field Service Technician

•Provided hardware, software and network support for company's client accounts including Morgan Stanley, Computer Horizons, Jersey City Medical Center, Hackensack Medical Center and a long term project for ADP.

•Installed and configured operating systems including Dos 6.22 Windows3.x, Windows95, Windows98, WindowsNT workstation/server and Novell 3.12 client/server.

•Setup and configured office applications including MS-Office97, Norton Utilities8.0, Seagate Backup Exe7.0, pcAnywhere 8.0, Ghost v.4/v.5, McAfee Antivirus and Norton Antivirus.

•Performed hardware upgrades, setup, installations and troubleshooting of CD ROM's, hard drives, NIC cards, modems, ram, video cards and peripherals on desktops, laptops and servers from IBM, HP, Compaq, Toshiba, AST, Sony, Gateway and DELL.

EDUCATION:

Bloomfield College, Bloomfield, NJ June 2000 A+ Certification A+ Certified Service Professional

Chubb Institute, Parsippany, NJ June 1998

Diploma in Computer Science and Data Center Support

Contact this candidate