SUMMARY:

• Over 10+ years of experience in Software Development Life Cycle with strong emphasis in Requirements Gathering, Functional Design Preparation, Unit & System Testing, Offshore - coordination and Interaction with Business Users.
• 6+ years of experience in Business Objects Enterprise Suite XI R3/R4, BO Data Services 4.x, Information Steward 4.x, IDT 4.x, SAP HANA Studio, WebI, CR & Dashboard designer.
• Mastered the 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.0 and 8.1 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 from multiple sources including Flat Files, Excel, XML.
• Experienced ininstalling BODS XI 3.2/4.x including C/S 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 knowledge in Data Quality for monitoring, maintaining & standardize the Data using Information steward 4.1/4.2.
• 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 the data & load the 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 the Universes using the 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, Houston, TX

SAP ETL/BOBJ/BI Lead Consultant

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.
• 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 the 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 the 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 the jobs. Worked on the Data Quality, Data cleanses transformations for cleansing the 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.
• Worked on the vendor master, customer master and material master IDOCS: CREMAS, DEBMAS, MATMAS &Developed workflows to load data into Customer Master Sale's data (KNVV) and Partner roles (KNVP) from legacy systems.
• As part of BODS up gradation, actively participated with configuring and migrating repositories, Data profiling including column & relationship on tables.
• 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 the test data to estimate job run time and Performance Statistics and optimized and fine tuned the job. Used Push Down where applicable.
• Architecting a HANA solution for the OLAP analysis through leveraging data from source systems
• Implemented the Object-Level Security and Row-level security in Universe. Implementing the 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

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 the 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 knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc.,
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Designed Dashboard on Weekly/Monthly/Quarterly & yearly reports.
• DevelopedProvider scorecard reports using WebI as the reporting tool.
• Developed a complexprovider scorecard dashboard withmultiple tabs using dynamic visibility.
• This dashboard shows the 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 thereport 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

Responsibilities:

• Worked with large volumes of data and being able to build summary tables for the dashboard
• Profit & Loss Predictive analysis using Dashboard design for management analysis.
• Worked on preparing the Dashboard specification Documents.
• Created Look & Feel Dashboard for Management perspective reports.
• Built multiple universes with 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 the Performance tuning of the Dashboard.
• Created complex new Universes, Linked with 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

Responsibilities:

• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the 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 the Performance tuning of the Dashboard.
• Created ad-hoc reports in WebI.
• Developed new Universe as per the business requirement.

Environment: Business Objects XI R3, Informatica, Teradata, Xcelcious, Crystal reports, universe designer, CMC.

Confidential

Java/J2ee Developer

Responsibilities:

• 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