himanshu srivastava

system analyst - big data | financial crime | aml and ctf

About

> Technical Solution Designer with more than 13 years of experience in design & development of OLTP, Data-Warehousing and Data Migration projects > More than 13 years of extensive experience in Oracle Database 8/8i/9i/10g/11g/12c SQL and PL/SQL > Design and development experience in Big Data Cloudera Hadoop using Cloudera HUE, Pig Scripting, Hive Query Language, Hbase, Sqoop, Impala, Flume, Oozie, HCatalog > More than 5 years of Techno-Functional experience in Banking Compliance\Anti Money Laundering in Client Screening, Transaction Monitoring and Customer Due Diligence > Experience in BAE Netreveal (Detica Norkom) and Fircosoft AML Products

Country

australia

City

melbourne

Industry

information technology and services

Skill

anti money laundering, detica netreveal, cliff fircosoft client screening, databases, oracle, oracle sql, pl/sql, data warehousing, business intelligence, data migration, performance tuning, data modeling, unix shell scripting, web services, sdlc, integration, xml, etl, informatica, oracle xml database, unix, database administration, core java, requirements analysis, soa, requirements gathering, sql, business analysis, consulting, oracle sql developer, big data, hadoop, apache pig, hive, sqoop, hcatalog, hbase, flume, oozie, software development life cycle, apache kudu, apache spark, scala, python

Experience

it analyst | business and data warehousing | data migration

tata consultancy services

2007-12 - 2011-7 · 3 yrs 8 mos

oracle dba and member of data modelling and decision team

tata consultancy services

2006-12 - 2007-12 · 1 yr 1 mo

Client : i2 Technologies \ Infineon Technologies As part of this project I worked as an Oracle DBA and member of Data Modelling and Decision Team (DMDT) and my roles and responsibilities were to track the Data Model changes. I worked on incorporating approved changes to database as single point of entry to the clients non production databases. Worked on creation of all the Oracle Database Scripts for various database objects like Tables, Materialized Views, Views, Indexes, Database Links, Sequences, Synonyms, Grants; performed refresh of the Materialized Views in database. Worked on migration of database objects to the production Oracle environment. Managed Import and Export of Schemas between the environments and managed grants and revocations of Privileges to users. Worked on maintenance of UNIX based RCS system (version control system). I also worked on tuning of Oracle Queries using plan tables and Oracle Procedures, Packages, Functions by using Profiler utility package.

system analyst - big data | financial crime | aml and ctf

anz

2018-10 - Present · 8 yrs

technical solution designer | cloudera hadoop | aml | sanctions

anz

2015-1 - 2018-9 · 3 yrs 9 mos

solution designer-aml and ctf platform upgrade

anz

2013-10 - 2015-1 · 1 yr 4 mos

As part of this project I worked on the Upgrade of the Netreveal based AML Platform from 5.7 to 6.7. I worked on the Transaction Monitoring System (TMS) , Client Name Screening, Netreveal MIS Reporting and Siebel (Customer Onboarding Application) - AML interface upgrade. I was also part of the design team for design & development of the the Sanctions SATPROD environment.

associate consultant - banking product integration

oracle

2005-4 - 2006-12 · 1 yr 9 mos

* gt * Integration of Banking Product Flexcube with other banking products and third party tools * gt * Development of XML, ASCII Interfaces * gt * Webservices Development * gt * XML, XSD, XSLT, Oracle XML Database * gt * Oracle 9i/10g SQL, PL/SQL * gt * Core Java, Java Based Web Services, Oracle Fusion Middleware Oracle BPEL 10gR2, OC4J Application Server, IBM Websphere Application Server,

anti money laundering - technical lead

royal bank of scotland

2011-8 - 2013-10 · 2 yrs 3 mos

* gt * Alerts Decision Data Migration from Norkom Client Screening Platform to Fircosoft Client Screening AML Platform * gt * Alerts Decision Data Migration from Fircosoft Client Screening Platform to Fircosoft Client Screening AML Platform * gt * Detica Norkom Client Screening (Sanctions & PEP) * gt * Fircosoft Clif Client Screening (Sanctions & PEP) * gt * Fircosoft Clif MIS Reporting * gt * Oracle 11g SQL, PL/SQL