SUMMARY

• Over 10+ years of experience in BI involving Architecting, design, Development, Administration, Support and Maintenance.
• Expertise in Business Objects Server Administration, Security Management, Information Design Tool, Universe Design Tool, Desktop Intelligence, Web Intelligence, Launch Pad and Info View.
• Experience in development and deployment on web/application servers like Apache Tomcat, IIS, and configuring/using various middleware needed for the development of universes, reports in BO.
• Expertise in administration/creating and maintaining Users, Universes and Reports, dashboards using BI 4.X, Business Objects 3.X and BO Data Services 4.x.
• Expertise in developing and generating adhoc, dashboard Reports, List of values along wif User Acceptance Test and data accuracy test.
• Experience in creating business objects reports using WebI, Deski and Rich client.
• Experience in installation, Up - gradation and Migration of various BI suites - BO(XI 3.x, BI4.X) and BODS(4.x). Experience in design, development, sizing & optimal configuration setup of various BI environments starting from BO 5.x to BO 4.X and BO Data services 4.x
• Experienced in interacting wif business users to analyze the business process and requirements and transforming requirements into report prototypes, designing and documenting.
• Expertise in Business objects Data Services Development and Administration.
• Experience in developing Data warehouse solutions using SAP Business objects Data Services 4.X (Designer, Management console) wif strong business understanding knowledge of Manufacturing.
• Strong in Data warehousing, Dimensional Data Modeling concepts - Star Schema and Snowflake Schema methodologies and handling Slowly Changing Dimensions.
• Involved in Data Modeling to determine data definitions and establish referential integrity of the system.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Expertise in creating Data flows, Workflows, Jobs, Projects using BO Data Services Designer and scheduling and monitoring jobs using Management console to move data from multiple sources into targets.
• Experience in a detailed understanding of the SAP data migration process and approach wif multiple SAP END-END Data Migration Projects.
• Over a Year of Experience in working wif HANA. Experience in working wif ABAP data flows and Data transports to extract the data from ECC tables.
• Experience in working wif different loading techniques IDOC, LSMW and BAPI and also the AIO working strategy.
• Experience in working wif the Data Quality, DQM and its Associate Transforms, Data Cleanse, Global Address cleanse, Match and also wif USPS directories .

TECHNICAL SKILLS

Operating System: Windows Server 2008

Database: MS SQL Server’s, Oracle, SAP BW, SAP ECC, HANA, Sales Force.

Internet Tools: IIS, Apache Tomcat

Languages: SQL

BI tools: SAP BW, Analyzer & Query Designer, Business Objects(5, 6.5, XI R2, 3.X, SAP BI 4.X) - DeskI, WebI, Universe Designer, IDT, UDT, Launch Pad, Import Wizard, Report Conversion Tool, Liveoffice, Qaaws, Widgets, Web Services, Life Cycle Manager, CCM, CMC,CMS, DS Designer, Xcelsius, Mobile BI, Data Services 4.x, Information Steward 4.x

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

BODS Administrator and Developer

Responsibilities:

• Installation, Configuration and administration of BO servers in multiple versions (3.X, 4.X ) in production and non-production environments
• End to End implementation for new 4.2 Data services system- Architecture, Installation, Configuration, migration, Support and new Development.
• Resolved major issues f BO Data services servers versions (4.x ) in production and non-production environments
• Installation of Services Packs and Fix packs for BODS and BO.
• Configuring, managing security & troubleshooting migration issues for BODS and BO.
• Maintaining Service level guarantee more TEMPthan 95% along wif First Time Resolution.
• Application Maintenance of BO instances (e.g. fixing bugs, delivering enhancements to universes and reports) and Development of BO universes and reports
• Liveoffice and Xcelsius dashboard deployment & support
• Involved in moving the universe and reports from development to DEV to TEST and TEST to PROD environment using import wizard.
• Published and scheduled Business Objects Reports to Users.
• Created Auditor Reports and tracked user access of reports and universes
• Defining the service strategy wif a focus on how the service fits wif other Business Intelligence services.
• Developing and reporting service metrics.
• Involved in Installing the Business Objects XI3.X, BI4.X, creating Users and User Groups using Central Management Console (CMC) and setting appropriate rights.
• Monitoring BO Servers.
• Perform CMS clustering Content Migration and platform up-gradation using various available tools like Import Wizard, Life Cycle Management Tool and Upgrade Management Tool.
• Involved in creating BODS repositories.
• Code Migrate from one server to another in BODS using both central repository and repository migrate option.
• Involved in resolving data connectivity issues from BODS to Data bases(BW,SQL)
• Created Local, Central and Profiler repositories in SQL Server 2008 R2 and configured Local and Profiler repositories wif Job server and Management console.
• Configured the same in DS wif Data services Repository manger.
• Configured the Data services to connect to the SAP R/3, BI and CRM.
• Experience on creating Jobs servers, Access server, SSL and SMTP configuration using DS Server Manager.
• Managed all BO/ BODS services using Central configuration manager and Central Management console and Ds Management console.
• Manage BODS jobs/servers/Connection using designer and management console.
• Configured 3rd party Autantication - AD/SAP for users to interact/use BO/BODS.
• Configured SSO for 3rd party AD autantication.
• Installed & configured BODS XI 4.0 and 4.1 SP1 and 4.2 SP5 in Development & Production Server.
• Manage BODS jobs/servers/Connection using designer and management console.
• Requirement gathering from business users. Analyze requirements and provide the technical design and implementation for the solution. Prepare functional and technical specifications.
• Managing and coordinate wif the offshore team for development.
• Involved in Best Practices Data Migration and AIO Methodologies for the Migration process and set up the whole Migration process.
• Worked wif ERP TFC\'s closely to understand the business process, coordinate wif business analyst and TFC\'s on specific business rules.
• Participate in Data Mapping workshops and follow-up meetings wif the client business, DML\'s, DMC\'s and TFC\'s.
• Created custom templates and custom lookups and shell jobs and used them in various business needs.
• Created Attribute, Analytical and Calculated views as per the requirement needs.
• Worked on the SAP END-END wif the Master Data-Material, Customer and Vendor master IDOCS: CREMAS, DEBMAS and MATMAS as well used ABAP program to load Address data.
• Developed workflows to load data into Customer Master Sale’s data (KNVV) and Partner roles (KNVP) from legacy systems.
• Worked wif ABAP data flows and Data transports to extract the data from ECC tables.
• Interacted wif both Legacy and Functional teams to design the mapping to load data into Customer Master IDOC.
• Moved the projects from DEV to QA, QA to PROD and PROD to Production.
• Scheduled the jobs, managed users and repositories in Management Console.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Sound understanding of end to end Data Migration process including Extraction, Data Profiling, and Transformation and Generation of Load ready data files in LSMW format.
• Ability to interpret, configure and implement data mapping / transformation business rules into Data Services.
• Delta Mechanism was crucial and closely worked wif data and resolved the Job execution from HIGH to LOW.
• Performed Sales Order Delta and reduced the Job run from 4 hours to 30 minutes.
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool
• Involved in AIO Methodologies for the Migration process and set up the whole Migration process.
• Defined Data Stores to allow Data Services to connect to the multiple source or target database. Experience in extracting data from various source Legacy systems like Oracle, SQL Server, Teradata and flat files.
• Schedule SAP BODS Jobs for Data loading from SAP ECC to MSSQL server.
• Maintain and Enhance SAP BODS jobs as per new requirements.
• Involved in Performance tuning of Code and system.
• Conducting UAT sessions and training sessions wif business users and IT teams.
• Expert in writing DI Scripts for File existence check, daily incremental read, daily Incremental update and Job Dependency.
• Used BOBJ Data Services cleansing transformations for de-duplication, house-holding and address parsing.
• Used various transformations including Map Operation, Table Comparison, Row-Generation, Query History Generation, Key Generation, Pivot and Query.
• Used Data Services as an external system for ETL between ECC and BI for cleansing the data using Data Quality transforms.
• Experience in working wif many Transform types like Integrator, Quality and Platform.

Confidential

Responsibilities:

• Involved in Installing the Business Objects XI3.x, BI4.x, creating Users and User Groups using Central Management Console (CMC) and setting appropriate rights.
• Monitoring BO Servers.
• Perform CMS clustering.
• Content Migration and platform up-gradation using various available tools like Import Wizard, Life Cycle Management Tool and Upgrade Management Tool.
• Scheduled multiple Webi & Deski reports using the publication in different formats to enterprise recipients as well as Dynamic recipients.
• Deployed the BO Web Applications on different application servers.
• Created Server Groups to maintain BO System efficiently.
• Created new Custom Access levels in to BO 3.x.
• Created File, schedule and Custom based Event Scheduling from the CMC
• Migrated all the Scheduled jobs and publication jobs in to BO 3.x
• Configured Auditing in the BO 3.x.
• Business Objects software interaction wif 3rd party autantication (Microsoft Active Directory(NTLM, Kerberos), LDAP and SAP
• Configuring Single Sign on for supported Business Objects Applications using BO bundled technologies like Vintela, Siteminder and Trusted Autantication.
• Implemented IIS-Tomcat Bridging (Jakarta)
• Published the Reports in to different formats like (excel, PDF etc) using the Publication from the CMC.
• Using the Repository Diagnostic Tool to scan and repair the inconsistencies between the CMS System Database and the File Repository Servers file store.
• Installation, Configuration and administration of BO servers in multiple versions (3.x, 4.x ) in production and non-production environments
• Installation, Configuration and administration of BO Data services server’s versions (4.x) in production and non-production environments.

Confidential

Responsibilities:

• Experience in design Web Intelligence Reports using SAP Business Objects XI 3.x.
• Experience in the designing Universe based on different Data Sources.
• Extensively worked on designing WEB Intelligence (WEBI) reports using xlcesisus, WEBi Rich Client and Info View.
• Monitor schedule reports.
• Scheduled multiple Webi & Deski reports to enterprise recipients as well as Dynamic recipients.
• Created Server Groups to maintain BO System efficiently.
• Created new Custom Access levels in to BO 3.X. Configured Auditing in the BO 3.x.
• Business Objects software interaction wif 3rd party autantication.