This is my profileContact via CazVid
Mritunjay
Incorta Architect
Contact
Competencies
Demonstrated experience with Incorta.
Demonstrated experience with Power BI.
Demonstrated experience with OBIEE.
Demonstrated experience with Oracle 11g.
Demonstrated experience with SQL Server.
Education
Summary
Incorta Architect open to new opportunities
Experience
Senior Incorta Architect
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
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
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
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 recovery support. Managed ETL processes and supported daily Incorta BI jobs in collaboration with business stakeholders. Coordinated with cross-functional teams to define requirements and architect data models in Incorta. Prepared technical documentation and coordinated user acceptance testing for all Incorta deployments.
SENIOR Technical Lead
Designed and implemented analytics solutions for business processes across diverse domains. Created comprehensive documentation, including technical/functional specifications, test scenarios, data lineage, and migration plans. Engaged with stakeholders to gather requirements, propose business solutions, and ensure alignment with objectives. Migrated legacy systems to Snowflake, reducing data processing times by 30%. Build scalable data pipelines and modern data warehouse solutions using Snowflake. Enhanced and maintained ETL processes, ensuring accuracy and efficiency in data integration workflows. Worked with ETL and data transformation tools, including Informatica and Matillion, to support data processing and reporting needs. Planned and managed deliverables, coordinated team activities, and ensured timely and quality project execution. Analyzed existing systems, proposed improvements, and implemented solutions to meet evolving business needs. Facilitated cross-functional collaboration through status meetings and task delegation.
Associate Consultant
Collaborated with stakeholders to gather business and technical requirements, estimate project scope, and create implementation plans. Developed and maintained dashboards, reports, and visualizations using OBIEE 11g for business intelligence needs. Created and managed repository (RPD) files including Physical, Business Model, and Presentation layers. Designed and developed interactive dashboards and reports using OBIEE Answers and Interactive Dashboards. Implemented security layers by setting up users, roles, and privileges in OBIEE to control data access. Tuned reports and dashboards for performance optimization, improving query response times. Integrated OBIEE with various data sources, ensuring seamless data flow and reporting. Provided support for OBIEE upgrades and migrations, ensuring minimal downtime and data integrity. Performed unit and integration testing of reports and dashboards, ensuring accuracy and performance. Created oracle ERP OTBI/BIP reports to help businesses for their day to day activities. Used the BIP report Scheduling and Bursting mechanisms to make the reports to send alerts with more interactive manner.
Senior Project Engineer
Assessed proposed solutions against existing functionality to identify risks, discrepancies, and required corrective measures, ensuring alignment with business objectives.. Led the collection, analysis, and documentation of business requirements, defining project scope and delivering actionable insights for enhancements to existing functionalities.. Resolved user-reported issues, system errors, and inconsistencies during development, testing, and post-deployment phases.. Prepared high-level and low-level technical designs, providing accurate project estimations and timelines to clients.. Designed and developed data models for reporting and analytics, leveraging Informatica to perform ETL processes from OLTP to OLAP systems.. Modified and optimized Informatica workflows to implement new business logic and support ongoing project requirements.. Automated recurring business processes using ETL and scripting solutions, improving operational efficiency and reducing manual efforts.. Managed BI security groups and configured role-based access controls to ensure compliance with corporate access control policies.. Enhanced report performance through query optimization, indexing, and tuning, reducing execution times and improving user experience.. Directed and managed a 10-member offshore team, ensuring effective task delegation, adherence to deadlines, and quality delivery of objectives.. Collaborated with cross-functional teams, including developers, QA, and business analysts, to ensure seamless implementation of solutions.. Participated in stakeholder meetings and provided technical guidance and support to facilitate decision-making.. Contributed to process improvement initiatives, documentation standards, and knowledge-sharing practices within the team.