SUMMARY

• 16 years of experience in data management with expertise in implementing Enterprise Data warehouse, Data integration, Metadata management and Data Quality projects.
• 12+ years of experience working for Confidential Bank as a Data Architect and ETL Lead.
• Experienced in full lifecycle projects including Effort estimation, Resource planning, Technical and Process compliance reviews, Risk management, change management, Testing & Defect tracking and Warranty support.
• Good knowledge in AML (anti - money laundering) compliance in risk assessment, Client Types, Financial Crimes Enforcement Network (FinCEN) across multiple business units GCB (Global Consumer Banking), CWM ( Confidential Wealth Management), CCB ( Confidential Commercial Banking).
• Coordinate and facilitate discussion with different levels of personnel ranging from team members, Administrators, Managers and Higher Management including outside vendors, source system, other teams, and document business rules.
• Worked closely with multiple source system in requirement gathering, Planning, Documenting for PPP (Paychex Protection Plan) migration in short span during COVID crisis.
• Specialized as a Techno functional expert in the core development of the enterprise solution using ETL, Oracle Sql, Pl/Sql and Reports.
• Actively involved in DJV Data Journey Validation - reverse engineering in validating CDE (Critical Data Element) with source system.
• Having good experience in deploying Multi-Country Rollouts.
• Practical Experience with different software development Methodologies like Agile and Waterfall.
• Good Exposures in ETL process, Data loading, Data cleansing / correction and creation of reports for Pre and Post ETL process, Slowly Changing Dimensions and Surrogate Keys
• Experience in using various Oracle Client tools such as SQL Developer, Pl/SQL Developer, Oracle SQL plus, Toad in writing Scripts for creating Tables, Large objects (CLOB), Constraints, views, triggers, materialized views, indexes, sequence, tablespace, partitions, Packages, Stored Procedures, Functions, Database Triggers, Functions, Cursors, Bulk, Indexes, Collections, Materialized Views, Query Re-Write for developing applications.
• Experience in using Teradata utilities (BTEQ, MLOAD, FASTEXPORT, FAST LOAD).
• Good Knowledge in Oracle Gloden gate replication concept and worked in environments enabled with Unidirectional and Bi-directional replication and with multiple cross region replication.
• Experience in working with Reporting team to help them understanding the data mart and its standardization and worked with other IT group to make interfaces between the data marts at an enterprise Data warehouse level.

TECHNICAL SKILLS

