Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, and Aggregation.
Unit testing the packages and deploying the Packages.
Creating the Procedures as Per SSIS and Report Requirements
As per the Client requirements developed the reports in the form of Matrix, Table, Drill Through. Drill down reports and Sub Reports.
Created tabular SSAS BI semantic model for Power BI Reporting.
writing T-SQL Queries, Sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
Involved in Azure Analysis Deployment of Tabular Model.
Worked with offshore teams to meet the client’s expectation and also help them with feedback on the product, which will actively contribute to the technology road map of the product and also liaise with them to resolve all support related issues with customers/prospects.
Worked as an Operations Manager in one of the Digital Marketing company based in Hyderabad, India, managing both Marketing Team and Development/ Production Team