Pallabi Jena
Wichita,KS
Summary
Highly skilled professional with 7 years of experience in Data Analytics, seeking a role as a Data Analyst whose leverage to apply strong analytical skills, critical thinking, and problem-solving skills in a fast-paced environment.
Overview
7
7
years of professional experience
2
2
Certification
Work History
SR DATA ANALYST
Wolters Kluwer Health
Wichita, KS
01.2023 - 05.2023
- Developed complex SAS and SQL queries to analyze large datasets for trends and insights.
- Performed statistical analysis on customer data to identify patterns and correlations.
- Established KPI metrics and monitored performance of data analysis projects.
- Created data visualizations in Power BI to present findings to stakeholders.
- Actively involved in data extraction, data cleaning and prepare workspace, update/modify SAS codes and perform calibrations and generated outputs.
Data Analyst
Magnit (Contract position with Wolters Kluwer)
Wichita, KS
05.2022 - 12.2022
- Translated raw data into meaningful information using statistical tools and techniques.
- Utilized advanced analytics tools such as SAS, and Excel PowerPivot, to manipulate large volumes of structured and unstructured data sets.
- Worked with internal teams to understand business needs and changing strategies.
- Collected, tracked and reviewed data to evaluate business and market trends.
- Created strategies for transitioning from traditional project management approaches to agile practices.
Data Analyst Intern
NumPy Ninja
DE, DE
01.2022 - 07.2022
- Performed data manipulation, data cleaning, and statistical analysis on the data sets receivedDesigned dashboards and reports for the volume of patients by demographics and the impact of biomarkers on the incidence
of sepsis by using Tableau and SQL - Developed data visualizations and dashboards to track business metrics using Tableau.
- Created SQL queries to extract relevant information from relational databases for various projects.
- Worked closely with stakeholders to ensure accuracy of collected data sets used in forecasting models.
- Collaborated with other teams to develop analytics solutions that provide value-added insights.
Lead Data Analyst
Genpact, India
Bengaluru, Karnataka
02.2012 - 09.2014
- As a key Pricing and Campaign Analytics team member developed and ran SAS and SQL code to support Marketing managers. The project involved analysis of existing credit card Pricing Strategy, APR rates, late fees, finance rates, and balance transfer.
- Campaign Analytics, worked closely with the Marketing and Campaign managers to analyze the Campaign design, fix the target audience, and offer. Also worked on the post campaign performance by calculating ROI and ROA indicators. Made a trend analysis to provide key insights into the campaigns.
- Collaborated with stakeholders to define business requirements and objectives related to data analysis projects.
- Created dashboards using Tableau to visualize data for stakeholders.
Data Analyst
Akamai Technology
Bengaluru, Karnataka
10.2010 - 01.2012
- Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE, and Data _Null_ for producing adhoc and customized reports and external.
- Analyze and interpret both quantitative and qualitative data.
- Primarily using SAS and Excel, monitor and analyses the performance and profitability of both Customer and Prospect marketing initiatives and incorporate learnings into future campaigns.
Data Analyst
Hewlett Packard Enterprise
Bengaluru, Karnataka
03.2010 - 10.2010
- Worked on sales and order management reports.
- Data extraction from various BI tools and extracting data to the .CSV,.TXT and Excel format and loading data into SAS for creating SAS data sets for further analysis.
- Assisted senior data analyst in creating reports on the performance of various departments.
- Conducted research and analysis to identify trends and patterns in raw data sets.
- Identified areas for improvement by analyzing existing processes and procedures.
- Cleaned, organized and transformed raw data into meaningful information for reporting purposes.
Education
MBA - Accounting And Finance
KIIT School of Management
Bhubaneswar, Odisha05.2009
Bachelor of Science - Pharmaceutical Sciences
Roland Institute of Pharmaceutical Sciences
Berhampur, Odisha05.2007
Skills
- Database: SQL (MySQL,PostgreSQL)
- Programming Languages: SAS, SQL,Python
- Analytical Tools: SAS, Power BI,Tableau
- Reporting tools: Tagetik, NetSuite,Great Plains (AWS), Tableau, MS
Excel (SUMIFS, VLOOKUP, Pivot table, Charts, etc), MS Word, PPT, - Experience with: SAP, and Salesforcecom
- Testing tools: Azure DevOps, Agile Methodology, Scrums
Certification
- SAS Certified Specialist: Base Programming using Base SAS 9.4, Certificate Verification Number: DH8TTNE2L1R11G3E, Certificate Verification Link: https://www.certmetrics.com/SAS/public/verification.aspx
- Udemy: Manual testing, JIRA, and Agile methodology
- NCFM: Beginner's model
Affiliations
- Certified Master Gardener
- A YouTuber who focuses on different aspects of gardening.
- A social worker who volunteers in different social activities.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
Timeline
SR DATA ANALYST
Wolters Kluwer Health
01.2023 - 05.2023
Data Analyst
Magnit (Contract position with Wolters Kluwer)
05.2022 - 12.2022
Data Analyst Intern
NumPy Ninja
01.2022 - 07.2022
Lead Data Analyst
Genpact, India
02.2012 - 09.2014
Data Analyst
Akamai Technology
10.2010 - 01.2012
Data Analyst
Hewlett Packard Enterprise
03.2010 - 10.2010
MBA - Accounting And Finance
KIIT School of Management
Bachelor of Science - Pharmaceutical Sciences
Roland Institute of Pharmaceutical Sciences
Similar Profiles
Shahnish KhanShahnish Khan
Publisher at Wolters Kluwer Health (Medknow)Publisher at Wolters Kluwer Health (Medknow)
Pamela TarapchakPamela Tarapchak
Managing Editor, Oncology Times at Wolters Kluwer HealthManaging Editor, Oncology Times at Wolters Kluwer Health
David PikeDavid Pike
Strategic Account Executive at Wolters Kluwer HealthStrategic Account Executive at Wolters Kluwer Health
Mariano MichavilaMariano Michavila
Director of Sales at Wolters Kluwer Health, Learning, Research and PracticeDirector of Sales at Wolters Kluwer Health, Learning, Research and Practice
Wayne BeckerWayne Becker
Solutions Engineer II at RapidScaleSolutions Engineer II at RapidScale