SUMMARY:

• A seasoned IT Professional specializing in Business Intelligence Reporting Solutions, Data Reporting/Business Analytics, Data Quality and Data Management. Possess unique blend of business and technology expertise
• Certified ScrumMaster
• Passionate business (product / engineering, growth, operations, marketing, customer, finance) analytics expert, critical thinker and ideas - generator, with deep understanding of technical processes and data structure with strong capabilities to make meaningful connection(s) and bridge the gap between data and business needs to drive decision-making.
• Designed data structures using SQL and Excel for business intelligence and reporting which include but not limited to Demand creation, Sales and Digital marketing, loan, deposit, variance and trends via dashboards.
• Data gathering, documentation and evaluation of system specifications for business requirements.
• Performing against KPI and SLA targets in terms of issue response and resolution times.
• Maintained proficiency with respect to SAS programming and statistical methodology.
• Data Migration/integration, analysis and reporting functions using SSIS, SSAS and SSRS.
• Provide data, write SQL queries for data manipulation and generate/build reports as requested.
• Ensure routine data backups on Oracle and SQL servers are performed as outlined by the Backup & Restore Manual.
• Maintained working knowledge of marketing analytics techniques such as Customer Segmentation, A/B testing
• Used BI tools like Oracle BI,Tableau, Domo and Cognos to explore, visualize, analyze and create dashboards to consolidate views for the management as requested, pulling out the reports as needed.
• Responsible for the translation of the Business Requirements into clear IT Systems Requirements.
• Designed business data structures and analyze/report using BI tools, power point and Think-cell.

PROFESSIONAL EXPERIENCE:

Confidential, California

Senior Data Management Consultant

• Datasource focuses exclusively on Enterprise Data Management, Data Integration and Business Intelligence (BI).Experts in data architecture, data modeling, data integration, data virtualization, data quality (DQ), MDM, metadata management, data visualization, mobile analytics, analytic and operational reporting, BI project management and Decision Intelligence, including both strategic and implementation services.
• Managing data structure, produce and automate KPI / performance reports and dashboards with storytelling for strategic business units, measured business risk to avoid unnecessary exposure, reviewed the performance against budget and communicated the variance to the stakeholders and provide workable intelligence based on the performance.
• Supporting demand Creation programs, normalize and map demand funnel Teradata (social media, contacts, campaigns, leads, opportunities, bookings and revenue) and integrate into the data center for transformation.
• Working with sales and marketing to validate lead to opportunity data mapping, and automate/generate reports not limited to conversion rate of the demand creation funnel, average deal sizes, forecast to actuals and lead velocity
• Digging into data and the metrics that drive the demand programs as well as demand funnel, making connections, and creating reports that stake holders can easily understand and operationalize
• Extract, transform, load, analyze and visualize salesforce, marketo, adobe analytics, omniture and Eloqua data in domo - BI tool
• Managing tasks and projects as well as assisting in documenting requirements for the company Global Demand System and recommending improvement to data linking logic and processes
• Build, automate and manage reports in Business Intelligence Systems with storytelling
• Perform ad-hoc report gathering, analyses along with data extraction requests using Microsoft office suites and SQL
• Supporting integration and streamlining of external party’s database with our system
• Report presentation with all types of internal and external stakeholders onsite and remotely
• Work in a cross functional team to gather demand linking data to recover demand/Revenue forecast
• Data Migration/integration, analysis, reporting and also developing analytical approaches and hypothesis
• Flexible work schedule to facilitate meetings across multiple time zones

Confidential

MIS/ Business Data Analyst

• Delivered a comprehensive Techno-Functional/ MIS role as well as managing modules, functional and technical requests on Oracle-Flexcube (Core banking application) and other external applications of the bank.
• Provide data, write SQL queries for data manipulation and generate/build reports via SQL as requested
• Used Tableau,Cognos and Business Object to explore, visualize, analyze and create dashboards to consolidate views for the management, regulatory units, branches, marketers, Investment, finance, HR and Cards business partners.
• Ensure routine data backups on Oracle and SQL servers are performed as outlined by the Backup & Restore Manual
• Successfully implemented, tested and Go-Live of Oracle EBS and Oracle Flexcube from Oracle FCR.
• Data Migration/integration, analysis and reporting functions using SSIS, SSAS and SSRS.
• Implemented and supported Products (Investment, deposit, loan), Account classes, Interest and charges, GLs, Branches, Card bins (Visa, master and verve), Transaction Codes and MIS modules on Flexcube (Oracle) and also supported users.
• Provided training, Functional support and also developed a comprehensive documentation for procedure manual, system enhancements and business cases supporting the development needs on Oracle Flexcube UBS 12.0 modules,Oracle EBS and COGNOS data warehouse
• Meetings, Local and remote support using VPN and webEx connection to an ITIL-aligned process within SLAs
• Ensures back-end and front-end synchronization and also troubleshoots and analyzes code to find root cause of errors
• Development of functions, procedures, triggers & packages using SQL to implement business logic
• Reviews and analysis of business performance and operational efficiency

