Data Analyst
Resume:
JANAM BHAUKAJEE
**************@*******.***
Irving, TX 75038
PROFESSIONAL PROFILE
- Industrial Engineering graduate with 10 plus years of work experience in Manufacturing, Retail, Healthcare and Supply Chain Management
- Worked extensively on Data Modelling, Simulation, Optimization and Productivity
- Experienced in Time Series Analysis for forecasting, Regression Analysis, Monte Carlo Simulations, Design of Experiments and Statistical Process Control
- Database Management, Updates and Reporting with SQL queries, SAS, MS Access, Process Automation with VBA, Dashboards, Sharepoint, HighJump, Red Prairie, CATAMARAN and also E-Commerce certified with SDLC
- Mentored interns and led cross functional teams for software and process implementation
- Trained clients and troubleshooted issues and documented business requirements and facilitated enhancements EDUCATION
Master of Science in Industrial Engineering GPA: 3.75 University of Houston, Houston, TX December 2014
Bachelor of Science in Industrial Engineering GPA: 3.02 University of Houston, Houston, TX December 2011
TECHNICAL EXPERTISE
SQL, HTML, CATAMARAN WMS, HighJump WMS, Red Prairie WMS, WINMAN WMS, MS Project, MS-Office Suite - Access, Excel, Word, Powerpoint, Visio, Sharepoint, AUTOCAD, ARENA, SIMIO, Python, IBM Cognos, I-DEAS, CATIA, C, BASIC, VB.NET, Python, MATLAB, FORTRAN, TORA, Google Sketch, E-Commerce Certified, Web Development, Six Sigma, Project Coordinator – Lynda.com WORK EXPERIENCE
Industrial Engineer - Sears Holdings Corporation, Garland, TX November 2016 – Present
- Develop and maintain an accurate and effective Work Measurement System. Ensuring effective productivity measurements for established identified job functions in the fulfillment center through time studies and frequency studies.
- Evaluate, maintain and subsequently revise best work methods flow for job functions.
- Analyze, recommend, and implement enhancements to existing work method flows and processes to increase throughput in Receiving, Putaways, Picking, Shipping.
- Train management and hourly workforce on productivity and work methods.
- Extensive use of Statistical Analysis and knowledge of Fulfillment Center Material Handling Systems.
- Track and maintain Red Prairie, HighJump and ProRep WMS applications for productivity reports.
- Develop new applications and tools as well as ad hoc and refreshable weekly reports to help with root cause analysis or to streamline related processes.
- Analyze and report on metrics and recommend ways to improve the efficiency and inventory control function.
- Create/Maintain/Organize Sharepoint platform for the engineering department documentation which also include front end customization and user access management.
- Develop solutions in Sharepoint which provide benefits for the end users and suggest and update creative page designs.
- Use Access and Excel with VBA and SQL extensively.
- AutoCAD and Database skills (Excel, Access).
- Develop and maintain distribution center and office area layouts and workflow in Red Prairie and HighJump.
- Collect data to assist in the development of distribution center and capital budgets.
- Analyze and provide cost justification on all capital project requests.
- Research technological advancement in material handling system to develop cost-effective improvements to operating methods and procedures to support purchase recommendations.
- Work effectively with external resources (consultants and contractors) as well as the internal clients
(Sears Holding fulfillment centers) to ensure collaborative partnerships to meet business requirements. Supply Chain Implementation Data Analyst – Shipcom Wireless, Houston, TX Feb 2015 – August 2016
- Extensively use Macros, Vlookup, Pivot Tables, Crosstab and other functionality of MS Excel and Catamaran ERP inventory and warehouse management software (Proprietary Shipcom Software).
- Design warehouses and inventory locations using Visio and Catamaran considering room measurement, Par-level of inventory and (Pegasus and ParEx) equipment’s.
- Analyze data using ABC data analysis to identify usage trends, deviations, inventory turns, and pathways for saving inventory dollars through PAR level management.
- Data cleansing and validation of national data and implementation of a system to track the inventory and set up the levels to promote smooth inventory flow and avoid stock outs.
- Create, design user interfaces, customize sites, user access management and web parts for SharePoint 2013.
- Work closely with supply chain departments to develop prototypes and mock-ups of sites and applications for review.
- Perform customizations to SharePoint sites using SharePoint designer and other approved tools.
- Work with customer and team to gather, analyze, and define business requirements, produce documentation and reports using Microsoft Office technology as requested by the customer.
- Work closely with clinicians and logistic personnel to make data based decisions, considering clinician practice parameters, and incorporate indicated changes into solution designs that meet the mutual needs of stakeholders across the spectrum.
- Organize meetings with clients to clarify problems and report findings and provide implementation timeline.
- Implement Quality Assurance and Quality Control and engage in customer satisfaction measures.
- Train the logistic personals and clinicians to new system (Catamaran) as well as the concept of Lean System (Kanban and ParEx Automatic system) and help them with issues.
- Work at various Veteran Affairs Medical Hospital (VA) locations across the US managing and collaborating with hospital personnel at various levels and develop ongoing process improvement within the operations process.
Graduate Assistant – Bauer College of Business, University of Houston, Houston, TX August – Dec. 2014
- Assisted and graded class of Business Modeling for Competitive Advantage.
- Coaching students towards understanding concepts of Supply chain, Optimization and Business Modeling. System Implementation Data Analyst – Shipcom Wireless, Houston, TX May – August 2014
- Understanding how different cabinet and shelving systems work for storage of supplies.
- Used MS-Excel to do the ABC analysis of the data that were provided by the project site.
- Making room design in Visio/AutoCAD and with Shipcom proprietary software tools.
- Collecting documents, pictures, annotations, report writing, documentation, presentation.
- Supervising supply room builders and giving them instructions to setup the rooms. Material Management Intern - Planet Investment LLC, San Antonio, TX January – May 2012
- Analyzed the cost for buying or repairing the materials for the restoration of the property.
- Developed the BOM, purchasing order for materials, expediting orders as needed and scheduled the delivery dates.
- Negotiated with manufacturer in the process of buying goods and materials for the restoration of the property.
- Assisted with purchasing order for materials, expediting orders as needed and verified delivery dates.
- Managed inventory and reorder point of key retail products. Store Manager – Phillps 66, Houston, TX February 2006 – January 2012
- Completed store operational requirements by scheduling and assigning employees.
- Maintained store staff by recruiting, orienting, coaching, counseling, monitoring, appraising and training employees.
- Supervised 10-15 individuals at a time.
- Scheduled expenditures; analyzed variances; initiated corrective actions.
- Identify current and future customer requirements.
- Ensures availability of merchandise and services by approving contracts; maintaining inventories.
- Formulated pricing by reviewing merchandising activities; determined additional needed sales promotion; authorized clearance sales by studying trends.
- Secured merchandise by implementing security systems and measures.
- Protected employees and customers by providing a safe and clean store environment.
- Maintained the stability and reputation of the store by complying with legal requirements, health and safety issues.
- Determined marketing strategy changes by reviewing departmental sales records.
- Contributed to team effort by accomplishing related results as needed. RELEVANT ACADEMIC PROJECTS
Active Asset Management System - M. D. Anderson Hospital, Department of Performance Improvement
- Studied and tested the Active Wi-Fi RFID technology from Aero-Scout Mobile View System.
- Documented test results to determine the adaptation of RFID technology for inventory assets management. Economic Evaluation of Real Estate Investment Project
- Detailed analysis of interest rates, economic equivalence, present worth analysis, future worth analysis, rate of return analysis, depreciation and depletion, taxation and inflation.
- Used Excel to compute and analyze the benefit of selecting each mortgage plan offered. Cougar Bus Line (University Bus System) – University of Houston
- Used the Integrated Job Analysis tool to study the Cougar bus line system to make it safer, reliable, predictable, and more beneficial to all users.
- Studied the factors affecting the bus schedule and provided effective recommendations. Simulation of Subway Restaurant and Cashier Station – Subway Restaurant, University of Houston
- Used Process Analyzer (PAN) and Opt Quest in the ARENA Simulation software. TRAINING AND CERTIFICATIONS
§ OSHA Hazard Recognition Training for General Industry
§ Privacy and HIPPA focused training
§ Six Sigma Green Belt Training
§ Lean Manufacturing
§ Value Stream Mapping
§ Project Coordinator – Lynda.com
§ E-Commerce Certified (JavaScript, Vbscript, HTML, CSS, XML)
§ SQL
§ Database management and System Development Life Cycle (SDLC) ACTIVITIES
§ Institute of Operations Research and the Management Science (Informs)
§ Institute of Industrial Engineers(IIE)
Contact this candidate