We provide IT Staff Augmentation Services!

Sql/etl/ssas/ Power Bi Developer Resume

0/5 (Submit Your Rating)

Beloit, WI

SUMMARY

  • Around 8+ Years of Extensive Experience in Business Intelligence Applications Design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).
  • Experience in creating/deploying Data Transformation Services (DTS), Knowledge of Integration Services (SSIS) packages, Analysis Services (SSAS) and Reporting Services (SSRS).
  • Expertise in Extraction, Transformation, Loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
  • Strong Experience in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, Joins, triggers, clustering, T - SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, data dictionaries, and data integrity.
  • Explore data in a variety of ways and across multiple visualizations using Power BI.
  • Responsible for creating SQL datasets forPowerBIand Ad-hoc Reports.
  • Expert on creating multiple kind ofPowerBIReports and Dashboards.
  • Created, Maintained & scheduled various reports inPowerBI.
  • Published Power BI reports from Power BI desktop to Power BI service.
  • Created different visualization in Power BI according to the requirements.
  • Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
  • Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), powerqueryand power Pivot.
  • Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
  • Experience in Designing, Building the Dimensions, cubes with star schema, snowflakes schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
  • Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005/2008 Analysis Services.
  • Experience in creating Report Models for building Ad hoc reports using SSRS.
  • Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
  • Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
  • Generated the weekly, monthly, and quarterly reports by using SSRS, MDS.
  • Very good experience in writing expressions in SSRS.
  • Excellent experience in developing complex Stored Procedures, Views and Indexed Views.
  • Good knowledge in RDBMS concepts, Data warehousing concepts, & OLAP.
  • Worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema and Entity relationship diagrams from business requirements.
  • Good experience in creating User Defined Functions and Triggers in observing Business Rules.
  • Expertise in working with Version control system (VSS, VS, TFS)
  • Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Proficient in implementing surrogate key generation strategy in the Data warehouse.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services, Scope, Tableau, Power BI.

RDBMS: SQL Server 2008/2005/2000 , 7.0, MS-Access.

Languages: C, C#, T-SQL, PL/SQL, JavaScript, Perl, Cosmos.

Web Technologies: Share point, HTML, CSS, XML, JavaScript, PHP, Shell Scripting.

Version Control: Visual Source Safe, Clear Case.

Data Modeling: Erwin r7.3/7x/4.0, MS Office Visio 2003/2007.

Operating System: Linux, Mac OS X, Microsoft Windows/Advanced Server, MS-DOS, UNIX.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential - Beloit, WI

SQL/ETL/SSAS/ POWER BI Developer

Responsibilities:

  • Interacted with the business users for understanding the business requirements and the existing system
  • Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
  • Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2016.
  • Created the views in the intake-database for the MS Sales hierarchies to be use in the store procedures in Staging database.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
  • Created many complex Query's and used them in Power BI Reports directly to generate reports on the fly.
  • Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
  • Using SSIS Package identified the Up-streams and imported the required tables into intake-database, Store Procedures are created in staging database using the intake-database tables & views.
  • Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment.
  • Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
  • Designed and implemented Row Level Security & Roles for SSAS Tabular Model. And deployed into SQL SERVER ANALYSIS SERVER 2016.
  • Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
  • Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
  • Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.
  • Adheres to department, organization and industry guidelines, standards, policies and procedures.
  • Create reports in Power BI preview portal utilizing the SSAS Tabular Model via Analysis connector.
  • Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
  • Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
  • Used One Drive for storing different versions of Power BI report.
  • Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.
  • Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
  • Used JIRA for Version Control needs, task check-ins.
  • Responsible for complete maintenance and delivery of scheduled releases.

Environment: MS SQL Server 2014/2016 T-SQL, MS SQL Integration Services 2014/2016, SSAS Cubes, Power BI.

Confidential - De Pere, WI

SQL/SSIS/SSAS/SSRS/ POWER BI Developer

