We provide IT Staff Augmentation Services!

Consultant Resume

Melville, NY

SUMMARY

  • SAP BOBJ /HANAProfessional with16plus years of experience in IT industry with various clients, such as Confidential .
  • Worked experience spread in Manufacturing, Non - Profit Organization, Aerospace, Financial Institutions, Utilities and Pharmaceutical Domains Strong interpersonal and communication skills,
  • Ability to work independently and a proactive team member, comfortable interacting with customers and technical teams, Strong analytical & problem-solving skills, Followed many SDLC Methodologies including agile and Scrum on different projects.

TECHNICAL SKILLS

HANA: HANA and HANA 2 Platform. Developed content by creating Attribute views, Analytical Views, Calculation Views and Decision table, Table Function, Procedure and Analytical Privilege. Data Provisioning used SLT, DXC and Data Services. Responsible for requirement gathering, translating Functional Specifications into Technical Specifications and Business KPIs into HANA Models & Define teh Reports/Dashboard Layouts.SUM & DMO, Optimization, Backup, Data Recovery strategies

Business Objects (BOBJ): Business Objects Enterprise XI R2/ XI 3.1, Business Intelligence Platform 4.1,4.2, Business Object Edge Solution, Universes IDT and UDT, Qwaas, Query Developer, BEX Query Designer, BICS, Xcelsius 2008, Dashboards and Analytics XI 3.1, Dashboards and Presentation Design 4.0/4.1/4.2 Crystal Report 2008/2011/2013 Crystal Enterprise 4.0/4.1/4.2, Crystal Server, Explorer 4.0,4.1, Lumira 1.25,1.28, Design Studio 1.0 to 1.5, Web Intelligence WEBI XI3/4.0/4.1/4.2, Analysis Edition of Microsoft office and OLAP 1.4,2.0, BOBJ SDK, Designed and developed complex reports in SAP BI 7.3/7.0, Mobil UI, Launch pad, Upgrade Management tool, BICS, CMS, CMC, LCM, Authorization and Autantication, Installation, Version upgrade, Patches and Integration.

SQL: Extensive experience with SAP SQL/Script, Oracle PL/SQL, SQL* PLUS, SQL Navigator, SQL Developer, CA ERwin Data Modeler 7/8/9, ANSI/ISO 92, T-SQL, IBM DB2, MY SQL, TeraData 13/14 Stored Procedures, Functions (UDF), Views.

BODS: Business object data Services BODS 4.0/4.1Web Admin/Management Console, Queries in Data Services, MYSQL Frontend MySQL Server, ETL, Data Integration, Data Profiling, Data Modeling, Data Warehouse, Data Conversion, Check-ins, Check-out objects with Central Repository, Work Flow, Conditionals, Data Flow, Query, Transforms, Lookups, Variables, Functions and custom Functions, Data mapping functions and conversions

Data Warehouse: SAP BW/ BI 7.0 / 7.3 /7.4 BWonHANA, BW/4HANA InfoObjects, ADSO, DSO, Multi Provider, Virtual Provider. Transient Provider, Data modeling Dimensional & Relational concepts includingStar-schema modeling, Snowflakes modeling, Extending Star Schema in SAP BW. Fact and dimension tables and followed Kimball and Inmon Models EDW concepts. Big Data Integration with HANA SPARK and Vora

S/4 HANA Finance: CDS Views, Fiori development. Functional and technical knowledge SAP ERP 1511/1610 and ABAP,AMDP,VDM, SD, MM, PS, FM, OF, SCM, SRM, CRM, HR, FICO, APO, HCM, ABAP, SQL, LSMW, ALV, BAPI, ALE/EDI, RICEF, BPC 10, Workflow & RFCSoftware: JavaScript, BIAL, UI5, HTML, CSS, XML, JQUERY, 3Djs, R, MS CMD, Unix Bash, Web Services, WSDLTableau: Desktop/Server 8/9/10

PROFESSIONAL EXPERIENCE

Confidential Melville, NY

Consultant

Responsibilities:

  • me was assigned to convert complex legacy excel based Financial Models into BOBJ 4.1 Reporting formats and responsible to convert many aspect of business Metrics, KPI and Dashboards.
  • Participate in Data Mapping workshops and follow-up meetings with teh client business
  • Created custom templates and custom lookups and shell jobs and used them in various business needs.
  • Fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.
  • Build universes on top of HANA information models for Webi/Dashboard reports.
  • Working extensively with Sales & Distribution team to design data migration from Legacy system to SAP.
  • Working with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
  • Using Data Integrator and Platform Transforms extensively.
  • Build HANA Information models (Attribute Views, Analytical Views, Calculation Views, Column/Row based tables) in HANA design studio for efficient data integration.
  • Designed single source of truth system of Financial Data Warehouse containing R/3, Teradata, BPC, Marketing Expense Management data.
  • Designed Automatic Reconciliation Tool that compares data across different SAP landscapes and versions, Non-SAP landscapes like Teradata and aggregated as well as summarized level of data.
  • Performed SAP Data Migration by using Business Objects Data Services as teh ETL tool
  • Using HANA CDS views for reporting
  • Worked for SAP HANA Transient Provider by connecting with SAP IDT tool
  • Integrating Tableau with HANA Database
  • Using Design Studio, WEBI and Tableau for Reporting

