Manager Data

Nafis Zafar

Cell Phone: 347-***-****

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

Linked In: http://www.linkedin.com/pub/nafis-zafar/b/149/89b

Professional Summary

Fifteen years of experience in Data Reporting, Data Analysis, Database management, Reporting Project Management and Data Warehouse Operations

Work directly with SME and Project stakeholders to understand strategic and tactical goals and translate into effective Reporting platforms

Strong and effective communication with other business groups to ensure project accuracy and timely delivering of each component

Excellent knowledge of RDBMS, SDLC, COGNOS, Power BI, tableau, SSIS, Data Manger (ETL tools)

Involved in multiple full Project Life Cycles and timely deliveries

Support the development of the overall ETL layer of our enterprise data warehouse and business intelligence initiatives (Cognos)

Dynamic data query, reporting and rational business decision experience using SQL, COGNOS, MS EXCEL (VOOLKS), pivot tables and ACCESS

Hands on experience in documenting and managing SOPs in SharePoint

Strong knowledge of designing process flows in VISIO

Strong Client management and data trouble-shooting skills

Strong understanding of client-server architecture

Superb skills in end user training and preparing training documentations

Excellent multitasking skills for handling multiple demanding projects and meeting stiff deadlines

Working knowledge of ISO policies and OSHA

Certifications in PCI DSS compliance

Superb interpersonal skills to effective communication and get the job done attitude

Knowledge of GAAP principals and SOX compliancy

Technical Skills

Programming Languages: T-SQL, C++, Python, Knowledge of JAVA.

ETL Tools: SSIS, Cognos Data Manager

Databases: SQL Server Management Studio v.14, Access

Reporting Tools: Cognos Report Studio, Framework Manager, Microsoft Power BI, Crystal Reports (Business Objects)

Web Dev. Tools: HTML, JavaScript

General: MS EXCEL, MS PowerPoint, MS Project, MS Word, VISIO, Photoshop, QuickBooks

Tracking Tool: Clear Quest, Smart Bear, Service Now

Content Mgmt. Tool: SharePoint

CRM Tool: Sage Sales Logix (Web, Mobile)

Mapping Tool: MS Map Point

Professional Experience

Nestle - Gerber Life, White Plains, NY (March 2013 – Present)

Senior BI and Data Warehouse Analyst

The Gerber Life Insurance provides the most innovative and most suitable children’s insurance and college plans and the top provider in this category. The data warehousing team provides crucial support to entire company in terms of creating data feeds, maintaining data warehouse, building and planning reports, metrics, dashboards, scorecards, and helping them make most accurate business decisions. I provide valuable support to the team by maintaining and enhancing creating reports and dashboards in a project management approach. My strong understanding of business needs and solid relationship with my stakeholders is something I take pride in.

Responsibilities:

Ensure daily operations of entire Data Warehouse processes and manage various Reporting projects

Transform various data trends to useful customer reporting and dashboards to help make meaningful business decisions

Perform various data analysis for multiple departments to ensure accuracy of business data

Use of powerful visualizations and data charts for management to clearly represent data

Collaborate with multiple IT teams and SMEs to understand technical data and translate to meaningful business data for reporting use and make rational business decisions

Develop and Cognos reports using Report Studio in Cognos 10.2 and 11.1.5 Suite using advanced features like conditional formatting, drill-thru, advanced prompting, drill up/down, advanced filters, usage of charts, bursting reports, complex data expressions, etc.

Involved in planning and implementing Dashboards (via Business Insight) for our Marketing team in order to get a superior view of daily stance of business transactions

Created complex T-SQL queries to select data from multiple source systems for ETL tools

Daily monitoring ETL process and enhancements of data feeds, looking for data issues and correcting them

Created ETL dimension and fact data builds from multiple source system data for Data Warehouse team to feed into reporting tools

Daily monitoring of Cognos Report schedules and fix any failures and errors

Cognos Administration and user access control, license management, audit license usage and audit report usage

Develop Cognos Packages in Framework Manager for new requirements and enhancements of existing packages

Use of Service Now tool for maintaining and managing IT change requests

Edit governor setting of packages, finding report dependencies of packages and creating a master manual of packages

Initiative in research and installation of third-party tool like MOTIO Pi and implement superior practice in Cognos Administration thru updating and validating packages and reports, finding and documenting report dependencies, etc.

Use of Content Administration to export/import packages and reports from test environment to Production environment

Maintain and update a list of LDAP and Cognos roles and group and licenses in Cognos Security

Update Data Source connections and test them while servers are upgraded

Lead role in building Audit reports to monitor overall BI reports usage and user login/logout information

Superior project planning to deliver compliance projects on time so business can always stay compliant with state and federal regulations

Initiative in maintaining reports folder structure and reports description and tool tips so that reports can be easily identified by business user and duplication can be avoided

Use of SmartBear (ticketing and tracking tool) to enter and update Project Requests and document all progress relating to a project delivery

Strong relationship with business users, other team members, affiliates of business, vendors, and 3rd party service providers to ensure clear communication and accuracy of projects

Tools used: Cognos Report Studio11.1.6, 10.4, IBM Cognos Framework Manager, IBM Data Manager, SSIS, Microsoft Power BI, Tableau

Proficient in: T-SQL, V-LookUps, Pivot tables, Data Analysis, Data querying, DDL and DML statements.

Zwilling J.A Henckels USA, Hawthorne, NY (December 2008- March 2013)

Business Intelligence Project Manager (Business Applications)

