Msbi/power Bi Developer Resume
Tampa, FL
SUMMARY:
- 7+ years of extensive experience in SQL Server database development/administration, extensively worked in OLTP, OLAP environment & development databases as a Developer/DBA in different domains of Fortune 500 companies including Insurance, Utility and Retail Industries.
- Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2014/2012/2008 R2/2005.
- Experienced in BI Development and Deployment of SSIS packages from MS - Access, Excel.
- Experience in reporting services, Power BI (Dashboard Reports), Crystal Reports, SSRS using MS SQL Server.
- Proficient in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
- Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
- Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL server.
- Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2014/2012/2008 R2/2005.
- Experienced in programming Tasks-Stored Procedures, Triggers and Cursors using SQL Server 2014/2012/2008 R2 with T-SQL.
- Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
- Efficient in up gradation and migration from SQL Server 2005/2008R2 to SQL Server 2012/2014.
- Implemented Power BI Gateway different source to matching analysis criteria and further modelling for Power Pivot and Power View.
- Designed and Deployment of Reports for the End-User requests using Web Interface & SSRS.
- Experienced in database administration for MS SQL Server databases, and supported applications with efficient back-end processing.
- Creating SQL Server Jobs, monitoring Job Failures in SQL Server & Enhancement of SSIS packages.
- Expert in creating and developing Power BI Dashboards into rich look.
TECHNICAL SKILLS:
Languages: T-SQL, PL/SQL, C/C++, XML, HTML, CSS, VisualBasic6, VBScript, Java script, C#, PHP, .NET, VB.NET, ASP.NET.
Operating Systems: MS-DOS, Windows Server 2012/2008/2003/ XP/NT 4.0/98/95, UNIX, Linux.
RDBMS/Databases/Database Tools: MS SQL Server 2014/2012/2008 R2/2005, Oracle 11g/10g/9i/8i, TOAD 7.5, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database
Data Warehouse Tools/Technologies: SSIS, SSRS 2014/2012/2008 R2/2005
Data Modeling Tools: MS Visio, Fact & Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access.
Reporting Tools: MS Reporting Server (SSRS), Excel Power View, Crystal Report, Workday, Power BI, Tableau.
Microsoft Technologies: VB.Net, ASP.NET
PROFESSIONAL EXPERIENCE:
Confidential, Tampa, FL
MSBI/Power BI Developer
Responsibilities:
- Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
- Developed Logical and physical data model using ERWIN and mapped the data into database objects.* Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases and optimized the database by creating various clustered, non-clustered indexes and indexed views.
- Integrated custom visuals based on business requirements using Power BI desktop.
- Provided continued maintenance and development of bugs fixes for the existing and new Power BI reports.
- 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 Datawarehouse.
- Installed and configured Enterprise gateway and Personal gateway in Power bi service.
- Scheduled Automatic refresh and scheduling refresh in power bi service.
- Involved in data mart and wrote MDX/DAX queries to access data from OLAP cubes
- Involved in various stages including: Development, System Analysis & Design, Testing and Documentation.
- Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
- Extract data from SharePoint document library and load into Azure SQL server.
- Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute Sql Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
- Developed scripts to automate the daily and routine tasks.
- Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS and Created Summary Reports, Sub Reports for data visualization.
- Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representative for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
- Designed and architected of OLAP cubes to support business reporting and forecasting processes.* Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services and finally to Reporting service.
Environment: Power BI, MS SQL Server 2014, SSDT, C#, SSIS, Visual studio 2013, SSRS, DTS, T-SQL, Azure, Power BI.
Confidential, Morristown, NJ
MSBI (SSIS/SSRS) Developer
Responsibilities:
- Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
- Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR(Staging Database) to Data warehouse (SQL server).
- Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
- Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
- Applied various data transformations like slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
- Used ETL to extract files for the external vendors and coordinated that effort.
- Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage,
- ODS and Mart.
- Prepared ETL standards, naming conventions and wrote ETL flow documentation for Stage,
- ODS and Mart.
- Created common reusable objects for the ETL team and overlook coding standards.
- Created mapping tables to find out the missing attributes for the ETL process.
- Responsible for hiding and disabling attributes and attribute hierarchies.
- Created Schema Objects and Application Objects using MicroStrategy Desktop and Architect.
- Modified existing SSIS packages for new requirements and modified existing SSRS reports to add new columns.
- Generated SSIS packages based on metadata using BIML for applying code reuse, templates and patterns in ETL solutions.
- Performed Design Code reviews Unit testing and data validation of MicroStrategy reports.
- Developed Tabular reports, Crystal reports, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
- Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models
- Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
- Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
- Assisted in creating SQL database maintenance logs and presenting any issues to the database architects.
- Generated reports using SQL Server Reporting Services and deploying them using web applications onto the web servers.
- Created jobs on daily basis and schedule on every minute to update recent data by using SQL Server Agent jobs.
- Gather Business Requirements from Retail and CC&B stakeholders for new BSS processes.
- Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
- Involved in improving performance tuning on SSIS, and SSRS and involved in integration of the front end with the SQL Server backend.
- Acted as primary liaison for HRIS system requests and user support for ongoing data maintenance and issues
- Involved in power pivot modelling such as building and maintaining power views
- Provided tech team support for SDLC Data Warehouse
- Established Inner Join, Outer Join and created Indexes whenever necessary.
- Created score cards with advanced set of dashboards using MS Office Performance Point Server 2007
- Publish dashboards to SharePoint Site on Development, Staging and Production environments.
- Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profilerand Database Engine Tuning Advisor.
- Involved in creating calculated members, named set, advanced KPI’S for the cubes.
- Interacted with testing team to fix the defects raised during the testing period.
- Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
- Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
- Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs.
- Worked closely with the developers and testing team to resolve Bugs and defects.
Environment: Microsoft SQL Server 2008/2005, SQL Server Integration Services (SSIS) 2005/2008, SQL Server Reporting Services (SSRS), MS Excel, Microsoft performance point server, Power BI, Team Foundation Server, VSS 2005, Team Explorer, Scheduler.
Confidential, LA CA
SQL/SSRS Developer
Responsibilities:
- Involved in DataMart planning meeting with Project Manager, Business Analyst and Team members to analyze the business requirements and outlined the proposed solutions.
- Developed stored procedures for performing various tasks on databases.
- Implemented execution plan, indexes and dynamic SQL to optimize queries such as stored procedures and UDFs.
- Implemented error handling in procedures utilizing try-catch block, and raiserror.
- Created various data connections from data source to SSRS for report and dashboard development.
- Created parameterized reports, drill down reports & summary reports by utilizing SSRS.
- Created document map for easy navigation to the particular section of the SSRS report.
- Scheduled reports execution on daily basis in order to support the incremental load of the databases in SSRS.
- Developed best suitable user interface for management dashboards with Power Pivot.
- Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.
- Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
- Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
- Deployed and Tested (UAT) Reports in Multiuser Environment. Created RS Config Files and Ensure Report Security with Keys.
- Worked closely with QA team and helped them come up with test scenarios
Environment: SQL Server 2012, TSQL, SSDT, SSIS, SSRS, Erwin, CSS, MS Excel, Power BI, TFS
Confidential, Houston, TX
MSBI Developer
Responsibilities:
- Worked as a part-time SQL Server reporting services (SSRS) report developer.
- Created and updated stored procedures (SPROCS).
- Created and modified reports in Microsoft SQL Server Report Builder.
- Modify/create refresh jobs for SSRS reports.
- Also work with Transact-SQL.
- Involved in supporting, maintaining and improving our ETL Processes in SSIS for a temporary period.
- Wrote stored procedures using T-SQL and implemented them.
- Performance Tuning and Maintenance plan for consistency checks, backup/restore and Rebuild Indexes.
- Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.
- Created SSIS packages, staged data from different data sources into a SQL Server Database using SQL Server Integration Services.
- Worked to enforce consistency in data warehouse for naming conventions and data types
- Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on the requirements and converting them into technical specifications.