NARENDRA YADAV

Ph: 973-***-****

Email: acfzm9@r.postjobfree.com

Parsippany, New Jersey-07054

PROFESSIONAL SUMMARY

. More than 12 years of IT industry experience encompassing a wide

range of skill set, roles and industry verticals of which 8+ years

of working on data warehouse environment. Accomplished Data

Warehouse Architecture, Data Modeler and Designer.

. Extensive experience in Data Modeling, Data warehousing, Business &

Data Analysis and documenting business requirements, functional

specifications & technical design .

. Experienced in Project Management and involvement in all phases of

data management life cycle.

. Worked extensively on Erwin in several projects in both OLAP and

OLTP applications.

. Practical understanding of the Data modeling (Dimensional &

Relational) concepts like Star-Schema Modeling, Snowflake Schema

Modeling, Fact and Dimension tables.

. Comprehensive knowledge and experience in process improvement,

normalization/de-normalization, data extraction, data cleansing,

data manipulation.

. Implemented Slowly Changing Dimensions - Type I & II in Dimension

tables as per the requirements.

. Familiarity and experience in the work environment consisting of

Business analysts, Production Support teams, Subject Matter

Experts, Database Administrators and Database developers

. Good understanding of views, Synonyms, Indexes, Joins and

Partitioning.

. Created, documented and maintained logical and physical database

models in compliance with enterprise standards and maintained

corporate metadata definitions for enterprise data stores within a

metadata repository.

. Established and maintained comprehensive data model documentation

including detailed descriptions of business entities, attributes,

and data relationships.

. Developed mapping spreadsheets for (ETL) team with source to target

data mapping with physical naming standards, data types,

volumetric, domain definitions, and corporate meta-data

definitions.

. Experience in Data Analysis, Dimensional Data Modeling, Data

Extraction Transformation & Loading (ETL), Building Cubes, Creating

Meta layer, Data Mining, End User Reporting, Web based Reporting &

Implementation, Creating Test scripts and user signoff documents.

. Experience using Business Objects Administration, Web-Intelligence,

BO Developer Suite using SDK, Application foundation, Broadcast

Agent, Auditor, Web Admin tool, Supervisor, Designer, Web

Intelligence/Info view and Crystal Suite

. Hands on skills in Application Development, Design,

Administration and Implementation using J2EE applications, SAP

Business Objects product suite, Cognos, Informatica,Data stage

and Teradata.

. Have advance UNIX shell scripting knowledge.

. Have advanced SQL skills, including stored procedure creation,

triggers in Oracle and DB2.

. Managed and supervised team of technology advisors both onshore-

offshore and have experience interfacing with a wide range of

technical and non-technical users and senior management through

all phases of technology life cycle.

. Strong multi-tasking abilities; consistently coordinate efforts

with all business arenas, customers, and vendors to ensure

needs and expectations are fulfilled.

. Ability to quickly learn and apply new technologies and

concepts.

. Excellent communication, analytical and problem solving skills.

TECHNICAL SKILLS:

RDBMS: Oracle8i/9i, Oracle10g/11g, DB2 8.x, 9.x,Teradata

Data Modeling Tools: Erwin r7.x,9.5

ETL: UNIX scripts and sql queries based ETL framework,

stored procedures,

User defined database functions, Data Stage

8.x,Informatica Power Center 9.5, Metadata Manager,

Informatica Data Quality (IDQ 9.1), Data Analyzer,

Informatica B2B Data Exchange.

Web/AppServers: Tomcat, WAS (WebSphere Application Server) 4.x, 5.x,

6.x Oracle 9iAs.

J2EE Frameworks: Struts, springs

Languages: Java

O/S: Windows NT/2000 Server, AIX 5.x, Linux

Tools: WSAD (WebSphere application development

environment), JDeveloper,

Rational Software Architectcture, Net Bean, PL SQL

Developer, Toad, DBArtisian, Business Objects XI

R2/R3,Cognos 8.4 &10.1

Processes: Rational Unified Process.

Version Control: CVS, Clear Case, VSS, PVCS.

PROFESSIONAL EXPERIENCE

Client: Prudential Insurance, Roseland, NJ Oct

2012 - Till Date

Role: Data Warehousing / Business Intelligent consultant

Project: IMBI

Team Size: 20

Description: I Involve in Project Planning, Execution and Management and I

am the SME (subject matter expert) for guiding the full lifecycle of IMBI

(Information management and business intelligence) implementation which

includes architecting the solution, analysis and modeling consulting, data

management, data quality and governance and Business Intelligence and

managing offshore and onshore delivery.

Responsibilities:

. Gather and analyze business requirements to identify and understand

