Senior Software Developer (May, 2015
–Jul, 2019) at TATA CONSULTANCY SERVICES, Mumbai
• Involved in daily Reporting of channel data as per there telecast on TV such as Programme, Advertisement, Vendor, Air time, Cost, Deal, Traffic.
• Performing SQL Queries for data Extraction. Create stored procedure as and when required to automate any task, Understanding and updating existing stored procedures .Creating Triggers, Function,View, Index as and when required . Joining multiple tables, writing T-SQL complex queries to get information for desired output . Performance tuning, Tracing the data using SQL Server Profiler.
• Create SSIS Package as per Requirements using Containers, Task and Transformation, for Data flow from Source to Destination. Handling EOD execution of packages. Scheduling SSIS packages by creating jobs using SQL server Agent. Migration of other ETL tool to SSIS.
• Create SSRS reports such as Parameterized report, Linked report, Drillthrough report based on client requirement using Data source and Datasets. Creating subscription and scheduling the report so that client can get updated reports on their Mailbox or Shared Location on specific time.
• Using Tableau for faster and better understanding of data by creating sheets and Dashboard, using Filters, charts,map .
• Involved in Data Cleaning, Data Categorization, Data Analysis .