We provide IT Staff Augmentation Services!

Ms Sql Business Intelligence Developer Resume

Pittsburgh, PA

SUMMARY:

  • Over 7+ years of IT experience as a MS SQL Server BI Developer 2016/ 2014/2012/2008 R 2/2008/2005/2000 in various Industry verticals like Mobile, Finance, Health Care and Insurance.
  • Extensive experience in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions.
  • Very good understanding of SQL Server Architecture design and Data-Warehousing Concepts.
  • Extensive experience in Data-Warehousing projects as a Business Intelligence developer worked in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) SQL Server 2016/ 2014/2012/2008 R 2/2008/2005.
  • Experience on Performance monitoring using SQL Profiler. Scheduled and monitored all maintenance activities of SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 including database consistency checks and index defragmentation.
  • Experience in SQL Server ( 2016/ 2014/2012/2008 R 2/2008/2005/2000 ) Installation, Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, running database consistency check with DBCC Commands.
  • Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
  • Extensive experience in MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
  • Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase, Excel and MS Access.
  • Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
  • Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
  • Experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
  • Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
  • Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
  • Extensively worked with Parameterized Reports, Report Snapshots, and Linked Reports and used Report Manager for deploying reports in SSRS ( 2016/ 2014/2012/2008 R2/2008/2005).
  • Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
  • Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
  • Experience in designing Power BI reports and Dashboards.
  • Experience in Data Analysis, understanding trends and patterns in data and create insights.
  • Used Visual Source Safe (VSS) for version control and configuration management.
  • Strong knowledge working with all the phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
  • Experience with Hadoop Environment. Familiarity in using HIVE. Experience in defining Job flows. Importing and exporting data into HDFS and Hive using Sqoop.
  • Experience in using Microsoft Azure Cloud Platform.
  • Worked in collaborative team environment with other developers, business analysts, and a project management team.
  • Can do Attitude and ability to effectively communicate with all levels of the organization such as Management, technical and customers.

TECHNICAL SKILLS:

RDBMS: SQL Azure, MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 , Access, Excel.

Database Tools: BIDS 2016/ 2014/2012/2008 R2/2008/2005, Management Studio, Visual Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, SSIS, SSAS, Upgrade Wizard, Replication.

Programming languages: SQL, T: SQL, PL/SQL, VB.NET, C#, Hive.

Scripts: U: SQL, PHP, JavaScript, CSS, VBScript, HTML and XML, Power Shell, Scope.

Operating systems: Windows NT/2000/XP/2003/Vista/Windows 7/8, UNIX.

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

Other: Microsoft Office, Microsoft Visio, Microsoft Visual Studio2008, SharePoint, Dream viewer, Team Foundation Server, Power BI, Qlikview, AWS, Azure Data Lake Factory.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

MS SQL Business Intelligence Developer

Responsibilities:

  • Experience in Azure Data lake.
  • Creating U-SQL scripts to migrate data from SQL server to Azure Data Lake.
  • Migrating On-Premise Databases to Azure Data Lake using U-SQL. Validating the data in Azure Data Lake, Setting up Validation Scripts. Creating U-SQL Assemblies using C#.
  • Installation and configuration of SQL server and SQL Server Business Intelligence Objects, Azure Data Lake. Design and alter database objects to support new applications. Building Datawarehouse to handle Incremental and Delta loads. Creating new Dashboard reports to accommodate user requests.
  • Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers in the database.
  • Experience in maintaining the database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
  • Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
  • Improving performance of the server by analyzing the long running queries and performance tuning them.
  • Optimized long running stored procedures and queries for effective data retrieval.
  • Worked on various tasks and transformations in SSIS like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination
  • Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Used C# and VB Scripts in ETL Packages where ever necessary.
  • Generated Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS reports according to the customer requirements.
  • Creating internal Operational reports to analyze the performance of the server in terms of load duration, transformation speed of the jobs (To track the time for loading the data into the staging tables and transforming them to the data warehouse)
  • Developing operational reports to monitor the load count of the records and the duration of the load.
  • Experience with handling the adhoc issues in production environment.
  • Integrating SSRS reports in an ASP.NET Application.
  • Experience in Data Modeling using Star and Snow Flake Schemas using Ralph Kimball and Bill Inmon Methodology, ER Model, Dimensional Data Modeling, Dimensional Hierarchies, Physical & Logical Data Modeling.
  • Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • In SSAS, created cubes on top of the data warehouse for reporting purpose
  • Developed Power View reports using Tabular Models in SQL Server Data Tools.
  • Developed and deployed BISM tabular models using SQL Server Data tools.
  • Monitoring the jobs schedule and performance of the transform jobs.
  • Taking care of some DBA tasks such as creating backup maintenance plans, restoring databases, creating and monitoring SQL jobs.
  • Involved in documenting the requirements to develop the technical specifications.
  • Automate and enhance daily administrative tasks, including space management, object alteration, and performance monitoring.
  • Experienced in running Hadoop streaming jobs to process terabytes of xml format data.
  • Experienced in managing and reviewing Hadoop log files.
  • Experience in using Windows Azure.
  • Experience in using Power Shell.
  • Experience with Team foundation server bug tracking system.
  • Involved in providing 24*7 services for Hadoop based System called as ONESI.
  • Experience in providing live site support and incident resolution that includes on-call rotation.
  • Working on live site issues to fix slow running Stored procedures, triggers etc and provide Root cause analysis.
  • Experience using GIT and Code Flow.
  • Experience in Data Analysis, understanding trends and patterns in data.
  • Working on extracting the logs from Cosmos using Scope.
  • The query contains the logic to extract the information like event start time, event end time, tracking id, procedure name, database name, server name from the logs and then calculate metrics like duration, volume, maximum latency, minimum latency, Average latency, Percentile 75, percentile 95, percentile 99.
  • Using the above query results from Cosmos, creating reports in Power BI, Ads pulse to show the metrics by server and procedure name, by server etc.
  • By Identifying high latency Stored procedures with tracking id from the above-mentioned report and getting the trace for that tracking Id helps to identify the issue.
  • Developed custom calculated measures using DAX in Power BI to satisfy business requirements
  • Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
  • Working on ETL tasks using SSIS and SSAS tasks.
  • Experience in implementing data warehouse concepts

