Post Job Free

Resume

Sign in

Data Project

Location:
Farmington Hills, MI, 48335
Posted:
August 18, 2013

Contact this candidate

Resume:

Email Id: ab40r4@r.postjobfree.com Phone

Number: *** -***- 7608

Summary

John Daniel has 6+ years of professional career of which about

5+ years of experience in IT - Data ware Housing and Business Intelligence.

Part of development team and worked extensively in IBM Info Sphere Data

Stage tool and delivered multiple data warehousing projects. He has worked

primarily in the domain of Banking and Finance, Services. In the course of

his experience he has been interacting with the business group, analyst,

and data modelling team & user groups and is aware of the methodology and

the practices involved in the same.

He has expertise in data warehousing concepts, ETL programming using IBM

DataStage Enterprise edition, Parallel jobs, Job Sequencers and other data

warehouse lifecycle tasks such as data analysis, transforming,

debugging/testing, and data loading across target systems. He also has

experience in Business Objects, Remedy, Autosys, Informatica, Siperian MDM

tools.

He has also strong interpersonal, problem solving & team skills, quick

learner, able to meet

deadlines, ability to interact with people at various levels.

He has worked on projects for clients such as TIAA CREF, Novo Nordisk,

General Motors, Citi Bank In his last assignment.

Skills SUMMARY

. Ability to interact with different teams, project execution

capabilities.

. Effective task tracking, execution and reporting skills.

. Ability to meet timelines with ease.

. Strong analysis skills to resolve critical issues

. Effective communication skills and good team coordination.

. Qualitative task delivery under stringent timelines and high pressure.

. Good verbal and written skills, Good ability of expression with

patience.

. Good knowledge of data warehousing concepts.

. Managing reports, analysis and decision-making for a change request.

Work experience

. Working as a Analyst in Cognizant Technology Services from Jan 2010 to

Till Date

. Worked as a Software Engineer in Mphasis an EDS Company from May 2006

to Sep 2009

Certification

. Certified in Information Technology Infrastructure library (ITIL V3F)

. Certified in IBM Web sphere Data Stage Enterprise

education SUMMARY

M C A from Andhra University, Andhra Pradesh, Apr 2006

KEY ROLES AND RESPONSIBILITIES

. Responsible for the project delivery.

. Develop and enhance processes to meet the DW & BI and client

Standards.

. Interacting with the business group, business analyst, data modeling

team and user groups to gather and understand requirements.

. Design (High level and Detail level) the Project as per the

requirement.

. Develop the Project as per the requirements and prepare test cases for

it.

. Unit test the project as per the requirement.

. Co-ordinate with QA team for the Testing in SIT and UAT.

. Issue analysis and bug fix in QA phase.

. Post support after go live of Project.

. Prepare Documents to comply different phase of SDLC.

Project SUMMARY

Project Name - TIAA -CREF - Informatica2Data Stage conversion

Duration - May 2012 - Till Date

Environment - Info Sphere Data Stage, Unix, Autosys, Oracle

10g

Role - ETL / Autosys Developer

Informatica2Data Stage conversion project has dead line to deliver on time

basis in term of bundles

All Informatica work flows and mapping needs to be converted to Data Stage

jobs and sequence jobs

We have altogether 34 to 40 work flows and 70 to 85 jobs to convert from

Informatica to Data Stage

Some are from Database to Data base and some are from Database to file,

file to Database, Data base to xml files..etc. few jobs has Unix scripts to

run to handle different file formats. All converted jobs are scheduled by

Autosys tool with different calendar events to support the TIAA business

used different approaches are used to reduce the run time of the jobs

Roles and Responsibilities:

. Responsible for the assigned tasks and to coordinate with different

teams to get the inflow and outflow of data setup

. Single point of contact for the client from the development team.

. Discussions with Business and Functional users to get the details

required for the development and enhancement tasks.

. Implement various Business Rules in line with the requirements.

. Implementation planning and successful deployment of the developed

code in production environment

. Assign the issue tickets and Tasks to the team members

. Provide post implementation support after go live.

. Create learning plan and mentor new and existing team members

. Attending status meetings with clients

Project Name - TIAA -CREF - SEC17a3 (Security Exchange

Scheme)

Duration - September 2011 - May 2012

Environment - Unix, Info Sphere Info Sphere Data Stage,

Autosys

Role - ETL / Autosys Developer

This project is aimed to fulfill the regulatory retention rules for storing

customer complaints and communications in a WORM storage. After

implementing this system, users will be able to search and verify customer

complaints and communications in Mobius

In 4Q 2010, in response to an upcoming FINRA audit, a consultant retained

to evaluate TIAA's compliance with SEC17a3-4 data retention requirements

produced a spreadsheet indicating that data in some applications, including

those containing customer complains and communications was not being stored

according to regulatory retention rules. Additionally, it was found that

TIAA must be compliant with SEC17a4, requiring third party access to

electronic storage media containing data subject to SEC17a3-4 rules. This

project is an attempt to address this concern by providing data in a

repository, satisfying retention rules and third party access requirements

Roles and Responsibilities:

. Responsible for Extracting, Transforming and Loading Data from Flat

files and oracle files and placing it into Data warehouse.

. Working on Data stage Designer tools- for Creating Jobs, Shared

Containers and Job Sequencer and Compile the Job.

. Studying the Existing Source Databases. Involved in interacting with

decision makers or analyzing their business plans.

