Data Engineering

Mani Ramanathan

**********@*****.***

**** * ******* ****, #108*-***-***

5849

Phoenix, AZ

S

ummary

Six years of professional experience in business and data analysis from

finance and health care industries.

Excellent logical, analytical, critical-thinking, problem-solving and

programming skills.

Possess all the vital senses of a great analyst - business sense, process

sense, data sense, statistical sense, analytical sense and programming

sense.

Always at ease with manipulating numbers as well as deriving useful

insights from it.

Advanced SAS-certified programmer and strong expertise in advanced-level

usage of Excel.

Outstanding academic performance in Mathematics, Engineering, Operations

Research and Statistics courses from reputed institutes.

Specialties

Business analysis, Data analysis, Statistical analysis and SAS programming.

Professional Experience

Marketing Analyst at American Express Bank August

2007 - Present

Responsibilities

Extracted, cleansed, explored, manipulated, summarized and analyzed account

payable data from global clients and created XML-driven analytical reports,

that gives spend intelligence as well as marketing insights for product

expansion and launch.

Developed a complex algorithm in SAS to identify the supplier hierarchies

that has multiple disjoint tree structures. This is critical in capturing

the performance metrics accurately and finding new opportunities precisely

within a given supplier hierarchy.

Explored, manipulated, summarized and analyzed the International Corporate

Card Marketing data to create analytical reports, that drives various key

marketing strategies.

Developed various ad-hoc macro utilities that improves the productivity of

SAS process development and deployment.

Tools used

SAS Base, SAS Macro, XML, VBA, Excel and Access

Portfolio Management Analyst at Cavalry Portfolio Services

May 2005 - August 2007

Responsibilities

Queried, explored, manipulated, summarized and analyzed data of existing

collection strategies, to understand and improve the collection business

intelligence.

Designed and conducted various statistical tests including TTEST, ANOVA,

NPAR1WAY and CHI-SQUARE to evaluate the effectiveness of mail campaigns and

dialer strategies.

Developed a logistic regression model that predicts a binary response for a

mail campaign.

Created analytical reports that drills down various performance metrics of

existing collection strategies by key collection performance drivers

including debt balance, recovery score, payment history and demographics.

Key Projects

Portfolio Management Report: Designed and developed a report that tracks

collection dollars, average inventory allocations and liquidation rates of

various portfolios by different collection strategies. The report also

drills down the performance metrics by key attributes of a collection

strategy including discount offered, total number of mails sent and total

number of dials attempted

Analysis of effectiveness of mail campaigns: Designed and developed a

report that evaluates the effectiveness of different mail campaigns of key

portfolios, to get useful insights of the strategy. Summarized data by

various segments including offers sent and outstanding balance and

calculated liquidation rate and total cost of mail campaigns.

Mail Response Model: Developed a logistic regression model that predicts a

binary response of a debtor to an offer letter sent. Queried, cleansed,

summarized and analyzed the mail campaign data, and built, tested and

implemented the model as well. Conducted a Chi-Square test to do the

Initial screening of predictors and used linear transformations and step-

wise regression in deciding the final set of predictors.

Tools used

SAS Base, SAS Macro, SAS STAT, SQL, VBA, Excel and Access

Health Care Data Analyst at Mercer Human Resource Consulting

February 2004 - May 2005

Responsibilities

Generated queries, analyzed large data sets and created customized reports

using SAS programming.

Improved the development, standardization and efficient deployment of data

knowledge.

Analyzed and interpreted health care payment and utilization data for

commercial and Medicaid clients.

Analyzed and validated encounter, claims, eligibility, provider and

pharmacy data.

Key Projects

Enhancement of data validation process: Enhanced the data validation

process through adding more representative summary statistics and

percentile distributions as well as adding data integrity checks through

cross-tabulations.

Automation of data importing: Automated the laborious and time-consuming

process of importing large DAT, TXT, CSV, XLS and MDB files into SAS data

sets. The lead time was reduced from 60 minutes to 3 minutes and thus the

productivity of entry-level data analysts was significantly improved.

Data de-duplicating and linking: Analyzed large provider population for

duplicate providers and de-duplicated and linked them together using a

proprietary scoring model developed by SAS macro programming.

Tools Used

SAS Base, SAS Macro, SAS STAT, SQL, Excel and Access

Relevant Projects

Modeling and Analysis of staffing - Modeled and optimized the complex

staffing of a chain restaurant where the customers have to wait in a

network of queues for service, using appropriate queuing theory concepts.

Modeling and Analysis of a Semiconductor Inter-bay AMHS- Modeled and

analyzed the system using ARENA 5.0 to come up with the optimal operational

control logic while meeting the delivery time requirements.

Supplier Collaboration Optimization Package - Designed a software product

using J2EE that optimizes the collaboration between a manufacturer and his

suppliers in a complex supply chain network. Best rated in a class of 25.

Regression Analysis on Average Life Expectancy - Analyzed the influence of

various possible regressors on Average Life Expectancy using Linear

Regression Analysis and consequently built a prediction model.

Optimization of scheduling in parallel machines - Analyzed and compared the

performances of Apparent Tardiness Cost, Modified Due Date and Genetic

Algorithm in minimizing the total weighted tardiness.

Enterprise Integration Package - Designed a software product using VB and

oracle that integrates various functions of a typical manufacturing

enterprise. Complex SQL queries, implementation of JIT concept, efficient

scheduling algorithm and extensive programming are some of the interesting

aspects of this project.

Fractional Factorial Experimentation - Analyzed the influence of various

possible factors on the data transfer rate over different types of computer

networks using Quarter Fractional Factorial experimentations.

Traveling Salesman Problem - Analyzed and compared the performances of

Genetic Algorithm and Simulated Annealing Algorithm on medium-sized

traveling salesman problems and found the former to be performing the best.

Decision analysis in making a career choice - Modeled and solved an

uncertain situation that involves making a career choice, using decision

analysis tools and did sensitivity analysis for further conclusions.

Relevant Courses

Simulation - Simulating Stochastic Systems, Simulation System Analysis and

Simulation in manufacturing.

Decision Science and Optimization - Analysis of Decision Processes Models,

Deterministic Operation Research Models, Stochastic Operation Research

Models and Scheduling and Network Analysis.

Statistics - Regression Analysis and Design of Engineering Experiments.

Software Engineering - Information Systems Engineering and Systems Analysis

for Distributed Systems.

Proficiency in Software

Simulation Packages : Arena 5.0, AutoMod and Slam II.

Optimization Tools : What's Best and Lindo.

Statistical Packages : SAS, SPSS, Design Expert and Minitab.

Decision Analysis Tools : BestFit, PrecisionTree, @RISK and

RISKOptimizer.

Programming Languages : C, C++, Java, Visual Basic and FORTRAN.

DBMS/RDBMS : Oracle and MS-Access.

Education

Arizona State University MS Industrial Engineering 2001 - 2003

GPA: 3.6/4.0

Anna University BE Industrial Engineering 1995 - 1999

GPA: 8.0/10.0

Honors and Awards

Deans Honors in Graduate coursework.

Distinction in Undergraduate coursework.

District-level gold medal in High School Diploma.

Contact this candidate