Sql Server Power Bi
Resume:
Kiran Kumar Jangeli
*****.**********@*****.***
SUMMARY:
13+ years of IT experience in various Industry verticals like Health, Insurance and Hospitality Domain.
Extensive experience Data Analytics, System Analysis, Database development Administration, Design development and MS SQL Server,2022, 2019, 2016, 2008 R2 in Production, Testing and Development and Extensively with all phases of Software Development Life Cycle (SDLC) and Project Management Methodologies.
Regular interaction/communication with client and on-site coordinator for understanding the scope and analyzing the risks involved in different enhancements and specification changes
Highly proficient in the use of SQL Server and T-SQL (DDL and DML) in Constructing tables Normalization\Denormalization Tech. and Creating Complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins. Key areas include Query Performance Tuning (Indexing, Query optimization).
Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
Expertise in designing complex reports using Cascading parameters, Dashboard, Graphs, Drill-Through Reports, Parameterized Reports, Sub reports and Ad-Hoc reports using SQL Server Reporting Services (SSRS), Power BI
Good experience in ETL data flow using Creating mapping/Workflow to extract data SQL Server and Data migration and Transformation from different sources using SSIS, Dell Boomi and Matillion.
Experience in Developing SSIS Packages. DTS Migration and Metadata management: Migrating DTS packages and Error and Error Handling: Precedence constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using on different environments and deploy data, Schedule the job execution task periodically
Good Working experience with Fact, Dimensions and Muli-Dimensional Cubes.
Good understanding of Star and Snowflake Schema, Dimensional Modeling, E-R modeling, Slowly Changing Dimensions (SCD) and Data warehousing concepts.
Experience in creating task and user stories, data pipeline and deployment process using Azure Devops.
Good Experience with Power Platform: Power Automate, Power BI, Canvas Apps, Model Driven, Dynamic 365 CRM and Portals.
Good Experience in developing application in power apps using Common Data Service (CDS), Flow, Excel, Forms and Share point online and backend SQL Server on-Premises
EDUCATIONAL QUALIFICATION
Master’s in business application in the year 2015, From Osmania University.
Bachelor of Technology in the year April 2005, From JNTU.
TECHNICAL SUMMARY
Microsoft Tools
Power Apps, Forms, Power Automate (Flow), Microsoft Teams, Power BI, MS Office, Azure DevOps
Reporting tools
SQL Server Reporting Services, PowerBI, Power platform Paginated report
ETL tools
SQL Server Integration Services, Dell Boomi, Matillion
Database and DBA
SQL SERVER 2005, 2008, 2008 R2, 2012, 2016, T-SQL
O.S.
All Flavors of Windows and XP
PROFESSIONAL EXPERIENCE
Client : Department of Public Health, CT
Environment : Power Apps, SSRS, SQL SERVER, Azure Devops
Database : SQL SERVER 2022
Role : Product Implementation
Duration : 2022 to till Date
Project#1 : CGMS - Health
Project Description:
This Project implementation involves different kinds of module like Provider, Grants, Contracts, Payment, Insurance, etc.
The scope for this implementing out of the box Analytics solution for Health Insurance, which involves detailed review of data Analysis, reporting needs and databases changes, discussion with the system users in different Phases. This will majorly include the following key features.
Major Features Include:
Implementation for All module based on understanding of existing system
Creating database ERDs and functional requirement
Application development using Power platform with power Automate using canvas Apps
Integrations and Configuration
Creating Report using SSRS, paginated reports and Power BI Dashboards
Roles & Responsibilities:
Analyzing and understanding the client requirements and preparing functional specifications
Creating ERDs for all modules based on Data migrations that given by the client
Application Development with Low Code Solutions using Power platform.
Integrations (Provider, Grants, Contracts, Payment, Insurance etc.) and Admin Configuration.
Developing Complex Stored Procedures and coordinating and assigning the task to Team members
Creating the stored procedures, functions as requested by business analyst.
Effort estimation and Project Planning
Performing Unit Testing.
Conducting daily stand-up meeting and team meeting
Writing Parameterized Queries for generating reports, formatting report layout, reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008/2016.
Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins.
Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
Client : Boca West, Boca Raton, FL
Environment : SSIS, SSRS, SQL SERVER, ASP.Net MVC
Database : SQL SERVER 2016
Role : Product Implementation (Cobalt Software)
Duration : 2016 to 2021
Project#2 : Cobalt
Title : Sr. Team Lead(SQL/ETL/Reporting)
Project Description:
Boca west is the Client, as a project this implementation involves different kinds of module like Membership, HR and Payroll, Accounting (Account Payables, Account Receivables, General Ledger) and Retail POS.
The scope for this implementing is an out of the box Horizon Analytics solution for Boca West, which involves detailed review of data Analysis, reporting needs and studying of current systems & databases, discussion with the system users in different Phases. This will majorly include the following key features.
Major Features Include:
Implementation for All module based on understanding of existing system
Creating database ERDs and functional requirement
Integrations and Configuration
Creating Report using SSRS and Qlik dashboards.
Data Migrations
Roles & Responsibilities:
Analyzing and understanding the client requirements and preparing functional specifications
Creating ERDs for all modules based on Data migrations that given by the client
Integrations (Accounting, Retails and Membership etc.) and Admin Configuration.
Creating the dashboard and reports
Developing Complex Stored Procedures and coordinating and assigning the task to Team members
Creating the stored procedures, functions as requested by business analyst.
Effort estimation and Project Planning
Performing Unit Testing.
Conducting daily stand-up meeting and team meeting
Client : Uniform Data System for Medical Rehabilitation, Amherst NY
Environment : SSRS, SQL SERVER
Database : SQL SERVER 2008 R2
Role : New Implantations Development and Maintenance
Duration : 2012 to 2017
Project#3 : UDS-PROI HL7
Title : Sr. Team Lead
Project Description:
UDS MR stands for Uniform Data System for Medical Rehabilitation which acts as a mediator between CMS (Centre for Medicare & Medicaid Services) & Rehabilitation centers. The main aim of UDS is to send the patient information of facilities to CMS to reimburse the amount spent by facilities and reduce the denials from CMS.
The rehabilitation centers have their own HIS (Health Information System) and they will be inserting patient demographic data into UDS-PROI and UDS Documentation by sending patient information through HL7 messages. The purpose of the HL7 system is to automate the process of capturing and managing patient information and its assessment details. Introduced a patient assessment tool more powerful than any seen to date by the medical rehabilitation field. Our UDS-PRO® System subscription is designed for IRF-PAI completion, CMG assignment, and data transmission to both CMS and UDSMR. The system has different case mix group (CMG) for different diseases based on this CMG system generates expected length of stay (ELOS) so that the patient gets cured with in that period. In each of the assessment’s patient conditions such as his eating, bathing, grooming, walking style are noted and each of them are given ratings so based on these ratings patients are transferred from one stage to another.
Roles & Responsibilities:
Analyzing and providing defect free fixes in coding/database patches required in Release Live phase of deployment.
Providing extensive support for the LIVE deployment.
Involved in all knowledge sharing sessions pertaining to the technical and project requirements
Preparing specifications and CR documents for the new implementations/Existing implementations.
Developing new implementations as per the HL7 specifications.
Developing HL7 ADT interfaces for inbound and DFT for outbound.
Having capable of reproducing all the scenarios which were encountered in production.
Analyzing and understanding the client requirements.
Modifying the stored procedures, functions as requested by business analyst.
Effort estimation and Project Planning.
Client : AmeriLife Group, LLC. Clearwater, FL
Environment : SSIS, SSRS, SQL SERVER
Database : SQL SERVER 2014
Role : Implementing and Maintenance of Business Horizon Analytics
Duration : 2012 to 2013
Project#4 : VUE AmeriLife BI
Title : Team Lead
Project Description:
VUE Insurance is a software and AmeriLife is the Client, as a project implement the Business Intelligence solution to help them taking strategic decisions related to vision, mission, goals and objectives.
The scope for this implementing out of the box Horizon Analytics solution for AmeriLife BI, which involve detailed review of AmeriLife reporting needs and studying of current systems & databases, discussion with the system users in different Phases. Here Phase 1 of this project will include out-of-the-box implementation of VUE Horizon Analytics. This will majorly include following key features.
Major Features Include:
Write the routines to extract the information from AmeriLife VUE Database
Configuring the warehouse database, cubes along with integration packages.
Remove the product entities that are not required for AmeriLife business purposes.
Setup the reporting hierarchy in the cube.
Test complete setup internally and then deploy to UAT.
Roles & Responsibilities:
Preparing specifications and CR documents for the new implementations/Existing implementations.
Developing stored procedures to extracting the information from source database to Warehouse
Creating the Packages for different module like Policy, Agent. Production etc.
Reproduce of scenarios which were encountered in production.
Analyzing and understanding the client requirements.
Modifying the stored procedures, functions as requested by business analyst.
Effort estimation and Project Planning
Performing Unit Testing.
Conducting daily stand-up meeting and team meeting
Performing Unit Testing.
Client : LNR Property LLC. Miami Beach, FL
Environment : SSRS, SQL SERVER
Database : SQL SERVER 2008 R2
Role : Development and Maintenance
Duration : 2011 to 2013
Project#5 : Performance Management System (LNR)
Title : Sr. Software Engineer
Project Description:
The Purpose of “Performance Management System” is to build a new platform using latest Microsoft.Net technology to manage the distribution, tracking and reporting of the Midyear Objectives and Annual Performance Review. This system can be operated on Intranet as a secure web application with year around availability.
It also provides a central location for all the regions (USA, UK and London). The system would also have an ability to migrate the data from LNR Existing system which would be a one-time process. Also, the new system will have the ability to interface the data from the existing HR system (called UltiPro). The Functionality of the system includes Export forms, print forms, and interface with UltiPro, Acknowledgements, Locking the dates, and restricted access to the users depending on the HR needs.
Roles & Responsibilities:
Developing Reports
Creating stored procedures, functions as requested by business analyst.
Performing Unit Testing.
Effort estimation and Project Planning
Training and giving KT sessions to the new team members.
Client : Insphere, FL
Environment : SSRS, SSIS
Database : SQL SERVER 2008 R2
Role : Maintenance, Developer and Unit Testing
Duration : 2011 to 2014
Project#6 : VUE Insphere
Title : Software Engineer
Project Description:
Insphere Source System Queries refers to the data extraction code to pull the data from the VUE application, CRM, and other source systems such as CSV files (Budget data, Geography, and Legacy Actual). In some cases, it requires a lot to extract the right data out of these systems to populate the data warehouse. In general, all transformation logic, such as the replacement of null values, or transforming a value to a more meaningful name to the end-user, will happen within the SSIS packages. Within each SSIS packages we execute SQL Stored procedures and/or queries to extract data from the source system. We then perform transformations and apply any business rule logic to the data. Finally, we load the data into the data warehouse where it can be consumed by reporting and/or OLAP tools.
Roles &Responsibilities:
Worked with SSRS, SSIS.
Worked with Stored Procedures.
Extensively worked in Sprint Model.
Responsible for all the documentation required for the applications.
Effort estimation and Project Planning
Helping the team in understanding the business workflows
Client : Microsoft Corporation
Environment : SSRS, SSIS
Database : SQL SERVER 2008 R2
Role : Development
Duration : Aug 2010 to Dec 2010
Project#7 : ITSM Platform
Title : Software Developer
Project Description:
ITSM Platform Solution utilizes e-Service Desk and Microsoft’s System Center Service manager to align MS Operate process. This Project is used as single point of contact for all Service-related activities. IT Service Management is an overall approach to running IT Operation from a service delivery perspective. It consists of numerous process areas including Incident Management, Request Fulfillment, Problem Management, Service Level Management, and Financial Management. This helps the service provider to understand what services are delivered and to clearly define and standardize roles, processes and tools to deliver those services.
Responsibilities:
Extensively Worked with SSRS
Worked with Stored Procedures.
Extensively worked in Sprint Model.
Responsible for all the documentation required for the applications.
Effort estimation and Project Planning.
Client : Leading Insurance Companies (Dubai)
Environment : SSRS
Database : SQL SERVER 2005
Role : Maintenance & Developing
Duration : 2009 to 2010
Project#8 : Leading Insurance Companies
Title : Software Developer
Project Description:
Complete ERP highly flexible and technically accurate software, fully developed and tested under the guidance of Software Professionals and Industry Experts. This brings together everything u can have in your business operation. Which include the CRM, Sales Management, Document Management System, Office Tools, Utility Tools, HR & Payroll & MIS and to back it up all the most powerful and flexible Finance & Budgeting Engine. This Software bring the Business Module currently caters to the Insurance Industry, focusing on the Middle East & East Asian Market.
Roles and Responsibilities:
Developing SSRS Reports.
Responsible for all the documentation required for the applications.
Contact this candidate