We provide IT Staff Augmentation Services!

Bi Developer Resume

Milwaukee, WisconsiN

SUMMARY

  • Over 8 years of IT experience as a BI consultant working on Tableau and Microsoft Power BI.
  • Experience in Business Objects, Business Intelligence, Data Analysis profiles with strong knowledge of Software Development Lifecycle (SDLC) using Waterfall, Agile Scrum and Kanban.
  • Experience working with different Enterprise Data sources like PDF, Flat Files, SAP HANA, SSAS Cubes, Teradata, Hadoop and HDFS.
  • Strong experience in SQL skills to build complex views, queries, scripts, stored procedures, and performance tuning.
  • Strong experience in Microsoft Business Intelligence Tools Power BI including Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
  • Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Experience inimporting/exportingdata between different sources like Access/Excel etc. using SSIS/DTS utility.
  • Highly experienced in working with OBI Answers, OBI Dashboards, BI Publisher and OBI Delivers.
  • Experience in creating SAP HANA information models with skillful usage of Analytical, Attribute, and Calculation Views.
  • Exposure to Office 365 tools SharePoint, PowerApps, Power Automate (Flow), Delve, Teams, Project, Forms, Video
  • Experience inMicrosoft Visual C#in script component of SSIS.
  • Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS) (2014/2016).
  • Developed Dashboards with multiple Data Sources (Excel, TXT, MS Access, Oracle, SAS) Using TIBCO Spotfire Professional.
  • Created Reports Master Detail, Cross Tables, Charts (Line, Bar, Combination) Using Business Objects, TIBCO Spotfire.
  • Expert in working with OBI administration tool developing metadata repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).
  • Developed Dashboards with multiple Data Sources (Excel, TXT, MS Access, Oracle, SAS) Using TIBCO Spotfire Professional.
  • Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, executive Dashboards using Tibco Spotfire and Business Objects.
  • Experience in creating configuration files to deploy the SSIS packages across all environments.
  • Excellent ability to gather and understand business requirements and translate into IT solutions with the use of Cognos
  • Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse, Azure Blob, Azure Storage Explorer.
  • Experience working with Azure Blob Storage, Azure Data Lake, Azure Data Factory, Azure SQL, Azure SQL Datawarehouse, Azure Analytics, Polybase, Azure HDInsight, Azure Databricks.
  • Experience managing Big Data platform deployed in Azure Cloud.
  • Worked on angular.js forms and controls to validate Input data.
  • Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On - cloud ETL processing.
  • Knowledge of statistical packages for analyzing large datasets using R programming, Python and MS Excel (Pivot tables and Charts, Advanced excel functions, Statistics, Macros, V - Lookup tables)
  • Expert in Python and its libraries like Pandas, NumPy, Matplotlib, Seaborn, Networks, and Scikit-Learn.
  • Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau 6.x/7.x/8.x Desktop, Server, Mobile, and Public
  • Expert in implementing advanced procedures like text analytics and processing using the in-memory computing capabilities like Apache Spark written in Scala
  • Experience in Cloud based report generation, development and implementation using SCOPE constructs and power BI.
  • Strong experience in developing data models in SAP HANA platform and Creation of Native HANA Views.
  • Extensive Tableau Experience in Enterprise Environment andTableau Experienceincluding technical support, troubleshooting, report design and monitoring of system usage.
  • Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Experience in creating parameterized reports and dashboards using Power BI.
  • High-skilled in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2016/2014/2012/2008 R2/2008.
  • Expertise in creation and use of Windows Controls, Windows Services, Win forms, Web forms, APIs
  • Experienced in developing dashboards using Tableau (on top of SAP BW and HANA).
  • Excellent experience in designing OBIEE Dashboards, BI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse.
  • Highly motivated team player with excellent decision making, leadership qualities, interpersonal and customer relational skills
  • Ability to work in groups and independently with minimum supervision and initiative to learn new technologies and tools. Excellent communication and strong analytical skills.