Databases: Oracle 12c, 11g, 10g, 9i, 8i, SQL Server, MySQL, Teradata (12.0) (Teradata SQL, Teradata Utilities (MLOAD, BTEQ, Fast load, Fast export).

ETL Tools: Ascential Datastage 7.1, Ascential Datastage 7.5.2, IBM Infosphere 8.0, 8.1, 8.5, Abinito

GUI interface: TOAD, Oracle SQL/PLSQL Developer

Data Model tool: Erwin, VISIO, Visual Paradigm, Sql Data Modeler

Operating Systems: Windows, UNIX, Linux, MS-DOS

Web Designing Tools: HTML, XML, XSL

Version and defect controls: SVN, JIRA, GIT, Bit bucket, HP QC, Test director, Remedy

Scheduling API/Tools: Autosys, Maestro and Tivoli

PROFESSIONAL EXPERIENCE

Senior Data Architect

Confidential - New Jersey

Responsibilities:

• Worked closely with business user community to understand business process challenges and identify solution opportunities within Business Intelligence area.
• Managing the Data Migration ETL process starting from data mapping of the source system to data validation in the KYC for various business streams such NAM Stage1, Mexico, Malaysia, CARDs NAM.
• Generate very critical report to Sr mgmt./Business in determining the MCE-Material Change Event like Reactivation of account, FINCEN WI, Client Type, Risk Changes, NTB (new To Bank) and ETB (Existing To Bank) customer
• Design and development of various DB Utilities to support various activities during the data migration such as Data Reconciliation and comparison tool, Data Masking Tool, Bulk update scripts, Data patches, Automated Data Validation Framework, Delete Customer Tool, Data Partitioning, Data Archival and Data Purge Solutions, Process Management and Auditing Framework for ETL tools etc.
• Verifying the data loaded in lower env using the automated data validation tool and reporting issues found.
• Providing project lead and business users to understand requirements, conduct analysis and recommend solutions.
• Translating customer requirements into functional and non-functional specifications for BI reports and applications.
• Used AbInitio ETL tool in designing and implementing business Intelligence solutions.
• Performed thorough Unit testing, System Integration Testing and User Acceptance Testing. Prepare reports and metrics for senior management, Business and Stakeholder.
• Performs data analysis and help business users prepare the mapping documents for data migration.
• Investigate the production issues and recommend solutions such as data patches to fix them.
• Assisting in the development of database and development standards.
• Involved in validating member screening changes in real time and end of batch.

Data Architect

Confidential

Responsibilities:

• ETL Requirement discussion with client, delivery estimation and timeline discussion
• Review functional specification with onshore and offshore teams
• Involve in performance tuning process and identify and tune the queries affecting the performance of the application.
• Involved in understanding input/output tables, necessary file creation, source to target mapping file.
• Responsible for coordination and completion of projects. Set deadlines, assigns responsibilities, and monitors and summarizes progress of project
• Analyze and address production support tickets and periodically prepare reports and metrics for Senior management, Business and Stakeholders
• Adhere the quality process and timelines in delivery of the requirements. Plan Function point estimates for the requirements, schedule and track the activities of the project and team. Appraise the team; educate the team on the technologies used
• Provide technical support as and when needed to the team. Also monitor and perform code review and test case review periodically. Perform Unit testing and System integration testing of the application.
• Development of stored procedures and database functions and modifying SQL code for performance and requirements changes.
• Developing various database components for ETL and Data Warehouse projects involving data migration and data integration.
• Performing regression and reconciliation testing of data integration batch processes for data quality and integrity.

ETL Project Lead

Confidential

Responsibilities:

• Analyzed and identified process that would of differences in data formats in source systems.
• Designed a solution that can be developed in a short period of time and would consume minimum resources without disturbing the existing processes and reports.
• DataStage jobs to perform Abstract Layer Loading, Interim Base population, Interim Supplementary population, Dimension population, Fact population, ORP population.
• Discussing with Business Analyst and Tester/User for the bugs raised in UAT. Helped in understanding technical specification and business queries to user.
• Responsible for preparing the work efforts sheet and assigning work to the team members and ensuring its timely accomplishment.
• Responsible for successful delivery of the application on the scheduled date with least number of defects.
• Conducting defect prevention meeting once in a month within the team.
• Involved in conducting session and validation for the new team members.

ETL Technical Lead

Confidential, Phoenix, AZ

Responsibilities:

• Involved in supporting real time DataStage Jobs.
• Implemented successfully Real time Data loading framework using DataStage, Tibco and UNIX scripts.
• Communicate directly with the Clients for Requirements and other inputs for the Project.
• Conducting the internal and external audit with quality team.
• Involved in the preparation of Test case document. Performed unit and system testing in the dev and test environment.
• Involved in weekend support for critical applications.
• Involved in the technical discussion and the design analysis with the offshore coordinator.
• Involved in bringing down/up the server during database outage

Senior Software Engineer

Confidential - Phoenix, AZ

Responsibilities:

• Changing the oracle specific queries to Teradata complaint.
• Converting all the ETI based loads to parallel jobs in DataStage. This involved handling MVS, SAP and Flat
• Files.
• Developing the Bteq, Fastload, Fastexport and Multiload scripts.
• Involved in understanding input/output tables, necessary file creation, source to target mapping file.
• Proper communication between the Onsite and Offshore teams.
• Interaction with client for gathering requirements and develop accordingly.
• Worked with a record size of around 30 billion.