Business Analyst Resume , NJ - Hire IT People

PROFESSIONAL SUMMARY

Data Scientist wif a background in big data analysis and data visualization. Experienced in SQL, Python, Tableau, VBA & HTML.
Proven technical and leadership abilities in data warehousing and data management environments. Excels at data visualization wif Tableau, Business Objects.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential, NJ

Responsibilities:

Created User Stories and Tasks for above two projects and broke them down into smaller sprints according to SCRUM methodology for ALAE including Include, Exclude, Reimburse, Flat-Fee, and Pro-Rata Daily and Monthly, respectively.
Created Acceptance Criteria for ALAE and Garage Keepers Liability.
Queried policy and claims-related data in SQL section of WINS accounting system.
Performed analysis of discrepancies in claim-related periodic data wif SQL downloads into Excel using pivot tables and other data-related features.
Uploaded all work and kept track using Jira.
Ran algorithms in Python and used Tableau to visualize data.

Sr. Business Analyst/Data Analyst

Confidential -Montebello, NY

Responsibilities:

Generated Python-based algorithms of Excel csv’s of loan loss-related data.
Imported data sets into SAS and created ODS (Output Delivery System) analysis of data that was manipulated of debtor information.
Constructed reports in R Language of different source system-related information.
Tableau was utilized to produce dashboards of debtor data by different buckets.
Created use cases and activity diagrams of workflow that consisted of various sources of loan information that would feed into main database: Impairment Studio. Exposed to such source systems as ABL(Asset Based Lending), CBR(Letters of Credit), INF (Equipment Finance Loans), LN (Signature), NVA (NovaCS Factoring), WL (Warehouse Lending), TMP (Payroll Finance), LIQ (Loan IQ), MCC (McCracken), DMI (Residential Loans), and ADV (Advantage Portfolio), respectively.
Utilized SQL Server by running queries to find errors in Loan Trial Balance table to help rectify them so that bank TEMPhas latest correct data for greater granularity and audit compliance.

Business Analyst

Confidential

Responsibilities:

Created both data sourcing and functional controls according to BCBS 239 Principals.
Wrote Data sourcing controls whose purpose was to match similar bucket names wif different feed names.
Located bucket names for all of teh above controls in Toad 12.6 RDBMS by running SQL queries.
Made data frames in Python-based pandas and jupyter notebook.
Created dashboards of loss reserves in Tableau.