As a senior process manager at eClerx, I served the marketing BI division of a computer technology company. My duties involved the following: • Design and perform UAT of Excel dashboards. The dashboards track metrics such as marketing activities and spend across regions and time. • Lead 2 other team members to setup and execute the reports regularly. • Comment on trends observed in reports. • Analyze backend data of reports to provide insights and recommendations • Perform adhoc analytics. Examples: • Identified cross-selling opportunity for 49% of churning accounts to reduce yearly $ churn by 74% and further classified 9% of churning accounts as easy cross-sell targets which could reduce $ churn by 36% ($29M). This was achieved by performing customer segmentation and 80-20 analyses. • Discovered opportunity to increase revenue from key accounts in a country by $58M (18%) by improving the share of wallet of 3% of these accounts to a minimum defined level. This was done by coming up with a methodology to rank accounts based on high buying power, high revenue and low share of wallet. • Used classification techniques such as logistic regression to solve business issues o Modeled revenue patterns for one country to predict margin changes. Found that increasing sales of one product group by $0.8M per quarter has the potential to increase overall business unit margins by $3.7M per quarter. o Modeled prospect customers and new purchasers to identify characteristics of prospects for improved targeting. Provided recommendations to reduce churn by 6% a year. • Developed an initial version of a model to help allocate marketing budget for a business unit for the next fiscal year across regions and activities • Came up with an approach to determine effectiveness (marketing RoI) of gift card programs for a client and analyzed gift card issuance and redemption data • Extract and provide client with data for business decision making from SQL databases, Teradata, Datameer, Salesforce.com, Tableau reports, sharepoint, etc. • Automate manual tasks of client and in report execution using Excel VBA. Examples: o Eliminated manual entry and reduced report execution time by 50%, liberating 80 man-hours per month. o Automated data integrity verification task for client, freeing up 8 man-hours per quarter

I was involved in the following functions: Product Development Reports / dashboards • Designed reports and ensured accuracy of online tools and wrote algorithms for calculation of metrics in my previous role of analyst at Pathways to Success, LLC. Example of reports: o Top physicians in terms of referring patients to specialists and hospital within the health system, and trends o $ impact of timely follow-up care (within 30 days) of discharge for patients with 3 critical conditions (pneumonia, heart attack and heart failure). Found potential for $2M in annual savings (2% of annual costs) due to reduction in readmissions to hospital which are not reimbursed by insurers. o Ranking of primary care physicians in terms of # of patients with emergency care visits, and frequency of visits, as emergency visits get lower reimbursement rates from insurers • Carried out deep dive analyses using transaction level data comparing types of procedures performed by physicians with below and above median performance levels, provided insights to explain reasons for poor performance and help set performance improvement targets • Provided benchmark reports on physician salaries to a health system client to help renegotiate and save 20% in terms of salaries paid Operations • Enabled saving of up to $200,000 by working on-site with a contractor, addressing issues and averting delays. • Created standardization protocol for contractors by applying expertise in interpreting billing system data. • Reduced report audit time by 75% by identifying and placing the most effective checkpoints in workflow. • Saved PTS 20% of outsourcing costs by taking charge of updating company website. Business Development • Helped expand PTS client base from Ohio to Indiana, Kentucky, Pennsylvania, and Georgia by performing analyses comparing its products with competitors’, enabling the company to identify its strengths. • Increased client engagement by modeling the difficulty of pursuing various options to improve the net operating income for a physician’s practice to set realistic targets for improvement.

Business Administration, Operations Management

Biological and Environmental Engineering, Energy

Mechanical Engineering