We provide IT Staff Augmentation Services!

Bo Data Services Developer Resume

5.00/5 (Submit Your Rating)

Chicago-illinoiS

SUMMARY

  • Having 12 years of IT experience reflecting strong technical, management and leadership qualities coupled wif “hands - on” experience implementing solutions across teh technology spectrum.
  • Complete lifecycle experience in larger enterprise SAP Business Objects shared environments.
  • Extensively worked on integration of Business Objects Data Services wif SAP MODULES (Finance, HR & CRM) and Non-SAP Data Sources like Oracle, SQL Server, Flat Files and Legacy System files.
  • Well experience in architecture, development, migration, administration (management) of different BO versions including 5.0, 6.5, XI R3 and XI R4.
  • Proficient in requirements gathering, systems design, user-interface design, application architecture and reports design.
  • Extensive experience in several turnkey Business Objects upgrades and migration projects.
  • Ability to work independently, and also wifin a team environment, having performed several technical roles wifin a customer-focused environment.
  • Hands on exposure wif Teradata Strong understandingof Data Marts, Datawarehousing,Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions,Partioning.
  • Experience maintains teh SSAS Cubes using different security measures Drill-through security, Dimension data security, Advanced Cell security.
  • Expertise in building BI information delivery solutions leveraging BO XI R3, Tableau and Dashboards in built capabilities and customizing these tools to meet business specific requirements.
  • Strong experience standardization in data modeling (both relational and dimensional) and data warehousing.
  • Excellent written and verbal communication, documentation skills, team player and ability to work across organizations to achieve results wif minimal handholding.
  • Strong leadership and project management skills.
  • Exposure to several industry verticals including Industrial, FMCG, telecommunication, manufacturing and finance.
  • Enthusiastic and project-oriented team player wif good written and oral communication skills.

TECHNICAL SKILLS

  • SAP Business Objects Product Suite
  • Business Objects 5.x 6.x XI XI R3
  • R4BOE Architecture
  • Report development (both WEBI and DESKI)
  • XI R3 - upgrades and migration
  • LCM (Life Cycle Manager)
  • Dashboards using Query as a Web service (QAAWS)
  • BOE Installation and Configuration on Windows.
  • Data Integration (ETL):
  • SAP BO Data Services 4.0
  • Business Objects Data Integrator XI R2
  • Oracle 10g 9i 8i 7.x
  • MS SQL Server 2005/7.0/6.5
  • MS Access Tera data and SAP Cubes

PROFESSIONAL EXPERIENCE

Confidential - Chicago-Illinois

BO Data Services Developer

Responsibilities:

  • BO Data Services Developer/ Technical lead for Development on Data Migration and EDW projects.
  • Requirements gathering from business users to support teh Solution Architecture ETL for EDW.
  • Supported teh Solution Architect for BODS Technical features to integrate wif SAP systems and provide solution to establish teh ETL Framework around SAP BODS.
  • Defined Data Stores to allow BO Data Services to connect to teh source or target database.
  • Developed ETL jobs to move data from multiple sources to Enterprise Data Warehouse
  • Developed ETL jobs to SAP R/3 tables and loaded into staging area and build transformations dat apply teh business rules provided by teh client requirement and loaded teh data target SQL Server
  • Worked wif tables involving Hierarchies and using Hierarchy flattening
  • Developed integration between different systems (SAP BW, SAP ECC, SQL Server)
  • Build Delta load logic and worked on Change Data Capture (CDC) on both Source and Target level for Slowly Changing Dimension (SCD) Type 1, Type 2 and Type 3.
  • Implemented Delta recovery solution for failed objects like auto-recovery etc.
  • Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, data flow's and target tables using bulk loads etc.
  • Designed data model and led team in developing new reports.
  • Constructed reusable templates to speed ETL development in BODS and provide auditing functionality. Led training sessions explaining usage of templates and gathering ideas for improvement.
  • Developed teh required configuration in SAP R/3, SRM, BI and Business Objects according to teh Functional specification provided by Functional team and prepare teh Technical design document.
  • Developed numerous custom data sources using database views and custom function modules.
  • Designed and implemented numerous accounting systems including applications such as G/L,A/P, A/R, F/A, and Financial Reporting.
  • Building SD order ODS (SD), order items ODS (SCOR-Supply Chain), shipment cost ODS update Transformation, and update routines as an input to teh same consolidated ODS to view teh overall Waterfall" structure of financial figures at a granular level.
  • Worked on payroll data info cube (0PY C02), where loaded teh data from payroll data(0HR PY 1), which contains all payroll result wage types and organizational assignment for teh employee grouping. Implemented a wage type hierarchy. Compared previous year wif respect to current year.
  • Worked on Cut-over activities and data validations and post. Go-live support.

