We provide IT Staff Augmentation Services!

Sql Server Msbi Developer Resume

4.00/5 (Submit Your Rating)

Norfolk, VA

SUMMARY:

  • A Microsoft Business Intelligence Professional with 6 years of experience in Programming, Development and Implementation of Client - Server Applications, and Database systems using SQL Server 2000/2005/2008 R 2/2012/2016.
  • Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation, and loading.
  • Worked on the entire software development life cycle(SDLC) including analysis, design, Programming, testing and documentation.
  • Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.
  • Experience in Logical and Physical Data modeling, data architecture designs.
  • Experience in Normalization and De-Normalization processes.
  • Experience in writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
  • Programming in SQL Server - Stored Procedures, Triggers, User-defined Functions and Views, Cursors, Performance tuning of Stored Procedures and T-SQL Queries.
  • Experienced in whole cycle of SQL server integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
  • Experience in providing Logging, Error handling and Custom Logging for SSIS Packages.
  • Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/20 /2014/2016 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2016/2008.
  • Good at Creating Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports. Very good experience in writing expressions in SSRS.
  • Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
  • Created interactive dashboards and reports with visualization using Power BI by pulling the data from SQL server and Excel spread sheets.
  • Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
  • Created, Maintained and scheduled various reports in Power BI like Tabular Reports.
  • Expertise in using Power BI and prepared dashboard reports for internal team progress tracking.
  • Good experience of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
  • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multidimensional expression (MDX), Perspectives and Roles.
  • Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities.
  • Wrote MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
  • Experience in Database Backup and Restore. Good Knowledge in Full Backup, Differential Backup and Log Backup.
  • Experience in creating Reports, Jobs, Alerts, SQL Mail Agent and Scheduling SSIS Packages
  • Supported team in resolving SQL Reporting services and ETL related issues.
  • Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile and sprint methodologies.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2005/2008/2010/2012/2014 , MS Access 2003/2005/2008/2010

Languages: SQL,Oracle MDX, C, ASP.NET, C#(.NET)

Web Technologies: HTML

Tools: and Packages: SQL Server Management Studio, SQL Server Business Intelligence

Development Studio: (BIDS), SSIS, SSRS, SSAS, Visual Studio .NET, Team

Foundation Server: (TFS), ERWIN 7.3/7.2, SNL Banker, Control M.

Operating Systems: Windows Vista/XP/ 2000/2003/2007/2008 , MAC, MS-DOS

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Power BI (Power Query, power Pivot, Power View, Power Map)

Application Packages: MS Office, VBA, MS Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, VA

SQL Server MSBI Developer

Responsibilities:

  • T-SQL development in database object creation and data manipulation with Tables and Views, User Defined functions, Indexes, CTE, Store procedures.
  • Developed stored procedures to generate weekly reports on provider data.
  • Wrote complex queries to generate reports on provider data to check the data quality in Facets.
  • Used RAM templates to load data into Production, QA, Development environments.
  • Designed ETL/SSIS packages to Extract data from heterogeneous sources like SQL server 2012, MS Excel, CSV files, MS Access and transform (provider data) and then load into Facets environments using SSIS.
  • Created various packages to generated pipe delimited flat files with dynamic datetime appended to it and sending the files over secure FTP to client destination.
  • Configured the SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
  • Implemented and executed SQL Server Integration Service packages to populate data from the various data sources, Developed packages for different data loading operations for many applications.
  • Created SSIS packages to load data by using For each loop Containers, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Data Conversion, Pivot Transformation, and Slowly Changing Dimension, FTP task, SMTP task
  • Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
  • Configured Dynamic Checkpoints to allow rerunning a package from the point of failure.
  • Implemented debugging of packages using Breakpoints, Checkpoints, Event Handlers and Loggings.
  • Created Tidal jobs and moving them to QA and Prod. Scheduled job in tidal according to client requirements.

Environment: SQL Server Data Tools (SSDT), SQL Server, visual studio (SSIS), Tidal

Confidential, Monterey, CA

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

  • Created T- SQL queries, stored procedures, triggers, views, Indexes, Constraints and user defined functions (UDFs) on various database objects to create, modify and/or maintain databases.
  • Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
  • Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.
  • Designed ETL/SSIS packages to Extract data from heterogeneous sources like SQL server 2012, MS Excel, CSV files, MS Access and transform (patient data, provider data) and then load into Data Warehouse using SSIS.
  • Implemented various SSIS tasks such as conditional split, derived column for data scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Identified slowly changing transformation, to maintain historical data in data warehouse.
  • Implemented Master/Child packages so only the master package needs to be scheduled which will in turn trigger the execution of other packages.
  • Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
  • Configured Dynamic Checkpoints to allow rerunning a package from the point of failure.
  • Implemented debugging of packages using Breakpoints, Checkpoints, Event Handlers and Loggings.
  • Worked on creating normalized logical and physical data models.
  • Reverse engineered the reports to identify the data elements, facts, dimensions there by building data models for new data warehouses.
  • Worked on creating various conceptual data models using ERWIN.
  • Created ETL process using SSIS to load the actual data from different core systems to the tested data warehouse.
  • Worked on SSIS Script component using Visual Basic Applications and C#, by creating generic C# components that can be used in the external packages in SSIS.
  • Modified the existing ETL Processes by altering the SSIS packages and enhanced their performance by altering the blocking transformations and sometimes replacing the blocking transformation with non-blocking transformations.
  • Also enhanced the performance of the SSIS packages by partitioning the extremely large tables and also by dropping clustered indexes on huge tables and while in the pre- execution phase and recreating them in the post execution phase.
  • Works on development and enhancement of SSAS cubes which are the data sources for the front-end reporting tool.
  • Wrote scripts using MDX Queries like for Addition of new calculations in reports and dashboards.
  • Created static reports using MDX queries and creating MDX base report definition and wrote MDX queries to extract data from data marts.
  • Worked on the integration of SSRS to share point there by increasing the SSRS reporting accessibility to wider range of users.
  • Created, Maintained and scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
  • Developed and maintained multiple Power BI dashboards/reports and content packs. Performed database backups and restores periodically along with refreshing various environments.
  • Converted MS Access Databases to SQL Server and created new ETL’s to automate the daily data load there by increasing the data accuracy and usage by more than 60% (Converted around 11 MS Access Databases).

