SUMMARY:

With proactive thinking, hands - on enterprise Data leader, Data Governance, Advanced Data Analytics, Master Data Management and ETL Solutions Architect for large scale Operational and Data Warehouse implementations and Applications. Extensive large on/off shore teams management, leadership, negotiation, vendor management and technical skills with "can do attitude”. Enterprise infrastructure & software design, deployment and on-going production support using both agile & waterfall SDLC for large scale programs and Project management. Strong problem solving skills and proven track record of producing high value results in Financial Services and technology industries. Extensive expertise in partnering with executive IT & Business management, internal teams and vendors to drive technology and business initiatives to deliver enterprise scale solutions.

TECHNICAL SKILLS:

RDBMS and 4GL’s: Teradata; Oracle; Netezza;DB2, Microsoft SQL*Server; Erwin, PowerDesigner; Oracle Enterprise Manage; TOAD; Oracle Golden Gate Replication; IBM DataStage; Informatica PowerCenter; Informatica IDQ; Siperian/Informatica MDM ; IBM InfoSphere MDM, Talend MDM; SAS

Operating System/Hardware Platforms: UNIX (Sun OS, Solaris; Linux); Mainframe; Windows; Veritas Cluster Server, Veritas Netbackup

Programming: Python;PL/SQL; SQL; SQL*Forms; JDeveloper,SQL*Developer; Bourne Shell; C Shell; Korn Shell; Awk; Sed; Cut; Join; Perl; Microsoft Visual C++; Microsoft Visual Basic; Java; NoSQL ; Hands-on Cloudera Data Analyst Training using Pig, Hive and Impala with Hadoop

Core Skill Set: Large Teams & Vendors management;Risk Management; Project Management; Software Development LifeCycle; Change Management; On/Off Shore large teams management; Data Science; Enterprise Architecture; Data & Database Architecture; IT Projects Design and Development; Conceptual, Logical and Physical data modeling; Logical and Physical Designs for Operational Data Stores and Data Warehouses;

WORK EXPERIENCE:

Sr. Director - Head of Data Management & Development

Confidential

Responsibilities:

• Built a motivated, self-sufficient and trustworthy data management team.
• As valued leader—provide employees with the autonomy to do their work well while building strong, personal relationships in order to improve communication as well as advance business development efforts.
• Proactive team-based management style that gains employee confidence and utilizes their talent and knowledge.
• Direct communication with CxO to translate complex and technical solutions and challenges in precise but easy to understand manner.
• Conceptualized and implemented business strategies for Operational Data Management, Data Warehousing, Customer Master Data Management, and Business Intelligence that improved operational efficiency, enhanced visibility for effective decision making, and targeted business growth.
• Defined and executed organizational roadmap for multi-year IT transformation program for data strategy and consolidation for operational efficiency, minimized data redundancy and enhanced data quality by defining and implementing data governance standards & Operational policies framework.
• Led implementation of Business Intelligence Competency Center(BICC) in collaboration with various business units at AlRajhi Bank to define data governance policies and prioritization of development initiatives to streamline demand/supply of projects and programs.
• Led the effort to collaborate with business units & source system SMEs to identify Data Trustee, Data stewards and Data Custodian for data subject areas(Client, Account, Transactions, Products etc.)
• Data assets within each datastore are mapped to an authority classification (System of Origin; System Of Record, Authorized Data Source).
• Data Quality rules were defined and documented to get them implemented via Data Quality Tool.
• Led and managed end-2-end SDLC of enterprise wise development initiatives, data integration programs from various source systems into Teradata EDW to consolidate data from departmental data iselands for advanced Analytics, internal and regulatory reporting needs with consistent, reliable, accurate and timely data.
• Performed source systems Data Profiling to identify Functional Dependency, Referential integrity and Data Attributes level analysis to ensure Data modeling exercise accounts for possible scenarios for incoming data feeds.
• Consolidation of data from various onsite and regional databases into an Operational Data Store (ODS) for real-time/near-real-time data access for consuming applications and to minimize workload on Operational source systems.
• Defined scope and led execution till delivery for multiple strategic data projects around Compliance and Risk business areas. Managed multiple vendors for successful, on-time & on budget delivery of the projects.
• Fulfilled data needs for various regulatory projects like Confidential modules, Monitoring of Current Account, Credit Card and Express Remittance transactions for Confidential / Confidential ; Risk Assessment of Customers; Fraud Management.
• Led Customer Centricity Program(CCP), Campaign Management and Customer Loyalty programs to provide Advanced analytics reports and Dashboard to CxO management based on customer and products segmentation and micro-segmentation for targeted marketing resulting in up/cross sell of products & services.
• Performed OPex and CAPex budgeting exercise and management of budget for Data management department for development and operational maintenance.
• Implemented Data Glossary to help define common definition of data elements for all business units.

