We provide IT Staff Augmentation Services!

Data Warehousing Resume

UsA

SUMMARY

  • Reporting Specialist with 13 years of Data warehousing experience in technical architecture, design, development, and deployment of business intelligence and web-based applications.
  • Project experience in various business verticals including Energy, Investment Banking, Insurance, Manufacturing and retail industries. Strong background in software quality processes, metrics and practices, with experience in CMMI Level 4 projects.
  • Extensively worked with various commodity teams (Power, Gas, and NGL), Credit Risk and Market Risk teams.
  • Primary strengths include SAP BO BI 4.0 SP2, UDT, IDT, BO XI R3 /R2/6.x, CMC, Designer, Import Wizard, Crystal Reports, Web Intelligence, Performance Management and Dashboard Design Tool 4.0.
  • Hands on experience on SAP BO Design Studio, SAP BO Explorer, Sap Lumira, BO Analysis for OLAP/Office.
  • Expertise in Data Visualization, Infographic design, Interactive dash boards using Tableau 8.0
  • Excellent track record of implementing ETL solutions for large scale data warehouses/data marts/reporting data stores on time using Informatica PowerCenter (8.1.1, 7.1.1, 6.2)
  • Sound working experience in ORACLE 11g/10g/9i, SQL SERVER, JAVA SCRIPT, HTML.
  • Strong knowledge in Star/Snowflake schema, Data Purging, Data Mining, Data Audits and other Data Warehousing concepts.
  • Acquainted with Configuration Management using version control systems and working under Operational change control Management system.
  • Excellent team player working within and across BUILD, PLAN, TEST, Infrastructure, and Operate teams.
  • Hands on experience in Spotfire 5.5 /6.5
  • Hands on experience in OBIEE 11g
  • Hands on experience in SAP-BW 7.3.
  • Trained in SAP HANA

PROFESSIONAL EXPERIENCE
Lead Business Object Developer (SAP BO BI 4.0 SP2)
Confidential, USA
Currently working in following projects as Business objects Lead maintaining more than 25 universes and 1000 reports and developing executive dashboards using Tableau 8.0, Coordinating onsite–offshore model and helping user community across Confidential locations.

Credit Risk Reporting (Credit) - Facilitates Credit exposure, Credit limit and
Counterparty information to Traders
Cash Forecasting (Financial) - Accrual and Actual reconciliation reporting for
Gas

Prices and Curves (P&C) - The project provides Commodity prices, curve
Dependencies volatile exceptions, Manual missing
prices for Market risk analysts
Functional Responsibilities:

  • Experience working with various Credit Risk Analyst on Counterparty Limits, Exposure and Collateral
  • Understanding of Various Deal types (Physical, Financial and Fixed/Float), Deals, Spot Transactions and facilitating users with Transaction deal list Reports on daily basis.
  • Good knowledge on Counterparty ,Parent ,Ultimate Parent hierarchy and notifying the unmapped counterparties in system by generating Business objects Reports
  • Alerting Credit Analysts by providing Trading breach reports on Tenor,Options,Terms and Fixed Prices
  • Expertise in Requirement gathering and designing effective solutions for Credit community.
Technical: Business Objects:
  • Developed Universe best suitable for adhoc reporting for trading analysts
  • Implemented custom hierarchies for flexible reporting to drilldown the data to lowest granularity.
  • Developed complex reports with multiple data providers (Merged Dimensions), unions, sub-queries, complex date objects, breaks, sections, alerts and database functions.
  • Worked with Business users to understand the user requirements, layout, and look and feel of the application to be developed.
  • Data blending implemented on Enterprise data ware house and generated interactive dashboards.
  • Created adhoc reports to users in Tableau by connecting various data sources.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Project: Power Reporting
The goal of this project is to extract data from Epsilon and nMarket stage it to support the business requirements in generating daily reports on Power Settlement,Mark-To-Market data, Trade Detail and Metrics data, P&L (Profit and Loss) and Reference data (Counterparties,ISO locations, Prices, Curves and Book structure)

Responsibilities:
  • Created aggregate objects on different level of aggregation using @aggregate functions to improve report performance
  • Implemented custom hierarchies for flexible reporting to drilldown the data to lowest granularity.
  • Developed complex reports with multiple data providers(Merged Dimensions), unions, sub-queries, complex date objects, breaks, sections, alerts and database functions.
  • Conducted Business Objects Web Intelligence end user training for Power and Compliance groups.
Project: Global Invoice Solution for Power
Provided a common platform to generate invoices for Physical Power, Physical Option Premium, Physical Emissions, Financial Power, Financial Option Premium, and Financial Emissions.

Responsibilities:
  • Developed complex reports for settlement team for Invoice PDF generation.
  • Designed and developed cross tab reports, reports with sub-reports (linked and unlinked) .Reports were based on a command object. Wrote several SQL queries to accomplish the task.
Project: NAGP Strategic Data Warehouse
Design and implement strategic framework for the existing NAGP DCT solutions architecture, including Reporting technology re-platforming from 6.x to BOXIR2. The goal is to streamline the current NAGP DCT technical architecture and infrastructure in order to provide a single, centrally managed and supported data warehouse environment that is more cost-effective, efficient, robust, and scalable.
Responsibilities:
Led a migration from Business Objects 6.5.1 to Business Objects XI R3 for Business Intelligence group. The migration included:
  • Design of an architecture to support full-lifecycle development of universes and reports
  • Migration of content from 6.5.1 system to XI R3 using the Import Wizard
  • Mapping of 6.5.1 security requirements to the XI R3 security model according to Confidential standards.
Lead Business Object Developer
Confidential
The Mercury reporting solution caters to the needs of Risk Analysts and Operations Line users to analyze the amount of risk involved in various transactions carried out by the bank and subsequently enables them to make appropriate business decisions.
Responsibilities:
  • Install and configure various components of BO XI R2 on Windows XP.Utilize CMC to manage the XI R2 system by creating users and groups and assigning appropriate access rights for various BO Applications as well as documents and universes.
Informatica Developer(ver 6.1)
The Confidential suite of programs within the UNIX environment was converting it to INFORMATICA based ETL layer for iSchwab. Extractions, transformations and pre-processing that were carried out on NDM, Pro*C, PL/SQL, Oracle stored procedures and Shell scripts were analyzed and converted to Informatica as applicable.
Responsibilities:
  • Analyzed the UNIX and PL/SQL scripts and implemented their functionality in Informatica using different transformations. Designed and created data cleansing, validation and loading scripts.
  • Performance tuned the system to cut 8 hours of daily load time using unorthodox techniques like LOAD from Cursor, Non recoverable loads, Volatile Tables, Clustered tables and Partitioning
Business Objects Developer
Service under this agreement to provide the reconciliation reports across source systems include life insurance, annuities, mutual funds, pension- and retirement-related investments and administration and asset management.

Hire Now