We provide IT Staff Augmentation Services!

Msbi Developer Resume

3.00/5 (Submit Your Rating)

Iselin, NJ

SUMMARY

  • Around 7+ years of IT experience as MS SQL BI Developer and involved in Designing, Development, Implementation and Maintenance of applications and strong background in Data - warehousing and ETL.
  • Strong programming experience in TSQL and SQL SERVER 2008R 2/ 2012/2014/2016 , BI tools such as SSIS, SSRS, Power BI, Tableau and Performance Analysis, Deployments, Production Support.
  • Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources by using multiple transformations.
  • Expertise in developing complex SSIS packages using SSDT 2015/2012/2008 and developing dashboards using Power BI from scratch.
  • Designed and developed SSIS packages using control flow tasks like For Loop Container, For Each Loop Container, Execute SQL Task, File System Task and Data Flow Tasks like Lookup, Derived Column, Conditional Spilt, Sort, Data Conversion, Multicast, Union All and Merge Join.
  • Strong knowledge inPowerBIon how to import, shape, and transform data for business intelligence.
  • Experience in creating and deploying parameterized reports using Power BI and writing custom DAX functions in Power BI and Power Pivot.
  • Worked on creating reports and dashboards using different type of slicers and different visualizations in Power BI.
  • Created analytical reports and visualizations with Microsoft Excel 2013, Power BI tools (Power View, Power pivot and Mapping) for exploratory analysis for data analysts
  • Experience in implementing Power BI gateway different source to matching analysis criteria and further modeling for Power Pivot and Power View.
  • Created Calculated Columns and Measures in Power BI depending on requirement using DAX queries.
  • Experience in implementing dashboards, visualizations, analytics using Tableau desktop and server.
  • Designed and deployed reports with dropdown and drilldown menu option and Parameterized and Linked Reports using Tableau.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, prompts, Calculated fields, Sets, Groups, Parameters in Tableau
  • Experience in scheduling instances for generating reports on the Tableau server.
  • Hands on experience executing Python scripts for Data cleansing.
  • Experience in creating complex ETL packages using SQL Server 2012/2014/2016 Integration services.
  • Experience in incremental and full load data migration from various data sources (Flat Files, Excel, MS Access, oracle) using ETL.
  • Experience in creating various Reports using SQL Server Reporting Services SSRS, Crystal Reports.
  • Proficient in creating several reports such as drill down reports, drill through reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
  • Good understanding of Data Warehouse principles using Fact Tables, Dimension Tables, Star/Snowflake Schema modeling and data modeling.
  • Experience in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables.
  • Experience in tuning T-SQL queries and improving the performance of the Database.
  • Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
  • Experience in creating jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent according to the business or application needs.
  • Experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
  • Good Knowledge in Database Backup, Recovery and Disaster Recovery procedures.
  • Involved in unit testing, performance, and system testing.
  • A self-motivated Individual with exemplary analytical and problem-solving skills.

TECHNICAL SKILLS

SQL Server Tools & Packages: SQL Server Management Studio (SSMS), SSIS, SSRS, SSAS, SQL Server Profiler, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Enterprise Manager, Data Transformation Services (DTS), Query Analyzer

Database: SQL Server 2008R 2/ 2012/2014/2016 , MS Access, Oracle 11g/12c

Reporting Tools: SSRS, Power BI, Tableau, Excel Reporting

Languages/Scripting: PL/SQL, T-SQL, Shell Scripting, Python, VB.NET, HTML, CSS, XML

Workflow Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Access, MS Project

Data Modeling: FACT & Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling, Normalization and De-Normalization Techniques

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Job Scheduling Tools: SQL Server-SQL Agent

Operating Systems: Windows XP/2008/2010, UNIX, LINUX, DOS

PROFESSIONAL EXPERIENCE

Confidential

MSBI Developer

