We provide IT Staff Augmentation Services!

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.
  • Developed analysis reports and visualization using DAX functions like table function , aggregation function and iteration functions.
  • 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

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.

Hire Now