SUMMARY:

• Over 9 years of experience as a Business Analyst with exposure to various domains such as Finance, Health & Safety, Telecommunications and Banking.
• Motivated Business Analyst with the technical expertise and business acumen necessary to translate business requirements and objectives into scalable, highly resilient and successful system solutions.
• Professional experience in working on web development technologies.
• Experience in working with various SDLC methodologies like Waterfall, Agile (Scrum).
• Good understanding of data models, ETL, metadata, data mapping and data flow process.
• Perceptive and logical data analyst with the proven ability and experience in Business Data profiling, Data Cleansing, Data Analysis, Data validation and creation of reports.
• Proficient in interacting with stakeholders, Requirement gathering through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools
• Experienced on business and systems requirements, data validation and process improvement.
• Experience in conducting GAP Analysis between the "As - Is" and the "To-Be" process.
• Proficient in drawing UML Diagrams like Use case, Activity, Swim-lane and Data flow diagrams using MS Visio.
• Experienced in developing User Stories, Wireframes/Prototypes and Data mapping .
• Proficient in creating Business Requirements Documents ( BRD ) and Functional Specifications Document ( FSD/FRD ).
• Experienced in writing SQL queries to extract data and perform data verification and validation.
• Created Requirement Traceability Matrix (RTM) to trace requirements and manage Change Requests.
• Expertise in developing Test plans, Test cases, analyzing defects, performing User Acceptance Testing (UAT).
• Experience in providing training and production support to end users for new and enhanced applications.
• Conducted demo session, walk through and tackle with change management process.
• Created reports using pivot tables and templates using MS Excel and VB Macros.
• Good understanding with Defect and change management process.
• Ability to coordinate effectively between onsite and offsite teams across all phases of the project.
• Excellent leadership skills and team building with good knowledge in scheduling meetings, resource allocation, and maintaining the project schedules.
• Not afraid to fail, played multiple roles, good inter-personal skills, liaison between business and tech team
• Enjoy making quilts and various sewing projects

TECHNICAL SKILLS:

Database: MS SQL Server, Oracle, MySql

Analytical Tools: MS Excel, VBA, Tableau, Toad, Workbench, SQL Server Management Studio, Google Analytics, SAP EPM

Languages: SQL, VBA Macros, C# .Net, Swift, HTML, XML, Apex (Salesforce)

Modeling Tools: MS Visio

Wireframing tools: Balsamiq, Axure, JustinMind, PowerPoint

Source safe tools: VSS, SharePoint, Documentum

Quality/ticketing tools: HP ALM

PROFESSIONAL EXPERIENCE:

Confidential, San Leandro, CA

Business Data Analyst

Responsibilities:

• Development of Business rules using SQL and Infomatica.
• Performed extensive data discovery and data analysis tasks to identify invalid, missing and inconsistencies in data.
• Conducted data quality activities such as analyzing the data, understanding data models
• Supported the data warehouse team to solve inconsistencies and anomalies in source data as part of ETL process
• Comparing and identifying data problems using excel functions and techniques.
• Defining visualization models in Tableau
• Determining Business impact of the data quality issues and communicating it the end users.
• Logging data issues and maintaining Product Backlog
• Co-ordination with Tech, QA and Prod support to concur on backlog item priorities.
• Liaised with business to understand loan processes and customer/borrower data
• Conducted user interviews, gathered requirements.
• Reviewed and suggested ways the team could reduce efforts and work efficiently.
• Setting up UAT activities, documenting test cases and training business users on logging UAT results
• Tracking defects for priority and solution to be achieved
• Designed dashboard mockups and reporting models
• Helped identify root cause of defects and suggested corrective action.
• Conducted validation of SQLs scripts

Environment: Asp.Net, Oracle SQL developer, MS SQL Server Management Studio, MS Excel, MS SharePoint, HP ALM, Ab Initio, Informatica, Tableau

Confidential, Walnut Creek, CA

Business Solutions Analyst

Responsibilities:

• Used SharePoint to introduce process automation which eliminated manual tasks & ensure that users adhere to deadlines for timely delivery of Leadership reports.
• Developed dashboards with key sales KPI’s like EDI Sales Performance, Invoice Sales Performance
• Developed Templates to gather actual & estimated expenses for each department which would automatically create Budget Vs Actual Report.
• Conducted Data collection and analysis for Operational Expenses reporting
• Reconciled Sales data extracted from different sources and build level dashboards to measure performance of individual distributors
• Performed data Analysis using SAP EPM for Microsoft platform for Excel.
• Identified opportunities to improve process efficiency of sales reporting by improving communication by setting up automatic alerts in SAP between Sales department and Finance department.
• Organized requirements meetings and data mapping sessions with end users to understand business needs for new Performance dashboards
• Migration and testing of reports to Tableau interactive reports.
• Created and standardized on-boarding process and training documentation for Finance department.
• Led UAT, setup the UAT environment, gathered necessary approvals, trained end users to document test results, created UAT training material.

Environment: Oracle JD Edward, SAP, MS Excel, MS Visio, MS SQL Server Management Studio, Tableau

Confidential

Web Analyst

Responsibilities:

• Certified in Google Analytics
• Configured Google Analytics to receive customer visit information
• Provided data and reports for various customer behavior transactions
• Helped provide data insights for improving user experience, convert to a sale ratio, etc.
• Provided WordPress tool support for fixes as required

Confidential

Business Analyst

Responsibilities:

• Implemented Value Added Processes (VAP) to improve data transformation.
• Requirement gathering and Documentation of Reporting process for HS&E (Health, Safety & Environment) for 25 functional groups of Confidential .
• Created data mapping for moving data to data warehouse
• Good understanding of data flow and ETL process
• Coordinated with client and end users for understanding and standardizing key KPIs.
• Defined key metrics for charts related to Safety incidents and action items
• Identified, defined and assessing the feasibility automation.
• Improved process efficiency by 33%
• Provided detailed analysis and trends for key KPIs to support new global projects and initiatives.
• Played key facilitation role between Confidential Brisbane office and all locations of Confidential corporate offices spread across the world.
• Responsible to document requirements for Incident Management and GHG reporting modules in the EHS solution
• Responsible for creating FRD, User stories, Wireframes and requirement walk through sessions.
• Developed reports for key metrics like AIFR (All Injury frequency rate), LTIFR (Lost time Injury Frequency Rate), Near misses.
• Administered and trained users of HSE Management portal.
• Software developer and module lead, worked on creating web applications.

Environment: SAP, Oracle, Asp.Net, C#, MS CCF, MS SQL, Asp.net, MS Excel, Tableau