Keerthi K

SQL BI Developer

adiput@r.postjobfree.com

Ph. No: 425-***-****

Skill Summary

•Around 7 years of professional Experience in SQL Server database development and in testing.

•Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server Databases, Azure databases and Power BI desktop.

•Worked on all phases of business intelligence systems development lifecycle, from requirements gathering to training, implementation and support.

•Experience in Creating and executing Complex Transact SQL(T-SQL) Constraints, Joins, Sub queries, Functions, Views and Store Procedures in SSMS.

•Experience in developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard, Bulk Insert, Merge and union all.

•Experience in report creation using SSRS and created various types of reports like drill down, Parameters, Conditional, Table Caluculations, Matrix, Chart and Sub Reports.

•Experience in Creating and writing DAX, measureS ansd Caluculated columns.

•Experience in Creating Interactive Reports and dashboards using different Visualizations with Filters and Slicers using Power BI Desktop.

•Experience in building and publishing, Scheduling customized reports from Power BIdesktop to Power BI Service.Knowledge with Tableau Desktop, Tableau Server.

•Demonstrated expertise using ETL tools such as SQL Server Integration Services (SSIS) and Data Transformation Services (DTS).

•Good Knowledge of OLAP Cubes, SSAS, Snow Flake, Star schema and its Architecture.

•Good Knowledge in MDX Queries, DAX Queries, Blob storages, Cosmos and Azure concepts of Azure Data Lake, Azure Datawarehouse, Databricks, Azure DataFactory.

•Experience in testing Client-server, Web-server and Database Back end applications.

•Experience in Query Performance Tuning, debugging and troubleshooting the SQL Scripts in various databases using Indexes, SQL Profiler and Index Tuning Wizard.

•Experienced in implementing Scrum methodologies in SDLC and involved in all Scrum events.

•Experience in connecting databases from MS SQL Server to Azure SQL Server.

•Thorough knowledge on Software Development Life Cycle (SDLC) starting from requirement analysis, design, development, coding, testing and Production/Build.

•Experience in Creating and Executing Test Cases, Test Procedures and Test Scenarios.

•Experience in System Integration, GUI, UAT, Functional, E2E and Regression Testing.

•Exposure to various stages of SDLC, STLC and Defect Life Cycle.

•Experience in preparing Test Plan, Test summary and Bug summary Reports.

•Experienced in leading offshore team and On shore (QA/Dev Role).

•Expert knowledge of MS office tools such as Word, Excel, PowerPoint, Visio and Outlook, Share point, Azure, Power BI. TFS, MTM, MS Batch, MS Build

•Solid experience working with different disciplines (Dev, Test & PM) and bringing issues to closure.

•Well organized, Quick learner and have good analytical, written and verbal Communication skills.

•Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Technical Skills:

•Data Bases: Microsoft SQL Server 2014/ 2017/2018, Azure SQL Server,Orcale

•Testing Tools: QTP 9.2 /11.5/UFT, Test Track, TFS.

•ETL: SSIS, SAP BW 3.5, SAP BI 7.0, SSAS,

•Bug Tracking Tool: Excel, QC/ALM, Bugzilla, Test Track, TFS and JIRA

•Management tools: Quality Center 9.0, VSTF, MTM

•Languages: VBScript, C# .NET, C, Exposure in Java and JavaScript

•Operating Systems: Windows XP/8, Windows 2003/2008 R2 Server, Windows 10.

•Web Technologies: Exposure in IIS 7.0 and WCF REST Services, Soap/Web API

•Reporting Tools: Power BI, SSRS, Tableau, Qlik View, SAP BO, WEBI, Crystal Reports

•Source Safe : Visual Source Safe, TFS

Education:

•Bachelor of Technology in Electronics and Communications from Jawaharlal Nehru Technological University, India.

Professional Experience:

Role: SQL BI Data Analyst Dec 2016 to June 2017

Client: Microsoft, Redmond, WA, USA

Project: Digital Crimes Unit (DCU)

Description:

Tech Fraud Detection group is one of the project in Digitals Crime Unit in Microsoft to investigate the various types of digital crimes like email spamming and MS licensing frauds etc.Tech Fraud project mainly deals with the technical crimes who are committing technical frauds on online on various things such as Pop-ups and non-licensed Websites.

Responsibilities:

•Worked with the project manager to analyze the data and to create business specifications.

•According to business specs., Created the column list of Tech Fraud Case Studies Columns list.

•Importing the data from Source Telemetry to Destination Database server through SSIS Package.

•Worked on SSMS for SQL querying new tables, columns, Complex joins, T-SQL Functions for new case attributes for Tech Fraud.

•Created and Executed tables, views, Store Procedures for Tech Fraud Case studies.

•Worked with Store Procedures to clean and automate the existing and new case studies.

•Extensively Worked with Google Open Refine Tool to clean and grouping of the Case attributes.

