| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name , MBAFarmers Branch, TX PHONE NUMBER AVAILABLE LinkedIn EMAIL AVAILABLEInnovative, ambitious Business & Data Analyst with years of invaluable experience and a strong educational foundation. Respected by colleagues and project teams for passionately offering first-class customer service to internal and external entities. Adept at offering a sound domestic and international business perspective, having worked in a diverse array of telecom settings over the course of an impressive career. Practiced at leading full lifecycle implementations of data warehouses and data marts. Liaise effectively with various entities including Developers, IT Consultants, Support Representatives and end-users to set forth necessary system features and operations. Skilled at moving data from source to target locations. Now seeking a Business Analyst or Data Analyst role with a healthcare focus with an organization that fosters career progression and growth.CORE COMPETENCIESData Analysis & Mapping, SQL Environments (Data Lake, Teradata, Oracle), SDLC Environments (Agile & Waterfall), Documentation & Reporting, Communication, Problem Solving, Troubleshooting, Teamwork, Leadership, Active Listening, Billing System Implementation, SQL Scripting, Siebel, Middleware, Unix (Shell Scripts), Linux, UbuntuEXPERIENCETEKsystems Sr. Data Analyst (10/26/2022 to Present)Client: Wells FargoWorking with data in Hadoop Data LakeUse SAS Software to create reports to verify business requirements.Creating mapping documents to map data from many sources to the company Data LakeWriting complex SQL queries to find customers who fit the profile for new products.Creating synthetic test data for testing efforts.Verified ETL process from legacy Teradata database to company Data Lake.RCG Global Services Sr. Consultant (5/2015 to 9/2/2022)Clients, Pizza Hut, Alliance DataLiaise with business and technical clients to work according to automated testing requirements; document operations and develop requirement-based solutionsWrite SQL scripts to move data from store databases to company database (ETL)Offer gap analysis for testing without automation in comparison to automation testing potential; craft automated test scripts using Java/Selenium/testNG platformsDeliver training guidance and customer support for system integration via Oracle PLM, SOA, and PeopleSoftDevise test plan and cases to confirm integrated system functionality between Oracle Agile and PeopleSoftExcel within the Scrum Team to author stories and assign points with the utmost accuracyAccenture Data Analyst (8/2012 to 5/2015)Examined and documented source data, creating maps to move data from source to target locationsContributed to a project team that wrote SAS programs to identify Medicaid and Medicare patients using records, notifying them of new drug availability and other important factorsCollaboratively identified Medicare and Medicaid records that were modified erroneously, restoring them to a proper state and resubmitting the correct versions to CMS for approvalSupervised ETL developers to transition Medicare and Medicaid records from legacy systems into an Oracle databaseCalled on SQL Developer to author ad-hoc reportsFannie Mae Sr. Data Analyst (8/2011 8/2012)Authored system requirements to develop new structures in a data mart, along with a logical and physical model for a relational databaseCrafted comprehensive database tables and load strategies for employee data and job assignmentsWrote PL/SQL code in Toad to profile and import data into Oracle tablesLed troubleshooting for SAS programs leveraged to develop analytic reports; also tested and validated data in Business Objects reportsBank of America Sr. Data Analyst (2/2011 8/2011)Devised system-level requirements to import data into the Home Loan Divisions Enterprise Data Warehouse, using Toad to analyze data from batch files before loading into the Enterprise Data WarehouseCreated multipart SQL queries to profile source file data received, along with strategies to map data from source file to Oracle and logical data models for new warehouse tablesCandidate's Name , MBAPage TwoSouthwest Airlines Sr. Analyst (02/2009 03/2011)Examined and profiled data prior to data warehouse importing, partnering with Middleware Developers to troubleshoot data issues concerning the interface between the middleware and data warehouseVerified that data marts contained information needed from the data warehouse in the hub and spoke architecture, confirming accuracy across data mart reportsLed End-To-End (ETE) UAT testing to align final project results with end-user requirementsGuided Extract, Transform, and Load (ETL) to load data across sources into the Enterprise Data Warehouse (EDW)Validated and finalized Ab Initio scripts from UNIX command line, assessing data files from the line as wellBlue Cross Blue Shield Sr. Analyst (03/2007 10/2008)Developed ETL program, utilizing SQL scripts to load data from source to Teradata data warehouse tablesOutlined testing strategy for data warehouse projects testing measures, crafting plans and conveying status updates to senior managementTested and validated data transformation business requirementsAutomated manual processes using UNIX shell scriptsProfiled data to understand how to propagate across database tablesADDITIONAL ROLESBusiness Intelligence Consultant, Rent-A-Center (07/2006 3/2007)Consultant, Alliance Data Systems (09/2005 07/2006)Consultant, Citigroup (06/2005 09/2005)Consultant, Verizon (06/2002 09/2002, 12/2002 04/2005)Consultant, Genuity (04/2001 12/2001)Consultant, Accenture (08/2000 02/2001)Business Analyst, WorldCom (04/1999 08/2000)Business Analyst, Telecom Technologies (04/1998 04/1999)Business Analyst, MCI (01/1994 04/1998)EDUCATION & CREDENTIALSMaster of Business Administration, University of Phoenix (April 2002 April 2004)Bachelor of Arts, English with Minor in History, Texas Tech University (September 1980 August 1985) |