We provide IT Staff Augmentation Services!

Business Systems Analyst  Resume

Atlanta, GA

SUMMARY:

  • Over 15 plus years in IT industry as a Business Techno/Functional Analyst working within an Agile/Scrum, SDLC environment.
  • Within various platforms such as: Informatica MDM, Teradata, Oracle 8, 9 and 10i, & 11g, 12, MS SQL Server 2005, 2008, 2010, Siebel BRM & CRM

TECHNICAL SKILLS:

Application Software: Visual Paradigm for UML, Epic Clarity (Healthcare Tapestry Application and Reporting Workbench), Teradata Sql Assistant 7.1, Crystal Reports Versions 8, 9, 10 and 11, and 12, SharePoint Designer 2007, Incentive v3 CRM Sales Compensation Database, SQL, SQL*Plus, SQL Loader and Oracle Enterprise Manager Toolset, SQL Server Enterprise Manager, Lotus Notes, SAP R/3, Microsoft Access, JD Edwards(ERP system), PeopleSoft 8, HL7, Horizon HealthCare Patient Folder, Horizon Electronic Patient Folder Workstation (McKesson Health Care Applications)

PROFESSIONAL EXPERIENCE:

Confidential,Columbus,Ga

Business Techno/Functional Analyst

Responsibilities:

  • Serves as liaison between the business partners and IT to provide technical solutions to meet user needs and maintain established business relationships.
  • Experienced in working in fast - paced Agile/Scrum environment, software development lifecycle (SDLC)
  • Lead the collection, analysis, and documentation of functional business requirements, business processes as well as the business design of functional solutions.
  • Assess near-term needs using a structured requirement process to recommend business priorities and advises clients of options, risks, and costs vs. benefits
  • Works closely with QA testing team to write appropriate User Stories for acceptance testing scripts
  • Work closely with MDM Informatica Architects and Data Warehouse Architects to fully understand and “read” ETL processes and process flows for business requirements, understand the business rules that are coded within the ETL load processes.
  • Write SQL statements to query databases to double check that load processes have full populated database tables and fields.
  • Participates in identifying opportunities that impact business strategy and performance issues
  • Leads the development, writing, and communication of business requirements for the design and implementation of business solutions for initiatives with high visibility
  • Leads in the development of project deliverables, such as requirements and interface specifications, business architecture models, business processes, functional and non-functional requirements in the form of use-cases, user stories, business scenario specifications
  • Conducts systems analysis with a focus on business process models and use cases
  • Collects research on the competition in terms of best practices, business processes, and procedures; pays particular attention to market strategies and product development makes recommendations for buy vs. build decisions
  • Performs other related duties as required

Confidential,Alpharetta, Ga

Epic Clarity ReportWriter

Responsibilities:
  • Extracted data from Epic Clarity Database to created SQL command to build into Crystal Report and or Tableau or QlikSense Environment
  • Types of Reports: Predictive Reports, Forecasting Reports, Revenue Cycle Reports, Claims, Inpatient/Outpatient Reports, Utilized Reporting Workbench for “Real-time” Reporting
  • Worked as a Liaison between Business and IT gathering business requirements in Use Case and User Story style for reporting purposes
  • Documented and reviewed data mapping between Source to Target systems
  • Monitored and refined dashboards and reports, worked with business members to ensure solutions are adopted and fully leveraged according to Data Governance and business rules

Confidential,Dunwoody, Ga

BI Business Solutions Architect

