Summary
Overview
Work History
Education
Skills
Timeline
Generic

TEJAS PATEL

North Brunswick,NJ

Summary

Results-oriented IT professional with over 20 years of hands on experience, excellent attention to details, a passion for owning and producing top-quality deliverables and disciplined to meet deadlines and commitments. Extensive experience in Database design Architecture, Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning. Expert level skills in designing and implementing complex ETL/ELT processes. Extensive experience in Business Intelligence in SQL Server Integration Services (SSIS) , SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). Experience on Azure SQL Database, and Azure SQL Data Warehouse, Azure Data Factory, Power BI, AWS Glue (Python, PySpark), Redshift. Proficient in understanding business processes / requirements and translating them into technical requirements.. Creative, hardworking team player with good written and verbal communication skills and strong focus on end user needs.

Overview

23
23
years of professional experience

Work History

Senior Data Engineer/Architect

The Children’s Place
Secaucus, NJ
02.2022 - Current
  • Lead architect and engineer for the design and implementation of CRM/Loyalty system for The Children’s Place
  • Key role in successfully building a CRM/Marketing/Loyalty system for the Children’s place on AWS Redshift platform
  • Specific responsibilities included:
  • Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes for a data warehousing and Data Migrations projects using AWS Glue (Python, PySpark) against Redshift
  • Work closely with external vendors (Epsilon and Exact Target) to design incoming/outgoing customer email activity feeds within CRM/DW
  • Responsible for CRM/Loyalty program development including customer segmentation strategies, direct email campaigns, tracking customer’s behavior (open/clicks), Omniture data (web log), Loyalty point’s engine, coupon push
  • Designed and developed Cognos and PowerBI reports according to user requirements
  • Analyze performance issues, perform RCA and provide resolutions for immediate fix and also recommend/build long term solutions to resolve the root cause
  • Establish coding standards, perform code review and automate the health of the platform

Lead BI Engineer/Architect

Burlington Stores Inc
06.2021 - 02.2022
  • Lead architect and engineer for the design and implementation of enterprise data warehouse for Burlington Stores
  • Specific responsibilities included:
  • Design & develop an Enterprise Data warehouse system to feed Burlington stores information from multiple systems throughout the organization
  • Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes for a data warehousing and Data Migrations projects using Unix shell scripts/Python against Netezza database
  • Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Azure SQL DW, PostgreSQL DB)
  • Liaise with business subject matter experts in analyzing business requirements and translating them into detailed conceptual data models, process models, logical models, physical models and schema development in the database
  • Maintain and support MicroStrategy cubes and reports
  • Manages end-user accounts and accessibility; provides technical expertise to end-users who create complex queries and reports
  • Responsible for migrating existing data warehouse application from Netezza to Azure cloud data warehouse
  • Environment: Unix, Netezza, SnowFlake, Azure, ADF, MicroStrategy, UC4, PowerBI.

Senior Data Engineer

Smartlinx Solutions
06.2018 - 06.2021
  • Smartlinx is the leader in HCM solutions for skilled nursing, long term care, assisted/independent living, and rehabilitation facilities
  • Lead architect/team lead for the design and implementation of BI (SpotLight) module of HRMS system
  • Key role in successfully building and implementing BI solutions for Smartlinx clients
  • Specific responsibilities included:
  • Responsible for architecting and designing a high-performance BI solutions on Microsoft Azure SQL server platform
  • Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Azure SQL DW, PostgreSQL DB)
  • Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment
  • Experience in DWH/BI project implementation using Azure DF
  • Created pipelines to migrate the data from on-prem resources through the data lake and load the data into the Azure SQL Data warehouse
  • Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes for a data warehousing and Data Migrations projects using Integration services
  • (SSIS) on SQL Server 2005/2008
  • Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell, Python
  • Responsible for moving Data in and out of Windows Azure SQL Databases and Blob Storage, monitoring and troubleshooting SQL Jobs, Scheduled Tasks, Disk spaces, Error logs and making recommendations for performance improvement which involved Index creation, Index removal, file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics
  • Environment: Microsoft Azure, SQL Server 2014/2019, Logi, VSTS, Jira, Flash, Angular, Redgate, SQL SentryOne, PostgreSQL, PowerBI, Python.

Data Engineer/Team Lead, Lead architect

The Children’s Place
Secaucus, NJ
02.2014 - 06.2018
  • And engineer for the design and implementation of CRM/Loyalty system for The Children’s Place
  • Key role in successfully building a CRM/Loyalty system for the Children’s place
  • Specific responsibilities included:
  • Responsible for CRM/Loyalty program development including customer segmentation strategies, direct email campaigns, tracking customer’s behavior (open/clicks), Omniture data (web log), Loyalty points engine, coupon push
  • Track, analyze and report on consumer activity and behavior
  • Transform data into actionable strategic insights and recommendations to optimize the customer experience in store and online
  • Designed complete ELT (Extract / Load / Transform) and management framework that leveraged Netezza for all of the data transformation and loading, while minimizing maintenance and development effort
  • Perform database maintenance activities such as backup/restore, performance monitoring and tuning, security configuration, workload/resource management, data distribution, data reclaim and health checks
  • Work closely with external vendors (Epsilon and Exact Target) to design incoming/outgoing customer email activity feeds within CRM/DW
  • Environment: Netezza, DataStage, DB2, UC4, Cognos, Oracle 11g, Linux, Aginity, Hadoop

Datamart Specialist

Hess Corporation
, NJ
09.2012 - 02.2014
  • Lead architect and developer for the design and implementation of 10 terabytes Retail enterprise data warehouse (RDW) application
  • Responsible for migrating Oralce RDW (Retek) onto Netezza (NPS) platform
  • Specific responsibilities included:
  • Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes for a data warehousing and Data Migrations projects using Integration services (SSIS) against Netezza 7.0 database
  • Developed and Published Packages in Cognos Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects
  • Responsible for optimizing SQL queries, implementing materialized views/clustered base tables, maintaining zone maps, identifying data skew to improve the quality of application in Netezza
  • Created DMR in Framework Manager Model against relational Data Source
  • Work with business users to analyze user requests and determine best ways to satisfy user requirements
  • Trained business users to use applications effectively
  • Environment: Netezza, SSIS/SSRS/SSAS, SQL Server 2008, Tidal, Oracle 11g, Visual Studio .NET, Linux, PVCS, Pro
  • C, Aginity

Senior Business Intelligence Analyst/ETL Developer

Coach
New York, NY
07.2011 - 09.2012
  • Principal developer for the design, development and deployment of a Global DW for Coach
  • Specific responsibilities included:
  • Responsible for migrating existing data warehouse application from SQL server into Netezza appliance
  • Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes using shell scripts, NZLOAD and NZSQL on TwinFin 12
  • Responsible for migrating SSIS packages into Informatica Mapping, Session, Workflows using Power center 9.0
  • Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports using Cognos 8
  • Environment: Netezza, Aginity, SSIS/SSRS/SSAS, Informatica, SQL Server 2008, Oracle 10g, Visual Studio .NET, Linux, PVCS, Tidal

Project Leader / ETL Developer

Barnes & Noble Inc
New York, NY
07.2004 - 07.2011
  • Principal developer for the design, development and deployment of a 12 terabytes data warehouse that serves to consolidate five legacy data sources and dissimilar repositories into a single high performance data warehouse and back-end to a unified reporting system
  • SSIS Packages were used to transform from Merchandising systems and loading the data into a dimensional database
  • Specific responsibilities included:
  • Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes for a data warehousing and Data Migrations projects using Integration services
  • (SSIS) on SQL Server 2005/2008
  • Responsible for creating SQL Server Drill down and Drill through Reports using SSRS to fit business requirements, and implemented into SQL Server 2005
  • Involved in designing cubes, developing reports using Cognos and writing MDx queries using SSAS
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of application
  • Responsible for migrating supplier portal web based application (SQL server) onto Netezza (NPS) platform
  • Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes using shell scripts, NZLOAD and NZSQL on TwinFin 6
  • Environment: SQL Server 2005/2008, SSIS, SSRS
  • SSAS, Netezza, Cognos 8, Oracle 10g, SQLToad, Visual Studio.NET, PVCS, Windows, UNIX

Database Developer

The Trizetto Group Inc
, NJ
10.2002 - 06.2004
  • Involved in the coding of the HIPAA Gateway/Privacy healthcare system
  • The Gateway system captures all HIPAA-regulated EDI data in the Gateway repository and compliance-checks Medical and Dental claims HIPAA-regulated EDI transactions
  • These include security, member information, Authorizations
  • Both systems are developed on Microsoft and Oracle Platforms
  • Specific responsibilities included:
  • Writing stored packages, procedures, triggers, cursors, and views to improve the quality of application using PL/SQL, T-SQL
  • Designing DTS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, Access to SQL Server
  • DBA activities - managing users, roles, privileges, grants, performing data load and analyzing objects
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
  • Environment: SQL Server 2000, Sybase, Visual Studio .NET, DBArtisan, PVCS, Windows NT, UNIX

Programmer Analyst

Humanic Design Corporation
Mahwah, NJ
06.2001 - 10.2002
  • Humanic builds one of the most robust HR Management System applications
  • HRMS is consisted of several modules (Employee, Benefit Administration, Time off, Time entry), Utilities (Group Security, User Security, Employee deletion) and fully integrated with Payroll system
  • Specific responsibilities included:
  • Involved in the complete life cycle of the project, which comprises of gathering, analysis, design, coding, and testing
  • GUI design, coding, testing and implementation of all parts of the HRMS/Payroll system using Oracle Forms 6i
  • Developing PL/SQL Programs that includes creation of Stored Procedures, Functions, Packages, Cursors and Triggers on Oracle Database 8i.

Education

B.S - Computer Information Systems

Kean University

Skills

  • Skill set:
  • Technology - Azure data warehouse, AWS Redshift, Netezza (IBM Pure Data for Analytics), Hadoop, Hive, Big data, SQL Server, Postgres, Oracle
  • ETL/ELT - ADF, AWS Glue, Spark, Python, SSIS, DataStage, Informatica, Unix/Linux shell scripting, PowerShell
  • Reporting – PowerBI, Cognos, MicroStrategy, Tableau, SSIS/SSRS/SSAS
  • Python Programming
  • Data Warehousing
  • API Development
  • Performance Tuning
  • NoSQL Databases
  • Data Security
  • Data Modeling
  • Relational Databases
  • SQL Transactional Replications
  • Big Data Technologies
  • Database Administration
  • Data Migration
  • Database Design
  • Business Intelligence
  • SQL and Databases
  • Database Structures
  • Data Aggregation Processes
  • Normalization Techniques

Timeline

Senior Data Engineer/Architect

The Children’s Place
02.2022 - Current

Lead BI Engineer/Architect

Burlington Stores Inc
06.2021 - 02.2022

Senior Data Engineer

Smartlinx Solutions
06.2018 - 06.2021

Data Engineer/Team Lead, Lead architect

The Children’s Place
02.2014 - 06.2018

Datamart Specialist

Hess Corporation
09.2012 - 02.2014

Senior Business Intelligence Analyst/ETL Developer

Coach
07.2011 - 09.2012

Project Leader / ETL Developer

Barnes & Noble Inc
07.2004 - 07.2011

Database Developer

The Trizetto Group Inc
10.2002 - 06.2004

Programmer Analyst

Humanic Design Corporation
06.2001 - 10.2002

B.S - Computer Information Systems

Kean University

Similar Profiles

CREATE PROFILE
TEJAS PATEL