SUMMARY:

• Over 9+ years of experience in Software Development Life Cycle wif strong emphasis in Requirements Gathering, Functional Design Preparation, Unit & System Testing, Offshore - coordination and Interaction wif Business Users.
• 6+ years of experience in Business Objects Enterprise Suite XI R3/R4, BO Data Services 4.2, Information Steward 4.2/4.1, IDT 4.x, SAP HANA Studio, WebI, CR & Dashboard designer.
• Mastered teh ability to design and deploy rich Graphic visualizations.
• Created Look & Feel Dashboard Design for Management perspective reports.
• Involved in performance tuning in BODS & Reporting as well.
• 4 years of extensive Tableau Experience in Enterprise Environment in Tableau 7.0, 8.x as a Developer and Analyst.
• 3 years of experience in Java/J2ee technologies.
• 2 years of experience in Informatica in loading huge amount of data into data warehouse.
• Experienced in 2 full life cycle implementations and 3 migration from SAP BO3.X to SAP BO 4.x & BODS 4.0 to 4.2.
• Experienced in Installing/Migrating Information Steward 4.2/4.1 on BI Platform.
• Experienced in developing data models in HANA 1.0 SP7.
• Well versed in using DS Designer toETLfrom multiple sources including Flat Files, Excel, XML,
• Experienced ininstalling BODS XI 3.2/4.x including Client/Server and configuring JobServer, Access Server, Profiler Server and setting up Local, Central & Profiler Repositories on top of BI.
• Installation and configuration of BOE, BODS 4.X & Information Steward 4.2.
• Good noledge in Data Quality for monitoring, maintaining & standardize teh Data using Information steward 4.1/4.2.
• Experienced in generate teh reports based on FI, CO-PA, GL, AP, SD and MM.
• Extracted data from BW7.x to BODS using OHD technique & DTP for data transformation.
• Involved inPerformance Tuningtechniques to improve in ETL, Universe & Report levels.
• Experienced in writing, testing, debugging, documenting & implementing complex Batch Jobs & Real time Jobs to extract data from variety of data sources, transform teh data & load teh data to specified destinations.
• Created complex WebI reports directly from BW using BEx, OLAP analysis tool.
• Created complex WebI reports using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis.
• Created Look & Feel Dashboard for Management perspective reports.
• Experienced in BO Installation & administration, Creating Repository, adding Users and Groups, Assigning Password Security, Assigning Privileges to Documents and Universes.
• Very good experience in Dashboard Design & Web Intelligence Rich Client.
• Migrated documents, Reports, Users and teh Universes using teh Import from BOXIR3.1 to BO4.0/4.1.
• Creation of Dashboards Converting Business Data requirements into Conceptual and logical data models. Commonly used excel functions. Microsoft Excel as a data source.

TECHNICAL SKILLS

BI Tools: SAP Business Objects 4.1, Dashboard design, WebI, BEx, OLAP analysis, Crystal Reports, SPAGOBI, Tableau.

ETL Tools: SAP BO Data Services 4.2/4.1/4.0/XI3.2/3.1(Designer, Repository Manager, DS Server Manager, SAP BO Data Integrator XIR2/11.7/11.5), Information Steward 4.1/4.2, Informatica.

Operating System: Windows NT 2000/ 2003/XP, Linux.

Databases: SAP HANA 1.0(SP07), Oracle 10G/11G, Teradata, MS SQL Server 2008.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

SAP HANA/BODS/BI Consultant

Roles and Responsibilities:

• Worked on creating Data models such as Attribute Views, Analytic Views & Calculation Views
• Provided guidance and advice to SAP Customers, Pre-sales and Solution Architect resources on teh development of HANA solutions.
• Delivered Documentation for all new objects and enhancements.
• Participated in GO LIVE and Production support.
• Worked wif end users in understanding teh current Budgeting scenarios from various business units and gathering new requirements.
• Good working noledge of SAP BO Data services 4.x & SLT replication methods.
• Connected to IMCE from Reporting tools such as WEBI and Crystal reports using Universe and Information Design Tool to generate teh reports based on FI, CO-PA, GL, AP, SD and MM.
• Created & designed Universe for reporting from Information models
• Developed and foster a collaborative working relationship wif clients
• Assigned appropriate rights to users and user groups to access reports on teh Business Objects Info View using teh Central Management Console.
• Involved in developing and conducting extensive Unit testing, Integration testing (SIT), Regression testing, User Acceptance Testing (UAT) and documentation.
• Developed BOBJ Crystal Reports for Month at a Glance report based on user requirements.
• Created Custom Monthly and Yearly Trend Reports per Profit Center, Segments for Actual data in General Ledger.

Environment: Business Objects 4.1, BO Data Services 4.x, SAP HANA 1.0, Oracle 11G, Dashboard design, Crystal Report, WebI, IDT4.1, BW7.x & SAP ECC.

Confidential, Houston, TX

SAP ETL/BOBJ/BI Lead Consultant

Roles and Responsibilities:

• Involved in Midstream & downstream analysis in Oil & Gas industry.
• Administration & configuration of multiple data stores & servers.
• Involved in gathering, analyzing, business requirements, and functional requirements and data specifications for data migration using BODS and BO Universes and Reports.
• Completed End-to End full HANA life cycle implementations including ECC, BODS, HANA, Information Design Tool and WEBI/ Crystal Report/ Dashboard on teh reporting side.
• Created various local, central repositories for users in DEV and Data stores made available in Central repository for different sources and target SAP ECC & SAP HANA1.0.
• Designed and developed ETL jobs in BODS, modified or created new Data Services jobs to meet project requirements.
• Created complex Web intelligence reports using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis.
• Designed and implemented ETL jobs by involving teh extraction of data from a variety of legacy systems, integration, and cleansing of data before loading into data warehouses.
• Experienced in extracting data from SAP ERP system (Tables, Hierarchies, RFC Function Modules) using BODS.
• Support & Fix all teh test cycles, trail/technical/Go-Live Cutover defects for several releases.
• Migrated jobs, rules, tables between DEV, TEST, and Pre-Prod and to PROD, & scheduled teh jobs. Worked on teh Data Quality, Data cleanses transformations for cleansing teh data.
• Worked on BODI/BODS transformation like Formats and Transforms including Flat File formats, Query, Table Comparison, History Preserving, Reverse Pivot, Pivot, Hierarchy Flattening, Match Transform, Validation Transform, Key Generation and Map Operation.
• Designed modeling in SAP HANA studio & created views & created reports from calculation views.
• Involved in BODS Data Integrate/Data Quality & platform.
• Performance-tuned complex Data Services projects and workflows related to a SAP ECC.
• Conversion involving data/address cleansing and multi-level Organization/Contact duplicate Utilized Data Profiling including Column and Relationship on tables.
• Data integration & data migration from ECC to HANA system
• Loaded teh test data to estimate job run time and Performance Statistics and optimized and fine tuned teh job. Used Push Down where applicable.
• As part of BODS up gradation, actively participated wif configuring and migrating repositories, Data profiling including column & relationship on tables.
• Architecting a HANA solution for teh OLAP analysis through leveraging data from source systems
• Implemented teh Object-Level Security and Row-level security in Universe. Implementing teh Table Mapping in Universe to restrict certain data in a table to only one group of users.

Environment: Business Objects 4.1, BO Data Services 4.1/4.2, SAP HANA 1.0, Information Steward 4.2/4.1, Oracle 10G, SQL Server 2008, Dashboard design, WebI, Tableau 8.1, IDT4.1, SAP ECC.

Confidential, Owings Mills, MD

SAP BODS/BI/BO Consultant

Roles and Responsibilities:

• Used Formats and Transforms including Flat File formats, Query, Table Comparison, History Preserving, Hierarchy Flattening, Match Transform, Validation Transform, Key Generation and Map Operation.
• Performance-tuned complex Data Services projects and workflows related to Database.
• Used Auditing and filtering features to analyze teh data flow and performed debugging to do Error Management.
• Leading a team of consultants for a BI Analytics enterprise reporting deployment.
• Writing SAP BEx queries using Query Designer.
• Utilizing ETL to extract, transform, and load data from various disparate sources
• Extensive noledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc.,
• Worked on teh development of Dashboard reports for teh Key Performance Indicators for teh top management.
• DevelopedProvider scorecard reports using WebI as teh reporting tool.
• Developed a complexprovider scorecard dashboard wifmultiple tabs using dynamic visibility.
• This dashboard shows teh high level information ofrolling 12 months of provider performance datavarying across different areas like productivity, machine utilization, compliance and quality.
• FormattedWebI reportsandscheduledthem to be busted as pdf to theirport to web server.

Environment: Business Objects XI R3/4.0, SAP Data Services 3.x/4.0, Oracle 10g, Crystal Reports 2008, Dashboard Design, WebI, BEx, IDT4.0, Tableau, Windows NT & Linux

Confidential, St Paul, MN

SAP BI/BO Consultant

Roles and Responsibilities:

• Worked wif large volumes of data and being able to build summary tables for teh dashboard
• Profit & Loss Predictive analysis using Dashboard design for management analysis.
• Worked on preparing teh Dashboard specification Documents.
• Created Look & Feel Dashboard for Management perspective reports.
• Built multiple universes wif appropriate Joins, Aliases and Aggregate awareness tables and built customized Classes and Objects.
• Created Reports related to Revenue Analysis, Expense, Cash flow, Cost allocation, Equity/Earning analysis.
• Generated context filters and used performance actions while handling huge volume of data.
• Worked on Data Modeling using Dimensional Data modeling, Star Schema, FACT & Dimensions tables, Physical & logical data modeling.
• Worked on teh Performance tuning of teh Dashboard.
• Created complex new Universes, Linked wif existing Universes from Data marts.
• Resolved loops and Traps, created complex Reports, Cross Tab and Master Detail reports by using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerts and other features.

Environment: Business Objects XI R3, Crystal Reports, WebI, Dashboard Designer, Oracle 10g.

Confidential, Baltimore, MD

SAP ETL/BO Consultant

Roles and Responsibilities:

• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into teh target tables in Teradata Database.
• CreatedMapplets, reusable transformationsand used them in different mappings.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Worked on teh Performance tuning of teh Dashboard.
• Created ad-hoc reports in WebI.
• Developed new Universe as per teh business requirement.
• Analysis, Design and GUI Development.
• Analysis all Information about various aspects including income-tax law and procedure.

Environment: Java/J2ee, JSP, Tomcat5.0, Oracle, Windows Server 2003.