Nikita Bharali

Email: adsl31@r.postjobfree.com

Ph#: 469-***-****

SUMMARY:

* ***** ** ************ ********** in Data Analysis, System Analysis, Development and Testing in various industries

(Mechanical, Automotive, Finance, Insurance and Hospitality Domain) executed in Client/Server and Data Warehouse environments.

• Data Analysis using tools like MS Excel.

• Reporting and Quality Control

• Product Information Processes

• Data Entry

• Inventory Management

• Good understanding of Software Development Life Cycle (SDLC).

• Experience on working with office applications like MS-Word, MS-Excel, and MS-PowerPoint.

• An excellent team member with an ability to perform individually and interpersonal relationship, good communication skills, hardworking and high level of motivation.

TECHNICAL SKILLS:

Languages/Technologies HTML, PHP, C, Visual Basic, Pig Databases SQL Server 2005 and 2008, MS Access, MySQL, Hadoop and Big Data Software Packages MS Word, MS Excel, and MS PowerPoint Tools SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) PROFESSIONAL EXPERIENCE:

W.W. Grainger Aug 2021 – Mar 2022

Product Information Analyst

• Responsible for performing product information activities such as data analysis, editing, applying updates resulting from normalization, technical content support and other teams related to content issues, and ensuring the consistency of product information.

• Responsible for cleaning, maintaining, and normalizing product information based on the priorities and using defined processes.

• Participate in PI team projects and discussions.

• Work with peers and multiple partners supporting overall merchandising projects.

• Analyze and address data content, consistency, and Taxonomy issues. Analyze the best way to implement within the product information data model.

• Responsible for executing addition, changes, and deletion to the Taxonomy structure.

• Support new product introduction and maintenance processes for product information.

• Review product information for accuracy, completeness, and consistency.

• Responsible for responding to and act on customer feedback about product selection and data accuracy. MISUMI USA Feb 2019 – Aug 2021

Product Information Specialist

• Responsible for providing PIM templates to external team; upon return data cleanse and load to internal PIM system.

• Responsible for finding and fixing any technical errors preventing returned templates from loading to the PIM system

• Responsible for maintaining a high standard of complete and accurate product information, specifications and attributes

• Collect new product proposals from different vendors for product line expansion. Based on the proposals, data are built in the systems.

• Quality control of new items by reviewing finished product pages with Product Management team prior to publication.

• Create, distribute, and maintain weekly reporting on volume of successfully added products to the catalog in order to provide a comparison of projected time versus how long it really took to add those products.

• Collect, consolidate and manage product data associated with Bill of Materials.

• Develop custom reports in MS Excel through online research and sales data to showcase new supplier and product opportunities by customer account and customer segment.

• Work with internal customers (sales, procurement, engineering departments) for producing successful Bill of Materials project outputs.

• Obtain quotation from suppliers and register the product data in the system for generating the sales. Robert Half Sep 2018 - Feb 2019

Associates (Temporary Assignments)

Worked on below temporary positions for multiple clients;

• Data Entry Operator: enter survey data from paper to web application.

• Inventory Management (2 assignments): manage new and existing inventory of one of the biggest retail chains. Bohniman Systems Pvt. Ltd., Guwahati, Assam, India. Apr 2014 – Apr 2015 Data Migration Analyst

Project: Back Office Operations and Technology Services

• Requirements Analysis.

• Assisted in designing, planning and managing the data migration process.

• Worked on SQL Servers (2005 and 2008) including writing SQL queries.

• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.

• Data Analysis: Performed source system data analysis to manage source to target data mapping, Oversee and ensure a gap analysis for any missing or archive data. Winsofts Exports Pvt. Ltd., Guwahati, Assam, India. Nov 2009 – Apr 2014 SQL Developer

Project: Portfolio Accounting System and Data Migration for an Independent Broker/Dealer

• Interacted with customer/users and understood their requirements for data migration needs.

• Requirements Analysis.

• Worked on SQL Servers (2005 and 2008) including writing SQL queries.

• Created, maintained, optimized stored procedures, database and ETL process.

• Data Migration: Transactions extract from advent, mapping products based on security type and symbol, loading transactions and ensured the accurate filling of intermediate data tables during data load.

• Import/Export of data using MS-Excel

• Data Analysis: Performed source system data analysis to manage source to target data mapping, Oversee and ensure a gap analysis for any missing or archive data.

• Reconciliations: Reckoned positions at position file dates.

• Project Account Management (Invoice Management).

• Operations Management.

EDUCATION:

Bachelor of Engineering (B.E)

North Eastern Hill University (NEHU), Meghalaya, India. 2006 - 2009

Contact this candidate