Data warehouse developer
Data warehouse/ETL Developer with 5.4 years of strong technical proﬁciency in SQL development to build an ETL pipeline for enterprise data warehouse. firstname.lastname@example.org 999-***-**** Vadodara, India linkedin.com/in/sanjana-satyan-6707414 SKILLS
MS SQL ETL Tools Data warehousing ETL testing Unix shell scripting PL SQL Redshift Reporting tools TECHNICAL SKILLS
Tools Putty, WinSCP, Control-M, ALM tool ETL Tools ODI - Oracle Data Integrator, SSIS, Ab Initio, Snaplogic
Databases Oracle SQL, MS SQL, MS Access,
Teradata, Amazon Redshift
SSRS, SSAS, Unix shell scripting, OBIEE
Senior SQL Developer
Stemmons Enterprise Ltd.
04/2020 - Present, Vadodara, Gujarat
Boxer property is one of the well known Real estate users in US who is the client for Stemmons Enterprise Ltd. We are managing their leasing data and creating reports from the database.
Involved in all phases of the project life cycle including requirement gathering, analysis, design, coding, testing, and implementation. Documented technical requirement speciﬁcations and detailed designs for database design changes. Designed database schemas for new features with optimum level of normalization and relationships. Implemented various logics through stored procedures, triggers, and user deﬁned functions using SQL Server Tuned and optimized queries by altering database design, analysing diﬀerent query options and indexing strategies. Assisted the testing team in preparing the test cases and validation of data. Involved in the defect analysis along with testers to understand the data and to make any modiﬁcations to code. Designed and implemented the backup strategy for the production databases Data transformation and loading using SSIS and creating reports using SSRS Designed, tuned and maintained complicated stored procedures, views and quires. Achievements/Tasks
Senior Project Engineer
06/2017 - 04/2020, Cochin, Kerala
First Gulf Bank project is about integration of two banks. First Gulf Bank (FGB) and National Bank of Abu Dhabi (NBAD), both were integrated to one bank First Abu Dhabi Bank (FAB). Team have done the integration work for the customer (FAB). Project mainly used ODI and Oracle SQL and integrated all the NBAD source systems to FGB source systems. We are dealing with multiple stake holders. Collect data from multiple upstream systems and load them into DWH Prepare ad hoc queries reports for both technical and business teams. Provide training to all employees of development team. Involved in end - to - end development
Analyze the mapping sheet and understanding the requirements and transformations needed Develop components such as ﬁle model, interfaces in Oracle Data Integrator and tables, stored procedures, views in Oracle DB Worked with PL/SQL and MS SQL.
Work with SIT and downstream systems for testing and reporting Automate the overall ﬂow to avoid manual process
Contact: Syamjith Leela (Tech Lead) - email@example.com Developer L2
11/2016 - 06/2017, Bangalore, Karnataka
The Capital One project is about to migrate credit card data from Teradata to Redshift (AWS Cloud) using Abinitio as an ETL tool Verify functionalities available in the cloud DB (redshift) and ensure it meets the requirements. Conﬁgure the Redshift DB.
Migrate the existing data from Teradata to Redshift DB using Abinitio (ETL). End-to-end process workﬂow testing
Automate the overall ﬂow to avoid manualprocess
03/2016 - 08/2016, Bangalore, Karnataka
The Capital One project is about moving data from Mainframe to Hadoop and pushed in to cloud, after pushing using Snap logic data loaded in to Redshift table.
Conﬁguration of new application infrastructure.
Migrate the existing data from Mainframe to Redshift DB using Snap logic (ETL). End-to-end process workﬂow testing.
Automate the overall ﬂow to avoid manual process.
Inspiring Performance Award (06/2017 - 04/2020)
First Gulf Bank
For Integration Project Completion.
Victory League (11/2016 - 06/2017)
For Migration [project completion].
Best Performance (03/2016 - 07/2016)
For best performance in the project.
Native or Bilingual Proﬁciency
Full Professional Proﬁciency
Full Professional Proﬁciency
Limited Working Proﬁciency