Business/data Analyst Resume
Plano, Tx
OBJECTIVE:
- I am a consulting professional whose career advancement is built on proven success in fast - paced, mission-critical environment.
- 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.
- I 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.
- Over 15 years of technical/business analysis with broad experience across operational areas.
TECHNICAL SKILLS:
- Agile/Waterfall Methodologies
- Windows
- ISO/IEC 20000
- Business Objects
- CSG - Convergys Billing
- ITIL
- Information Technology Infrastructure Library
- CRIS
- CIS
- CORDAPTIX
- Peace/CIS
- AS400
- PUC
- BMC Remedy
- PowerPoint
- Word
- USHA/SYBASE Unicorn Billing
- People soft
- Oracle BRM
- Convergys
- Portal
- SAP
- DPI
- Mercury Suite
- TBS
- / Metasolve
- Smarts
- Lotus Notes/DOMINODEV
- Access
- Excel
- Atlas
- Seibel/SIMS
- EMI/EMR
- BOSS
- ASBS/SBC
- COFEE
- NOCV
- RequisitePro
- MS Project
- Visio
- Borland/Caliper/Starmem
- Aldea
- Singleview
- Webtrax
- Telegence
- AAIS
- AWAS
- Wisdom Legacy-Wholesale
- Keenan/Arbor
- RUP
- Vantive
- Client Server
- SAS-70/SOX
- Data models
- Ecommerce
- Oracle CRM
- CC&B
- Sarbanes Oxley/SAS -70 Audit
- DOCSHARE & Groupshare-Sprint/Nextel
- Change Management
- Ensemble Suite /Sprint/Nextel-Convergys P2K
- NDW
- ABM-B/OSS Manager -OSS
- SRM
- Cramer
- Ensemble Suite/Enabler Billing
- Vantive
- Amdocs CES 7.5
- Agile Methodology
- Visual Studio .Net
- Clarify CRM
- OMS
- Object Oriented Analysis
- Unified Process
- Defect Management
- Oracle CRM
- Cramer-network Inventory
- QA
- UAT
- Test Director
- ERCOT
- Telecom/Utilities Industry SME
- Service Oriented Architecture
- ERP eTOM
- Revenue Assurance
- Waterfall and SCRUM methodologies
- DOORS
- Agile/Waterfall/SCRUM Methodologies
- Brio
- MS SharePoint 2010 (Architecture upgrade and work flow enhancement project)SQL Query
- Oracle PL/SQL TOAD
- JIRA
- PRISM
- ALM
- Change Management (CAB)
- Data mapping validation and testing via ETL tools
- SOAP UI
- UNIX
- SQL
- Mercury Test Director
- HP Quick Test Pro Quality Center. SME level knowledge of Telecom billing systems call rating bill cycles data processing
- SAP data and billing system conversions are a few of the skills I specialize in. 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
PROFESSIONAL EXPERIENCE:
Confidential, TX
Business/Data Analyst
Responsibilities:
- Data analysis, data validation, testing, integration & auditing of VA IT Help Desk & Asset Management Data.
- Created MS Access dB to process external into Metrics format, power point presentations, MS Excel analysis spreadsheets, Pivot charts. Create & run SQL scripts, Excel filters and V - Lookups, updating, verifying and transforming existing data from SDM Teams.
- Created MS Access dB for ETL process into Service Now platform
Confidential, Plano, TX
Business Analyst
Responsibilities:- Responsibilities include: data analysis, database mapping, data validation, testing, integration & migration of Flight planning tool.
- Ran SOADP UI scripts, updating and verifying existing requirements as a liaison to UI & Development Teams. Creating power point presentations, MS Excel analysis spreadsheets, as well as collaborating on Visio wireframes. Agile Project Team working with “Agile Sprint’ framework.
Confidential
Business Systems Support Analyst
Responsibilities:- Providing support to the stakeholders of the Americas ERP team(a combination of end user support and project support).
- End user support: Investigation, tracking and resolving or escalating production issues relevant to different systems used in the North America order processing and/or billing process. Interacting with business and technical resources of varying levels to accomplish this support..
- Activities include: ROI creation, requirements gathering and documentation, communications, testing, project scheduling and administration and issue tracking/resolution as well as other business related activities as needed.
- Provide end user support for Order Management & Billing Operations systems, resolving issues or escalating them to ensure resolution as needed.
- Communication of issues, impacts, options and status to leadership and team members
- Supporting project business related activities through individual contribution or management of the activities of other resources.
- Activities include: ROI determination, requirements gathering, documentation, communications, testing, project scheduling and administration and issue tracking/resolution.
- Act as the liaison between IT and business stakeholders for recurring support requests such as Mass Updates of SAP production data and, in some cases, execute the updates.
Confidential, Plano, TX
SAP Migration Specialist
Responsibilities:- Responsibilities include: Business Objects Data extracts from invoice and procurement systems, data analysis, data validation, data manipulation to create pivot tables for dashboard reports showing trends and providing KPI’s
- MS Access: Maintaining and enhancing multiple MS Access databases, data entry and table updates into databases for Small Business Team and US Public Sector Reporting solutions
- US Public Sector: Daily, Weekly and Monthly Work Order/Invoice spend reporting for D.O.D. & US Navy & Marines
- Utilize SQL features and VB Scripts in and Business Objects & Access to write the queries updating spend and cost data.
- Export it to MS Excel to identify the monthly and daily data.
- Format & arrange for the teams as part of the project management solution on an excel spreadsheets & pivot tables shared via SharePoint
Confidential, Dallas, TX
Management Consultant
Responsibilities:- Worked closely with LOB and CAB 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
Confidential, Dallas, TX
Technical Management Consultant
Responsibilities:- Demonstrated experience with documenting UAT test plans, cases, results and execution of the Testing for high quality deliverables according to business rules. Prepared test cases and Oracle data query script based off business rules & requirements documents, use cases, process flows and thorough system analysis with minimal supervision. 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.
- Knowledge of secondary mortgage market & experience of working with Servicing / Loss mitigation systems and data.
- HP Quality Center, QTP - Quick Test Pro script modification & execution VB Marco Scripting, Oracle / TOAD, SharePoint 2007 - request forms, data views and task workflows.
Confidential, Plano, TX
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 Front & Backend Telecom OSS (Operation Support Systems).
- Participate with business architects and analysts in identifying and defining business requirements.
- 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 .Assisted with the development of the organization’s requirements engineering policies, procedures, tools.
- 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, Dallas, TX
Business Data Analyst
Responsibilities:- 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, Irving, TX
Business Consultant
Responsibilities:- 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, Irving, TX
Global PMO
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 Service Management 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 Confidential 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 Confidential 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 Confidential 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 Confidential 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.
- 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 Lead NTP (Network Planning) efforts to complete needed RF & BSC updates for Confidential. 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, BMC Remedy, CITRIX
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.
