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 & SQL Server 2000 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).
  • Deploying SSIS packages and configure SSIS DB projects and environments.
  • Wrote complex T-SQL queries and stored procedures for the reports.
  • Created various Daily and Monthly reports showing detailed and summary information.
  • Create reports and dashboards in Power BI and SSRS.
  • 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.

Confidential, Los Angeles

SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

  • Designed and Developed new SSAS Multidimensional Models.
  • 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.

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.

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/2016 , SSRS 2016/2014/2008 , SSIS 2008,2014,2016 SSAS, Power BI, T-SQL, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP

Hire Now