SUMMARY

• Strategic thinker with broad, deep understanding of financial services, risk & compliance, and technology.
• 20 years of experience in strategy consulting, credit risk management, data management, and program management, and 10+ years in the financial services industry working on Risk and Regulatory.
• 10+ years of Data Management & Delivery experience in implementing Data Strategy, Data Standards, Policies, Reference Data, Master Data Management, Data Quality Management, Lineage, Metadata Management, Remediation, and Advanced Data Analytics,
• Strong Leadership skills, technical background in Data Architecture, Data Models, Data Analytics, Modeling, and Financial Fraud Analytics, and managed large Data Warehouse and Web Analytics infrastructure.
• Exceptional analytical and problem - solving skills, and experience applying these skills to resolve application design considerations and technical issues.
• Worked extensively on Scope Definition, Business Requirements, Functional Specifications, Business Process improvement, Architecture, Change Management, Impact and Gap Analysis and Applications Service Management.
• Experience in implementing ITSM Model (ITIL) for Service delivery management for large set up in HP
• Worked on Financial, Credit Card, Healthcare, eCommerce, Retail Applications and Semi-Conductor companies.

TECHNICAL SKILLS

Management Skills: Project Management, Risk Management, Customer Management, Requirement Management, Budgeting and Effort Estimation for Software Development (SDLC / Agile), Testing/QA Process implementation.

Database Skills: Oracle, Teradata, SQL Server, SAS, MySQL, Data Modeling, Data Migration, Designing STAR Schema, DB Procedures, Triggers and Packages, ERWIN and DB utilities, DB tuning, SQL Query Tuning, DWH Capacity Planning, UNIX Shell, Perl scripts

Tools: and Languages: Informatica (9.x/6.x), IBM Infosphere/Datastage, OBIEE, Microstrategy, Cognos, Tableau, Business Objects, MDM Hub, Data Quality, HyperRoll Cubes, SQL, PL/SQL, T-SQL, Control-M, Maestro and Tidal scheduler, Developer/2000, Webservices Tibco, ClearCase, PVCS, Harvest, VSS, Ms Project, Planview, Project Workbench, Niku-RPM and Primavera, Sharepoint.

PROFESSIONAL EXPERIENCE

Confidential

Governance Strategy & Analytics Manager

Responsibilities:

• Responsible for implementing Data Management to all LOBs and Systems (SORs). Enforce, and monitor the compliance with Enterprise Data Governance framework Processes, Policies and Standards.
• Managed monthly data feed, external data, and implemented Basel (BCBS 239), Stress Test, BSA, AML, FATCA and related regulatory processes across critical systems to ensure compliance with policy and standards.
• Established and managed the 3year roadmap on Data Lake integration, reference data, domain analytics and rolled out .
• Worked on the creation of Customer Master Legal Entity of Wholesale and responsible for Data Strategy & Integrity
• Established the Insurance Data Council and Lead it to drive remediation ensure data accuracy and compliance.
• Using machine learning model performed clustering of customers to predict financial scores for Segmentation and Credit decisions strategy. Also created models for Insurance to identify revenue opportunity.
• Text-mined emails, log-files on the compliant database to identify customer issues with products and address issues.
• Created partner analytics/reporting & BI dashboards for Risk, Regulatory, Customer-360, Compensation Metrics, and other KPIs measurements. Also provided analytics on Loss, Forecast and Variance, and Budget analysis
• Created various DQ Control Dashboards, Scorecards, to perform Qualitative Analysis on SOR and LOB data against different thresholds to measure data integrity for Credit and Profit View data.
• Created Financial Crimes Analytics for suspicious activity reports and Fraud Prevention Analytics from the actionable intelligence using data visualization and insights for AML and various other Risks.
• Established various Master data (Customer, Products, Org) to produce consistent analytics within LOB and Enterprise.
• Evaluated all the (60+) systems to create the Data Strategy, and came up with Solution, Platform, Tools and Technologies recommendations for a Strategic Analytical platform, along with Data Integrity & Metadata processes.
• Established and Data Quality and Remediation process to manage regulatory reporting in compliant with Regulatory Council.
• Created SalesforceCRM Marketing Analytics on Tableau for self-service among the sales managers about leads.
• Responsible for promoting Governance, Quality, Lineage and educating Data Stewards.

