Summary

21+ yrs of IT experience with last 11 yrs in SAP BW/BI & Business Objects (BO) as Architect/Project Lead

5 Full Life Cycle implementations, BI 7.0 Upgrade experience in SAP BW/BI-BO on SD, MM, P2P, FI-CO, FI-AP, FI-AR,
FI-GL, FI-SL, CO-PA, SRM, SCM, APO, PS, QM, PM, PP, IM, SEM-BCS/BPS, TAX, Asset Accounting, HR, IS-U CCS & FICA

• Expertise in gathering business requirements, systems analysis, systems design & solution architecture, developing solutions for complex business applications through all phases of the system development life cycle including analysis, design, configuration, development, testing, implementation, production support/maintenance functions, end-user training, developing functional design, technical design, business process and implementation plan documents
• Expertly define and map project scope and provide direction to team to align technology solutions with project requirements
• Excellent experience with enterprise application integration in large complex corporate environments
• Excellent experience in managing the projects, teams and successfully managed a team of 16
• Expertise in designing/developing/configuring SAP BI objects InfoObjects, InfoSources, DataSources, ODS, DSO, InfoCubes, InfoSets, Transfer Rules, Update Rules, Transformations, DTP’s, InfoProviders, MultiProviders, Data Marts, Infospokes/Open Hub, InfoPackages, Process Chains and Activation & Enhancing the Business Content
• Expertise in developing SAP BO Universes, Web Intelligence, Crystal Reports, Xcelsius Dashboards & QaaWS
• Extensive experience in loading the data from R/3, ECC, cProjects, Oracle, 3rd party & legacy systems
• Extensive experience in Data Modeling, Extraction, Cleansing, Loading, Scheduling, Monitoring, Delta Management, Reporting, troubleshoot issues with data integrity andUser & Security administration
• Strong knowledge of BI extractors from the ECC system and working knowledge of SAP structures & tables
• Excellent in ABAP to develop Programs/Function Modules, Start/End Routines, User Exits to Enhance Extractors, customize Transformations/Transfer/Update Rules, analyze Dumps and resolve team members ABAP issues
• Strong Data Warehouse (DW) background to translate customer\'s needs into technically sound DW solutions
• Interacted with business analysts, end users, functional experts, process teams, SME’s, Finance controllers, senior managers, executives and COE to identify the requirements
• Excellent experience in data extraction from legacy applications, non-SAP and SAP
• Extensive experience with standard FI-SL, LO cockpit, SRM & CO-PA Extractions and Generic Extractions
• Excellent experience with BI Accelerator, Business Explorer (BEx) Query Analyzer, Query Designer & Report Designer and Web Application Designer (WAD) for Web Reporting
• In-depth knowledge of data warehousing and data management, and database design and performance issues
• Strong in BW Performance Tuning (Query and load performance), SQL tuning, indexing and partitioning
• Good experience in researching SAP issues through OSS, applying OSS Notes and creating the Customer Messages
• Very good ASAP Methodology knowledge for system designing, development and implementation
• Good experience with Portal Integration
• Excellent experience with Mainframe technologies and good exposure to Java technologies
• Excellent knowledge with project management best practices, methodologies and tools
• Aggressive, self-starter, ability to quickly adapt to client’s requirements and always focused on customer satisfaction
• Excellent analytical, problem solving, Communication, interpersonal, multi-tasking and leadership skills
• Excellent verbal and written communication skills
• Excellent Team player, flexible, ability to perform under stress and work effectively in fast paced environments
• PMI Certified Project Management Professional (PMP)
• SUN Certified JAVA2 Programmer

BW/BI : BW (3.0B, 3.1C & 3.5), BI 7.0, 7.1 & familiar with BI 7.3 functionality
SAP R/3 ECC : SD, MM, PS, FI/CO, HR, IS-U CCS (4.6C/ECC 5.0/6.0/6.5), SEM (4.0 & 5.0), SRM 4.0, SCM 7.0 & cProjects
Web : EP 7.0, SCP 6.0 & WAS 6.4
Languages : COBOL, ABAP, SQL, JAVA, HTML & Visual Basic
Databases : DB2 8.0 & Oracle 9.2.0 & 10.2.0
ETL Tools : Informatica, DB Connect & UD Connect
Reporting Tools : Business Explorer, Web Reporting & MS- Excel
Business Object Tools: XI 3.1, familiar with BO 4.0, Info View, Universe Designer, Web Intelligence, Crystal Reports & Xcelsius
Operating Systems : AIX 5.3, MVS/ESA, OS/390, z/OS and Windows 3.x/95/98/NT/2000/XP/Vista/7
Others : SAP Solution Manager, P Quality Center, Lotus Notes, MS Office, MS Project, Outlook, Power Point & Visio
Industries : Banking, Insurance, Credit Cards, Retail, Automotive, Financial, Manufacturing & Utility (Gas & Electric)
Education: Masters (M. Tech) degree in Computer Science & Engineering Osmania University, Hyderabad, India
Employment: Started with India’s largest IT company, Tata Consultancy Services (TCS) in 1990 & worked for 6 years

Detailed Project Experience

• Designed, developed and implemented enterprise-level Business Intelligence solutions to address ongoing business strategies
• based on business requirements, technology standards and service level agreements
• Interacted with senior management and business leaders to elicit business and technical information in order to produce high quality decision making solutions.
• Worked closely with SME’s, functional specialists and process owners to gather detailed business requirements and translated the requirements into robust reporting solutions.
• Developed data models, data flow diagrams, functional design and technical design documents for BI Solutions
• Responsible in providing leadership, guidance, and mentoring for a team of 5 Business Intelligence members
• Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity
• Acted as integration point between the management, development team, business process group, BASIS and database group.
• Ensure the creation of solutions will address quality, performance, availability, scalability, and integrity
• Created solution road map, ensure that scope of solution is manageable, integrating multiple disparate processes and addressing short and long term organizational need
• Responsible for defining and driving the use of standards for BI work and review the quality of the development work.
• Evaluate tool selection and emerging technologies in the area of Business Intelligence.
  Environment: BI 7.0/7.1, ECC 6.0/6,5, BO XI 3.1, BEx, FI/CO, SD, MM, PS & IM

• Provided hands on leadership, direction and guidance to design and develop a sustainable Enterprise wide Business Intelligence reporting framework and solutions
• Lead the planning, data modeling, detailed requirements analysis and deployment of a project engagement for Inventory Management, Procure-To-Pay (P2P), Order-To-Cash (OTC) & Revenue
• Assess and cultivate long-term strategic goals for data warehousing in conjunction with data users, department managers, clients, and other key stakeholders
• Assigning and managing work activities, meeting deadlines and developing project management reporting
• Developed cost estimates and timelines for detailed analysis, design and implementation
• Worked with SME’s and functional experts to gather detailed business requirements and drive functional and technical designs
• Created detailed solution documentation and presentations
• Developed naming, cube design, security standards, and design principles
• Developed/configured SAP BI objects/components and performed Data Extraction, Data Loading, Scheduling & Monitoring the Process Chains, creation of Queries and Workbooks
• Configured Transformations, DTP’s, Start & End Routines to meet requirements at optimum performance
• Managing support issues, ensuring performance optimization, planning and managing upgrades and enhancement packages
• Used ABAP to develop/modify Function Modules, Programs, Start Routines, End Routines, Enhance Data Sources with User Exits
• Used BW Statistics, Query Monitor, Aggregates, Compressions, partition to improve the loading & Query performance
• Identified and executed business performance improvement initiatives
• Responsible for transporting the objects up to Production Systems in ECC & BI
• Coordinated effectively with SAP Basis, Security and DBA team to resolve performance and data issues
• Documented BW configuration, functional & technical design and implementation plans for easy support and maintenance

Environment: BI 7.0, ECC 6.0, BO XI 3.1, BEx, FI/CO, SD, MM, PS, IM, HR and IS-U CCS

• Lead to develop and implement new SAP BI applications/solutions in IS-Utility CCS, IS-U FICA, FI, SD, Enterprise Asset Management (EAM), Project Systems and HR/HCM modules
• Responsible for the requirement gathering, Analysis, Design, Data Modeling, Developing the BI objects, Data Extraction, Data Loading, Scheduling, Monitoring, Process Chains, creation of Queries, iViews and Workbooks
• Activated/customized the Business Content, developed/configured InfoObjects, InfoCubes, DSO, MultiProviders, InfoSets, Process Chains, Enhanced the DataSources, developed Generic Extractors as per business requirements
• Developed & implemented SAP BO’s Universes, Web Intelligence, Live Office, Crystal Reports & Xcelsius Dashboards
• Interacted with business users, business analysts and process team to gather Business Requirements and analyzed the requirements to develop the BI solutions
• Developed/configured Transformations, DTP’s, Start & End Routines to meet requirements at optimum performance
• Used ABAP to develop/modify Function Modules, Programs, Start Routines, End Routines, Enhance Data Sources with User Exits
• Provided technical guidance, helped team members in resolving the data load, design and ABAP related issues
• Used BW Statistics, Query Monitor, Aggregates, Compressions, partition to improve the loading & Query performance
• Developed very complex Queries in BEx with BEx User Exit Variables, RKF, CKF, Structures, Conditions, Exceptions etc

Environment: BI 7.0, ECC 6.0, BO XI 3.1, BEx, WAS 6.4, BI Accelerator, EP 7.0, FI/CO, SD, MM, PS, HR and IS-U CCS/FI-CA

• Lead BW upgrade project from BW 3.5 to BI 7.0 Upgrade
• Developed new projects in FI, CO, SD, CO-PA, Asset Accounting, HR, SEM-BPS & SEM-BCS and enhanced existing reports
• Responsible for requirement gathering, Analysis, Design, Data Modeling, Developing the BW/BI objects, Data Extraction, Data Loading, Scheduling, Monitoring, creation of Queries, iViews and Workbooks
• Installed/configured the Business Content, developed/ configured the InfoObjects, InfoCubes, ODS, DSO, InfoSets, MultiProviders, Process Chains, DataSource Enhancements, Generic Extractors, Transformations, DTPs, User Exits and customized the objects as per business requirement
• Developed/ configured Transformations, DTP’s and Start Routines to meet requirements at optimum performance
• Interacted with business users & analysts to gather Business Requirements and analyzed the requirements
• Performed Remodeling feature to add new InfoObjects into InfoCube without deleting the existing data in InfoCube
• Used BW Statistics, Query Monitor, and created Aggregates & Indexes to enhance the Query performance
• Extensively used BEx Analyzer, created Queries with BEx User Exit Variables, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions etc
• Created the functional design, technical design and implementation plan documents
• Developed various reports such as Sales Review, Rebates, Shopping Cart per Contacts, Tax Expenses for Budget & Forecast, Balance Sheet, Taxable Income Summary, Asset Values and Invoice Analysis.
• Used Reporting Agent to create the batch jobs for Report printing and Exception reporting
• Communicated effectively with SAP Basis and DBA team members to resolve performance issues

Environment: BW 3.5, BI 7.0, R/3 ECC 5.0 & 6.0, BEx, WAS 6.4, EP 7.0, FI-CO, CO-PA, SD, SEM-BCS, HR, SCP 6.0 & SRM 4.0