Responsibilities:
  • Implementation of Informatica MDM master data, worked with Enterprise Architects, Solutions Architects, and Database Developers for implementation of MDM across all databases.
  • Created Schema, Conceptual, Logical and Physical Data Models in Customer Master Data, CRM, BRM systems
  • Developed dashboards and reports utilizing either Tableau, OBIEE, Google Analytics
  • Ability to read and test code in: HTML, javascript, application programming interfaces to check for inconsistencies of data within websites.
  • Documented and reviewed data mapping between systems
  • Translate business requirements and use cases into system requirements documents
  • Facilitate meeting sessions with both technical and business participants
  • Support Solution Architects in creating solution designs
  • Work with system SMEs on preparing system specification documents
  • Communicate system specifications to development teams and provide support throughout the implementation processes
  • Experienced in working in fast-paced Agile/Scrum environment, software development lifecycle (SDLC)
  • Support testing teams in preparation of testing plans and investigation of erroneous outcomes
  • Perform root-cause analysis of production issues
  • Support multiple initiatives simultaneously
  • Queried data using databases in a business environment with complex data sets
  • Utilized Informatica IDQ for Data Profiling, duplication of addresses, customer names, etc.
  • Analyzed flat file imports for standardization and data integrity
  • Sampled and compared data within new and existing subject areas
  • Assisted in performance testing on new or existing deliverables
  • Developed an understanding of the current end-to-end BI platform architecture to help support deployed solutions
  • Monitored and refined dashboards and reports, worked with business members to ensure solutions are adopted and full leveraged
  • Created UAT Testing scripts and Test Cases
  • Gather functional requirements and business case, define scope, and specifications for development
  • Provided data for analysis by operations staff, internal executable level and/or outside partners as needed
  • Worked with database administrators and architects to improve overall performance and eliminate report/query redundancies and bottle necks.

Confidential,Atlanta, GA

Senior Business Systems Analyst

Responsibilities:
  • Interfaced with executives, senior management, and clients within and outside the organization.
  • Utilized such tools such as QlikView and Tableau Analytics tool to isolate company’s data quality issues and then set business rules around these issues.
  • Responsible for system testing and assisting in the client’s user acceptance testing (UAT).
  • Responsible for leveraging and transitioning fully implemented projects to the client services team for long term implementation support
  • Acted as Liaison between Business and IT Partners across multiple business functions to align Business Intelligence technology solutions with business strategies
  • Lead JAD sessions to gather and document technical solutions for Business gave presented further findings to IT staff to implement
  • Assisted the Business with day to day processing of data and delivery of information from within the Data warehouse (source systems) to Oracle and SAP Master databases for Customer, Claims and Policy database information.
  • Created Schema, Conceptual, Logical and Physical Data Models
  • Responsible for the collection, analysis, design and documentation of functional requirements.
  • Created regression and unit test scripts for any and all new BI dashboards, scorecards, and reporting brought into production environment
  • Developed a strong understanding of change control and data governance for requirement artifacts.
  • Provided Subject Matter Expertise in one or more core functional areas
  • Utilized SQL or Oracle Database 2010 to create forms, queried database to create reports for Business Users to use for everyday processes.
  • Utilized SQL to resolve data processing errors and batch processing errors

Confidential,Marietta, GA

Senior Teradata Analyst

Responsibilities:
  • Acted as Liaison between Business and IT partners across multiple business functions to align technology solutions with business strategies.
  • Responsible for creating Test Scripts for Integration testing from one platform to another, utilizing HP ALM Quality Center
  • Assisted the Business with day to day processing of data and delivery of information within Micro-Strategy database for Coca- Confidential Bottler information.
  • Responsible for the collection, analysis, design and documentation of functional requirements.
  • Coordinated and prioritized all escalated activities, including testing, project management and implementation of system upgrades, enhancements, and bug fixes.
  • Queried databases did inserts, updates and deletes. Examined and reconfigured Store procedures. Modified existing code to stored procedures and Views
  • Documented the alignment of data distribution thru gap analysis, ERD diagrams,
  • Physical and logical data modeling documentation.
  • Created SQL statements to troubleshoot any data processing and/or batch issues

Confidential,Alpharetta, GA

Senior Business Systems Analyst

