We provide IT Staff Augmentation Services!

Sr. Bi & Etl Consultant Resume

SUMMARY:

  • Over 17+ years of experience in IT
  • 14+ years of experience in Data Warehousing and Business Intelligence
  • Strong Project Management Skills
  • Data warehousing end to end experience
  • Strong Knowledge in Business Objects Administration, Universe development, Reporting
  • Storing Knowledge in row level security
  • Strong Knowledge in Data Warehousing technologies, analysis, development and testing in the software industry.
  • Well versed in creating Metadata Structures, Ad - hoc Full client and Thin Client Reports.
  • Good understanding of Decision Support System and Online Transaction Processing.
  • Good understanding on Big Data and Hadoop areas like storage, processing, presentation layers.
  • Trained in Big Data Hadoop.
  • Extensive knowledge in Data warehousing concepts.
  • Good knowledge on PL/SQL and SQL Query Tuning.
  • Experience in troubleshooting, maintenance and support.
  • Has strong communication and interpersonal skills and applies strong organizational, technical, and interpersonal skills to produce quality results.

TECHNICAL SKILLS:

ETL Tools \ Data Warehousing: Informatica PowerCenter, Informatica MDM, Data modeling (ERWIN), Dimension Modeling Oracle Warehouse Builder, \ BO Data Integrator\

Business Intelligence\ Databases: Business Objects 4.x, XIR3.1, XIR2, 6x, 5x, MS Access, Oracle 9x,10g, Netezza, Crystal Reports, X Celsius\ Essbase \Tableau Teradata\ Sybase \DB2 \SQL Server \SYBASE

Development/Productivity Tools\ Software Engineering Tools\: PL/SQL, Visual Basic Star Team, ER Win, Quality Center

BIG Data technologies\: Hadoop, SQOOP, FLUME, MapReduce, HIVE, PIG, HBASE, SPARK, SCALA, OOZIE, ZOOKEEPER

FUNCTIONAL AREAS: Accounts, Finance, Retirement Plans, Purchase, Sales & Marketing, HealthCare, Life Insurance, Fleet Management

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BI & ETL Consultant

Responsibilities:

  • Develop source to target mapping docs.
  • Development and unit testing of Universes
  • Reports (Webi) development and unit testing
  • Develop RPAG, Discovery, Platform Summary, CRM master data management, Trust Certification, eVestment Informatica mappings and unit testing
  • Preparation of test cases and test plan
  • Data testing
  • Preparation of System test cases and test plan
  • Preparation of regression test cases
  • Support UAT
  • Preparation of Implementation plan
  • Support post Implementation
  • Support CIP and AUM Reporting.

Environment: Business Objects XIR3.x, Business Objects 4.0, Webi, Informatica, SQL Server, DB2, Oracle

Confidential

Sr. BI Consultant / Data Analytics Tech Lead

Responsibilities:

  • Define KPIs in discussion with BAs & Business
  • Derive data warehouse solutions to support KPIs representation consumed by universe designers
  • Define and execute ETL solutions (custom scripts) to support KPIs
  • Define, prepare and execute Universe data dictionary (UDD) process
  • Participate in data model definitions
  • Participate in data decomposition and data provisioning process
  • Manage sprint planning and deliveries
  • Prepare estimations and schedules
  • Manage team assignments
  • Defects management in terms of development
  • Prepare Universe data dictionary (Universe design documents)
  • Develop universes
  • Test universes
  • Participate in requirement sessions
  • Prepare report detail design documents
  • Reports development and unit testing
  • Reports regression testing
  • Manage promotions from DEV / QA / PROD
  • Sync up different dev environments time to time
  • Manage user security and folder security
  • Support BOBJ servers

Confidential

Sr. BI & ETL Consultant

