Description
Professional Summary: * Having extensive experience as a SQL server Developer that includes Database Design and Development of SQL Server 2005/2008R2/2008/2012/2014 * Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T-SQL, relational database models, data dictionaries, and data integrity. * Excellent experience in developing complex Stored Procedures, Views and Indexed Views. * Efficient in creating joins and sub-queries for complex queries involving multiple tables * Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads. * Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages. * Proficient in Microsoft BI Tools and Tableau to generate reports and dashboards. * Expert knowledge of support agreements and their implied service levels * Expertise in Debugging, Error logging, Error Handling and Production support for SSIS. * Transformed data from various data sources using OLE DB / MS ACCESS connection by creating various DTS packages. * Expertise in creating Report Models for building Ad hoc reports using SSRS. * Very good experience in writing expressions in SSRS. * Experience with data analysis and data analytics tools including Microsoft Machine Learning * Experience with Big Data Technologies like Azure Data Lake/ USQL * Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS * Created Reports with complex formulas and to query the database for business Intelligence. * Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS). * Solid understanding of network protocols / technologies such as DNS, WINS and TCP/IP * Most possess the ability to effectively communicate technical options and recommendations to stakeholders * Experience working in an Agile/SCRUM SDLC environment * Experience in creating and deploying parameterized reports using power BI * Experience in creating hierarchies in Power BI reports using Data visualizations such as Bar charts, Line charts, pie charts, and forecast charts * Sound Knowledge in Troubleshooting anyperformance issues in SQL using DMV's and DTA. * Expertise in creating Cell Level Security in cubes using SSAS. * Expertise in using Data Mining tools Microsoft Analysis Services. * Expertise in implementing SQL Server Security and Process Control. * Expert knowledge of Help Desk tools and trouble ticket tracking processes * Proficient Knowledge with Database Backup, disaster recovery and Disaster recovery drill. * Expertise in scheduling and Creating Jobs, alerts and DTS Packages * Exposure to entire SDLC with knowledge of SQL and relational databases, including Object Oriented Analysis/Design skills * Driven, self-motivated, focused on project activities, strategy, and opportunities * Strong work ethic with good time management with ability to work with diverse teams and lead meetings
Accomplishments
Highlights:
Keywords
