COMPUTER SKILLS:

Hardware: IBM PCs and Compatibles; Sun Enterprise Servers, TIBCO middleware

Operating Systems: UNIX, Windows 95/98/NT/XP, /Vista/7/8;

Languages: SAS; C/C++; Oracle SQL*PLUS, PL/SQL; UNIX korn shell; Basic; Java; ASP.Net, HTML

Databases: SQL Developer/2000, SQL Forms 4.5, SQL Report; Microsoft SQL Server 2008 & 2010.4

Applications: Microsoft Office 365, OneDrive, Word, Excel, Note, PowerPoint, Project, Visio, Paint, OutlookVisual Studio, Team Foundation Server; AS AF/FSP; XML Spy Editor, Toad; VI Editor; TSO/ISPF

ERP: SAP R/3; Oracle; PeopleSoft.

CASE: Erwin; Texas Instrument / IEF; Excelerator

BI: Cognos PowerPlay, Transformer, Explorer, Reporter; SAS / EIS;

MicroStrategy: DSS Architect, DSS Agent, DSS Executive; Power BI; SAP Business Objects 4.0

Job Scheduler: AppWorx 6.1.4.1, Oracle Concurrent Manager; UNIX Kron

Test tools: SoapUI 2.0.2; IBM Rational tools ClearCase\ClearQuest; Mercury Quality Center 9.0 Test Director;

Business Analyst tools: Rally, TFS (Team Foundation Server), SharePoint 2013

EXPERIENCE:

Confidential, Bellevue, WA

Business System / Sprint Analyst

Responsibilities:

• Worked with the client’s Product Owners to define the requirements of the features for the scrum team.
• Attended business process walk - thru and JAD sessions of the business requirements.
• Collaborated in creating Change Plan and Services eCommerce wireframes based on business process.
• Created the Epics, user stories and acceptance criteria in Rally tool using agile methodology for the Rebellion Web project.
• Functional grooming of developers and testers for any clarification of the CPS user stories.
• Reviewed developers’ HTML and Composition, the test cases defined by the testers and completed UAT.
• Worked in the capacity of a Project Manager to insure the servers required for all platforms are procured, configured and implemented for the Cloud computing NextGen project.
• Collaborated in the creation of Context and System Diagrams for the Call Logging Tool and Explore.MS project with the Engineering Point of Contact.
• Gathered customer requirements for customized business solution. Web application is for Volume Licensing.
• Initiated the data mapping for the database migration of MSOps application into retirement and data analytics of SQL Server transactional databases.
• Analyzed business requirements’ security of the role based MSOps application and expression based Explore.MS application for the Call Logging Tool’s Functional Specification document.
• Created functional specifications document from business requirements.
• Have an excellent understanding of software architectures, MS products, software lifecycle methodology and information systems development & Data communication products and project lifecycle methodology. Proficient with the latest MS development tools and technologies like Office 365 One Drive storage.
• Broad knowledge base of technologies outside of area of focus (e.g. Power BI, SQL Server 2010, Visual Studio 2010, SharePoint 2010).

Confidential, Bothell, WA

Sr. Systems Analyst

Responsibilities:

• Created EIT Billing Systems functional specification documents for postpaid and prepaid developers.
• Worked on 4 Postpaid and Prepaid projects simultaneously to implement the changes to the billing systems (SAMSON - Postpaid and RPX - Prepaid) based on the business requirements. Acted as a SME on various projects from the Postpaid and Prepaid billing systems stand point.
• Well versed with the AMDOCS billing modules i.e., CSM, Billing, Price Plan, BPCM, Wi-Fi calling.
• Defined and worked on BAN activities like activation, future activations, suspension, cancellation and resume with Oracle as backend database.
• Participated JAD (Joint Application Design) sessions with the Billing Systems Architect and Solutions Architect to get a good understanding of the problem and the solution on how to implement the requirements. Initiated JAD sessions with other project System Analysts and Business Analysts to exactly capture the impacts from the other applications on the Billing System.
• Created BPTCR’s to send a request to update the tables with new values and also to send a request to create new columns based on the requirement.
• Captured mock-up diagrams for VASA prepaid eCommerce application (TMO) to clearly mention what the changes were as per the requirements.
• Worked on XML’s and WSDL’s to capture the mandatory attributes/parameters which need to be passed through TIBCO middleware to other systems from the billing system.
• Involved in search and request for API (Application Program Interface) needed for Wi-Fi Calling project’s GUI (Graphical User Interface) components.
• Involved in the Assessment Sessions along with the project manager and other project members to finalize the impacts on various applications from the Billing Systems stand point.
• Worked on sending Capital Assessment request on various projects to the AMDOCS development teams using Artifact Tracker process through SharePoint.
• Created process flows, use cases/use case diagrams using UML (Unified Modeling Language) with MS Visio for Prepaid eCommerce application.
• Incorporated Rational Unified Process (RUP) with Agile methodology to create Functional Specifications Document using MS Word, Visio and Paint.
• Performed data validations using SQL-scripts with SQL Developer to reverse engineer existing stored procedures used for business intelligence tool.

Confidential, Bothell, WA

Business Functional Analyst

Responsibilities:

• Subject matter expert in the mapping of Call Detail Record processing for each switch type or element to Confidential internal billing format.
• Knowledge in wireless network, call detail record and cellular billing.
• Primary production support function is to translate customer usage records from the Mediation Platform to the internal billing format and data. Excellent Excel skills including graph, pivot table, V lookup, H lookup to analyze large data sets.
• Worked with other IT-Billing teams, cross-functional IT teams and 3rd Party Billing Vendor to fully analyze, develop and document business requirements in order to trouble shoot billing errors. Work productively in an environment where job requirements, technical knowledge, approaches and priorities change rapidly.
• Created functional requirements for Mediation Tech Support and Development using Key Performance Indicator to measure and correct call event usage errors that have been caused by incorrect billing and fraud.
• Extracted GPRS, SMS, MMS, Call Detail Record data from Oracle 10.g database with TOAD. Application knowledge with PeopleSoft, Telegence, CARE, CDRlive, Borg, SNAP, SnooperWeb, WebScan, LAC-Cell Lookup, Clarify and Webtrax.

Confidential, Bellevue, WA

Business System Analyst

Responsibilities:

• Gathered information using Agile methodology to analyze and evaluate existing Confidential eCommerce application and system.
• Provided GUI wire frames for the developers’ mockup screens.
• Prepared detailed Data Flow Diagrams outlining systems capabilities and processes for each RSP (Retail Service Platform) services’ test plans.
• Translated business and user requirements into accurate system requirements specification documents like the FRD and SDD through systems and data analysis for each RSP services’ test case summaries.
• Group Test Lead for the Highlander Project’s 5-minute activation of customers in retail stores. Created test strategy document, test cases and test scripts in SoapUI 2.0.2 web service test tool. Extracted test data from Oracle 9.2 of Confidential -Mobile’s Amdocs 3 Oracle database with TOAD. Posted defects in Mercury Quality Center 9.0 Test Director. Created test dashboard for all web services.
• Presented a MS PowerPoint presentation to the Confidential development manager and web development team the User Acceptance Testing of the POS (Point of Sale) retail web services.
• Communicated effectively to keep business, IT and project personnel up-to-date with test audit of each test cycles in system and regression testing. Estimated task and workload to achieve deliverables and goals, delivering on-time and on-estimation for development system integration testing for the RSP project.
• Worked on XML’s and WSDL’s to capture the mandatory attributes/parameters which need to be passed through TIBCO middleware for other systems. Used an open source bus as the interface for the GUI, databases, business intelligence tool, enterprise resource planning tool and external vendors.
• Assisted in definition, design and management of SOA components and low-level technical architecture design documents. Interacted regularly with architects, developers and testers.

Confidential, Bothell, WA

Systems Analyst

Responsibilities:

• Primary contact for ERP application and presided as a Project Manager between the business side and IT department using Short Interval Scheduling for the roll-out tasks of remaining application issues after the application was implemented completely in production.
• IT Finance Tier 2 production support of the ASPEN financial applications (cash, revenue, tax) and ERP application PeopleSoft which use Oracle 10g as the backend database.
• Gathered job schedule requirements, designed and implemented job schedules using AppWorx version 6.1.4.1 for financial applications like ASPEN fast export and load ready file jobs, Audit, BID Extract, CARE / Telegence billing, PFT (profitability), PRM (Partner Relationship Management) and Revenue Share jobs.
• Trained the finance application production support team with AppWorx job scheduler and created supporting documents as their reference. As the AppWorx guru, taught development, operations, administration and troubleshooting to the IT Finance production support team for the iPhone first generation project.
• Created production support training manual for the team and posted knowledge base in MS SharePoint.
• Created Apptricity ePayables application manual with Oracle Concurrent Manager included. Trained an employee on supporting the accounts payable application and troubleshooting the application with web logic.
• Created Disaster and Recovery document for the ERP application.

Confidential, Bellevue, WA

Sr. Systems Analyst

Responsibilities:

• Member of Accounts Payable Department’s Leadership Team and liaison for the business side and IT department (EIT). As point of contact for system functional requirements gathering, worked closely with IT department to facilitate resolving system problems in finance and payroll.
• On my initiative negotiated running month end jobs after normal business hours to keep SAP available for 5,000 end users.
• Served as SAP R/3 superuser and subject matter expert on day-to-day processes. As the department's Security Point of Contact Tier 1 Production Support, provided diagnosis & resolution for 50+ end users, solved customer issues while further researching, troubleshooting & simulating to determine root cause & solutions.
• Able to track issues and clearly communicate status and resolution with users and Leadership Team.
• Provided analysis and reports on an adhoc basis for the Financial Operations department and auditors from Sarbanes-Oxley and PriceWaterhouseCoopers for SOX security compliance.
• Involved as the UAT tester for the DCM project’s web-based customer order system called Confidential -Star that use Oracle 9i database for all of Confidential -Mobile’s products and services. Critiqued the website during development. This application use TIBCO middleware.
• Helped determine the User Acceptance Testing, once problem was determined then convey resolution to engineers, then test and finally to production. Wrote the code/script for the testing. Tested new SAP functionalities in the test environment for patches, upgrades and provided results in the test script document.
• Archived SAP data to store in Oracle database for 2 years audit trail.
• Created user’s guide document for new SAP users. Responsibilities also included actively supporting fellow Leadership Team members and providing training and assistance as needed in the department.
• Worked with DocuLink a paperless invoice application to resolve system errors against SAP.
• Administrator of Confidential -Mobile’s signing Authority levels for all Confidential -Mobile’s employee expense.

Confidential, Bellevue, WA

Social Media Manager

Responsibilities:

• Work closely with the marketing team to develop social media campaigns that help to achieve corporate marketing goals
• Develop monthly reports on emerging social media trends that will be submitted to the management and executive teams
• Monitor the company’s social media accounts and offer constructive interaction with users
• Create methods for finding and saving online customer reviews
• Analyze the long-term needs of the company’s social media strategy and offer quarterly reports to the management and executive teams that outline any necessary changes to the digital marketing plan.