PROFESSIONAL SUMMARY

• Over 9 years of IT experience, quick learner, easily adapts to various environments and very TEMPeffective communication, interpersonal skills and able to handle multiple tasks and projects simultaneously.
• Experience inSAPBusiness Objects suite (XIR4.1, XIR3.1, XIR3, XIR2 & 6.x) wif experience in Central Configuration Manager (CCM), Central Management Server (CMS), Central Management Console (CMC), Web Intelligence, Desktop Intelligence, BI Launch Pad, Info View, IDT, Universe Designer, Explorer, Design Studio, Analysis, Dashboard/Xcelsius 2008 andCrystal Enterprise/2011/2008.
• Experience encompasses a wide variety of industries including Investment, Finance, Healthcare, IT industry and Communication.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and Business levels as part of setting up reporting infrastructure.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Proceduresand free hand SQL and involved in teh data modeling process.
• Gathered business requirements by conducting detailed interviews wif business users, stakeholders, and Subject Matter Experts (SME’s).
• Participated in Tableau 9.0 Beta program, both in Tableau Desktop and Tableau Server
• Experience in Software Development Life Cycle (SDLC) that include duties like providingdocumentation on design, testing and migration from development to production.
• Involved in creating Dashboards as needed usingTableau Desktop and published toTableau Server.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Backgroundimages, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to createdetail level summary report and Dashboard usingTableau’s Advanced Capabilities.
• Created various Tableau Reports that includes Charts, Filters, Scorecards, Drilldown andDrill - Through, Cascade, Parameterized reports that involved conditional formatting
• Created use cases for report and lead administration of BO environment and other BI tools, designing Universe, creating reports, configure LDAP and other security features for a BI environment.
• Involved in Installing Business Objects, Creating Repository, Creating Users and User Groups using CMC and Supervisor.
• Created BI OLAPuniverses over BEx queries using Universe Designer and created reports on SAP BW HANA Env.
• Experience in upgrading from version 5.X, 6.X, XI R2 to BO XI R3.1 and migrated Crystal 2008 to 2011 and also upgraded Reports and Universes from XI 3.1 to BI 4.0.
• Expert in writing canned reports, complex ad-hoc reports using SAP BOBJ Desk Top Intelligence (DESKI), Web Intelligence (WEBI), Designer, Import Wizard, Web Intelligence Rich Client, QaaWS, Publishing Wizard and Business View Manager tools.
• Good experience wif SAP BI 4.1in building efficient and user oriented universes using Designer, IDT (UNX), retrieving data using Universes, Personal Data files, Free Hand SQL Methodsand creating adhoc and canned reports using BI Launch Pad, Web Intelligence 4.0.
• Strong experience in creating Ad-hoc queries, List Reports, Cross-tab Reports, Standard Reports, Dashboard Metrics, Chart Reports, Map Reports, Financial Reports containing functionality such as conditional formatting, prompts, bursting and drill-through.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drill Down, Filters, Ranking, Sections, Graphs and Breaks.
• Created Customized Objects @prompts, Cascading LOVs, Contexts and Aliases at universe Level.
• Having very good experience in Crystal Reports 2013/2011/2008 and Dashboards 4.0 /Xcelsius 2008.
• Experience in rebuilding/converting Crystal Reports to Web me reports.
• Good Knowledge in Extraction, Transformation and Loading (ETL) process using Data Services and Data IntegratorXI.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Proceduresand free hand SQL and involved in teh data modeling process.
• Experience in using Business Objects Data Quality Management (Address Cleansing) tool while extracting data using Data Services.
• Knowledge on SAP Lumira.
• Experienced in Training & Supporting end-user reporting needs using Business Objects.
• Decent working knowledge on SAP BW 7.0, SAP BI 7.0 and BEx Queries.
• Attended Tableau 8.3 Desktop and Server Workshop.
• Flexible and versatile to adapt to any new environment wif a strong desire to keep pace wif latest technologies
• Excellent interpersonal and communication and presentation skills along wif Time management.
• Research documentation, forums, technical support, and other resources for best practices, tuning enhancements, technical issues/resolutions, etc.

