Power Bi Business Intelligence

SINOJ JOSEPH

PROFILE

• **+ years of IT experience in Data Architecture, Data Warehouse, Business Intelligence, ETL, OLAP Cubes, Data Analysis, Design, Development, Implementation, Testing and troubleshooting of DW, strong emphasis on user requirements gathering, business rules and data analysis.

• 17+ years of technical hands-on experience in development of data warehousing solutions using Oracle10/11g, OBIEE, Microsoft BI (SQL Server Integration Services - SSIS, Analysis Services - SSAS, Power BI tools, Reporting Services - SSRS, PPS, T-SQL). Successfully implemented end-to end solutions using 2008 and 2012 versions.

• 8 years of experience in BI and Data Architecture with MS Azure Cloud Services, to include: Strong development skills with Azure Data Lake, KQL, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer, Azure Architecture, Azure Synapse Analysis, ADF, Azure Analysis Services, and Custom Azure Data Factory Pipeline Activities.

• 4+ Years of extensive experience in Microsoft Power BI. Strong experience with Power BI report migration with 4 different clients

• Experience in developing, maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, T-SQL, MDX, Excel pivot tables, Power Pivots, Power BI, DAX).

• Extensive working knowledge in SAP HANA, ECC6, JD One World and Microsoft Dynamics.

• Experience in using the Dimensional Modeling techniques such as Kimball Star Schema and Snowflake Schema. Experience in developing SSAS Cubes, Dimensions and data source views and deploying and processing SSAS objects.

• Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, and Drill through features in using Business Intelligence Development Studio (BIDS).

• Self-driven individual with a bias for action and a passion for analytics. Strong expertise in building and delivering world-class dashboard and analytics solutions using Microsoft’s Power BI and related Azure data services.

• Strong Customer Interaction skills, user training skills and client facing skills in both 1 to1 and large group audiences.

• Expertise on Big Data Platform Key Capabilities like Deploy On-premises or in cloud, Build Next-Gen-Apps, delivering predictive analytics, etc.

• 8+ yrs. Experience in Tableau and QlikView Dashboards in latest Design and Presentation. Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Acted as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.

• Experience in developing Performance Dashboards, Score Cards, Metrics, what if analysis, Prompts, Drills, Search

(using Add-ons), Reports/Dashboards for Finance, Controlling, Inventory Management, Sales and Marketing, Supply Chain, Material Management, Production and Purchasing and functional areas.

• 15 years of experience in creation of database objects using Oracle and MS SQL Server databases, expertise in scripting T-SQL queries (DDL and DML), Views, complex stored procedures, Data Import/Export, cursors, power view, power pivot, user defined functions (UDF) and database triggers.

• Expertise in performing detailed analysis of source systems and source system data and modeling that data.

• Worked extensively on Business Intelligence (BI) technologies to provide historical, current, and predictive views of business operations.

• Experience and proficiency on design, development, and test scripts to import data from source systems and dashboards to meet customer requirements.

• Expert in interpreting written business requirements and technical specification documents, performing quality coding to business and technical specifications.

• Expertise in creating and maintaining technical design documentation.

• Work directly with business units to define, prototype and validate applications, Extracting, Transforming and Loading – ETL, data from multiple sources monitoring and maintenance of all components that make up the Data Warehouse and Business Intelligence infrastructure.

• Designed architecture for loading, pushing and pulling data from & to different servers.

• Excellent verbal and communication skills with a clear understanding of business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS

DW, BI, Enterprise

Planning &

Forecasting

MS SQL BI stack (SSIS, SSAS, SSRS, Power BI Latest ), Microsoft Azure DW, Data factory, Azure Blob Storage, SharePoint server Performance point server, Cognos 10.1.1,10.1, Cognos 8/7

