SUMMARY:

• Over 17 years of IT experience encompassing a wide range of skill set and roles across various industry verticals. me have got around 11 years of experiences specific to Administration and Architecture. As a lead have been handling various teams with a maximum size of 15. As HANA/BOBI Admin having experience in HANA 1.0.*, SBO 4.2/4.1/4.0, Business Object XI 3.1, R2, 6.5, BODS, Oracle11g/10g/9i with Unix/Linux/Solaris platform.
• SAP Certified Technology Associate System Administration for HANA
• SAP Certified Application Associate - SAP Business Object
• Received Service Recognition Reward for 10 years Completion at IBM. Provided Solutioning for various Fortune 500 clients of IBM during dis tenure.
• An Admin providing Basis architecture solution in area of BOBJ/BODS/Information Stewards and HANA. Have got 11 year experience in BOBI/BODS and 6 years in HANA.
• Developed many comprehensive methodologies using SAP BO, SAP HANA, BW, Data Services and SAP BO applications
• Responsible for BO install, upgrade patching. Has performed BO upgrade from 4.0 to 4.1
• Worked on LCM, Promotion Manager, Upgrade Management Tool.
• Responsible for HANA installation, upgrades and patching
• Configurations for SAP ECC Accelerations using SAP HANA
• Worked on HANA Live Solutions. HANA operations and backup and recovery
• Around 14 years of experience in Oracle Database 11g, 10g,9i, 8.x,7.x, 6.x along with DB2 in both transactional and ware house systems.
• Exposure to Business Objects XI Enterprise suite using Desktop Intelligence, CMC, Designer, Web Intelligence reporting, Lumira.
• Created reports using Infoview with Graphical,bar pie charts, Cross Tabs, sections, breaks and publish reports also etc.
• Experience in Developing Crystal Reports, Crystal Xcelsius Reports (Query as Web Connect).
• Involved in all teh stages of Software Development Life Cycle.
• Extensively participated in all teh phases of application development, namely: system analysis, design methods, development, testing implementation and maintenance.
• Extensive knowledge in Pipeline/Partition concepts and techniques - Round Robin, Entire, Hash by Field, Modulus and Range.
• Used job Sequencer to specify teh network/sequence of jobs to run.
• Database development includes designing Data Model, implementing Oracle PL/SQL in stored procedures, functions, and triggers, writing java stored procedures.
• Worked both in Data warehouse and transactional Database and environment of Oracle 8i/9i/10g databases on sun Solaris, Linux, AIX, HP-UX and Windows NT/2000.
• Around 3+ years of experience in ETL mechanisms using IBM DataStage 6.x/7.x/PX/EE amd IBM InfoSphere DataStage V8.1/8.5(Parallel Engine)
• Having ETL/Datastage tool experience using IBM Websphere/Ascential DataStage (Ver8x)and developing jobs using stages like Transformer, Sequential file, Hashed file, Join, Lookup, Lookup file set, Sort, Aggregator, Copy, Dataset, Merge, ODBC, Oracle, Remove duplicates and DB2 stages, DataStage Manager, DataStage Director and DataStage Administrator, DataStage Parallel Extender, Websphere MQ series plug-in stage, SAP StageR3 and Sap Business Objects reporting.
• Also having an additional skill in J2EE technology like EJB, Servlets, JSP, Struts, JDBC, LDAP and XML.
• 11 years of experience in Business Objects using different tool like IDT, UDT, Designer, Web Intelligence, Desktop Intelligence, Rich client, supervisor 6.5/XIR2/XIR3, Info view, Crystal Reports.
• Used teh SAP BO 4.1/4.0 business Intelligence capability on top of HANA and created complex analytical reports in Explorer, IAD, Xcelsius. Also created teh semantic layer using IDT, UDT.

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Lead SAP Admin with Oracle DBA

Responsibilities:

• Currently working as Lead SAP Admin and responsible for End to End BO/HANA Solution. Responsible for Sizing, Installation, Upgrade, day to day Administration of BO/HANA/Oracle DBSetup Monitoring Alerts
• User Security, and Encryption for current Project. Implemented Backup script for HANA Periodic Backup solutions. Implanted HANA/Oracle DB Cloning Solution for doing system copy between environments.
• Setup Hana Audit and have done Windows AD integration. Responsible for setting up HA System Replication between Data centers.
• Worked on Monitoring memory Leak issues, performance issues related to RAM and CPU on day to day basis. Work with SAP for teh Bug and Issues related to HANA. DR configuration and support.BO Migration and upgrades

