We provide IT Staff Augmentation Services!

Sr Bi Developer Resume

SUMMARY

  • 7 years of professional experience in developing and implementing projects in various business domains like Financial, Insurance using Microsoft Business intelligence 2012/2014/2016 (SSIS, SSRS, SSAS, Power BI Desktop/Service, DAX, MDX, Azure Synapse) and Tableau.
  • Responsible for Data Sourcing and Pre - processing for SAP Callidus.
  • Responsible for Offshore deliverables with 100% Quality and managed a team of 4 people at offshore.
  • Responsible for project estimates, deliverables, SME Level support and daily status report calls.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring, scheduling, backup & recovery and troubleshooting SQL Server 2012/2014/2016 and Power BI.
  • Experience in writing complex stored procedures, triggers, views, cursors, stored procedures, CTE and User Defined Functions (UDF’s). Informatica
  • Hands on experience in Designing and building data mart and data warehouse using STAR and Snowflake schema.
  • Expertise in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS 2012/2014 from different systems like Teradata, Salesforce, Oracle, Flat files, SQL server, Excel and CSV.
  • Experience in creating both Multidimensional and Tabular model analysis services cubes; Applied industry best practices optimizing query performance by creating partitions, aggregations and perspectives.
  • Hand on experience in writing calculated columns and measures using MDX and DAX query language
  • Helped and trained business users to explore analysis services cube data using self-servicing BI tools like power view, power pivot, Power BI and excel.
  • Great knowledge on connecting Microsoft Power BI to various data sources and setting up and configuring Power BI related Gateways and related data connections.
  • Expertise in implementing Dynamic row-level securities in SSAS cube and PowerBI; Install and configure on-premise Gateway;
  • Experience in creating Power BI dashboards using Power BI desktop/service and Power Query.
  • Expertise in migrating reports from BO, Crystal and SAS to SSRS reports and Deploy and schedule SSRS reports into Report Manager and handle users access based on roles and permissions.
  • Experience in creating dashboard Reports using Tableau Desktop and Tableau Server.
  • Experience in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
  • Hands on experience in Documaker versions - Legacy 11.1and studio 11.3
  • Hands on experience in BizTalk Server 2013 and involved in supporting the interfaces in Black and Veatch Project. Good Working Knowledge on BizTalk artifacts like Orchestrations, Schemas, Maps, Ports
  • Experience with Use of code cloud, GIT Hub and Jura for work item management, version control, code analysis, and testing
  • Broad and extensive knowledge of the software development process and its technologies
  • Strong knowledge of computer languages, such as Java, C++, JavaScript and SQL

TECHNICAL SKILLS

Operating Systems/Server: Windows 7/10, Windows Server 2003/2008, BizTalk server 2013

Tools: Visual Studio 2015/2017, MS Office, Microsoft TFS 2013, Oracle Documaker (Legacy 11.1 and Studio 11.3), TFS, Jira, Code Cloud, GIT’s Hub

Languages: T-SQL, .Net (3.5), ADO.NET, ASP.NET, C#.NET, DAX, MDX

Databases: MS SQL Server 2012/14/16, Oracle 10g, Teradata, Vertica

BI Tools: SSIS, SSRS, SSAS, Power BI, Tableau 9.2, Crystal Reports

Cloud: Microsoft Azure, SAP Callidus Cloud - Commissions and Reporting Analytics

PROFESSIONAL EXPERIENCE

Confidential

Sr BI Developer

Responsibilities:

  • Responsible for E2E project delivery including Estimates, Project Plan, Analysis, Requirements, Design, Build, Testing, Deployment, Support, BAU and Administration.
  • Experience doing full support, configuration and management of Power BI server (On Premise). SSRS (SQL Server Reporting Services) and SSAS configuration and deployment.
  • Expert in writing code in Microsoft Azure and deploying Analysis Services cubes to Azure and configure.
  • Experience in Dimensional Modelling, Star Schema /Snowflake Schema, FACT and Dimensional tables
  • Created Complex packages and ETL logic extracting data from different systems like Teradata, Salesforce, Oracle, Flat files, SQL server, Excel
  • Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions Cube Partitioning, Refresh strategy and planning and Dimensional data modelling and Perspective using SQL Server Analysis Services 2016(SSAS).
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • Designing and developing standard, complex and ad-hoc views, dashboards and stories for management executives and analysts including KPI metrics reports.
  • Experience in generating Drill through and Drill down reports with drop down menu option, sorting the data, and defining subtotals in Power BI.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Expert knowledge using advanced calculations using MS Power BI Desktop (Aggregate, Date, Logical, String, Table).
  • Good at creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
  • Published reports into power bi service and schedule the datasets and dashboards, providing row level security.
  • Share dashboards to users through office 365, content packs and workspaces.
  • Experience in designing customized dashboards on power service.
  • Expert in writing parameterized queries for generating complex dashboard reports, drill down, drill through formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS 2016.
  • Knowledge on Azure Experience in Custom Visuals and Groups usage
  • Experience in developing on an Agile basis and Agile fundamentals.
  • Good knowledge on version control tools like TFS, CVS

Environment: SQL Server 2016, T- SQL, SSIS, SSAS, SSRS, T-SQL, DAX, MDX, Power BI, Tableau 9.2

Confidential

Sr BI Developer

Responsibilities:

  • Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions Cube Partitioning, Refresh strategy and planning and Dimensional data modelling and Perspective using SQL Server Analysis Services 2012(SSAS).
  • Managed user level access using roles and Row Level security using DAX.
  • Experience in maintenance and administration of SQL Agent Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
  • Experience with SSIS performance tuning using error handling, event handling, re-running of failed SSIS packages using checkpoints. Involved in optimize stored procedures, functions and queries for faster retrieval and Server efficiency.
  • Analyse, design, develop and support Power BI dashboards along with slicers and dicers enabling end-user to make filters to meet business and technical requirements and deploy into cloud;
  • Install and configure on-premise Gateway; Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Create usage base reports and performance monitoring Power BI dashboard reports by extracting data from DMV’s and Performance Counters.
  • 100’s of COB and on demand reports have been created using SSRS for private equity, Finance, Risk control, governance and OTC derivative team.
  • Created complex Store procedures, User defined functions, Views, T-SQL scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.
  • Experience in writing User Manuals, Documentation, Proposals and in preparing Technical Specifications for projects/Products and created process design documents using Visio

Environment: SQL Server 2014, T- SQL, SSIS, SSAS, SSRS, T-SQL, DAX, MDX, Power BI, Tableau 9.2

Capgemini

Sr BI Developer

Responsibilities:

  • As a team we work and handle end to end projects like gathering requirements, analysis, design, development, testing, implementation and production support for all the ETL packages, reports and cubes build projects.
  • Had great experience on working on Agile and waterfall methodology.
  • Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, union all, lookup, derived column and conditional split to achieve the required data.
  • Experience in designing, building and deploying multidimensional and tabular model cubes using SSAS 2012. Experience in Performance Tuning and Query Optimization .
  • Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions Cube Partitioning, Refresh strategy and planning and Dimensional data modelling and Perspective using SQL Server Analysis Services 2012(SSAS).
  • Extensively involved in the SSAS storage and partitions, and aggregations, calculation, developing reports using MDX and SQL.
  • Experience in formulating complex DAX in measures and Data Transformation, Data Mashup using Power Query Formula Language.
  • Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper level management.
  • Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
  • Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
  • Optimized report performance with caches and snapshots.
  • Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual client needs. .
  • Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending

Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, T-SQL, DAX, MDX, Power BI, Tableau

Hire Now