SUMMARY:

• 10+ years of experience in IT industry accumulating 4+ years in Designing and Development of Business Intelligence applications with QlikView 11.2/10.0/9.0, 2+ years in QlikSense and 6+ years in Data Analysis/Validation, Database and QA Testing.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView .
• Excellent knowledge in designing and developing dashboards using QlikView by extracting the data from multiple sources (Oracle, SQL Server, Salesforce.com, Web Services, Teradata, Flat files, Excel, Access etc.).
• Experience in installing and setting up third party customs connectors like SalesForce connector, SAP Connector and Big Data connectors (Cloudera ODBC/JDBC Connectors) etc.
• Explored intensively and Implemented QlikView 11 advanced features like Direct Discovery, Alternate States, Grid Container, Dimension Limits, iPad offline Plug - in etc.
• Experience on QlikSense data visualization and implemented the new features of Qliksense like Pivot Table, KPI Object, PDF Printing etc.
• Extensive experience with QlikView sheet objects like Straight tables, Pivot tables, Containers, Line charts and Bar charts, scripting and building QVD’s and QVW’s.
• Solid experience in setting up the NPrinting Server, expertise with NPrinting Designer for developing design templates, constructing NSQs, Scheduling them on to the server with required filters, implementation of on-Demand extension objects for dynamic reporting etc.
• Installed and configured QlikView versions 10.x and 11.x.
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report designing and Performance Tuning using QlikView.
• Strong understanding of Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.
• Created data models for power users to create their own ad-hoc queries.
• Team oriented individual with a results driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management.

TECHNICAL SKILLS:

BI Tools: QlikView 10/11, QlikSense 1.2/2.0, QMC, Qlik Publisher, NPrinting

RDBMS: Oracle 9i, 10g, 11g MS SQL Server, MS Access, Sybase and DB2

Operating Systems: MS-DOS, UNIX, MVS, Windows 9x/NT/2000/XPand Linux

Languages: C, C++, .Net, JAVA, VB Script, SQL

ETL: Informatica, IBM Infosphere Datastage

Web server: Web Logic, IBM Web sphere, Microsoft IIS

Testing Tools: HP QC ALM

Data Modeling: Erwin data modeler

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, NY

QlikView Developer

Responsibilities:

• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs.
• Created and maintained OLE DB/ODBC connections for all environments.
• Created tasks and complex triggers to deploy the applications in access point using QlikView Management Console.
• Performed POC on QlikSense to generate immediate analyses and insights for reporting from mobile platform.
• Scheduled tasks refresh based on external events (EDX) and developed a batch file code to trigger the tasks.
• Tested application performance following existing test procedures and suggested improvements.
• Designed and developed QlikView complex dashboards from scratch to support reporting and Business Intelligence initiatives.
• Developed QlikView dashboards using different charts (Scatter, Bar, Line, Combo), drill through, and cycle down.
• Validated the application using QlikView document analyzer.
• Verified the data lineage for each application to ensure proper data flow.
• Managing database connections by creating connection strings as per requirement.
• Acquaintance with HP service manager for day-to-day issue tracking.
• Coordinated with Team Members in development process to integrate with the Test and Production Servers and helped creating use cases.
• Configured and deployed the applications in the access point using QlikView Server/Publisher.
• Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that business needs meet.
• Created Variables and Triggers to enhance the functionality of QlikView.
• Created tasks and deployed applications in access point using QlikView Enterprise Management Console.
• Managed all data and configuration information using QlikSense API’s.
• Created QlikSense Extensions to reach to requirements.
• Mounted the folders on QlikView publisher to publish the application on access point.
• Created folder structure for new applications and provided access to the users in QlikView server.
• Developed and modified UNIX shell scripts to meet the requirements after the system modifications and was also involved in monitoring and maintenance of the batch jobs.
• Established automatic email notifications to the concerned persons.
• Built QVD’s from Hadoop Hive/Impala, Web Services using SOAP request, Teradata, Oracle, and Sales Force.
• Identified data sources and targets for data modeling and solution architecture
• Participated with PM and other team members to design POC and later implementing it to create dashboard.

Environment: QlikView 11.2 SRx, Windows 2000 Server, Oracle 11g, SQL Server 2005, Hadoop, Teradata, MS Office.

Confidential, Seattle, WA

QlikView Developer

Responsibilities:

