Summary

• Business Analyst
• Data Analyst
• Requirements Analyst
• Project Coordinator

Skills

• Access, RDBMS, Excel , Visio , MS Office, MI Reporting
• Writing skills / Requirements Documentation / Process Mapping
• ISP NSP Operations, Applications support, Help Desk support
• Website: HTML, Photoshop
• Ecommerce catalogs

Professional Abilities

• Communication, Critical thinking, Analysis
• Management, Information Management, Organization
• Business Area Experience
• Marketing
• Financial Service / Regulation Compliance
• Utilities Energy
• Medical Insurance Tech US
• Ecommerce
• Internet Service Provider
• Network Service Provider / Telecommunications

Career Summary

• I have 15 years experience in Business Analysis, using MS Office together with other proprietary and customized systems. I efficiently identify and engage with stakeholders, gather and document requirements, compose process maps and domain models, and conduct gap analysis to improve the business process.
• With analysis experience across multiple industries, systems, and business processes, I have garnered many techniques that provide me with versatility on new projects.
• Along with a propensity for logical, analytical thinking, I am diplomatic with a can-do attitude, an eagerness, capacity and technical aptitude to rapidly acquire expertise with various in-house systems, exceptional organization, and notably, communication skills. I am highly motivated, customer oriented, and perform effectively both independently and as part of the team.

US Permanent Resident

Confidential

• Member Services Supplier Governance Analyst
• Maintaining and working with Enlighta Outsourcing Resource Management tool to maintain and report on governance and regulatory Compliance for 3rd party suppliers
• Research and analysis of Supplier contract Deliverables Obligations
• Project Management Weekly Status Reports, Weekly Varience Reports actual v's projected hours for development and Run The Business work efforts
• Project Management for internal Affiliate Service Oversight Descriptions SODs development / workflow processing.

Confidential

• Developing MS Access databases for MI reporting:
• Call Center client management
• Sales process management and tracking / reporting Marketing Service Fees processing, Bonds, Bonuses, : Weekly Submission Tracker, Earnings Summary, Payments Summary

Confidential

• Financial Services PPI miss selling review and analysis for Certus contracted Lloyds Banking Group project, within the Product Regulatory Compliance team
• Excel data analysis of PPI account holders, process mapping of PPI redress operations and customer service response procedures in Visio
• PPI Policy documentation review, Lease Agreement analysis, Checklist analysis
• Procedural guide workshop review, preparation of process maps in Visio, procedural guides in Word
• SoftCo, Keybank
• MI Summary Reporting on PPI Redress project workflow status database queries and Excel summary report format

Confidential

• IT performance metrics reports - Excel, Access, PowerPoint, Chart representation: Project tasks daily tasks performance and status Infrastructure statistics Call statistics - received / Resolved / Open - internal IT / external System performance - uptime versus outages Major incident requests MIR statistics Change Requests - applications, projects, and infrastructure requests - upgraded CR Access database of queries and data exporting to Excel pivot tables and charts sourcing to PowerPoint presentation REPORTS: Key Performance Incentive KPI weekly Weekly Submission Pack - Sys performance, uptimes / outages, current week versus rolling 4 weeks, rolling 13 weeks, and YTD
• Created the SQL queries for Avg Wks closed for current year CRs that were in 'Open Status' for 2011 - Infra, Apps, and Projects
• Created a new MIR 2012 Pivot table for updating the Weekly KPI report
• Redesigned the CR processing to bypass the Excel formula area and translate formula to SQL in Access
• Updated the Change Window process in Excel and created a new formula to set the Status as 'Change Window'
• Corrected the Access query KPI 2 in IT Reporting database to place the weeks in running order for CRs Closed under Change management report on Weekly KPI Report
• Created query for 2011 Cumulative CRs closed Change Management report in Weekly KPI Report
• Developed an Access database to process Weekly Status of BAU CRs - output to Excel, feeding charts, feeding Powerpoint Presentation developed Cross Tab SQL queries to build reports and export to Excel

Confidential

• Managed energy efficiency incentive program for commercial customers database tools for customer services and support
• Energy efficiency main rebate incentive programs Lighting and HVAC
• Developed MS Access customer management database with statistics reporting on projects status, budget mapping in Visio
• Created Access table relationships, queries Make Table, Append, Update, Crosstab, forms with entry validation, macros, and reports
• Developed and implemented MS Confidential
• and application validation using M V from 3rd party service provider Nexant
• Administered rebate payments / credits for commercial customers working with Accounts Payable dept and using SAP
• Developed real time dashboard for financial commercial program Confidential
• date and program, KW KWH reduction, total amount, rebates by check, by account credit, detailed customer management rebate status by application received, review in progress, verification sent/received, customer acceptance, NPO signature, checks delivered, accounts credited
• Developed Confidential
• of variables for interior lighting based on commercial factor, industrial factor, avoided costs, capacity value factor, available rebate factor, present value, over seasonal rates seasonal on peak, seasonal off peak, seasonal mid peak, non-seasonal off and on peak etc. Entered validation formats on user entry forms.
• Extracted quarterly customer data from Oracle backend to Excel, produced formula calculating energy efficiency ratings for HVAC BTU Output, EER, COP, KW per Ton. Developed Excel sizing and energy efficiency matrix to calculate rebates for HVAC systems showing steps based on minimum international standard efficiency baselines in coordination with 3rd party service provider Nexant.

