Data Project
Resume:
CHITTARANJAN A PRADHAN
**********@*****.***
PROFESSIONAL SUMMARY:
Having 7+ years of continuous IT experience in Design and Development of management information System for Various Application
Good knowledge in Data Warehousing concepts.
Experience in handling all the client and server components, Parallel jobs, built-in stages.
Skilled in defining and implementing the various components of a data warehouse such as Operational source systems, Data staging, Star Schema and Snowflake Schema.
Extensively used different processing stages like: Transformer, Aggregator, Join, Look-up, Merge, Copy etc.
Worked on Quality Centre, Control-M, and MSTFS.
Good knowledge on HP Vertica Projection, Segmentation and the Data store Model, Vertica Architecture.
Implemented performance tuning logic on sources, mappings and targets.
Good knowledge on HP Vertica Projection, Segmentation and the Data store Model.
Knowledge on HP Vertica Bulk Loading of data with COPY command.
Familiarity in incorporation of transformation logic to move data from various data sources like Oracle,
DB2 and Flat Files to Target Teradata, DB2,HP Vertica and Oracle database.
Good knowledge in UNIX commands and Shell Scripting
Diverse background with fast learning skills and creative analytical abilities with good communication and technical skills.
EXPERIENCE SUMMARY:
Working as SSE at Tech Mahindra, Bangalore (Oct 2010 Till Date)
Worked as a SE in IBM India Pvt Ltd, Bangalore (Oct 2008 Oct 2010)
ONSITE EXPERIENCE
Worked as Senior ETL Developer for 1 year at Canada client (ICBC) location on Data
Warehousing Technologies, Concentrating on Data stage, DB2 and Vertica. Involved in
Developing Data Stage job and Sequencers and root cause analysis of defects. Expertise in
Analysis and Resolution of production issues and prepared release note and prepared technical
Specification Document.
TECHNICAL SKILLS:
ETL Tools : Data Stage Parallel Extender (PX)
Operating Systems: Windows XP, UNIX
Scheduling Tool : Control - M
Databases : Oracle 9i, DB2, Teradata, HP Vertica
EDUCATION:
MCA from BPUT University, Orissa.
PROJECT DETAILS:
Project#1
Project Name: INFO R1
Client: ICBC (Vancouver, BC)
Role: Design & Developer
Tools Used: Data stage 9.1
Team Size: 10
Project Description
ICBC is interested in being able to have a comprehensive view of their clients in order to provide cost effective service and maintain leadership in the BC Insurance industry.
To achieve this ICBC is establishing an Enterprise Data Warehouse (EDW), analytical reporting, and data conversion of existing EDW/legacy information.
The initial focus is on Claims related analytics and reporting requirements, with Claims personnel being prime users, along with finance, actuarial, and Road Safety teams.
Responsibilities
Involved in understanding Technical Spec Doc and Handling CR’s.
Transform the data based on business requirement and Mapping sheets.
Developed Job to load data to Staging area using various stages.
Deliver the technical specification & code along with release note, UTC (Unit Test Cases) & Smoke Test documents.
Directly deliver the code to testing team for testing with release note.
Worked on defect fixing during system and integration testing.
Loading the report sql’s into the Vertica database so as the report goes faster for the business.
Implement some projection based on the requirement of the business so as to run the reports on a faster way.
Loads the larger files into staging with the help of bulk operation in Vertica database.
Environment: Data Stage 9.1, UNIX, DB2, HP Vertica
Project#2
Project Name: Probe, Mortgage
Client: Tesco Bank
Role: Design & Developer
Tools Used: Data stage 8.5
Team Size: 8
Project Description
Tesco Bank is getting different data from different source systems (Fiserv, Bureau, Experian, HSBC, Signature etc).We are transforming the data and auditing the data for checking whether data is already processed or not for the day and loading the data into common area so that our downstream can access the data for further process.
Responsibilities
Developed new data stage jobs and sequences.
Involved in understanding Technical Spec Doc and Handling CR’s.
Used the Unix command and shell scripting depending upon business requirement.
Performed smoke testing to test the job is performing properly and loading the data into the target table correctly.
Deliver the technical specification & code along with release note, UTC (Unit Test Cases) & Smoke Test documents for onsite review and testing.
Worked on defect fixing during system and integration testing.
Involved in code check in and checkout process through SVN Tool for deployment to Test and smoke environment.
Environment: Data Stage 8.5, UNIX, Oracle
Project#3
Project Name: Stores
Client: Target India
Role: Design & Developer
Tools Used: Data stage 8.5
Team Size: 12
Project Description
Target is the second-largest discount retailer in the United States.Target stores carry clothing, shoes, jewelry, health and beauty products, electronics, compact discs, DVDs, bedding, kitchen supplies, sporting goods, toys, pet supplies, automotive supplies, and hardware supplies.
They also carry seasonal merchandise such as patio furniture during the summer and Christmas decorations during November and December. Many stores, depending upon location, may also have Target Optical, Target Clinic, and a portrait studio.
The document intends to provide low level design including ETL Data Stage Jobs changes, data model changes, Database changes, Data migration, Job scheduling processes.
Responsibilities:
Analyzing the system process and functionality and designing the new system with the respective appropriate functioning techniques.
Created the LLD, UTC and STM Documents.
Involved in Designing the Data stage job
Tunes the jobs and building scripts and modified as per the new requirement
Prepared Control-M Visio for Daily/Weekly/Monthly Running of jobs
Involved in Post-Production activities.
Environment: Data Stage 8.5,Unix, Teradata,DB2
Project#4
Project Name: Stock Ledger (STL-SO)
Client: Target India
Role: Design & Developer
Tools Used: Data stage 7.5
Team Size: 6
Project Description
The purpose of this Project is to present detail design for integration of Foundation EDW-Finance-STL layer with Shared objects. The document intends to provide low level design including ETL Data Stage Jobs changes, data model changes, Database changes, Data migration, Job scheduling processes.
Responsibilities:
Analyzing the existing system process and functionality and designing the new system with the respective appropriate functioning techniques
Providing Technical/functional assistance to offshore team members
Created the HLD, Low level design and STM Documents.
Involved in Designing the Data stage job
Tunes the existing jobs and analyze the existing scripts and modified as per the new requirement
Build the unit test cases.
Prepared Control-M Visio for Daily/Weekly/Monthly Running of jobs
Involved in Post-Production activities.
Given Transition to the EAM Team once all reports verified
Environment: Data Stage 7.5,Unix, Window XP, DB2
Project#5
Project Name: SDP-Service Delivery Platform
Client: Bharti-Airtel
Role: Design & Developer
Tools Used: Data stage 7.5, DB2 and Unix Scripting
Database: DB2
Team Size: 8
Project Description
SDP_BI generated analytics for VAS. VAS includes Airtel Live, Hello Tunes
Short Code Messages. Daily rated & Unrated EDR’s get pushed by mediation team for each
VAS Services. Data get extracted from files and loaded into tables. Aggregate tables get
Populated as per KPI’s defined, on top of reporting layer Tables reports are available. This
Helps business to know revenue & usage from various VAS services and promote/introduce
New Services. Campaigns are also run based upon analytics generated.
Responsibilities
Administer Data-stage server and perform activities like creating projects, configuration
File, export/import jobs and monitor processes.
Modifying the UNIX and Co-sort scripts as per the requirements.
Connectivity to DB like DB2
Data Stage jobs for Data validation
Monitor data load process and perform bulk load process.
To perform ETL programming, and design ETL (parallel jobs) for data extraction,
Cleansing, Transforming and Loading
To support Production Environments on handling and resolving the production issues,
Job Monitoring, Emergency code fixes, and worked on Enhancement of existing system
Responsible for module leading and client interaction for requirement gathering
Environment: Data Stage 7.5, Unix, DB2
Contact this candidate