Marketing Data

Azhar Hussain Mohammad

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

Email: *********@*****.**.**

PROFESSIONAL PROFILE:

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

TECHNICAL SKILLS:

• Programming Languages: C, C++, JAVA, HTML, SAS, PL/SQL.

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

EDUCATIONAL QUALIFICATIONS:

•Master in Computer and Information Sciences from Chicago State University, -Chicago, Illinois, US. (Year of Passing: 2017)

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

CVS Caremark

Northbrook, Illinois - 60062

(September-2018 to November-2018)

Business Analyst:

Job Responsibilities:

• Responsible for performing database list pulls for strategic initiatives to support communications to PBM members primarily relating to formulary and benefit plan designs.

• Execute structured SAS-SQL Teradata code to synthesize large amounts of relational data to optimize complex member communications products to key audiences.

• Perform quality assurance on list pulls.

•Involved in the development of Mail order system associated to this PBM application.

•Attention to detail and the ability to manage multiple projects simultaneously, adjusting priorities as needed and meeting deadlines.

• Involved in various complex custom client requirements for new capabilities and product enhancements to compete in the marketplace and will be critical to retention and new business.

• Responsible in gathering the requirements for Client front end applications, Customer services applications and also on custom reports posted to Client websites.

• Responsible for managing the change controls, worked closely with development and testing teams to estimate the impact within a strict delivery dates..

• Helped integrate corresponding module into the system using Pharmacy Benefits Management (PBM)

• Strong understanding about user interface (UI) and user experience (UX) design principles and users centered methodology.

• Research and resolve complex issues relating to benefit information, claims adjudication, eligibility verification, prior authorization and other Pharmacy Benefits Management (PBM) processes.

relationship between related requirements and maintaining version control.

• Involved in different testing stages of the product through unit testing, system integration testing and UAT testing.

• Involved in the development of Mail order system associated to this PBM application.

•Managed changing requirements which included establishing a baseline, keeping track of the history, determining dependencies that are important to trace, tracing.

Walgreens

Deerfield, Illinois - 60015

(April 2018 to July 2018)

Business Analyst:

Job Responsibilities:

•Supporting Rite Aid Acquisition Process

•

•Documenting business requirements, including managing open issues and bringing unresolved

•issues to conclusion

•

•Consulting with various business and IT partners to understand business requirements and intent

as well as system capabilities and limitations

•

•Performing as a liaison between HR, IT and various business functions

•

•Ability to identify processes, functions, and procedures requiring improvement,

then develop and execute appropriate solutions.

•

•Serve as resource to testing and user support teams on expected system behavior

•

•Collaborate with training team for knowledge transfer

•

•Take initiative to learn existing system capabilities and grow knowledge based

on complex HR Systems infrastructure and downstream systems dependencies

•Ability to successfully balance deadlines, projects, and day to day responsibilities

•Be inquisitive and ask thoughtful questions Knowledge, Skills and Ability

•

•environment

•Experience supporting full software development lifecycle

• SDLC (business process, requirements, design, development, testing, deployment, training)

•Capable of successfully multi-tasking while working independently or within a group environment

•Provided review and validation oversight of data related to target entity prior to formal

release of the data into the Company’s HR and payroll systems.

•Accessed and maintained the confidential information associated with HR data and mergers

and acquisitions activities.

•With its newly-expanded geographical footprint optimization especially on the East coast,

helping Walgreens to prioritize grocery, convenience, and beauty tips for the urban shopper.

•Pulling up the files from EnvisionRX site and transforming the data and posting on the shared

drives and on the Optum Site.

•Coordinating with all the Recruiters from eleven regions to gather the information for all the

Footprint Optimization process employees and Store Conversion employees.

•Creating a file for the Promotion-Demotion employees along with their new rate of pay/salaries.

•

CVS Caremark

Northbrook, Illinois - 60062

(September 2017 to December 2017)

Business Analyst:

Job Responsibilities:

• Involved in the development of Mail order system associated to this PBM application.

• Involved in various complex custom client requirements for new capabilities and product enhancements to compete in the marketplace and will be critical to retention and new business.

• Responsible in gathering the requirements for Client front end applications, Customer services applications and also on custom reports posted to Client websites.

• Responsible for managing the change controls, worked closely with development and testing teams to estimate the impact within a strict delivery dates..

• Helped integrate corresponding module into the system using Pharmacy Benefits Management (PBM)

• Strong understanding about user interface (UI) and user experience (UX) design principles and users centered methodology.

• Research and resolve complex issues relating to benefit information, claims adjudication, eligibility verification, prior authorization and other Pharmacy Benefits Management (PBM) processes.

• Managed changing requirements which included establishing a baseline, keeping track of the history, determining dependencies that are important to trace, tracing.relationship between related requirements and maintaining version control.

• Involved in different testing stages of the product through unit testing, system integration testing and UAT testing.

• Involved in the development of Mail order system associated to this PBM application.

Allstate Insurance Company (Head-Quarters)

Northbrook, Illinois - 60062

(July 2013 to March 2017)

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

•Involved in discussions with Project Managers on disputing variances, such as comparing the lead counts from the present quarter campaign counts to the previous quarters campaign counts and deciding if it is to be delivered or not.

•Understanding the concept of sales reporting by finding out with Revenue Department if the most recent campaign did excellent, good, satisfactory or showed no improvement in the lead count.

•Forecasting of customer leads and preventing it from being deployed which will eventually result in no profit, for example trying to generate a Motorcycle Cross Sell campaign in winter time in Eastern Coast Area when it is predicted to be a snowy season.

•Encouraging customers to take a policy from us by giving them a good discount/rebate offer when they bundle up a new policy with the existing old policy.

•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