We provide IT Staff Augmentation Services!

Sql/msbi/power Bi Developer Resume

Dallas, TX

SUMMARY:

  • Database developer with 7.5 years of Experience in IT domain focused on Robotic Process Automation (RPA), Confidential SQL Server 2008/2012/2014 , Confidential Business Intelligence (MSBI), OLTP, OLAP, Confidential Power BI, Tableau, C#, .NET, Oracle, Statistical Analysis System (SAS) with expertise in Blue Prism, UIPath, T - SQL, Advanced SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Confidential Power BI, SQL Server Administration (DBA), Design, Development, Testing and Support phases of SDLC for Data Warehouse working in Agile, Waterfall environment. Good analytical and interpersonal skills strengthened with diligence and human values have been the prime constituents of my approach to tackle challenges.
  • Expertise in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) in Confidential Business Intelligence (MSBI), Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT).
  • Strong Knowledge and experience in C#, VB, Blue Prism, UIPath in developing Business Objects and processes.
  • Automated numerous routine tasks using Blue Prism and UIPath thereby reducing Manual intervention.
  • Experience in RPA script programming using C# and VB.
  • Knowledge on Automation Anywhere and Work fusion RPA tools.
  • Experience in performing different operations like creating procedures, tasks, code snippets, performing Statistical Analysis and generating dashboards using SAS.
  • Extensive experience in Tuning SQL queries and improving the query performance.
  • Experience in creating and loading XML files into data base.
  • Proficient in creating Indexes, Views, Stored Procedures, appropriate functions and SQL scripts related to various DDL and DML operations.
  • Experience in SQL data base Administration(DBA) activities like Restore and Backup of databases, monitoring server health, Job scheduling, Configurations, Granting and revoking access for users, reviewing database sizes and growth settings, Database recovery, Database snapshot and replication processes.
  • Experience in mirroring, clustering, database shrink operations and usage of DBCC commands.
  • Experience in Database Normalization, Optimization and tuning, Database Objects authorization.
  • Experience in using Oracle connectors and migrating the data from Oracle to SQL.
  • Experience in creating Oracle PL/SQL Procedures, functions and Oracle queries.
  • Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge, Merge Join, Lookup, Sort, Union All, Conditional Split, Aggregate, Derived Column, Data Conversion Transformations, Execute SQL Task, Script Task, Custom Tasks, Sequence container, For each loop container and For loop container.
  • Experience in creating Event Handlers and SSIS logging through SQL table and Flat files.
  • Experience in SSIS package deployment using manifest files and project deployment model.
  • Configured Connection Manager files for SSIS packages to dynamically execute in Quality Analysis server and Production server.
  • Experience in creating Tabular, Matrix, Drill down, Drill through, Parameterized and Sub Reports, Share Point reports in SQL Server Reporting Services (SSRS) and deploying them in various environments using Report Server and Report Manager.
  • Formatted the Reports using Global variables and Expressions in SSRS.
  • Experience in creating SQL Jobs and scheduling them through SQL Server Agent.
  • Experience in creating Bar and column charts, stacked area charts, Gauge charts, Doughnut charts, Funnel charts, Pie charts, Key Performance Indicators (KPI), Time-line slicers, Chicklet slicers and other custom visualizations using Power BI Desktop.
  • Knowledge and experience in creating basic reports using Tableau.
  • Experience in creating Data Source Views, Dimensions, Measures, Partitions, Perspectives, Roles, Aggregations, KPI’s, Actions, Calculations in OLAP SQL Server Analysis Services (SSAS) Cubes.
  • Experience in Cube processing and deployment using various methods.
  • Experience in creating DAX functions related to SUM, Mean, Median, Mode.
  • Experience in Slicing, Dicing and creating sub cubes using MDX
  • Experience in Black Box, White Box Testing. Proficient in Functional & non-Functional Testing which includes Unit, Functionality, Negative, Regression, Integration, System testing.
  • Strong debugging skills and the ability to solve complex problems.
  • Good team player with strong analytical skills.
  • Hands on experience in installing, configuring, managing and monitoring SQL 2014/2012/2008 .
  • Experience in working with Team Foundation Server (TFS) version control.
  • Effective in working independently and collaboratively in teams.
  • Involved in creating Technical documents as per the customer requirements.
  • Effective communication and interpersonal skills with the ability to focus on multiple tasks in a goal-oriented manner.
  • Good Knowledge on SQL Azure Data warehouse and Azure Data factory.

