SUMMARY:

• Over 12 years progressive IT consulting experience with an emphasis in technical design, development, and deployment of cross - functional Business Intelligence (BI), Enterprise Data Warehouse & Enterprise Reporting Solutions.
• Extensive BI experience along with 3 successful Full BI Life cycle & 3 production Support deployment including requirement gathering, confirmation & acknowledgement, planning, designing, development, test & Rollout/ Go Live. Experience in Complex Universe Design, HANA Modelling, Technical and functional expertise in Reporting and Dashboards development.
• Strong experience in Business Objects 4.2/4.1/3.1/XIR2 suites, SAP BI/BW 7.4/7.3/7.0/3.5, SAP BW-BOBJ Integration, HANA Analytical Modelling, SAP ABAP and Reports and Dashboards Development.
• Strong experiences with BOBJ front-end reporting Tools (WEBI, Crystal Reports, Dashboard, Explorer)
• Excellent understanding & work experience of building complex Universe(s) (UNV & UNX) of normalized & De-Normalized schemas using Information Design Tool (IDT & UDT) in Single or Multi Data Sources environment.
• Strong work experience in Dimensional Modeling and designing Star and Snowflake Schemas, Fact and Dimension tables.
• Experience in Designing/Developing Universes/Data-Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports utilizing Best Practices in Enterprise Business Intelligence Solutions.
• Excellent skills to develop challenging reports using Web Intelligence 4.2 & Crystal Reports in Multi-Data Sources environment with SAP BW Queries using BICS, HANA DB, Non-SAP Sources (Oracle, Teradata, SQL Server, DB2).
• Designed & Developed cross tab reports, reports with sub reports (linked & unlinked) and charts using Crystal Reports.
• Extensive experience in creating Dashboard Solutions, Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Dashboard Designer Components like Charts, Selectors (Filters, label Based menus), Canvas Containers.
• Strong knowledge In creating connections using Data Connection manager like Query Bowser, Live Office, Query As A Web Service (QAAWS), Flash Variables, SAP BI connectors, UD connecters, DB connectors.
• Experience in Business Explorer Suite - BEx Query Designer, BEx Analyzer and BEx Web Analyzer.
• Created connections to BEx queries and BW Objects (InfoCubes, DSO’s, and Info Providers) using BICS connections in IDT.
• Strong experience as BusinessObjects (BOE) Administrator including installation, configuration of BOE tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.
• Experience in BO Administration & CMC Administration activities like installation, configuration of BOE tools, set up & managing repositories, BOE Security, managing/granting user group, profile through Central Management Server.
• Migrated Universes, Reports and Users from XI R3 to BI 4.2/4.1 using Upgrade Management Tool in BI 4.2, Coordinated and executed Business Objects migration from XIR2 to XI 3.1 SP3 Using Import Wizard and BIAR files applying Business Objects Best Practices.
• Experience with Promotion Manager using CTS in migrating universes, reports and Dashboards from Dev to Test, UAT and Production environments.
• Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills.
• Wide experience in interacting with end-users to gather and document the reporting requirements and giving training to the end users.

TECHNICAL SKILLS:

Business Intelligence Tools & ERP: Business Objects BO BI Suite 4.2/4.1/4.0/XI, SAP BW 3.7/7.3/7.4, ECC 6.0, Central Management Console (CMC), Central Configuration Management (CCM), Central Management Services (CMS), BICS, Universe Designer (IDT & UDT), Web Intelligence 4.1,, Live Office, LCM, QaaWS, Live office, Dashboard designer 4.x, Query Designer, Lumira, Crystal Reports 2008/2011, HANA 1.0/2.0, QlikView, Tableau, BEx Query Design, Query Analyzer, ABAP

ETL Tools: SAP BW 7.3/7.0/3.5, BODS 4.x, Informatica Power Center V 10, SAS 9.x, SSIS

Data Modeling Tools: Dimensional data modeling, physical & logical data modeling, ERWIN, Visio, Star Schema Modeling, Snow flake Modeling.

Databases: Oracle 11g/10g/9i, SQL server 2000/2005/2008, IBM DB2, MS Access, Teradata V 15.x, Sybase, HANA 1.0.

