Business Analyst Resume
PROFESSIONAL EXPERIENCE
Confidential, Houston TX 2010 - 2011
Database Marketing Campaign Analyst, Energy Retail Marketing
- Responsible for developing campaign populations for targeted marketing campaigns for multiple channels using SAS.
- Utilized SAS to create and modify codes which identified and defined strategic business issues in market segmentation, acquisition, retention and attrition.
- Presented reports to management which recommended pricing changes, and created margin reports to compared companies within Reliant’s ERCOT market.
- Directly involved in direct marketing retention, conversion, attrition and LTV projects by performing initial analysis of customer usage and demographics.
- Identified customer segments through pricing models which allowed upper management to make critical decisions in campaign modifications for small business customers through the ERCOT market.
Confidential, Jericho, New York 2006 - 2010
Manager, Business Analysis, Customer Service Operations
- Implemented MS Access databases and produced benchmarking reports in dashboards relating to customer service call volume for analysis at both a high level overview and specific issues and root cause levels.
- Developed criterial algorithms and decision trees to determine and identify trouble calls which are deemed avoidable.
- Designed sub-level statistical performance metrics using MS Excel and Business Objects Crystal Reports, which analyzed customer behavior and aided other departmental entities through Cablevision to make better decisions relating to its products and quality of service.
- Created relationships with campaign marketing department in order to share data which improved current root cause models in identifying issues more efficiently. Previously utilized SAS/EG to import and create databases and libraries in order validate data and analyze field characteristics for further analyses.
- Utilized Six Sigma methodologies such as DMAIC and DMADV for trouble calls, internal dashboard creation and network analyses to cut significant operating costs within the customer service division.
Confidential, Melville, New York 2005 - 2006
Financial Data Analyst, Supply Chain Finance
- Coordinated the development of the annual operations budget and forecasts for delivery and transportation expenses.
- Created financial models to measure productivity throughout distribution network.
- Initiated processes to develop annual standard costs for the local transportation department.
- Prepared weekly, monthly, quarterly and ad hoc distribution financial reports to senior management in corporate, operations and accounting departments using Hyperion/ESSBASE.
- Developed and maintained routine key performance indicators, metrics and glide-paths for carrier services, claims, waste, and data integrity reported by outsourcing vendors.
Financial Data Analyst, Channel Sales Finance
- Performed financial database analyses utilizing MS Access, Excel, Siebel and SAP R/3.
- Reviewed and corrected sales transactions to ensure timely and accurate credit to the appropriate account managers and end-user compliance.
- Improved data quality and integrity issues arising from submission of Sales Out and Inventory Reports from distributors and partners.
- Worked with outside vendors to determine which Chanel sales tool would become the most effective, efficient and affordable way to streamline the commission pay out processes within the US and Latin American sectors for Symbol Technologies.
SAS Statistical Government Analyst
- Performed data manipulation and analyses using SAS/Base and SAS/STAT for ad hoc reports requested from local and federal government agencies.
- Extracted data from the Florida Department of Law Enforcement (CCH) database, US Department of Justice (UCR) and other large databases (ATMS) using SAS and created raw code programming to perform data and statistical analyses of criminal history data using DATA and PROC steps.
Teaching Research Assistant
- While on full academic scholarship for the doctoral program in Theoretical physics, demonstrated and taught physics practical physics labs to liberal arts students and grad students.
Maple, Math lab, SAS/Base, SAS/Graph, SAS/STAT, SAS/EG, HTML, VBA, SQL, SPSS, S-Plus, TOAD/SQL.
Siebel, SAP, MS (Excel, Access, Word, Outlook, FrontPage), ORG Plus, COPES, SAMAS, Group Wise, AutoCAD, Hyperion/Essbase, PRISM, UNIX, Windows 95 - XP, NT, Remedy, GroupWise, Citrix, Business Objects (Crystal Reports)
MS Visio, MS Project, Workforce Management (WFM), ETL experience, Web Intelligence, Xcelsius
- Ph.D. candidate Management (Decision Science)
- MBA. Finance & Accounting.
- Graduate studies (PhD program). Theoretical Physics.
- BS. AppliedPhysics (Materials Science & Electronics).
