Microsoft Bi Developer Resume
5.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 teh 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 teh 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 teh data from ETL Loads
- Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for teh Business Users.
- Experience in creatingsnapshotsof reports to reduce theload on teh server.
- Managedsubscriptionsto provide timely reports to teh 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 teh 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 teh performance tuning and troubleshooting for running code.
- Create, Maintain, Update and troubleshooting for all store procedure related with teh 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 teh 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 teh restart ability of teh 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 teh 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 teh reports.
- Created reports with Analysis Services Cube as teh 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 teh data between teh linked servers.
- Involved in 2012 to SQL Server 2016 using Migration Wizard.
- Worked on Stored Procedures and Database Triggers.
- Tuned teh database to perform efficiently by managing databases using teh option grow or shrink database files and monitor teh size of transaction log.
- Wrote various T-SQL stored procedures and Triggers to carry out various tasks
- Created indexes on teh columns recommended by query optimizer to improve teh performance of teh 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 teh packages.
- Created User Interface reports for validating teh Data through Reporting Services.
- Experience in creating reports using stored procedures. Involved in scheduling, creating snapshot and subscription for teh reports and triggers to facilitate consistent data entry into teh database.
- Proficiency in creating various types of parameterized reports such as drill-down, Drill-Through, Graphs, Charts and formatting using SSRS allowing users teh 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 teh 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 (me.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 teh 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 teh 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 teh performance of teh slow running queries.
- Created parameterized reports for teh 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 teh 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.