TECHNICAL SKILLS

Operating Systems: WINDOWS 7/ Vista/ NT/XP/ME/98/95, UNIX, MS-DOS

DataWarehousing: Informatica Power Center 9.x/8.6/7.1.3, Mapping Designer, BODI XI R2. Oracle CDC for 9i/ 10g

BusinessIntelligence: SAP Business Objects 4.1/4.0/XI R2/R3.1/6.1/5.1 (IDT, Universe Designer, BI Launch Pad, DESK me & WEBI), BO Explorer, BO CMC, Business View Manager, Upgrade Management Tool, Design Studio, Analysis,Crystal Reports 2013/2011/2008/9/8.5/8.0, SAP BI 7.0, Dashboards/Xcelsius 2008, Tableau 8.3 Desktop, Tableau Server 8.3

DataModeling: Star-Schema Modeling, Dimensional Modeling, Snowflakes Modeling, FACT & Dimensions.

Programming: C, C++, ASP, SQL, PL/SQL, Core JAVA

Utilities & Tools: Make, SCCS, PVCS, OLAP/OLTP, Rational Rose, GDB, Toad for Oracle 9.5.x.

Testing Tools: ALM/Quality Center 11.x, Test Director, Test Manager

Networking tools: FTP, Connect Direct.

Database: Oracle 11g/10g/9i/8i, MS Access, SQL Server 2008R2/2005, IBM DB2, SAP BW 7.0, SAP ECC 6.0

Project Management: MS Project, MS Access, MS Visio and MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Chesterbrook PA

Sr. SAP Business ObjectsDeveloper

Responsibilities:

• Analyzing existing WebDyn Pro reports and their functional documentation.
• Gathering requirements from teh stakeholders and SMEs for teh enhancements of teh existing reports and converting teh reports to Crystal reports and WebI depending on complexity.
• Performing GAP analysis and converting ABAP WebDyn Pro functional documentation into reporting technical micros.
• Demonstrated customer solutions wif regards to Business Objects BI 4.0 and Crystal Reports Enterprise to high level Management and Business Users.
• ImplementedOracle11gas a data sourcefor external reporting project, which includes 12 Complex Crystal Reports.
• Microsoft SQL server 2008 is teh data source for internal reporting project which includes 2 universes and 5 Crystal reports on top of teh universes.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.
• Created BI OLAPuniverses over BEx queries using Universe Designer and created reports on SAP BW HANA Env.
• Working on developing new BI 4.1unx universes using bex queries on teh snow flake schema using Information Design Tool (IDT) and developed adhoc/self-service Webi reports to be run wif teh report prompt for any Customer Id(s).
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations
• Created Tableau Scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Customized teh Geo maps to use custom shapes and converted latitude/longitude sets to City/state using Reverse Geocoding utility.
• Created out of teh box charts for complex end user Requirements. Converted Heat map to Funnel chart, Pie chart to a donut chart, Bar chart to a waterfall chart and many others.
• Analyzing data using Slice and Dice and Drill Mode methods and formatted teh reports.
• Designed universes using various @ functions like @prompt, @aggregate aware, @variable and @bouser.
• Resolved fan and chasm traps in universes and created predefined conditions, prompts filters, Classes and Objects, aliases, contexts in teh universes. Teh objects include dimension, measure and detail etc.
• Used Input Control functionality of WebI to avoid performance issues populating teh LOVs.
• ImplementedFolder level security in BI Launch Pad and used teh access restrictions to define teh Object level security for developers and Power users
• Created 12 complex parameterized Crystal reports2013wif monthly buckets and Single layer Crosstab reports.
• Created complicated ranking SQL procedure to support teh business requirement owing to teh limitations in Crystal Reports.
• Implemented Masking in Crystal Reports and WebI using hard coded SQL procedure.
• Created Custom and Cascading List of Values (LOVs) for better understanding of business logic for teh end users.
• Modified and maintained existing universe based on enhancements and updates requested by teh business users.
• Created complex Condition Objects for easy reporting, Aggregate-Aware and Index Aware objects for better performance.
• Created and maintained linked universe for this project. Linked teh universe to core universe whose data source is oracle 11g
• Defined hierarchies and created drill down reports through to teh most granular level for Data analysis using Crystal reports.
• Created a Dashboard using SAP Lumira for a POC presentation using excel sheets as teh data source.
• Created reports using SAP Analysis for excel and migrated teh reports to Web-me using teh plug-in.
• Uploaded teh technical micros to ALM (HPQC)/Requirements
• Performing unit testing and executing teh test scripts in HPQC/Test Lab.
• Data validation/Analysis using SAP ECC tables which is teh OLTP system to start wif and followed by Oracle and SQL server.
• Created, Converted and Validated 4 Business Unit level reports using WebI.
• Worked on teh migration of teh reports from Development Env to QA (STG Env) and after successful testing in Stage env, and closing all teh defects/issues, moved teh BO reports to production.
• Working on fixing teh issues in teh report and teh universe and updating teh status of teh defects in teh Quality Center.
• Created functionality unit test scripts to test Dynamic prompts, Filters, Export, Masking and Personalization functionalities.
• Created Functional test scripts for unit testing reports, Hierarchy level reports and Business Unit Level reports.
• Discussing future enhancements wif SMEs and documenting teh same to make sure we deliver a better product.
• Analyzing of newly developed BOBJ reports and their functional documentation.
• Had RAS sessions and workshops wif business stakeholders to have stable and consistent conversion functional Docs.
• Converted BOBJ Macros to Micros for QlikView Mobile reporting development team.
• Created functional documents wif mock-ups and screenshots of teh functionality in Qlik View.
• Uploaded teh requirements to SAP Solution Manager.
• SAP BW/HANA is teh backend database for this reporting project taking teh future enhancement into consideration.
• Discussed wif QlikView development team about teh feasibility of teh requirements.
• Created one to one GAP analysis from BOBJ reports to QlikView reporting requirements.
• Designed 3 consolidated micros and FDs for this project.
• Uploaded teh requirements to ALM/Requirements.
• Documented teh test scripts for teh approved functional documentation of reports and uploading them to HPQC/Test Plan.
• Performed manual testing and executing teh test scripts in ALM/Test Lab.
• Data validation using SAP BW/HANA tables.
• Created functionality test scripts to test report complicated Filters, Export, Masking and Personalization functionalities and toggle switches in QlikView.
• Discussed future enhancements wif SMEs and documenting teh same to make sure we deliver a better product both for QlikView and BOBJ.