TECHNICAL SKILLS:

Languages: SQL, Transact SQL, Advanced SQL, PL/SQL, C#, VB

Technologies: RPA, Blue Prism, UIPath, SAS

Databases: SQL Server 2014/2012/2008 R2, Oracle 10g/11g

Reporting Tools: SQL Server Reporting Service (SSRS), Power BI Desktop

ETL Tools: SSIS (SQL Server Integration Services)

Other Software: MS Office 2013/2010/2007 , Adobe Professional

Operating Systems: Windows XP/Vista/7/8.1/10

Database Tools: SQL Server Management Studio

Methodologies: Logical and Physical Database Design, Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL/MSBI/Power BI Developer

Responsibilities:

  • Creation of stored procedures using SQL Server Management Studio.
  • Modification of existing stored procedures for performance optimization.
  • Write, update, maintain SSIS packages to handle specific jobs.
  • Migration of existing SSIS packages from SQL 2005 to SQL 2012 and SQL 2014.
  • Creation of various reports using SSRS and Power BI on a scheduled and Adhoc basis.
  • Manage source code and build repositories.
  • Deployment of packages in SIT and UAT environments using project deployment model.
  • Deployment of SSRS reports in SIT, UAT and production environments.
  • Identification of Blocks and Deadlocks on multiple Production servers using Spotlight, Foglight and will resolve them on a high priority basis.
  • Reducing CPU utilization and CPU wait times on production servers.
  • Responsible for Customer support and using Splunk and Service now to meet support requirements.
  • Creating jobs and scheduling of packages through SQL Server Agent.
  • Trouble shooting and error handling of SSIS packages.
  • Documentation with flow diagrams and required support guidelines.
  • Working on creating Data factories to extract data from source table and load into target tables.

Environment: Confidential SQL Server 2005/2008 R2/2012,2014, Confidential Excel 2010/2013, Confidential SQL Server Integration Services (SSIS), Confidential SQL Server Reporting Services (SSRS), Confidential SQL Server Reporting Services (SSAS), Power BI Desktop, Power BI Online.

Confidential, Wayne, PA

RPA/SQL/MSBI/Power BI Developer

Responsibilities:

  • Created UIPath robots which automatically retrieves the data for daily subscription process in insurance domain.
  • Automated normal and OCR text in PDF’s using Screen Scraping to calculate the invoices and store them into a data table using UiPath.
  • Automated Email process as a POC using UiPath.
  • Implemented all the Basic, Desktop, web recordings using numerous activities and Flow charts using UiPath.
  • Fine-tuned the existing SQL queries for performance optimization and to reduce the manual effort while retrieving the data.
  • Created Oracle connectors to migrate data from Oracle source systems to SQL tables.
  • Created Oracle PL/SQL Procedures and functions as per user requirements.
  • Designing SSIS packages that communicates with Web Services and Rest API services data sources.
  • Validating the data consumed through the web services.
  • Used the custom tasks from SSIS power pack to consume the data from Rest API and Web services like ZS Rest API Task, ZS JSON transformation, ZS XML Task when the source data is not in the expected format or if the Web Service Description Language (WSDL) file is not available.
  • Used File System Tasks to move the files to archive folder once they are processed.
  • Generating SSRS reports with excel as a data source for end users.
  • Created Bar charts, Pie charts, Drill down reports and parameterized reports using SSRS.
  • Created Stacked Area charts, Gauze charts, Funnel charts Drill down reports and parameterized reports using Power BI.
  • Created Bar charts, Pie charts using Tableau for POC purpose.
  • Created data sets, tasks, snippets in SAS studio with Excel and files with different delimiters as a data source.
  • Created different procedures and used in-built procedures in SAS for Mean, Frequency distribution, Standard deviation using SAS Studio.
  • Used Histograms, Bar charts, Pie charts for representing different statistics in SAS.
  • Created Tabular cubes in SSAS and generated reports using Power BI.
  • Created Dimensions, Measures and partitions and KPI's for the Tabular cubes.
  • Deployment of packages in SIT and UAT environments using project deployment model and Ispac files.
  • Deploying the SSRS reports in SIT and UAT environments.
  • Creating jobs and scheduling of packages through SQL Server Agent.
  • Documentation with flow diagrams and required support guidelines.

