PROFESSIONAL SUMMARY:

• Extensive experience in SAS programming and Marketing / Marketing Analytics with Healthcare, Financial clients and non profit clients.
• Certified SAS professional with experience in Finance/Utility/Insurance/Mortgage/Credit Card service domains in Statistical Analysis, Reporting and Data Management involving Analysis, design, development, testing and validating the applications of Business Analytics projects using SAS softwares.
• Extensive experience with SAS Enterprise Guide/ SAS Enterprise Miner / SQL/ Excel.
• Extensive exposure of every steps of entire project life cycle including data collection, query, modifying, analysis, summary of findings, communicating strategic insight and presentation of results and documentation of the processes.
• Expert proficiency in gaining deeper understanding of the consumer, products and channels and translating that understanding into insights measurement solutions in a dynamic, fast paced environment.
• Proven skills in data archival, data migration, ad - hoc reporting, and coding using SAS on various environments like Windows and UNIX.
• Expertise in Data Reporting, Campaign Marketing Strategy, Predictive Modeling, Quantitative Analysis, Data Manipulation, Member Segmentation, and Team/Project Management.
• Experience working with large databases to perform complete data retrieval, manipulation using multiple input files using SAS data steps .
• Possess strong ability to quickly adapt to new applications and platforms. Experience in interacting with clients, multiple user groups and managing development teams.
• Experience in supporting multiple projects under deadlines often with competing priorities and complexities by applying critical thinking, problem solving, and decision-making skills to optimize solutions.
• Proficient in MS Excel: V-lookup, H-lookup, pivot table and data analysis.

TECHNICAL SKILLS:

Data Bases: SAS, Base SAS, SAS Enterprise Guide, SAS Enterprise Miner, SAS Customer Intelligence Studio, R Studio, SQL Server, MySQL, 1010 Data, R, Big Data, Tableau, Hadoop

SAS/SQL Procedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, Summary, Sort, Reg, SQL, Copy, Freq, Forms, Upload, Download, Formats, Data Visualization, Data Mining Techniques, SQL, Statistical and Predictive Modeling, Text Mining, Sentimental Analysis, GIS, ANOVA, Marketing Segmentation, Data Interpretation, GIS applications, Web Analytics, Market Based Analysis, Time Series Analysis, Marketing Optimization.

Analytical Capabilities: Statistical and Forecasting Models, Marketing Optimization, Multi-Channel

Effectiveness, Customer Life: Time Value modelling, Social Media Sentiment AnalysisData Mining, Multivariate Testing, Business Intelligence, CRM Analytics, Big Data Analytics, Data Visualization, Product Analytics/Insights, Automation, Web Analytics, Text Mining, GIS Applications, Experiment Design and A/B Testing, Machine LearningPredictive Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. SAS Developer / Programmer

Responsibilities:

• Analyze and evaluate business requirements from Economists on Consumer Expenditure (CE) survey data and convert the rules/requirements into detailed flow charts, functional specification and design documents.
• Perform Statistical Analysis on Data Collected including Regression Analysis, Time Series Analysis, Multivariate Analysis, and Survey Development and Reliability/Validity Testing for the CPI (Consumer price Index) and PPI (Producers Price Index) Surveys.
• Design, Analyze and Develop Web-based Report Systems in support of The Consumer Expenditure Survey Program (CE).
• Act as an advisor and problem-solver for US Department of Labor (DOL) by identifying undefined issues, researching root issues, summarizing information and providing suggestions and solutions.
• Serve as a senior information technology specialist for developing one or more applications through all phases of the Department of Labor (DOL ) System Development Life Cycle, including the inception, elaboration, development and transition to production.
• Work with Confidential for Data and Specifications on the collected Data to respond to internal requests to provide information, reports and detailed data needed to make sound and timely decisions.
• Extract and process analytical data for Geographical Analysis and Market Analysis (Including some Economic Data) from the FPDA (Federal Procurement Data System) as well as data from the Confidential .
• Increase system efficiency of data processing procedures through creating and utilizing SAS Macro facilities.

Confidential, Charlotte, NC

