Anu Kumar Email & Phone Number

Saint Paul, Mn, Us

Whitby, Ontario, Canada

Translate requirements and create visualizations.Create data models to supports dashboardsCreate load scripts to populate data in the applications.Build and manage reports and analytics using Qlik SenseCollaborate directly with business development and product teams to translate business requirements into useful analytic reports, dashboards, and KPIsHelp architect and plan for changes and enhancements to the product in a proactive fashionWork with a data-centric platform… Show more Translate requirements and create visualizations.Create data models to supports dashboardsCreate load scripts to populate data in the applications.Build and manage reports and analytics using Qlik SenseCollaborate directly with business development and product teams to translate business requirements into useful analytic reports, dashboards, and KPIsHelp architect and plan for changes and enhancements to the product in a proactive fashionWork with a data-centric platform in extract, transforming, and load dataWork with our cloud-based platform in AWS, manipulating data through AWS-provided servicesDesigning of Qlik Sense app using visualization, creating data connections, user directory connections, Applications etc via QMC. Show less

Whitby, Ontario, Canada

Validate data displayed in the various Qlik Sense dashboards. (Project Name: MotoBI, Inights, Alcon, 360Claims Monitor, Dish Network) drill down to specific distributors and individual resellers. In order to get the data in the dashboard different ETL process were involved for Qlik app refresh. I have worked on different database like Redshift, Maria, ODS, Sql to populate data in the dashboards. We have used amazon S3 bucket in order to create that data lake and get the data in the different… Show more Validate data displayed in the various Qlik Sense dashboards. (Project Name: MotoBI, Inights, Alcon, 360Claims Monitor, Dish Network) drill down to specific distributors and individual resellers. In order to get the data in the dashboard different ETL process were involved for Qlik app refresh. I have worked on different database like Redshift, Maria, ODS, Sql to populate data in the dashboards. We have used amazon S3 bucket in order to create that data lake and get the data in the different database. Then run ETL jobs to populate the data in the database.I am also involved in validation for ETL jobs, we use Rundeck to run our ETL jobs and in case of any failures notifications are send on Teams further investigation involves Redshift monitoring via AWS Services. It is my job to deploy code in the lower environment using Teamcity. Show less

Mn, Usa

Description: Scantron’s ASPS (Achievement Series and Performance Series) is a SaaS based application. Achievement Series, Scantron’s fixed-form, formative assessment solution for interim testing, helps K-12 educators increase student achievement while meeting federal requirements. This unique and powerful tool performs web-based or paper testing to measure grade level knowledge in multiple subject areas. It also provides immediate results to accurately measure student progress… Show more Description: Scantron’s ASPS (Achievement Series and Performance Series) is a SaaS based application. Achievement Series, Scantron’s fixed-form, formative assessment solution for interim testing, helps K-12 educators increase student achievement while meeting federal requirements. This unique and powerful tool performs web-based or paper testing to measure grade level knowledge in multiple subject areas. It also provides immediate results to accurately measure student progress. Performance Series, Scantron’s computer-adaptive diagnostic testing solution, provides educators with instant test results, personalized to each student, that ensure correct overall student placement at, above, or below grade level. Administered online over various devices, these individualized tests provide a longitudinal view of student growth across semesters or years in core curriculum areas (English Language Arts, Mathematics, and Science). Actively participated in Summative testing. The development follows Agile Scrum with two-week sprints.Scantron Data Portal (Analytics) for South Carolina: Scantron Analytics delivers up-to-date information through highly visual, easy-to-understand dashboards. Scantron Analytics simply stores data from a variety of educational systems and represents information online to parents to view their child performance in each testing period thorough out the school year. It shows easy to understand graphical representation of data with District Average. MAP, MAP Growth, SAT, ACT, Attendance, Discipline and other such data are displayed in together to get the real picture about which area teacher needs to work on and parents gets comprehensive picture on one go. Analytics is a powerful tool to get the data from District and simplifies the display of data by accessing and representing in a form where data makes sense to teacher, parents and school administration. Show less

Mn, Usa