VP Information Architecture

Confidential, Delaware

Responsibilities:

• Managed team of 30+ on/off shore Information & solution architects for Consumer Community Banking Department of Confidential Auto & Confidential .
• Defined &established target state Enterprise Data Architecture platform after review of current state and bridging the gaps.Provided data architecture and application development teams access to set of best practices, tools and processes utilizing Zachman and TOGAF methodologies. Incorporated both business and technical needs into defined practices.
• Led high profile Advanced Analytics initiatives for Auto and Home Mortgage businesses to increase market share for the bank by targeted marketing for potential customers and by simplifying and enhacing application processing procedure for such clients.
• Collaborated with business units to define & implement data quality rules and standards for sourcing, provisioning and presentation of data to provide operational and development efficiency.
• Consolidation and integration of data from various disparate data sources into Oracle Enterprise Data warehouse for client and business facing applications.
• Led effort to define requirements for data visualization tools and collaborated with IT teams during proof of concept efforts. Provided data visualization platform to business for canned and self-serve reporting capability leveraging EDW.
• As voting member of CCB data review board, defined and implemented process to review application architecture and data sourcing and consumption strategy for all strategic and tactical initiatives.
• Collaborating with business analysts, data stewards and development teams on run-the-bank and change-the-bank related tactical and strategic initiatives.
• Led effort to compile comprehensive inventory of Auto and Mortgage banking datastores. Data assets within each datastore are mapped to data classification (Customer, Product, Compliance, Risk etc) and an authority classification (System of Origin; System Of Record, Authorized Data Source) is assigned. This strategic initiative is to ensure that data is sourced from authoritative and approved source systems only to avoid point-2-point delivery of data for consuming application needs.

VP - Data Architecture

Confidential, New York

Responsibilities:

• As VP of Global Risk Technology organization within Confidential, provided strategic roadmap and led execution of multiple high profile strategic data initiatives
• Managed a team of 15 on/off-shore data architects and developers while collaborating with a large cross-functional team of business analysts, data stewards, DBAs, system admins and Project managers to ensure milestones and deliverables are meeting scheduled delivery dates within allocated budget.
• Worked closely with executive management and steering committees to update them on accomplishments, roadblocks and upcoming milestones on highly technical matters in business understandable language.
• Detailed study of current data platforms to understand technical and business challenges identify opportunities to propose short term and strategic solutions that align with business needs and vision.
• Defined standards and policies for data acquisition, data modeling, history retention, data provisioning, Metadata, Reference data and multi-domain master data.
• Designed and implementedstrategic end-2-end solution to consolidate Master and associated Reference data from disparate source systems into an Operational Data Store(ODS) using ETL, IBM InfoSphere MDM, IBM Reference Data Management(RDM) to provide contextual, consistent, accurate and single version of truth data for reporting needs and consuming systems.
• Influenced partner IT and business teams to get their buy-in and commitment for enhanced Data Quality and Data Governance initiative.
• Collaborated with Data Steward Executives, Data Domain experts and Data stewards to compile Key Business Elements list and associated definitions for each data element.
• Adopt and promote Agile methodology to provide business continuous incremental functionalities via sprints.
• Vendor management, resource & capacity planning, strategic data platforms adoption by current systems and decommission strategy for legacy systems after migration.
• Led an initiative to evaluate functionality and integration of BIG DATA using Hadoop, Sqoop, Hive and Impala with Enterprise Data warehouse for enhanced Data Analytics and Reporting around structured, unstructured and semi-structured data.

Director -- Data Architecture Operational Data Store and Enterprise Data Warehouse

Confidential, New Jersey

Responsibilities:

• Wealth Management Technology organization fulfills technology needs of Confidential to become best wealth management firm in the Americas by delivering right IT solutions at right time at right return on investment, in-line with target state architecture to empower our clients and evaluate organization’s leadership position.
• Architected interfaces to Temenos T24 Core Banking System to fetch information on Demand Deposit Accounts for Confidential reportings.
• Migrated Temenos T24 Oracle backend and IBM InforSphere application server layer to Oracle RAC and multiple JVM instances respectively.
• Managed development and customization of periodic and adhoc Client Valuation and Confidential reports on T24 Core Banking System.
• Directly managed and led Data Architecture on/off shore team to analyze source and consuming systems of market and associated reference data to integrate data into Operational Data Store to address data inconsistency, data redundancy and data quality issues along with reducing CTB and RTB costs.
• Performed analysis of current data platform and presented target state architecture of data platform to adress stability, data redundancy, data quality and data governance related issues.
• Promoted the culture and mindset within immediate and partner IT & Business teams to consider Data Profiling, Data Integration and Data Quality as closely related and key pillers to effective data governance.
• Defined data governance framework for financial and reference data.
• Prepared and presented business cases to provide cost-benefit and ROI analysis for strategic initiatives like Data Governance and Master Data Management (MDM) for Client and Financial Instrument (Products) data.
• Proposed business case, initiated new project to implement IBM Infosphere MDM solution to align business focus from Product centricity to Client centricity.
• Installed and configured IBM MDM using IBM Websphere as application Server.
• Defined Party/Customer and Product data models for landing, staging and base objects to implement Informatica MDM solution for Party and Product Hubs.
• Installed and configured Informatica Data Director (IDD) for business users & data stewards to view and manage MDM data for data governance related needs.
• Using agile methodology defined and communicated scope of each sprint to business and partner IT teams. This helped both business and IT teams to prioritize their requirements and also assess impact of upcoming release on current data and application landscape.
• Prepared business case to migrate EDW from Oracle to Teradata that included impact on current processes/applications, ROI and how restructuring of EDW will help revive business’s confidence on EDW data.
• Led effort to collaborate with business and power uses to understand their analytical reporting needs and analyzed data available in EDW to determine data gaps so that needed data can be fed into Oracle and Teradata platform EDW and Data Marts.
• Using IBM Information Analyzer(IA) and IBM Rational Asset Analyzer(RAA) performed in-depth data analysis and applications review to discover application structure, embedded business rules, relationships, inter-dependencies with databases and processes for legacy applications which are to start using Operational Data Store for consistent unified data.
• Using Teradata FSLDM as an accelerator, developed flexible logical and physical data models for Positions, Balances, Transactions, PARTY, Products, Asset Classifications, Liabilities, Household(Accounts Grouping) etc, to meet current and future growing business needs.
• Mapped captured data attributes to columns in physical data model to define ETL process flows.
• Produced business requirement (BRD), functional specifications (FSD) and non-functional documents for Operational Data Store.
• Collaborated with stakeholders at all levels to define and implement physical database design and associated processes.
• As pivotal member of Data Governance team, identified and reviewed data inconsistencies with business owners to gain sponsorship from business for data governance initiative.
• Defined and implemented enterprise wide guidelines, standards and principals for Data modeling, Metadata management, data provisioning and data quality.
• Implemented CA Confidential to maintain versions of data models for collaborative development.

VP -- Advanced Analytics - Master Data Management

Confidential, New Jersey

Responsibilities:

• Client & Account Data technology organization under Global Wealth and Investment Management provides business intelligence, architecture, strategy, governance, data integration, and data delivery services to GWM leadership and all the business areas. The group supports all the key systems and processes related to client and account data. The group is focused on enriching the analytical and decision support capabilities in the areas of customer and marketing segmentation, financial advisory, product profitability, core financial metrics, compliance and risk metrics.
• Had the opportunity to be part of Client & Account Data technology team from the beginning to participate both as a leader and individual contributor to collaborate, influence, negotiate and gain commitment from multiple stake holders and partner teams onshore and offshore to ensure successful implementation and deployment of initiatives like Siperian/Informatica Master Data Management to present best version of truth of data coming from multiple source systems, MyMerrill, ML Direct, NFS conversion and California/NW conversion.
• Analyzed data from multiple source systems, business requirements and business needs to design data flow and associated ETL jobs.
• Designed and enhanced processes to stage, load, match & merge client profiles based on cleanse and matching rules.
• Defined guidelines, best practices and principals around Data integration, Information Architecture and ETL processing.
• Defined guidelines, best practices and principals to manage and secure client sensitive data within Siperian MDM. Reviewed business requirements for strategic and tactical changes to define and manage Metadata, Reference and lookup data. Analyzed and managed impact on reference and master data due to changes in business and regulatory requirements. Managed characteristics of referential data particularly related to client facing business critical applications.
• Provided end to end strategic solution for Data Warehouse and associated processes, for enterprise level Advanced Analytical needs around Client & Account Data.
• Collaborated with business and development teams to define requirements and implementation details to feed Client and account data from Informatica MDM HUB to warehouse via ETL.
• Structured and Unstructured Data management. Implementation of XQuery and Oracle Text Search.
• Led migration of IBM Datastage Jobs from Windows platform to Datastage 8.5 on Linux platform.
• Implemented IBM InfoSphere FastTrack for Source to Target mappings for data cleansing.
• Managed and maintained metadata repositories, metadata modeling, data mappings, conceptual, logical and physical data models, modeling guidelines and principals to ensure data integrity, 360 degree view of client data and hierarchy relationship management while maintaining application performance.
• Defined Metadata Integration Strategy for the Client and Account Data Initiative including software evaluation and information integration and management. Organization of data content and context, existing data models, data flows, data dictionaries into a Metadata Repository. Designed a conceptual model as an architecture migration target and developed procedures and guidelines to map this model to the database architecture to facilitate information location.
• As Lead Siperian/Informatica MDM solution architect for database and ETL platform, forecasted long-range implications of current strategies, promoted strategic thinking to implement integrated and high performance architectural solutions in complex multi-platform environment.
• Configured, tested and implemented Oracle Golden Gate replication in Performance, QA, Production and DR DB environments to provide high availability and to offload backups and adhoc users/reporting related workload from primary node. Successfully implemented Golden Gate replication for data migrations and “Dark Pod validations” during scheduled business functionality releases.
• Migrated Oracle Database MDM platform from SUN Solaris to 3-node Linux platform using Veritas Cluster to manage failover for unscheduled outages. As part of same initiative, migrated Oracle RDBMS from 10g to 11gR2 using ASM (Automatic Storage Management) and migrated Siperian/Informatica from XU-SP2 to 9.0.1. Defined, tested (functionality and Performance perspective) and implemented Data Migration Strategy for this cross platform migration.
• Led and managed on and offsite Siperian/Informatica engineering teams to prepare/review requirements, design, implement and successfully deploy as a major milestone for GWIM technology to gain “Zero Down Time” during scheduled business releases to avoid downtime for clients.
• Prepared and presented business case and plan to address unscheduled platform outages impacting client experience. Collaborated with GWM Architecture, design and other partner teams to present, review, negotiate and finalize hardware/software design to implement 3-node Oracle Real Application Cluster (RAC).
• Engaged and worked closely with “Performance Engineering” (PE) and QA teams to conduct stress testing to identify and resolve performance bottlenecks within Database, application and associated platforms/tiers.
• Reviewed batch and ETL jobs to identify performance bottlenecks and implemented software/hardware architectural solutions to gain outstanding improvements in processing time. Batch cycle was reduced from 10 hours to 6 hours because of performance enhancements.
• Led an initiative partnering with Enterprise Security team to identify, plan and remediated violations per new Bank standards and guidelines for entire GWIM Data platform.
• Reviewed, approved, and managed promotion of database related changes for business functionality releases throughout lifecycle of releases. Reviewed release deployment plan, determine associated risks, failback plans and provided visibility to senior management and partner teams to gain buy-in and support.
• Identified and resolved Microsoft SQL Server DB related performance issues for business critical, Enterprise Account Opening application and currently working on migration of SQL Server DB from windows 2003 & SQL Server 2005 to windows 2008 & SQL Server 2008 on new hardware.
• Built knowledgeable, dependable and committed team both onshore and offshore to ensure support for 24*7 business critical data platform. Worked with partner teams to define and implement run-books and escalation procedures to ensure enhanced client experience for Client Facing Applications.

