COMPUTER SKILLS:

• Windows 2010,
• Microsoft Suites (Word, PowerPoint, Access, Excel and Outlook) Lotus 123,
• Netscape,
• Oracle 9I & 10G, 
• Maximo 6.5,
• Electronic Email,
• IBM Mainframe,
• Facsimile,
• CompuServe,
• Easytrieve,
• Spufi,
• Xpeditor,
• SQL,
• Cobol I & II,
• JCL,
• Fortran,
• PL/1,
• C++,
• File Aid,
• Basic,
• CMM,
• ProComm Plus,
• IBM 4321,
• INNATE,
• SAP,
• TSO,
• MVS,
• JES2,
• JES3,
• ISPF,
• IMS,
• CICS,
• CA7,
• CA11,
• CAVIEW,
• DB2,
• AS400 Mainframe,
• VSSM,
• OS/400,
• Focus,
• Regisnet,
• Control D,
• Netscape,
• Xcaliber,
• Plotworx,
• PL1,
• Champ,
• Endeavor & Bea WebLogic.

PROFESSIONAL EXPERIENCE:

Confidential, Las Colinas, TX

Data Analyst

Responsibilities:

• Work with Global Contracts Data on the MedAssets side & Vizient Side
• Assisted with gathering, sorting & manipulating data to be set to move from the MedAssets database to the Vizients’.
• Utilize SQL Server 2014 Management Studio to enter (PIM) Product Identification Master Codes to pull back Data to analyze.
• Perform data analysis on Product Summary Contracts, Pricing & Product Spend Categories.
• Utilized the Request Que where all the contracts are held to be worked according to their seniority.
• Ensured the correct Spend and Savings categories were listed into the final product summary to be reviewed by upper management.
• Perform variance checks making sure that the correct spend category is attain at the completion of data analysis
• Send data to manager to have Quality Assurance performed before sending final report out to upper management.
• Pulled data in access to 220,000 rows at times. Upon sorting, filtering, removing duplicates & removing old dates of previous years. The final data to be analyze is at times 25,000.
• Selected completed contract files and posted onto SharePoint for upper management & sales team to have access.
• Perform VLOOKUP to search a particular piece data to be compiled & joined with data in another location on that worksheet.
• Created Pivot table to better organize certain data criteria to look at specifically.
• Uploaded completed analyzed data into the database.
• Variance checks performed by searching UOM’s (Unit of Measure) comparisons.
• Utilized various internet search functions for pricing comparisons eg. the company home page to utilize Market Place Procure to look up the product contract information in order review how many Tiers has to be worked. Also used Owens & Minor as well as Medline as a pricing source.
• Created Raw Data Template to place all data pulled from the Sequel Server.
• Combined all data before completion and entered into the Final Data format to be submitted onto the Global worksheet to complete the process of analysis.
• Handled sensitive Client paperwork. Ensuring no HIPPA compliance is violated.

Confidential, Addison, TX

Data Analyst

• Collection, Analysis & reporting of data via EHR(Electronic Health Record) database.
• Perform data analysis & assist in the interpretation of results using various techniques.
• Pulled Data Sets to perform analysis to ensure correct prices are in place according to the customers’ contract.
• Ensured the correct form data runs to determined impact level for data quality issues.
• Create Reports, Graphs, Charts, Spread sheets on a regular basis that summarizes data to be reviewed by upper management.
• Provide ad hoc statistical analysis and reports as requested.
• Create Weekly, Bi - weekly, Quarterly and Annual Reports via EHR.
• Provided backup for admin support if need to assist Veteran Clients with Paperwork.
• Handled sensitive Client paperwork. Ensuring no HIPPA compliance is violated.
• Interpret data, analyze results using statistical techniques & providing ongoing reports.
• Filter & clean data by reviewing computer report printouts & performance indicators to locate and correct any data issues.
• Locate & define new process improvement opportunities.
• Coordinated with the Clinicians for data cleaning & variables selection to ensure data clinical meaningful and analyzable.

Confidential, Dallas, TX

Quality Data Analyst

• Evaluate large datasets for quality and accuracy.
• Created tables to map graphs by use of the data pulled from the database.
• Created Pivot Table to produce data to receive Top 100 CPT codes used by the Anesthesiologist.
• Determined impact level for data quality issues.
• Utilized Centricity software to evaluate patience records data to determine which CPT code the Anesthetists performed on the patient.
• Resolved most internal data exceptions in timely and accurate manner.
• Analyzed and manipulated data according to defined business rules and procedures
• Make recommendations to operational support for enhancements to systems of record to improve accuracy.
• Utilized Centricity software to evaluate patience records data to determine which CPT code the Anesthetists performed on the patient.
• Resolved most internal data exceptions in timely and accurate manner.
• Analyzed and manipulated data according to defined business rules and procedures.

Confidential, Irving, TX

QA Analyst II

• Gather requirements, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
• Pull up UB’s & EOB’s to ensure all information is correct and precise with no defects.
• Utilized both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression. i.e (Sharepoint)
• Develop use cases, user interface specifications, and user requirement specification documents.
• Provide test data, schedule automated/manual tests. Approve results documentation and tracking systems updates.
• Interacted with developers, system engineers, and testing teams to identify applications defects
• Performed functional testing, Integration testing.
• Participate in execution, modification of the test cases, and bug verification changes.
• Utilize the software SPIDER to enter Client ID number which pulls files in order to analyze data for possible defects.
• Verified standards of quality and testing procedures - Reviewed and modified quality assurance programs and tested performance according to user’s specific requests and data inputs.
• Mentored team members in quality assurance procedures and processes and facilitated discussions on areas of improvement.
• Logged defects and followed up on issue resolution ensuring timely customer reporting needs were being met.
• Monitored testing resources to ensure project tasks are completed successfully and according to development specifications and deadlines.

Confidential, Irving, TX

EDI Analyst

• Create and maintain functional models, process flows, and wire-frame diagrams.
• Manage and enhance requirement changes.
• Maintain project documentation such as project lists, project status reports.
• Utilized CompLink database to analyze data via former employees Cobra & FSA benefits.
• Maintain regular contact with clients. Coordinate and report on project progress and accomplishments.
• Develop use cases as a key communication tool between the business and technical teams.
• Utilize EDI application to include but not limit to setups, changes, testing, requests, follow-ups and error management.
• Analyze test results and log its defects by use of the database CompLink .
• Ensure the compliance with HIPAA regulations and requirements were met.
• Utilized the software RTDB (Request Tracking Database) to locate data for comparative bounce testing.
• Monitor the production environment and proactively prioritize, communicate, and resolve any EDI process or system issues.
• Support Account Management with EDI issues that are raised or escalated by their clients or vendors.
• Work closely with administration, technology & operations.
• Utilized the access to data and personal observation to identify potential process improvement opportunities.
• Perform routine and ad hoc analysis of various facets of EDI processing including but not limited to system performance.

Confidential, Irving, TX

Business Data Analyst

• Gathered business requirements from business users and subject matter experts.
• Defined and documented business data requirements as well as analyzed and prioritized them.
• Prepared project status reports for senior management.
• Provide 3rd level support for applications.
• Wrote functional specifications by use of basic SQL usage.
• Participate in releases, perform system integration testing & perform/organize user acceptance testing.
• Gather user requirements from the business line users for various systems & fully document all requirements & solutions.
• Performed system user recertification as needed.
• Utilized the software RTDB (Request Tracking Database) to locate data for comparative bounce testing.
• Maintained client confidentiality and protected operations by keeping information confidential.
• Lead requirements validation and traceability analysis by performing large bounces by use of running DX25 data comparisons
• Work closely with administration, technology & operations.
• Utilized ARC software (Asset Repository & Collateral System) to pull various results for the asking customer.
• Write test scripts and coordinate system & UAT testing.
• Operated BODC software (Data Converter) to convert data to be utilized.
• Gathered required data after running Vlookup and transferring from Microsoft Word to either a .txt or .ecs file to make readability accessible when applying to different software’s to further analyze the data.
• Protected database by developing access system. Also, specifying user level of access.
• Support client software and data compilations.
• Assisted in operational rollout and support.
• Performed Daily Integrity Reports by use of the Freddie Mac Selling System.
• Upon data collection, filtered and cleaned the data to remove errors and ensured consistency.
• Utilized VLOOKUP to perform data comparisons, manipulations.
• Also specifically pulled information from large amounts of data which came from different customer account files that they requested to be bounced.
• Performed business process designs in conjunction with other Business Data Analyst teams.
• Data pulled to be analyzed was in access of up to, but not limited between 80,000-90,000 records.
• Utilized the software’s WINS CMS 7.3, DASHBOARD & ICR Database’s to perform the bulk of assigned assignments.
• Performed assigned tasks given from leadership as needed to complete future job endeavors. As well as assist teammates with assignments to keep all task moving along to keep all assignments within SLA.

