SUMMARY:

• Diverse comprehensive operational background, including engineering, manufacturing, logistics, strategic scheduling, marketing, and supply chain/sourcing.
• Involved in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases, Test Scripts for Manual and Automated Testing based on User Requirements Document and System Requirements Document for Functional, System, Integration, Regression, Graphical User Interface (GUI), User Acceptance Testing (UAT), Security, Database, and Usability Testing.
• Implemented in manual and automation testing of web - based and client-server applications.
• Implemented Automation Framework using Hybrid, Data Driven, and Customized Framework approaches.
• Implemented with software automation testing tools such as Selenium RC (Selenium Remote Control), Selenium IDE (Selenium Integrated Development Environment), Selenium Grid, and Selenium WebDriver.
• Coordinated activities in all phases of Agile Software Development, Software Development Life Cycle (SDLC), and Software Development Process.
• Implemented software test techniques such as Decision Tables, Use Cases, State Transition, and Data Flow Diagrams.
• Possessed extensive in-depth knowledge of programming languages like Java/J2EE, Python, JavaScript, and Relational Databases (Oracle Database/SQL).
• Implemented in using analytical and data techniques such as SAS (Statistical Analysis Software), SQL (Structured Query Language), and Advanced Excel.
• Experienced in SAS Programs including detailed knowledge of statistical with reports and tables.
• Experienced in using SAS Procedures, Macros, and SAS Applications for data loading, data extraction, data cleansing, and reporting.
• Experienced in developing and modifying SAS Programs and Macros for data extraction, data integration, data cleaning, validation, and query writing and reporting.
• Experienced in extracting, creating, merging, analyzing, and reporting large SAS datasets.
• Experienced in coding with SQL, Procedures/Functions, SAS Arrays, and SAS Macros.
• Experienced in writing SQL Programs for creating SQL views, creating indexes, joining multiple tables, sorting data, and metadata analysis.
• Experienced in writing procedures for data extraction, data validations, transformation and loading to target decision support system using MS Excel, PivotTables, and SAS on various environments.

EXPERTISE:

Proficient in Excel, Advanced Excel Functions, PivotTables, PivotCharts, VLookup, Oracle Database, SQL, data analysis, gather and set up data scripts/feeds, MediaWiki dashboard, MS Office suite, MS Word, MS Excel, MS Access, MS PowerPoint, MS Outlook, MS Project, Google Docs/Sheets/Presentations, Lotus Notes, typing 65 wpm, Smartsheet, SharePoint, SAP Business Objects Web Intelligence, web - based application, HTML, Java/J2EE programming, JIRA, Rally, Eclipse, Windows, Python, database research, computer networking, internet, conference meetings, coordinating cross-functional teams, process improvement, performance management, verbal communication, organizational ability, detail-oriented, project management, understanding campaign performance metrics, and self-starting.

EXPERIENCE:

Confidential, San Jose, CA

IT Analyst

Responsibilities:

• Developed user stories and demonstrated software process through Rally tool with Agile techniques and tools.
• Supported the conduit between software development team and business community toward variety fields in sales, marketing, and technology through requirements flow.
• Supported with cross functional groups to identify and prioritize business needs.
• Supported in application of analytical and data analysis process.
• Supported sprints process with Software Development team.
• Assisted to expedite the release management process to launch software products into the market.
• Assisted to conduct Application Programming Interface (API) Testing for review on the business logic layer of the software architecture.
• Assisted to develop Test Scenario for software testing process.
• Assisted to review into User Interface (UI) of software applications into various devices such as laptops and tablets toward software testing activities.
• Assisted analysis and tracking features in Smartsheet and processed requests about review and update features for application enhancements.
• Assisted for reviewing, analyzing, implementing about user process toward software applications services in Information Technology (IT) and Software Development process.

Confidential, Sunnyvale, CA

Order Processing Agent & Business Analyst

Responsibilities:

• Supported to process internal business request for hardware and equipment ordering in the Internet Services Organization Asset Lifecycle toward Asset Management and Order Management.
• Supported to review requirements and request vendor quotes.
• Supported to review quotes and attach to Purchase Requisitions (PRs).
• Supported to review status of orders back to requestors.
• Assisted to review the update of logistics information on Purchase Orders (POs) such as Estimate Time Arrivals (ETAs), shipper information, and tracking numbers.
• Analyzed large sets of data with order management tool and Advanced Excel, conducted dashboard, and generated reporting back to management within Internet Services Organization Asset Lifecycle of Data Center Operations.

Confidential, Piscataway, NJ

Responsibilities:

• Experienced in data extraction, data preparation, data validation, and data analysis toward data science and analytics projects.
• Experienced for writing Statistical Analysis Software (SAS) programs utilizing SAS Base and SAS Macros for creation of analysis datasets.
• Experienced in coding SAS programming to transform structure of raw data into a specific form the tool required.
• Experienced in generating and maintaining SQL (Structured Query Language) scripts, indexes, and complex queries for data extraction and analysis.
• Generated SAS programs to implement data listings, analysis datasets, annotated figures, and summary tables.
• Generated SAS data sets by extracting data from database systems using SAS Data Step, cleaned, manipulated, and validated data by SAS and SQL.
• Identified, analyzed, and interpreted trends or patterns in complex data sets utilizing data mining tools.
• Provided analysis reports and graphs by using SAS and MS Excel.
• Provided reports by implementing with a single table, joining tables, or utilizing set operators in the SQL procedure.
• Performed statistical analysis and data management on study data by using statistical techniques with SAS programming and SAS tools.
• Performed the use of advanced data look-up such as array processing, formats, and combining/merging data.
• Performed in gathering requirements, creating specifications, developing codes, validating and maintaining programs.

Environment: SAS, SQL, and MS Excel.

Confidential, Fremont, CA

Customer Solutions Specialist

Responsibilities:

• Supported for interfacing with customers’ prior to and after sales for assisting in researching status of customer orders, assisting in resolution of Production and Shipping, providing pricing information and product enhancements, and communicating of schedule status.
• Prepared necessary documentation analysis through Excel and reports for internal and external customers.
• Assisted for coordination with various functions within the organization through product information management system to communicate shipping status and to support Sales and Divisional Manufacturing process.
• Interfaced with manufacturing and engineering and import/export administrator to assist for coordination with various functions in Sales and Customer Solutions Support.
• Assisted to review for quote of contracts and shipping status of Purchase Orders (POs), Work Orders, and Commercial Documents.

Confidential, Fremont, CA

Software Quality Assurance (QA) Automation Testing

Responsibilities:

• Developed and implemented Manual and Automation Testing with Selenium RC (Selenium Remote Control) automated Tests Scripts and file for a particular software module.
• Developed, wrote, and implemented Software Quality Plans, Software Configuration Management Plans, Software Test Plans, Test Design Specifications, and Software Test Cases through Software Development Life Cycle (SDLC).
• Involved in developing Software Test Strategy and Software Test Plans which ensure Software Test Cases meet the user’s functional, user interface, usability, and security requirements.
• Implemented the SoapUI Test Cases, tracked features resolutions from JIRA, and assigned them to the Scrum Master.
• Implemented for identifying Test Cases for manual and automation with Selenium. WebDriver for Functional and Regression Tests.
• Developed and participated in building test automation using Selenium RC and implemented Software Test Cases and Software Test Suites using JUnit Framework.
• Involved in execution of all types of system testing including: Integration, Regression, User Acceptance, and Functional Testing.
• Interacted with developers, users, and various members of the team to discuss for features resolutions and set priorities.
• Used SQL for data integrity testing, captured the SQL statements from the application execution and manually checked the results.
• Implemented on Extensible Markup Language (XML) files to validate with XML Schema.
• Analyzed and obtained a thorough grasp of the business process and documented the System specifications, Business Requirements, and the Testing Process.
• Maintained Automation Selenium WebDriver scripts and Selenium IDE (Selenium Integrated Development Environment) functions for Regression and Functional testing using Hybrid Framework.
• Implemented Selenium based scripts using Java & JUnit Framework.
• Supported for organizing and maintaining written java class libraries for automation with Selenium RC and keyword driving software testing functions library for Selenium IDE.

