We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

Oak Brook, IL

SUMMARY

  • Over 9+ years of working experience as a Business Systems Analyst with high proficiency in requirement gathering and data modelling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
  • Hands on experience in importing, cleaning, transforming, and validating data and making conclusions from the data for decision - making purposes.
  • Strong knowledge of HL7 Standards, HIX, EHR - Electronic Health Records, EMR - Electronic Medical Records, CMS regulations, Meaningful Use Compliances, Health Care Reform, EMTALA, PPO, POS and HMO.
  • Solid understanding of statistical analysis, predictive analysis, machine learning, data mining, quantitative analytics, multivariate testing, and optimization algorithms.
  • Worked on various databases Oracle, SQL server, Teradata andDB2.
  • Experienced in conducting JAD sessions with Stakeholders and Business Partners to resolve issues.
  • Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modelling Language (UML).
  • Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP).
  • Experienced with Medicare and Healthcare Insurance; as well as Medical Standards (HIPAA and HL7).
  • Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Ability to use custom SQL for complex data pulls.
  • Well versed in system analysis, ER/Dimensional Modelling, Database design and implementing RDBMS specific features.
  • Skilled in visualizing, manipulating and analysing large datasets and also has ability of designing and developing effective reports. Proficient with MS Office Applicants, Excel (Pivot Table, Vlook Up, CountIf, etc) and also experienced with Tableau, MS SQL Server,
  • Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Informatica Power Centre Experience in testing, data validation and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modelling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modelling.
  • Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
  • Highly skilled in Tableau Desktop for data visualization, Reporting and Analysis, Cross Map, Scatter Plots, Pie Charts and Bar Charts, Page Trails and Density Chart.
  • Experience with data warehousing techniques like Slowly Changing Dimensions, Surrogate key, Snow flaking etc. Worked with Star Schema, Data Models, E-R diagrams and Physical data Models.
  • Extensive knowledge on Data Profiling using Informatica Developer tool.
  • Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re-usable transformations, Mapplets and PL/SQL stored procedures
  • Experience in Data warehousing, Data Architecture &Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Centre.
  • Profound knowledge of Data modelling including Star Schema and Snowflake Dimensional Data modelling, 3NF Normalized Data Modelling. Very good understanding of Logical Modelling and Fine-tuned Physical Data Modelling.
  • Worked on Tableau and created adhoc reports and dashboards.
  • Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing the issues.
  • Worked in creating different Visualizations in Tableau using Bar charts, Line charts, Pie charts, Maps, Scatter Plot charts, Heat maps and Table reports.
  • Involved in Design of the Enterprise Data Visualization Architecture. Defined best practices for Tableau report development.
  • Expert knowledge of UNIX Shell Scripting and understanding of PERL & Korn scripting.
  • Worked on creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
  • Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, MS Access, Flat files into a staging area.
  • Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
  • Extensive experience in creating data scope and requirements. Strong expertise in understanding various data sources.
  • Experience working with data analysis tools for data lineage, metadata, and data profiling
  • Proficient in working with senior executives and multiple stakeholders to understand key data issues and identifying their resolution.
  • Extensive experience in developing Unit, Integration and UAT Test plans and Cases and also has experience in generating/executing SQL Test Scripts and Test results.

PROFESSIONAL EXPERIENCE

Sr. Business Systems Analyst

Confidential, Oak Brook, IL