Responsibilities:  Analyze the Business and Functional requirements, involved in several brainstorming sessions with BA, Product Manager, Product Owner, Development Director and Developers Actively participated from QA Automation team for the new environments build from scratch. Involved in meetings with Developers and Infrastructure team for the bugs and issues found in the process Participate in agile scrum sprint planning, daily standups, product demos and sprint… Show more Responsibilities:  Analyze the Business and Functional requirements, involved in several brainstorming sessions with BA, Product Manager, Product Owner, Development Director and Developers Actively participated from QA Automation team for the new environments build from scratch. Involved in meetings with Developers and Infrastructure team for the bugs and issues found in the process Participate in agile scrum sprint planning, daily standups, product demos and sprint retrospectives Work with Business users to understand project requirements and to figure out the scope of test strategy and test planning Analyze user requirements and develop Test Cases with both negative and positive scenarios Perform GUI, Functional, System, Integration and Regression Testing Perform smoke and regression testing during production release deployment Work over Production releases, Hotfix and Critical Incident reports Prepare and execute System Test Cases against the user requirements Execute SQL scripts/queries for data verification to compare the expected results with database Evaluate Test Results & Submit Status Report to QA Manager and Development Director periodically Close interaction with software developers to understand application functionality and performance, discuss test findings and report bugs Execute automation script in Selenium for Regression testing Execute automated Selenium scripts and debug code in C#, reproduce failures manually  Good Experience on Selenium IDE and creating Scripts in selenium, using C#Environment: C#.Net, SQL Server 2012, CSS, JIRA, TTP, Agile Central, Test Manager, TFS, XML Web Services.Rewards and Recognition's:• Core value award for Customer Focus in quarter III (2018)• Core value award for Customer Focus in quarter I (2018)• On Spot achievement award Show less

Mn, Usa

The Order Import Process builds a Console Application EXE called OrderImportProcess.exe. This console application processes files from various clients and network folders based on values in its configuration file and is scheduled to run on a regular basis. These files are usually sent to us via FTP and can be flat files (Comma Separated Value, pipe-delimited, or fixed-width) or XML files.The User Import Process modeled around an abstract Base User Importer class which takes in a Client… Show more The Order Import Process builds a Console Application EXE called OrderImportProcess.exe. This console application processes files from various clients and network folders based on values in its configuration file and is scheduled to run on a regular basis. These files are usually sent to us via FTP and can be flat files (Comma Separated Value, pipe-delimited, or fixed-width) or XML files.The User Import Process modeled around an abstract Base User Importer class which takes in a Client object and a configuration collection in its constructor.Responsibilities: Study and Analysis of Test requirement specifications Preparation of the Test Execution Plan Execution of Manual Test Scripts Test Data Loading Validating the Test Results Responsible for writing the code in Microsoft Visual Studio.Net 2010 with ASP.Net using code behind as C#.Net Used Grid View control extensively for data display, dynamic generation of rows, and user input inside template columns. Used Edit Item-Templates and Footer Templates extensively for editing and adding rows Involved in writing SQL queries in SQL Server 2005 Maintenance and enhancements of these applications in maintenance phase Troubleshooting and debugging production issues Discuss problems with the sales team Make code changes and bug fixesEnvironment: C#.net, JavaScript, Html, XML, Sql Server, CSS, HTML, SVN Show less

New Delhi, India

Responsibilities: Design Real time tracking system for Indian Railways Actively participate in gathering requirements, designing and coding Design, manage relationships and populate the SQL server database Created test cases and test procedures based on Functional requirement Performed Functionality testing and Integration testing Regression testing is also undertaken after every Bug is fixed Interacted with developers to resolve application… Show more Responsibilities: Design Real time tracking system for Indian Railways Actively participate in gathering requirements, designing and coding Design, manage relationships and populate the SQL server database Created test cases and test procedures based on Functional requirement Performed Functionality testing and Integration testing Regression testing is also undertaken after every Bug is fixed Interacted with developers to resolve application defects Responsible for execution of test cases  Logging Defects in Bug tracking tool Defects tracked, reviewed, and analyzed  Trained the new joiners about the applicationEnvironment: Bugzilla, Asp.net, Html, CSS, XML, JavaScript, Sql Show less

Master, Computer

Masters

Bachelor'S Degree(Computer Science), Computer Science