SUMMARY

• 11+ Years of IT experience, with over 6+ Years of solid experience in SAP BI/BW/BO/BODS and on SAP HANA1.0 data modeling.
• Around 5 years of experience in Lotus Notes (Domino) and Java.
• Senior - level SAP BI/BW Consultant with extensive experience in the design, development and implementation of cost-effective, high-performance technology solutions to meet challenging business needs.
• Innovative and practical SAP Business Intelligence consultant with extensive project delivery experience who engages with all levels within the business.
• Worked as onsite coordinator for projects based out onsite/offshore model.
• Drives the development of BI/ETL/Data initiatives and ensures that the benefits of SAP BI are understood by the staff and stakeholders in the organization.
• Delivered high-quality BI/Data solutions in complex and multi-disciplinary business organizations to budget, scope and plan.
• Worked in various sectors including Manufacturing, Finance; EHS, Public Sector.
• Have a good understanding of business processes for FI-CO, Logistics (SD, MM etc.), CRM, APO and IP.
• Involved in Full life cycle implementations of BW, which includes requirement analysis, data modeling, technical design and development, data extraction, report generation and transports.
• Extensive hands-on experience in Administration Workbench activities which includes customizing Delivered Business Contents and developing custom objects for business requirements.
• Having in-depth experience in implementing BI 7.x new features like DSO, DTP and Transformation etc,.
• Hands-on experience with BW related ABAP coding to enhance/customize R/3 extractors which includes LO Cockpit, COPA, LIS and create generic R/3 extractors using views, user-exits and start routines, field routines and also experienced in extracting data from Non-SAP systems.
• Experienced in performance tuning, Aggregation, Compression, Roll Up, BIA Indexes, and Secondary Indexes on DSOs.
• Actively and regularly involved in loads of master data and transaction data of Daily, weekly, and Monthly, Data Loads using Process Chains..
• Upgrading SAP BW 3.5 data flows to SAP BW 7.x. Involved in testing after the upgrade to higher versions and bug fixes and raising SAP OSS notes.
• BW/BO Reporting: Hands on experience in BeX Analyzer, Query Designer, Web Application Designer, Infoset queries, Jump Analysis using RRI. Building custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures.
• Hands on experience on SAP BW security (Roles, Authorization)
• Trouble shooting on security related issues
• Worked on BICS connection, OLAP universes, WEBI reports.
• Hands on experience on HANA (Beginner Experience) on SAP SLT Replication Server (SLT), DXC, BODS; data modeling concepts like creation of Analytic, attribute, calculation views, packages, schemas, data provisioning.
• Experienced in conducting end-user training for business users, developing Business Process documentation and technical design documents.
• Worked on setting up processes for various testing cycles like scenario testing, integration testing, regression testing, and customer acceptance testing using tools like HP quality center.
• Hands on experience on Agile Methodology.
• Presentations - Conducted workshops and presentations to validate business requirements and solutions with the end user community. Developed business process documentation
• Ability to involve in complex development and integration efforts and mentor peers, users and staff.

Areas of Expertise

• Team Management
• Requirements (business rules) gathering and analysis
• Expert in Business improvement implementations.
• Presentations-Workshops, Educating End users; End users Training.
• Good Analytical and Problem solving skills.
• Source To Target mapping.

TECHNICAL SKILLS

ERP Packages: ECC 6.0 and SAP R/3 - 4.7 / 4.6C, 3.1C.

Data Warehouse: SAP BI 7.4/7.0 and SAP BW3.5; BODS

Enterprise Database: Oracle ; MS-Access

Reporting Tools: BEx Reporting tools, Business objects 4.X

Languages: C, C++, Core Java, ABAP/4, SQL

Web Technologies: HTML, JavaScript

PROFESSIONAL EXPERIENCE

Sr. SAP-BI/BW/BODS. CONSULTANT

Confidential, MILWAUKEE, WI

Responsibilities:

• Identification of Business Needs and Constraints.
• Compiling and translating user requirements into technical design and implementation plan.
• Designing and implementing data integration processes, including data quality and testing.
• Understanding and Addressing Customer Requirements, Areas of concerns and Issues.
• Establishing guidelines, communication with client managers & end-users.
• Preparing Solution/Application Design, Development and go-live execution.
• Preparing Technical Specifications to carry out the reporting development.
• Creating workbooks to support user reporting
• Updating and create key figure structures
• Creating row structure hierarchies in Bex queries.
• Performing month-end reporting closure activities.
• Developing report hierarchies and structures as per PeopleSoft Reports.
• Involving in group discussions with COE France Team.
• Developing Security/Authorization for reporting
• Formatting reports in workbooks.
• End users training in different business units (like Boston, Canada, Houston, Milwaukee, etc,).
• Involving in reconciliation.
• Creating Analyzer/Broadcaster variants.
• Monitoring the broadcaster process chain.
• Publishing reports to BEx broadcasters.
• Creating formatted queries in Bex for webfocus.
• Executing BI workbooks and creating lookup files for webfocus reporting.
• Providing support for webfocus.
• Confirming data models.
• Creating and documenting logical data integration (ETL) strategies for data flows between disparate systems and / or the enterprise data warehouse.
• Perform other duties as assigned by manager to assist in the deployment and scheduling of solutions.
• Providing estimates for assigned tasks and work efforts.
• Providing project and task updates on a timely basis.
• Monitoring production job schedule and correct job failures in a timely manner.
• Creating projects, repositories, data sources in BODS.
• Creating data stores for source and target applications.
• Extracting data from flat files.
• Cleansing of data.
• Presenting reports to users
• Gathering further reporting requirements
• Supporting UAT activities
• Providing post Go Live support

Environment: SAP-BW/BEx 7.4 ECC 6.0, PeopleSoft, BODS, Webfocus, SQL, HPQC, Service Now.

TECHNICAL LEAD - SAP BI/BW

Confidential

Responsibilities:

• Taking part in RFPs (Request for Proposals) for various customers
• Helped Customers in Creating Business Cases for their BI/BW/BOBJ/HANA needs.
• Helped Customers to Upgrade SAP BW (from 3.x to 7.x including 7.3).
• Understanding and Addressing Customer Requirements, Areas of concerns and Issues.
• Preparing Solution/Application Design, Development and go-live execution.
• Establishing guidelines, communication with client managers & end-users.
• Preparing Technical Specifications to carry out the development.
• Delivery of the tasks as per schedule with the required documentation.
• Involved in organizing the entire Reporting solution across the client's organization.
• Involved in creating Reports & Web Dashboards for Top Management Reporting.
• Involved in creating roles and authorization objects for implementing various access rights and security in BW
• Optimized the efficiency of the BW systems and addressed performance issues.
• Maintaining Best Practices and Document Repository.
• Involved in end-to-end implementation projects of combination of Non-SAP+ ECC.
• Involved in gathering business requirements from users for sizing and critical area of the business and the system.
• Worked extensively on standard and custom defined LO extractors. Installed relevant SAP business content.
• Used LO structures for extracting sales order, delivery information.
• Logistics Cockpit Configuration, Customization and enhancing Extract Structures transaction data, master data.
• Mapping all the required fields with the info objects in the BI system.
• Replicating the required data sources from ECC system to the BI system.
• Applying the transformations as per the business requirements in the infosources.
• Exporting the data sources and creating the data mart set up to meet the business functionality.
• Aggregates and the index creation for improving the query performance.
• Data Source enhancements, generic extractors, User Exits and customized delta built up for the data sources, V3 Updates..
• Created Transformations and applying routines for restricting and transforming data.
• Involved with PSA in monitoring data transfer from source system into BW.
• Involved in performing unit testing in development server and transporting to Quality server.
• Involved in support work which includes Daily process chain monitoring, Background jobs, Support calls which needs to be fixed on priority basis.
• Worked on Business Objects (BO) integration with BW for reporting requirements.
• Worked on creating OLAP universes on top of BEx queries and used Web Intelligence to create reporting solutions.
• Involved in workshops with the business users to explain usage of SAP-HANA studio to implement SAP HANA as a pilot project plan.

Environment: SAP-BW 7.X ECC 6.0; BO 4.0; HANA; BODS; CRM, APO,HPQC.

ONSITE COORDINATOR/TECHNICAL LEAD

Confidential, PHEONIX, AZ

Responsibilities:

• Understanding and Addressing Customer Requirements, Areas of concerns and Issues.
• Preparing Solution/Application Design, Development and go-live execution.
• Establishing guidelines, communication with client managers & end-users.
• Preparing Technical Specifications to carry out the development.
• Optimized the efficiency of the BW systems and addressed performance issues.
• Involved in supporting and maintaining SAP BW landscapes including enhancements to existing scenarios for FI & SD.
• Extensive experience in implementing reporting solutions for FI-GL, FI-AP, SD, MM, CRM, Warehouse Management,
• Involved in implementing new business scenarios in BW for FI-AP, AR, GL and customized solutions.
• Creation of Info cubes, DSO’s, Info objects, MultiProviders and Data Marts.
• Involved in Modeling, Extraction and Reporting.
• Worked extensively on standard and custom defined LO extractors. Installed relevant SAP business content.
• Logistics Cockpit Configuration, Customization and enhancing Extract Structures transaction data, master data.
• Worked on Routines in Transformations, Enhancement of Data sources.
• Created Analysis Process Designer.
• Design of Queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics, Exceptions, Conditions.
• Created BEx queries for reporting on InfoCubes, DSOs and MultiProviders.
• Created Calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.
• Used ABAP to create Start, End routines in transformations to facilitate various reporting requirements.
• Worked on Business Objects (BO) integration with BW for reporting requirements.
• Worked on creating OLAP universes on top of BeX queries and used Web Intelligence to create reporting solutions.
• Involvedin resolving the Tickets (Incident & change request).
• Maintained Reconciliation's to verify the data inSAPR3 andSAPBW.
• Prepared Unit test scripts documents.
• Involved in performing unit testing in development server and transporting to Quality server.

Environment: SAP-BI/7.x; BO 4.0; ECC 6.0; HPQC

LOTUS NOTES CONSULTANT, ONSITE COORDINATOR

Confidential, DETRIOT, MI

Responsibilities:

• Worked as technical lead (onsite coordinator)
• Team Management
• Business meetings with Client.
• System requirement gathering.
• Requirement Analysis and Designing.
• Handling communication with onsite counter parts
• Modification of design elements of the application
• Involve in the development and implementation of System Reports.
• Enhancements/Reports generating for MS-Access DB application.
• System Study for MS-Access DB
• Migrating the Same application in LotusNotes.

LOTUS NOTES CONSULTANT

Confidential

Responsibilities:

• Involved in the pre-migration, remediation, migration & post-migration activities of databases.
• Team Management.
• Work initiation/assigning to the pre-migration team.
• Analyzed database for static and server dependencies.
• Remediation of the databases for new Production environment.
• Migrated to new Production environment.
• Contributed for remediating 2500+ templates.
• Proper and accurate maintenance of the database details.
• Involved in post-migration activities.
• Worked on enhancement requests raised by the users. This includes closing the user feedback calls raised by the users. (Production Support)
• Provide senior analyst and technical support function for various analyst/end users and IT Managers for applications used across the client organization.
• Hands on coding for prioritized tickets on Lotus Notes application maintenance and support.
• Evaluate estimation and sizing for project requests, and assist in query resolution raised by business clients.
• Creating K245 and doing requirements gathering for new enhancements.
• Evaluated security model, and ensured adherence as compliance standards and policies.
• Reviewing ACL/Group entries for verifying authorized and secure access.
• Team Track (Business Mashups) for use during issue and defect tracking.

Environment: Lotus Notes 6.5.5, Lotus SameTime, Lotus Script and Formula language, Team studio Windows XP, 2000.Lotus Notes, Formula Language, Lotus Script

SOFTWARE ENGINNER

Confidential

Responsibilities:

• Production Support to end-users.
• Enhancement /Change requests.
• Collecting requirements, giving effort estimates, Impact analysis, and coding.
• Implementation of CaringGov module at Client Side and handholding of users.
• Coordination with client and other administration teams.
• Closing user feedback calls on daily basis and if the problem severity is major analyzing the same and discussion with the team to resolve the issue on permanent basis.
• Trained the end users, which include State Ministers and IAS officers who are working in AP secretariat.

Environment: Lotus Notes, Lotus Workflow Architect, and Domino.Doc. Oracle 8i, MS-Word, MS-Excel Reports and Imaging Client.