SUMMARY

• Seven (8+) Years of Business Intelligence experience with 5 complete life cycles using Business Objects Enterprises XI3.0/XI R2/XI R 1/6.5/6.0/5.1 , 4.7(BO SDK, Desktop / Web - Intelligence XI 3.0/ XI R2/XI R1/6.5, CMC, CCM, CMS, SAP Business Objects Data Services XI, Data Integrator, Data Quality, Live office, Import Wizard, Broadcast Agent (BCA), Publisher, Supervisor, Designer, Info view, Performance Manager, Dashboard Builder, Business Objects Reporting and Crystal Reports XI R2/2008, BO Set Analyzer, Application Foundation, Dashboard Manager, Crystal Xcelsius 2008/4.5).
• 4+ Years of Experience in ETL with Different Versions of SAP Business Objects Data Services/Data Integrator.
• 5+ years of experience in Business Objects reporting tools Universe Designer, WebI, DeskI and Infoview for Ad-hoc/Canned Reports using Business Objects 6.5 / XIR2 / XIR3 and report Migration.
• Experiences working in all phases of the software development life cycle (SDLC).
• Expert skills in Data Services/Data integrator in design, creation, and implementation of BODS/BODI scripts and performing perform simple and complex transforms in dataflow using different data integrator, data quality platform and transforms, hands on experience of Recovery Mechanism for unsuccessful batch jobs execution.
• Experience in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake Schema and Star Schema. Experience in Fact & Dimensions tables, Physical & logical data modeling.
• Worked extensively on Cubes, Dimensions and Slowly Changing Dimensions, various Transformations, Workflow, Building Data warehouse, development, performance tuning, job automation, Scheduling and query tuning.
• Excellent administration skills to manage the environment, server, users, groups and security setup for BOE/DS/DI/DQ tools.
• Experience in creating and maintaining of accurate and complete master data for a business imperative by Master Data Management (MDM).
• Experience in user training and extensively involved in taking business and technical requirements and basing on that delivered the required reports to the project.
• Experience in migrating BO Universe, Reports, Dashboard reports, ETL jobs from one environment to another environment.
• Working Experience in designing, development and deployment of complex Universes.
• Expert in retrieving data using Business Objects Universes, Data files, stored procedures and free hand SQL methods.
• Experience in using Business Objects Administration, Web-Intelligence, BO Developer Suite using SDK Report application server (RAS), Application foundation. Broadcast Agent, Auditor, Web Admin tool, Supervisor, Designer, Web Intelligence/Info view.
• Experience in Report Development using Crystal Reports 8.5/9.0/10/XI, (Designing, Sub-reporting, OLAP, Ad-hoc queries, Drilldown, Cross-tab etc.)
• Expertise in Relational Database Systems such as Microsoft SQL Server 2008/2005, MYSQL, DB2, Oracle 10g/9i and Microsoft Access. Technical proficiency in Querying Databases, Writing Stored Procedures, Triggers, Functions, Creating Views.
• Excellent communication and interpersonal, analytical and technical documentation skills, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS

Languages: C++, Java, SQL, PL/SQL, C#.Net, .NET Platform, VB

Reporting Tools: Business Objects XI 3.0/XI R2, 6.X, 5.X, CMS, CMC, Crystal Reports, Web Intelligence Rich Client, Publisher, Desktop Intelligence XI R2/6.x/5.x Supervisor, Designer, BO Reporter, Web Intelligence, Dash Board Manager, Infoview, BCA, BO Auditor, Crystal Xcelsius 4.5 & 2008, Security Viewer 2.2

ETL Tools: Data Services, Data Integrator, Data Quality, Data Insight

Internet Technologies: ASP.Net, HTML, Adobe Photoshop

Scripting Languages: JavaScript, VB Script, XML

Operating Systems: Windows XP/2000/98, Windows NT 4.0, UNIX

Network systems: Internet Information Services Server, Apache, Soap UIFilezilla, WinSCP

Database Management Systems: Oracle, MS SQL Server, DB2, MS Access, TOADSQL Developer

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.5/4.0

PROFESSIONAL EXPERIENCE