Confidential

Senior Business Data Analyst

• Data gathering, documentation and evaluation of system specifications for business requirements.
• Develops and implements comprehensive test plans to ensure that systems and programs are tested and debugged.
• Determines proper installation parameters for software and hardware, for smooth integration, change and efficiency
• Run SQL queries and output result set to Excel for various analyses and reporting
• Worked closely with management to prioritize business goals and information needs.

Confidential

Application / Data Analyst

• Providing all level application support and resolution management within health public sector setting
• Manages ETL processes and generate ad-hoc reports from crystal, Oracle and MSSQL databases as required
• Working within a multi-platform, Teradata and mixed operating system environment (Unix/Linux)
• Conducting data cleansing, integrity checking, updating system documentation and relevant procedures
• Data gathering, documentation and evaluation of system specifications for business requirements
• Supporting data security policy through maintenance of Oracle user accounts and access permissions
• Performing against KPI and SLA targets in terms of issue response and resolution times
• Develops and implements comprehensive test plans to ensure that systems and programs are tested and debugged
• Determines proper installation parameters for software and hardware, for smooth integration, change and efficiency
• Works closely with management to prioritize business goals and information needs
• System performance monitoring including error analysis and security monitoring
• Operating in line with defined service management frameworks; following procedures for call logging, prioritization of issues/incidents, managing user expectations and reporting
• Contributed to driving system improvements, reported recurring issues through appropriate channels
• Liaising with ICT department in resolving hardware failures affecting the operation of Oracle including escalating significant disruption incidents and ensuring effective user communication

Confidential

Systems/Reporting Analyst

• Delivering comprehensive IT support to over 3000 user-base within this major financial service provider by ensuring that all incidents/service requests are logged, documented and prioritized with progress effectively conversed back to users.
• Run SQL queries and output result set to Excel for various analyses.
• Meeting, Local and remote desktop support using VPN and Webex connection to an ITIL-aligned process within SLAs
• Installation of computer hardware and peripherals; managing infrastructure and software deployment processes
• Application support (Astra, Remedy, Tivoli, Exchange/Outlook, Oracle), plus UAT of new applications
• Identifying trends and escalating incidents to both internal and external (System providers) parties as required by strict procedures and advising senior management and colleagues
• Identifying potential system failures and weaknesses and proactively advice management on course of action

Confidential

Systems/Data Analyst

• Responsible for the translation of the Business Requirements into clear IT Systems Requirements.
• Used Tableau desktop to explore data, visualize, analyze and create dashboards to consolidate views for the management as requested, pulling out the reports as needed.
• Responded to department requests for financial data, providing financial expertise in Project Management
• Coding of system data and also ensured that all system-related reporting issues were resolved promptly.
• Continual measurement of company performance against agreed strategic business plan.
• Designed and produced reports with detailed commentary and variance/trend analysis, identifying areas of potential improvement and highlighting risks for the purpose of business intelligence via manipulation of data on SAS
• Assisted with the automation of common tasks to secure increased in efficiency
• Coordinated software and system test which include preparation of acceptance test plans, test planning, test execution, and monitoring and oversight of test execution

Confidential

Financial Data Analyst

• Maintained accounting records and prepared management accounts
• Established and integrated new investments into existing systems and processes
• Monitored existing investments, primarily through analysis and interpretation of financial information
• Designed financial data structures in Microsoft excel and analyze/report using power point and Think-cell

Confidential

Data/Reporting Analyst

• Produced performance reports of the strategic business unit, regulatory report and provided financial advice based on the performance; reviewed the performance against budget and communicated the variance to the management
• Assessed the credit-worthiness of client companies; underwriting loan modification, renewal, and extension requests using bank credit policies to spread customers’ financial statements in order to determine the financial position of borrowing customers, measuring risk in the business to avoid unnecessary exposure

Confidential

Data & Reporting Analyst

• Maintained knowledge of compliance to ensure deliverables consistently met regulatory requirements
• Designed data structures using SQL and Excel for business intelligence and reporting which include but not limited to loan, deposit, variance and trends via dashboards.
• Appraised transactions and verified if executed transactions were conducted under appropriate approvals.
• Balance sheet /income data monitoring and also supervised the Inventory and tagging of assets acquisition
• Provided data for external auditors -PricewaterhouseCoopers (PwC) during audit process