Profile

• 7 years of IT Experience
• 7 years of BI Business Objects Experience
• 7 years of Database Experience

Summary

• SDLC: 7 years of IT experience in Analysis, Design, Development and Implementation of Data Warehousing and other applications using Object Oriented Analysis, Design and Methodologies
• Business Intelligence: 7 years of Business Intelligence experience with complete life cycle Implementations using Business Objects XIR3.1/XIR2/6.5/6.1/6.0/5.1 (Supervisor, Designer, Info view, Business Objects Reporting Business Objects SDK, Xcelsius, Web-Intelligence 6.0/2.7/2.6/2.5, Web-I SDK, Broadcast Agent, Publisher, BO Set Analyzer, Data Integrator, Application Foundation 6.0/2.5 & Dashboard Manager)
• Business Objects: 7 years of Extensive experience in Business Objects full client & thin client environment. Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc. Used Stored Procedure Data Provider for frequently running tasks. Trained Users in report development and running ad-hoc queries in business objects. Tested business objects reports for data validation and compared results with TOAD. Set up Broad Cast Agent and Configured the Broad Cast Agent.
• Data Warehousing: 6 Years of Experience in ETL with Different Versions of Business Objects SAP Data Services/Data Integrator.
• Data Quality: 3 years of experience with Data Quality of data profiling, parsing, cleansing, standardization and matching capabilities to make sure data is correct., MS SQL Server 2005, MS Access 2000/97, Erwin 4/3.x, Windows NT/2000, Windows 2000/98/95.
• Databases: 7 years of solid database experience in Oracle 10g/9i/8i/8.0/7.x, Teradata V2R5/V2R4, DB2 8.0/7.0/6.0, MS SQL Server 2000/7.0, (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, Developer 2000 (Forms 6i/5.0, Reports 3.0/2.5), TOAD, Rapid SQL.
• Good Understanding of ERP’s Modules ( G.L, A.P, A.R & F.A) and underlying tables in Oracle
• Experience in educating and supporting end-user reporting needs using Business Objects.
• Extensively worked with Oracle, Access, Spread Sheet, SQL Server databases.
• Strong Analytical, Interpersonal, Communication and Leadership skills.

Education:
Bachelors in Computer Science Engineering.

Technical Skills

BusinessObjectsXIR3.1/XIR2/XI/6.5/6.1/6.0/5.1(Supervisor, Designer, Info view, Business Objects Reporting Business Objects SDK, Web-Intelligence 6.0/2.7/2.6/2.5, Data Integrator XI, Xcelsius, Web-I SDK, Broadcast Agent, Publisher, Designer, Supervisor, Auditor, Application Foundation Dashboard Manager, Report Writer, BO Set Analyzer, Application Foundation 6.0/2.5 & Dashboard Manager), Informatica Data Analyzer (PA 8) & PowerAnalyzer 5.X/4.X

Business Analysis

Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing

Dimensional Data Modeling

Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2, Oracle Designer, Visio and Sybase Power Designer.

Business Objects Data Services XI 3.1/3.2/4.0, BO Data Integrator 12.2/11.7/6.5, SQL*Plus, SQL*Loader

Databases

Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access.

Programming

Unix Shell Scripting, Kernel Programming, Perl Programming, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, Java, C, C++

Environment

Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos

Professional Experience:
Confidential,TX Jun’12 – Sep’12
SAP BO Data Services Consultant
.The Texas Medicaid & Healthcare Partnership (TMHP), a coalition of contractors headed by ACS, a Xerox company, carries out the Medicaid claims payment for the state of Texas, under contract with the Texas Health and Human Services Commission.

Responsibilities:

• Participated in requirements gathering, analysis and structured Business Intelligence platform based on user requirements
• Created Data Flows to load data from flat file, CSV files with various formats into Data Warehouse.
• Involved in creating batch jobs for data cleansing and address cleansing.
• Involved in creating the batch jobs for de-duplicating the data for different sources.
• Worked on making full load jobs in to incremental loads using Map Operation, Table Comparison, and Auto Correct Load.
• Extensively used Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, and Validation Transforms in order to load data from source to Target Systems.
• Extensively used lookup, lookup_ext functions in Data Integrator to load data from source to Target using a transform Table
• Designed & developed error catching procedures in BODI jobs.
• Scheduled and Monitor jobs using Data Integrator Management console.
• Defined separate data store for each database to allow Data Integrator to connect to the source or target database.
• Created Scripts like starting script and ending script for each job, sending the job notification to users using scripts and declaring the Local and Global Variables.
• Created and administered Local and Central Repositories for multi user environment.
• Migrated and tested jobs in different instances and validated the data by comparing source and target tables.
• Automating all error handling, error escalation, and email notification procedures.
• Generated several Metadata reports for Data Integrator mapping, and job execution statistics.
• Training the end users on using the WebI environment by highlighting the user friendly concepts and the ease in developing Ad-hoc reports. Provided the end users with easy to read and understand documentation for the WebI reporting tool.
• Evaluated initial version of XCelsius and did pilot run with few of Dashboards in development environment.
• Developed technical documentation for all the reports.
• Performed Manual Testing and Automated Testing to check usability of the system.
• E-mail reports to users, and published them to the web as required using Business Objects Enterprise.
• Exported the Reports between Development, System Test, UAT and Production Environments.
• Mentored end users in working with the Business Objects user module and provided technical expertise.

Environment: Business Objects XI 3.1/R3/R2 Suite (Desktop Intelligence, Web Intelligence, Central Management Server, Central Management Console, Import Wizard), Life Cycle Manager, Import Wizard, BOBJ Explorer, Xcelsius 2008, QAAWS, Designer, Live Office, Crystal Report 2008API, BCA, SAP BW/BI 7.0, SAP ECC, SAP Data Services, SAP Netweaver, Oracle 10g, MS Access 2000, Windows 2003 server/XP, Unix.

Confidential,WA Nov’11 – June 12
Sr BOBJ/BODS Consultant
Project: Hold Separate
T-Mobile USA, Inc. is an American Mobile network operator headquartered in Bellevue, Washington, that provides wireless voice, messaging and data services in the United States, Puerto Rico and the U.S. Virgin Islands. The company is the fourth-largest wireless carrier in the U.S. market with 33.73 million customers and annual revenues of US$ 21.35 billion. As of 2011, J.D. Power and Associates, a global marketing-information-services firm, ranked the company highest among major wireless carriers for retail-store satisfaction four years consecutively and highest for wireless customer care two years consecutively.

Responsibilities

• Involved in gathering the Reporting requirements from Supplier Quality Engineers who are the key users of the QPM system.
• Analyzed the Business Requirements (functional & technical) with the Business users.
• Participated in requirement gathering sessions and developed Business Objects Data Services jobs specifications on excel sheets based on information acquired from analysis of source data, user requirements, Business rules and Enterprise standards.
• Worked with Business analysts, SMEs and Business Users to understand Business process and Collaborated with business technicians to research existing business, system processes and functional requirements for modifying Job.
• Used Business Objects Data Services for ETL extraction, transformation and loading data from heterogeneous source systems.
• Developed/Modified Real time Business Objects Data Services jobs to generate the Web Services WSDL to integrate it with User Interface application.
• Developed Maintained and Configured Web Service Definition Language (WSDL) in Business Objects Data Services Management Console and tested it extensively using SOAP UI.
• Used various transformations like Case, Map Operation, Merge, Query, Row Generation, SQL, Validation, Data Cleanse, Address Cleanse and Match
• Used Business Objects Data Services cleansing transformations extensively for de-duplication, Standardization and address parsing.
• Extensively involved in Data cleansing and standardizing using USA and Multi Plug-in transforms in Business Objects Data Services Data Quality.
• Used Business Objects Data Services interactive debugger to test the jobs and fixed the bugs.
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data.
• Modified the existing Universes according to the Specifications, which were from different data sources like Oracle/SQL Server/SAP BW.
• Involved in the designing and Building of Universes for new Components.
• Involved in creating Universe, Classes, Measure Objects, Dimension Objects, and Detail Objects and applied Hierarchies based on Business logic.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc to develop the reports.
• Created reports using multiple data providers such as Universes and personal data files in generating reports. Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis.
• Validating and Verifying Universes and Reports created by the Off Shore team and making the Necessary Changes if needed.
• Involved in Performance Testing for Testing the Performance of the Reports created by the SMA team and suggested solutions to improve the Performance.
• Involved in managing key component of QPM which is a custom built SDK application, AutoConfigurator that integrates with the BOBJ Dashboard.
• Created Rules in the Dashboard Manager to Run the Control Charts that is created by designated QPM Administrators in the AutoConfigurator application.
• Created both dynamic and static dashboards using Xcelsius from SAP and Non-SAP data using both QAAWS (Query as a Web Service) and Live Office.
• Evaluate the HCM/HR reports and Dashboards created from BW universes.
• Created Rules in the Dashboard Manager for the Control Charts Scheduled to run daily.
• Monitoring the Alerts sent to QPM users who subscribed to Lotus Notes e-mail alerts when an out of control condition exists on a control chart for a supplier of a given commodity.
• Created new Metric Universes specifically designed for creation of Dashboards.
• Developed Quality Performance Management Dashboards for the Users to view all the QPM Reports.
• Training the business users and conduct training workshops for the DBAs and Business Users on BOXI 3.1.
• Educating users on the data being used in the reports (using proper contexts and universes for adhoc reporting).
• Was involved in the BOBJCOE meetings to upgrade to Business Objects XI 3.1.

Environment: Business Objects XI 3.1 / R2 (CMC, CMS, CCM, Designer, DeskI, Web Intelligence, InfoView, Dashboard Manager, Performance Manager, Import Wizard), Crystal Reports 2008/ X1 R2, Xcelsius 2008, Business Objects Data Integrator 11.7.2, Business Objects Data Services 12.2.3., SAP BW 7.0 ,Live Office, Oracle 10g, TOAD, SQL, PL/SQL, Windows XP.

Confidential,Tampa, FL Aug’10 – Oct’11
Sr SAP BO Data Services Consultant
Well Care provides Medi Care and Medicaid managed care health plans for 2.2 million members.

Responsibilities:

• Interacted with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Installed & configured Data Services XI 3.2 SP1 in Development & Production Server.
• Created the Local Repositories, Central Repositories, Profiler Repositories in Oracle 10g and configured the Local, Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3.
• Exposure to Data services Architecture Data services objects, Data services design interface, Data stores, Importing metadata, File format.
• Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
• Based on the requirements, extracted the data from ECC 6.0 and loaded into BW 7.0 using Data Services XI 3.2 SP1 as an ETL tool.
• Used Open Hub Services to push data out of SAP BI using Data Services.
• Extracted the data from Legacy systems(SQL server) and loaded into Oracle 10g.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality
• Used Data Integrator and Platform Transforms extensively.
• Created jobs, Workflows and Dataflow.
• Worked on Change Data Capture on both Source and Target level for SCD(Slowly changing Dimension) Type 1, Type 2 and Type 3.
• Move the projects from DEV to ST, ST to UAT and UAT to Production.
• Scheduled the Jobs in Management Console.

Environment: Business Objects XI 3.1/R3/R2 Suite (Desktop Intelligence, Web Intelligence, Central Management Server, Central Management Console, Import Wizard), Life Cycle Manager, Import Wizard, BOBJ Explorer, Xcelsius 2008, QAAWS, Designer, Live Office, Crystal Report 2008API, BCA, SAP BW/BI 7.0, SAP ECC, SAP Data Services, SAP Netweaver, Oracle 10g, MS Access 2000, Windows 2003 server/XP, Unix.

Confidential, (Bartlesville, OK) Feb’10 – Aug’10
SAP BOBJ/BODS Consultant
Conoco Phillips one of the Fortune 500 Companies is the third-largest integrated energy company in the United States based on market capitalization, oil and natural gas reserves, is the fourth-largest refiner and the sixth-largest reserves holder of non government-controlled companies.

Responsibilities:

• Documented the user requirements into Functional Specs and Technical Specs.
• Created Universe using SAP BW Infocubes as Data Source and configured Classes and Objects based on the InfoCubes.
• Involved in using Job Server in creation of batch jobs. And also involved in Performance tuning at source, transformation, and target levels.
• Created Data Services ETL jobs to load source data from to target table.
• Created Data Services for data cleansing and data standardizing.
• Worked with a Team to develop a complex universe and generated reports exclusively using Full client.
• Administering the entire Business Objects Suite including BO reports/Data Services management console, Data Services repository management and also configured tools like FirstLogic.
• Created and Maintained Data Services local and central repositories.
• Developed Data Integrator jobs and Data Quality workflows.
• Extensively involved in Data cleansing and standardizing using Multi Plug-in transforms in Data Quality.
• Created Data Quality transactional jobs and Integrated jobs utilizing FirstLogic tools.
• Integrated Data Quality jobs with DI job for data cleansing and standardizing.
• Worked on Data Profiling using DI/DQ and Data Insight tools to know the quality of data.
• Ensured Data Quality using tool like FirstLogic before extracting data from disparate sources.
• Involved in Designing and Development of Universes, Classes and objects which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Detected loops, and checked the Integrity of Universes. Created Classes, Objects, Hierarchies. Created Prompts, and Filters and used Aggregated Awareness function.
• Created Derived Tables in the Universe to create frequently used reports.
• Used Contexts and Aliases to resolve Chasm Traps and Fan Traps.
• Built complex formulas in the WebI documents to accommodate business rules and report Formatting.
• Created Several Standard reports WebI Documents for various Departments, which uses refresh on Open so that each time Prompts are presented to the users to select the report Criteria.
• Created Analytic Dashboards for upscale users on the Financial Actual Budget and Target Budget.
• Created reports in Crystal, WebI and Deski using all the functionalities (@ Functions, Case Syntaxes, Open Doc.
• Imported reports from Source to destination Platform in SAP both DeskI and WebI using the Import Wizard..
• Responsible for testing the Corporate/User Reports once moved from Test - Production.
• Interact with system users and stakeholders around specific work efforts / Issues for the deliverable.
• Responsible for testing the Browser Version from IE6 to IE8.Responsible for documenting the changes made to the complex formulas.
• Involved in meetings on deciding strategies and planning the Workarounds for the Reports.
• Reported on weekly basis to Business Objects Project Team lead and Company’s Project Manager on the Issues and met the time Limits Successfully.

Environment: Business Objects XIR2/R3 (Info view, DeskI, Universe Designer, RCT, and Import Wizard, Crystal Reports XI, Oracle 11g/10g, Teradata, SAP ECC, SAP BW Business Objects 6.5, Unix, Windows XP, and Citrix.

Confidential, (Miami, FL) Apr’09- Feb’10
Sr. SAP BODS Consultant
World Fuel Services is the global leader in the downstream marketing and financing of aviation, marine and ground transportation fuel products and related services.
Integrated Information Management Systems (IIMS) department at World Fuel Services has a homegrown data warehouse which has been operational since 7 years. Crystal reports (mainly financial reports) used for Accounting purposes were in place from a long time, and were distributed through crystal enterprise 9.

Responsibilities:

• Interacted with business analysts and End client to understand technical and functional requirements for creating new Job. Written Data Services/Data Integrator Scripts for File existence check, Daily incremental read, Daily Incremental update, workflow level Script read, workflow level Script update, workflow level Error Handling and Job Dependency.
• Defined database Data Stores to allow Data Services/Data Integrator to connect to the source or target database.
• Used Business Objects Data Services/Data Integrator for ETL extraction, transformation and loading data from heterogeneous source systems.
• Created Data Services/Data Quality workflow to clean and standardize names and address using USA and multi plug-in address transforms.
• Extracting Data from different sources like SAP ECC and flat files and loading them into requested target flat files, excel sheets, Oracle Tables in Data Services/Data Integrator.
• Integrated DQ workflows with DI ETL jobs with cleansing and matching logic.
• Cleaned data from different sources and matching among the source data and matched against the corporate data to find the Master and subordinates and avoid duplicates entries into the system.
• Used Data Insight to profile the source data to generate the quality of source data.
• Created Scripts like starting script and ending script for each job and declaring the variables local and Global Variables.
• Defined separate data store for each database to allow Data Services/Data Integrator to connect to the source or target database.
• Tune the simple and complex transformations in Data Flows.
• Used Business Objects Data Services/Data Integrator interactive debugger to test the jobs and fixed the bugs.
• Created different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Documented the deviations from the original specifications and employed Enhancements on complex reports and also optimized the usage of user objects, conditions and universe level filters and also write test cases and test scripts to validate the queries.
• Responsible for re-pointing of crystal reports to use SAP BO universes.
• Designed and maintained universes for better report performance.
• Created report templates and established templates for documentation of reports providing new insights into the reports and helping them understand have a record which was absent till now.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Created and modified reports based upon the business use.
• Worked with Import wizard to move the objects between DEV, QA and Production systems, to create users in bulk.
• Worked on row level user security, helping to create SAP BO user variable loading security from the Windows AD group.
• Modified complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, and @aggregate), complex SQL queries and joins.
• Interacted with the end-users understanding the business needs to suggest better reporting practices and decide the strategy on training the end-users.
• in extracting and transforming Data in Business Objects Data Integrator.