Environment: Software Testing Management, Software Automation Testing, MS Office tools, MS Project, Windows 7, JIRA, Selenium WebDriver, Selenium RC, Oracle Database, SQL Server, SQL, Agile environment, UNIX, Performance (LoadRunner/JMeter), WebServices/API (Application Programming Interface), SoapUI, and Eclipse IDE (Eclipse Integrated Development Environment).

Confidential, Sunnyvale, CA

Contract Migration Specialist & Project Coordinator

Responsibilities:

• Fulfilled routine contract migration tasks, including identification, pricing, and product mappings of Sales Orders in tracking tools through Advanced Excel and SharePoint system for Software Security - Data Security Products and Services.
• Responded to internal inquiries, regarding descriptions, numbers, invoices, pricing, and renewals of Software Security products for SecureData and SecureMail.
• Supported to track with contract and renewal migration of Sales Orders and to conduct necessary research and analysis of contract and renewal documentation of Sales Orders toward the financial data analysis and sales analysis between Finance and Sales Operations.
• Coordinated with department leadership, preparing communications and correspondence regarding product descriptions, pricing, mapping, contracts, and renewals.
• Assisted for identifying, classifying, organizing, and preparing records documents to be categorized for records management.
• Demonstrated an understanding of advanced knowledge of the practice of software engineering, following standards such as Software Life Cycle Processes, Work Product Standards, Process Standards, Requirement Analysis and Management, and System Integration, from scope to analysis, design, validation, and deployment.
• Improved operations by conducting systems analysis, measuring software specification and designs, measuring software code and implementation, performing data flow analysis, coordinated techniques such as Agile, including Scrum and Extreme Programming (XP), tools, and practices.
• Developed and directed software system testing and validation process, programming, and debugging procedure.
• Coordinated and demonstrated project activities through Google Calendar/Hangouts/Mail/Drive and Google Docs/Sheets/Presentations.
• Experienced with Relational Databases (Oracle Database/SQL).
• Experienced with the Python, Java/J2EE, and JavaScript.

Confidential, San Jose, CA

Product Marketing Business Analyst

Responsibilities:

• Analyzed large amounts of data from different processes/functions and business metrics as well as full life cycle of Information Technology (IT) Projects from conception process to delivery process.
• Supported for the Data Center Group toward Operating Systems Product Management to keep tracking and updating features and status for Software Release process.
• Supported for tracking and updating the program data for trade events and staffing activities in the MediaWiki’s website portal of the marketing research analysis.
• Analyzed large sets of data in Advanced Excel with SAP Business Objects Web Intelligence system, Smartsheet, MediaWiki dashboard and reporting back to the lead of Software Product Management.

Confidential, Cupertino, CA

Project Coordinator

Responsibilities:

• Assisted to schedule activities in Information Systems & Technology (IS&T) Retail Systems Operations to support in New Store Openings and Relocation Stores.
• Assisted for ordering and tracking shipment of equipment, hardware, computer networking, servers, IS&T Systems with order management tool to support for IS&T Retail Systems Operations.
• Assisted for reporting and project tracking to management, both with organization and with vendors.

Confidential, Milpitas, CA

Operations Data Analyst

Responsibilities:

• Supported for analysis of data between multiple databases, including Wireless Carriers, Oracle Enterprise Resource Planning (ERP) Billing in Finance, Geo-Manager into master files from various tools.
• Assisted to extract and compare data from multiple sources for data integrity analysis through Advanced Excel, Advanced Excel Functions, VLookup, and Oracle ERP system in Operations.
• Assisted to document admin tool functions in Geo-Manager and admin processes for and consistent performance of tasks.