I am a graduate with Masters in Information Systems from Northeastern University with a core background in Data Warehousing & Business Intelligence with Advances in Data Science & Architecture using Python. Prior to my graduation I have about a year of experience as a Data Analyst.
For the past 2 years, I have been working Database Design and Management, Handling large datasets and building visualization reports using some BI Tools - like Tableau majorly, but also other tools like PowerBI, QlikSense. With that I am also certified in Tableau Desktop Specialist.
During my masters I secured a Co-op opportunity at HighRes Biosolutions as an Data Engineer Co-op where my major responsibilities were with data Analysis, making data models for the stakeholders, doing data integration using ETL between 2 large information systems like PLM and ERP, also took lead of live data migration from legacy CRM to Salesforce CRM platform. This involved me to convert the requirements to the desired end result where I ensured the deliverables are met . While was the data manager in the data migration project where I handled everything from Data sources, connecting with Salesforce Architects, testing and then performed LIVE migration successfully. Also with this I was responsible for making dashboards and reports in Tableau BI platform for the Sales and Executives - I love pouring data, spotting trends, predicting future outcomes, creating informative displays and explaining the results in a way that makes sense.
★ Skills:
• BI and Data Integration : Tableau, Qlik View, Power BI, Talend Studio, SSIS, Jitterbit Studio
• Programming languages : SQL, Python, R
• Databases : MySQL, MS SQL Server, Oracle, PostgreSQL, AWS Redshift, MongoDB
• Cloud Technologies (AWS) : VPC, EC2, Lambda, Cloudformation, Cloudwatch, CodeDeploy, S3, RDS,
DynamoDB, IAM, Route53, SES, SNS, WAF, AWS CLI
• Tools and IDE : MS Azure, Jupyter Notebook, GitHub, Toad Data Modeler, Eclipse, SOAP, REST API
• Program Management tools: Sharepoint, OneDrive, Slack, VeleroPPM, MS Project, Google Forms
• Proficient in using MS Excel (Pivot tables, Index, Match, VLOOKUP, Charts, Solver)
-
Experience
Data Engineer Co-op, Jul 2018 – Dec 2018
HighRes Biosolutions,Inc, Beverly, Massachusetts, USA
•Built complex integration data model on Jitterbit using SOAP web service for extracting data from Omnify PLM to Visibility ERP
• Created Reports & Dashboard using Tableau to track progress of business and facilitated data-driven decision making
• Constructed advanced SQL scripts to extract data from SQL server which saw 23% increase in query performance
• Migrated large volumes (150M rows) of internal data from legacy CRM on to Salesforce.com with Jitterbit and Data Loader
• Solved data integrity issues and developed data migration templates which resulted in improvement in data consistency
• Involved in data mapping from SQL Server to Salesforce.com leading to data migration of leads, accounts, opportunities and
contacts to the Sales Cloud with the help of Jitterbit which increased efficiency by 45%
Product Development Intern
YieldCurve Analytics Private Limited, Mumbai, India
•Performed data analysis of legacy financial market data using Excel (Macros) and performing ETL from various source systems
• Audited and improvised new business strategies based on the client feedback to improve performance and customer service which
led me to take the ownership and responsibility of 10 clients contributing to a revenue of $10K
Data Analyst Intern
ONGC (Oil and Natural Gas Corporation Ltd.), Mumbai, India
• Worked on e-BDP (book of delegated power) by translating business needs into actionable technical and prepared custom dashboards using PowerBI for multiple clients analyzing their revenues weekly by different users
• Complied datasets containing more than 1 million rows determining current trends, demographics, and contributors of the product
-
Projects
Visualizing Covid-19 using R
• Visualized data from early months of the coronavirus outbreak to see how this virus grew to be global pandemic
• Manipulated data frames using dplyr and making plots using ggplot2
Retail Datawarehouse - https://public.tableau.com/profile/neelambari.verma#!/
• Created Dimensional model of AdventureWorks database in Toad Data Modeler simplifying Data Warehouse creation
• Performed ETL using Talend & SSIS to migrate data from multiple sources to target warehouses in MySQL, SQL Server
• Visualized and provided insight on data by creating interactive, elegant dashboards in Tableau, PowerBI and Qlik View
• Implemented Error Handling, Load Statistics, Slowly Changing Dimensions, and Performance Tuning with 48M rows
Prediction and Classification of Mushrooms
Pre-processed and cleaned Mushroom Analytics dataset for missing values, outliers using Python Matplotlib & Seaborn
• Performed EDA on dataset to find edible mushrooms using Pandas & Numpy; identified mushroom groups based on contribution of a variety of factors using KMeans clustering and Regression models in Python
Cloud Computing Project
Implemented Spring Security Enabled Spring Boot webapp interacting with multiple AWS services like RDS, SNS, IAM, S3 running on Load Balanced, Auto-Scaling EC2 instances with application logging on CloudWatch
Achieved Continuous Integration with Circle CI and AWS Code Deploy and automated shell scripts to create and teardown
CloudFormation stack resources like VPC, Internet gateways, Route tables, Subnets, EC2 instances and RDS