Mritunjay Sinha

Skilled in data visualization, statistical analysis, and data warehousing, offering meticulous and thoughtful approach to problem-solving. Expert in leveraging SQL, Incorta, Power BI, OBIEE, BIP and Python to drive data-driven insights and support strategic decision-making. Thrives in complex technical environments, delivering actionable intelligence, essential for successful BI Analyst.

Experienced in data warehousing, and familiar with Parquet files and data integration using Incorta's No-ETL approach.

Senior Incorta Architect - EnnarIT LLC - Winchester, Virginia

(2025-05 - 2026-03)

• Designs and develops data pipelines, integrates diverse data sources (ERP, cloud, on-premises), and models complex data for analytics, ensuring scalability and maintainability.
• Creates and maintains visually appealing, interactive dashboards and reports using Incorta; translates business requirements into technical analytics solutions
• Manages and tunes Incorta load plans, optimizes data queries, and enhances dashboard performance for speedy, accurate business intelligence reporting.
• Provides technical guidance for development teams, conducts code reviews, shares best practices, and helps build technical capabilities within the team
• Works closely with business analysts, data engineers, and stakeholders to capture business requirements and convert them into data models and actionable insights
• Prepares technical architecture documents, defines implementation scope, and tracks deliverables for successful Incorta solution rollout
• Build business schemas, formulas, and joins in Incorta; leverages tools like SQL, ODI, PySpark, or Azure Data Factory for ETL and data orchestration
• Governs data migration activities, performance tuning, and ensures seamless upgrades or releases of Incorta solutions across environments.
• Conducts proof-of-concept (POC) solutions for new requirements, demos Incorta capabilities to stakeholders, and drives technical innovation.
• Extracts, normalizes, and harmonizes data from multiple transactional sources, ensuring robust reporting and dashboard creation across enterprise functions
• Develops and maintains database objects (tables, views, triggers, procedures) and advanced SQL queries essential for precise business intelligence and reporting.
• Creates complex scripts and code for data manipulation, aggregation, and transformation to support analytics and data warehouse solutions.
• Leverages UNIX shell scripting and Perl for data orchestration, automated data loads, ETL processes, and system automation, contributing to robust pipeline management and process monitoring.
• Troubleshoots and optimizes production data workflows, improving efficiency of batch jobs and integration tasks in large data environments.

Senior BI Analyst - TEK Content LLC - Winchester, Virginia

(2024-09 - 2025-01)

• Worked as Oracle Business Intelligence Developer which included managing and developing Dimensional Model
• Participated in the full data management lifecycle—including data sourcing, cleansing, transformation, and visualization—to support enterprise planning, reporting, and strategic insights.
• Served as an Incorta Developer, designing and managing direct data mapping models, schema definitions, and interactive dashboards to deliver real-time, actionable insights.
• Developed and maintained robust ETL/ELT pipelines using Informatica, Oracle PL/SQL, and Azure Data Factory, integrating data from systems like Siebel CRM and Oracle EBS into Incorta, Power BI.
• Enabled self-service analytics by building intuitive dashboards and secure data access layers across Incorta, Power BI, and cloud BI tools such as Google Data Studio and Looker.
• Collaborated with business stakeholders to define and translate reporting requirements, turning complex data sets into meaningful business intelligence solutions.
• Designed and implemented cloud-based data architectures using platforms such as Snowflake, Azure Synapse Analytics, and Google BigQuery, ensuring scalability, performance, and cost efficiency.
• Leveraged cloud-native features (e.g., data partitioning, serverless processing, auto-scaling) and integrated real-time and batch data from on-prem and cloud sources.
• Applied basic performance tuning at the schema and dashboard level, optimizing load times and refresh frequencies in Incorta and Power BI.
• Administered and maintained BI and data environments, handling schema refreshes, access control, and dashboard migrations across development and production.
• Automated server monitoring and routine maintenance using shell scripting on Oracle Linux VMs, enhancing system stability and uptime.
• Implemented data governance policies, including validation rules, access controls, and audit logs to ensure data quality, integrity, and compliance with industry standards.
• Supported Agile project cycles by delivering scalable and reusable data solutions, mentoring junior team members, and continuously identifying improvement opportunities.

Business Intelligence Developer - PAR Western Line Contractors - Winchester, Virginia

(2022-12 - 2024-07)

• Led the design, development, and implementation of Incorta dashboards to monitor and track critical business KPIs, integrating data from multiple sources including Origami, Fuel/Transportation systems, and SFTP feeds.
• Oversaw all Incorta administration tasks, including security configurations, user management, schema maintenance, and performance tuning to ensure system stability and scalability.
• Developed complex datasets, formula columns, and dashboards using Incorta 5.x, translating business requirements into functional, user-friendly analytics solutions.
• Monitored and optimized Incorta system performance, resolving data latency issues, improving dashboard load times, and ensuring high-quality reporting outputs.
• Provided training, documentation, and technical support for end users, enabling self-service analytics and increasing dashboard adoption across departments.
• Utilized Boomi integration platform for JD Edwards data integration, optimizing data flows, automating ETL processes, and ensuring data integrity across multiple systems.
• Conducted data validation, reconciliation, and testing to maintain accuracy and consistency of all dashboards and reporting outputs.
• Implemented role-based access controls and BI security policies, ensuring compliance with corporate data governance and regulatory standards.
• Collaborated with business analysts, IT teams, and stakeholders to identify reporting needs, improve analytics workflows, and deliver actionable insights.
• Participated in Incorta environment upgrades, migrations, and patching activities, ensuring minimal disruption and maintaining data reliability.
• Developed and maintained KPIs, metrics, and reports for Finance, Operations, and Supply Chain, supporting executive decision-making and operational efficiency.
• Supported ad-hoc reporting requests and data analysis tasks, providing quick turnaround insights for business-critical decisions.
• Evaluated and recommended best practices, tools, and methodologies to improve reporting efficiency, dashboard usability, and data quality.
• Worked with cross-functional teams to identify process gaps and implement automation in data pipelines, reducing manual effort and errors.
• Designing, building, and optimizing dashboards, schemas, and reports to deliver actionable business insights.
• Developing and tuning complex queries, stored procedures, functions, and packages for large-scale datasets.
• Automating data workflows, ETL processes, and scheduling to streamline operations.
• Supporting system integration and legacy data migration activities.
• End-to-end development and maintenance of ETL pipelines, data models, and performance tuning for enterprise reporting.
• Collaborating with cross-functional teams to ensure timely delivery of BI solutions and maintaining data accuracy across business functions.
• Builds integration processes with Boomi Atmosphere to enable smooth data flow between systems such as SAP, Salesforce, Dynamics 365, AWS, and other enterprise apps.
• Translates business requirements into robust, scalable technical integration solutions; manages data mapping, transformation, and API creation (REST/SOAP).
• Automates business processes, standardizes legacy integrations, and optimizes performance for reliability and scalability within enterprise environments.

SENIOR Technical Lead - Wipro Limited / Broadcom Inc. - San Jose, California

(2021-03 - 2022-12)

• Provided 24/7 Incorta supports the client, managing Level 2/3 incidents, problem resolutions, and system maintenance
• Conducted Incorta administrative tasks, including system audits, SOX compliance, patch management, and disaster re