SQL Server/T-Sql Developer Resume

SUMMARY

Seeking challenging assignments in Sql, T - Sql, Business Intelligence, MSBI, Power BI in a technology driven, growth oriented organization, which shall help me develop a rational approach to come out with efficient solutions to problems/challenges and also inherit a multidimensional learning curve with an assertive environmental ionization.
Flexible to work on any Backend(Database) Technologies.
6 years of Experience in Power BI, Sql, T-Sql, and SSIS, SSAS, SSRS has provided technical Knowledge in Sql queries, T/SQL Programming (Stored Procedures, Cursors, Functions, and Triggers etc.), performance tuning and Business Intelligence projects.
Working in Power BI Desktop, Power BI Service, Getaways and customized tooltip and Power Query to convert the data in desired format and creating visualizations.
Working on SSIS various tasks such as Control Flow (Execute SQL task, for each loop container, Data Flow task, File System etc.) And transformations such as FTP Task, Aggregate, Sort, Lookup, Fuzzy Lookup, SCD (Slowly Changing dimension), Merge join multicast, conditional split, derived column etc.
Worked on complex queries using Procedures, Functions, Cursors, Triggers and Performance tuning used majorly in projects.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

SQL Server/T-Sql Developer

Confidential

Responsibilities:

Regularly developed Power BI Report as per the HR Department demands
Developed SSAS Tabular Model and Imported in Power BI in Live connection mode to keep data updated in Power BI
Normalization done to reduce redundancy and populate data in the tables accordingly.
Designed and developed SSIS Packages for regular ETL load.
Generated multiple reports depending on required Similarity threshold using Fuzzy lookup.
Deleted approx. matching records manually depending on the fuzzy lookup reports to avoid repetition.
Developed complex stored procedure, cursors according to the need.

Confidential

Responsibilities:

Regularly developed Power BI Report as per the Need.
Connect Sql Server to Power BI in Direct Query mode.
Implemented Automatic Refresh and Getway in Power BI.
Developed SSAS Tabular Model and Imported in Power BI in Live connection mode to keep data updated in Power BI
Designed and developed SSIS Packages for regular ETL load.
Developed complex stored procedure, cursors according to the need.

Confidential

Responsibilities:

Take Backup in chunks every month before deployment in production.
Schedule Sql Server Agent to run the package on daily basis or schedule according to the change request.
Modification of SSIS package.
Detail analysis of excel sheets.
Finding the right error for package failures.
Running the package in Production by making site down.

Confidential

Responsibilities:

Database creation following 3rd Normal Form
Designed and Developed SSIS Packages
Automated process to execute SSIS Package on daily basis
Deployed packages to Production server
Conducted POC
Used Several Transformations like for each loop container, derived column, file system task etc.

Confidential

Responsibilities:

Designed and Develop Metadata Repository Import Methods.
Sql queries used to retrieve data in MEGA Application.
Expert Level hand on MEGA Application.
Different Integration sources like Erwin, Visio, Rally, Bizagi etc.
Conducted POC with every integration source.
Used Several Advance methods to integrate.
Responsible to integrate data from different sources as displayed in below diagram