Data Analyst Power Platform

Nabaneeta Chakraborty ****.*****@*****.*** 908-***-****

SUMMARY:

Results-driven data analyst and Power Platform citizen developer with years of experience designing, developing, and optimizing business applications using Microsoft Power Platform. Adept at streamlining processes through automation, creating insightful dashboards with Power BI, and building scalable Power Apps. Strong communicator with a knack for translating business needs into effective technical solutions

EDUCATION:

MS Engineering, 2017-2020, Rutgers University, NJ graduate school.

SKILLS:

Operations and project management, documentations, trained internal auditor, six sigma, excellent analytical, troubleshooting, multitasking, interpersonal skills, organized, quick learning abilities, detail oriented, problem solving, customer relationship management, negotiation, communication skill.

MATLAB, Polymath, Linux, SAP ERP, MM, PP, HRM, FICO, MS Project, MS office suite (Word, Excel, Power point) 2013/2010, Visio, SQL, Python,Power BI, Tally, Salesforce, Microsoft Power Platform (Power Automate, Power Apps (Canvas & Model-driven), Dataverse), SharePoint Online, Microsoft 365, Teams, AUTOCAD, Minitab, JIRA, SLDC, Scrum, Agile, EDEM simulation.

PROFESSIONAL EXPERIENCE:

Boehringer Ingelheim, R&D, North Brunswick, NJ Mar 2022 – Present

Junior analyst

Gathered and understood requirements to visualise the failed uploads of studies and its reasons.

Joined data from tables and created a meaningful visualisation for the failed uploads.

In SQL, cross verified the count and other important calculations from the visualisations to the database data.

Written Python scripts to extract the data from the Send Explorer and uploaded it in network file structure.

Used technical and analytical skill to coordinate between Lab personal, vendors and engineer with attention to details and adaptability and checked performance metrics.

Ran monthly instrument due queries/reports for routine service schedule.

Cross checked Inventory and asset management with the Service Program Manager.

Determined need of service quotes meeting logistics and support.

Gathered information from database on instrument histories, past services, repairs, etc.

Participated in validation of various categories of lab equipment.

Updated LIMS, Bigcal, SAP database, change Controls, Deviations, CAPA etc. document coordinator for Global facilities engineering team.

Communicated with the management staff from multiple functional areas and sites to understand changing priorities and ensured minimum to no service interruptions.

Ensured compliance to cGMP, regulatory regulations, and global and local policy for equipment.

Developed and maintained Excel-based reports for tracking calibration schedules.

Assisted in the analysis of business processes and development of user stories, contributing to the successful implementation of technology solutions that improved operational efficiency.

Executed validation protocols, plan, risk assessment, created test cases for computerized system for laboratory equipment, ensuring compliance with cGMP regulations.

Conducted in-depth analysis of large datasets to identify trends, patterns, and anomalies

Did data cleansing and preparation, including cleaning and preprocessing raw data to ensure accuracy and reliability, developing and implement data quality standards and working with a team to integrate and automate data pipelines.

Created and maintained comprehensive dashboards and reports for key performance indicators and ssupported UAT execution

Used visualization tools (Tableau, Power BI) to present complex data in an understandable format after rrequirements gathering.

Self-motivated with ability to work effectively with limited supervision, enthusiasm for collaboration, continuous learning, and a team player.

Advanced Excel expertise (pivot tables, VLOOKUPS, Power Pivot, functions, etc.)

Understand importance of code review and automated testing and different levels at which these need to be performed and wrote and implemented tests as required.

Knowledge in implementing solutions with Microsoft PowerApps, Power Automate, and/or Common Data Service (Power Platform).

Knowledge of data models, data modelling (Relational and Dimensional), Data profiling and working with large data environments.

Strong communication, team player and advance analytical skills to analyze data issues and drive appropriate actions with data operations and business processes.

Data Governance, Data Quality, Master Data Management knowledge.

Hisense Photonics, South Plainfield, NJ Aug 2021 – Dec 2021

R&D Assistant

Responsibilities:

Performed testing, measuring, recording, and analysing of the optical transceiver modules to produce reliable and precise data in LabView to support the development.

Maintained, operated, and calibrated the test equipment, microscopes, spectral analyser, source meter etc.

Performed inspections of packaging components, bulk, WIP, finished goods

Assist in continuous improvement of manufacturing operations to improve safety, quality, flow and efficiency through application of LEAN manufacturing principles.

Identify and help resolve packaging quality issues that arise in process, systems, methods or procedures used to produce components, WIP, or finished goods.

Ensured the laboratory is well-stocked and resourced. Followed and ensured strict safety procedures.

Rutgers University, Piscataway, NJ Nov 2019 to Aug 2021

Graduate Research Assistant

Responsibilities:

Involved in R&D sponsored by Takeda Pharma optimization of heat transfer in drug API in an agitated filter bed dryer in both laboratory hands on chemical handling experiments and simulation of powder particles for Pharmaceutical Manufacturing Center.

Reviewed research literature studies on heat transfer and drying of materials and design of experiment procedures for a lab scale process to validate process simulation predictions data and calibration procedures.

Analysed type-T thermocouple and FLIR infrared camera data and generated reports in Research IR and Thermal Studio analytical software to examine trends in heating of the bed after performing the experiments independently.

Co-authored research paper on heat transfer and ran simulations of agitated dryer on EDEM software and assisted in slide preparation and presentation.

Created experiment, cleaning, analysis SOPs and reports on various research results data, DOE using PAT tools.

Involved in projects sponsored by Exxon- Mobil, Evonik and other catalyst manufacturing company for rotary calciner efficiency improvement and moisture analysis of powder on thermal properties for scale up input in simulations.

Analysed FT4 rheometer, Laser Diffraction Particle Analyzer, particle size distribution, stability test, material characterization.

Knowledge about basic regulatory affairs, GLP, chromatography, UV, HPLC, GC, dissolution testing.

Optimum Cablevision / Altice USA, NJ Mar 2016 – July 2018

Database Coordinator

Responsibilities:

Proficiently coordinated with design, survey, sales consultants, supervisors, and managers to track the Wi-Fi network design projects of the different hubs in New Jersey for access agreements and customer contact information.

Updated survey and design status database on the engineering tracking system to assign jobs to the survey contractors.

Corrected data discrepancies on the Tectrac website for jobs released to construction and mapped radio locations.

Developed and maintained Power BI dashboards, reports, utilizing SQL for data queries, to track key performance metrics, resulting in improvement in data-driven business decision-making and data accessibility.

Implemented a comprehensive data profiling strategy, identifying and resolving data quality issues, which improved data accuracy.

Developed and implemented data analysis models to optimize data tracking processes, resulting in increase in efficiency and compliance with regulatory standards.

Implemented a new workflow management system, resulting in increase in efficiency by streamlining processes and reducing manual errors.

Developed and maintained Tableau dashboards to track key performance metrics, resulting in improved data-driven decision-making and data accessibility.

Developed and maintained Business Requirements Documents (BRD) and Functional Requirements Specifications (FRS) for various projects, ensuring alignment with Software Development Life Cycle (SDLC) methodologies.

BALCO Vedanta group of companies India Jul 2008 – Jul 2013

Smelter’s anode plant Projects coordinator/Process control engineer/Assistant Manager

Responsibilities:

As project engineer collaborated with cross functional technical installation team from kick of meeting to reconciliation, commissioning.

Handled overall documentation, site project management for fabrication and erection of structural steel, equipment, utilities.

Framed schedules, business plan to ensure time management for higher operational efficiency. Developed staff by training.

Created ISO, OSHA documents for regulated guidelines risk assessment, policies, SOPs, protocols of cGMP and implemented CAPA.

Actively audited monthly safety inspections, quality audits to ensure compliance with company policies according to OHSAS.

Responsible for Calibration, validation, and maintenance of equipment/instruments

Monitored preventive and predictive operations as shift in charge and executed saving measures by working within the budget.

Supervised team of quality assurance members to ensure that final products met design and customer satisfaction.

Executed root cause analysis, analysed data, resolved product/process problems to continuously improve plant performance.

Reduced amount of scrap waste. Planned with cross functional maintenance team to reduce equipment downtime by 25%.

Met production levels of 35 pieces/hour in automated platform. Supported product development and cost reduction as manufacturing engineer.

Performed QA lab duties, handled sample receipt, logged in incoming shipments (pitch, coal) and tested protocols.

Maintained the integrity of all samples, identified, and labelled them, maintained custody records, assured sample analysis.

Techno commercially negotiated, created BOM and procured administrative, infrastructure, equipment (IT, mechanical, electrical, medical), raw materials, EPC, non-EPC supply and services contracts for Medical Research Foundation Project.

Worked with local, overseas stakeholder for mixers, extruder, vibrating screen, belt conveyors, bucket elevator, compactor.

Performed manual or automated process performance data analysis, extraction, reporting.

Coordinated the execution of process validation protocols, including scheduling, communication, coordination of sample delivery and data collection for business process.

Led a process improvement project using the DMAIC process to reduce equipment downtime by 60%, resulting in significant cost savings and increased production efficiency

Coordinated activities by communicating with internal and external team members like Manufacturing and operating groups, Supply Chain, and QA/QC to meet project timelines and deadlines.

Coordinated a cross-functional team to successfully complete a project on time and within budget, improving operational efficiency through effective resource allocation and stakeholder communication.

VOCATIONAL TRAINING PROJECT/ ACADEMIC EXPERIENCE:

Training cum project work in INDIAN OIL CORPORATION LIMITED on refining process overview and efficiencies of pumps. The training dealt with the analysis of various processes in the petroleum industry and the efficiencies of various pumps.

Project on bio diesel manufacturing in IIT. College project on ethylene oxide manufacture. Achieved CEO-KITTY award from BALCO for successful completion of GAP plant structural erection.

Vapor-Liquid Equilibrium of Nitrogen/Methane/Ethane - Advanced Chemical Engineering Thermodynamics.

Matlab project on enzyme substrate reaction of set of differential equations – Analytical Methods in Engineering Mathematics.

Design of packed bed catalytic fixed bed flow reactor – Chemical Reaction Engineering.

Pharmaceutical unit operations. Drug development. Global food supply, Drug delivery.

Statistical analysis of pharma process - Quality by Design (QbD), Design of Experiments (DOE), multivariate analysis, PAT, critical process, and material attributes and CQA's

Contact this candidate