Responsibilities:

  • Worked on data extraction using various queries/formulas, manipulate using various analytical tools to create reports.
  • Worked on various reports using reporting tools like Tableau and MS excel to forecast the growth of various KPI.
  • Worked independently to store, organize and collaborate numerical data and business objects to initiate analysis that enhance the understanding of our client's current customer base which can be leveraged to generate future business opportunities.
  • Analyse and creating reports to evaluate inventory data and makes recommendations to enhance processes in pharmacy operations.
  • Create web forms that feed directly to Sales Cloud or Marketing Cloud.
  • Worked along the SME for Data Governance on current Common Data Model Project.
  • Worked with data governance teams to create and maintain documentation related to Metadata and data dictionaries of different kinds of data.
  • Developed HL7 messaging for bi-directional case and disease report exchange, in HTML and XML formats, in accordance with HL7 specifications.
  • Extract data on request from customers and business partners using SQL and translate results into various formats, including Excel, Crystal Reports and SSRS.
  • Involved in creating Ad-hoc reports by data analysis using MS-Access via ODBC or TOAD for data import and SQL analysis of reconciling data from the call centre and stores across USA.
  • Work with team on core operational processes and uses of Sales Cloud and Marketing Cloud.
  • Involved in developing SQL and VBA (ADO) automated processes to access and clean externally and internally generated data and making that data usable for analysis and project trackers.
  • Established Data Management Office and Chair Data Governance and Business Intelligence councils implemented global Data Governance, Data Stewardship and Data Quality monitoring processes, standards, policies and executive reporting dashboards.
  • Functional testing of the application was performed as per the necessary changes and identified bugs during the test phase and reported them using ALM.
  • Involved in creating functional specification documents based on RBC data feed requirements to be on-boarded onto the Cosmos platform.
  • Involved in intensive system level testing of analysing the HL7 messages coming out and in of EPIC Bridges
  • Responsible for the mainframes that receive the HL7 message in pre-approved format from the middleware as disclosed in the documentation
  • Worked on creating mappings between Transcend (Cosmos) data feed requirements and RBC source data feeds.
  • Involved in Legacy Application Developments, SAP Implementations, Country rollouts, M&A assignments, continues improvements, enhancements, server consolidations, upgrades and Tools development.
  • Worked on implementing enhancements over the existing reports to improve user experience.
  • Involved in writing, Queries to retrieve data from ODS to analyse relationships and supported in building the Data Model.
  • Utilized Power Query and Excel Power BI to pivot the data model for data cleansing.
  • Identified the key facts and dimensions necessary to support the business requirements to develop the logical dimensional models.
  • Performing detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of SFDC and other Platform based technologies like Visualforce, Force.com API and Web Services (Soap/Rest).
  • Involved in design and conversion of business requirements to Conceptual Data Model, logical Data Model and Physical Data Model for subject areas.
  • Involved in creating the Gap analysis document by analysing the as is process and understanding the future need.
  • Involved in creating a logical design and physical design in Erwin.
  • Used Reverse Engineering and Forward Engineering techniques on databases and created tables and models in data mart, data warehouse and staging.
  • Work with clients to establish eligibility data exchange and write data mapping specifications for custom file layouts. Includes testing eligibility data files with vendors, defining profiles and documenting procedures
  • Worked with testing team and performed UAT on the application.
  • Worked on Test Plans and Test Execution Procedure Document based on the Business & Functional Requirement Document and numerous Test Cases and Test Scenarios to cover overall aspect of quality assurance.

Business Systems Analyst

Confidential - Austin, TX

