Data Solutions Consultant

Data Analytics Clemson, South Carolina, United States

Profile
Contacts

Summary

Subway (Restaurants/Retail) Sr. Consultant (Marketing Data Analysis and Business Strategy)

- Curated customer loyalty data, wrangled and statistically analyzed the databases for helping the marketing team increase the reach
- Analyzed customer data for invalid phone numbers, emails in the databases for the database cleanup effort saving over 25% space
- Regulated the database as well as data quality by formulating the business logics while building data mappings
- Assisted Subways Loyalty marketing team with critical decisions on merging and managing customer data in the enterprise databases
- Devised methods to manage and clean duplicate data, multiple profiles across various platforms like Reltio, AWS Redshift data warehouse
- Designed business logics with the Subways Product team for user interface (UI/UX) of customers web account.

National Grid (Utilities) Data Engineer (Master Data Management)

- Developed transformation logics, diligently working with the business team for MDM data loads to check data quality and correctness
- Formulated the rules for extracting, profiling, cleaning the data, and loading as per the business requirements
- Wrangled the customer data while data migrating, saving data storage space by removing about 20% of the dirty records from the tables
- Contributed to the end-to-end testing of the data architecture, the tables, views, schemas, and data pipelines
- Successfully migrated transformed customer data from IBM DB2 database to Snowflake and Reltio MDM
- Designed MDM data mappings for tables & columns in source database to be loaded into Reltio as master data using Matillion ETL pipelines.

Canon Europe (Electronics)

- Administered Oracle EPM modules with specific focus on products data and financial modules (multi-year planning)
- Built and maintained Essbase cube outlines, calculation scripts, dimension builds, batch automation scripts, business rules and data loads
- Monitored and managed Oracle load process (ad-hoc requests and nightly scheduled loads), data validation and resolving load issues
- Optimized Essbase applications for performance improvement for data loads, aggregations and calculations and data retrievals

Rolls-Royce UK (Automobile)

- Designed, developed, and deployed solutions for business automation on Oracle Hyperion applications & functionality
- Provided primary support in development, testing and maintenance of reports and dashboards using ad-hoc queries, SmartView, financial reporting reports as requested by business users
- Successfully performed ad hoc analysis on planning forms in Planning and admin web console, managing attribute dimensions on the business user data using dimension grids and pivot-tables