•Worked on Excel spreadsheet to pull data to Tech fraud, Open refine and to Power BI desktop.

•Connecting the Tech Fraud SQL data source to load the data to Power BI desktop for reporting

•Importing the Investigators Case list data from excel to the Power BI to analyze the reports.

•Created various Power BI dashboard reports for Cases and types of Crimes to Investigate.

•Worked on Different visualization of Bar Columns, stacked column and KPI’ S etc. for reporting.

•Worked on export the Power BI reports to Azure for Case Management studies.

•Exported the Power BI reports to Various Case Management teams and Investigation teams to Investigate the Tech Fraud Digital Crimes.

Environment: SQL Server 2017, Power BI, Excel, Google Open Refine, VSTF, Azure

Role: Power BI Developer Sep 2016 to Nov 2016

Client: Microsoft, Redmond, WA, USA

Project: Practical Development Unit (PDU)

Responsibilities:

•Working with project manager to analyze the data and to create business specifications.

•Connecting the different data sources EXCEL, CVS files, SSAS, SQL Server to Power BI to load the data to Power BI desktop.

•Worked on Direct query and Import query mode to load the data to Power BI Desktop.

•Extensively working on Excel PDU, MPN spreadsheet to pull data to Power BI desktop.

•Importing the manager partners list data from excel to the Power BI desktop for reporting.

•Created databases, tables, views, for PDU and MPN data for reporting.

•Created and executed Complex SQL queries in SQL server for Power BI reporting.

•Creating Power BI dashboard reports using according to the requirements.

•Worked on creating visualization of gauges, stacked column, line charts, KPI’ S, MAP, drill down and drill through filters, Score cards for reporting.

•Worked on Power BI PDU desktop dashboard reports to publish to Power BI portal.

•Worked on roles and Permissions of sharing Power BI reports in the organization.

•Worked on export the Power BI dashboards to Azure and Share point.

Environment: SQL Server 2014, Power BI, Excel, MSRA, MTM, VSTF, Azure

Role: SQL Power BI Developer Feb 2016 to Apr 2016

Client: Peopletech Group, Redmond, WA, USA

Responsibilities:

•Worked with Business Analysts and analyzed the data to create business specifications.

•Worked with developer’s orientations on new projects and new Power BI Poc’s.

•Worked in Power BI Poc’s, SQL Azure Poc ‘s, Azure ADF and Azure cloud concepts.

•Worked on relational databases, T- SQL, SSIS and SSRS for Poc’s according to requirements.

•Created and executed SSIS packages to load and transform data between databases.

•Worked on migrating the data from on premise SQL Server database to SQL Azure database.

•Loading the data from different data sources SQL Server, SSAS for Power BI reporting.

•Developed Power BI Visualizations dashboards and published to Power BI portal.

•Created multiple visualizations Bar Chart, Column Chart, Maps and Filled Map in Power BI reports.

•Imported Custom visuals and worked on according to requirements in Power BI.

•Assisting Sr. Developers in various tasks in SQL Server according to their requirements.

Environment: SQL Server 2012, SSIS, SSRS, VSTF, ADF, SQL Azure, Azure, Power BI

Role: SQL BI Developer May 2015 to Jan 2016

Client: Microsoft, Redmond, WA, USA

Project: MSSales

Responsibilities:

•Review of Business Requirements document and Functional Specification document.

•Understand the Functional specifications and worked according to the requirement.

•Involved in Dev Planning, Test Planning and Code reviews for the requirements.

•Created and executed tables, views, Store procedures and triggers in MSSales Database.

•Created and executed various complex transact T-SQL Joins, Functions, Indexes, in MSSales database according to requirements.

•Involved in Change requests requirements and creating the code in MSSales warehouse database.

•Extensively worked on Warehouse, Staging and Factory servers and its databases.

•Performed Debugging on the complex Store procedures for the requirement to handle the errors.

•Involved in Agile Software development process (Scrum) and attended sprint meetings.

•Involved in status meetings, Defect triaging meetings, business meetings with Business analysts.

•Involved in various types of Functional, User acceptance testing, end to end and database testing.

•Extensively worked with VSTF and Microsoft Microsoft Test Management.

•Involved in deploying the code by using MS Batch build

•Reporting and maintaining the bug status by using Microsoft Team Foundation Server.

•Developed user requested reports by using Excel add in MSRA in MSSales.

•Involved in trouble-shooting and debug the code when problem occurs.

•Closely interacted with developers to fix bugs, track changes and modifications.

Environment: SQL Server 2012, SSIS, SSRS, MSRA, MTM, VSTF, SQL Azure

Role: Software Engineer Feb 2015 to Apr 2015

Client: WIRB, Puyallup, WA, USA

Project: Connexus.

Responsibilities:

•Review of Business Requirements document and Functional Specification document.

•Involved in Designing, Coding and Test Planning of Connexus Email Reader application.

•Participated in Test Estimation and Test coverage techniques for entire Connexus application.

