We provide IT Staff Augmentation Services!

Business Systems Analyst (consultant) Resume

Lancaster, PA

SUMMARY:

  • Worked very closely with customers, end users and power users collect to requirements using agile methods and training or resolve any business process related issues.
  • Excellent communication, analytical and interpersonal skills.
  • Versatile team player with proven problem - solving skills and ability to quickly learn modern technologies.
  • Apply Machine Learning Algorithm for Business Analytics Example Time Series analysis using Arima, Decision tree, Random Forrest, Cluster/Segmentation analysis
  • Using Python, SAS, and R to create predictive and descriptive data analysis.
  • Intermediate Statistical Knowledge for data analysis.
  • Created Source to Target Mapping using different data sources.
  • Created and Assisted Data modeling using conceptual, logical, and physical modeling.
  • Using CRISP-DM methodology to mine and extract data.
  • Proficient in Transact-SQL development which includes creating complex business stored procedures, tables, cursors, views, triggers and functions.
  • Knowledge of querying No-SQL database MongoDB.
  • Proficient in creating sub-queries and joins for complex queries involving multiple tables and exception handlers.
  • SSRS reporting - creating functional reports for business units.
  • Developed and deployed Business Objects Reports using SAP Crystal Reports.
  • Proficient in writing parameterized queries for generating tabular reports and sub reports using global variables, expressions, and functions, sorting the data, defining data sources and subtotals for the reports using SSRS.
  • Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files, JSON files using connectors, tasks and transformations provided by Integration services(SSIS).
  • Prepared test cases and UAT sessions.

TECHNICAL SKILLS:

  • Combined 10 years of experience in the following technologies: Visual Studio, C#.net, VB.net, SSMS, SSIS, SSRS, ASP.net, HTML, CSS, PHP, MYSQL, Python, R Programming, SAS Programming, SAP Business Objects
  • Software Used: TOAD, Microsoft Team Foundation for source control, HP ALM and HP Quality Center, ChangeGear, IDX GE Business Centricity, Facets, Plexis Claims Manager and Quantum Choice, Other Proprietary systems, Excel Pivot, VLOOKUP, Macros, Access, outlook, Lotus Notes, Tableau, SAS Analytics,

PROFESSIONAL EXPERIENCE:

Confidential, Lancaster, PA

Business Systems Analyst (Consultant)

Responsibilities:
  • Data Discovery project analyzing data needs for CareTend Implementation.
  • Provide System analysis of CPR+ Software.
  • Assist Clinical and Pharmacy team with daily reports.
  • Create Pharmacy dashboard for specialty drugs under the direction of Pharmacy Director.
  • Maintain CPR+ ICD 10 tables for new ICD 10 codes updates
  • Developed a conceptual data model for data warehouse project.
  • Created ETL process for loading data into Data Warehouse using SSIS.
  • Created a Data flow maps to identify data integration needs.
  • Provide database support for CPR+ example back up of data and restore.
  • Data profiling to determine data accuracy.
  • Performed data cleansing techniques to prepare data for warehouse storage.
  • Ad Hoc Tableau Report development.
  • Create and Maintain reports in Business Objects using SAP Crystal Report.
  • Extensive T-SQL query for data analysis using Python and R.

Confidential

Data Analyst

Responsibilities:
  • Data Discovery project analyzing data needs for new application.
  • Prepare Source to Target mapping with various source files example Flat files, JSON, XML and DBMS sources includes VSAM files from mainframe.
  • Created a Time Series analysis using ARIMA to predict future outcome.
  • Created Machine Learning Algorithm such as Decision Tree, Random Forrest, and Segmentation/Cluster Analysis using K Means, Descriptive analysis and Exploratory Analysis.
  • Assisted Marketing initiatives using data to implement a robust incentive system.
  • Assisted Data Architect in gathering data requirements for Incentive System data discovery.
  • Developed a conceptual data model for salesforce solution.
  • Data profiling to determine data accuracy.
  • Performed data cleansing techniques to prepare data for salesforce consumption.
  • Using Python to create predictive models for Incentive programs, example of models Decision Trees, Logistic Regression and Random Forrest.
  • Extensive Ad hoc queries in Oracle and SQL Server environment.
  • Performed simple NoSQL queries using MongoDB.
  • Analysis of data integration example: integration of data with other systems such Lawson.
  • Ad Hoc Tableau Report development.
  • Create and Maintain reports in Business Objects using SAP Crystal Report.
  • Extensive T-SQL query for data analysis using Python, R, and SAS Procedures.