Environment: UIPath, Confidential SQL Server 2014, Confidential Excel 2010/2013, Confidential SQL Server Integration Services (SSIS), Confidential SQL Server Reporting Services (SSRS), Confidential SQL Server Reporting Services (SSAS), Power BI Desktop, Power BI Online, Oracle 11g, SAS Studio.

Confidential, Redmond, WA

SQL/MSBI/RPA Developer

Responsibilities:

  • Developed various Azure SQL objects such as Tables, Views, Indexes, Constraints and granted permissions to the users on those OLTP database objects.
  • Created XML files and loaded them into Database.
  • Developed, monitored and deployed SSIS packages related to ETL flow to validate, extract, transform and load data into database.
  • Performed Full load & Incremental load with several Data flow tasks like Lookup and Slowly Changing Dimensions(Type-2) and Control Flow Tasks using SSIS.
  • Developed SSIS Packages using For-Each loop container to loop through all the Excel files and Flat files in the source folder path.
  • Fine-tuned the SQL queries using the execution plans by creating Indexes and constraints wherever necessary and made sure that there is no redundancy in the data.
  • Created SSIS packages to Import the Data from Excel and Flat files to Azure-SQL tables.
  • Configured Excel and Flat File Connection Managers for SSIS packages to dynamically validate, process and load those files in UAT and Production environments.
  • Created XML Package Configurations so that those files can be used for package executions if necessary.
  • Created Oracle queries to pull the data from source system.
  • Tuned Oracle queries for performance optimization and used different types of Joins for retrieval of data.
  • Designed developed and tested Bot tasks using Blue Prism.
  • Implemented End to End Robotic Process Automation (RPA) using Blue Prism for Products web application.
  • Implemented Excel Automation for Invoice activities using Blue Prism.
  • Created reusable components in Object studio and used them in Process studio.
  • Created external scripts using VB and integrated with Blue Prism to achieve RPA.
  • Implemented Blue Prism user authentication by defining user roles, creating users and setting password policies.
  • Created Basic Area Charts, Stacked Area Charts, Bar Charts, Column Charts, Single number cards, Multi-row cards, Combo Charts, Doughnut Charts, Funnel Charts, Line Charts, Gauge Charts, Key Performance Indicators(KPI’s), Basic Maps, Pie Charts, Scatter and Bubble charts, Slicers, Tree Maps, Waterfall Charts using Power BI Desktop.
  • Created Dimensions, Measures, Measure Groups for Tabular Cubes.
  • Added Partitions to enhance the performance of cubes
  • Created Cube perspectives for the end users.
  • Used MDX to calculate YTD, QTD, TOP COUNT, MTD sales values.
  • Creating Dashboards for the generated reports and sharing those reports across specific groups.
  • Refreshing reports by creating Gateways for connecting with On-premise SQL databases.
  • Created Content packs to share the designed reports across the team for further modifications.
  • SQL data base Administration(DBA) activities like installation of SQL Server 2016 and components, Restore and Backup of databases, monitoring server health, Job scheduling, Granting and revoking access for users, reviewing database sizes and growth settings, Database recovery, Patching, Database snapshot and replication processes.

Environment: Blue Prism 5.0, Confidential SQL Server 2012/2014, Confidential Excel 2010/2013, Confidential SQL Server Integration Services (SSIS), Confidential SQL Server Analysis Services (SSAS), Power BI Desktop, Power BI Online, Oracle 11g.

