We provide IT Staff Augmentation Services!

Sql Bi Developer/ Power Bi/ Data Analyst Resume

VA

PROFESSIONAL SUMMARY:

  • 8+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment).
  • Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
  • Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
  • Experience in writing complex SQL queries involving multiple tables with inner and outer joins, stored procedures.
  • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
  • Worked Extensively on ETL process using SSIS package.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Experience in Tableau report developing, testing and deploying report using Tableau Server.
  • Experience in creating metrics, attributes, charts, filters, hierarchies, trend lines, sets and grouping, data blending, Parameters and Complex Calculation to manipulate data using Tableau.
  • Hands-on Experience in MDX Expressions, DAX Expressions, Power BI Power Pivot, Power integrated with Share Point and in creating dashboards in Power BI and Tableau visualization tools.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Sub reports, and formatting them.
  • Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
  • Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
  • Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Experience in Creation and deployment of cubes on SSAS.
  • Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Worked with different versions of SQL - 2005, 2008, 2008R2, 2012, 2014, 2016, 2017.
  • Migration of SQL Databases from SQL 2008 to SQL 2016.
  • Experience in building the Azure Cloud Databases and transferring data to Azure using SSIS.
  • Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
  • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
  • Involved in DBA activities such as backups and restores.
  • Ability to handle multiple tasks, initiative and adaptable. Proactive team player with capability of handling responsibilities independently as well.
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

TECHNICAL SKILLS:

Databases: SQL Server 2017/2016/2014/2012/2008 R2/2008, Oracle 8i/9i/10g/11g, MYSQL

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio (BIDS), SQL CMD.

Reporting Tools: SSRS, Report Builder, Focus, Power BI.

Languages: T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA

OLAP: SQL Server Reporting Services (SSRS), SSIS, Crystal Reports 9.0/8.5, OLAP, Erwin, Tableau, Power BI

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003/2008/2012 , MS DOS, Unix, Linux.

IT Processes: Software Development Life Cycle (SDLC), Agile, Waterfall, Iterative

Methodologies: Agile, Waterfall, Scrum, SDLC

PROFESSIONAL EXPERIENCE:

Confidential, VA

SQL BI Developer/ Power BI/ Data Analyst

Responsibilities:

  • Responsible for creating critical compliance test analysis documents and Business Requirement Documents (BRD).
  • Created the Complex SQL Queries, User Functions, stored procedures, CTE’s, Views, Indexes also created schema and Tables Using SSMS 2018.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
  • Working on live site issues to fix slow running stored procedures, triggers etc. and provide Root cause analysis.
  • Experience in Data Analysis, understanding trends and patterns in data.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Created SSIS packages to implement error/failure handling with event handlers, row redirects, and loggings.
  • Created SSIS packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
  • Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server Analysis Services (SSAS).
  • Developed data visualizations and dashboards using Power BI and Tableau
  • Extensively involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
  • Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
  • Wrote calculated columns, Measures query's using DAX in Power BI to show good data analysis techniques.
  • Involved in scorecard and KPI Reporting.
  • Designed Tableau and Power BI dashboard which give a visual representation for the users on MTD sales growth, Visual analytics on injuries, dealer location map etc.,
  • Worked on various visualization techniques in Tableau like Scatter Plots, Histogram and Heat Maps.
  • Created different tabular reports using Power BI features and enhanced them based on user requirements.
  • Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper level management.
  • Installed and configured on premises gateway in Power BI services.
  • Scheduled Automatic refresh and scheduling refresh in Power BI services.
  • Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
  • Published dashboards on an intranet site using SharePoint Server.
  • Collaborated with different stakeholders from various business units to validate and approve compliance tests independently.

Environment: MS SQL Server 2012/ 2014/ 2017 , Microsoft Management Studio, Microsoft Visual Studio, MS SQL Server Integration Services (SSIS) 2012/2008R2/2008, SQL Server Reporting Services (SSRS), Power BI, Tableau, T-SQL.

Confidential, CA

SQL BI Developer

