SUMMARY:

• 10+ years of experience in data extraction, data quality/cleansing, transformation, analysis and reporting in finance, marketing and oil/gas sectors using SAS, SQL(Teradata, Oracle, Hive), Tableau and Python.
• Strong experience with databases like Oracle, Teradata, MS SQL Server, IBM DB2 and MS Access.
• Experience with data visualization tools like Tableau and Microstrategy.
• Experience with Marketing analytics tools like Google analytics and campaign management tool like IBM Unica.
• 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 EXPERTISE:

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

Data Visualization: Tableau, Matplotlib, ggplot

Operating Systems: Windows, Unix, Mainframe

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

Marketing Analytics Tools: IBM Unica, Google Analytics

PROFESSIONAL EXPERIENCE:

Sr. Analytics Consultant

Confidential, CA

Responsibilities:

• Provide statistical analysis and reporting for Rate Data Analytics (RDA) team using SAS, SQL (Teradata, Oracle, Hive) Python 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 or 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.
• 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 (Teradata, Oracle) Advanced MS Excel, VBA, Tableau, Python 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 R.
• 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.

Data Analyst/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 (Teradata, Oracle), Tableau and IBM Unica.
• Consult with different marketing staff to strategize and define marketing campaign requirements and scope.
• Applying tools and techniques (SAS, R, SPSS, Excel, Python) for distilling information to identify actionable information and findings for specific users ( Confidential .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.

Marketing Analyst

Confidential, IL

Responsibilities:

• Design, develop and produce reports that connect quantitative data to insights that drive and change business using SAS, SQL (Oracle) and Google analytics.
• Test, optimize, scale, and track numerous acquisition marketing channels including, but not limited to: Paid Search, Paid Social, Display, and Affiliates.
• Develop, implement and maintain customer acquisition efforts across multiple digital channels.
• Optimize existing digital channels and test new channels to drive new customer growth.
• Optimize existing digital channels and test new channels for re-marketing to current customers, as well as site users that browse.
• Create descriptive, diagnostic and predictive analytics & reporting solutions
• Identify and recommend areas for growth, including via organic search, display, retargeting or other virtuous cyclical growth loops.
• Communicate issues related to data quality with both internal and external clients and resolve them within designated timeframe.
• Perform custom analysis, reporting, and multiple ad hoc queries as needed.
• Involved in discussions with business users and data architects to define metadata for tables to perform ETL process.

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 (R, 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.