SUMMARY:

• 14+ Years of strong experience as a Software Professional with hands - on experience in DB Maintenance, Backup and Recovery. 10 Yr’s of good hands-on experience in Architect like Business Intelligence, Native/BW HANA/S4 HANA Modeling, Data warehousing Tools, Data Modeling, Administration, Analysis, Design, Development, ETL, Deployment of various applications using different BI Technologies, Techniques, Structures, Global Onsite / Offshore Models, Agile Methodology, Predictive Analysis and Power BI and Cloud Platform.
• Expertise in BW/Native HANA hands-on development experience: creating SAP HANA information models such as Procedure and HANA Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SAP HANA Live (Analytics). as well as strong technical aptitude.
• Expertise in Business Intelligence tools Native/BW HANA1.0/ S-4 HANA Data bases and HANA XS Engine. Translating Functional Specifications into Technical Specifications.
• Working with large data volumes and ETL tools like Business Object Data Services, SLT and others.
• Enhanced multiple SAP ECC data sources such as 0CACONT ACC ATTR and 0UCCONTRACT ATTR 2 as well as create and enhance teh necessary info objects and info providers for BEX/ MDX queries. Modified transformations withinBWusing ABAP to produce accurate data for reports.
• Good experience on various data source like AWS Red shift data base and big data concepts.
• Has an eye for Detail and flair for learning’s. Knowledge and POC’s on BI, BODS, SAP HANA Modeler, Information Steward. Good understanding of various sap modules like SAP MM, SD, FI, AP, LUMIRA Discovery. Design and develop on Analytical privileges, Export/ import, creating delivery unit.
• Core Experience on architectprovide end to end solutions in teh design and development of teh applications Using IDT/UDT, WEBI Intelligence, Xcelsius-2008/2010, Dashboards, Business Explorer, Data connections. Administration activates, TABLEAU, Design Studio, SAP LUMIRA2.0, Mobile reporting, Analysis for Office and Power BI, BI / BW and Complex Crystal Reports using SAP Business Objects, Explorer Info spaces, Dashboards. Good on Microstratagy dash boards and Subscriptions.
• Good experience on SDMMQMPU and EWM Modules, Eclipse utilizing AMDPs and BADIs in AMDPs.
• Created folders in CMC and implement teh security on various objects in CMC (Folders, Applications, Universe and Connections). Performance tuning on both admin and application related activities.
• Trained and mentoring business users, Start /Stop, Enable/Disable, Clone, Add, remove Services (Delete, edit & Move). Work with SAP Support in case any issue is not resolved internally and Admin/applications related. In-depth knowledge on Tableau Desktop and Tableau Server.
• Provide technology and architectural leadership, strategic direction and long-term vision for teh SAP Investment; inspire creative solutions for maximizing teh value contribution of that investment.
• Involved in teh full System Development Life Cycle (SDLC) of a Data Warehouse and responsible for Designing, coding, testing, implementing and supporting teh ETL processes for data warehouse solutions and related data marts. Skilled in Data Model design and development using various tools like ERWIN 3.5.
• Excellent ability in writing specifications and gathering requirements from teh user to develop Reports as per teh needs of teh client and maintain documentation of teh reports for future reference and SCEIS standards.
• Strong Experience on live, Extract and Scheduling teh TABLEAU / SAP LUMIRA / Analysis for Office/ Power BI Documents/ Workbooks, Stories, admin, Security activities and Information steward.
• Strong Experience and development of WEBI /Crystal Reports, XCELSIUS. Different data connections of Live Office, QAWS, XML DATA, Web Services (BIWS). Performance tuning on both admin and application related.
• Extensive Experience in Admin /Security of teh various versions, Business Objects ( BOBJ 4.2), SAP LUMIRA, TABLEAU, Design Studio, MICROSTRATAGY, Power BI and Crystal Reports XI/ Enterprise.
• Strong Administrator skills, DC migrations, Version UP-gradation, User groups, Security, support activities for All Environments (End to End activity). And implementing aFacets/software environment also.
• Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator Using BODS as an external system for ETL between ECC and BI with 360 Eye and Info bust
• Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target and Trade Management.
• Perform installation, migration, configuration, maintenance, technical support and troubleshooting of various Versions in Business Objects, TABLEAU, LUMIRA, Design studio and BODS. Knowledge on Bial Scripting
• Created monthly and summary reports in WEBI 4.0\4.2for teh different domains like Finance, Marketing and HR domains Server Intelligent Agent (SIA), Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Auditor, Voyager, Live Office.
• Handled Change Requests (CRs), Issue Logs and Support Request (SRs) within a given target time. Coordinating / Working on various back end ETL teams and resolved Admin, Reports, Performance issues.
• 4 years of strong experience as a MS - office DBA, Testing and SQL Server 2000 maintenance like Backup, Recovery and report generations. Good knowledge on US Section 508 and WCAG2.0. Good in UI Design.
• Extensive Experience in corporate training, Good Team leading skills. Gained extensive experience in Designed, Development phase as part of teh young development teams and couple of initiatives Well Advanced. Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in teh Query Designer.

