Madhab Nayak

Senior Manager – Analytics and Information Management

acz3su@r.postjobfree.com, Ph# +1-404-***-****

S U M M A R Y

** ***** ** ***** **** and BI Management projects experience with various domain and global client, and 21 years of overall

Hands on experience of:

Data Architect, Modeling, Profiling, Sourcing, Cleansing, Consolidation, Migration, Purging and Retention Strategy to support Data Integration and Analytical requirements of business groups

Architected a secure Bigdata Analytics environment, which includes Hortonwork Hadoop Ecosystem

Worked on data integration projects with Greenplum/Exadata/Vertica/Oracle/SQL Server/Informatica/Talend/BigQuery env.

Hands on experience of ETL tools/ languages like SQL/PL/SQL/OWB/Informatica/T-SQL/PostgreSQL/Greenplum function/Talend

Good working experience in Data Visualization/Dashboards with Sportfire/MSBI/OBIEE/BOXI/Hyperion/Cognos/WebFocus

Good experience on Data Architecture and Modelling, Data Operations Management, Data Integration and Development Data Operations Management, Data Warehousing and Business Intelligence, Metadata Management and Data Governance

Managed data architecture/modeling services delivery and CoE within IT and business unit projects effectively

Have experience on Initiate/maintain short- and long- term Information Architecture plans consistent with business objectives

Ensured efficient and consistent use of data architecture roadmap to reflect business priorities with best-in-industry standards

Have experience on establishing/tuning methods and procedures for data management by engaging with all key stakeholders

Lead by example demonstrating good work ethics, commitment to excellence and focus on business value and results

Hand on experience with continuous improvement by consistent and efficient use of data asset across the enterprise

Identify, document and socialize solutions patterns and best practice related to use of company's data assets

Articulate value propositions of various data architecture designs, modeling and implementing data standards and processes

Designed solutions for EDW, EDW Integration/Spin-Off, Data Marts, ODS, and Reporting and Visualization

Have worked on multiple performance optimization projects to support users across multiple geographies

Proficient with SDLC, from requirements to post-implementation of large-scale and mission critical applications

Requirement prioritization in coordination with stake holders and delivery of planned deliverables

Planning knowledge transitions within and outside of the team and execute them successfully

Reviews of deliverables to ensure adherence to quality, issue, risk and mitigation to ensure timely delivery

Mentoring new comers on development life cycle, processes and function and technical skills

Experience with data security standards and data governance tools to adhere required controls on per data usage

Advice, Guidance, Direction, and authorization to carry out major plans and procedures to ensure schedule attainment, product development process adherence, and performance and budget targets are met

Worked as Data/BI architect with clients such as Apple, Moto, Agilent, Keysight, FPL, HP, Xerox, Sony, D&B, OA, etc...

Customer Satisfaction, Customer feedback analysis, issue approach/solution and action plan E D U C A T I O N, C E R T I F I C A T I O N & P R O F E S S I O N A L E X P E R I E N C E

M.Sc. (Analytical Chemistry) from Berhampur University

B.Sc. (Physics, Chemistry & Mathematics) from Berhampur University

PG Diploma in Marketing Management IGNOU (New Delhi)

Oracle 10g SQL Expert Certified from Oracle Corporation

• Worked as an Data/ETL, BIDW solution architect and program manager with global clients

• Immigration Status: US Green Card

T E C H N I C A L S K I L L S

Datawarehousing

& ETL

SQL, PL/SQL, Oracle Warehouse Builder 11g Release1 (Warehouse Builder Client and Server, Design and Runtime Repositories, Design Browser and Runtime Audit Browser, Client Version, Integration with Oracle Application Server), ETL, OLAP, OLTP, 3NF, Star Schema, Snowflake Schema, Informatica 9.1

Databases Oracle 11g/10g/9i/8i, Exadata, Greenplum, Vertica, Mongo DB, SQL Server Data Modeling ERWIN 9.5, TOAD Data Modeler, Logical Modeling, Physical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions, 3NF), Entities, Attributes, Cardinality, ER Diagrams.

Environment RHEL 5, UNIX (Sun Solaris, HP-UX, AIX), Windows 2003/2000/XP/98 BiGData Hadoop/Hortonworks, BigFrame, Pig, Hive and R BI Tools

MSBI, OBIEE 10g/11g, Essbase 11, Spotfire 6, Hyperion IR 11, Webfocus 7.6.9, Business Objects 4.0, Cognos 9 and Microstrategy 9.2

PROFESSIONAL PROJECTS

1. AMI DW at FPL

Description

FPL AMI program is to design, develop and implement Greenplum/Big Data database platform solutions. Consolidate daily and historical data from current AMI or DSS Data Warehouse. Enable business analytics from Greenplum data repository; validate business benefits, opportunities and hardening enhancements. Integrated graphical view of AMI meter events, voltage, consumption and load, with breaker operations, trouble tickets, and feeder telemetry at the premise level, customer analytics, Test center analytics.

Role and Responsibilities

Data architecture/modeling services delivery and CoE within IT and business unit projects effectively

Design and develop data architecture for all data warehousing and transaction components

(e.g. data model, tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)

Design of data warehouse, data storage strategy/technique (ODS, EDW, DM, OLAP, etc.)

Create and manage designs including data models, data diagrams, data flows, and corresponding data dictionary documentation