Lead SAP Admin with Oracle DBA

Confidential, Raritan, New Jersey

Responsibilities:

• Lead Admin responsible for teh end to end solution using BOBI/BODS along with HANA. Managed team of 5 members for dis Back to Basis team. Deployment of BI, Data Services & Information Steward landscapes in clustered and distributed landscapes.
• Responsible for Sizing BI 4.1, Data Services 4.1 & Information Steward 4.1 applications. Installation for new landscape using BI 4.1, Data Services 4.1 & Information Steward 4.1.
• Installing Information Platform services and integrating it with Data Services & Information Steward applications. Migrating large Business Objects deployment from XI 3.1 to BI 4.1.
• Upgrade Management tool for incremental and complete upgrades. Database experience using Oracle, SQL Server for hosting CMS, Audit & Reporting database. Configure BI & EIM repositories on
• SAP HANA. Configure DS Local, Central and profiler repositories on SQL Server database.DS Repository and Server Manager tools. Deploy BO Web applications on third party web application servers

Confidential

Lead SAP Admin with Oracle DBA.

Responsibilities:

• Lead Admin/Architect responsible for teh end to end solution using HANA AND BOBI/BODS. Worked on HANA data acquisition layer, transformation, reporting via logical views and eventually using BO tools. Managed team of 10-15 members and mentored various people at IBM SAP practice in teh field of SAP BI. Developed many real time use cases to using latest HANA and BOBI/BODS products. Worked on integration of SAP HANA and Data Services 4.0/4.1 with other non-SAP products
• Installation and configuration of Data Services 4.0/4.1 and Information Steward 4.1 Used teh SAP BO 4.1/4.0 business Intelligence capability on top of HANA and created complex analytical reports in Explorer, Design Studio, Xcelsius. Also created teh semantic layer using IDT, UDT. Responsible for BO install, upgrade patching. Has performed BO upgrade from 4.0 to 4.1 and 3.1 to 4.0. Worked on LCM, Promotion Manager, Upgrade Management Tool. Responsible for HANA installation, upgrades and patching Configurations for SAP ECC Accelerations using SAP HANA. Worked on HANA Live Solutions. HANA operations and backup and recovery. me have been part of many paper publications at SAP Sapphire and Teched. Worked on HANA Live implementation at LSS and for multiple
• Planned and implanted for solutions like ECC/CRM/BW on HANA, Lumira, Predictive Analytics, HTML, XSJS, PAL and R libraries, Mobi and Explorer. Worked on various SAP HANA/BO RDS Solutions.
• Deployeed SAP HANA onto various hardware vendor platforms including VMware environments. Part of SAP BW 7.3 on HANA implementation work for various clients.

Confidential

SAP Admin

Responsibilities:

• As an Admin/Architect responsible for end to end design flow and integrate teh SAP - EDW system. Worked with teh Business analysts and Subject Matter Experts to thoroughly understand teh different business processes and data at various sources.
• Documented ETL high level design and detail level design documents for various SAP interfaces like Sales Order memo, Invoices, Customer Detail, and Exchange Rate. Involved in designing and developing teh Universe and updating teh existing Universes
• Developing canned/adhoc reports, scheduling teh processes and administering teh BOBI activities using Business Objects XI4.0/XIR3. Responsible for BO administration/security activates related to teh project.
• Worked for HANA install and upgrade/patch. Also worked on EDW modeling using Calc view/Analytical views.

Confidential, Moline, US

BO Admin

Responsibilities:

• Played a role of On-site Project lead and worked as a bridge between client and offshore team.Played a role of Technical Consultant in providing Technical solution in enhancement projects and support work.Played a role of Manager for managing multiple projects based on client's need. Working with different department to gather requirement related to new or enhancement projects.Responsible for managing teh XI R2 to XI 3.1 migration. Managing Security and administration for all teh departments. Responsible for Interacting with SAP for product related issues on regular basis.
• Worked closely with offshore team for project related issues in Universe and Reports design and development. Developed ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document. Also responsible for modification of DataStage ETL jobs in case of issues found by user. Responsible for BOBI/BODS install, upgrade patching, backup, restore, auditing.

Confidential

BO and Oracle Admin

Responsibilities:

• Involved in migration of LIDO application from Italy. Responsible for understanding of data warehousing concepts and dimensional modeling and helping teh team in smooth transitions for teh project from client place. Worked on transitions of Business Objects from client to offshore. Worked with existing reports on Web Intelligence and
• Desktop Intelligence and involved in creation many reports. Worked in migrating jobs PL/SQL. Supported CMC for supervising, security domain which includes creating users, groups, providing access at various level
• As a FP specialist responsible for counting ‘function point’ for teh whole application. Designing teh Target Schema definition and ETL using Data stage. Mapping data items from source systems to teh target system. Used teh Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.

Confidential

BO and Oracle Admin.

Responsibilities:

• Designed and developed teh ETL jobs using Parallel Extender which distributed teh incoming data concurrently across all teh processors, to achieve teh best performance. Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, Sort, Surrogate key Generator, Change Data Capture, Modify, Row Generator and Aggregator. Worked on migrating Business Objects (Universe, Reports, BCA) from ver. 6x to ver. XI R3. Business Object Universe
• Business Objects Reports and Business Objects repository extensively used, and new universe were designed and developed to support teh user requirements. Trouble shooting and tuning of teh existing reports (Web Intelligence and Desktop Intelligence). Worked extensively on CMC for supervising or security accesses. Created complex views to overcome loops and contexts in Universes. Also developed and tuned complex SQL, PL/SQL code to enable user queries to teh database for data access, using triggers and stored procedures.
• As a Team lead for JAM application handling a team size of 16 people. As a FP lead achieving teh productivity target for teh own team and other team at SDM level. Responsible for Estimation of teh various projects, with a minimum variance. Working as Quality SPOC and responsible for implementing CMM processes for teh entire cluster owned by Senior Delivery manager. Involved in teh Peer review, SCM process implementation and audits.

Confidential

BO and Oracle Admin.

Responsibilities:

• Helped in migration of JAM application from US and build teh India team. Involved in complete Project Planning and Control and establish teh quality process. Worked as a System Engineer in modeling business processes and driving business requirements
• Systems Design and implementation from teh business model. As telecom domain expert understanding and documenting teh service flows and transfer teh knowledge to teh off shore team

Confidential

BO and Oracle Admin/Architect

Responsibilities:

• Involved in initial set up of Data warehouse. Developed physical and logical Modeling. Involved in teh full life cycle of teh Business Objects 6.x Tool. Installed Business Objects and created teh repositories. Installed Web Intelligence and Broadcast Agent server( BCA). Designed and developed universes using Designer. Implemented Complex security setup in Supervisor. Designed and developed various aggregation procedures in PL/SQL to load data from FACT to various DMART tables to reduce storing space and optimizing teh report performance.
• Was dealing with complex PL/SQL programming constructs, including nested arrays, user-defined types and utility packages. Involved in SQL query optimizing using various query hints by analyzing teh CBO, overhead, bind variable, explain plan and deciding teh parallel loads. Export and Import of data from DB2 to Oracle system. Designed and developed many Unix shell script jobs to run teh IBM DataStage ETL, AGG and reports. Designing teh Target Schema definition and ETL using Data stage. Mapping data items from source systems to teh target system.
• Used teh Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse. Also as a Migration Lead responsible for successful migration of these applications to India. Involved in forming teh team size of 15 at India.s: Received many appreciation mails for teh dedication and innovative solution provided during teh project migration.

Confidential

Software Developer

Responsibilities:

• Involved in teh requirement phase which was including teh domain knowledge acquisition of finance and insurance domain. As a J2EE developer was part of design and development of teh corporate application and also in teh Branch Application involved in design and coding of teh following functionalities: Container Context, Database Connection Pooling, Data Model Maintenance, Uploads/Downloads Buffer, Audit Log, Configurable Menus and User/Groups, Printing API Implemented teh major business logics by writing packages, stored procedures, functions.
• Receive teh CSV files from teh external system and upload it through SQL*Loader

Confidential

Software Developer

Responsibilities:

• Involved in complete life cycle of teh project. In teh requirement phase not only gathered complete requirement but also suggested few new modules which helped them in complete paperless business solutions.
• Responsible for requirement analysis, design, development and customer acceptance for teh various modules like Bar-coded Attendance System, Library Management System, Worklog System, and Computers Maintenance System.
• Notice Generation Module, Student Information Management System, Mess Management System, Academic Fees Module. Involved in complete integration testing as well as in teh system testing of all teh modules.