. Analyzed the Sources, Targets, Transformed the Data, Mapped the Data,

and Loading the Data into the Targets using Data stage.

. Designed Data Stage ETL jobs for extracting data from heterogeneous

source systems, transform and finally load into the Data Warehouses.

. Involved in ETL Processes to load data from Flat file, Oracle, RDBMS

into target Oracle, RDBMS databases by applying business logic on

transformation mapping for inserting and updating records when loaded.

Project Name - Novo Nordisk - PDR ETL and VB .Net Support

Duration - January 2010 - September 2011

Environment - Unix, Siperian MDM, DataStage, Oracle 10g

Role - ETL Developer

Currently, Managed Care Sales Operations manually updates the Novo Managed

Care (NMC) custom hierarchies to maintain synchronicity with the Managed

Care Workbook during each POA. The custom hierarchies (in the form of a

file) are then processed through MDM and loaded into Phoenix Data Warehouse

where they are used for analytics.

To avoid the manual intervention and to be able to have access to up-to-

date analytics, the NMC file is required to be in synch on a monthly basis

with the Managed Care (MC) Workbook. To accomplish this, MDM will

implement a set of Extract, Transform, and Load (ETL) mappings and custom

procedures that resolve any discrepancies pertaining to plan ADDs, CHANGEs,

and DELETEs by updating the NMC file data with the new plans for each

monthly load.

Roles and Responsibilities:

. Develop Data Stage jobs using existing framework.

. Develop UNIX shell scripts that would run the above mentioned

DataStage jobs.

. Develop and schedule the Autosys jobs to call the UNIX scripts to run

in the desired manner.

. Actively participate in thorough unit testing and coordinate with the

testing team for System Integration Testing.

. Implementation planning and successful deployment of the developed

code in production environment.

. Weekly and monthly status reports to the client.

. Mentor the less experience team members

Project Name - GM - Onstar- Reporting Data Store

Duration - March 2008 - Till Date

Environment - Unix, Cognos8.2, DataStage 7.5.3, Oracle 9i

Role - ETL Developer

ReDS (Reporting and Enterprise Decision Support) is OnStar's analytical

reporting environment. The data in ReDS is refreshed during a batch cycle

overnight updating ReDS with yesterday's operational data. ReDS contains

historical data that is kept based on corporate approved data retention

rules. Neither real time or near real time data is available in ReDS.

ReDS is not intended to be used for Operational Reporting or any

Operational Processes. ReDS is normally available for reporting from

approximately 8:00 am until 11:00 pm Eastern Standard Time. ReDS consists

of Oracle Databases, IBM's Data Stage Tool to load data into ReDS and

Cognos 8.2 to report on data in ReDS.

Roles and Responsibilities:

. Monitoring the ReDS application production cycle 24x7 processes.

. Analyze the production issues regularly and bug fixing.

. Resolving the production issues within the time period.

. Simultaneously working on change requests.

. Designing the jobs based on the business requirements

. Developing the jobs.

. Perform unit testing on the designed jobs and functional testing.

. Deploying the jobs in production environment at appropriate time

interval.

Project Name - GM - WWP- MaRS

Duration - September 2007 - March 2008

Environment - Unix, Cognos7.3, DataStage 7.5.1A, Oracle 9i

Role - ETL Developer

GM has been investigating solutions to provide comprehensive business

information services to WWP Executives, Managers and individuals, since at

least 1997.

The GM Worldwide Purchasing Metrics and Reporting Project (WWP MARS)

provides web-delivered, self-service business information to the broad GM

Worldwide Purchasing organization, worldwide, related to the procurement of

direct material, in the form of on-demand information. The business

information must be consistent, complete, accurate, up-to-date and

verifiable.

Roles and Responsibilities:

. Responsible for Extracting, Transforming and Loading Data from Flat

files and Oracle files and placing it into Data warehouse.

. Working on Data stage Designer tools- for Creating Jobs, Shared

Containers and Job Sequencer and Compile the Job.

. Studying the Existing Source Databases. Involved in interacting with

decision makers or analyzing their business plans.

. Analyzed the Sources, Targets, Transformed the Data, Mapped the Data,

and Loading the Data into the Targets using Data stage.

. Designed Data Stage ETL jobs for extracting data from heterogeneous

source systems, transform and finally load into the Data Warehouses.

. Involved in ETL Processes to load data from Flat file, Oracle, RDBMS

into target Oracle, RDBMS databases by applying business logic on

transformation mapping for inserting and updating records when loaded.

Project Name - Business Data Unit - BDU

Duration - May 2006 - August 2007

Environment - Action Request System 6.3, Oracle 9i

Role - Remedy Developer

BDU is a team who bids for the projects. BDU team is looking at an End-to-

End implementation of the Remedy Helpdesk Suite of products to track their

Bidding data and Bidding related Queries. This Project involved the

installation, configuration, development and customization of the Remedy

Helpdesk Application. A web interface was provided as requested by the

client in order to enable the end users to raise a request for solution of

their queries.

Roles and Responsibilities:

. Analyzing the business scenario based on the requirement

. Functional & Technical understanding of the requirement

. Installation, Configuration and Implementation of the Remedy Helpdesk

Suite

. Creation of various Workflow components like Forms, Active links,

Filters, Escalations, Menus

. Unit testing of designed forms

. Manage AR System licenses

. Create AR System reports using Remedy User



Contact this candidate