PROFESSIONAL SUMMARY

* ***** ** ************ ********** of interpreting and analyzing data to drive successful business solutions. Proficient knowledge in statistics, mathematics, and analytics. Excellent understanding of business operations and analytics tools for effective analysis of data.

DATA SCIENCE

Technical expertise in data models, database design development, data mining and segmentation techniques.

Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, and SAS)

Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

Experience in building and optimizing ‘big data’ data pipelines, architectures and data sets.

Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.

Experience in supporting and working with cross-functional teams in a dynamic environment.

PROJECT MANAGEMENT

Strong Experience using project management tools of JIRA, MS Project, MS Access, Kanban, Gantt Chart, Agile Methodologies, and SCRUM.

Experience of Planning and coordinating through all phases of SDLC

Exceptional collaborator adept at bridging the business and technical needs with very strong management and communication skills.

Successfully delivered multiple projects with tight deadlines in short time frames.

Strong skills in team building and management, communication and presentation, conflict resolution, as well as inter-department and executive client relations.

EXPERIENCE

POSTAL ADVOCATE, MASSACHUSETTS, USA

DATA COORDINATOR AND ASSOCIATE ANALYST (FULL-TIME, REMOTE)

JUNE 2019 – PRESENT

Postal Advocate helps companies manage their mailing processes and look for best practices to optimize operations and reduce spend.

Used advanced Microsoft Excel to create pivot tables and pivot reporting, as well as use VLOOKUP function and Excel functions.

Conducted reports for implementation of marketing strategies, leading to 60% average equipment savings.

Managed a team of analysts to analyze the postal delivery data for various clients.

Presented findings and data to team to improve strategies and operations.

Proposed solutions to improve system efficiencies and increase client savings by $59M.

Participated in locating/defining new process improvement opportunities based on the gathered data sets.

Coordinated plans, deliverables, and issues between al internal stakeholders and clients.

Conducted research and evaluation of vendor solutions and manage relationships.

Verified, standardized, and maintained database (Manual look-ups at times).

Reviewed and updated client database to ensure data quality, consistency and accuracy.

Generated and analyzed routine and ad hoc reports to assist with client database applications.

Tools and skills: Jira, SCRUM, Agile, Kanban, Navicat, MS Excel, enterprise Advocate Dashboard, Interactive Dashboard, Data Analysis, MS Excel and macros, Pivot table, Lean, Tableau, SQL, ETL, Share point.

IERAX ANALYTIX, ATHENS, GREECE

DATA ANALYST (INTERN, REMOTE)

JAN 2019 – MARCH 2019

Lead and Managed on understanding the business scope, business goals and the deliverables of the project for predicting the future profits of a supermarket in Athens neighborhoods with one-year data from 3 other supermarkets (1.05 million entries).

Responsibilities:

Used quantitative data gathered to develop an understanding of customer behavior, demographics and lifecycle.

Investigated and conducted study on forecasts, demand, and capital for products.

Acted in the capacity of a project manager by facilitating analysis, organizing daily standups, and monitoring project progress using Kanban and Gantt Charts.

Analyzed and then effectively strategized regarding business goals, deadlines, scheduling, budgets, needed resources, and team member coordination.

Managed a team of 4 analysts across multiple locations to successfully provide the deliverables to the client in Greece.

Performed complex analysis such as trend analysis what – if analysis and forecasting using Supervised ML Algorithms (Python Language).

Organize, extrapolate, and disseminate data across departments to be used for drawing conclusions about the success of current methods.

Provided recommendations thorough succinct data to support suggestions and obtained accuracy of 93.67%.

Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis in Tableau for Sales Marketing, Business Analysis and Strategic Planning.

Tools and skills: Gantt chart, Kanban, MS Project, Python (Anaconda), Jupyter Notebook, Tableau, Interactive Dashboard, ML Algorithm, MS Excel, ETL.

AAKARSOFT TECHNOLOGIES, INDIA

PROJECT MANAGER

JUNE 2016 – JULY 2017

