Intelligence Developer Data Analyst

Ishan Verma

Torrance, CA ***** • 972-***-**** • ************@*****.*** • www.linkedin.com/in/ishan94verma/

Professional Summary

Business intelligence and analytics professional with 3+ years of experience in designing, developing, testing, and deploying enterprise level data warehousing solutions using SQL, MSBI (SSIS, SSRS, SSAS), Power BI, Python, and Azure.

A self-motivated learner with proven track record in data modeling, analytics, and visualization by understanding customer requirements and translating them into actionable project plans with data-driven insights.

Work Experience

OSI Systems, Hawthorne, CA 09/2019 - Present

Business Intelligence Developer

Build end to end, fully automated BI solutions involving data integration through ETL jobs from multiple source systems to data marts and delivered performance score cards/reports through scheduled subscriptions/alerts to 500+ users based on dynamic row level security.

Engineered and implemented a fully semantic and dimensional general ledger data mart by merging data from multiple source systems like Dynamics 365 Finance & Operations, Navision, and MFGPro, using SQL, SSIS, SSAS, Power BI, and loaded 100K+ daily general journal entries for corporate finance and accounting departments.

Spearheaded multiple interactive applications and dashboards using Microsoft Power Apps and Power BI to eliminate manual reporting reducing reporting time and increasing self-service usage metric by 29%

Created and optimized workflows using incremental load patterns, slowly changing dimensions, and lookups to load data into data marts using Azure Data Factory, SSIS and SQL

Conducted data loads and ad-hoc analysis for senior leadership including SVPs, CFO and COO on company’s FP&A activities: annual budgeting, forecasts, account reconciliation, management reporting and financial reporting.

Designed and presented Power BI dashboards to align multiple business teams on common KPIs and increase visibility into possible root causes of irregular business performance.

Trained junior developers and interns on fine-tuning SQL queries and build compelling visualizations & dashboards.

Technology Stack - MS SQL Server, SSIS, SSAS, SSRS, Power BI, Power Automate, Python, Azure Data Factory, Azure SQL Database, Microsoft Dynamics 365 Finance & Operations, Navision, MFGPro, Oracle Data Modeler, HFM, BigMachines

Tech Mahindra Americas, Plano, TX 09/2018 – 12/2018

Business Intelligence and Analytics Intern

Automated data validation and loading process using Python for weekly POS file generation, channel inventory report generation and monthly promotion file generation, reducing human errors and manual effort by 500%

Developed and tested ETL pipelines using SQL, Alteryx, and Tableau for senior executives to track service reliability and metrics and report monthly/quarterly/yearly operational availability trends.

Worked with senior data architects, database administrators, and business stakeholders to determine the requirements to identify entity and attributes to build conceptual, logical, and physical data models.

RR Parkon, Delhi, India 05/2015 – 07/2016

Data Analyst

Developed and tested SQL queries and Tableau reports to provide in-transit vehicle visibility to delivery center, in the supply chain pipeline, thereby, enhancing delivery efficiency by 7%

Developed and maintained 50+ SQL stored procedures, views, tables, and functions in the data warehouse.

Build KPIs to optimize outbound logistics’ operational effectiveness and identify trends to perform toot cause analysis.

Utilized VBA and Excel to automate daily/weekly/monthly report generation with data integrity and quality checks.

Technical Skills

Business Intelligence : MSBI (SSIS, SSRS, SSAS), Power BI, Tableau, Alteryx

Programming : SQL, Python, VBA, C#

Database : MS SQL Server, Oracle, MySQL, PostgreSQL

Cloud Platform : Azure (SQL Database, Data Factory, Analysis Services, DevOps, Data Lake), AWS (S3, Redshift)

Other Tools : Microsoft Dynamics 365 Finance & Operations, Power Automate, PowerApps, Git, TFS, Jira

Education

M.S. Information Technology and Management, The University of Texas at Dallas, Richardson, TX 08/2016 - 12/2018

B.A. Economics (Honors), University of Delhi, Hans Raj College, New Delhi, India 07/2012 - 07/2015

Contact this candidate