Sr. Insights Delivery Consultant

Responsibilities:

• Create analytical reports and marketing insights dashboards through the use of marketing results data, transaction history, SAS and Tableau.
• Produce compelling stories from the fusion of data with visualization techniques and analytic methodologies and deliver presentations of data and content for clients in an accurate, understandable and engaging manner.
• Create, automate, maintain reporting solutions to communicate KPIs to the leadership team.
• Develop and manage strategies through data mining and analytical techniques that are synthesized to the strategic and tactical objectives of Product Marketing initiatives.
• Support client growth and retention by providing insightful data-driven analytics to grow customer base, increase marketing ROI and improve leads to customer conversion metrics.
• Responsible for performing root case analytics, statistical modeling on customer data to support Confidential ’s big data platform and data integration strategy.
• Perform ad-hoc analysis and develop reproducible analytical approaches to meet Confidential ’s business requirements.
• Compile and share campaign results with senior management and executives for decisions determining risks, funding and opportunities for improvement.
• Build/maintain a marketing, personalization, and analytics data mart that captures all customer interactions from all the channels (Direct Mail, Email, Digital, Indirect) .
• Define, design and develop customized analytical reports that concert with business partners (Product Marketing) to improve their understanding of customer actions, evaluate business priorities and economics.

Confidential, Washington, DC

Sr. Business Analyst

Responsibilities:

• Managed entire data science project life cycle like data extraction, data cleaning, statistical modeling and data visualization with large datasets of structured and unstructured data.
• Executed data mining, data analysis, data management and reporting using SAS and on multiple data warehouses to generate reports for use in quality monitoring and improving customer experience.
• Ensured that service level agreements between the client and its affiliates are met by generating weekly and monthly reports via SAS and Excel which indicated the desired output versus targeted output.
• Highlighted operational measures and key performance indicators from marketing reports that allowed the client to make decisions regarding resource allocation, risk assessment.
• Published daily, weekly and monthly dashboards and reports via Outlook and SharePoint, indicating the performance of key metrics.
• Supported the quality management initiative by designing, creating and maintaining multiple data templates using Excel's pivot tables.
• Monitored data analysis on comparative remittance data in order to generate reports and conclusion based on trend analysis.
• Compiled and shared campaign results with senior management and executives for decisions determining risks, funding and opportunities for improvement.
• Created data quality reports to highlight areas of low data quality with the overall goal of improving data quality and integrity across the company and client databases.
• Troubleshooted inconsistencies in weekly campaign results and pinpoint data anomalies & decipher hidden traffic patterns.

Confidential, New York, NY

Business Analyst / Marketing Campaign Analyst

Responsibilities:

• Created Ad hoc analysis to support Confidential - Plenti marketing needs including market analysis, share of wallet analysis, campaign analysis, test analysis etc.
• Managed strategy and ongoing delivery of Plenti’s core member engagement assets including Welcome, Early Engagement Series, and ongoing lifecycle triggers.
• Produced product offer reports including redemption rates and incremental sales vs. control groups.
• Identified and articulated customer patterns in a meaningful way to drive value to Plenti/Wellness+ members.
• Partnered closely with Plenti partners, marketing and technology to personalize the customer experience across multiple channels.
• Managed execution of Marketing Campaigns: Selection, deployment, tracking and reporting.
• Reported and monitored marketing campaign performance.
• Designed and improved predictive models to forecast Plenti Points Issued for Confidential ’s circular offers.
• Maintained coalition between Plenti - Confidential with timely deliverables.
• Assisted compliance team in creating targeting formulas, wireframes and attributes for marketing campaigns.
• Leveraged vital metrics such as CPC, CTR, Open rate, ROI, Bounce rate etc. to derive actionable insights such as analyzing pattern of sales and behavior of different audiences.
• Worked directly with offer marketing teams to establish offers for existing Plenti members and prospects, determine offer dates, bonus/incentives and spend thresholds.
• Analyzed campaigns post-launch to determine incremental revenue generated, new accounts acquired, redemptions, ROI and other metrics to consistently improve campaign execution process.
• Applied A/B and multivariate testing (subject lines, dynamic images, email content, etc.) and data segmentation.
• Lead campaign execution strategy, collateral development, ongoing KPI analysis/reporting, project management, testing, budget management, data segmentation, relationship management, and process improvement.
• Created, maintained and automated timely reports, dashboards and scorecards.
• Applied SAS programming and technical expertise on statistical analysis, methods and techniques.