Responsibilities:
  • Liaison with External and Internal business partners across multiple business functions to align technology solutions with business strategies.
  • Supported one or more highly complex Master data processes, requiring design or integration of technical solutions that may cross multiple functions of the business and backend data source systems.
  • Created dashboards or reports for Stakeholders, Executives, Operational Center
  • Leads project team members through the process of developing and maintaining requirements from analysis to deployment.
  • Responsible for the collection, analysis, design and documentation of functional requirements.
  • Presents business and functional requirements documentation for review and sign-off.
  • Developed a strong understanding of change control and data governance for requirement artifacts.
  • Coordinates feasibility studies and proposals for evaluation by appropriate users and managers.
  • Created Schema, Conceptual, Logical and Physical Data Models
  • May assist in the RFP process by preparing the technology requirements documentation and participating in the evaluation and selection of products/services. Investigates, resolves and escalates problems.
  • Worked alongside with DBA’s and plotted out Data Mapping from source to destination

Confidential, Atlanta, GA

Senior BI Analyst

Responsibilities:
  • Provided Subject Matter Expertise in one or more core functional areas
  • Application support in (Message Processing, Mediations, Provisioning, Billing, Web, Middleware, Retail Activation Systems, Payment Processing)
  • Participated with both the architectural and development design teams to thoroughly understand data issues involved in daily load processes.
  • Protected and insured the stability of the operational systems as well as maintain the integrity of the data they contain.
  • Understood the whole ETL processes and data governances involving the movement of data from source to destination.
  • Coordinated and prioritized all escalated activities, including testing, project management and implementation of system upgrades, enhancements, and bug fixes.
  • Maintained cross-business responsibilities by providing end-user support to multiple organizations within the company when issues arise
  • Frequented interaction with the business to integrate knowledge of the business and functional priorities.
  • Assisted in determining the impact of operational issues and provide input into their resolution via data extraction and quantification.
  • Availability to provide 24 X7 support as required
  • Worked in an Oracle, Sql Server OLAP, and Unix environment utilizing command line and GUI SQL tools.
  • Also provided expertise in Sarbanes Oxley and Change Management and Methodologies.
  • Created Schema, Conceptual, Logical and Physical Data Models
  • Ability to Forecast and plan for supporting both applications functionality and capacity requirements in a rapidly growing, changing and complex environment.

Confidential,Atlanta, GA

Senior BI Analyst

Responsibilities:
  • Queried databases did inserts, updates and deletes. Examined and reconfigured Store procedures, added new codes to stored procedures.
  • Utilized Tableau Reporting tool to streamline data quality issues and gaps in data, to help drive business rules needed to change processes in data flows or workflows
  • Helped resolved application issues, management of revenue cycle data from client extraction uploads, transforming using STRM and third party tools, and load into STRM system to achieve maximum client satisfaction.
  • Provide Business Analytic and real time solutions and access to Key Performance metrics that enable healthcare organizations to identify and manage opportunities to maximize financial performance.
  • Organizes, sorts, and filters data in order to distinguish patterns and recognize trends.
  • Works with Project Team so solve Client Business needs
  • Worked tickets, troubleshooting application and or database issues.
  • Analyzes the client extracted data, maps, and integrates the disparate data using proven Sql Server 2010 methodology.
  • Validates that all functions perform according to the relevant specifications.
  • Identifies solutions to non-standard requests and issues.
  • Conducts moderately complex analyses and solves moderately complex issues.
  • Establishes team standards and templates to ensure consistency and supportability of solutions, as a team.
  • Works with all team members to gain insight to the business need(s) and draws upon all skills/subject matter experts to ensure the solution corresponds with the team focus and direction.

Confidential,Alpharetta, GA

Senior BI Analyst

