Ranjan Singh

Talented Data Delivery Analyst with approx four years of diverse experience in database design and using Power Bi, Excel, Alteryx, and Tableau for data blending and transforming. I also have knowledge of Systems Architecture. Extensive technical skills and advanced understanding of Excel, Power BI, SAP Hana, Alteryx, SQL, Python, MS Suite administration.

Strong collaborator and team player with good communication skills and expertise in analytical problem-Solving. Since I have been working with Map data customer delivery so there is a need to have client to client interaction.

Power BI and ETL Developer - innovantes it solutions llp - Mohali

(2025-07)

• Architect and manage cloud landing zones for raw data feeds, handling batch and streaming inputs (Parquet, Avro, CSV, JSON, ORC).
• Develop and orchestrate ETL workflows using Cloud Data Fusion (Wrangler) for data cleansing, transformation, and enrichment.
• Design data models (star/snowflake schemas) and define semantic layers to support Power BI datasets.
• Load curated datasets into BigQuery (raw → staging → curated) with orchestration via Cloud Composer/Airflow/Terraform.
• Optimize performance, implement automated data-quality checks, and monitor pipelines for reliability and cost-efficiency.

Data analyst - Poly Medicure Ltd. - Faridabad

(2024-01 - 2025-07)

• Analyzed production line data to identify bottlenecks, reducing downtime by 15% through data-driven recommendation.
• Developed interactive dashboards (using Power BI / Tableau) for real-time monitoring of OEE (Overall Equipment Effectiveness) and key KPIs.
• Performed root cause analysis using statistical methods (e.g., regression, hypothesis testing) on quality defects to support Six Sigma initiatives.
• Created ETL pipelines to extract and process large datasets from ERP systems (e.g., SAP).
• Automated routine reporting using Python and SQL, reducing manual effort by 30%.
• Collaborated with operations and engineering teams to optimize inventory levels and forecast material requirements using historical data trends.
• Conducted cost analysis on raw materials and production overhead to support strategic procurement decisions.
• Built predictive models for demand forecasting and preventive maintenance, improving forecast accuracy by 20%.

Data Engineer - MapmyIndia - New Delhi

(2021-08 - 2023-12)

• Designed and developed Tableau dashboards, contributing to 2.8%–4.5% enhancements in road network data accuracy.
• Collaborated with data stewards to test, clean, and standardize data, ensuring 100% compliance with business and quality requirements.
• Achieved 100% improvement in ETL processing time by optimizing data pipelines and workflows.
• Oversaw the successful delivery of analytics and reporting solutions for $15 million worth of projects annually.
• Tested and modified Alteryx workflows and databases, identifying and resolving issues to streamline data processing.
• Handled and manipulated large datasets using regular expressions to extract insights and build logic-based statistical models.
• Built and presented explanatory models for various use cases to both technical teams and non-technical stakeholders.
• Conducted data cleaning using SQL, Tableau, and Alteryx for predictive analytics in the construction and financial sectors.
• Provided technical support for new software systems by designing database schemas and tables based on 20+ business requirements.

Bachelor of Engineering - Mechanical Engineering - SAGAR INSTITUTE OF SCIENCE AND TECHNOLOGY