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