Analyst BIM
Axtria Ingenious Insights · Jul 2022 – Present
- Detail-oriented and results-driven Data Analyst with 3+ years of experience in the pharmaceutical and life sciences sector.
- Skilled at collating, cleaning and analyzing complex datasets using AWS services, proficient in SQL, Power-BI and Python, with a proven ability to transform, analyze and extract trends and insights from complex healthcare and sales datasets to support analytics and reporting, generate meaningful insights for business end-users and meet stringent industry standards.
- Expertise in working on processes to collect, clean and analyze datasets utilizing technologies such as Apache Spark, Hadoop, and AWS services and integrating into historical data and generating insights
- Proficiency in implementing data transformations and workflows to ingest the staging data into various refine layers and apply appropriate data quality checks such as NULL, DUPE and LOV checks
- Implemented processes to provide refined data on Redshift and generate dashboards from the data using Power-BI to aid business and end-users to meet business objectives and enable data-driven decision-making
- Created HQL, Python, and wrapper shell scripts for the ETL processes, and automation of Hadoop/PySpark jobs using Control-M, resulting in increased operational efficiency and requiring minimal manual interventions, also reducing average failures from 18% -> 2% and daily cycle from ~17 hrs -> ~8 hrs
- Optimized ETL jobs by fine-tuning the SQL code improving query performance and enhanced response times on production servers
- Involved in the creation, backup, monitoring, and termination of EMR and EC2 clusters, forming the base platforms for our processes over 7 Janssen data products
- Experienced in improving operational workflows, achieving a 97% compliance rate with service level agreements and customer satisfaction rating of 4.5/5 over 3 years
- Adapt at collaborating with cross-functional teams, conducting internal POCs, facilitating knowledge-sharing using comprehensive documentation and creating standard operating procedures (SOP) documents