Confidential, Plano, TX

Data Analyst

• Utilize final month end sales data sent in from the bottlers via email to project exact sales for previous month’s sales.
• Utilized software known as STARS, which is used to translate the bottlers’ data into readable data that is understood via Confidential / Confidential ’s system.
• Maintained files for 24 bottlers each end of month.
• Maintained the Data which came in as one of the following, .txt, .esc or .htm via email.
• Perform data analysis by use of Microsoft Excel by using text to columns & columns width to properly align the data.
• Identified the new chains that the bottler may have been added to the current chains.
• Verified all new company codes in order to match them with the correct products. Should there be any errors in the data, I utilized STARS ECS Translation process to clear them by adding all the new product codes into the system. Once all errors were corrected. Saved the new file as a .prn to its perspective month/year folder.
• Utilize the software PFE to pull the data now saved as a .prn to translate it to a .dat file.
• Moved the .dat file into the Confidential / Confidential server by use of the software WINSCP3.
• Perform the following once the data has been moved into the STARS server, Created the ECS input via the .dat data, Maintained it in the ECS DATA load. Loaded the Data into ECS SALES.
• Ensure the data was maintained via ECS SALES by printing the report out verify all data was moved correctly. Lastly, completed final Load of the month end CASE SALES.
• Created final report to print out and turn over to auditors.

Confidential, Richardson, TX

Customer Engagement Analyst

• Utilized Microsoft Excel to create Customer Information Tracking to better understand the major customer concerns & maintain daily.
• Created power point slides to train Regional Operations Managers, Branch Managers & Area Managers on new process sets that I created through Quick Base to simplify each branches’ ability to gather and maintain customer accounts.
• Created as well as maintain Graphs & Charts in order to identify the trends for each quarter.
• Maintained as well as kept the Database current.
• Provided the majority of trainings via Microsoft Live Meeting, while accompanied by Confidential CEO, VP of Operations, Director of Operations and the Customer Engagement Senior Manager.
• Managed Pivot tables that I created and ones that were already created, but I managed all the enhancements. I also compile various amounts of charts when requested.
• Maintained my department files as well as records. When needed, I ordered company equipment and supplies. Proofread/Reviewed a plethora of forms/documents.
• Utilized & Created the Customer Complaints Tracking system through Quick Base to provide a better, accurate and more efficient means of accessing and maintain each complaint making it easier for each Branch to manage their specific areas of responsibility.
• As the administrator, I managed all the Add, Changes & Deletes and also, give access to individuals according to their level of responsibility.
• Created Voice Message via utilizing the VOIP telephone system. The purpose was to give each Area Operations Managers direct access to their desktop computer email and voicemails if they are out in the field. This methodology also allowed the AOM’s to have immediate access to their perspective customers in their region.
• Received and solved customer complaints through all Incoming calls, Email, Mail, BBB (Better Business Bureau), Yelp, Facebook and Consumer Affairs.
• Access the BBB (Better Business Bureau) web portal to track all open cases against Confidential / Confidential and assign each case to its Regional Operations Manager until all cases are resolved.

Confidential, Washington DC

Electronic Data Interface Specialist

• Utilized ALTHA & CHCS system to ensure all Confidential records were installed correctly into the database, while ensuring that no HIPPA violations have occurred.
• Operate scanning device to scan clients’ medical information into the system whether it is for clinical notes or either of the following; Previous Encounters or Current Encounters.
• Provided support of training operations of the DOD Electronic Health Record (EHR), which include outpatient clinical information systems and inpatient clinical systems, in conjunction with Office Automation. Responsible for coordinating with Regional Chief Medical Information Office and AMEDD training activities involved in the analysis, design, development, implementation, and evaluation of training programs, and support of training programs.
• Utilized (Version 9.7) Initiate to search & edit various providers. Types of ways I performed my searches are as follows; By Provider ID, Last Name, First Name, Specialty, Office etc.
• Viewed Providers information with Initiate as well. Perform imports and exports either in .csv, .xls or .xlsx formats to either email to the doctors or hand delivered. The type of data I pulled is larger to name a few are Credentials, Emergency contact info & organizational relationships.
• Managed providers, Added individual providers, Adding organizational Providers & Worked Notifications from time to time.
• Utilize EMPI(Enterprise Master Patient Index) to accurately store patient data. I utilized this application to match, merge & prevent unwanted duplication of patients with the same names or similar names.
• Trained co-workers on the proper use of EMPI and the importance of effective usage. Sharing with them during training that by effective utilizing this application each Hospital department can share data on the same patient confidently which will prohibit a HIPPA violation.
• Managed all administrative and reporting requirements for the MTF MAPS training. Also, prepared many administrative documents as well as reports while simultaneously monitoring the transactions of each individual Medical Records. Resolved all discrepancies should there have been any.
• Provided technical expertise & guidance on established requirements regarding receiving lines, invitations, and courtesies to domestic and visiting foreign dignitaries.
• Participated in planning, coordinating, and executing Confidential and civilian visits. Follows policies and specific requirements of the CG to insure proper reception, orientation and assistance, and to prevent unauthorized disclosure of classified information.
• Planned, coordinated and carried out Confidential and civilian ceremonies for retirement, awards and promotions.