Environment: Oracle, Teradata, Informatica, SQL Server, SSRS, SAS, Tableau, SQL, R, Hadoop, Hive, Salesforce

Director

Confidential

Responsibilities:

• Led a team to develop new analytics products platform for metrics, and scorecards for actionable insights, and depict the portfolio view of investment assets for profit-loss, periodic position etc.
• Assessed the Wealth Datamart environment for various operational issues, and SLA impacts to business. Identified Critical path to keep business running and improve performance, data quality and reliability of data for Investment Managers. Improved business process and support processes to bring resiliency into the system.
• Implement the process improvements by isolating critical functions from other lower priority processes for on-time availability of IM Dashboards during trading and operation hours. This resulted in 40% improvement in the IM Dashboards performance and it has been highly appreciated at CTO/CIO of Wealth and Trust Management Group.
• Delivered the assessment of the Data Strategy and Analytics platform solution of the Trust Services group. Implemented the business process fixes, technical fixes such as ETL bottlenecks, effective early alerts, notifications and server HW problems for optimized performance.
• For Trust Datamart, conducted a strategic assessment of Data environment and architected a Real-Time Data warehouse solution. Provided evaluation of various ETL, BI tools for the new BI platform creation.
• Gathered the requirement for building the BI platform. Identified and defined key SORs, H/W platform requirements, reporting metrics and analytics, metadata management and other value-added initiatives.

Environment: DB2, MySQL, SQL Server, Oracle, Informatica 9, OBIEE, MsProject

Informatica, Analytics Consultant

Confidential

Responsibilities:

• As an Analytics Manager, implemented marketing analytics to convert leads from social media data into Sales.
• Created Marketing Analytics from CRM systems on Tableau for self-service mode among the sales and analytics managers
• Designed and rolled out 10+ market analytics and sale pipeline reports across European user base, and fixed system-wide data quality issues, and provided Technical solution recommendations.

Environment: Oracle11g, SQL Server, Informatica 9, MicroStrategy, Tableau, Hadoop (big data), Hive, Salesforce

Confidential

Analytics Project Manager

Responsibilities:

• As an IT Analytics PM, managed multiple complex projects of Confidential .com such as AAA Entitlement Framework for Financial Crimes and Fraud Analytics and Prevention, Oracle R12 Country Enablement, Hierarchy Security Access Management, Unusual Financial Activity Reports and Fraud Prevention Analytics.
• Implemented Crime and Risk analytics from high value orders, tracking suspicious activities, spikes and shipments
• Created tactical and strategic architecture for managing Identity and Access solutions of Confidential . Executed access solution projects based on Central Profile Repository (CPR) and Customer Registry (MDM) for new acquisitions.
• Architected a next generation of dynamic fine-grained access management platform using Confidential Enterprise Policy Manager (CEPM) for One Confidential Sales hierarchy (OSH), this will drive the access control of several OBIEE implementations.

Environment: Oracle10g, Teradata, SSIS, Web Services, OIM, OAM, OBIEE, Hadoop (big data), Hive, Analytics

Confidential

Senior Project Manager

Responsibilities:

• Successfully completed multiple systems integration projects of Wachovia’- Confidential financial applications in Datamart for Wholesale Risk Analytics (Cognos BI Platform) and managed credit and operational risks of all wholesale LOBs.
• Created new Portfolio reporting (with various KPIs, dollars, credit risk analysis), and Dashboard for Senior Management using aggregated data of 40+ systems and reduced lag time by 90%,.
• Lead and successfully managed multiple Loancenter roll outs projects such as Roanoke, Winston Salem, Auto Dealer Services and multiple phases of data migration. Designed strategy for data integration of STOC, LoanIQ etc. ($5 million budget)
• Acted as a center of Influence for Sr. Management and LOB Managers for self service reporting, better Information management, identification of new KPIs, data capture, data quality and to provide business savvy solutions.
• Managed the IBM Infosphere upgrade project and redesigned Datamart platform to be productive and efficient for higher volume of data. Migrated Loan processing workflow of 14 MS Access databases to Datamart and FRED and build automated workflow (using Java/J2EE products using Agile), coordinated the deliveries with Loan Center Managers.
• Prepared and managed project plan, project communications, and all project management activities including status reporting to Wholesale PMO, and Sr. Management.
• Created and maintained project roadmap for future integration releases.

Environment: Oracle11g, Teradata, SQL Server, SSIS, IBM Infosphere, Cognos 8.x, SSRS, Ms Project, JIRA

Confidential

Project Manager

Responsibilities:

• As a Lead Project Manager, was responsible for managing multiple products (Cognos BI Platform) within the Business Intelligence and Web Analytics track and budget of over $ 2 m.
• Coordinated with various Business partners, Program office, Infrastructure team, Release management team and QA team. Involved in hardware assessment and acquisition process for the project.
• Lead the BA team to capture the business requirements and translating it to product roadmap and deliveries.
• Participate in architecture, designing activity and integration with ERP/CRM systems
• Delivered multiple dashboards for measuring and reporting of KPIs for Kaiser Productivity metrics and scorecards.
• Preparation of technical specifications, test activities, UAT support and other release activities.
• Managed multiple tracks of projects by enforcing planning, prioritization, estimating effort, product scoping and signing SOW.

Confidential

Tech Manager

Responsibilities:

• As a Technical Manager, I was responsible for delivery WLS Datamart platform and for CMSA, it is a Metadata management project
• Designed the architecture of data dictionary project and presented the POC to the LOB. And subsequently completed the project with Java, JSP as frontend and Oracle as database.
• Data modeling of ODS, Data mart and Design of their ETL logic along with Master data integration
• Provided framework, tools-technology evaluation for various ETL and BI tools for solution implementation
• Design of interfaces and different financial reports, property reports catering to Mortgage industry
• Streamlined the Release management process for multiple builds using Clearcase tool.
• Managed the team, budget and performed status report to management.

Environment: Oracle10g, Weblogic, Java, JSP, Webservice, XML, Clearcase, Teradata, Data stage, Cognos 8.x

Confidential

Responsibilities:

• Responsible for re-engineering of Account Profile product. Delivering solutions as a new Business Criteria Datamart, uniquely designed for catering to large volumes of data, and improved performance from 24 hours to 14 hours.
• Collected Requirements from the Business implemented the DW solutions and delivered on time.
• Designed the ETL mappings using Informatica for the Datamart
• Implemented the Audit management solution to boost application availability to users

Environment: Oracle9i, HP-UX, Unix Shell script, PL/SQL, SQL, SAS, Business Objects and Informatica

Confidential

Global Project Lead

Responsibilities:

• As Head of EDW Operations, responsible for managing a team of 30+ developers and DBAs for the development and maintenance of HP Business Intelligence warehouse of EMEA region.
• Integrated the EDW of HP with Compaq for Finance and Sales systems
• Implemented ITSM support model to manage Data and BI operations by providing 24x7 support and SLA management.
• Responsible for Support, Risk Management, Disaster Recovery, Business Continuity of warehouse operations
• Managed escalations and presented monthly reporting, metrics to customer.
• Planned for shutdowns/patch upgrades and coordinated with other Global teams.
• Maintained Hardware Server Infrastructure platform of HP Europe region.

Environment: Oracle, HP-UX, SAP-BW, Informatica, Tibco, Business Objects, Maestro, Siebel Reports, Microstrategy.