We provide IT Staff Augmentation Services!

Business Intelligence & Report Developer Resume

SUMMARY:

  • Over 7 years of experience as a Business Intelligence Developer in SQL Server 2016/2012/2008 R2
  • Hands on experience in all aspects of Software Development Life Cycle (SDLC)
  • Extensive experience in MS SQL Server 2016/2012/2008 R2 Business Intelligence technologies like MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS) and Power BI
  • Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, Enterprise Data Warehouse, Data marts, OLAP analysis and Reporting tools.
  • Experience in Normalization and De - normalization
  • Participated in AGILE iterative development methodology.
  • Participated on Microsoft Azure,Azure Devops provided by Microsoft.
  • Utilized Power BI(Power View, DAX query) to create various analytical Dashboards dat depicts critical KPI such as Profit,Gain,Loss,Customer status along wif slicers and dicers enabling business user to make filter the data.
  • Formulated and documented the physical ETL process design based on business requirements and system specifications, including source to target mappings, transformations, lookups, aggregations and expressions.
  • Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion wif multiple data flow tasks.
  • Involved in creating SSIS package to Export and Import data from SQL Server, Access, Oracle,DB2,Access databases, Text, EXCEL, XML and CSV files and Configured SQL mail agent for sending mails upon package deployment.
  • Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, aggregate, multicasting, conditional split and derived column.
  • Followed Data Management processes and procedures to meet system audits and provided input to the creation of data definitions, business rules and data access methods.
  • Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
  • Extensive experience in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)
  • Facilitated production ad-hoc and parameter driven reports using Microsoft T-SQL, SSRS and communicated project status to management as well as clients on a regular basis.
  • Analyzed Queries and boost the performance necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
  • Work closely wif Report analysts and operation staff for support in problem resolution and root cause analysis.
  • Worked wif Business analyst, Data architect and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
  • Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS)
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Designing enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.
  • Implemented different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse.
  • Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modelling, Snow flake modeling for fact and Dimension tables.
  • Strong proficiency in the use of T-SQL for developing complex stored procedures, triggers, tables, user-defined functions, relational database models and data integrity, SQL joins and query writing.
  • Full System Development Life Cycle(SDLC) experience including Requirement Gathering, Analysis, Design, Development, Testing and Implementation of various medium and large scale client/server application in a structured development environment
  • Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
  • Supported DBA in activities related to database and log backups, restoration, backup strategies and scheduling backups.
  • Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.
  • Provided documentation about database/data warehouse structures and updated functional specification and technical design documents.
  • Worked wif Azure Sql database.

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista/7, Windows Server 2003/2003 R2/2008/2008 R2

Database Tools: SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard

GUI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2005/2008/2010/2012/2014/2016, MATLAB for AI programming, Python

T: SQL,C++,C,VB.Net, Assembly Language

OLAP Tools: SSAS, SSRS,Power BI

Source Control Tools: Visual Source Safe 2005, Team Foundation Server 2010

ETL Tools: SSIS, DTS, Import/Export Wizard

PROFESSIONAL EXPERIENCE:

Business Intelligence & Report developer

Confidential

Responsibilities:

  • Work in a team development environment as well as work independently and efficiently to meet deadlines
  • Participate in application design and project planning sessions wif other developers and users
  • Establishes and implements standards and strategies for data management, lifecycle, and quality
  • Designs and monitors construction of an enterprise data warehouse, working wif a team of engineers
  • Continuously improves upon existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions
  • Assist wif testing and quality assurance activities wif data extracts
  • Conducts performance tuning of existing data structures
  • Responsible for creating SSIS package which extract data to single flat file from different data-source.
  • Troubleshooting of processes, issues and errors in SSIS Packages to improve their performance.
  • Administered SQL Server security, SQL server automatic e-mail notification and SQL Server backup strategy and automation.
  • Responsible for elevating and automating successful code to production environment ----part of Production Support
  • Advanced extensible reporting skills using SQL Server Reporting Services (SSRS). Created many complex stored procedures/functions and used them in SSRS directly to generate ad-hoc reports.
  • Processed and generated manual reports for the end business users on a daily, weekly, and monthly basis.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Create stored procedures comprising of dynamic scripts using Bulk Insert, Insert and Update tasks to copy data from multiple flat files to SQL server staging tables.

Business Intelligence Consultant

Confidential

