| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Kirkland, WA PHONE NUMBER AVAILABLE EMAIL AVAILABLE LinkedIn: LINKEDIN LINK AVAILABLE OverviewSeasoned Business Analyst with over 10 years experience in Program Management, Project Management, Cost Analysis, Business Analysis, Financial Analysis and Data Analysis. Expansive knowledge in ETL, PLX Workflows, Dashboards and other visualization tools. Excel in process documentation and process improvement, gathering requirements and implementation of ERP System. Business Analyst experience: 10 years Financial Data/Financial Analyst: 2 years Program Manager experience: 3 years Project Manager experience: 2 years SQL query / Dashboarding experience: 8 years Excel/Microsoft Office Products: 23 years Industry Span: Ranging from global tech companies such as Google, Amazon and Microsoft to small-sized manufacturing firms and start-ups Function Area Span: HR Compliance, Compensation, Cost Analysis, Sales, Marketing, Digital Media Buying and Selling, Bookkeeping, Purchasing, A/R & A/PEducation Global MBA Strategic Management (GPA: 3.67) Reichman University, Israel, Graduated in 2012 Bachelor of Business Administration Finance (GPA: 3.78) graduated Magna Cum Laude, Reichman University in 2014 Technical Skills Software/Programs/Tools: PLX suite of applications (Dashboards, Workflows, Scripts), Cider-V, Critique, Workday, Asana, PopsConnect, QuickSight, Redshift, Workday, Salesforce, Hire, Priority, QuickBooks, CRM, LivePerson, Oracle BI, MS SQL Server, Visio, Dynamics GP, SQL Server Reporting Services (SSRS), Smart Connect, Putty, Google Analytics, Smart Connect, and Microsoft Office (Word, Excel incl. pivot tables, graphs & advanced formulas, Power Point, Outlook). Communication and Data Sharing Software: AWS S3 Bucket, Google Drive, SharePoint, OneNote, MiCollab and Own Cloud Programing Languages: SQL, Oracle SQL, VBA, HTML and Java Relevant ExperienceGoogle, Kirkland, USA Jan. 2023 May 2024Compensation Programs Analyst Managed compensation models for annual total compensation and promotion cycles. Improved workflow run time by stripping unnecessary nodes - saving 1 hour each day. Prepared Discretion Compensation analyses to support managers planning strategy. Maintained daily communication with partner team to validate completeness of data. Created detailed documentation of all variables, files and processes in order to drive efficiencies and minimize human error. Automated processes requiring manual inputs such as templates for backdated cases. Detailed oriented and excelling in QA (caught an error that had multiple-dollar impact) Used Asana as one of the project management tools to manage compensation programs. Managed and updated compensation budget utilization that was used by VP of Compensation and Benefits. Presented MY 2024 Promotion cycle sign off to VP of Compensation of Benefits that contained budget and spend analysis. Amazon, Seattle, USA June 2022 Dec. 2022Business Intelligence Engineer Utilized SQL to extract and analyze data from various databases for business insights. Employed BI tools to create interactive dashboards and reports for data-driven decision making. Maintained data and analytics ETL pipeline infrastructure to support automated WBR generation (Weekly Business Review slide deck) supporting Amazon Business executive leadership Provided bi-weekly business updates to ProServe leadership regarding new initiatives and projects. Amazon, Seattle, USA Sept. 2019 June 2022Business Analyst II Human Resources Risk and Compliance Generated reports to fulfill global governmental compliance obligations for multiple teams within PXT Compliance and Immigration department. As the SME and reporting support POC for PXT Compliance and Immigration department, supported numerous ad-hoc reporting and access requests. Spearheaded and led automation efforts of all global government reporting by creating Self Service Government Reports. Facilitated weekly meetings with key stakeholders, discussed timelines, confirmed requirements, conducted demonstration and feedback sessions, and recorded actionable items. Spearheaded and helped in the development and promotion of the Self Service QuickSight Dashboards, and Landing Pages Supported VP of Employee Services, in preparation of Employee Services Operational Call (ESOC) Paper by collecting inputs from all Service Area Owners. This paper was reviewed and discussed during the weekly ESOC call. Moreover, recorded and distributed actionable items from the meeting to a broader audience. Assisted in creating guides and metric definitions for ESOC Dashboards. The dashboards have generated over 37K clicks from their release in 2021 up to June 2022. Led the transition from PeopleSoft to HCM tables in Redshift as source for government reporting. This process involved mapping the data sources from PeopleSoft to Redshift, updating the SQL scripts and identifying gaps. Moreover, led weekly meetings between EEP and HCM teams until all gaps have been identified and addressed. Amazon, Seattle, USA (via contract) March 2019 Sept. 2019 Business Analyst II Human Resources Risk and Compliance Generated reports to fulfill governmental compliance requirements in support of Equal Opportunities and Affirmative Action Programs. Supported automation of governmental/regulatory reporting requirements using SQL scripts Gathered and prepared report requirements to transition EEP department from PeopleSoft to Workday, and supported development of Global Trade and Diversity teams report requirements Conducted gap analysis in the transition from PeopleSoft to Workday, facilitated weekly Workday implementation meetings and recorded actionable itemsWave Broadband, Kirkland, USA July 2018 Feb. 2019 Cost Engineer I Construction Project Management Spearheaded number of projects including Project Costing reports distributed weekly to regional VPs using Oracle system and SharePoint Provided support and guidance to the Cost Engineer and Executive Vice President on project performance Supported Cost Engineer with tracking and documenting of project budgets, actual costs, and forecasts Communicated with field staff, subcontractors, estimators, and accounts payable personnel regarding scope of work, purchase orders, invoices, and payments Assisted with cost-benefit analyses at project and program levels Supported execution of established project control processes and proactively identified opportunities for improvements King Electric Manufacturing, Seattle, USA March 2016 June 2018 Business Analyst / Sales Program ManagerBusiness Analysis/BI Project Management Managed development and self-generation of a wide range of ad-hoc financial and sales reports across all departments using VBA, SQL and SSRS Forecasted sales and purchasing, planning manufacturing production via MRP system Developed reports generating insights across wide range of BI functions including monitoring manufacturing capacity Supported implementation of new ERP system (Microsoft Dynamics) through spearheading integration of historical data. Researched new BI platforms and advising executives on purchase recommendations Maintained customer databases including validation of new account setups Created new company documents (including Credit App Application, and Customer Set Up Documentation) Lead development and implementation of various BI and IT projects, including: o New internal communication platform, SSRS reporting, SQL views and procedures, SharePoint sites o Sales, job quotation and inventory availability tools Sales Program Management: Managed Marketing Development Fund and Loyalty programs including drafting contracts, creating sales program policies, authorizing co-op advertisement expenses and rebates Developed and implemented marketing strategy, including orchestrating national trade shows and building online presence. Assisted in preparation of price lists and job quotations Created new company forms, contracts and sales presentations Managed email marketing campaign regarding product and operational updates to agents and clients Prepared and distributed monthly commission and ranking reports for internal and external customers Created sales reports and tools for the regional sales managers including territory maps, item inventory, project quote log, and contact listMicrosoft, Redmond, USA (via contract) June 2015 Feb. 2016 Financial Data Specialist Prepared ad-hoc financial reports and performed data validation Managed and ran SQL procedures for worldwide incentive compensation awards Maintained award-related daily communication with worldwide sales managers and salespeople Prepared departmental process flow charts Scheduled and managed team meetings, created training material and onboarded new team hire Bitcocktail Ltd/Wajamu, Herzliya, Israel Aug. 2014 - April 2015 Data Analyst, Monetization and Partnership Manager Provided performance analytics for various monetization types and presented the findings and recommendations to CEO, EVP, and VP of Business Development on a weekly basis Prepared various performance reports (including daily revenue projections) Conducted International Business Development (including representing Bitcocktail at ASE (Affiliate Summit East, NYC) and DMEXCO (Digital Marketing Exposition & Conference, Germany) Managed advertiser & publisher portfolio, including setting up new monetization and distribution channels and monitoring performanceDatomo Ltd, Herzliya, Israel Aug. 2013 - Aug. 2014 Data Analyst, Financial Coordinator, Media Buyer & Senior Campaign Manager Data analyst projects included development and implementation of campaign analytics tools for Global Media Department Initiated and led the design of a new Business Intelligence system for the company As financial coordinator, played a key role in Accounts Payable and Accounts Receivable As a media buyer, managed publisher relations including daily negotiations and accounts payable inquiries In role as senior campaign manager, provided training to new campaign managers Managed client portfolio, including setting up and monitoring campaigns Etoro Ltd, Tel Aviv, Israel Aug. 2009 July 2013Financial Project Manager/Bookkeeper/Accounts Payable Managed various projects in Finance Department, including developing and implementing cross-departmental procedures that included setting and monitoring all departments budgets, purchase orders and travel reimbursement Performed Accounts Payable duties including recording invoices and payments, and journal entries using Priority system. Maintained daily communication with suppliers and purchasers Assisted in preparation of quarterly and annual reports (including adjustment entries, etc) Reconciled bank statements, and reconciled petty cash transactions, recorded and reimbursed employees expenses Senior Customer Support Representative Introduced new customers to FOREX and indexes Trained and acclimated new hires to the organization. Facilitated communication improvements between marketing, sales and support departments on issues such as marketing campaigns, promotions and bonuses Content writing and maintenance of the LivePerson responses Communicated and aided traders to solve their accounting, technical and trading issues. Rainbow Sign Manufacturing, Toronto, Canada May 2005 - Sept. 2008 Procurement, A/R, Sales and Marketing Manager Supervised Sales, Customer Support, Accounts Payable, Accounts Receivable, Procurement, New Product Development, and Online Marketing Developed online marketing strategies to increase the companys market share in Canada and U.S.A. using Google campaigns. Managed companys marketing material such as product catalogues and fax advertisements Provided Cost-based estimations for sign manufacturing projects Assumed executive duties during CEO's absence, primarily overseeing production planning and daily operation |
