Gunjan Gunjan, Software Analyst

Gunjan Gunjan

Software Analyst

Vanity Fair Corporation

Location
India
Education
Bachelor's degree, computer science engineer
Experience
2 years, 7 months

Share My Profile

Block User


Work Experience

Total years of experience :2 years, 7 months

Software Analyst at Vanity Fair Corporation
  • India
  • June 2013 to December 2013

Vanity Fair Corporation Project, Accenture Kolkata (June 2013-Dec 2013)

Vanity Fair Corporation deals with fashion apparels business focusing majorly on american continent.
It has two brands Timberland and Smart Wool.

Project motive centralized around data conversion from SAP 4.6 to SAP 6.5. Entire project was
divided into several objects like Customer Master, Vendor Master, Material Master, Fixed assets, etc and there after allocated to teams. I worked on Customer Master Object. It was developed from scratch and went through several rounds of mock and testing before going into production. For reporting
pupose, the data loaded into SA P 6.5 was further prepared as per requirement and loaded into MDM.

DataStage Aspect: Components used for development were Transformer, Join, Pivot, Files, Copy, and
Lookups.

Software Analyst at Travelers Corporation Project, Accenture Mumbai
  • India
  • August 2011 to June 2013

PROFESSIONAL SKILLS
ETL (Extract Transformation Load) Tools: Ab-Initio (2 years), IBM Data Stage (6 Months), basic
training on Informatica at Accenture
Database: Teradata, Oracle, My SQL
Shell Scripting: Unix
HP Quality Center: Defects Handling Autosys: Jobs Management Tool
Programming Languages: C/C++, Core Java
Operating System: Windows 98/2000, Linux

PROJECT EXPERIENCE
Travelers Corporation Project, Accenture Mumbai (August 2011- June 2013)

Travelers Corp. is one of the largest insurance firms in US headquartered at Hartford, Connecticut and one of the platinum clients of Accenture. The project is based on Commercial Lines as well as Personal
Lines of Insurance. Operations centralized on developing applications to load their business generated
data across global areas into their data warehouse. Initially it was on monthly basis but then focus was to shift applications on daily operations.

Worked on a Development Cum Enhancement module called "Profitability 3" which was to load
Premium related data for Travelers Corporation on daily basis into their warehouse. It was successfully
done and appreciated by the delivery unit of Accenture.

Worked end to end on a Development module called "Loss data Optimization" which was to load Loss
related data for Travelers Corporation on daily basis into their ware house. It was successfully done and appreciated by the delivery unit of Accenture.

Ab Initio Aspect: Components used in the development were Sort, Reformat, Roll Up, Ded Up Sorted,
Filter by Expression, Join, Inclusion of graphs in plans and Psets.

INTERNSHIP at National Thermal Power Corporation
  • India
  • June 2010 to July 2010

INTERNSHIP
National Thermal Power Corporation, Kahalgaon, Bhagalpur BIHAR ( June 2010 - July 2010)

Designed a Quality Circle Information System as per the requirements explained by Sr.
Engineer Anuj Swami (Information Technology Department of NTPC) .It was an initiative to assess and improve the performance of its employees by the administration of NTPC, with online intranet support. Technology used was PHP and My SQL.

Education

Bachelor's degree, computer science engineer
  • at Kalinga Institute of Industrial Technology
  • January 2011

Kalinga Institute of Industrial B.Tech Technology (Computer Science & KIIT University, Bhubaneswar, Engineering) Odisha 2011 CGPA 8.97

High school or equivalent,
  • at Delhi Public School
  • January 2005

Delhi Public School, Bokaro Steel City, Jharkhand (CBSE Board, New Standard 12 Delhi) 2005 65 SKP Vidyavihar, Banka, Bihar

High school or equivalent,
  • at SKP Vidyavihar
  • January 2003

Standard 10 (CBSE Board, New Delhi) 2003 92.8

Specialties & Skills

Teradata
Datastage
Abinitio
AB INITIO
DATA WAREHOUSE

Languages

English
Expert
Hindi
Intermediate

Hobbies

  • Public Speaking, Swimming, Playing cricket