Responsibilities:

  • Report requirements Gathering and analysis for all GDPM Business units like Enterprise Publishing, CMC, Marketing, ELMOS (Enterprise Literature Management & Ordering System)
  • Prepare design documents for AXIS (Universe), ELMOS (Universe), B2B DX Universe, AUM Universe, Harte-Hanks (ETL), Mail Room Inbound / Outbound (Retirement Plans) ETL process, Legal Account Holding ETL process, Finance - Mail Tracking ETL process
  • Design multi-source universes (SQL server data from AXIS and DB2 data from IDM, Oracle data from AUM)
  • Develop source to target mapping docs.
  • Complex Multi-Source universes development and unit testing
  • Reports (Webi) development and unit testing
  • Develop Harte-Hank Informatica mappings and unit testing
  • Preparation of test cases and test plan
  • Data testing
  • Preparation of System test cases and test plan
  • Preparation of regression test cases
  • Support UAT
  • Preparation of Implementation plan
  • Support post Implementation
  • Support AXIS and AUM Reporting.

Environment: Business Objects XIR3.x, Business Objects 4.0, Webi, Crystal, Informatica, SQL Server, DB2, Oracle, Tableau

Confidential

Sr. BI Consultant

Responsibilities:

  • Convert all deski reports to webi
  • Create new webi reports based on new requirements
  • Enhance existing crystal reports
  • Create 60 Essbase reports based on new cube
  • Maintain existing Essbase reports till new accounting system go live
  • Develop mapping document between e2 universe and new PeopleSoft universe
  • Develop mapping document between SuspenseNXG Essbase cube and new PeopleSoft cube.
  • Universe update
  • Test universe
  • Requirements analysis
  • Reports design and documentation
  • Design documents review
  • Design AWD Data Model
  • Reports (Crystal and Webi) development and unit testing
  • Develop AWD Informatica mappings and unit testing
  • Develop source to target mapping doc
  • Develop AWD universe and unit testing
  • Update PDW universe and unit testing
  • Define data testing strategies
  • Preparation of test cases and test plan
  • Reports testing
  • Data testing
  • Preparation of System test cases and test plan
  • Preparation of regression test cases
  • Support UAT
  • Preparation of Implementation plan
  • Support post Implementation

Environment: Business Objects XIR3, Webi, Crystal, Informatica, Oracle, PeopleSoft, Essbase

Confidential

Consultant

Responsibilities:

  • Update Crystal and Webi reports as per business requirements
  • Provide support to Ad-hoc users
  • Provide support to production issues
  • Troubleshoot performance issues
  • Developed document templates as per SDLC.
  • Report technical design document
  • Report standards
  • Report test cases
  • Universe Design document
  • Universe test cases
  • Test Plan
  • Implementation Plan
  • Requirements gathering (Datamart,Universe and reports)
  • Requirements analysis
  • Preparation of Requirements document
  • Design AWD datamart
  • Universes design and documentation
  • Reports design and documentation
  • Design documents review
  • Develop AWD data model
  • Universes development and unit testing
  • Reports development and unit testing
  • Preparation of test cases and test plan
  • Preparation of System test cases and test plan
  • Preparation of regression test cases
  • Preparation of Implementation plan
  • Define universe testing strategies
  • Define data testing strategies
  • Universe testing
  • Reports testing
  • Data testing
  • Support UAT
  • Support post Implementation

Environment: Business Objects XIR2, Crystal Reports, Xcelsius, Informatica, Oracle, Teradata

Confidential

Consultant

Responsibilities:

  • Update Crystal and Webi reports as per business requirements
  • Provide support to Ad-hoc users
  • Provide support to production issues
  • Troubleshoot performance issues
  • Requirements gathering (Universe and reports)
  • Requirements analysis
  • Preparation of Requirements document
  • Universes design and documentation
  • Reports design and documentation
  • Design documents review
  • Universes development and unit testing
  • Reports development and unit testing
  • Preparation of test cases and test plan
  • Preparation of System test cases and test plan
  • Preparation of regression test cases
  • Preparation of Implementation plan
  • Define universe testing strategies
  • Define data testing strategies
  • Universe testing
  • Reports testing
  • Data testing
  • Support UAT
  • Support post Implementation

Environment: Business Objects XIR2, Crystal Reports, Xcelsius, Informatica, Oracle, Teradata, Sybase, Performance Point

Confidential

Consultant