GUI Tools: Java Script, UI5, Visual Basic 8.0/9.0, VSS 6.0d, TOAD.

Web Application Servers: Weblogic 7.0, Apache Tomcat, Web Sphere, IIS 6.0

Languages: C, C#, Java (J2EE), SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, MD

Senior SAP Business Objects BI Consultant

Responsibilities:

• Building complex Universes geared towards Self-service environments and adhering to the functional requirements, making sure that objects exposed from Self-Service model produce the correct report outcome with various permutations and combinations allowed to the end user.
• Experience in reporting methodologies, scheduled delivery of reports, ad-hoc execution of reports, metadata, drill-downs/through, and Composite model using BW cubes.
• Build canned reports, some of which are quite complicated; adhering to leading practices fulfilling the required functional requirements- chart, line, bar, stacked bar, pie, tabular, cross-tab
• Create, Design, administer & manage 75+ WEBI (Canned & matrix Reports) & 20+ Crystal Reports and 12+ Deski Reports converted to 8 Webi 4.2 Canned Reports in Contracting Operation (ConOps) group, Financial & budget management, G8 Manpower & several PM/PEO offices.
• Created Technical specification for indicated Business Objects indicated artifacts.
• Provide data analysis, design, modeling, and implementation leadership to development team, functional team, and power / end users to ensure that reporting solutions are designed and aligned with Army Contracting Command(ACC) HQ architectural direction.
• Created multiple Business layers on the data foundation in BO 4.1 IDT with single Data source and Multiple Data Sources.
• Created Classes, Prompts, Alias, Contexts & number of derived tables and used oracle functions like Start with, Connect by Prior, List Agg, DBMS lob etc.
• Used Index Awareness concept extensively in the Business layer to improve the performance of the Query /BOE report.
• Successfully implemented Business Objects functionalities like Contexts, Aliases, Aggregate Awareness, Derived Tables, Cascading LOVs, Customized LOVs, and Cascading Prompts.
• Created complex and sophisticated ad hoc reports with multiple Data Providers, Master/Detail, Breaks, Filters, Drill Down, Slice and Dice features, 2D/3D charts, Dashboards, Scorecards.
• Support end users questions as it relates to the released Universes, Canned Reports, and end users reports.

Environment: 115+ WEBi, 32 Matrices Reports SAP BO BI 4.1 Support Pack 4 1000+ Authorized User Oracle 11G Six BI Servers Remedy 7.6/8.1 Six Dashboard Applications (Xcelcius/Design Studio) QlikView/ Qlik Sense Informatica Power Center V10 Tomcat Apache

Confidential, Vienna VA

Senior SAP BOBJ BW HANA Consultant

Responsibilities:

• Performed the role of a Senior Consultant in delivering solution to meet both standard and non-standard business requirements of the business end-users
• Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views (Graphical and SQL Script) to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Created Attribute views with Hierarchies, Calculated columns in an Analytic view, and Calculation views in SAP HANA.
• Develop SQL scripts and functions for complex reusable scenarios in HANA.
• Consumption of HANA information Models in BW by creating Composite and Transient Providers.
• Creating InfoCubes, InfoObjects, DSO's, DataSources, InfoPacakages, Process Chains, DTP's, Transformations, Activating & Enhancing Business Content, Routines, etc.
• Designing BW jobs and retrieving data from ECC and SCM using extractors to BW.
• Working with SAP BOBJ Business users and involved in requirement gathering, analysis and creation of best practices architecture.
• Experience in creating universes using information design tool 4.x and connecting to multiple data sources.
• Involved in developing, designing, maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Modified BW queries in to generate WEBI & Crystal reports using BI Launch Pad in BO to meet user requirements.
• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
• Created monthly and summary reports in WEBI 4.1 for the domains like Finance, Marketing Payroll and HR domains.
• 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.
• Created & schedule Crystal reports and deployed them through BI Launch Pad with Bex as source.
• Exclusively used QAAWS and Live Office to import data to spreadsheet and develop visually rich Dynamic Dashboards.
• Documented all design and development efforts in accordance with Software Development Life Cycle standards

