U.S Foods

  • Cary, NC, USA

Manjula P

 

Email:manjurp@gmail.com                                                                                                        Mobile# 224-241-4961.

 
PROFESSIONAL SUMMARY
 
  • 10 years of IT experience Having 5 years of Experience in SAP BO.
Implementations, custom development involving all phases of the package development life cycle to meet the business needs.
  • Have Professional experience in designing, development of Data warehouse, reporting in Business Objects Enterprise 4.0, XI3.0/3.1/4.0/R2/6.X including End-to-End BO Implementation.
  • Strong Experience in Business Objects Suite (XI/XIR2/XI3.1/4.0), Universe Designer/IDT, Deski, BI Launch Pad, Webi - Rich client, CMC and Import wizard.
  • Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
  • Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
  • Involved in developing, modifying and maintaining universes.
  • Design and developed new Classes and Objects in the Universe based on Functional Specifications.
  • Experienced in creating Universes, resolving Loops, Traps and Testing the Universe and developing Derived Tables according to the requirements.
  • Extensive experience in migrating Business Objects reports from XI R2 to XI 3.1 Version.
  • Experienced in changing Deski reports to Webi using report conversion tool.
  • Experience in creating Detail Reports using Hyper Links.
  • Developed Reports and Customizing reports using Alerts, Breaks, and Filters and Sorts, Hyper Links.
  • Created Webi-Reports using BICS Connection and Universes using two data sources.
  • Experienced in creating reports using Web Intelligence, schedule the reports as per the business needs and supporting.
  • Experienced in Creating Crystal Reports XI/XIR2/2008/2011 and implemented Charts with Value-based alerts and setting up Drill down in charts using Crystal Xcelsius.
  • Good experience in developing Reports for the different data sources like Oracle, SQL Server.
  • Very good experience of working in Onsite-offshore delivery model.
  • Participated in SEI-CMM V, ISO 9000 quality processes and in the full software development life cycles to provide quality assurance and project risk mitigation planning for projects.
  • Excellent team player with good communication, analytical, problem solving skills, zeal to learn new technologies and can work independently.
  • Leadership abilities: can build, supervise and motivate a productive team.
  • The ability to cope up with a fast and difficult learning curve. Good prioritizing skills
 
Technical Skills:
 
Data Ware-housing ToolsBusiness objects XI, /XIR2/XI R3.1/4.0, Web Intelligence Reports, Universe Designer/IDT, Analysis for EXEL, Query Designer, Crystal Reports XI/XIR2/2008/2011 and Xcelsius/Dashboards, QAAWS,Design Studio, Launchpad,Lumira.
Operating SystemsWindows , UNIX
 
Databases/
Database tools
Oracle 11g/10g/9i/8i, SQL server 2005/2008, IDE Toad, PL/SQL Developer, SQL Developer, SQL*Plus                                                             
Automation Testing ToolsQuick Test Professional, Load Runner, Test Director/Quality Centre and Rational Clear Quest
 
Programming LanguagesSQL, C, C#, VB Script, Java
Reporting ToolsTest Director/Quality Center, ALM, Bugzilla, Jira
Web TechnologiesHTML, XML, VB .NET
Documentation ToolsMS-Office, MS-Visio, MS Project, PowerPoint
Education:
           
  • Masters in Computer Science from Osmania University, India
Non-Technical Skill Set
 
  • Good Communication Skills
  • Project management
  • Quality Management and SCM Activities
                                                                                                                                                              
PROFFESSIONAL EXPERIENCE
 
1.       U.S. Food Service, Rosemont, IL                                                                                         Oct 2014 to Till date
                    
       Description:
U.S. Foodservice is one of the United States Largest Broad-line foodservice distributors of national, private label, and signature brand items. As a Sr. Developer for the past 5 years I involved in developing reports for Area Managers, District Managers using the BO, which was rolled out 3years ago at US Foodservice. We were using Business Objects.
 
   Responsibilities:
  • Involved in Creating and maintaining Universes by using Universe Designer.
  • Created Classes and Objects in Universes, According to Functional specifications.
  • Created reports by taking data from different data source.
  • Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
  • Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
  • Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
  • Created Analysis Reports for finance users.
  • Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
  • Created monthly and summary reports in WEBI 4.0 for the different domains like Finance, Marketing and HR domains. 
  • Created Detail Reports using Hyper Links.
  • Involved in the modifying and Building of Universes, Classes and objects.
  • Created objects and defined them accordingly into measures, dimensions and detail.
  • Used joins concept by taking different tables from different data sources in the Universe.
  • Set up Universe level conditions to restrict data based on Functional specifications.
  • Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down and Formulae’s.
  • Created a backup of WEBI Reports and Universes in BIAR format using promotion management.
  • Created Web-I reports as per the Functional specifications.
  • Used the formatting options like cross tab, sections, breaks, data sort.
  • Created reports with different charts, Prompt filters as per Functional specifications.
  • Published the reports and universes to live repository.
  • Created Report level conditions to restrict data, based on report requirements.
  • Used @select, @where, @variable, @prompt and @aggregated awareness functions in universe development.
  • Implemented Row & Object level security for different user groups as per the Functional Specifications.
  • Created various dashboards using Crystal reports, XCelsius.
 
               Environment: Business Objects XIR2/4.0, Business Objects Info view (Webi), Crystal Reports XI, Xcelsius,
   SQL server, Oracle, Toad, Windows.
 
  1.  