Responsibilities:

  • Requirements gathering (Universe and reports)
  • Requirements analysis
  • Preparation of Requirements document
  • Universes design and documentation
  • Reports design and documentation
  • Design documents review
  • Universes development and unit testing
  • Reports development and unit testing
  • Preparation of test cases and test plan
  • Preparation of System test cases and test plan
  • Preparation of regression test cases
  • Preparation of Implementation plan
  • Update universes (60+ universes)
  • Update reports (300+ reports)
  • Provide support to Ad-hoc users
  • Provide support to production issues
  • Troubleshoot performance issues
  • Define universe testing strategies
  • Define data testing strategies
  • Universe testing
  • Reports testing
  • Data testing
  • Support UAT
  • Support post Implementation

Environment: Business Objects XIR2, Informatica, Oracle, Netezza

Confidential

Consultant

Responsibilities:

  • Data extract from three different sources (Quarterly Member Reporting(Essbase), Clearing(Flat Files), b-Smart(DB2))
  • Manage security from QMR, b-Smart applications while extracting the source data.
  • Load data into Data Warehouse staging
  • Load data from Staging to Data Warehouse (Oracle)
  • Data Quality check
  • Development of Universe and testing.
  • Development of 4 complex reports and testing. Each report has 24 tabs.
  • Development of 4 medium complex dashboards (reports) and testing.

Environment: BO Data Integrator, Business Objects XIR2

Confidential

Project Manager / Tech Lead

Responsibilities:

  • Understanding user and business requirements.
  • Creating the data base structure and BO repository.
  • Generating Reports using Business Objects 5.1.7, 6.5 and XIR2
  • Created Universes.
  • End user training on Business Objects .
  • Leading the Offshore team and interacting with customers.
  • Fine tuning the performance of universe and reports.
  • Involved in creating cascaded prompts.
  • Interaction with the clients on a daily basis.
  • Configuration management.
  • Managing the deliverables.
  • Maintain BO 5.1.7 and 6.5 repository
  • Created categories
  • Created User groups
  • Created users
  • Support / trouble shoot all admin related tasks as end user baseline support
  • One point contact for Business users and Enterprise Business Intelligence group.
  • Secondary administration (Managing users security, assign user to specific groups / projects).
  • Migrated reports from 5.1.7 to XIR2 using Import tool.
  • Validate migrated reports.
  • Troubleshoot macro reports.
  • Raise or resolve defects in Quality Center.
  • Participated in system testing
  • Support production stabilization
  • Responsible for planning and tracking
  • Plan and perform work allocation
  • Monitor the progress of work
  • Execute the activities assigned
  • Perform peer reviews and update work plan /review status in E-Cube
  • Solution development and testing
  • Adhere to standards and schedules
  • Report the status to Program Manager and Client
  • Participate in weekly status meetings
  • Handle Severity 1 and 2 maintenance calls (Minor enhancement, Bug Fix, Others(Analysis, Testing, Job monitoring, User Consulting etc.)
  • Maintained from project initiation to preparation of Project Data Metrics Reports(PDMR),conducted Look ahead meetings.
  • Managed 5 diverse applications of Reporting systems and 3 applications of ETL Processes

Confidential

Project Leader

Responsibilities:

  • Project Management, Requirements Analysis, Universe Development, Reports Development
  • Maintained project management from project plan to delivery
  • Requirements gathering
  • Re-engineered existing universe as per the new requirements
  • Modified existing reports
  • Created new reports
  • Implementation

Environment: Informatica, Business Objects, Oracle Confidential DNCC(Integrated Gas Management System - Distribution National Control Centre)

Confidential

Project Leader / Test Leader

Responsibilities:

  • Executed all testing activities like writing test plan
  • Write, test cases,
  • Write DVQ(data verification queries on source)
  • Verification of DVQ's against BO reports.
  • Executed test cases against BO reports

Environment: OWB, Business Objects

Confidential

Project Leader

Responsibilities:

  • Participated in Design
  • Detailed Design
  • Writing Program Specifications
  • Write Source to Target specifications
  • Write test cases
  • Develop mappings
  • Test mappings
  • Participated in System Testing
  • Support User Acceptance Testing

Environment: OWB, Oracle

Hire Now