Koel Biswas

Background

About Koel Biswas

A dynamic professional with 10+ years of total IT experience and strong technical experience in ETL, SSRS, SSIS, SQL, T-SQL, PanIntelligence, POWER BI. • Excellent SQL Scripting skills with expert knowledge of Join, aggregation, CTEs, Temporary tables, triggers, Optimizing performance through SQL best practices • Strong background in database querying and report writing. Transact SQL skills Stored Procedures, Functions and Views and working in Microsoft SQL Server. • Extensive knowledge in Azure Devops which contain GIT repositories,work items, builds and re- leases. GIT repository is used to manage and control source code. • End-to-end delivery of report solutions, including extensive knowledge of version controlling application Azure DevOps(using GIT),Team Foundation Server (TFS) and Report Builder 2012/2014. • Experience in Develop, Maintain and Enhance Management Information and Business Information Solutions, using SQL Server 2012/2014, Integration Services, Reporting Services, PanIntelligence, POWER BI. • Writing report specifications with the business to ensure requirements are clearly defined and signed off • Build and maintain Business Intelligence solutions and reports based on requirements, prototypes, models, and deployment methods • Build SQL scripts and/or stored procedures within Microsoft SQL Server environment used by the reporting tools. • Maintain reports (security, additional fields, report failures) • Participate in the design and requirements capture of new Management Information. Problem solves and debugs existing ELT processes. • Work with a BI visualization tool to present management information in a relevant and engaging man- ner. • Develop a framework that automates the production and visualization of recurring requirements. • Strong self-sufficiency and proactive approach towards responsibilities while working on Challenging projects. Strong Stakeholder management • Processing Ad-hoc data requests for internal stakeholders and external parties. • Working experience as part of an Agile Methodology following Delivery Team with Sprint Planning, Sprint retrospective, Demo, Stand-ups, training and empowering other team members on report building and report delivery methodology • Strong written and verbal communication skills. Able to work within a team or as an individual contributor. • Strong interpersonal and communication skills to facilitate gathering requirements from an interna- tional team with varying needs and expectations.