Data quality, data architecture and data management best practices

Design of data warehouse tables and objects, including source to target mappings.

Architecture and Design review, BI/Reporting/Test Architecture

Negotiate with various vendors and stake holders, educate them on business data

Pre and Post-Production Support, Problem Approach and Solution

DLD, Code and Process review with stake holders, etc...

Offshore-Onsite Coordination and Delivery

Managed Technology Stacks:

Operating System(s) RHEL 6, IBM AIX, Windows 2012, Mainframe Database Oracle 11g/12c, Greenplum Appliances, SQL Server ETL tools Informatica 9.1, PL/SQL, SQL Developer/Modeler, BODS BigData Hortonworks Hadoop Ecosystem/Bigframe/Hive, BI Tools MSBI, Cognos, PowerBI

OLTP UIQ, Mainframe, Microsoft Dynamics and SAP ECC Period Aug 2015 – Dec 2016

2. Agilent BI

Description

Agilent Technologies, Inc., is a company that designs and manufactures electronic and bio-analytical measurement instruments and equipment for measurement and evaluation. Agilent Technologies has a stock market capitalization of over 7 billion USD and the company's headquarters are in Santa Clara, California, in the Silicon Valley region. The project is BI support which has various technology stacks of data warehouse and reporting.

Role and Responsibilities

Project and Delivery Management

Architecture, Solutioning and Design

Offshore-Onsite Coordination and Delivery

Resource Allocation, forecasting and Capacity Planning

Effort estimation, resource planning and allocation

Customer Satisfaction and Customer feedback Analysis and Action Plan

Demand forecast, and work stakeholders to determine future requirements

Preparation and presentation of monthly performance metrics

Weekly/Monthly status report (Project/CR/Defect Status): Planned Vs Actual

Coordination with Management, Product Owner, QA and Release teams

Architecture and Design review

BI/Reporting/Test Architecture

Pre and Post-Production Support

Problem Approach and Solution

DLD, Code and Process review with stake holders, etc... Managed Technology Stacks:

Operating System(s) RHEL 4/5/6, IBM AIX, Windows 2008 Database Oracle 11g, Exadata Appliances and SAP BW ETL tools Informatica 9.1, PL/SQL, SQL Developer/Modeler, BODS BI Tools OBIEE 10/11g, Spotfire 6.0, Hyperion IR and Essbase, MSTR and Cognos 9 OLTP Oracle EBS, Siebel CRM and SAP ECC/CRM

Period Apr 2013 – Mar 2015

3. GLS

Description

The objective of this project is to assess and implement the most appropriate solution in order to manage various aspects of clients’ legal portfolio Global Legal Systems. The solution will allow stake holders to directly access and enter information and documents in the System. The activities related to this project are i) establish a new OLTP system ii) consolidate fragmented legacy data and migrate to new OLTP system iii) built new data warehouse and BI platform for enterprise reporting Role and Responsibilities

Product Architecture

Data Sourcing

Data Profiling, Cleansing and Data Modeling

Data Consolidation and Migration

High Level Design Documentation

Data Purging and Retention Strategy

Worked with Business Process Managers and Business Analysts in gathering and understanding requirements

Negotiate with various vendors and stake holders to set common and optimum delivery schedules

Translate user requirements into technical architecture vision and implementation plan

Design and develop the architecture for all data warehousing and transaction components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)

Design of the data warehouse data storage strategy/technique (ODS, EDW, DM, OLAP, etc.)

Design of data warehouse tables, including source to target mappings.

Some ETL development and providing oversight to ETL developers

Problem and issue resolution

Mentoring and developing junior staff

Defining Source/Target Mapping Specification Documents

Implemented Oracle Change Data Capture (CDC) to capture incremental data load from source. Operating System(s) Linux Ubuntu, IBM AIX Unix

Skills SQL, PL/SQL, Oracle, SQL Developer, ERWIN, Business Object, Informatica 9.1 Environment IBM AIX, Unix, Linux, Oracle 11g

Period Dec 2011 – Mar 2013

4. Authenticated Rewards at HP

Description

It’s reward program for ink customer. The objective of this program to increase customer loyalty. Goal Statement: Increase customer loyalty, win switching customers back, and proactive process to manage the impact of customer and serial numbers and their usage thus enabling more accurate reporting.

Role and Responsibilities

Software Architect

Data Sourcing

Data Profiling, Cleansing and Data Modeling

High Level Design Documentation

Data Purging and Retention Strategy

Worked with Business Process Managers and Business Analysts in gathering and understanding requirements

Translate user requirements into technical architecture vision and implementation plan

Design and develop the architecture for all data warehousing components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)

Design of the data warehouse data storage strategy/technique (ODS, EDW, DM, OLAP, etc.)

Design of data warehouse tables, including source to target mappings.

Some ETL development and providing oversight to ETL developers

Problem and issue resolution

Mentoring and developing junior staff

Defining Source/Target Mapping Specification Documents

Implemented Oracle Change Data Capture (CDC) to capture incremental data load from source. Operating System(s) Linux Ubontu and Unix

Skills SQL, PL/SQL, Oracle, MySQL, MongoDB, TOAD, ERWIN, Web Focus Environment Unix, Oracle 10g, Web Focus

Period Jul 2011 – Dec 2011

Contact this candidate