Ashish

Responsible for building enterprise data warehouse/lakes/marts solutions, architectures, scriptwriter & proof of concepts for digitalization of Pharmaceuticals Industry, Smart Infrastructure divisions, and AI Lab projects. Pillar of Industrial Data Analytics Team for transformation to smart e-health assessments projects.

Overall responsibile for the Data Engineering activities (ETL and data enrichment). Designed, developed, optimized, and maintained data architecture and ETL pipelines to support business goals. Responsible for data extraction, data flow in the pipe, processing jobs, data quality, and alerts. Worked closely with the data integration & application owners. Understood various integration, data records, and dependencies among systems data.

Utilized a BI Solution to analyze data, such as clinical trial findings, market potential, epidemiology, or documentation for safety, efficiency, and toxicity of medicines to evaluate the potential future usage of a drug. With an advanced data strategy, companies can make the drug development process faster, and at less expense. We have used AWS cloud services, like EMR, RDS, SNS, SQS, Python, Glue, etc.

Utilized a big data solution for analytical purposes to support new business models, predominately in the service business for Sun pharma Ltd. The platform is mainly used for utilizing statistical process control in-process monitoring and verification, cycle time optimization, quality-by-design in continuous manufacturing, etc. business use cases. We have used big data Hadoop, Talend, MySQL, Java, Jasper soft, etc.