NEERAJ IYER
Data Engineer / Data Analyst/ BI Analyst
Chicago,IL
Summary
Results-driven professional with knowledge in data warehousing, databases, data analysis and business intelligence. Skilled in leveraging data to drive actionable insights, optimize processes, and support strategic data-driven decision-making. Expertise in SQL, data visualization tools, Python, and other data tools. Known for dedication, hard-work , adaptability and collaboration with passion for Data
Overview
9
9
years of professional experience
6
6
years of post-secondary education
10
10
Certifications
Work History
Cloud Data Engineer Sr. Consultant
Baker Tilly Advisory Group
Chicago, Illinois
06.2021 - Current
- Built Azure data factory pipelines to load data to staging databases, Used Snowflake along with Snowpark to analyze data and Airflow to orchestrate pipelines. Utilize Microsoft fabric for latest data solutions.
- Executed SQL queries for data manipulation. Created Proof of Concept on Microsoft 365 Copilot to automate excel tasks, PowerBI' s Copilot and Quicksight Q to utilize its generative BI capabilities.
- Optimized data processing by implementing efficient ETL solutions, Automated manual tasks and re designing infrastructure to optimize data solution delivery.
- Worked on extraction of text from pdf documents using Python scripts & AWS Textract. Developed database artifacts.
- Assembled, prepared large data sets, performed data modeling, Database development, Analyze and interpret trends.
- Built API integrations using Python/SQL programming languages for cloud based solutions.
- Engaged in building chatbots, reports, API's, lambda functions using various AWS services. Use of various AWS data engineering services (QuickSight, Lex, Lambda, API Gateway, Elastic Search, Athena, SNS, SES, Glue, Redshift, Sagemaker)
- Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
Cloud Data Engineer Consultant
Baker Tilly Advisory Group
Chicago, Illinois
07.2019 - 06.2021
- Built reports using ELK stack, Power BI, Quicksight, SSRS to identify insights about data using complex data sets.
- Engaged in building chatbots, reports, API's, lambda functions using various AWS services. Use of various AWS data engineering services (QuickSight, Lex, Lambda, API Gateway, Elastic Search, Athena, SNS, SES, Cloud formation, Glue, Redshift)
- Created wireframes, architectural diagrams for a project proposal and designed database architectures.
- Used SQL skills to analyze data using Sql server, Snowflake, Postgres Sql, Oracle. Build SQL pipelines and dashboards to reduce report generation by 40%
- Ingested data into databases using python code and performed data transformations on csv/xlsx files. Automate excel reports using python.
Data Engineer Intern
Northwestern Mutual
Milwaukee, Wisconsin
05.2018 - 08.2018
- Company Overview: Northwestern mutual is an American financial services organization based in Milwaukee.
- Worked on Power BI reporting for visualizing data quality report, JIRA report.
- Modified and executed ETL Autosys Jobs and JAWS which is a batch visualization tool.
- Used ELK stack to connect DB2 database to Elastic search and create visualizations on Kibana.
- Performed Power BI API call to visualize weather data of 5 cities.
- Created real-time dashboard on Power BI using Python API call.
- Extensively worked on SQL queries.
- Presented my work to the entire team during the sprint demo and my work was appreciated among team members and from other teams for precise description of my work and good time management.
Data & Deployment Engineer (Oracle Flexcube) - Associate Consultant
Oracle Financial Services Software Ltd
Mumbai, India
03.2017 - 07.2017
- Company Overview: OFSS is an IT solution provider to the banking industry where I worked as a data & deployment engineer for a top client in banking sector.
- Visualized JIRA data extracts using Tableau, Used python for extracting and cleaning data.
- Involved in Database Administration to take database backups, create databases, release locks, clean logs, manage passwords, shutdown and start of server.
- Hosting Apache Tomcat logs hosting on web. Experience in working with SQL and PL/SQL queries.
- Perform daily deployment of various artifacts of 50 team members and notify to team members if there were issues related to their code.
Data & Deployment Engineer (Oracle Flexcube) - Consultant
Randstad India Pvt Ltd
Mumbai, India
01.2016 - 03.2017
- Deployed to Oracle Financial Services Software Ltd for a top client in banking sector.
- Company Overview: OFSS is an IT solution provider to the banking industry where I worked as a data & deployment engineer
- Improved deployment efficiency by streamlining processes and implementing automation tools.
- Build and Deploy artifacts on IT, UAT environments.
- Used Jenkins for continuous integration, delivery to save at least 50% time from manual process.
- Visualized JIRA data extracts using Tableau, Used python for extracting and cleaning data.
- Packed & unpacked environments instead of creating a new integration environment. Used Linux, shell scripting, Weblogic, IBM MQMs, BIP, Docker. Built an application using Oracle APEX and PL/SQL.
- Increased customer satisfaction by providing timely and accurate updates on deployment progress.
Education
Master of Science - Information technology & Management-Data Management
Illinois Institute of Technology
Chicago, IL 05.2017 - 05.2019
Bachelor of Science - Computer Engineering
University of Mumbai
Mumbai, India 05.2011 - 06.2015
Skills
SQL
Python
R
Bash scripting
Linux
PL/SQL
Oracle
MySql
Ms-Access
SQL Server
Mongo DB
Oracle Apex
Eclipse
Tableau
SSIS,SSRS,SSAS
Power BI
Amazon Quicksight
Data analytics
ELK
JIRA
Excel
Jupyter Notebook
HTML/CSS
Github
Spyder
PowerPoint
Oracle BI
Putty
AWS/Azure Data engineering
Big data technologies- Hive, Kafka
Waterfall,Agile methodologies
Snowflake, Snowpark
Airflow
Copilot/Amazon Q
Dbt fundamentals
NoSQL databases
Metadata management
Data modeling
Data warehousing
Data pipeline design
ETL development
Redshift, Glue, S3, Athena
Data visualization
Certification
AWS Certified Solutions Architect Associate, AWS, 02/01/21
Publications
- Survey on metadata management schemes in HDFS, IJCSIT, 05/01/14
- Survey on Online recommendation system using Web usage mining, IJCSIT, 03/01/15
Accomplishments
AWS Certified Data Analytics Specialty Certification
AWS Certified Data Engineer Associate Certification
All builders grant mentor at AWS re:Invent
AWS community builder for the 5th consecutive year
Timeline
Cloud Data Engineer Sr. Consultant
Baker Tilly Advisory Group
06.2021 - Current
Cloud Data Engineer Consultant
Baker Tilly Advisory Group
07.2019 - 06.2021
Data Engineer Intern
Northwestern Mutual
05.2018 - 08.2018
Master of Science - Information technology & Management-Data Management
Illinois Institute of Technology
05.2017 - 05.2019
Data & Deployment Engineer (Oracle Flexcube) - Associate Consultant
Oracle Financial Services Software Ltd
03.2017 - 07.2017
Data & Deployment Engineer (Oracle Flexcube) - Consultant
Randstad India Pvt Ltd
01.2016 - 03.2017
Bachelor of Science - Computer Engineering
University of Mumbai
05.2011 - 06.2015