Juilee Thakur

Experience

• 

  Sciative Solutions - We Price Right

  Jul 2019 - Apr 2022

  Data Architecture, Pipeline Development, and Client Data Reports:• Orchestrated the design of database architecture, implementing robust data pipelines (ETL) with Python scripts.• Elevated client data reports by developing and upgrading stored procedures and functions, significantly enhancing data accuracy and accessibility.AWS Infrastructure Management and Database Optimization:• Spearheaded the development, testing, and deployment of AWS spot instances for job scheduling, replacing Jenkins.Integration Development and Web Development:• Developed integrations for Amazon and Shopify within the pricing application.• Played a pivotal role in the seamless development of the company's WordPress-based website.SDLC Engagement, Team Leadership, and Sprint Planning:• Established a weekly sprint plan for a 9 to 10-member team, ensuring efficient project delivery.• Successfully executed plans, fostering alignment through discussions with the team and senior management.Client Relationship Management, Meetings, and Requirement Discussions:• Oversaw a portfolio of 9 to 10 clients, ensuring elevated customer satisfaction.• Led weekly client meetings, discussing new requirements, application additions, and development progress.• Finalized client requirements with the team and higher authorities.Project Planning, Technical Guidance, and Additional Achievements:• Finalized UI design, process flow, architecture changes, and development processes with the team.• Analyzed festive client data, processed and extracted data using Excel, presenting valuable business insights.Data Analysis, Business Insights, and Technical Expertise:• Utilized Django, HTML, CSS, jQuery, and JavaScript for UI Design and Dashboard Creation.• Processed client data resources in Amazon Athena, Redshift, and S3 bucket.• Shifted data architecture from RDS to MongoDB for scalability and optimized dashboard performance.• Implemented GCP Spot VMs, comparing performance with AWS spot instances. Show less • Data Processing and Transformation: Executed daily processing of each data source file, utilising Excel for cleaning and converting each input file into a usable format.• Data Pipeline Development: Designed and implemented a data pipeline for a new data source, involving data interpretation, extraction, transformation, and loading into the system using Python scripts.• Pricing Model and Regression Modelling: Contributed to the development of a pricing model for an Entertainment sector client, leveraging regression modelling. This encompassed processing historical data, model training, evaluation, and prediction using Python scripts.• UI Design and Dashboard Creation: Crafted UI designs and dashboards tailored to client requirements using Django.• Security Enhancements and Integration: Implemented SAML integration for single sign-on and authentication between the created application and the client's side application. Ensured basic security measures on dashboards, including anti-CSRF tokens and prevention of SQL injection and cross-site scripting.• Data Analysis: Conducted thorough data analysis to derive valuable insights.• Client Engagement and Requirement Understanding: Actively participated in client discussions to comprehend requirements and new developments, contributing insights and aligning solutions accordingly. Show less

  • Tech Manager

    Jun 2020 - Apr 2022

  • Data Analyst

    Jul 2019 - May 2020
• 

  Locobuzz

  Apr 2022 - Aug 2022

  Data Engineer

  • Scheduled, Monitored, and Managed Excel Report Generation Workflows: Implemented Apache Airflow to efficiently schedule, monitor, and oversee the generation of Excel reports on the client dashboard.• Process Optimisation and Implementation: Actively participated in discussions regarding process changes, providing valuable insights, and suggesting implementation improvements.• Process Flow Modification and Testing: Successfully changed, implemented, and rigorously tested updated process flows to enhance efficiency and effectiveness.• CI/CD Pipeline Management: Established and managed Continuous Integration/Continuous Deployment (CI/CD) pipelines, ensuring a seamless and automated development and deployment process.• API Development for Dashboard Versioning: Developed APIs to support the versioning changes in the dashboard. This involved a comprehensive understanding of the existing data flow and API structure, reviewing new designs, and meticulously creating and testing new APIs. Show less

• 

  Nostra

  Jul 2024 - now

  IT Analyst