SUMMARY:

• Experienced Analytical Business System Analyst committed to maintaining cutting edge technical skills and up - to-date industry knowledge.
• Extensive knowledge in requirement gathering through user interviews, workshops and systems documentation, User guide documentation, data dictionary and procedures.
• Tableau 8.0, 9.0 Expert with experience in data and statistical analysis. Experience developing many Tableau visualization and dashboards with scorecards, KPI’s, optimization tools and Tableau server maintenance skills. Strong applied analytics’ skills with a passion for and demonstrable experience in transforming and distilling enormous data sets into information
• Ability to understand and write complex SQL queries using clients like SSMS, TOAD and SQL Plus Skilled in eliciting stakeholder demands and translating them to data, functional, quality and usability requirements.
• A Strong experience in MS Office Suite, MS Access, MS SharePoint Well versed in the entire Software Development Life Cycle (RUP, Waterfall, and Spiral) SME in GAP analysis between AS IS and TO BE workflow models
• Extensive knowledge in business and technical documentation including Project charter, BRD, FSD, Test Plans, Test Cases. Expert in liaising and coordinating with various technical and managerial teams at all levels of an organization. Creating Work Breakdown Structures (WBS), Project Schedules and Project Timelines.
• Very strong written and verbal communication skills including excellent facilitation skills with all seniority levels of business clients, IT representatives, internal team members and vendors.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Reporting Business System Analyst

• Work closely with business users, OR-Analyst and engineers to gather multiple data source requirement, and developed complex Tableau dashboards with visualization, and statistics calculations to support supply demand optimization, production performance and inventory.
• Excellent experience managing and maintaining the existing and new built visualization on Tableau Server.
• Prepare and conduct Unit Testing and User Acceptance Testing scripts and Bug Tracking
• Wrote complex SQL queries in support of ad hoc data requests, and to validate report data to requirements.
• Excellent understanding of BI Best Practices/Methodologies, relational structures, dimensional data modeling, SQL, data warehouse. ETL mapping and reporting techniques.
• Manage large/medium size projects as team member or lead to implement new functionalities and enhance existing functionalities including articulating, analyzing requirements and translating them into effective solutions
• Managed project portfolio for SDO project planning, and resource allocation using HP PPM and advanced Excel skills for project planning and scheduling.
• Created Project Wiki for planning, tracking and scheduling the weekly progress and created training manual/User guide for .Net UI, Tableau dashboards and process flow for Tableau RDMT (Resource decision management tool).
• Work with cross functional teams to prioritize work and drive system solutions by clearly articulating business needs

Environment: SQL Developer, HP PPM NV Bugs Quality Center, SharePoint, SQL Server, SSMS, SAP BW, Tableau Desktop, Tableau Server, MS Access, Advanced MS Excel, MS Word, MS Visio, PowerPoint, HP PPM.

Confidential, Irvine, CA

IT Business System Analyst/ Reporting Data Analyst

• Sales planning and reporting, communicating with district managers, regional sales managers and executives to gather field requirements to create Tableau 8.2 dashboards.
• Created a dashboard with scorecards to track progress for 350 reports
• Created Tableau Dashboards by extracting data from multiple sources including SAS, Oracle 11g, Salesforce, MS Access etc.
• Design and delivery of system analytics (e.g. feature usage statistics, executive dashboards, etc.) experience in designing and developing SQL queries which obtain data from various sources (e.g. Oracle, SQL Server, Hyperion, Cassiopae and MS Access)
• Experience working with multiple business groups/units like, Treasury, Bankruptcy, Recovery, Collections, Consumer Credit.
• Good experience working with complex data management initiatives, such as data mart data analysis, data modeling, data standardization, data validation, normalization, data profiling, data categorization
• Trained users on BO 4.1 Web Intelligence reports and developed SharePoint BO training portal for users

Environment: Metacenter, Business Objects 4.1, SQL Developer, MS Access, MS Excel, MS Word, Teradata, MS Visio, PowerPoint, HP Quality Center, SharePoint, SQL Server 2008, SSRS (SQL Reporting Services), Oracle Hyperion, BI Brio (a database query and analysis tool), Tableau

Confidential, SFO, CA

Business Analyst/ Data Analyst

• Worked on CMR (Customer Management Reporting) application with large set of data and complex analysis
• Worked with complex datasets and analysis to derive insights and investigate for customer conversions. Created stored procedure Automating data gathering/ reporting, & process improvements
• Customized CMR similar to Salesforce.com CRM modules to better track leads, prospects
• Responsible for monthly reports to upper management involving Trend Charts, Histograms, Pivot tables and ad hoc reports for key metrics and data modeling.

Confidential,Palo Alto,CA

Business/Data Analyst

• Involved in implementing and managing production support team and providing support to implementation teams for Order-to-Cash (i.e. Order Management, Service Contract, Bill of Materials, Advance Pricing, Oracle PIM, Installed Base and Business Intelligence) for Confidential .
• Gathering requirements from Business, articulate the requirement into Function Business requirements and performing gap analysis as-is and to-be with all the Impacts.
• Involved cross-functionally with key stakeholders in both IT and Business teams to create effective business process and systems process maps with key metrics and indicators
• Work closely with project stakeholders and directly with subject matter experts to identify and document end-user business intelligence needs for sales, revenue and market intelligence reporting and analysis needs.
• Worked on Static, ad hoc, automated and dynamic Hyperion Essbase reporting solution to facilitate a more efficient quarterly and annual reporting process.
• Implemented report /data validation in order to identify scalability of project in every level of organization
• Build Use Cases & Maintaining all the finance applications under SOX compliance