SHAREE ROBINSON

229-***-****

ad14wd@r.postjobfree.com

SUMMARY

Highly motivated Business Intelligence Professional using Extract Transform & Load (ETL) processes with Microsoft Technologies and sub applications to provide internal business solutions for Senior Management decisions. Additional experience in other programming acumen and CRM tools-such as Salesforce.com (SFDC), Integration Services (SSIS), SQL Server Reporting Services (SSRS), Financial Systems (Zuora) and MicrosoftStrategy. Demonstrated leadership abilities and team-work skills as well as the ability to accomplish tasks under minimal direction and supervision.

TECHNICAL SKILLS

Competent in MS PowerPoint/Outlook/Excel/Word/Works/Strategy, Gmail, Google Docs, Read/Convert/Edit/Organize PDF Documents, Adobe Acrobat, FTP and transfer files, ETL, Software Development Life Cycle (SDLC), SSRS, SSIS, SFDC, Workbench, Workday, Kanban Project Management & Daily SCRUM meetings to discuss statuses/backlogs and assign tasks/sprints with team members and business owners

•Proficient in Agile Software Development, SQL Server Management Studio, T-SQL, Automation and Integrations Systems, IBM CastIron Web Studio (CastIron), SOQL, Trailhead, DeveloperForce, Quality Assurance testing, Pivot tables, Apex Data Loader, WinMerge

•Knowledge in MS Access, MS SharePoint, HPCC, ECL, xml, notepad++, TeraData SQL Assistant, Oracle, Azure SQL DB, REST SoapUI, Zuora 360, Sococo, Data Warehousing (DW), Data Mining, Data Marting, FileZilla, JIRA, CSV Creator

•Working knowledge in Trucare, Tableau v2.0, Lightning, Apex Classes, JSON, XSLT, OKTA

RECENT PROJECTS

•Streamlined a user-friendly report flagging the load delivery status and if compliance was met. I completed this project by bucketing drivers per load in comparison to defective goods invoicing.

•Established trends and predictions as a start-up company versus competition. I completed this project by revamping reports to capture monthly & quarterly business metrics in comparison to data gathered from competitive local markets.

EXPERIENCE

Ad Hoc Reporting Analyst/Accounts Receivable Coordinator

Quality Merchandise & Transport, Atlanta, GA, August 2020-Present.

•Massage, cleanse and manipulate raw data, import into MS Excel and create formula fields or SQL that capture current volume, establish patterns and then predict the frequency of dedicated lane transports

•Maintain and organize office documents to include the following daily tasks: sort, file, scan, email, copy, print, fax

•Create ad-hoc reports showing driver activity to ensure employee pay and loads completed are in sync in addition to invoicing and all receivables

Open Records Act Analyst/Inside Threat Analyst

Georgia Institute of Technology, Atlanta, GA, April 2020-July 2020.

•Review and analyze collected information and data associated with the Georgia Open Records Act (ORA) to ensure full compliance before making internal records public

•Conduct quantitative analysis of sensitive information using attention to detail and accuracy of data to fulfill ORA requests while relating sensitive info to state exemptions and redacting data accordingly

•Identify potential disgruntled employees through reviews associated with existing or active ORA’s to support the Insider Threat Program

Quality Test Analyst III/Data Analyst III

LexisNexis Risk Solutions, Alpharetta, GA, August 2019-January 2020.

•Create ECL code on Roxie clusters to validate field to field comparison against versioned key files between environments

•Analyze substantially large volumes of data to identify potential inconsistencies in datasets, logical files and base files that were collected from multiple sources

•Perform regression testing to ensure unchanged parts of files are unaffected, detect unintended changes, identify any new changes and confirm those changes have not introduced any new bugs or inconsistencies

Data Analyst III (Behavioral Health)

PeachState Health Plan, Atlanta, GA, November 2018-August 2019.

•Collaborate with behavioral health managers to understand the company’s internal insurance processes, interpret business needs into report requests and develop reports to measure the progression of health insurance workflows for timely ad-hoc or operational requests

•Adhere to DCH state reporting requirements to capture data elements needed to measure compliance for Medicaid and Medicare audits

•Maintain/refactor Teradata SQL Assistant queries and MicroStrategy queries to interpret business requirements into user-friendly formatted reports showing aggregated insurance data

•Transform corporate Microstrategy reports to present metrics in a summary format using pivot tables/charts

Software Engineer

RentPath, Buckhead, GA, July 2015-October 2018.

•Automate processes to migrate data between application systems and provide continual production support for ongoing CastIron orchestrations while leveraging a normal workload in addition to discovering and/or responding to bugs in any production or test environments

•Convert CastIron projects and database components (SQL Server and Oracle) to an upgraded version of 2016 and then to a cloud-based version of Azure (involving creating detailed documentation for change and release management in addition to coordination of Kanban cards and SFDC cases between teams)

•Gauge business requests from business owner's perspectives, write, develop and test stories from Kanban cards that will eventually go thru the agile process to facilitate enhancements and meet Enterprise Application expectations

•Integrate data between applications using ETL processes while simultaneously creating unit tests in SoapUI before deploying projects to QA and then to Staging environments

•Engineer commissions project to retrieve financial data generated from sales reps and send data elements from SFDC to an Iconixx sftp site

•Build custom fields in SFDC in addition to Grant/Edit view permissions for profiles, modify Page Layouts and list views, create custom objects and write SOQL for SFDC Reports, Workbench, or data load tasks using Apex Data Loader

•Produce and maintain Google Docs for Production releases and Inventory of our CastIron business processes which captures the most current running processes in preparation for spontaneous audits

•Train new integration team members on business processes and the CastIron development environment

SQL Reporting Analyst

RentPath, Norcross, GA, May 2012-July 2015.

•Convert tens of thousands of leads from external sources into prospects through precise SQL analytics and allocating them to the proper objects in SFDC to generate new business

•Capture most recent data from SFDC using the Apex Data Loader/CSV creator to refresh or create tables in SQL Databases and manipulating data to generate reports

•Upload contracts from Max Cross Reference into SalesForce to ensure the cloud is updated

Reporting Analyst (Finance Team)

CareerBuilder-Technology HQ, Norcross, GA, December 2011-May2012.

•Build reports in SSRS by extracting info from Pivot Tables and Fact/Dimension Tables

•Develop mid to high-level queries and Stored Procedures built out of Data Marts to provide financial and head count data

•Manipulate, integrate, analyze, and organize data from the company’s Data Store

Business Administration Internship

United Parcel Service (UPS), Pittsburgh, PA, November 2004-July 2006.

•Calculate confidential data to compare and contrast competitor activity using MS Excel and MS Access

•Update customer information to effectively track packages and provide excellent customer service

•Create numerous presentations for company-wide projects using MS PowerPoint and MS Excel

EDUCATION

•Robert Morris University, Moon Township, PA. BA degree in business administration, 2005.

•The American Business School, Paris, France. The Center for Study Abroad Program, 2004.

•Community College of Allegheny County, Pittsburgh, PA. AA credits transferred to BA degree, 2002.

CERTIFICATIONS

•U.S. Security Clearance, Secret Level, August 2020

•Microsoft Certificate of Achievement: Writing Queries Using SQL Server 2008 Transact-SQL, 2011

•Microsoft Certificate of Achievement: Implementing and Maintaining SQL Server 2008 Reporting Services, 2011

•Advanced Individual Training Certification in Signal Support, U. S. Army, 2010

•Published in Who’s Who Among Students In Junior Colleges, 2002

•African American Outstanding Achievement Honorable Certification, CCAC, 2002

References Available Upon Request

Contact this candidate