Business Analyst
Microsoft, Hyd. (via) Collabera Technologies
Total years of experience :17 years, 4 Months
• fixing the Task pane triggering issues
• Writing codes in XML to monitor Bing Answer Triggering responses
• Testing the code manually (test creation, compilation, and execution)
• Writing Alerts for the bing monitoring tests
• Probing the tests and fixing the errors
• Resolving the tickets raised on priority bases and fixing the alerts
• Working on Fact Answer (quick answer) and Task pane triggering issues
• Blacklisting / white listing the queries, Fixing the task pane collage image issues
• Doing Judgmental tasks
• preparing guidelines on each task and working along with Bing Entertainment and Editorial teams
• Preparing Management Reports and meeting the ETA’s of all the tasks assigned
• Preparing PowerPoint presentations
Progressive Digital Media is a company, producing premium business information analysis, research services and marketing solutions for senior level decision makers.
Doing Product Market Analysis & Reports
Doing Secondary Research (Value, Volume,
Brand Share & Brand presence and Distribution
Channel)
Constructing data sets, modelling data and
forecasting on the basis of qualitative and
quantitative factors
The extraction, processing and interpretation of
data sets into analytical output
Developing deep, expert, insight into the industry
and its consumers
Delivery of high quality analysis in the form of
written (PowerPoint and Word and excel)
business information reports
Providing confident and effective client support
through responses to client queries and requests
• Maintaining supplier hierarchies, adding new suppliers and mapping distributors for the existing suppliers
• Spend analytics by mining and filtering data, identifying saving opportunities for the hospitals
• Writing Oracle SQL queries, for data retrieval and analysis
• Exporting data in excel sheet and cleansing as per client specification
• Manufacturer and Vendor Master Maintenance
• New manufacturer and vendor names are regularly updated in the database with a unique ID while coming across Distributor Data, High Spend Data, Project Data and Contracts
• Generating Reports and updating to client
Project # I
Spend Analysis - Classification of Line item data to the UNSPSC and analyzing spend with respect to different dimensions available in data to provide wide range of spend visibility and Customized Analysis Reports
• Identify the Line of Business for the Supplier from
its Websites
• Working with customer to gather their Spend
Analysis requirements
• Perform data mining to identify potential saving
opportunities
• Invoice Data Classification - classify customer
invoice records by using UNSPSC (The United
Nations Standard Products and Services Code)
• Cleanse, Enrichment & Normalization - ensuring
that attribute values have the same
• Categorizing the suppliers based on its line of
business according to UNSPSC standards.
Project # II
Item Master Cleansing - Item master needs to contain the essential information to ensure that the right things are being purchased from the right vendor, and in the right quantities
• De Duplication - Remove the duplications in
items from within an inventory master.
• Standardization of item description - Enrichment
of item descriptions by identification of attributes,
120 char short description and complete long
description.
• Supplier Data Enrichment - map the client
supplier data to supplier records in the data
enrichment supplier base, providing parent and
company specific business risk information.
• Catalog Data Enrichment - classify, normalize
and rationalize the catalog information.
• Item category classification - UNSPSC, HCPCS.
Receiving SLIs(Shipping Line Instructions) from
Shippers,
Coding & Manifesting the Bill of Lading (B/L’s)
Creating Invoices, Auditing the b/l’s
Sending Proofs to the Customers & Releasing the
B/L’s
Daily interacting with the front office (New
Zealand & Australia) through Mails & chat. On
process related queries and updates.
Active participation in WRM & MRM (Weekly &
Monthly review meetings)
Quality feed-backs for the Jr. Associates of the
team on regular basis.
Generating MIS reports on daily and weekly
productions.
• Quality check for the data entered by Data Processing Executives.
• Providing reports of Scan responses to US clients.
• Performs a variety of routine and some non-routine analysis functions in accordance with standard procedures in general accounting, accounts payable or accounts receivable or other financial departments. Daily preparing Exceptional Reports while on Quality Check
• Upgrading of the database using Netterm & Exceptional Reports.
• Error rectification & maintaining standards of Quality as an important function of the Quality Department.
• Handling people management issues, Leaves management, Task allocation & explanation, Meeting deadlines with good quality as backup Team Lead.
• Preparing MIS reports on daily and weekly productions
•Maintain a daily attendance register, check for the employee entry, half day leaves, full day leaves and enters all the final details to calculate the daily pay of the employees
•Creating new Payroll accounts for new employees
•Making necessary revisions to existing accounts
•Calculating and preparing the accurate payouts for the employees
•Forwarding the payroll totals to the accounting department
•Attending to internal payroll audits
•Conducting seminars at various educational institutions about the need to prepare for competitive exams
•Identifying the seasonal advertisement requirements and designing the advertisement strategies
•Accounts maintenance and communicating with the head office through periodical MIS reports
(i.e., Attendance, Training Material requirements, Financial reports, and Additional equipment requirements for betterment/advancement of training methodology)