2.Walgreens, Deerfield, IL                                                                                                  Jul 2012 to Oct 2014                                                                                                                           
       Description:
Worked on Pharmacy project which enabled Walgreens to provide the resources and support that can help patients achieve the best results from their prescribed therapy. The main aim of Specialty
Pharmacy is to offer a free Health Management Program for people living with HIV/AIDS, hepatitis, multiple sclerosis, cystic fibrosis, and growth hormone deficiency. The data comes from different operational sources and stored in a data mart and then data is transformed and loaded into a centralized data warehouse for various strategic business reports. The objective is to automate the entire data load on a schedule basis and generate reports for the management to take better corporate decisions.
 
     Responsibilities:
  • Used Import Wizard Tool to Designed and developed Universes using Business Objects Universe Designer.
  • Designed and created WEBI reports using Web Intelligence Rich Client and InfoView.
  • Created reports involving table/section breaks, multiple data providers and derived tables.
  • Coordinated with offshore team for report deliveries.
  • Converted about 120 DESKI reports to WEBI using BO Conversion tool. These processes also involved analyzing the SQLs more closely and modify the prompts and objects in WEBI reports.
  • Create BIAR files and assisted CM team to deploy them onto Integration environment.
  • Used Rational Clear case for version control of report (. wid) and BIAR files. 
  • Work with SAP support to resolve any BO related tickets/issues. Modify/Create new BO Deski/Webi reports and Universes.
  • Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis. 
  • Implemented security features of Business Objects like row level, object level and report level to make the data secure.
  • Used multiple data providers such as Universe and personal data files in generating report.
  • Responsible for developing all types of reports including Cross-tab. 
  • Created BIAR files for Rapid deployment between environments, and for easier application maintenance.
 
               Environment: Business Objects XIR2, Business Objects Info view (Webi), Crystal reports XI, Xcelsius,
                         SQL server, Oracle, Toad, Windows.
 
3.       AON, ROLLING MEADOWS,IL                                                                                      Jul 2010  to  Jul 2012
             Description:
AON / ASA is a division of AON Corp catering to the Employee benefit Services for AT&T, Lucent
Technologies, WR Grace, Tyco and a few other companies. Business Objects has been deployed in Oracle and SQL Server environment to develop canned and ad-hoc reports for determining and monitoring the processing of employee benefits and operational efficiency evaluation.
 
Responsibilities:
  • Managed existing Universes, created Classes, Objects and applied Hierarchies based on Business logic.
  •  Created reports using multiple data providers such as Universes and personal data files in generating reports.
  • Customized the reports as per the business requirements.
  • Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
  • Created complex reports using reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formula.
  • Created dashboards for Operations and Sales, Actual Sales and Projected Sales, National and International Territories Sales using Xcelsius 2008, Web services, XML, QaaWS and Excel data.
  • Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports.
  • Created objects and defined them accordingly into measures, dimensions and detail.
  • Used joins concept by taking different tables from different data sources in the Universe.
  • Set up Universe level conditions to restrict data based on Functional specifications.
  • Involved in creating Aliases and contexts in Universe Designer.
  • Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down and Formulae’s.
  • Created a backup of WEBI Reports and Universes in BIAR format using Import Wizard.
        Environment: Business Objects XIR2, Business Objects Info view(Webi), Crystal reports XI, Xcelsius,
                                  SQL server, Oracle, Toad, Windows.
 
 
 
 
 
4.       Prudential Bank, NY USA                                                                                                         Dec 2008   to  JUL 2010
       Description:
Exult Inc is a Human Resources outsourcing company providing HR services to enhance human capital. The scope of the project includes maintaining Exult Inc’s internal applications covering the Employees Self-service and Financial services testing.
 Responsibilities:
 
  • Performed Functional System testing, Regression testing, Data Integrity testing and GUI testing.
  • Preparation of Requirement Traceability Matrix, daily status and defect reports. 
  • Create Feature Test Plans, test cases, execution of test cases, defect reporting using Test Directors. 
  • Understood, supported, and enforced the Standard Test Process (following SDLC, CMMi) and helped ensure that other testers understood and used the Standard Test processes so they were consistent with the goals and needs
  • Assisted individual contributors in resolving immediate. Ensured that the results were reported correctly to deliver the value expected via appropriate metrics.
  • Trained and mentored testers on all facets of the SDLC as well as testing and testing tools. Estimated time and testing resources necessary to support/produce successful end-results of software development efforts.
  •  Worked on multiple projects concurrently, producing results and keeping testing within the project schedules and scope.
  •  Peer reviewed and edited many documents/test plans/test cases for teammates and management.
  • Actively involved in the creation of the Design Structure Matrix and Orthogonal Array to identify end-to-end scenarios.
  • Participated in Functional Specification enhancements
  • Developed and Reviewed test pack/cases
  • Performed Functional Testing, Regression Testing and Integration Testing
  • Developing and maintaining test methodology
  • Application Tested using QTP and Manually.
  • Defining test strategies for projects. Coordinating the work of test teams and monitoring their performance.
  • Managing the gathering of results. Compiling test metrics for management
  • Recording and execution of test scripts using QTP
  • Creating the Bug Reports and  Analyzing Test Results
  • Identify test approaches that optimize the delivery schedule.
  • Build Acceptance Testing for various releases.
