PROFESSIONAL SUMMARY

• Over 8 years of experience in IT including 6yrs SAS Analyst and 2yrs as Business Analyst.
• Extensive knowledge of Financial, Retail and Campaign marketing data.
• Experience working on SAS Business Intelligence BI platform with Enterprise Guide and other tools.
• Expertise in Data Mining, SAS Programming, Database Management, Marketing Research, Forecasting and Statistical Analysis Techniques with proficiency in Statistical Data Analysis, Predictive Modeling, Consumer Segmentation, Profiling and Project Management
• Worked as a liaison between catalog circulation teams and business teams to understand the requirements and developing the code based on requirements.
• Extensive experience in Base SAS, SAS/MACROS SAS/SQL, SAS/GRAPH, SAS/ACCESS and SAS/ODS etc in Windows and Unix environment.
• Experience in data management, data extraction, manipulation, validation, and analyzing huge volume of data.
• Expertise in transforming data imported from different data sources into analysis data structures, using SAS functions, options, ODS, macro facility and storing and managing data in SAS data files.
• Expertise in data analysis, complex reports generation with macro utility to improve efficiency.
• Expertise in writing utility macros and extensively used existing macros for validation, analysis, report generation and integration of data.
• Highly experienced in extracting data from relational databases like IBM-Netezza, SQL Server and MS Access etc.
• Experience in complete Software Development Life Cycle SDLC of the project such as modeling, process flows, development, unit testing and documentation.
• Strong analytical, data interpretation and problem solving skills.
• Strong critical thinking and quantitative reasoning skills.
• Strong communication skills and ability to work individually and in a team environment.

Skills :

Statistical Software: Base SAS, SAS/SQL, SAS/MACRO, SAS/ODS, SAS/ACCESS, SAS/CONNECT, SAS/IntrNET, SAS/ETL, SAS/GRAPH, SAS/ENTERPRISE GUIDE SAS BI Tools. SPSS, E-VIEWS, STATA, ADVANCED EXCEL.

SAP, MS VISIO, MS ACCESS, SAP BUSINESS OBJECTS.

PROFESSIONAL EXPERIENCE

Confidential

Senior Marketing Statistician

Responsibilities:

• Develop predictive models Logistic Regression Models on 220 in-house catalogs for non-profit and B2B customers predict customer behavior via segmentation and profiling using SAS.
• Develop statistical models Logistic Regression Models to generate propensity scores using weights and segments for direct marketing campaigns.
• Responsible for data extraction, sampling, developing statistical models, building predictive models, validating and final scoring.
• Sourced and analyzed data from a variety of sources like SAS data sets, MS Access, MS Excel, CSV and flat files etc.
• Provide ad-hoc analysis to support customer targeted marketing efforts and predict customer buying trends for free shipping campaigns.
• Deliver timely, error-free reporting for various email campaigns for management decisions.
• Assist the team for standardization of reports using SAS macros and SQL and modified programs in SAS under Unix environment.
• Employ analytic techniques in relation to marketing effectiveness to improve the performance of marketing programs.
• Involved in peer review, testing of the code written and documented every step as part of report development documentation.

Environment: Base/SAS, SAS/Macro, SAS/SQL, MS Access, SAS/UNIX, Business Objects.

Confidential

Statistical Analyst

• Data Analytics team provides analytics support for tele-research and quality assurance teams. As a statistical analyst, I was responsible for production support and running the analysis, reporting, modeling and forecasting to provide insights and data points to the business group. Worked with quality assurance and tele-research to develop a process that segmented business records into two group in business and out of business . I had to combine five different data sources with the main database and write SAS programs and devise a plan to test the appended data elements were useful in determining whether or not the company is in business or out of business . Involved in key projects : Cleansing business database and segmentation of business and consumer database for data quality efforts.
• Performed sophisticated analysis such as in business segmentation analysis using data elements and forecasting, based on the result by tele-research teams.
• Extensively used various SAS ODS techniques to generate complex reports.
• Coded and modified existing SAS programs to automate the process and improve efficiency.
• Created complex and reusable Macros and used existing macros for Data Cleansing, Validation, Analysis and Report generation.
• Worked closely with internal business units to design and deliver key performance measurements operational, financial and marketing to discuss analysis needs.
• Collected and analyzed data from various sources like SAS data sets, MS Access, MS Excel, CSV and flat files and wrote SAS programs to generate desired data sets.
• Communicated segmentations to tele-research to identify in business segments, and implemented solutions into production workflow.
• Developed audit and control scripts/programs to identify gaps/fallouts in the production processes to streamline processes Documented the processes for other new resources to support the production activities.

