Neevitha Vijayakumar
Stockholm
Summary
Solutions oriented Data Engineer with over 7+ years of experience in retail, banking and healthcare solutions that provide business insights and metrics for corporate decision making. Background includes data mining, warehousing and analytics. Detail-oriented team player with strong organizational skills. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills. Willingness to take on added responsibilities to meet team goals.
Overview
8
8
years of professional experience
Work History
Data Engineer
TCS - H&M
03.2021 - 11.2021
- Worked as a Data Engineer for H&M Client on the Ground Calculation Platform which is used to process the H&M Key data of Article & Region wise sales information and process them in the formats which is used by Business & Algorithm to predict and Plan the Forecast information for Buying & Production Office
- H&M was in the Cloud Adoption Strategy, for that redesigned and Migrated the On-perm ETL flow completely to Azure through Azure Data Factory and transferred, redeployed Data Pipeline and Successfully Ramp downed the On-perm Solution
- Designed, Migrated and implemented Azure business intelligence solutions using Azure SQL DB, Azure Data Factory, Azure Data Lake Gen2
- Created and orchestrated pipelines using Azure Data Factory including creation of dynamic pipelines for loading API data to Azure SQL DB and integration patterns for data movement between databases and files in both Azure and on-premises
- Migrated SSAS tubular from on-premises to Azure and build an ADF pipeline to process and query the tabular
- Secure the infrastructures created in Azure by using Key vaults, Managed Identity, IP restrictions, Azure Active Directory
- Designed and implemented data transfer pipelines between Azure services and on-premises systems, leveraging Azure Data Factory to create accurate historically comparable baselines of sales, stocks, orders and purchases
- Performed Data Mapping and Modeling, Data Cleansing and validation and Performance tuning
- Worked with large-scale data sets and has experience in both batch and real time Data Integration
- Created PowerBI dashboards to monitor the SQL jobs and to provide support
- Build CI/CD pipelines in Azure DevOps for the deployment of Azure components
- Involved in Azure architectural decisions along with Senior Architect
Technology Analyst
Infosys - Microsoft
01.2018 - 07.2020
- Worked for Microsoft Client as a Business Intelligence Developer for a Scorecard Program, which is used to share the metrics utilization and consumption data report
- The report provides Market wise and Organization wise details, which is used by the Microsoft to plan their Market & Solution Strategy
- Created objects for temporary processing, consolidating and loading the data into databases using Integration services
- Created stored procedures, functions and views for periodic report generation
- Designed and developed SQL Server Integration Services-SSIS packages with different control flow tasks and data flow transformations and deploying the packages
- Created transformations, mappings using data flow tasks and created event handlers for the packages
- Involved in performance tuning and query optimization for efficient result
- Tested Scheduled Jobs and maintained the ETL packages using SQL Server Management Studio
- Understand report specification document and designed the reports which meets the client requirements.
Software Engineer
IVY Mobility Solutions LTD
07.2015 - 01.2018
- Ivy Mobility provides a cloud-based intelligent Route-to-Market (iRTM) solution for consumer goods companies
- Ivy Mobility helps his customers to scale, innovate and transform into digital seamlessly
- Ivy Mobility solutions help consumer goods companies increase visibility and expand their reach into the widest of geographies
- Designed and developed SSIS packages to extract, transform and load from synced data into SQL server
- Created complex stored procedures, triggers, functions, indexes, tables, views and SQL joins
- Provided logging, error handling by using event handler and custom logging for SSIS packages
- Created various reports using SSRS for analysis and managing claim processing
- Created tabular reports, matrix reports, list & chart reports, parameterized reports, sub reports, drill down reports as well as interactive reports according to business requirements in a time restricted environment
- Scheduled reports using Reporting services to Email with an attachment in the desired format of report to the top management
- Maintained and provided support to the users for the applications and deployed reports.
Officer/Analyst
Standard Chartered Bank (Scope International)
12.2013 - 07.2015
- Standard Chartered is a multinational bank with operations in consumer, corporate and institutional banking and treasury services
- Customer due diligence is one of the applications and is the process used by financial institutions to collect and evaluate relevant information about corporate clients
- Implemented new enhancements to the CDD application and involved in integration testing to ensure end to end functionality and responsible for development of CDD applications to take an overall active client details
- Worked in data analysis and backtracking of the issues from target table till the source tables followed by rectification of SSIS package codes
- Developed packages and involved in release activities to production
- Worked closely with a team of business analysts which involves requirement gathering, creation of technical design and documentation.
Education
Information Technology
Anna University
Trichy, TamilNadu05.2013
Skills
- Azure Data Pipeline Design
- Data Pipeline Design
- ETL development
- Data Warehousing
- Data Modeling
- Data Migration
- Performance Tuning
- SQL Programming and Databases
- Business Intelligence
- Data Analytics
- Data Mining
- Data Security
- Requirements Gathering
- Technical Support
- Power BI
Accomplishments
Insta Award, Infosys, Chennai (Jan 2018 - July 2020)
Languages
Tamil
Native language
English
Proficient
C2
Tamil
Proficient
C2
Kannada
Proficient
C2
Timeline
Data Engineer
TCS - H&M
03.2021 - 11.2021
Technology Analyst
Infosys - Microsoft
01.2018 - 07.2020
Software Engineer
IVY Mobility Solutions LTD
07.2015 - 01.2018
Officer/Analyst
Standard Chartered Bank (Scope International)
12.2013 - 07.2015
Information Technology
Anna University
Similar Profiles
Raghu UppatalaRaghu Uppatala
Data Engineer at TCSData Engineer at TCS
Judy ThomasJudy Thomas
Senior Process Associate (Pharmacovigilance) at TCSSenior Process Associate (Pharmacovigilance) at TCS
HANAMANT MANEHANAMANT MANE
DevOps Engineer at TCSDevOps Engineer at TCS