SUMMARY:

• SAP Business Warehouse Consultant with 16+ years of IT experience, which includes 14 years in SAP BW, ABAP, BW/4HANA, Datastage and Teradata and 2+ years as programmer analyst.
• Thorough design and development experience of end - to-end Data-Warehouse solutions including Data sources, Infosource, ADSO/DSO/Infocubes, CompositeProviders/Multi-providers
• Thorough Front-end experience in designing queries, web templates and Lumira/BO dash boards
• Developed Reports in BW QUERY/ BEX / BO technologies
• Extensive experience in BW with CRM, SD, HR, CCA, MM, FICO, COPA and EM extractors
• Extensive experience in Analysis process designer tool
• Good leading experience of BW projects from start to finish
• Expertise in HANA 1.x/2.x / Business Objects 4.x
• BW Consultant at Confidential for Canada post Group of Companies for 14 years
• Worked for Accenture USA, upgrading SAP BW at DuPont
• Experience in working at fortune 500 companies in U.S like Cigna
• Experience in ABAP
• Experience in upgrading BW 7.0 to 7.5 and BW 7.5 to BW/4 HANA working along with Basis team

TECHNICAL SKILLS

Technical Skills: SAP BW 3.x, 7.x, BW/4 HANA, ERP 6.0 4.6C, 4.0B, 3.x, SAP CRM 7.x, 4.xS/4 HANA, Teradata, IBM Datastage, Development in Agile methodologies

Languages: ABAP, C, C++, Java, Java Script, PL/SQL, SQL 7.0, COBOL, Visual Basic.netHTML, XML, Python

Platforms and O.S: Windows 2007, Windows 10, Solaris 10, OS/390, Linux

Databases: HANA, Oracle, DB2, MS Access, SQL Server 2000, TERA DATA

Others: BW QUERY, SAP ANALYTICS, LUMIRA, BEX, BOBJ 3.x, 4.x, WEBI, Crystal reportsIntegrated Planning tool, Visual Composer, Explorer, MS Office tools, JIRAConfluence

PROFESSIONAL EXPERIENCE:

Confidential, ON

Sr. SAP BW Consultant

Responsibilities:

• Upgraded from sap BW 7.02 to 7.5 to BW/4 HANA in 2018/2019
• Upgraded from SAP BW 3.1 to SAP BW 7.0 in 2006
• Designed and developed end to end data warehousing solutions for various applications
• Develop SAP BW-IP (Integrated Planning) to do the Short term forecast (STF). Developed various Aggregation Levels on top of real time Info providers, created various Filters for restricting the data at the planning modeler, used various Planning Functions like COPY, DELETE, REVALUATION, REPOST, FORMULA and so on, defined the Planning Sequences for executing and testing the Planning Functions.
• Extensive experience in designing ADSO, Composite providers, Hana artifacts
• Extensive experience in building Hana information views, Calculation views and functions
• Extensive experience in Hana modeling and SQL Scripts
• Extensive experience in AMDP, ABAP routines, ABAP CDS, BW Cockpit, Data-Warehouse admin and maintenance processes
• Experience in Stored procedures and SQL Scripts
• Expertise in accessing remote data using HANA Smart data access
• Designed and developed reports using BW Queries, BEX technologies and consumed in BO technologies and some in Lumira
• Maintained the BW systems during the support pack upgrades
• Extensive experience in extracting data from CRM, SD, CCA, HR, MM, FICO, COPA and EM system extractors
• Experience in ABAP coding for BW Extractors and Transformations
• Extensive experience in Analysis process designer tool
• Provide estimates over project requirements
• Provided 7X24 support for daily batch schedule.
• Experience in load processes & scheduling process chains
• Experience in developing BW Planning tool applications using IP
• Expertise in uploading data from SAP BW & ERP to IBM Teradata tables using Datastage

Confidential

SAP BW Consultant

Responsibilities:

• Upgraded from SAP BW 2.1 to SAP BW 3.1
• Maintained the BW systems during the support pack upgrades
• Extensive experience in working with CRM, SD, CCA, MM, FICO, COPA extractors
• Developed reports in BEX query designer and Web templates
• Used existing data sources 0co om cca 1 & 0co om cca 11 according to the customer needs.
• Responsible for Infocube Building, Infocube Changes and Created Multi Providers as per the requirement.
• Technical Specifications for data mapping, conversions and interfaces. Plan OLTP extract processes.
• Used 0CCA O10 - Committed line items business content ODS to capture the future accrued costs at the line item level.
• Used Multi provider to combine different versions of the plan data with the actual infocube.
• Resolved the queries that serve the same purpose into one single query
• Supported the on-failure, backup & recovery strategies for the design by using the nearline storage technology of the filetek archiving tool.
• Wrote ABAP code in transfer rules and update rules.
• Developed load strategy; created infopackages, developed Process chain

Confidential

Software Consultant

Responsibilities:

• Familiarized with CDB, CED, Rate Capture and CARBS online screens. Loaded New Client, Account & Rate Line information into the System.
• Building Db2 queries in QMF to extract data for the comparison of Pre-Single counting and Post-Single Counting processes. Developed & used Rexx routines to automate the process.
• Going through and understanding of System and Program documentations for Carbs System.
• Familiarizing with Batch jobs in the Carbs System
• Analyzing the Triggers and Trigger tables of the CED, PREM CALC and Batch Message processes.
• Joined the Single Counting Development team and analyzed rate change programs.
• Developed conversion programs that converted the data from the old process to the new process.
• Assisted in design and developed the conversion programs and successfully completed the unit testing.
• Building the data for Single counting process testing needs.
• Loading the test data from DB2 System Test tables into DB2 Unit Test tables.

Confidential, PA

Software Engineer

Responsibilities:

• Supporting the SSNS application in all phases of the Software Development Life Cycle.
• Developing the code using C, DB2, CICS, IBM/COBOL, on Back-end of the application on MVS platform.
• Implementing code for products like “Line Hunting”, “Local Packaging” etc. at Confidential .
• Used Hierarchical data structures to transfer data from one building block to another.
• Solving issues of high priority that are opened by customers.
• Preparing and submitting jobs using JCL on MVS platform.
• Unit testing the developed code and for doing the integration and system tests.
• Developing the Korn shell scripts on Unix platform to customize the working environment.
• Reviewing SQL queries for efficiency by using the “Explain” tool on DB2.
• Putting efforts in web-based documentation using HTML to present the data structures of the SSNS application and their use in AOM modules.
• Designing a web project to access the mainframe data from the web by using the IBM provided advance technology called net.data, a macro language.