Srividhya Shiju

SRIVIDHYA SIVAKUMAR PHONE #:-,- MAIL ID:- CAREER OBJECTIVE To be associated with an organization that gives me scope to learn new technologies and will utilize my professional and life skill experiences to the fullest extent for the benefit of the company as well as for my personal growth and professional advancement. PROFESSIONAL SUMMARY 7+ years of IT experience in Data warehousing and Business intelligence domain as an ETL developer with emphasis on Business Requirements Analysis, Developing technical Design Documents, column level mapping documents, design documents, implement , test and maintain the Data Warehouse. Hands on experience in relational databases (Oracle SQL, Teradata) and ETL Tool (Informatica Power center 9x&10x) Experience in SQL and Basic knowledge of PL/SQL packages, functions, stored procedures and materialized Views to implement business logic in oracle database. Experience working in Agile methodology Extensively worked on developing Informatica Power Center Mappings, Sessions and Workflows for data loads. Having hands on experience working n Hadoop - Hive SQL. Working knowledge on implementation of incremental Load and insert-update strategies. Experience in using major Informatica transformations like Source qualifier, connected and unconnected Lookup, stored procedures, Filter, Expression, Router, aggregator in Informatica power center. Experience in automating ETL runs through Dollar U and TES (Tidal Enterprise solution), ESP. Experience in code build and migration from one environment to the other using Jenkins & Udeploy Experience in delivering Knowledge Sharing sessions on ETL , internal to organization and have regularly contributed to the knowledge database of the organization Experience in Onsite-Offshore model. Understanding and troubleshooting the issues and fixing the bugs. Involvement in all phases of SDLC. Hands on experience in Business Object Reports testing. Experience in Golden Gate Replication process Basic Knowledge of developing reports using Tableau. Having strong communication and presentation skills along with perseverance and positive attitude. AREAS OF EXPERTISE Reporting Tools : Informatica Power Center, Business Objects, Tableau Database: Oracle 11g, Teradata , SQL Server DB TOOLS : Toad, Teradata SQL assistant, Teradata Studio Programming/Scripting: SQL, PLSQL LANGUAGES KNOWN: C, C++, C#, Python Reporting Tools : Business Objects, Tableau Scheduling Tools : Dollar Universe, Tidal Enterprise Solution, ESP. Source Experience : ERP, Flat files, Relational DB Code Migration : Jenkins, Udeploy ACADEMIC PROFILE Degree Board / University Year of Passing Percentage PGDBA - HR Symbiosis center for distance learning 2017 7.6 B.E in Electrical & Electronics Engineering Tagore Engineering College, Anna University, Chennai- CGPA Higher Secondary Sri Sitaram Vidhyalaya Matriculation Higher Secondary school, Chennai 2008 88% SSLC Sri Sitaram Vidhyalaya Matriculation Higher Secondary school, Chennai 2006 89% PROJECT PROFILE TATA Communications August 2018 – Till date Lead Software Engineer Customer: TATA Communications – CSG Group Account : Telecom Domain : Datawarehousing Technology/Tools : Informatica, Teradata, Oracle,SQL Server, PowerBI,Python Accenture August 2016 – July 2018 Software Engineer Client : Cigna Account : Health Insurance Organization: Accenture Domain : Datawarehousing Technology/Tools : Informatica, Teradata,Hive SQL, Scoop, Oracle, Python, Unix, Udeploy, Jenkins, ESP, GIT Description : The Purpose of the project is to pull insurance & health information from flat file, oracle & DB2 source systems using Informatica Powercenter 9 and 10. The data extracted is then loaded into Teradata target tables using various transformations to meet the expected business requirements. The data loaded into the Teradata Target table will be used both for reporting & for downstream consumers. Responsibilities: Analyze, design and develop end-end ETL flow from Source – Landing layer, Landing - Staging, Staging- Base layer using Informatica power center with the help of transformations, Bteq scripts and .sql files using Python Created reusable ABC (audit, balance & control) component which is used across various teams Performed unit testing and regression testing of the developed code Involved in preparation of Low level Design Document(LLD) and Technical Design Documents (TDD) Following Agile methodology to deliver the assigned tasks Performed package creation through Jenkins and version control using GIT Performed migration of the code using Udeploy Scheduled ETLs & Bteqs using ESP scheduler Coordinated Production Deployment activities with different support groups Tech Mahindra July 2013 – August 2016 Software Engineer Client :Cisco systems inc, USA Account:Finance Project(s):Cisco Capital Project Connect Tools :Informatica Power Center 9.6.1, Oracle SQL, Business Objects, TES, Dollar U, AppDB Domain : Datawarehousing Description : The primary mission of this project is to profitably enable sales and growth by tailoring unique financial solutions to promote specific Cisco product offerings. In this project we are aligning all the legacy systems into one streamlined source and making it as data source for generating reports. Responsibilities: Analyze, design and develop end-end ETL flow from Source - Raw layer, Raw layer - 3NF, 3NF -Dimensions & Facts using Informatica power center 9.6.1 (in current usage) with the help of transformations. Performed thorough Impact and table level analysis with reference to Functional Specification Document Performed unit testing and integration testing along with test cases preparation Scheduled ETLs through Dollar U and TES Performed migration of DB changes through AppDB Coordinated Production Deployment activities with different Support groups Prepared column level mapping documents, technical design documents WORKSHOPS/TRAINING PROGRAMS AND CERTIFICATIONS Successfully completed Entry Level Technology Program (ELTP) at Tech Mahindra Undergone Trainings on Informatica 9x Tableau Agile Oracle SQL RDBMS, Web Programming Business communication Hadoop Tech Mahindra Internal Certification on Agile, Informatica PERSONAL DETAILS Name : Srividhya Sivakumar Email Id :-Date of Birth:- Passport Detail: K- (09/11/2012 – 08/11/2022) Contact # : - , - Gender : Female Nationality : Indian