Environment: Azure Data Lake, U-SQL, Hadoop, Hive, COSMOS, SCOPE, SQL Azure, MS SQL Server 2014/2012/2008 R2, SSRS, SSAS, SSIS, T-SQL, VB Script, XML, SCOM, TFS, BIDS, SharePoint, SCOM, Power shell, Power Pivot, Power BI, SQL Azure.

Confidential, Sunnyvale, CA

MS SQL Business Intelligence Developer

Responsibilities:

  • Gathering reporting requirements from users and business analysts and analyzing requirements.
  • Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
  • Developed Dashboards to analyze sales, supply chain.
  • Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement. Performing query plans and making sure each query is using appropriate useful indexes.
  • Optimized long running stored procedures and queries for effective data retrieval.
  • Experience in maintaining the database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
  • Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
  • Worked on various tasks and transformations in SSIS like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination
  • Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Used C# and VB Scripts in ETL Packages where ever necessary.
  • Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions and Perspectives using SSAS 2008 R2.
  • Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Involved in Data Modeling using Star and Snow Flake Schemas using Ralph Kimball and Bill Inmon Methodology, ER Model, Dimensional Data Modeling, Dimensional Hierarchies, Physical & Logical Data Modeling.
  • Developed power view reports using Tabular Models in SQL Server Data Tools.
  • Developed and deployed BISM tabular models using SQL Server Data tools.
  • Automate and enhance daily administrative tasks, including space management, object alteration, and performance monitoring.
  • Involved in implementation of replications like Snapshot and Transactional.
  • Involved in handling live site production issues. Providing a hot fix for the problem within less than a day ETA.
  • I have experience in building servers using AWS, importing volumes, launching EC2, creating security groups.
  • Experience in using Windows Azure.
  • Experience in using Power Shell.
  • Experience in coordinating and working with Off shore team.

Environment: MS SQL Server 2014/2012/2008 R2, SSRS, SSIS, SSAS, T-SQL, VB Script, Server Data Tools, Windows Azure, Power Shell, AWS.

Confidential, Milpitas, CA

MS SQL Business Intelligence Developer