source data systems. Perform data analysis and translate business

needs into long-term information architecture solutions. Conduct

data quality analysis to purge systems of old, unused, or duplicate

data.

. Conduct discovery, perform root cause analysis, and make

recommendations for the remediation of data quality issues and help

in identifying new sources of data.

. Work with data owners and department managers and VP's to

contribute to the development of data models and to determine data

rules for aggregation. Also developed the logic/rules for

aggregation for key feeds like Premiums and Claims using stored

procedures.

. Participate in data definition and data management reviews.

. Created the Data Warehouse Data Model to store atomic level data

and the summarized data.

. Performed Dimensional Data modeling and created Star Schema and

Snow Flakes Schema data model to meet the OLAP needs.

. Experience in several facets of MDM implementations including Data

Profiling, metadata acquisition, data Lineage, data migration,

validation, reject processing,quality tolerance levels and pre-

landing processing.

. Widely used Informatica client tools -- Source Analyzer, Warehouse

designer, Mapping designer, Transformation Developer and

Informatica Work Flow Manager.

. Used look up, router, filter, joiner, stored procedure, source

qualifier, aggregator and update strategy transformations

extensively.

. Used workflow manager for session management, database connection

management and scheduling of jobs.

. Assisted the team in the development of design standards and codes

for effective ETL procedure development and implementation.

. Extensive performance tuning by determining bottlenecks at various

points like targets, sources, mappings and sessions.

. Experienced in Cognos 10, 8, ReportNet with Report Studio,

Framework Manager, Query Studio, Analysis Studio, Metric Studio and

Cognos Connection.

. Well-versed in developing reporting applications using Cognos

Business Intelligence components like Report Studio, Framework

Manager, Query Studio, Analysis Studio, Metric Studio and Cognos

Connection.

. Extensively used Framework Manager, Query Studio and Report Studio

for model design, ad-hoc reporting and advanced report authoring.

. Mentored and trained team on Framework Manager, "Report Studio",

"Analysis Studio" and "Query Studio" tools .

. Implemented Security in Cognos Connection by creating User Groups,

Users and assigning privileges to various users for accessing

Reports.

. Create and deliver monthly key analytics and IT metrics reports

which focus on scheduled jobs, data growth and job failures to

senior management.

. Troubleshoot ETL load and extract problems, BI Environment problems

and tune for performance. Diagnose and resolve application

bottlenecks and performance issues. Work on defining and enforcing

coding standards, design styles and best practices.

. Involved in performance tuning and optimization of DataStage

mappings using features like Pipeline and Partition Parallelism and

data/index cache to manage very large volume of data.

. Streamlined routine processes and ensure optimum database

performance in a highly fast-paced environment.

. Worked as an architect to create framework to load all the manual

files in data warehouse.

. Participate in UAT by partnering with the end users.

. Support data warehouse production batch and release management

process.

. Worked on enrollment reporting which focus on voluntary products

for Life, Disability, and Dental.

. Designing a new data mart for Critical Illness product. This will

enhance current group insurance Web Enrollment Application, SPARC

Proposal Process, and CMWS Enrollment process to support the

Critical Illness product.

. Manage onshore/offshore resource allocations, developing plans &

schedules, and managing execution of plan & schedules.

Environment: AIX and Toad for development, AIX for Production, DB2 Database

Server, Oracle11g, Business Objects XI R2/R3,Cognos 8.4/10.1, and Info

sphere Data Architect, Data stage, MS Visio, MS Power Point, UNIX

Client: Prudential Insurance. Roseland, NJ July

2008 - Sep 2012

Role: Sr. Data warehouse consultant

Project: GIDW

Description: As a Sr. Data warehouse consultant I am the SME (subject

matter expert) for guiding the full lifecycle of GIDW (Group Insurance Data

warehouse) implementation which includes data management, data quality and

governance and Business Intelligence.

. Gather and analyze business requirements to identify and understand

source data systems. Perform data analysis and translate business

needs into long-term information architecture solutions. Conduct

data quality analysis to purge systems of old, unused, or duplicate

data.

. Developing architectural and design patterns, considerations,

solution options, and impact using Rational Unified Process and IBM

Unified Method Framework.

. Developed an automated framework that sends alerts, throws

exceptions and validates data uploaded using UNIX scripting and

DB2. This was a manual process before which the users were going

through every quarter, semi-annual and annually.

. Conduct discovery, perform root cause analysis, and make

recommendations for the remediation of data quality issues and help

in identifying new sources of data.

. Worked with Datastage Manager for importing metadata from

repository, new job Categories and creating new data elements.

