Resume

Sign in

Developer Data

Location:
Bhubaneswar, Odisha, India
Posted:
September 25, 2019

Contact this candidate

Resume:

Prasanna Kumar Khuntia

adaf0s@r.postjobfree.com +917*********

Database and SSIS Developer

OBJECTIVE

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.

PROJECT DESCRIPTION

Scalable Systems PVT. Ltd

1.Project IntelliMRA

Duration: 01-June-19 to 24-Sep-19

Description: In this project we are Making Report for IntelliMRA (Healthcare Database) using

“PowerBI” BI Tool.

Responsibility:

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

Client: INFORMATICA

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

Client: INFORMATICA

PERSONAL DETAILS

Permanent Address : Bhadrak, Odisha- 756100

Date of Birth : 17 March 1995

Languages Known : English, Hindi and Odia

(Prasanna Kumar Khuntia)



Contact this candidate