Description
PROFESSIONAL SUMMARY: * Over 8+ years of IT Experience MS SQL DEVELOPER and involved in Design, Development and support of MS SQL SERVER 2005/2008/2008R2/2012/2014. * Worked extensively on ETL development using Microsoft SQL Server Integration Services (SSIS) and Reporting solutions (SSRS), SQL Server Analytical Services (SSAS), POWERBI Desktop and Excel Reporting. * Experience in RDBMS & Data Warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse. * Strong understanding on Normalization/Data modeling. * Good understanding of (SDLC) software development life cycle process methodologies and principles like agile and scrum. * Experience in installing and configuring SQL Server 2014/2012/2008R2/ 2008/2005/ 2000 SQL Server Versions. * Experience in data warehousing dimensional modeling to define dimensions and fact tables using star schema and snowflake schema design based on the requirements. * Experience with SQL server and in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Data Dictionaries and Integrity. * Expertise in writing TSQL queries using joins, sub queries and cursors in SQL Server 2005, 2008, 2012 and 2014. * Experience in analyzing, designing, tuning and developing business intelligence database applications using MS SQL Server 2005/2008/2012 SSIS, Reporting and Analysis services. * Experience in High Level Design of ETL -DTS Packages & SSIS Packages-for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data). * Worked on SSIS Transformations such as Union, Union All, Data Conversions, Merge, Conditional split, Bulk Insert, Derived Columns, Control Flow using for loop Containers and Fuzzy Lookups etc. * Experience in creating XML data files using SSIS Script task (VB.NET.C#.NET). * Expertise working with PowerBI reports, Excel Reporting. * Expertise in creating effective Data Modeling and creating Relationships in Excel Data Modeling and PowerBI Modeling. * Proficiency in gathering business requirements through interviews, customer facing sessions, prototyping and observations. * Expert in generating Drill down/ Drillreports using SQL Server Reporting Services (SSRS) in BIDS. * Created complex dashboard using multiple data sources (like Oracle, SQL and Excel) and Custom Hierarchies to meet the Business requirements in Tableau. * Proficient in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance. * Worked with Team Foundation Server (TFS), perforce as the source for Version control and Project/issue management.
Accomplishments
Highlights:
Keywords
