We provide IT Staff Augmentation Services!

Sql Server/power Bi Developer Resume

2.00/5 (Submit Your Rating)

Kansas City, MO

SUMMARY

  • 8+ years of experience in data modeling, database designing, product support, development and implementation of applications using Microsoft SQL Server suite of products.
  • Extensive working experience with Business Intelligence Development Studio (BIDS) which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).
  • Proficient in all areas of SQL Server development such as tables, views, user defined functions, indexes, stored procedures, functions, triggers.
  • Expertise in extracting data from multiple tables using T - SQL joins, correlated and non- correlated sub queries.
  • Experience in developing interactive data visualization reports, and dashboards using Power BI Desktop.
  • Extensive working experience in developing SSRS reports such as tabular, matrix, cascading parameterized, drill down, drill through, custom reports using report builder and report designer.
  • Experience in Extracting, Transforming, and Loading (ETL) data from various data sources such as flat files, excel, csv, and oracle to SQL Server database.
  • Experience in ETL process using SSIS, DTS, Import and Export utility.
  • Implemented event handlers, package configurations, logging, user defined variables, and expressions in SSIS packages.
  • Worked on OLTP and OLAP systems. Created Tabular and Multi-dimensional cubesusing SSAS.
  • Experience in designing data warehouse using dimensional model schemas like star schema and snow flake schema.
  • Expertise in populating dimension, fact tables, and data marts using SSIS packages.
  • Experience working in agile environment and have good understanding of Software Development Life Cycle (SDLC) methodologies and principles.
  • Worked on designing database models using MS Visio and Erwin.
  • Experience in troubleshootingthe database issues and resolve the incidents/tickets as per SLAs.
  • Extensively worked on Performance Tuning Analysis, Query optimization, Avoiding deadlocks and Blocking, Backups, Disaster Recovery Planning.
  • Created datasets based on MDX queries and implemented performance analysis of the SSRS reports.
  • Experience in scheduling jobs using SQL Server Agent and involved in database administration activities such as backup, recovery, and replication of databases.
  • Experience in performance tuning, query optimization, and database security by creating users and role based access to data.
  • Responsible for coordination and execution of User Acceptance Testing (UAT) for standard and custom implementations.
  • Facilitated technical trainings to clients/end users/support team.
  • Worked on complex RDBMS table structures and ability to research application issues using SQL or related tools.
  • Experience in source code management, reporting, requirements management, and project management using Team Foundation Server (TFS).

TECHNICAL SKILLS

Database: MS SQL Server 2005/08/12/14/16, Oracle 11g, MySQL

SQL Server Suite: SSMS, SSIS, SSRS, SSAS, SQL Profiler, DTS

Reporting Services: SSRS, Power BI, Pivot Tables

Data Modeling Tools: Erwin

Programming Languages: T-SQL, Java, VB Script, MDX

MS Office Suite: MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, TFS

Ticketing Tool: ServiceNow, First wave

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

SQL Server/Power BI Developer

Responsibilities:

  • Working on gathering business requirements from end users, developing and maintaining SSRS reports and MS SQL server database querying and programming. collaborate with cross-functional teams to halp end users navigate the data and reporting to solve business problems.
  • Develop SQL scripts to load data into enterprise data warehouse(EDW).
  • Basic troubleshooting and fixing the issues within EDW and reporting solutions.
  • Work TEMPeffectively with the client management team to identify, estimate, prioritize, and resolve issues.
  • Create data marts and load data into dimension and fact tables by creating SSIS packages.
  • Work closely with application teams and be responsible for database query design.
  • Develop and support SSIS ETL packages to perform data loads from various types of source files to SQL server database.
  • Handle incremental data load into staging and ODS databases
  • Perform SQL code review on new procedures and report queries created by consulting team.
  • Use performance monitor and SQL profiler to optimize the SQL queries and enhance the performance of the database.

Environment: SQL Server 2016, SSRS, SSAS, SSIS, ServiceNow, Visual Studio

Confidential, Cleveland, Ohio

Power BI Developer(SSIS/SSAS/SSRS)

Responsibilities:

  • Designed and developed tabular models and multidimensional models usingSSASbased on the insights provided by the business users.
  • Designeddimensionsand 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.
  • Created visualizations and dashboards using Power BI as per the requirements.
  • Based on report requirements, me have created the calculated columns and measures using DAX in Power BI.
  • Involved in user interface design of reports and layouts that were developed using Power BI.
  • Used various Power BI visualizations such as clustered column chart, waterfall chart, gauge, pie chart, tree map, bar chart etc.
  • 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: Power BI Desktop, SQL Server 2014, SSAS, SSIS

Confidential, Baltimore, MD

SQL Database Developer (SSIS/SSRS/SSAS)

Responsibilities:

  • Automated the execution of SSRS reports using subscriptions and data-driven subscriptions.
  • Designed and maintained SSRS Reports using parameters and expressions.
  • Designed and implemented parameterizedand cascading parameterized reports using SSRS.
  • Build different types of chart reports using SSRS like column chart and pie charts.
  • Created sub reports and pass through parameters from main report to the sub reports.
  • Generated various report models on views and deployed them on to the production reporting server and generated various report models and ad-hoc reports.
  • Created reports from SSAS cube using MDX.
  • Hands on experience on Star Schema Modeling, Snow-Flake Modeling, FACT and Dimension tables, Physical and logical data Modeling.
  • Improved the performance of the slow running queries by using performance tuning.
  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
  • Created packages in SSIS with error handling.
  • Worked with different methods of logging in SSIS.
  • Experience in creating complex SSIS packages using proper control and data flow elements.

