Kamalakar Akiri

• Having 2.5+ years of professional development experience in the areas of Microsoft Power BI primarily using Microsoft SQL and T-SQL Server, Data Warehouse, SSAS Tabular Model Cube
• Imported data from multiple data sources into BI Tools, created relationship between data, Created Calculated Columns, Measures using DAX Query.
• Experience in creating different visualizations like Line, Bar, Scatter Plot, Waterfall Chart, Heat map, Tree map, Card, Multi card, Table, Area chart, Pie chart, Donut chart etc.
• Hands on practice on market place timeline slicer, Hierarchy slicer, Drill down and Drill up, Text filter and Word cloud on Power BI.
• Created Joins by combining Tables, Column elements from available data sources and data connections in Power BI Services.
• Well knowledge on gathering and translating End User requirements into Reports & Dashboards. Including Analysis, Design, Development of Reports and Dashboards.
• Great exposure on working with edit interactions,
• Good experience to work with Focus mode for non-interactions
• Having Great Experience in implementing the security by RLS
• Experience in scheduling power bi reports by using the Data Gateway and Knowledge of viewing dashboards in Power BI Mobile version.
• Good knowledge in publishing Reports to Power BI Services and setting up the necessary connection details and Scheduling.
• Creating interactions of Highlight, Filter Action add interactivity o the Visualizations.
• Designing and Deploying data Reports and Dashboards for large of Data in Power BI.
• Knowledge in creating Workspaces, Groups and Content packs in the Power BI Services.
• Expertise in Transact-SQL (DDL, DML, DCL, DQL) and in design and Normalization of the database tables. Improve the database Performance and Availability.
• Experience in implementing business logic using Indexes, Views and Stored Procedures. Hands in Query Tuning and Performance Tuning.
• Extensively used derive column, data conversion, conditional split and Aggregate.
• Analyzed existing SQL queries to identify opportunities for improvements.
• Created optimal technical solutions to user needs with in-depth system analysis.
• Performed regular database backups to prevent information loss.
• Designed and implemented TSQL queries for reporting and complex solution development.
• Developed, implemented and optimized stored procedures and functions using T-SQL.
• Developed custom database objects, stored procedures and delivered application support.
• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
• Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.

Description:

Established in 1990 and headquartered at Bangalore, DTDC has 7 Zonal offices, 20 strategically located Regional Offices and over 430 operating facilities spread across India. DTDC Express Limited has its presence in more than 500 district headquarters through its large network of more than 10,500 franchisees and extends services to over 10,500 Pin codes while handling more than 12 million shipments every month.

DTDC Express Limited also has a significant global footprint and services 240 international locations including USA, UK, Canada, UAE, Hong Kong, Australia, China and all Asian countries, through its own operations, joint ventures and business associates. A key part of the success of DTDC's network is the contribution of its people. It comprises of a family of 35,000 people including employees, franchisees and their associates who are committed to its spirit of service.

Roles & Responsibilities:

• Worked with Drill through, for page navigations,
• Created Book marks and worked with Selection pane
• Extensively worked on Power BI personal Gateways and Enterprise Gateways.
• Created rich visualized Dashboards in Power BI.
• Writing multiple stored procedures, views and joins,
• Created charts like Lines, Pies, Bar, Scatter, Area, Tree map, Map, Filled map, Gauge, Funnel, Single Card, Multi row card, Slicer etc.
• Importing Custom Visuals from Microsoft Power Bi gallery as per client request.
• Have good Experience to Implement RLS as part of security.
• Working on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text, Monthly Reports.
• Created Views, SPs as per business requirements handed over to Seniors to Validate them
• Stored procedures created according to the requirement in terms of data retrieving

Description:

SevenHills Hospital are three private hospitals, operating under central management, in Mumbai, Maharashtra,and Visakhapatnam, Andhra Pradesh, India. The Vishakhapatnam branch opened in 1986 and the Mumbai branch in 2010. The Mumbai hospital was the result of an Rs.10 billion public-private partnership between Seven Hills and Brihanmumbai Municipal Corporation (BMC).

Role and Responsibilities:

• Created database and required Tables with business integration for Seven Hills Hospital as per Architecture document
• Created Views, SPs as per business requirements handed over to Seniors to Validate them
• Stored procedures created according to the requirement in terms of data retrieving
• Retrieving the data for reports and loading into Power BI to create visualizations and dash boards
• Business Goals: Power query, Power pivot, and Power view for creating the effective reports and dashboards in Power BI
• Publishing the reports into Power BI Service and sharing the dashboards to the Users.
• Used DAX expressions like Logical, Aggregate, and Time Intelligence & Date Functions to create business Calculations based on requirements.
• Worked on visual interactions using edit interactions to make few visual to effect data based on requirement.
• Created Row level security in Power Bi.
• Hands-on experience in Dashboard design on Power BI desktop, have done report creation using visualization on Power BI.

• Recorded information using word processing, dictation and transcription software and equipment.
• Accurately documented medical dictation to record patient care records.
• Assisted in maintenance of medical charts and/or electronic medical record filing, Op Reports, test results and home care forms.
• Followed all HIPAA rules and regulations regarding patient confidentiality.
• Documented patient medical histories, vitals and test results in electronic health records system.
• Transcribed and edited physician reports from dictation using NexGen Software.
• Applied medical terminology related to provider-specific treatments and techniques.
• Corrected grammar, spelling and syntax mistakes in medical records.
• Maintained security and privacy of records to protect patients and providers.
• Reviewed documentation for compliance with requirements and accuracy of information.
• Maintained 99.9% accuracy rate for spelling and content.
• Reviewed patient charts for accuracy, correcting grammar and syntax errors before submission to clinic.
• Referred to variety of medical sources to prevent mistakes in medical terms.

• Attended training associated with role to improve skills and boost speed.
• Assisted in maintenance of medical charts and/or electronic medical record filing, Op Reports, test results and home care forms.
• Followed all HIPAA rules and regulations regarding patient confidentiality.
• Performed qualitative analysis of records for accuracy, internal consistency and correlation of recorded data.
• Transcribed and edited physician reports from dictation using [FFT Software Platform].
• Documented patient medical histories, vitals and test results in electronic health records system.
• Maintained 99.9% accuracy rate for spelling and content.
• Reviewed patient charts for accuracy, correcting grammar and syntax errors before submission to clinic.
• Accurately documented medical dictation to record patient care records.
• Referred to variety of medical sources to prevent mistakes in medical terms.

• Maintained spreadsheets of Excel data across multiple systems while preserving exceptional data accuracy.
• Generated reports covering details about data, system operation, and error monitoring.
• Complied with data entry quotients to support time-sensitive project input milestones.
• Changed and replaced backup tapes regularly and performed detailed server backups.
• Maintained spreadsheets of data across multiple systems.
• Developed system maintenance schedule to prevent unnecessary downtime or avoidable interruptions.
• Recommended system improvements, accounting for budgetary concerns and performance requirements.
• Generated reports each month covering excel data.
• Produced tables, pivot reports and charts for use in key decision-making processes.

• Organized, sorted, and checked input data against original documents.
• Completed data entry tasks with accuracy and efficiency.
• Sorted documents and maintained organized filing process.
• Entered numerical data into databases with speed and accuracy using 10-key pad.
• Scanned documents and saved in database to keep records of essential organizational information.
• Communicated with supervisors and colleagues to process data quickly and resolve discrepancies.
• Entered data into various computer systems accurately using Microsoft Office Suite.
• Followed established procedures to enter and process data correctly.
• Developed and maintained databases to store customer information.
• Resolved discrepancies in data entry activities for accurate, complete jobs.
• Created spreadsheets for more efficient recordkeeping.

• Managed documents by organizing forms, making photocopies, filing records, preparing correspondence, and creating reports.
• Reviewed and updated students correspondence files and database information to maintain accurate records.
• Completed data entry tasks with accuracy and efficiency.
• Identified data entry errors and reported to necessary departments.
• Maintained files, records and chronologies of entry activities.
• Produced monthly reports with advanced Excel spreadsheet functions.
• Sorted documents and maintained organized filing process.
• Managed workflow scheduling, data entry, and accuracy verification for large data projects.
• Scanned documents and saved in database to keep records of essential organizational information.