Responsibilities:

  • Worked on gathering business requirements from end users, developing and maintainingSSRS Reports.
  • Collaborate with cross-functional teams to help end users navigate the data and reporting to solve business problems.
  • Developed SQL scripts to load data into enterprise data warehouse(EDW).
  • Capture business objectives and processes and design and develop a comprehensive application and solution.
  • Generated reports from OLTP and OLAP databases.
  • Designed and developed tabular models and multidimensional models usingSSASbased on the insights provided by the business users.
  • Designed dimensions and hierarchies inSSAScubes based on star schema from Data warehouse.
  • Interacted with business users and analyzed the user requirements and built reporting solutions such as relational database reports, OLAP reporting, and dashboards.
  • Worked on developing Power BI reports and dashboards from multiple sources.
  • Created dashboards and data visualization using Power BI desktop.
  • Published reports and dashboards to Power BI Service through Office 365 integration.
  • Created data marts and load data into dimension and fact tables by creating SSIS packages.
  • Worked closely with application teams and be responsible for database query design.
  • Developed and supported SSIS ETL packages to perform data loads from distinct types of source files to SQL server database.
  • Handled incremental data load into staging and ODS databases.
  • Performed SQL code review on new procedures and report queries created by consulting team.
  • Used performance monitor and SQL profiler to optimize the SQL queries and enhance the performance of the database.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
  • Troubleshooted and resolved the issues with existing ETL process.
  • Provided documentation for the new SSIS packages and procedures.

Environment: SQL Server 2016, T-SQL, SSIS, SSAS, SSRS, Visual Studio, Power BI

Confidential - Oakland, CA

SQL/SSIS/SSAS/ POWER BI Developer

Responsibilities:

  • Involved in Data Analysis and Migration of Data.
  • Involved in complete Software Development Cycle (SDLC).
  • Created SSIS packages to load data into SQL Server using various transformations in SSIS.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.
  • Capture business objectives and processes and design and develop a comprehensive application and solution.
  • Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse
  • Works with SQL Server, SSIS technologies and has a good Data Warehouse knowledge and tools.
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Documentation for all kinds of reports and SSIS packages.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
  • Successfully conducted root cause analysis to identify the underlying issues and design solutions accordingly.
  • Involved in the data mapping sessions and creation of Data dictionary.
  • Migration of the data from one environment to other environment. Testing and analysis of the migrated data.
  • Identify and replace manual processes and exchange of data with an Automated System.
  • Implement the best design patterns in data migration to adapt for future changes.
  • Review several test plans and test scenarios with the QC team for each project worked on.
  • Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
  • Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard and also using SSIS, MDS.
  • Worked on XML along with PL/SQL to develop and modify web forms.
  • Created SSAS OLAP Cubes and Partitioning Cubes, monitored and full and incremental load using cube wizard.
  • Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
  • Responsible for creating Dashboards in Power BI and made them available in Web Clients and Mobile Apps.
  • Created Share Point solution to host Power BI Monitoring dashboards to indicate claims spend to date.
  • Published Power BI reports from Power BI desktop to Power BI service.
  • Created different visualization in Power BI according to the requirements.

Environment: Microsoft SQL Server 2012/2008/2005 , MS Access, SSAS, SSIS, MDS, EDS, HTML, Visual Studio 2005/2008/2010 , IIS, Sybase 12.0, Query Analyzer, ERWIN, Windows server 2008R2, DTS, TSQL, Net, SQL Profiler, DTS, Team Foundation Server, CITRIX, CISCO Any Connect, Visual Source Safe, Power BI.

Confidential - Charlotte, NC

SQL/SSIS/SSAS/SSRS Developer

Responsibilities:

  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
  • Created functions and developed procedures to implement application functionality at the database side for performance improvement.
  • Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
  • Created DTS and SSIS packages.
  • Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
  • Created SSIS package to get data from different sources, consolidate and merge into one single source.
  • Created ETL package for data conversion using various transformations tasks.
  • Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
  • Created dash board to show the business performance.
  • Created partitions and designed aggregations in Cubes.
  • Created perspectives in SSAS and configured security levels for the Cubes.
  • Designed KPI’s in SSAS and imported them to Excel.
  • Created custom reports which had cascaded parameters using SSRS/SQL Server BI studio.
  • Created Ad hoc reports using SSRS.
  • Created several reports using SSRS and MDS like parameterized report, drill through reports, linked and sub reports
  • Created reports that call Sub reports in SSRS.
  • Created datasets for reports using T-SQL and stored procedures
  • Responsible for maintaining cubes using SSAS and populate the cubes with the data.
  • Responsible for Query optimization and Performance tuning

Environment: SQL Server 2000/2005 Enterprise Edition,.NET Framework, XML, T-SQL, SSIS 2005, SSRS, SSAS,VisualStudio.NET IDE, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access. Visual Studio 2005.

