SUMMARY

• Over 8 years of experience as a Data Analyst interpreting and analyzing data to drive successful business.
• Complete understanding of Software Development Life Cycle (SDLC) involved in various phases like requirements, analysis/design, development, and testing.
• SQL Server and My SQL certified professional with expertise in writing complex queries along with data extraction and normalization.
• Worked as a Data Analyst in Unilever using SAP, SQL and Microsoft excel, Key contributor in leading multiple cross functional groups including Customer Development, Supply Chain, R&D and Brand Teams to identify, to drive innovations and facilitate data management activities for new product innovations.
• Worked as a Data Operational Analyst worked with all data types across the enterprise and serving as key liaison between IT, Sales, Finance and Marketing departments for managing stakeholders.
• Worked as a Data Analyst in Race Academy, worked with multiple databases to record and report student admission data.
• Strong working knowledge in SAP GDS and understanding of the data management processes including established linkages with SAP ECC, SAP MDM, SAP GDS
• Expertise in data management best practices, interpretation, and usage of GTIN/GS1 standards and all GDS requirements and validation rules.
• Advanced Microsoft Excel for Data Analysis certified professional with proficiency in handling huge amount of data and mining crucial and relevant data using advanced techniques like VLOOKUP, HLOOKUP, Pivot Table and Macros.
• Highly proficient in MS Access, SharePoint, PowerPoint, Microsoft Project and database tools such as SQL Server Management Studio (SSMS), MySQL Workbench and Visual Studio 2017 including the ability to analyze, summarize and manipulate large volumes of data.
• Proficient in designing interactive dashboards and reporting insights and trends using Tableau and presenting insights to managers and other staff members.
• Performed data analysis and data profiling using SQL on various sources systems including Oracle and MySQL.
• Proficient in Logical Analysis, Regression Analysis, Pattern, and trend identification.
• Well versed in Lean Principles, Agile Model, Waterfall Model and Software Development Life Cycle (SDLC).
• Proficient in gathering and converting user requirements into Business Requirements and Functional Requirement Specifications (FRS).
• Experienced in creating and implementing interactive charts, graphs, and other user interface elements.
• Experienced in mapping business requirements, designing customized solutions with strong analytical skills.
• Excellent knowledge in preparing required project documentation and reporting regularly on the status of projects to all project stakeholders.

TECHNICAL SKILLS

Product Marketing: Product Launch, Marketing, Strategy, International Strategy, Project Management, Innovation, Business Analysis, Requirements Gathering, Change Management, Technology and IT for Managers, Management Consulting

Process Improvement: Lean methodologies, Six Sigma, 5S, KANBAN, Kaizen, Quality Control.

Statistical Analysis: Pivot Tables, V - Lookup & H-Lookup, Validation, ANOVA test, Regression test, What-if Analysis, Solver

Software/Tools: Visio, ARIS, Smart Draw, Lotus Notes, Quick Book, MS-Access.

Programming Languages: MS SQL, MySQL, C++, Angular JavaScript, Python Tools MS Excel, VBA, JDA, MS Project,XLMiner.

Software Suites: Responsys, Google Analytics, AdWords, Photoshop, Adobe creative suite

Operating System: Windows.

Documents & Processes: Use Cases, Business Process Modelling, Project Planning & tracking.

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Coordinated with business analysts to deeply analyze the business requirements from end-to-end perspective.
• Participated in periodic meeting to discuss data cleansing activities.
• Collected, cleansed, and interpreted large data sets, conducted reports, and performed accurate and successful data management.
• Created dashboards and interactive charts using Tableau to provide insights for managers and stakeholders and enabled decision-making for market development.
• Collaborated with senior management teams to prioritize business requirements and define opportunities for process improvements.
• Used SQL and Tableau for data screening and reporting.
• Responsible for writing & Editing Stored Procedures, Triggers, Views, Tables & SQL Scripts.
• Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures, and triggers.
• Performed optimization of query, triggers, and stored procedures, their testing focusing on stability and execution plan which has resulted increase in performance of numerous modules.
• Created datasets for reports using SQL and stored procedures.
• Responsible for Query optimization and Performance tuning.
• Created functions and developed procedures for implementing application functionality at the database side for performance improvement.
• Created packages and scheduled it to get data from OLTP, Created Stepped and Block reports using SSRS.
• Designed, developed, and implemented BI solutions using Tableau for marketing strategies.
• Managed multiple project tasks with changing priorities and successfully met tight deadlines.
• Presented findings to the management as well as other members of the staff (internal and external) by creating presentations using MS PowerPoint.
• Designed and presented weekly, monthly, and quarterly reports with the information gathered through the analysis performed.
• Involved in onsite & offshore coordination to ensure the completeness of deliverables.

Confidential, Richmond, VA

Supply Chain Data Analyst

Responsibilities:

