Skill Summary

• MBA in MIS and Marketing
• Experience in the development of Data Marts containing customer information data to support predictive modeling
• Experience in Multivariate statistical analysis including ANOVA, Regression, Factor and Discriminant analysis techniques.
• Expert level skills in SAS, SQL, RDBMS like SQL Server and Oracle running on Windows and Unix operating systems. Proficient in integrating with Microsoft Office products.

• Interviewed users, gathered requirements and developed specifications for a CRM application
• Evaluated software options for development of a 10-15 user system
• Developed automated processes using SAS software to populate Act! Database
• Customized Act! User interface and database fields

Intuit, Inc. – Data Mining & Database Marketing (4 month project)

• Developed architecture for a Oracle based Data Mart specific to analyzing marketing campaign data (sales, registration and promotion). Addressed issues related to data infrastructure and technical architecture
• Developed data aggregation rules for a multidimensional Data Mart
• Incorporated design changes to integrate easily with an enterprise-wide Data Warehouse
• Used SAS Enterprise Miner for mining Data Mart
• Wrote SAS & SQL programs to extract data from Data Mart for ad hoc reporting
• Developed Excel Pivot Table and SAS based reporting processes
• Created and maintained detailed project plans for OLAP / analytical reporting initiatives.
• Presented Data Mart proposal to executive management
• Developed several reports in SAS and Excel to analyze historic sales of Intuit tax products
• Explored market basket analysis and other data mining tasks using SAS Enterprise Miner
• Developed Analytical Data Mart containing primary and secondary data for predictive modeling

Sun Microsystems, Inc. – Statistical Analysis (several assignments over three years)

• Identified research questions and developed hypotheses to be tested.
• Devised processes to code survey questionnaires and capture data in a database.
• Wrote SAS programs to reformat data elements.
• Created tabulations and listings
• Performed following univariate and multivariate analysis using SAS/Stat: T-test, Chi-square, Correlation Analysis, ANOVA, Factor Analysis, Regression Analysis
• Developed detailed reports explaining selection of statistical tests and interpreted results.

Consulting Psychologists Press, Inc. – Statistical analysis (1 year on-going project)

• Coded STRONG & MBTI vocational testing questionnaires
• Created databases in SAS to store data
• Developed SAS macro programs along with third party tools like Data Junction, for data cleansing and ETL processes
• Tuned database structure to improve performance and facilitate data exchange
• Analyzed data using multivariate statistical techniques using SAS/Stat T-test, Chi-square, Correlation Analysis
• Created reports and graphs using SAS/Graph

• Interviewed managers to define measurements for analyzing performance of CRM service center.
• Wrote SAS programs to automatically generate reports from Informix using SQL and SAS/Access.
• Developed process specifications and designed reports to be distributed via email and Intranet.
• Developed a prototype EIS application to provide real time performance assessment.

St. John's Hospital – Market Research (3 month project)

• Designed questionnaire to study woman's health care services
• Selected sample and created mailing lists
• Administered questionnaires via mail and telephone
• Coded questionnaires and entered data into SAS datasets
• Performed detailed univariate and multivariate analysis - T-test, Chi-square, Correlation analysis, ANOVA
• Created tabular and graphical reports
• Presented findings to hospital management

Pacific Bell – Marketing Database Analysis (2 years on-going project)

• Designed logical and physical data model to incorporate Census Block Variables, Microvision profiling, and related customer segmentation & distribution variables
• Developed SAS processes to combine primary data such as billing and direct mail campaign data with secondary data
• Used SAS software to analyze this data to evaluate campaign performance
• Developed backup/restore and replication strategies using IBM utilities
• Developed automated processes to transfer data to/from vendors such as Demographic scoring companies, mailing list houses and advertising agencies
• Wrote several SAS programs for data cleansing, mailing list generation
• Revised mailing lists for future campaigns based on prior campaign’s performance
• Developed SAS based process to create product wise performance reports

Pacific Gas & Electric Company – Marketing Information System (3 month project)

• Participated in the design of a marketing information system
• Wrote SAS/AF software to create a front-end for the system
• Developed SAS based processes to interface with customer billing data

Avon Inc. – Strategic Analysis (6 month project)

• Designed and developed SQL based databases to store data on Marketing Campaigns.
• Carried out statistical analysis to support sales forecasting and new product launch.
• Performed financial analysis to assess sales force performance and set targets
• Created reports using SAS software

Macro Consulting – Market Research
Conducted market survey analysis in the food industry to study brand image, market share, consumer profiles & perform competitive analysis.


Bardsley & Haslacher, Inc. – Market Research Business Development
Developed a business plan to revive this company’s business potential.


The Far West Research – Market Research Consulting
Offered statistical consulting in sampling techniques, questionnaire design, coding and analysis of survey data.


The Research Alliance – Market Research
Statistical analysis of survey data using SAS/STAT and techniques like ANOVA, FACTORS analysis and univariate procedures.


Aradigm Corporation – Product Marketing Support
Procured data from NIH on DCCT study (Diabetes Control and Complication Trial), and located other secondary data sources on diabetes. Developed SAS programs to search Meta data and identify information regarding insulin dose and patterns of use. Analyzed clinical trial data and created graphical and tabular reports using SAS and Excel.


Oklahoma State University – Survey Research
Assisted in design and development of survey instruments and the analyses of data using statistical and quantitative techniques.