Microsoft Bi Developer Resume
2.00/5 (Submit Your Rating)
Addison, TexaS
SUMMARY
- Professional, dedicated, and resourceful with proven success in developing with BI/EDW Applications SSIS, SSAS, SSRS. Demonstrated ability to analyze complex situations.
- Set goals and conceived strategies in meeting deadlines and produced several successful projects
- A Microsoft professional with 5+ years of total IT experience in the design, modeling, development, implementation, and support of SQL Server 2012/2014/2016
- Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
- Experience in using SSIS tool like import and export wizard, package installation and SSIS package designer.
- Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
- Experience in enhancing and deploying the SSIS Packages from development server to production serverby using package configurations.
- Experience in ETL process involving migrations and in sync process between two databases.
- Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with slowly changing dimensions.
- Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools, MS Access and Microsoft Visio.
- Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
- Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
- Expertise in creating Perspectives, Partitions, KPI and Design Aggregationsin cubes using SSAS TABULAR MODEL.
- Expertise in writing T - SQL queries, dynamic, sub-queries and complex joins for generation complex stored procedures, triggers, user-defined functions, views, and cursors.
- Extensive knowledge in database maintenance,SQLquery optimization & performance tuning using performance tools like SQL Profile, Index Tuning Wizard, and Database Engine Tuning Advisor.
- Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads
- Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
- Experience in creatingsnapshotsof reports to reduce theload on the server.
- Managedsubscriptionsto provide timely reports to the clients and end users.
- Extensive experience in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)
TECHNICAL SKILLS
Database Tools: SQL Server Management Studio (SSMS) 2012, 2014,2016.
BI Tools: Visual Studio 2017 SQL Server Integration Services (SSIS-ETL), SQL Server Analytical Services (SSAS), SQL Server Reporting Tools (SSRS), Power BI
MS Office: Windows 98,2000, XP, NT, 7, Vista, 10, 2010 MS Office Excel, Word, Outlook, PowerPoint
PROFESSIONAL EXPERIENCE
Confidential, Addison, Texas
Microsoft BI Developer
Responsibilities:
- Actively supporting application systems in operation, including tasks related to identifying and troubleshooting of application and data issues, including resolution or escalation of issues.
- Created Complex ETL Packages using SSIS to extract, modify, & clean the data as per business requirements.
- Directly working with DBA team to perform all kind of update and troubleshooting.
- Developed, deployed, monitored, and troubleshoot almost 300 SSIS Packages.
- Designed and Developed Database Objects likeTables, Stored Procedures, Triggers,Rules, Defaults, user defined data types andfunctionsfor this project.
- Developed, tested, and implemented Referential Integrityrules and regulations through constraints, triggers and views, partitioned views. Actively monitoring the performance tuning and troubleshooting for running code.
- Create, Maintain, Update and troubleshooting for all store procedure related with the Project.
- Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
- Created SSIS packages for File Transfer from one location to the other using FTP task.
- Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
- Used Check points to implement the restart ability of the packages inSSIS.
- Implemented Custom and System logging in SSIS using event handlers and execute SQL task.
- Deployed SSIS packages in SQL server Catalog and automated the packages
- Extensively working with SSRS report. Communicate with BA Team for any kind of changes and troubleshooting.
- Created SSRS reports using Report Parameters,Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
- Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
- Created reports with Analysis Services Cube as the data source using SSRS.
Confidential, Dallas, Texas
Microsoft SQL Server BI-SSIS-ETL/SSAS/SSRS Developer
Responsibilities:
- Generated database SQL scripts and deployed databases including installation and configuration.
- Design and Build Extract Transform Load procedures in SQL Server 2016 to import/export data feeds to/from data warehouse.
- Worked with SSIS to import, export, and transform the data between the linked servers.
- Involved in 2012 to SQL Server 2016 using Migration Wizard.
- Worked on Stored Procedures and Database Triggers.
- Tuned the database to perform efficiently by managing databases using the option grow or shrink database files and monitor the size of transaction log.
- Wrote various T-SQL stored procedures and Triggers to carry out various tasks
- Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
- Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server
- Used SQL Profiler and Query Analyzer to optimize queries and Stored Procedures.
- Extracted Data from various Heterogeneous Databases such as flat files to SQL server 2016 using SSIS.
- Create packages in SSIS with error handling as well as created complex SSIS packages using various data transformations.
- Implemented Custom loggingin SSIS using event handlers and execute SQL task.
- Deployed SSIS packages to file system, SQL server and automated the packages.
- Created User Interface reports for validating the Data through Reporting Services.
- Experience in creating reports using stored procedures. Involved in scheduling, creating snapshot and subscription for the reports and triggers to facilitate consistent data entry into the database.
- Proficiency in creating various types of parameterized reports such as drill-down, Drill-Through, Graphs, Charts and formatting using SSRS allowing users the ability to make selections before executing reports; thus, making them user friendly.
- Work with users and business analysts to design and develop tabular, matrix, gauges, chart, and drill down reports as well as interactive reports according to business requirements.
- Deployed reports to report manager and troubleshooting for any error occur in execution.
- Scheduled the reports to run on daily and weekly basis in report manager and email them to managers and analysts to review in excel spread sheet.
- Participate in Quality processes such as design reviews, peer code reviews and documentation.
Confidential, McKinney, Texas
MSBI - SQL/SSIS-ETL/SSAS/SSRS Developer
Responsibilities:
- Experienced in Business Intelligence and ETL implementation based on Microsoft SQL Server, Microsoft Integration Services (SSIS), Microsoft Analysis Services (SSAS), and Microsoft Reporting Services (SSRS).
- Data Warehouse Design and Implementation.
- Create and maintain clearly written technical, user, and system documentation.
- Worked with complex SQL, Stored Procedures, Triggers, and packages in very large databases from various servers.
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
- Used advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, Aggregations, Multicasting).
- Highly responsible for development and management of SSRS and SSIS projects.
- Extracting and Loading data into SQL Server Database using SSIS.
- Extensively involved in designing the SSIS packages to export data from SQL Server database to flat file source.
- Scheduling & Maintaining ETL packages in terms of data validation and consistency.
- Designing SSIS packages to migrate data from database (Hierarchical) to database (Relational).
- Created Mapping, Design, and technical Documentation for complex SSIS packages.
- Experience in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
- Involved in Maintaining Database with Backup, Restore Strategies and Scheduling those backups using SSIS packages as a Developer.
- Created the SSIS/DTSpackages and scheduled them using SQL Server agent.
- Deployed many packages on different servers using SSIS package Configurations.
- Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
- Designed and createdviewsfor security purposes, implemented rules, defaults, and user defined data types.
- Improved the performance of the slow running queries.
- Created parameterized reports for the users and clients, with drill-down, drill-through features.
- Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
- Created parameterized reports for the users and clients, with drill-down, drill-through features.
- Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
