Description
Professional summary: * Over 3 and half years of IT experience in Database Administration, Design, Development, System Administration and Support of MS SQL Server 2014, 2012, 2008, 2005 in an Enterprise environments. * Expertise in the SDLC cycle to Design, Develop, and Unit-Test and deploy the Software Applications. * Hands on Experience in installing, configuring, managing, monitoring and troubleshooting various versions of SQL Server. * Hands on experience with SQL Server and T-SQL in constructing Tables, Views, Indexes, Constraints, Triggers, User Defined Functions, Joins, Linked Servers, Stored Procedures, relational database models, data dictionaries, and data integrity. * Good knowledge in Performance tuning using SQL Profiler, Performance monitor. Hands-on working experience in Performance Tuning, analyzing query plans, usage of extended Stored Procedures, managing indexes, troubleshooting blocks and deadlocks. * Expertise in using BCP, Bulk Insert along with Format Files and Import/Export wizard for importing and exporting data into and out from SQL Server from various file types with various delimiters. * Expertise in generating reports using Crystal Reports and SQL Server Reporting Services (SSRS). * Experience in generating Drill through and Drilldown reports with Drop down menu option sorting the data, defining subtotals in SSRS. * Experience in Creation and maintenance of databases, creating roles and managing user permissions. * Possesses excellent skills in Data Modeling using Erwin, Star and Snowflake Schemas. * Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects. * Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions * Experience in Data warehousing concepts, dimensional, star schema and snow flake schema methodologies. * Excellent analytical, communication, organizational and presentation skills * Experience in designing ETL's from different sources like PostgreSQL, Redshift and salesforce systems using ODBC. * Participated in disaster recovery drills and real time disaster recovery failovers. * Developed numerous financial models, BI reports defined built countless key metrics, KPIs, scorecards chart rich reports using complex excel functions. * Experience in Microsoft Power Bi stack -power pivot, DAX, power view, power query, power map, OLAP cubes.
Accomplishments
Highlights:
Keywords