Environment: SAP BO 3.1/4.0/4.1, WEBI 4.x, Crystal Reports 2011, HANA 1.0 SP7, SAP BW 7.3, ECC 6.0, BODS 4.x, BEx, IDT, Dashboard Design Tool, Design Studio, BICS, Live Office, Oracle 10g, TOAD, HP ALM.

Confidential, Alexandria, VA

SAP BOBJ Consultant/Reporting SME

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate to Technical specifications for Designing Universes & custom Reports.
• Created & managed 120+ Webi & Crystal Reports for Various user group (Asset Management, HR & Payroll, Deployment Operation & Baseline management)
• Migrated Universes, Reports and Users from XI R3 to BI 4.0 using Upgrade Management Tool in BI 4.0, Coordinated and executed Business Objects migration from XIR2 to XI 3.1 SP3 Using Import Wizard and BIAR files applying Business Objects Best Practices.
• Migrated all the Users, User Groups model and Folder Structure into new environment also setup content security model for the users.
• Migrated Events and Calendar objects from old environment to new to schedule production reports and Setting up security model.
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.
• Provide Training & On-call Power users support for all BOBJ Support & reporting needs.

Environment: Business Objects 4.0/XI 3.1, WEBI 4.0, Crystal Report 2008, Dashboard 4.0, Informatica Power Center, Teradata V 14/15, Oracle 11g, CMC, BMC Remedy 6.7, VB.NET, QAAWS, Apache Tomcat 5.5/6.0, Windows Server 2008 R2, LDAP

Confidential, Newark NJ

SAP Business Objects Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate to Technical specifications for Designing Universes.
• Worked on System Integration Testing, User Acceptance Testing. He was also involved in resolving day-to-day problems in Business Objects Applications using SAP Business Objects XI, Teradata and Windows XP.
• Responsible for support and maintenance of MBT DWH and MBT Data Analytics reporting applications Create documentation to support design, build and unit testing of Business Objects reports; Analyze, organize, and prioritize reporting requirements.
• Worked in Fixing Post Production Defects/issues on BO reports and Universes and Working with business users on resolving report, universe and Data issues.
• Worked in implementing Migration plan and implementation for Defect/Enhancements in Universe and Reports and providing status reports to managers.
• Worked in Incident resolution, ensuring adherence service-level agreement (SLA) and Interact with end users to understand business needs and requirements and resolving report, universe and data issues.
• Responsible for handling team with sufficient task every day and track all the incidents/Defects/Enhancements in tracking tool service now and interacting with SAP Business Objects Admin team to migrate reports and universe from development environment to production environment.
• Worked on gathering Customer, User and Owner requirements; analyzed and documented them.
• Responsible for tracking and day-to-day team work on incidents, defects and Enhancements in the project and responsible for updating the status to project manager.

Environment: Business Objects XIR2/R3, Crystal Reports XI, WEBI XI R2/R3, Oracle, Informatica Power Center, QaaWS, HP ALM, Solaris

Confidential, Chantilly VA

Business Objects & Crystal Reports Consultant

Responsibilities:

• Responsible for Universe Design & optimization, development of Ad-hoc & Formatted Crystal Reports solutions.
• Created & maintained 60+ Daily, Weekly, Bi-Weekly, Monthly & YTD custom reports.
• Design and develop various universes and configure Joins, Cardinalities, Loops, Contexts and Shortcut Joins.
• Use Database Expert, Group Expert, Select Expert, and Section Expert to create different Crystal reports.
• Provide Onsite end user training & On-call support for their business needs.

Environment: Business Objects XI R2, Crystal Reports XI, Informatica Power Center, DB2, Oracle 10g/9i, LDAP, Mainframe

Confidential

BI Reporting Developer

Responsibilities:

• Participated in Multiple Critical and cutting edge efforts with Data Analytics & Business Intelligence Team Responsibilities were related to Finance, Delivery and Information systems in order to meet business objectives, such as achieve financial forecasts,
• Delivery Performance, developed web-based portal Information System to capture, distribute and report all financial and deliveries information.