Environment  : QTP, Manual Test Director, Load Runner , Oracle 8i,Windows NT
 
 
  1.  
  2.  
  1.  
  2.  
  3.  
  4.  
5.       Liberty Mutual, NY USA                                                                                                             Jun 2007 to Dec 2008
Description:
Liberty mutual specializes in offering insurance service for vast customer base. Scope of the Project includes managing insurance service (auto and health) , maintaining call center services and enhancing the internal portal web applications.
 
Responsibilities:    
 
  • Designed and Executed Test Cases.
  • Managing all phases of testing for assigned components ensuring test plans and test cases are completed and met business requirements.
  • Involved in Regression, Functional Testing.
  • Participated in regular project status meetings related to testing.
  • Analyzed Test Results/Reports.
  • Performed various types of testing, such as Functional, GUI, System, Regression and User acceptance testing.
  • Extensive interaction with Development Team and Doctors Team
  • Worked with business analysts to resolve issues
  • Consulted development staff with regards to investigating and correcting
  • Preparation of Requirement Traceability Matrix, daily status and defect reports. 
  • Software bugs and deficiencies based on testing results.
  • Participated in the testing of the health care solution software
  • Performed various types of testing, such as Functional, GUI, System, Regression and User acceptance testing.
  • Record and document test results.
Environment   : Manual, Test Director, Load Runner ,VB.NET, SQL Server2000
 
  1.  
  2.  
  3.  
6.        Patient Point (Hospital Management System) , NY USA                                            Sep 2006 to Jun 2007
   Description:
 The software developed for Gastroenterology Associates, Poughkeepsie NY is a complete Doctor¡¦s Office Management Suite that includes Doctor¡¦s Appointment Scheduling, Electronic Patient Record, Billing and   processing Insurance Claims. . It will automate the Gastroenterology Associates office with efficient record keeping, retrieval and management of the data.
 
Responsibilities: 
                                                                                          
  • Designed and Executed Test Cases.
  • Managing all phases of testing for assigned components ensuring test plans and test cases are completed and met business requirements.
  • Involved in Regression, Functional Testing.
  • Participated in regular project status meetings related to testing.
  • Analyzed Test Results/Reports.
  • Performed various types of testing, such as Functional, GUI, System, Regression and User acceptance testing.
  • Extensive interaction with Development Team and Doctors Team
  • Worked with business analysts to resolve issues
  • Consulted development staff with regards to investigating and correcting
  • Preparation of Requirement Traceability Matrix, daily status and defect reports. 
  • Software bugs and deficiencies based on testing results.
  • Participated in the testing of the health care solution software
  • Performed various types of testing, such as Functional, GUI, System, Regression and User acceptance testing.
  • Record and document test results.
Environment   : Manual Testing, V.B 6.0, Test Director, oracle 8i  
                 
7.       Clinical Management Client , DE USA                                                                                              June 2005 to Sep 2006
Description:
Clinical Management System that is used by physicians and healthcare providers in doctor's offices and hospitals to manage and automate the interaction between a patient and physician. It has the functionality to record patient encounter information generate reports (consultation report, physician order report, well child report, etc.) and interface with coding and billing software.
Responsibilities:                                                                                                          
 
  • Designed and executed test cases for Responsible modules to test the complete functionality of application manually.
  • Analyzed Test Results and generated bug report to management.
  • Involved in functional, User Interface Testing, Retesting/Regression testing.
  • Attended weekly status meetings and provide detailed status report
  • Interact with development, product management, project management and test lead to gain a strong understanding of the project and testing objectives
  • Participated in troubleshooting and triaging of issues towards root cause identification and resolution.
  • Document, track and escalate issues using HP Quality
  • Define a standard process for: testing metrics collection and reporting; defect management process.
  • Work with Business Analyst and Developer to resolve the defect
  • Analyzes and reports overall test status and results of test case execution
  • Review test results, applies analytical skills to identify when issues need to be escalated and identifies associated risk and/or impact
  • Worked on Analysis tool to capture the Response Times, Passed/Failed Transactions, Errors after each
  • Load Test and Documented the Load Test Performance Reports.
  • Involved in Resolving performance issues.
Environment  : Manual Testing  ,VB6.0 and Oracle 8i