Arief Ahmed Shaik

adg3vh@r.postjobfree.com +1-773-***-**** Buena Park, CA, 90620, United States

Techno-Functional with more than 8 years of Banking Financial & Risk experience in Data Warehouse, ODS, CDW,EDW & Regulatory projects. Implementation and support of Regulatory systems (Quarter end support, FFIEC031, HC-R, CCAR 14Q &14A) using ETL Informatica, Moody's and Axiom Solutions in Accordance to Basel III rules.

Skills and Technology

PL/SQL, UNIX shell script, Python 2.7.

ETL- Informatica Power Center 8.6.0/9.1.

Oracle 11g, TOAD, Oracle SQL developer.

Axiom SL V9, V10,

Moody’s tool-RAY2.0.

Autosys & JIL Scripts

Excel, PowerPoint, Visio, and Word.

PROFESSIONAL EXPERIENCE

Application consultant/Reporting Analyst June 2020 to Current

Silicon Valley Bank, CA

Responsible for BRD, FRD, enhancements and support of Canada Regulatory reports using Axiom platform V9.

Design, development and deployment of Canada Stat Can reports S1, QS, S2, AS, C3.

Workflow automation of Axiom job using Redwood scheduler and shell scripts reducing the manual efforts intervention.

Consolidation of Axiom workflows to reduce manual effort of running 23 workflows without affecting inter series dependencies. This approach has reduced the manual effort and execution time by 40%.

Responsible for Inter series bug fixes, Regulatory changes and Form updates from Axiom release.

Application Consultant – ETL Lead March 2016 to June 2020

MUFG Union Bank, CA

End to end Axiom support generating Regulatory Capital FRY9C HC-R, FFIEC031 RC-R, and 14-Q reports.

Responsible for architecture and technical design document to communicate with offshore development team.

Performing ETL informatica code review and quality edit checks as per banks policy.

Reviewing &Preparing the Business requirement document, Functional requirement document, Detailed Design documents.

Created objects like Data Source, Data Model, Aggregation & Portfolio in Axiom helping business for better analysis.

Managing the ETL Informatica specification documents, data lineage and project related documents in share point.

Developed mappings like SCD 1, 2, 3, sessions, Packages & workflows using ETL tool Informatica & deployment activity.

Created transformations such as Joiner, Filter, Lookup, Expression, Aggregator and Update Strategy.

Tuning SQL queries by creating accurate indexes, using Explain plan, table partitioning & avoiding foreign key constraints.

Fine-tuned several SQL queries in Informatica that were used at the ETL level which were causing performance bottlenecks.

Implemented several partitions at ETL level to enable parallel threads resulting the processing window to pull by 2 hours which was a significant achievement for Enterprise DW allowing the downstream partners to complete the reporting quickly.

Defining the Edit checks, check error reports, attestation process & freezing of numbers for the Quarterly reports.

Analysis and Implementation of Axiom Solution as an upgrade to existing Moody’s solution reducing the Basel calculation time by 70% and labor cost by $0.3MM.

Optimized the ETL Informatica loads by changing the architecture to introduce Financial Data foundation (FDF) as source to reduce the execution time by 75%.

Elimination of manual trigger of ETL Informatica jobs by automating it using UNIX shell scripts reducing the labor by 50%.

Created channel between producer & consumer account on GIS server to SFTP Downstream files using UNIX shell scripts.

Carry out data related activities such as data extraction, profiling, cleansing, conversion, transformation, loading, data mining, warehousing, archiving and reporting.

Automation of Axiom Workflows by creating Autosys Jobs, using Jill and UNIX shell script eliminating offshore labor cost.

Produce equivalent detailed design document which would translate business requirement to technical requirement.

Fabricate system interfaces document to elaborate the hardware aspects of the project.

Devise Swim lane and Visio diagram to understand application workflow Work order documentation,

Writing SIT test cases, UAT support, sign off from Business, CAB approvals & production deployment activities.

Data profiling and assisting to business queries by writing simple and complex PL/SQL queries.

Experience in working with OLTP, ODS, CDW, EDW environments.

Graduate Research Assistant Jan 2015 to Dec 2015

CAPS, University of Oklahoma, OKC

Has developed Dual pol Radar Data simulator for various numerical Models using Python scripting.

Implemented python modules PyART to read data from files like CFRadial, netCDF file, UF file, NEXRAD level II.

Worked on matplotlib for plotting radar data and to interpolate model data to radar sweep functions.

Application Consultant – ETL Informatica Developer Sep 2010 to Dec 2013

MUFG Union Bank, India

Developed SQL scripts for Referential Integrity check, checking validity of incoming data with the data in master tables.

Created Oracle Tables, Views, stored procedures, cursors, triggers, Indexes, Synonyms, and Sequences.

Well versed with Relational /Dimensional Modeling techniques like Star, Snowflake Schema, Fact /Dimensional Tables.

Created new ETL codes, Package and views to pull data from different source systems and to generate the extracts.

Conducted data analysis on the extract files in order to set/validate error thresholds for the KDE Commercial.

Introduced a process in ODS to maintain 5 years Data for Cash and Save consumption helping it to maintain longer history.

Education and Training

Master of Science in Information Technology Management

in Campbellsville University, GPA of 3.6. 2019-2020

Axiom Solutions training from vendor at client location March 2019

Master of Science in Computer Science in University of Oklahoma, GPA of 3.7. 2014-2015

BE Computer Science Osmania University, Hyderabad. 2006-2010

Achievements

Received $2000 ConocoPhillips scholarship award in the first semester (Spring 2014) of Masters.

BE Computer Science Osmania University, Hyderabad. 2006-2010

Certifications

AxiomSL Controller View V10 Functional Foundations Certification January 2020

Contact this candidate