Responsibilities:
  • Design and develop OBIEE user interface objects (e.g. reports, dashboards, etc.)
  • Design and develop OBIEE metadata/logical data models
  • Utilized TOAD to Query data in Oracle 11g database environment
  • Translate BI requirements into analytic BI subject areas
  • Determine requirements for aggregate tables
  • Worked with customers and business Architects to understand and develop reporting and BI requirements.
  • Actively participate in design and analysis sessions to ensure sound team decision-making
  • Support system and user acceptance testing activities, including issue resolution.
  • Complete technical documentation to ensure system is fully documented
  • Mentor and train IT staff by sharing best practices and lessons learned from past implementation efforts
  • Converted all reports in Scout Application to OBIEE Reports and Dashboards.
  • Managed tickets and work orders queued in Remedy Ticketing Systems to ensure that customers receive regular updates and optimum support.
  • Wrote queries to perform data quality checks after ETL process was kicked off to ensure tables and fields were populated accordingly
  • Demonstrated good phone skills, professional courteous demeanor, and a friendly helpful attitude
  • Acquired good sound problem solving, prioritization, and time management skills
  • Ability to work with technical and user staff in a technical role on their projects
  • Was a liaison between the Business Services Group, Service Desk Support and the Business Application Services support team.
  • Demonstrated excellent business judgment in relation to business value to drive effective prioritization decisions
  • Utilized Microsoft Squirrel to running queries in database environment and create some views within database as well.
  • Moved Dashboards, Graphs and Charts to SharePoint Designer 2007 so Business Users and Stakeholders to view and run reports.

Confidential,Atlanta, GA

Data Governance Analyst

Responsibilities:
  • Act as a Liaison between Business and Technical staff gathering requirements for Business Intelligence queries and reports, ensuring proper usage, data quality and security of the information provided by Business Users.
  • Created Ad hoc and specialized reports for Business Users utilizing such tools as TOAD, Business Objects XI and Crystal Reports 10 and moved this reports to SharePoint Designer 2007 for viewing.
  • Created Functional and Technical business requirements for purposes of testing flow of data from Data Warehouse to Interfaces to Application to actual report itself.
  • Recommended business solutions that satisfy sponsor/stakeholder needs continually exploring and assessing options for value-add for clients
  • Creation of Data Flow charts, mapping of data from resource to destination.
  • Responsible for monitoring daily log feeds from financial systems checking for errors in batch flow processes.
  • Estimate activities required to perform requirements gathering and acceptance testing improving accuracy over time
  • Research and document sponsor/stakeholder needs in accordance with Project Life Cycle methodology utilizing reporting tools, requirements gathering methodologies, process models, data models and prototypes
  • Responsible for simplifying and standardizing business processes and IT department solutions.
  • Cross-functional support role that interfaces with multiple departments and locations within client’s environment.
  • Provided support and maintenance including end-user support, service incidents/problem resolution, and system support process which include daily job monitoring, coordination with other IT teams and communication with impacted users.
  • Assisted in troubleshooting and solving SAP BI/BW related issues.
  • SAP Supply chain modules * MM, WM, IM, Purchasing, PP, BW, SRM
  • Planned and executed unit, string testing, integration, cutover and acceptance testing to support system initiatives.
  • Provided solutions in SAP BI for end users by helping with enterprise information analysis and design, work with data team to execute design with SAP.
  • Created complex SQL statements to check data integrity within tables and fields.
  • Utilized BO to create reports and dashboards for Business Users and Key Stake Holders.

Confidential, Norcross, GA

Senior BI Analyst

Responsibilities:
  • Interviewed and gathered Business Rules and KPI’s from Service Providers ensuring appropriate governance’s and policies are in place for creation of reports.
  • Created Queries from scratch in Access Database in preparation for Reports Development.
  • Heavily utilized Excel Charts and Pivots Table and Access Database for creation of Director’s Reports.
  • Created Power Point presentation of Reports for distribution to Directors, Service Level Providers and Service Managers.
  • Types of Reports created: Incident Management, Incident Volume, Incident Duration, and Time to Incident Engagement, Time to Incident Restoration, Impact Duration, Service Desk, Mainframe Outages, and Change Management etc.
  • Daily Data Entry of Incident Level outages and updating of Excel Spreadsheets for further data analysis.
  • Data Mapping of Remedy Ticketing to backend Oracle 11g databases.

