Business Intelligence Analyst
Awok
Total years of experience :11 years, 7 Months
Roles and Responsibilities:
• Experience with full development cycle of Data Warehouse, including requirements gathering, design, implementation and maintenance.
• Developed and Architected ETL processes for different projects (RMA, inventory, sale order etc.) Re-Engineer some of the current ETL processes to streamline the data acquisition and integration process using ETL tools.
• Involved in design and development of Data transformation framework components to support ETL process, which gets the Single Complete Actionable View of a Customer.
• Written ETL scripts to create DataMart from various sources for report generations.
• Written Python scripts to pull marketing data from various vendors application to Data warehouse
• Identify, analyse and interpret trends or patterns in complex data sets.
• Analyse, build and interpret multiple proprietary dashboards to track and improve the company's various business lines.
• Design, develop and establish KPIs to monitor analysis and provide strategic insights to drive performance within warehouse operations.
• Created UI using Python Flask Framework and Google cloud (App Engine, Cloud SQL and Storage) for interactive visualization.
• Analyse Google Analytics360 data for user interaction with our site and prepared necessary data require for Recommendation Engine to show personalized and trendy products to the customer.
• Establish and maintain SQL queries and routines
• Write ad-hoc queries based upon the schema understanding for diverse needs of our business
Roles and Responsibilities:
• As a shift lead, driving the Hand over call across the various shifts.
• To provide ongoing technical maintenance and usage support of business applications in order to maintain their reliability and business benefits.
• To track all pending issues and ensure the resolution of the same as per the agreed priority and timelines.
• To provide timely resolution for incidents reported and response to business users within SLA.
• Writing complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Well versed with Data Warehousing concepts.
• Managing end to end risk reporting process starting feeds from upstream to final reports delivery to business users.
• Performing incident management, request fulfilment, problem management for issues encountered during risk reporting process.
• Debugging the oracle packages, procedure, functions and UNIX scripts while investigating the issue.
• Automated space management of disk utilization in Unix shell script by applying business validations
• Validate changes / Request for Change (RFC) provided by business units in order to be developed in house or forward to vendor and accordingly route it
• Interacting with Business users and other teams to discuss the areas of improvement.
• To provide on-call support and problem resolution for computer applications, including post office hours and holidays.
• Responsible & accountable provide timely response (correct & complete) related to Audit subject.
Roles and Responsibilities:
• Creating and modifying shell scripts and stored procedure as per need of business requirement.
• Dealing with Non - SAP services based on technologies like Oracle, UNIX, Microsoft Technologies etc.
• Performing Application Functional testing and version deployment.
• Involved in end to end feed management from upstream systems to business users.
• Preparing the documentation along with the database design, UI, screen shots as per the clients’ guidelines.
• Daily interaction with client team to discuss areas of improvement and other items.
• Performing Disaster Recovery Test for application servers within team contract scope.
• Performing Incident Management, Request Fulfilment and Problem Management for issues encountered during report generation.
• Writing complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Dealing with packages, procedures, functions while investigating issue with report generation.
• Working on query optimization and other database aspects to improve the database performance for feed loading and report generation.
• Writing PL/SQL procedures, functions, package as per business requirement.
• Created Indexes on tables depending on select query for faster report generation.
• UNIX Object creation and deployment.
• Creating Shell scripts & CRON job automation for backups & FTP.