Confidential, Chicago, IL

SQL/SSIS/SSRS Developer

Responsibilities:

  • Involved in gathering requirements, business rules and deliver them in time
  • Created Complex Stored Procedures for implementing the business rules, also worked on SQL joins, CTEs (Common Table Expressions), Materialized Views, Aggregate Conditions.
  • Used Joins, sub-queries for complex business queries involving multiple tables from different databases.
  • Worked on Performance Tuning to reduce the runtime and increase performance & efficiency.
  • Involved in SSIS packages to bring data from Oracle, Excel and Flat Files using SQL Server Integration Services (SSIS)
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Execute SQL task, Merge using SQL Server 2012.
  • Imported data from excel sheets using SQL Server Integration Services (SSIS) 2012.
  • Created Drill-through, Drill-down, Tabular and Matrix reports.
  • Strong Experience in report design with SQL Server Reporting Service (SSRS).
  • Created Bar and column charts, stacked area charts, Gauge charts, Doughnut charts, Funnel charts, Pie charts Key Performance Indicators (KPI), Time-line slicers, Chicklet slicers and other custom visualizations using Power BI Desktop.
  • Deployment of the generated reports.
  • Created reports that included formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.

Environment: Confidential SQL Server 2012, Confidential Excel 2010/2013, Confidential SQL Server Integration Services (SSIS), Confidential SQL Server Reporting Services (SSRS).

Confidential, MD

SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Table Structures.
  • Developed SQL Queries to fetch data from different tables using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
  • Designed and built up high performance ETL packages to migrate and manipulate data from Excel source to SQL Server by using SSIS.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both Development and Production environments.
  • Created SSIS packages to move and copy files using File System task.
  • Created SSIS packages to loop through a folder of files using For-each loop container.
  • Created manifest files to deploy SSIS Packages.
  • Created shared and embedded data sets to develop tabular reports.
  • Created Parameterized reports and deployed them in various environments to serve the purpose of end users.
  • Experience in creating crystal reports using SQL and C#.
  • Restore and Backup of databases, monitoring server health, Job scheduling, Granting and revoking access for users, reviewing database sizes and growth settings, Database recovery, Patching, Database snapshot and replication processes.
  • Provided support to deployment activities in UAT and Production environments.
  • Created Partitions in SSAS to improve the performance of Cube.
  • Created Roles to ensure Security to OLAP Cube.
  • Used MDX to calculate TOP COUNT, BOTTOM COUNT, LAG, LEAD based on the requirement.
  • Created sets and tuples using MDX for querying on SSAS Cubes.

Environment: Confidential SQL Server 2008/2012, Confidential Excel 2010/2007, Confidential SQL Server Integration Services (SSIS), Confidential SQL Server Reporting Services (SSRS), Confidential SQL Server Analysis Services (SSAS).

Confidential, Chantilly, VA

SQL Server/ SSIS/ SSRS Developer

Responsibilities:

  • Actively interacted with end user to gather business requirement, system specification and enhancement.
  • Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, OLTP Table Structures.
  • Developed SQL Queries to fetch data from different tables using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
  • Optimized the performance SQL queries by removing duplicates, established joins and created clustered/non-clustered indexes wherever necessary.
  • Created SSIS packages to load data from database on different servers.
  • Created SSIS package to load data from Flat File to SQL Server using Lookup, Derived Columns, Condition Split, Row Count, Aggregate Transformations.
  • Converted data with the Data Conversion transformation and then sorted data to remove duplicates.
  • Configured the File connection managers dynamically.
  • Created manifest files to deploy SSIS Packages.
  • Created shared and embedded data sets to develop tabular reports.
  • Created Drill down reports and deployed them in various environments to serve the purpose of end users.
  • Provided support to deployment activities in UAT and Production environments.

Environment: Confidential SQL Server 2008, Confidential Excel 2007/2003, Confidential SQL Server Integration Services (SSIS), Confidential SQL Server Reporting Services (SSRS), SQL Server Business Intelligence Development Studio (BIDS).

Hire Now