Jaspreet Sahota E-mail: adx3zy@r.postjobfree.com

Ph.: 713-***-****

PROFESSIONAL SUMMARY

Experienced Data Engineering professional with 5 years of experience in designing and executing solutions for complex business problems involving large-scale data warehousing, real-time analytics, data ETL, Business Intelligence (BI), reporting solutions and customer experience. Seeking opportunity to expand my skills by growing with an organization and be part of a team that acknowledges my potential and willingness to work in a high-energy environment. SKILLS

AWS: S3, S3 Glacier, Redshift, Route 53, Athena, Cloudwatch BI Tools: Tableau, Power BI, Google Data Studio, SSIS Databases: Aginity workbench for Redshift, MySQL, MS SQL Server, Oracle, PostgreSQL, Google BigQuery ETL Tools: ChannelMix, Supermetrics, Datorama, funnel.io Issue & Project Management Applications: Yodiz, Trello, JIRA, Zendesk, Asana, HubSpot, Bugzilla Methodologies: Agile (Scrum), SDLC, Waterfall

Soft Skills: Excellent verbal and written communication, Fast learner, Critical thinking, Detail-oriented Tools & Technologies (other): Base SAS, SSAS, Visual Studio, MS office tools, MS Sharepoint, Balsamiq, GitHub, Visio, Lucidchart, GoDaddy

WORK HISTORY

Data Architect/Engineer (Client facing role) Aug 2019 – Dec 2022 ChannelMix (formerly Alight Analytics)

● Evaluate clients' requests for completeness and feasibility and design data integration solutions for their business needs [Noteworthy fact: Solo Data Engineer for Pipeline Analytics Product that focused on customer’s marketing campaign journey].

● Develop, maintain and enhance data curation pipeline models connecting marketing to sales funnel using business essential KPIs in a single data model [Noteworthy fact: Solo Data Engineer for 3 pods containing more than 35 clients including firms like Academy Bank, Konica Minolta, Adidas, etc].

● Develop solutions for datasets combining multiple marketing data sources (cross channel performance) at different levels of aggregation [Noteworthy fact: set up and maintain more than 20 data models for each client].

● Monitor and optimize data ETL processes from marketing services to ChannelMix Data Warehouse, in-house marketing intelligence platform that powers holistic analytics solutions for marketers.

● Designed internal process improvements to automate repetitive tasks, shortening data delivery times.

● Developed scripts and processes for data integration and maintenance.

● Set up design models as proof of concepts for business prospects.

● Actively communicating with clients (agencies and large brands) via ticketing system to address and solve their business needs and issues related to data.

● Performed query, quality check, and implemented updates using PostgreSQL as Data Engineer.

● Perform UAT on different platform integrations to support the end products.

● Troubleshoot discrepancies in reporting dashboards and predictive models. Database Developer (Client facing role) Nov 2017 – Aug 2019 ChannelMix (formerly Alight Analytics)

● Worked with clients to understand their business needs and set up meaningful datasets accordingly.

● Used in-house ETL tool to automate and load client's marketing data into ChannelMix Data Warehouse which uses AWS Redshift framework.

● Developed and updated databases to handle data.

● Get familiar with several marketing platform integrations like Google Analytics, Google Ads, Facebook Ads, Salesforce, Bing Ads, etc. and use those API integrations to set up meaningful reporting datasets for clients.

● Troubleshoot clients' data quality concerns by validating API data against the UI for more than 100 platforms.

● Troubleshoot failed data pulls and communicate directly to clients as well as necessary departments.

● Review, write and update documentation on team processes. Distance Learning Coordinator Aug 2015 – Dec 2016

University of Nebraska at Omaha

● Worked under the IT department with a team to achieve distance learning program’s goals.

● Worked closely with program managers on system problems.

● Assisted in performing quality check on distance classroom support applications (Cisco devices, AMX monitor etc.) by referring to requirements and objectives.

● Performed analysis on newly developed application (AMX desktop application) by trying different input and output combinations on application making sure that the objective is met.

● Assisted professors and the supervisor in scheduling hour-to-hour schedules for distance classes. EDUCATION

Management Information Systems, Master of Science Jan 2015 – Dec 2016 University of Nebraska at Omaha, Omaha, NE

Information Technology, Bachelor of Engineering Aug 2009 – Jun 2013 Arya College of Engineering & Research Center, Jaipur, Rajasthan, India CERTIFICATION

Google Analytics Certification Mar 2023

Skillshop

System Analysis and Design Certificate Dec 2016

University of Nebraska at Omaha

Contact this candidate