Business Analyst Resume Jefferson City, MO - Hire IT People

SUMMARY

Programmer/Analyst or Business Analyst function with progressive challenge, responsibility and opportunity for data/applications conversion projects using Microsoft SSIS or Pervasive Data Integrator.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential, Jefferson City, MO

Business Analyst

Responsibilities:

Data Analysis and Profiling. Analyze 15 databases using Talend for Simple Statistics(Row, null, distinct, duplicates, blanks cnt).
Documented Data dictionary, Sql queries used for Data Analysis and inconsistencies.
Analysis results presented in Excel spreadsheets.

Confidential, Cedar Rapids, IA

Pervasive Developer

Responsibilities:

Mapped desired attributes per requirement using Pervasive(ETL) Map Designer
Analysis of Service ticket request for smaller issues (fields not populating, formatting etc.) with in Pervasive Process. Completed coding and testing.
Created technical documentation depicting Source/Target paths & names, version control, test results, code review
SQL queries to verify test data/results
Project Summary meeting for all ticket that passed QA for deployment

Confidential, Irving TX

Data Integration Specialist

Responsibilities:

Mapped desired attributes per requirement using Pervasive(ETL) Map Designer and loaded to database for multiple clients
Additional functionality/formatting added to attributes within Pervasive process using Pervasive's Rapid Integration Flow Language(RIFL)
Reports written using the Pervasive (RIFL language) to create load detail, counts, and totals
Pervasive Data Integrator (ETL) used to create/maintain a W2 export process whose primary functions is to create the SSA MMREF extract.
Monthly After Load verification was created within Pervasive process to calculate counts, totals for billing purposes using database as source. Process created to compare initial load data report vs database data to reveal discrepancies
SQL queries used as source/target of Pervasive Map
Worked closely with Technical Account Manager to implement Tax Law changes and enhancements.
Consult with external client regarding requirement clarification
Modify shell (.ksh) script that are called to execute Pervasive process on the Unix platform. Functionality added to create notification emails and Total Count emails
Pervasive tool used to implement medical claim format conversion for Medical Card System.
Conducted Proof of Concept for the use of Pervasive Data Integrator.
Conduct Proof of Concept Pervasive Data Profiler used to validate data based on rules and write inaccurate data for client review

Confidential, Kansas City, MO

Data Analyst

Responsibilities:

Weekly uploads of data from IDX System to SQL2000 database using Pervasive.
Enter/maintain physician information within IDX.
Monthly reporting processes automated that represents AR internally and for Corporate.
Adhoc reports request as needed Current participant in Data Migration Project to provide data from IDX system to be uploaded into eClinical Works.

Confidential, St. Joseph, MO

Office Manager

Responsibilities:

Managed Tax Office Associates for two locations, Tax Preparer training, mentoring, and staffing.
Tax return management, including verification, Holds,rejects, customer service issues and resolutions.
Daily Accounting Procedures and Office supply management.

Confidential, St, Joseph, MO

Programmer/Analyst

Responsibilities:

Added functionality to production applications.
Added password encryption software to all processes according to bank compliance standards.
Researched software packages for possible purchase.
Worked closely with Compliance Manager regarding the bank’s compliance with OFAC data matching.
Worked closely with Facilities Manager to automate manual Work order Tracking.
Data Junction/Pervasive (ETL) used to load vehicle loans data into database