•Manual created Test Scripts by referring FR documents and discussing with Business Analysts.

•Extensively worked on Email Reader and Electronic Submission Application for Connexus Db.

•Validated the data coming from Connexus application in Connexus database and in IRIS Database.

•Extensively worked on SQL Server joins to get the data from different tables.

•Worked on SQL Views and SQL queries to validate the data in IRIS Database.

•Created and executed the SQL Scripts for the Connexus Database.

•Validated the data in Connexus application and also in Connexus website.

•Involved in migrating the data from Connexus databases to IRIS Database using SSIS Packages.

•Created and Executed the Test cases according to requirements for Email and ESub applications.

•Developed and tested the whole functionalities of Email Reader Application for Connexus.

•Involved in End to End testing of Electronic Submission Processing Application in Connexus.

•Involved in System testing, Integration, End to End, Functional, Compatibility testing and Regression Testing of whole Connexus application.

•Logged the defects in Test Track and also send the bugs for QA Reviews.

•Involved in triage meetings with the Manager and developers with co-testers to fix the bugs.

•Involved in trouble shooting of bugs when occurred at the time of testing.

•Involved in documentation of the application status reports and send them to higher management.

Environment: Test Track, C#.NET, SQL Server 2012, SSIS

Role: SDET May 2014 to Jan 2015

Client: C2S Technologies, Redmond, WA, USA

Project: Wayspin Application

Responsibilities:

•Involved in Design, development and testing phases of wayspin application.

•Involved in Design, Develop and Execution of Test planning according to requirements.

•Involved in Master test plan, Test Plan and Test Strategy, Test Summary for wayspin application.

•Involved in documentation of Requirement Traceability matrices for requirements coverage.

•Creating and executing Test Cases according to the requirement.

•Extensively tested the Messages, Contacts, Driving Session modules of the whole application.

•Involved testing the application in functional, Compatibility, System testing and Usability testing.

•Created and executed SQL Queries and SQL Joins to perform database testing.

•Created and developed databases for each module in wayspin application.

•Created and executed complex store procedures in wayspin application for better performance.

•Experience in testing data flow from source SQL Server to destination SQL Server database.

•Experience in migrating the data from wayspin database to SQL Azure Database.

•Designed SSIS Packages to extract, transfer, load (ETL) existing data from SQL Server wayspinDb

•Involved in designing, executing, debugging and testing of reports in SSRS.

•Experience in generating and validating the test data according to requirements.

•Logging bugs in Quality center and Microsoft Team management tool.

•Owning the message, contacts module and tested the whole scenarios.

•Created and executed Functional, Security and Navigation and Usability Test cases manually.

•Tested on different browsers for browser Compatibility testing.

•Participated actively in the team meetings with the Developers for fixing the Bugs.

•Analyzed performance results and verified with the development team.

•Conducted document review meetings with business analysts, developers and with other testers.

Environment: SQL Server 2012, SSIS, SSRS, SQL Azure, C# .NET

Role: Software Test/ Report Analyst Sep 2013 to Apr 2014

Client: C2S Technologies, Redmond, WA, USA

Project: Sentimental Analytics

Responsibilities:

•Involved in Design, development and testing phases of Sentimental Analysis.

•Involved in reviewing of BRD, FRD, Test plan, Test Strategies and Test Procedures.

•Involved and Created test analysis, preparing design documents, Use cases and test cases.

•Created and executed SQL Server Scripts and updated scripts according to the requirements.

•Generated periodic reports based on the analysis of the data from various data using SQL Server

•Developed various operational Drill-through and Drill-down reports using SSRS.

•Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

•Involved in helping the business by creating the test scripts required to start the UAT.

•Involved in preparing the traceability matrix for the test requirements.

•Involved in helping the UAT team for fixing the UAT issues identified.

•Involved in the maintenance of the application and fixing of bugs.

•Coordinating test effort with the offshore team and guiding the team.

•Involved in daily triage meetings with the developers to resolve bugs.

Environment: SQL Server 2012, SSRS, C# .NET

Role: Test Engineer Oct 2010 to Apr 2013

Client: Champion Mortgage Company (CMC), Hyd, India

Project: Janus

Responsibilities:

•Analyzing the Business requirements.

•Prepared and executed test cases as per the Functional requirement documents.

•Created the test cases based on the client requirements.

•Involved in Manual Testing of the application.

•Involved in the execution of test cases for positive and negative testing.

•Conducting Sanity, Functional, Integration, Security, Regression and Retests on the application.

•Executed the test cases & Analyzed Test Results.

•Extensively worked with Excel Sheets and Quality Center.

•Logged the bugs and prepared the Bug report.

•Written SQL scripts for creating and updating the data from the database.

•Reported bugs and interacted with developers to resolve problems.

•Interacted with the client and involved in Project discussions.

•Interacted with various teams to resolve problems using Quality Center.

Environment: C#.NET, SQL Server 2008

Contact this candidate