Sql Bi/ Power Bi Developer Resume
Orlando, FL
SUMMARY:
- Over 8 years of Database Design and Development experience on SQL server 2016 / 2014 / 2008 & SQL Server 2000 in OLTP and OLAP environment.
- Expertise in generating reports using SQL Server Reporting Services (SSRS) 2014/ 2008/2005 and Tableau .
- Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
- Expert in Ad - hoc reports, drill down and drill through reports, sub reports and cross tab reports.
- Expert in creating Dashboards and using different types of Gauges .
- Expert in creating SSRS reports using Bar charts, Line charts, Pie charts.
- Expert in all the Latest BI Tools Tableau , Power BI Dashboard Design .
- Experience in developing and monitoring SSIS Packages and DTS packages.
- Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2012/ 2008/2005
- Experience in implementing Change Data Capture and Table partitioning
- Designed and created OLAP cubes on data warehouse.
- Designed and developed SSIS ETL/ELT Packages (SSIS 2008/2014/2016 ).
- Designed a partitioning strategy to refresh cubes effectively.
- Expertise with T-SQL in writing complex queries, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and maintaining data integrity.
- Experience in using tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
- Experience with the .NET framework including C#, ASP.NET and Web Service.
- Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
- Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
- Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
- Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
- Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
- Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries and DAX expressions, OLAP Cubes and SSAS Tabular Models, and deployment and processing SSAS objects.
TECHNICAL SKILLS:
RDBMS: MS SQL Server 2016/2014/2012/2008 , Oracle 8i/9i, MS Access.
Database Tools: SSIS, SSAS, SSRS, Enterprise Manager, Query Analyzer, SQL Profiler, Management Studio, SharePoint 2007, COGNOS 6.5/7.0, Crystal Reports 9.0/10, Power BI, Tableau Reports
Programming Languages: SQL, TSQL, VB.NET, XML, C++, VB 6.0
Scripts: JavaScript, VBScript, HTML, DHTML and XML
Web Tools: MS-Front Page, Macromedia Suite, IIS, Outlook Express
Applications: Microsoft Office, Visio, and Visual SourceSafe
Operating Systems: Windows 9x/NT/2000/XP. Unix
PROFESSIONAL EXPERIENCE:
Confidential, Orlando, FL
SQL BI/ Power BI Developer
Responsibilities:
- Worked in creating Stored Procedures, Triggers, Functions, Indexes, Tables, Views for applications.
- Designed and developed databases for OLTP and OLAP Applications.
- Implemented process to import Google Analytics data and Google AdWords data into Data warehouse system.
- Implemented ETL process to download files by email attachments and import data into Data warehouse system through SSIS packages.
- Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
- Configuring Power BI Gateway for SSAS Live connection and DirectQuery.
- Worked on several types of SSIS control tasks like WMI data task, MSMQ task, Web service task, Script task, Ftp task to upload and download files, worked with several types of connection managers like file connection manager, flat file connection manager, cache connection manager, ftp connection manager and data quality connection services manager. Also, used XML task to validate XML files and XSLT for generating html pages from XML.
- Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
- Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
- Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
- Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports and Dashboards.
- Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders.
- Implementing SSRS solutions, used dashboards and gauges to enhance for the business users.
- Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes.
Environment: SQL Server 2008/2014/2016 , SSRS 2016/2014/2008 , SSIS 2008,2014,2016 SSAS, Power BI, T-SQL, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP
Confidential, Houston, TX
Power BI Developer
Responsibilities:
- Upgraded database tables from 2005 to 2008 and 2014.
- Worked in creating Stored Procedures, Triggers, Functions, Indexes, Tables, Views for applications.
- Designed and developed databases for OLTP and OLAP Applications.
- Extensively worked on Table Design creating Clustered Indexes, NonClustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
- Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- Troubleshooting performance issues and fine-tuning queries and stored procedures.
- Implemented Change Data Capture and Table partitioning on data warehouse and DataMart systems.
- Worked on different types of control tasks of SSIS like WMI data task, MSMQ task, Web service task, Script task, Ftp task to upload and download files, worked with different types of connection managers like file connection manager, flat file connection manager, cache connection manager, ftp connection manager and data quality connection services manager. Also, used XML task to validate XML files and XSLT for generating html pages from XML.
- Designed and developed SSIS ETL/ELT processes (SSIS 2008/2014).
- Design and Develop new SSAS Tabular Models.
- Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
- Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
- Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012.
- Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
- Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
- Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
- Configuring Power BI Gateway for SSAS Live connection and DirectQuery.
- Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Extensive use of Pivot Tables and Power Pivot Excel for reports.
- Imported data from different sources like csv, excel and directquery to sql server/analysis database and used good visualizations and industry standards for creating Power BI reports and dashboards.
- Implemented Row-level security (RLS) on Power BI reports.
- Developed reports using Tableau and qlikview.
- Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS).
- Developed reports in Tableau, Crystal and converted Crystal reports in to SSRS reports.
- Experience in strong SQL debugging skills, application level troubleshooting skills.
- Create SSAS Tabular Model and SSAS Cube Model and support the existing database components
- Worked on OLAP Data warehouse, Model, Design, and Implementation.
- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
- Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
- Created standard report Subscriptions and Data Driven Report Subscriptions.
- Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Environment: SQL Server 2005/2008/2014 , SSRS 2014/2008/2005 , SSIS 2005,2008,2014, SSAS, power BI, T-SQL, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP
Confidential, Cleveland, OH
SQL/SSRS/SSIS Developer
Responsibilities:
- Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
- Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders.
- Implementing SSRS solutions, used dashboards and gauges to enhance for the business users.
- Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes
- Worked on Development and implementation of SSRS reports and ran them as per the requirement.
- Created gauges and used gauges as Key Performance Indicators.
- Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.
- Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
- Created SSIS Packages to integrate data coming from Text files and Excel files.
- Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
- Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS .
- Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
- Defined the report layout in SSRS and Dashboards.
- Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
- Generated daily, weekly and monthly reports for the managers.
- Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services ( SSAS ).
- Designed a partitioning strategy to refresh cubes effectively.
- SSAS cube development in both SQL 2005 and 2008 for financial planning and operational performance metrics.
- Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
- Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
- Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
- Implemented Logging and Event Handlers on SSIS packages for trouble shooting application.
- Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube’s data.
- Involved in writing MDX queries and performance optimization of the SSAS cubes
- Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS.
Environment: SQL Server 2005/2008/2014 , SSRS 2014/2008/2005 , SSIS 2005/2008, SSAS, T-SQL, Crystal Reports, T-SQL, Excel, Access, Windows 2000/XP
Confidential
SSAS/SSRS/SSIS/SQL Developer
Responsibilities:
- Provided support to 75 database Servers. Support included Production, QA and Development
- Worked on Migration from SQL Server
- Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003
- Wrote complex T-SQL Scripts for generating reports
- Wrote stored procedures and designed triggers
- Scheduled Backups of databases and recovered them periodically to verify integrity of Backups
- Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
- Involved in performance tuning issues by running Profiler Trace and analyzing the output
- Ensured Security by defining access control to data
- Generated reports using SSRS
- Designed and developed DTS packages for data import and export
- Configured Linked Servers
- Worked on OLAP and OLTP
- Interacted with development and testing team
- Importing and exporting of Databases using various techniques like BCP, DTS
- Analyzed and Installed Security patches as required.
Environment: SQL Server 2000/2005, .NET Framework, ASP.NET, ADO.NET, WINDOWS 2000/2003
Confidential
SQL Developer
Responsibilities:
- Implemented the database for production and marketing purpose.
- Designed databases for OLTP applications
- Created tables, indexes and constraints.
- Created Triggers, Stored procedures for implementing the business logic.
- Managed Database files, transaction log and estimated space requirements.
- Configured and monitored database application.
- Designed and implemented several complex reports
- Designed VB forms using the forms and crystal reports were made for business reporting purpose.
- Created stored procedures for module integrity and application.
- Wrote database triggers in T-SQL to check the referential integrity of the database
- Managed ongoing activities like importing and exporting, backup and recovery.
Environment: SQL server 2000, Visual Basic 5.0, Win NT.