Sakshi Bansal

• Automated data quality checks and error-handling processes ensure the integrity and reliability of the Brands dataset.
• Streamlined data flow from diverse sources using ETL tools, such as Alteryx.
• Provided technical mentorship to junior data engineers, guiding them on best practices and project execution.
• I analyzed user requirements, designed the solutions to load enterprise data into the Data Warehouse.
• Documented data architecture designs and changes, ensuring knowledge transfer and system maintainability.
• Created conceptual, logical, and physical data models for various use cases.
• Maintained cloud-based data infrastructure on AWS to enhance data storage and computation capabilities.
• Collaborated with business stakeholders to gather requirements and translate business needs into technical specifications for data solutions.
• Conducted comprehensive research and data analysis to support strategic planning and informed decision-making.
• Collaborated closely with team members to achieve project objectives and meet deadlines.
• Participated in agile development processes, contributing to sprint planning, stand-ups, and reviews to ensure timely delivery of data projects.
• Coordinated cross-functional teams to ensure timely and successful completion.
• Collaborated with data scientists and analysts to understand data needs and implement appropriate data models and structures.

• Collaborated with data scientists and analysts to understand data needs and implement appropriate data models and structures.
• Conducted data analysis using SQL to derive insights and support decision-making processes.
• Streamlined data flow from diverse sources using ETL tools such as Alteryx.
• Collected, outlined, and refined requirements, and led design processes.
• Managed version control and deployment of data applications using Git and Jenkins.
• Analyzed user requirements, designed and developed ARDs to meet business requirements.
• Developed and implemented data models, database designs, data access and table maintenance codes.
• Documented data architecture designs and changes, ensuring knowledge transfer and system maintainability.
• Wrote and coded logical and physical database descriptions, specifying identifiers of database to management systems.
• Utilized advanced technical skills and expertise to troubleshoot complex problems and implement solutions.
• Conducted end-to-end testing of ARDs to ensure quality and reliability.
• Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.
• Worked successfully with IQVIA to integrate the results into the C360 Dashboard.
• Conducted comprehensive research and data analysis to support strategic planning and informed decision-making.

Created reports for senior management summarizing HCP engagement and sales data.

• Oversaw requirements from leading top 10 global markets.
• Collaborated with business stakeholders to enhance comprehension of DAC procedures.
• Engaged with IQVIA to evaluate and interpret multiple data offerings.
• Performed assessments of various IQVIA-acquired data sets with the procurement team.
• Constructed Qlik Dashboard enhancing access to consolidated IQVIA data for business stakeholders.
• Streamlined entire demand management workflow with the implementation of Alteryx and Power Automate.
• Established data governance framework to ensure data availability, security, and privacy across various regions.
• Conducted standardization activities for consistent international data.
• Collaborated with finance team for monitoring cross charging of purchased data sets by country teams.

• Partnered with IT, Data Strategy, and Business stakeholders to develop tailored business solutions.
• Conducted comprehensive data analysis for all new requests.
• Designed conceptual models addressing business user requirements.
• Facilitated business stakeholders in testing newly onboarded data into CDH.
• Developed project-specific protocols including Data Governance frameworks.
• Conducted a comprehensive gap analysis on various use cases.
• Formulated a robust operating model to handle user requests effectively.

• Engaged in comprehensive data modeling of Scheme Management.
• Engineered comprehensive CI/CD solutions with Bitbucket and Jenkins for seamless deployment through production stages.
• Developed models to extract data from various sources and stored it in MDM.
• Executed multiple proofs of concept for complex requirements involving JAVA APIs.
• Managed server deployment using Ansible and Terraform to align with every application update.
• Developed Python scripts to automate bulk data loading processes.
• Engaged with business users consistently to gather requirements.
• Configured platform for automated test case execution using UTPLSQL utility.
• Automated notification emails to inform clients of payment due dates.
• Utilized Informatica jobs and BizTalk orchestrations to automate the processing of client communications.
• Enhanced ETL efficiency by leveraging advanced optimization methodologies in handling high-volume data.
• Ensured historical data maintenance by automating Warehouse and Audit table synchronization via PL/SQL Triggers.
• Directed comprehensive project delivery, spanning from requirement analysis to report and dashboard development.
• Performed multiple data reconciliation tasks to monitor daily transactional and holding trends.
• Created PL/SQL scripts to automate regression tests.
• Expertise in managing complex business logic implementations for optimal data loading.

• Oversaw complete database transition from SQL Server 2008 R2 to MongoDB.
• Designed script to automate database creation for new accounts.
• Automated data migration workflows between Microsoft SQL and MongoDB using Pentaho ETL tool.
• Participated in regular user interactions to gather requirements.
• Configured data integration workflows to load structured formats with embedded documents.
• Executed data import and export from MongoDB in key-value pair format.
• Validated and implemented code deployment processes in advanced environments.
• Recorded requirements for implementation and developed high-level solution designs.