EXPLORE


0.0
0.0
0%
$25 USD / Hour
・

India (10:11 AM)
・
Joined on July 11, 2008
$25 USD / Hour
・
IT experience in the business requirements analysis, application design, dimensional data modeling, data modeling, designing, coding, development, testing and implementation of business applications with RDBMS, Data Warehouse/Data marts, ETL, and client/server environment applications for Banking, Retail, financial and Health Care. ETL Tools -: Data stage 7.5/8.1/8.5 PX, Informatica 8.6.1, SAS. Databases (RDBMS) -: Oracle 11i/10g/9i, Teradata, DB2, SQL-Server, MS Access. Languages-:SQL, PL/SQL, UNIX shell scripting, Transact-SQL, PERL. Operating Systems-:UNIX, Windows (95/98/00/XP, vista), HP-UX, Linux. Version Control Tools-: CONTROL-M, Autosys, HP Quality center, Sequencer. Data Modeling Tools-:Erwin 3.0/3.5/4.0/4.1, MS Visio. • Working in banking domain for over 6 yrs. • Dedicated to maintain high quality standards. • Diversified domain experience in banking domain.
No reviews to see here!
Experience
Anti Money Laundering (AML),Saudi Arabian Monetary Agency (SAMA) & Moody's Analytics
May, 2014 - Present
•
11 years, 6 months
National Commercial Bank (NCB), Saudi Arabia
May, 2014 - Present
•
11 years, 6 months
• Created Oracle packages, scenarios using interfaces, variables, procedure • Designed the Software Design Document (SDD) for SIMAH project. • Was involved in the Design review and Code Reviews of different projects. • Used Data stage ETL for Designer to create the interfaces. • Performance tuned the Oracle and DB2 queries. • Involved in production support of daily EDW cycle. • Conducted code reviews and planned the knowledge transfer to client.
May, 2014 - Present
•
11 years, 6 months
Migration Data Cleanse
Apr, 2013 - Apr, 2014
•
1 year
Barclay’s Direct (UK).
Apr, 2013 - Apr, 2014
•
1 year
Designed and developed ETL processes to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database. Involved in performance tuning and optimization to manage very large volume of data. Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
Apr, 2013 - Apr, 2014
•
1 year
MASDBIP
Nov, 2011 - Mar, 2013
•
1 year, 4 months
Danske Bank, Denmark
Nov, 2011 - Mar, 2013
•
1 year, 4 months
• Understanding the Mapping document based on Standard Transformation rules. • Profound knowledge on IBM-BDW (Bank data warehouse model). • Developed Informatica mappings from (CPY to SOR) & (SOR to MART) Type-1 and Type-2 based on mapping rules to generate PIV. • Extracting data, cleansing, transforming, integrating, and loading data into Data Warehouse. • Design and Develop the ETL Parallel jobs in Data Stage. • Experience in Unix Shell Scripting
Nov, 2011 - Mar, 2013
•
1 year, 4 months
Education
Jawaharlal Nehru Technological University
2004 - 2008
•
4 years
B.Tech

India
2004 - 2008
•
4 years
Verifications