Responsibilities:

  • Working on a Data Conversion project, extracting data from a legacy system IBM Lotus notes and transform, cleanse, and inject the data into Microsoft Dynamics D365, a cloud-based CRM and ERP solution on Azure.
  • Worked on creating the complex database tables based on the requirements where we stage the data extracted from Lotus Notes using Notrix software.
  • Developed Microsoft SQL SSIS Packages for consolidation of the data and developing technical design and support documents.
  • Planning and performing data mapping between source and target systems.
  • Worked on multiple Data Dictionaries, mapped, and validated data across various Applications using Microsoft Excel.
  • Execute Python scripts for data cleansing after consolidation to remove duplicates, replace sensitive data with GUIDs.
  • Worked on data-Ingestion of the data from SSMS to the Microsoft Dynamics CRM. Used Kingsway-soft as a tool to connect to the Dynamics 365 from the SSIS.
  • Analyzed and transformed data with the option sets using XRM Toolbox to bring the required option sets for the Data Dictionary working on.
  • Worked on Power Apps for Data Mapping and creating Cloud Flows to migrate the Data across different servers using Data Gateways and Connection references to the servers.
  • Scheduled the SSIS jobs on a timely basis to prepare them for the GO-LIVE.
  • Responsible for creating and changing the visualizations in Power BI reports and Dashboards.
  • Developed various power BI Reports and Dashboards from multiple data sources using Data Blending based on the client requirements.
  • Published Power BI Desktop reports created in Report view to the Power BI service.
  • Migrated existing self-service reports and ad-hoc reports to Power BI.
  • Worked on both live and import mode to bring data to Power BI for creating reports. Used Power BI gateway to schedule daily job to refresh data
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views.
  • Worked on a 3-week sprint cycle, to deliver the deliverables to the customer. Communicated with the customers to meet the standards and maintain Data Quality all along.
  • Have been working on an Agile methodology, using JIRA as a platform to track the status of the tasks and Kanban Board to have a clear picture on the Road Map and understand what must be done in the current sprint cycle.
  • Worked closely with cross functional teams rendering full support migrating the Data to a Cloud Platform, Microsoft Dynamics 365, solving the issues and validating the data.
  • Used SharePoint to maintain and update the Documents shared across multiple teams to keep a track of the changes the Data is going through.
  • Maintain Data Quality on the deliverables and On-time delivery with a great customer satisfaction.

Environment: MSSQLServer 2016, SQLServer Integration Services (SSIS), SSMS, SSDT, Microsoft Dynamics, Notrix, Azure, Power BI, MS Excel, JIRA, Microsoft Power Apps, Windows 10.

Confidential, Iselin, NJ

SQL/BI Developer

Responsibilities:

  • Involve in every phase of Software Development Life Cycle (SDLC) including Requirements gathering, Design, Development, Testing, Deployment and support.
  • Using SQL Server SSIS 2016 created various packages to bring data into the staging area from various sources like text files, Excel and SQL Server databases.
  • Worked on the Reports module of the project as a developer on MSSQL Server 2016(usingSSRS, T-SQL, stored procedures and views).
  • Layout design plan for ETL process to populate dimensions and fact tables.
  • Developed SSIS configurations using XML, SQL run tables and various dynamic expressions.
  • SSIS logging using both traditional SSIS logging via tool as well as use system variables to take log.
  • Automate and schedule daily, weekly and monthly SSIS, SQL jobs using SQL server job agent.
  • Developed SSIS packages and deployed into Dev, Test and Production Environments.
  • Deploy and maintain SSIS packages both by using SQL and File system deployment.
  • Troubleshooting the failed SQL jobs due to errors in the sample processing and fixing them and re-scheduling the SQL Jobs.
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs enabling end-user to make filters.
  • Implemented DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • UsedPowerBIPowerPivot to develop data analysis prototype and usedPowerView andPower Map to visualize reports.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. And formatted dashboards, multiple chart types, trends and KPIs with Power View to support analyses.
  • Created reports in Power BI preview portal utilizing the SSAS Tabular.
  • Published Power BI Desktop reports created in Report view to the Power BI service.
  • Transformed and combined the data using Query Editor in the Power BI.
  • Developed complex stored procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Deployed the generated various reports using SSRS, data driven report subscription.
  • Debugging reports performance (SSRS) using error log and provide recommendations upon identifying the issues and help in resolving them.
  • Designed and deployed reports with dropdown and drilldown menu option and Parameterized and Linked Reports using Tableau for a Client based requirement.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps and Gantt charts using show me functionality.
  • Worked on User access and permissions at various report levels and reports subscription.
  • Created new stored procedures and updated the existing procedures as per the business requirement. Involved in creating Adhoc Stored procedures as well.
  • Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
  • Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures.
  • Worked under Agile Methodology throughout the project.