Confidential,Miami, FL

Data Analyst - Business Intelligence (Consultant)

Responsibilities:
  • Review, create and analyze Business Requirement Documents for proposed BI solutions.
  • Responsible for Database and Data warehouse (data mart) design assisting data architect.
  • Data mapping and integration from different data sources.
  • Using Python Jupyter notebooks created statistical data analysis.
  • Extensive T-SQL querying for data analysis and root cause analysis on issues.
  • Coordinates, manages and participates in complex testing efforts.
  • Create Ad-hoc Reports using SSRS and deploy into SharePoint site.
  • Create Departmental BI Application for department’s use.
  • Deploy BI Solution into SharePoint or Report Server.
  • Train users on newly deployed BI Solution.
  • Troubleshoot issues with BI Solution.
  • Crystal Reports Conversion to SSRS.
  • Design SQL SSIS Packages Using Visual Studio Data Tools, to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2014 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Create and Maintain Dashboards using Tableau.

Confidential,Miami, FL

IT Systems Analyst - Production Support (Consultant)

Responsibilities:
  • SQL Development for minor issues.
  • Code Review and Code deployment.
  • Provides strategic advice for business processes and solutions.
  • Extensive T-SQL querying for data analysis and root cause analysis on issues.
  • Participate on Code Release management meetings.
  • Work closely with development team for business process analysis and system designs.
  • Manage the day to day workload from Incident reporting to Request for Change.
  • Triage and Assign Incident tickets to the proper areas.
  • Coordinate the QA process, unit testing, regression testing and business analysis as directed by upper management.
  • Manage testing activities for project and maintenance assignments.
  • Provide guidance for testing strategies, scope and scenarios.
  • Review and provide advice for testing-related estimates of effort, duration and resource utilization. Prepare and reviews test plans; identifies testing risks and contributes to the overall management of project and risk and mitigation plans.
  • Coordinates, manages and participates in complex testing efforts.
  • Create Ad-hoc Reports using SSRS and deploy into SharePoint site.

Confidential, Boca Raton, FL

Business Analyst

Responsibilities:
  • Used Complex T-SQL queries to update, delete, and insert Benefit data.
  • Updated Eligibility issues using requirements from the business (T-SQL update).
  • Developed and designed reports for business use.
  • Implemented KPIs for Claims Department (SSRS).
  • Created financial reports to determined Provider Overpayment (SSRS ad hoc report).
  • Support EDI data mapping implementation of the 834 file format.
  • SSIS Packages to update Medical Fee Schedules, CPT, HCPCS tables and ICD10/ICD9 codes into database objects.
  • Gathered user requirements for BI solutions.
  • Supported Plexis Claims System Back end tables, example creating triggers, views, and modifying stored procedures.
  • Configuration of Claims System.
  • Assisted in the Configuration of provider contracts.
  • Assisted in the implementation of Vistar Evips software for credentialing.
  • Source to Target Mapping MS Access data for Evips Implementation.
  • Followed HIPAA requirements to protect personal data.
  • Documentation of BI Solution.
  • Trained business users to Access BI Solution.
  • Created Subscription in SSRS report server.
  • Prepared and executed Test Cases.
  • Prepared claims utilization reports for upper management.
  • Performed Claims Cost Analysis to determine financial impact on issues Identified.

Hire Now