We provide IT Staff Augmentation Services!

Ms Sql/power Bi Developer Resume

Cincinnati, OH

SUMMARY

  • Over 6+ years of experience in design, development & analysis of SQL Server 2008/2012/2014/2016/2017 and SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS, SSAS and experience with Power BI.
  • Experience with Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2005/2008/12/14/16/17.
  • Experience in assigning row level security for dataset in Power BI Desktop.
  • Experience in creating Dashboards from various sources with new Q&A feature in Power BI service.
  • Good exposure on Power BI Reporting Tool.
  • Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
  • Proven experience developing and managing data integration solutions using Microsoft BI technologies.
  • Experience in creating complex reports in Power BI (List reports, Cross-tab reports, Drill through reports, Sub reports and Cascading prompts).
  • Extensive experience in Cognos which includes Impromptu, Powerplay, Powerplay Transformer, Architect, Query Created multidimensional models and Power Cubes for distribution using Power Play Transformer.
  • Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
  • Extensive experience in developing Stored Procedures, Functions using T-SQL.
  • Good at improving Performance using Table Indexes, Indexed Views by implementing Schema Bindings.
  • Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
  • Good experience of creating OLAP cubes in SSAS.
  • Experience in creating MDX queries to retrieve data from SSAS Cubes.
  • Experience in administrating and working on Microsoft Metadata Management (MDM) Services.
  • Experience in generating Parameterized Reports, Custom generated reports, Charts, Drill down, Drill Through reports using Local and Global Variables, Expressions and Filters in SSRS.
  • Developed Complex Queries, Stored Procedures and Functions for Report generation using SQL Server Reporting Services (SSRS) for organization requirements.
  • Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance
  • Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule DTS/SSIS Packages.
  • Expert in monitoring SQL Server Performance using SQL Profiler.
  • Experience in administration tasks such as Data Loading, Batch Jobs, Data Unloading, Backup and Recovery, Upgrades, Creating Databases, Files, File groups and Transaction logs.
  • A multitasking analytical thinker with the ability to work on fast paced work Environment.
  • Strong communication skills and an ability to work individually or part of a team and good learner to adapt new technologies that improve the business.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/ 2012/14/16/17 /19 , Oracle 9i/10g, PL/SQL, MS Access

Programming Languages: T-SQL, PL/SQL, HTML, XML, Oracle, C, C#, ASP.NET, JavaScript, Unix.

Tools: /Utilities: Enterprise Manager, SQL Server Management Studio (SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio, SQL * Plus, Ervin, Power BI

Database Design Tools & Data Modeling: MS Visio, MS Access, SQL Server 2008/2012, Star Schema/Snowflake Schema modeling. Physical & logical data modeling and De-Normalization techniques, Kimball & Agile Scrum Methodologies.

Business Intelligence Tools: Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), DTS Packages, Performance Point Server, Visual Studio.

Operating Systems: Windows Server 2000/2003/2008 , Windows XP/Vista.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

MS SQL/Power BI Developer

Responsibilities:

  • Active participation with customers in understanding their business process and suggesting optimal database structure, practices and tools on specific projects, ensuring high customer satisfaction rates.
  • Created Dashboards using Power BI and integrated with UI.
  • Use Power BI to transforms and model data needed for business decisions.
  • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Used Power BI for developing reports, data marts, KPI's and charts.
  • Created various kinds of reports using Power BI and Tableau based on the client's needs.
  • Migrate existing data into the Power BI.
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • Generated several Pivot Tables in Excel by using the SharePoint as back end and using Power BI Pivot Tables and Power Query
  • Scheduled Automatic refresh and scheduling refresh in Power BI service.
  • Migrated existing self-service reports and ad-hoc reports to Power BI.
  • Upgraded the databases and servers of SQL Server 2016 to SQL Server 2017.
  • Expertise in creating ETL packages using SSIS to extract data from heterogeneous sources such as Oracle, IBM DB2, My-SQL, MS Excel, Flat files into SQL Server 2016 and 2017 then transform and load into the data warehouse.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Used for each loop for iterative loading and Send mail task for E-mail notifications.
  • Migrated DTS objects to SSIS environment.
  • Developed complex stored procedures, CTE’s, Merge queries, triggers and cursors.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services.
  • Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS.
  • Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
  • Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
  • Created Cubes with multiple dimensions, measures, hierarchy, Key Performance Indicators as well as slowly changing dimensions.
  • Scheduled SSAS cubes through Analysis services processing task from SSIS.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL code.
  • Optimized complex queries by looking at Execution Plan for better tuning of the database.
  • Used various data compare tools to compare data from different servers.
  • Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated users and to administrative Clients.

