SUMMARY:

• A highly motivated elite information technology professional with 2+ years of solutions experience seeking a position as a Business Intelligence Analyst with a great company that will utilize my skills and experience.
• Strengths include as eclectic experience with Web Based projects, Business Intelligence and Data warehousing.
• A team player with excellent communication, organizational, interpersonal and problem - solving abilities.

TECHNICAL SKILLS:

Software Testing Tools: Selenium, QTP 11.0, Load Runner

Databases: Microsoft SQL Server 2010, 2012, 2014, 2016

BI Tools: SSIS, SSRS, Informatica, Tableau

Operating Systems: Windows XP, 07, 8.1, 10, UNIX

QA: Rally, Trello, Bugzilla, JIRA, HP ALM Quality Center

Airlines Design Tool: Sabre

Cloud Computing: Salesforce

Methodologies: Waterfall, Agile, Scrum Methodology

Other tools: Remedy (ARS) Trouble Ticketing, Microsoft Office Suite, Open Office, MS Visio 2016

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth-TX

QA Business Analyst

• Worked on the requirements, analysis, design and business process for integrating the US Airways LUS and Confidential LAA Flight Crew Management Systems within the Flight Operations Integrations.
• Working as a liaison between stakeholders and the technology team to interpret business needs.
• Performing GAP Analysis to compare actual performance with desired performance.
• Eliciting and gathering project requirements from the stakeholders by facilitating JAD, JAR, Interview sessions, Focus groups.
• Designed process flow diagrams reflecting current and proposed business processes and their desired functionality.
• Troubleshooting system issues, monitoring scheduled jobs and setting up maintenance plans for proactively monitoring the performance of the SQL Server databases.
• As part of the Customer Acceptance Testing CAT testing performing conducting white box testing working on FOS Sabre to test the code and entries given by the development team.
• Writing test cases for the scenarios developed for CAT testing to include the changes and enhancements involved in the FOS system.
• Running the test cases for the CAT dates to meet the UAT deadlines as per the business processes mapped.
• Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.
• Working with the ‘Labor Protective Provisions’ team to explain the enhanced changes required further through the change Request CR form for all the Flight Attendant operations required.
• Participated in the grooming session as part of the beginning of iteration to define the scope and points for the User Stories based on the complexity.
• Created Test cases for the User Stories, execute the test cases in the QA environment. Worked closely with the developers to log and resolve issues. Retested the code after bug fixes and conducted a demo of the finished story to the Product Owner.
• Wrote test cases, executed tests and validated results for project management FOS, FOS Flight Integrations and Progress Reporting.
• Perform analysis on the root cause of the failed Test Cases and provide the related data samples to the Test Lead.
• Involved in the preparation of Requirement Traceability Metrics (RTM) as well as the Software Metrics.
• Provide daily updates in Daily Scrum calls and send weekly execution results to the Team Leader to continue guiding the Development Team through the defect resolution life cycle.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing, environment using Selenium RC.
• Created a test framework using Selenium for automated test execution.
• Performing data analysis and running SQL queries against the databases to verify the correctness of XML response.
• Document request/response XML's Test Procedures along with functional or technical findings from the test run.

Confidential, Pawtucket-RI

Business Intelligence Analyst

• Created a new SSIS package to extract date from the Legacy System to the SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Defined Check constraints, Indexes, and Views that aligned with the Business Rules.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to the Data Warehouse Databases and Data Marts.
• Responsible for creating reports basing on the requirements using SSRS 2008.
• Developed SSIS Templates which were used to develop SSIS Packages that allowed to dynamically deploy into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Developed, monitored and deployed SSIS packages, Performance tuning of Stored Procedures and T-SQL Queries.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
• Performed data conversion from flat file into a normalized database structure.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
• Tested the ETL mappings from Source to Target.
• Verified the populated data correctly into fact and dimension tables.
• Executed SQL queries using Microsoft SQL Server Management Studio to find useful test data to verify various functionalities of the application and also done the back-end verification.
• Worked on developing and integrating the Data from Salesforce to the SQL server, and back to Salesforce using the SQL Server Integration Services (SSIS) and SQL Server Data Tools (SSDT).
• Integrated Salesforce with the SQL server using SSIS by Task Factory acting as mediator for the data flow.
• Created Reports, Dashboards and Dashboard Components and implemented multiple levels of sales Dashboards and scheduled Dashboard refreshes using Tableau.
• Dashboard Visualization through Tableau BI application.
• Preparation of Daily status reports, defect summary reports and weekly status reports on the daily builds.

Confidential, Chicago-IL

Data Analyst

• Performed daily monitoring and regular analysis of credit card fraud data and statistic.
• Delivered efficient and accurate reporting of data associated with Credit Card fraud.
• Reported mid-month and month-end fraud statistics using SQL Server as well as ad-hoc reporting.
• Proactively identified and evaluated fraud trends across multiple channels.
• Performed in depth, ad-hoc analysis of processing volumes related to credit card fraud, including identifying and applying trends and root cause analysis.
• Developed presentations that summarize and communicates results from analysis.
• Provided recommendations to management on long-term strategic plans for global fraud strategy.
• Identified issues, propose solutions and coordinated/contributed to implementation.
• Worked with management and end-users to address data and process concerns.
• Supported fraud prevention initiatives, projects and vendor relationships.
• Part of scrum ceremonies - Concept team, sprint estimation, sprint planning, gathering all the requirements from client, Creation of high level test scenarios as per acceptance criteria and Conducted group meetings, walkthroughs with business and IT teams.
• Validated Microsoft SQL Server details from SCCM, UNIX servers from HPSA, and validating list of Virtual machines from VMware.
• Reviewed unlimited number of contacts, hosts from SI2 and CoreDB, hosts to ensure accuracy.
• Validated Microsoft SQL Server details from SCCM, UNIX servers from HPSA, and validated list of Virtual machines from VMware.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
• Involved with Data Extraction, Modification, Validation, Analysis, Management and Reporting.

Confidential

Intern SQL Business and Data Analyst

• Analyzed the Business Requirement Specification document to understand the project.
• Worked closely with clients and SMEs to understand the business process. Elicited business requirements through brainstorming sessions and developed a Business Requirement Document for additional requirements.
• As part of a team interacted with the Business Analysts and the Developers to obtain proper understanding of the requirements, gathered system specifications and work through projects.
• Assisted in creating new tables, wrote stored procedures for Application Developers and some user defined functions.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables in QA.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Performed Gap Analysis, conducted walkthroughs and acted as a liaison between the business users, stakeholders and the team to perform requirements, quality and risk analysis.
• Facilitated requirement gathering and sessions with critical stakeholders from Sales, Marketing, and the Customer Service Departments.
• Handled multiple projects at the same time while adhering to the QA/QC processes during each phase for a project.

Confidential, Valparaiso-IN

Teaching/ Lab Assistant- Department of Communication

• Primary responsibility was to provide Student Support and Customer Service to 200 students weekly.
• Tutored over 200 communication students to learn MAC IOS.
• Worked with professors to operate data entry devices, input and maintain lists, records and other data points into an electronic format for Reporting Analysis.
• Responsible for opening and prepping over 60 pieces of mail and reviewing the documentation received in order to ensure the assignments submission process has been completed.

Confidential, Valparaiso-IN

Library Assistant- Christopher Center Library Services

• Performed circulation desk procedures such as checking in and checking out materials. Registered patrons and collecting fines.
• Worked to process, withdraw, repair and reconditions Library materials.
• Assisted with library programs and displays.