SUMMARY:

Highly accomplished and hands on professional with over 15 years of experience in BI design & development, ETL development and data modeling in Data Warehousing & Business Intelligence space.

• Business Intelligence experience includes hands on development leveraging Qlikview 11.2, Qliksense 3.0, OBIEE 11g, Business Objects 3.1 and Tableau 9. Extensive experience in training users, developing POC’s to prove technology and for visualization design. Extensive experience in working with business users and stakeholders on deliverable, roadmaps, rollout and training.
• Qlikview / Qliksense Extensive experience in implementation of Qlikview & Qliksense apps. Experience includes scripting, data modeling, and dashboard development. Experience includes server capacity planning and Qlikview server/security setup. Experience with integrating Qlikview connectors to Big Data and integrating Qlikview with NPrinting for reports.
• UI / Visualization design Extensive experience in working with users in designing simple and consistent UI that helps in data exploration and conveying a business story (recommend layouts, sheets, visualization types, interaction types etc.)
• Data architecture experience includes hands on development experience with Informatica (6+ years) and Erwin for data modeling.
• Technical project management experience - 8 years of experience in leading and managing project delivery (Vice President - BI Manager at Confidential and BI manager at MF Global)
• DW and BI Solution Architecture experience in establishing reference architecture for data warehouse and business intelligence, preparing development guidelines, identify and establish design patterns around ETL process (file transmissions, data quality, recon checks, data rule validations), BI (user security, data security, report delivery, dashboard design)
• Financial Services- 11 years of experience in financial services industry supporting core business areas - Capital Markets, Wealth & Asset Management, Commercial Lending. Extensive experience in broker/dealer, risk, compliance and regulatory reporting requirements. Good understanding of the data requirements and reporting requirements for US and IHC requirements for Basel, EPS, 5g reporting, Intraday Liquidity reporting etc.
• Big Data & Hadoop ecosystem- Experience in delivering POC projects on Hadoop platform. Good working knowledge of HDFS Internals, setting up Hadoop clusters, data ingestion into HDFS via Sqoop and data analytics using Map Reduce, Hive, Spark, NoSQL.
• Extensive experience in executing projects in agile methodology (SCRUM).
• Proficient in developing PL/SQL, UNIX shell scripts.

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City

Sr. BI Solutions Architect

Technology: Qlikview 11.2, Qliksense 3.0, OBIEE 11.1.1.7.1 , Informatica 8.6, OFSAA, SQL Server, Oracle

Responsibilities:

• Responsible for Qlikview, Qliksense hands on development (source data analysis, script development, data model, visualization design and development).
• Responsible for Qlikview server installation and security implementation (document security, section access & publishing).
• Responsible for Qliksense server installation and configuration. Involved in migrating applications from Qlikview to Qliksense.
• Responsible for vendor evaluation and championed Qlikview design & implementation.
• As a solution architect, Responsible for design and delivery of Liquidity Risk data mart and analytics solution.
• Design of Real time Liquidity monitoring dashboards, regulatory EPS reports (BCBS Liquidity monitoring, Collateral monitoring, Base Cash Flow, Balance Sheet reports in OBIEE and dashboards in Qlikview.
• Responsible for design and delivery of Data Quality and Data Recon rules dashboard.
• Work closely with Treasury Funding and Market Risk stake holders for business analysis and BI requirements.
• Responsible for the hands on development of various credit risk reporting tracks- Facility Risk Rating, Risk Weighted Assets, Expected Loss& Economic Capital, EC Stress testing, Concentration reporting.
• Provide admin support in the OBIEE installation, upgrade, LDAP, SSO and MUD setup.

Confidential, NY

Sr. Solutions Architect & data modeler

Technology: Tableau 8.0, OBIEE 11.1.1.6.5 , Oracle 11, Linux

Responsibilities:

• Responsible for conducting a current state assessment of the data warehouse and the different departmental data marts and delivered reference architecture & best practices for data warehouse/mart development. The assessment was done on the following aspects-data model; ETL data flows and identify silo design that doesn’t conform to standards.
• Involved in vendor evaluation and developing POCs in Qlikview and Tableau
• Builds dashboards for Portfolio managers and front office in Tableau
• As the BI architect for the Equities Portfolio Management application, responsible for the overall BI solution design and development (Data mart / data model design, OBIEE design, Security, dashboard design etc.)
• Deliver OBIEE 11G upgrade roadmap.

Confidential, NY

BI Consultant

Technology: Tableau 8.0, OBIEE 11.1.1.5 (BI Publisher), SQL Server

Responsibilities:

• Responsible for performing an implementation assessment, stabilizing the Financial Analytics application and troubleshoot performance issues.
• Mentor the internal development team.
• Perform POC on Tableau to prove Tableau as their technology for dashboards.

Confidential, NY

Senior BI Solutions Architect & Data modeler

Technology: Oracle BI 10.1.3.4.1 / 11.1.1.5 , OBIA Financials & HR analytics 7.8.6, Informatica 8.6, Oracle Exadata, Linux.

• BI Apps implementation of Oracle Financials and HR Analytics

• Constructed an enterprise data warehouse to consolidate the transactional data from the firm’s middle and back office trading systems. The platform supports the reporting requirements of Risk, Compliance, Global Institutional Sales, Retail, Equities, Fixed Income, and Prime Services division
• Architected the end to end OBIEE reporting solution including the data mart model, ETL, and OBIEE metadata /report configuration)
• Championed the data mart architecture and implemented data mart based OBIEE reporting solutions for the Global Institutional Sales, Equities trading, Retail and Prime Services division
• Integrated OBIEE with Oracle’s Virtual Private Database (VPD) to enforce data security
• Designed and developed the Fed Primary Broker Dealer compliance reporting solution on the client’s Fixed Income Repo transactions including positions and financing on a daily and weekly basis using BI Publisher
• Designed and developed a Fixed Income P&L reconciliation platform using OBIEE and .NET
• Designed and developed a Revenue, Client balance, and Account status dashboard reporting for the Futures and Options business

Confidential,VP

Technical Project manager

Technology: Oracle BI 10.1.3.4.1 , OBIA 7.8.5 (Sales and Finance) Informatica 8.6, DB2, Linux

Responsibilities:

• Responsible for overall design, development and project delivery.

• Lead the BI upgrade project- 7.8 to 10.3.4.1 including hands on installation and configuration.
• Responsible for implementing OBIEE governance, development guidelines (MUD, best practices)
• Worked closely with the business leads to enhance usability and drive user adoption.
• Significant contribution/initiatives: Rollout of BI Delivers, significant performance tuning of the BI application, consistently work around product limitations in giving workarounds, integrate the application with revenue data warehouse, provide level 3 support