Sr. Manager- Data Architecture

Confidential, Tennessee

Responsibilities:

• Confidential provides research-based, standards-aligned technology solutions that improve student performance and teacher productivity. Featured product of Confidential, Confidential award winner “Yearly Progress Pro” is a research-based, assessment, instructional and intervention tool to provide teachers and administrators specific frequent feedback on students’ progress to ensure that instruction is aligned to national and State standards.
• Led large scale complex data management initiative to build Oracle Data warehouse.
• Co-ordinated among management, business and development teams to gather requirements, build project plans, identify suitable resources, and manage issues resolution to ensure delivery of data warehouse and development of reports for business and senior management users.
• Reviewed and enhanced existing logical and Physical design of databases for data integrity and performance.
• Defined standards for data modeling, data standardization, data quality and coding practices. Ensured compliance to defined standards by collaborating with development teams.
• Revised PL/SQL backend code to improve I/O activity and database memory management to dramatically improve the application’s performance.
• Provided data models and data maps (extract, transform and load analysis) of the data marts and source systems. Led initiative to design and implement Metadata Repository to provide a centralized information source for the data models, data maps, data dictionaries and processes.
• Used Erwin dataModeler to create ER diagrams for all existing and new database designs.
• Revised PL/SQL backend code to improve I/O activity and database memory management to improve the application’s performance and database resources consumption.
• Led an initiative to review ETL processes. Identified appropriate Systems of Records to feed data warehouse from authoritative sources only to address data quality issues. Updated metadata repository with new process & data flow diagrams.

Manager- Database Administration/Architect

Confidential, New York

Responsibilities:

• Started working with Confidential as a consultant to server as Oracle resource for database administration and application development using PL/SQL and JAVA. Joined Confidential as permanent employee on March 03, 1998.
• Confidential, the energy information and market services unit of the McGraw-Hill Companies, is the world’s largest and most trusted provider of news, analysis and Price discovery for the oil, natural gas, petrochemical, coalelectricity, nuclear power, shipping and metal industries.
• Mentored and directly managed team of two DBAs and a data analyst.
• Collaborated with both development and business teams to define business requirements, high and low level design documents around data and database platform related initiatives and managed delivery of the projects.
• Played pivotal role in defining & presenting business case for migration of database platform and enhancement of associated data management processes from Oracle 8i on Windows platform to Oracle 9i on Sun Solaris.
• Managed and executed platform migration plan for successful delivery of project on-time and within budget.
• Redefined logical and physical design of Confidential ’ Price Database using Oracle’s partitioning option (version 9i) to manage business critical data more efficiently.
• Designed and implemented Master-to-Master Oracle Advanced Replication, for Price database to setup failover strands at remote data centers for high availability.
• Developed and implemented UNIX and PL/SQL scripts for database and operating system security, for production systems.
• Led and executed logical and physical design for Platt’s web based applications and their integration with multiple databases.
• Designed and implemented Oracle 9i database design for Confidential ’ Portal site. Multi-master symmetric replication was used to bring high availability and throughput to this 24*7 mission critical web based application.
• Implemented DataGuard and Standby Database concept for web based applications for high availability.
• Real Application cluster (RAC) technology was implemented on 64 bit Linux to introduce High availability for 24*7 Oracle environment.
• Setup Oracle Enterprise Manager (OEM) to monitor all production and development systems.
• Created ad hoc reports using PL/SQL, Java Stored Procedures and Oracle Reports.