SUMMARY:

• 10+ years of Business Analyst with project management lead experience in multiple departments.
• Involved in training documentation and e - learning
• Provided processes for collecting, aggregating, matching, consolidating, quality-assuring, persisting and distributing such data throughout an organization to ensure consistency and control in the ongoing maintenance and application use of this information
• Development with Oracle Business Intelligence Enterprise Edition (OBIEE).Extensive expertise with SQL and PL/SQL Expertise in data warehouse dimensional and relational modeling.
• Worked on medium to large-scale data warehouses.
• Understanding of database performance tuning techniques as it relates to data warehousing.
• Experienced with all the techniques used to manage, build, and maintain a data warehouse environment. Communication and awareness across business units of technology project efforts and involvement or participation required from different areas of the company.
• Interaction / involvement with the solution delivery team for projects throughout the lifecycle. Involved with delivering critical reports used for vendor management, finance and accounting, field workforce management, operations management, and executive decision-making

TECHNICAL SKILLS:

ACT, ASP, Ariba, Business Objects XI, Eudora, Filemaker Pro, Go-Live, HTML, Internet Explorer, Lotus Notes

Office (Word, Excel, PowerPoint, Outlook, Visio, and MS Access), Sales Force CRM, Essbase,SAP

Financial Edge, Schedule Plus, SharePoint, SQL, Sybase

Budget Tracking, Financial Analysis, Forecasting, Revenue Accounting

Performance Metrics, Forecast vs. Actual, Variance Analysis and Summaries and Graphs

Software Development Lifecycle (SDLC), Application Testing and Support

Power MS Excel Use, Pivot Tables, Macros, Formulas, Graphs and Reports

EXPERIENCE:

Confidential, Cupertino, CA

Business Analyst

Responsibilities:

• Supported the VP of the Corporate Accounting and Director of Human Resources.
• Assisted PM in monitoring and controlling project progress against baseline work plan.
• Supported for E-Business Suite.
• Worked with various teams (Business Analytics, Sales Analytics, Sales, Client Services, etc.) to devise and deliver comprehensive, accurate analysis of the Stakeholder/Customer Initiatives business on an ongoing and timely basis.
• Kept management abreast of sales activity, delivered value, customer concerns, and provide ongoing assessment of quantifiable risks.
• Assist users with technical issues; work with E- Support to resolve service requests.
• Reported data on the number of visitors, page views, etc. to gauge the traffic and popularity trends doing the market research. collect data via page tagging requires changes to the website
• Managed the process of assigning a cookie to the user, which can uniquely identify visit and in subsequent visits.
• Collected web site data using a third-party data collection server
• Established practices to ensure data quality and perform quality review of Cognos Framework Manager and data modeling
• Effectively worked with the users to identify the source systems and data required in the data warehouse environment to meet the users current and potentially future needs. Performed gap analysis between the current state and future data warehouse environment identifying data gaps and quality issues plus recommended potential solutions.
• Worked closely with the data warehouse development team to ensure user requirements and issues are being addressed while controlling scope, ETL processing methods, underlying data warehouse data models, security, and front-end delivery products.
• Coordinated user acceptance testing and training. Ensured that the final data warehouse implementation will meet the user expectations.
• Supported the Business Intelligence & Analytics processes and techniques.
• Developed and implemented BI/DSS applications such as Oracle BI ( Siebel Analytics) Business Objects, Cognos, Micro Strategy.
• Data modeling of concepts, entity-relationship data modeling.
• Used a wide range of interpretive analysis tools (e.g., trend analysis, spreadsheets, comparisons, graphs, summary.
• Forecasted project deviations and advise PM on potential corrective actions; great follow-up with the entire team. Organized, planned, status changes, took control of the project schedule plan.
• Worked with Excel extensively for reports, pivot table, VBA, and created Power point slides for effective chart presentation.

Confidential, Mountain View, CA

Business Analyst/PM

Responsibilities:

• Reported to the Bay Area Sales Manager and closely worked with IT Manager
• Supported PM in monitoring and controlling project progress against baseline work plan. Forecasted project deviations and advised PM on potential corrective actions; organized planned, status changes, took control of the project schedule plan, followed - up with the entire team.
• Documented to include building process flows Designed various models to implement in Cognos, starting with the P&L.
• Implemented Cognos 8 BI Migration Roadmap addresses ; the topics under the Cognos BI Implementation Roadmap. Assessed current environment in order to successfully plan and migrate your Series 7 objects.
• Delivered a proposed Migration Strategy Plan for the Cognos 8 BI infrastructure, using the right approach: Lift & Shift, Compress & Optimize, and/or Interoperate
• Determined report priority sets from gathered information, such as usage statistics, inventory, complexity rating, business factors
• Implemented the report priority sets through the Design-Build-Deploy migration cycle
• Assisted Data Warehousing in analyzing existing reports and identifying iteration metrics;
• Lead technical teams in delivering multi-tier web enabled applications and Business Intelligence/DataWarehouse implementation
• Lead preparation of data warehouse requirements document
• Assisted data analyst in mapping task;
• Analyzed existing reports;
• Lead the identification and documentation of business metrics ;
• Determined systems of record with the assistance of appropriate source system experts;
• Helped identify potential sources of data for the data warehouse;
• Oversee testing of data acquisition processes and their implementation into production;
• Acted as consultant to the ETL and front-end programmers.
• Supported the sales department by taking full advantage of custom built functionality in Salesforce to manage Confidential s business processes.
• Evaluated, identified, and solved small to medium Business Intelligence system and process issues utilizing system and business analysis and design best practices and solutions.
• Contributed to the successful execution of the solutions delivery process.
• Focused on Business Intelligence projects in the Sales Domain. Provided analytical and statistical support within the Sales business area.
• Prepared excel-based and OBIEE reports for use in business planning and analysis for Sales.
• Supported the business through compiling, prepared and reported metrics and statistical data used in the analysis of operational performance of designated functional area.
• Generated reports in Cognos.
• Assist in definition and reporting of key business process metrics.
• Design and document business process changes required, as a result of system changes. implement process changes
• Partner with IT Product Managers to design and implement system changes.
• Perform user acceptance testing of new features before they are released, specifically, create test scripts, coordinate testing with business subject matter experts, execute testing, and sign off on testing success.
• Create training documentation and e-learning, and assist manager with execution of global training and change management.
• Worked on Oracle R12. Worked with large volume of data in excel; sorted, filtered, and analyzed the data to determine/delete the duplicates, reviewed the duplicates with the client, and determined, validated the data with Confidential back end data (Oracle ) to eliminate/consolidate them.
• Worked with large volume of data in excel; sorted, filtered, and analyzed the data to determine/delete the duplicates, reviewed the duplicates with the client, and determined, validated the data with Confidential back end data (Oracle Financials) to eliminate/consolidate them.
• Created comp plans for new hires and structure for management plans. Interacted with sales organization to address inquiries regarding bookings allocation and resulting commissions
• Prepared monthly commission statements.
• Communicated commission payouts to international accounting teams.
• Provided reporting and data analysis to the sales management team.
• Managed day-to-day workflow while managing a commissions analyst
• Ad-hoc commission reporting & analysis
• Run what-if scenarios for commission expense calculations.
• Driving process improvements and efficiencies while being able to meet monthly close schedules
• Successfully administered, analyzed and managed the process for Confidential Partner programs and reporting requirements.
• Developed and tested reports.
• Defined the reporting required for validating vendor billing, partner discounts
• Used multiple data sources with a high level of complexity, created deep analytical ad-hoc and what-if analysis for planning.
• Built and maintained data warehouse and business intelligence infrastructure.
• Used the full spectrum of BI tools from Business Objects, SalesForce CRM; utilized high volume reporting infrastructure with more data volume and better performance than your core application research, identify, and rectify any problems that may cause denials of payment and complete action steps necessary for resolution according to appropriate policy, re-bill or appeal as necessary to obtain full payment on services rendered
• Determined the policies behind the divergences/gaps to the desired course. Determined the Objectives Map; identified and documented system gaps; originated root causes which were inadequate/outdated approach
• Supported project teams to ensure completion of complex and multi-release of Confidential technologies, worked with Visio process flow diagrams and WBS drawings.
• Reported SME, closely worked with IT Team in collecting data from different Confidential database and organized so that it can easily be analyzed, extracted, synthesized, and presenting it in meetings for better understanding.
• Documented process flows, used cases and mock-ups that was illustrated useful information to engineering team.
• Developed an automated and structured plan of projects, pulled metrics/reports from Business Objects, Crystal reports and dashboards
• Developed project status reports and issues/risks log documentation. Updated the SharePoint site and pulled reports from Business Objects. Developed ad-hoc queries in SQL, access, translated questions into report design and development. Effective data modeling which represented Confidential 's process/system to distinguish variables visually in the system.
• Worked extensively with data analysis, aggregation and statistics
• Worked extensively with Excel; adobe files, report generation, data mining, trends, patterns, ranges; migrated data to SharePoint portal.
• Shared data with PM, Engineers, SAM's and others by creating and modifying charts for a visual representation.
• Formatted chart data series and text, line and bar charts
• Analyzed worksheet data using a pivot table, (this was used to extract data from Partner Test file and validate it against Confidential data file), used Report Filter to filter the entire report based on the selected items.
• Presented PivotTable data to create effective and easy to read charts in meetings

Confidential, Santa Clara, CA

IT Business Analyst

Responsibilities:

• Partnered and influenced the Data architect/Data warehouse modeler to ensure performance throughput and other systemic requirements.
• Provided leadership and recommendations to business clients on optimizing their information usage and leveraging the data warehouse.
• Represented the internal customer and ensure that their business needs are managed and prioritized accurately. Developed business requirements and translate them into functional and technical design specifications and implementation plans. Independently, lead efforts to provide targeted data solutions to a variety of business groups. Worked with other BI product managers
• Integrated SalesForce with existing web based and accounting software will be the first task. Developed, testing and deploying solutions, suggesting innovative and efficient ways to improve CRM applications and processes, and producing and maintaining documentation for all projects.
• Assisted in definition and reporting of key business process metrics.
• Designed and document business process changes required, as a result of system changes.
• Implemented process changes
• Partnered with IT Product Managers to design and implement system changes.
• Executive meeting projects, Liaised with IT and Engineering Department.
• Worked closely with Vice President of Finance, Sales - Reporting and Analysis to ensure sales, strategic and financial reporting and analytical needs are met
• Provided ad hoc reporting and value-added analysis and commentary to various business units.
• Communicated sales, assets, and forecasting results to affiliates and other business partners
• Measured and reported sales results to accounting for commission processing
• Developed various financial models in order to add efficiencies to the monthly accounting and analysis process.
• Provided skilled, knowledgeable expertise in Oracle Financials Suite best practices Identified business requirements and map them to the Oracle Application functionality Identified functionality gaps and develop solutions to them
• Configured Oracle Applications to meet internal requirements and document application set-ups.
• Successfully developed automated data anomalies.
• Analyzed to support process and reports.
• Closely worked with Project Manager.
• Worked heavily with MS Access and Excel database as back end tool to execute data, reports, run SQL queries.
• Loaded the HP data into Access database.
• Created a "What-If Analysis scenario with Goal Seek. Created a scenario summary and PivotTable Report.
• Used solver to predict results which might change over time based on different assumptions.
• Used Solver which took the current quotas fro each month and determined how sales quotas can be adjusted to achieve the goal
• Worked with users, getting the requirement, analyzing the needs and resolving the cases. Worked with Root Causes analysis to find the perceived root cause of the problem. Documented and completed the self-report instruments; prioritized techniques, process models, to verify the root cause and determined the attempts to resolve the issue
• Performed "data cleansing"; validated, corrected and formatted data for conversion from Legacy system to upgraded System.
• Tested existing processes/models and supported failure operations; improved reporting enhancements and better tactics/methodologies for Confidential .
• Collected data and organized so that it can easily be analyzed, extracted, synthesized, and presenting it in meetings for better understanding.
• Utilized Six Sigma method for Root Cause failure
• Led continual process improvement activities. Ensured all activities are conducted within established policies.
• Evaluated and made recommendations on specifications for new tools/ applications. Interfaced design and models of the business, heavy projects in MS projects and Visio. Pulling reports/metrics in Business Objects 11, wrote functional specs
• Developed and tested a model for making predictions on inventory levels needed. Created a plan for automating the system of making orders based on changes in inventory

Confidential, San Jose, CA

Business Analyst

Responsibilities:

• Reported to the Senior Project Manager of Engineering and IT.
• Developed positioning and action plan to increase market value in Database Marketing
• Queried relational data utilizing SQL Server 2000 database for Customer Retention Programs
• Migrated databases using Access and FTP sites from Trade shows and Marketing campaigns
• Integrated and validated databases with SQL Server Enterprise templates
• Implemented key strategic marketing plans for CRM
• Ensured all data validity testing and data capture testing with SQL, Oracle platforms
• Developed business requirements models, documentation and life/cycle delivery utilizing MS Project 2000.
• Responsible for data cleansing and integrity
• Produced client email marketing campaigns and retention programs for Marketing Reps using Power Play, Impromptu and Act
• Built database marketing queries and OLAP cubes using Power Play, and Impromptu
• Liaised with Developers and Programmers in order to implement data capture and integrity
• Managed Web Registration URL s for Customer Updates and Seminars
• Responsible for hardware/software vendor relationships

Confidential, Foster City, CA

Business Analyst

Responsibilities:

• Acted as central point of contact to Field for all Sales Compensation related questions or concerns, calculated Sales Commission for the Confidential 's in Excel.
• Adhered to stated revenue crediting guidelines as outlined in the Branded Sales Compensation Plan Heavy projects on adhoc and licensing of Confidential documents, contracts, interacting with customers, vendors, and contractors and data gathering. Managed analysis services security
• Deployed and secured an analysis services solution in a production environment monitoring and optimizing analysis service solution
• Accurately data mining functionality with SQL server planned and implemented data mining solution
• Wrote advanced SQL queries, tested and optimized to business standards. Worked with Ariba tool for purchasing
• Provided accurate and up - to-date information by running the queries in Confidential database
• Closely worked with IT developers, data modelers, and peers
• Performed duties in Finance/Accounting and Revenue Accounting
• Provided data lineage maps, data point of failure, and created process maps
• Performed gap analysis
• Participated and contributed to solution option and strategy
• Served as team thinker/leader for customer data model

Confidential, San Jose, CA

IT Analyst

Responsibilities:

• Supported the President and Director of Quality Controls. Assisted Finance, IT and Accounting
• Manipulated and presented large volumes of complex data Oracle SQL/relational databases - writing and optimizing advanced queries; complex joins, sub queries.
• Created database objects such as tables, views and indexes
• Extended process scheduling development for IT to Business (project code, accruals, reporting).
• Developed and implemented monthly reporting packages for different audience based on Kaiser Requirement.
• Worked with Sales Management, FP & amp;A and Human Resources to manage exceptions and resolve conflict related to plan specifications
• Processed revenue crediting and commission calculations for given Area or Region
• Provided revenue reporting analysis for monthly accrual and payroll reviews
• Created transact-SQL queries built and queried on analysis services cube; deployed analysis services database
• Executed reports from Business objects; created scorecards, provided the PM with weekly metrics for the team meeting. Heavy documenting of each project. Provided executive level reporting and case management
• Documented process flows, developed detailed functional specifications and use cases for complex web solutions.
• Assisted Confidential PM's with business operations and administration of the project. Gathered and documented business requirements, functional specifications and used cases
• Worked with project owners to aid them in identifying all customers/partners/ stakeholders and elements required by Confidential .
• Provided excellent customer service; gathered and understanding the needs of customer samples, customer Reference Design boards forecast, Applied good understanding and detailed attention with standard project planning tools and methodologies to deliver projects/critical business outcomes on schedule and within budget
• Coordinated and managed all intra/inter-departmental and intra-company support requirements and interfaces, HR projects as assigned Worked on assignments that are complex in nature, which required independent action and a high degree of initiative in resolving problems.
• Prepared statistical and analytical crystal reports
• Tracked and maintained department budget, and conducted year-over-year analysis. Generated annual budget reports.
• Closely worked with accounting department to analyze and forecast spending ensuring budget target is reached.

Confidential, San Jose, CA

Project Manager

Responsibilities:

• Supported the VP of Engineering, IT and Finance department
• Contacted various vendors to obtain new or updated information on equipment and other products, searched and tracked GE databases
• Interacted with customers and vendors worldwide. Independently responded to customers and vendors to solve problems and issues to customer satisfaction
• Prepared reports, correspondence and materials for presentation, coordinated travel arrangements, conference calls; transcribed complex and confusing minutes, and managed VP's calendar.