• Built QVD’s from SQL Server Database, Stored procedures and Excel files.
• Designed UI based on the Business requirements
• Developed QVD scripts to load history and current data using Incremental logic.
• Used Store function to store QlikView Data into CSV files to create other reports.
• Created PDF reports and scheduled to generate PDF’s every week.
• Installed and configured QlikView 10 SR4.
• Used Section access and Sheet access to make the application available to desired users.
• Loaded Data from SAP Database to QlikView and Developed DashBoards according to requirements.
• Created Variables to select date ranges as Calendar objects are not user friendly on IPad.
• Used SET Analysis and Aggregate functions to look back 30 days or 60 days and get the required information.
• Updated and deleted the CAL information on the server using QV manager.
• Upgraded QlikView to a most recent SR version.
• Responsible for Performance tuning the reports.
• Assisted in demoing QlikView application to users and gather feedback at every phase.
• Communicating with the Users to evaluate satisfaction and Identifying needs.
• Took part in designing a User document for Business Analysts.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time.

Environment: QlikView 11, Set Analysis, SQL server, Excel, SAP BI 7.01 & 7.31, Integrated Planning ECC 6.0, SAP HANA 1.0 - SP6, QlickView.

Confidential, Wilmington, DE

QlikView Developer

Responsibilities:

• Extracted the data from various data sources such as databases, Excel documents and CSV files, transforming the data into standard format and load the data so that it is available for analyzing and creating reports.
• Worked closely with Business to design, develop and enhance the Hyperion Reports.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Developed QlikView scripts to load the transformations and make enhancements to the user interface of the desktop application.
• Installed and configured QlikView 9.
• Customized QlikView reports to interact with Hyperion IR.
• Application processed tables with over 20 million records.
• Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Created batch scripts to process the data periodically as per the business requirements.
• Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Experience in scripting QlikView Set Analysis and Macros.
• Altered the QlikView scripts based on any unusual latency in the response time on the UI.
• Created User Interface and prepared layouts for the system by using QlikView.
• Participated in the developing/enhancement of star schema dimensional data model.
• Used MS Access and QlikView extensively as reporting tools and to create user build specifications.
• Assisted in upgrading from QlikView 8.2 to version 9.0.
• Wrote scripts and created batch files for automatic running of QlikView scripts.
• Worked on the UI for various applications.

Environment: QlikView 10, Set Analysis, Hyperion IR, Oracle 10g, PL/SQL 8.0, SQL*Plus, SQL Developer, MS Acces.

Confidential, Los Angeles, CA

Senior QA Analyst

Responsibilities:

• Communicate with the Data Services Team (Business Analysts, Data Architects, Developers and SVT) to review and analyze the business requirements.
• Actively participated in Requirements and Functional Specification Reviews (FRS).
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project.
• Apply knowledge of data analytics and business intelligence models to interpret technical solutions being implemented and design test cases that address functional and regulatory requirements.
• Worked with cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets the business requirements.
• Assisted in creating the Test Strategies (TS) and methods and Test Plans (TP).
• Assisted the lead and the SVT manager in creating the MRVPs (Major/Minor Release Validation Pack) documents and participated in sign-off meetings.
• Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing.
• Actively involved in the go/no-go and deferred defect meetings.
• Conducted end-to-end data validation of data flow between source, staging, ODS(Operational Data Store), and DM ( Data Mart) layer.
• Analyzed the EDW mapping documents, Dimension tables and fact tables.
• Wrote SQL queries to do the column level verification of the Dimension and Fact tables.
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target.
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica.
• Prepared Test Cases based on business requirements and business rules Performed Positive and Negative Testing Manually. Created SQL statements to validate the data tables.
• Communicate with the team - status, issues and risks on a timely basis to mitigate and drive project issues to resolution. Assisted the team in executing the ETL workflows to its completion and monitor the results. Actively involved in the Defect Triage meeting between the Development team and the SVT (System Validation and Testing).
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.

Environment: HP Quality Center, Oracle 10g, TOAD, SQL Developer, Internet Explorer, SQ

Confidential, Pleasanton, CA

QA Analyst

Responsibilities:

• Created test cases and implemented test strategy for EPS application and batch jobs.
• Created Drug Order (EDI 850 forms) for individual vendors from various stores.
• Coordinated and managed testing activities as per the Agile methodology followed by project team members.
• Validated End to end data mappings with business rules form source to target databases using SQL server and Oracle DBs.
• Data Base Back end interface testing using SQL quires on Oracle and SQL Servers.
• Validated batch jobs for reporting which were extracted from Confidential and Albertsons PDX EPS systems.
• Validated ePrescriptions from vendors to EPS system, EDI 850 (Order), 855 (Acknowledgment) and 810 (Invoice).
• Extensively involved in system, regression and End to end integration testing.
• Performed XML data files validations for web method transactions.
• Worked closely with the developers and team members on the issues found in the application.
• Generated the Daily Test reports about Test status and Defects summary.
• Involved in daily status meetings and weekly team meetings.
• Performed testing of converted accounts data of Confidential into Albertsons database.
• Tracked defects in Quality centre reported them to developers for fixes.