Zwilling J.A Henckels is the leader in quality cutlery, cookware, and flatware products. The US headquarter in Hawthorne is the hub of American sales, marketing, and distribution of Zwilling products. The IT team provides strong support to the sales team, marketing team, and warehouse by creating dynamic business tools and also helps customer service and upper management by providing valuable information which is the core of company’s success.

Responsibilities:

BI (Business Intelligence) Project:

Developed the Business Intelligence (Cognos 8.2) reporting portals, reports, dashboards, and analysis for our entire sales force with full scale SDLC approach

Worked with our business partners and internal users to identifying bugs in data marts and measure definitions to ensure data accuracy

Implemented cube roles in analysis services to ensure data level security among users

In depth knowledge report studio, analysis studio, Cognos Administration, Performance, Permissions and Security

Used Framework Manager to create new data objects and models

Proficient with drill through reports to make reports more dynamic and analytical

CRM (SalesLogix) Project:

Led the full life cycle of Sage Sales Logix project

Met with end users and outside sales reps to obtain business requirements and understood the business needs and their day-to-day business steps

Ensured a perfect harmony between technical feasibility and business case design and connected the dots between out of the box application and our business requirements

Worked rigorously with Programming teams to ensure front end design and back end database setup

Worked with a deadline to design, test, and roll out of the CRM tool

Responsible for reporting design in Crystal Reports (XI, release 2)

Provided valuable data input to management to help business decision

Provided superb End user training and documentation

Also

Responsible for special sales reporting and other ad-hoc reporting for upper management

Superb knowledge in excel using V-lookups and other advanced formulas to create analysis

Helped the merchandising team in creating sales territories using MS Map Point

Implemented the mobile version the CRM tool (Sales Logix)

Responsible for test case design, project planning, oversee development, roll out, maintenance and reporting of Sales Logix Mobile

Affinion Group, Norwalk, CT (August 2006 – October 2008)

Membership Operations Manager

Affinion Group is one of the leaders in providing innovative marketing solutions to fortune 100 companies. It provides various membership products, loyalty services, and insurance.

Responsibilities:

Responsible for carrying out all aspect of operational facets for my assigned accounts in membership operations team

Involved in full Project Life Cycle of ‘Price point increase Project’ with Project management approach

Efficient handling and tracking of operational projects using MS Project

Responsible for root cause analysis, data analysis and rational business decision process with extensive use of Excel pivot tables, macros, and Access data mapping

Expertise in account management by providing day to day analysis of membership status, join analysis, cancel reason analysis using SQL data queries

Excellence in business reporting using Pie charts and graphs, pivot tables off excel data

Effective use of financial applications (FTC) and analysis of financial transactions

Translated BRD into fully scalable technical designs to assist IT development team and track progress and provide guidance via Clear Quest tracking tool

Worked with billing operations and ensured billings accuracy for each client with extensive use of BRIO reports, COGNOS queries, and ACH rules and regulations

Responsible for setting up and update client profiles

Knowledge of data warehouse including data marts methodologies (master data, metadata) as well as extensive knowledge of OLAP technologies (Business Intelligence Cognos 8.2)

Supported IT team with the ETL layer of the data warehouse

In depth knowledge of client-server technology and effective data transfers and FTP-ing important data and CSV files in network areas

Created monthly and annual billing statistics report to show client billing success rates using COGNOS Reporting Tools

Worked with BDCS team and provided valuable analysis on setting up proper marketing channels and fulfillment channels

Organized meetings with IT team and Upper management to provide client analysis, current and ongoing issues and proper recommendations with the use of ACCESS Mops Deck Reporting

Worked with BA team to reengineer existing enrollment process

Created end user training materials and provided training on new processes and special projects using PowerPoint and VISIO flowchart

IBM, Poughkeepsie, NY (Jan 2005 – Aug 2006)

IT Systems Analyst, BAT Integration

BAT (Bond Assembly and Testing) is a bonding and testing facility of microchips for supercomputers. This facility in New York is responsible for almost 35% of the microchip testing.

Responsibilities:

Interacted with Users, Developers, and Project Manager to understand the business process, identify gaps and convert them to Functional Requirements

Conducted meetings with Subject Matter Experts to understand and document the various Business Process Flows

Created System Architecture and Process Flow diagrams using MS Visio to define the system functionalities and manual processes

Created Business Requirement Documents and Functional Specification Documents

Involved in creating the User Acceptance Test (UAT) plan and test cases with the testing team, and also verifying and validating the test results

Wrote SQL Queries to retrieve data from SQL Server

Used MS Project for managing schedules and resource management

Worked extensively on Gap Analysis, Current State and Future State Analysis, as well as Problem Solving on a daily basis

Education, Certifications and Trainings

Pace University, BS in Computer Science (Dec 2003)

Six Sigma; 2008; Affinion Group, CT

COGNOS reporting tools; 2007; Affinion Group, CT

Training in Operations, Products, Managerial communications; 2006; Affinion Group, CT

Seminar in SOX compliancy; 2006; Affinion Group, CT

Training in project management; 2004; IBM, NY

BRIO workshop, 2005; IBM, Poughkeepsie, NY

Cognos Report Studio (10.1) Nestle 2013, White Plains NY

Cognos Data Manager (10.1) Nestle 2014, White Plains NY

Cognos Framework Manager (10.1) Nestle 2013, White Plains NY

Cognos Metric Designer (10.1) Nestle 2013, White Plains NY

Writing queries using T-SQL in SQL Server 2015, Nestle 2014, Fremont, MI

Python Certification, Coursera, University of Michigan, 2019

Contact this candidate