Home
Get started
Why iGiGXWork from Dubai
Login
Meet Genie
Home / Candidates Listing / Anonym
avatar

BI Analyst

Score
100%
Experience:
16 y
Score
100%
Experience:
16 y
Location:
30-383 krakow
Last update:
21.04.2021
Register to Contact Freelancer
Availability
Available
Rate
Onsite hourly: 75 €
Remote hourly: N/A
Languages
German: Basic knowledge
English: Near native
Area Preference
Yes, Willing to Travel
Description
SKILLS
Informatica PowerCenter, Informatica Data Quality, Oracle Business Intelligence Enterprise Edition, Microsoft Business Intelligence, SSIS, SSAS, SSRS, tableau, Qlikview, SQL Server, Oracle, Teradata, Vertica, PL / SQL
Other skills
user acceptance testing backend profiling Metadata Qlikview Teradata TSQL Tableau database Oracle BI PL / SQL ETL Sql Queries Stored Procedures Data profiling Dimensional Modeling SSIS Microsoft SQL SQL Server Physical Data Model Analytics Oracle Developer SSRS code reviews Pivot Table Oracle performance tuning OBIEE Oracle Business Intelligence Enterprise Edition Vertica SSAS MSBI Big Data Microsoft Business Intelligence PL/SQL SQL Oracle BI Publisher Stored Procedure Informatica Powercenter
Work & Experience
01.04.2017 — Now
PROJEKTHISTORIE; Adriot People PVT.LTD.
BI Analyst
Roles & Responsibilities: * Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes. * Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements. * Responsible for creating ETL mapping documents to define data flow from source system to target database. * Worked with Source system Subject Matter Expert SME to ensure that the extracts are properly mapped. * Worked on the backend SSAS cube development which was the source data for the tableau. * Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling. * Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports. * Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau. * Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. In a single dashboard by using parameters. * Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.. * Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types. * Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Google Big-query later. * Used Sql Queries at the custom Sql level to pull the data in tableau desktop and validated the results in Tableau by running Sql queries in Sql developer and Google Big-Query. * Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment. * Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters. * Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes. * Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functional design document.
01.03.2015 — 31.08.2016
Hewlett-Packard (M) Sdn. Bhd.; LaurelSoft ISolutions Sdn. Bhd.
Informatica Developer
Roles & Responsibilities: * As a developer in this team initiated the process of Data profiling by profiling different formats of data from different sources * Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer. * And started analyzing its dimensions to find its actual structure and the rules which are implemented as part of Standardization. * Validation, Standardization and cleansing of data will be done in the process of implementing the business rules. * Match and Merge rules will be implemented in Informatica MDM to find the duplicates and to analyze the golden record. * Extensively worked on Informatica IDE/IDQ. * Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging. * Have Knowledge on Informatica MDM concepts and implementation of De-duplication process. * Created Reports and Dashboards using Tableau. * Migrated the code into QA (Testing) and supported QA team and UAT (User). * Conducted code reviews developed by my team mates before moving the code into QA. * Provided support to develop the entire warehouse architecture and plan the ETL process. * Modified existing mappings for enhancements of new business requirements. * Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities and Involved in production support.
01.02.2013 — 31.01.2015
Texas Instruments Sdn. Bhd.
Software Engineer
Company: Texas Instruments Sdn. Bhd. Payroll: Sri Soft Solutions Sdn. Bhd. Duration: Feb 2013 to Jan 2015 Roles & Responsibilities: * Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables. * Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data. * Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms. * Continuous working with the data profiling, as the data received from many source systems and manual files with many data issues. Performed data cleansing on all the file and implemented the validations over the files. * Partitioned tables and indexes for better performance of application * Subject matter expert for OBIEE expertise in Oracle BI server, Oracle BI Answers, BI interactive Dashboards and Oracle BI Publisher. * Experience in providing end to end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD),Interactive Dashboards, OBIEE Answers, Security implementation, Analytics Metadata objects, Web Catalog Objects(Dashboards, Pages, Folders, Reports). * Used HPQC Quality management tool for issue logging and Defect Tracking.
01.07.2009 — 31.12.2012
Kentech Solutions Pvt. Ltd.
Software Engineer
Roles & Responsibilities: * Developed PL/SQL packages, procedure/functions, triggers, tables, collections, Sequences, views and indexes. * Involved in enhancement developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL. * Worked on complex queries PL/SQL packages, functions, stored procedures, triggers, views etc. * Partitioned tables and indexes for better performance of application. * Identify and tracked the slowly changing dimension tables, heterogeneous Sources and determine the hierarchies in the dimensions. * Understanding the Business requirements and Configuration of repository at all the three layers including Physical, Business Model and Mapping Layer, and Presentation Layer. * Imported metadata in to the Physical layer, applied Business rules in the Business Modeling and Mapping layer. * Configured Joins in Physical and BMM Layers. * Configured Dimensional Hierarchies in the Business Model and Mapping Layer. * Configured Logical Table Sources by defining the physical sources and content in the BMM Layer. * Calculation measures in the business model using Time series. * Extensively used Oracle Answers in building various reports. * Designed and Developed new subject areas/ Customizations and front end reports. * Developed Reports with different Views (Pivot Table, Chart, Column Selector) using Oracle Presentation Services and Interacted with users, developed and maintained Reports and Dashboard.
ZEITLICHE UND RÄUMLICHE VERFÜGBARKEIT
ZEITLICHE UND RÄUMLICHE VERFÜGBARKEIT Yes, Willing to Travel
HILFE UND SUPPORT
HILFE UND SUPPORT * FAQ * Kontakt * RSS * Sitemap * Preise und Leistungen
ÜBER UNS
Unsere Partner
ÜBER UNS * Kundenecho * Werben Sie bei uns * Presse * Unsere Partner * Werden Sie Partner * Karriere
SOZIALE NETZWERKE
SOZIALE NETZWERKE * facebook * Twitter * LinkedIn
AGB
* AGB * Impressum
Attachments
Having9yearsofexperienceonETLandBI

