We provide IT Staff Augmentation Services!

Msbi Developer Resume

Provo, UT

SUMMARY

  • Around 8years of experience in Data Modeling, Database Design, Programming, Development, and Implementation of Client - Server Applications & Database systems using SQL Server 2008/2008R 2/2012/2014.
  • Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
  • Extensive experience in using Microsoft BI studio products like SSIS, SSRS, SSAS for implementation of ETL methodology in data extraction, transformation, and loading.
  • Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
  • Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2008R2/2012/2014) Packages (Developing, Deploying, Scheduling, Troubleshooting, and monitoring) for performing Data transfers and ETL Purposes across different servers.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
  • Scheduling and Monitoring ETL Processes using SSDT and batch files.
  • Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
  • Expert in transforming complex business logic into Database design and implemented by creating Stored Procedures, Views, T-SQL Scripting and DTS
  • Experience in Oracle supplied packages and PL/SQL Development.
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008R2/2012/2014) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008R 2/2012/2014.
  • Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
  • Good knowledge of Data Marts, Operational Data Store (ODS), MDM, 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 multi-dimensional expression (MDX), Perspectives and Roles.
  • Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
  • Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
  • With the ease of TFS, managed user permissions among team projects and further made it easy to identify any missing permissions as well.
  • Created Scorecard/Dashboard pages in Performance point server (PPS)
  • Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
  • Hands on experience with SQL Server Management Studio and T-SQL in constructing triggers and tables.
  • Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming, and problem-solving skills.
  • Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box.
  • Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

  • SQL Server 2014/2012/2008 R2/2008
  • SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSAS), Data Transformation Services (DTS), Business Intelligence Development Studio (BIDS), SSDT
  • Performance Monitor, Backup Utility, SQL Server Management Studio, Query Analyzer, Enterprise Manager, Profiler
  • T-SQL, XML, VB.NET, C#, C,
  • Windows 8/10/ Windows 7/Vista

PROFESSIONAL EXPERIENCE

Confidential, Provo, UT

MSBI Developer

Responsibilities:

  • Developed T-SQL queries, scripts and stored procedures used for extracting, validating, transforming, and loading data provided by clients.
  • Respond to ad-hoc requests from Business Analyst and Project Managers by providing accurate data/reports in a timely manner.
  • Designed ETL packages to load the data from staging server to Data marts on Data warehouse.
  • Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
  • Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
  • Automated execution process, scheduling, deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and FTP.
  • Deployed SSIS packages with minimal changes using XML configuration file.
  • Created SSRS reports using complex SQL Queries/Stored Procs which have sub-reports, Drill-Down reports, and charts.
  • Created data sources, connection strings and defined the datasets for generating the report.
  • Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules as per the Client requirements.
  • Created the test data to test the performance and functionality of the SSRS Reports.
  • Created subscriptions to provide a daily basis reports.
  • Managed and troubleshoot report server related issues.
  • Created database objects like Procedures, Functions, Triggers, Indexes, DML and DDL changes.
  • Worked on monitoring and tuning of SQL scripts, Created Indexes for production database and supported it.
  • Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
  • Created copy-only backups from production environment and Applied to Test/Dev environments to test functionality on the latest data.

Environment: Microsoft SQL Server 2014/2012/2008 R2, SSIS, SSRS, Visual Studio/BIDS, SSDT, Windows 2008, C#, MS ACCESS, EXCEL, TFS, VSS

Confidential, Northville, MI

BI Developer

Responsibilities:

  • Creation, Development and Maintenance of SSIS Packages and SSRS Reports.
  • Responsible for designing and managing project specific ETL codes using SSIS and SQL Server 2008, 2008 R2,2012 fetching data across various source systems into Client specific Enterprise Data Warehouse.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle DB etc.)
  • Loaded the data into destination tables: both full and incremental load, by performing different kinds of transformations like row count, Look-up, derived column, merge, script task using SSIS packages and also performed with truncating, modifying and creating tables in data base as per requirements.
  • Designed databases to feed the data from monthly flat file data and automated the data load process.
  • Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
  • Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
  • Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
  • Automated execution process, scheduling, deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and FTP and Used SQL Profiler to optimize Stored Procedures.
  • Loaded fact and dimension tables as part of modified data warehouse solution.
  • Deployed SSIS packages with minimal changes using XML configuration file.
  • Worked extensively with SSIS to import, export and transform the data from xml and text files.
  • Used Execution Plan, SQL SERVER Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.
  • Created SQL scripts for tuning and scheduling. Performed data conversion from flat file into normalized data structure.
  • Created new SSIS Package to extract date from legacy to SQL SERVER objects using BIDS and Visual studio 2012.
  • Written with Complex Queries, stored procedures, Batch Scripts, Triggers, indexes, and Functions using T-SQL for SQL Server 2012.
  • Used DDL and DML for writing triggers, stored procedures to check the Pre-ETL conditions and reconciliation of data.
  • Process SSAS cubes to store data to OLAP databases
  • Created SSRS Reports: involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters Tablix control and involved in Dashboard reporting, Share Point with Power View tool, TFS etc.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012.
  • Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Microsoft SQL Server 2012/2008R2/2008, SSMS, SSDT, SSIS, SSRS, SSAS, Visual Studio 2010/2008, SQL SERVER AGENT, C#, Windows 2008,MS-OFFICE.

Confidential, Riverwoods, IL

MS SQL / BI Developer

Responsibilities:

  • Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
  • Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
  • Migrated DTS packages from SQL Server 2008R2 to SQL Server 2012 as SSIS Packages.
  • Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
  • Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
  • Extensively worked with SSIS tool suite, designed, and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
  • Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
  • Handled Tableau admin activities granting access, managing extracts and Installations
  • Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
  • Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
  • Worked on Database Compression for different databases to save space across different environments.
  • Wrote many stored procedures for cleaning, manipulating, and processing data between the databases.
  • Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Created different Power Pivot reports as per the client requirement.
  • Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
  • Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
  • Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
  • Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
  • Repaired/recreated PPS reports damaged in the conversion process.
  • Worked on Filtered Views, views, and Base table integration between different Source systems.
  • Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs, and scripts.
  • With the help of TFS, managed repositories, build processes, testing infrastructure and lab deployment while easily collaborating and reporting status.
  • Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
  • Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
  • Interacted with vendors, developers, and customers to manage the business requirements.
  • Verified business requirements and functional specifications.

Environment: Windows2003 Advanced Server, ODBC, OBIEE, MS SQL Server 2008/2008r2/2012, TSQL, PL/SQL 11g, Informatica, Visual Studio 2008, SharePoint 2007/2010, QlikView, Lotus Notes, Oracle, SSRS, SSIS, Erwin.

Confidential

SSIS Developer

Responsibilities:

  • Understand the data requirements from the business analysts to analyze the source data and derive required datasets.
  • Designed and developed the ETL process (SSIS packages) to make the data available from various relational databases, excel, flat files etc., for analysis and reporting purposes.
  • Utilized multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union-all.
  • Created various types of reports like Tables, Matrix, List, drilldown and drilldown.
  • Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
  • Created OLAP Cubes using SQL Server Analysis Services 2008.
  • Created Database Objects like Tables, Views, Stored Procedures, Indexes and Triggers.
  • Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
  • Written the Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
  • Involved in for end-to- end testing, Data Validations and Reconciliation of the Data
  • Responsible for project documentation, maintaining scripts

Environment: Microsoft SQL Server 2008 Enterprise Edition, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Windows server 2003 and IIS 5.0, Visual Source Safe.

Hire Now