Environment: MS SQL Server 2008R2, MS SQL Server 2014, SSIS, SSRS, SSAS, Visual Studio 2010, MS Excel, MS Access

Confidential, Irving, TX

MSBI/ETL Developer

Responsibilities:

  • Took over the designing of newer data warehouse and produced data models using Erwin. Considered different ways of approaching the designing of database and documented all the possible ways before building the data warehouse.
  • Discussed and documented the building of data warehouse at every step.
  • Exported the existing data from a legacy database to a newer database.
  • Optimized the existing stored procedures and automated them for various tasks.
  • Created new Database objects like Tables, Views, indexes and functions.
  • Developed a new set of complex stored procedures for newer business requirements.
  • Imported data from various sources like Excel, Access.
  • Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
  • Used SQL Server Profiler to trace the slow running queries and the server activity.
  • Developed ETL packages using multiple data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations.
  • Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
  • Participated in disaster prevention and recovery strategies.
  • Optimized the existing SSIS packages to fix various issues and improve performance.
  • Built SSIS Packages for processing fact and dimension tables with complex transforms.
  • Designed new SSIS packages to extract data from newer OLAP and OLTP sources and transferred the data to SQL Server using SSDT.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
  • Worked on troubleshooting various issues with the existing ETL process.
  • Provided documentation for SSIS packages and various other procedures.
  • Identified and worked with multi-value parameters for parameterized reports in SSRS.
  • Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports in SSRS.
  • Deployed Reports created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.

Environment: MS SQL Server 2012, SSDT SSIS, Visual Studio 2010, SSRS, SSAS, MS Excel, MS Access and Window 2008 R2, Erwin.

Confidential

SQL Server BI Developer

Responsibilities:

  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel Source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services.
  • Created/Migrated packages from DTS packages to SSIS 2005/ 2008 to SSIS 2012. Involved in Upgrade and Migration of SQL Server 2005/2008R2 in placed, side by side to MS SQL Server 2012.
  • Analyzed the business requirements and building logical and physical data models.
  • Developed new stored procedures and optimize existing ones.
  • Developed template scripts for users so they can generate their own daily/weekly/monthly reports.
  • Developed and implemented stored procedures and triggers for automation tasks.
  • Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL Server Agent.
  • Modify the existing SSIS packages to reflect the new business requirements.
  • Developed packages to create Error Fallout Reports, send Business and IT mails.
  • Created connection strings using various external drivers like Relativity Drivers or CONNX Drivers.
  • Apply various transformations like Slowly Changing Dimension (SCD), Multicasting, Union, Derived Column and Data Conversion.
  • Created dimension model for reporting system by identifying required dimensions and facts using ERWIN.
  • Used various advanced SSIS functionalities like complex joins, conditional splitting for better performance during package execution.
  • Developed Unit test plans for SSIS packages.
  • Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
  • Set up traces and use profiler to troubleshoot performance issues.
  • Created drill-down, drill-through and sub reports using SQL Server Reporting Services 2008R2.
  • Developed different chart reports for customers, based on the requirements.
  • Deploy the reports to the report manager and maintain the same providing necessary access to the users.
  • Created roles for the reports and assign them accordingly.
  • Developed UI mockups and ER diagrams using Visio and assisted teams working on Citrix and VMware.
  • Experience with Cognos Report & Dashboard Development experience

Environment: MS SQL Server 2008(R2), BIDS SSIS, SSRS, JIRA, Source Safe, Visual Studio 2010, C#.Net 2008 and Window 7, Windows Server 2008 R2, ERWIN, COGNOS

Confidential

Jr.SQL Developer

Responsibilities:

  • Gathered functional and Business requirements and wrote technical specifications for building the Global Enterprise Data Warehouse.
  • Implemented and maintained Database mirroring as a Disaster Recovery Solution.
  • Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles. Analyzed and prepared Statement of Work and Requirement Definition Document.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
  • Created packages for error handling, logging and custom logging to log the error information to SQL Server, Flat files and XML files
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications and adding scheduled jobs to re-index and update statistics in databases.
  • Involved in development activities included hardware and network specification, installation and configuration and participation in database design, architecture and SQL scripting.
  • Troubleshooting performance issues and fine-tuning queries and stored procedures.

Environment: MS SQL Server 2008/2005/2000 Enterprise Edition, SSIS, SSRS and Windows Server 2003, MS Access.

We'd love your feedback!