Tapash Mandal

Experience

• 

  Charter Communications ( Previous Time Warner Cable)

  Mar 1999 - Nov 2016

  As a part of the Agile team, participated in backlog grooming, release and sprint planning, daily standup, impediment removal and delivering the final products to end user. • Achieved reporting automation through a combination of different types of SSRS reports including parameterized, drill down, crosstab reports.• Following the Agile Methodology, converted more than 800 reports from legacy environment to SQL Server 2014 environment and migrated nearly 200 SSIS package from 2008 R2 to 2014 environment• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.• Scheduled daily, weekly, monthly reports for executives, business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases. • Scheduled and maintained SSIS packages and batch jobs through SQL Server Agent. • Documented the data flow and the relationships between various entities.• Actively participated in user acceptance testing and debugging of the system. Show less Developed, scheduled and maintained ETL processes (using UNIX shell script and Oracle PL/SQL), Cognos Reports and BI eco system• Participated in requirement analysis, design, development and code reviews. Excellent in problem analysis and finding the best solution. • Using Report Studio and Scheduler, developed hourly and daily dashboard reports of sales activity to compare the sales activity on different day and time • Involved in Designing and modifying of Database objects like tables, index, triggers, packages, functions, procedures etc. Experts in query optimization using execution plans, hints, indexes, join etc.• Developed and supported Unix FTP /SFTP scripts and connection to upload data extracts to several 3rd parties and vendors’ site.• Experience in ETL techniques to extract, consolidate, analyze data from multiple sources and delivering final report using Cognos• Loaded data into Oracle table using SQL Loader Show less Using PL/SQL stored procedure developed several Datamarts for Cognos to help users become self-sufficient in the new web based Report Net after the upgrade of the reporting environment from desktop Cognos-Impromptu to web based Cognos Report Net. • Experience in Cognos Framework Manager, Creating Packages, Query Subject, Columns join• Created shell script for invoking SQL scripts and scheduled them using crontab• Helped users to create and schedule different types of reports in Cognos – simple list report to complex crosstab, prompted reports, multi-level query report, reports with pasted SQL code.• Created complex multiple query reports having joins and unions between different queries• Mid-level knowledge of Cognos administrative and security tasks Show less

  • Sr BI App Developer

    Jan 2013 - Nov 2016

  • Supervisor of BI Admin

    Jan 2010 - Dec 2012

  • Cognos BI Developer

    Jun 2002 - Dec 2009

  • RPG Programmer

    Mar 1999 - May 2002