Confidential, Ewing, NJ

SAS Informatics Analyst

Responsibilities:

• Provided meaningful analytic output that meet the needs of internal and external customers in the areas of Actuarial, Account Reporting, Network Profiling, Disease Management, Decision Support, and Data Management.
• Design, develop and executed SAS Server database queries for the purpose of data quality validation.
• Developed/enhanced production for ad-hoc reporting and analytical processes
• Streamlined existing processes to reduce runtime and complexity.
• Business and technical requirement gathering and maintain working relationship through reporting lifecycle to ensure deliverables consistently meet expectations.
• Designed and implemented complex scripts and macros utilizing the SAS programming language to query large volumes of Health care date.
• Mentored junior programmer/analysts; delegate assignments and support deliverables when needed.
• Lead data hygiene efforts to continually maintain high standards of data integrity.

Confidential, Newark, NJ

Marketing Campaign Analyst

Responsibilities:

• Executed strategy on marketing channels, including social media, Paid Search, website print and Email.
• Analyzed Marketing Database and match it with Prospects Database to plan Marketing strategies.
• Designed, developed and executed SAS Server database queries for the purpose of data quality validation.
• Participated in the design, development and delivery of dashboards and analytics to accurately depict the overall health of marketing campaigns.
• Designed Presentations and reports for VP and senior Management.
• Performed data quality analysis using advanced SAS Enterprise Guide.
• Managed end to end campaign execution for the digital and offline channels.
• Coordinated with external agencies like Acxiom for execution of marketing campaigns.
• Ensured accurate measurement of campaign performance, site traffic, acquisition metrics and channel attribution through continued development and maintenance of best in class data collection strategies across digital assets.
• Used SAS Customer Intelligence studio to build and deploy marketing campaigns.
• Conducted comprehensive analysis and evaluations of business needs and provided analytical support.

Confidential, Buffalo, NY

SAS Modeler/ SQL Modeler, Risk Management

Responsibilities:

• Performed daily weekly and monthly campaigns as per the deliverable schedules.
• Create waterfall reports and analyzing data and creating ad-hoc on deliverables.
• Tracked campaigns by transactions and revenue and run significance test based on the response rate between groups (campaign vs. control)
• Built Channel p model to segment members by their behaviors and provide the marketers intelligence in designing and executing multi-channel campaigns
• Developed SAS Macro programs to create ad-hoc reports. Provide technical support to end users on SAS, SAS Enterprise Miner, and SAS Enterprise Guide.
• Automated the existing audit reviews and production.
• Performed data validation, transformed data from RDBMS oracle to SAS datasets Monitored Operational and Business Metrics and identify the trend, analyze and resolve data errors and inconsistencies.
• Supported the Global Business Development Team to set up the expectations for KPIs, such as member counts and transactions, for new product, and report the actual comparing with the forecast on monthly basis.
• Wrote business summary and present findings based on the analytical results from the reports.
• Developed queries on the existing Teradata, Oracle and SQL server databases to provide ad-hoc reports using SAS/SQL for marketing department use. Coordinate analyses involving customer information, campaign response data, and demographics.
• Created dynamic Macro arrays by SQL and with data step programs.
• Developed repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting.
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.

Confidential, Stillwater, OK

Graduate Teaching Assistant

Responsibilities:

• Graded assignments for marketing and finance students.
• Updated/modified online classroom webpage

Confidential

Research Analyst

Responsibilities:

• Optimized websites on the board by mapping keywords based advertisements.
• Enhanced customer’s portfolio performance by constant research and study of reports.
• Learned new concepts of online advertising like e-commerce, digital advertising, search engine optimization (SEO)
• Strategically analyzed daily customer reports by identifying, summarizing and classifying daily reports.