SUMMARY:

• Having 15 years of IT experience including 12+ years’ experience in SAP, including SAP HANA, SAP BW on HANA, SAP BW. Experience with analysis, design, development, and implementation of integration and BW solutions. Hands on full life cycle end - to-end Implementation, Data Migration, Support and Maintenance projects
• Experience in back-end and front-end Techno-functional, Experience in BW architect as well as SAP BI (Business Intelligence)/BW (Business Information Warehouse)/ABAP. Implemented SAP BI/BW through 2 full lifecycles in multi-industry global deployments of SAP BW version 3.x & BI 7.x and 7.50 SP07 on HANA . SAP BI 7.x and HANA (Version 7.0, 7.4 with HANA) Includes Upgrade experience, BW to BI transformation Management and leading the team.
• Strong backend Data modeling and Architect experience, BW with HANA mixed modelling experience with BW 7.4 powered with HANA database.
• Experience in developing data models in Eclipse HANA 1.0 SP2 with BW/4HANA add-on.
• Working Knowledge of SAP FICO configuration that includes FI-General Ledger, FI-Accounts Payable and Receivable, Grant, HCM, Asset and Funds management
• Hands-on expertise in all stages of SAP BI/BW rollouts i.e. Data Extraction, Staging and Storage, Transformation and Presentation.
• 10 year Experienced in data modeling for functional areas from SAP ECC, FI, SD, HCM, GRANTS(GM), FMBCS(FM), ASSETS, CRM 4.0, SRM 7.02, IP, flat files using different extraction structures.
• Leverage my knowledge of SAP BW to develop reporting solutions that address user requirements using Query Designer, Report Designer and BEx Analyzer, Report development in WAD and Dashboard.
• Experience in creating BW on HANA Info providers like Advanced DSO, Composite providers and Open ODS.
• Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing. Experienced creating report from HANA STUDIO for other BI tools also loading data from tables in HANA Database to HANA studio data marts
• Hands-on on Lumira, PowerBI, Micro Strategy and Tableau BI tool for creating reports sap BW
• Extensive experience in gathering system requirements, defining business processes, identifying risks and Impact analysis .Good understanding of Project Management and System Development Life Cycle.

EXPERTISE SUMMARY:

Domains: AR, AP, GL, SD, GM, HCM, SRM 7.02, FM

Data Warehouse: SAP BI, SAP BI, SAP HANA, SAP BW on HANA, Eclipse HANA 1.0 SP2 with BW/4HANA add on .

Implementations: 2 Full Cycle Implementations (BW) plus 6+ Clients

Industry expertise: Higher Education, Public Sector, Manufacturing, Pharmaceutical, Chemicals and Gases, Apparel and Footwear, Consumer Products

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Lead SAP BI (BW/BI) Developer

Environment: SAP BW 7.1/ 7.3/ 7.4/7.50 SP13 on HANA with BW/4HANA add on SPS05 and SAP HANA SPS03, SAP ECC 6.0, SRM 7.02, BEx Analyzer, Eclipse, Query Designer, and Web Application Designer.

Responsibilities:

• Responsible for upgrading BW 7.50 SP13 on HANA with BW/4HANA add on
• Designing, configuring, implementing & supporting complex SAP’s BW solutions, front-end to back-end; designing, implementing & supporting complex extraction, transformation and loading of SAP BW Data. Designing and developing reports using BW.
• Migrated object into Bw on Hana and created new object in Bw on Hana with BW/4HANA add on using Eclipse to prepare for BW/4HANA implementation
• Created ADSO, Composite providers and created mixed BW Hana Architecture.
• Created HANA view to access 3rd Party tools such as Power BI
• Created SQL script to replace abap code in end routine.
• Extended the Business Content Data sources using Enhancements and populated the appended fields using User Exits. Created custom Info Source/Data Source, ODS, and Info Cubes for Data extraction, transformation and loading from SAP R/3 system to SAP BW
• The BI Technical Lead will proactively identify where existing systems can be enhanced and the data reporting environment improved
• Responsible for creating Employee Self-Service Model for HR business group where they can extract all HR related university data in one model
• Customization of SRM, HCM, FI-GL, FI-AR, FI-AR, Grants, FM(Funds management) and AA (Asset Accounting as well as all related Master data extractor to satisfies business needs and report requirements needs.
• Created around 100 + standards or customized reports in FI, HCM, SRM, Grants and Funds management area and responsible for monitoring query and load Performance
• Created HCM dashboard using WEB Application designer for end users
• Created Process Chains for Master data Loads and Transaction data loads and supporting BU BW daily and monthly jobs
• Ensured that all end users and stakeholders reviewed the prototype solutions and provided feedback and these changes were incorporated into the final design.

Confidential, Milford, MA

Sr. SAP BI (BW/BI) Developer

Environment: Net weaver 2004s, SAP R/3 6.0, SAP BW/BI 7.10, CRM 4.0/ 7.0, Query Designer BEx Analyzer/Browser, SAP Business Objects (SAP BO) XI 3.1,, Xcelsius® 2008, ABAP/4, Workbench, SD, FI, CRM, Oracle, Windows 2000/NT. Information Broadcasting., BPC 7.10

Responsibilities:

• Involved in design, development and supporting SAP BI in the areas of SD, FI and CRM.
• Extensively worked on Front-end (Bex Query Designer,) and Back - end.
• Responsible for extracting CRM, SD data into BW. Enhanced Activity, opportunity Data source, related master data source.
• Expertise in delta management between CRM and BW. Expertise in understanding and trouble shooting of related issues in CRM and subsequent data flow to BW.
• Expertise in debugging extractor issues. Expertise in analyzing and fixing the data quality issues between CRM and BW.
• As part of the development, developed several data targets such as DSO Objects (ODS) and Cubes and Multi Cube.
• Converted excel based dash Board into Xcelsius 2008. Created BW Queries from all CRM areas which used to create in Xcelsius 2008 dash Board
• Provided Production support and daily monitoring jobs in a production Environment

Confidential, NV

SAP BI/BW Consultant

Environment: Net weaver 2004s, SAP R/3 4.6C,6.0, SAP BW/BI 7.0 /3.5, BEx Analyzer/Browser, ABAP/4, Workbench, SD, FI/CO, Oracle, Windows 2000/NT. Informatica 7.1

Responsibilities:

• Involved in complete life cycle implementation of BW 3.5, which includes Data-modeling, data extraction, generic extraction, data loading, scheduling, monitoring and Report Designer.
• Responsible for extracting FIGL, FIAR, FIAP, HR, SD data into BW.
• Responsible for creating logical systems for R/3 client and BW client, installing business content objects to load R/3 data. Setting up BW Authorizations and Security in BW Systems
• Worked extensively in Enterprise Reporting, Query and Analysis BEx Design Tools, BEx Reporting Tools and Information Broadcasting.
• Expertise in configuring and creation of BW components Info Cubes, Multi-Cubes, Info Sets, Info Sources, Info Objects, ODS objects (Data store objects), Update rules and Transfer rules.

Confidential, Boston, MA

SAP BI (BW/BI) Architect Consultant

Environment: Net weaver 2004s, SAP R/3 6.0, SAP BW/BI 7.0, SAP Business Objects(SAP BO) XI r2, SAP WebI, BEx Analyzer/Browser, WAD and Report .

Responsibilities:

• Responsible for development and configuration of BW, BEx reporting utilities and ETL of production delta updates to ODS, Info Cubes and hierarchy structures.
• Expertise in creating Reports using query Designer, BEx Analyzer, BEx Reporting Tools, WAD (Web Application Design), Dashboard, Broad casting and Report Designer.
• Experience in extracting SD, Vistex-IP into BW.Proficient in extracting data from LO-Cockpit, SD and Flat Files.
• Configured and Customized delta built up for the Data Sources, LO-Cockpit Configuration and Customization. Customized Business Content and configured Generic Extractors.
• Expertise in Configuring and creation of BW components Info Cubes, Multi-Cubes, Info Sets, Info Sources, Info Objects, ODS objects (Data store objects), Update rules and Transfer rules.
• Analyzed OLAP performance using BW statistics. Improving query and load performance using Aggregates, Partitions, Indices and Data Compression.
• Provided Production support and daily monitoring jobs in a production Environment
• Expertise in configuring and creation of BW components Info Cubes, Multi-Cubes, Info Sets, Info Sources, Info Objects, ODS objects (Data store objects), Update rules and Transfer rules.

Confidential, Marlborough, MA

SR. Principal Software Engineer

Environment: Oracle 9i, Windows NT, 2K COBOL II, JCL, CICS, DB2, UNIX, PL/SQL, MERCATOR 6.7 (Data stage TX), INFORMATICA 7, Mainframe

Responsibilities:

• Actively participate in full lifecycle client implementation using mainframe and client server technology. Created TSD and testing documents for technical design.
• Development of mapping structures for ETL (extract, transform, and load) processes using Informatica Power Center.
• Lead a team to convert extraction program into ETL Informatica Tool. Involved in design, development and implementations of various clients
• Lead role in development and implementation of full cycle DB Client routine project for Critical business solution, which includes developing IOM online, batch Modules Using CICS, COBOL, DB2, JCL.

Confidential, MA

Sr. Software Engineer/Developer

Environment: COBOL II, JCL, CICS, DB2, UNIX, PL/SQL, Mainframe

Responsibilities:

• Actively participate in full lifecycle client implementation using mainframe and client server technology. Created TSD and testing documents for technical design.
• Lead role in development and implementation of full cycle DB Client routine project for Critical business solution, which includes developing IOM online, batch Modules Using CICS, COBOL, DB2, JCL.