Hari Krishna K. Email & Phone Number

Richmond, Tx, Us

Bangalore, Karnataka, In

• Lead analysis, prototyping, and design of reporting solutions using data engineering tools and techniques. • Hands-on experience with Azure Databricks in creating database entities and notebooks.• Effectively work with cross-disciplinary SMEs and users across multiple business regions.• Work with customers with an ability to deeply understand requirements and customer personas• Responsible for reviewing and deploying code using DevOps.• Mentor interns and support team members on technical issues and performance fine-tuning• Create data pipelines and maintain jobs for automated data loads in Azure Databricks.• Use strong SQL, Python skills to write effective data transformations

Windsor, Ct, Us

• Architect/Customize/Design reporting solution using Power BI • Developed visualizations, reports and dashboards on Power BI desktop and published to Power BI service.• Used custom visuals and advanced DAX • Involved in data quality and documentation.

Houston, Tx, Us

• Lead requirement analysis, customer interfacing and data modeling,• Architect/Designed and driven a reporting solution using Power BI backed by SQL Server• Developed visualizations, reports and dashboards on Power BI desktop and published to Power BI service.• Implemented row level security and enabled data refreshes using on-premise/enterprise gateways• Used advanced DAX for creating time intelligence measures • Involved in data quality and documentation.

Us

Houston, Texas, Us

• Lead requirements gathering with data owners for data sources, metrics, reports and data quality• Design, develop and maintain MS Power BI reports and dashboards and publish to targeted user groups• Expertise in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Heat Maps, Tree maps, etc.• Design end to end ETL work flow in Azure with various data sources and landing data in ADW• Design and deploy data models in Azure Analysis Services and use the models in Power BI to build reports.• Expertise in using MS Excel’s power pivots and power query for data analysis

Fort Worth, Texas, Us

• Designed, Built, Deployed and Presented BI Solutions in close cross-functional collaboration with various departments like Sales, Marketing, Product Management, Production Development• Key areas of focus – Customer Segmentation, Customer Engagement, Customer Journey Analysis, Sales on a customer base of 30+ Million• Lead Business Data Analysis, Reporting, Data Quality, Test coverage, Data Validation and Presentation to various business stakeholders and executives• Developed several enhancements to the Enterprise Data Warehouse (SQL Server):o Integration and in-bound / out-bound data flow automation of various enterprise source systems into Data Warehouse and Data Marts. New ETL Package Development (Microsoft SSIS)o Maintained Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSISo Created data models and database objectso Created automated schedules using CA ESPo Developed and implemented Historical and Incremental Loadso Created sanity checks and alert for monitoring data quality• Developed interactive dashboards and reports using Power BI for day to day business decision making and strategic planning needs• Performed several Power BI administration tasks including configuration of Power BI Gateways and scheduling refreshes• Developed and deployed OLAP cubes for various dashboards. Developed data models, dimensions, measures and calculated measures (SSAS)• Experience in using Data Analysis Expression (DAX) to create complex calculated columns and measures• Ad-hoc data analysis using R programming and Power BI

 Use Data Profiling to identify the vital attributes of the data. Perform Data Analysis of projects’ data and present analysis reports and metrics to senior management. Identify the functional dependencies and referential attributes Prepare a detailed report after the data profiling exercise  Design and develop reports and dashboards in QC and MS-Excel using advanced VBA scripting. HP Quality Centre – project workflow customization, user administration, QC upgrade and dashboards.  Install, configure and customize Quality Center Lead and evangelize the test management processes and the usage of various HP test tools such as LoadRunner, QTP and Quality Center  Define the project workflows in HP Quality Center for all projects across multiple teams in the organization Review the test execution metrics and provide recommendations for improving test execution productivity, savings in time and resources and ensuring on-time delivery

Global, Us

 Lead the QA activities including swags, kickoff meetings, QA estimations, requirements analysis, test planing, test authoring and execution & defect management. Responsible for QA sign offs for projects involving enrollments, billing, migrations and several other aspects of customer life cycle Participate in regular team reviews and retrospectives to identify and fix gaps in the test process Work in an agile methodology and update the QA status in daily scrums Ensure traceability of test cases to requirements, working with the project Business Analyst to ensure all requirements are tested. Work with technical analysts to identify testing scope, coverage and ensure any gaps are documented and addressed. Coordinate assignment of work to offshore testers and ensure that testers understand and are following the QA process Create traceability matrix between the functional specification and test cases/objectives Develop SQL code to test the business rules and perform data integrity, comparison, transformation, and report testing Use check points, functions, and customized VB scripting in QTP Lead, implement and maintain test process activities and artefacts. Perform Data Analysis of projects data and present QA metrics to higher management.  HP Quality Center – project workflow customization, user administration, QC upgrade and dashboards. Install, configure and customize Quality Center Lead and evangelize the test management processes and the usage of various HP test tools such as LoadRunner, QTP and Quality Center  Define the project workflows in HP Quality Center for all projects across multiple teams in the organization Build and present executive dashboards depicting overall testing status based on the project data in HP Quality Center Design and develop reports and dashboards in QC and MS-Excel using advanced VBA scripting.

 Establish test process framework at a client's place for a energy retailer in USA.  Create templates, guidelines, checklists as part of the test process design/framework. Train project teams on the test process and metrics. Comprehensive data analysis and metrics calculation. Design and development of Statistical Defect Prediction Model in Excel using VBA code.  Approach problems from several perspectives to provide the best solution Process Assessment, Process Definition, Facilitation and Internal Audits Prepare case studies of the accomplishments at client's places.

• Understand the functionality of the application in business perspective.• Prepare Project and Test plan.• Estimating the schedules, setting up the test environment, designing Test Strategy.• Authoring the Functionality/Compatibility and regression test cases, executing the same posting the issues in bug tracking tool. • Authored various Functional scenarios along with performing Gap analysis, Ad-hoc testing. • Responsible for handling full implementation cycle for multiple change requests (CR). • Responsible in the preparation of summary report after completion of testing for a release candidate and also client interaction via tele-conference on a weekly basis.

Joined AppLabs on 23-Oct-2006.

• Understand business requirements and functional specifications.• Prepared test plan and test scenarios and integration test cases.• Used Quick Test Professional to record and run smoke test cases for internal releases.• Record and report various bugs/issues and track them to closure• Involved in preparing and executing test cases for web testing.• Worked closely with developers to adjust specifications and enhance products with new features.

Mca, Master Of Computer Applications

Bsc, Maths, Physics, Chemistry