Amit Rawat Mobile# +1-469 766 6691 Profile Glimpse
Amit Rawat Mobile# +1-469 766 6691 Profile Glimpse
Amit Rawat Mobile# +1-469 766 6691 Profile Glimpse
Email: wishamit@gmail.com
Mobile# +1- 469 766 6691
Profile Glimpse
Educational Credentials
Technical Skills
Operating System Unix, OS 390, Win NT
Tools/Software Abinitio 1.15, Informatica 9.1, Brio Suite 7.0,Brio
Information delivery portal, Hyperion 8.3
Database Worked On Teradata, Oracle
Languages Brio SQR (Reports), PL/SQL, JCL
Played the role of Project Manager for Reports – Archive Data R11 reports to
Business Objects R4 migration.
Responsibilities includes managing this Project from Delivery perspective by ensuring
proper transition of Business Requirement Documents from other Vendors & ensuring
Development & delivery of report as planned.
(A.2)
Name of the Client: Neiman Marcus, USA
Role Played: Project Lead/Manager
Operating System: UNIX, Win NT
Technology Used: Informatica 9.1, SQL, Oracle
Duration: 23 Apr 2012 – 22 July 2012
(A.3)
Name of the Client: Capital One Bank, USA
Role Played: Project Manager
Operating System: UNIX, Win NT
Technology Used: Abinitio 1.15, SQL, Teradata
Duration: June 2009 – 22 Apr 2012
Description: Capital One is a leading Bank in US. Capital One is in Credit Card,
Home Loans & Auto Loan Business in US.Engagement includes taking care of Client’s
ETL requirement needs & providing Development & Maintenance support to several
of different application in Capital One.Project is to Establish Mortgage Development
Team in ETL space & taking care of their ETL processes & develops new interfaces to
Mortgage Warehouse from different source systems.
Responsibilities: This project started with Capital One took over of Norfolk Bank,
Chevy Chase Bank & Bank South (ALS).Helped in establishing the ETL Team at onsite
& Offshore, whose responsibility was to develop the interface for the Data in these
Banks to Capital One Mortgage Warehouse.
Task was also to provide Development, Maintenance & Production support to these
recently developed interfaces.
In Jan 2010, Capital One Mortgage Business shifted from Richmond, US to Plano, TX
location. Ensured proper Transition of knowledge in location change as it also
included change in ETL Development Team.
Capital One Mortgage Yr 2010 Plan included, shifting of existing interfaces & new
source ETL development to 3NF where complete Database was redesigned to 3 NF
into different Subject Areas (Collateral, Foreclosure, REO, Loss Mitigation and
Application).
Plan was also to gradual parallel Decommission of earlier Developed Data
Warehouse, to start mapping the Business reporting from Mortgage Warehouse
(3NF) from PMORE (1 NF).
Responsibility included playing the lead Designer & Project Manager role & managing
the complete Mortgage Team as Project Manager from Delivery perspective.
Daily tasks included requirement analysis, Discussion of requirement with Business &
finalize the ETL design in given stipulated Timelines.
Also playing the role of BSA (Business System Analyst) on different requirements to
provide End to End ETL development.
Responsibilities also included, managing all work in different Mortgage Onsite Team
(Production Support Team, PMORE Decommission Team, Business As Usual Team) &
ensure zero Defect delivery to Client.
Monthly Invoicing, Budgeting & Resource Management was also part of exclusive
responsibilities.
Responsibilities: Metrics Team was a newly established Team in AETNA where task
was to understand their current ETL structure, taking care of new ETL Development
& existing ETL process enhancement.
Played the role of Team Lead & helped establishing the Team, ensuring proper
Knowledge Transition, managing ETL Development Delivery.
Responsibilities included Effort Estimation, Requirement analysis & providing Design
to Development Team. Also, worked on different requests & played the role of ETL
Developer as needed.
(A.5)
Name of the Client: Wachovia Bank, USA
Role Played: Team Lead
Operating System: UNIX, Win NT
Technology Used: Abinitio 1.15, SQL, Oracle,
Duration: Aug 2007 - Dec 2008
Description: Wachovia Bank is a leading Bank in US. Currently it has been merged
with Wells Fargo Bank in US.
Project includes taking care of their ETL structure & providing Development &
maintenance support to their ETL reporting needs.
Responsibilities: Worked as a Technology Lead & Team Lead in this Project & led 3
different Application Team - CDW (Corporate Data Warehouse), AML (Anti Money
Laundering) and Tech Refresh (ETL server Migration Project).
Played the role of Designer where Task was to perform the requirement analysis,
provide Design to individual Team for Development & managing their work from End
Delivery perspective.
Tech Refresh was an ETL server Migration project in Wachovia, where task was to
start from scratch & ensure smooth migration of Dev/Test/Production servers.
Led this Team starting from Effort Estimation, Resource management, Issue
Resolution.
(A.7)
Name of the Client: Capital One Bank, USA
Role Played: System Support Lead Specialist
Operating System: UNIX
Technology Used: SQL, Oracle 8i, Brio Suite (Brio 7.0), Hyperion Performance
Suite (HPS 8.3),
Duration: Nov 2005 – Jan 2006
Description: We were handling all the client's servers & users which include Data
Warehouse portals on Brio & Hyperion/Oracle Support.
We were abide to handle the client Data warehouse systems & resolving any
perforamce/problamatic/Critical issues
(A.8)
Name of the Client: Freescale – Semiconductor, USA
Role Played: Informatica Developer
Operating System: UNIX, OS 390, WIN NT
Technology Used: Informatica 6.2, Brio Suite (BP 7.0), Oracle 8i/9i, SQL, Hyperion
8.3(Hyperion BI)
Tools Used: Gentia, Brio Designer, Remedy, Maestro Scheduler, CA-7 Scheduler
Duration: Feb 2004 – Oct 2005
Responsibility was to keep the production portal up & to provide efficient & effective
solutions while working on various types of problem & enhancement/development
tickets raised by the client/user. The content of the problem tickets includes Data
Mismatch, SQR Report/BQY development, Portal Services, Reports performance;
Query tuning, Client interaction, Technical Guidance.
Enhancement/development request includes working on different work requests
which includes creation of new Informatica mappings, enhancing the functionality of
an existing mapping, Performance tuning & proper execution of the mapping.
(A.9)
Name of the Client: Johns Manville, USA
Role Played: Informatica Developer
Operating System: UNIX, OS 390, Win NT
Technology Used: Informatica 6.2, SQL, Oracle 8i, Brio Suite (Brio 7.0), JCL,
Endevor
Duration: Oct 2003 – Jan 2004
Responsibility: JM has a huge D/B & source system comprise of various platforms
on MVS, UNIX servers. Primary responsibility was to keep the systems up & to
provide effective solutions with in the mentioned period in SLA. Worked on various
types of tickets (Problems Request, Enhancement). Worked on creating BQY,
Creating JCL & updating different programs in COBOL. Working on creation of new
mapping, enhancing a mapping functionality, Performance tuning & proper execution
of ETL jobs were also part of responsibility.