KALYAN BISWAS

Roles and Responsibilities:

• Working as a Devops engineer to implement Infrastructure as code with Terraform and Ansible .Mainly responsible for integrating Terraform and ansible with Azure Devops.

• Creating yaml based pipelines for CI/CD purpose.

• Well versed with Azure Data Factory, Azure Databricks, Azure EventHub, Azure SQL DW.

• Implementation of Data Lake on Azure using Azure data Factory and pyspark on AzureDatabricks. Migrate the existing Data warehouse Environment from Teradata to Azure Cloud on SQL DW and Azure Data Lake.

• Responsible for architecting, designing, implementing and supporting of cloud based infrastructure and its solutions.
• Proficient in AWS services like VPC, EC2, S3, ELB, AutoScalingGroups(ASG), EBS, RDS, IAM, CloudFormation, Route 53, CloudWatch, CloudFront, CloudTrail.

• Experienced in creating multiple VPC’s and public, private subnets as per requirement and distributed them as groups into various availability zones of the VPC.

• Created NAT gateways and instances to allow communication from the private instances to the internet through bastion hosts.

• Involved in writing Java API for Amazon Lambda to manage some of the AWS services.

• Used security groups, network ACL’s, internet gateways and route tables to ensure a secure zone for organization in AWS public cloud.

SKILLS : AWS Infra & Web Services, Python.

Roles And Responsibilities includes:

• Experience as a primary Knowledge about SSIS,SSRS and SSAS and SharePoint (2013).

• Experience in ETL (SSIS) • Experience in SSRS – report development.

• Ability to execute SharePoint end to end administrative tasks, PowerShell & HTML knowledge.

•Imported and Extracted data from various sources such as flat file, access, SQL server and loaded those data into SQL server to build various reports.

• Maintain existing SharePoint environments: DEV, QA and PROD.

• Security maintenance within SharePoint • Perform typical system administrative duties such as community creation, daily monitoring, and performance analysis.

• Custom Web Part and Workflow Development.

SKILLS : MSBI and SharePoint 2013.

As a developer in Analytics stream and my responsibilities includes:

• Feature detailing and requirement mapping for BI solutions. ‑ Creation of logical and physical design of databases.
• Modelling of data to create reports and dashboards. ‑ Data integration of Analytics system with other end systems like Charging, DCRM, Billing and with other 3rd party vendors like Token/Weather Data etc.
• Design, develop and test the ETL packages using SSIS, knowledge about all the transformation tasks. Packaging and deployment of SSIS package on Production environment.
• Used logging, audit, checkpoint, containers, transformation task such as analysis services, script task, file system, lookup, conditional split, derived columns, merge, union and Slowly Changing Dimension, source and destination transformation.
• Design and development of multidimensional cube using SSAS, creation of calculated fields, KPIs, dimensional usage, partition creation. Packaging and deployment of SSAS package on Production environment.

As a Team Lead of the group, my responsibilities includes:

1> Requirement gathering and analysis, Development, Documentation, Code Review, Independent Unit Testing, Functional Testing & Design of reports.

2> 2rd line application support activities and interaction with end customers. Incident management, change management, problem management, RCA management etc. ASM activities.

3> Liaise with the client and different component teams.

4>Technical and functional knowledge sharing with the team members. Ensuring BT policies compliance and agile practices.

SKILLS : PL/SQL, UNIX.