Shubhi Asthana

Client: AstraZeneca. Project: Field Sales Incentive Program. Enabling infrastructure and providing solutions for development and data processing for credit compensation of sales representatives promoting medicines in US Pharma sector. Roles and responsibilities: Currently working as Lead developer for US SHARP platform managing a team of 4 associates. Experienced in designing automated workflows. Involved in Project Planning, timeline and resource management for critical deliverables along with SOW, Ad-hoc requests and cost, client budget estimates and approvals. Hands on Experience in working on Spark and Spark-SQL. Hands on Experience with AWS, creating and storing data in S3 buckets, using Elastic Map Reduce (EMR). Used Spark and proposed solutions to improve performance and increase system efficiency. Addressed issues occurring due to high volume of data and transitions. Coached and trained newer associates in the team.

Client: AstraZeneca. Roles and responsibilities: Performed data analytics in healthcare domain involving data extraction, manipulation, visualization and validation. Created workflows in python using Apache Airflow. Automated business processes to reduce turnaround time by 200% using Spark SQL. Used SQL queries and MS Excel to Extract, Validate, Transform and Load data for complex data analysis, reporting and testing complex healthcare datasets for key insights. Used AWS EMR (Elastic Map Reduce) for resource intensive transformation jobs. Performed business impact analysis, Root Cause Analysis (RCA), identified and analyzed data anomalies. Understood 6D lifecycle of a change request and associated deliverables with each phase. Worked on AWS services including EC2, S3, Redshift and Athena for data management. Understood, analyzed and documented business requirements, technical specifications and created Business Rule Documents (BRDs). Created technical illustrations and dataflow diagrams. Delivered under strict timelines with limited resources at hand while working with geographically diverse team.

Trained in working on Implementation of Queries used in adding, manipulating and accessing data in a database using MySQL- an open source RDBMS. Proficient in fundamentals of programming in Python along with object-oriented programming and data structures. Skilled in Microsoft Office with an Emphasis on Microsoft Excel.

Client: BlumeGlobal. Roles and responsibilities: Writing Test Cases and Test Scenarios on TestRail, Test Management Tool. Tracking and Logging bugs on JIRA. Ensuring API functionality using Swagger, an open-source software framework. Hands on experience of working on Selenium - a Software Testing framework to automate test cases. Worked on automating test cases using the framework, Unified Functional Testing (UFT).