. Designed and developed ETL processes using DataStage designer to

load data from Oracle, and Flat Files (Fixed Width) to staging

database and from staging to the target Data Warehouse database.

. Used DataStage stages namely Hash file, Sequential file,

Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change

Capture, Funnel, Peek, Row Generator stages in accomplishing the

ETL Coding.

. Developed job sequencer with proper job dependencies, job control

stages, triggers.

. Used QualityStage to ensure consistency, removing data anomalies

and spelling errors of the source information before being

delivered for further processing.

. Excessively used DS Director for monitoring Job logs to resolve

issues.

. Participate in data definition and data management reviews.

. Expertise in Business Objects enterprise Products (Universe

Designer, Desktop Intelligence, Web Intelligence, Info View, CMS,

CMC & CCM) and its deployment.

. Expertise in identification of Business and Data requirements and

converting them into conceptual and logical data models.

. Extensively used various features like Joins, Alias and Contexts in

Universe designer to overcome various traps (Chasm, Fan) and Loops.

. Excellent data-analysis skills and ability to translate

specifications into a working Universe and/or Report.

. Experienced in Training & Supporting end-user reporting needs using

Business Objects.

. Create and deliver monthly key analytics and IT metrics reports

which focus on scheduled jobs, data growth and job failures to

senior management.

. Troubleshoot ETL load and extract problems, BI Environment problems

and tune for performance. Diagnose and resolve application

bottlenecks and performance issues. Work on defining and enforcing

coding standards, design styles and best practices.

. Created DW schema design, streamlined routine processes and ensure

optimum database performance in a highly fast-paced environment.

. Configured and optimize BI Environment, which includes relational

and OLAP layers. Developed semantic layers and metadata

repositories to support reporting.

. Participate in UAT by partnering with the end users.

. Lead a team of technology developers for creation and

implementations of UNIX based ETL architecture using shell

scripting and stored procedures.

. Participate in the release management process by creating install

scripts and guides.

Environment: AIX and Toad for development, AIX for Production, DB2

Database Server, Oracle11g, Business Objects XI R2/R3, and Info sphere Data

Architect, Data stage, MS Visio, MS Power Point, UNIX

Client: IGA, Gurgaon, India Jan 2006 - May

2008

Role: Senior Developer

Project: e-Pricer-CAT

Description: As a module lead of ePricer-CAT (Comparative analysis tool),

responsible for maintaining a warehouse of historical transactions and

supporting data (getting files from users, parse validate and load these

files to database) to support comparative analysis with US xSeries actual

revenue transaction.

Responsibilities:

. Analysis, design, development, and implementation of ePricer-CAT

(Comparative analysis tool) for new implementations and upgrades

for IBM US.

. Providing guidance for the structure, storage and forms in which

data is stored, retrieved, and represented

. Created a parser for exception rules to keep track of data quality

and work with business owners to resolve those issues.

. Troubleshoot any data load, data integrity and schema designing

issues and suggest improvements

. Created conceptual and logical data structures to aid with

visualizing data flow through the system components

. Analyze data streams and feeds and ensure that they meet the

business/data requirements and prevent duplications and

inconsistencies

. Generate reports for users to compare and analyze against

historical data

. Responsible for managing scope, planning, tracking, change control,

aspects of ePricer-CAT module.

. Responsible in making of external design document and internal

design document for ePricer-CAT module.

. Tracking Issue resolution and technical guidance to ePricer

maintenance Team.

. Responsible for effective communication between the CAT team and

the customer. Provide day to day direction to the project team and

regular project status to the customer.

. Establish Quality Procedure for the team and continuously monitor

and audit to ensure team meets quality goals.

Environment: Windows-XP for development, AIX for Production, DB2 Database

Server, WebSphere Application Server, Teradata.

Client: DBS, (Singapore Bank), Singapore. July 2005 -

Dec 2005

Role: Application Programmer

Description: During this span I worked on Security Server System for DBS

(Development Banking of Singapore). Security Server is an in-house Bank

application that authenticates an employee's Host ID with the Mainframe

RACF server. It is widely used by many internal Bank applications to check

if the user of applications is a genuine Bank staff. Furthermore, the

Security Server can be used to register a user's access rights to the

internal Bank applications by specifying his Access Matrix in its database.

Extensible Application Server (EAS) provides Security Server with such

administrative functions to specify this Access Matrix.

Responsibilities:

. Setup the application at IBM onsite.

. Migrating the application from WAS3.5 to WAS 6.0.

. Removed deprecated methods from application

. Tested application on WAS 6.0.

Environment: Windows-XP, WebSphere Application Server 3.5 / 6.0.

Contact this candidate