21+ yrs of IT experience with last 11 yrs in SAP BW/BI & Business Objects (BO) as Architect/Project Lead, 5 Full Life Cycleimplementations, 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 todevelop 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 2008
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

SAP BW/BI Architect/Project Lead Confidential, Oklahoma City, OK May 09 – Apr 10

• 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) & 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

• Solely responsible for the development, day-to-day maintenance, support, and enhancements of the existing BW applications in whole company with 24/7 support
• Responsible for the Analysis, Design, Data Modeling, Developing the BW objects (InfoObjects, InfoCubes, ODS, InfoSets, MultiProviders), Data Loading, Scheduling, Monitoring, creation of Queries and Workbooks for Profitability Analysis (CO-PA), SD, MM, FI-CO, FI-GL, FI-AR, FI-AP, FI-SL, Consolidations, cProjects and Project Systems
• Designed, developed, customized Logistics Cockpit and extracted data from SD and MM Modules
• Interacted with business users & analysts to gather Business Requirements and analyzed the requirements
• Worked on installing the Business Content, DataSource Enhancements and created Generic Extractors & User Exits
• Worked as BW Administrator and created Users, Roles, Profiles, assigned Roles to Users, created Role based security, grant security access, unlock user id’s, reset password & Custom authorization objects on hierarchies
• Installed BW Statistics to evaluate the performance of loading and reporting
• Responsible for cleanup the system by deleting the obsolete Queries and workbooks
• Responsible for monitoring the loads and resolving the problems/errors in the loads
• Responsible for transporting the objects from Development systems up to Production Systems in R/3 & BW
• Used BW Statistics, Query Monitor, Aggregates and created Indexes to enhance the Query performance
• Created Queries in BEx with Variables, Restricted Key Figures, Calculated Key Figures, Conditions & Exceptions etc
• Developed various reports such as Profitability analysis, Quarterly Margin analysis, Backlog Purchase Orders/Sales Orders, Daily Booking of Purchase Orders/Sales Orders and Commission Reports

Environment: SAP BW 3.5, SAP R/3 ECC 5.0, BEx, WAS 6.4, EP 7.0, FI-CO, CO-PA, SD, MM, PS & cProjects

• Responsible for the Requirement Analysis, Data Modeling, Design, Development and implementation of standard/customized Info Cubes, ODS objects, Multi Providers & Info Sets for FI/CO, MM & SD modules
• Worked on CO-PA, FI-SL, LO Cockpit applications specific and generic extractors
• Created Process Chains to automate the loading of master & transaction data and periodical Deletion of PSA’s
• Used Aggregates, Compressions, Indexes and Partitioning to improve the performance
• Analyzed BW Statistics for optimization of data loads and report performance
• Developed Profit Center Accounting cubes, Accounts Payable cubes, Accounts Receivable cubes, Purchasing, Sales Order, Sales Delivery and Sales Billing InfoCubes as part of SAP BW implementation
• Developed various reports such as DSO Analysis Current Period, Days overdue Analysis, Customer Sales Trend in Sales for FI/CO and Incoming Orders Analysis and Sales Ranking Report (top 10) in SD
• Extensively used BEx Analyzer, created queries with Variables, Restricted key figures & Calculated key figures
• Configured Reporting Agent to run and execute queries during off-peak hours
• Provided post-implementation support and trained of end-users on query development and trouble-shooting
• Experienced with Crystal Reports for the reporting and Web Application Designer for the web reporting

Environment: SAP BW 3.1C, SAP R/3 4.6C, BEx, FI/CO, SD, MM, PP, Crystal Reports & WAS 

SAP BW Consultant Confidential, Indianapolis, IN Jul 01 – Dec 02

• Interacted with the management, business analysts and end-users to identify business requirements
• Designed, developed and configured Info Objects, Info Cubes, ODS Objects, Info Sources, Transfer rules, Update rules and Process Chains to suit the business requirements
• Activated Business content SD, MM, FI and CO-PA
• Created custom ODS, InfoCubes and InfoSets based on the client requirements with Start Routines
• Experienced with CO-PA extraction and LO-cockpit extractions
• Made enhancements to transaction data extractors in R/3 to accommodate the custom requirements
• Monitored data loads. Optimized load performance by adjusting the packet sizes and resolved the errors
• Improved Query performance by using Aggregates, table partitioning, indexing of Info Cubes.
• Setting up Reporting Agent to write exception/condition queries that automatically notify users using e-mail alerts.
• Created queries in BEx with variables, filters, calculated key figures, restricted key figures, exceptions, conditions etc.
• Developed various reports in SD and FI modules such as Sales Ranking, Order Fulfillment, On- time/delayed Delivery Orders, GL Balances, DSO Analysis, Dunning details, Assets Returns, Invoice list per customer & Commissions etc.

Environment: BW 3.0B, SAP R/3 4.6C, SD, PM, MM & FI/CO

Senior Mainframe Consultant Confidential, Dallas, TX Jan 01- Jul 01

• Worked in Online New Add group that set-up the new Credit Card accounts. 
• Independently developed the projects with analysis, design, development, implementation and post- implementation support phases and used Software Development Methodologies. Actively interacted with the Business Analysts, Users/Testing Group

Senior Mainframe Consultant Confidential, Dallas, TX Mar 00 - Dec 00

• Worked in Cash Posting group that reconciles the transactions with Sungard’s InvestOne software and makes adjustments to unsuccessful transactions and produces reports for the business group.
• Collected requirements, Analyzed, designed, developed and implemented new phases with the enhanced functionality
• Identified the time critical jobs and split to run concurrently to improve the performance

Senior Mainframe Programmer/Analyst Confidential, Dallas, TX Jan 98 - Mar 00

• Worked in Retail group which supports the Quotes, Issuing of Auto & Homeowner insurance policy systems.
• Collected requirements, analyzed, designed, developed and implemented system enhancements
• Developed the Data warehouse application for UniSure with using ETL tool Informatica
• Prepared the project estimates, project plans and coordinated the project activities

Senior Mainframe Programmer/Analyst Confidential, Detroit, MI Jun 96 - Dec 97

• A list of strategies proposed and implemented to eliminate the program and job inefficiencies to improve the performance.
• Modified existing programs, developed new programs, performed Unit/System Testing and verifiedperformance improvement

Project Manager: Development of Retailers Confidential, Tampa, FL (TCS, India) Aug 95 - Jun 96

• It will process the payments to the retailers for the space that they provide to display the magazines.
• Managed a team of 16, prepared the project plans and monitored all the development activities of the project at the off-site.

Monosourcing of Credit Card’s AR System Confidential, Mar 95 - Aug 95

• Role: Team Lead. It required to develop a single set of billing function programs for Asia-Pacific countries & Australia.
• Coordinatedthe development activities from the off-site and assigning the tasks
• Reviewed the modified programs, screens, Test plans, Test Results and deliverables

Development of Direct Debit Interface Confidential (TCS, India) Jan 94 - Mar 95

• It processes the BACS tapes about Direct Debit premium payments by the banks and registers the Direct Debit Dishonors.
• Analyzed, Designed, Developed new programs and modified existing programs, performed Unit/System/Integration Testing and implemented. Analyzed and solved various types of post-implementation and production problems.
• Migration of database from IDMS to DB2 Confidential (TCS, India) Jan 93 - Dec 93
• Developed conversion tools, and automated conversion activities for making source code changes
• Tested the programs and compared the test results, and reviewed the deliverables

Development of the API for Image Plus Confidential, Bethesda, MD (TCS, India) Sep 90 - Dec 92

• Image Plus is IBM’s product and capable of handling images of office documents for paperless office automation.
• Developed new on-line programs, performed Unit/Function Verification/System Testing & analyzed and solved various problems

Mainframe Environment:IBM 3090, ES9000, COBOL, COBOL II, PL/1, REXX, CLIST, CICS, DB2, IMS-DB/DC, VSAM, JCL, XPEDITER, INTERTEST, SPUFI, QMF, TSO, SDF II, MFS, ENDEVOR, NDM, FTP, CA-7, MQ Series, Abend-Aid, File-Aid, Platinum tools, JAVA, Java Script, Java Servlets, Java Beans, JSP, EJB, HTML, Visual Basic, ASP & Informatica ETL