TECHNICAL SKILLS

Data Analytics tools: Power BI, Tableau, Gephi, IBM Watson Analysis, IBM Cognos, Spotfire, Alteryx, Crystal Reports, Azure SQL, QlikSense, SSRS, SSAS, Scala, Cosmos Scope Scripts, Looker, Snowflake

Management tools: Clear Quest, JIRA, Confluence, Visual Studio, SOAP UI, REST API

Languages: SQL, UML, HTML, Java, Python

Databases: MS Access, Teradata, Oracle, Microsoft SQL Server Management Studio

Microsoft office programs: MS Word, MS PowerPoint, MS Excel, Microsoft Visio, MS Project, MS 365.

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, Wisconsin

BI Developer

Responsibilities:

  • Understanding the KPIs and Requirements Documents, Designing, Developing, and testing reports in Power BI/Tableau/Looker.
  • Involved in designing, developing, and deploying reports in MS SQL Server environment using SSRSandSSIS in Business Intelligence Development Studio (BIDS).
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse.
  • Prepared the complete data mapping for all the migrated jobs using SSIS.
  • Develop functional and technical specifications from business requirements for the development of SAP BW objects such as extractors, info objects, info sources, info cubes, transformations, process chains etc.
  • Configuring, Managing and Administering MS office 365 Cloud
  • Wrote scripts in Python for Extracting Data from JSON and XML files.
  • Unit Test Python library was used for testing many programs on python and other codes.
  • Support for all the API's present in test and production environments of all the projects.
  • Analyze the various API analytics summary to calculate and improve for better performance
  • Integrate data from APIs by using resource and http services
  • Simple web app for reviewing sitcoms that gives users the ability to view, add, review, up/down vote, search, etc.
  • Designed Data Mart using Dimensional Data Modeling using ETL tool.
  • Experienced exposure in Office 365 and troubleshooting several tickets associated with the windows Servers, user accounts, service accounts and its permission levels.
  • Used pandas, NumPy, sea born, SciPy, matplotlib, scikit - learn, NLTK in Python for developing various machine learning algorithms .
  • Wrote Python scripts to parse JSON documents and load the data in database.
  • Used calculated columns, Custom expressions, Action controls, Property controls in the Spotfire Reporting to provide the best solution to the business.
  • Configured and installed Data Warehouse Administration Console (DAC).
  • Loading the data into database tables into the development environment to test the report functionality.
  • Managing Exclaimer Cloud Signatures for Office 365 and Developing SharePoint online Sites And administration.
  • Good at the using Cross tables, Charts(Pie Chart, Tree Map, Heat Map, Bar Chart, Line Chart), Calculated Columns, Creating Hierarchies, Bookmarks and complex reports with multiple filters with Spotfire Professional.
  • Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, executive Dashboards using Tibco Spotfire
  • Used Git to resolve and coding the work on python and portlet.
  • Extensively Worked on Star Schema, Snowflake Schema, Data Modeling, Logical and Physical Model, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
  • Worked on different data formats such as JSON, XML and performed machine learning algorithms in Python.
  • Good at the using Cross tables, Charts(Pie Chart, Tree Map, Heat Map, Bar Chart, Line Chart), Calculated Columns, Creating Hierarchies, Bookmarks and complex reports with multiple filters with Spotfire Professional
  • In-depth knowledge of. Snowflake Database, Schema and Table structures.
  • Experience in using Snowflake Clone and Time Travel. Heavily involved in testing Snowflake to understand best possible way to use the cloud resources.
  • Worked on angular.js forms and controls to validate Input data.
  • Used Angular 4 Http services for asynchronous validations for the input fields of the forms with the data existed in the database.
  • Designed and maintained databases using Python and developed Python based API (RESTful Web Service) using Flask, SQLAlchemy and PostgreSQL.
  • Took part in setting up the routing configuration using Angular 4 router for various views and sub views.
  • Also involved in converting the Tableau/Looker and Business Objects reports to Spotfire Dashboards.
  • Installing and configuring Microsoft windows server 2008.2012, Exchange 2007 and SQL Server 2005
  • Worked on creating Angular custom pipes to sort the history of various customers through order of date, year and month, for display of the history of customer details in tables.
  • Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
  • Testing the Spotfire reports, validating data from the report and database and updating testing document.
  • Developer story telling dashboards in Tableau Desktop 8.0/8.1 and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Scheduled data refresh on Tableau/Power BI Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Assisted in creating technology deployment plan within their existing environment to ensure all employees could utilize Office 365 services
  • Designed and Developed EIP (Enterprise Information Platform) Metadata Repository (.rpd) that consist of physical layer, business model / layers with aggregates, dimensions and Dimension hierarchies, presentation layer with catalogs & folders using Oracle BI Administration tool EE 10.1.3.4.1.
  • Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Developed Spotfire Dashboards / Reports Using Action Control, Property Control to navigate from one page to another page and also to access data dynamically.
  • Created user variables, property expressions,script taskinSSIS.
  • Implementing variousSSISpackages having different tasks and transformations and scheduledSSIS packages.
  • Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated ServicesSSIS.
  • CreatedETLprocess usingSSISto transfer data from heterogeneous data sources.
  • Created logging forETLload at package level and task level to log number of records processed by each package and each task in a package usingSSIS.
  • Familiar with Microsoft Office 365 products both on Exchange and Local levels
  • MigratedDTSobjects to SQL Server Integrated ServicesSSISenvironment.
  • Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Build Dashboards using calculations & measures in Power BI. Worked in Creating DAX Expressions and implement Partitions in Tabular models
  • Migrate linked mailboxes to office 365 in the hybrid deployment
  • Created Meta Data repositories using OBIEE administration tool.
  • Designing the Reports using Power BI from the SQL Server database, Created Actions to achieve desired functionality.
  • Created OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.
  • Experience in creating database schema and performing data modelling in SQL Server database using SQL scripting. Ability to write stored procedures and queries to perform tasks in SQL Server.
  • Perform password resets, setup user licenses, and administration for Office 365 & SharePoint
  • Created proper Indexes on fact and dimension tables to reduced execution time of queries. Extracted data from multiple Flat File/Excel/XML with various formats utilizing SSIS to load into dimensions and facts.
  • Involved in designing and implementing dynamic monthly partitions in SSIS with complex process scripts for optimizing the cube processing inside the Tabular Model.
  • Worked with Drill Down, Drill Through on Reports.
  • Used Parameters, Aggregate Functions, Filters, Measure Name and Measure Value fields to create visualizations with multiple measures and columns.
  • Develop, organize, manage, and maintain various graphs, tables, slides and templates that will allow for efficient creation of reports.
  • Managed ODBC connections with created Meta Data and Repositories according to needed Subject Areas.
  • Performed the administration task of Office 365
  • Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.
  • Primarily involved in Data Migration using SQL, SQL Azure, Azure Storage, and Azure Data Factory, Data Bricks, SSIS, and PowerShell. Created processes to load data from Azure Storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.
  • Build and extended the Databricks system.
  • Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks).
  • Designed and built the physical and logical models in Physical and Business Model & Mapping Layer in the OBIEE Administration tool.
  • Creating Databricks notebooks using SQL, Python and automated notebooks using jobs.
  • Creating Spark clusters and configuring high concurrency clusters using Azure Databricks to speed up the preparation of high-quality data.
  • Produced comprehensive analysis report on legacy data, data structure and statistical summary with Python.
  • Experienced in developing scripts for doing transformations using Scala.
  • Involved in creating complex measures including ranking, KPIs, aggregation by DAX in SSAS cubes according to business requirements.
  • Cloud based report generation, development and implementation using SCOPE constructs and power BI.
  • Performed data cleaning and feature selection using MLlib package in PySpark and working with deep learning frameworks such as Caffe, Neon .
  • Involved in supporting Power BI applications which includes creation and cosmetic changes of different charts.
  • Designed dynamic row level security for entire global procurement team with different level of users utilizing complex DAX functions within SSAS tabular model.
  • Involved in optimizing SSAS cubes by assigning appropriate storage modes to partitions, improving query performance.
  • Programmed a utility in Python that used multiple packages (scipy, numpy, pandas)
  • Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing, and Implementation.
  • Expertise in scheduling reports to end-users and provide access to the report server.
  • Optimize query performance by modifying, removing unnecessary columns, eliminating redundant and inconsistent data.
  • Application of various machine learning algorithms and statistical modelling like decision trees, text analytics, natural language processing ( NLP ), supervised and unsupervised, regression models, social network analysis, neural networks, deep learning, SVM, clustering to identify Volume using scikit-learn package in python, Mat lab.
  • Designed and developed ETL workflows and datasets in Alteryx to be used for Reporting (ETL tool specific for creating datasets) Tableau Data Extract for BI.
  • Involved in creating data blending in case of merging different sources, used Alteryx for Data blending for Tableau.
  • Used ETL (Alteryx) process to Extract, Transform and Load the data into stage area and data warehouse.
  • Used Tableau Desktop Data Visualization tool for reports, integrated tableau with Alteryx for Data & Analytics.
  • Performed Data Cleaning, features scaling, features engineering using pandas and numpy packages in python
  • Build Dashboards using calculations & measures in Tableau. Worked in Creating DAX Expressions and implement Partitions in Tabular models.
  • Worked on complex data loading (implemented the batch data cleansing and data loading).
  • Gathered requirements for the project from Business Analysts and data modeling team.
  • Presented different types of metrics and key performance indicators (KPIs), such as financial, operational, and customer-focused measures in a single list.

