SQL Server MSBI Developer Resume

SUMMARY:

9+ years of experience in IT industry as a SQL Server MSBI Developer.
Working as a lead, as a senior developer, I am familiar with all phases of the development life - cycle and have contributed in project management, system design, business process dimensional modeling, testing, and documentation skills.
Worked through all the phases of Software Development Life Cycle (SDLC) including Requirements gathering, Analysis, Design, Development, Testing, UAT, Production and Post-Production Support.
Strong SQL Server 2005/2008/2012 Developer Skills including writing Stored Procedures, User-Defined Functions, Triggers, Views. Good understanding of Normalization /De-normalization and database design methodology.
Extensive experience in BI suite - using integration services (SSIS) for ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cube.
Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2008/2005.
Proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, multicast, Union All, Merge Join, Merge and Slowly Changing dimension to load data into SQL Server destination.
Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
Expertise in developing and extending MS SQL Server Analysis Services 2008/2005 (SSAS) cubes, data mining models, deploying and processing SSAS objects, and writing MDX queries.
Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
Extensively used tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning SQL Server
Excellent Knowledge in Database backup, Replication, recovery, restoration and Linked servers.
Fast learning capability can adapt to the n-tier development environment, experience in setting up and maintaining development and production environments with IIS, MS SQL Server 2005/2008/2012 .
Excellent communication, learning, problem solving and conceptual skills, ability to work effectively.

TECHNICAL SKILLS:

Operational Systems: Windows 9x/NT/2000/XP, 2003 Servers, UNIX

Databases: MS SQL Server 2005/2008/2012, MS Access, Oracle 9i, Oracle 10g

Database Tools: SQL Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS, Import/Export, SQL Client Configuration utility, Backup Server, Replication server, MS OLAP Services, Replication Tools, Erwin Data Modeler, SQL Server Management Studio, SQL Server Business IntelligenceBI Tools DTS, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), PowerBI

Development Skills: Transact SQL (T-SQL), PL/SQL

Languages: C, C++, Python, XML, Visual Basics 6.0, VB.Net, ASP

Methodologies: Data Modeling, Star Schema, Snowflake Schema, UML (Rational Rose).

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship