ANINDYA BANERJEE

EMAIL: adlrnk@r.postjobfree.com

PHONE: +1-408-***-****

Result-oriented professional, offering over 10 years of experience in Business Requirements Analysis, Application Design, Dimensional Data Modelling, Designing, Coding, Development, Testing and Implementation of Business applications with RDBMS, Data Warehouse/Data marts, ETL and OLAP

Responsible to work closely with Business User, source team and other stakeholders to understand the project requirements. Perform requirement analysis, evaluate the data and impact analysis for the other downstream applications. Prepare functional and other design documents in client’s standard template and prepare the end to end deployment plan using client’s Development to Production process.

Expertise in Data Analysis, Data Modeling, System Design and Development and Project management

Define and architect future state data architectures incorporating latest industry standard methodologies utilizing Snowflake and AWS

Expertise in Snowflake – data modelling, ELT using Snowflake SQL,.

Experience in Snowflake performance optimization.

Involved in creating reports using Tableau dashboard based on KPI metrics.

Extensive knowledge in various reporting objects like Facts, Attributes, filters, Calculated fields, Sets Parameters etc., in Tableau.

Ability to think strategically, analyze and interpret market and consumer information.

Hands on experience with modern cloud data analytics stack Snowflake.

Extensively working on spark framework and Kafka for near real time data induction.

Experience in writing Oracle Sql/Pl Sql stored Procedures.

Experience in writing Teradata stored procedure and Teradata utilities.

Developed JCL in mainframe to execute different utilities of Teradata through control cards.

Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software.

Used Data Stage as an ETL tool to extract data from sources systems, loaded the data into the Teradata database.

Proficient in all phases of Data warehousing concepts, and experience in dimensional modelling using Star Schema and Snow-flake Schemas.

Extensively used Unica as Email campaign management tool.

Excellent communication and interpersonal skills

Effective interaction with clients on finalizing deadlines

TECHNICAL SKILLS

Tools & Utilities

Teradata SQL, Tableau, Snowflake, Teradata Utilities, DataStage, Informatica Unica, Autosys

Databases

Teradata, SQL server, Oracle, Cassandra

Cloud

AWS, Snowflake

Big Data

Spark, Kafka, Splunk

Languages

Python, Scala

Operating Systems

Mac, Windows

EDUCATION

EDUCATION

Masters in Computer Applications (MCA), West Bengal University of Technology

Masters in ML/AI, Liverpool John Mores University (Pursuing)

CERTIFICATIONS

CERTIFICATIONS

AWS Certified Data Analytics -Specialty

AWS Certified Solutions Architect -SAA

SnowPro Core Certification

Post Graduate Diploma in Machine Learning and AI – IIIT B

EXPERIENCE

Project #1

Search ADS – Data Migration

Duration

May 2020 – Till Date

Role

Techno Functional Lead

Tools and Utilities

Snowflake,AWS,Teradata, spark, Kafka

Operating Systems

Mac, Unix

Database

Snowflake,Teradata

Project Description:

As part of Apple’s Data migration initiative to cloud, the main objective of this project is to migrate the search Ad’s application from onprem Teradata to Snowflake cloud.

Responsibilities:

•Experienced creating high level and detailed design documents.

•Integration of apples data pipeline tool Keystone with Snowflake and Teradata.

•Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Keystone.

•Deployed Snowflake features such as data sharing.

•Data Migration from RDBMS to Snowflake cloud data warehouse

Project #2

Search ADS – Real time Campaign operation

Duration

Jan 2020 – April 2020

Role

Techno Functional Lead

Tools and Utilities

Teradata, Tableau, pyspark, Kafka, unica

Operating Systems

Mac, Unix

Database

Teradata and Oracle

Project Description:

This project’s main objective is to build a communication platform (EDW tables) that supports the Search ads contact strategy and enables Search Ads marketing team to engage its customers with highly relevant, timely and actionable communications with the goal of maximizing their success and their value to the Search Ads marketplace.

Hermes2 (Phase2) of the project builds on top of Phase1, with adding these capabilities:

•Enable near real-time Marketing data feed from Search Ads to EDW

•Set up an end-to-end functional instance of event triggered email delivery

•Deliver near real-time event triggered emails via the solution

•Un-tie the reliance of Search Ads engineering to send an event triggered email

•Design and execute the email campaign by Search Ads Marketing team

•Measure and report performance of email key metrics e.g. Opens, Clicks, Unsubs, Heat maps

•

Responsibilities:

•Creating an end to end data pipeline through spark

•Consuming the source data through pie Kafka in a near real time fashion.

