PROFESSIONAL SUMMARY:

• 6 plus years of experience in Information Technology with emphasis on Business Intelligence. In - depth knowledge of Business (Analysis, Processes, Models, Flow Diagrams and functionality for developing multidimensional modeling (Data Modeling). Extensive experience in Data analysis/ Testing of Data Warehouse applications and Micro strategy development and hands on experience with Desktop, Architect, Intelligence Server, OLAP provider, Data Mart and Web components. Experienced in various types of testing including Sanity Testing, Smoke Testing, Functionality Testing, Performance Testing, Volume Testing, Unit Testing, Integrated Testing, System Testing, Positive and Negative Testing, Security Testing and Regression Testing of, Web Based and Client-Server applications. Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).

TECHNICAL SKILLS:

BI Tools: MicroStrategy 10x/9x, MicroStrategy Architect, MicroStrategy Web, Visual Insight, MicroStrategy Intelligent Server, Distribution Services, MicroStrategy Narrowcast Sever, MicroStrategy OLAP Services, MicroStrategy Office

QA Tools:  Quality Center

Data Modeling: Erwin Data Modeler, MS Visio

ETL Tools: Informatica, DataStage

Databases: Oracle10g, MS SQL Server, MS Access

Environments: Windows 2008 Web Server, Windows 2012 Web Server, Windows XP,HTML, CSS, Javascript Documentation and communication skills

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida

DW QA Analyst

Responsibilities:

• Managed various testing activities throughout the Software Testing Lifecycle (STLC) for multiple projects.
• Responsible for testing all new and existing ETL Data Warehouse components.
• Attended Change Request Meetings to ensure products and changes are fully documented for further Test changes.
• Performed various types of testing such as Functional, Regression, SIT, UAT, Backend etc.
• Created Test Plans and Scenario which describes the features and functions to be tested.
• Worked with ETL development team for understating Source to Target mappings for dimensions and facts.
• Tested data movement and data validation from the various source is to dimension and fact tables.
• Tested Type I and Type II slowly changing Dimension tables.
• Performed back-end testing using SQL and PL/SQL for data validation.
• Produced various test reports such as Test Execution Status, Test Execution Summary/Progress, Defect Status, Defect Summary, and Defect Inject Rate on daily and weekly basis and submitted.
• Performed Data Validation of the data flow from the front-end to the back-end by executing SQL scripts.
• Performed Data validation of the reports generated from Micro strategy.
• Tested Drill down and drill up functionality of the reports and Dashboard.
• Created test plans, conditions, scripts, and test data; performed product testing, user acceptance, remote user testing, usability standards validation, and performance testing; and resolved system defects.
• Detected, reported and tracked defects using Quality Center.
• Conducted the defect report in Quality Center.
• Interacted with the developers to report and using Mercury Quality Center.

Confidential, New York, NY

DW QA Analyst

• Aligned system design with business requirement through appropriate documentation and requirements mapping
• Involved in the data model and technical design review meetings.
• Performed manual testing of data extraction, data transformation and data loading of ETLs.
• Tested various transformations like lookup, update strategy, router, source qualifier/Joiner on data according to the business rules and technical specifications.
• Tested complex data transformations consisting of approximately 25 transformations for each mapping.
• Written ETL test specifications including test source data preparation, writing test cases to test - Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables as per specifications
• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Involved in testing dashboard reports
• Ensure all documentation above is approved by QA Lead prior to carrying out any testing.
• Participated in weekly meeting with the management team and walkthroughs.

Confidential, Rockvile, MD

Microstrategy Developer

• Utilized data modelers to create dimensional model based on the requirements
• Analyzed, designed, and constructed metadata as well as coordinated with ETL team to design flexible and scalable data models
• Created public objects such as metrics, prompts, consolidations, custom groups, drill maps and templates
• Designed Dashboards, Operational, Business and Ad-hoc Reports
• Created monthly Dynamic Dashboard Documents with multiple panel stacks, selectors, and customized widgets
• Created advanced reports using MicroStrategy Desktop Designer as well as Data Mart Reports, Partition Mappings, and Aggregate tables to improve performance of Enterprise Reports