Data Project
Resume:
Email Id: ******@*****.*** Phone
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