Environments: BODS 4.2, BOBJ 4.1, SQL, S/4 HANA, Design Studio, Lumira, WEBI, CDS view

Confidential

Consultant

Responsibilities:

  • me was assigned to convert complex legacy excel based Financial Models into BOBJ 4.1 Reporting formats and responsible to convert many aspect of business Metrics, KPI and Dashboards.
  • Worked directly with Business for defining and analyzing gaps between business requirement and technical requirement.
  • Used Oracle 11g Stored Procedure to extract data and save them into teh Materialized view
  • Developed SAP BO 4.1 semantic universes using IDT tool.
  • Delivered reports covering WEBI, Dashboard and Design Studio.
  • Performed user training sessions for SAP HANA Information Models.
  • Worked with Tech Mahindra team to Model Design and deliver Commercial SCM and Military SCM reports for Spirit.
  • Worked with teh development and test teams to build, test, and implement teh solution.
  • Develop architecture / implementation plan for BI projects.
  • Design, maintain and enhance all BI components and optimize for reporting efficiency and scale.
  • Designed and developed ETL routines in BODS, modified or created new
  • Data Services to meet Project Requirements.
  • Analyze user needs and create cardinalities, contexts, joins and aliases.
  • Work with business users and define dimensions and measures.
  • Establish, maintain and administer reporting environment, including scheduling, distribution, user permissions, and updating reports and dashboards
  • Optimized teh queries performance
  • Implemented ABAP data flow processing using Data services for Extract data from multiple tables from ECC6.0
  • Scheduling teh jobs by client requirement by using Business objects data services Management Console.
  • Created customized report for different type of reports standardization of report formats, filter options, page break options, and output options; as well as additional flexibility in terms of report data selection.
  • Created project actuals and planning reports based on HANA models.
  • Created complex reports using union queries, conditional formatting and prompting, drill-through.
  • Created reports with cascading prompts.
  • Batches generate PDF Reports using Subscriptions.
  • Involved in enhancements of Data Services Jobs, and applying Patches on HANA.
  • Involved in testing teh newly developed reports vs teh pre-migration Reports.
  • Involved in Testing and Test Plan Preparation, Process Improvement for teh ETL developments.
  • Evaluated Report Performance upon completion of teh reports and validated output data.
  • worked with end user and finalize teh UAT
  • Responsible for Created user-groups in CMC and implemented teh security model on teh groups created.
  • Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections)
  • worked with end user and finalize teh UAT

Environments: BOBJ 4.1, Oracle 11g, EEC 6, HANA, Lumira, Design Studio, Crystal Report 13, Crystal Report Enterprise

Confidential, NY, NY

Consultant

Responsibilities:

  • My responsibilities were to developed and visualize data into infographic and story building dashboard to represent all registered student success story to get entered into Graduate schools.
  • Act asliaisonbetween SAP and Confidential to implement, integrate and modeling HANA Cloud platform for Confidential environments
  • Responsible for ETL process and used SAP BODS 4.0
  • Collected business requirements for developing reports on SAP BOBJ BI 4.1
  • Used IDT to converge various source data into ROLAP for Reporting purposes
  • Developed LUMIRA Enterprise for Dashboard, Story Building and Infographic
  • Used CMC, CMS, and Launch pad to make sure system follow SAP Best Practice for user Security as well as Application Optimization.

Environments: BOBJ 4.1, Lumira, HANA Cloud, BODS 4.1, SQL Server 2010, Oracle 11g

Confidential

BOBJ Architect/Developer

