We provide IT Staff Augmentation Services!

Sql/ssis/ssas/ssrs/ Power Bi Developer Resume

De Pere, WI

PROFESSIONAL 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 for Power BI and Ad-hoc Reports.
  • Expert on creating multiple kind of Power BI Reports and Dashboards.
  • Created, Maintained & scheduled various reports in Power BI.
  • 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), power query and 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.

WORK EXPERIENCE:

Confidential, De Pere, WI

SQL/SSIS/SSAS/SSRS/ POWER BI Developer

Responsibilities:

  • Worked on gathering business requirements from end users, developing and maintaining SSRS 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 using SSAS based on the insights provided by the business users.
  • Designed dimensions and hierarchies in SSAS cubes 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.

Hire Now