| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidate Candidate's Name
Cell: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLE Address: Street Address
|SUMMARY: |Experience in data analytics, retail analytics, web analytics-(reporting/implementation), human resource management analytics, businessprocess improvement, strategic management and strategic marketingmanagement in different industries.|EXPERIENCE/ INTERNSHIPS: |Dal-Tile - Dallas, TX 06/17 - Present Transportation Network Analyst . Transportation data analysis using SQL /SAP/Power BI/ MS Access . Data extraction from different transportation APIs using web scrapping . Lane predictive models (machine learning) using R. . Data visualization using power BI/ Dashboards creation/ Graph analysis/ Cluster Analysis . Dashboards creation/ reporting for Director International and Domestic transportation on weekly basis . Reports/dashboard creation for International and domestic transportation departments . Pricing models development/ contract administration . Performing transportation simulation efforts, evaluation and solution review process to implement efficient solution . Conducting network modeling exercise along with network cost analysis and productivity analysis . Transportation networking strategy and practices to create most effective supply chain solution . System enhancement and development based on department's business needs . Developing prototypes and models to predict impact of operation changesVerizon - Irving, TX 12/16 - 04/17Data Scientist (Contract) . 2 to 3 Voice of Customer related analytics projects provision to Director on Biweekly basis . Chat Analysis using sentiment analysis/ word cloud, topics generation (Clarabridge, Machine Learning Algorithms using Aster/Python/R) . Data analysis using descriptive and prescriptive statistics. . Recommendation Engines, Propensity and other probabilistic/classification models using Python/R/Teradata Aster . Data analysis/ Predictive modelling using Teradata, Aster, Python and R. . Data visualization using Tableau . Gather and merge data from various sources. Sources include SQL databases, analytics platforms like Tableau,ZLog and Operational Analytics using Splunk. . Website analytics tools Google Analytics, SiteCatalyst and monitoring tools like Dynatrace, Tealeaf etc. . Monitor web traffic, site conversions and funnels. . Work collaboratively to establish key performance indicators, benchmarks and targets across various projects. . Monitor and/or create new analytic dashboards to measure all digital properties and campaigns. . Manage, organize, and present findings. . Monitor and analyze effectiveness of new features and web site experiences . Communicate relevant business insights to managers and stakeholders . Drive the collection of new data and the refinement of existing data sources . Drive the process of designing, building, and rolling out big data solutions and models that deliver optimal product offerings . Analyze customer and market trends that impact business performance and recommend ways to improve outcomes . Interpret and communicate analytic results to analytical and non- analytical business partners and executive leadership in a relevant, crisp, clear and concise manner. . Develop analytical frameworks to facilitate strategic decision making and identify risks and opportunities . Utilize predictive and prescriptive analytics to drive business decisions and new product designsMichael Page USA- Stamford, CT 04/16 - 07/16Data Quality Analyst (Contract) . Execute data validation, data integrity, data profiling, data auditing using 2014 SQL Server (SSMS, SSIS and SSRS) . Writing queries, stored procedures, functions and views. . Implement data cleansing and data improvement initiatives . Perform daily monitoring of data feeds from various partners and coordinate correction of invalid, inconsistent or incomplete data . Troubleshoot data defects and anomalies and work with business users to determine best course of action for correction . Conduct root cause analysis and make recommendations to improve accuracy of dataBenjamin Moore & Co., Montvale, NJ 09/15 - 03/16Retail Application and Data Support Specialist (Contract) . Database query using tools such as TOAD, Discoverer, SQL, FTP, and working with an Oracle based application (Retail.net)
. System/data maintenance with emphasis on customer/inventory data. . Retail Data Analysis utilizing Microsoft excel/Multiple Databases. . Responsible to run pre and after inventory queries/SQL, communication with retail stores/companies within USA and Canada. (Worked on non- standard hours; late nights/early mornings/weekends as needed). . Generating requested excel files for Stores/Companies. . Responsible to answer/complete all retail data related requests for USA and Canada.Orange and Rockland Utilities, Spring Valley, NY 10/14 - 8/15Data/Excel Specialist- Gas Engineering (Contract) . Developing and updating/editing several Excel spreadsheets for departmental use by using Excel (V-Lookups, H-Lookups, Dynamic/Interactive charts, Pivot tables, Pivot charts, IF/SUM IF functions, VBA Tools etc.) As per management need and on weekly/monthly basis (Extensive Vertical and Horizontal communication/research required to update spreadsheets) . Developed/updated/edited Excel spreadsheets to gather information related to Gas Engineering projects in Rockland and Orange Counties in NY. . Worked on 10-15 Excel spreadsheets at the same time to keep department operations running smoothly using complex Excel Formulas e.g., V- lookups, H-lookups, Pivot tables, macros, Pivot charts, IF Formulas, Chain IF Formulas, and Sum IF Formulas etc. . Worked on Gas Engineering procedures, standards, and manuals with Section Manager to keep organization in compliance with Public Service commission . Managed/organized departmental deliverables and reminders for Gas Engineering Team . Exporting reports from Oracle (Business Intelligence) and developing customized excel reports as per management need and on weekly/monthly basis. . Updating/Editing Financial and Gas Engineering SharePoint. . Working with Section Manager/Team Members on daily basis to help department meet organizational/Public Service Commission (PSC) deadlines . Sending reminders to team on weekly and monthly basis so that department meets Organizational/PSC deadlines using Action Tracking System (ATS) and Microsoft Outlook. . Working on Microsoft Visio (Develop Visio Project Diagrams) to help Engineers . Filing old documents to Iron Mountain as per Organizational Procedures (it requires rigorous communication and effort within the department) . Departmental monthly and yearly meeting arrangements (drafting emails, sending invitations after looking at schedules of all the participants on outlook calendar, communication with external consultants, communication with printing/drafting department to get documents printed for the meeting and conference room reservations) . Post meetings communication within the organization to get Assessments/Questionnaires done, which kept organization in compliance with Public Service Commission . New employees/interns departmental orientation (handing over employee handbook, explaining procedures and coordination with IT to get their desks setup) . Ordered supplies for the department/inventory count . Miscellaneous tasks as per Manager/Team requests.Benjamin Moore & Co., Montvale, New Jersey 7/14 - 9/14Jr. HRIS Analyst (Intern) . HRIS database maintenance and routine analytical audits (Using complex Excel formulas and tools) . Focus on compensation, employee classifications, employment status, organizational structure and/or benefit data as directed . Assist with design, testing and implementing various HRIS projects, e.g. creating new vender data files, building import layouts, system configurations, software customizations, etc. . Prepare reports, graphs, charts and use statistical analytics to support the Human Resources department and other internal-external customer . Performed all the data analytics and reporting on Benjamin Moore`s medical plans outsourcing project with Sr. Benefits Administrator (Brian Connolly) from beginning to end. . Worked on Benjamin Moore`s Human Capital Management outsourcing (Bid`s project) with National HRIS/Payroll Manager Paul Smith and Human Resource Director, Liz Edwards. . Developed "GANTT CHARTS- Microsoft Excel-Visio" for project management/deliverables. . Worked with HR Managers for assistance in HR- Scorecard analytics . Worked on Attrition reportsBenjamin Moore & Co., Montvale, New Jersey 8/14 - 9/14Demand Planning (Intern) . Development of forecasting models for demand planning using excel (advanced formulas, macros and pivot tables etc) . Monthly demand forecasting at SKU, product group and Brand level. . Monthly demand forecasting accuracy and error estimation at SKU, product group and Brand level. . Promotional analysis for all the promotions at Benjamin Moore.PSS World Medical, Fairfield, NJ 3/13 - 10/13Accounts Receivable Representative . Cash applications/ Write-offs, check/credit card refunds and applying credits. Helping collectors with receiving calls in queue. Receiving payments over the phone and email. . Tax Exemption/ Handling Credit Applications . Sending statements to customers/ Manual POS and updating POS . Sending final demand notice, declined POS and applying Unapplied Cash (RUs)/ Monthly Bad debt Audit . Lean Training/Test completion . Lean Six Sigma Green Belt . Worked with more than 3500 Accounts in States of New York, New Jersey, Pennsylvania and Connecticut on daily basis. . Mastered JD Edwards (One world) (Accounts Receivable portion)Imzada, Paramus, New Jersey 6/12 - 8/12Web Analyst (Intern) . Excel Dashboards development (Using complex Excel Formulas and tools/ SPSS) . Client KPI Development and Monitoring . Web analytics, competitive intelligence, voice of customer, etc.) to understand visitor behavior and improvement opportunities . Actionable Recommendations | A/B Multivariate Testing . In-depth analysis of website reporting performance . Introduced Predictive Analytics in the company using SPSS and Excel: Forecasting, Correlation, Regression/Multiple Regression, etc. . Worked with the team of 5 consultants and achieved all milestones on time during various web analytics/web improvement projects (Used "GANTT CHART-Microsoft Excel-Visio" for project management)|EDUCATION: | . MS Organizational Development and Leadership Nyack College, Nyack NY (CGPA 3.89 out of 4.0) 2014 - 2015 . MBA (BUSINESS ADMINISTRATION) - Forman Christian College (A Chartered University), Lahore, Pakistan (US Equivalent- 72 Semester Credits of undergraduate degree in Business Administration) 2007 - 2009 . M.Sc/B.Sc Mathematics - Forman Christian College (A Chartered University), Lahore, Pakistan (US Equivalent- Bachelor's Degree in Mathematics) 2003 - 2007|SKILLS: | . Expert in Microsoft Office Suite and SPSS: (Microsoft- Visio, Visual Basic, Outlook, Excel (Pivot Tables, V-look ups, H-look ups, Macros, Grouping etc.), Microsoft Word, Power Point, Internet) . My SQL . Hive . Unix/Linux . Python (Scikit-Learn) . R . Machine Learning/ Statistical Learning . Fedora AMI-AWS . Oracle (Business Intelligence) . Oracle based application (Retail.net) . Tableau . Power BI . Toad . QC - HP Quality Center Defects . Jira . Aster . Teradata . Clarabridge . IBM Tealeaf . Google Analytics/Site Catalyst Omniture . Ceridian/ ADP/ Citrix (ERP)/Ultipro . Action Tracking System (ATS) . SOX (Sarbanes-Oxley Act)/ QuickBooks . Calarabridge, Machine Learning . SAP . Data visualization using Tableau, and Analytical framework |