ENVIRONMENT: SAP BO Data Services 4.0, BW 7.0/7.3, SRM, BI 4.0, BEx, ECC 6.0

Confidential - Chicago-Illinois

Business Objects Developer/Lead and Administration

Responsibilities:

  • Work as developer wif teh Confidential Business Intelligence team performing tasks like report development, universe development of teh Business Objects Platform.
  • Primary work involves migrating and administration of Business Objects environments. Focus on administration, architecture, design of several Business Objects initiatives and projects.
  • Worked on Version upgradation of Business Objects from XI R3 to XI R4
  • Scheduling of Reports to reach users and stake holders for day to day validations and user require data
  • Scheduling of Reports to reach users and stake holders for Monthly, Quarterly and Half yearly and Annual progress of business.
  • User Management such as creation of new users and deletion of users and Modification of user roles as per requirement.
  • Maintenance of SSAS cube such as refresh and validation of cube data.
  • Deploy teh cube form one Environment to other.

ENVIRONMENT: Business Objects product suite Version XI R3 and R4, Designer, Web Intelligence, CMC, CMS, Oracle 10g, Teradata, SAP BW, Data stage.

Confidential - Milpitas, CA

Datawarehouse and Business Objects Developer

Responsibilities:

  • Work as developer wif teh GF Business Intelligence team performing tasks like report development, universe development of teh Business Objects Platform.
  • Primary work involves migrating and administration of Business Objects environments. Focus on administration, architecture, design of several Business Objects initiatives and projects.
  • Understand requirements and specifications from teh business and technical perspective. Detailed design technical architecture for teh solution. Designing teh Data Warehouse using best practices.
  • Created KPI Objects in line wif Requirement Docs.
  • Involved in teh day to day maintenance of teh Business Objects system.
  • Developed several Business Objects reports and universes in DESKI environments.
  • Interface wif customers to capture and analyze business needs and customer’s strategic information requirements.

ENVIRONMENT: Business Objects product suite Version XI R2, Designer, Desktop Intelligence, CMC, CMS,Oracle 10g, Teradata PL/SQL, VBA

Confidential -

Datawarehouse and Business Objects Developer

Responsibilities:

  • Work as developer wif teh Confidential Business Intelligence team performing tasks like report development, universe development of teh Business Objects Platform.
  • Primary work involves migrating and administration of Business Objects environments. Focus on administration, architecture, design of several Business Objects initiatives and projects.
  • Understand requirements and specifications from teh business and technical perspective. Detailed design technical architecture for teh solution. Designing teh Data Warehouse using best practices.
  • Created KPI Objects in line wif Requirement Docs.
  • Involved in teh day to day maintenance of teh Business Objects system.
  • Developed several Business Objects reports and universes in both WEBI and DESKI environments.
  • Involved in converting reports and universes from 6.1 to XI R2.
  • Involved in data modeling of ETL processes for teh data mart using Informatica.
  • Interface wif customers to capture and analyze business needs and customer’s strategic information requirements.

ENVIRONMENT: Business Objects product suite Version XI R2 and 6.5 including Report Writer (Full client), Designer, Web Intelligence, CMC, CMS, Dashboard Manager XI R2, SQL Server 2005, Oracle 10g, Teradata PL/SQL, VBA

Confidential

Business Objects Developer

Responsibilities:

  • Work as a consultant wif teh Business Intelligence/Data warehouse team, proactively recommending and implementing solutions using Business Objects toolset.
  • Development of Business Objects 6.5 universes and reports based on specific business requirements.
  • Maintenance and enhancement existing Business Objects Universes, Reports in Production.
  • Modify / Enhance existing reports, universes for business users according to their daily business needs.
  • Escalate process change requests, system enhancements or any other major resource requests to manager for prioritization.
  • Created complex reports using multiple data providers, complex filters, prompts, sub queries and free hand SQL.
  • Managed and configured security in Business Objects 6.5 supervisor
  • Performed Stress testing and performance testing of teh new environment.
  • Developed and maintained project plans and schedules, scheduled status meetings in collaboration wif teh Manager.
  • Organized and maintained project documentation on Share point.

ENVIRONMENT: Business Objects product suite Version 6.5, Designer, Supervisor, Broadcast Agent (BCA), Web Intelligence, Oracle 9, PL/SQL, Toad, Data warehousing.

We'd love your feedback!