Sign in

Marketing Data

Chicago, Illinois, United States
May 30, 2017

Contact this candidate

Azhar Hussain Mohammad

Phone# 773-***-****



•Strong knowledge of writing simple and complex SQL in various databases.

•Interacted with Subject Matter Experts (SMEs), Business Process Owners (BPOs), Project Management Office (PMO), Change Management and Compliance to design Business Blueprints, As-Is and To-Be documents.

•Analyzing, Designing and Unit Testing the Unica Affinium flowchart.

• Developing Unica campaigns using Affinium Unica Campaign development tool.

• Creating complex SQL join queries, transformations of all types as needed to smoothly pass data through ETL maps.

• Possess strong RDBMS development skills in distributed and multi-platform environments.

• Marketing Analyst specializing in multi-channel campaign design, execution and analysis. Passion for supporting innovative and dynamic marketing strategies through data endorsed and customer focused direct communications.

• Strong interpersonal skills working with various vendors and teams

• Worked on data migration projects using various third party tools.

• Possess good problem solving and decision-making skills with an ability to work under pressure in fast paced environment with minimal supervision.


• Programming Languages: C, C++, JAVA, HTML, PL/SQL, Visual Basics

• Tools: Unica, Matlab, MSACCESS, EXCEL.

• Databases: Oracle, SQL Server, HP Vertica

• Operating systems: Windows, UNIX, Linux, MAC.

• Project Documentation: Microsoft Word, MS-Excel, Power Point. Rational Rose. Excellent at documenting business and technical requirements. Proficient at user stories, product backlog, functional/technical specifications, wire frames and scope documents.


•Presently pursuing third Masters in Computer and Information Sciences from Chicago State University, -Chicago, Illinois, US.

•Master of Business Administration from Argosy University Chicago -Downtown, US.

(Year of Passing: 2012)

•Master of Science in Computer Systems and Networking, University of Greenwich, London, U.K. (Year of Passing :2008)

• Bachelor of Engineering in Computer Science, Osmania University, A.P, India.

(Year of Passing :2006)

WORK EXPERIENCE: (July 2013 to March 2017)

Allstate Insurance Company (Head-Quarters)

Northbrook, Illinois - 60062

Database Analyst

Job Responsibilities:

• Campaign coding in Unica Affinium Campaign.

• Creating promotional campaigns using Affinium Unica tool. Designed and developed flowcharts in Unica to send email and mail campaigns. Worked with strategy managers in discussing the campaign approach.

• Performing the role of a SQL Developer and Data analyst with projects related to Allstate Marketing Operations.

•Analyzing, Designing and Unit Testing the Unica Affinium flowchart.

•Inbound and Outbound data testing.

• Provide SQL Reports to marketing strategy managers for marketing opportunity to existing as well as prospect customers.

•Provided Admin support for Unica campaign developers. Created new data sources, managed permissions and roles, cleaned up un-used Unica sessions, created scripts to cleanup Unica temporary tables.

•Involved in developing ETL mappings to load data from Flat files into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.

•Performed tuning of SQL queries for faster extraction of data.

•Developed separate test cases for ETL process and reporting.

•Involved in extensive DATA validation using SQL database queries and back-end testing.

•Developed and Performed execution of Test Scripts manually to verify the expected results.

•Primary analyst for multi-channel Rewards Program Direct Marketing campaign initiatives encompassing campaign design, test and learn strategies, reporting and analysis.

•Created Requirement Traceability Matrix for various projects.

•Performing data mappings between source systems and warehouse components

•Used TOAD & SQL Navigator GUI tools for Querying Database.

•Documented and reported various bugs during Manual Testing.

•Validated various functionalities in reports like Formulas & Calculations, Sorts, drop down list, Breaks and Prompts.

•Worked with Summary and detailed reports for Daily, Monthly reports.

•Analyzed the systems, met with end users and business users to define the requirements.

•Created complex join queries, transformations of all types as needed to smoothly pass data through ETL maps.

•Design and development of PL/SQL Stored Procedures using dynamic SQL for checking existence of partitions and creating them with appropriate values in the case of their absence.

•Created Report Templates for consistency in the look and feel of the reports.

•Worked with Unica Optimize to apply priority rules in campaigns as per marketing managers strategy.

Environment: Oracle 11g, SQL*Plus, Unica 8.2/9.1, UNIX, Windows XP

Contact this candidate