SUMMARY

• Around 7 years of experience in Information Technology with expertise in Implementation, Maintenance, support of Data warehouses and Business Intelligence applications.
• Proficient in writing SQL queries to perform data driven tests and involved in front - end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in Oracle databases to conduct DB testing.
• 5+ years of strong IT professional experience in OLAP Data Warehousing and Business Intelligence tools including SAP Business Objects XI 4.0/3.1/3.0/R2, Universe Design Tool, Designer, Crystal Reports 2011/2008, Dashboards 4.0,Xcelsius 2008/4.5, Launch Pad/ Infoview Desktop Intelligence and Web Intelligence.
• 3 years experience with Dimensional Data Modeling, Star Schema, Snow-Flake, FACT and Dimension Tables, (Ralph Kimball methodologies) Physical and Logical Data Modeling.
• Worked on Data files & label parameter of data file, strong in writing UNIX Korn shell scripting.
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and assisting in developing TEST PLAN.
• Expertise in creating/developing TEST CASES and developing TEST SCRIPTS.
• Experience in working as a liaison between the team members and the manager.
• IT industry experience in Banking, Financial, Self-Service Software Services industries with strong Business and Functional knowledge and Ability to evaluate ETL/BI specification, verify it with systems and Experienced with Master Data Management (MDM).
• Excellent data-analysis skills and ability to translate specifications into a working universe and/or report.
• Expertise in Designing and Developing Complex Reports. (Canned/Ad-hoc).
• Extensively used slice and dice for generating master/detail and tabular reports.
• Handled Embedded Functions like @Prompt, @Select, and @Where, @Aggregate awareness in the designer to handle User requests for report generators.
• Solid Hands-on experience in Performance Tuning Reports and SQLs. Identify and resolve performance bottlenecks at all levels of the applications.
• Involved in Full life cycle (analysis, design, networking, development and deployment) of Business Objects reporting Applications with Web Intelligence and Broadcast Agent
• Expertise in writing SQL queries, PL/SQL Stored Procedures and Triggers.
• Expertise in developing test cases/ test scripts for Inbound and Outbound ETL processes.
• Strong knowledge of working with Data Marts (Star Schema and Snowflake Schema).
• Interacted with Business partners to identify information needs and business requirements.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS

ETL Tools: Informatica 8.5/7.1, Data Stage 7.5, Quality Stage 7.1, SSIS

Reporting Tools: SAP Business Objects XI 4.0/3.1/3.0/R2, Web I, Launch Pad/Info View, Cognos 8.x series, Crystal Reports 2011/2008/XI, Dashboards 4.0/Xcelsius 2008/4.5, Live Office

Test Management: MS Project Test Scheduling, Test Director, Quality Center, Rational Quality Manager,Keyword Driven and Data Driven testing, Top to Bottom and Bottom to Top test methodology, Requirement based, Risk based, Priority based test methodology

Bug Reporting: Rational Clear Quest, Test Director, HP Quality Center, Remedy Tool, MS Access, Bugzilla, Siebel Service Request

Scripting languages: TSL, SQA basic, Java script, VB Script, VBA, Shell Scripting, XSLT, PERL, HTML

Programming Languages: C, C++, Java, Visual Basic

Databases: Teradata 12/V2R6, Oracle 11g/10g/9i/8i/7.3, IBM DB2, MS SQL Server 2008/2005/2000 , Sybase12.0/11.0, MS Access

Operating Systems: Windows XP/NT/2000, DOS, Mac 10.4, AIX UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

Sr. Data Analyst/BI developer

Responsibilities:

• Involved in gathering the requirements for reporting from the end users.
• Responsible for data analysis of the source systems, ensuring the data quality and meeting the customer expectations for smooth data transition.
• Interacted with the SMEs to identify data discrepancies and handling root-cause analysis.
• Translated business/functional requirements in to technical/data element requirements.
• Worked with multiple departments/Business Units (platform/ architects) to ensure universe designs meet short and long term/future business requirements.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
• Created Universes and resolved loops and join problems by creating Aliases and Contexts.
• Created Full Client Reports making use of Business Objects functionalities, like Multiple Data Providers, Prompts, Slice and Dice, Drill Down/Up/Through, and @Functions.
• Extensively used Input Controls function and Outline feature for complex reports.
• Extensively used Hyperlink functionality to Link the summary and detail reports.
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of SAP Business Objects XI 4.0/3.1.
• Tested several business reports developed using Business Objects including dashboard, drill-down,
• Summarized, master-detail & Pivot reports.
• Demonstrated the features of the WEB Intelligence tool and info view to the users for the best requirements gathering process.
• Created interactive Dashboards, models and Business Presentations for Executives by importing data from Excel spreadsheets using Xcelsius.
• Created complex Crystal reports containing Sub reports, Parameters, Record selection formulas, Custom Functions, and SQL Expressions.
• Involved in Unit testing, system integration testing and user accepting testing for data validation for canned reports.
• Proactively interacted with the platform team to migrate the Universes and reports across various environments.
• Validated the metrics in the Universe in accordance with the report requirement document.
• Managed and executed the BI development, using Agile Methodology.

Environment: SAP Business Objects XI 4.0/3.1/3.0, Dashboards 4.0/Xcelsuis 2008, Crystal Report 2011/2008, UTD, Designer, Web Intelligence, Launch Pad/Infoview XI, Oracle 11G, SQL Server 2008, IBM DB2, ETL Informatica 8.5, SQL, PL/SQL, Windows XP, QTP 9.5, TOAD, Quality Center 9.2, UNIX.