Environment: SQL Server 2014, SSIS, SSRS, SSAS, Visual Studio

Confidential, Pittsburgh, PA

SQL Database developer(SSIS/SSRS)

Responsibilities:

  • Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
  • Responsible for deploying and scheduling the SSIS packages through jobs.
  • Designed data models using Erwin.
  • Developed physical data models and created DDL scripts to create database schema and database objects.
  • Worked with T-SQLto create Tables, Views, and triggers and complex stored Procedures.
  • Used Script task for Data Flow and Error Handling in SSIS.
  • Wrote complexSQLqueries using joins, sub queries and correlated sub queries to retrieve data from the database.
  • Created/Updated database objects like tables, views, stored procedures, function, packages.
  • Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
  • Designed and developed monthly, quarterly, and yearly reports.
  • Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
  • UsedSQLServerProfiler to trace the slow running queries and theserveractivity.
  • Automated and enhanced daily administrative tasks including database backup and recovery.
  • Involved in setting upSQLServerAgent Jobs for periodic backups with backup devices, database maintenance plans and recovery.

Environment: MS SQL Server 2012, SSIS, SSRS, T-SQL, Visual Studio 2012, Erwin, SQL Profiler.

Confidential, Overland Park, KS

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Created ETL packages to load transactional data to data warehouse and built analysis services database to provide summarized data for dashboards.
  • Created custom measure groups in SSAS cube to implement business logic.
  • Created roles and implemented security to restrict users to view the data.
  • Migrated data from different heterogeneous sources such as flat files, excel, and SQL Server using SSIS and Bulk Insert.
  • Designed and maintained SQL server views to support ongoing reporting and application requirements.
  • Worked with team and created the data sets for reporting. Managed and supported the report environment.
  • Used SQL server relational database and T-SQL query language to create new database objects as needed, including primarily tables, views, and stored procedures.
  • Created reports with SSAS cube as the data source using SQL Server Reporting Services (SSRS).
  • Maintained the Business Intelligence Incident Management queue.
  • Responsible for trouble shooting, supporting, and enhancing existing production application reports.
  • Provided business users the data required for metrics and analysis.
  • Performed unit testing on the SSRS reports before deploying them to the production server.
  • Provided the production support after designing and deploying the reports to production server.

Environment: SQL Server 2012, SQL Server Data Tools (SSDT), SSIS, SSRS, SSAS, T-SQL, TFS

Confidential

Jr SQL Developer(SSIS/SSRS)

Responsibilities:

  • Worked with clients/end-users to determine configuration requirements for new implementations and enhancements for the existing application.
  • Implemented and supported the Confidential ’s HR system application and provided the BI Solutions to clients by creating SSRS reports and SSIS packages.
  • Migrated data from different heterogeneous sources such as flat files, excel, and SQL Server using SSIS and Bulk Insert.
  • Created SSIS packages to load data into data warehouse using various SSIS Tasks like execute SQL task, bulk insert task, data flow task, send email task.
  • Designed and maintained SQL Server Views to support ongoing reporting and application requirements.
  • Used SQL server relational database and T-SQL query language to create new database objects as needed, including primarily tables, views, and stored procedures.
  • Developed SSRS reports such as sub reports, parameterized, drill down, and ad-hoc reports.
  • Supported the application users, client support personnel who worked in a 2nd tier support environment.
  • Supported internal/external technical and functional users.
  • Trained the non-technical users to create the basic SQL queries using views through the application wizard.
  • Prepared test cases, performed unit testing, documented the test results, and involved in code reviews.
  • Worked with business team and clients to coordinate UAT, maintain Issues and Actions Log, ensure configuration issues are promptly resolved, tested, and signed-off.
  • Provided post implementation hyper care, end user training and documentation.
  • Managed production support by trouble shooting and resolving the incidents/tickets as per SLAs.
  • Participated in weekly status calls with clients, ensure the application is configured and ready to go-live as per schedule, and document lessons learned.
  • Participated in weekly 24/7 on call rotation.

Environment: SQL Server 2008, SSIS, SSRS, T-SQL, ServiceNow, Excel, Word, Confidential HR System.

Confidential

Jr SQL Developer/SSAS Developer

Responsibilities:

  • Involved in gathering, analyzing, designing of the system specification, and prepared the document for proposed system.
  • Involved in designing and creating the database tables and views.
  • Created various database objects such as stored procedures, user defined functions, triggers.
  • Wrote complex SQL queries using joins and sub queries involving multiple to extract the desired data for reporting.
  • Involved in database administrative activities such as database backup and restore.
  • Developed various reports using SSRS and MS Excel.
  • Worked on SQL Server Import and Export wizard to load the source data to SQL Server database.

Environment: SQL Server 2005/2008, SSRS, T-SQL, Excel.

We'd love your feedback!