SUMMARY

• Overall 14 Years of experience in Information technology field with strong emphasis on Data Warehousing and Business Intelligence, which includes Architect roles, Development, Administration and Support solutions for Business Objects Data Services.
• Over 14 years of experience with SAP Data Services and data integrator as an ETL tool and also more than 8 years of SAP Data Conversion Experience.
• Installed and configured the Business Objects Data Services V.4.2/V.4.1/V4.0, Data Services XI 3.2 with SAP BI, ECC, SCM and CRM.
• Experience in installing and working with the Information steward 4.0.
• Expert in Data Services Data Quality (DQM) like address cleansing and data cleansing process
• Created the Repositories on Oracle 10g/11g, SQL Server 2012, and Linux and configured the Local, Profiler repositories with Job server and Management console.
• Strong understanding of RDBMS and Data warehousing concepts and Knowledge in Data mart development, ER Modeling and Data - Flow Modeling.
• Worked with Data Integrator, Quality and Platform Transforms.
• Extensively worked on development of mappings and worked with BODI Transformations like, Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation Etc
• Experience working on Change Data Capture on both Source and Target level and implemented SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.
• Worked extensively on integration of Business Objects Data Services with SAP modules and non-SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2005/2008/2012 , DB2.
• Knowledge in SAP modules SD, MM, FI, and CO.
• Extracted SAP ECC Extractors data (SD, MM, FICO, CO PA) and loaded it into Enterprise Data warehouse. Developed various SAP BODS Jobs based on the delta extraction type of ECC extractors to setup the subscription for delta extraction process.
• Experience in Data Warehouse/Data Mart Multi-dimension logical/physical model design) for many industries such as Finance, Insurance, automobile, Utility Service and Manufacture. Extensively used Kimball dimension modeling.
• Expert in advising clients, offering configuration, best practice advice and enablement from technical perspective on Responsys.
• Strong background on implementing best practices to provide a clear path for clients to drive more value and efficiencies from Responsys.
• On HANA Database expertise on Data provisioning and transformation techniques, Modeling techniques, Security and authorization techniques
• Experienced in loading data from multiple sources to tables into HANA Database.
• Worked with ABAP dataflow and Data transports to extract the data from R3 tables.
• Used the SAP inbuilt AIO jobs for customer master, material master, vendor master.
• Expert in using LSMW, BDC's & IDOC's in loading data into SAP ECC 6.0
• Loaded data into Customer master, Material master, and Vendor master using DEBMAS, MATMAS, and CREMAS IDOCS by referencing SAP AIO jobs.
• Used Data services XI 4.2 as an external system as ETL to extract data from ECC and BI for cleansing the data using Data Quality transforms.
• Worked with Open Hub Services to push data out of SAP BI using Data Services. Also
• Worked with Match and Associate Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Worked extensively with AIO (All in One) Templates and SAP ABAP.
• Worked on Profiling and Auditing in migration.
• Installed and have development work on the Information Steward and done some profiling tasks in data insight.

TECHNICAL SKILLS

