TWINKLE SEBASTIAN
Data Engineer
Bangalore,KA
Summary
End to end data warehousing professional with hands on experience in solving real world data problem solving across organizations ranging from startup to MNC. Having hands on experience on MSBI, SQL Server and AWS cloud environment and many new technologies.
Overview
9
9
years of professional experience
3
3
years of post-secondary education
Work History
Senior BI Data Engineer
Koch Business
Banglore, KA
11.2020 - Current
- Implemented and end to end ETL solution for Time series data(PI)
- Implemented data virtualization layer for Visualization using Denodo which had data from various sources and types
- Migrated existing MSBI data warehouse into Redshift using AWS services
- Leading team(BI) of 5 member and managing BI projects
Module Lead
Nous Info System
Banglore, KA
03.2020 - 11.2020
- Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse.
- Built data cubes, data marts and queries, maintaining every aspect of storage and translation.
- Utilized comprehensive understanding of data types and best practices for organization and display.
Senior Data Warehouse Developer
EF Education First
Bengaluru, KA
07.2017 - 03.2020
- Developed Enterprise Data warehouse for Organization
- Created SSIS packages to gather data from various sources such as flat files, SQL server, etc
- Implemented parent child SSIS packages to allow controlled execution of packages depending upon scenarios
- Implemented SSIS event handling to monitor package progress and provide logging for debugging and maintenance
- Implemented SSRS reports for operational reporting
- Used data gathered to develop understanding trends, patterns, and relationships; predictive analytics, which seeks to predict customer
- Having experience on AWS cloud environment (S3, DMS, RDS, Data pipeline and CloudWatch matrix)
- Currently working on developing event driven ETL process for company involving new technologies present in market
- Develop data models for applications, metadata tables, views, or related database structures
- Develop or maintain archived procedures, procedural codes, or queries for applications
- Maintaining code standards while writing and placing scripts and credentials using GitHub, KeyPass, Vaults etc
- Developed applications and designed processes for transformation and data management from company-wide databases.
MSBI/Database Developer
Cropin Technologies. Bengaluru
Bengaluru, KA
01.2015 - 07.2017
- Assisting with database design and data model decisions
- Developed complex SSRS/Jasper reports: multi-functioned, levelled and grouped, summary functionality in main reports providing detailed drill down through On Demand Sub-reports, dynamic link labeling, complex functions, charts, imported parameters and record sets from stored procedures
- Taking ownership of client data related issues
- Migrated Data from MSSQL to MYSQL using Talend
- Giving expert advice on SQL optimization, stored procedure design and other Database performance issues
- Carrying out database tuning activities to ensure optimal performance.
Graduate Trainee Engineer
Fidelity Investments
Bengaluru, KA
02.2013 - 10.2014
- Responsible for development and maintenance of various stored procedures written in Sybase
- Worked as Data Analyst providing business solution across Implementation and operational groups for their day-to-day activities
- Converted requirements into technical requirements and provide business solutions.
Education
Computer Engineering
Christ University
Bengaluru, KA 07.2010 - 06.2013
Skills
MSBI
Data Warehousing
Denodo
AWS Services(DMS,Lambda,S3,Redshift)
ETL
Data Modeling
Data Migration
Data Quality Engineering
Additional Information
- 8+ years of IT experience
- 8+ years Databases &SQL MSBI
- 6+ years ETL/Data Modeling and Data warehousing
- Worked on complex data warehouse implementation end to end in MSBI and Cloud
- Implemented data virtualization using Denodo
- Experience on Agriculture,Manufacturing,Banking,Travel & Education domains
Timeline
Senior BI Data Engineer
Koch Business
11.2020 - Current
Module Lead
Nous Info System
03.2020 - 11.2020
Senior Data Warehouse Developer
EF Education First
07.2017 - 03.2020
MSBI/Database Developer
Cropin Technologies. Bengaluru
01.2015 - 07.2017
Graduate Trainee Engineer
Fidelity Investments
02.2013 - 10.2014
Computer Engineering
Christ University
07.2010 - 06.2013