SUMMARY:

• Over 15 years of technical/business analysis with broad experience across operational areas. Data mapping, validation and testing via ETL tools, UNIX,SQL, Mercury Test Director, Confidential Quick Test Pro Quality Center.
• SME level knowledge of Telecom billing systems, call rating, bill cycles, data processing, USOC/ASOC and billing system conversions are a few of the skills I specialize in.
• Ability to keep a cool head under pressure and to deal professionally and successfully with conflict situations around resource contention and tight deadlines
• Very strong interpersonal, communication, negotiation and presentation skills .Prior work experience with, or a deep working knowledge of a SDLC environment.
• Prior experience in working within an internal controls, application security or software implementation environment and strong customer facing skills.
• An immense ability to understand business needs and their technical solutions .
• Self - motivated and an initiator with strong problem- solving and time management skills, driven by challenge and opportunities for development, thrives in diverse and fast-paced settings.
• Have a strong ability to interact with stakeholders and all levels of Management to discuss and resolve matters, and a solid understanding of information technology.

TECHNICAL SKILLS:

• Windows
• Business Objects
• CRIS
• AS400
• PUC
• Remedy
• PowerPoint
• Word
• Oracle
• Portal
• SAP
• DPI
• Mercury Suite
• TBS
• Metasolve
• Smarts
• Lotus Notes
• Access
• Excel
• Atlas
• Seibel/SIMS
• EMI/EMR
• BOSS
• MS Project
• Visio
• Singleview
• Webtrax
• Telegence
• AAIS
• AWAS
• Wisdom Legacy-Wholesale
• Keenan/Arbor
• RUP
• Vantive
• Data models
• Sarbanes Oxley/SAS -70 Audit Change Management
• Ensemble Suite /Enabler Billing
• Amdocs CES 7.5, Agile Methodology
• Defect Management
• QA
• UAT
• Test Director
• Telecom Industry SME
• Service Oriented Architecture
• ERP
• Revenue Assurance
• Waterfall and SCRUM methodologies
• DOORS, EDGE
• GSM
• 3G/4G
• CDMA technologies
• Oracle PL/SQL
• SQL
• TOAD
• BTS
• BSC
• TRX parameter and software
• Wimax
• Remedy
• Citrix
• CABS/CAMS
• EMI/EMR
• AMA
• Testing (System, User, Performance, Regression, Blackbox)
• Business Analysis and Design
• Project management
• Reporting
• System integration and Implementation.

EXPERIENCE:

Confidential

SAP Migration Specialist

Responsibilities:

• Data analysis, data mapping, data validation, testing, migration tool requirements development, project management of migration activities for vendor set up. Utilize knowledge of SAP modules and Procurement / Supply Chain applications.
• ODBC/ MS Access: Connect to PIR tables (CAS Legacy System) via ODBC Database and use the SQL feature in Access to write the query to extract vendor data. Export it to MS Excel to identifying the proper data to arrange for the set up of vendor data but also to keep track of it for team as part of the project management purposes on an excel spreadsheet in SharePoint.
• SAP: EDS Legacy SAP purchasing systems are in 3 areas: PL1 (Americas), PP1 (APJ), P10 (EMEA).
• SAP BW Tool: Modify & execute a query for a report that is used for the purposes of extracting RAD SAP data in relation to the migration to provide to the teams that require it for migration.
• SharePoint: project data is storage and to access and input files as part of the project management.
• SharePoint query: downloading the file which contains all of the latest deployment information and adding it to a template then forward to another team that will query data against that file.
• Metrics Report /Adhoc Queries.
• Vendor Project Management: Goal is to ensure all vendors are set up for the migration of the account for both Commercial and USPS Vendor data. Must identify the suppliers, determine if they are set up to the correct master data, validate they are certified (for govt data). Maintain record of all the vendors via the USPS working vendor file.

Confidential

Consultant - MIS Analyst Business Intelligence

Responsibilities:

• Worked closely with LOB to review provided requirements and develop proper data reporting and application development.
• Review and enhance existing reports/processes related to issues involving query performance, enhancements in LOB requirements. Support various data and report development requests
• Additional duties as assigned by management