Environment: .Net Framework, SQL, MSSQL Server, Data Stage, XML,WSDL, MS Office.

Confidential, Portland, OR

Senior QA/Integration Test Analyst

Responsibilities:

• Worked with Business Analyst and QA Lead in reviewing and analyzing the business requirements Documents and functional requirements.
• Analyzed the EDW mapping documents, Dimension tables and fact tables.
• Wrote SQL queries to do the column level verification of the Dimension and Fact tables.
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target.
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica.
• Developed several hundred of test cases to cover the data movement between sources to target.
• Developed test scripts in SQL to check the data integrity from the databases.
• Imported pre existing Microsoft Word and Excel-based requirements and tests for analysis in MQC.
• Prepared Test Cases based on business requirements and business rules Performed Positive and Negative Testing Manually. Created SQL statements to validate the data tables.
• Actively participated in walkthroughs and enhancement meetings.
• Maintained Test Matrix and Requirement Traceability Matrix. Performed Gap Analysis.
• Created requirement/test case relationship using Quality Center (traceability).
• Contributed to and assist in implementing improvements in test methods and strategies.
• Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Executed test cases found errors reported defects, determined repair priorities, did regression testing and closed by using Mercury Quality Center.
• Assisted the automation team to automate the test cases for the next iteration.
• Customized Quality Center to suit the requirements of testing effort.
• Monitored the Defect Tracking Process and generated customized graphs and reports for the client using QC.

Environment: Oracle, HIPPA EDI, Mercury Quality Center, SQL, ETL.

Confidential, San Diego, CA

Senior QA Tester

Responsibilities:

• Worked with Business Analyst and QA Lead in reviewing and analyzing the business requirements Documents and functional requirements.
• Wrote SQL queries to verify that data are extracted according to the mapping documents into the Dimension and Fact tables from the source table.
• Involved in the testing the target tables for all the members and providers (EDI 834) after the tables are being populated from the source after ETL transformation.
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Tested that all the legitimate existing records in the source tables are being pulled and being populated in the right fields of the DIM and FACT tables.
• Performed SQL queries in the SQL Developer and ensured Correct Data Retrieval.
• Developed several hundred of test cases to cover the data movement between sources to target.
• Developed test scripts in SQL to check the data integrity from the databases.
• Imported pre existing Microsoft Word and Excel-based requirements and tests for analysis in MQC.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 834, 276/277, 270/271, 837/835.
• Performed Positive and Negative Testing Manually. Actively participated in walkthroughs and enhancement meetings. Created SQL statements to validate the data tables.
• Maintained Test Matrix and Requirement Traceability Matrix.
• Performed Gap Analysis. Validate the date from EDI transaction.
• Experiences working in ANSI x12 837-835 EDI Transaction.
• Tested the HIPPA 837/835 transactions according to test scenarios and verify the data on different modules.
• Authored test case scenarios in Excel spread sheet and export them into Mercury Quality Center.
• Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Executed test cases found errors reported defects, determined repair priorities, did regression testing and closed by using Mercury Quality Center.
• Responsible for Performing Integration Testing, UAT testing. Conducted Back-End Testing Using SQL Commands. Customized Quality Center to suit the requirements of testing effort.
• Monitored the Defect Tracking Process and generated customized graphs and reports for the client using QC

Environment: Oracle, HIPPA EDI, XML, Mercury Quality Center .

Confidential, San Jose, CA

QA and Performance Analyst

Responsibilities:

• Assisted the team members in writing the test cases and executed the test plans for the User Acceptance Testing. Worked extensively with SQL queries.
• Studied and assessed the client systems and the business process.
• Assisted in data analysis and worked with the design team in the designing of the databases with extensive use of ERDs. Worked with MS Access for the arrangement of the customer data.
• Analyzed user/business requirements to develop a Test Plan and Test Scripts which would cover all the functional specifications.
• Wrote scripts to perform positive and negative testing manually to verify actual results with the expected results.
• Created Defect Status Document for bug tracking and reporting and also followed up with the development team to verify bug fixes and update bug status.
• Conducted database testing for the application by writing and executing SQL queries.
• Checked the data flow through the front end to back end and used the SQL queries to extract the data from the database. Performed extensive manual testing for each module of the AUT.
• Created Requirement Traceability Matrix (RTM) to make sure that test cases were written for all the requirements.

Environment: MS Office Suite, Manual Testing, SQL MS Project, MS Access, Quality Center.