SUMMARY

• 8+ years of experience in data extraction, transformation, analysis and reporting in banking, insurance and marketing domain using SAS, SQL, R, Tableau, HiveQL and Python.
• Strong experience with databases like Oracle, Teradata, Hive, MS SQL Server, IBM DB2 and MS Access.
• Experience with data visualization tools like Tableau and Microstrategy.
• Base and Advanced SAS certified programmer.
• Experience with Google analytics, A/B testing and IBM Unica for campaign management.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Self starter and an effective team player with strong communication and interpersonal skills.
• Highly Motivated individual with an eagerness to learn new technologies if needed.

TECHNICAL SKILLS

Statistical Tools: SAS EG SAS/SQL, SAS/ODS, SAS/IML, SPSS, SAS Miner, R, Python (Numpy, Pandas)

Data Visualization: Tableau, Matplotlib, ggplot

Operating Systems: Windows, Unix, Mainframe

Databases: Oracle, SQL Server, IBM DB2, Teradata, MS Access, Hive

Certifications: Base Certified SAS Programmer, Advanced Certified SAS Programmer, Intro to Python for Data Science (DataCamp), Intermediate Python for Data Science (DataCamp), Importing Data in Python (DataCamp), Introduction to SQL for Data science (DataCamp), Joins in PostGreSQL (Datacamp)

Marketing Analytics Tools/Techniques: IBM Unica, Google Analytics, A/B testing

PROFESSIONAL EXPERIENCE

Sr. Marketing Data Analyst

Confidential, CA

Responsibilities:

• Provide statistical analysis and reporting for Rate Data Analytics (RDA) team using SAS, SQL, Python, Hive and Tableau.
• Design, develop, deploy and support Tableau dashboards to track high energy usage, gas load, electric load forecasting.
• Develop project plans from KPI design to documenting business requirements to building logic in SAS/Teradata to deployment and validating the dashboards in Tableau.
• Generate data feeds for tableau by developing business logic in Teradata SQL and SAS.
• Participates in and supports quality assurance and testing.
• Analyze web traffic and site behavior using Google analytics and clickstream data for customer and business insights to support business decisions and deliver on improved customer site experience.
• Identify traffic trends, site issues and opportunities for improving site conversion rates using A/B testing.
• Provide insights and recommendations to increase site conversion and drive site improvements
• Monitoring and analyze key components and activity on the site including landing pages, banner tracking and funnel progression.
• Design, administer, and analyze the results of A/B and multivariate tests for micro and macro conversion optimization.
• Identify key needs or gaps and provide suggestion to close gaps and perform Ad - hoc analysis per required.
• Solely responsible for conversion and validation of code from Mainframe SAS to SAS in windows environment and from SAS to Hive to automate reporting and streamline business processes.

Analytic Consultant

Confidential, CA

Responsibilities:

• Provide statistical analysis and reporting for Digital Sales & Marketing Analytics (DSMA) team using SAS, SQL, R, Advanced MS Excel, Tableau and IBM Unica.
• Responsible for analytics and reporting of traditional products (Home equity, Investments, Credit, Deposit, Autoloan, Payroll, Mortgage, Personal lines and loans) reporting at Confidential using SAS, SQL and Tableau.
• Perform A/B testing to compare different versions of a single campaign and choose campaign that performs best.
• Design, build, QC, and execute addressable marketing campaigns to specifications within SLA timeframes using IBM Unica.
• Measure and report performance of all user/customer based marketing campaigns, and assess against goals (LTV, ROI and KPIs).
• Perform high level execution of the end to end campaign process leveraging IBM Unica and Teradata SQL.
• Ensure proper audience selection, test setup, segmentation, and tracking of marketing campaigns.
• Responsible for weekly campaign reporting for email marketing programs.
• Conduct ad-hoc analysis pulling data from multiple sources including historical performance trends / benchmarking.
• Review campaign requests and validate requirements prior to execution.
• Conduct campaign & quality control reviews with business partners.
• Assess sales performance and deliver insightful recommendations to business partners based on trends/patterns in data.

Marketing analyst

Confidential, CA

Responsibilities:

• Providing statistical and quantitative modeling for Marketing and customer insights team, validation and implementation of campaign management gathering business requirements from internal and external sources, understanding business needs and logic and converting business requirements into technical specification using SAS, SQL, Advanced MS Excel and Tableau.
• Consult with different marketing staff to strategize and define marketing campaign requirements and scope.
• Applying tools and techniques (SAS, R) for distilling information to identify actionable information and findings for specific users (e.g., entity disambiguation, data mining, anomaly detection, trend analysis, summarization and abstraction).
• Responsible for end-to-end management of Pay4Performance campaigns, advertising campaign, wellness and social initiative campaigns and Covered California campaign.
• Key activities include campaign design and requirements (Geographic segmentation, Demographic segmentation, Behavioral segmentation and psychographic segmentation), campaign quality assurance (campaign list validation so that final output meets campaign requirements) and finally campaign analysis(provide success metrics, insights and recommendations to optimize campaigns).
• Assessing campaign performance and delivering insightful recommendations to partners by generating analysis reports using Tableau, Microstrategy and MS powerpoint.
• Designed SAS queries to access multiple databases and extract geo-demographic data from customer, transaction, customer value segment, product and customer campaign history tables.

Statistical programmer

Confidential, NJ

Responsibilities:

• Identify and locating relevant information from large data sets using analytic tools or techniques (SQL, SAS, R, SPSS and Excel).
• Create analyze, summarize safety and efficacy data associated with Phase II and Phase III clinical studies as per SAP.
• Review Study protocols, Statistical analysis plans, annotated CRF’s and output specifications.
• Built setup study programs using SQL, SAS and performed statistical analysis of efficacy end points.
• Using data mining tools like SAS to search for data identification, characteristics, trends, or anomalies.
• Extract data from a data warehouse and create ad-hoc reports, tables, and graphs according to business needs.
• Worked on edit check programs to maintain data consistency and data validation.
• Involved in developing, testing, and writing programs, developing models and running reports in SAS ccording to specifications as required.