Priya M. Email & Phone Number

Brampton, On, Ca

Toronto, Ontario, Canada

Extracting, cleaning, transforming & analyzing large data sets from customers.Extracted, cleaned & transformed data using Python, SQL & ExcelAnalyzed marketing data sets to identify opportunities for Account Managers to transform them into actionable recommendations.Developed and maintained automated data pipelines for efficient ETL processes.Loaded data from websites using third-party APIs for pharma customers analysisCreated Dashboards using Power BI for communicating key insights to external & internal stakeholders & supporting key decision-makingConducted statistical analysis on large marketing datasets to identify trends, patterns, and correlations, providing valuable insights for process improvements.Collaborated with cross-functional teams to define data requirements, ensure data accuracy, and develop solutions for data-related challenges.Assisted in the development and implementation of data quality standards and procedures to maintain data integrity.Presented findings and recommendations to management and non-technical stakeholders in a clear and concise manner.Conducted analysis to find the impact of the campaigns in acquiring new customers, revenue, customer subscription to various services, and lifetime value

Toronto, Ontario, Canada

• Worked with different technologies: Python, Postgres SQL, Python APIs, MS Excel, VBA, JavaScript• Worked with different libraries in Python; Pandas, NumPy, Matplotlib; used R • Conducted data extraction, cleaning, and analysis of financial and health data for projects• Organized, analyzed, and interpreted data using software and different analytical tools• Used Flask, MongoDB, and Python APIs working with structured and unstructured data• Presented data in charts, tables, maps, reports, data dashboards using Tableau, Power BI• Used web display technologies, HTML, CSS, and JavaScript• Used GitHub repositories for maintenance of codes

Toronto, Ontario, Canada

• Followed up with managers, business owners in case of an outbreak• Created a contact list of the people present at the place of exposure• Created contact records in the medical software, CCM in Salesforce• Notified the contacts of their exposure, advised self-isolation as per the Public Health guidelines• Checked up with the contacts for symptoms and provided public health resources for follow-up

Toronto, Canada Area

Machine Learning ProjectAnalyzed credit data of customers and help the bank decide with regards to approving loansCleaned the data to remove the missing values and outliers and did Feature SelectionUsed supervised machine learning algorithms such as Naive Bayes, Random Forest, and Logistic RegressionUsed unsupervised machine learning algorithms such as Clustering and K-MeansEvaluated the model on the basis of accuracy,speed and error%. Used the results of the algorithm to make recommendations to the bankHiveUsed movies data-set. Created databases and tables. Executed hive commands to output specific records or columns. Used complex data types such as map,array and struct in addition to basic datatypes. Created inner joins,left joins,right joins and full outer joins and map-side joins. Created external and managed tables with partitions and buckets.Used windows analytical functions such as rank,dense_rank and row_numbers

I worked as a freelance writer for approximately five (5) years. I wrote and edited articles, website content, press releases and blogs for the clients. I drafted and edited reports, letters, proposals, presentations, reviews, and manuals. I created chapter summaries, how-to articles, resumes, and cover letters. I researched, composed and edited web pages, business cases, strategies, reports, guidelines, manuals, presentations, and procedures. I used excellent communication skills to communicate relevant topics through writing. I used my knowledge of grammar, spellings, and punctuations to ensure compilation of well researched, high quality and error-free articles. I was able to communicate the required message in a neat and concise formatI conducted comprehensive researches for content and communicated with the clients through emails and website-chats to understand their specific requirements.

Gurgaon, India

I worked as a Data Analyst in MD Boss Inc, India for more than 2 years. MD Boss Inc is a health-services provider company which is concerned with providing medical transcription, medical billing, and transaction, development of medical billing software for its clients, the doctors. I was primarily concerned with the extraction, transformation, and loading of the highly confidential patients’ data. I created and managed database projects using MySQL. I used MySQL extensively for generating reports for understanding business operations. Talend was as an ETL tool to extract, transform and load data in and from MySQL. I created logical and physical data models according to the requirements I crafted and executed data queries and used MYSQL Workbench for data visualization. I analyzed the extracted data to answer business questions such as resignation rate, recruitment time, attrition rate and revenue generated from employees. I generated reports and created data visualization using MySQL Workbench as a BI tool. I implemented Mode MySQL for creating data insights and analytics in visual form. I used analytical results to establish a relationship between business measures and HR. I made recommendations for reshaping HR strategy using analytical results. The work enabled me to conduct comprehensive researches for upcoming database technologies and methodologies.

Gurgaon,India

I worked as a Data Operations Coordinator in MD Boss Inc for more than five (5) years. I was primarily concerned with the extraction, maintenance, manipulation, analysis of data. I extracted and combined data from various data sources using Power Query in Excel. I analyzed data using Pivot Tables, VLOOKUP and Index and Match in Excel. I implemented text and if formulas, charts and conditional formatting functions in Excel for analysis. I compiled and summarized findings in form of reports with regards to the business problem. I generated dynamic and interactive charts by using Quick Analysis in Excel for data visualization. I communicated findings to the supervisors, peers and all stakeholders in the form of easy to understand and attractive charts, graphs, and bars. I administered MS Excel as a complete BI tool for analysis and reporting. I created ad-hoc reports with regards to new hires, attrition rates, hiring costs using Excel. I provided internal support services and administrative support to all the employees. I maintained inventory supply records, files, and other paperwork and organized them in folders. I also answered numerous phone calls from clients and vendors. I created and maintained employees’ and customers’ records in spreadsheets and made it available to the supervisors when required.

Certificate, Data Analytics, Big Data And Predictive Analytics

Master Of Business Administration (M.B.A.)