SUMMARY:

• Fifteen Years of IT Experience of Managing, creating, and supporting of Complex Applications using traditional Data Warehousing and ERP solutions such as SAP Business Objects, SAP BODS, Information Steward, Actuate, Tableau with Oracle,DB2, SQL Server, Teradata, BW, HANA and PeopleSoft.
• Worked with SAP implementations for their SAP BOBI, DS, IS in 4.X upgrades, migrations and new environments in single and multiple deployments across Windows, Linux and Unix platforms.
• Involved in Full life cycle (Solution Blueprint, Project planning, Requirements Gathering, Architecture, Installation, Integration, Analysis, Design, Development, Cutover, Deployment, Support) of Business Objects reporting & analytical Applications with SAP and Non - SAP backgrounds.
• Worked 10 years as a Sr. developer & system Admin, 5 years as a BI Lead & Architect for SAP BI implementations.
• Worked 4 years in SAP Analytics area by using SAP Xcelsius, Dashboard Designer, SAP Design Studio, SAP Lumira, SAP Predictive Analysis, Analysis suite for Office / OLAP and SAP BO Explorer.
• Worked 5 years as a Subject Matter Expert role in SAP BOBI 4.X/XI 3.X/ XI R2.
• Worked 6 years in SAP Business Objects Data Services (BODS) and Information steward (IS) for data migrations and metadata management.
• Three years (3) of experience with SAP HANA data modeling by using Native HANA, BW Powered by HANA and HANA LIVE.
• Two and half years experience in EPIC Hospital Billing, PQRS, Ambulatory related BO Reports and universes.
• Programming knowledge in Teradata 4.0/5.0, ORACLE 8i/8.x/7.x/6.x, SQL Server 6.5/7.0/ 2000, MS-Access, DB2 and Sybase.
• Strong in SQL, DB2, Teradata, PL/SQL, SQL*LOADER, SQL*PLUS, DTS, MS-SQL & VB
• Experience in Erwin 3.5.2/4.0, Cognos and Informatica
• Experience in Sales, Marketing, Banking, Oil & Gas, Financial and Insurance Industry.
• Expert in Business Requirements Gathering, Gap analysis, Functional Documentation, Technical documentation, Mentoring and Training for Business & Technical people in BI area.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr. SAP BODS & HANA Developer

Responsibilities:

• Installed and configured SAP BOBI 4.1 SP2 in Distributed environment and upgraded to SP5 & 6 with different patches.
• Installed & configured BODS 4.2 SP5 and BO IS 4.2 SP 3/SP5in different servers and integrated with BO 4.1
• Migrated BO 3.x to 4.1 SP2 and then SP6 with latest patches.
• Prepared BI Security model for the new SAP Business objects environment for 5000 users.
• Prepared and given demo in SAP BO reporting & Analytical applications (WebI, Crystal, analysis suite, Lumira, Design Studio and Predictive Analysis) for senior executives & managers.
• Prepared blue print for SAP Production landscape for 5000 users, 700 WebI reports, 25 dashboards, 100's of ad-hoc users for Analysis suite & Lumira.
• Created AR, AP reports by using Webi in FICO modules and SAP BO Rapid Marts.
• Created WebI reports, Crystal Reports by using OLAP and relational databases.
• Created Dashboard by using Xcelsius dashboard designer and Design studio 1.3 & 1.5 with Java script and CSS.
• Created Story books from different data sources by using Lumira.
• Created various dashboards by using Dashboard Designer tool & Design Studio with Java script, global functions and CSS.
• Created Webi, Crystal Reports, and Workbooks by using analysis suite and storybook reports from SPA Lumira.
• Worked on creating local and central repository and providing user roles and maintaining groups and configured job server to local repositories in BOBJ Data Services.
• Worked on data profiling, creating scorecards, validation, matching strategy and finding duplicates using Information Steward 4.2.
• Worked on creating batch jobs for address cleansing, data cleansing, match transforms as part of the data quality process in Data Services.
• Use control tables to find easy ways to identifying the problem/job failures.
• Used parameters, variables and Global variables depending on necessity.
• Shutdown and start-up of servers as part of the weekly maintenance.
• Configured repositories in DB2 environment.
• Worked on DS workbench in designing the jobs based on business needs.
• Used try catch blocks for error check.
• Created several stage jobs for importing the source data into staging environment for further processing.
• Created complex DS batch jobs and heavily used Data Cleansing and Address cleansing transforms to standardize name and Address data.
• Extensively done data profiling, column profiling, Uniqueness profiling using for KNA1, ADRC, LFA1, MARA tables using IS.
• Worked on creating user roles in Information Steward
• Worked in creating data store connection and using flat files as sources.
• Worked on cleansing data. Performed Data Quality tests.
• Worked on validation rules, Unit testing of rules, and built scorecards in Information Steward.
• Worked on Data Services workbench in designing the jobs based on business needs.
• Created complex Data Services batch jobs and heavily used Data Cleansing and Address cleansing transforms to standardize name and Address data.
• Extensively done data profiling, column profiling, Uniqueness profiling using for KNA1, ADRC, LFA1, MARA tables using IS.
• Created HANA Modeling in Native HANA for customer, material, fico and SD modules in BW powered by HANA
• Designed, Developed and Deployed Dashboard in Design Studio with HANA models which is replacement to the old Bex based reporting system.
• Creation of calculated measures, restricted measures, filters, variables and Analytical privileges in HANA.
• Used Data Services as well as SLT to get the tables from ECC to HANA as a source.
• Created Attribute views, Analytical views and complex calculation views in HANA Data modeling.
• Created custom Hierarchies in HANA for traditional as well as transactional hierarchies.
• Created HANA SQL Scripts as a process of ongoing reusable packages for some of the complex aggregation & projection tables.

