Senior BI Consultant
Business Development Trading Establishment / Arab National Bank
Total years of experience :14 years, 10 Months
● Worked closely with business counterparts in identifying and prioritizing their needs, analyse and define business requirements and functional specifications.
● Facilitate project meetings with all stakeholders. Actively manage project plan and deliverables.
● Acted as primary liaison among internal client departments, Information systems and IT vendors.
● Managed vendors during the pre-sales and post sales activity and assisted the senior management in verifying the proposed statement of work by the vendor.
● Worked with compliance department for defining the scenarios and threshold values for Anti Money Laundering(AML) and investigating the sensitive unreported suspected transactions by the system.
● Successfully implemented the integration of ANB's remittance system with the AML/CTF using enterprise data warehouse (EDW) and SAP BO.
● Helped ANB's private banking in saving 20000 USD by resolving a critical data issue in the ETL cycle.
● Was responsible for managing the 10 terabyte (TB) enterprise data warehouse on OFDM.
● Fine tuned daily ETL cycle from 16 hours to 8 hours.
● Successfully upgraded IBM datastage 7.5 to 8.7 and managed 750+ daily ETL jobs using IBM datastage along with 125+ universes using SAP BO’s central management console (CMC).
● Worked with the vendor on setting up a data mart for fulfilling the business reporting requirement by finance & planning department.
● Provide monthly remittance report to SAMA( Saudi Arabian Monetary Agency) for corporate, commercial and individual clients from the data warehouse.
● Fine tuned daily batch processing of AML from 26 to 4 hours
● Acted as a team lead and successfully handled the upgrade of the project worth 2 million riyals for AML.
● Worked in coordination with SAMA & PCI to close out the listed vulnerabilities and to achieve the PCI-DSS certification.
● Worked with various teams to set up disaster recovery site for AML, BO and ETL.
● Implemented partition pruning, parallelism features and various data warehousing techniques to optimise the query performance.
● Worked on maximising the return on investment(ROI) for the implemented enterprise data warehouse
● Interacted with the end user to get the business requirements.
● Created multiple reports for the business divisions using SQL developer.
● Actively involved in the functional design, development, testing and deployment of custom point solutions.
Client: Saudi Telecom Company (S.T.C)
● Worked on all phases of software development life cycle (SDLC).
●Involved in process reengineering, presenting and implementing ideas to restructure the IT and business processes.
● Successfully migrated 200 Gb database from MS access to oracle which had transactions worth 45 million riyals.
● Worked on data extraction from various vendor based servers i.e.
HUAWEI, Siemens, Alcatel lucent for creations of reports based on alarms triggered on network elements.
● Interacted with the end users ranging from project manager to a technician to understand, design and migrate the existing applications i.e. HRMS, fleet management and supply chain management from MS-access to oracle using forms 10g.
● Created various dashboards using xcelcius which was used by senior STC's management in the board meeting.
● Was responsible for daily administration and backup of the oracle database.
● Successfully restored a critical financial table with a minimum impact on the company's
financial operations using cold backup after got corrupted.
● Created multiple universes and webi reports using SAP business objects.
● Created CAPEX and OPEX sheets based on input from senior management.
B.TECH (Bachelor of Technology in Information Technology) Jawaharlal Nehru Technological University, Hyderabad, AP, India