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, Proffiling 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.

TECHNICAL SKILLS

• 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, NE

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, Omaha, NE

Statistical Analyst

Responsibilities:

• 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.
• Worked closely with internal business units to design and deliver key performance measurements (operational, financial and marketing) to discuss analysis needs.
• Created complex and reusable Macros and used existing macros for Data Cleansing, Validation, Analysis and Report generation.
• Coded and modified existing SAS programs to automate the process and improve efficiency.
• Extensively used various SAS ODS techniques to generate complex reports.
• Performed sophisticated analysis such as “in business” segmentation analysis using data elements and forecasting, based on the result by tele-research teams.
• 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, Irvine, CA

Risk Analyst

Responsibilities:

• 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

Responsibilities:

• 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,owerPoint, SAP Business Objects.

Confidential

Business Analyst

Responsibilities:

• 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.