Responsibilities:

  • Worked on SSAS Tabular Model and the data extraction process to identify the design of data source and data flows and convert into simple sources table for the migrated SQL databases and cloud environment.
  • To setup and automate Power BI platform using scripting languages like Python and Power Shell.
  • Scrum meeting to give the updated status of the project.
  • Developed drilldown, parameterized, and Ad hoc reports and charts using power BI.
  • Utilized Power Query to Pivot and Unpivot the data model for data cleansing and data processing.
  • Sharing existing Excel power Pivot into Power BI to the decision maker for strategic planning.
  • Build CI/CD pipeline to check in and migrate Power BI data sets/dashboards/reports between workspaces utilizing Power BI Power Platform, Take regular backup of workspace content & data sets using Power BI Rest APIs/PBI cmdlets
  • Designing a data structure wif multiple facts and dimension tables to hold the source data to be used for building new reports wif Power BI using DAX .
  • Worked on Power BI user tracking/logging, anomalies detection in published data sets and reporting .
  • Using DAX functional capabilities like Aggregation, Date & Time function, Financial, Information,Logical,Math,Time Intelligent and Table manipulation functions, me created reports for the business user to see current status,profit,loss and overall gain of the business.
  • Designiing Power BI data visualization utilizing cross tabs, maps,scatter plots,pie, bar,density charts.
  • Perform Unit testing, User acceptance testing during the development phase of the product.
  • Created and maintained database objects (tables, stored procedures, and views).
  • Optimized the performance of queries wif modification in T-SQL queries, normalized tables, established joins, and created indexes.
  • Experienced in working wif many complex SQL queries using joins and date functions to generate various reports.
  • Involved in generating and maintaining Azure SQL scripts.
  • Created complex stored procedures for complex reports developed using SSRS 2008
  • Developed drilldown, drill through, parameterized, and Ad hoc reports and charts using SSRS.
  • Advanced extensible reporting skills using SQL Server Reporting Services (SSRS). Created many complex stored procedures/functions and used them in SSRS directly to generate ad-hoc reports.
  • Processed and generated manual reports for the end business users on a daily, weekly, and monthly basis.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Create stored procedures comprising of dynamic scripts using Bulk Insert, Insert and Update tasks to copy data from multiple flat files to SQL server staging tables.
  • Designing a data structure wif multiple tables to hold the source data to be used for building new reports wif PowerBI .
  • Extensive testing on the performance of the stored procedures.
  • Worked wif Azure SQL as a part of the new migrated environment

Sr Business Intelligence Developer

Confidential

Responsibilities:

  • Gatheird business requirements, definition and design of data source and data flows.
  • Initiate Scrum meeting to get the updated status of the project.
  • Provide supports during On Call weekly basis.
  • Perform Unit testing, User acceptance testing during the development phase of the product.
  • Created and maintained database objects (tables, stored procedures, and views).
  • Optimized the performance of queries wif modification in T-SQL queries, normalized tables, established joins, and created indexes.
  • Experienced in working wif many complex SQL queries using joins and date functions to generate various reports.
  • Involved in generating and maintaining SQL scripts.
  • Created complex stored procedures for complex reports developed using SSRS 2008
  • Developed drilldown, drill through, parameterized, and Ad hoc reports and charts using SSRS.
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS). Created many complex stored procedures/functions and used them in SSRS directly to generate ad-hoc reports.
  • Processed and generated manual reports for the end business users on a daily, weekly, and monthly basis.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema and snowflake schema.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
  • Create stored procedures comprising of dynamic scripts using Bulk Insert, Insert and Update tasks to copy data from multiple flat files to SQL server staging tables.
  • Involved in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012.
  • Extensive testing on the performance of the stored procedures.
  • Advanced extensible reporting skills using SQL Server Reporting Services (SSRS). Created complex stored procedures/functions and used them in SSRS directly to generate ad-hoc reports.
  • Processed and generated automated reports for the end business users on a daily, weekly, and monthly basis.

SQL Server SSIS/SSRS/SSAS Developer

Confidential

Responsibilities:

  • Created and maintained database objects (tables, stored procedures, and views).
  • Optimized the performance of queries wif modification in T-SQL queries, normalized tables, established joins, and created indexes.
  • Experienced in working wif many complex SQL queries using joins and date functions to generate various reports.
  • Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports
  • Developed drilldown, drill through, parameterized, and Ad hoc reports and charts using SSRS.
  • Processed and generated manual reports for the end business users on a daily, weekly, and monthly basis.
  • Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema and snowflake schema.
  • Designing a data structure wif multiple facts and dimension tables to hold the source data to be used for building new reports wif SSRS.
  • Involved in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
  • Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, aggregate, multicasting, conditional split and derived column.

SQL SSIS/SSRS/SSAS Developer

Confidential

Responsibilities:

  • Actively participated in gathering of User Requirement and System Specification.
  • Designed high level ETL architecture for overall data transfer from the source server to the destination server which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
  • Developed SSIS Packages to load data into database and flat file using SSMS 2008 R2 and BIDS 2012.
  • Responsible for creating SSIS package which extract data to single flat file from different data-source.
  • Troubleshooting of processes, issues and errors in SSIS Packages to improve their performance.
  • Administered SQL Server security, SQL server automatic e-mail notification and SQL Server backup strategy and automation.
  • Responsible for elevating and automating successful code to production environment
  • Wrote SQL queries and stored procedures to generate data for reports.
  • Deployed and configured the reports in the Report Server.
  • Created Parameterized reports, Cross-Tab reports, Drill Down reports by using SSRS.

Hire Now