Dedicated and focused Support Representative who excels at prioritizing, completing multiple tasks simultaneously and following through to achieve project goals. Seeking a role of increased responsibility and authority.
•Testing activities to validate the overall process to extract and integrate data including the delivery of information using pre-defined and ad hoc reports.
•Testing the performance of the system to extract and load data, and respond to database queries.
•Tested the data staging process that load flat files data in to ODS.
•Developed complex SQL queries for querying data against different databases for data verification process.
• Worked with Data Warehousing developers who extensively used DATASTAGE, to design mapping to move data from source to target database-using Stages to do the functionality.
•Prepared status summary reports with details of executed, passed and failed test cases.
•Functional testing to ensure business requirements are met.
•Non-functional testing to ensure usability and system requirements are met.
•Power Query to Import data from sources including relational databases, text files, web pages, and Excel workbooks.
•Build repeatable processes to filter, clean, aggregate, and transform your data.
•Prepared the Test Plan and Testing Strategies for Data Warehousing Application
•Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.
•Tested to validate the data using excel for data mapping to SQL studio.
•Participated in regular project status meetings and QA status meetings every week.
•Involved in Peer review of the test cases.
•Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
•Assigned the tasks of testing functional applications and, validating testing procedures
•Used Data profiler to test the files.
Environment: Microsoft Management studio, Visual Studio, SQL, Flat Files, Excel, Xml, Power Query, Manual Testing.
academic, administrative, administrative support, attention to detail, billing, cash register, Strong interpersonalskills, conferences, clients, customer service, databases, email, fashion, fast, faxes, faxing, filing, insurance, Legal, materials, meetings, Excel spreadsheets, mail, Microsoft Office, MS Office Suite, office, neat, numeric filing, policies, presentation development, problem solver, processes, receptionist, reception, sales, scanner, scanning, scheduling, spreadsheets, team-player, team player, telephone, phone, Time management, websites,QA testing, SQL
Companies Worked For:
Job Titles Held: