Experience

Mactech Engg

• MSBI and sql developer



Mactech Engg

• India
• Industrial Machinery Manufacturing
• 1 - 100 Employee

• Software Engineer

  • Jun 2021 - Present

  Responsibilities: • Created SQL queries, views as needed. • Involved in creating Temporary tables, Table variables. • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio. • Developed UDF’s and Triggers required to execute the functionality. • Stored procedures were used to implement business rules. • Defined Check constraints, primary and foreign key relationships. • Developed SQL Queries to fetch data using Sub queries and Cte’s. • Used joins and set operators to get data from different tables. • Involved in backup and restore databases. • Designed Reports in SSRS for the product implementation. • Created Matrix reports, Parameterized reports, Sub reports, Drilldown reports and Drill through reports. • Involved in scheduling the subscription reports in report server. • Created reports using parameterized reports and cascading reports • Implementing and maintaining existing reports Show less