Ssis/ssrs/ssas/power Bi Developer Resume
DallaS
SUMMARY
- Over 8 years of Database Design and Development experience on SQL server 2016 / 2014 / 2008 in OLTP and OLAP environment.
- Expertise in generating reports using SQL Server Reporting Services (SSRS) 2014/ 2008/2005 .
- 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 several types of Gauges .
- Expert in creating SSRS reports using Bar charts, Line charts, Pie charts.
- Created reports in Tableau.
- 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 (SSAS) 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 , SharePoint 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 that 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, OLAP Cubes, and deployment and processing SSAS objects.
- Expert in all the Latest BI Tools Tableau , Power BI Dashboard Design .
- Experience in Azure PAAS, IAAS
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, 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, Dallas
SSIS/SSRS/SSAS/Power BI Developer
Responsibilities:
- Designed and developed SSIS ETL/ELT processes (SSIS 2016).
- Create reports and dashboards in Power BI and SSRS.
- Imported data from different data sources like SQL Server DB, Azure SQL DB to Power BI for Vetting Business users and published concerned reports to BI portal.
- Expertise in publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server.
- Worked on creating Stored Procedures for reports and for other applications.
- Created SSAS Tabular Model and SSAS Multidimensional Model and support the existing database components.
- Designed and Developed new SSAS Tabular Models and used DAX expressions/formulas for creating calculated measures and columns.
- Used SSIS packages to upload files into Azure Data Lake using Shell script and used External tables to retrieve data into data warehouse.
- Upload files using Blob Storage.
- Worked with Azure SQL Data Warehouse .
- Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
- Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
- Imported data from SQL Server DB, Azure SQL DW to Power BI to generate reports.
- Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
- Implemented both direct and import query methods in the power BI.
- Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
- Optimized the performance of existing TSQL queries with utilization of query optimization techniques such as indexes, table partitions, CTE's, execution plans, and made structural changes to queries.
Environment: MS SQL Server Management Studio 2014, SSIS, SSRS, T-SQL, Power BI Desktop, Power BI Dashboard, DAX Functions, Azure Data Lake(ADL), TFS, Visual studio Data Tools 2015,, .Net, C#, HTML.
Confidential, Los Angeles
SSIS/SSRS/SSAS/Power BI Developer
Responsibilities:
- Designed and Developed new SSAS Multidimensional Models.
- Involved in understanding the client's business processes and gathering technical requirement.
- Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes.
- Created SSAS Tabular Model and SSAS Multidimensional Model and support the existing database components.
- Designed and Developed new SSAS Tabular Models and used DAX expressions/formulas for creating calculated measures and columns.
- Create 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 /expressions.
- Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the various source to MS SQL Server with the help of MS SSIS.
- Assisted in design, build, verification, implementation and maintenance of ETL code / jobs based on business needs
- Configured Power BI gateways and reports to combine data from on-premises resources and SQL Azure databases .
- Coordinated teams to clean large data sets to develop normalized databases for clients in various industries
- Created Dashboard Reports to support end users using SSAS and Power BI.
- Conducted extensive data mining for various databases using advanced SQL for both clients and internal purposes.
Environment: SQL Server 2014/2012/2008 R2, SQL Server Integration Services, SQL Server Reporting Services, TFS and Power BI.
Confidential, Los Angeles
SSIS/SSRS/SSAS/Power BI Developer
Responsibilities:
- Worked on creating Stored Procedures for reports and for other applications.
- Worked on performance tuning to optimize stored procs.
- Checking Execution plans and optimizing stored procs.
- Created appropriate indexes to increase the performance of queries and stored procs.
- Designed and developed databases for OLTP and OLAP Applications.
- Gather requirements and design of data warehouse and data mart entities.
- Designed and developed SSIS ETL/ELT processes (SSIS 2008/2014).
- Designed and Developed new SSAS Tabular Models.
- Worked on several types of SSIS control tasks like WMI data 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.
Environment: MS SQL Server 2008/2012/2014 (Query Analyzer, SQL Profiler), SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), Power BI, Power View, Business Intelligent Studio, SQL Server Management Studio, ASP, Crystal Report, Erwin, T-SQL, MySQL, OLTP, Oracle 11g, Enterprise Manager, MS Excel, Windows XP Professional, TFS.
Confidential, Orlando, FL
SSIS/SSRS/SSAS/Power BI Developer
Responsibilities:
- Worked on creating Stored Procedures, Triggers, Functions, Indexes, Tables, Views for applications.
- Gather requirements and design of data warehouse and data mart entities.
- Created dimension and measure objects according to business requirements.
- Designed and developed databases for OLTP and OLAP Applications.
- Implemented ETL 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.
- Worked on data modeling and ensured proper relationships by supporting all the requirements.
- Worked on several types of SSIS control tasks like WMI data 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.
- Worked on various kinds of transformations in SQL Server Integration Services (SSIS) like Term Lookup, Merge, Derived column, Cache transform, DQS cleansing, Term extraction, Aggregate, Character map, Pivot, for each Loop Container, Execute SQL Task.
- 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.
- Create SSAS Tabular Model and SSAS Multidimensional Model and support the existing database components.
- Implemented projects using Agile Methodology.
Environment: SQL Server 2008/2014, SSRS 2014/2008, SSIS 2008,2014 SSAS, Power BI, T-SQL, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP
Confidential, Jacksonville, FL
SSIS/SSRS/SSAS/Power BI Developer
Responsibilities:
- Upgraded database tables from 2008 to 2014.
- Worked on creating Stored Procedures, Triggers, Functions, Indexes, Tables and Views for applications.
- Created dimension and measure objects according to business requirements.
- Assisted in data analysis, star schema data modeling and design specific to data warehousing and business intelligence environment.
- Designed and developed databases for OLTP and OLAP Applications.
- Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- 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.
- Implemented Change Data Capture and Table partitioning on data warehouse and DataMart systems.
- Worked on several types of control tasks of SSIS like WMI data 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.
- Worked on various kinds of transformations in SQL Server Integration Services (SSIS) like Term Lookup, Merge, Derived column, Cache transform, DQS cleansing, Term extraction, Aggregate, Character map, Pivot and Un Pivot, foreach Loop Container, Execute SQL Task.
- Designed and developed SSIS ETL/ELT processes (SSIS 2008/2014/2016 ).
- Converted SSIS packages from 2008 to 2014 and 2016.
- Designed and implemented ETL processes for clients based on change tracking for full and incremental data.
- Discuss and finalize requirements from business users for designing efficient ETL processes.
- Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from various sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
- Created package configuration in XML and used to deploy packages into SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
- Designed and Developed new SSAS Tabular Models and used DAX expressions/formulas for creating calculated measures and columns.
- Create 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 /expressions.
- Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Imported data from various 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. And implemented Row-level security (RLS).
- Configuring Power BI Gateway for SSAS Live connection.
- Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Developed reports using Tableau.
- 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.
- Experience in strong SQL debugging skills, application level troubleshooting skills.
- Create SSAS Tabular Model and SSAS Multidimensional Model and support the existing database components.
- Write SQL queries in SQL Server databases to validate data entered by service methods and to setup data for testing scenarios.
- 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. Implemented partitioning on measure groups.
- 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.
- Implemented projects using Agile Methodology.
Environment: SQL Server 2008/2014/2016 , SSRS 2016/2014/2008 , SSIS 2008,2014,2016 SSAS, Power BI, T-SQL, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP