Highly knowledgeable and experienced SQL Server Developer with 3 years of overall experience. Proactive professional with track record of success in developing solutions to ensure customer needs are met and satisfaction remains high with every project.
TECHNICAL EXPERTISE
- Experience with SQL, SSRS, SSAS, SSIS,
Power BI, Power Query and DAX
- Excellent knowledge in writing database objects (stored proc, views, triggers, functions, indexes etc.).
- Troubleshooting performance issues and fine-tuning queries whenever required.
- Developing and deploying ETL (Extract, Transform and Load) SSIS Packages for data integration and data loaded in to different SQL Server instances
- Ability to effectively develop new reports as well as troubleshooting existing reports and data queries
- Utilization of Execution plan, SQL server profiler and Activity monitor for troubleshooting activities in development.
- Developed various parameterized reports which were used for making current and future business decisions using SSRS.
- Ability to work independently or as part of team to accomplish business objectives.
- Experience in maintenance and administration of SQL server jobs.
- Ability to translate and plan resource requirements from high level specifications.
- Highly numerate, analytical and logical strong problem solving skills. To continuously learn and improve in every area that I engage.
- Experience working in an Agile environment
- Experience in setting up Replication and monitoring using replication monitor.
- Experience in setting up Mirroring where ever required by applications