Confidential, Dallas, TX

BI Developer

Responsibilities:

  • Performing quality check on data, identifying outliers, normality and standardizing the data
  • Extensively involved in the Analysis, design and Modeling. Worked on Snowflake Schema, Data Modeling, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
  • Created Meta Data repositories using OBIEE administration tool.
  • Generating Risk stratification reports using MS Power BI to manage the higher cost treatment plans and improve the quality of care by highlighting the risk summary and impact ability by chronic conditions
  • Developed linear regression predictive risk and impact ability models to predict the members with high risk and helps care-providers to quantify the care-gaps prioritization for each member
  • Established platform to process raw data and convert them to datasets
  • Created dashboards by extracting data from different sources
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Created Drill-downs such as Employee Service Level, Narratives, and Aggregations for Salary in BMM layer of OBIEE Administration tool.
  • Created customized reports using complex SQL queries, Created Database connections and Spotfire Dashboard file (DXP) in Spotfire server.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
  • Developed, deployed, and monitored SSIS Packages.
  • Produced comprehensive analysis report on legacy data, data structure and statistical summary with Python.
  • Perform development, enhancement and provide support for Office 365 collaboration services not limited to Microsoft Teams, Office 365 Groups, Office Suite, OneDrive for Business, Power BI and other collaboration capabilities in the Office 365 & Flow related services
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
  • Involved in creating interactive dashboard and applied actions (filter, highlight, and URL) to dashboard
  • Created hierarchies and partitions for improving SSAS cube performance.
  • Involved in creation and maintenance of SSAS cubes, perspectives, aggregations, and named sets for reporting.
  • Experience with Office 365 tools SharePoint, PowerApps, Power Automate (Flow), Delve, MS Teams, Project, Forms, and Video
  • Worked on formatting SSRS reports using the Global variables and expressions.
  • Created parameterized reports and Drill down reports using SSRS.
  • Created and maintained security within OBIEE using a combination of LDAP integration, data level security, and presentation catalog groups.
  • Involved in creating data blending in case of merging different sources and in creating a dual-axis bar chart with multiple measures
  • Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks).
  • Working on generating various dashboards in Power BI using different data sources such as Oracle, Microsoft SQL Server, and Files
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Experience in creating ERD, database schema and performing data modelling in SQL Server database using SQL scripting. Ability to write stored procedures and queries to perform tasks in SQL Server.
  • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • 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.
  • Working on generating various dashboards in Tableau using different data sources such as Oracle, Microsoft SQL Server, and Files
  • Involved in supporting other Tableau applications which includes creation and cosmetic changes of different charts
  • Prepared and executed comprehensive test plans for system and quality testing of reports which included writing PL/SQL queries to check and compare the quality of data provided by report.
  • Performed Tableau/Power BI type conversion functions when connected to relational data sources
  • Develop, organize, manage, and maintain graph, table, slide, and document templates that will allow for efficient creation of reports
  • Involved in supporting other Power BI applications which includes creation and cosmetic changes of different charts
  • Created ARM, MOM Document and maintain the root cause analysis & issues tracker sheet and maintain log files, screenshot
  • Participating in the daily call status updates to discuss progress, issues, and any new requirements