Environment: Microsoft SQL Server 2016/2014, Oracle 12c, SSRS, SSIS, Power BI, Tableau 2020.2, SQL Profiler, T-SQL, GitHub, SharePoint, Bit Bucket, DTS, Microsoft Visual Studio 2013, Microsoft Office, Microsoft Teams

Confidential - Louisville, KY

SQL/MSBI Developer

Responsibilities:

  • Analyze, design, develop and document reports using Microsoft SQL Server 2014 and SSRS against proprietary and packaged application databases.
  • Designed and created data extracts, supporting SSRS, POWER BI and other visualization tools for reporting applications.
  • Create operational reports, parameterized, dashboards, drill down, sub reports, cross tab and other complex reports and publish using SharePoint.
  • Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
  • Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
  • Unit test reports to identify defects and data issues and to ensure an accurate, high quality end product for delivery to reporting users.
  • Upload SSRS reports to Web portal using SharePoint.
  • Used MicrosoftPowerBIPowerQuery to extract data from external sources and modify data to certain format as required in Excel.
  • CreatedPowerBIDashboards (PowerView,PowerQuery,PowerPivot, andPowerMaps) and integrated them to share point.Created the power view reports using the Tabular SSAS model in Excel.
  • Created DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Expertise in writing complex DAX functions inPower BI and Power Pivot.
  • Worked on Scheduling Automatic refresh and scheduling refresh in Power BI service.
  • Migrated existing self-service reports and ad-hoc reports to Power BI.
  • Developed tabular queries for efficient analysis of report usingPivot/Un pivotinT-SQL.
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs enabling end-user to make filters.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • UsedPowerBIPowerPivot to develop data analysis prototype and usedPowerView andPower Map to visualize reports.
  • Developed SSIS packages to extract and transform data and Involved in Scheduling SSIS Packages and Using SQL Server Integration Services (SSIS) to populate data from various data sources using concept of OLE DB.
  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
  • Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors. Captured technical metadata through data modeling tools.
  • Worked on Data Transfers between various servers using BCP.
  • Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
  • Worked with star schema by building relationships between Fact Table and Dimension tables.
  • Work with application development teams to update existing SSIS packages and reports as underlying application design is enhanced/changed.
  • Automate and schedule daily, weekly and monthly SSIS, SQL jobs using SQL server job agent.
  • Provided on call support for the job failures in the SQL Agent and rerun the jobs post resolution.
  • Responsible for checking databases, jobs, nightly backups on all servers and monitored system log, security log on Event Viewer.
  • Design and creation of tables and stored procedures with E-R diagrams.
  • Writing the stored procedures, checking the code for efficiency using T-SQL.
  • Created and maintained various databases for development and testing environment using SQL Server.
  • Write complex SQL queries and stored procedures to meet business requirements.

Environment: MS SQL Server 2014/2016, T-SQL, SSIS (ETL), SSRS, Power BI, SQL Agent, Windows 2012 Servers, XML, MS Excel and MS Access, JIRA, Visual Team Foundation Server, visual studio 2012, Visio

Confidential

BI Developer