Confidential, ROCKFORD, IL

SAP Business Objects Data Services Developer

Responsibilities:

• Working as member of Data Management Organization Team as a Business Objects Data Services Specialist. I was responsible for Data Services design, development, testing and support.
• Gathered Customer and User requirements analyzed and documented them.
• Developed functional requirements and data specifications for ETL Process. Used Data Services 3.2.
• Created new Workflows and Data Flows according to their Business and implemented their business logic.
• Extensively worked on creating CDC’s workflows for Sub ledgers stuff AP/AR/IC/PA and Sales order table on Daily and History Oracle CDC Tables.
• Create and design SAP workflows extracted data from ECC 6.0 and SAP BW
• Extensively used SAP Business Warehouse for Extraction and Loading data into SAP BW.
• Tuned and optimized various Dataflow by using all Optimizing techniques SQL and Indexes.
• Redesigned and updated the old workflows as per the user’s requirement by adding and removing the objects from the workflows.
• Performed Unit and System testing of the Business Objects Data Integrator ETL jobs.
• Prepared documentation for all the Workflows which has newly created and old updated Data flows.

Environment: SAP Business Object Data Services 3.2, Oracle 10g, SAP BW 7.0, ECC 6.0, Business Objects XI 3.1, BI 4.0, Windows 7 /NT, UNIX, Window XP/2003 Server, PL/SQL Developer 6.0.4.906.

Confidential, Middletown, NJ

SAP Business Objects Data Services Developer

Responsibilities:

• In this firm I was member of Data Management Organization Team as a Business Objects Data Services Specialist. I was responsible for Data Services design, development, testing and support.
• Gathered Customer and User requirements; analyzed and documented them.· Developed functional requirements and data specifications for ETL Process. Used Data Services 3.2 for migrating data from various OLTP databases to the Data Warehouse
• Extensively worked on creating Dimensional Data Model for New Business from Operational Data Sources.
• The data migration included identifying various databases where the information lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Created Jobs, Workflows and Data Flows according to their Business and implemented their business logic.
• Extensively involved in Data cleansing and standardizing using USA and Multi-Plug-in transforms in Data Quality
• Implemented Business Rules in Data Flow mappings to Load Data Mart.

Environment: SAP Business Object Data Services 3.2, Business Objects XI 3.1, Data Insight, Report Migration Tool, Oracle 9i/10g, DB2, Windows /NT, UNIX.

Confidential, NY

SAP Business Objects Data Services Developer

Responsibilities:

• 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.
• Used Business Objects Data Services for ETL extraction, transformation and loading data from heterogeneous source systems.
• 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.
• Worked on SAP tables, doing data conversion, moving data from source to loading table and then to staging table and then target database.
• Perform Unit testing and Document the results of Unit testing and ETL process.
• Involved in complete Business Objects Data Services installation and configuration.
• Responsible for setting up Development, Test and Production Environment.
• Administering and maintaining BO Data Services management console and repository management.
• Modified existing Data Services jobs to fix defects Confidential the root cause as enhancement part of project.
• Created and maintained Enhancement, Bug tracking and Bug fix documents.
• Designed and Developed Business Objects universes.
• Resolved issues like loops and traps by creating Contexts and Aliases to remove cyclic dependencies.
• Created the reports using Web Intelligence, WEBI Rich Client and Live Office according to the user requirements.
• Developed WEBI reports by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL Confidential Report level.
• Used alerter to highlight critical data based on business conditions.
• Used @Functions (@select, @where) to increase the Performance and Reuse the conditions.
• Scheduled and published these reports in Business Objects Enterprise using Info View.

Environment: SAP Business Objects Data Services 3.x(Data Integrator, Data Quality), SQL Server 2005, Oracle 10g,PL/SQL, TOAD, Oracle SQL Developer, UNIX, Window XP/2000/2003 Server, Soap UI, Filezilla, WinSCP.

Confidential, PA

SAP Business Objects Data Services Developer

Responsibilities:

• Involved in gathering business requirements, functional requirements and data specification.
• Migrated Business Objects from XI R2 to XI R3.
• Involved in Creation of jobs that specify data mappings and transformations by using SAP Business Objects Data Services Designer.
• Working with different transformations like Map Operation, Table Comparison, Row-Generation, Query, History Generation, Key Generation, and Pivot.
• Worked with different Business Objects Data Services Data Quality Transform such as Global Address Cleanse, Data Cleanse and Match Transform.
• Involved in scheduling and running Batch jobs on time using Data Services Management Console.
• Scheduled, monitored and fixed the errors of the jobs.
• 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.
• Created and Maintained Data Services local and central repositories.
• Developed Data Integrator jobs and Data Quality workflows.
• Designed Universe by creating the Business Objects Data Model.
• Created Hierarchies, complex objects using various@functions, Aggregate objects in the universe.
• Defined @Aggregate Awarness, @Prompt, @Select, @Where functions in universe level.
• Designed cascading prompts in the universe to filter the list of account names based on the business units.
• Linked multiple universes.
• Created Dynamic Filters and Dynamic Conditions in universe level as per Business rules.
• Defined Customized Hierarchies in Universe level.
• Created Derived Tables in the universes.
• Resolved Chasm traps, Fan Traps & Loop problems.
• Created the reports using Web Intelligence, WEBI Rich Client by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL Confidential Report level.
• Used Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and Formulas etc.
• Created Dashboard by using Dashboard Builder/Dashboard Manager and Xcelsius.
• Tuning the Universes & Reports.
• Created Users, User groups and setting up the user profiles.
• Created Objects / Data Level Security in universe level.
• Created User Groups Level Security in CMS.
• Created standard reports, cross-tab reports, Mailing reports & OLAP reports.

Environment: Business Objects Data Services 3.x, Business Objects XI R2 /XI R3 (Designer, Supervisor, Web Intelligence, Performance Manager, Data Integrator, Data Quality), IBM DB2, SQL Server 2005/2000, Oracle 10g/11i/9i, PL/SQL, TOAD, Crystal Reports 10, Xcelsius 2008, Erwin, Unix, Window XP/2000/2003 Server.

Confidential, NJ

Sr. Business Objects Data Integrator Developer

Responsibilities:

• Interacted with business analysts and End client to understand technical and functional requirements for creating new Job.
• 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.
• Created Scripts like starting script and ending script for each job and declaring the variables local and Global Variables.
• 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.
• Used various transformations like, Map Operation, Table Comparison, Row-Generation, Query and SQL transformation.
• Implemented performance tuning concepts to the whole Business Objects Data Services/Data Integrator ETL process.
• Experience in debugging execution errors using Data Services/Data Integrator logs (trace, statistics and error) and by examining the target data.
• Designed, developed, modified and maintained Business Objects Universe using Designer for Ad-hoc and canned reports.
• Created joins, indicating cardinalities, checked integrity of the universe and resolved loops and traps using aliases and contexts.
• Created Hierarchies, complex objects using various@functions, Aggregate objects in the universe.
• Import and export universes and reports to and from Repository using Import Wizard.
• Extensively used Report Conversion tool to convert DeskI reports to WebI reports.
• Created users, users groups and maintained user access rights for BO universes and reports using Supervisor.
• Created reports and compare the daily sales using both tabular reports and 3-D graphical chart reports (bar graph & pie charts).
• Generated reports using variables, formulae and, prompts, filters and conditions used Slice & Dice and Drill up/down functionality.
• Created complex dashboards using Xcelsius which enhanced decision making.
• Exported reports into various formats like EXCEL, PDF, HTML and WORD according to user requirements.
• Performed Unit and System testing of the Business Objects Data Integrator ETL jobs.

Environment: Business Objects Data Integrator 3.x,Business Objects 6.5/XIR2/XIR3 (Designer, Supervisor, BO Full Client, Web Intelligence, Broad Cast Agent (BCA), Publisher, ZABO),Crystal Reports, Xcelsius 4.5, IBM DB2, SQL Server 2005/2000, Erwin, Data Integrator, Data Insight, Data Quality, Oracle 10g/9i, Unix, Window XP/2000/2003 Server, PL/SQL, TOAD.

