SUMMARY

• Confidential Certified BI Developer with over 4 years of experience in SQL Server. Involved with professional group in development and maintenance process for enterprise - level databases in various projects.
• Seasoned experience in data modeling, database design, data quality management, trouble shooting and Business Intelligence (SSIS/SSAS/SSRS). Proven ability to deal with challenges dedicated, friendly, excellent team player, hardworking, fast learner and can work in stressful environment with excellent written and verbal communication skills.
• More than 4 years’ working experience in MS SQL Server/BI developers (TSQL/SSIS/SSAS/SSRS)
• Involved in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints
• Strong experience with data warehouse and ETL (Extraction/Transformation/Loading)
• Created SSIS packages with different control flow and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Proven ability in generating reports in SQL Server Reporting Services (SSRS). Designed various operational, drill-down, sub reports and parameterized reports and developed these reports using Global variables, Functions and expressions.
• Experience with SQL based reporting tools: SSRS and Crystal Reports
• Design and Develop new SSAS Tabular models and provide operational support to existing SSAS Tabular models to satisfy business requirements.
• Proficient with SQL Management Studio, SQL Server Business Intelligence Development Studio, SQL Profiler and Performance Monitor
• Used SQL Profiler, Execution Plans, DMV's, Database Engine Tuning Advisor (DTA) and Created Suitable Indexes for Query Performance Tuning and Optimization
• Involved in monitoring database maintenance plans for checking database Integrity, Rebuilding, Reorganizing Indexes, Shrinking Databases, updating statistics, Creating and Scheduling SQL Server Agent Jobs
• Highly experienced in creating complex Views, Stored Procedures, DDL/DML Triggers and User- Defined Functions (UDF), subqueries, joins to implement Business Logic and Data Protection
• Deep understanding and solid skills in MS SQL Server Log Shipping, Database Mirroring, Snapshot/Transactional/Merge Replication, Failover Cluster
• Possessed Excellent T-SQL Programming skills and effectively used Advanced Programming concepts like CTE's, Functions, Table Partitioning, Apply Operators, Table Valued Parameters, Output Clause, Merge Statement, Pivot, XML, Dynamic SQL, Table Valued Functions etc.
• Worked with other team to develop web server application using Agile Development
• Experienced in database migration and upgrade from SQL Server 2005 to 2008 and 2012.
• Experience in installation and configuration of MS SQL Server
• Experience in Migrating SQL Server 2008 to SQL Server 2012
• Excellent communication and interpersonal skills, self-motivated, quick learner and determined to learn new technologies, strong team player with excellent interpersonal skills
• Environment: SQL Server 2012 and 2008R2 Enterprise Edition, VB.NET, T-SQL, MDS 2012, MS Access, MS Excel, & Windows 2008 server, Linux, Business Intelligent technologies (SSIS, SSRS, SSAS), Data Quality Services

TECHNICAL SKILLS

• M S SQL Server 2008/2008R2/2012, MS Access T-SQL, Visual Basic, PowerShell, C#
• Confidential SSRS/SSAS/SSIS, Visual Studio/ SharePoint/Agile
• GIT / Subversion / JIRA / Rally
• FTP, Samba, DNS, Firewall, VPN, VMware

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. Confidential SQL Database Developer

Responsibilities:

• Created ETL packages using SQL Server SSIS to extracted data from flat file, reformat the data, and insert the reformatted data into fact table, loaded dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio (BIDS).
• Used various SSIS transformations such as Conditional Split, Derived Column, and Lookup which were used for data scrubbing, data validation checks during staging, before loading the data in the data warehouse
• Developed end-to-end system design for specific data warehouse applications to meet business goals
• Created various jobs to monitor resources on various servers and send an alert mail when threshold is surpassed
• Developed projects using SQL Server 2008/2012 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships
• Modified cube and dimensions and added new measure groups and dimensions
• Created data-mining solutions in BIDS, deployed them to SSAS instance, trained the model and queried the model using MDX. Deployed KPIs on SSRS and created different metrics
• Prepared reports including tabular, matrix, conditional, drill-down, list, charts, Sub Reports and multi parameterized reports using SSRS allowing users to filter
• Created MS SQL server objects like tables, views, stored procedures, functions and triggers
• Extensively used joins and common table expressions to simplify complex queries involving multiple tables
• Used Performance Monitor and SQL profiler to optimize queries and enhance the performance of database servers.

Confidential

Confidential SQL Server DBA/Developer

Responsibilities:

• Analyzed long running queries using execution plan and profiler and fine-tuned to optimize application and system performance
• Rebuild Indexes and Tables as part of Performance Tuning Exercise.
• Developed Confidential SQL Server objects (stored procedures, views, scalar-valued and table-valued functions etc...) using T-SQL
• Extracted large volumes of data from different data sources and loaded the data into targeted destinations/Data Warehouse after applying some transformations using SSIS/DTS
• Involved in creating packages in SSIS Designer using various control flow tasks and data flow transformations to implement Business Rules.
• Used checkpoint, break point and Logging in SSIS to debug and optimize package while developing
• Designed reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Generated variety of business reports using SSRS including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint 2010
• Actively involved in generating tabular, matrix, sub reports and complex reports with multi value parameters for the analysis of Performance
• Installed, upgraded and configured Confidential SQL Server 2008,2008R2 and 2012.
• Upgraded SQL server databases from 2005/2008,2005/2008R2
• Troubleshot production issues, performed root cause analysis and implemented sound technical resolutions in a timely manner
• Assisted on planning and implementing HA and DR strategies (backup, mirroring and replication)
• Create and configured SQL Logins and Roles as a part of Security Policies for various categories of users
• Developed Confidential SQL Server objects (stored procedures, views, scalar-valued and table-valued functions, cursors etc..) using T-SQL