Skills and tools used: MS SharePoint 2010 (Architecture upgrade and work flow enhancement project), MS Excel, SQL Query, Oracle PL/SQL, TOAD

Confidential

Consultant - Technical Data Analyst

Responsibilities:

• Analyst / Project Management role, also data lead to drive project and execute reports.
• Demonstrated experience with documenting UAT test plans, cases, results and execution of the Testing for high quality deliverables
• Prepared test cases and Oracle data query script s based of business requirements documents, use cases, process flows and thorough system analysis with minimal supervision.
• Hands-on business analysis related to Accounting/Financial systems.
• Documenting and flow-charting procedures including working knowledge of Visio software MS Office applications including Excel, PowerPoint, and MS SQL.
• Demonstrated project management expertise in a fast paced environment on large projects involving cross department communication, planning and estimation.
• Utilized strong oral and written communication skills to lead conference calls, prepare documentation, requirements, and other project related communication.
• Analyze and interpret data query results to assist business users
• Knowledge of secondary mortgage market & experience of working with Servicing / Loss mitigation systems and data
• Confidential Quality Center
• QTP - Quick Test Pro script modification & execution
• Oracle / TOAD
• SharePoint 2007 - request forms, data views and task workflows

Confidential

Consultant - Project Reporting / Business Intelligence

Responsibilities:

• Responsible for project status reporting, resource allocation, task management, time reporting, defect trending and tracking in Clarity and Confidential Quality Center.
• Leveraged previous knowledge of AS400 DPI application table structures, to support both DPI and CRM tables (CRM is the UI layer over DPI used by the call centers).
• Managed efforts of Telecom / ETL Coding Analysts working in the mapping team and conversion team.
• Data Conversion for DPI billing system, CBSS Telecommunication billing system & other Telecom billing systems ( AMDOCS, Kenan / Arbor).
• Write & running of SQL queries on AS400 DB2 database and via PL/SQL editor.
• Created Excel spreadsheets to serve as coding specifications.
• Experience with data migration/data conversion in telecom industry & understanding of telecom concepts in terms of data elements needed to create a subscriber and attach services and promotions.
• Successfully converted data from one system (Verizon) to frontier’s billing system (DPI), in multiple phases and environments.
• Utilized SQL to create Confidential Quality Center testing and defect tracking summary reports.
• Developed business process and metric dashboards for tracking defects and reporting completed team assignment tasks
• Created Visio data transformation process work flow.

Confidential

Business Analyst II

Responsibilities:

• Gathered documents, and most importantly, analysis of reporting requirements, conduct analysis, participate in design of Executive KPI metric reporting; Executive .ppt slide decks, creates and analyzes ad-hoc reports.
• Development of complex reports in Business Objects Deski & Webi, development knowledge with Business Objects.
• Business Intelligence, database knowledge on SQL Server and Oracle, extensive knowledge of SQL, TOAD.
• Execute UNIX commands and .shell scripts to copy and load files as well as execute and monitor batch processing jobs
• Run SAS scripts to convert .csv files to .DAT for data processing.
• Development and modification of Visual Basic code, MS Access databases.
• Development and maintenance of Xcelsius, Crystal, SAP reports and Reporting Suite tools.
• Relational database knowledge, use of ETL standards including best practices for Integration, and development and accountability for interface estimates including new design and change request.
• Utilize DOORS for requirement development and technical documentation, SharePoint Admin/Development.
• Assess procedures and business processes in a financial management, accounting, transactional, or business operations unit for methods of automating or improving existing applications supporting them.
• Participate in meetings with financial management, Accounting, or product management staff and application developers and project managers to plan development or upgrades of applications used by their offices or business units.
• Planning testing & acceptance of newly developed financial management software by client group who will be using it.
• Provide support to applications in production by tracking and troubleshooting problems and ensuring continued and efficient operation of application in production, and full access by its users.
• Develop queries, analyses, or reports from financial management applications for operations or management staff of assigned business unit
• UAT and test case documentation for BO Class and Object development.
• Run and review Confidential QTP test scripts in Quality Center
• SharePoint 2007 administration and SharePoint Designer development work

