We provide IT Staff Augmentation Services!

Sr.bi Developer (etl, Sql, Powerbi/ Tableau Report) Resume

SUMMARY:

6 years of database development experience with Microsoft SQL Server 2008/2012/2014. Worked with SSIS, SSRS, SSAS, Excel, and Power BI, Tableau as well as ETL and Data Extraction. Experience working with the full development cycle of a data warehouse including requirements gathering, design, implementation, and maintenance. A team player and looking for a challenging opportunity that will leverage technical background to add value on a project.

TECHNICAL SKILLS:

Languages: T - SQL, Java, C#, C/C++, CSS, HTML, PHP, MatLab

Data Warehouse Tools: SSIS, SSRS, SSAS, Business Intelligence Development Studio, DTS, SQL Profiler, Weka.

Database: MS SQL 2016/2014/2012/2008, MySQL, Visual Studio 2010,2012 and 2013, MS SharePoint 2013, TFS 2013, Power BI, Azure DB.

Reporting Tools: Excel, Power BI, Tableau, SQL Server Reporting Services 2012,2008, 2005.

Other Tools: MS Office, JIRA, Confluence, Visio, MS Excel, MS-Project, Star UML, Eclipse, Load Runner, NetBeans, Adobe Photoshop CS, Corel paint shop pro, Microsoft Photo edition 2006, Illustrator.

PROFESSIONAL EXPERIENCE:

Sr.BI Developer (ETL, SQL, PowerBI/ Tableau Report)

Confidential

  • Extract data directly from various data sources (Splash Core, SAP, Data warehouse) using SSIS
  • Create a (user friendly) central database which combines the various data
  • Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks
  • Create multiple kind of Power BI Reports and Dashboards.
  • Build/create a UI through which we can generate sales reports, forecasting tools, etc.
  • Train existing ops/tech on how to use Power BI
  • Migrate Business Objects reports to Power BI
  • Migrate SSRS reports to Power BI
  • Designed and created different ETL packages using SSIS from various source to SQL Server as destination
  • Performance Tuning the Stored Procedures used in SSIS Packages
  • Wrote Stored Procedures in designing various SSIS packages
  • Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
  • Develop Tableau reports that provide clear visualizations of various KPIs.

Sr.BI Developer (ETL, PowerBI Report)

Confidential

  • Designed and created different ETL packages using SSIS from various source to SQL Server as destination
  • Mange and administer two servers (Production and User Acceptance) used by worldwide Team.
  • Create SSIS package to pull all incident and programs data from database server and SharePoint lists.
  • Create a staging database and apply the business logic using T-SQL scripts.
  • Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Involved in Performance tuning of ETL transformations, data validations and stored procedures
  • Working with project managers, business analysts and SME to develop different kind of report.
  • Expert on creating multiple kind of Power BI Reports and Dashboards.
  • Create Views and stored procedure to be consumed by SharePoint dashboard, Excel dashboard, and Power BI dashboard.
  • Design, develop and deliver services analytics materials including back-end development of analytics services, SQL
  • Reporting, delivery of automated reports & Power BI reports customization
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • The data analytics covers multiple service areas such as incident management, change management, problem management, monitoring analysis and support & service qualities
  • Set-up Enterprise Gateway and SSAS Connector on Azure VM for Power BI Report Deployments.
  • Developed complex reports using multiple data sources, user defined object synchronized queries.
  • Publish reports into SharePoint portal site from Excel
  • Coordinate with off shore team (India) to deliver projects.
  • Supporting internal stakeholders by providing business reporting, analysis of results, identification of opportunities & successes and updates on progress toward goals and strategies.
  • Perform database administration tasks in support of development testing and deployment tasks, troubleshooting, and physical database configuration.
  • Create a Virtual Network on Windows Azure to connect all the servers.
  • Subscribe SQL Server Azure Cloud Services.
  • Create Database(s) on SQL AZURE
  • Setting up SQL Azure Firewall
  • Create, manage SQL Server AZURE Databases
  • Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers

BI Developer (Power BI Report)

Confidential

  • Created various kinds of reports using Power BI and Tableau based on the client’s needs.
  • Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
  • Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
  • Migrate existing data into the Power BI.
  • Worked with the application developers and provide necessary SQL Scripts using T-SQL.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • Working directly with stakeholders for requirements gathering and developing various decision making Dashboards.
  • Hands on experienced developing dashboards and reporting visualization.
  • Expert on creating complex CTE, Sub Queries, Joins, cumulative queries for multiple kind of reports.
  • Investigates problems through to resolution or root cause/raises by pulling Data from multiple Sources and Develop Report .
  • Proven experience developing and managing data integration solutions using Microsoft BI technologies.
  • Designing, constructing, and testing of ETL processes. Created SSIS packages to extract data from the transactional and/or operational databases, transforming the data according to analytical / reporting business needs, and loading the data into a Data Warehouse or Data mart.
  • Responsible for creating datasets using different kind of query language.
  • Expert on creating Score Cards, Metrics, Power View/MAP and Pivot Tables using Office 365.
  • Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
  • Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
  • Experienced with connecting multiple data sources in Tableau to implement working reports.
  • Created SSIS packages to transfer data, from flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment

SQL Server/BI Consultant Developer

Confidential

  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS)
  • Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Tabular reports
  • Generated matrix reports, drill down, drill through, multi parameterized reports using SSRS
  • Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
  • Created Datasets in T-SQL Stored Procedures for SSRS
  • Using SSRS created well-formed web-based reports
  • Troubleshoot data issues, validates result sets, recommends and implements process improvements
  • Created report snapshots and cache for better performance
  • Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager
  • Configured SQL mail Agent for sending Automatic emails on Errors
  • Designed and created different ETL packages using SSIS from various source to SQL Server as destination
  • Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
  • Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations
  • Created Maintenance Plans and setup log files to monitor jobs
  • Utilized several Transformations like Lookup, Fuzzy Lookup for implementing the Transformation Logic in the Packages
  • Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more
  • Wrote complex SQL scripts to avoid Informatics joiners and Look-ups to improve the performance as the volume of the data was heavy
  • Design/Develop complex queries efficiently as per the given business requirements
  • Develop views, sub-queries and joins for complex queries involving multiple tables
  • Created joins and sub-queries for complex queries involving multiple tables
  • Worked with Business Analysts to understand the requirements
  • Perform data back-up and archival on regular basis
  • Involved in Creation of database, tables and procedures to update and clean the old data
  • Test and evaluates report’s performance and implements necessary solution
  • Scheduled and maintained nightly and weekly loads of data by creating the corresponding job task by using Scheduled Jobs and Alerts using SQL Server Agent
  • Produce standard monthly reports using Tableau.
  • Automate monthly excel reports into Tableau Workbooks and Dashboards.
  • Design and develop Tableau visualization solutions.
  • Prepare Dashboards using calculations, parameters in Tableau
  • Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.

Network Administrator

Confidential

  • Managing and Maintaining the Servers, PC’s, Routers and Switches.
  • Tutoring students with Networking related questions and give solutions to their technical issues.
  • Configure 40 plus workstations with the virus protection and eradications.
  • Provide a brief training for CISCO students how to configure routers and switches.
  • Help provide setting up security administration port security on switch and IP security on Router via Access list.
  • Help students get familiarized with IP addressing, sub-netting, and routing concepts.
  • Worked with a team to provide technology support to students, faculty, and staff
  • Solved issues related to any MS Software’s, networking, virus removal on PCs and Macs

Hire Now