Sheela Amalraj
Chennai
Summary
An innovative professional having 9+ years of hands-on experience in Data and Business analytics to increase clients/firm's profitability, sales, revenue or decrease cost & credit losses. Proven ability to develop, mentor and train teams on technical skills. Significant exposure in providing operational analytics to solve business problems and evaluate historical experience to make business recommendations. Subject matter expert in developing, managing business dashboards, predictive modeling, forecasting and performance tracking. SQL skills include creating complicated Stored Procedures, Triggers, and Tables, as well as User Defined Functions, views, indexes, user profiles, Relational Database models, query writing, and SQL joins. Working experience in SAS, R, Python, Postgres, Paxata, Tableau and QlikView. Good analytical and documentation skills and able to strongly drive for result. Ability to quickly produce initial results & iterate to perfection.
Overview
7
7
years of professional experience
7
7
years of post-secondary education
4
4
Certifications
3
3
Languages
Work History
AVP
Citi
- Conceptualization and Delivery of the entire Data Quality Framework
- DQM team manages the implementation of best-in-class data quality measurement programs across globe in retail consumer bank (PBW)
- Regulatory Support: Execution of business data quality measurements as per regulatory programs Metrics Design: Identification of critical data elements in different systems, data quality rules design, Testing and validation of rules Data Governance: Standardization of data definitions and ensuring consistency in measurement as per definitions across systems/products/regions
- DQ Score cards: Publishing monthly/quarterly score cards at country level and preparing executive summary reports for senior management Issue Management: Identifying defects and investigating root causes for different issues
- Following up with stakeholders for resolution as per SLA Audit Support: Identifying cases on control gaps, policy breaches and providing data evidence for audit completion
Specialist in Analytics
Larsen & Toubro Limited
- Primary responsibility is to support the Bank's Basel III Risk Weighted Assets (RWA) and Analyzing data and reporting process
- Support the RWA calculation process including performing reconciliation with other report schedules, validation of risk weighted assets, issues investigation and remediation and preparation of work papers
- Prepare & present analysis of variance trends of RWA and develop analytics for results presentation to executive management SME for Basel III Risk Weighted Assets (RWA)-Risk Drivers as well as understand the end-to-end banks capital calculation process including data lineage, system flows etc
- Monitor and stay abreast of regulatory changes, interpret those changes into reporting requirements and Strong presentation and written communication skills Working understanding of US Basel III regulatory rules/regulations and hands on experience with the calculations and data analysis
- Solid understanding of Retail banking products Problem resolution experience requiring strong analytical skills, sound judgment and ability to work effectively with technical and non-technical stakeholders Excellent time management skills and the ability to work under time pressure and handle multiple tasks/projects at the same time Ability to work with large volumes of data from different sources and knowledge on systems Tools: ORACLE SQL Server, Hive, Excel Macros and Python
Senior Data Analyst
TOTALogistix
11.2016
- Highly motivated Logistics Data Scientist adaptable to evolving logistics technology to facilitate the shipping process
- Proficient in customer support and efficient problem solving
- Centered on meeting client expectations while retaining quality standards to ensure timely delivers
- Senior data analyst with responsibilities in master data, and transportation
- Transportation focus on (domestic and international) freight optimization, cost avoidance, and trade compliance
- Handle key carriers in purchasing through communication of requirements, deadlines, and mode of transportation in an effort to reduce freight spend
- Tracked, analyzed and interpreted trends in Spends
- Reported KPI's to internal and external account managers, directors, and senior management on a daily, weekly and monthly basis
- Proactively monitor and manage key performance indicators and execute root cause analysis utilizing TM operating systems Created predictive forecast using spend from previous years and RFP from Carriers
- Analyzed the Contracts from carriers including Incoterms Analysis Generated and provided baseline analysis on a depot, region and network level
- Conducted and supported ad-hoc analysis
- Created and maintained key performance metrics (KPI's) using analytical models and mathematical analysis
- Worked cross-functionally and managed multiple priorities
- Provided technical, analytical leadership and support to improve the quality and timeliness of the S&OP process Aggregated weekly predicted and actual spend to update the company on current business status Innovated lane analysis using data and mapping to pinpoint lane opportunities; instructing Category how to effectively identify, analyze and track lane opportunities
- Good knowledge for import & export of Parcel Tariffs Accrual Analysis for various clients
Analytics Lead Consultant
Infosys
- 01.2023
- Conceptualization and Delivery of the entire Data Quality Framework
- This includes writing data quality rules, creating results dashboards and building the data quality management platform Led the design and requirements of the data quality platform using Tableau for dashboards
- SQL and Hue for DQ rules
- Also developing SQL rules to perform Data Quality checks on data in accordance with the FINRA guidelines and specifications
- It also includes analyzing the results of DQ rules, finding insights on the failures and conveying the same to the data remediator Working with Tableau
Senior Business and Data Analyst
INCEDO, Financial Services
- 05.2020
- Abreast with tool and software concepts to do BA and Data Analytics
- Hands on in Software Engineering Methodologies like SDLC e.g., Waterfall, Iterative (Agile/Scrum), High-Level Technology like Database structure, Reporting Tools interacts with the business stakeholders and subject matter experts in order to understand their problems and needs
- Gathers, documents, and analyzes business needs and requirements
- Writing clear requirements and creating data models, process diagrams and design wireframes that will further support the business' needs
- Also determine what additional information is necessary, what key details are missing and the potential impacts and challenges to the solution and/or other projects
- Managing requirements at the project level to fulfill business needs
- Taking the lead role in Translating and simplifying requirements
- Assisting on what requirements and solutions will best fit a business' needs, now and into the future
- Working closely with key business decision makers as well as development and testing teams, ensure the solution developed will meet the business' requirements in an acceptable and sustainable way
- Involving in data preparation is the process: - collecting data from a number of (usually disparate) data sources, and then profiling, cleansing, enriching, and combining those into a derived data set for use in a downstream process and also analyzing the data using PAXATA
- Using Alteryxo Data Validation/Data Quality check Accessing, investigating, and Blending of Data Parsing, Transforming, and Calculating
Senior Business Analyst
Tibil Solutions Pvt.Ltd.
07.2015 - 10.2016
- Projects: Credit Risk Model: Leading Finance Company in USA Responsibilities: Business Analyst (SAS, Excel & PowerPoint) Process of Inspecting: Data Understanding: Variables Understanding Data Cleaning and Transforming (Data Mart Creation) Developed risk model to predict the default behavior of the customers by identifying debt factors and develop personalize strategy to protect against default of new/ existing customers Credit Risk Model to identify reliable customers who will repay the loan in time Loss Forecasting Model: Leading Finance Company in USA Responsibilities: Business Analyst (R, Excel & PowerPoint) Process of Inspecting: Data Understanding: Variables Understanding A Forecasting tool for Loan Portfolio that utilizes vintage curves and MOB to predict the Loss Forecasting by preparing Loss Curves and Loss Forecasting Numbers based on delinquency buckets Built a forecasting tool for Credit Cards Portfolio that utilizes vintage curves and time series forecasting to predict the future financials and key metrics of the business
- This functionality is fully automated using R and Excel
- Developed Customer Lifetime Value model for credit cards that contains the forecasted values for the key drivers and profit estimates at an account level
- Developed sophisticated forecasting engine for daily bill pay volume that helped the customer to understand the client level detail and daily payment behavior Online Demand Forecasting: Leading Retailer in US Responsibilities: Business Analyst (SAS, Excel & PowerPoint) Developed a forecasting tool in SAS/Excel using Linear Regression Model that predicts unattributed online demand and automated the whole process that brought down the process time considerably
- Developed Product Association for Market basket Analysis and built Price Elasticity for each product based on their different prices Implement Cross Sell and Up Sell Model DQC & Reporting: Leading CRM Company in US Responsibilities: Business Analyst (SQL Server & Excel) Data cleansing and Data treatment
- Analyzed the existing products portfolio and created segments which linked customers purchase behavior to their overall value and built campaign strategies for optimizing the financial performance in terms of product mix
Software Programmer
GopiKrishna Software Solutions
11.2009 - 04.2011
- Projects: Data Cleansing and Reporting: Financial Services Organization India Responsibilities: Data Expert (SQL Server & Excel) Developed a data model and a corresponding data base schema to integrate different forms of data in a comprehensive and standardized manner Built a historical analytical data mart & Reporting and Analysis
Education
MPhil in Computer Science - undefined
Vinayaka Missions University
01.2008 - 04.2009
M.Sc. in Computer Science - undefined
Avinashilingam Deemed University
01.1995 - 04.1997
B.Sc. in Computer Science - undefined
Sri Sarada College
01.1992 - 04.1995
Certification
QIP Short term course on "Modern Computer Network Management"
Personal Information
- Date of Birth: 12/19/1974
- Gender: Female
Timeline
Senior Data Analyst
TOTALogistix
11.2016
Senior Business Analyst
Tibil Solutions Pvt.Ltd.
07.2015 - 10.2016
Software Programmer
GopiKrishna Software Solutions
11.2009 - 04.2011
MPhil in Computer Science - undefined
Vinayaka Missions University
01.2008 - 04.2009
M.Sc. in Computer Science - undefined
Avinashilingam Deemed University
01.1995 - 04.1997
B.Sc. in Computer Science - undefined
Sri Sarada College
01.1992 - 04.1995
AVP
Citi
Specialist in Analytics
Larsen & Toubro Limited
Analytics Lead Consultant
Infosys
- 01.2023
Senior Business and Data Analyst
INCEDO, Financial Services
- 05.2020
QIP Short term course on "Modern Computer Network Management"
Higher Diploma in Software Engineering
Diploma in RDBMS
Certified Business Analytics Professional
Similar Profiles
Rebecca FormaRebecca Forma
Mortgage Loan Processor at CitiMortgage Loan Processor at Citi
Mahima BhandariMahima Bhandari
Assistant Vice President - Product Manager at CitiAssistant Vice President - Product Manager at Citi
Muralidharan RMuralidharan R
Assistant Vice President at CitiAssistant Vice President at Citi
Steven McAreeSteven McAree
Data Quality Manager at CitiData Quality Manager at Citi
Hari Krishna NallapareddyHari Krishna Nallapareddy
Lead Engineer at VESTAS WIND TECHNOLOGY INDIA PRIVATE LIMITEDLead Engineer at VESTAS WIND TECHNOLOGY INDIA PRIVATE LIMITED