Data Analyst It Business
Resume:
Giorgi Gamkhitashvili
IT Business & Data Analyst - Project Lead (NY, 11204) *********************@*****.***
IT Business Systems/Data Analyst with 10+ years of project management experience serving as a liaison between business needs and technology. Proficient in translating complex requirements into standardized messages and managing the entire requirements process, from user interviews to technical documentation and user story creation. Business acumen and adept in agile methodology. Experience in evaluating and optimizing business processes. Ability of analyzing large databases to generate new information using Excel and importing it to specific systems. Proficient knowledge of ERP (TEMS) Calero, Power BI, Jira, Visio. Effective writing and communication skills.
Authorized to work in the US for any employer
Work Experience
IT Business Analyst - Data Analyst
FedEx Remote (HQ – Memphis, TN)
June 2022 to July 2024
Processed high number of invoices in the range of $5 - $20M in TEMS Calero – Inventory Build Queue
Built, updated, and coded more than 1M telecom circuits for different product types in ERP TEMS Calero
Mapped data across 15 product types with 20 different features each for 2M inventories. Analyzed 2M inventories, corrected / reflected all features in ERP TEMS Calero.
Analyzed expense trends of 2M inventories using Excel
Led project to approve new FedEx site on GPS, coordinated with the official representatives of the state of Georgia, so that vendor could verify it and send a technician to install the circuit.
Effectively used Agile methodologies while installing circuits across company sites in United States and Canada
Disconnected more than 5,000 various types of circuits across all FedEx locations in USA & Canada - Order form creation, and submission.
Active communication with vendors like Verizon, ATT, Cogent, T Mobile, Granite during invoice processing and on other projects.
Analyzed inventory expenses with total amount of $300M and followed vendors for disputes and resubmission processes.
Managed SIP and ported more than 2,000 POTS lines from one vendor to another. Reflected all ported lines in ERP TEMS Calero
Mapped data for building and coding 2000 Broadband circuits with 110 column each
Created order forms for porting lines from one vendor to another and communicating with vendors for ongoing status of project
Ported more than 500 Fax Line: Order form creation > Submission > Leading Project > Reporting
IT Business Analyst/Project Lead
STELLANTIS Remote (HQ Detroit, MI)
May 2022 to August 2023
Led project for testing 38 Penta interfaces related to procurement department of STELLANTIS before migration to SAP.
Successfully executed functional and nonfunctional requirements through Jira with IT team.
Led cross department communication and covered area: United States, Europe, South America, India, Canada
Elicited and gathered requirements from stakeholders - transformed them into small user stories using agile methodology.
Made BRDs/FRDs and managed processes of functional and nonfunctional requirements execution in procurement reporting tools like Cognos and QlikView
Used Jira effectively for processing and controlling the progress of user stories.
Documented technical requirement for migrating Purchasing Departments commodity codes from 6 digits to 4. Documented interface testing requirements
Evaluated suppliers’ performance like cost, quality and sustainability metrics.
Business Analyst/Data Analyst
PMO Business Consulting (Tbilisi-Georgia)
June 2013 -March 2022
Visualized and optimized SL company's operational processes utilizing Visio.
Proven track record of using Data validation and mapping techniques to analyze current market trends in mining sector of Georgia.
Forecasted sales volume for each product/service and hotel room using Excel.
Proven track record of creating business plan for dairy product manufacturing company Agrocom, based on that company received $1.5M of funding.
QA: Conducted thorough testing to ensure the reliability and effectiveness of the implemented solutions from an end user view.
Education
Master of Business Administration in Operations Management
FREE UNIVERSITY OF TBILISI 2015 - 2017
Bachelor of Business Administration in Business Administration
DAVIT AGHMASHENEBELI UNIVERSITY OF GEORGIA 2007 - 2011
Skills
•Business analysis
•Operations management
•BPMN
•Visio
•Project management
•Jira
•Microsoft Excel (Advanced)
•Systems analysis
•Application development
•Data visualization
•Data Modeling/Mapping/Mining
•Microsoft Outlook & SharePoint
•Business requirements gathering
•Agile
•Waterfall
•Power BI (3 years)
•Microsoft PowerPoint & Word
•Supply chain management
•Market Analysis
•Forecasting
•Pricing
•Budgeting
•Product development
•Tableau (3 years)
•Time management
Certifications and Licenses
Driving License
December 2022 to September 2026
www.linkedin.com/in/giorgi-gamkhitashvili-3a7a4a156/
Contact this candidate