Confidential

Report Developer

Responsibilities:

  • Worked in an Agile environment with frequently changing requirements, handling offshore teams effectively as a lead while working with onsite-offshore model.
  • Handled client knowledge transfer calls and communicate requirements to the team.
  • Gathered the requirements from Business users and understanding the functionality and business rules.
  • Analyzed the systems and source databases.
  • Prepared the test data in the paper claims, mainframes, EDI, CSV, XML formats and tested the database using SQL queries in Microsoft SQL server.
  • Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and used multiple transformation in SSIS to collect data from various sources.
  • Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
  • Created SSIS packages for File Transfer from one location to the other using FTP task.
  • Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints in SSIS.
  • Support for all the API's present in test and production environments of all the projects.
  • Analyze the various API analytics summary to calculate and improve for better performance
  • Experience in writing queries to create reports, creating ERD diagram to perform data modelling, and ability to create stored procedures to perform tasks in SQL Server.
  • Gathered user requirements to develop the business logic and analyzed and designed database solutions.
  • Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
  • Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
  • Created Parameterized, matrix and drill down reports using SSRS 2008.
  • Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2008.
  • Formatted reports for various Output formats as requested by the management using SSRS.
  • Actively supported business users for changes in reports as and when required using SSRS.
  • Analyzed reports and fixed bugs in stored procedures using SSRS.
  • Used complex expressions to group data, filter and parameterize reports.
  • Created linked reports and managed snapshots using SSRS.
  • Created various cubes based on the reporting and application requirements of the business users using SSAS. Created several KPI’s, perspectives, and calculated members that were eventually used for generating reports.
  • Performed various calculations using complex expressions in the reports and created report models.
  • Prepared the test data in the paper claims, mainframes, EDI, CSV, XML formats and tested the database using SQL queries in Microsoft SQL server
  • Worked on report enhancement requests to develop reports and dashboards in Tableau/Power BI
  • Developed worksheets with different styles like bar, pie, treemap, dual axis, filled maps
  • Combined data sources by joining multiple tables and using data blending
  • Prepared deployment documents and involved in production deployments
  • Published the dashboards to Tableau server and managing the security for users
  • Worked with Cognos connection to run, distribute, and schedule reports using Schedule Management. Created reports using Cognos Report Studio.
  • Used multi-level hierarchy in Tableau Dashboard.
  • Automated regular daily, weekly, monthly, and quarterly business reports by using Cognos BI tool, which saved manual effort and ensured accuracy and on - time delivery of the report.
  • Checked if all the environments are working as expected, if not working inform to support team
  • Proactively involved in project management activities including status reports, kick-off and sign off activities.
  • Managed and supported the team in completing the deliverables on time to meet the deadlines.

Hire Now