Confidential

• MS Access report application development
• Designed and developed weekly Global Sales Dashboard report from Salesforce.com files in MS Access
• Produced logical sequence of SQL calls and export of report for executive management
• Imported Salesforce produced Excel Sales data source files to Access to generate formatted Access reports based on Excel formula and SQL calculations of Quota, Commit to Quota, Commit, Bookings to quota, total bookings, New Sales bookings, Partner bookings, prior month end, percent of total month new sales/upgrades /partner for APAC, EMEA, and US regions

Confidential

• SQL Developer SQL Plus Oracle data migration / validation
• Performed SQL queries to verify and validate data
• Worked closely with PLSQL syntax developer to produce PLSQL scripts to transfer terabytes of data millions of line items
• Produced Pseudo code and Business Logic for these scripts, annotated for developer, and troubleshot scripting for errors
• Prepared project documentation with examples of the database structures using Visio

Confidential

• BCBSA Tech Support - Mainframe, AS/400, LRSP, ITS, SDLC Project tracking:
• Analyzed local insurance claims processing software upgrades via data element mapping to ITS global BCBSA systems
• version upgrades to maintain current EDI insurance claim transfer between home / host insurance companies across the U.S.
• Performed requirements gathering and designed and developed MS Access host claims log and reporting database designed and developed update, append, delete, make table, union, crosstab queries, forms, reports, and implemented Security settings for this database as the administrator:
• This log will be used to record daily counts of BlueCard Host hardcopy claims received. It will also be used for the following batch control exception handling conditions:
• Tracking claims returned to provider
• Tracking claims sent for medical reviews
• Tracking claims returned to plans Plan Profile Handle Direct, etc.
• Tracking of split claims
• The log will replace the current ScanOptics Log for the following three functions:
• Issuing of daily batch numbers and logging of claims count
• Logging of validation of claims scanned into Documentum
• Logging of current Host backend SF balancing function
• The log can be concurrently used by multiple users
• This log is built upon an ACCESS Database. Access is granted to individuals associated with Host claims processing.
• Access can be requested through the BlueCard Project Team.
• Initial use of this log will be limited to BlueCard Control Host Operations.
• Developed SQL code to translate Julian to Gregorian dates and vice versa.
• Produced process models and data mapping using Visio

Confidential

• Requirements gathering - State Dept of Education
• Lotus Notes document management system to maintain communication of updated requirements templates regarding
• school district administration examination requirements

Confidential

• Directional oil well survey data analysis
• Proprietary database system research and update DWS Oracle based database. Online research, Texas Railroad Association online library research
• Hardcopy library source data references
• Detailed oil well survey statistics and analysis

Confidential

• BCBSA Tech Support - Mainframe, AS/400, LRSP, ITS, SDLC Project tracking:
• Analyzed local insurance claims processing software upgrades via data element mapping to ITS global BCBSA systems
• version upgrades to maintain current EDI insurance claim transfer between home / host insurance companies across the U.S.
• Performed requirements gathering and designed and developed MS Access host claims log and reporting database
• Produced process models and data mapping using Visio

Confidential

• Network Operations Center Analyst Operations Help Desk Analyst Remedy, Webstats metrics reporting
• Worked closely with developers and managers in resolving trouble ticket issues regarding metrics reports spikes and anomalies
• Mapping / modeling of Legacy Billing System and Member Services processes in Visio
• Designed and developed MS Access 'knowledgebase' for purposes of facilitating and accommodating various departments help desk needs in the interests of cross-training.

Confidential

• Management - 10 Data Specialists / 30,000,000 e-catalog line items / 1290 vendors
• Processed and prepared client catalog maintenance files for upload dealt with other functionality issues in the system
• Researched and responded to clients on an array of issues managed flow of new start client and client maintenance work
• Assigned workloads and ensured that all client requests were dealt with in a timely manner
• Expedited process by designing overall systems models and designing and implementing MS Access applications
• Tracked all processes within the catalog team and developed and produced reports based on a self-designed and
• implemented MS Access database

Confidential

• Queried Internet backbone circuit database using Access SQL on maintenance activity using MS Access front end ODBC
• connection to Sybase backend tables
• Prepared weekly network maps in Visio against global system data
• Prepared and presented management reports