Environment: SAP BOBI 4.1 SP6, SAP BODS 3.1/4.1, SAP Information Steward 4.1, Lumira 1.28, SAP Predictive Analysis2.0, Tableau 9.0, Dashboard Designer tool, Design Studio 1.5/1.3, Analysis Suite for Office/ OLAP, COPA HANA, HANA Studio, HANA Live, BEx Analyzer, BEx Query Designer, SAP BW 7.3, SAP Data Services 4.1 SP2, SQL Server 2010, MS Access, MS Excel, Oracle 10g.

Confidential, Houston, TX

Sr. SAP BO /BODS/HANA consultant

Responsibilities:

• Working as a Developer, Admin and Architect for both SAP & Non SAP based BO solutions.
• Installed, migrated, upgraded from SAP BO BI 3.x to 4.0 SP2 to FP3 and then recently upgraded to 4.0 SP4 /SP6 with latest patches.
• Solved lots of server performance issues and redesigned production lay out.
• Designed and developed distributed SAP BO Architecture for better performance and global needs.
• Designed and developed Multisource Universes with SAPBW, SQL Server, Oracle databases.
• Created Webi reports and Xcelsius dashboards in FICO, HR, SCM, SD, MM modules by using BEX queries.
• Mentored and trained full time resources for the ongoing support.
• Created relational universes on top of SAP BW Multi cubes and combined with existing SQL Server & Oracle databases for multiple sources.
• Created BICS based WebI reports, crystal reports by using SAP and Non-SAP data sources
• Created Xcelsius dashboards and Design Studio dashboards in 1.1 & 1.2 by using Java scripts and CSS style sheets.
• Involved in Data Quality (address validation), Match, De-dup, Data cleansing, Data Profiling using SAP BODS for Customer master and material master and vendor master data.
• Involved in Information Steward administration by creating project work space, import, export from one land scape to another landscape.
• Involved in Views and derived views creation, Address Profiling, Column profiling, Dependency profiling, Uniqueness Profiling using Information Steward.
• Involved in integration of Information Steward rules in DS jobs as part of the reusability.
• Used IDOC’s (Debmas, Cremas) to load the Customer and Supplier data into the target SAP system by SAP Business objects Data Services.
• Involved in Customer/Vendor Rules review with Data stewards and updated them as per IS/DS standards.
• Installed, Configured BODS with BO as well as and separate IPS.
• Created Transformations on top of flat files to load data in SQL Server 2010 by using SAP BO Data Services 4.1
• Created BODS Transformations for Legacy systems to SQL Server & Oracle databases.
• Installed and configured SAP Data Services and Information Steward.
• Configured repositories in DB2 environment for Information Steward & Data Services.
• Worked on DS workbench in designing the jobs based on business needs.
• Created several stage jobs for importing the source data into staging environment for further processing.
• Worked on creating user roles in Information Steward and assign this in connection to BO 4.1 & Data Services.
• Worked in HR, SCM, MM, and FI/CO for the master data cleaning in information steward & Data Services.
• Created HANA Views and HANA models in 1.0 SP8 for ECC Data & EDW.
• Created multiple attribute views, Analytical views and calculation views in HANA SP8 on top of ECC & EDW data sources for BOBJ reporting needs.
• USED HANA SLT replication for data loading from ECC to HANA and also used Data Services for EDW data loads in HANA.

Environment: SAP BOBI 4.1 SP2, 4.X, SAP BO Data Services, SAP IS, SBOP Explorer 4.0 SP02, Business Object XI 3.1 SP2, Data Federation 3.0 SP2 pack 1, CMS, Designer, IDT, Dashboard Design tool, LCM, BO Advanced Analytics 1.0, SAP Design Studio 1.1, 1.3, 1.5 & SAP Lumira, SAP HANA 1.x SP8, BEx Analyzer, SAP Netweaver 7.0, SAP BI 7.0, Desktop Intelligence, WebI Rich Client, Xcelsius 2008, SAP BI 7.0, MS Access, MS Excel, Oracle 10g.

Confidential - Houston, TX

Sr. SAP BOBI Developer/ Admin

Responsibilities:

• Downloaded and installed BOBI 4 SP 2 patch 7.
• Downloaded and installed BOBI 4 SP 2 Patch 7 Client tools.
• Installed BOBI Crystal, Business Explorer, Dashboard Designer SP2, Patch 7
• Installed Data Services SP1 Patch 4.
• Configured all the above applications each other.
• Configured SSO using LDAP and SAP
• Sync SSO and LDAP
• Data SSO using SAP.
• Installed and configured Data Services 4.0 with SAP and Oracle.
• Installed and configured Sharepoint Integration with SBOP BI.
• Created project plan for SAP BOBI 4.0 upgrade.
• Worked with SAP Basis team to get the full picture of current architecture and process.
• Installed SAP BOBI 4.0 SP2 patch 5 in Sandbox and DEV.
• Migrated 3.1 SP2 content into 4.1.
• Fixed most of the migration issues and identified remaining as Bugs after confirm with SAP.
• Installed and configured Sharepoint integration option for BI Launchpad
• Configured WebParts on Sharepoint deployment and documented.
• Installed Mobile platform for SAP BOBI 4.0
• Created POC universe for Data Federator using IDT.
• Created POC dashboard for Dashboard Designer.
• Configured BEX Web Application, SAP Authentication, Portal Integration, SNC Setup and LDAP Configuration.
• Migrated 3.1 Sp2 content into 4.0 using Upgrade management tool using BIAR to LIVE and LIVE to LIVE modes with Full and Incremental backups.
• Identified migration problems and sorted out by priority.
• Worked with BI team to identify what’ the bugs and features in 4.0 since it is not yet GA and there is no proper documentation from SAP.
• Documented all the process from planning to deliver the BOBI 4.0.
• Created MS Excel based security structure (Folder, groups, application, LOV, Connection, universe folder) security and synch them with LDAP users.
• Installed SAP Business Objects Business Intelligence 4.0 SP1 in Sandbox, Dev and QA environments.
• Integrated SAP BOBI with SAP BW with SNC SSO. Configured LDAP (Sun Directory) with SAP BOBI.
• Managed a team of three BO developers, one Crystal and two Xcelsius developers and also involved in the development phase of the project.
• Installed Data Services, Lifecycle manager, Metadata Manager separately and configured with existing BO deployment.
• Created multiple universes (OLAP & Rational) from BW Querries and DB2 ODS data sources.
• Created scorecards and dashboards from data services as well as Universe as a data source.
• Worked as a Data Analyst for CAMS databases, XP database and PM databases.
• Created and helped MV’s at database level to support requirements.
• Involved in full life cycle of Dashboard development (KPI’s discussion, design and implementation).
• Created POC Dashboards and presented client for more understanding and finalization of front end of the dashboard (like colors, fonts, functionality etc).
• Utilized all advanced concepts of Xcelsius including dynamic visibility, What if ratios, interactive charts with drill capabilities, hierarchies.
• Used more than 40 components in each Xcelsius dashboards.
• Corrected the existing seven universes and 20 WebI reports and improved performance a lot.
• Created prototypes of WebI reports and presented to the client.
• Created WebI reports top of SAP BW OLAP universes using WebI rich client and WebI.
• Mentored a group of Business Users on how to use WebI and do more Adhoc type of reports.
• Created Lifecycle Manger instructions/standard document to maintain smooth promotions across different environment.
• Created new webI reports by using 3.1 WebI SDK and universe SDK.
• Designed and developed ad-hoc reporting tool by using 3.1 Universe SDK in java environment.
• Used advanced options and including multiple tabs, charts, and drill down reports in WebI reports.
• Mentored non technical users in Ad hoc reporting and info view functionality
• Configured & Exported dashboards into SAP Netweaver portal.
• Created Dashboard Prototypes (using Xcelcius 2008) and given a demo to the client.
• Used Live office, QAAWS and Xcelcius together for the creation of some Xcelsius dashboards.
• Created four advanced dashboards with different functionalities and used lot of components.
• Mentored Business Users on how to use Xcelsius dashboards using their browser and created documentation on that.
• Used Data Federator 3.2 and created multiple projects and connections using SAP, SQL Server and some flat files.
• Involved in full life cycle of Data Federation project from planning to deployment.
• Scheduled Data Federator objects from one environment to other environment.
• Created Universes using SAP BW queries and Oracle EWD.
• Worked closely with SAP BW architect and developers for the cube design as well as queries developing.
• Created large universes, webI reports as well as Xcelcius dashboards.
• Created Financial, Supply chain and Operational databases using SAP BW Querries and SAP BPC data.
• Created Web I reports from different source systems including SAP BW and Oracle databases.
• Created and worked on WebI standard document procedure.
• Worked in Lifecycle manager and import wizard to move contents from one environment to other environment.
• Mentored users in WebI rich client and its functionalities.
• Integrated with JDE 8.12 for Business objects SSO authentication & authorization.
• Created JDE data sources for Universes & Report creation.

Environment: Business Object XI 3.1 SP2, CMS, Designer, Web Intelligence XI,Desktop Intelligence, Lifecycle Manager, WebI Rich Client, Xcelsius 2008, SAP Net weaver portal, SAP BW/BI 7.0, SAP Data Services, BO Advanced Analytics 1.0,JD Edwards 8.12, BEx Analyzer, SAP BPC, MS Access, MS Excel, Oracle 10g, Crystal Reports XI/2008, SQL, PL/SQL,, BO Auditor, Toad, Data stage, Windows XP Professional.