Ankit Sharma
- Role
- Analytics Developer - Enterprise Data Warehouse at Northwestern Medicine
- Location
- Wheeling, IL, US
- LinkedIn followers
- 500 followers
About Ankit Sharma
I am an IT Professional having 5+ years of experience with an emphasis on Data…
Experience
Analytics Developer - Enterprise Data Warehouse
Apr 2021 — Present
Develop SSIS packages to extract data from different sources like Postgres, Oracle, Flat Files transform and then load to MS SQL Server. • Analyzed source data to identify data quality issues and developed strategies to address them, resulting in a 30% reduction in data errors and inconsistencies. • Troubleshoot issues related to daily, weekly, and monthly ETL load. • Responsible for maintaining and performing quality assurance for all the nightly ETL jobs for more than 75 + data sources. • Created pipelines in ADF using linked services to extract, transform and load data from multiple sources like Azure SQL, Blob storage and Azure SQL Data warehouse. • Created multiple repositories in Azure DevOps and developed data pipelines to manage the resources across multiple environments (staging, ingestion, and production). • Develop reports using complex formulas and query the database to generate different types of ad-hoc reports using SSRS, Tableau and Power BI. • Assist and train other departments in the design of ETL process using the internal ETL tool and SSIS. • Perform administrative and support activities across Tableau infrastructure including security administration, installation, and configuration of the Tableau server.
Education
Pace University
Master's degree, Information Systems
2015 — 2017
Saint Peter's University
Master's degree, Business Analytics
Rajiv Gandhi Prodyogiki Vishwavidyalaya
Bachelor of Engineering, Information Technology
2008 — 2012
Skills
- Html
- Business Development
- Php4/5
- Sql
- Java
- Microsoft Excel
- Big Data Analytics
- Strategic Planning
- Sailpoint
- Html 5
- Stat Tools
- Microsoft Visio
- Data Management
- Drupal
- Data Analysis
- Sdlc
- Predictive Analytics
- Statistics
- Microsoft Powerpoint
- Microsoft Office
- Wordpress
- R
- Oracle Pl/Sql Development
- Enterprise Resource Planning (Erp)
- Pivot Tables
- Business Analysis
- Css
- Tableau
- Mysql
- Cascading Style Sheets (Css)
- Hive
- Team Management
- Customer Relationship Management (Crm)
- Microsoft Access
- Project Management
- Data Mining
- Hdfs
- Hadoop
- Arcgis
- Web Development
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.