Archit Mishra
Cary,NC
Summary
Accomplished Data Analytics professional with 15 years of IT experience providing robust and scalable Business Intelligence and Data Warehousing solutions, focused upon strategy and data-driven decision-making. With an objective of improving operational effectiveness, achieved up to 90% reduction in the processing times, 30% improvement in the dashboard performance and 25% cut in the maintenance costs.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Technical Manager
HCL America
10.2016 - Current
- As Data Analytics Lead, managed team of 9 data engineers, for Optum (UnitedHealth Group) - US. Streamlined Claims, Provider and Member data pipelines, that pulled data from EDI, XML, JSON files, reducing throughput time from 90 minutes to 30 seconds. Designed OMMS dashboards, reports, KPIs and improved data availability by 30%.
- As Data Visualization Architect for Maximus Inc - US, laid down BI roadmap for MPC project. Utilized data from Jira, Jama and SonarQube to implement Sprint Progress dashboard for Core, Nebraska and Tennessee. Automated solution helped cut down maintenance costs by 50%.
- As Business Intelligence Manager for Public Consulting Group - US, conceptualized and designed COO Books, an Operations product that served the purpose to all the decision-making wants of the Executive Leadership. The Key Performance Indicators for financial modules like Revenue, CM, AP & AR helped escalate profit margins by 15% and bring down the resource costs by 67%.
- While working in EDIFECS and DSNP projects as Data Analysis Lead for LA Care Health Plan - US, identified business requirements, drafted mappings, assisted Business Users during UAT phase, created Test Plans, TRDs, and automated Test Scripts thereby cutting down overall team effort by 13%.
- Exposure of conducting Scrum ceremonies, prioritizing features and US from Product Backlog, defining acceptance criterion and dependencies.
- Sound exposure in hiring, coaching, managing, and grooming BI-DWH professionals.
IT Analyst
Tata Consultancy Services
05.2016 - 10.2016
- As Data Analyst for Airtel, India, designed Operational Data Store for Fixed Assets, Inventory Aging and CWIP modules which helped cut down processing times by 40%.
BI Technical Staff Consultant
Oracle
01.2015 - 04.2016
- As Business Intelligence Consultant, implemented the EDW solution for Statoil Fuel & Retail, Norway and Uganda Revenue Authority, Uganda.
- Orchestrated design of EDW and ETL framework, resulting in 20% reduction in data processing times and 25% increase in data analysis efficiency.
Application Developer
IBM
03.2013 - 01.2015
- Catered to DWBI wants of Enbridge Pipelines, Canada as ETL Developer.
- Utilized Journalization (CDC through JKM), SCD, Parallelism, External Tables to process 19GB data per 10 minutes, thereby improving performance by 75%.
Senior Systems Engineer
Infosys Technologies
07.2009 - 02.2013
- As ETL Developer for Reed Elsevier, UK, did multiple POCs, KM customizations, SQL tuning, Error Handling, and Code Reviews. Enhanced PL/SQL blocks to reduce error volume by 30%.
Education
Bachelor of Technology - Information Technology
Uttar Pradesh Technical University
India06.2009
Skills
- Business Intelligence & Data Visualization (Power BI, Tableau, SAP Crystal Reports)
- ETL (Alteryx, Talend, ODI, DataStage, Informatica)
- Data Governance
- Data Integrity
- Data Quality
- Data Security
- Data Analysis
- Data Warehousing
- Data Modeling
- Cloud (AWS, Amazon Redshift, AWS Glue, Amazon S3)
- Python (Pandas, NumPy, Matplotlib, Seaborn)
- SQL (PL/ SQL, T-SQL)
- DAX, Power Query
- Database (Oracle, MS SQL Serve, MySQL, Teradata)
- Scheduling/ Orchestration/ Monitoring (Airflow, Informatica Workflow Monitor, Alteryx Scheduler, TWS, Control-M)
- Statistics/ Mathematics
- Agile
- Scrum
- Kanban
- Jira
- Rally
- Confluence
- Jama
- Microsoft 365
- Excel
- Word
- Outlook
- Teams
- OneDrive
- PowerPoint
- SharePoint
- Other Data Formats
- Files (EDI, XML, JSON, CSV, EXCEL, TXT, TrueXC)
- Web (Jira, Jama, SonarQube, Salesforce)
- FACETS
- EDIFECS
- DSNP
- VS Code
- Jupyter Notebook
- Git
- GitHub
- Jenkins
- SVN
- Erwin
- Visio
- Lucidchart
- Windows
- Linux
Certification
- Tableau Desktop Specialist
- Certified Scrum Master : Scrum Alliance
- SMAC (Scrum Master Accredited Certification: International Scrum Institute
Recognition
- HCL OInfinity Award (2022, 2021, 2020, 2019)
- HCL Xtramiles Spot Award (2021)
- UHG Diamond Bravo Award (2020)
- HCL Livewire Award (2018)
- IBM Mgr’s Choice Award (2014)
Certification
- Certified Scrum Master - Scrum Alliance
- Tableau Desktop Specialist
Timeline
Technical Manager
HCL America
10.2016 - Current
IT Analyst
Tata Consultancy Services
05.2016 - 10.2016
BI Technical Staff Consultant
Oracle
01.2015 - 04.2016
Application Developer
IBM
03.2013 - 01.2015
Senior Systems Engineer
Infosys Technologies
07.2009 - 02.2013
Bachelor of Technology - Information Technology
Uttar Pradesh Technical University