• Over 8 years of IT experience in Data warehousing and all aspects of Systems Development using Client/Server technologies that includes Requirements gathering, Analysis, Design and Development.
• Experience in testing Business Report developed in Business Objects XIR2 Cognos 8 series.
• Experienced in writing Excel Macros Pivot Tables.
• Experienced in Writing UNIX Korn Shell Scripting for job scheduling and sequencing.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Expert in PERL, UNIX Shell Scripting
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Worked on different versions of Business Objects 4.1/5.1.5 /6.0 /6.1b /6.5/XI R1/XI R2
• Having 6 yrs of experience in Business Objects XI R2, 6.X and 5.X including Central Management Console, Central Configuration Manager, Desktop Intelligence, Import Wizard, WebI XIR2, Application Foundation/Performance Manager Dashboards , Supervisor, Designer, Reporter, Web Intelligence, Info View, ZABO, Broadcast Agent Publisher.
• Experience in designing and building the Universe business view of the database , and updating the existing Universes, developing canned/ad-hoc reports, scheduling the processes using Broadcast Agent and administering the BO activities.
• Certified Software Tester from ISTQB International Software Testing Qualification Board .
• Extensive experience in different Modules of Business Objects like Desktop Intelligence, Web Intelligence, Infoview, Designer, Supervisor/CMC.
• Sound understanding of Dimensional Modeling, designing Star and Snowflake Schemas.
• Performed Pre Migration Assessment, Migration Post Migration.
• Identifying Reports Complexity, Implemented Row level/Column Level/Report Level Security.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL.
• Proficient in SQL and PL/SQL coding.
• Excellent Communication skills.
• BI Tools: Business Objects XIR2/6.5.1/6.0/5.1.x/4.0 Supervisor, Designer, Reporter , Web Intelligence, ZABO, InfoView, 3 Tier Business Objects, BCA, BO XI R2 CMS, CMC, Designer, Deski, Web Intelligence , Performance Manager EPM , Import wizard, Report Conversion Tool, Crystal Reports, Business Views, Cognos ReportNet Frame work manager, Reports Studio, Query Studio , Crystal Xcelsius
• ETL Tools: Informatica 7.1.2/6.1.X Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• RDBMS: Oracle 10g/9i/8i, Informix, DB2 UDB 8.0, MS Access 2000, MS SQL Server 7.0/2000, Sybase 12.0, TOAD 7.6
• Design Tools: ERWin 4.X, UML 2.0
• Web/Application Servers: Apache Tomcat, JBoss, Weblogic, WehSphere.
• Testing Tools QTP 9.2, WinRunner 8x, Test Director,
• O/S: Windows NT/XP Prof/2003 Server/2000/98/95, UNIX, Solaris 9 , Linux SuSe 9.0, RedHat 7.0/8.0/9.1
• Languages: Java, Servlets, JSP, J2ee, C, C , COBOL, VB, SQL, PL/SQL, HTML, DHTML, XML, XSLT
• Others: MS Office-2003, MS Project.

Confidential

Sr. BI/ETL/SQL Test Analyst

Confidential has implemented the Credit Risk Data Warehouse CRDW and enabling applications to satisfy the Federal Reserve's mandate that BOFA comply with the terms of the Basel II accord for measuring credit risk, calculating regulatory capital, publicly disclosing the centrally aggregated credit risk information, and reconciling the warehouse's information with BOFA general ledger. The CRDW processes daily credit risk information from all the Bank systems and resides in the IBM hosted data center in New Jersey

Responsibilities:

• Mapping the database fields after developing the reports or after adjusting report as per the client requirement.
• Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
• Worked on issues with migration from development to testing.
• Testing the reports and maintenance of daily, monthly and yearly.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Tested and maintained the universe and reports
• Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ TPUMP
• Using Import Wizard deploying the reports from Dev system to QA box.
• Used Sets, Metrics, Productive Analysis and Enterprise Performance Management Scorecard and Dashboard .
• Tested several packages developed using SSIS.
• Written several test cases for SSIS Packages and for data flow.
• Tested stored procedures.
• Tested reports in Web Intelligence XIR2
• Security implementation for both Webi and EPM.
• Involved in Unit testing and UAT.
• Tested complex objects to the universe to enhance the report functionality.
• Optimized the usage of user objects, conditions and universe level filters
• Involved in documenting the changes to the universe and reports functionality.
• Performed data validation by writing SQL queries and creating ad hoc reports using desktop intelligence and web intelligence
• Involved in fixing the defects and data validation of reports for Partially Converted and Fully Converted Reports.
• Involved in automation of test cases using QTP.
• Did functional testing using QTP
• Used QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple applications.
• Worked with QTP for Regression Testing
• Used Quality Center 8.2 for writing Test Plan, Test Cases development, test script writing, Test case execution Defect Tracking
• Extracted certain column of data from a number to files using PERL.
• Worked with PERL control structures Regular Expressions for substitutions based on matches.
• Tuned ETL jobs/procedures/scripts, T-SQL queries, PL/SQL procedures to improve the system performance
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Evaluation of critical problems/issues during testing and reporting them in Quality Center.