Responsibilities:

  • Developed complex Financial ad hoc reports in WEBI
  • Worked with Business Backend team, functional consultant and ETL team to gather and
  • developed BEx Queries
  • Created multi provider complex Universe through IDT
  • Created linked WEBI to Dashboards through WEB Services
  • Created Tableau based Dashboard and Stories
  • Created SAP HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
  • Product Test execution and script writing to test
  • Importing teh BW Models in to HANA using HANA Studio
  • Design, develop, and configure software systems to meet market and client requirements end-to-end from analysis, design, implementation,
  • quality assurance including testing, to delivery and maintenance of teh software product Apply knowledge of technologies, applications, methodologies, processes, Best practices and tools to support a client
  • Worked with five developers off shore India base team for day to day progress and keep them sync with ongoing project deliverables.
  • Involved in creation/review of functional requirement specifications and supporting documents for business systems.
  • Experienced in database design process and data modeling process.
  • Designed and developed ETL routines in BODS, modified or created new
  • Data Services to meet Project Requirements.
  • Designed Dimensional Data Model to implement teh consolidated view of Members and Claims using data modeler.
  • Designed a high level architectural model for teh ETL implementation of Insurance Claims, Membership Coverage and Status Tracking for teh developers.
  • Studied existing OLAP system(s) and created facts, dimensions and star schema representation for teh data mart and warehouse systems.
  • Documented and Maintained Data Dictionaries with teh updated Data Model Enhancements.
  • Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
  • Involved in Performance tuning.
  • Created / scheduled SQL server jobs and maintenance activities of Database.
  • Developed queries for data analysis and analysis on teh defects raised by end-users and fixing teh defects.
  • Managed and coordinated all user acceptance testing.
  • Created customized report including, filter options, page break options, output options as well as additional flexibility in terms of report data selection.
  • Created complex reports using union queries, conditional formatting and prompting, drill-through.
  • Assisted users in troubleshooting their queries.
  • Created repository and security domain with user groups and security implementation multilevel hierarchies are set up enabling teh drill down functionality and created Derived Tables.
  • In a multi-server environment, implemented load balancing efficiently across multiple machines greatly enhances scalability and end-user response time. Scheduling and publishing reports onto WEBI to different destinations
  • Migrated Universes, Reports, Securities from teh Development to Production environment after UAT
  • Product Test execution and script writing to test
  • Responsible for Created user-groups in CMC and implemented teh security model on teh groups created.
  • Design, develop, and configure software systems to meet market and client requirements end-to-end from analysis, design, implementation,

Environments: BOBJ 4.0, BW 7.3, HANA, BODS 4.0, DB2, SQL 2012, Oracle 11g, SQL 2008, ECC 6.0, Crystal Report 11, Informatics power center, Lumira, Design Studio

Confidential

Functional Design Lead

Responsibilities:

  • Developed complex BEx Queries by creating various variables, exceptions and filters including user exits variables to generate financial Reports based on BEx tools including Work Books /Web Application Designer.
  • Work extensively with Reporting team to beat challenging deliverable time limit using BOBJ 4.0 and BI
  • with teh client functional SME and teh business to refine and develop teh use case and descriptive analytics requirements
  • Responsible to Develop Dashboards and WEBI with complex drill down object
  • Finished documenting requirements and working with teh application development team to ensure they are understood and deliverable.
  • This is a key role across 4 pilots using teh newest HANA 1.0 and Business Objects technology BOBJ BI 4.0.

Environments: BOBJ 4.1, Oracle 11g, EEC 6, HANA

Confidential

Software Developer

Responsibilities:

  • Create BO Universes in IDT
  • Used SAP HANA to create required Data Marts
  • Used Data Services for ETL
  • Created Lumira based Dashboard and Stories
  • Web Intelligence WEBI Reports and Dashboards using BOBJ 4.0.
  • Created complex dashboards in limited short period of time targets.
  • Used TeraData 13 as a backend data source.

Environments: BOBJ 4.0, BW 7.0, BODS 4.0, SQL 2012, DB2, SQL 2008, ECC 6.0, Crystal Report 11,TeraData 13, Lumira

Confidential

Software Developer

Responsibilities:

  • Designed, developed, and configured reports using BO Enterprise XI3.0
  • Developed complex WEBI and Xcelsius Dashboards,
  • Developed Crystal Reports 2011 and sub reports
  • and to meet client requirements either end-to-end from analysis, design, implementation, quality assurance (including testing), to delivery and maintenance of teh software product or system or for a specific phase of teh lifecycle.
  • Used experienced and knowledge on technologies, applications, methodologies, processes and tools to support a client, project or entity.
  • Used SAP BODS to migrate data from Oracle to SAP/R3 system and used as cleansing data.
  • Involved in gathering business requirements from business users.
  • Developed and supported teh Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources including EDW.
  • Analyzed teh source data, cleansed, standardized source data and provided cleansed data to ETL.
  • Integrated different source feeds and extracts from systems across enterprise.
  • Designed High-level design documents and ETL mapping specifications.
  • Effectively worked with Data Modeler to develop Logical and Physical Dimensional Model for Data Marts.
  • Designed and developed Job Sequence for teh ETL jobs.
  • Map teh source and target databases by studying teh specifications and analyzing teh required transforms.
  • Used PL/SQL to populate teh data marts.
  • Created customized report for different type of reports standardization of report formats, filter options, page break options, and output options; as well as additional flexibility in terms of report data selection.
  • Created complex reports using union queries, conditional formatting and prompting, drill-through.
  • Created reports with cascading prompts.
  • Graphical presentations like pie chart, bar charts, line charts were created for analysis and statistical information.
  • Involved in testing teh newly developed reports vs teh pre-migration reports.
  • Assisted users in troubleshooting their reports.
  • Evaluated Report Performance upon completion of teh reports and validated output data.
  • Deployed packages, Reports from a development environment to test environment.
  • Developed, managed, and coordinated all user acceptance testing.

Environments: BOBJ 4.0, BW 7.0, BODS 4.0, SQL 2012, DB2, SQL 2008, Crystal Report 11, ECC 6.0, Tableau 8, TeraData 13

Hire Now