We provide IT Staff Augmentation Services!

Principal Lead Consultant (data Architect) Resume

2.00/5 (Submit Your Rating)

SUMMARY

  • Insurance, Bank, Financial Services, Retail, Government Sector, IT Consultancy, Printing Company, Garments Company, and Media and Publishing Company
  • Finance & Accounting (GL, Accounts, Journal Entry, and etc.) Sales & Marketing, Operation, Actuarial, ERP, CRM, SCM, Claims, Insurance Business Process (Group, Life, and GI)
  • Data Initiatives Project Developed, Implemented, and Supported
  • Operational Data Store (Core Systems, Promo Code Layering, Group Asia Insurance, Life and GI Insurance, Finance and Accounting, and etc.)
  • Data warehouse, Datamart, Data Lake, Single Customer View, Data Governance/Management, Reference & MDM (Master Data Management), Data Visualization, Data Mining (Anomaly Detection, Clustering, Classification, Summarization, and etc.), Predictive Analytics (Cross & Up Sell, Fraud Detection, Underwriting, Chatbot, Risk Management, AML, and etc.), and etc.
  • Data Management/Governance Roles and Responsibilities
  • Data Architect, Data Modeling, Metadata Management, Data Development, Data Operations Management, Data Quality Management, Reference and Master Data Management
  • 9 yrs.: Data Model (Erwin, Infosphere Architect, MS Visio)
  • Physical Database, Data Integrations Services (ETL Architecture and Design), Data Lineage, Data Mapping, Data Standardization, Data Profiling, Data Migration, Data Mapping, Data Lineage, Data Flow Diagram, and Data Cleansing
  • Others: Audit and Control Process, Health Checking, Email Alert & Notifications, Parallel processing, Error and Exceptions Handling, Optimizations process, CDC, and Real - time & Batch processing
  • Implement Reference and Master Data Model
  • Reference Data Management (Vocabularies, Standardize Terms, Code Values, Unique Identifiers, Business Definitions, Reference Data Values to classify and Categorize, and etc.)
  • MDM: Parties (Customer, Individuals, Organizations, Roles, and etc.), Products (internal and external), Financial Structures (GL, Cost Centre, and etc.), and Locations (Addresses)
  • Data Strategies (Standard business definition, strategic data requirements, and etc.)
  • Enterprise Data Model
  • Data related deliver architecture: (data integration, database architecture, data lake, data warehouse / business intelligence architecture, and meta-data architecture)
  • Good knowledge in: Windows, Linux, Network, Storage, VMs
  • SDLC, Waterfall Development Cycle and Data Quality Life Cycle (V-Model), Data Management (DAMA), and Agile Framework (Scrum and Kanban)
  • Planning, Roadmap, Timeline, Resource Management and Allocations, Facilitation & Workshop, Stakeholder and Vendor Management, Solution Proposal/Recommendation, Stakeholders Presentation, Governance, Implementation Process, Change Management, Code Review, and Production Support (BAU), Data Requirement Gathering, Functional Specs, and Technical Specs.
  • AVP, Manager, Team lead, Technical Lead, Data Architect, and Lead Consultant
  • JIRA, Mantishub, IBM ClearQuest, MS Project, MS Visio, SharePoint, and MS Office.

TECHNICAL SKILLS

SQL Server 2005. 2008, 2012, 2016 (JSON Query, T/SQL, Partition, Data Files, Index, Constraint, Tuning, Table Structures, Database Creation, SQL Server CDC, and etc.)

Oracle 8, 10g, 11 (JSON Query, PL/SQL, Index, Constraint, Partition, Data Files, Tuning, Table Structures, Database Creation, SQL Server CDC, and etc.)