Aakarsoft has set a benchmark for quality products and dependable performance in its core focus areas of web designing, website development, application development & graphic design. Worked in a team of 7 engineers (frontend and backend) to develop and deploy multiple website projects simultaneously.

Responsibilities:

Managed an interdisciplinary team to achieve project milestones using PERT/CPM.

Collaborated with development teams to plan project sprints.

Developed status report, cost estimation, and resource plan using MS Project.

Worked in cross functional environment and derived decisions using PDCA methodology.

Implemented and maintained development best practices.

Monitored workflow and made timeline adjustments as needed using Gantt Chart.

Worked in all phases of Software Development Life Cycle in an Agile Environment.

Advised Upper Management on technology, marketing and design.

Performed scheduling, budgeting and accounting, and resource management.

Communicated problems and progress to upper management via engaging and artful presentations.

Tools and skills: Gantt chart, Kanban, Agile methodology, SCRUM, MS Project, PERT/CPM, PDCA, Network Diagram, Stakeholder matrix, check sheet, network scheduling, resource allocation.

KIRAN HOSPITAL, INDIA

DATA ANALYST

JULY 2015 – MAY 2016

Balanced simultaneous requests for data analysis and synthesis compiled of multiple internal and external sources including market data, patient origin, and financial outcomes for the Health System, Medical Group, Strategic Services, and Hospital Administration for data entry of approximately 5000 patients and 200000 Transactions.

Responsibilities:

Participated in collecting, organizing, and interpreting data along with fellow colleagues.

Coordinated with doctors for data cleaning and variables selection to ensure data clinical meaningful and analyzable.

Participated in extraction, aggregation and quality assurance of data from multiple sources in support of performing operational reporting, client reporting, and quantitative analyses of utilization and healthcare costs.

Applied knowledge of SQL table joins, DDL, DML, pivots, views, constraints, and functions to Microsoft SQL Server 2008.

Used Microsoft Access 2010 to link with SQL Server 2008 database in creation of multiple internal/external reports.

Developed and enhanced several strategic models to assist in long term planning of the health.

Managed the planning and development of design and procedures for metrics reports.

Practiced transforming reports into interactive business intelligence dashboards using Tableau software for data visualization purposes.

Demonstrate high proficiency with Microsoft Excel including charts, pivot tables, VLookup/HLookups, and other excel functions

Used statistical techniques for hypothesis testing to validate data and interpretations.

Tools and skills: Gantt chart, Agile environment, Tableau, Python, ML Algorithms, MySQL, MS Access, Dashboard, MS Project, Six Sigma, My SQL, Performance measuring parameters.

NMIMS UNIVERSITY, INDIA

ASSISTANT PROFESSOR

AUG 2014 – JUNE 2015

Taught undergraduate level courses - Algorithms and Data Structures, and Object-Oriented Programming.

Responsibilities:

Oversaw student progress with class projects (Diploma class size: 73, Undergraduate class size: 69).

Planned the deliverables of class based on the Program objectives.

Worked with colleagues to update teaching modules.

Implemented an updated grading system and provided feedback to each student.

Attended periodic seminars and conferences to remain updated on technology trends.

UPASANA AGRAWAL

640 19th Avenue,

San Mateo, CA 94403.

T 505-***-****

E adbyrk@r.postjobfree.com

www.linkedin.com/in/upasana-agrawal

PROGRAMMING LANGUAGE

SQL

PL/SQL

Python (Pandas, numpy)

DATABASES

My SQL

MS SQL Server

PostgreSQL

Oracle

BI TOOL

Tableau

MS Excel

MS Access

Power BI

Qlik Sense

Google Analytics

ANALYTICAL TECHNIQUES

Machine Learning

Classification

Clustering

Regression

Predictive Analysis

ETL TOOLS

SSIS

Talend

Toad Data Modeler

EDUCATION

Master of Science – Informatics (GPA: 3.90/4.00)

Northeastern University, Boston, USA

Master of Technology – Computer Engineering (GPA: 3.50/4.00)

NMIMS University, India

Bachelor of Technology – Information Technology (GPA: 5.47/6.00)

S.N.D.T. University, India

Contact this candidate