EXPERIENCE SUMMARY:

• Dynamic and motivated professional with a proven record of generating and building relationships, managing projects from concept to completion, designing strategies, and coaching individuals to success.
• Skilled in building cross - functional teams, demonstrating exceptional communication skills, and making critical decisions during challenges.
• Adaptable and transformational leader with an ability to work independently, creating effective presentations, and developing opportunities that further establish organizational goals.
• Visionary and result oriented Information Technology thought Leader/Solution Architect with over 11 years of Financial and Healthcare domain experience.
• Ability to be creative and take self-initiatives and execute/ manage multiple projects in parallel during time critical situations.
• Expert in strategically designing and implementing enterprise data management programs in the financial services and insurance industries with hands-on expertise in regulatory compliance programs including BCBS 239, CCAR, General Data Protection Regulation and Enterprise Data Management.
• Experience in Client handling and gathering requirements and preparing the requirement documents,
• Served as a IT liaison between Business and Functional areas and the Data Governance Team to implement the Data Governance Solutions .
• Extensively worked on Data Warehousing and Business Intelligence (ETL - Informatica, Reporting - Business Objects) Concepts.
• Good Experience in Release Management Deployments including multiple vendor management.
• Successfully delivered large BI/DW programs in a global delivery model, leading & motivating highly skilled IT professionals.
• Collibra Community Manager, Steward, Developer and Admin Certified by Collibra. Expert in designing and implementing Operating Models. Experienced in Enterprise Meta-Models, Data Management control frameworks, Data Accountability Framework.
• Expert in Test planning, preparing Test Plans, preparing and executing unite test cases, System Testing and Smoke Testing for ETL projects.
• Good Experience in Release Management Deployments including multiple vendor management, handling onsite offshore model teams and working with big teams.
• Completed Project Management Course from Indian Institute of Management Kozhikode.

SKILLS SUMMARY:

Primary Skills: Collibra, Adaptive, IBM IGC, Ab Initio Metadata hub, Waterline data, Alation, Informatica Metadata manager, IDQ

Essential Skills: Data Governance, Data Warehousing, Reporting, Informatica, BO, OBIEE, Groovy, Teradata, Oracle, DB2, MySQL, OBIEE, Oracle - SQL, Data Modelling

Industry & Domain Experience: Banking /, Finance, Healthcare, Labor and Payroll Systems, Sales Forecasting, HR

TECHNICAL EXPERTISE:

Languages: Informatica 9.5.1, OBIEE, Confidential, BO XIR3

Microsoft Technologies: Windows14

Scripting Languages: UNIX, GROOVY, SVN,APPWRX

RDBMS: Oracle, Teradata, SQL Server, My SQL Server

UML Tools: MS Visio, Confidential QC, ZIRA

Source Control Systems: Oracle, SQL Server, Manual Files

IDE: MS Visio 2016Web Servers: IIS, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte

Subject Matter Expert

Environment: Collibra, Ab Initio, Data Quality Portal, Enterprise Data Lake

Responsibilities:

• With a role of Subject Matter Expert understanding the need of Enterprise Data Lake integration with other functional areas.
• Analyzing the gap between existing architecture and integrations and provide solutioning.
• Comparing the Business Metadata & Technical Metadata tools in market and proving consultation to senior management on tools selection.
• Understanding the data flows of different data zones of data lake and requirements to integrate the data quality and data governance solutions.
• Working on Integrated Solution Architecture to collaborate multiple solutions available in the Bank.
• Preparing Enterprise Data Environment Playbook one common guide for all the teams to step by step guidance from SOR ingestion to Reports utilizations in the Bank.

Confidential, New York

Senior Business Analyst/ Team Lead

Environment: Collibra 4.5.4/4.6, JIRA, Oracle, Python, Auto Sys.

Responsibilities:

• With a role of Business Analyst understanding business requirements of wealth management domain in Confidential .
• Build the asset model by creating different asset types, attributes, relationships, complex relationships.
• Publish the Business Glossary across MSWM to provide a common vocabulary of Business Terms and Data Elements to ensure clear communication and increase productivity.
• Structure and classify business terms and data elements based on Data Domain taxonomy, Boundary taxonomy, Context Groups, Criticality, etc.
• Capture synonyms, acronyms, and terms represented in another way and build meaningful relations with the business terms and data elements.
• Capture Business Rules, Data Quality Rules and Policies for all the Business Terms.
• Data Quality Score from MS Data Quality Platform will be exported to Data Governance Portal.
• Issues information will be collected for tools like Service Now and displayed on to Data Governance Portal.
• Visualize the various assets in DGP and analyze impact.
• Establish an asset-relationship model.
• Provide dashboards to Stewardship to support them with their tasks.
• Define ownership structure within the Data Governance Portal.
• Define and automate the tasks and responsibilities for Stewardship.
• Automate the execution of governance and stewardship tasks by workflows.
• Single resource in the team to create all the customized workflows as per the requirement.
• Handled end to end release for first collibra implementation in MS from Development environment to Production environment.
• Create all workflows with unit testing and all testing documents and the design documents for the project.
• Handling interim releases independent with direct client involvement and suggesting them solutions to build the new relationships and workflows.
• Provided demonstration of the tool in Tech expo event in Confidential and demonstration the client for all the developed workflows and the asset model in Collibra.

