Ketan Chandekar
Schaumburg,IL
Summary
- 14+ years of industry experience encompassing a wide range of skill set in Analysis, Development, Testing and Implementation applications in Ab Initio, UNIX, Linux, SQL, Oracle, Teradata and Tableau environments.
- Working in Agile Scrum methodology from last 5+ years. Highly motivated, able to work independently.
- Onsite experience of working from client’s US office for analyzing and translating business requirements to technical requirements, data modeling and architecture design.
- Quality Management - Knowledge of quality management methods, tools and techniques.
- Strong SQL / ETL skills. Ability to write and understand complex SQL queries.
- Completed Azure Fundamental certification. Learning Python and preparing for GCP certification.
- Learning and doing hands on practice in dbt.
- Strong experience in ETL Application Development with Ab Initio (ETL application and Data Quality application).
- Excellent knowledge of Data Analysis, Design, Development and Testing of Ab Initio GDE & Express It 3.2 applications over Unix AIX server and DBMS of Teradata.
- Strong experience in Batch Application Development (with ETL Tool Ab Initio), Data Quality Configuration Developer, Production Support (with Level 3 support primary) and Business Analyst in Credit Card and Card Payment, Rewards, Document Tracking. Expert in Data Analysis, troubleshooting and Resolving Ab-initio ETL Batch applications along with code optimization of the code.
- Expert in handling Production batch jobs while Production Support Primary job role. Experienced in leading development teams and being responsible for setting up coding, testing, team building, guiding and mentoring team members.
- Worked closely with business analysts, business users and client Managers /Directors. Extensively worked on BI Reporting, IBM Workload scheduler tool and UNIX. Excellent Analytical and problem-solving skills.
- Experienced in end-to-end software development lifecycle covering test strategy, test planning, test design, execution and defect management.
- Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle.
- Developed Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems.
- Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation.
- Analyze and understand the ETL work flows developed.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Data Engineer
Discover Financial Services, DFS
Richwoods, IL
10.2023 - Current
- Working in Payments area where we monitor the transactional data happing over DFS network
- Loading the data in SF table and providing the data to AML and GNA team to analyze the fraudulent transaction
- Creating Data Quality check before loading the data into Snowflake
- Creating Reports in Tableau where we can monitor daily job runs and can escalate to support team if there is any delay in SLA strems
- Handling offshore team of 5 members
Lead Data Analyst
TAG – The Aspen Group (Aspen Dental)
Chicago, IL
09.2022 - 10.2023
- We are migrating our code on-premise Data Wearhouse to Google Cloud
- Working on analyzing transactional data for the net revenue, budget, wages and attendance model
- We are getting data from multiple sources like workday, mainframe etc
- Extracting that data, loading it in our data warehouse and creating reports on the same
- Reports are mainly built in SSRS but since we are migrating to Google cloud, we built all the new reports in Tableau.
Data Specialist (ETL Architect)
LTIMindtree
Tampa FL (Chicago - Remote for now), FL
10.2021 - 09.2022
- Working on compliance project AML (Anti-money laundering) team for Citi Bank
- We capture all fraudulent transaction and activities depending upon their individual score at Citi
- Our team is extracting data form multiple sources and providing the info (AML info) to the downstream teams or business about the individual or a group of people /companies.
- We used Actimize tool to analyze the fraudulent transaction
Associate Engagement Consultant
Bitwise Inc.
Wheeling Chicago (Remote)
03.2021 - 10.2021
- Client has implemented a Data Warehouse system to perform analytics and reporting
- Client decided to move the entire code to Hadoop environment
- To achieve this, helped client to move several ETL applications in Bitwise tool Hydrograph
- These applications are divided into multiple business areas as Footwear, sportswear, European Sports and Enterprise Data Warehouse
- These applications consist of several jobs that constitute the daily/monthly production runs
- Helped Client to redesign and redevelop similar data warehouse architecture into Hadoop using Hydrograph
Associate Engagement Consultant
Bitwise Inc.
Lake Cook Rd, Riverwood’s, Illinois (Greater Chicago area)
09.2017 - 03.2021
- Discover has implemented a Data Warehouse system to perform analytics and reporting
- To achieve this, several ETL applications have been developed
- These applications are divided into four functional areas as Enterprise Data Store, Operational Data Store, Decision Data Sourcing and Enterprise Data Warehouse
- These applications consist of several jobs that constitute the daily production run.
Sr. Consultant
Bitwise Inc.
Lake Cook Rd, Riverwood’s, Illinois (Greater Chicago area)
03.2018 - 05.2019
- Amazon Web Service Migration is an initiative taken by the Discover to store data on cloud for easy accessibility and better data retention
- Currently Discover is using a physical database to store business critical data
- For business continuity and to handle large dataset Discover needs to migrate from traditional database to modern AWS architecture
- Discover will be migrating its business modules in multiple phases.
Sr. Consultant
Bitwise Inc.
Lake Cook Rd, Riverwood’s, Illinois (Greater Chicago area)
10.2016 - 02.2018
- This project involves capturing of fraudulent activities and send that data to the team
- This is part of critical streams as it comes under compliance
- This stream of jobs has a strict SLA and need to complete in SLA time frame.
Team Lead
Bitwise Inc.
Pune, India
09.2012 - 08.2016
- This project involves end to end ETL and BI reports testing of jobs
- Testing is performed using BI Testing Tool (developed by Bitwise) QualiDI
- Mapping documents are referred to create Test scenarios, write SQL queries for validation of source and target data
Sr. Software Engineer
Bitwise Inc.
Pune, India
03.2012 - 08.2012
- This project involved web site development and testing of application built for multi-level marketing on multiple browsers on Windows and Mac operating systems
- The application was developed using Ajax and Java
- Performed Performance / load testing using Apache JMeter tool.
Software Engineer
Bitwise Inc.
Pune, India
01.2011 - 03.2012
- This project involved testing of web application and mobile application developed for the credit card and financial organization
- All web and mobile applications were developed using Java
- Mobile applications were tested on Perfecto Mobile Automation Testing Tool as well as real devices
Trainee Engineer
Global Step LLC.
Pune, India
04.2010 - 12.2010
- Involved in testing of all types of electronic games
- Client provides game testing services in all type of consoles
- Conducted complete functional testing on the all 3 platforms viz
- Microsoft XBOX, Nintendo Dual Screen and Sony PlayStation
Education
BE (IT) - Information Technology
Amravati University
Maharashtra India06-2009
Skills
- ETL Development Tool: AB Initio GDE, Data Hub, EME, GitHub
- Cloud Technology: AZ 900: Azure Fundamental certified, Big Query, dbt, S3, Snowflake, Docker, Terraform, Github
- Defect / Test Management Tools: HP (mercury) tools – ALM/Quality Center, Bugzilla and JIRA
- RDBMS / Databases: Microsoft SQL, Oracle, Netezza and Teradata
- Agile Management Tool: Rally, Jira
- Other Tool: Secure CRT for Unix, ServiceNow (for INC’s and reporting), VSCode for DBT
- Language : Python (Basics)
- Application Scheduler: JS Console, IBM Maestro scheduling development, Control Center
Certification
- Azure Fundamentals - https://api.accredible.com/v1/frontend/credential_website_embed_image/badge/65914436
- DBT - https://www.youracclaim.com/badges/b790e5a6-0b97-4e25-a1e9-3d7e38185c6b?source=linked_in_profile
Timeline
Data Engineer
Discover Financial Services, DFS
10.2023 - Current
Lead Data Analyst
TAG – The Aspen Group (Aspen Dental)
09.2022 - 10.2023
Data Specialist (ETL Architect)
LTIMindtree
10.2021 - 09.2022
Associate Engagement Consultant
Bitwise Inc.
03.2021 - 10.2021
Sr. Consultant
Bitwise Inc.
03.2018 - 05.2019
Associate Engagement Consultant
Bitwise Inc.
09.2017 - 03.2021
Sr. Consultant
Bitwise Inc.
10.2016 - 02.2018
Team Lead
Bitwise Inc.
09.2012 - 08.2016
Sr. Software Engineer
Bitwise Inc.
03.2012 - 08.2012
Software Engineer
Bitwise Inc.
01.2011 - 03.2012
Trainee Engineer
Global Step LLC.
04.2010 - 12.2010
BE (IT) - Information Technology
Amravati University
Similar Profiles
River BonsRiver Bons
Lead Account Specialist at Discover Financial Services, DFSLead Account Specialist at Discover Financial Services, DFS
DAWNE GARRETTDAWNE GARRETT
Senior Customer Service Representative at Discover Financial Services, DFSSenior Customer Service Representative at Discover Financial Services, DFS
Sonia CarterSonia Carter
Digital Account Specilist at Discover Financial Services, DFSDigital Account Specilist at Discover Financial Services, DFS
Garrett Van DellenGarrett Van Dellen
Customer Service Coach at Discover Financial Services, DFSCustomer Service Coach at Discover Financial Services, DFS
Sai BhandarSai Bhandar
Computer Science Intern at VitharkaComputer Science Intern at Vitharka