Confidential

Enterprise Architect Business Analyst

Responsibilities:

• Provided Business analysis and Requirements management related to Enterprise applications and Service Oriented Architectures (SOA) with specific experience related to Telecom OSS (Operation Support Systems).
• Participate with business architects and analysts in identifying and defining business requirements
• Elicit requirements using interviews, document analysis and facilitating requirements workshops
• Review & edit requirements, specifications, business processes and recommendations related to proposed solution. Developed business process descriptions using BPMN, Use cases, Scenarios, and task/workflow analysis.
• Developed functional specifications and system design specifications for client engagements.
• Evaluated information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, and distinguished user requests. Creation of all report analysis using Telelogic System Architect & DOORS
• Assist with the development of the organization’s requirements engineering policies, procedures, tools.
• Delivery of all presentations and documentation for project team
• Provided creative thinking beyond the boundaries of existing industry practices and client mindsets. Facilitate effective team interaction. Knowledge of interface methodologies (point to point, API’s). Demonstrated skill in JAVA, SQL, and HTML. Understanding of SFTP, PGP, and secure data transfer methods IT Environment: UNIX, Oracle, PL/SQL, SQL

Confidential

System/ Technical Analyst

Responsibilities:

• Was a part of the Solution Design team for the SIF project. This is the Billing implementation for Amdocs Ensemble Billing system for the Wire line and Wireless integration onto one platform for BSS and OSS. Systems used - WISDOM (wholesale, PSR and retail)OSADIA (homegrown ordering system)ADA,F2F,M6(TBS), AAIS, AWAS, ATAS, CIDS, STAR(Siebel)Ensemble Billing Suite, CPS, IPTV/DTH, and FACTS and ecommerce websites for online CRM.
• Developed solutions with business client, based on Agile methodology, project and executive communications, project management, training, risk and issue management. Load balance multiple projects. Lead detailed requirements development sessions with executives, process owners and/or users, conduct interviews, work with program leadership, technical architects and developers who will translate requirements to applications. Document processes, use cases and requirements. Experience with quality assurance review and testing( Unit testing for software development, interface development and integration areas.)
• Knowledge of interface methodologies (point to point, API’s). Demonstrated skill in JAVA, C, PERL, SQL, and HTML. Understanding of SFTP, PGP, and secure data transfer methods IT Environment: UNIX, Oracle, PL/SQL, SQL, and PERL.

Confidential

Business Data Analyst

Responsibilities:

• Business Analyst liaison between Sr. Vice Presidents, Learning Management Team, Area Directors, Managers and SABA Development Team. Extensive knowledge and experience on how the SABA LMS is used as the interface for running, scheduling, and delivering reports.
• Business Analyst liaison between Sr. Vice Presidents, Learning Management Team, Area Directors, Managers and SABA Development Team. Extensive knowledge and experience on how the SABA LMS is used as the interface for running, scheduling, and delivering reports.
• Conducted requirements sessions to discuss and gather dB & reporting requirements for Crystal and SABA
• QA of SABA data tables, QA/ Testing of Crystal data tables and QA Testing for data integrity and data reporting
• Writing queries against our clients Oracle database using SQL tools (TOAD, SQL Plus, etc). IT Environment: SABA, Oracle, PL/SQL, SQL, Business Objects, Crystal 2008

Confidential

Business Consultant

Responsibilities:

• Delivery of Service Support projects in the Service Delivery organization for Confidential Americas Outsourcing (AOS) supporting multiple clients
• Review and analyze the various components of Business Processes & work flow to develop GAP Analysis. Review analysis to identify the appropriate Business Process Improvements. Analysis consisted of comparisons of the “costs” to implement Business Process Improvements. Analysis of workflow management and efficiency including prioritization and backlog management processes. Responsible for taking analysis data developing sales presentations and unit costs for executive / client KPI/ROI reporting, project metrics. Present comparative cost analysis of business unit performance/costs metrics and drivers against comparable industry standards and best practices. Prepared budgets, monthly forecasts and month end Business Unit reporting and ROI. Project Management of both internal initiatives designed to improve Confidential ’s Outsourcing performance as well as client-sponsored, client facing initiatives to identify and remediate existing service challenges. Training schedules, milestone definition, project scheduling, communication planning.
• Technical Documentation of new process development, CAB calls (Change Approval - Change Control Board). Work across SMG (Service Management Group) to track & complete RCA’s & service improvements. Worked across Global & Regional Confidential Network Management & OSS Groups to develop and write technical documentation on Global CAB process, improve OSS performance from once an RCA or new order was submitted to fulfillment and client acceptance. Created project schedule (based on SDLC), Rational Rose utilized for OOA and swim lane creation with Visio process flow. Work with Problem / Incident / Change Management Team Managers to resolve Network outages and Service Level issues cause by Change Events or Major Incidents. Communicate/influence different parties such as MIRT (Major Incident Response Team) and client/partners to commit and fulfill contractual Service Level Agreements (SLA ’s).
• Technical writing of reporting, data, dB configuration for Digital Fuel ETL Tool, Network / Server performance and configuration requirements. Responsible for solving customer request cases and progress reporting queries via PL/SQL
• Creation of context diagrams, Use Cases and utilized data models for OOA using Rational Rose and Visio.
• Technical Documentation of “As-is” and “To-be” Service Management Processes for existing AOS Accounts. Documentation of RCA’s (Request for Corrective Actions)
• Applied commonly recognized PMBOK and ITIL concepts within their field of expertise. Provide GAP analysis during transition and transformation phases of AOS Accounts. IT Environment: Oracle, PL/SQL, SQL, Excel Report Writer, Digital Fuel (ETL Tool)

Confidential

Project Management Office

Responsibilities:

• Delivery of client carrier network projects in the agreed time schedule, within agreed costs and fulfils specified quality requirements and customer satisfaction.
• Performed day-to-day analysis to meet NET CMO NAM PM Process & Tools Mgmt US departmental/ client project objectives. Worked with project teams / partners to gain “Buy in” to Web Tools to fulfill the project requirements.
• Planned and executed technical tasks requiring Nokia IPM (Integrated Project Management) Web Tools & Business Objects Reporting solution. Led remote and on-site requirement sessions to develop Business Objects reporting solutions. Wrote, maintained, supported reports using TOAD & PL/SQL on an Oracle dB. Designed Bus Objects Universes and setup user accounts and published reports via WEBI. Conducted client/end-user training sessions on Nokia Web Tools for project tracking and KPI reporting. Administrator of IPM, CITRIX, and Documentum Web document management tool for Technical Documentation storage. Planed and performed technical activities to service the customer and bring expertise to customer site on as needed basis. Correctly set operational SLA with customer. Gain understanding of client’s business, production and testing requirements, critical dates, and impacts to provide accurate solution. Created Use Cases, requirements gathering and technical documentation for User experience and Agile development of EPM applications and Nokia IPM Web Tools for progress & time tracking. Worked with OSS to integrate New/Change order of Carrier Network components from request phase to delivery, testing & production. Responsible for Nokia IPM (Integrated Project Management) Web Tools & Business Objects Quality Assurance, Testing and data integrity for regional and global clients/project teams.
• Identified and solved technical problems. Support areas by participating in emergency and on 24/7 duty for international collaboration. Utilized Remedy tool to track & monitor QA issues, problem and change requests according to established Change Management process. Development of IPM process adherence of PM templates and standard approval documents. Lead Testing of End User Web Application and portal updates/enhancements
• Utilized Agile, PMBOK and ITIL v3 methodologies, processes and procedures.

PM/Business Analyst:

Responsibilities:

• Business Analyst liaison between Project Management and Networking and Transmission Planning Department.
• Conduct JAR sessions with NTP to discuss reporting requirements for network site data for NTP audits
• Write & test "Ad-hoc" PL/SQL, SQL queries in Access-Visual Basic and Oracle dB & run daily reports to load excel spreadsheets with. Daily meeting to discuss scheduling plan and update "Exceptions" and resolutions from the Excel spreadsheet data.
• Lead NTP(Network Planning) efforts to complete needed RF & BSC updates for ATT 15K site EDGE network
• Complete understanding of BSC /BTS/ TRX parameters and software requirements for Enhanced Data Rates GSM implementation. Worked on GPS/RF CATS functionality for the EDGE network. IT Environment: SAP, Oracle, PL/SQL, SQL, Business Objects 6.5 Designer / Supervisor, MS Access, GSM, BSC, BTS, TRX parameter and software, 3G System, WCDMA, WiMax, Remedy, CITRIX