Confidential, Connecticut

Senior ETL Developer

Environment: Windows7, Informatica 9.5.1, SQL Server

Responsibilities:

• Building a Data Warehouse and integrating all different components in Confidential .
• Involved in creating mapping and scheduling the data loads.
• Created mappings and mapplets based on new requirements.
• Transformations like Source Qualifier, Lookup (connected & Unconnected), Aggregator, Expression, Update Strategy, Joiner and Union are used.
• Writing View for creation of New BO Reports wherever applicable.
• Identifying the error records and updating the error data using Informatica mapping.
• Analyze source data, source data was coming from flat files, Oracle database.
• Extensively used Informatica Tools- Workflow Manager, Workflow Monitor to load data from Oracle OLTP sources into Target oracle 9i Data warehouse.

Confidential, Norwalk, CT

Onsite ETL Testing Lead

Environment: Windows7, Informatica 9.5.1, Oracle 11g, Confidential QC, Confidential

Responsibilities:

• Provide a unified infrastructure for addressing their Enterprise Risk regulatory requirements.
• Customize the Oracle LRM solution per Confidential requirements to address the US Federal Reserve guidelines for Liquidity.
• Build a reconciliation solution to reconcile their monthly balances and cashflows.
• Enable periodic reporting of the Liquidity status per regulatory norms.
• Allow end users to perform adhoc reporting on Liquidity status based on their security profile.
• Configure an automated solution for data adjustments and capture audit log of these changes.
• Enable Confidential to easily configure the solution to address Liquidity specific regulatory changes they may occur in the future.
• With a role of ETL Testing Lead understanding business requirements of different domains of Confidential Capital(LRM,IRIS) and establish the testing strategy for EDW (Enterprise Data Warehouse) on which OBIEE Reports needs to be displayed. Making use case designs and doing wing to wing product testing from source to functional reports. Testing the ETL code and writing technical test cases and executing them in Confidential QC to make sure data loaded in Confidential from multiple sources like TDP, MDM, Manual Files is meeting business requirements and referential integrity rules as per Data Modal. Smoke Testing, Stress Testing, Performance Testing and System testing before the code designed by the Development teams delegated to Production Environment. Set accountabilities for the design, implementation, monitoring, and enforcement of policy, standards, or requirements for testing.
• Co-ordinate with global Confidential configuration delivery team to report issues with various Confidential environments (Dev, Test, etc.).
• Coordination with architecture & ETL teams for ensuring successful delivery.
• Hold workshops with IT & business to gather and document non-functional requirements.
• Help Business Analysts to test FTP, LRM & PFT modules - write/modify SQL codes, T2T, debug/fix issues
• Help Business Analysts to configure data entry forms /excel upload template and data mapping.

Confidential, Milwaukee, WI

ETL Development Lead/Project Lead

Environment: Windows7, Informatica 8.6.1, Teradata 13.0, Cronacle, Oracle, QC, SVN

Responsibilities:

• With a role of Team Lead gather business requirements of different domains of Confidential Healthcare and establish the design of EDW (Enterprise Data Warehouse) on which Reports needs to be displayed. Developing the ETL code and BTEQ Scripts to load the data in ODS and EDW.Doing unit/system testing before delegating the code designed by the team to Final ODS/EDW. Creation of new interface mapping sheets from Source Side (Siebel) to Teradata DB for the offshore team to work on.
• Holded the soul of the project without a dedicated project manager and fitted in Project Manager Role in crucial phase of the project.
• Involved in designing the architecture for the application with onsite Architect.
• Involved in Release Management - Dev to QA, QA to Production Environments with multiple vendor involvement.

Confidential

Onsite Team Lead

Environment: Windows 2000, Informatica 8.1, Oracle 9i, Clearcase

Responsibilities:

• With 6 months onsite experience handling all business gathering and with a role of team lead developing the ETL code as well as distributing the ETL work to off shore team and doing system testing before delegating the code designed by the team to Final SAP.
• ETL Development for the multiple modules like HRA, Sales, Master Sales.
• Understanding requirements form BSA and writing technical documenting for offshore team.
• Monitoring and Scheduling the Loads.