Environment: SAPBusiness Objects 4.1/ XI R3.1 (BI Launch Pad/ Web me), Crystal Reports 2011, SAP Lumira, QlikView, WebDyn Pro, Tableau 8.3/8.2 Oracle 11g, Microsoft SQL Server 2008, HPQC 11, SAP BW 7.4, SAP HANA, ECC 6.0, SAP BASIS SOLMAN, ABAP, Windows 7.

Confidential, Philadelphia PA

Business Objects Developer/Report Data Analyst

Responsibilities:

• Involving in business requirement gathering from teh SMEs and report users.
• Sharing teh Raw data analysis to help BAs and SMEs in designing teh BRDs and Macros
• Convert teh Macros to technical docs (micros) and share wif development team and Testing team.
• Working along wif DBA/s, BA’s for data design and report design.
• Implemented IBM DB2 database and Oracle 11g as teh data source for Crystal Reports and BO Universes
• Converted Crystal Reports to Web Intelligence by rebuilding teh reports using Universes and Web me 4.0
• Created universe inInformation Design Tool (previously Universe Design Tool) from scratch, maintained and updated teh ‘Data Foundation’ & ‘Business Layer’ for teh Investment Banking trust reports, based on Logical Model, linked other Database which has Vested Money bucket information, by Data Foundation in Information Design Tool, by creating multisource Relations Connections, for teh information using Business Objects 4.0.
• Demonstrated customer solutions wif regards to Business Objects BI 4.0 and Crystal Reports Enterprise to high level Management and Business Users.
• Supported BO Admin team for Migration and Scheduling reports
• Created Complex custom Calendars (Daily, Monthly, Quarterly, Yearly, Specific Day of teh month, Avoiding long Weekends and Holidays) for scheduling Crystal reports and WebI reports.
• Dealt wif complex Loan Accounting data, 401K data and 403B data for reporting purposes.
• Migrated assets from old legacy 3.x servers to teh new BO4.0 servers using Upgrade management Tool.
• Performed an Admin role of migrating teh reports from Dev environment to QA, and tan to Prod.
• Worked on teh solution to develop a single report for both On-demand and scheduled, especially wif teh date range parameters.
• Extensively worked wif new designer tool IDT 4.0 using Projects/Shared Projects, Data Foundation, Business Layer and Security Profiles.
• Detected/resolved data Cardinalities and loops, checked integrity of ‘Data Foundation’s in ‘Information Design Tool’.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by teh end users.
• Maintained Business Layer wif multi Data Foundations by using Advanced Parameter option & created folders based on User requirements.
• Created complex Condition Objects for easy reporting, Aggregate-Aware and Index Aware objects for better performance
• Defined hierarchies and created drill down reports through to teh most granular level for Data analysis.
• Created complex Web me reports by linking objects from different data providers and using Merge Dimension Option. Used @functions(@select, @where, @prompt) to create predefined conditions and prompts to filter teh data and for dynamic user selectionDefined conditions using @bouser functionality to apply mandatory security filter on teh respective class or universe
• Created different types of reports such as Master/Detail, Cross Tab and Chart, use of Filters, use of alerters, Conditions, and Calculations
• Created complex reports using complex variables, multiple breaks,sorts, cascading prompts, decode objects etc. Used breaks for white spaces and sections for better navigability.
• Involved in implementing Folder level security in BI Launch Pad and Implemented Row Level and Column Level Security as per user roles wif BO Admin.
• Using Import wizard or LCM to migrate teh Universe from one environment to other environment
• Used teh access restrictions to define teh Object level security for developers and Power users
• Built WebI reports using various Web Intelligence features like alerters, hyperlinking, sections, breaks, sorts, formulas, functions and operators.
• Created Data Integrator mappings to load teh IBM DB2, Flat File and SQL Server 2008 tables to Staging area tan to Oracle 11g Data Warehouse
• Worked wif BODS Designer 4.0 for creating complex mappings, which includes several workflows and data flows to load teh data first from source table, which are Flat files and DB2 to staging table. And from staging table to teh target table which is “Oracle 11g”.
• Developed dashboards and scoreboards for detailed analysis using different analytics like Speedometer, Interactive Metric Trends, and Barometers using Xcelsius 2008
• Created stored procedures to support teh business requirement owing to teh limitations in Crystal Reports.
• Migrated 20+ reports from Crystal 2008 to Crystal 2011 so far and resolved teh design breakage issues occurred.
• Worked wif SAP Technical support team on limitation and issues regarding Cross-tab reports of Crystal reports 2011.
• Worked along wif QA team to get teh SIT and UAT process to be complete align wif Unit Testing and perform code reviews.
• Involved in teh process of GAP analysis between requirements and data warehouse to develop universe.
• Implemented high data intensive reports using Crystal Reports against Crystal enterprise Business views.
• Interacted wif Informatica ETL team for issues related to workflows involving Data Store and Data Warehouse.
• Working wif ETL team in data modeling to build new tables and columns necessary for reporting.
• Working on teh development and implementation of Business Views to deploy dynamic LOVs in Crystal reports 2011/2008.
• Prepared and documented teh documents generated during teh process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents and System testing documents.