Responsibilities:

  • Created ETL packages with different data sources (SQLServer, Flat Files, Excel source files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
  • Used various Data Flow Transformations like Lookup, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
  • Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation.
  • Execute data validation stored procedures in SSIS packages in Business Intelligence Development Studio.
  • Worked on creating SSIS Script tasks integrating with C# to increase SSIS functionality.
  • Test and manage the SSIS packages.
  • Used Temporary tables, Table variables and Common Table Expressions (CTE) depending on requirement. Transferred data from various sources like MS Excel, Flat File andSQLServer using SSIS and then created reports using this data using SSRS.
  • Create different type of reports including: A Sub report, Drill-down and Parameter prompts, Linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Developed critical SSRS reports using T-SQLstored procedures with parameters and without parameters and complexSQLqueries with custom coding for dynamic tables.
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
  • Responsible for creatingSQLdatasets for Power BI.
  • Expert on creating multiple kinds of Power BI Reports and Dashboards.
  • Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designed error table.
  • Involve in Type 1 and Type 2 slowly changing dimensions using SSIS and Scheduling the SSIS packages by creating a Job usingSQLAgent in SSMS.
  • Created forms on share-point to show live data from underlying data-sources likeSQLServer to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data sources.

Environment: MSSQLServer 2014,SQLServer Integration Services SSIS, SQL Server Data Tools Installed (SSDT), BIDS, Power BI, T-SQL, MS Excel, Windows 2010 Server.

Confidential

SQL Developer/Data Analyst

Responsibilities:

  • Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS
  • Implemented SQL Server SSIS packages for ETL methodologies
  • Installed, configured and maintained SQL Server Integration Services (SSIS).
  • Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.
  • Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
  • Developed reports using Cognos and experience working with report studio, query studio and framework.
  • Developed custom selection of reports ordering using SQL Server Reporting Services(SSRS)
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Deployed reports in to Report Manager.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • CreatedSQLServer Reports using SSRS.
  • Developed Query for generating drill down reports in SSRS.
  • Worked with Business Analysts & Business stakeholders in gathering requirements and developing them into Tableau Dashboards and Reports.
  • Developed and reviewedSQL querieswith use of join clauses inTableau Desktopfor validating static anddynamic parametersdata for data validation.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Developed Tableau dashboards/workbooks to display PCS summary reports, PCS playbook reports, FMU vs MLE distribution and Pending Exposure report to Business
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
  • Developed visualizations like Bar, Bubble, Line, Area, Stacked Bar, Pie and Donuts charts. Created workbooks using calculated fields for different visualization requirements.
  • Created and assisted users in Tableau dashboard development by providing various levels of Drill Down functionality to understand the business in detail.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code andSQLjoins for applications.
  • Implemented different types of constraints on tables.
  • Managed index, statistics and optimizing queries by using execution plan for tuning the database.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Monitored Scheduled jobs and alerts.

Environment: SQLServer 2012, SSIS, SSRS, T-SQL, MS Access, Oracle 12c, Tableau, Redgate Tools, MS Excel, Windows 2010 Server, SQL source control

Confidential

SQL Developer

Responsibilities:

  • Involved in Analysis of the Business requirements and source systems.
  • Designed the mapping technical specifications on the basis of functional requirements.
  • Designing and documenting the High-Level process flow of extracting the data from the Source system till loading the data in Data warehouse.
  • Responsible for transferring the data using SSIS packages.
  • Developed, monitored, and deployed SSIS packages.
  • Analyzed reports and fixed bugs in stored procedures.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code andSQLjoins for applications.
  • Implemented different types of constraints on tables.
  • Managed index, statistics and optimizing queries by using execution plan for tuning the database.
  • Maintained the physical database by monitoring performance, integrity and optimizeSQLqueries for maximum efficiency usingSQLProfiler.
  • CreatedSQLServer Reports using SSRS.
  • Developed Query for generating drill down reports in SSRS.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Involved in Performing the Unit testing and basic functional testing.

Environment: SQLServer2012, SSIS, SSRS, T-SQL, SVN, Windows 2010 Server, SharePoint.

We'd love your feedback!