SUMMARY:

• Result oriented and highly motivated IT professional with 8+ years of experience in all phases of Software development life cycle including application maintenance and project management.
• Self - starter with excellent communication skills, technical acumen and great learning agility.
• Relational Databases
• SQL
• SAP: BI/BW, BO
• Testing and Quality Assurance
• QA &QC standards
• Waterfall and Agile methodologies
• Test methodologies: System, Integration, User Acceptance
• Analytical & problem solving
• Report development and testing
• Strong documentation skills
• Business Process Mapping
• Gap Analysis & Data Mapping
• Team oriented Player
• Requirements Gathering
• Strong communication skills

TECHNICAL SKILLS:

Tools: BOXI R3/R4 SAP BW3.5, BI 7.0 SQL Server 2005/2008 Oracle 11g Sybase Central 15 Informatica Power Center 7.x Cognos TOAD for Oracle, SQL Server Management Studio WEBI, Crystal Reports Putty HP ALM, QC, QTP/UFT Clear Case & Clear Quest MS Project, SharePoint MS Office suite MS Visio, MS Access JIRA IBM Rational DOORS Windows OS

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements.
• Developed and pruned the artifact repository and templates to conform the RUP standards.
• Extracted the Business Requirements during various sessions with business leads and entered all requirements in Requisite Pro, tracing them all the way to the stakeholder requirements.
• Created Business Process Flows across the capability.
• Decomposed high-level requirements into a detail functional design specification.
• Instrumental in writing the business and system Vision documents, business and System Use Cases, Supplementary Specifications and extracting Stakeholder requirements.
• Conducted JAD sessions with extensive involvement from business, development, testing teams, architects, SME’s (Subject Matter Experts) of various business units.
• Conducted project related presentations and provided reports to the higher management.
• Involved in Defect Management process.
• Recognized for excellent ability to multi-task on projects consisting of diverse set of people, platforms and parallel timelines via exceptional communication, organizational and interpersonal skills.

Confidential, Herndon, VA

UAT Test Analyst/ ETL Tester

Environment: BOXI R4, Oracle, HP Quality Center

Responsibilities:

• Prepare the Test plan, with detailed testing scope, strategy, test requirements and resource planning.
• Performed manual testing to check on major functionality of AUT (Application Under testing).
• Performed Functionality testing, Integration, Regression testing and UI testing.
• Involved in testing of checkout security, cross browser testing and link testing.
• Performed back-end testing procedures using SQL statements to verify data in the reports.
• Tested 8 new reports, 40+ reports with enhancements and nearly 100 reports for schedule changes.
• Tested reports from various applications like Asset servicing, Admin Bond and SIR.
• Tested the schedules, Attributes and functionality of all the reports.
• Managed all phases of the software testing process, like, executing tests and tracking defects.
• Worked closely with Business Users in testing the application.
• Organized meetings with the development team to work with, and help them in resolving issues.

Confidential

UAT Test Analyst

Environment: SQL Loader, BOXI R4, QTP, Oracle, UNIX

Responsibilities:

• Worked closely with all team members (Developers, Test Lead, Business Analysts, End Users)
• Prepared Test environment and Identified/Prepared Test data for every code drop before testing begins.
• Developed several Test Cases, Test scenarios for Data Validation and Report testing.
• Performed Data Analysis to understand requirements and business flow.
• Focused on Data Quality issues, Transformation Rules, problems, Incremental data loads that include completeness, conformity, consistency, accuracy, duplicates and integrity.
• Extensively used SQL queries for Database testing and Validation.
• Wrote complex SQL queries for extracting data from multiple tables and implementing business rules.
• Reported defects to the developer and maintained in IBM Clear Quest.
• Developed regression test scripts for the application that are automated.
• Tested the data and data integrity among various sources and targets.
• Extensively used MS OFFICE Suite for documentation purposes like preparing test plan, test summary document and test results.
• Reported Test summary results to the management team.
• Prepared traceability matrix for requirements from the completed test cases.
• Clearly communicated and documented test results and defect resolution during all phases of testing.

Confidential

UAT Test Analyst

Environment: Informatica, Oracle, Sybase, Putty, HP Quality Center

Responsibilities:

• Involved in full SDLC/STLC steps like requirements, design, implementation, testing and documentation.
• Worked closely with all the team (developers, test manager, business analysts, and end users) by having daily status calls.
• Developed ETL and Reporting Test Plan and Test Strategies.
• Prepared Test environment and Identified/Prepared Test data before starting testing.
• Developed several Test Cases and Test scenarios for ETL Data Validation and Report testing.
• Worked as ETL Tester responsible for the requirements/ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Performed Data Analysis to understand requirements and business flow.
• Prepared test queries and extensively used them for Database testing and Validation.
• Experienced in writing complex SQL queries for extracting data from multiple tables and implementing business transformation rules.
• Reported bugs to the developer and maintained the log in Quality center.
• Tested the data and data integrity among various sources and targets.
• Tested the Reports and validated the data on the Reports.
• Written several complex SQL queries for validating Reports.

Confidential

BOXI Report Test Analyst

Environment: BOXI, Oracle, ALM

Responsibilities:

• Provided Level of estimates on the testing for the number of reports that were being migrated.
• Worked with the Technical Lead on establishing processes for report testing and validation.
• Worked on Migration of reports (WEBI, Crystal and XCelsius) from versions BOXI R3 and BO 4.0 Unit tested the reports for compatibility and fixed the issues that occurred during migration.
• Worked with migration project team (PM, Business Objects Admin and Developers) to fix issues.
• Performed testing on the migrated reports from BOXI R3 to BO 4.0.
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Performed Unit Testing, Integration Testing, User Acceptance Testing and Requirement Testing.
• Executed Test Cases with respect to Source and Target database tables.
• Written SQL queries to validate reports against the database.
• Validated reports based on Functional Requirements.
• Extensively tested several BO reports for data quality, fonts, headers and footers.

Confidential, Houston, TX

Report Analyst

Environment: BOXI, Oracle, QTP, ALM

Responsibilities:

• Worked closely with Functional and Business Analysts to understand and define Technical Requirements.
• Utilized graphical interfaces such as Bar chart, Pie chart, Gauge Chart, Column chart, Ticker, Trend chart.
• Involved in designing Business Objects Classes, Objects, in the Universe designer.
• Developed Ad- hoc reports in Web- Intelligence.
• Developed vertical, horizontal, Cross-tab, Drill-down Reports using formulae, filters, prompts and alerts.
• Experienced in using sorting, grouping and Ranking in Report level.
• Created Xcelsius dashboards to connect to BEX Queries and used live office and QAAWS as a middleware between Xcelsius and BO Universe.
• Experienced in creating Xcelsius Dashboards from Microsoft Excel as a data source.
• Developed/modified and scheduled reports as per the Business requirement and Change Request.
• Analyzed and corrected production problems as they occur in the SAP BW system and BO reports.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Involved in enhancements of Data Sources with the help of ABAP developer.
• Resolved many issues by performing root cause analysis.
• Led Weekly, Daily team meetings with developers and communicated project status to the client.

Confidential

SAP Consultant (Implementation)

Environment: BW/BI, Oracle (Migration/Maintenance Project)

Responsibilities:

• Worked hand-in-hand with Upgrade team (from SAP BO XI to SAP BO 4.0) on validations with earlier version.
• Exported the Universes to the Repository to make resources available to the users.
• Created reports based on requirements using the Universes on top of BEx queries as the main data providers.
• Maintain and migrate Business Objects Universes and reports using IMPORT Wizard.
• Creation and maintenance of users and groups for use within multiple Global projects for both application and data level security using the AD Groups.
• Worked on Input controls, Conditional formatting, Open Document URL’s etc. in BO 4.
• Developed variety of Reports using OLAP Analysis Edition in BI, and BO 4 WebI reports using BEx Queries
• Performed Comparison analysis of B04 WebI report data with Bex Query Analyzer report.
• Created Test Scripts and BEX Master Queries on top of Multi-providers, restricted Key figure, structures etc.
• Analyzed BEx queries and gathered user requirements for the reporting work.
• Interacted closely with the Business, Analysts and Functional people to do requirements gathering and Impact Analysis.

Confidential

SAP Consultant (Implementation)

Environment: SAP BW/BI, Oracle

Responsibilities:

• Created and maintained Transfer Structures, Communication Structures, Transfer Rules and Update Rules for Info Sources, ODS objects and Info Cubes.
• Created and maintained Aggregates and Rollup activities as a part of the Info cube Management.
• Implemented several Process Chains for automated data upload.
• Performed LO-Extraction for loading data from SAP R/3 to SAP BW.
• Set up procedures for extracting data from SAP R/3 by using Generic Extraction and Customizing LO Cockpit.
• Designed, developed and scheduled process chains for master and transaction data loads using Info Packages.
• Developed queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables etc. for customized reporting using BEX Analyzer, Designed. Developed several workbooks and global views.
• Installing business content in BW and R/3, activated data sources in R/3 for Transaction and Master Data.
• Enhanced data source structures and implemented User Exits according to user requirements.
• Sourced HR data like Personnel and Time Management and Financial data (Payroll) into the Infocube.
• Configured the Enterprise Structure and Employee Structure as per client requirements as part of sourcing Personnel Administration data.
• Worked with Client Payroll Schema and its related sub schemas, as part of sourcing Payroll data.
• Integrated several modules from the HRIS data into Infocubes.
• Maintained both the Master data and Transaction data in the Infocube created for HR.
• Created and maintained Employee Hierarchy Reports, Employee Performance Reports using BEX Analyzer.
• Developed variety of reports like Employee Joining Report, Working Hours report, Payroll reports.
• Utilized Restricted Characteristics functionality to limit selection on certain details in reports, like Payroll.
• Generated Payroll periods and Cumulative Periods and Absentee Quotas through Reports (RPTQTA00).

SAP Consultant (Prod Support)

Confidential

Environment: SAP BW, Oracle

Responsibilities:

• Monitoring and scheduling of Process chains.
• Analyzing and resolving the errors occurred while uploading the data. Worked with other teams in error resolution.
• Scheduling, Monitoring and Troubleshooting BW Data extraction/loading.
• Loading master data and transaction data into SAP BI system.
• Roll up data from info cubes to aggregates.
• Working on Process chain and subsequent processes.
• Refreshed Info Cubes and reloading the data from the DSO when the daily deltas are scheduled
• Finding the root cause for the Errors of the chains if they have not started in time.
• Raising tickets to other resolution groups regarding performance of the system and data loads.