• Provided end to end analytics solutions across Supply Chain to improve Visibility, Performance & Processes.
• Used aims grid to define problem and define strategy to tackle the problem.
• Gathered required data and performed data analysis to support business needs and anticipated clients' future and ongoing needs.
• Worked closely with Application Developers and Business Analysts to produce all required documents.
• Performed market analysis with the use of tools such as Power BI, Tableau and Kibana.
• Created inventory trends, sales integration and forecast accuracy related dashboards.
• Trained Teams/functions to achieve the self-service BI culture.
• Managed projects to create tools, dashboards & reports to make data actionable.
• Enabled business to democratize data & foster the data-driven culture.
• Enabled standard metrics and data sets across functions by a detailed understanding of supply chain processes.
• Helped the organization to find and enhance Data Analytics capability through several initiative.
• Trained teams to unleash analytic potential through training sessions and workshops.
• Provided SCOR (Supply Chain Operational Reference) training for internal and external departments to bring an aligned understanding of supply chain.
• Analyzed business requirements, system requirements, data mapping requirement specifications and assisted with documenting functional and supplementary requirements.
• Presented findings and proposed solutions to boost system efficiency and reduce expenditure within the warehousing department.
• Worked closely with the marketing and business intelligence teams to make sound decisions on how to covert information gathered from data analysis into improvements in business strategies.
• Used statistical models to correlate various data sets which assisted in the improvement of business actions.
• Generated reports using Excel and Tableau on a weekly, monthly, and quarterly basis about the efforts impacted business trends and improvements.

Confidential, Itasca, Illinois

Supply Chain/Logistics Analyst

Responsibilities:

• Support Commodity Leader in developing category strategy with commodity research, planning & forecasting material requirements, Supplier Savings & commodity Roadmap, cost driver analysis, cost models and RFQ/RFP development, financialand ad hoc reporting,etc.
• Work on developing RFQ/ RFP, running bids, analysis of bids and sample development for NPI.
• Provides frontline support for daily logistics operations, resolves issues and ensures on time delivery of products
• Identifies and analyzes root causes of issues and works with logistics partners to develop solutions and performance improvement measures
• Project manage the supplier transition projects, by coordinating with manufacturing plants, suppliers, keep a check on inventory through ERP and quality folks for GMP.
• Support Commodity leaders with initiatives related to Pay Terms, Supply Risk mitigation, supplier consolidation & Rapid Sourcing through SAP& Material inspection after receipt of goods.
• Document and update Standard Operating Procedures (SOP) as needed.
• Negotiate with various shippers and logistics providers on best rates for shipments.

Confidential, Plano, Texas

Procurement Buyer

Responsibilities:

• Standardize purchase requests, streamline purchasing processes and gather data to support requests for preferred pricing from vendors through Salesforce.
• Read, analyse and interpret customer/project supplied schematics.
• Produce accurate and detailed bidding proposals for PCB assemblies and services like Labor, Material costing, Machine Assembly, testing, NRE etc. according to customer requirements mentioned in BOM.
• Purchase electronic and semi-conductor materials and parts (Resistors, capacitors, ICs, relays, shunts, wires, cable assemblies etc.) &suggest alternate parts for non-stocked / obsolete parts to support manufacturing and assembly.
• Check material and parts in stock through ERP.
• Assist QA with Returned Material (RMA) processing.
• Earned Value Management (EVM) Planning Support
• Maintain relationships with customers and potential customers (CRM) for creating and maintaining a loyal customer base.
• Reduces costs, increase efficiency and improve customer satisfaction.
• To manage the bid qualification (bid go / no go) process for new opportunities.
• Carry out expediting/progress duties in support of the business and update company business system (SAP) Manager and Engineering Production Manager.
• Learn and utilize new technology to drive root cause analysis and problem resolution relating to On-Time Delivery, Order Blocks, and other individual/team metrics.

Confidential

Category Buyer

Responsibilities:

• Procurement of bulk electrical item, mechanical, electro-mechanical items.
• Compile with contracts with regards to buying from correct suppliers and at negotiated prices.
• Develop and maintain cost models by commodities and suppliers, drive continuous improvements to yield productivity.
• Handling P2P process through SAP FICO, providing ideas for cost savings and business expansion.
• Assist in solving procurement discrepancies, working with Accounting, suppliers and other internal departments.
• Manage pertinent purchase activities and information regarding part shortages, RFP analysis alternate suppliers, and build and delivery schedules.
• Meeting with suppliers to discuss contracts, price negotiations, lead-time issues, open order status, etc.
• Prepare request for quotations/bid/proposal to support an effective competitive bidding process.

Confidential

Pricing Analyst

Responsibilities:

• Ensure timely review of the customer’s RFQ and distribution of specifications to relevant parties for their input.
• Work in conjunction with Global Sales Support, Process Engineering, and external vendors as required to ensure a fit-for-purpose product solution is developed.
• Post Order confirmation preparation of Work orders as per Purchase order and working on amendment as per customer or consultant’s request and work order will be pass it on through ERP application to next concerned Dept.
• Continually review freight costs, transportation rates, and/or the prices of raw materials to keep costs down wherever possible