Confidential, Duluth, Georgia

Sr. Data Analyst/ BI Developer

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked with the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Involved in collecting Business Intelligence reporting data from managers, staff across divisions and across geographies.
• Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, BTEQ AND TPUMP.
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Created Universes for Sales Data analysis and Inventory Data analysis based on Master Child approach.
• Created various reports like the Combined Queries, Drill Down, Cross Tab, Master Detail to make the reports easier for analysis.
• Defined custom hierarchies for implementing drill down, drill up capabilities in Business Objects.
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes.
• Created interactive Dashboards and Business Presentations by importing data fromExcel sheetsusing Crystal Xcelsius.
• Extensive experience in different Modules of Business Objects like Desktop Intelligence, Web Intelligence, Infoview, Designer, Supervisor/CMC.
• Tested reports developed by Universes for both Adhoc & Canned Reporting users of BOE XI R3.1 - Deski & WebI.
• Incorporated Xcelsius and created dashboards and scorecards.
• Written complex SQL queries for data validation and data verification.
• Performed functional and Regression testing by QTP and managed the defects by Quality Center.
• Conducted performance and load testing using Load Runner.
• Analyzed, reported and kept track of defects using Test Director.
• Provided testing results and weekly status report to the QA lead, provided test summary report once project was fully completed.

Environment: ETL Informatica 8.5, SAP Business Objects XI 3.0/R2, Web Intelligence, Desktop Intelligence, Info View, Xcelsius 2008, SQL Server 2008, IBM DB2, PL/SQL, Teradata SQL Assistant 6.0,Windows XP, QTP 9.5, Quality Center 9.2, UNIX.

Confidential, Cleveland, OH

Data Analyst/ BO Developer

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked with the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Tested the ETL business logic for different feeds and checking the log files for data counts.
• Worked with Quality Center for executing test cases and reporting defects.
• Analyzed test results, generate test reports, file bugs and follow up on resolution with development & support team.
• Data Integration testing for products, Reference Data and Customer master data management (MDM)
• Prepared the Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.
• Created universes and Business Objects reports for business analysis.
• Worked on the design and creation of a robust universe, Objects, Classes, Joins and Contexts.
• Resolved loops, fan traps, chasm traps by creating aliases and contexts.
• Created complex reports using cascading prompts, decode objects using both full client and thin client reporter.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc.
• Used Schedule manage to schedule reports on timely basis.
• Created and modified custom based dashboards as per the Business Users needs. These dashboards were built using Crystal Xcelsius.
• Generated various reports to track the Deposits for various products and also to analyze the newly open, closed and migrated accounts.
• Written complex SQL queries for data validation and data verification.
• Executes the test suite to identify regressions and unexpected side effects.
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Analyzed, reported and kept track of defects using Test Director.

Environment: Informatica 7.1, SAP Business Objects XI R2, WebI, Broadcast Agent, Crystal Xcelsius 4.5, Infoview, SQL, PL/SQL, IBM DB2, Manual Testing, Test Director, Load Runner.

Confidential, Boston, MA

BO Developer

Responsibilities:

• Involved in gathering Business requirements, documenting functional requirements and converting them to Technical Specifications.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Created, Managed, tested and tuned the Semantic layer (Universes) according to the end user requirements.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity of the Business Objects Semantic Layer.
• Created custom LOV’s and Custom Hierarchies which help the end users to drill down to lower levels.
• Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Created ALL and cascading prompts which help the Business users to narrow the selection criteria.
• Linked the Universes to share the common components in the semantic layer.
• Involved in scheduling of documents monthly, weekly and daily through Broadcast agent.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula’s etc.
• Created Cross tab reports and Adhoc reports and implemented the drill down function to analyze the data in their business.
• Exporting the Reports to the Broadcast Agent Server, and used the Broadcast Agent to Schedule and Monitor the Reports.
• Migrating Reports from to 6.x to XI R2full client, thin client/ZABO.
• Interacted with Customers and Associated Organizations, documented for UAT.
• Experience with User Acceptance Testing (UAT) & release skill sets.

Environment: Business objects XIR2/6.5.1, Designer, Deski, Info View, WebI, Oracle 10g/9i, SQL Server 2000, Teradata V2R4, Teradata SQL Assistant, Windows XP/2003/2000 and UNIX

Confidential

Data Analyst

Responsibilities:

• Understanding of complex financial business requirements.
• Writing test plans and test scripts.
• Maintained Progress Report of team members for update on individual work during test execution cycle.
• Written complex SQL queries.
• Performed testing in mainframe environment.
• High Level Test Case Design and writing detailed test cases.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Reported periodic project status and updates to the QA Lead and QA Manager.
• Heavily involved in interacting with UNIX Shell scripts.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases.
• Exporting test cases to Test Director.
• Preparation of Data Requirements.
• Data mapping (one-to-one mappings).
• Accessing mainframes and validating the data.
• Identify & record defects with required information for issue to be reproduced by other teams.
• Worked with high-volume, real-time DB2 database applications and systems.
• Conducted Bug Review meetings for update on defects from development team & retesting of bug fix.
• Worked with developers to fix faults found in the structure and functionality of the application.
• Experienced in co-coordinating resources within Onsite-Offshore model.
• Conducted Training Sessions and Knowledge Transfer Sessions on new applications.
• Managing testing documents in Test Director.

Environment: Windows, SQL, PL/SQL, Mainframes, MVS, COBOL II, VSAM Files, JCL, .Net, DB2, ASP.Net, Test Director