Confidential - Baltimore, MD

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Created and Developed Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions, T-SQL (DDL, DML) statements and other advanced queries for databases by using SQL Server Management Studio.
  • Designed high level ETL architecture for overall data transfer from the source server to the SQL Server 2005 which encompasses database name, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005.
  • Involved in Data migration using BCP from text to SQL Server2005.
  • Created packages in SSIS using Control Flow and Data Flow Transformations.
  • Created the mappings using transformations such as the Derived Column, Conditional Split, Pivot, and Script Component.
  • Used Control Flow elements like For each loop and Sequence container, Execute SQL task, Execute Process task, Execute package task and Script task, File System task Send Mail Task.
  • Developed Exception handling process for each SSIS packages.
  • Scheduled and monitored the SSIS packages for daily load in SQL Server job Agent.
  • Created several lookup tables and updated couple of existing lookup tables.
  • Involved in Creating Stored Procedures for reports generation.
  • Designed and generated simple and custom reports using SSRS 2005.
  • Scheduling SSRS, MDS jobs and production support.
  • Involved in Debugging reports and deploying reports.
  • Created Tabular reports, Cross Tab Reports and Sub Reports.
  • Launched the report builder for ad-hoc reports.
  • Created and deployed complex reports using multiple parameters from stored procedures, expressions and conditional formatting.
  • Created complex table, matrix and chart reports to work with different output formats.
  • Conducted performance tuning by using SQL Profiler and database engine tuning advisor.

Environment: MS SQL Server 2005, SSIS, SSAS, SSRS, T-SQL, MDS, MS Office, Performance Monitor, Visual studio 2005, SQL Profiler, Windows XP.

Confidential - Dallas, TX

SSIS/SSRS Application Developer

Responsibilities:

  • Gathering Requirements from the Business Users and developing the work flows.
  • Performed Column Mapping, Data Mapping and Maintained Data Models and Data Dictionaries.
  • Designed SSIS packages to migrate the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL Server.
  • Expertise in Using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
  • Worked on Huge Data Transfers from and to SQL Server Databases using SSIS, and used Configuration Files and Environment Variables for production deployment.
  • Developed drill down and drill through reports from multi-dimensional objects like Star and Snow Flake Schema using SSRS and performance point server.
  • Involved in Performance tuning of ETL transformations, data validations and stored procedures.
  • Involved in retrieving multi-million records for data loads using SSIS and by querying against Heterogeneous Data Sources like SQL Server, Oracle, Text files, Great Plains, and some Legacy systems.
  • Employed SSIS Data Profiler Task to profile Target Source Systems and build ETL Solutions, which was helpful in designing the table structures and cleaning data for data consistency.
  • Used configuration files and variables to deploy SSIS packages across several Environments (Development/Testing).
  • Created calculated measures using MDX implementing business requirement
  • Experienced working on Star and snow flake schemas and used the fact and dimension tables to build the cubes, perform processing and deployed them to SSAS database.
  • Designed aggregations and pre-calculations in SSAS.
  • Involved in designing Partitions in Cubes to improve performance using SSAS.
  • Developed Linked, Drill Down, Drill Through and Sub Reports using SSRS.
  • Involved in optimization of queries and refining the performance using Data Purging, Index Optimization, Execution Plans, DMV’s and DMF’s.
  • Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
  • Designed Subscriptions and Security for Reports.

Environment: MS SQL Server 2005/2008, SSIS 2005/2008, SSRS 2005/2008, SSAS 2005/2008, Oracle 11g, VB.Net and Visual Studio 2008.

Confidential

SQL Server BI Developer

Responsibilities:

  • Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
  • Created reports by retrieving the data from cube using MDX reports.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Designed MDX queries to retrieve data from SSAS cubes.
  • Designed high level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS.
  • Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.
  • Set package configuration in SSIS to redirect path from test environment to production environment.
  • Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
  • Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
  • Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports.
  • Worked on Huge Data Transfers from & to SQL Server Database. Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
  • Created reports by retrieving the data from cube using MDX reports.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Designed MDX queries to retrieve data from SSAS cubes.
  • Designed high level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS.
  • Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.
  • Set package configuration in SSIS to redirect path from test environment to production environment.
  • Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
  • Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
  • Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports.
  • Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment.
  • Created necessary steps to enhance user response time by improving queries and their index selections to minimize IO and eliminate table scans.
  • Enhancing the SSIS Packages and deploying from development server to production server.

Environment: SQL Server 2005/2008, Query Analyzer, SQL/SSIS/SSRS/SSAS, C#, Visual Studio.NET, ProClarity Server, TFS, XML, BizTalk, MS Excel, Oracle, Visual Source Safe.

Confidential

SQL Developer

Responsibilities:

  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
  • Actively participated in gathering of Requirement and System Specification.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
  • Worked on complex T-SQL statements, and implemented various codes and functions.
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services
  • Wrote Transact SQL utilities to generate table insert and update statements.
  • Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
  • Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression (CTE)
  • Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2005, T-SQL, .Net, Microsoft Framework 2.0, Erwin, MS Visio.

We'd love your feedback!