Dec 2020 – Sep 2021 · 9 mos · Gurugram, Haryana, India

• ● Designing, maintaining, upgrading and developing dashboards along with end-to-end ETL process which precedes it, in Tableau, Power BI, Google Data Studio, etc.
• ● Extract large dataset from various databases (MySQL, Amazon Redshift) or extract flat files (CSV, excel, google sheet) from cloud platforms (i.e. FTP or box.com. etc.) for
• integration into data warehouse through scheduled ETL process.
• ● Design and maintain databases objects like schema, tables, and views in Redshift.
• ● Transform the data with the help of the ETL process (writing queries in MySQL or Redshift) to build the data warehouse which will support decision making and reporting.
• ● Develop interactive dashboards in DOMO and Tableau for data-driven decision making to improve client’s business performance, media buying decisions, evaluate channel
• effectiveness, and identify the discrepancies.
• ● Worked on various social, search, display media channels and CRM (Google Ads, Facebook Ads, Bing Ads, Yahoo, Google My Business, Google Analytics, etc.)
• ● Validate the data of the dashboards before delivering it to the client.
• ● Made post-production enhancements for better reliability.
• ● Collaborate on real-time projects with team members and achieve their respective project deadlines.

Nov 2016 – Dec 2020 · 4 yrs 1 mo · Gurugram, Haryana, India

• ● Driving Insights by working with different data sources
• ● Creating data flow pipelines and integrating with Data Studio and Power BI
• ● Generate powerful Informative Insights for higher Management and Clients.
• ● Managing and working with a Team of 5 and playing a key role in delivering business intelligence modules/products/solutions.
• ● Internal Tool Reporting Expert-SQL based (Intermediate Level) - Dashboards Creation and Maintenance
• ● Metrics reporting for Operations and Weekly business review (WBR) Slide preparations
• ● SQL Scripts Automation - Dremel commands integration for data export
• ● Productivity and utilization reports along with Attendance management for payroll.
• ● Raw cases Strings and Dump expert for reporting purposes of live Productivity and Assigned Queue management

Sep 2015 – Aug 2016 · 11 mos · Greater Delhi Area

• Project JRF at CSIR-IGIB has given me exposure to Cloning Work and also RNA Extraction, cDNA synthesis, PCR and qRT-PCR arrays. Profiling miRNA Levels from total RNA of Patient blood. Drylab analysis involving Pathway Enrichment and miRNA-mRNA Co-relation studied from miRNA profiled data and RNAseq data from lab. I would not say that I am a total expert in everything but have good exposure to all.
• ● miRNA Research Fellow for Pediatric TB patients.
• ● miRNA Profiling, Vector-DNA Recombineering and Bacterial Culture Maintenance.
• ● Protein Purification and Protein Profiling.
• ● Carry out research work of the collaborative research projects with other Scientists and teams in CSIR-IGIB.
• ● Worked with a Team of 5 Research Scientists and fellows in exploratory research in testing various Scientific hypothesis.

Jun 2015 – Aug 2015 · 2 mos · IMT Manesar

• ● Joined as On-Job-Trainee for 2 Months to support Mass Scale Protein Purification for medical purposes
• ● Downstream Protein Fractionation and Concentration (Including Lyophilization in some cases)
• ● Large scale manufacturing (i.e. chromatography techniques, TFF techniques and buffer preparation).
• ● Manufacturing of monoclonal antibodies or recombinant therapeutic proteins, media preparations & seed preparation activities

Jun 2013 – Jun 2013 · 0 mo

• ● Designing and executing laboratory testing according standard procedures
• ● Worked on various pathological tests and reporting in Pathology labs