Subasini Ramalingam

Liaison with external vendors, internal data stewards and Data architect to gather requirements and design solutions in Cloud. Build BI Publisher data models to set up a bulk retrieval mechanism to expose data from ERP systems to S3 buckets. Leverage services of AWS to design solutions & set up CICD pipelines using GitHub Actions. Configure S3 buckets with various lifecycle policies, create monitors, alarms, and notifications for EC2 hosts using Cloud Watch, Cloud trail and SNS. Drive Agile ceremonies

Capture change data (SCD Type1) in ETL and populate Corporate Workforce tables used across the enterprise. Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator. Performance Optimization of SQL queries and improve efficiency of ETL pipelines. Perform downstream impact analysis to facilitate the divestiture of legacy Data Warehouse

Implement , test data purge mechanism in Enterprise HR tables and views for GDPR compliance. Build operational, analytical dashboards in BI Publisher using Employment, Compensation and Performance data. Identify KPIs related to employee headcount, retention and attrition and its correlation with Compensation and Performance. Use IBM Workload scheduler and Mainframe CA7 to set up cross platform job dependencies. Code automated test scripts using Selenium and Java to reduce manual testing efforts.

I studied at NMIMS Global Access School for Continuing Education. My major is Business Management with a subjects like Essentials of HRM, Decision Science, Business Law, Strategic Management, Operations Management, Marketing Management, Business Economics, Financial Accounting, Information Systems

Awards: Best Project in Final year