Description

SKILLS
Informatica PowerCenter, Informatica Data Quality, Oracle Business Intelligence Enterprise Edition, Microsoft Business Intelligence, SSIS, SSAS, SSRS, tableau, Qlikview, SQL Server, Oracle, Teradata, Vertica, PL / SQL

Main Skills

Other Skills

user acceptance testing backend profiling Metadata Qlikview Teradata TSQL Tableau database Oracle BI PL / SQL ETL Sql Queries Stored Procedures Data profiling Dimensional Modeling SSIS Microsoft SQL SQL Server Physical Data Model Analytics Oracle Developer SSRS code reviews Pivot Table Oracle performance tuning OBIEE Oracle Business Intelligence Enterprise Edition Vertica SSAS MSBI Big Data Microsoft Business Intelligence PL/SQL SQL Oracle BI Publisher Stored Procedure Informatica Powercenter

Work & Experience

01.04.2017 — Now
PROJEKTHISTORIE; Adriot People PVT.LTD.
BI Analyst
Roles & Responsibilities: * Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes. * Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements. * Responsible for creating ETL mapping documents to define data flow from source system to target database. * Worked with Source system Subject Matter Expert SME to ensure that the extracts are properly mapped. * Worked on the backend SSAS cube development which was the source data for the tableau. * Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling. * Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports. * Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau. * Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. In a single dashboard by using parameters. * Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.. * Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types. * Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Google Big-query later. * Used Sql Queries at the custom Sql level to pull the data in tableau desktop and validated the results in Tableau by running Sql queries in Sql developer and Google Big-Query. * Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment. * Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters. * Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes. * Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functional design document.
01.03.2015 — 31.08.2016
Hewlett-Packard (M) Sdn. Bhd.; LaurelSoft ISolutions Sdn. Bhd.
Informatica Developer
Roles & Responsibilities: * As a developer in this team initiated the process of Data profiling by profiling different formats of data from different sources * Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer. * And started analyzing its dimensions to find its actual structure and the rules which are implemented as part of Standardization. * Validation, Standardization and cleansing of data will be done in the process of implementing the business rules. * Match and Merge rules will be implemented in Informatica MDM to find the duplicates and to analyze the golden record. * Extensively worked on Informatica IDE/IDQ. * Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging. * Have Knowledge on Informatica MDM concepts and implementation of De-duplication process. * Created Reports and Dashboards using Tableau. * Migrated the code into QA (Testing) and supported QA team and UAT (User). * Conducted code reviews developed by my team mates before moving the code into QA. * Provided support to develop the entire warehouse architecture and plan the ETL process. * Modified existing mappings for enhancements of new business requirements. * Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities and Involved in production support.
01.02.2013 — 31.01.2015
Texas Instruments Sdn. Bhd.
Software Engineer
Company: Texas Instruments Sdn. Bhd. Payroll: Sri Soft Solutions Sdn. Bhd. Duration: Feb 2013 to Jan 2015 Roles & Responsibilities: * Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables. * Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data. * Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms. * Continuous working with the data profiling, as the data received from many source systems and manual files with many data issues. Performed data cleansing on all the file and implemented the validations over the files. * Partitioned tables and indexes for better performance of application * Subject matter expert for OBIEE expertise in Oracle BI server, Oracle BI Answers, BI interactive Dashboards and Oracle BI Publisher. * Experience in providing end to end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD),Interactive Dashboards, OBIEE Answers, Security implementation, Analytics Metadata objects, Web Catalog Objects(Dashboards, Pages, Folders, Reports). * Used HPQC Quality management tool for issue logging and Defect Tracking.
01.07.2009 — 31.12.2012
Kentech Solutions Pvt. Ltd.
Software Engineer
Roles & Responsibilities: * Developed PL/SQL packages, procedure/functions, triggers, tables, collections, Sequences, views and indexes. * Involved in enhancement developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL. * Worked on complex queries PL/SQL packages, functions, stored procedures, triggers, views etc. * Partitioned tables and indexes for better performance of application. * Identify and tracked the slowly changing dimension tables, heterogeneous Sources and determine the hierarchies in the dimensions. * Understanding the Business requirements and Configuration of repository at all the three layers including Physical, Business Model and Mapping Layer, and Presentation Layer. * Imported metadata in to the Physical layer, applied Business rules in the Business Modeling and Mapping layer. * Configured Joins in Physical and BMM Layers. * Configured Dimensional Hierarchies in the Business Model and Mapping Layer. * Configured Logical Table Sources by defining the physical sources and content in the BMM Layer. * Calculation measures in the business model using Time series. * Extensively used Oracle Answers in building various reports. * Designed and Developed new subject areas/ Customizations and front end reports. * Developed Reports with different Views (Pivot Table, Chart, Column Selector) using Oracle Presentation Services and Interacted with users, developed and maintained Reports and Dashboard.
ZEITLICHE UND RÄUMLICHE VERFÜGBARKEIT
ZEITLICHE UND RÄUMLICHE VERFÜGBARKEIT Yes, Willing to Travel
HILFE UND SUPPORT
HILFE UND SUPPORT * FAQ * Kontakt * RSS * Sitemap * Preise und Leistungen
ÜBER UNS
Unsere Partner
ÜBER UNS * Kundenecho * Werben Sie bei uns * Presse * Unsere Partner * Werden Sie Partner * Karriere
SOZIALE NETZWERKE
SOZIALE NETZWERKE * facebook * Twitter * LinkedIn
AGB
* AGB * Impressum

Attachments

Having9yearsofexperienceonETLandBI