Data Lake/Big Data: AWS (S3, Hive, Redshift, EMR, EC2, Athena, Parquet File, CloudWatch, Versioning, and etc, Hadoop (Hortonworks, Cloudera, Spark, Impala, Kudu, Hive, MAPR, Yarn, HDFS, Parquet File, and etc.), IBM Infosphere (DataStage, Architect, Administrator, Installation and Configuration), SSIS, Informatica 7

Quality Assurance: Test Plan, Test Case, Preparation of Test Data, Test Execution, Unit Testing, SIT, and UAT

Programing: Visual Basic, Java Script, SQL, Java, Phyton, and etc.

PROFESSIONAL EXPERIENCE

Confidential

Principal Lead Consultant (Data Architect)

Responsibilities:

  • Lead the data solution and architecture of the Data Management of the Maritime Data Hub SQL Server 2016 and Bigdata in Cloudera Hadoop Platform.
  • Lead the data requirements and come-up end to end data flow diagram, ETL design, and framework that will be developed using Talend Studio. This includes strategizing how the Talend Architecture, Setup and Configuration will be implemented for Talend Big Data Platform, TAC, Nexus, SVN, Job Server, and etc.
  • Lead the development and implementation of metadata and data management, Talend Streaming (runtime, and ESB), Data Preparation, Data Quality, and Data Catalog
  • Developed a dynamic ingestion framework and other ETL reusable frameworks that will help the implementation much faster
  • Plan, design, and implement end to end solution from disparate source data up to MDH data consumer. This includes the data ingestion for CDC process, data replication, batch processing, ETL process, staging and archiving process to Hadoop platform, SFTP process, creating and managing files, and process for cloud integration in AWS S3 and MySQL
  • Designed and developed data flow from MDH to Cloudera Hadoop (HDFS, Parquet File, Hive, Java, Spark, Cloudera, Impala, MAPR, Yarn, Kudu, and etc.)
  • Recommend and implement all the high availability, load balancing, necessary infrastructure and hardware specification in order to sustains client business needs and requirements.
  • MAS Data Analytics,, SFA Data Lake, and STB STANTI Pre-Sales - Provide initial solution, estimation effort, estimated cost, estimated resources, review tenders specification and compliance, and etc. in regards of Pre-sale.
  • Developed POC or Prototype that will be used for Product demonstration and presentation that includes some sample framework using Talend products such as Talend Big Data (standard, spark, and MAPR), Data Profiling, Talend Data Catalog (metadata harvesting, sematic flow, data flow for data lineage and data impact, data mapping, metadata comparison, business glossary, and etc.), Talend Administrator Center, and etc.
  • Recommended Holistic Data Management Programs and solution platforms that involves Data Integration, Data Quality, Data Profiling, Metadata Management Platform, Reference and MDM, Data Preparation, Data Stewardship, Solution Architecture Environment, Centralize Administration (includes Schedule, Audit, LDAP, SSL, Monitoring, Security Accessibility), Continues Development, GIT/SVN, Data Staging, ODS, Datawarehouse, Big Data Platform, and Data Modelling
  • Design Data Model in RDMS and Big Data Platform (HDFS, Cloudera and Hortonworks, Hadoop Parquet File, Hive, Java, Spark, Cloudera, Impala, MAPR, Yarn, ORC, Kudu, and etc.)
  • Lead the data design and implementation of the Talend Platform (Big Data Platform, CDC, Talend Real-Time Big Data, Data Catalog, Talend Data Management, Data Preparation, Data Profiling, Data Quality)
  • Work with Business Stakeholders/Users, Data Scientist, Data Governance, Business Intelligence, and Infrastructure in building data related activities and robust analytics solution.
  • Propose DevOps (CI/CD) Solution (Talend Studio, Github, Jenkins, Nexus, TAC, Maveen), Hive Availability, Load Balancing, and Disaster Recovery
  • Development of data architecture, strategy and governance to support business, application, security and technology strategic analysis and decision making
  • Assessment of current and target states of the data architecture to align with strategic or tactical objectives and to develop recommendations to close the gaps
  • Integrate cloud and on premise data warehouses and data lakes with metadata management, for powerful data-driven solutions
  • Provides consultancy to clients in areas of data governance to improve quality and control in the management and usage of data. Helps help defines standards, processes and adopts best practices in data management.
  • Presents roadmaps and architecture landscapes to senior stakeholders to fulfil the organization’s data science, cognitive, analytics and reporting requirements
  • Evaluation of data related technologies, and defining best practices in the assessments of standards, tools and methodologies including ETL development, to perform hands on data analysis.
  • Design and develop reusable frameworks and processes that shall provide efficient and faster implementation.
  • Create innovations in both analytic algorithms and methodologies with business impact. Responsible for the end-to-end process of analytical solutioning, involving conceptualization and business engagement
  • Ensures data quality and performs data cleansing to ensure a single source of truth, to enable data as a service for business units and front-end applications to consume.
  • Perform quality review of data modelling design and deliverable, leading work sessions and deliverable presentations with business stakeholders
  • Manage architecture and technology governance committee agenda to ensure data, security and technology requirements aligned to enterprise standards and policies

Technologies used: Talend 7.0.1 (TAC, Nexus, SVN, Talend Real-Big Data Platform, Talend Data Quality, Talend CDC, Talend Data Catalog, Data Preparation, Talend ESB, Data Stewardship, MDM), AWS S3, MySQL, SFTP Server, Sybase Hana, Oracle 11g, SQL Server 2012 & 2016, Cloudera and Hortonworks (Impala, Spark, HDFS, Hive, Oozie, Zookeeper, MAPR, Yarn, Parquet File, HDFS), Windows 2016 and OS Cluster, and RHEL.

Confidential

Data Integration Manager

Responsibilities:

  • ODS (Operational Data Store) - Supported International Health, EB Portal, Travel App, PMAP, CRM, Customer Portal, Chatbot (AI), Sales and Marketing, Chabot, Finance Detail GL, Group Asia, and etc.
  • Data Lake and DW (Single Customer View) Phase 1 - Sources from Life Assurance, General Insurance, Intelligent Life, CRM, AWPL (PDF files), WebDB (JSON and XML data), Group Asia, and Integration Systems.
  • Project Supported and delivered different Insurance Products and Benefits development such as International Health, GI Renewal, Promo Code Layering, PMAP, Portal, Customer Portal, Home Insurance, Chatbot (Policies, Claims, and etc.), Mobile Health Care, Travel Benefits, and etc.
  • Responsible for the data governance, data management, and data architecture of the data integration application such as ODS, EDW, and Data Lake.
  • Build end to end Data Architecture for different type of Data Integration such as: ODS (SQL Server), Data Lake (AWS-S3), and Data-warehouse (AWS-Redshift). Designed Data Flow for different types of Data such as: Structured (AS400, RDBMS), Semi-structured (JSON and XML), and Unstructured (Voice, Images, PDF, and etc.). Convert Semi-structured data to structured data. This include the best and standard practices in building ETL and Data Modelling.
  • Assess and identify the full technology stack will be used such as: Data Modelling, Data Management, CDC/ETL/ELT, Data Profiling and Cleansing, Streaming, Repository (Storage), Reports/Analytics, and Data Mining.
  • Build a Data Governance Program in regards of several types of data management like metadata management (enterprise data model, data lineage, data dictionary, data mapping, and etc.), reference and master data management, data quality, data operation, and etc.
  • Review the business requirements then recommend and deliver the solution that will sustain business needs.
  • Gather and understand report requirements then propose, design, and develop dashboard required.
  • Provide insight into leading analytic practices, design and lead iterative learning and development cycles, and ultimately produce new and creative analytic solutions that will become part of our core deliverables. Work with Actuarial Team to understand the data requires or they need.
  • Manage system vendor, communicate to end-user, and interacting with internal stakeholders like Marketing, Analytics, Finance, Actuarial, Claims, CRM, and etc.
  • Plan, design, and develop a robust CDC and ETL/ELT Solution based on the heterogeneous data source, transformation, denormalization, aggregation, and etc. Including in the data development management and data operation management like (Error Handling, Control Process, Audit Process, Email Alerts, Health Checking, other standard practices in terms of structures and data integration)
  • Managing business intelligence and analytics including administration using Qlik Sense
  • Oversee the Change Data Management using Mantishub and JIRA for Data Integration Applications.
  • Prepare and present Project and BAU status updates for C level management. This include presenting Proposal, Design, and Solution to IT SteerCo meeting.
  • Developed MOLAP for Insurance Intelligent Life using SSAS
  • Managing and executing several POCs for CDC, JSON Data, Talend, Apache Spark (Python), and Amazon (AWS, Redshift, Athena, EMR, and etc.) for Data Lake and EDW
  • Support CTO to implement the Data Strategy (Plan for manpower development, Plan and monitor career development for each IT staff, Responsible for staff recruitment, appraisal and training, Document data standards, requirement specifications, and business processes)

Technologies used: IBM Infosphere (Datastage, Operational Console, Parallel Extender, CDC, and etc.), AWS (S3, Redshift, EC2, EBS, Hive, Pigweb, Cloud watch, Versioning, Athena, EMR, Parquet File, and etc), AS400, SSAS, SQL Server 2012 & 2016, Erwin, Power Designer, Talend Platform (Talend DI/Studio, TAC, Nexus, GIT, DQP, and etc), AS400, Qlik Sense, R, SQL Server CDC, Mantishub, MS Visio, MS Office, MS Project, and JIRA

Confidential

Data Architecture/Management

Responsibilities:

  • Project leader of the data initiative for Business Intelligence Platform Metadata enrichment
  • Reviewer of the Data Model/Architecture of the data warehouse for Financial Risk Data Ledger in Hadoop.
  • Data Management for Group Finance Project in terms of data issues and quality.
  • Project Manager of group finance project track for ‘Product Code and Tree Roll-up alignment of Financial Accounting and MIS.
  • Review, recommend, and design the solution requires for Semantic and Agnostic Data Model such as: Conceptual, Logical, and Physical Data Model that used for big data (Hadoop) and data warehouse (Teradata and using FSLDM). Assess the appropriate data modelling by using Snowflakes (Data warehouse) and Start Schema (Big Data)
  • Review, propose, and design the reports and dashboard applicable for each report requirements.
  • Review and recommend standard Metadata Management: data model, data lineage, data mapping, and data dictionary including the identification of the system and business definition created of each entities and attributes.
  • Execute data management policy and process to any respective data initiative and project tracks. This includes reviewing and assessing the requirements, issues, data quality, and impact analysis of each items or cases raised by business users. Recommend the architecture, process, control, and governance required.
  • Participate in the design and enhancement of Data Governance Program, Data Steward, and Data Quality including data profiling and data cleansing.
  • Review, propose, and design ETL/ELT process flow and creating standard practices not only for data development but also data operation,
  • Facilitate and participate in requirement gathering to understand and support the business needs.
  • Execute the POC using spark programming handle data upstream and downstream of Big Data (Hadoop)
  • Design and develop data quality metrics using Qlikview and Qlik Sense
  • POC creating reports and dashboard using Power BI for other department.
  • Review and redesign ETL pipeline and data transformation using Apache Spark and Python
  • Identify, propose, and execute the necessary approach of which Agile Framework or SDLC applicable to deliver the initiatives or projects involved.
  • Execute project management such identifying the business case, preparing project charter, resource planning, vendor management, communication plan, and etc. This includes the reporting for project status, issues, change request, and escalation. Facilitate and oversee the entire execution of the project.

Technologies used: Erwin, Mega, Hadoop, Teradata, JIRA, Confluence, Qlik Sense, Qlik View, Power BI, Cloudera Hadoop (Hive, Apache Spark, Zookeeper, Oozie, Impala) MS Visio, MS Office, Informatica, and MS Project

Confidential

BI/DW Data Modeller (Manager)

Responsibilities:

  • Oracle Financial and GE Business Insurance as part of regional Project called Megatron for Data warehouse, DataMart and Operational Data Store
  • Review, Design, Recommend, and Implement Insurance Information Warehouse (IIW) industry model (Life, Premium, Claims, General Insurance, Corporate, Agents, and etc.)
  • Assess Data Model for the Impact of the upcoming project for BI Customer Analytics
  • Assess, Evaluate, and Analyse the impact and challenges once the EDW design from FSLDM into IIW design approach.
  • Review, propose, and design Data-warehouse Architecture in Enterprise Level improvement.
  • Participate in terms of Business Requirement gathering to Data Requirement then translated the BRD into Technical Design including the definition and articulation of business rules for data accuracy and consistency.
  • Determines the Data-warehouse Architecture Design and database structural requirements by analysing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems
  • Plan, Design, Recommend, and Develop Data Model using a Hybrid and Data Vault related approach in implementing Data warehouse. Designs, maintains and builds conceptual, logical and physical database models including the reviewing, assessing, and evaluating the Vendor Data Model Design and Development.
  • Applied the IIW framework in GE Data Warehouse Standard/Customize Design Methodology and recommend/establish Data Modelling standard rules and principles as common and best practice across different domains.
  • Create a systematic process in terms of communication, task deliverables, and process improvement to reduce development time.
  • Monitoring, leading, and driving the team to ensure the task and commitment tracked and delivered as per project plan and budget including guiding the team in proper execution and format of Data Mapping, Data Profiling Process, and Identification of the business glossary. This includes the vendor management and assisting resource planning.
  • POC using different ETL technology like Talend (DI and Metadata Management) and IBM Infosphere Datastage
  • Plan, recommend, review, and design CDC and ETL/ELT Process flow including best practices (e.g. Error Handling, Audit Process, and etc.)
  • Analyse, Design, and Identify the BI requirements and elements required in creating the reports, dashboards, data visualization, and etc.
  • Provide Data Model walk through to internal and external team (like user from downstream and contractual developers).
  • Plan, Design, and Execute Data Warehouse Testing Life Cycle. Assist business user how to execute SIT and UAT the whole test cycle, from Creation Test Plan up to UAT Sign-off

Confidential

Data warehouse/Business Intelligence Consultant (Sr)

Responsibilities:

  • ODS Phase 2 SIT (Financial Module-GL and AP), for real time report, Including the report requirement for Journal Reports, General Ledgers, Account Analysis, Trial Balances, Invoice Accounting Entries, and etc.
  • Customer Loyalty Programmed Integrated Database assigned as DW/BI Technical Lead, Analyst and Designer including functionality for Green Report Internal Portal FXAP
  • Created and developed Data Model, Data Profiling, ETL Design, UML, Data Standardization, and Develop BIS for Simple Information Exchange System (SIES) and Integrated DB, Green Report Project (Functional Usage, Energy Usage, and Paper Consumption requirements)
  • Propose and design Data-warehouse Architecture improvement (Data Flow, CDC, ETL process, Data Modelling, Staging, and Data Consumer like Cognos and Microstrategy)
  • Business and Data Gathering for the user requirements, provide estimation and create project timeline for the potential implementation Dates.
  • Create Technical Specification that including the Data Modelling (Conceptual, Logical, and Physical) in a formed of Dimensional Modelling for the Star Schema and De-normalize Approach for difference scenario and analysis base from the Business Requirements.
  • Design and Develop the table structures including the analysis and anticipation of the Partition, Indexes, SQL Queries, and other potential optimize solutions for the Database side.
  • Design the Source Target Mapping and consideration and business transformation logic to build the Detail and Summary fact tables that used in the BI reports.
  • Plan, Design, and Develop the ETL process in order to extract and populate the data from heterogeneous data to Data warehouse with the optimize solutions.
  • Support user requirements and change request by means of data gathering, solution recommendation for best approach, data investigation, resources and effort estimation, and implementation.
  • Work closely with business users in different location/Countries (Japan, HK, SG, TH, MY, NZ, AU, PHP, and etc.) to ensure that functionality in the supported systems used in the correct manner, and adequate processes are in place to handle issues reported by the users.
  • Design and develop oracle golden gate to transfer or migrating the data from one database to Oracle Exadata. Golden gate used for near real time process, replicate the data, transactional CDC (Change Data Capture), transformation, and verification.

Confidential

BI/DW and QA Analyst

Responsibilities:

  • Analysed the business requirements and data gathering and translate into technical solution for Financial G/L Data warehouse in terms of Period snapshots and journal entry transactions. Handling common G/L challenges including multiple currencies, multiple fiscal years, unbalance organization trees and series of events of budgeting process chain. In addition to this project is, multidimensional OLAP products for financial analysis.
  • Oversee and monitor the whole Software Development Life Cycle of a Project for each phase such as Initiation, Elaboration, Construction, and Transition Phase. Design and develop Bus Matrix, Identify the business process model and understand cross functional of different kind of business areas that will be used in Data modelling.
  • Plan and Design CDC and ETL process from the heterogeneous data, staging and up to Data-warehouse. Implement the business logic in the ETL by identifying the proper data transformation and cleansing that will push to the Business Intelligence repository. Apply the proper Control and Data flow task to ensure the accuracy and data completion.
  • Provide detail information for test Scenario, Test case, Test scenario, Pre-condition, Test Steps, Test Data, Expected, and Actual Results.

Confidential

QA Analyst (BI/DW)

Responsibilities:
  • Assigned as Senior QA Analyst by overseeing the Development, Changes, Quality Assurance, User Change Request, and etc.
  • Review the Business Requirements against the Technical Specification of the CDC and ETL process flow and identify all the defects. Create a checklist for standard way of Testing the Web Page, Desktop, Client Server, and Data warehouse applications like the following areas: compatibility, usability, security, functional, Performance, data completion, data transformation, data quality, integration, regression and etc.
  • For a medium project requirement, managed and works (across different time zone) with developer/software engineers, other QA engineers, and product managers as needed, to ensure quality and successful rollout of new applications or features, and Assist/Support in User Acceptance Testing.
  • Provide quick action against any critical issues related to the supported systems at all times. Investigate the data issues directly from the database using SQL and creating some store procedure for some automation process. Conduct data analysis as needed to support optimal solution

Confidential

Data warehouse/Business Intelligence Consultant

Responsibilities:

  • Provide contribution in supporting the whole software development phases (SDLC) of project and send status to the project manager.
  • Provide BI and Data warehouse solutions and ensuring the Quality Assurance of the application is free from error.
  • Responsible for the Analysis of the business requirements and translate into Technical Specification.
  • Plan, Design and Develop ETL workload and processes from heterogeneous data and ODS to Data warehouse and Data mart storage application.
  • Including the Data warehouse process development and systematic metadata management/data profiling/data lineage solution and services.
  • Identify the non-heterogeneous record-oriented, Item level data metadata from diverse collections, normalizing data and improving the quality.
  • ETL design and development such as Process Cycle, Work Flow, Data Cleansing, Data Validation, Performance Tuning, Data Transformation and etc. SME for the Design and Developed database/table structure (Index, Partition, Relational Database, Database Management, Monitoring and etc.).
  • Design and develop optimize solution of Dimensional model for OLAP/MOLAP Cubes and create different type of Reports such as Dashboard, KPI's, Report Drill Through, Crosstab/Pivot tables, List, Charts and etc. Design and Create Dashboard that will sustain the defined Analytics Themes of the Business matrix/process

Confidential

Business Intelligence Consultant (Team Lead)

Responsibilities:
  • Provide BI solutions and Data warehouse applications. Carry out requirement analysis, system design, documentation, hands-on application development and database schema design.
  • Plan and design high level approach for EDW development cycle, Data Architecture (derived from the business process model and data gathering), and ETL process flow (base from business requirements) then present to the client. Performed the Data profiling and Data Modelling that will be used in the Data warehouse process, Database structures, and ETL process Cycle. Lead the design and development of the database/table structure (Index, Partition, Relational Database, Database Management, Monitoring, and etc.) and development for SQL (T/SQ, Optimize queries/solutions, Stored Procedure, User-defined Functions, Triggers, Constraint and etc.).

Confidential

Senior Consultant

Responsibilities:

  • Lead the BI Technical Development in terms of Database, ETL and Front-End design, Web/Window Application and provide Analysis of the business requirements and translate into Technical specs.
  • Involved in the whole process of the Data Warehouse Development Cycle such as Planning, Business Requirements,
  • Development including Design, Software Testing including the support for UAT, and Implementation.
  • Project Planning and Responsible for Project Timeline, Team Plan, identify Role & Responsibilities needed, Estimation of work load and Design up to Implementation and Estimation of Cost and Budgeting for the Individual Role, Resources, Software Details, Hardware Details and others Cost.
  • ETL Design (Defining Data flow, Handling data errors and etc.).
  • Prepare technical documentations and Data Modelling for ERD purposes of the Reference, Dimension, and Fact tables design diagrams and other technical specifications. Develop ETL jobs using SSIS. Select reliable Control Flow Task, Container, Data Flow components that will match the requirements for the right transformation of source data into accurate output.
  • Use SSAS for the Data Modelling and design dimension, hierarchy, measures. Develop Reports using SSRS/Report Builder for different kind of dashboard and KPI’s. Design the reports in which it can use the drilldown, drill through, and etc.

Confidential

System Analyst/ Programmer

Responsibilities:

  • Web/Window Application and provide Analysis of the business requirements and translate into Technical Specification,
  • Provide ETL Designed and Developed such as Defining Data flow, Handling data errors, Defining/Analyse from Data sources going to Destination, Data Cleansing, Fine tuning, Optimization, ETL Mapping from source to target, Naming Convention and etc. Analyse, design, develop and support new and existing store procedure, functions, packages, and triggers to sustain the business need for daily activities of the software application. Identify and implement the change requirements or enhancement made to optimize the solutions.
  • Develop Data Model and design dimension, hierarchy, measures. MDX, calculation, actions and etc. that will be use for the analysis of the business user. Create Reports using SSRS. Design the reports in which it can use the drilldown, drill through, and etc.
  • Involved of the Ordering Management development including billing, shipping and invoices.
  • Involved in the data gathering of business requirements and translate into standard technical specification.
  • Analysed and developed Web Application for Online Ordering and Tracking System which includes billing and shipping products from one place to another.
  • Involved in the Business and Data gathering in Initial development of initial BI CRM business Analysis project for Australia.
  • Gather all the information for all aspect of Business, from Marketing, Sales, Operation, and Services

We'd love your feedback!