Resume_Achin

of 5
CURRICULUM VITAE
Name Achin Singhal Contact # +91-8860222219 / 8884106789
Location Bangalore
Mail Id
achinsinghal_706@yahoo.co
.in
Career Objective
 To work in a challenging atmosphere where individual skill and team spirit is recognized and
rewarded.
Professional Summary
 Around 4 years of experience as a Software Engineer with strong Data Warehousing and
BI skills.
 Well worked in Netezza database development and have hands on experience in
creating various database objects including procedures and functions and also aware of
performance optimization.
 Well aware of several NZSQL utilities.
 Proficiently worked on ETL tool Informatica Power Center 8.x/9.x and well versed
with creation of Mappings, Workflows and Tasks. Also possesses basic knowledge of its
administrative part and worked with Admin Console part.
 Well aware of all the client application including Repository manager, Admin console,
designer and workflow manager and worked with several complex transformations.
 Equipped with knowledge on Informatica upgrade from 8.x to 9.x version.
 Basic Knowledge in Linux and Shells and File transfer using SFT tool ST Client,
Connect Direct process.
 Also worked on MS SQL server 2008 and oracle 10g and several tools including Toad,
Aginity and SQL server client.
 Well equipped with various windows functions including Task scheduler to schedule the
windows jobs and also automation tool like Workload automation.
 Good Interpersonal skills, committed, result oriented, hard working with a quest and zeal
to learn new technologies.
 Team player & effective communicator with strong analytical & organizational skills.
 Ability to troubleshoot issues quickly and effectively.
 Good Knowledge in Software Development Life Cycle.

of 5
Experience Summary
Organization Name Designation Period
Capgemini Consultant May 2014-Till date
IBM India Pvt. Ltd.
Application Developer-
Informatica/Netezza
July 2013 – May-2014
Tata Consultancy Services Ltd. System Engineer Jan 2011 – Jul 2013
Technical Expertise
Education Summary
2010 BTech from UPTU, Lucknow with an aggregate of 76%
2006 12th from CBSE with an aggregate of 88%
2002 10th from CBSE with an aggregate of 91%
Engagement Overview
Project #1:
Project Name BOBI Start Date May-2014
Client AT&T End Date Till date
Project Location Capgemini Bangalore
Technologies
Involved and
Tools Used
Informatica
9.5,Oracle 10G ,
TOAD, Linux and
OBIEE
Tools and Languages Informatica PC 8.x/9.x, SQL, Netezza NPS 6.0, Linux and
shell scripting.
Databases Netezza and Oracle 10g.
Operating System Windows XP/Vista/7 and Linux
Documentation Tools M.S Word, Power Point, Excel, IBM Symphony
Development Tools & Utilities TOAD, Informatica, Netezza, WA, Aginity, SFT
Ticketing Tool Remedy, Tivoli, Infoman

of 5
Project Description:
At&t is a major US telecom service provider. We manage their DSL and UVerse data warehouse
business which involves the complete bundle of products.
Responsibilities:
 Currently working as a Tier-3 support resource and independently handling all the issues
and requirements passed on by T1 and T2 support teams.
 Involved in quick resolution of high priority issues effectively and efficiently.
 Actively engaged in handling all Client/Support team calls to understand issues and exact
requirements.
 Also engaged in creation of new mappings for the new requirements.
 Effectively handled the Unix to Linux servers migration.
Achievements:
Awarded with Technical expertise and star award within a short span of time.
Project #2:
Project Name
Export Blue(American
Express) IRIS
Start Date Jul-2013
Tools
Informatica PC 9.1, SQL
Server 2008, Intellisuite
from Sunguard
End Date May 2014
Project Location
IBM India Pvt Ltd. –
Noida
Technologies
Involved and Tools
used
Informatica,
MSSql server
2008,
Reconciliation
and Matching
tool Intellisuite.
IRIS: International Reconciliation Information System is the prime reconciliation and
matching platform in American Express bank where various accounts at the Balance pool level are
matched, either auto match or manual match and reconciliated thereafter.
Feeds from different third party sources are received and converted to format files which are then
fed into the Intellisuite application where its matched and reconciled. Then the data is being loaded
into the warehouse and used for generating reports.
Responsibilities:
 Understanding the requirements document and preparing the functional and Technical design
document.
 Designing and development of Informatica mappings and automated batch scripts along with
DB objects based on Technical document.
 Scheduling the jobs with help of windows task scheduler and file transfers through SFT.
 Add and modify users and security privileges through Informatica Admin Console.

of 5
 Importing and exporting data to Sunguard tool Intellisuite and perform matching and reconciliation
Project #3:
Project Name
Demand IT BI CoE
Offshore - Polaris (B2B) Start Date Dec-2011
Client
A large US Based
Pharmaceuticals
company
End Date Jul-2013
Project Location TCS – Noida
Technologies
Involved and Tools
Used
Data
Warehousing,
Informatica v 8.6
and 9.1,Netezza
6.0, Linux, TOAD,
WA
Polaris made a single complete and consistent store of data obtained from a variety of different
sources made available to end users for their better understanding and using in a business context
and Supports Lilly’s Sales and marketing organizations. It is a is a global data warehouse
containing data from US and multiple affiliates and contains two layers- Integration layer and
Datamart layer. Integration layer is used to store the historical data and Datamart layer is used for
Reporting and Analysis part. This project deals with handling data in retail marketing a well as B2B
transactions in Sales and Marketing of Pharma Domain.
Responsibilities:
 To understand the client requirement and implement the same.
 Involved in data loading obtained from different sources.
 Worked on the creation of various database objects including Tables, Index, Views,
sequence, procedures and UDF.
 Create Informatica mapping for new requirement and change existing Informatica Map,
Session as per change request
 Performed Informatica upgrade from 8.6 to 9.1 version.
 Involved in the Change of Linux shell scripts.
 Written test case to test Functions, Procedures, Package.
 Performance tuning of Queries.
Project #4:
Project Name RMPS-RBS Start Date Jan-2011
Client Royal Bank of Scotland End Date Dec-2011
Project Location TCS – Gurgaon
Technologies
Involved and
Tools Used
Informatica 8.6,
Netezza,TOAD,
Linux and PVCS
tracker

of 5
RMP Strategic is an initiative to create a reporting platform which can be used across the Corporate
Lending market in UK and Europe. It enables the relationship managers to keep a track of
performance of facilities provided to their customers and provides alerts and warnings to avoid
any defaults and take appropriate actions. Best practices followed on implementation.
1. Best Documentation in all phases of SDLC.
2. Framework for the UNIX batches created as part of data loading.
3. Checklist for Reviewing UNIX Shell Scripts, NZSQL, Informatica
Responsibilities:
 Tested all the workflows in test environment. After fixing all the issues the same was setup
for Production environment.
 Worked as a Informatica developer including creation of various mappings and workflows.
 Worked on the database objects creation like Tables, Views, sequence, Stored procedures.
 Put efforts to understand the system and prepare the workflow dependency sheet.
 Documented the testing done in Test environment as a smoke test report and incorporated
the same in Production environment.
 Involved in the review of the LINUX shell scripts.
Achievements:
Being a trainee, received appreciation form client and project manager and awarded with
On the Spot award several times
Personal Details
Name : Achin Singhal
Date of Birth : 10th Jan 1989
Marital Status : Single
Passport Number : J5867891 (Exp: Feb 2021)
Phone Number : +91 8860222219
Mail Id : achinsinghal_706@yahoo.co.in
Languages Known : English, Hindi
Declaration
I hereby declare that the information given above is true to the best of my knowledge. I will make
it my earnest endeavor to discharge competently and carefully the duties you may be pleased to
entrust with me.
Place: Bangalore (Achin Singhal)

Resume_Achin

Recommended

Recommended

More Related Content

What's hot

What's hot (19)

Similar to Resume_Achin

Similar to Resume_Achin (20)

Resume_Achin