(Data manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Transformer, Cognos Planning Analyst, Contributor, Metric designer, Framework Manager, Life cycle Manager, Cognos Series7 Ver.7.3 (Transformer, Upfront, Power Play Enterprise Server, Power Play Web, Impromptu Web Reports, Notice Cast, Cognos Web Services, Visualizer, Cognos Metrics Manager), Cognos Planning 7.2 (Analyst & Contributor), Sun One 5.2 LDAP, Netscape Directory Server 4.2 LDAP, OLAP, MicroStrategy Project Designer, MicroStrategy desktop (Informatica Power Center 8.6./8.1/7 (Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets), Informatica Data Analyzer 8.6/8.5/8.1, Informatica Power Connect, Data cleansing, OLAP, ROLAP, MOLAP, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader, DTS Package, Cognos Data manager, Decision Stream SSIS, OWB

Data Modeling Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7.2/7.0, Visio 2003, Oracle Designer, SQL Developer, Dimensional Data Models /, 3rd NF, TOAD ERP Systems SAP HANA, SAP ECC6, JD Edwards Enterprise, OneWorld, Microsoft Dynamics Databases Oracle 11g/10g/9i, MS Access, SQL Server 2005/2000, MongoDB, MS Access Reporting

Tools/Dashboards

MSBI Reporting services, Power BI, Cognos 10/ 8.4/8.3/8.2, Cognos Report Net 1.0/1.1(Report Studio, Query Studio, Event Studio, Metric Studio, Cognos Connection, Framework Manager), Tableau, QlikView Dashboard and QVD implementation Networking&

Protocols

TCP/IP, Active Directory, SUN One DS, IIS, HTTP, POP3, and SMTP Programming SQL, T-SQL, SQL*Plus 3.3/8.0, NoSQL, HTML Environment Windows 2003/2000/XP/Vista, WinNT4.0, MS DOS 6.22 EDUCATION

Master’s in business administration, MBA (IT)

Bachelor of Science Degree

WORK HISTORY

SanJose Systems Houston, TX 11/2019 - Present

Data Architect - BI Architect – Power BI

• Subject Matter Expert (SME) for Microsoft BI implementation specifically focused on BI Requirement gathering, Data Modeling, Power BI Enterprise Architecture, different ERP systems like AS400, SAP ECC6, QAD and Power BI development.

• Extensively worked on Azure Architecture, Azure Synapse Analysis, ADF, KQL, Azure Analysis services, Power BI premium.

• Worked with different business users from different global region to adopt the data visualization - Power BI in the organization and get insights from the data.

• Worked with the technical team to gain a good understanding of the database models used for reporting.

• Created Power BI reports that represented different findings and insights from the data using interactive charts and maps, and how they were leveraged within the organization.

• Developed Power BI reports & effective dashboards after gathering and translating end user requirements.

• Created widget visualizations of dashboards, volume reports, operating summaries, and presentations and graphs per user requirements.

• Heavy use of calculated measures and columns with DAX in MS Power BI Desktop.

• Created accurate and consistent longitudinal datasets based on the business requirement.

• Implemented Custom Visuals and Groups Creation in development.

• Developed advanced calculations using MS Power BI Desktop and Report builder.

• Published reports to app.powerbi.com and setting up the necessary connection details and scheduling.

• Designed corporate dashboards in PowerBI.com using Tiles from reports.

• Defined data architecture and ERP data architecture for Microsoft Power BI Desktop to various data sources.

• Created and mapped large datasets using different data sources like Microsoft SQL Server, Microsoft Azure, Excel and SAP.

• Implemented Data security (row level security) on Dataset and Reports.

• Created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.

• Uploaded Power BI reports to Power BI online version and implement security and audit.

• Configured Gateways in the Power BI service.

• Created Groups and Content packs in the Power BI service.

• Scheduled Power BI reports in online version and knowledge of viewing dashboards in Power BI mobile version. Vaco /Crosby Dallas, TX 02/2019 – 03/2020

Power BI Architect

• Subject Matter Expert (SME) for Power BI and worked extensively on Microsoft Business Intelligence stack and Azure Architecture and development.

• Responsible for best practice design, BI Architecture and development of Power BI dashboards for Finance, Quality control, Purchasing, and Sales.

• Worked with different business users to adopt the data visualization - Power BI in the Organization and get insights from the data.

• Worked with technical team to gain a good understanding of the database models used for reporting. Primarily involved in Power BI development and Data Migration using SQL, SQL Azure, Azure Storage, and Azure Data Factory, SSIS Created applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled jobs for daily loads. Implemented Copy activity, Custom Azure Data Factory Pipeline Activities. Heavy use of KQL to discover patterns and trends

• Developed different visualizations in Power BI using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.

• Uploaded Power BI reports to Power BI online version and implement security and audit.

• Created Groups and Content packs in Power BI service.

• Used Information structure tables from ERP systems and redefined calculations in Power BI Desktop.

• Extensive use of calculated measures and columns with DAX in MS Power BI Desktop.

• Published reports to app.powerbi.com and setting up the necessary connection details and scheduling.

• Created Executive Dashboards in PowerBI.com using Tiles from reports. Implemented Data security (row level security) on Dataset and Reports.

State of Texas DIR Austin, TX 11/2017 – 02/2019

Data Warehouse Architect

• The Education data application and repository project helped the customer how they can re-model, load and validate their data on an ongoing basis through its education information management systems. The project dramatically improved user’s access to relevant timely education data for decision making.

• The team adopted Kimball methodology and DMDL for their business modeling approach.

• Responsible for requirement gathering, database table and query design, ETL extracts, data modeling, use of report query tools, multidimensional data cube design for both web and desktop distribution. The current effort continues its work consolidating its data from Oracle JD One world to DW systems. The goal was to reduce redundant collection and improve connections between databases for better reportability. As needed, other data marts could be created to accommodate other programs.

• Data Warehouse and OLAP application software included Microsoft SSIS SSAS, SSRS and power pivot for user group.

• Architected, designed and developed Business Intelligence (BI) solutions with Microsoft Power BI to meet new and existing business demands and ensuring integrity of design through to implementation.

• Worked closely with business and IT stakeholders to define problems and design data visualization solutions in a team environment.

• Performed software installation, setup, upgrades and production system support, as well as ongoing support to business users, including account setup, report access, preparation of new reports, data extracts, and Data Mart cubes and training.

• Responsible for Logical and physical data model using ERWIN and mapped the data into database Objects.

• Focused on maintaining and optimizing the existing databases, by monitoring database performance and growth, performance tuning, and populating data warehouse using SQL Server Integration Service (SSIS).

• Managed complete BI upgrades with best practices. State of Texas 05/2015 - 07/2017

BIDW Data Modeler – Data Architect

• The State Data Warehouse was built on Microsoft BI tool sets (SSIS, MDM, etc.) and the IBM Cognos Business Intelligence (BI) software platforms and was used by customer to meet the state, cooperative, district and school-level data reporting needs. The state data warehouse was updated nine times per year through the statewide information system.

• Microsoft BIDW and IBM Cognos were used to provide dashboards to educational stakeholders.

• Dashboards offered feature-rich visualizations to allow users to “drill-up” and “drill-down” on pre- built reports to examine areas of academic strength and weakness.

• Supported and administered development, test and production environments.

• Responsible for Comprehensive Admin Review: Created multiple models to meet the need of ad hoc and canned reports. Modified the existed model of Phase 1 and took care of all business needs for phase 2.

• Developed FM model for report studio developers created CPF (Project files) and Published projects from the FM Models Created Query subjects, query items, Filters, Namespaces Handled Complex Queries as separate Query Subjects.

• Setup report bursting and scheduled it to run on the11th of every month. Gathered and documented requirements from end users in JAD sessions to develop ad–hoc reports.

• Defined roles and permission and matched them across all environments for multiple applications (linked the reports to dashboards.)

• Responsible for ensuring compliance with best practices for all Cognos Models, Cubes and reporting in the production environment.

• Designed new architecture for Cognos platform which consisted of BI servers, and job/Data servers. This architecture used best practice in order to bring performance and scalability to existing environment fully dimensional queries instead of flat queries to achieve faster build times ease of support and extensibility.

• Reviewed models developed by others and cut their build times by taking advantage of DMR best practice and modeling techniques.

ERS 06/2014 - 04/2015

BI Developer

• The state agency dept administers retirement, health, insurance and other benefits for more than half a million state and higher education employees, retirees, and their eligible family members. As part of its larger strategic program of enhancing agency performance and accountability, agency took a close look at its business intelligence BI capabilities.

• Management strongly believed it needed to use many sources of data to drive smart decisions based on fact and experience. Traditionally ERS had access to large quantity of data; however, the organization’s mix of reporting tools (including SQL scripts, BI query to extract actuarial, insurance, annuity and member data) did not provide the flexibility and speed needed to respond to both internal and external information requests. The IT department was strained as it tried to keep up with these requests using tools to manually manipulate the data located in different sources throughout the organization.

• Most of the effort concentrated on data modeling for three major business portfolios and subsequent modeling of enterprise OLTP data to a dimensional and fact table-based structure.

• Power BI suite was used for data visualizations and development of dashboards. All data models were designed as per Kimball enterprise modeling principles.

• Other major tasks performed included drafting BI requirements and capabilities for an efficient BI system and on building the core database engine using SQL Server as the basis of the data warehouse.

• The claims DataMart was developed on SQL 2012 using MSBI enterprise suite. The team used SQL Server Integration Services (SSIS) and Tableau to move a subset of customer benefit data from the PeopleSoft Oracle database to a DataMart in SQL Server, and to extract data from a third-party administrator’s flat files to the SQL DataMart.

Hewlett-Packard 06/2013 - 05/2014

Business Intelligence Architect

• Implementation for Channel Dashboard Business Managed project. Channel Dashboard Business Managed Project was to increase productivity and efficiency in report generation through automation with enhanced capabilities built in. The current report generation process was manual and time consuming. This project also standardized the use of required reference data and improved Domain to Regions’ data reconciliation since region provided sourcing data.

• Responsible for Data modeling for Business data repository project and Architecture of DW design, development and testing and final push to production systems.

• CDBM was a WW reporting systems application. Data from all three regions (AMS, EMEA.APJ) were consolidated into “OneView” for the customer. The various reporting systems that were used varied upon the region as different regions had different reporting systems and were implemented based on the regional business requirements.

• For the purposes of CDBM, the data extracted was Distributor Sales, Final Tier Sales, SubD Sales (For APJ Only), Inventory and Shipments. Trident, Flash Pro and eBit which were Business Objects reporting applications were used to extract the required data for AMS, EMEA and APJ respectively. Various BO queries were created and ran in the BO scheduler. The FTP functionally for BO scheduling agent was used to post the Comma Delimited Text files into a staging are on one of the servers.

• Architected and installed a shared QlikView enterprise platform for three major business portfolios at HP.

• This QlikView platform had a very wide set of features allowing for much flexibility in implementations of QV applications/documents.

• Trained end users on major features for decision making process. Nordstrom Seattle WA 04/2011 - 04/2013

BI Architect

• Responsible for leading cross functional teams including Engineering & Operations toward successful implementation of next release of Cognos BI 10.1 and Microsoft BI solutions and completion of all SDLC deliverables.

• Provided best practices and processes for day-to-day operations, performance analysis, tuning and capacity planning of Cognos BI & Microsoft BI solutions in separate BI projects, supporting Cognos 8.4 environment, developers and consumers. This load balanced environment supported over 800+ consumers.

• Responsible for month end reporting and over 60 planning applications and models. Supported and administered Cognos Planning with several Contributor applications.

• Advised and assisted with all Cognos BI, MSBI reporting and MS designer best practices and development activities throughout the organization. Responsible for ensuring compliance with best practices for all BI Models, Cubes and reporting in the production environment.

• Designed new architecture for Cognos and Microsoft platform which consisted of BI servers, planning servers and job/Data servers. This architecture used best practices to bring performance and scalability to existing environment fully dimensional queries instead of flat queries to achieve faster build times ease of support and extensibility.

• Reviewed models developed by others and cut their build times by taking advantage of DMR best practices and modeling techniques.

Panasonic Auto (PASA Inc.) 05/2010 – 03/2011

IBM Cognos Architect

• Managed client facing consultants delivering both data warehouse and business intelligence solutions.

• Mentored both internal and client team members in best practices for a variety of tools and technologies.

• Designed, developed and implemented data warehouse and business intelligence solutions for both Fortune 100 and mid-sized businesses.

• Created dashboards, cubes, reports and ad-hoc queries for Sales operations, accounting and human resources analytics.

• Architected, installed and configured Cognos 8.4.1 business intelligence software in large geographically distributed environment. Installation consisted of four physical and eight virtual machine (VM) servers.

• Implementation supported 500 users running Power Play Cognos Planning cubes, Analysis Studio, Report Studio and Query Studio hitting Oracle and ERP systems.

• Designed, developed and tested Framework models, Metric packages in 8.4 platforms.

• Designed and administered Cognos Planning contributor applications through IBM Cognos Planning administrator. Designed the Planning contributor applications based on a Planning Analyst model, managed security using Cognos security model, performed the administrative task, such as importing and publishing data, deployed the application to Cognos portal DW solutions using Cognos Data Manager Integration Services. Keystone LKQ Corporation 01/2010 - 04/2010

IBM Cognos Architect

• Designed, implemented and supported Cognos environment, developers and consumers. This load balanced and fault tolerant environment supported over 1,300 Power Play, 800+ Reporting consumers.

• Responsible for over 60 daily production cube builds 100+ Analysis Reports. Supported and administered Cognos Planning with several Contributor applications and 200+ users.

• Developed and implemented a cube build automation script in Cognos. Advised and assisted with all Cognos and data warehouse development activities throughout the organization.

• Responsible for ensuring compliance with best practices for all Cognos Framework Models, Transformer

• Models, Cubes and reporting in the production environment.

• Designed and implemented a series of Power Play Transformer cubes from a star schema architected data warehouse. Transformer models used best practice fully dimensional queries instead of flat queries to

• achieve faster build times ease of support and extensibility.

• Reviewed models developed by others and cut their build times by 50% by taking advantage of multi- dimensional best practice modeling techniques.

• The Cognos environment consisted of sixteen servers in a distributed configuration with Teradata in separate development, test and production areas.

Stockmann Corporation 08/2008 - 09/2009

IBM Cognos Architect

• Responsible for the design, development, implementation and administration of Data Warehouse and Cognos Reporting tools throughout the organization. This included database table and query design, extracts, data modeling, use of report query tools, multidimensional data cube design, and both web and desktop distribution.

• Implemented full multi-level user class security using Netscape Directory Server and provided User Training and Document preparation.

• Data Warehouse and OLAP application software included version 8 of Cognos Transformer, Cognos EP Planning, Report Studio, Query Studio, Metric Studio, Metric Designer.

• Performed software installation, setup, upgrades and production system support, as well as ongoing support to business users, including account setup, report access, preparation of new reports, data extracts, and Data Mart cubes and training.

• Performed data extraction, Cognos server installation and content administration, transformation and loading from multiple sources, updating of tables and data cubes, and restructuring data to Data

• Warehouse architecture for use with front-end tools.

• Setup, design, and administration of the Cognos Server, Transformer, Cognos Planning Analyst, Contributor applications. Heavy use of SQL, (SQL, Stored Procedures and Data Transformation Services), as well as

• Visual Basic to create and maintain Data Warehouse. IZHMASH JHC 10/2006 - 06/2008

IBM Cognos developer

• Responsible for providing Senior Staff leadership to the branch office as well as functioning as a billable resource. Senior Staff responsibilities included assisting in the development of a business plan, interviewing and hiring candidates as well as performing comprehensive project review.

• As a billable resource, provided services ranging from the gathering of requirements through formal project management and application development. The source for the data is the Excel files and the staging database was in SQL 2005, SSIS and Cognos Data manager is being used for loading the data from Excel files to staging, Project Margin Mart in SQL Server 2005 along with performing many of the management adjustments.

• The Data Mart was dimensionally designed with Star Schema concept having many dimensions between the Facts. Our job was to design / test complex Reports using Cognos Report Net (Query Studio & Report Studio) & Cognos Impromptu and then implement OLAP. The data flowed from OLTP server to a staging area server

(Oracle) and then finally to the Data Warehouse in Oracle. The OLAP tool used Cognos EP Series as the main warehouse for reporting.

BRBNMPL RBI INDIA 02/2006 - 09/2006

Project Support Consultant

• BRBNMPL is a subsidiary of RBI is a Global leader in producing bank notes and other security products and is operating in Indian and global market catering to security document needs of Central banks and monetary authorities of the world by designing, printing and supplying bank notes and other security notes.

• They utilized an ERP JD Edwards, and data flowed from this ERP to ODS MS. Cognos 7 series was the BI environment.

• Responsible for managing development teams consisting of three to five programmers for various projects.

• Created, maintained and presented weekly reports tracking each team members actual hours, percent completed and estimate-to-complete to senior executive staff.

• Adjusted assignments and staffing as required to meet budgets, milestones and completion dates.

• Intimately involved in projects from the initial vision, design, development, and through implementation and delivery.

• Tools used were Visual Basic 6.0, Oracle, PL/SQL, Micro-Focus Cobol, DOS/VSE tools and proprietary systems. Mazaya BI System UAE 05/2005 - 12/2005

Sr. Programmer/Analyst

• Responsible for the design, development, implementation and administration of Data Warehouse and Cognos Reporting tools throughout the organization. This included database, DW table and query design, extracts, data modeling, use of report query tools, multidimensional data cube design, and both web and desktop distribution. Implemented full multi-level user class security.

• Responsible for Customer requirement gathering, designing and developing staging and warehouse database, designing and developing ETL mappings, developing Framework and Transformer Models, Administered the same in Production environment.

• The Cognos environment consisted of sixteen servers in a distributed configuration and separate development, test and production areas.

• Completely installed, configured all Cognos applications. Project Margin Mart Head Strong, Netherlands 11/2004 - 05/2005 Programmer/Analyst

• This project was for the head strong Global consulting company. The modules that were addressed in the project were further specific Financial Reports to be catered to the high-level management at the Project Margin level data. The source for the data were the Excel files collected from different geographies and the Oracle Database, the SSIS was used as ETL, which took care of loading the data from Excel files and Oracle Database to the Project Margin Mart in SQL Server 2000 along with performing many of the management adjustments.

• The Data Mart was dimensionally designed with Star Schema concept having many confirmed dimensions between the Facts. The Relational Modeling (for Reporting), Dimensional Modeling (for Power play Cube) and Metadata Modeling (for Cognos Report Studio) of the Mart was done in Cognos Framework Manger to provide the Report Authors a perfectly designed model to develop the final Reports with ease.

• The Power play Transformer was used to define the Dimensional Hierarchies and the Measures or Calculated Measures in the Cube to assist the MIS Team of Headstrong to take out the reports at any level.

• Responsible for Customer requirement gathering, designing and developing staging and warehouse database, designing and developing ETL mappings, developing Framework and Transformer Models, administered the same in Production environment.

• The Cognos environment consisted of Cognos DS, Cognos BI (Report Studio, Query Studio FM, Transformer), Cognos EP 7 Oracle 9i, SQL 2000, Excel DTS, Windows XP.

• Completely installed, configured all Cognos application software. Data Mart for Inventory Dept, Proton Edar Sdn. 01/2004 - 09/2004 Programmer/Analyst

• Proton Edar was the major car manufacturer, which produced different kind of cars and offers a complete line of car parts and accessories. The company required different level of analysis. The sales data mart was designed and developed to generate reports to analyze the sales details of the company.

• The analysis was based on area, date, and customer wide sales. The Inventory data mart designed and developed was to generate reports to analyze the stock details of the company. The analysis was based on

• area, dealer, and date wise stock.

• The system generated reports for Inquires, Purchase Orders, Quotations and Invoices. This system

• provided the ability to access, analyze and share information in the company’s database. Banking Information System

Contact this candidate