SUMMARY:

Sophisticated information technology leader with deep expertise working on complex Financial Data Processing Systems. Having 17+ years of comprehensive IT experience and highly adept at providing innovative solutions to complex Business & Technical requirements, efficiently partnering with Business clients and effectively driving solution implementation in - liaison with cross-functional, cross-platform IT teams

AREAS OF EXPERTISE:

TECHNICAL SKILLS:

Tools: /Languages: ACTIMIZE, Informatica 9.x/8.x, Oracle Data Integrator (ODI) ETL Tool, OEM, PL/SQL developer IDE, Erwin - ER Studio, OBIEE, OWB, OLAP, TOADVS2013, VB.NET, Visio, Oracle Golden-Gate, Eclipse, CVS, ClearCase, TableauPL/SQL, T-SQL, UNIX Shell, Java, J2EE, C, C++, Perl, Python, HTML, C#

Databases: Oracle 7.x - 12c, MS-SQL 2008-2014, MS Access 2000-2013

Business IT Systems Experience: High Volume data processing, Time & Attendance, Securities industry, “Card Not Present” / online, real-time Credit Card Authorization Recommendations to eliminate fraudulent purchases, Decision Support System (DSS), Business Intelligence system, Payment Processing, Money Laundering, Financial Compliance Technology development and Portfolio Management, Oracle DBA

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Application/Data Architect

Responsibilities:

• Collaborated with the brand new, source data provider ' Confidential, ' key stakeholders, business analyst and internal teams to define the enterprise architecture and data requirements for 'ACTIMIZE' tool.
• Design and Development of multiple ‘Data Mapping’ requirements from source to target up to three levels.
• Architect and Designed the entire process in-line with the existing single, ‘ Confidential Data Warehouse’ repository and created a comprehensive, multiple ‘Mapping’ documents for the Three ETL processes.
• Created both Logical and Physical Entity Relationship Diagram (ERD) for this project using ErWin.
• Actively participated since the inception with various stakeholders to optimize the design of the whole process.
• Design and development of the ‘Data validation’ processes to make sure the data will always be consistent with the existing data warehouse.
• Assisted in the development of multiple ETL processes using Informatica 9.x for processing both Confidential and B2C ‘Twelve’ source data files from ‘Three’ different regions around the world every business day.
• Created ‘High-Level Design’ (HLD) and ‘Scope & Assessment’ (S&A) documents including the source data definitions, data dictionary, and data analysis for this project.
• Created the new reference data, new loading processes, Tables, views in line with the existing ‘Data Warehouse.’
• Actively participated in the process of setting up the model’s ‘thresholds’ for the proper alert generations.
• Assisted in in-house ‘Actimize’ tool test data set up for Development, QA and UAT purposes.
• Actively supported the post-production deployment.
• Design and Development were being done for the above project on UNIX/Linux/Windows platforms. The extensive use of UNIX shell script, Erwin - ER Studio, ACTIMIZE tool, Perl, AutoSys, SQL and Oracle PL/SQL Procedures.

Confidential, Piscataway, NJ

Sr. Data Analyst

Responsibilities:

• Designed and developed DM, DW, and Interfaces with in-house applications for other metrics and data.
• KPI and their trends for the different end-user side and company services performances.
• Will provide the predictive analytics about the causes and their effects on the business and customers.
• The source data are being extracted from multiple databases, 3rd party tools, and another Data warehouse.
• Various business decisions are being made based on the contents of these reports.
• Designed and developed DM, ETL, and data processing application.
• Discussed with various in-house stakeholders to successfully extract the data in an appropriate format for further Transformation and Load processing.
• This application is set up to execute at multiple timings in a day by a cron job.
• Development was being done for the above application on UNIX / Windows platform.
• The code has been written in the extensive use of Oracle PL/SQL Packages, Procedures, OBIEE, UNIX shell script, VB.Net, Erwin - ER Studio, Perl, Tableau.

Confidential, NY, NY

Solution Data Architect and Data Warehouse Lead

Responsibilities:

• Research, architect and developed the new ‘IFA’ and ‘CARS’ DWH database systems that receive the data from the multiple agencies every day and translate those data and load into these systems for further processing.
• Designed the logical and physical ‘IFA’ and ‘CARS’ DWH database systems with multiple relations fact and dimensions tables of ERD using ErWin, materialized views, triggers, sequences, and constraints.
• Worked on data warehousing component from inception toimplementation and developed and enhanced the various ETL processes to load the required data from different agencies with multiple formats effectively using Informatica, PL/SQL packages, and VB.NET.
• Created new data formats for Extract, Translate and Load (ETL) the data to ‘IFA’ and ‘CARS’ DWH database systems with the consultations with various internal and external stakeholders.
• Designed and developed multiple in-house Oracle PL/SQL package modules for data processing, data feeds, multiple reports creations and email the reports to multiple, participating agencies.
• Modified the existing ‘CityTime’ system to improve the performance by changing the data flow and SQL tuning.
• Development is being done for the above application on UNIX and Windows platforms.
• The code has been written in the extensive use of Oracle PL/SQL Packages, Procedures, Functions, Triggers, OWB, UNIX shell script, VB.Net, Erwin - ER Studio, Informatica.

Confidential, Iselin, NJ

Sr. Oracle Programmer

Responsibilities:

• Research, designed, developed and maintain the new Oracle PL/SQL modules that extracting data from various sources and recursively exploding the finished goods up to the bottom-most level of ‘Bill of Materials’.
• Designed and developed MRP Oracle DB schema including logical and physical ERD using Erwin studio.
• Designed and developed multiple reports using ‘Tableau’ for internal clients from multiple data sources.

Confidential, New York, NY

Sr. Software Engineer (Consultant)

Responsibilities:

• Enhanced the existing multiple DB systems to remove the unused objects, merging the existing objects and created the maintenance script to manage after profound analyzing the DB.
• Research, designed and developed Oracle modules to implement the ETL processing of the raw data combined with VB code with various UNIX shell scripts, C++ code for ETL with FTP and SFTP protocols.

Confidential, Princeton, NJ

Sr. Software Developer (Consultant)

Responsibilities:

• Research, designed and developed Java modules for the products which simulate the working environment for the multiple payment processors.
• Designed and developed various Java modules for the highly secured socket and multi-threading applications to support other products using FTP, SFTP, HTTP and HTTPS protocols.
• Development was being done for the above products on Sun-Solaris, HP-Unix and Windows platforms.
• Code had been written in extensive use of Java, JBoss, eclipse, Oracle PL/SQL Packages, Procedures, Functions, Triggers, Perl, UNIX shell script, VB.Net, C++, HTML, and SVN

Confidential, Edison, NJ

Sr. Systems and Software Engineer

Responsibilities:

• Research, designed, developed and maintained two types of “fraud detection Oracle DB modules,” which reduced the online fraud by 22% and the ultimate savings of more than $175 million clients’ money every year.
• Designed, developed and maintained new system procedures which dramatically reduced the network traffic by 70% to upload the high volume of negative data from various card issuers and banks.
• Proposed and designed multiple complex rules transaction processing and Oracle service modules based on the client's requirements, which would reduce the online fraud by 14%.
• Designed and implemented the high-speed real-time data replications including the configuration, between the various databases and servers using ‘Golden Gate’ Real Time data replication software.
• Active development team member in our innovative product “Electronic Payment Processing” system that predicts and prevents the money laundering, bank fraud, credit card fraud and online payment in real time for the merchants. This product is using self-learning “Neural Network” technology, which was developed by a Noble Prize winner Prof. Leon N. Cooper.

Confidential, New York, NY

Sr. Software Engineer

Responsibilities:

• Designed, developed and maintained the new data validation procedures, which became the standard methods for all future data validations and processing for all clients using C++, Oracle, and VB.
• Upload the dirty data and send back the corrected data using a various custom C++ ETL scripts, FTP / SFTP / TCP / IP protocols.