Address: Tel:+91-971*******(M)
House Number :B - 23, Email: aboi42@r.postjobfree.com
Lajpat Nagar - III,
New Delhi - 110024,
India
ANSHU GARG
* Overall Experience of 4.5 years in the IT industry.
* Experience over the entire software development life. Have been
extensively involved in requirements gathering (understanding of customer
business needs / requirements), analysis / design (high level design, low
level / detailed design, system requirements specifications & database
design, unit testing, data migration, data extraction, data load,
reporting, application maintenance, application / production support and
release management, environment setup, handling change request/change
management, impact analysis, mentoring team members.
* Strong background in Informatica, DataStage (Server), Business
Intelligence & Data Warehousing
* Knowledge and concepts in DW, BI, ETL, Reporting (Crystal Reports) & BO
Universe.
* In-depth knowledge of data mapping, warehousing tools, unit testing,
process documentation.
* Competent in data warehouse project planning, maintenance, development
and enhancements.
* Good team player with strong analytical and communication skills.
* Goal oriented and possess strong desire to work with huge data sets.
* Experience Summary
. RMS India Pvt Ltd - Oct 2011 to Present
. Infosys Technologies Ltd - Sep 2008 to Sep 2011
* Education Qualification
Examination Year Institution/ School Percentage
B.E.(Comp Sci) 2004-2008 LIMAT, MDU/Rohtak University 67.85
XIIth 2002-2003 Air Force Bal Bharti School, 78.8
Xth 2000-2001 Delhi 84.4
Air Force Bal Bharti School,
Delhi
* Skills/ Experience
. Hands on experience of development using ETL tools: (Informatica
9.0.1, DataStage Server Edition 8.5, SSIS)
. Worked extensively on SQL Server.
. POC on MongoDB, Python.
. Exposure on Universe and Crystal Reports
. Excellent analytical, interpersonal and communication skills.
. Experience of data migration / conversion projects.
. Experience of supporting a live data environment for a business
critical application.
. Experience in performance aspects of large databases.
Project Work
Company : RMS
Title : Exposure Source Database
Role : Senior Database Analyst
Tenure : Oct - 2011 - Till Date
Database/Tools : Informatica 9.0.1 PowerCenter, MS SQL Server
2008
Description
ESDB provides location specific, US commercial and residential property
exposure data that is optimized to use with catastrophe modelling for
insurance industry.
It is used for checking accuracy of client data, identifying areas of good
and bad data quality to make suitable recommendations for improvement of
exposure data quality.
I am involved in Requirement Gathering and Development phase, worked on End-
to-End lifecycle of the product.
Responsibilities
Requirement Gathering
Analyze the business rules to be applied, optimize them and define their
sequence.
Roll out Functional Specifications for various stages of development
process.
Development
Extracting data from various sources and finding the relevant accurate data
based on requirement.
Analyzing data to judge its accuracy and predict data from which source
would be accurate in case of overlaps.
Design, implement and maintain the data warehouse.
Develop jobs to extract data from various sources, apply transformations and
business rules on the relevant data to load to Exposure Source Data Base.
Company
:
Infosys Technologies Ltd.
Title
:
SCI
Client
:
Service Corporation International
Role
:
Senior Software Engineer
Tenure
:
Aug 2010 - Sept 2011
Database/Tools
:
Informatica 8.6.1, Microsoft SQL Server 2005
Description
SCI is North America's largest provider of end-of-life arrangements and
services.
I was part of the Information Delivery Team that maintained the data storage
in OLAP model for analysis. ETL of data was done from data warehouses to
data marts and in turn reports were created.
The project used HMIS NextGen application at the front end that handled real
time data. This real time data was stored in HMIS database (Client's
database).
Responsibilities
Understanding of business requirements and identify the relevant functional
and technical requirements.
Developing ETL jobs, scheduling and monitoring.
Appreciations :
Awarded with Certificate of Excellence.
Awarded with On the Spot Award
Company
:
Infosys Technologies Ltd.
Client
:
Stewart
Role
:
Software Engineer
Tenure
:
Till Aug 2010
Database/Tools
:
DataStage (server), ETL jobs, Data Warehousing, Microsoft SQL Server
Migrations
:
DataStage 7.5(Server) to DataStage 8.5(Server).
SQL Server 2000 to SQL Server 2005.
Description
Stewart is the second largest provider of funeral and cemetery services in
the United States.
The project used HMIS 7.5 application at the front end that handled its real
time data.
Responsibilities
Developing ETL jobs, scheduling and monitoring.
Production Support
Achievements
* Awarded with a Certificate of Excellence By Infosys.
* Awarded with a certificate from University of Toronto for successfully
completing a course in Python on Coursera.
* Presented a paper in the National Conference on Future
Trends in Software Development'08 on Remote Sensing and GIS in
Sustainable Environment Development.
* Painting- Was awarded with excellence in painting award in
class 12th, received 3rd prize in State level poster making
competition.
* Certificate of Merit at National Mathematics Olympiad Contest
conducted by Delhi Association of Mathematics Teachers held in 1999.
* Actively Participated and won prizes in Music, community service.
* All rounder award in 2001-2002