Responsibilities:

  • Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers in the database.
  • Created and Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis. Developing load scripts to populate data into the data ware house.
  • Monitoring the jobs schedule and performance of the transform jobs.
  • Taking care of some DBA tasks such as creating backup maintenance plans, restoring databases, creating and monitoring SQL jobs.
  • Improving performance of the server by analyzing the long running queries and performance tuning them.
  • Generated Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS reports according to the customer requirements.
  • Creating internal Operational reports to analyze the performance of the server in terms of load duration, transformation speed of the jobs (To track the time for loading the data into the staging tables and transforming them to the data warehouse)
  • Developing operational reports to monitor the load count of the records and the duration of the load.
  • Created Dashboards, scoreboards to generate more usable information the form of data visualization.
  • Experience in working with tabular models.
  • Experience in working with Power Pivot.
  • Experience with handling the adhoc issues in production environment.
  • Experience with dealing the issues with OFF shore team in Israel.
  • Provided on call support on rotation basis.
  • Experience using C#.
  • Expertise in Data Modeling using Star and Snow Flake Schemas using Ralph Kimball and Bill Inmon Methodology, ER Model, Dimensional Data Modeling, Dimensional Hierarchies, Physical & Logical Data Modeling.
  • Experience in designing Power BI reports depending on the Business requirements.
  • Developed and published several Power BI Reports.
  • Build the OLAP cubes with Dimension and Fact Tables using SQL Server Analysis service (SSAS).
  • In SSAS, created cubes on top of the data warehouse for reporting purpose
  • Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
  • Experience with Team foundation server bug tracking system.
  • The team flows the agile methodology.
  • Interacting with the users for requirements.
  • Documenting the requirements and implementation.
  • Developing the platform using Hadoop to store large data.
  • Using Hive to Query the HDFS files.
  • Involved in providing 24*7 services for Hadoop based System called as ONESI.
  • Experienced in running Hadoop streaming jobs to process terabytes of xml format
  • Experienced in managing and reviewing Hadoop log files
  • Experienced in defining job flows
  • Managing and resolving SCOM alerts.
  • Monitoring the Jobs using ICM portal and fixing the issues immediately.
  • Experience working with live site production issues.
  • Understanding about data related to Microsoft devices Xbox, Surface.

Environment: Hadoop, Hive, SQL Azure, MS SQL Server 2014/2012, SSRS, SSIS, SSAS, T-SQL, VB Script, SCOM, TFS, Server data tools, Power BI, SharePoint, SCOM.

Confidential

SQL Server Developer

Responsibilities:

  • Gathering reporting requirements from users and business analysts and analyzing requirements.
  • Designed and altered database objects to support new custom applications.
  • Involved in Dimensional Data modeling.
  • Optimized long running stored procedures and queries for effective data retrieval.
  • Created Stored Procedures, Views, and Functions in the Database.
  • Reorganize database structures as needed, automate procedures at regular intervals.
  • Developed Operational reports to support complex user requirements using SSRS.
  • Involved in creating package to load Member Master Table in SSIS which is helpful in tracking the history of tables.
  • Worked with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Script Component, Loop Containers, Execute SQL Task and lot more using SSIS.
  • Involved in creating various sub reports, drill down, drill through and parameterized reports.
  • Involved in creating SSRS Reports which are excel friendly to perform various operations like pivot.
  • Developed Dashboard reports to analyze the enrollment, payment and member suspend history.
  • Developed Reconciliation Reports to analyze the difference in different payment systems.
  • Involved in deployment of the reports to Windows Azure.
  • Involved in Unit Testing, Validating Reports and Production Support to resolve ongoing Production Problems by reviewing design changes made to production systems Involved in Performance tuning the SQL Server Queries used in SSRS Reports.
  • Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
  • Monitor and troubles shoot production issues during deployments.
  • Monitor strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and development databases.

Environment: SQL Azure, MS SQL Server 2012, SSRS, SSIS, SSAS, T-SQL, VB Script, Server Data Tools, Share Point.

­­

Confidential

Associate Developer

Responsibilities:

  • Involved in Installation and Configuration of MS SQL Server 2008 R2.
  • Involved in Configuring Team Foundation server with Visual studio.
  • Gathered reporting requirements from users and business analysts and analyzed requirements.
  • Designed and altered database objects to support new custom applications.
  • Involved in creating operational reports to monitor the number of rows updated, inserted, deleted after each ETL loading. (This helped in monitoring the ETL Loading).
  • Developed dynamic T-SQL scripts for operational reports.
  • Involved in Data modeling.
  • Worked on creating ETL Load scripts to populate the tables in the database.
  • Created Stored Procedures, Views, and Functions in the Database for Developing Reports.
  • Developed reports to support complex user requirements.
  • Developed drilldown, drill through reports which had complex groupings.
  • Developed parameterized reports, reports with cascading parameters.
  • Worked with complex bar charts.
  • Worked with the reporting tool FOCUS.
  • Involved in deployment of the reports.
  • Involved in testing the reports.
  • Involved in testing the data mart data against the Intake data.
  • Involved in Performance tuning the SQL Server Queries used in SSRS Reports and also used Report Snapshots for better performance.
  • Provided documentation for all kinds of reports and ETL Scripts.
  • Developed SSRS reports which are excel friendly when they are exported to excel.
  • Attend and report in Daily stand-up meetings.
  • Monitor Production Operation.
  • Troubles shoot production issues.
  • Provide end user support and assistance.
  • Enhancement of existing applications if needed.

Environment: MS SQL Server 2008 R2/2008, SSRS, SSAS, SSIS, T-SQL, Query Analyzer, MS Visio 2007/2003, Windows 2003/2000 Advanced Server, VB Script, Team Foundation Server, BIDS, FOCUS.

Hire Now