Responsibilities:

  • Analyzed company’s business practice and product performance to determine potential growth.
  • Involved in creating database objects - Tables, Indexes, Views, User defined functions, Parameterized Stored Procedures.
  • Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
  • Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
  • Extensively used SQL queries to translate data into valuable information for decision making.
  • Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on SQL Servers.
  • Extracting the data from the different sources (CSV files, flat files, Excel files and MS SQL) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
  • Created highly complex SSIS packages using various Data transformations like conditional splitting, Lookup, For Each Loop, Error handling.
  • Defined best practices for Tableau report development.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau.
  • Created SSIS packages to implement error/failure handling with row redirects.
  • Developed Cubes using SQL Analysis Services (SSAS) and Dimensions using cube wizard and Generated Named calculations and named queries.
  • Experience in Designing, Building the Dimensions, cubes with star schema, snowflakes schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
  • Created partitions and designed aggregations in Cubes.
  • Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS)
  • Designed and implemented data models and reports in Power BI to help clients analyze data to identify market trends, competition and customer behavior.
  • Developed custom calculated measures using DAX in Power BI to compare the company’s industry wide.
  • 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.
  • Developed dashboards including various charts- bar charts, pie charts, scatter charts, bubble charts and shape maps.
  • Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
  • Involved in reporting of KPI and gauges for some parameters to keep track of close competitors in the industry.
  • Provided in-depth market research reports for qualitative and quantitative methods.
  • Provided SWOT analysis on financial data using Power BI charts.
  • Recommended new services based on data driven analysis.

Environment: MS SQL Server 2012/ 2014/ 2016 , Microsoft Management Studio, Microsoft Visual Studio, Power BI, Power Pivot, Tableau, DAX.

Confidential, GA

SQL BI Developer

Responsibilities:

  • Experience in using SQL Server tools like SQL Server Management Studio, SQL Server Data Tools, and SQL Server Visual Studio.
  • Extensively used T-SQL in constructing User Functions, Views, CTE’s Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Use DDL and DML for writing triggers, stored procedures, and data manipulation
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
  • Error handling using Try-Catch Block.
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Designed the SSIS packages with error handling.
  • Analyzing and designing reports and reporting solutions according to the specifications given.
  • Meet deadlines while meeting the reporting needs of the business users and project owners.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Created SSAS Tabular cubes and loaded dimensions and facts. Defined attribute properties in a Parent Child Dimensions.
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Design SSAS Cubes storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
  • Creating Ad Hoc and Parameterized Reports using SQL server Reporting services.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports using SQL Server Reporting Services.
  • Generated Sub-Reports, drilldown reports, Drill through reports and Parameterized reports using SSRS.
  • Representation for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
  • Reports were created according to the report specifications and make sure to submit the work assignment before the due time.
  • Scheduling the jobs for monthly reports and yearly reports
  • Played a major role in production support and maintenance of SSIS jobs.
  • Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Environment: MS SQL Server 2008/2012, Micro Soft Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Confidential

SQL Server BI Developer

Responsibilities:

  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
  • Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
  • Part of team for analyzing and implementing the physical design for the database.
  • Responsible for drafting documentation for describing the metadata and writing technical guides.
  • Created Stored Procedures, Triggers, Views and SQL Joins and other statements for various applications.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Involved in creating and visualizing dashboards using Tableau Desktop.
  • Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
  • Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
  • Thorough understanding of first NF (1NF), second NF (2NF) and third NF (3NF).
  • Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Installation and configuration of SQL Server 2008.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports using SQL Server Reporting Services 2008.
  • Created SQL Server Analysis Project using MS SSAS 2008.
  • Querying and manipulating multidimensional cube data through MDX Scripting.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Created complex SSAS cubes with multiple fact measures groups.
  • Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
  • Developed the chart type, Tablix, matrix reports in SSRS (SQL Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
  • Used performance Point Services, SSRS, excel as the reporting tools.
  • Wrote the expressions in SSRS wherever necessary.
  • Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Modifying report content and exporting reports in multiple formats based on the business requirements.
  • Designed and implemented Parameterized and cascading reports using SSRS.
  • Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
  • Created derived columns on the final fact and dimension tables as per the business requirements.
  • Understanding the OLAP processing for changing and maintaining multidimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
  • Played a major role in production support of SSAS (cube refresh), SSIS jobs.
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, MS PowerPoint, Tableau, OLAP, OLTP, MDX.

Confidential

SQL Server Developer

Responsibilities:

  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Involved in designing Flow charts, office layout for the business users and professionals using VISIO.
  • Created SQL reports, data extraction and data loading scripts for different databases and schemas.
  • 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.
  • Wrote Transact SQL utilities to generate table insert and update statements.
  • Involved in performance tuning and monitoring of T-SQL blocks.
  • Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
  • Involved in developing report using SQL Server Report Services.
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
  • Performed all aspects of database administration, including data modeling, backups and recovery.

Environment: MS SQL Server, T-SQL, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS, SSRS, SQL Server Query Analyzer, SQL Profiler.

Hire Now