SUMMARY

• 11 years of total IT experience in the Analysis, Design, Development, Deployment and Project management of Business Intelligence applications with excellent skills in EDW industries which include Confidential, Confidential &E, Confidential, Confidential & Poor’s, Nomura America’s, General Electric and Nestle. Etc.
• 10 Years of experience in Enterprise Resource planning, product design and development and a total of 8 Full Life cycle implementation experience of a Decision support system.
• Expertise in 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)
• Hands-on experience on SQL scripting.
• Implementation expert in data provisioning from SAP and non-SAP source systems, flat files into SAP HANA and other databases using various ETL tools including SAP BODS and SAP HANA SLT, HANA SDA, HANA Studio.
• Excellent knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts. Knowledge on Data modeling using Dimensional Data modeling - Star Schema Modeling, Snowflake Modeling.
• Expert in using SAP BOBJ Desk Top Intelligence (DESKI), Web Intelligence Interactive Analysis(WEBI), BI Launch Pad, Import Wizard, Promotion Management, Designer (UDT & IDT), QaaWS, Publishing Wizard, Analysis for Office, BI Web Services, Business View Manager tools, SAP Lumira, Design Studio, Tableau and profound knowledge on Crystal Reports.
• Expertise in Basis activities include; Upgrade/ patch installations, server administration, troubleshooting, user creation, creating and assigning roles and HANA, BOBJ security.
• Hands on experience in tuning the performance of SQL queries and BO reports.
• Experience in coding using SQL, SQL*Plus, PL/SQL Procedures and Functions, Triggers.
• Expert in working with OLAP, OLTP & ODS systems with DBs like Oracle, SQL Server, DB2 and Teradata.
• Experienced in client facing, requirement gathering, analyzing, documenting and providing the solutions with POC.
• Assisted clients in business process improvement to maximize software functionality and demonstrated tool training & usage.
• Good Understanding of requirements management, change management, software development and testing phases process while designing project implementation plan.
• Experienced in Preparation of complex project plans, documenting several templates to track the status of the project and assisting in project progress meetings.
• Recognized for strong communication, negotiation and client relation management skills.

TECHNICAL SKILLS

BI: SAP HANA, Bank Analyzer, HANA Studio, BW on HANA, SAP BI 7.1/7.3, BW 3.x/7.x, SAP BIBO 4.2/4.1/4.0,XIR3/R2/6x/5x, BI Launch Pad, IDT, UDT, UMT, LCM, Promotion Management, Live Office, Crystal Reports 2008/XIR2/10, Xcelsius 4.1, Design Studio, BOBJ Explorer, SAP Lumira, SAP Mobile, BRIO Tool, MS Analysis for Office, Infomatica 8.5, DataStage 8.x, ERWIN 3.5,TOAD, SQL Developer, SQL, PL/SQL, Web servers & App. Servers (IIS, Apache, Tomcat)

Databases: ORACLE 7.1/8.0/8i/9i,10g/11i, SQL Server 2008/2005, DB2, Teradata v2r6

OS: Unix (HP), AIX, Win2k Servers, NT, Windows 95/98, XP, Vista, Windows 7

ERP Modules: SAP R/3 (4.7) FICO, SD, MM, PM, WM, PP, ECC 6.0

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

SAP Native HANA / BOBJ Reporting Lead Consultant

Responsibilities:

• Working as reporting lead, played a vital role in SAP BI/HANA/BO Global Implementation of a team of 10 members (offshore 6 and onshore 4).
• Involved through all phases of Requirements Gathering, Gap Analysis, Blue printing, Functional/Technical Specs, Development, Go-live, rollout and post implementation support of SAP BI in APO, COPA, FI, MM, SD Implemented according to SAP.
• Lead global cross-functional project teams, as big as 9 resources, of onshore and offshore model while interacting with client, corporate sponsors and business end-users to manage scope, schedule and cost of projects.
• Interacting with business heads and users to provide better solutions and explaining the capabilities of the BI and HANA.
• Worked on native SAP HANA application modelling and development using HANA studio; Data Modeler, Developer, HANA Administration Perspectives.
• Extensively worked on creating SAP HANA models for General Ledger, Account Payables, Account Receivables, Reconciliation, Payments/Credits departments.
• Interacted with Functional Analysts and Business Users in gathering reporting requirements and involved in functional spec discussions and project plan.
• Involved in planning, design, development, implementation and production deployment of reporting solutions using SAP BOBJ reporting tool for various business process like Confidential Risk, Credit, Legal, HR and Finance.
• Actively interacted with SAP security team in providing the security design requirements for various projects and in resolving the user access issues; involved in testing the security design in development and test environments and actively worked with SAP support team in resolving the security related issues in BOBJ environments.
• Actively involved with Basis tem in upgrading the BOBJ environments to BI 4.1 SP6 and BI 4.2 SP1, SP2 and SP3 environments and post upgrade validations.
• Extensively worked on Web Intelligence reports suite in Business Objects, creating universes and reports on top of HANA Calculation views, Oracle DB, Excel Sheets as source, Web Services, QUAWS, BW Infocubes and BEx queries as source.
• Worked extensively on the BI tools, Business Objects, Crystal Reports, Lumira, Design Studio, Power BI, Micro strategy, Advanced Analysis for Office (AAO), Bex Query/ Analyzer and HANA reporting.
• Worked as an onsite AMS reporting lead for BOBJ reporting and coordinated with Offshore BOBJ BI teams.
• Involved in PFIT reporting/security requirements discussions and provided best practices for BOBJ content migration to target environments and coordinated with PFIT team in migrating BOBJ content to Test environment.

Environment: Native SAP HANA, SAP HANA Studio, SAP Bank Analyzer, HANA SQL, SAP BI 7.3, BW 3.x/7.x, SAP BOBJ 4.1 SP5/SP6, BI 4.2 SP1, BOBJ Explorer 4.1 SP5, Dashboards Design Studio, Oracle 11, SQL Server 2008, SQL Developer, SAP Lumira, MS AAO.

Confidential, San Ramon, CA

SAP BOBJ Developer / Solution Architect

Responsibilities:

• Interacted with the Business End-Users, Analysts and SMEs of Gas Distribution/Transmission departments of PGE to identify business requirements, document specifications and actively involved in implementing AGILE methodology.
• Involved in the project scope & charter and Project Planning of the Leak Survey Mobility & Leak Management projects in Confidential &E Gas Distribution/Transmission departments and provided estimates of the deliverables.
• Involved in feasibility and analysis phase of Leak Survey, Mobility Analysis, Advanced Leak Detection techniques and documented business requirements, technical specifications for developing reporting solutions.
• Involved in Data reconciliation among SAP, BW & BOBJ systems. Validated the BW & BOBJ reports and underlying data among the three environments; enhanced the existing reports and provided bug fixes to the existing issues.
• Involved in creating & updating the Unx based Universes on top of Infocubes and OLAP based universes on top of BEx queries and used Web Intelligence & Crystal Reports to create reporting solutions.
• Developed Business Objects Web Intelligence reports to cater Ad-hoc reporting needs and used Business Objects functionalities like Queries, Drill Down, Cross Tab, Master Detail and Formulae.
• Automated numerous user specific excel reports/dashboards using Webi & Crystal reports for better performance and provided scheduling facilities.
• Hands-on development assisting users in creating and modifying Tableau worksheets, data visualizations, story boards and dashboards.
• Developed dashboards using live connections and BIWS for operations analysis using Xcelsius 2008.
• Prepared POCs on the Work Management data for Gas Distribution & Transmissions to report on the Gas Leaks, Repairs and Rechecks using Design Studio.
• Coordination and work along with the SAP & BW teams to ensure the timely execution of data loads and delta loads to the reporting tables as well as testing the quality of data and providing inputs to the Business.
• Involved in the Sprint planning, creation of Epics, Backlogs, Stories, Road Blocks and Risks in Agile methodology and provided weekly status on reporting deliverables and upcoming task details to management.

Environment: SAP BIBO 4.1SP3/SP5, Crystal Reports, SAP BW 7.1, ECC 6.0, Xcelsius 2008, Dashboards Design Studio, Tableau 9.0, Data Stage 8.1, SQL, PL/SQL, Oracle 10g, Windows Server 2003.

Confidential, Santa Clara, CA

SAP BOBJ Lead Developer / Tableau Consultant

Responsibilities:

• Interacted with Functional Analysts and Business Users in gathering project requirements and involved in BRD discussions and Project Plan.
• Involved in planning, design, development, implementation and production deployment of three major projects with SSG, Varian and PDC.
• Extensively worked in implementing reporting solutions for FI-GL, FI-AP/AR, SD, MM, CRM, Warehouse Management modules and SSG, AGS, EES and Display Business Segments.
• Worked on data validation of Info cubes, DSO’s, Info objects and Multi Providers.
• Designed BEx Queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics, Exceptions and Conditions.
• Worked with Basis team on setting up the BOBJ environment for versions 4.1 SP2, SP3 & SP5, Explorer 4.1 SP3, SP5 versions, MS Analysis for office version 1.4 SP4, 1.4 SP6, Xcelsius 4.1 and Design Studio 4.1 versions.
• Configured and validated the Test & Quality environments for post upgrade to BOBJ 4.1 SP3 & SP5 versions.
• Created OLAP universes on top of BEx queries and used Web Intelligence to create reporting solutions.
• Created Unx based universes on Relational databases, Infocubes and Multi Providers and Infoobjects.
• Created Webi reports on top of BEx queries using BICS connectivity.
• Created BOBJ HANA reports on the Unx universes created on top of the HANA views.
• Extensively worked on the HANA views and data modeling using HANA Studio on SAP MM & PM modules.
• Strong knowledge of HANA replication methods, provisioning data, Monitoring and Troubleshooting data loads in HANA environment.
• Worked on creating Attribute Views, Analytic Views & Calculation Views and created Analytical Privileges and procedures for modeling.
• Proposed BI solution for the PGE’s gas leak system detection department and involved in BO Sizing and implementation.
• Involved in the BO CMS/ SIA setup and multi node SIA, Clustered and load balancing environment.
• Translated business requirements and high-level designs into a suitable technical design using HANA.
• Created complex Webi Reports and Charts with Drilldown functionality, Hyperlinking, Open Doc functionality, scope of analysis, Hierarchy, Block hiding based on the prompts selections and merged dimensions using the advanced functions/features available in the Webi front end.
• Worked on complex dashboards using Xcelsius dashboard designer and created POCs on the SAP SD & MM modules using Dashboards Design Studio.
• Worked with BASIS, SAP support team to resolve the technical issues, version issues and tool issues.
• Used Promotion management tool to track and promote the BOBJ content to multiple environments.
• Prepared technical specification documents and project documentation.
• Worked with Onsite-Offshore team setup environment.

Environment: SAP HANA V1.0, HANA Studio, Developer/ Data Modeler, HANA SQL, SAP BI 7.1/7.3, SAP BOBJ 4.0/4.1 SP2/SP3/SP5, ECC 6.0, BOBJ Explorer 4.1 SP3/SP5, Dashboards Design Studio, HPQC, Oracle 10g, DB2, MS SQL Server 2008.

Confidential, New York

Sr. BOBJ Developer / Administrator

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• Expertise in Resolving the Daily issues in the Daily Production Environment.
• Involved in full life cycle of SAP Business Objects 4.0.
• Involved in the upgrade of BO from XI3.1 to 4.0 and responsible for applying service packs and fix pack to BO installation.
• Setup alternate development and testing environments for BOBJ Upgrade testing from 4.1 Sp5 to Sp6 & 4.2 Sp1; involved in creation of SIA, CMS back up and Webi Application processing servers.
• Actively worked with BASIS team and SAP support team in resolving the migration issues, Promotion management issues in BOBJ, Security issues and other project related issues.
• Apart from promoting Info Objects, used Life Cycle Manager to Create, Copy, Edit and scheduled a job.
• Maintained & managed different versions of the same document using Life Cycle Manager.
• Created repository and security domain with user groups and security implementation.
• Extensively worked with security issues and user maintenance in SAP BOBJ 4.0.
• Evaluated the possible use of aggregate tables and worked with DBA to create the aggregate tables.
• Involved in the Single Sign-On (SSO) application team for the Operations Updates project and used the BO SDK to accomplish this task.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implement Folder and object level restrictions.
• Extensively worked on HANA Design Studio - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions and Analytical Privileges.
• Created HANA POC reports in Web Intelligence on the Unx based universes which were created on top of the HANA views.
• Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.

Environment: SAP Business Objects XI 3.1/4.0, Life Cycle Manager, Promotion Management, Crystal Reports, Web Intelligence, IDT, UDT, UMT, Oracle 9i/10g, Windows Server2003.

Confidential, New York

Sr. BOBJ & Crystal Reports Consultant / Lead

Responsibilities:

• Analyzed users need, design and develop various decision support reports and applications for optimum performance
• Involved in the upgrade of Crystal Reports Enterprise to Business Objects Enterprise XI3.
• Migrated folders, sub-folders and objects using the import wizard from Crystal Reports 10 to Business objects XI3
• Setup users and groups in CMC and created user profiles
• Modify reports from Business Objects XIr2 to Business Objects XI3
• Installed fix packs and service packs on DEV, QA and PROD crystal servers
• Created ODBC configurations on DEV and PROD Business Objects servers
• Troubleshoot both crystal reports and BOE server issues
• Migrated Financial Reports to work for Global Financial Consolidation
• Globalization of Accounting Analytical reports across Nomura Worldwide
• ERP( 8.8 to 9.1) migration remediation of Business Objects Universes and web intelligence reports

Environment: Business Objects Enterprise XI3.1, Web Intelligence XI3.1, BO Dashboard Manager, Crystal Reports 2008, Xcelsius, Peoplesoft 9.1, Oracle 10G, Informatica 8.5, VB6.0, EBI Version Manager, IBM Clear Quest, Windows NT, MS Office 2007, SQL, PL SQL, Toad 8.6.1, SQL Developer, Citrix Platform.

Confidential, Charlottesville, VA

Sr. BOBJ Developer / Admin

Responsibilities:

• Involved in security design for the BO Enterprise by creating folders, users and user groups as per the specifications according to the different Departments.
• Production Support the users with their reports and be responsible for solving admin issues with the Database connectivity, response time and security of users.
• Involve in Unit testing, system integration testing and user accepting testing for data validation for Inventory.
• Understood business requirements, designed the solution document, tested, and managed offshore team from client site
• Design and build Universes as per the business processes of different Departments.
• Create complex Linked Universes to reduce development and maintenance time.
• Define security filters to implement Row level and Column level security
• Handle Embedded Functions like @Prompt, @Select, and @Where, @Aggregate awareness in the designer to handle User requests for report generators
• Move content from dev-test-prod enivironments using import wizard and biar files.
• Create Dashboards in Xcelsius with features such as drill down charts, Interactive Calendar components, alert methods

Environment: Business Objects Enterprise XI3.1, Oracle 9i, Data Integrator 11.5, Windows 2000, MS Office 2003, SQL, PL SQL, UNIX, SQL Developer, Citrix Platform.

Confidential, New York, NY

Sr. BOBJ Consultant

Responsibilities:

• Involved in requirement gathering and data analysis for reporting from business users.
• Created High-level and Detail-level documentation of the project.
• Involved in the upgrade of Crystal Reports Enterprise to Business Objects Enterprise XI3.
• Migrated folders, sub-folders and objects using the import wizard from Crystal Reports 10 to Business objects XI3
• Setup users and groups in CMC and created user profiles
• Modify reports from Crystal Reports 10 to Business Objects XI3
• Used PVCS version control manager to store different versions of Business Objects Reports as well as stored procedures, packages and XML files
• Maintained and managed all the maintenance of the DEV, QA and PROD BOE servers
• Managed an offshore Kanbay team of 8 developers & testers to work on the development & testing of over 50 reports and six universes.

Environment: Crystal Enterprise 10, Business Objects Enterprise XI3.1, SQL Server 2000/2005, DB2, DataStage 7.5, Windows 2000, MS Office 2003, SQL, PL SQL, UNIX, Toad 8.6x, PVCS Version Control Manager and Lotus Notes.

Confidential, Greenwich, CT

BOBJ/ Crystal Reports Consultant

Responsibilities:

• Working in the Home and Office Delivery Division as Business Objects Enterprise Administrator and Reports Specialist.
• Meet with Business users to understand and analyze business requirements.
• Installation & Configuration of Business Objects XIR2 Enterprise Suite of Products for Production Environment.
• Responsible for Business Objects Servers maintenance using CMC, CMS.
• Defined Complex Security set up for end users, groups using CMC and configured rights.
• Designed universes and Sales Marketing reports, Confidential and adhoc reports, and organizational charts on top of those universes.
• Involved in complete software development life cycle from Requirement analysis to UAT and Maintenance.
• Created formulas using Crystal syntax and basic syntax.
• Worked with the ETL team in solving issues using SQL Server Integration Services (SSIS).
• Used APOS - Info Scheduler and Instance Manager to Schedule, Refresh and Distribute Reports & maintaining Instances of financial reports for at least 90 days.

Environment: Business Objects XIr2, Crystal Enterprise 10/XIr2/2008, Crystal Analysis Services 10, Business Objects XIr2, SQL Server 2000/2005, SSIS, SSRS, OLAP Cubes, Windows 2000, MS Office 2003, APOS - Info Scheduler, APOS-Instance Manager, SQL, PL SQL, UNIX.