Description
SUMMARY * Over 5 years of IT Experience as MS SQL Server Developer, and involved in Design, Development and Support of MSSQL Server for various business domains like Pharmaceuticals, HR, financial services and Health Care. * Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Experience in SDLC and Agile environments of project including requirement gathering, creating technical specifications, development and testing of end product. * Involved in Migrating MYSQL to SQL Server 2008 databases. * Experience in installing and configuring SQL Server [ ] [ ] SQL Server versions. * Experienced in writing complex SQL queries which involves multiple tables' joins, common table expressions (CTEs), user defined functions, indexed views, cursors and DDL/DML triggers for data consistency and data manipulation according to the business and configuration prerequisites utilizing T-SQL. * Experience in performance tuning using Index strategies, Data profiling and analyzing execution plans. * Experience with data modeling, entity relationship diagrams and data analysis concepts on data warehouse. * Experience in using features like logging, event handlers, configuration files and deployment of SSIS packages. * Experience in Data Migration processing including data loading from flat files to the database tables using SQL Loader. * Proficient in SQL programming, physical database design, and SQL Performance tuning, replication. * Used Erwin modeling tool for designing database objects. * Expert in creating and developing Power BI Dashboards in to rich look. * Maintain reports developed in PowerBI and implement changes as needed.
Work Experience
COMPANY | POSITION HELD | DATES WORKED |
---|---|---|
Levi Strauss | Sql Developer | 9/2013 - 3/2016 |
Vit University | Bachelor's Degree | 9/2013 - 9/2013 |