Msbi Developer Resume
Birmingham, AL
SUMMARY
- 7 years of experience as Microsoft Business Intelligence Developer involved in developing solutions using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
- Acquainted wif all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
- Expertise in developing SQL Server databases wif T - SQL for constructing Triggers, Tables (DDL), Joins, Cursors, User Functions, Views, Indexes, User Profiles, Relational Database Models (RDBMS), data dictionaries and data integrity.
- Hands-on experience wif Star & Snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
- Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
- Experienced in implementing various logic using objects like Tables, Joins, Views and Constraints using Data Definition Language (DDL), Data Manipulation Language (DML).
- Expertise in merging data from various Heterogeneous Data sources, populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
- Experience in Logical and Physical Database design & development, Normalization and Data modeling using ERWIN and SQL Server Enterprise Manager.
- Experience in designing and developing complex reports using Drill Down, Sub Reports, Cascading parameters, Drill-Through Reports, Parameterized Reports, Chart Reports and Ad-hoc reports for Business Users using SQL Server Reporting Services (SSRS).
- Experience wif SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard for monitoring and tuning MS SQL Server performance.
- Proficient in SSAS (Analysis services) functions like calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles wifin a cube.
- Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
- Designed and developed QlikView and Qlik Sense dashboards by extracting data from different sources like SQL Server, Excel files, Oracle, SAP, Flat Files, XML Files.
- Good Communication and interpersonal skills wif strong ability and experience in seeking solutions effectively in challenging environments.
TECHNICAL SKILLS
Operating Systems: Windows, Linux, Unix
Developer Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Visual Studio, BCP, Team Foundation Server (TFS)
ETL & Reporting: SSIS, SSRS, SSAS, Excel, Power View, PowerPivot, Tableau
Databases: MS SQL Server, Oracle, MySQL, MS Access
Database Modeling: MS Visio, Erwin
Languages: SQL, T-SQL, C, C++, C#, .NET, PL/SQL
PROFESSIONAL EXPERIENCE
Confidential, Birmingham, AL
MSBI Developer
Responsibilities:
- Responsible for gathering requirements, analysis, design, functional & technical specification, coding, testing and documentation of new module development.
- Used the Business Process Modeling (BPM) to GAP Analysis to bridge the gap between business processes.
- Created SSIS Package Configurations and maintained the Tables by editing the values of the variables as per the requirement.
- Developed the packages wif monitoring features and logging so dat audit information of the packages and their execution results are loaded in to the audit table.
- Worked on the row count transformation and Event Handlers control flow to populate the special Log tables wif high level SSIS package execution.
- Developed Informatica mappings for data loads, business rules development, data cleansing.
- Created and configured an OLTP replication database for disaster recovery purpose.
- Designed packages including direction of Data Flow, Column Mapping, Data Dictionary, Metadata Flat file Source & Destination, and OLEDB Source & Destination using SSIS.
- Created different Facts and Dimension tables to increase the performance of complex SQL queries dat are used in SSRS reporting.
- Involved in performance tuning of MDX queries for efficient reporting performance.
- Reverse engineered backend database to change the T-SQL scripts, create Views, Stored Procedures, Triggers and Functions to improve performance drastically.
- Developed services to store SQL Server data in to Cloud base data warehousing by using Microsoft Azure and Amazon Web Services (AWS) Redshift.
- Implemented data and storage management solutions in Azure, SQL Azure, Azure files, Queue storage, Blob storage
- Configured the Azure storage accounts to enable soft delete and enabling the Encryption for the data at rest by using the keys provided by Microsoft.
- Used TFS for maintenance and status of the developers for development of application.
- Created various types of performance reports from the TFS server database using SSRS.
- Created Non-Clustered Indexes on new servers for enhancing the performance of the queries.
- Created dashboards in Power BI using DAX expressions to deploy them using content pack.
- Responsible for monitoring SQL Error Logs, scheduling Tasks, Database Activity, and eliminating Blocking and Deadlocks.
Confidential, Edison, NJ
BI Developer
Responsibilities:
- Collected requirements from business users and transforming them into logical and physical database designs.
- Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
- Migrated tables from old data warehouse to new database for transaction history of the app.
- Created DAX calculated columns in power pivot worksheets to extract, import and join data dat coming from different sources.
- Developing SSIS packages dat upload multiple Flat files using For-Each Loop Container and other control flow tasks like File System task, FTP task, Send Mail Task, Script Task.
- Used Data Transformation Services (DTS) and ETL tools to populate data from various data sources, creating packages for different data loading operations for application.
- Gained understanding of OLAP processing for changing and maintaining warehousing optimizing dimensions and hierarchies and adding aggregations to cube.
- Involved in writing MDX queries and performance optimization of SSAS cubes for calculated members and measure groups.
- Responsible for Implementation of tagging on all the Azure resources to logically organize the resources.
- Created Docker Containers and managed Azure Container Registry wif Kubernetes Service.
- Responsible for incident management from job monitoring to Root-Cause Analysis to issues resolution.
- Responsible for performance tuning and optimization of stored procedures using SQL Profiler and Database tuning wizard.
- Worked wif QlikView & Sense objects like Multi Boxes, Straight tables, Combo charts, Pivot tables, Pie charts, Bar charts, Scatter charts, Containers, Line charts, Line objects, Buttons.
- Worked wif Qlikview dashboard and automated daily data loads of QVW documents using QlikView Publisher
- Migrated QlikView applications to production environments and handled performance tuning
- Created reports to retrieve data using function, views, stored procedures and T-SQL code using parameters.
- Designed and deployed report wif Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.
- Worked on deploying and scheduling Reports using SSRS and Tableau as well as triggers to generate all daily, weekly, monthly and quarterly Reports including current status.
- Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
- Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.
- Responsible for scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.
Confidential, SFO, CA
SQL BI Developer
Responsibilities:
- Involved in gathering requirements and analyzing the requirements related to the project.
- Wrote complex SQL queries involving multiple tables from different databases using Joins, Stored Procedures, Temporary tables, functions.
- Worked on Data Flow tasks like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
- Designed and implemented comprehensive backup plan and disaster recovery strategies to ensure high availability of data.
- Scheduled package execution using SQL Server Management Studio to execute packages on a daily and weekly basis.
- Developed SSIS ETL packages using data warehouse architecture model by creating fact tables role playing and conformed dimensions.
- Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
- Worked wif SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpaved Control Flow Transformations.
- Used SQL Server Package Configuration technique to make Dynamic configurations.
- Used Text Files/SQL Server Logging for all SSIS packages.
- Responsible for Analyzing requirements, designing, maintaining and updating data models using Erwin.
- Created package configuration in XML and used to deploy packages into SQL server.
- Identified the Issues dat occur during the package execution by redirecting the rows from source component to error output.
- Created data sources, data source views, dimensions, measures, measure groups, key performance indicators (KPI), perspectives, partition aggregations. And deployment and processing SSAS objects.
- As part of Business Intelligence and Reporting team, played a key role in Development and Maintenance of SSRS Reporting Environment.
- Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports, Created Complex Charts and Drill Down reports using SSRS.
- Created Views, Materialized Views to get the values dynamically using joins and other SQL queries from the multiple tables.
- Created MDX queries to retrieve data from the cube and also to display SSRS reports.
- Designed and developed SQL codes for Tableau Reporting.
- Manually ran SQL Jobs which generates the Weekly, Monthly and Quarterly reports after making sure dat the input data acquired or not.
Confidential, Kirkland, WA
SQL Developer
Responsibilities:
- Interacted wif business users for understanding and gathering business requirements and involved in project planning.
- Wrote complex stored procedures to get data from servers & generated reports on dat data.
- Performed data transfer from files in remote server to folders in another server using FTP.
- Generated various reports like Matrix reports, Tabular reports, and Drill down reports.
- Built the report models, created a wide variety of interactive reports for business users in SSRS and deployed the reports in various formats depending on the user requirements.
- Designed reports and tuned them for optimal performance when using Multiple Parameters.
- Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
- Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
- Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
- Managed the use of disk space, memory and connections.
- Prepared of project documentation.
- Worked wif application developers in data modeling.
- Created materialized views and normal views as per requirement.
- Imported data from PeopleSoft to MS SQL Server database.
- Developed wif a focus on structured query language, T-SQL, Stored procedures and triggers, automating and improving repetitive data tasks so they are more efficient.
- Reviewed and fixed issues related to pre-existing SQL queries, Ensured all database servers and Backups
- Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
Confidential, Westfield Center OH
SQL DBA
Responsibilities:
- Worked in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
- Performance Tuning of theSQLServerin OLTP, Web based, Production and Development environments including the usage of Performance Monitor and Profiler Trace to monitor, and use Index Tuning Wizard to create proper indexes.
- Identified the performance bottlenecks like CPU, Memory, and I/O and tuned and improved the overall performance of theserverfor many clients.
- Responsible for Setup and maintaining Log shipping, Mirroring Replication.
- Installed, Authored, Managed and Deployed Reports using SSRS.
- MonitoredSQLserverperformance on regular basis, and gatheird data for trending analysis.
- Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
- UsedSQLProfiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning ofSQLServerandSQLcode.
- Involved in improving the performance of SSRS reports to complete the report in a timely manager by debugging and indexing history tables.
- Utilized SSIS packages functionality to create complete ETL Process using scripts, stored procedure, Functions and Transformation of Data in BIDS.
- Responsible for regular database maintenance process and disk defrag procedures in Production environment.
- ConfiguredSQLServerswif appropriate settings to resolve various resource allocation & memory issues.
- Reviewed T-SQLcode written by developers to follow better standards, procedures to optimize for better performance before QA deployment.
- Installed, Configured, Developed and Deployed SSIS packages.
