Archana Gautam
Data Analyst @Raptor Supplies Limited
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @Raptor Supplies Limited
Bengaluru, IN
Extracted and analyzed complex SQL queries using tools like Microsoft SQL Server, identifying performance bottlenecks and reengineering queries for improved efficiency. • Implemented table partitioning and indexing strategies to enhance query performance, reduce I/O operations, and accelerate data retrieval time, particularly for large datasets in PostgreSQL and MariaDB. • Developed and maintained relational data models, ensuring referential integrity and optimal join conditions in analytical datasets. • Used CTEs, window functions, and stored procedures to write modular and readable SQL code that powers dashboards and automates recurring reporting tasks.Automated reporting pipelines using Python scripts scheduled via cron jobs and orchestrated through Apache Airflow, reducing manual intervention by over 90%. • Built data ingestion frameworks to extract, transform, and load data from APIs (Aftership, FedEx, Google Ads, Ahrefs), CSVs, and databases, ensuring high accuracy and data integrity. • Designed custom data parsers using advanced Python libraries like Pandas, Numpy, Regular Expressions, and FuzzyWuzzy to clean, merge, and transform unstructured data. • Integrated with external APIs using the Requests and Postman libraries, handling token-based authentication, rate-limiting strategies, and pagination for scalable data access. • Applied Python multiprocessing techniques to speed up batch jobs and file operations in production workflows.
EDUCATION
Kamla Nehru Institute of Technology, Sultanpur
Bachelor of Technology - BTech
Air Force School , Allahabad
INTERMEDIATE
ABOUT ARCHANA GAUTAM
With a strong background in Data Analytics, Machine Learning, and Data Engineering, I thrive on uncovering insights from complex datasets and turning them into actionable strategies. Over the past 3 + years, I’ve built and deployed scalable data solutions that have improved business operations, marketing performance, and customer engagement.Technical Expertise Includes:• Language & Libraries: Python (Pandas, NumPy, Scikit-learn, TensorFlow), SQL• Data Tools: PostgreSQL, Metabase, PySpark, DBeaver, SQLyog• ETL & Automation: Building pipelines, API integrations (Aftership, Google Ads, Ahrefs), Cron scheduling• Visualization & Reporting: Power BI, Tableau, Excel, Dash• Web Technologies: Flask, Django, FastAPI• Platforms: Databricks, Git, Google Colab, Jupyter NotebookI’ve led and contributed to projects such as: Automating shipping and analytics with API integrations, saving 15+ hours per week Building churn prediction models with 92% accuracy Creating unified reporting systems for sales and marketing teams Deploying real-time dashboards for customer behavior and sales trendI enjoy collaborating with cross-functional teams, asking the right questions, and making data a valuable asset. Whether it’s cleaning messy datasets or deploying real-time applications, I bring a problem-solving mindset to every challenge.Let’s connect and explore how we can leverage data together!
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.