Talent's Information
-
Location
Kolkata, India
-
Rate
$16.0 per Hour
-
Experience
12 Year
-
Languages Known
English,Hindi
Available for
Background Verification
40 Hr/Week
About Dev P
A performance driven ambitious software developer with an extraordinary blend of and technical knowledge. Ability to communicate and motivate team members to enhance strategic goals and bottom line objectives. Creative problem solving and troubleshooting skills complemented by meticulous attention to details that will result in the success of an organization by developing new applications or improving existing ones.
Tech Stack Expertise
-
Microsoft .Net
ASP.NET,PowerShell
6 Years -
C#
C#
5 Years -
Microsoft SQL Server
SQL,Microsoft SQL Server 2016
11 Years -
Python
Python
1 Years -
Azure
Azure Databricks,Azure Data Factory (ADF2),Azure Stream Analytics,AZURE Data Catalog,Azure Data Lake Gen2,Azure Data
9 Years -
Web Server
IIS 7
1 Years
Work Experience
Data Engineer
- January 2011 - December 2022 - 12 Year
- India
Projects
Data Engineering, Data Warehouse And Integration
- January 2020 - January 2021 - 13 Months
Technologies
- PowerShell
- Scala
- Azure Databricks
- Event Hub
- Azure Data Factory (ADF2)
- Azure Stream Analytics
- AZURE Data Catalog
- Azure Data Lake Gen2
Role & Responsibility
-
Client is looking for analyzing the IOT data which is coming and store in Blob storage (ADLS Gen2) on daily basis. As a Data Engineer I must get the data out of ADLS and process in Azure Data Bricks for transformation. Summarized data then goes to Azure Analysis services for data modelling. PowerBI fetch the data from AAS and present it as live connection to PowerBI reports.
Responsibilities
Senior DW\BI consultant\Architect and individual technical contributor role.
Work directly with clients to development a robust reporting platform.
Assess existing and available data base technologies and methods to ensure our Report Database ETL architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture. Data Modelling experience.
Created ELT process for Data consolidation before summarization which became source for DWH.
Data Warehouse And Integration
- February 2013 - January 2014 - 12 Months
Technologies
- SSIS
- Azure Databricks
- Azure Data
- Windows Server 2012
- Azure Data Factory (ADF2)
- Azure Data Lake Gen2
- Business Intelligence - SSAS
- Report Server
- CIS
- Catalog
- Microsoft SQL Server 2016
Role & Responsibility
-
Working on projects parallel manner. First project is integration project which is basically the data sync activity between salesforce and CRM online database.
Second project is related to retail client and they want to move into Power BI and data warehousing space. One more who want to replace SAS with Azure ML and want to visualize the output in Power BI. Also having good experience on google analytics and Digital Marketing Dashboard\Reports.
Senior DW\BI consultant\Architect and individual technical contributor role.
Work directly with clients to development a robust reporting platform.
Assess existing and available data base technologies and methods to ensure our Report Database ETL architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture. Data Modelling experience.
Create LLD, HLD, detail design, work on development.
Analysis & implementation of better performance strategies for integration.
Design complex ETL process.
Research, define and deploy BI improvement opportunities and streamline the business intelligence processes.
Data migration activity.
AzureML and PowerBI.
Created Business Apps by using PowerApps (with Flow).
Created ELT process for Data consolidation before summarization which became source for DWH.
Data Warehouse
- June 2013 - January 2015 - 20 Months
Technologies
Role & Responsibility
-
Data warehouse is basically started in nuance communication to provide the deep insight to CAC customer’s that after using their product how they are gaining in business. This helped the customer to get the Productivity and accuracy for their coder who does coding for ICD9 and ICD10.
Senior Software Development Engineer and individual technical contributor role.
Work directly with BA’s and Product Owner in understanding the information needs of the business and developing new ETL functionalities or tools to meet these requirements.
Created Dashboard POC in PowerBI, QlickSense and Tableau.
Finally, POWERBI approved and created various reports and dashboard.
Assess existing and available data warehousing technologies and methods to ensure our Report Database ETL architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture.
Create detail design, work on development and perform code reviews.
Analysis & implementation of better performance strategies.
Design complex ETL process.
Research, define and deploy BI improvement opportunities and streamline the business intelligence processes.
Data Warehouse(DWH)
- April 2015 - June 2016 - 15 Months
Technologies
Role & Responsibility
-
FIS is the world's largest global provider dedicated to banking and payments technologies. FIS delivers the most comprehensive range of solutions for the broadest range of financial markets and holds leadership positions in payment processing and banking solutions, providing software, services and outsourcing of the technology that drives financial institutions
Core Team member of Dataware house Development Team.
Support existing data warehouse reporting platform and applications to ensure operational availability and scalability
Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture.
Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
Help team member in case they face any problem during Development.
Generating Cubes by using SSAS and design complex ETL process.
Create detail design, work on development and perform code reviews.
Analysis & implementation of better performance strategies.
Developing SSRS Reports like Drill Down, Drill through, Gauge, Map, Matrix.
Online ERP
- April 2018 - January 2020 - 22 Months
Technologies
Role & Responsibility
-
Online ERP is basically related with Student Management system. Client has 300+ Centers all over India and needs a online systems through which client can able manage his entire centers. Online ERP able to get the status of every center. Centers needs to fill every details of student like Telephonic and Walk-In Enquiry, Admission or Fees collection, Course Up-gradation, Full and Final settlement, Issue of Books, Transfer Request. Student can see his/her status in particular center by using his/her Login details etc are the feature of this online system.
Entrusted with the responsibility of gathering and analyzing of the specifications provided by the client.
Used 3-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.
Involved in database design for every requirement.
Actively involved in the Design Reports using with Groupings and Conditions and Generate the Drill Through, Tabular, Matrix, Drill Down and Sub Reports in SSRS.
Developed application logic using C#.
Batch Management System
- February 2020 - January 2021 - 12 Months
Technologies
Role & Responsibility
-
Batch management system for maintain the Batch running for students in particular center.
Batch management system has following features.
Counselor is able to see the current status of running batch to book new student to particular batch at the time Admission.
Quality Control team member able to see the proper status of students that they are getting proper service from the respective centers or not.
Head Faculty able to see the proper activity of particular faculty taking his/her class on time.
Entrusted with the responsibility of gathering and analyzing of the specifications provided by the clients
Used 3-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.
Involved in database design for every requirement.
Actively involved in the Design Reports using with Groupings and Conditions and Generate the Drill Through, Tabular, Matrix, Drill Down and Sub Reports in SSRS.
Developed application logic using C#.
Soft Skills
Industry Expertise
Education
in B.Com
Kolkata University- June 2005 - June 2008