Responsibilities:

  • Involved in gathering, analysing and documenting business and technical requirements from both formal and informal sessions and validated the needs of the business stakeholders.
  • Interacted with client to assess needs, identify key challenges and define project scope and deliverables.
  • Worked on Facets (Frontend/Backend) and reporting using SSRS (Daily, Monthly, Quarterly, Yearly) within Data warehousing.
  • Involved in generating daily/weekly/monthly dashboards and reports from various BI sources for readouts and reporting to the Business and IT Leadership.
  • Involved in user interviews and documented business and functional requirements.
  • Worked on requirement analysis and developed use cases and activity diagrams using Rational Rose.
  • Worked on Excel Reporting using SQL in the HPQC Dashboard.
  • Involved in developing UML use cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
  • Gained knowledge of Software Development Life Cycle SDLC methodology such as Agile, Waterfall and RUP.
  • Involved in JAD sessions to identify the business flows and determined whether any current or proposed systems were impacted by the EDI X12 Transaction, code set and identifier aspects of HIPAA.
  • Validated the reports and files according to HIPAA X12 enforced standards. Identify issues, related to claims processing issues that impact encounters.
  • Involved in performing data mapping and logical data modelling and created class and ER diagrams.
  • Knowledge and experience in implementation of HIPAA, NCPDP, HL7, CDA, CCD, FHIR and other transactional standards.
  • Involved in creating Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
  • Performed numerous data pulling requests using SQL for analysis.
  • Involved in intensive system level testing of analysing the HL7 messages coming out and in of EPIC Bridges
  • Responsible for the mainframes that receive the HL7 message in pre-approved format from the middleware as disclosed in the documentation.
  • Actively involved in database querying, HL7 mapping and HL7 data interface testing.
  • Involved in creating and maintaining data model/architecture standards, including master data management (MDM).
  • Worked with ETL teams to deliver the reporting layer composed of the highly tuned and aggregated tables designed from the base tables.
  • Involved in writing DDL scripts to create tables and views in the company Data Warehouse.
  • Involved in importing/exporting large amounts of data from files to Oracle/Teradata and vice versa.
  • Worked on business requirements into user stories and tasks for agile BI projects. Create a more efficient process for project delivery using JIRA and Confluence.
  • Involved in creating stories using Version One, JIRA Scrum and Kanban boards. Daily stand-ups, Planning, Retrospect, Velocity reports, Sprint summary.
  • Worked on automate reporting processes utilizing SSIS, Power BI and SQL Server scheduled Jobs.
  • Worked on Data Manipulation and Data Validation using SQL queries in a MS SQL Server.
  • Good Experience in Business Analysis and Business Modelling methodologies and Iterative Software Development Life Cycle (SDLC) using Agile, waterfall and Rational Unified Process (RUP).
  • Involved in creating business requirement documents and functional require document and developed test plans.
  • Worked on designing a claim processing system for the healthcare management client system. It allowed the user to inexpensively capture information regarding patient, summary of medical history, symptoms (ICD-10 codes), and treatment (CPT).
  • Involved in designing and developing use cases, activity and sequence diagrams, OOAD using UML and business process modelling.
  • Worked with all the phases of software development life cycle (SDLC) methodologies throughout the project life cycle.
  • Worked on business processes and modelling diagrams using Rational Unified Process (RUP).
  • Worked on use case scenarios and documented workflow and business process using Rational Rose.
  • Worked on requirements, associated change requests with requirements and connected requirements with use cases.
  • Incorporated Rational Unified Process (RUP) to create requirement document specifications using Visible Analyst.
  • Performed extensive data modelling to differentiate between the OLTP and data warehouse data models.
  • Involved in creating test scenarios and scripted test cases using testing tool and defect management for policy management systems, payables/receivables and claims processing.
  • Worked on managing system requirements between the business and the software development team.
  • Involved in gap analysis, user acceptance testing (UAT), cost benefit analysis and ROI analysis.
  • Involved in writing test cases and test scripts for the user acceptance testing.

Business Data Analyst

Confidential - Louisville, KY

Responsibilities:

  • Worked on Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Worked on performing technical analysis for 834 (EDI file for Enrolment and Benefits Maintenance)
  • Involved in creating Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
  • Performed numerous data pulling requests using SQL for analysis.
  • Involved in creating and maintaining data model/architecture standards, including master data management (MDM).
  • Worked with ETL teams to deliver the reporting layer composed of the highly tuned and aggregated tables designed from the base tables.
  • Involved in writing DDL scripts to create tables and views in the company Data Warehouse.
  • Involved in Performance Tuning and Optimization for increasing the efficiency of the scripts.
  • Involved in designing and developing Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.
  • Used Joins like Inner Join, Outer join while creating tables from multiple tables.
  • Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
  • Proficient working in loading data into staging tables via views.
  • Involved in creating daily and monthly reports using SQL and UNIX for Business Analysis.
  • Involved in generating graphs using MS Excel Pivot tables.
  • Worked on creating the POC and prototype Tableau reports and dashboards with the key metrics.
  • Worked on documentation of scripts, specifications, other processes and preparation of Technical Design Documents.
  • Analysed web analytics data using Google Analytics and optimized website content which led to a significant decrease in bounce rates and improvement in conversions.
  • Worked on project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
  • Involved in extracting data from existing data source, Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Excel.
  • Analysed data quality issues against source system and prepared a data quality document confirming all the source data quality.
  • Used MS Office suite (Word, Excel, Access, Visio, Power Point), for project tracking, documentation and presentation.
  • Worked with the QA team for designing Test Plan and Test Cases for the User Acceptance testing (UAT).
  • Performed Manual Testing and Involved in Functional, Black box, Usability and Regression Testing for UAT (User Acceptance Testing) and SIT (System Integration Testing).

