Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Geethapriya R Sankaran

Geethapriya R Sankaran

Senior System Analyst
Chennai,TamilNadu

Summary

  • I have accumulated 13.3 years of experience as an IT professional specializing in the design, development, and implementation of Data Warehousing Technology and Data Analysis. During this time, have dedicated 7 years to working with Informatica Power Center and the last 6 years as an Alteryx developer.
  • My expertise covers all phases of the Data warehouse life cycle, encompassing Analysis, Design, Development, and Testing of Data warehouses using ETL.
  • Furthermore, I possess extensive experience in ETL design, development, and maintenance using Oracle SQL, Teradata, TSQL, Alteryx (2022.3), and Informatica Power Center v 9.1.
  • Experienced in Alteryx to prep, blend, and analyze data. Designed macros to load multiple files into db. Extracted data from SQL Server, Flat Files and API.
  • Have good knowledge in formula, join, unique, xml and json parse, Transform, append, dynamic input, dynamic rename
  • Using Alteryx have done Data integrationfrom different source system, Data analysis, Data Validation and did performance tuning in source and target
  • Well versed in developing the complex SQL queries, unions and multiple tables joins and experience with Views
  • Experienced at Creating effective Test data and development of thorough Unit test cases to ensure successful execution of the data
  • Excellent problem solving, interpersonal and communication skills with experience working in fast paced, challenging and dynamic environment. Highly motivated with passion for learning
  • Have knowledge in UNIX shell scripting
  • Have basic knowledge of reporting tools such as QlikSense and Power BI.

Overview

13
13
years of professional experience
5
5
years of post-secondary education
1
1
Certification

Work History

Senior System Analyst

Artech Infosystems Private
07.2023 - Current

Client: Ford- Cyber Security and Data Protection

  • Analyzed existing systems and databases and recommended enhancements to run workflow effectively
  • Proactively integrate data from various sources including JAMF, SACM, Easset, SEPM, and HX to identify and address any broken or malfunctioning clients.
  • This streamlined approach empowers policy deployment team to efficiently deploy necessary packages and engage with affected machines, ensuring compliance and optimal functionality.

System Analyst

Hexaware Technologies
11.2017 - 07.2023

Client: IQVIA - ITAM Hardware Discovery

  • The asset details are integrated from different source system like SCCM, SNOW, JAMF, Antivirus, Nexthink, Intune and Snow License Manager to check on device status and compliance.
  • The Server details, last logged in user, no of logins for respective servers are tracked.
  • Hence system compliance and non-compliance status is tracked

Client: IQVIA - ITAM User Integration

  • The employee information, including details such as contact information, job title, and department, is stored in Active Directory and workday table.
  • This data is then seamlessly integrated into ITAM User table and carefully managed in EBX.
  • Any changes to this information, such as when user leaves organization, supervisor change occurs, or there are updates to asset allocation, are captured and incorporated into system to ensure accurate and up-to-date records.

Client: Inchcape Shipping Services

  • Inchcape Shipping Services, as one of largest cargo shipping companies with extensive experience, aims to provide customers with comprehensive information about their cargo. This includes details such as origin port of container, specific operations conducted on commodity, duration spent in each port, and overall sailing time.
  • To accomplish this, we gather data from port agents and extract it from source database on daily basis.
  • We meticulously process each set of data, calculating duration for each operation, and carefully analyze active and idle time of each operation, presenting findings in detailed reports in Tableau dashboard.

Technical Lead

HCL Technologies
04.2017 - 11.2017

Client: Tyco

  • Tyco is fire fighters and many other fire intrusion manufacturing and logistics company.
  • Tuned systems to boost performance.
  • Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
  • Automated monitoring and security measures to reduce required employee attention.

Associate

Cognizant Technologies Solutions
02.2011 - 03.2017

lient: Abbvie Pharma

  • Abbvie is pharma company which sales medicines in all geography and maintains trademark of it
  • In order to effectively analyze a specific market, it is necessary to accurately calculate volume of previous month based on required month.
  • If data for particular month is not available, the system will generate the corresponding month and replicate the previous month's volume.
  • This approach is designed to support the gradual growth of the representative and to help achieve future targets.
  • The entire development process is carried out using Teradata PL/SQL procedure, ensuring a robust and efficient implementation.

Education

Bachelor of Science - Biotechnology

Arunai Engineering College
Tiruvannamalai, India
07.2006 - 04.2010

12th - Bio-Maths

Prince Matric Higher Secondary School
Chennai
06.2005 - 04.2006

10th - Tamil, English

St.Theresa Girls Higher Seconday School
Chennai
06.2003 - 04.2004

Skills

Alteryx Desgining

Certification

Alteryx Core Designer- May 2026

Timeline

Senior System Analyst

Artech Infosystems Private
07.2023 - Current

System Analyst

Hexaware Technologies
11.2017 - 07.2023

Technical Lead

HCL Technologies
04.2017 - 11.2017

Associate

Cognizant Technologies Solutions
02.2011 - 03.2017

Bachelor of Science - Biotechnology

Arunai Engineering College
07.2006 - 04.2010

12th - Bio-Maths

Prince Matric Higher Secondary School
06.2005 - 04.2006

10th - Tamil, English

St.Theresa Girls Higher Seconday School
06.2003 - 04.2004

Alteryx Core Designer- May 2026

Geethapriya R SankaranSenior System Analyst