SUMMARY

• 7+ years of experience working as a Data Analyst with deep expertise in requirement gathering from multiple stakeholders and departments with mix of supporting data driven decision making by analytics
• Hands on experience with ERP & CRM implementation (Salesforce and Microsoft Dynamics AX); certified in Finance and Trade & Logistics module
• Excellent skills in managing enhancement/feature upgrade of application (UI/UX)
• Extensive experience in data reporting, data cleaning, data architecture creating custom metrics/KPI’s/dashboard through data visualization using Tableau, Power BI, Qlik, Google Data Studio
• Experience in digital/web analytics using Google Analytics to track & monitor users to identify behavior patterns for driving user engagement, customer segments for Marketing analytics
• Business process re - designing using Signavio (BPMN) with simulation, Change Management across organization
• Data crunching, manipulation analysis/cleaning and management, report automation using SQL, MS Excel, VBA, Macros, SharePoint, Workday
• Facilitate the documentation of requirement into technical specification to support development and engineering of tailored solutions to cater to each party
• Conduct Gap-Fit Analysis, System Analysis, As-Is To-Be stage, supervising the development lifecycle using Agile/SCRUM methodology (SDLC)
• Efficient in coordinating and communicating with offshore team and track project progress and status update (JIRA, Assembla)
• Preparing demo data, user accepting testing (UAT), user stories, Go-Live (Implementation or Deployment at client location), User training
• Excellent Communication & Interpersonal skills, commitment to co-operative teamwork. Motivated team player with ability to work under minimal supervision
• Experience with working in Risk & Compliance side of operations using RSA Archer
• Use data to create models that depict trends in the client base and client as a whole

PROFESSIONAL EXPERIENCE

Confidential

Sr. BI Developer/Data Analyst

Responsibilities:

• Responsible for managing front end client portal (UI/UX, Liferay DXP 7) where clients engage with software/model documentation, configuration files, event id’s, event update, known issues, product documentation and creating cases for assistance with in-house products, RiskLink, HD Analyzer, Risk Intelligence, SiteIQ & RiskBrowser
• Assisted and owned Google Analytics deployed on client platform to track user activity to recommend multiple teams how to drive engagement. Track and bucket users for customer segmenting to engage with them for potential opportunities
• Define joins in Google Analytics to map each activity of user to company and then to contract/subscription to generate funnels for STP (Segmenting, Targeting & Positioning) for sales and Marketing teams
• Automated report generation from Salesforce CRM (data cleaning/extraction, SOQL)
• Designed 30+ dashboards and KPI metrics companywide for C-level executives, project manager, Product owner, CSM teams to view the user retention ratio and behavior patterns (Google Analytics, Google Data Studio, Tableau)
• Business process re-engineering using Signavio/Visio for optimizing data flow architecture and business process
• Data extraction and analysis using S&P Market Intelligence platform
• Supervised 2 platform version upgrade, 20 features/enhancement request by clients and stakeholders, managed QA/DEV/TEST environment for enhancement purpose
• Manage an offshore team of engineers and developers with client feature request or enhancement - Agile/SCRUM methodology
• Supervise the entire development process with multiple stakeholders, soliciting requirement and preparing Functional/Technical documents with acceptance criteria, workflow logic, conduct regression testing, user acceptance testing (UAT), user stories, Go-Live deployment, track progress of development (JIRA, Assembla)
• Content management of documents to be published, customizing the entire permissions of clients (based on active subscription - contract), automate the entire permission standards from Salesforce CRM, API design management (Logic and workflow)
• Content management via IBM Aspera, FileZilla
• Client on-boarding on Salesforce CRM and process owner of Salesforce work request - customizing the CRM application based on market needs/product manager/CSM team
• Managed the Salesforce CRM business process for Technical Team Request - assistance required by clients
• Transition department from Salesforce Classic to Salesforce Lightening version
• Designed a module for mass communication to clients based on their subscription using their behavior pattern to drive engagement
• Designed a module for mass tagging to optimize searched results (SOLR Engine)
• Designed the workflow logic for advance search filter to further optimize search results (SOLR Engine)

Environment: Liferay DXP 7, JIRA, Tableau, Power BI, Google Analytics, Qlik, Salesforce Classic & Lightening, Google Data Studio, IBM Aspera, SQL, SOLR Search Engine, Workday, SharePoint, Assembla, Signavio, Visio, MS Excel

Confidential

Business Intelligence Analyst

Responsibilities:

• Worked with GRC team to design Governance, Risk & Compliance metrics KPI
• Solicit requirement from stakeholders and prepare documentation on RSA Archer enhancement
• Gather requirement from C-level executives to monitor their department verticals
• Re-design the architecture of data pipeline and data flow matrix to ensure simplified solutions of the reporting process
• Deployed 50+ dashboards using Tableau, SQL & Power BI, automated data reporting from Workday, SharePoint and RSA Archer
• Data cleaning, working with outliers and anomalies, data processing (SQL)
• Customized Policy Management, Audit management, Enterprise Management, Business Continuity Management for high level information about risk matrix

Environment: Tableau, Workday, SharePoint, SQL, RSA Archer, Power BI

Confidential

Data Analyst

Responsibilities:

• Interact with clients and understand their business process/operations
• Document the functional requirement into technical specifications with acceptance criteria, workflow logic, enhancement, custom the entire module to build a tailored solution for the client
• Conduct Gap-Fit Analysis for Microsoft Dynamics AX 2012 ERP & CRM application
• Prepare project scoping, timelines, customization, work breakdown structure for the project
• Act as a liaison between development and engineering team to fulfill the requirement for tailored solutions
• Designing the system framework, data transfer between modules
• Re-design the entire business process of clients into the ERP and CRM system (BPMN)
• Track and monitor the progress of development (JIRA), attend regular client meeting for updates and changes in business requirement
• Prepare user stories, user acceptance testing (UAT), create Demo Data for testing purpose, train and prepare manual documentation for multiple departments of clients - how to use the ERP & CRM system, Go-Live (Deployment)