Confidential, IL

BO/BODI Developer

Responsibilities:

• Worked extensively on Full project life cycle (requirement gathering to implementation phase).
• Installed and configured Data Integrator/Data Quality/Data Insight/Business Objects Enterprise suite.
• Created Data Integrator local/central repositories and configured to use different job servers and server groups.
• Integrated Data Quality jobs within DI job.
• Generate profiling reports using Data Integrator profiler.
• Developed functional requirements and data specifications for ETL Process.
• Used Data Integrator for migrating data from various OLTP databases to the Data Warehouse.
• Generated Custom variables, groups and formulas in Business Objects.
• Generated Reports on different data sources such as Business Objects Universes, Stored Procedures etc
• Created user groups and managed access privileges using Business Objects CMC.
• Responsible for Business Objects repository and BO Audit universe and reports.
• Performed release management of Business Objects reports using Broadcast Agent Server.
• Extensively used Designer to design various universes for different business groups. Created complex reports using cascading prompts, decode objects etc.
• Created complex dashboards using Xcelsius professional.
• Developed various Charts, Graphs and drill down reports.
• Scheduled the weekly, monthly, quarterly reports using business objects.
• Worked on improving performance of reports with aggregate aware and using indexed columns in reports.
• Published reports on the web using CMC (Central Management Console).

Environment: Business Objects 6.5/XI R2, Crystal Reports XI, Crystal Xcelsius 4.5, Oracle 8i/9i, PL/SQL Developer, SQL Server 2005/2000, Windows 2000/XP, Data Integrator, Data Quality.

Confidential, FL

Business Objects Developer

Responsibilities:

• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master Detail and Formulas etc.
• Created the Reports using the universes as the main Data providers and writing the complex queries.
• Involved in resolving the loops, Cardinalities, contexts and checked the Integrity of the Universes.
• Involved in the creating the reports on the web using the BO Web Intelligence from the online internet database and migrated from third party database.
• Exporting the universe to the Repository to make resources available to the users.
• Designed and developed universes for reporting generation from different database.
• Involved in the designing and building of universes, classes and objects.
• Created repository and user, user groups using supervisor module.
• Creating the various ad-hoc reports.
• Developed WEBI reports by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL Confidential Report level.
• Used alerter to highlight critical data based on business conditions
• Converted all Desktop Intelligence Reports to Web Intelligence Reports using Report Conversion Tool.
• Scheduled and Monitored the BO reports through Broad Cast Agent.

Environment: Business Objects 5.0 (Designer, Reporter, Supervisor, Broadcast Agent and Web Intelligence), PL/SQL, Oracle 8i, SQL Server 7.0, and Windows 2000/98.

Confidential, TX

Business Objects Developer

Responsibilities:

• Designed Business Objects Universes and reports.
• Designed, developed, maintained and tested Universes for supporting ad hoc queries.
• Resolved Chasm traps, Fan traps and Loop problems.
• Created variables, formulae and detail objects Confidential report level.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Migrated Universes and reports from development to testing and production environments.
• Created Row level restrictions using create and manage restrictions in the Universe.
• Exported the Business Objects reports to WebI to be viewed by all users on the Internet.

Environment: Business Objects XI R2, Central Management Server, Central Management Console, Infoview, WebI, Import Wizard, SQL Server 2005, PL/SQL Developer, Windows XP.

Confidential

Oracle Developer

Responsibilities:

• Create and maintenance of Oracle Forms and Oracle Report.
• Create and maintenance of PL/SQL packages, stored procedures, functions and Triggers.
• Day to day communication with client related new requirement, support and development.
• Designed, developed, modified and maintained Business Objects universe using Designer 6.5 for ad hoc and canned reports.
• Created joins, indicating cardinalities, checked integrity of the universe and resolved loops and traps using aliases and contexts.
• Created Hierarchies, complex objects using various@functions, Aggregate objects in the universe.
• Preparation of Program Specs and Test cases.
• Unit testing and System testing with test cases.

Environment: Oracle 8i, Business Objects, MS Access, PL/SQLXML, HTML, Windows 2000/NT.