Business Systems Analyst

Confidential - Chicago, IL

Responsibilities:

  • Involved in gathering high-level requirement for all the external projects in a release.
  • Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
  • Worked on requirements for business process flow and on-screen flow for wizards driven products from products SME's and Salespeople and created Requirements documents to implement in Pega PRPC.
  • Worked on Business Rules Document and Requirement Traceability Matrix to track the requirements for Pega PRPC.
  • Communicate with Customer Service on ACORD Forms design and other technical problems.
  • Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
  • Involved in developing Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
  • Used MS Office (Word, Excel, Visio, and Power Point) for calculations, graphs, analysis, documentation and presentation throughout the project.
  • Worked extensively with MS Excel and MS access.
  • Assigned tasks among development team, monitored and tracked progress of project following agile methodology.
  • Involved in JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
  • Involved in creating UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
  • Involved in reviewing test results and coordinated with testing and development team to correct the issues.
  • Involved in developing timelines for project delivery, and managed projects/resources.
  • Worked on business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.
  • Involved in preparing Business Requirement Document (BRD) and then translating into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
  • Worked on documenting and delivering Functional Specification Document to the project team.
  • Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
  • Interacting with the developers on resolving the reported bugs and various technical issues.
  • Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.
  • Worked on developing test plans with QA team and helped to develop test cases for system testing, Integration testing and performance testing.

Data Analyst

Confidential - Madison, WI

Responsibilities:

  • Involved in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Worked on business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Centre.
  • Involved in data governance, defined data mapping from source to target (for all the three heritages).
  • Involved in gathering metadata and created data analysis repository (spreadsheet), which includes following metadata information: data source, hierarchy, fact, dimension, data attribute, data integration, data model, data acquisition etc.
  • Worked collaboratively with multiple business entities and successfully implemented new business processes and established data governance.
  • Involved with data quality and data governance solutions including platforms and supporting data processes.
  • Worked on estimates, project plans (Microsoft project), training material, BI reports using Micro strategy.
  • Involved in defining data requirements and elements used in XML transactions.
  • Worked on Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2008 environment.
  • Involved in Data Validation with Data profiling.
  • Worked on report generation using SAS/Macros as per the requirements.
  • Involved in the testing of Data Mart using Power Centre.
  • Involved in documenting additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
  • Used Informatica Power Centre for Extraction, Transformation and Loading process.
  • Tested several ETL Mappings developed using Informatica.
  • Involved in performing Data Cleansing, data aggregation, Data Scrubbing during the ETL's Extraction and Loading Phase by analysing the raw data and writing SAS and SQL queries and creating complex reusable Macros.
  • Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
  • Involved in GAP analysis on the traditional claims system and newly integrated Policy Centre and carefully elaborated application enhancement specifications detailing in scope/out of scope items, as-is/to-be process maps and critical test scenarios.
  • Worked on different Data mapping activities from Source systems to Teradata.
  • Worked on cost estimation and timelines for various Business Intelligence reports.
  • Involved in Developing, Debugging, and validating the project-specific SAS programs to generate derived SAS datasets, codebooks, summary tables, and data listings according to departmental standards.
  • Worked on tasks performed by other team members and involved in data validation and data cleaning in all phases of Survey studies.
  • Worked on Unit testing for all reports and packages.
  • Involved in preparing Test Strategy, Test Plan, test report and Gap Report.
  • Performed UAT based on Requirements Document and prepared the Test Cases using Quality Centre.