SUMMARY:

• A seasoned Business Intelligence Technology Leader with extensive experience delivering Enterprise Data Warehouse solutions in Financial and insurance Industries. An industry expert with both technology expertize as well as domain SME knowledge on financial functions like AML/KYC, Single view of Customer across Channels, Customer Privacy, Trillium household matching process, Basel risk reporting, Central transaction operations (CTO) and Integrated voice response (IVR).
• More than 18 years’ experience in designing and delivering large scale Data stores on varied platforms like Teradata, Oracle, DB2, and Big data.
• Hands on technical experience with varied technologies including Abinitio (3.0.2), Informatica (9.x), Teradata (13), Oracle, DB2, SAS, Hadoop Big data, Mongo, Elastic, Cognos, Micro strategy, Tableau, Control M and Maestro (TWS).
• Manage the compliance and audit related tasks which include complete risk assessments, DR (Disaster Recovery) setup and work with risk managers to identify and close any risk related issues. Worked with different Lines of Business customers and App Dev teams on wide variety of Control Self - Assessment activities for one of the largest Teradata Installations, ICDW (Integrated Customer Data Warehouse).
• Managed a global team of about 30 + developers in delivering a portfolio of about $15MM in 2016.

CORE COMPETENCIES:

• DW/BI Roadmaps
• Strategic Planning and Leadership
• Project Planning/Execution
• Hadoop Based Analytic environments
• Hands on experience on Multiple ETL tools and databases.
• Hot and Cold data archival strategy
• Performance Management
• Change Management
• Training and mentoring team members
• Total Quality Management
• Productivity and Efficiency Improvement
• SME in multiple subject areas
• Agile Delivery

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

Integrated Customer Data warehouse - Data Management & Analytics

Responsibilities:

• Designed and architected 90+ AML projects and supported 56 BCBS reports (Basel reporting) in last 2 years.
• Responsible for compliance and audit related tasks which include complete risk assessments, DR setup and work with risk managers to identify and close any risk related issues.
• Cold data archival into HDFS from Teradata as part of the space reclaim in Teradata platform.
• Ingested multiple source data into HDFS platform and developed an ETL and reporting layer for the end user analytics.
• Project estimations, budgeting, and resource allocations and monitor the project.
• Involve in every phase of Project (Requirements, Design, Architecture, Data Modeling, Development, QA and Implementation).
• Guide the team in technical design discussions and involve in resolving the complex problems.
• Hands on experience in Ab initio, Informatica, Teradata, Oracle, DB2 and Control M.
• Experience with Erwin Data modeling and ETL Solution data architecture.
• Manage multiple data marts (AML/KYC, Basel risk reporting, Compliance, Customer data marts).
• Allocate tasks to project team and monitor quality and timeliness of deliverables.
• Conduct performance reviews, appraisals and personal development planning with team members.

Environment: Cloudera Hadoop, Hive, MapReduce, Abinitio, Informatica 9.x, Teradata V13, DB2, Erwin Data Modeling, Control M, Trillium, UNIX, TWS, SEAL, JIRA and ALM.

Confidential

Responsibilities:

• Allocate tasks to project team and monitor quality and timeliness of deliverables.
• Played the SME role on Customer, Prospect data mart, and Compliance data marts.
• Involved in Project design, development and implementation activities.
• Responsible in managing the Trillium matching process, postal updates for the customer geo location accuracy.
• Involve in every phase of Project (Requirements, Design, Architecture, Data Modeling, Development, QA and Implementation).
• Communicate project status and issues for resolution to all stakeholders
• Managing scope and project costs to ensure budget adherence
• Conduct performance reviews, appraisals and personal development planning with team members.

Environment: Abinitio, Db2, Control M, Trillium, UNIX, TWS

Confidential, Columbus, Ohio

ETL Development Team Lead and SME

Responsibilities:

• Responsible for delivery of design documents and build for all new interfaces and enhancements for existing interfaces.
• Designed and developed for multiple complex Informatica mappings, Teradata BTEQS, Micro strategy and Maestro scheduling jobs for this project.
• Resolved complex issues in development.

Environment: Teradata, BTEQS, Teradata Utilities, Informatica (8.6), UNIX and Maestro.

Confidential

ETL Lead developer

Responsibilities:

• Designed and developed the complex Informatica mappings and Oracle PL SQLs.
• Served as ETL systems specialist as well as Informatica Administrator.
• Mentors junior development team members.
• Coordinate with offshore team for resolving issues and deploying application.

Environment: Informatica (8.6), Oracle, Cobol-II, UNIX and Maestro.

Confidential

Responsibilities:

• Actively involved in preparing the High level specs, low-level specs, coding application programs per the requirements, unit testing, System testing of Homeowners, Mobile Homeowners, Boat owners, Inland Marine and Fine arts.
• Responsible for design and the architecture of the rating tool.
• Responsible for working with other team managers to establish effective system integration architecture for integrating information from one part of the application to another.
• Mentors and assigns work to development team members.
• Developed the rating modules by using the Pricing Applications for all LOBS.

Environment: Pricing Tools, MVS/ESA, Cobol-II, Assembler, JCL and Oracle.

Confidential

Responsibilities:

• Involved in the high level design, preparation of low level specifications,
• Developed new Cobol modules as well as modify the existing programs as per the requirements and change requests
• Resolved complex recon issues.
• Involved in all phases of the project.

Environment: Cobol-II, JCL, IMS DB/DC & VSAM.

Confidential

Agent Automation

Responsibilities:

• Actively involved in preparing high level designs, low level specs.
• Developed the online COBOL screen modules for Confidential quotes, New Business and Enquiry/changes.
• Testing was done in MF COBOL environment using animator tools.

Environment: COBOL -II, JCL, IMS DB/DC & VSAM

Confidential, MA

Responsibilities:

• Actively involved in preparing low-level specs, coding application programs per the requirements, unit testing, negative testing and integration testing.

Environment: COBOL -II, JCL, IMS DB/DC & VSAM