Iti Agarwal Email & Phone Number

India

• Developed ETL pipelines with the Common Data Lake and Apache Airflow
• Mentored and managed a 10-member team, leading both Operations and Enhancements for DevOps projects
• Enhanced operational efficiency by 22% across processes by streamlining cross team collaboration with stakeholders through standardization of communication and delivery procedure.
• Leveraged Python, SQL and PySpark in designing and deploying incentive plans, goal setting frameworks, and performance KPIs to derive insights on patient journey
• Drove process optimization engagement, using PySpark and SQL, achieving delivery ETA reduction up to 40%, cost and runtime reduction by 50%-70%
• Automated Data Quality and Validation checks across Tableau dashboards and data procedures increasing data checks by 7 folds, saving more than 400 man-hours annually

India

• Addressing business concerns and improving program design through ad-hoc analytics.
• Engaged in end-to-end tech cycles including requirements gathering, Effort Estimation, Development and operations handling
• Created high-quality deliverables and reports which impacted the day-to-day decisions of the sales force, marketing, and forecasting teams of the pharma client
• Gained expertise across tools and technologies such as Tableau, Python, SQL, and Advanced Excel to generate insights, study the ongoing market dynamics in the United States. Worked on big data for pharmaceutical.
• Helped launch new drugs and generics from an analytics standpoint, forecasted the market penetration, carried out a various analyses to help in day-to-day decisions & operations
• Managing and optimizing operations of business intelligence and data warehousing projects, transforming processes through Intelligent Process Automation, and advising internal and external teams on ways to improve.

Pune, Maharashtra, India

• Designed and developed schema data models, developed database objects, including tables, views using SQL and designed tableau reports
• Participated in requirements meetings, problem solving sessions to understand business needs.
• Validated data deliverables, Optimized and Automated validation processes across multiple data services saving more than 400 man-hours annually

Maharashtra, India

• Conducted board and general meetings and managed a 100 member-group. Oversaw existing activities, programs, and collaborations with other student organizations.
• Organized campaigns and provided marketing strategies for workshops resulting in 20% increase in participation, organized PRE PATW competition and hosted over 50 participants from around India.

Maharashtra, India

• Managed 5 members team of interns and ensured use of best practices
• Applied Object Oriented Programming concepts in software development practices
• Supported back end development, QA and user experience staff to develop new products.
• Designed software prototype and wire frames for software application post user reviews

Bachelor Of Technology - Btech, Computer Science

High School Diploma, Mathematics And Computer Science, 95%