RAVULA SURYATEJA

Client: Exelixis-commercial Data Foundation.

• Exelixis, Inc., is a leading biopharmaceutical company focused on cancer treatment, I spearheaded a project to consolidate and calculate data from various sources, including specialty distribution, specialty pharmacy, EASE, Chargeback, INS, IMS and the MDM team (informatica team)
• The project involved integrating unique MDM IDs for each customer from the MDM team
• Our team is responsible in ensuring data quality, enforcing business rules, and developing Business logic procedures.
• The procedures facilitated data circulation on a quarterly, yearly, monthly, weekly, daily basis
• This data was instrumental in providing Sisense with well-organized data to develop interactive dashboards for comprehensive data analysis and informed decision-making
• Roles & Responsibilities:
• Developing and maintaining SQL queries for data extraction, transformation, and loading (ETL) processes.
• Designing and optimizing database schema and queries for performance.
• Building and maintaining AWS infrastructure, including EC2 instances, S3 buckets, Lambda functions, and Redshift clusters.
• Writing Lambda functions using python scripts for automation, data manipulation, and integration with AWS services.
• Utilizing JIRA for issue tracking, project management, and collaboration with cross-functional teams.
• Providing technical expertise and guidance on SQL, AWS, Python best practices.
• Participating in Agile development processes, including sprint planning, daily stand-ups, and retrospectives.
• Collaborating with data scientists, analysts, and stakeholders to understand requirements and deliver solutions.
• Documenting processes, workflows, and technical specifications for future reference.
• Worked varied hours to meet seasonal and business needs.
• Prioritized tasks to meet tight deadlines, pitching in to assist others with project duties.
• Increased customer satisfaction by resolving complex issues and providing exceptional service at all times.

Client : Growel Agrovet Pvt.Ltd

• Growel Agrovet Pvt.Ltd, a prominent player in the ecommerce and retail domain, specializes in developing, manufacturing, exporting, and marketing premium quality animal healthcare products and veterinary medicines for livestock and poultry
• In project team was responsible for implementing data quality checks and validation processes to ensure that accuracy and completeness of the extracted data before loading into the Enterprise data warehouse built on MS SQL Server
• The data sourced from ERP systems, CRM systems, supply chain systems, and online sales platforms, including information on sales, inventory, procurement, production, customer interactions, and online sales performance
• Additionally, the scope of the project included creating interactive Power
• BI dashboards to visualize and analyze the transformed data, providing key insights for business decision-making
• Roles & Responsibilities:
• Developed and maintained complex SQL queries to extract and manipulate data from various databases.
• Implemented data quality checks and validation processes to ensure accuracy and completeness of the extracted data.
• Designed and implemented data models to support reporting and analysis in Power Bi.
• Created interactive Power BI dashboards to visualize and analyze data, providing key insights for business decision-making.
• Collaborated with cross-functional teams to understand business requirements and deliver solutions that met stakeholders needs.
• Utilized JIRA for issue tracking and project management, ensuring timely delivery of project milestones.
• Provided training and support to end users on SQL, Power BI functionality and best practices.
• Documented database designs, data transformation processes, and report specifications for future reference
• Identified and resolved issues related to data quality, performance, or functionality in SQL.