Confidential, Atlanta, GA

Business Systems Analyst

Responsibilities:
  • Business requirement gathering and functional specification development
  • Created Dashboards for Key Stakeholders and Business Users.
  • Assist in technical specification development and application testing;
  • Systems analysis: Design technical solutions from functional design specifications
  • Developed Use Case and Process Diagrams, Functional and Non-Functional Requirements
  • Provided support for data quality issues pertaining to Siebel eCRM
  • Performed Business Analysis and Data Analysis
  • Involved in Data relationships, Data Re-engineering, mappings and definitions
  • Developed and adapted technical solutions/options into detailed technical design documents, ensuring all functional requirements are met in the technical design
  • Designed and tested changes to software applications to meet both functional and technical requirements; Data Elements and Usage
  • Utilized TOAD to query Oracle Database for data analysis and gap analysis for testing purposes.
  • Utilized such tools as Visio for data mapping, ERD Diagrams, schema diagrams etc.
  • Worked Query Data with drill down analysis and evaluate data quality
  • Expert in SQL Querying, Oracle, MS Access and MS Excel
  • Acted as liaison between stakeholders and development/quality assurance team
  • Involved in writing complex SQL statements.
  • Wrote queries to perform data quality checks after ETL process was kicked off to ensure tables and fields were populated accordingly.
  • Data mapping from Source to Destination databases, understood ETL processes and character length and elements involved in ETL processes.

Confidential, Atlanta, GA

EPIC Clarity Report Writer

Responsibilities:
  • Responsible for Business Analysis, Data Analysis, Data relationships, Data Reengineering, mappings and definitions
  • Provided training and professional development on new technologies and applications to staff.
  • Acted as Liaison/Business Architect between End Users and Technical Staff to gather and define applications processes and requirements gathering for reports creation.
  • Provide data architectural leadership in developing enterprise data/process models, and logical/ physical database designs.
  • Applied analytical skills to business requests (which are often high-level or lacking in detail) and communicate these business wants/needs in a clear and unambiguous manner.
  • Provide data and database development, maintenance, reports development, and production support.
  • Participated in IT and Business project to define system requirements.
  • Designed developed, implemented complex logical and physical databases across multiple platforms, technologies and computing environments.
  • Wrote and Performed application test scripts to ensure the application is performing according to the designer’s specifications and meets customer needs.
  • Creation of Dashboards and Scorecards for Upper Management, Doctors and Executives to review on a daily basis.
  • Performed Query Data with drill down analysis and evaluate data quality; Data Elements and Usage
  • Lead and supported efforts in implementing, testing, and integration of Epic’s Tapestry Healthcare Application within Clarity Database (Tapestry Managed Care Application Modules: QRM, CRM, Resolute, Inpatient, AP Claims (CMS1500 & UB40) and Radiant)
  • Creation of Ad Hoc and specialized reports both in Reporting Services, SharePoint Designer 2007, Cognos, Crystal Reports and Epic’s Reporting Workbench within a Teradata Database system and Sql Server 2005.
  • Responsible for analyzing the business needs of clients and stakeholders to help identify business problems and purpose solutions.
  • Utilized SQL Querying, Visio, Oracle, MS Access and MS Excel
  • Performed data mapping from application interface to database and gap analysis of old database environment to new database environment
  • Created Test scripts and test plans, performed unit, functional, and regression testing on applications
  • Wrote queries to perform data quality checks after ETL process was kicked off to ensure tables and fields were populated accordingly.
  • Created temporary tables and created views in databases for End Users.
  • Wrote complex SQL statements in a Teradata database environment for reporting purposes or data mining.

Hire Now