Prasanna Kumar Khuntia
Database and SSIS Developer
To be employed in an Organization where I can utilize my technical and analytical skills to enhance the database and reporting process and in developing software that will be helpful in boost the company’s productivity. CAREER SUMMARY
Overall 2+ years of IT experience in SQL, T-SQL/PL-SQL, ETL, BI and Data Analysis.
Having Good domain knowledge in HEALTH CARE SYSTEMS.
Having Good Knowledge in T- SQL programming: Written Store Procedure, Function, Views, Joins, and Sub Queries.
Existing data from diverse data sources were consolidated into uniform SQL Server database, ETL capabilities of SQL Server Integration Services were used to define imports of the data log data error exception etc.
Good exposure on advanced topics like Analytical Functions.
Strong understanding of Relational database, Proficiency in writing SQL Queries, Stored Procedure and Views in SQL Server.
Experience in maintaining one to many and many to one relationships while moving data between two databases.
Having knowledge in creating parameter, functions, web report and passing parameter through the link between the reports.
Involved in preparation of Technical Documentation of Various Modules.
Good interpersonal and Communicational skills, better understanding of client’s expectation and strong problem solving ability.
Ability to work with a team and independently.
Proficient in documentation, designing and developing database. PROFESSIONAL EXPERIENCE
Database Developer, Scalable Systems PVT. Ltd (Bhubaneswar) (July 2017 to till Date). TECHNICAL SKILLS
Programming Languages : SQL, T-SQL, PL/SQL
Databases Tools : SQL Server, ORACLE, MySQL
ETL Tool : SQL Server Integration Service (SSIS)
Operating Systems : Windows
IDEs : SQL Server Management Studio,
, SQL Server Business Intelligence Development
Studio Reporting/BI Tool : QlikView, SAS, PowerBI, Micro strategy, SAS VIYA QUALIFICATION
Master of Computer Applications in Ajay Binay Institute of Technology (ABIT), Cuttack at Odisha. Passing year 2017.
Scalable Systems PVT. Ltd
Duration: 01-June-19 to 24-Sep-19
Description: In this project we are Making Report for IntelliMRA (Healthcare Database) using
“PowerBI” BI Tool.
Designed and developed Dashboards in PowerBI for some modules like Vitals, Medication, Radiology, Microbiology, Orders, Payments etc.
Role: Database and PowerBI Developer
Team Size: 12
Database Tools: SQL Server Management Studio
BI Tool: PowerBI
2. Project Enterprise Data Warehouse and DataMart
Duration 15-May-18 to 03-May-19
Description: The project that we undertake aims to develop a business analysis based on Patient and provider data. We develop a new data warehouse. We extract data from Data Lake and load into RAW DB and from RAW DB we pull data into Staging area. In staging necessary cleansing taken place to move data to Warehouse. Responsibility:
Created packages using SSIS for data extraction from Excel Files, and OLEDB to SQL Server.
ETL, data profiling, Validation document for SSIS packages.
Involved in writing SQL Queries for Transformation.
Involved in Performance and Query optimization of the Database as required by the application.
Used event handlers to handle error.
Worked on Email notification, Deployment, creation of jobs and scheduling of Packages.
Worked on Project level connection and Parameter creation. Role: SSIS and Database Developer
Team Size: 15
Database Tools: SQL Server Management Studio and Sql Server Business Intelligence Development Studio ETL Tool: SSIS
Client: Bilingual Interactive
3. Project IntelliPayer
Duration 07-August-17 to 28-April-18
Description: This Project aims to develop reports on some modules of “Healthcare”. It helps the Hospital in generating Lab Reports, Vital Information, Intake Output Information and Discharge Information etc. for Patients along with Doctor assigned to Patient and detailed info related to Patient. Responsibility:
Created reports in QlikView Designer using Cross tab, Table, Banded Object, Sub report and Tabular etc.
Involved in writing Imported SQLs, Formulas, Queries and Parameter creation and its implementation.
Created Materialized and Virtual View in ILM.
Written Queries in IDV and Published reports in ILM Server. Role: Jr. Database and QlikView Developer
Team Size: 9
Environment: Informatica Life Cycle Management. (ILM) Database Tools: SQL Server Management Studio, IDV (Aqua Studio), DBeaver BI Tool: QlikView
Permanent Address : Bhadrak, Odisha- 756100
Date of Birth : 17 March 1995
Languages Known : English, Hindi and Odia
(Prasanna Kumar Khuntia)