We provide IT Staff Augmentation Services!

Ms Sql Server/ Msbi Developer Resume

5.00 Rating

Detroit, MI

SUMMARY

  • 7+ years of extensive experience in IT industry, focused on ETL and reporting with MSBI suite(SSIS, SSRS)
  • Worked on the following versions of MS SQL Server 2012/2008R2, 2008/2005 as developer.
  • Experienced in full life cycle ETL development using SSIS
  • Extensive experience in creating many complex SSIS packages using SQL Server Integration Services using SQL server 2012/2008 R2/2005
  • Experience in Extraction and Migration of Data from heterogeneous data sources like flat files, CSV, Excel, MS Access, Oracle, XML &MS SQL Server using SSIS.
  • Experience with Data Visualization libraries/tools/toolkits like Tableau, PowerPivot, Power View Qlikview, OLAP and/or Tabular etc. hands - on experience in interactive graphics, data visualization, data mining and data analysis.
  • Experience in Creating, Populating and maintaining Data marts.
  • Develop ETL specifications, source to target mapping and other documentation required for ETL development.
  • Having knowledge on build cubes via SSAS using MDX and DAX.
  • Designs and develops Business Intelligence solutions using multidimensional cube cubes using SSAS
  • Expert in designing reports using SQL Server Reporting Services (SSRS).
  • Strong experience on an Agile/Scrum.
  • Experienced in generating on-demand and scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2012/2008 R2/2008 (SSRS).
  • Worked on complete Reporting Life Cycle on Authoring, Management & Delivery.
  • Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005 Reporting Services (SSRS).
  • Experience in Designing reports using Report Designer, Report Builder3.1, and Report Manager, creating parameterized reports & managing subscriptions.
  • Worked on Report Manager to subscribe reports, assign roles, user access with respect to security.
  • Experience in Reporting Conversion from Crystal Reports to SQL Reporting Services
  • Upgrade of Crystal Server product to current version, Install and configure Crystal Server (v2008) to 2013.
  • Strong in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, Triggers, User Defined Functions, Views, DDL/DML, TSQL Scripts and Batches.
  • Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client requirement.
  • In-depth understanding of all stages of software development life cycle (SDLC).
  • Excellent understanding and experience in Data Warehouse design (Kimball Group) of Dimensional Modeling, ETL Design and Dimensional and Facts Maintenance.
  • Experience in unit testing and support user acceptance testing and document test results.
  • Knowledge of Change Management procedures and source control tools.
  • Experience in using TFS like Team Foundation Server and Exchange and Team Foundation Version Control.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Data Tools, Oracle 11g

Operating Systems: Windows 2003/XP/VISTA/7

Databases: MS SQL Server 2012/2008 R2/2008/2005

ETL Tools: SSIS 2 008

Reporting Tools: SSRS 2012/2008R2/2005, Crystal Reports 9.0

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2010/2008/2005 , MS Office

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

MS SQL Server/ MSBI Developer

Responsibilities:

  • Involved in the Requirement gathering, documenting and delivered functional specification document to the project team.
  • Migrated data from Heterogeneous Data Sources and legacy system (Access, Excel) to centralized MS SQL Server databases using MS SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Create packages to validate, extract, transform and load data to a centralized MS SQL server from the existing diversified data sources.
  • Performed Data Cleansing by creating staging tables to eliminate invalid data using SSIS
  • Involved in performing incremental loads while transferring data from the legacy systems and using different data flow and control flow tasks in SSIS.
  • Maintained log tables and error logging tables to handle errors using event handlers.
  • Migrated packages from development server to production server using package configuration.
  • Extensively used MS SQL Server Reporting Services with relational data.
  • Created several reports using SSRS for the monthly claims and details of all locations.
  • Most of these reports had multi-level drill downs and charts.
  • Developed crystal reports to generate various reports.

Environment: MS SQL Server 2012/2008R2/2005, SSIS, SSRS, T-SQL, Visual Studio 2005, Crystal Report 9.0, MS Office, Windows2000/2003.

Confidential, McLean, VA

MS SQL Server / SSIS / SSRS / Developer

Responsibilities:

  • Developed and deployed packages, which extracted data using SSIS from different employee Data base systems and consolidated into the SQL Server 2008 R2, consolidated Employee DB.
  • Used various transformations while mapping the data from source to destination databases using SSIS.
  • Created data validations and integrity check by using staging tables before loading the data.
  • These were achieved using T-SQL stored procedures and some user defined functions.
  • Developed several reports for the HR department based on the Employee DB.
  • Identified and worked with parameterized reports in SSRS 2008 R2.
  • Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
  • Created Cross-Tab, Drill-down and Sub-Reports using SSRS 2008 R2.
  • Developed various reports using crystal reports
  • Modified functionality of crystal reports and formatted them to match exactly with the predefined styles.

Environment: MS SQL Server 2008 R2, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Micro Strategy 9.0, Crystal Report 9.0, T-SQL, Windows 2003, SQL Profiler, Query Analyzer, MS Office.

Confidential, PA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Involved in transferring old data from various sources like flat files, MS Access, and MS Excel into SQL Server.
  • The customer data from these systems were consolidated into a centralized SQL Server database to effectively generate reports.
  • Wrote complex Stored Procedure, Queries which were used in the ETL (SSIS) packages.
  • Was also involved in the database development creating Triggers, Functions, Indexes, User-Defined functions on the tables.
  • Prepared end user documentation, Technical documentation.
  • Gathered Requirements from the business users and created parameterized reports and ad-hoc reports using SSRS.
  • Involved in training to the end users to familiarize them about how to use the reports.

Environment: MS SQL Server 2008, MS Access, ASP.NET, MS SQL Server Reporting services 2008, MS SQL Server Integration Services 2008.

Confidential, Hartford, CT

MS SQL Server Application Developer

Responsibilities:

  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
  • Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
  • Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
  • As a team member developed several ETL packages using SSIS to load the data to the SQL server DB.
  • Worked with integration services for transferring data from diverse sources like Excel, CSV, Oracle, flat file.
  • Created several reports which had Drill down’s charts to break down the weekly, monthly and quarterly claims handling data.
  • Used scheduled subscriptions to deliver these reports to the user base via email.

Environment: MS SQL Server 2008, SSIS, SSRS

Confidential, SanFrancisco, California

SQL Server BI Developer

Responsibilities:

  • Created tables, functions and views according to business requirements.
  • Hands in rebuilding the indexes at regular intervals for better performance.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Extracted the data by using different predicates and joining different tables.

Environment: SQL Server 2005, 2008, SQL, SSRS, SSIS, Windows Server2003, 2008, Windows XP.

We'd love your feedback!