Sign in

Etl developer

Buena Park, CA
October 08, 2019

Contact this candidate


Arief Ahmed Shaik +1-773-***-**** Buena Park, CA, 90620, United States

Techno-Functional with more than 7 years of Banking Financial & Risk experience in Data Warehouse & Regulatory projects. Implementation and support of Regulatory systems (Quarter end support, FFIEC031, HC-R, CCAR 14Q &14A) using 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, MySQL.

Axiom Solutions, Moody’s tool-RAY2.0.

Autosys & JIL Scripts

Excel, PowerPoint, Visio, Word.


Application Consultant - Basel Reporting Analyst March 2016 to Current

MUFG Union Bank, CA

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

Collaborating with business, assisting them with the RWA calculation, reconciliation of Reports and General Ledger (GL) for loans, Leases, Unfunded commitments, Loans –Held for Sale, Securities.

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

Supported Capital ratio and RWA calculation at granular level for products like Derivatives, Deposits, Loans and Securities.

Accountable for queries and reconciliation issues on Balance sheet (Equity, Assets & Liabilities) at MUB and MUAH level.

Automated CAT 1&2 reports in Axiom using free form reports reducing the manual efforts of Business every quarter.

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

Through understanding of Commercial, Retail &Capital market data and mapping to line items in Regulatory 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 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 jobs by automating it using shell scripts reducing the labor by 50%.

Created channel between producer & consumer account on GIS server to SFTP Downstream files using 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 Basel run by creating jobs in Autosys, using Jill and 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.

Graduate Research Assistant Jan 2015 to Dec 2015

CAPS, University of Oklahoma, OKC

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

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.

Used ctypes libraries for creating ctypes objects for using shared data as a part of multiprocessing.

Plotted 2D plots & Histogram for fields of radar data by using colorbar, pcolormesh, hist function of Matplotlib.

Application Consultant - Basel Reporting Analyst March 2016 to Current

MUFG Union Bank, CA

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.

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.

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

Fine-tuned several SQL queries 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.

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

Pursuing Master of Science in Management Information Technology in Campbellsville University. 2019-Current

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


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

Contact this candidate