TECHNICAL SKILLS

SAP HANA: S/4 HANA1605, BW / BI7.5, Info Cubes, SLT, Native HANA, SAP HANA SQL, Information modelsHANA Cloud, CDS Views, XS engine, Modeling, Security, BODS, DXE, UNIX, Information steward, CTS++.

Business Intelligence: Business Objects R 3.1/2, BOBJ 4.2 /4.1/ 4.0 Central Management Console (CMC), CCM, User/ Security/

Server Management: LCM, IDT/ UDT, WEBI /Desktop / OLAP Intelligence, BIWS / (QWAS) /Live Office, Enterprise PerformancePromotion Management, Crystal Reports XI/ Enterprise, XCELSIUS, Import Wizard, Publisher, Upgrade management Tool (UMT)Report Conversion Tool, BI Launch Pad, Business Explorer, SAP LUMIRA, Analysis for office, Design Studio (1.5/1.6), EDI, HL7.4HIPAA, Architecture, Web, Mobile Reporting, UML and Use Cases, Asset Management Tools, Team Foundation Server (TFS), EHSMBOPF, MDX, Data Federator, TABLEAU Desktop (8/9), Tableau Server, Tableau Online, Power BI Desktop and server, Knowledge on

Data Stage: Hadoop,Cogon’s, UI, EIR Accessibility, QLIK View, BRIST, Facets, Information Steward, Clarity, Lumira2.0Discovery,AWS

Data Modeling: Star-Schema and Snowflakes Modeling, FACT and Dimensions.

Programming & scripts: SQL, PL/SQL.MS Office Macro’s, HTML, DHTML

Data Base: SQL Server2005/2008/2012, Oracle, Teradata13.0/14.0,DB2, T/SQL, HANA/S-4 HANA.

Industry Application: Manufacturing, Healthcare, Food & Retail, Finance, Logistics, Energy, Telecom and Banking

Testing and Ticketing tools: Manual, Knowledge on Win runner, QTP and SM9, ISM, Remedy, Service Now.

PROFESSIONAL WORK EXPERIENCE:

HANA Modeler

Confidential, Milwaukee, WI

Responsibilities:

• Experience in loading data from multiple sources and working on O-data services and information Models.
• Expertise on Data provisioning, transformation, Modeling, Security, Authorization and Analytical Privileges.
• Good experience on teh S/E version Migrations. Data load by using SLT, DS. TPM reporting experience. Good understanding of various sap modules like SAP MM, SD, FI, AP, HANA Cloud Platform. Explorer Info spaces, Dashboards. provisioning data using dynamic-tie ring
• Expertise in Business Intelligence tools and Native/BW HANA1.0 DB and HANA XS Engine Enhanced multiple SAP ECC data sources such as 0CACONT ACC ATTR and 0UCCONTRACT ATTR 2 as well as create and enhance teh necessary info objects and info providers for BEX queries.
• Excellent experience monitoring and enhancement for HANA Views, functions, procedures and data loading form RDBMS DB. Also SDMMQMPU and EWM Modules, Eclipse utilizing AMDPs and BADIs in AMDPs
• Strong ExperienceNativeHANAInformation Models using Attribute, Analytic and Calculated Views. Developed MS Analysis Reports, Input Templates. Data load by using SLT, DS and Native HANA SQL.
• Worked as architect to provide End to End solutions for various BI tools BOBJ, Microstratagy and Power BI.
• Working on MSTR enhancements, report issues. Creating attributes /Matrices and various filters. Setting up New Subscriptions and Dashboards. Good on AWS, big data concepts and Web IDE and Flow graph.
• Modified transformations withinBWusing ABAP to produce accurate data for reports and REVPRO, Virtual Trader and Cost Management modules. Good on ETL DS jobs.
• Q qStrong Understanding on live, Extract and Scheduling teh TABLEAU, SAP LUMIRA Documents/Workbooks/ Stories, Admin and Security. Extensive expertise and experience implementing and developing with Microsoft Power BI tools including analytics, reports, dashboards, and data visualizations. Extract, transform and load teh Data by using various transformations and good UI design with 360 Eye and Info bust
• Developed Dashboards for top level management by using BIWS / Query as a Web Service.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in teh Query Designer. automated testing
• Data center Migration for teh DEV /QA / PROD Environments and Repository. Upgrade service packs, ODBC Drivers and Supported admin activity for teh various Server/services supported.
• Troubleshoot and Resolved by teh service now incidents, new user creation, SR, performance and ARS incidents.
• Integration for S4 HANA, Tableau, BIBO. HANA view Calculating /Analytical views.
• WEBI, LUMIRA2.0, AOP, Design Studio Setup teh security for Analytical privileges.
• Good on CDS Views, Explorer Info spaces. O-Data service on SAP Fiori app and Power BI
• ACL, Load balancer, Proxy and Network configurations End to end Admin activities and BODS.
• REVPRO, Virtual Trader and Cost Management modules. Good on AWS and big data concepts

Environment: S/4 HANA1605, ABAP CDS Views, BW, Admin Tableau, SAP BI4.2 SP3, WEBI, LUMIRA Discovery, SAP Fiori, Information Steward, BODS, TABLEAU, REVPRO, Virtual Trader and Cost Management, AWS, Hadoop.

Architect on BOBJ, HAN

Confidential, New Jersey

Responsibilities:

• Work on HANA data modeler KPI’s to create view for reporting like calculating and analytical views and Good understanding of various sap modules like SAP MM, SD, FI, and AP, HANA Cloud Platform.
• Strong ExperienceNativeHANAInformation Models using Attribute, Analytic and Calculated Views. Developed MS Analysis Reports, Input Templates. Data load by using SLT, DS and Native HANA SQL.
• Worked as architect to provide End to End solutions for BI (BOBJ, Tableau, and Power BI) tools, HANA, BODS.
• Managed Services for BO 4.2 environment stability, sizing and sustainability, system slowness, Explorer Info spaces, Dashboards. Good on information models and SDMMQMPU and EWM Modules, Eclipse utilizing AMDPs and BADIs in AMDPs
• Expertise to Resolved teh Daily issues in teh Daily Production / Non Production Environments.
• Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator using BODS as an external system for ETL between ECC, BI and SAP HANA1.0 Data bases.
• Expertise in BW/Native HANA1.0, HANA XS Engine. Enhanced multiple SAP ECC data sources such as 0CACONT ACC ATTR and 0UCCONTRACT ATTR 2 as well as create and enhance teh necessary info objects and info providers for BEX queries. Modified transformations withinBWusing ABAP to produce accurate data for reports.
• Excellent experience monitoring and enhancement for HANA Views, functions, procedures and data loading form RDBMS DB and Web IDE and Flow graph.
• Designed and Modified IDT/UDT, WEBI, Design Studio, Business explorer, Dashboards using Lookups and various formulae to analyze teh data like PDF, Line, column and combination charts and Explorer.
• Strong Understanding on live, Extract and Scheduling teh TABLEAU, SAP LUMIRA Documents/Workbooks, Admin, Security. Developing with Microsoft Power BI tools including analytics, reports, dashboards, and data visualizations. Hands on knowledge of EIR Accessibility, required technical specifications, Techniques.
• Created folders in CMC and implement teh security on various objects in CMC (Folders, Applications, Universe and Connections). Performance tuning on both admin and application related activities.
• Trained and mentoring business users, Start /Stop, Enable/Disable, Clone, Add, remove BO Services (Delete, Move & edit). Work with SAP Support in case any issue is not resolved internally for all Admin/applications related And 360 Eye and Info bust. In-depth knowledge on Tableau / Power BI Desktop/ Server.
• Strong ExperienceSAPHANAInformation Models using Attribute, Analytic and Calculated Views. Developed MS Analysis Reports, Input Templates. Data load by using SLT, BODS and SAP HANA SQL, API Library.
• Expertise in SAP BI 4.0, 4.1, 4.2 tools and SAP HANA1.0 Data bases. Data load by using SLT, BODS.
• Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms(Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target
• Created repository and security domain with user groups and security implementation multilevel hierarchies are Setup enabling teh drill down functionality, Create Derived Tables and good UI design.
• Implement teh Single Sign-On (SSO) application for teh Operations, Updates teh project and Utilize. Taking care End to end issues like, Report scheduling and handled various performance tuning issues on reports\Stories.
• Troubleshoot and Resolved by teh Remedy incidents, New user creation, performance and ARS incidents

Environment: SAP HANA, BW, SAP BO 4.2 SP2, ISM, BI, SAP LUMIRA, TABLEAU, POWER BI, EDI, I, SLT, DXC

Lead on HANA

Confidential, Springdale, AR

Responsibilities:

• Worked as HANA modeler/developer to provide End to End solutions for HANA, BI, and BODS. Expertise in SAP HANA1.0 Modeler and DS jobs.
• Data load by using SLT, BODS. TPM reporting experience. Good understanding of various sap modules like SAP MM, SD, FI, AP, HANA Cloud Platform. Explorer Info spaces, Dashboards.
• Expertise in Business Intelligence and SAP HANA1.0 DB, HANA XS Engine and Analytical privileges’.
• Created Complex Crystal Reports using SAP Business Objects and SQL as data source Expertise to Resolved Daily issues for both Admin and Documents\ Reports in teh Daily Production Environment.
• Created folders in CMC and implement teh security on various objects in CMC (Folders, Applications, Universe and Connections). Performance tuning on both admin and application related activities. Good experience on teh S/E version Migrations.
• Excellent experience on modeling like Views, functions, procedures Decision Tables. Data loading form RDBMS DB, CVS and flat files.
• Trained and mentoring business users, Start /Stop, Enable/Disable, Clone, Add, remove BO Services (Delete, Move & edit). Work with SAP Support in case any issue is not resolved internally for all Admin/applications related
• Strong ExperienceNativeHANAInformation Models using Attribute, Analytic and Calculated Views. Developed MS Analysis Reports, Input Templates. Data load by using SLT, BODS and Native HANA SQL, API Library.
• Designed and Modified IDT/UDT, WEBI, Design Studio dashboards, Stories using Lookups and various formulae To analyze teh data like PDF, Line, column, combination, Pie charts, and Local and Global filters.
• Strong Understanding on live, Extract and Scheduling teh TABLEAU, SAP LUMIRA Documents/Workbooks/ Stories, Admin and Security. Extensive expertise and experience implementing and developing with Microsoft Power BI tools including analytics, reports, dashboards, and data visualizations. Extract, transform and load teh Data by using various transformations and good UI design with 360 Eye and Info bust
• Responsible for Created user-groups in CMC and implemented teh new security model on teh groups created like End to end solutions and Performance tuning on both admin and Documents/Reports related activities.
• Developed Dashboards for top level management by using BIWS / Query as a Web Service.
• Perform installation, migration, configuration, maintenance, technical support and troubleshooting of Business Objects TABLEAU implementations. Setup teh Platform search applications and Service level memory issues.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis. Unit testing, integration testing.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in teh Query Designer. automated testing
• Created repository and security domain with user groups and security implementation multilevel hierarchies are Setup enabling teh drill down functionality and created Derived Tables.
• Implemented Single Sign-On (SSO) and Taking care End to end issues like, User groups, Report Scheduling and various performance Activities. Hands on knowledge of EIR Accessibility, required technical specifications
• Troubleshoot and Resolved by teh Remedy incidents, new user creation, performance and ARS incidents.
• Worked as architect to provide End to End solutions for various BOBJ Environment tools
• Implemented different TABLEAU / LUMIRA Storey futures, Dashboards, Trend lines, Forecasting, Sets, and Date Comparisons. And Performance Tuning on both admin (Vizql) and Documents related activities.
• Designed and Developed WEBI, Design Studio dashboards using Lookups and various formulae to analyze teh Data like PDF, Line, column and combination charts. Unit testing, integration testing, and automated testing
• Strong Understanding on live, Extract and Scheduling teh Sap LUMIRA and Tableau Documents /Workbooks, Admin and security. Performance tuning on both admin and application related.
• Coordinate with business teams to update teh business requirements. Developed product requirement.
• Designed and Developed Web/Desktop reports on MS Access/SQL, creating Hierarchy on different data sets by Utilize Drill across teh call history status like call drop, failures...etc. Created user filters, Conditions and global Filters for various reports to specify teh reporting parameters and good UI design.
• Create teh dashboards for various details about call status.

Environment: TABLEAU, MICROSTRATAGY (9.4), MS SQL/Access, Architecture, WEBI, Document, Dashboard, POC on Admin and developer, SAP LUMIRA, Design Studio, EDI.

SAP BI /BO Technical Lead

Confidential, Camden, NJ

Responsibilities:

• Worked as architect to provide End to End solutions for various BOBJ Environment tools.
• Attended Business meetings assisted Business Analysts and gatheird requirements as per Data model.
• Designed universes from Multi providers and applied row level and objects level restrictions to different groups and users as required with 360 Eye and Info bust.
• Experience in SAP BO Integration kit, Created Reports and Universe using SAP BEX queries. Trained in BO best practices and testing Universe.
• Setup teh environments/deployed to DEV, QA and PROD Server for this implementation.
• Coordinated with business teams to update teh business requirements. Developed product development,
• Experienced working with Universe Builder to build OLAP Universes from SAP BW data source like Info Cubes/ MDX and BW Query. Performance tuning on both admin and application related. Good UI design
• Hands on knowledge of EIR Accessibility, required technical specifications. Unit testing, integration testing.
• Created YTD, MTD, user filters, Conditions and global Filters for various reports to specify teh reporting Parameters. Moved reports by using Promotions Management for various environments.
• Created teh BIAR files by using CHARM (UnicCSC ID Format) ID’s as per teh company standard format.
• Experience in SAP BO Integration kit, Created Reports and Universe using BW / SAP BEX / MDX queries.
• Setup teh environments for DEV, QA and PROD Server for this implementation. Performance tuning on bothAdmin and application related. Hands on knowledge of EIR Accessibility, required technical specifications
• Experience in SAP BO Integration kit, Created Reports and Universe using SAP BEX queries.Trained in BO best practices and testing Universe.
• Good Experience in EHSM Incident Management enhancements onBOPF using Enhancement Workbench, consuming web services EHSM.
• Coordinated with teh business teams to update teh business requirements like KPI’s. Developed product Development and lead supporting responsibility like resolve customer issues support and good UI design.
• Designed and Developed Universe (IDT), Web Intelligence reports, and administration activity.

Environment: SAPBOXIR4.0 (SP6), SAPBI/BW, IDT, Web Intelligence Rich client, BEX, MDX, EDI, BOPF, EHSM.

Scrum / KANBAN Master

Confidential, TX

Responsibilities:

• Attended Business meetings assisted to Business Analysts and gatheird requirements as per Data Model.
• Migrate from sapbo3.1 to SAPBO4.1 by using Upgrade Management Tool. Extract, transform and load teh Data by using various transformations and good UI design with 360 Eye and Info bust.
• Created folders in CMC and implement teh security on various objects in CMC (Folders, Applications, Universe and Connections). Performance tuning on both admin and application related activities. Good experience on teh S/E version Migrations.
• Trained and mentoring business users, Start /Stop, Enable/Disable, Clone, Add, remove BO Services (Delete, Move & edit). Work with SAP Support in case any issue is not resolved internally for all Admin/applications related
• Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator using BODS as an external system for ETL between ECC and BI.
• Created Complex Crystal Reports using SAP Business Objects and SQL as data source
• Designed and Developed WEBI Reports using teh features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze teh data and Performance tuning on both admin and application related. Hands on knowledge of EIR Accessibility, required technical specifications.
• Coordinated with teh business teams to update teh business requirements. Developed product development.
• Setup teh environments for DEV, QA and PROD Server for this implementation.
• Interacted with MS excel as data source from GSE & GSAP Databases to understand teh BRD’s and convert them to tangible Technical spec’s to be used in Dash board report specifications.
• Coordinated teh business teams to update teh business requirements. Developed product development and Performance tuning on both admin and Dashboards application level and Initial testing activities.
• Automated reports by using VBA Macro’s In MS excel to convert source Data into XML formats, Those XML (URL’s) file incorporated into XCELSIUS Dashboards with XML data Connections and good UI design.
• Design and Develop teh Complexes Xcelsius-2008 dashboards using Lookups and various formulae to analyze teh data. Hands on knowledge of EIR Accessibility, required technical specifications
• Good Experience in EHSM Incident Management enhancements onBOPF using Enhancement Workbench, consuming web services EHSM. TPM reporting experience
• Worked as architect role to provide End to End solutions for various Environments. Unit testing, integration Testing, and automated testing.

Environment: SAPBO Xcelsius-2008(Dash Boards), MS excel, VBA macro’s, XML data/ Web service Connection, BOPF, EHSM, Live office, BIWS / Query As A Web Service(QAWS).

Sr. BO Developer at Caterpillar

Confidential, TX

Responsibilities:

• Worked as architect role to provide End to End solutions for various BOBJ tools with in teh Environment
• Attended Business meetings assisted to Business Analysts and gatheird requirements as per Data Model.
• Designed universes and applied row level and objects level restrictions to different groups and users as required.
• Setup teh environments for teh DEV, QA, and PROD Server for this implementation and good UI design.
• Designed universes (Information designer tool) IDT and applied row level and objects level restrictions to different groups and users as required. Set hierarchy, cascading prompts and Initial testing activities.
• Developed Universe by using BEX and Created Complex WEBI and Xcelsius Dashboards by using live office, BIWS / Query as a Web Service. TPM reporting experience. Creating data state jobs.
• Coordinate with teh client s to update teh business requirements. Develop teh entire product development.
• R&D latest (BOBJ4.0) version we used in teh project and also guide teh team members, and take responsibility to Reached customer desires. Extract, transform and load teh Data by using various transformations.
• Design and Develop teh WEBI Reports using teh features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze teh data.
• Created user Prompts, Conditions and global Filters for various reports to specify teh reporting parameters.

Environment: SAPBOXIR4.0 (BOBJ4.0) Information designer tool, BI launch Pad, Web intelligence Rich client, SAP Business Object Explorer, SP1,2,&3, Dashboards, Live office, BIWS / Query As A Web Service, Windows 2000 Server, IBM Data stage 8.5, Teradata13.0.Informatica.

SR Sap Consultant

Confidential

Responsibilities:

• Attended Business meetings assisted to Business Analysts and gatheird requirements as per Data Model.
• Setup teh environments for DEV, QA and PROD Server for these implementations and moved teh Reports.
• Designed Universe and applied row level and objects level restrictions to different groups and users as required. Developed Universe by using BEX and Created Complex WEBI and Xcelsius Dashboards by using live office, BIWS / Query as a Web Service.
• Interacted with SAP BI a team member to understand teh BRD’s and convert them to tangible Technical spec’s to be used in report specifications.
• Coordinated with client s to update teh business requirements. Developed teh entire product development.
• Embedded reports directly into developed web applications and thick client report generation and good UI design.
• Used @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), and @Select to create duplicate objects in teh process of building teh Universes. Unit testing, integration testing.
• Very good experience in design dash boards like global filters, Complex Dash boards and Complex reporting.
• Created user Prompts, Conditions and global Filters for various reports to specify teh reporting parameters.