Confidential, Alexandria, VA

Help Desk Consultant

• Completed Maximo Installations for Desk & Laptop Computers. The installations consisted of implementing the Inventory Management & Work Management software.
• Created Oracle Database 10g to support Maximo in its entirety.
• Created as well as Modified Maximo Starter Screens by creating screen changes as requested by the customer. During the process, created KPI’s, by use of specific SQL statements to produce required data, also created new Column headings & removed headings from one area to another to satisfy job tasks.
• Performed duties above in a client server environment utilizing Oracle 9I & 10G.
• Utilized Weblogic to associate with Maximo when producing required job tasks. I also, completed Weblogic installations.
• Performed Rules Manager to manipulation Maximo screen settings to allow more advanced work to be completed that normally could not be done.
• Completed Maximo Handheld installations while also accepting helpdesk calls from the client. I also maintained Microsoft Excel spreadsheet to log all completed & open issues for tracking purposes.
• Completed Front-end & Backend sides of version 6.5 of Maximo as well as its Counterpart Maximo handhelds.
• Configured Symbol Handhelds models MC3500s’, MC7090s’, & also MC9090s’ to accept jobs coming from the customers desktop as well as the handheld having the capability to send offsite jobs back to the desktop.
• Implemented new software to enable Each Symbol handheld to utilize barcodes to scan customers’ products into the Inventory Management of the Maximo system.
• Provided Customer with documentation defining the hardware, software and Configuration.
• Created Excel Spreadsheet to keep track of all Symbol Handhelds that has been uploaded with the Maximo Application and Configurations has been applied as well as its security structure.
• Tested each individual handheld by going through and creating job task to ensure that it applied each task deliverables per the customers (U.S Mint) request. Also created Test scripts passing them along to my co-workers to test the products capability as well as trained each individual during a conference room environment ensuring they understood the complete proper use of the Symbol Handhelds.
• Managed Work Management (Assets, Job Plans, PMs, Service Requests and Work Orders)
• Performed Preventive Maintenance (developed & verified job plans, fixpacks, and hotfixes.

Confidential, Laurel, MD

Monitoring Program Data Technician

• Analyze Bird Banding data utilized by use of the Oracle Database system
• Copied text, image & tab files and modified on CD ROM or Diskette. Once Modified sent through X: Drive thru production to run test. Also, modified file paths when necessary.
• Reviewing that same data queried, I made contact with the banders by either phone or through Lotus Notes to explain the renewal process.
• Wrote data to Diskettes, DVD’s & CD’s and/or hard drives when needed.
• Performed system queries and print outs of all permits not current or within 30 days of expiring.
• Met with management to provide outputs of any banders whom were delinquent with needed data to renew permits and close the cases in order to continued monitoring through oracle.
• Released Data into Oracle Production upon revising the data to be readable through the network.
• Stored data onto the X drive for continuous use in the future. Also kept track of all data in descending order on an excel spread sheet.
• Utilize DeLorme Street Atlas 2008 to plot points of area where the Biologist banded its birds. Locations plotted are based from Latitude/Longitude bases. Each plot created in 10 minute increments & must be accurately exact.
• Gained access to data listed within Oracle & downloaded on Diskettes and CD’s to be utilized for future references to locate testing birds’ migratory stages.
• Kept tract of the production of data I ran to ensure there were no errors. Should there have been any abended errors, I would debug then rerun during the next production period.