Sanjana Sathyan

Data warehouse developer

Data warehouse/ETL Developer with 5.4 years of strong technical proficiency in SQL development to build an ETL pipeline for enterprise data warehouse. adgjve@r.postjobfree.com 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

Operating

Systems

Windows, Linux

Other

technologies

SSRS, SSAS, Unix shell scripting, OBIEE

WORK EXPERIENCE

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 specifications 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 defined functions using SQL Server Tuned and optimized queries by altering database design, analysing different 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 modifications 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

WORK EXPERIENCE

Senior Project Engineer

Wipro Technologies

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 file 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 flow to avoid manual process

Contact: Syamjith Leela (Tech Lead) - adgjve@r.postjobfree.com Developer L2

Wipro Technologies

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. Configure the Redshift DB.

Migrate the existing data from Teradata to Redshift DB using Abinitio (ETL). End-to-end process workflow testing

Automate the overall flow to avoid manualprocess

Developer L1

Wipro Technologies

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.

Configuration of new application infrastructure.

Migrate the existing data from Mainframe to Redshift DB using Snap logic (ETL). End-to-end process workflow testing.

Automate the overall flow to avoid manual process.

HONOR AWARDS

Inspiring Performance Award (06/2017 - 04/2020)

First Gulf Bank

For Integration Project Completion.

Victory League (11/2016 - 06/2017)

Capital One

For Migration [project completion].

Best Performance (03/2016 - 07/2016)

Wipro Technologies

For best performance in the project.

LANGUAGES

Malayalam

Native or Bilingual Proficiency

English

Full Professional Proficiency

Hindi

Full Professional Proficiency

Tamil

Limited Working Proficiency

Achievements/Tasks

Achievements/Tasks

Achievements/Tasks

Contact this candidate