SUMMARY:

• Confidential has 10+ years of BO experience and 5+ years of BODS. He has created and migrated reports, created universes, worked on Webi and Crystal, created drill down/up reports, and worked with SQL, Stored procedures, triggers, and indexes.
• He has designed ETL mappings and workflow, transformations and developed BODS jobs working in a DW.
• Confidential has performed data analysis, worked with multiple sources databases and SQL Server as the target.
• Confidential is available to interview and begin work with a short notice.
• Over 15 years of experience in design and development of BI, DW and Applications using Business Objects, BODS, HANA, MS SQL Server, Oracle and DB2.
• Applications development experience with ASP.NET, VB 6.0 and Crystal Reports.
• Good experience with full SDLC includes analyze and understand business requirement, understanding the data flow and data modeling, building reports, testing, documenting and users.
• Over 6 years of experience with Design & development of ETL/DW using BODS.
• Implementing Kimball’s methodologies to build/support data warehouses.
• Designing Dimensional Data Modeling, Star schemas and Snow - flake schemas and Aggregation Tables.
• Creating Jobs, Workflows, Data flows, Data stores, Template Tables, Flat files.
• Configured Central Repository, Profiler Repository and added User roles.
• Implemented SnapShot jobs and SCD Type 2 Concept for Large Volume Data Configured SAP Application Data Stores and SAP BW Source Data stores.
• Worked on Management Console for Job Scheduling, Tracing, Monitoring, Editing Repositories, Job Servers.
• Performed Elementary Job analysis from Operational Dashboards and generated documents from Auto Documentation in Management Console.
• Good knowledge on Transforms & Custom function.
• Worked on Data quality (data cleansing, standardization, duplicate entries) with larger Data volume.
• Extracting data from multiple databases/file formats and transforming using various BODS Transformations such as Query, Case, Merge, Map Operation & table comparison etc.
• Propagating Job from development to staging and production environment.
• Error handling by validating, auditing and debugging the jobs and reviewing logs.
• Specialist in Data Warehousing concepts Star and Snowflake Schemas, SCDs, Aggregation Tables.
• Proficiency with Database Programming, SQL, Stored Procedures, User Defined functions, Triggers and Indexes.
• Responsible for database backup, data import/export, schedulers, database link, sql scripts and performance monitoring.
• Responsible for MS Sql Server, database creation, table creation, database administration, backup and restore, DTS Package.
• Responsible to gather business requirements and BO design and development.
• Responsible of Creation and Publishing Connections, Data Foundation and Business Layer.
• Proficiency with Universe/IDT development with Tables or Derived Tables, Detecting Joins and Cardinalities, Creating Context, Solving Loops, Creating Parameters and LOVs. Responsible for Check Integrity and Publish Universe.
• Created complex Webi reports with Multiple Queries, Merging Dimensions, Custom Sql, using Functions, Case Statements and Aggregate Functions.
• Created Classes and Objects, designed Dimensions and Measures with Table values and formulas and Conditions.
• Developed SQL scripts, queries and data analytics to get related meaningful and quality data for reports.
• Designed Drill Down, Drill Up, Drill Across and complex filters query filters and report level filters.
• Responsible fine tuning report performance, troubleshooting in data import/export.
• Used Crystal Reports for standard form of Reports.
• Used WEBi RichClient or Launch Pad to Develop Webi Reports.
• Extensively worked in INFOVIEW to create Web Intelligence Reports over the Universe Created for 3.1 version.
• Created Advance multiple Reports, tables, charts and highly formatted page layouts.
• Involved in review for various objects and created test case and test plans in different environments
• Strong experience in BO Central Management Console (CMC) for Monitor, Instance Schedule, Users and Group Management and BO environment management
• Created users' user group, folder security, Universe and Webi security using CMC.
• Responsible for performance monitoring and tuning of reports during application testing and production operations.
• Documented benchmarks and procedures to optimize performance. Ensure that all guidelines are followed.
• Experience in version upgrade from 3.1 to 4 and 4.0 to 4.1 and objects migration.
• Experience in using Import Wizard and BIAR from version 3.1. Used Upgrade Management Tool (UMT) and BIAR from version 4.0
• Experience in migrating objects from Dev environment to Test environment and Test environment to Production environment.
• Experience in creating and using Promotion Management jobs from CMC for promoting the developments to UAT or from UAT to Prod.
• Experience in Server Intelligence Agent (SIA) configurations from Central Configuration Manager (CCM)

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis

BO/BODS consultant

Environment: BODS 4.0, Business Objects 4.2, Oracle 11, MS SQL Server

Responsibilities:

• Develop ETL jobs and migrate data. Data from Kalypso user program to Data warehouse and develop reports as per the Business requirement.
• Requirement gathering, Analyse DW database, develop/modify ETL jobs.
• Developed Universe and Webi reports for Collateral data
• Used Team Foundation Service (TFS) for keeping master work of ETL Jobs, Universe and Webi reports.
• Created TFS Labels and stored ATL files, Data Foundation, Business Layer and Connection files for migration.
• FHLBI’ structure of DW has three stages, Landing Zone (LZ), Staging (ST) and DataMart (DM). Developed jobs for LZ, ST and DM
• Migrated developments from Dev to Test and Test to Prod
• Migrated Data from SBX environment to DEV environment, DEV to PROD environments.
• Migration involved Tables and Table columns matching between environments and databases.
• Data reconciliation between environments after and before data migration.
• Working with the Bank staffs to get report requirements, arranging meetings and users for the new reports. Working in Agile model.

Confidential, Boise, ID

BO/BODS consultant

Environment: BODS 4.0, Business Objects 4.1, Oracle 11, MS SQL Server, Tableau

Responsibilities:

• Worked with the functional consultant for defining the reporting needs and helped design/develop flexible queries using Webi reporting features like adding queries, merging dimensions, applying various filters, variables and conditions.
• Creating User and Group permissions, Monitoring and Troubleshooting Job servers, Schedules and Reports.
• Developed Webi reports using different level filters, drill down, Folder and report links.
• Developed Parent Child report with report links to other Webi Reports.
• Developed and scheduled Production Status report to refresh frequently.
• Developed Data Modelling, query designing, and generating the reports.
• Developed rich Interactive reports and dashboards integrating various reporting components from multiple sources and proficient in Tableau 10.5 (Desktop, Server, Online).
• Used Tableau Extensively to create various reports with MES data and KPI's.
• Created Tableau dashboards with parameters, aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, parameters and worked on complex data sets.
• Implemented data blending using various data sources and created stories using Tableau for better understanding of the data.
• Created different visualizations using Bars, Bullets, Heat maps, Scatter plots, Gantts, Bubbles, Histograms, Lines and Pies, Maps and Highlight tables in Tableau.
• Responsible for Database & Tables analysis for PLM data.
• Working with Project Manager, Onshore development team and Off-shore team.
• Attending Weekly updates meeting and suggest decisions for project flow and smooth release.
• Designing Workflow and Data Flow. Scheduling jobs for SCD2 type ETL jobs.
• Creating Data Store for Oracle database and MS Sql Server database and design Transformations
• Coordination with DBA’s to satisfy business requirements.
• Monitored scheduled jobs and troubleshoot ETL.

Confidential, Fremont, CA

BODS / BO Developer

Environment: BODS 4.0 and Business Objects 4.1 SP 5, Oracle 11

Responsibilities:

• Requirement gathering, development of reports and administration of MES data
• Created technical specifications and unit testing documents for the Workflows
• Plan, design and development of On Hand, On Hold, Container History, Online Traveler, MRB Hold, Rework, Alternate Path, Resources, Data collection, Yield report with Wafer Qty, Run Log reports.
• Developed Online Traveler, Webi report with report links to other Webi Reports Container History, Data collection & Resources.
• Worked with Onshore team and off-shore development team.
• Developed BODS jobs to bring data from transaction tables to DW tables.
• Connected Oracle databases using Datastore in BODS
• Created Query Transformations from BODS
• Plan, design and development of On Hand, On Hold, Container History, Online Traveler, MRB Hold, Rework, Alternate Path, Resources, Data collection, Yield report for Wafer Qty, Run Log reports.
• Developed Data Modeling, query designing, and generating the reports.

Confidential, Folsom, CA

BO/BODS Developer

Environment: Business Objects 4.0 (WEBI), HANA, BODS 4.0, Design Studio 1.6

Responsibilities:

• Requirement gathering, development of reports and administration of HealthCare data
• Created technical specifications and unit testing documents for the KPI'S
• Developed BOBJ reports, created Universes and Webi Reports and Dashboards.
• Developed reports for Agents and policy information, Active courses, Agents and completed courses, Agents and Policies and etc.
• Plan, design and development of Agents/Agency Onboarding/Bulk Onboarding dashboards.
• Developed Data Modeling, query designing, and generating the reports.
• Developed Dynamic Chart reports using Design Studio for Agents Onboarding Information, Agents & States, etc.
• Worked with the functional consultant for defining the reporting needs and helped design/develop flexible queries using Webi reporting features like adding queries, merging dimensions, applying various filters, variables and conditions.
• Creating User and Group permissions, Monitoring and Troubleshooting Job servers, Schedules and Reports.
• Developed Webi reports using different level filters, drill down and report links.
• Developed BODS jobs to bring data from transaction tables to analysis tables.
• Created SCD types jobs to keep History data with end data and Current Data with active date.
• Used Initialization Scripts and Global Variables.
• Created 'Joins' & 'Where' within Query Transformation.
• Used Table Comparison, History Preserving, Key Generation transformations for Surrogate key form SCD type 2 jobs.
• Used Datastore for database connections, used Template tables to create tables in HANA database.

Confidential, Sacramento, CA

BO/BODS Developer

Environment: BODS 4.0, Business Objects 4.1 (WEBI), DB2

Responsibilities:

• Developed BODS jobs using Datastore for connections. Used Query Transformations, Case Transformations and created cases for various return types.
• Developed SQL scripts, Stored Procedures for fetching required data from source.
• Developed Batch jobs and scheduled for different time periods.
• Developed HANA views and used the views for Webi reports.
• Used BusinessObjects 4.0, IDT. Responsible of Creation of Connection, Data Foundation and Business Layer.
• Used Crystal Reports for standard form of Reports.
• Adding Tables or Derived Tables, Detecting Joins and Cardinalities, Parameters and LOVs and other Data Foundation related activities.
• Created Dimensions and Measures with direct table columns and by using Sql statements including Case statements and Aggregate functions. * Created Filters either Native (Direct table column) or Business
• Liaise with business users to come up with design for a single enterprise ad-hoc Universe integrating multiple functional areas (Filing Enforcement, PIT Returns, BE Returns, Finance, ARCS).
• Design, Build and demonstrate the Universe capability to Business users validating the ITs ability and answer ad-hoc business questions.
• Responsible for performance monitoring and tuning of reports during application testing and production operations.
• Establish and implement best practices to ensure data quality and report performance Collaborate with DBAs, architects, and developers in the implementation of BI solution.

Confidential, Dallas, TX

BO/BODS Consultant

Environment: SAP HANA, BW, BODS 4.0, Business Objects 3.1 (WEBI)

Responsibilities:

• Extracted Audit information of the terminal from ECC source data to produce various Xcelsius Dashboards and Webi reports which is useful for oil companies in using the marine terminal. Oil companies are using marine terminal to transport their product based on the audit information about the terminal.
• Relational database data extracted using BODS jobs in daily schedule.
• Responsible to build and maintenance of data extraction jobs and monitoring jobs.
• Responsible in modeling data and reports generation using SAP Business Objects 4.1 (Universe Designer/IDT, Dashboard designer, QAAWS, BIWS, WEBI Rich Client, Import Wizard, CMC, Info view etc.) and SAP BW Environments.
• Provided support in BO Administration, Users and Group creation and maintenance, Instances monitor and execution, SIA configurations and Job servers configurations using CMC and CCM tools
• Responsible for designing, leading and implementing metrics and KPI dashboard solutions using WEBI/XCELCIUS.
• Responsible for programming, testing and documenting highly complex ETL applications using SAP BW 7.x and BODS 4.x

Confidential

Consultant

Environment: MS Sql Server, VB 6.0, Business Objects 3.1 (WEBI)

Responsibilities:

• Built routines to transfer data from POS (every stores) to central server database (Head Office).
• Developed VB application and SQL queries to build data extraction jobs and data cleansing.
• Responsible to monitor the job execution every day and troubleshoot.
• Work with users to understand report requirement.
• Responsible for Database daily backup, Weekly backup & Monthly backup. Restore database on request. Reading Execution Plan, Performance tuning, Query alteration, Indexing.
• Data modeling and report generation using BOBJ Universe & Webi.
• Functional reports for Top Managements, Middle Managements, Brand Managers and Area Managers, Brand wise reports, Sellout reports, Discounts, Seasonal discounts and Special discounts, KPI, Fast moving items and slow moving items, Warehouse, Inventory, Replenishments, Daily reports, Weekly reports, MTD, YTD & Etc.