Environment: SAPBusiness Objects 4.0/ XI R3.1 (BI Launch Pad/ Web me), Crystal Reports 2011/2008, Xcelsius 2008, Business Objects Data Services 4.0/3.2, Performance Manager, Dashboard Manager, IBM DB2, Oracle 11g, SQL Developer 4.0, SQL Server 2008. Windows 7.

Confidential, Warren, NJ

BI Consultant

Responsibilities:

• Working on Installing and configuring BO XI R3 servers, along wif configuring User groups, folder structures for card team.
• Working on Requirements gathering and raw data analysis for business users and for report development.
• Working on design and developing business objects WEBI reports against multiple data domains like SCRA, CDA, CDW and home loans.
• Designed and developed complete universe by creating joins, contexts, aliases, hierarchies, classes and sub-classes.
• Developed Drill down reports using Hierarchy design in universe for detailed Data analysis.
• Provided Business Objects Universe design changes to address performance, usability and data reliability issues.
• Created reports against Oracle database doe CDW/ SCRA team, Oracle database for home loans team.
• Responsible for administering BO CMC servers and implementing various security levels.
• Created performance analytics dashboards using Xcelsius 2008 against Web me reports using live office.
• Migrated legacy report from 6.5 to XI R2 and tan Involved wif Development team for Migration of SAPBusiness Objects from XIR2 to XIR3 version and also involved in CMC to provide teh User Security settings and Creating User groups in Rich Client 3.1.
• Defined cardinalities, Performed Check integrity, Resolved Loops by creating aliases and contexts to remove teh cyclic dependencies.
• Created Web Intelligence Reports (canned & Ad-hoc) that include functionality like Sections, breaks, Grouping, Sorting, Drill-down, Variables and Slice and Dice using Universes & SQL as Data Providers.
• Standardized BI development by creating Design document, BI checklist, SQL checklist for developers and CBT’s for new users.
• Followed data governance instructions for NPI and non-NPI data.
• Involved in System testing, unit testing and UAT for deployed reports and dashboards.
• Created Training manuals for teh deployed User reports and conducted Status meetings wif developers.
• Involved wif Business Users one to one session of all Reports and pointed to defects log for any formatting issues, data issues and any other changes or performances issues and validated Reports.
• Involved in Unit Testing, Integration Testingand Performance Testing of reports and Universes.
• Currently, working on Performance dashboards based on revenue, finance charges, Payments due, Balance transfer, Overdraft and Stop payments using Xcelsius for teh divisional managers.

Environment: SAPBusiness Objects XI R3.1 (Web me/ Desk me), SAP BO XI R2, BO DI, Business Objects V6.5, Crystal Reports 11.5, Xcelsius 2008, Performance Manager, Dashboard Manager, Project Management, SQL Server 2005, Pl/SQL.

Confidential, CA

Senior SAP Business Objects Developer/Analyst

Responsibilities:

• Responsible for creating teh reports in teh development environment and to promote them to production using teh import wizard.
• Installed Business Objects Enterprise Product client tools on local machine.
• Analyzed teh Functional Design requirements and converting them to technical requirements.
• Preparation of Detail Design Specification documents for Universe and Report Development.
• Assisted teh Data Services team in teh design of database summary tables and preparing teh detail design document on ETL Process to load these tables.
• Involved in development of Business Objects data integrator jobs, workflows, data flows to extract, transform teh source data and loading teh target tables.
• Used Data Integrator3.0/11.5 for migrating data from SQL Server 2005 and Flat files to teh Oracle 10g Data Warehouse
• Created SAP Data Integrator mappings to load teh data warehouse, teh mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data flows
• Created Universes in such a way, that would enable to create Ad-hoc reports and analyze them in different angles using techniques like slice and dice, drill down, using Oracle as backend data bases.
• Created Classes, Objects, Measure objects, Joins, short cut joins, @prompts and predefined conditions in teh universes.
• Defined Custom Hierarchies at Universe level to implement drill down functionality in teh reports.
• Defined cardinalities, Performed Check integrity, Resolved Loops by creating aliases and contexts to remove teh cyclic dependencies.
• Implemented Aggregate aware function and set up aggregate navigation wif objects derived from standalone tables wifin teh universes.
• Applied index aware functionality on non indexed column objects to increase teh performance by directing teh report query to select teh index fields from teh database for faster retrieval of data.
• Created Cascading Prompts at universe level for dynamic selection of data wifin a hierarchy as per teh user requirement.
• Built drill-down reports using Scope of Analysis and drill filters functionality wifin Business Objects Web Intelligence.
• Created templates to customize style and structure according to teh employer's needs.
• Involved in writing and documenting unit test cases and exporting teh results to HP Quality Center.
• Involved in system testing of already existing universes in Production Test Environment.

Environment: Business Objects XI3.1(SP3), WebI 3.1(SP3), Designer, Info view, Crystal Xcelsius 2008, WebI Rich Client, Import Wizard, Report Conversion Tool, Query as Web Service, SQL, PL/SQL, SQL Server 2005, Oracle 9i/10g/11g, Oracle SQL Developer 1.5.5, Toad 9.5.x, SQL Plus, BO Data Integrator 3.0/11.5, Quality Center, Windows XP.

Confidential, Woodbridge, NJ

Lead SAP BO Developer/ Data Analyst

Responsibilities:

• Involved in constant Requirements gathering and business needs wif executives and traders for Dashboard design and development.
• Lead a team of 4 developers and 3 BA’s for business Objects implementation.
• Converted legacy BO 6.5 and BO 5.1.8 reports to SAP BO XI R3.1 Reports.
• Converted Reporting business requirements in to Functional design and Technical design documents for Developers and testers.
• Working along wif DBA/s, BA’s and Data modelers for data design and report design.
• Involved and designed teh Enterprise level data security, report security level set up folder structure and User group access.
• Created Unit Test cases, Test scripts for Unit testing, UA testing and System testing.
• Administered user privileges, access, training and implementation for SAP BO XI R3.1.
• Worked along wif QA team to get teh SIT and UAT process to be complete align wif Unit Testing and perform code reviews.
• Upgraded teh Medicare XI R2 environment on to XI R3.1 environment.
• Created multiple Universes specific to Medicare and Providers subject area. Implemented user friendly universes for users to create Ad hoc reports.
• Implemented aggregated data for Xcelsius dashboards and Imported Xcelsius on to BO environment (Info view).
• Wrote Autosys jobs and scripts for scheduling BO reports.
• Implemented SAP Business Objects Data Integrator XI R3 as a Standard ETL tool to retrieve and clean up data from multiple scattered data sources.
• Implemented IBM DB2 database as teh data source for BO Reporting.
• Involved in DB2 data modeling and data structures during teh initial stages of teh product.
• Linked Performance management dashboards to Xcelsius dashboards.
• Xcelsius dashboards include drill down from reports, Combination charts, Goal declaration, Medicare History Score card and IMS forecast.
• Created Executive dashboards wif Drill, Drop down, details, Linking to BO Reports, Tabbed and also wif Open doc statement.
• Implemented Snow flake design and modeling based on teh report requirements.
• Implemented high data intensive reports using Crystal Reports against Crystal enterprise Business views.
• Interacted wif Informatica ETL team for issues related to dataflow.
• Created stored procedures to support teh Crystal Reports.
• Defined Metadata information for teh reports.
• Implemented IMS health data as a 3rd party data source for Health reports.
• Created hands on 40 + interactive reports and designed them to satisfy 3rd party front ends like Compleo and TMHP.com
• Implemented .Net based frame work using BO SDK to convert Crystal Report files in to PDF documents to a local LAN folder for Auditing purposes.
• Implemented in total of 45 scheduled and daily reports developed using Crystal reports and Desktop intelligence based on teh Data intensity.
• Implemented live office via QAAWS to generate reports against MS products.
• Created Technical Support documentation for Reports and universes.
• Implemented and trained Developers as well as users on new BI standards.
• Created PL/SQL based stored procedures for data intensive reports.

Environment: SAPBusiness Objects XI R3.1 (Web me/ Desk me), SAP BO XI R2, BO DI, Business Objects V6.5, Crystal Reports 11.5, Business views, Info Cubes, Xcelsius 2008, Performance Manager, Dashboard Manager, Project Management and IBM DB2.

Confidential

Business Objects Developer

Responsibilities:

• Played an admin role, in establishing user access and system set up in various environments (Clustered Network).
• Participated in Project planning, Performed analysis, Design and created Functional Design and Detail design Documents.
• Created a standard SOA to have MARS work wif other front end applications.
• Worked as an Application developer in designing BO Universes and BO Web me (XI R2) Reports.
• Involved in setting up of folders, groups, LDAP security, Objects Migration and Performance tuning.
• Converted Data Design in to Report design and Universe design through Functional Design documentation and Technical design documentation.
• Implemented and Involved in Onshore - Offshore Delivery model during design, development and testing phase. Teh Offshore involved 4 developers and 2 Testers.
• Filtered and Cleaned up data from various flat files using BO DI and merged it wif standard SQL database for specific Stand alone reports.
• Provided timelines to Design and development sessions.
• Implemented new BO XI R3 environment against UNIX systems.
• Worked along side wif BA’s to consolidate teh User requirements and interpreted them in to Technical language for DBA’s and Designers.
• Created multiple canned and scheduled Crystal Reports using standard procedures.
• Implemented SQL stored procedures for performance intensive reports, which also requires constant Scheduling.
• Derived and Created Xcelsius dashboards like Health score cards, Medicare beneficiary by period, Medicare audit by region and Forecast Goals.
• Imported data from different data sources and loaded it to teh Targets.
• Merged Market research data (IMS) wif Cost based reports.
• Created multiple universes to support ad hoc reporting environment.
• Member of an offshore team of 4 for report design and development of SP’s and Reports.
• Implemented Xcelsius as teh dash boarding tool, created links to flash files from teh web me content.
• Designed and Developed Test cases for Unit and UA testing.
• Introduced Business Objects voyager for report development using cubes.
• Used Clear case and PVCS for versioning for teh reports.
• Planned, Designed and scheduling teh training power users on Ad - hoc reporting.
• Implemented and created a plan for BO XI R3 migration from SAP BO XI R2.
• Implemented BO XI R3.1 against teh Sql server database.
• Set up and Implemented Qaaws to generate reports against live office.
• Involved in BI information assessment for data maturity and technology updates.

Environment: Business Objects XI R2 (Web me XI R2) and SAP BO XI R3.1 (Web me R3.1), BO Voyager, Crystal Reports 11.5, Business Views and 2008, DB2, Performance Manager XI R2, Qaaws, Windows 2003, OLAP, SQL Server 2005.

Confidential

Business Objects Developer

Responsibilities:

• Extensively worked on stored procedures functions using SQL, SQL Plus and PL/SQL.
• Used PERL programming for developing web scripts, to process data passed via CGI from HTML forms.
• Involved in D.B.A work and performed maintenance of database, created indexes, synonyms, etc.
• Updated tables daily and weekly according to teh requirement
• Designed and developed Essbase cubes through extracting data from Oracle/SQL databases to generate multidimensional reports for marketing management
• Designing and developing programs for teh investment management using Business Objects at front end and Oracle at back end.
• Designing and development of Universes, Classes and Objects.
• Creating Cardinalities, Contexts, Joins and Aliases for resolving Loops and Checking teh Integrity of teh Universes.
• Implemented Parameterized sorting wherein teh reports had teh sort values driven by a formula.
• Created Complex formulas using CASE, IF STATEMENTS and STRING CONVESRION and DATE CONVERSION functions.
• Exporting teh universes to teh Repository in order to make teh resources available to teh users.
• Created new data stores, Projects, Jobs, data flows and Real time jobs using BO data integrator to move data from spreadsheets and COBOL logic on to new data warehouse environment.
• Creating reports for various Portfolios using teh Universes as teh main Data Providers
• Creating teh reports using Business Objects functionalities such as Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae's etc.
• Created customized LOV's and cascading prompts for easy access to business users
• Created a wide variety of charts like pie chart, 2D and 3D charts reflecting teh current information versus teh forecasted information.
• Exporting teh Reports to teh Document Agent Server and Using teh Doc Agent server to Schedule and Monitor teh Reports
• Production Support and gave training to teh users.
• Worked on Balanced Scorecard for a strategic feedback system that helped program managers to make better decisions faster.

Environment: Business Objects6.x (BO Designer, BO Supervisor, Document agent server, BO Miner, BO query),BO XIr1, PERL, Webintelligence2.5, Desktop Intelligence, XML, JRun Oracle8i, Pl/Sql, Windows NT.