Environment: Base/SAS v9.1, SAS/Macro, SAS/SQL, SAS/STAT, MS Access, Windows XP, UNIX, AS400, Advanced Excel.

Confidential

Risk Analyst

• Leads team was responsible for risk analytics in product development, strategy design and risk based P L modeling related to Retail and Lease products as well as new company products. As a Risk Analyst, I was responsible for developing risk strategy, planning and risk appetite framework for HCA's overall market strategy to include economic impact and segment analysis, new product, new geography risk strategy development as well as developing necessary data and modeling infrastructure validation and governance.
• Involved in designing, documenting, analyzing, and managing complex credit risk projects, developing and maintaining analytical applications and data structures needed for modeling and forecasting using SAS.
• Involved in querying data from various data sources and preparing sample data for building predictive models.
• Responsible for ad-hoc requests for business insights from management and responsible for communicating statistical findings/results to management.
• Monitored and evaluated performance of existing credit risk strategies for new products and geography by analyzing and evaluating large data volume utilizing various statistical and analytical techniques.

Environment: Base/SAS v9.1, SAS/Macro, SAS/SQL, SAS/STAT, MS Access, Windows XP, UNIX, Advanced Excel, MS Word, MS Powerpoin

Confidential

Data/SAS Analyst

• HP's Global Analytics group helps understand analytics to drive Competitive Advantage, Business Intelligence, Customer Insight, Marketing and Pricing for internal HP global teams. As part of the HP's global analytics team I was involved in implementing business intelligence solutions across all of HP's different business units and Finance function. As a Data Analyst, I was responsible for providing analysis and interpretations of campaign data and market insights to identify key drivers for Marketing Return on Investment ROI optimization.
• Conduct data-driven analysis based on primary and secondary market research and customer data.
• Build statistical models to predict customer shopping behavior and elasticity.
• Identify data requirements to be able to conduct future analytic studies in a timely and efficient manner.
• Analyze and interpret campaign data and market insights to identify key drivers for Marketing Return on Investment ROI optimization.
• Participate in testing to ensure new marketing processes and applications are delivering the benefits based on customer insights.
• Document and communicate marketing requirements to management.

Environment: SAS, SAP FI/GL, MS Visio, MS Access, Excel, PowerPoint, SAP Business Objects.

Confidential

Business Analyst

• As part of the business solutions architect team at Hewlett-Packard I was responsible to lead the Shared Service centers transformation efforts of implementing future process and system capabilities for all domain areas in F A. Coordinating the transformation within the supply chain organization and the implications to the shared services process and systems. I was also responsible for financial business process design, process mapping, process presentations to clients, process documentation and process training.
• Responsible for re-engineering process by developing and maintaining statement of work SOW , drawing up process maps, presenting process maps to customers and incorporating customer requirements.
• Regularly presented new process solutions to Financial Controllers at Customer site. Visited various customer sites to conduct fit gap analysis and gather tribal knowledge legacy information .
• Involved in documenting business process by identifying the requirements and also involved in defining system requirements.
• Monitored, resolved, outlined and streamlined General Ledger processes on SAP for North America Operations.
• Worked with product owners and software developers to discover new ways to enhance content, functionality for SAP and other business applications
• A single point of contact for all Product Support and Quality Assurance issues for both operations and customers.
• Supported end users and businesses in the form of assistance in understanding functionality, fixing problems, adding functionality and implementing SAP at new sites.
• Attended workshops in the US Cincinnati , UK London , Germany Frankfurt and Poland Wroclaw on legacy systems and SAP migration.
• Single point of contact for all KPMG audits.
• Project management experience in full cycle implementations.

Environment: SAP FI/GL, MS Visio, MS Access, Windows XP, Excel, PowerPoint, SAP Business Objects.