•Loading the source data in enterprise data warehouse continuously.

•Creating real time campaigns to reach out to targeted business unit through UNICA.

•Building an integrated tableau dashboard for the usage stats of all sandbox environments

•Creating Tableau dashboard to check the data quality.

Project #3

Apple – News personalization

Duration

Aug 2019 – Dec 2019

Role

Techno Functional Lead

Tools and Utilities

Teradata 13/14, Tableau, Unix, unica

Operating Systems

Mac, Unix

Database

Teradata and Oracle

project description:

Apple News personalization project is all about identifying the correct set of audience based on the usage pattern through vectorization and sending email marketing communication to the target audience and capturing the customer response though online marketing dashboard.

Responsibilities:

•Creating an end to end data pipeline for apple News personalization project.

•Decrypting the GPG encrypted file before loading it into enterprise data warehouse in Teradata.

•Creation of campaigns to reach out to the targeted customers in Unica

•Encrypting the final out file before sending it to chatterbox for

•Creating a Splunk dashboard to capture the logs.

•Capturing the customer response through online marketing tableu dashboard.

Project #4

Data Quality Management -Apple Care Business Intelligence Reports

Duration

April 2019 – July 2019

Role

Techno Functional Lead

Tools and Utilities

Tableau, Teradata

Operating Systems

Mac, Unix

Database

Teradata and Oracle

Project Description:

In DQM (Data Quality Management), the key data quality metrics have been tracked through an integrated reporting dashboard. Majority of the AppleCare business intelligence objects have been tracked through an integrated tableau dashboard.

Responsibilities:

•Preparing the data for the DQM.

•Creating various tableau reports for capturing data counts for some of the key fact and dimensional tables.

•Creating an integrated DQM report to identify if there is any delay from job execution point of view, count of data getting loaded each day and systematic comparison of data across different time dimensions.

Project #5

Apple – GBI Chrysalis

Duration

May 2017 – March 2019

Role

Senior Developer

Tools and Utilities

Teradata 13/14, Unix, Kafka, Storm

Operating Systems

Mac, Unix

Database

Teradata and Oracle

Responsibilities:

Have been handling new initiative or enhancement requests for various applications in OLS area, such as Jive, Badge Ville, Gather, CDS, SOCIAL & Haiku.

Designing Transformer framework with semantic procedures and data replication.

Migrating Files based Interface to S2f lite framework.

Developing codes for end-to-end process such as Autosys Job, Procedures, Scripts to load the data into Semantic and downstream for reporting

Designing the ETL process to Extract data from source system to EDW

Have been handling history data correction for respective applications.

Monitoring & Analyzing DQM of BO tables.

Developing scripts to automate the manual efforts.

Performing Unit/Regression Test in Dev, SIT & UAT Environments.

Preparing project related documents such as Requirements, Specifications and Technical Designs document

Responsible for CR activities to implement the changes in production.

PROJECT DETAILS

Project #6

Custops BI

Duration

Oct 2016– April 2017

Role

Developer

Tools and Utilities

Teradata, Micro strategy

Operating Systems

Windows XP

Database

Teradata and Oracle

Project Description

Customer Operations Call Insights is an interactive reporting tool that provides intelligence for call-based activity from a call, labor, and customer perspective. For example, Call Insights helps business users to analyze the average call handle time, number of calls handled, offered calls, and service level rate. Labor Insights is another interactive reporting tool that was designed to provide visibility to numerous performance metrics related to customer operations labor. It provides the ability to view agents’ individual performance for each metric by fiscal month.

Responsibilities

Carried out the following activities:

Responsible for building various ETL functionalities by writing Oracle and Teradata Stored Procedure.

Involved in building different Oracle stored procedure from scratch for World Box Reporting, Equipment Details and for labor Management dashboard.

Involvement in various enhancement activities in Teradata.

Unit Testing.

Analyzing the data in Micro strategy reporting tool.

PROJECT DETAILS

Project #7

Enterprise Data Warehouse

Duration

Nov 2013 – Sept 2016

Role

Developer

Tools and Utilities

Teradata, DataStage, MicroStrategy

Operating Systems

Windows XP

Database

Teradata, Oracle

Project Description

Enterprise Data Warehouse (EDW) in Hallmark is based on a single 18-node enterprise data warehouse from Teradata to gain a single view of the business that powers Hallmark's one-to-one marketing initiatives. The Data’s from the different upstream applications are extracted by Data Stage and loaded into EDW (Teradata) which is extracted by Micro strategy to create reports.

Responsibilities

Carried out the following activities:

Responsible for leading a project team in delivering solution to the customer

Responsible for managing estimation, scope, planning, tracking, change control, aspects of the project.

Involved in writing Oracle SQL/PL SQL Stored Procedure.

Developed JCL in mainframe to execute different utilities of Teradata through control cards.

Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software

Involved in loading and extracting data from EDW to SAP through IDOC Load and Idoc Extract stage.

Design the ETL jobs based on the DMD with required Tables in the Dev Environment.

Used Data Stage as an ETL tool to extract data from sources systems, loaded the data into the Teradata database

Designed and Developed Data Stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.

Created Data stage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, and Filter.

Extensively worked with Join, Look up and Merge stages.

Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components

Creation of jobs sequences.

Participated in weekly status meetings.

Writing unit test cases

Unit Testing.

PROJECT DETAILS

Project #8

Sap Hana Implementation

Duration

May 2013 – Oct 2013

Role

Developer

Tools and Utilities

SAP HANA, SAP BO

Operating Systems

Windows XP

Database

Teradata

Project Description

Sap Hana has been implemented which stores inventory related data which has been captured by Business Object for various kinds of reporting applications in this project.

Responsibilities

Carried out the following activities:

Responsible for leading a project team in delivering solution to the customer.

Responsible for managing estimation, scope, planning, tracking, change control, aspects of the project

Designing of the attributes and analytical and calculation views in Sap Hana

Writing unit test cases.

Unit Testing.

Executing Unit test cases both in Sap Hana and Business Object end. Performance tuning using Score Carding.

PROJECT DETAILS

Project #9

Enterprise Application Support

Duration

Jan 2012-April 2013

Role

Developer

Tools and Utilities

Teradata, DataStage, Informatica

Operating Systems

Windows XP

Database

Teradata, SQL Server

Project Description

Business intelligence is a critical service for Walmart to survive in the competitive retail market. Walmart has a large enterprise data warehouse (EDW) and uses ETL, Teradata, Abinitio, OBIEE, and Data Stage for its BI and analytics needs. Walmart requires varied forms of analytics reports from the EDW.

Responsibilities

Carried out the following activities:

Understanding the client requirement from business requirement document. Prepare the functional and technical specification of the system. Prepare technical design document from business requirement document. Develop code based on technical design document. Developing Teradata procedures, perform code review in order to ensure defect free delivery. Prepare the unit test plan, test cases for testing the functionalities. Extracting, transforming and loading data from OLTP and dumping into common staging area. Execute the unit test plan to ensure if the system acts as per the functional specification. Identifying the bugs during unit testing and performing of bug fixing. Documenting the internal design of software for the purpose of future maintenance.

Instructing client counterpart to deploy the code in different environment. and

Maintaining the enhancing software to cope with newly discovered faults (post production).

Extensively used Teradata Utilities like Bteq, Fast load, Multiload, fast export navigating through Mainframe JCL

Involved in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.

Troubleshooting of Data Stage jobs and addressing production issue.

Created Data stage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, and Filter.

PROJECT DETAILS

Project #10

Work Force Data Staging

Role

Developer

Duration

May 2011– Jan2012

Tools and Utilities

Teradata, Informatica

Operating Systems

Windows, Unix

Project Description

Work Flow Data Staging (WFDS) is the program/project name to build the Data Staging capability using the TD MDM tool. Through WFDS we used to stage data as it flows between enterprise data sources (Calypso, vanguard) and the planning use cases (solvers). It Provides a centralized place to sync, clean and complete data before it gets moved

Responsibilities

Carried out the following activities:

Developing Teradata Procedures using Sql and Pl/Sql.

Preparing CR (Change Request No), EECR using SAP Solman.

Scheduling jobs using Autosys.

Unit Testing.

Defect Fixing during Integration Testing.

Performance tuning using Score Carding.

PROJECT DETAILS

Project #11

Credit Suisse Business Intelligence

Role

Developer

Duration

Dec 2010– April 2012

Tools and Utilities

Informatica, Oracle SQL PL/SQL

Operating Systems

Windows

Database

Oracle, Teradata

Project Description

The main objective of this project is to extract operational data from various operational Data Sources or OLTP. This operational data then transformed and cleansed using Informatica.After completion of extraction, transformation and loading this data has been fetched from a reporting tool called Business Object. Business Object finally generates the report.

Responsibilities

Carried out the following activities:

Developing mapping using Informatica and writing Oracle sql/pl sql.

Creation of various mapplets and workflow.

Analyzing of business needs and requirement.

Unit Testing.

Defect Fixing during Integration Testing

Contact this candidate