• SAP BI 7.0/3.5
• SAP BO Data Services 4.2/4.1,4.0, XI 3.2 SP1(Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2., SIA, Central Management Console, Central Configuration Manager, Designer, Tomcat, Apache
• Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader.
• ORACLE 11.2/10g/9i/8i, DB2, Informix, MS Access, MS
• SQL Server 2005, 2008, 2012, Syspro, David database.
• SQL, PL/SQL, ABAP, Java, C#, .Net, VB.net, C, C++
• Servlets 2.0, JSP 2.0, XML (XSDL, XSLT, SAX, DOM)
• HTML 3.2/4.0, IIS 4.0/5.0.
• UNIX, Linux version 3.0.13-0.27 , MS-Dos, Windows NT 4.0/2000/ 2003/2008 r2, xp

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

SAP BODS Consultant

Responsibilities:

• Initiated client meetings and Gathered the requirement.
• Created mapping document and performed Gap/Fit analysis.
• Identified the objects from the scope and estimated the Project Schedule.
• Designed and Developed High level and low-level design document.
• Created Local and central repository for the IPayables Project. Also Configured them using administrator console as per business requirements.
• Involved in meetings with Cloud based application functional users (IPayables and Salesforce), to determine the flat file layouts, data types and naming conventions of the column and table names.
• Worked on the project which involved in the designing of newly Oracle database.
• Worked in the development of the account payables extractions and the enhancement of sever objects involved in the concerned applications.
• Strong Responsys product knowledge and expert in implementing best practices to collaborate with customers in defining effective account setup integrations, targeted segmentation using filters and SQL, automated lifecycle programs and other areas
• Knowledge of Oracle Responsys Programming Language (RPL) as well as HTML.
• Has understanding and hands-on experience on EMD/RPL
• Data-analysis for Marketing Group. Compiled marketing information from the Oracle data-warehouse for marketing clients using the SCIF Oracle marketing Information Warehouse. Tools used include FastLoad, FastExport, MultiLoad, BTEQ and customized windows scripts.
• Full responsibility for the research, design, testing and implementation of the marketing system. This involved gathering requirements, creating functional specifications, transforming these in detailed specifications and finally modeling a database and developing a complex and interactive system that allow users to submit requests and have the requests assigned and completed.
• Installed the salesforce adaptors and configured with the SAP BODS Data services.
• Worked on Dimension modeling as per business needs and created Fact and Dimension tables.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements
• Worked on Error handling and auditing. Developed mechanism to collect statistical information of jobs into control tables for recovery and performance optimization.
• Involved in creation of recoverable workflows during source and target server crashes.
• Implementing both source and target-based CDC using time stamp and history preserving transforms.
• Worked on Extracting Data from SAP ECC, SAP HANA and SQL server and loaded into Cloud based application IPayables and Salesforce application.
• Used different transforms such as Query, Case, Table Comparison, Key Generation, Merge, Date Generation, Pivot transforms and functions like ifthenelse(), substr, lookup, lookup ext etc. as per requirement.
• Migrated code across the environment using the central repository.
• Scheduled the jobs using third party scheduler active batch.

Confidential

SAP BODS Consultant

Responsibilities:

• Involved in the business requirement meetings to understand the Enterprise reporting requirements for designing new reports and dashboards.
• Assisted Business analyst in identifying KPI's and metrics for business processes and data improvement.
• Based on identified KPI’s developed/modified new and existing ETL jobs towards project completion.
• Profiled various information systems databases/applications and identified source/target mappings and transformations based on project requirements.
• Worked on Dimensional Modeling design using Kimball methodology.
• Worked independently, conducted assessments and meetings with client on SAP DS/IS capabilities. Worked on new initiatives and available features.
• Used all DI transforms such as Query, Validation, Case transforms as well as DQ transforms such as Match, Associate, Data Cleanse & Address Cleans.
• Extensively used SAP Business Objects Data Quality for addresses profiling, parsing, standardization, cleansing, matching for customer, product and material data.
• Worked on staging reference data from legacy systems as well as SAP ECC and used the reference data to lookup information required for SAP CRM loads, for Ex. Country description for country codes.
• Developed complex SAP Data Services job flows to extract from/load to SAP systems such as SAP ECC, CRM, SCM, BW, HANA as well as non-SAP systems such as Oracle, MS SQL Server.
• Loaded data into Customer master, Material master, and Vendor master using Vendor master -- DEBMAS, Product/Material Master -- MATMAS, and Customer Master - CREMAS IDOCS using SAP AIO business content and jobs.
• Extensively used IDOCS in loading the prerequisites objects, master data objects and transaction data objects.
• Extensively utilized BAPI to create and modify LSMW to load object using custom jobs.
• Worked on performance Tuning of long running jobs used techniques like pushing down operations to database level, using cache memory, Degree of Parallelism, collect statistics to monitor jobs.
• Implemented optimized techniques and tuned jobs for high volume and complex transformation scenarios.
• Configured additional DS components including job server and repositories.
• Created and configured DS data stores to connect to variety of data sources such as SAP HANA, SAP R/3, SAP BW, Oracle, MS SQL Server.
• Developed Map CDC jobs to extract data from SAP Extractors & Tables, SAP BW DSOs, also loaded data to BW PSA
• Automated DS/IS jobs using in-built and third-party schedulers.
• Developed and executed advanced data profiling, data validation scenarios

Confidential

SAP BODS Consultant

Responsibilities:

• Integrated SAP suite of BI products with Business Objects including Business Objects Data Services (Rapid marts).
• Installed and configured SAP Data services 4.2 SP7 Client on SQL server environment in non-production and production environment. Created Local, Central and Profiler Repository with SQL Server 2012 and configured it with job server and management console.
• Installed the SQL Server 2012 R2 and created the Databases for Data Services and Repositories.
• Implemented Cost Center, Fixed Asset, Purchasing, Sales Analysis, Account payable, Account receivables, Production planning, General Ledger and Inventory Rapid marts for deploying rapid reporting solutions. All prebuilt rapid marts are customized based on business requirements.
• Prepared Dimension analysis, Kimball Bus Matrx and Data model as per requirements from FRD.
• Architected Chromaflo-CPS integration project and designed ETL process and guided a team of developers to meet demanding deadlines.
• Standardized the customer master and Material master data during the data integration of merger company.
• Initiated interaction with business and SAP functional resources to find the data integration requirements and modifications. Based on Business requirements and existing database structures developed ETL data mapping document.
• Developed the High-level and Detail-level documentation of the project.
• Worked with ETL programmers on implementing the Design of the project with Data mapping blue prints and also met project standards using proven data load tools and methodology.
• As a part of Chromaflo new acquisitions extracted data from multiple ERP systems (Microsiga of Brazil region, Syspro of china region, SAP ECC 6.0 of NFTA region, SAP ECC 4.6 of EMEA region, David database of south Africa region) and various CSV/Excel spreadsheets to Enterprise data ware house (SQL Server 2012) using several ETL tools.
• Developed SQL Server Cubes to extract the data as CSV files for loading data in the non-integrated server environment.
• Created Real Time Jobs and Nested Structures Using BODS.
• Created data store connection for several applications in BODS including the web services applications.
• Used Data Integrator to call external Web Services from within its jobs using a built-in web services adapter
• Strong SQL Server scripting skills. Capable of developing the complex SQL server structures and lookup tables which are used during the rapid mart process.
• Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs to extract data as files.
• Developed Stored procedures and SQL Jobs to defrag and compress the SQL Server tables for performance optimization of database. In the process created/altered the indexes and partitioning of the database tables.
• Implemented Data services optimization techniques to improve the jobs performance. It includes the cache adjustments, bulk loading, commit row sizes, increasing the parallel processing, push down SQL, adjusting Look up techniques.
• Worked extensively on the COPA based timestamp type extractors for extracting the profitability business related information. Capable of maintaining and enabling of various delta type of SAP ECC extractors.
• Developed an Error handling technique to address the internal SAP BODS application bugs to enhance the stability of the SAP Business objects enterprise.
• Designed, developed, deployed and maintained universes using Business Objects designer, tableau. Installed and configured Business enterprise in a multi-tier environment.
• Created customized Web Intelligence reports from various sources of data. It includes major managements reports for sales by region, sales by market segment, sales by sales manager, sales by product hierarchy, sales by customer hierarchy.
• Managing the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CCM. Security design features of Business Objects like row level, report level & object level security in the universe to make the sensitive data secure by creating Users/Groups/Sub-groups & assigning the privileges.