Environment: SQL SERVER 2005, SSIS, T-SQL, Business Objects Enterprise XI R2, Business Objects Designer, Web intelligence XIR2, PERL, UNIX Shell Scripting, Teradata V2R6 Multi-LOAD, Fast-LOAD, FAST EXPORT, TPUMP, BTEQ , Teradata SQL Assistant, Desktop Intelligence XIR2 Windows XP/2003/2000, Crystal Reports XI R2, SQL, Korn Shell Scripting, QTP9.2,PL/SQL, T-SQL, XML, XSLT, XSD, MVS, COBOL II, JCL, VSAM, Copy Books, TSO, Quality Center 8.2

Confidential

Sr. Data Warehousing Tester

Responsibilities:

• Tested various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Tested data migration to ensure that integrity of data was not compromised.
• Developed test scripts using QTP for Functionality and Regression Testing
• Involved in conversion of WinRunner scripts to QTP Quick Test Pro ..
• Tested ad hoc and canned reports for Business objects.
• Tested reports for various portfolios using universe as the main data provider.
• Tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.
• Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Tested Desktop Intelligence and Web Intelligence reports.

Environment: Oracle 9i/10g, SQL, PL/SQL, Stored Procedures, XML, XSD, Unix Shell Scripting, Teradata V2R5, SQL Assistant 6.0, QTP9.2, Business Objects 6.5, Business Objects Enterprise XI R2 Professional, Business Objects Designer, Web Intelligence, and Desktop Intelligence, Windows XP/2003

Confidential

Responsibilities:

• Tested Business Objects reports and Web Intelligence reports.
• Tested Cross-Tab reports
• Resolved major issues affecting the reporting environment.
• Provided solutions for the most complex scenarios of linking objects while testing.
• Performed data validation by creating ad hoc reports.
• Created derived tables at the universe level to reduce the complexity of universe building.
• Extensively used Informatica power center for ETL process.
• Preparation of ETL mapping specifications.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designed mappings for dimensions and facts.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings
• Development of mappings as per the technical specifications approved by the client.
• Created reusable transformations and mapplets to use in multiple mappings.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in Unit testing and integration testing of Informatica mappings.
• Implemented Error handling logic to capture the invalid data.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Tested existing Data web application from classic ASP and VB6.0 to VB.NET, ASP.NET, C .NET Framework 3.5 , SQL Server 2005.
• Figuring out various error handling strategies to be adopted during cross system data migration
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts for trend analysis .
• Tested complex reports with multiple data providers/different universes and databases Oracle, SQL server, DB2 .
• Involved in documenting the changes to the universe and reports functionality.
• Documented the deviations from the original specifications.
• Tested objects in the universe, to ensure the correct mapping of the objects.
• Tested resolved loops and contexts to ensure the correct results from the query.
• Tested the universe structure to ensure the tables are properly updated along with the database.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation

Environment: Oracle 8/9i, Informatica 7.1, HTML, .NET, ASP.NET, VB.NET, UNIX Shell Scripting, SQL, PL/SQL, Business Objects 6.1b, 6.5, BO Designer6.1b, Web intelligence 6.1b, Windows XP.

Confidential

Business Objects Developer/Tester

Responsibilities:

• Designed, developed, tested and deployed Accounts Receivable Universe
• Maintained and supported the old and the new universe.
• Developed strategy for implementing Row-level security utilizing the feature of Oracle Policies.
• Work with developers to test the fixed defects
• Performed Manual Testing of the application which involves accounting of various customer accounts using numerous test scripts
• Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
• Trained the users, developers in creating reports, universe and its deployment.
• Interacted with the end users, Project Manager and other resources in understanding the requirements and writing universe, report specifications
• Coordinated with technology group in deploying optimal solution
• Defined and created classes, objects, conditions, user and measure objects to capture complex formulae
• Managed user accounts and security using Business Objects Supervisor
• Captured the information from the financials universe and included the functionality in the new universe
• Tested the universes and reports in Business Objects 6.0
• Created variables, formulae and detail objects at report level
• Resolved the performance issues in report generation
• Tuned the universe for better performance.
• Responsible for knowledge transition, documentation of every aspect of Universe and Report creation
• Created reports using Business Objects functionalities like Slice Dice, Drill Mode, Functions, Cross Tab, Master/Detail and Formulas etc.
• Created Universes and Linking of multiple universes.

Environment: Oracle 8, Oracle Applications 10.7, Test Director 7.5, SQL, PL-SQL, Stored Procedures, Test Plan, XML, Business Objects 4.1/5.1.5/6.0, BO Designer, Supervisor, Windows citrix environment

Confidential

Application Test Engineer

Responsibilities:

• Involved in Test plan and Test case preparation.
• Prepared reusable function in QTP to use across the automation scripts
• Involved in Installation testing.
• Transformation of XML documents using XSLT.
• Transformed the XML documents into various form using XSLT.
• Identify business rules for data migration and Perform data validations.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Coordinated with Offshore team and Onsite managers
• Interacting with developers for the Bug Fixes and Problem resolution
• Involved in preparing Daily status report
• Provided weekly management status reports.
• Executed SQL Queries to check table updates and data retrieval
• Conducted Data Driven Testing using different sets of external data
• Involved in Hindi based Localization Testing.
• Reporting defects to development team through the Test Director.
• Involved in Test Summary Report preparation

Environment: Oracle 8i, QTP, Win Runner, Test Director, XML, XSLT, SQL, PL/SQL, Test Cases, Test Scripts, Test Plan, Traceability Matrix.