Environment: Sap BO XI R3.1,BI/BW Designer, Info View, Web intelligence Rich client, Live office3.1, BIWS / Query As A Web Service, SP3, Xcelsius-2008, Windows 2000 Server, Sap R/3.

BO Developer

Confidential, NJ

Responsibilities:

• Developed universes, reports using Designer, Web Intelligence and Desktop Intelligence. Create metrics and Dashboards using Application Foundation and good UI design.
• Export teh universes to teh Repository to make resources available to teh users. Create reports for various Portfolios using teh Universes as teh main data Providers.
• Handled all teh change requests to teh existing universes requested by reporting team.
• Worked towards optimal development of universes by removing loops through teh use of aliases and contexts, Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equiv. joins as per requirement.
• Used Dashboard Manager to build Dashboards and deploy them across teh organization to monitor business Performance. Unit testing, integration testing, and automated testing
• Analyzed teh business logic built into teh warehouse and also gatheird user requirements for teh reporting work
• Documented requirements and performed Gap analysis to identify teh gaps.
• Performed extraction, transformation and loading of data warehouse and Data Marts.
• Data modeled part of teh warehouse tables and was part of teh team in designing teh final conceptual, logical, physical model. Designed and configured both teh real-time and batch jobs
• Enabled Single Sign on and integrated their use base in to Enterprise mode of BO XI R2 Autantication using teh LDAP Java SDK plug in.
• Enabled monitoring of File Server, Job Server and Event Server for Scheduling jobs, etc. Using SDK.

Environment: Designer, WebIntelligenceXIR2, Crystal Reports, Performance Management, Data marts, SQL Server, Windows 2000/XP.

BO, ETL Developer at

Confidential

Responsibilities:

• Interacted Users and Business Analysts to understand and document teh requirements and translate these to Technical specifications for designing Universes and Business Object Reports.
• Designed and implemented Data Models to meet existing and future anticipated reporting requirements. Also involved to modifying teh existing data model as per requirement and good UI design.
• Designed Universes using BO XI R2 designer by retrieving data from database, using Derived tables, defining teh necessary connections and exported them to specific universe domains.
• Implemented various types of joins including equijoin, outer-join, theta-join, self-restricting join, defined Cardinalities and resolved issues like loops by creating aliases and contexts to remove teh cyclic dependencies.
• Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and Custom Hierarchies for drill down purposes
• Extensively to work with Web Intelligence XI R2 and Info View to create thin client reports based on teh business Requirements. Unit testing, integration testing, and automated testing
• Designed and Developed WEBI Reports as per teh Users Requirements using teh features in Business Objects Including: Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze Teh data with halp of aFacets 5.3software environment.
• Analyzed, designed, built and tested reports while working directly with end-users and technical members of teh Team. Understanding of lab data, non-lab clinical data like BMI CPT codes, HL7.
• Created user Prompts, Conditions and Filters for various reports to specify teh reporting parameters as per teh Business rules and teh requirements of teh end users.
• Created Crystal Reports Templates to support Corporation Report Standards and color scheme.
• Use teh Dashboard Manager to build Dashboards and deploy them across teh organization to monitor business Performance.
• Created Production support documentation and user manuals for teh end user understanding and training.

Environment: BO XI R2 (Designer, Info View, WEBI), Crystal reports XI, Dashboard Builder, SDK, SQL Server, Windows 2000 Server, Testing, EDI, HL7,HIPAA,Clarity, Facets.