Data Analyst

Sheela Manoranjitham

+91-822*******; 978-***-****/*****.*******@*****.***

PROFILE 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 high-visibility project development from conceptualization to execution, inception, requirement specs, planning, designing, implementation, documentation and closure in BFSI, Retail (direct & online), Manufacturing, Telecom, Supply Chain & Logistics, Wealth Management

Subject matter expert in developing, managing business dashboards, predictive modeling, forecasting and performance tracking

Proficient in the use of SQL for developing complex Stored Procedures, Triggers, and Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, query writing and SQL joins.

Exposure to working in multiple geographies and different business problems that were solved using data analytics

Expertise in requirement gathering, data warehouse design, development and BI report generation

Experienced in Extraction, Transformation, Loading (ETL) process & & Data Modelling Techniques

Working experience in SAS, SQL SERVER, R, VBA(EXCEL), Python, Postgres

Working experience in PAXATA, Alteryx

Working Knowledge in QlikView & Tableau

Working knowledge of Microsoft Office Applications

Excellent team player and hard-working person with good communication and documentation skills.

Ability to work independently with no supervision with strong organizational & time-management skills with the ability to handle multiple tasks

Good analytical and writing skills and able to strongly drive for result. Ability to quickly produce initial results & iterate to perfection

PROFESSIONAL EXPERIENCE& KEY PROJECTS

Since Mar’2019 INCEDO, Financial Services as Senior Business and Data Analyst

(IT Data Services and Enterprise Architecture)

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 Alteryx

o Data Validation/Data Quality check

o Accessing, investigating, and Blending of Data

oParsing, Transforming, and Calculating

oDoing predictive analytics, and data visualization, which directly apply to the use case or business problem

Nov’16 - Feb’2019 TOTALogistix as Senior Data Analyst

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

Jul’15 - Oct’16 Tibil Solutions Pvt.Ltd. as Senior Business Analyst

Projects:

Credit Risk Model: Leading Finance Company in USA

Responsibilities: Business Analyst (SAS, Excel & PowerPoint)

oProcess of Inspecting: Data Understanding: Variables Understanding

oData Cleaning and Transforming (Data Mart Creation)

oDeveloped 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

oCredit 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)

oProcess of Inspecting: Data Understanding: Variables Understanding

oA 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

oBuilt 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 Europe

Responsibilities: Business Analyst (SAS, Excel & PowerPoint)

oDeveloped 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.

oDeveloped Online Marketing Dashboard to understand and monitor the current state of the business and raise a red flag before it hits the financials.

oDevelop Marketing Campaign Strategies for merchandising campaigns, Generate the list of customers to be targeted for the campaign to be launched and also the data required for modeling.

Jun’11 - Apr’15 Alternative Systems as Business Analyst

Projects:

Customers Value Segmentation: Leading Retailer in Europe

Responsibilities: Data Analyst (SAS, SQL Server & Excel)

oData Extraction and cleansing Transactions history

oData Mart creation that captures vintages, recent transactions, frequency of transactions and value of the transaction

oUsing RFM score, created value segments to optimize the list of customers to be targeted for the campaign

oAutomated the whole process so that every time an ad-hoc campaign is launched, the list of target customers will be generated automatically

Merchandising Campaigns Performance Report: Leading Online Retailer in US

Responsibilities: Data Analyst (SAS, SQL Server & Excel)

oDealt with massive amount of data and created OLAP cubes to query transaction details of Merchandising campaigns

oCreated and automated data marts to generate weekly reports in excel to analyze the performance of merchandising campaigns over search and raise a red flag before it hits financials

Store Optimization: Leading Retailer in UAE

Responsibilities: Business Analyst (R & Excel)

oData extraction, data quality and data profiling

oPerformed Portfolio Analysis and Analyzed the buying pattern of items for individual Suppliers, different brands from same supplier and cluster of stores

oCreated a design to maximize the sales of associated products

oAnalyzed 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 Market Research analysis to capture profitable customer segments for a new business set up

Pricing: Leading CRM Company in US

Responsibilities: Business Analyst (SQL Server, SAS & Excel)

oData cleansing and Data treatment.

oAnalyzed 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

oDeveloped Product Association for Market basket Analysis and built Price Elasticity for each product based on their different prices

oImplement Cross Sell and Up Sell Model

Nov’09 - Apr’11 GopiKrishna Software Solutions as Software Programmer

Projects:

Data Cleansing and Reporting: Financial Services Organization India

Responsibilities: Data Expert (SQL Server & Excel)

oDeveloped a data model and a corresponding data base schema to integrate different forms of data in a comprehensive and standardized manner

oBuilt a historical analytical data mart and created a de-dupe algorithm in order to identify unique customers.

oReporting and Analysis.

Other work experience

Wealthsurance Advisor at IDBI federal life insurance company [2006 – 2009]

Lecturer at Department of Computer Science, Trinity College of Arts and Science for women [Dec 2004 – Apr 2005]

HOD at Department of Computer Science, Subramaniam College of Arts and Science [Nov 2000- June 2001]

Lecturer at Department of Computer Science, Vellalar College for women [Oct 1997 – Oct 2000]

EDUCATIONAL QUALIFICATION

MPhil in Computer Science, (Master of Philosophy/Advance Postgraduate Research degree) [2008 & 2009] Vinayaka Missions University, Salem

M.Sc. in Computer Science (Master of Science) [1995-1997] Avinashilingam Deemed University, Coimbatore

B.Sc. in Computer Science (Bachelor of Science) [1992-1995] Sri Sarada College Salem, Madras University

CERTIFICATIONS/TRAININGS UNDERGONE

QIP Short term course on “Modern Computer Network Management”

Higher Diploma in Software Engineering

Diploma in RDBMS

Certified Business Analytics Professional

PERSONAL DETAILS

Date of Birth: 19th Dec 1974

Address: Coimbatore

Languages Known: Tamil, English & Hindi

Contact this candidate