Utsav Chatterjee is seeking a position as a Data Quality Analyst. He has experience with Winshuttle, Informatica, SAP, DataFlux, Hadoop, and SQL. He has a Master's in Information Quality from UALR and a Bachelor's in Mechanical Engineering from KIIT University. He has work experience in data quality roles and as a research assistant working with Hadoop.
1 of 5
Downloaded 26 times
More Related Content
Uc resume 2013
1. 油
Utsav Chatterjee
1701 Westpark Dr. Apt 19
Little Rock, Cell no: +1 501-707-4170
Arkansas 72204 E-mail: utsavchatterjee@hotmail.com
OBJECTIVE
To work as a Data Quality Analyst, using experience gained in an academic environment and gain
hands-on industry experience in the process. My specialization interests are Data Governance and
Data Quality.
CERTIFICATIONS
油AND
油TRAINING
油
CITI (Collaborative Institutional Training Initiative) Certified Research Curriculum Completion, 2013.
Score: 100%
Scored 98% in FS-Insurance Certification working in Farmers Insurance Group, 2012.
Scored 82% in FS-Banking Certification working in Farmers Insurance Group 2012.
Successfully completed training on SAP and Winshuttle Studio (Transaction, Query, Designer &
Central) from Reliance Global Services Pvt Ltd
Successfully completed training on Informatica 9.5.1 at Software Training and Development
Achieved a Distinction in Green Field Training from Accenture IDC, 2012.
Course Company/Vendor Date Taken
QTP Basic course Mercury/HP August 2012
QC Basic Course Mercury/HP August 2012
Load Runner Basic Course Mercury/HP August 2012
IBM RFT 8 Basic Course Mercury/HP August 2012
SKILLS
油AND
油EXPERTISE
WINSHUTTLE
Winshuttle Transaction
則 Automates Data Import (including Mass upload) into SAP with no programming
Winshuttle Query
則 Simplifies SAP extracts and reporting and automates them.
Winshuttle Designer
則 Automates business processes via workflows
Winshuttle Central
則 Integrates Native sharepoints, forms, documents and Business processes which gives the capability
of governance, risk, and compliance
Winshuttle Runner
則 Integrates SAP processes easily and securely into Excel
Winshuttle FormEx
則 Develops web based forms for data uploads to SAP
Winshuttle DocEx
則 Integrates Native sharepoint with document workspace and adds the functionality of workflows as
per the business processes.
INFORMATICA
Informatica Data Quality Developer 9.5.1
則 Data standardization
則 Address Validation
則 Logical view of Enterprise wide Data
1
2. 油
Utsav Chatterjee
1701 Westpark Dr. Apt 19
Little Rock, Cell no: +1 501-707-4170
Arkansas 72204 E-mail: utsavchatterjee@hotmail.com
Informatica Analyst 9.5.1
則 Data profiling
則 Scorecards
則 Data Quality Tables
Informatica PowerCenter 9.5.1
則 Extract, Transform and Load
SAP
Customer Master (Order To Cash)
Vendor Master (Purchase To Pay)
DataFlux
DataFlux dfPower Studio 8.2
則 Dataflux integrates solutions, tools, methodologies and workflows to manage data.
DataFlux dfProfiler
則 Profiles and analyzes data with features like pattern analysis, frequency distribution and drill downs
DataFlux dfArchitect
則 Provides solutions like Data validation, standardization, parsing, integration using match codes,
clustering, enrichment, and Data monitoring
DataFlux DBViewer
則 Detailed overview of Data in the form of Standard metrics and custom metrics
DataFlux DQAnalyzer 8
則 A comprehensive tool for statistical analysis of data and dependencies based on the business rules
DataFlux Data Management Studio 2.3
則 Responsible for administrating the repository and Quality knowledge base. Enables the user to
create Data specific business rules and process jobs.
HADOOP
Setting up Hadoop Cluster
Administer and run Map-Reduce jobs
Quality Center 11.0
Defect Logging
Report Generation
Defect Analysis
Quick Test Professional 11.0
Automation scripting using JavaScript
Collaborative defect reporting with Mercury QC
Root Cause Analysis
SQL
Databases:
SQL Server
MySQL
Oracle
Access
2
3. 油
Utsav Chatterjee
1701 Westpark Dr. Apt 19
Little Rock, Cell no: +1 501-707-4170
Arkansas 72204 E-mail: utsavchatterjee@hotmail.com
Programming languages
Java
C
C++
C#
JavaScript
HTML
CSS
Python
WORK
油EXPERIENCE
Jan 2013 Present - Working as a Graduate Research Assistant, leading the Hadoop- Big Data team for
analysis of Social Network Data. The purpose of this project is to implement the concept of distributed
computing while using the Hadoop Distributed File System for Social Network Analysis related projects.
Jan 2013- Present- Working as Academic Coach at the UALR Academic Success Center. Job responsibilities
include counseling undergraduate students and conduct seminars and workshops for Personal Development.
Feb 2012 Dec 2012 - Worked as a Testing Analyst, for the firm Zurich Financial Services
Won, Organized and Participated in various events and activities while working in ZFS.
Jun 2012 Dec 2012- Worked as an Associate Software Engineer, in the field of Functional Testing
May 2011- July 2011- Technical Intern at Birla Copper (Hindalco Industries Pvt. Ltd.). Main concentrations
of internship were to understand the management and maintenance aspects of Asias Largest Copper Smelting
plant and study the use of SAP in monitoring and controlling in-plant processes.
Successfully Attended, 8 Continuous Competency Development (CCD) Sessions and completed more than
50 Online Trainings while in Accenture.
ACADEMIC
油EXPERIENCE
Jan 2013 Mar 2013- Performed data cleansing, standardization and entity resolution (master data management)
on a data set of 100,000 records using SAS DataFlux and Oyster. This assignment had a very strict deadline and
was delivered successfully. It was a team project and I served as a technical resource. (Note: According to
Gartner, DataFlux is an industry leader in data quality and master data management applications)
Jan 2013- Current Member of the IAIDQ (International Association for Information and Data Quality)
committee of UALR. http://iaidq.org/ (The professional association for those interested in improving business
effectiveness through quality data and information.)
Jul 2009 Dec 2009 Designed a Library Management System project where I designed a database and
created it using various relations for the ease in management. The GUI was built using HTML, CSS and Java
Script. Technologies used: Oracle
May 2012- Graduated with a score among the top 10% in class.
Jan 2012- Designed a Twin-Tube Shock Absorber for a 4-stroke 2-wheeler vehicle, considering the
vehicle weight to be approximately 150 kg and the combined weight of the passengers to be 200kg, under
Prof. Purna Chandra Mishra.
3
4. 油
Utsav Chatterjee
1701 Westpark Dr. Apt 19
Little Rock, Cell no: +1 501-707-4170
Arkansas 72204 E-mail: utsavchatterjee@hotmail.com
Oct 2011- Worked on a research paper concerning Noise Control in Internal Combustion Engines under
Prof. Isham Panigrahi in November 2011. The paper included a detailed analysis of all the causes of
noise in an internal combustion engine and possible ways in which to reduce the noise.
Jan 2011- Worked on the design and fabrication of an Abrasive Grinder under Prof. K. Pal. The main
intention of this project is to use the grinder on specimen and study the microstructures of ferrous and
non-ferrous alloys.
Feb 2011- Case study on The usefulness and applications of Six-Sigma in todays Industries by visiting
various firms and performing a short research on Lean manufacturing.
Sep 2010- Automation in milling tool design project using CATIA- a detailed analysis.
Mar 2012- Research paper on Noise reduction in Internal Combustion Engines selected to be published
in a scientific journal.
Presented seminars on; Rapid Prototyping; Bio-diesel; Geothermal Energy
ACADEMIC
油ACHIEVEMENTS
Scored 320/340 in GRE
Scored 116/120 in TOEFL
Graduated with a score among the top 10% in class in KIIT University (B. Tech in Mechanical
Engineering)
Research paper on Noise reduction in Internal Combustion Engines selected to be published in a
scientific journal.
ACADEMIC
油PROFILE
COURSE INSTITUTION YEAR
COMPLETED
MSIQ (Masters University of AR at Little Rock 2014 (expected)
of Science Curriculum includes:
Information Principles of Information Quality (Currently Enrolled)
Quality) Information Quality Tools and Industry Landscape (Currently Enrolled)
Information Systems Analysis (Currently Enrolled)
Entity Resolution (Fall 2013)
Database Systems (Fall 2013)
Information Visualization (Fall 2013)
Information Quality Theory (Spring 2014)
Social Media and Completion (Spring 2014)
Information Quality Policy and Strategy (Spring 2014)
B.TECH KIIT University, Bhubaneswar, India 2012
(Bachelors in
Technology) GPA: 3.41/ 4.0
Major:
Mechanical and
Industrial
Engineering
4
5. 油
Utsav Chatterjee
1701 Westpark Dr. Apt 19
Little Rock, Cell no: +1 501-707-4170
Arkansas 72204 E-mail: utsavchatterjee@hotmail.com
10+2 Center Point School, Nagpur (DISTINCTION) 2008
th
10 Naval Public School, Goa (DISTINCTION) 2006
CURRICULAR
油ACTIVITIES
油
油
Won the National Football Championship in Collegiate level for KIIT University in 2011 as Captain of the team.
Won District Level Badminton Championship hosted by YMCA in the state of Maharashtra in 2005.
Was a member of the core organizing team of Techno-Management Fest at KIIT University in 2010 and 2011.
POSITIONS
油OF
油RESPONSIBILITY
Organizer, National Inter-College Futsal tournament, organized in KIIT University.
Organizer, Battleground- a Robotic warfare competition, a part of Kritansh- KIIT Universitys Techno-
Management Fest
Languages: English, Hindi, and Bengali.
5