Confidential

Implementation Manager

Responsibilities:

• Provide LD Tier2 Usage production job and process support for Error Management, Message Processing, Managed support effort/tasks for ATT Implementation and Amdocs Support Teams.
• Research files and re-reprocesses DAT files in UNIX to ensure files process successfully Run PL/SQL and Korn .ksh (shell) scripts to provide production support for Bill Cycle production. Used CCMI and ran Business Objects queries to balance Audit and Control reports from external departments. Wrote PL/SQL queries to research LD usage issues and pull ad-hoc data from UNIX tables. Verified Toll rates based on CCMI standards. Implemented training course for new recruits-speeding profitability.
• Monitor Long Distance production job files and scripts in UNIX / Oracle 8i environment. Executed queries in CITRIX / Business Objects / Vista to extract data and produce a prep cycle for Quality Assurance Testing Auditing.
• Lead support & resolution efforts for Tier 2 support Teams. Completed and followed up on all assignments, project plan tasks and clarification of requirements. Gathered and documented requirements, Business Process definitions with functional business and Amdocs Support Teams. Responsible for delivery of enhancements & updated software releases from the Amdocs support Team on the Amdocs Telegence Billing software. Worked with OSS to resolve Quality Assurance issues, software updates and enhancements for Amdocs quote to cash CRM Billing software. Conducted needs assessments and requirements gathering sessions to better understand the user needs and translate them into meaningful functional/technical requirements. Led JAR sessions to create technical documentation, gather & communicate requirements for the Lightspeed Project initiative to enhance the OSS for ATT & Cingular. Developed risk management plan & risk documentation.
• Point of contact & handled escalation to Amdocs of any Telegence/Ensemble Quality Assurance issues. Analysis of any issues during Ensemble upgrades and escalations. Document and track Quality Assurance, exception and format issues in Telegence Ensemble{MPS,CSM, BILLING, and FORMATER} Led Implementation project efforts through the implementation of Ensemble billing & Telegence message processing enhancement releases IT Environment: UNIX, Oracle 8i, PL/SQL, Business Objects, Toad, .ksh scripts, Telegence Ensemble

Confidential

Sr. Business Analyst

Responsibilities:

• Direct report to Revenue Recovery Department Director for Telecom CLEC re-seller. Primary functions were development of staff business processes, SDLC for Collect billing software.
• Created MS Project Plan and budget for "Collect " SDLC. Created Visio work flow and technical documentation for business processes and procedures. Developed Department/Project budget.
• On site in Victoria B.C. Canada to work with “Collect ” developers to create a custom software solution for Confidential Conduct JAR sessions with Revenue Recovery Director to discuss reporting requirements. Delivered requirements to developers to create daily, monthly and status reports for Revenue Recovery management. Liaison with Sage IT Application Team to implement "Collect " collections software solution. Created "canned" queries in SQL 2000 Server environment for Ad-hoc data pulls.
• Trained Revenue Recovery Team on “Collect ” GUI Interface and reporting solution.
• Analysis of revenue generation process billing, time and materials. IT Environment: MS Project 2000, SQL 2000, SDLC, Visio, Collect

Confidential

Revenue Assurance Manager

Responsibilities:

• Developed Revenue Recovery process and billing software data integrity, quality assurance for correctional facilities telecommunications provider.
• Conduct JAR sessions with Department Directors to discuss reporting requirements. Developed status reports for Revenue Recovery management. Wrote Business Process Improvements for Strategic Assets Department Revenue Assurance Team. Created technical documentation and Visio work flow for business processes. Deliverables include use cases and models, system requirements specifications, functional specifications, non-functional specifications. Developed and implemented new processes around managing requirements. Worked with other technical and business teams to ensure that expectations are met and our specifications are meeting their needs. Served as the central focal point into the IT organization for all requirements including new functionality or enhancements to current systems for specific projects and programs. Ensuring all requirements/specifications have been captured from all the various business stakeholders and CCMI standards.
• Created MS Project Plan adhering to SDLC methodology. Created and implemented Trending tools using MS Excel, monitor Team activities and SLA. Created MS Project Plan to schedule and report status of Billing System Enhancements and Change Requests. Wrote and execute SQL scripts to extract data from the Billing dB.

Confidential

Developer/Sr. Business Analyst

Responsibilities:

• Conduct JAR sessions with Department Executive Vice Presidents to discuss User Acceptance Testing and reporting requirements.
• Wrote and tested "End-User" queries on SQL 2000 Query Analyzer for operations staff to run monthly. Created Stored Procedures and run DTS packages in a SQL 7.0 Server environment to load tables with AS/400 and SQL databases for data pulls and storage. Queried databases via TRANSACT SQL Statements or BRIO Query to extract data per reporting requirements. Created, monitored and scheduled stored procedures, OLAP cubes
• Created and performed User Acceptance Test cases of "EIS" GUI menu items on BRIO Intelligence 6.6 using JavaScript for End User operations staff. IT Environment: SQL 2000 Query Analyzer, DTS, SQL 7.0 Server, AS/400, EIS GUI, JavaScript, OLAP

Confidential

Sr. Billing Project Analyst

Responsibilities:

• Sr. Project Analyst / UAT Lead for Saville Single View roll-out Lead Integration User Acceptance Testing Efforts to ensure that the reporting functions and data migration was meeting SLA requirements.
• Special Billing Project Manager for Single View Convergent Billing Platform Implementation. Scope included developing Billing Platform Customer Structure work flow, created technical documentation, test forms/scripts, lead User Acceptance Testing efforts, and Single Event Toll rating training sessions. Gathered requirements for the Single event Tables structure, reporting catalog, User Interface (GUI), Master Files and Master Environment CCMI Billing rules. Data mapping & data integrity testing from source data to new billing platform tables.
• Ran and oversaw the DPI(As400)/CAMS (Alltel) cycle control reports for the Bill Verification group by creating and monitoring spreadsheets used to analyze revenue from each bill cycle. Provided a monthly report of all bill cycles in all billing systems and the revenue associated. Monitored daily log of job / test duties for the Bill Verification and Production group. Created a monthly Power Point Presentation to be posted on the intranet of End User Billing Revenue. Monthly report of departmental accomplishments. Created and updated MS Project plans for progress tracking and status reporting for Billing System Conversion projects. Created MS Access dB for the Bill Verification and Tables Department.
• Technical writer of job processes and User Acceptance Testing procedures in Information Mapping Format. Heavily involved with the creation of test scripts and source to converted data integrity tests. Conducted JAR / JAD sessions for testing requirements as well as "Lessons Learned" sessions.
• Run high level queries in Single View, AS400-NGS (DPI), SQL, P/SQL, TSO/JCL(eztrive), BRIO, MS Access, (DB2 data warehouse). Led Integration User Acceptance Testing efforts to ensure that DPI and CAMS reporting functions as well as data mapping for SLA requirements. Ensured that USOC’s/GSECs mapped correctly to ASOCs in CABS, CAMS or S&Es in DPI. Used CCMI to verify that rates, product descriptions, formats and bill messages converted accurately. Followed revenues through to the appropriate accounting codes to ensure overall revenue transferred correctly. Attended JAR/JAD sessions for DPI requirements and “Lessons Learned” from previous conversions. Used Mercury Test Director 7.2 to coordinate testing team’s tasks. Key contributor during Billing Systems Vendor selection reviewing Arbor, Amdocs, Saville solutions.

IT Environment: JAR, JAD, Saville Single View, AS400-NGS (DPI), QMF,SQL, P/SQL, TSO/JCL(eztrive), BRIO, MS Access, MS Project 2000, (DB2 data warehouse), IMI, Data Mapping, Mercury Test Director