Msbi Developer Resume
IL
PROFESSIONAL SUMMARY
- About 7 years of experience in IT, as MS SQL Server Database BI Developer in Windows environment, current experience with SQL 2012/2008 r2/2008/2005.
- Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
- Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SQL Server SSIS 2008.
- Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
- Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.
- Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008.
- Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
- Experience in Performance Tuning and Query Optimization.
- Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
- Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
- Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
- Experience in creating and managing fragmentation of Indexes to achieve better query performance.
- Expert in creating the cubes and dimensions in SSAS.
- Extensive Experience in creating different types of reports like Drill down, Drill through, Parameterized etc.
- Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
- Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
- Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
- Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
- Good experience on Qlikview Business Intelligence reporting tool for developing dynamic reports.
- Hands on experience in developing QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar etc.
TECHNICAL SKILLS
Databases: SQL Server 2012/2008/2008 R2, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g, MYSQL, Data warehouse.
Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.
Languages: T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA, MS SharePoint
Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP
Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)
Operating Systems: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0
PROFESSIONAL EXPERIENCE
Confidential, IL
MSBI Developer
Responsibilities:
- Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
- Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
- Designed Data Mapping documents, DDL scripts, Data Dictionary and meta data of the models and maintained them.
- Developed SQL scripts for administration task.
- Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
- Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
- Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
- Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
- Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
- Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule DTS/SSIS Packages.
- Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
- Developed SSIS packages for File Transfer from one location to the other using FTP task
- Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
- Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
- Generated ad-hoc reports using MS Reporting services and Crystal reports.
- Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
- Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
- Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS
- Created Multi-Dimensional Cubes using SSAS for the Data Warehouse.
- Created Production Deployment Scripts for SSAS Cube & Roles
- Developing OLAP cubes by identifying tables (fact and dimension), data source and data source views attributes and dimension members using SQL Server Analysis Services (SSAS).Created SSAS storage and partitions, and Aggregations, calculation of queries with MDX.
- Developed many MDX queries for creating measures that fits business logic.
- DefinedCalculated members,named sets, and executed other script commandsusingMDXexpressions.
- Conducted weekly Crystal Reports training session for the reports team.
- Developed a dashboard solution for analyzing STD statistics by building SSAS 2008 R2 cubes and Tableau
- Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
- Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
- Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
- Performed Documentation for all kinds of reports, DTS and SSIS packages.
- Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
- Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
- Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
- Created Linked Servers for data retrieval using OLE DB data sources and providers.
- Design and implementation of stored procedures and triggers for automating tasks.
- Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
- Created Views to reduce database complexities for the end users.
- Created Provided assistance to development teams on Tuning Data, Indexes and Queries.
- Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
- Created Functions, Stored Procedures, Database Triggers
- Created checks and constraints to maintain data integrity.
- Involved in De-Normalization of existing tables for faster query retrieval.
- Involved in development, enhancement, testing and performance tuning of the application.
- Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS).
- Ensured best practices are applied and integrity of data is maintained through security and documentation.
Environment: Windows 2003 Server/XP, SQL Server 2008 R2/2012, SQL Integration Services(SSIS), SQL Reporting(SSRS), Business Intelligence Studio, Visual Studio 2008 R2/2012, OLE DB, Crystal Reports, Erwin 4.0.
Confidential, NJ
Sr. Application Developer (SSIS\SSAS\SSRS)
Responsibilities:
- Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
- Created and developed database objects such as tables, indexes, views, procedures, functions, triggers and T-SQL code with proper grants to all the users and roles using SSMS 2008 R2.
- Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
- Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
- Wrote DTS scripts for data transfer and Involved in System testing.
- Involved in installation and configuration of SQL Server 2008 R2 with latest Service Packs.
- Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.
- Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2and Flat files.
- Experience in writing VB scripts in script component task.
- Used different Transformation in SSIS as per design specifications.
- Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
- Worked with building the hybrid data integration to SQL server 2008 R2where the data source were Access, Excel, Oracle from SQL server 2005.
- Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
- Involved in extracting the data using SSIS from OLTP to OLAP.
- Responsible for defining the complete Data Warehouse architecture (e.g. ODS, ETL process)
- Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 R2 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).
- Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
- Designed, developed and implemented the Dimension Data Model through multiple expert interviews for multiple fact tables.
- Configured Internet Information Services (IIS) and Deployed Reports and Analysis Project in to server.
- Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2.
- Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
- Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
- Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008 R2.
- Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports.
- Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
- Performed data transfers using BCP and BULK INSERT utilities.
- Performed performance tuning by studying Execution Plan, Analyzing Indexes.
- Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
- Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
Environment: MS SQL Server 2008 R2,SQL Server Management Studio (SSMS) 2008 R2,SSIS-2008 R2, SSAS, VB 6, OLAP, OLTP, Load Runner, SSRS-2008 R2, SQL Server Profiler, Visual studio 2008 R2, SQL Analyzer, Enterprise Manager and SQL Server Agent.
JP Morgan Chase, NY
BI Developer (SSRS/SSIS/SSAS)
Responsibilities:
- Created Cubes with multiple dimensions, measures, hierarchy, complex MDX queries, Key Performance Indicators as well as slowly changing dimensions.
- Developed perspectives to simplify the process of browsing the cubes
- Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables
- Created partitions of the Analysis Services cube to improve performance.
- Analyzed the xml data (XMLA) and transformed to access and SQL server database.
- Involved in taking backups of SSAS database and restoring them when needed.
- Created data driven subscriptions for different users using Report Manager.
- Designed and implemented stored procedures and triggers for automating tasks.
- Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
- Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
- Successfully migrated data between different heterogeneous sources such as InfoPath forms, flat file, Excel, Access Database and SQL Server 2005 using SSIS, BCP and Bulk Insert.
- Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, InfoPath files, text files and Excel files.
- Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
- Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder 2.0.
- Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
- Dealt with huge amount of data and used SSAS in order to retrieve the data
- Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
- Used scripting to automate the development using DOS, VB and PowerShell.
- Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
- Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
- Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
- Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
- Customized tables by importing them into a LINQ to SQL document in visual studio 2008.
- Used OLAP Processing Tasks for automatic processing of OLAP Databases
- Involved in Dimensional Modeling to design data warehouse.
- Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
- Identified the measures, dimensions and defined cubes to enable decision makers to drill through the detail data.
- Developed Access and SQL Database and wrote queries for data migration and Reporting Services. (SSRS).
- Experienced in developing and deploying SSAS cube.
Environment: SQL Server 2008 Enterprise, WindowsEnterpriseServer2003, SSAS, SSIS, SSRS, Server 2004, InfoPath, Access, Agile, Share Point Portal Server 2003, IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio, C#, ASP.Net 3.5, VB.Net.
Confidential
SQL Developer (SSRS/SSIS/SSAS)
Responsibilities:
- Work closely with management and end-users to create and evaluate business requirements.
- Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
- Used differentControl Flow Tasks and Data flow Tasksfor creating SSIS Packages. Designed packages using different types ofTransformationsfor Data Conversion, Derived Columns with Multiple Data Flow tasks
- Experience inError handlinganddebuggingcoding issues andtroubleshootproduction problems.
- Involved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.
- Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
- Experience in writing custom code expressions in SSRS.
- Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
- Created Report Models for Business Users to create their own reports.
- Designed & created OLAP Cubes with Star schema using SSAS 2008.
- Created Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
- Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Managed security and user access to Analysis Services cubes using creation of Groups and Roles by creating windows AD and also Perspectives within the OLAP cube.
- Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files.Also ensured that nightly backup jobs or cube processing or other ETL jobs didn’t interfere with each other. Managed SQL 2005 and 2008 databases and nightly SSIS Processes.
- Involved in Monitoringand troubleshooting complex packages by using Data Viewers Grids.
- Monitoring the scheduled SSRS and Crystal reports. Re-running the reports in case of any failures or data mismatches.
- Involved in deploying the changes to QA, Staging and Prod environments.
- Managed off shore team in Report migration project.
- Followed agile methodology and coordinated daily scrum meetings.
- Involved in Product Releases and support calls.
Environment: SQL Server 2005/2008, Windows Server 2003/2008R2, T-SQL, SSIS, SSRS, SSAS, Crystal Reports, Share Point 2010, BIDS