Ajitesh Pradhan
NOIDA
Summary
Data Analyst with over 2.5 years of experience. Success using technical expertise to drive business goals and metrics.Achieved a 36% improvement in the performance of Spotfire reports having large datasets through effectively utilizing combination of parameterised information links, TERR data functions and IronPython scripts. This approach minimised data loading and processing time while performing any interactive action on the dashboard.
Overview
1
1
year of professional experience
7
7
years of post-secondary education
2
2
Certifications
Work History
Associate Software Engineer 2
RxLogix Corporation
01.2023 - Current
- Enhanced the entire structure of data cleaning, manipulation and querying process by effectively utilizing Oracle's PL/SQL, improving the timing performance of overall report generation by 43%.
- Developed an Operations dashboard using Spotfire, SQL and PL/SQL to monitor productivity and compliance of the users who are involved in reviewing pharmacovigilance alerts and signals.
- Collaborated with client consulting teams, team leads and project managers to successfully implement multiple client projects of PV Analytics (spotfire reports and dashboards ).
- Resolved client bugs/issues within SLA timings for the automated spotfire reports and dashboards.
- Developed next-generation integration platform for internal applications.
- Designed and implemented scalable applications for data extraction and analysis.
Associate Software Engineer 1
RxLogix Corporation
2 2022 - 01.2023
- Reduced 40% loading time on Report generation of Safety systems of FDA
- Build AE Reporting Rate Report to visualise drug or vaccine high adverse event rate
- Created a Safety Compliance Report to examine individual Cases in which adverse effects have happened because of taking specific drugs or vaccines, which reduced manual efforts by 80%
- Collaborated with 10+ Stakeholders directly, to make custom interactive dashboards according to their requirements
- Gather, analyse, and clean data using SQL developer, optimized SQL, Spitfire and create meaningful data.
- Collaborated with product owners to stay current on intended functionality.
Education
B. Tech (CSE) -
Galgotias Collage of engineering And Technology
01.2019 - 04.2022
Diploma (IT) - undefined
Chattarpati Sahuji Maharaj Govt. Polytechnic
01.2016 - 04.2019
Skills
Oracle PL/SQL:-Stored Procedures Functions Triggers Transaction Management Error Handling Dynamic SQL Performance Optimization Version Control
Spotfire: - Dashboard Visualization Action Filters Parameters Data Transformation Spotfire Server IronPython R
Power BI: - Data Reporting Data modelling Data Cleaning DAX Integration
Database - Transact-SQL (T-SQL) Data Warehousing SQL Server Analysis Services (SSAS) SQL Server Reporting Services (SSRS) SQL Server Integration Services (SSIS) Argus Safety Database Oracle PL/SQL Developer Iron Python
Python- Pandas NumPy
Certification
HACKERRANK ADVANCED SQL, 06/2023, Achieved Hacker rank SQL advance Certification which includes complex joins, unions, and sub-queries.
Extracurricular Activities
SPORTS HEAD, 08/2019, 08/2021
Volleyball Captain
Cricket Vice-Captain
Projects
DISEASE PREDICTOR, Disease Predictor implements data mining techniques like Decision tree, Random Forest, Naïve Bayes, Support Vector Machine, Kth nearest neighbours (KNN) and Stacking Classifier that classifies the disease as per data., Web interface platform to predict the occurrence of disease based on various symptoms with their probabilistic figures with the best accuracy of 94%.
Timeline
Associate Software Engineer 2
RxLogix Corporation
01.2023 - Current
B. Tech (CSE) -
Galgotias Collage of engineering And Technology
01.2019 - 04.2022
Diploma (IT) - undefined
Chattarpati Sahuji Maharaj Govt. Polytechnic
01.2016 - 04.2019
Associate Software Engineer 1
RxLogix Corporation
2 2022 - 01.2023