Environment: SQL Server 2012/14/16/17 , Business Intelligence, Power BI, IBM DB2, SQL Profiler, Report Builder, SSRS, SSIS, Visual Studio, Visual SourceSafe and Team Foundation Server.

Confidential, Santa Clara, CA

MS SQL/Power BI Developer

Responsibilities:

  • Using the Software Development Life Cycle (SDLC), analyzed business requirements and developed functional work flow for information from source systems to destination systems.
  • Involved in SQL Server Stored Procedure Development and T-SQL.
  • Supported efficient Data Insertion, Manipulation, and Retrieval using various Joins, Indexed Views, Stored Procedures, and Functions.
  • Built data visualizations in Power BI Desktop and Power BI Service.
  • Configured report Subscription and report sharing rules in Power BI workspace.
  • Utilized Custom Visuals from Power BI market place.
  • Migrated SSRS reports to Power BI.
  • Developed Self-Service Analytical Data model using Power BI.
  • Created dashboards and reports using Power BI Desktop.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
  • Creating relationships between different data sources in Power BI to visualize the data and build the reports.
  • Wrote Calculated Columns, DAX Measures, and Queries in Power BI desktop to show good data analysis techniques.
  • Transferred data from various OLTP data sources such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2014.
  • Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report services (SSRS).
  • Migrated reports from MS SQL Server Reporting Services 2012 to 2014 and created complex reports using SSRS 2012 from the OLAP cubes for end user analysis.
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
  • Optimized and implemented stored Procedures and triggers for automating tasks and also managed indexing, debugging, optimization and performance tuning using T-SQL.
  • Involved in Migration of databases from Business Objects to SQL server 2014.
  • Imported data from various sources like MS Excel, MS Access, oracle, DB2, transformed to data warehouse using SSIS and then created reports using this data by SSRS.
  • Creating database objects like tables, Views, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Migrated Parameterized reports from Business Objects to Reporting services (SSRS).
  • Created Parameterized Reports using RDL. Promoted RDLs to Reporting Service Server (SSRS).

Environment: Power BI, MS SQL Server Management Studio 2012/14, OLPT, OLAP, SQL Profiler, MS SQL Server Integration Services (SSIS), ETL, MS SQL Server Reporting Services (SSRS), Microsoft Visual Studio, Agile, Business Objects (BO), Windows.

Confidential, Rochester, NY

SQL BI Developer (SSIS, SSRS)

Responsibilities:

  • Created Views to reduce apparent database complexity for end users and preventing sensitive columns from being displayed.
  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
  • Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2005/2008.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2008.
  • Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
  • Participated in the development, maintenance, enhancement, and support of applications.
  • Managed up-gradation of DTS packages to SSIS packages for ETL.
  • Responsible for developing, monitoring and deploying SSIS packages.
  • Data migration using SSIS across different databases like Oracle, MS access & flat files.
  • Used BCP utility to publish table output to text files...
  • Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
  • Extensively used joins and sub queries to simplify complex queries involving multiple tables.
  • Developed scripts for maintaining administration tasks.
  • Developed DTS Packages to transfer the data between SQL server database and files.
  • Creation and management of database maintenance plan for various database consistency checks.
  • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
  • Developed custom reports using SQL Server Reporting Services (SSRS)/SQL Server BI studio.

Environment: MS SQL Server Management Studio 2008 R2, Query Analyzer, SQL Profiler, BCP, ETL, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).

Confidential, Atlanta, GA

MS SQL BI Developer (TSQL, SSIS, SSRS)

Responsibilities:

  • Involved in Migration of databases from SQL Server 2008 R2 to SQL server 2012 to SQL Server 2014.
  • Experience in SQL Server Stored Procedure Development and T-SQL.
  • Supported efficient Data Insertion, Manipulation, and Retrieval using various Joins, Indexed Views, Stored Procedures, and Functions.
  • Created SSIS packages to capture the Incremental changes for the Data warehouse.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
  • Developed SSIS packages using for each loop in Control Flow to process all flat files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
  • Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server.
  • Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.
  • Experience in Developing, testing, deploying, and maintained new and existing ETL processes.
  • Maintained Data Quality and consistency using various types of Constraints, triggers, and defaults.
  • Designed generic web template and developed various periodic and ad-hoc reports.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created Cross-Tab, Drill-down, and Parameterized Reports using RDL. Promoted RDLs to Reporting Service Server (SSRS).

Environment: MS SQL Server Management Studio 2008 R2/2012/14, SQL Profiler, Informatica, MS SQL Server Integration Services (SSIS), ETL, MS SQL Server Reporting Services (SSRS), Microsoft Visual Studio, PL/SQL, Windows.

Hire Now