Business/rules Analyst Resume
Springfield, OH
SUMMARY
- Over 9 years of experience in Business System/Data Analysis, Development, Administration and Support solutions.
- Strong understanding of RDBMS and Data warehousing concepts. Knowledge in Data mart development, ER Modeling and Data - Flow Modeling.
- Interacting with stakeholders, gathering requirements, rating them and assigning priorities to each of them.
- Documenting business processes and translating them to functional specifications.
- Expertise in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
- Demonstrated proficiency in requirements gathering (interview techniques, JAD sessions, questionnaires), requirements.
- Experienced BOBJ implementation to post-production support
- Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.
- Experienced in customization of war files into different Web Application Servers.
- Expertise in Development, Maintenance, Upgrade, Integration, Production Support and Re-engineering Projects.
- Good understanding of health care industry claims management process, Medicaid and Medicare Services and insurance sector.
- Expertise in designing Universes for Performance Management and Reporting needs.
- Experienced in developing Desktop Intelligence, Web Intelligence / Rich Client and Crystal Reports using different Data Sources.
- Good practical knowledge in understanding Medicare Concepts, detailed knowledge of the claims adjudication process within a healthcarepayerand interacting with hospitals
- Extensive experience in creating Stored Procedures, Packages, Functions, Triggers, Materialized Views, Cursors and other database objects using SQL, PL/SQL.
- Experience in creating DDL, DML and Transaction queries in SQL.
- Experience in SQL Tuning/Performance tuning of SQL queries/stored procedures using partitioning, Explain Plan, SQL Trace.
- Server Intelligent Agent (SIA),Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Auditor, Crystal Reports, Crystal Xcelsuis, Query as a Web Service (QaaWS), Voyager, Live Office, Dashboard Manager.
- SDLC-(Software Development Life Cycle Methodology) and ASAP Methodology
- Efficiently mapped business requirements and processes to technical solutions.
- Writing Use cases and producing Use Case Model, Analysis model, Behavior diagrams (Sequence diagrams, Collaboration diagrams) and Class diagrams based on UML Methodology and Business process flow diagrams using MS Visio.
- Conducted JAD Sessions and other formal and informal discovery sessions with users and customer IT personnel to identify requirements and develop design specifications for data warehouse projects and corresponding applications.
- Strong knowledge of Software Quality Assurance methodology
- Defining Test Cases, analyzing bugs, interaction with team members in fixing errors and User Acceptance Testing (UAT).
- Using project management tools like MS-Project for status reporting and planning.
- Strong analytical and troubleshooting skills
- Ability to adapt to change in a fast-paced environment, be creative, and be able to balance multiple priorities simultaneously
- Formidable ability to coordinate multiple projects and meet deadlines under pressure
- Exceptional ability to inspire and communicate with both clients and team members to achieve and surpass project goals
TECHNICAL SKILLS
Requirement Gathering tools: Joint application development (JAD), Prototyping, Use cases, Request for proposals (RFPs), Brainstorming, Questionnaires, UML
Data Modeling/Oracle Utilities: Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader.
Databases: ORACLE 10g/9i/8i, DB2, Informix, MS Access, MS SQLServer, SAS / Hsql,Teradata
Languages: SQL, PL/SQL, C, C++, COBOL and Visual Basic 6.0.
Web Technologies: VBScript, HTML 3.2/4.0, IIS 4.0/5.0.
Operating Systems: UNIX, Linux, MS-Dos, Windows NT 4.0/2000/ 2003
MS Office Professional: Word, Excel, PowerPoint, Access, and MS Visio.
PROFESSIONAL EXPERIENCE
Confidential, Springfield, OH
Business/Rules Analyst
Responsibilities:
- Worked on UAT testing and took sign-off for several clients and assisted with Government Sponsored Enterprise(GSE) rules design for the new Fannie and Freddie Mac guidelines for 2015.
- Provide customer service and support for the rule build.
- Worked with EDI for the structured transmission of data.
- Collaborated in building a business analysis process model using Rational Rose and Visio.
- Worked with XML for data exchange.
- Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR),
- Interviews and Requirement Elicitation sessions
- Wrote Test Cases in HP Quality center that would test various Test scenarios.
- Writing new COBOL, DB2 programs to handle Claim centre messages (from front end via XML)
- Processed in the Mainframe from the front end system called Claim Centre (CC) using GUIDEWIRE working with SQL SERVER Data.
- Provided key initiatives in working with users in defining project and system requirements.
- Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
- Responsible for creating mapping documents required for the ETL team.
- Developed SSIS Packages to transfer the data between SQL Server database and files.
- Worked on following applications Business Objects, Enterprise Architect, Toad, PlanView (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project)
- Responsible for the development of a Data Warehouse for personal lines conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.
- Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and
- Use Case Narrative using the UML (Unified Modeling Language) methodologies
- Worked on data modeling and produced data mapping and data definition documentation
- Helped with Data Mapping between the data mart and the Source Systems.
- Extensively used Test Director to review and update the status of entire testing process.
- Designed custom applications using Visual Studio.NET 2008 and MS SQL Server 2008.
- Installed SQL Server 2008 R2. Designed new SQL databases and restored old ones.
- Normalized the database up to 3NF to put them into the star schema of the data warehouse.
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- Performed requirement analysis, went through all the use cases and issue logs.
- Worked extensively with MS Excel
Business /Technical Analyst
Responsibilities:
- Performed gap analysis between HIPAA /835 and HIPAA /835 Companion Guides.
- Performed impact analysis of other enrollment processing systems to determine potential scope/impacts.
- Performed thorough analysis of the companion guides from each trading partners both Medicaid as well as Commercial clients and identified the changes that specific clients need.
- Reviewed with business owners to identify data requirements and business rules based on the changes within the transaction set.
- Involved in analysis of requirements for Medicaid and Commercial line of businesses.
- Engaged on theloading EDI 834-file toFacetsthroughMembership module.
- Performed gap analysis for ICD 9 to ICD 10.
- Created BRD and FRD for Medicaid managed care requirements.
- Documented and mapped the variousCPTandICD 9and10codes with incoming claim messages.
- Mapped the data according to the client requirement.
- Responsible for updating clients with provider information within MMIS on a weekly basis by running queries and exporting data in a defined file formats.
- Analyzed and mapped different data sets from system with the new MMIS system.
- Created SQL queries to find out the data in HIPPA compliance from .
- Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data.
- Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
- Manage alignment of business data requirements with the Data Management Infrastructure
- Used the mapping tools to map 4010 and 5010 transactions along with ICD 9 and ICD 10 codes, and validated the HIPAA Syntax.
- Has been a part of Creating Pharmacy Benefit Management (PBM) Mapping document.
- Prepared Requirement Traceability Matrix, Functional Specification, System Change Documents, Technical Specification Documents, As-is and To-be flows for the entire conversion process.
- Create Requirement Traceability Matrix (RTM), Crosswalk, mapping documents for ETL process.
- Participated in ETL process to load the base table and to build aggregates in corporate business logic / Summarization .
- Participated in Data Analysis and Design and data mining with the Data analyst in defining data sources and required data content for the data warehouse component.
- Documented the dimensional models of ETL system.
- Worked with the commercial business owners as well as with the state representatives in process of gathering the requirements.
- Mapped the new data in 5010 to the X- translator to make it 5010 compatible.
- After performing the thorough analysis, designed the new translator based on the specific requirement from the commercial and state clients.
- Maintained the dual usage functionality in order to receive the 4010 formatted files for the clients who are not ready to switch to 5010 and 5010 formatted files that are willing to switch to 5010.
- Prepared the common as well as the translator specific test plan for testing the new 5010 process flow
- Performed System Testing for the X12 formatted data that gets translated to the flat file through translator.
- Assist with ETL development, documentation and testing.
- Validated the positions and the characters after the data gets translated through TIBCO.
Environment: Windows 2003, X-translator, MS Office, MS Visio, SharePoint, HIPAA 4010/5010 Blue Works Live, SQL, PL/SQL, RUP, Rational RequisitePro, Microsoft .Net (ASP, VB), HTML, XML, MS Visio, SQL
Confidential, Southfield, MI
Data Analyst/Technical Analyst
Responsibilities:
- Involved in the entire SDLC of the project. Requirement & Analysis, Design, Development, QA, UAT and Implementation.
- Was part of the requirements workshop and assisted in requirement gathering from the users and creation of BRD. Prepared the FBTR (Functional, Business and Technical requirement document) based on the BRD.
- Created BRD and FRD for Medicaid managed care requirements and documenting them.
- Gathered required business rules for data transformation
- Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures.
- Prepared the business requirement document (BRD) and system requirement document (SRD).
- Responsible for checking member eligibility, provider enrollment, member enrollment for Medicaid and Medicare claims.
- Wrote FRDs for the defects and enhancements and got approval from business for the developers.
- Worked on Technical design documentation (TDD) of the claims processing system.
- Data modeled part of the warehouse tables and assisted designing the final conceptual, logical, physical model in ERWIN
- Documented the dimensional models of ETL system
- Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals. This includes HIPAA 4010; 837, 835, 270/271, and others.
- Support maintenance of database schema, tables, procedures and users/user access levels for each segment of database and modify existing databases and database management systems.
- Developed data quality test plans and manually executed ETL and BI test cases.
- Worked on electronic Medicaid eligibility verification system & the Medicaid & Medicare intermediary along with their roles in claim processing
- Coordinated with the developers and IT architects to design the interface of the new system according to the X12 (270, 276, 278, 834, 837 (I,P,D) and 820) standards
- Work as part of a project team to coordinate database development and determine project scope and limitations. Review project requests describing database user needs to estimate time required to accomplish project.
- Used SQL to test various reports and ETL load jobs in development, QA and production environment
- Worked extensively with client gathering requirements to generate customized SQL reports.
- Performed extensive task which include Data Quality Analysis, Data lineage and Data Standardizations.
- Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for processing of Medicaid Claims.
- As part of technical team that focuses on ensuring compliance to the data models, data standards and overall data architecture. Monitored compliance by conducting reviews of the project logical and physical data models.
- Performed Work Product Review (WPR) to ensure that the documentation was up to the standard and without any errors.
- Designed Universes on Teradata V2R5/V2R6 DB platform as per the technical requirements and applied the necessary object level, row level security.
- Written SQL queries for validation of ETL Reports from Source to Target system
- Implemented various joins including equijoin, outer-join, self-restricting joins. Defined cardinalities and resolved issues like loops by creating aliases and contexts to remove the cyclic dependencies.
- Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes.
- Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes
- Developed ER diagrams and Physical Data-model along with the testing team so as to provide a clear understanding of the system under development and for reference of the testing tem
- Extracted data by running SQL queries, and analyzed financial and customer metadata that gets populated on the web application
- Extensively used ETL to load data from XML files, Flat files data also used import data
- Involved in report rationalization as part of the entire BI platform stabilization project.
- Analyzed, designed, built and tested reports while working directly with end-users.
- Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
- Designed the Unit test cases required for Unit testing before migration to the Testing Environment.
- Tested the Universe on various parameters such as Database Connectivity, loops and Contexts, object mapping, aggregate awareness. Tested the report data against the database.
- Performed Production support activities to the users throughout the Production cycle.
- Performed the support activities during the cutover.
Environment: Dashboards, Oracle 10g, Toad 9.6.1, Teradata V2R5/V2R6, SQL, PL/SQL, RUP, Rational RequisitePro, Microsoft .Net (ASP, VB), HTML, XML, MS Visio, SQL Server, MS Access, Quality Center, QTP.
Confidential, Middletown, NJ
Business Analyst
Responsibilities:
- Interacted with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
- Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures.
- Prepared the business requirement document (BRD) and system requirement document (SRD).
- Facilitated Provider Enrollment, Setting up Provider profile & Trading Partner Agreement.
- Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize th requirements.
- Converted business requirements in business/technical requirement documents.
- Used the Sql Server profiler tool to monitor the performance of SQL Server-particularly to analyze the performance of stored procedures.
- Involved in data warehouse testing by checking ETL procedures/mappings.
- Created and maintained SSIS packages designed for replication of data.
- Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
- Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes
- Designed Use Cases using UML and managed the entire functional requirements life cycle using RUP.
- Written Stored Procedures to display the data in front end application
- Did data analysis, created data mapping and data interface documents and kept the documents updated with changes in requirements and functional specifications.
- Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
- Analyzing the change request and coordinating the changes required with the development team
- Writing SQL queries and matching the data with database and reports.
- Tuned and Enhanced Universes with SQL Queries for the Report Performance.
- Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
- Involved in data warehouse testing by checking ETL procedures/mappings.
- Created Web Intelligence reports Ad-hoc and canned reports.
- Tuning the queries to improve the performance of the report refresh time.
- Identifying and Removing Bottlenecks in order to improve the performance of Dashboards and Reports.
- Worked closely with DBAs to create aggregate tables to support Universes and dashboard.
- Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.
- Exported Xcelsius to repository to make it available for users through infoview.
- Migrated universes and reports from ST/UAT to production using Import wizard.
- Deployed configuration on all Development, Test, SIT, UAT and Production Environments.
- Expert level knowledge of complex T-SQL using Teradata functions, UDFs, macros and stored procedures.
- Used agile methods to promote a disciplined project management process that encourages frequent inspection and adaptation.
- Developed & enhanced stored procedures in SQL Server 2005 to update its logic based upon the changing business environment.
- Implemented row level Security, object level Security Confidential the Universe level for security purpose.
- Tuned and Enhanced Universes with SQL Queries for the Report Performance.
- Tuning the queries to improve the performance of the report refresh time.
- Created customized Web Intelligence reports from various different sources of data.
- Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
- Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
- Worked closely with DBAs to create aggregate tables to support Universes and dashboard.
- Tested the aggregate awareness to ensure the query is pulling correct level of aggregation
- Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
Environment: RUP, Rational RequisitePro, Microsoft .Net (ASP, VB), HTML, XML, MS Visio, SQL Server, MS Access, Quality Center, QTP.
Confidential, Evansville, Indiana
Business Data Analyst
Responsibilities:
- Performed Business Analysis and identified critical Metadata for key Business Divisions. Created Mapping & Metadata documents. Created rules for Electronic cataloging of data via attribute extraction services.
- Extracted and analyzed data from existing data stores and performed ad hoc queries.
- Assisted in the design and implementation of new production and DB systems.
- Part of team that coded monthly Datamart scripts which extracted data from Third-Normal form Teradata table.
- Intensive use of SQL within the Teradata platform. Performed the Back-end testing manually by writing and executing SQL statements on Oracle Database in UNIX environment to query the database for Data validation, identifying, cleaning/scrubbing.
- Developed universes to accommodate complex database design approaches.
- Tuned and Enhanced Universes with SQL Queries for the Report Performance.
- Streamlined SQL generation from Universes by implementing Aggregate Aware functions and @Variables.
- Created highly formatted reports to visually represent data..
- Collecting report & Visual requirements from users/business owner.
- Enhanced the Performance of the Dashboards by manipulating and using complex formulas on the Universe and Excel.
- Worked in the Team closely with Functional Architect, DBA and Analysts to get a clear understanding on the Application.
- Created and modified views within Teradata for Business Analysts.
- Identified the usage of Indexes in Teradata Confidential various situations as part of tuning.
- Collected statistics and used join indexes
- Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
- Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
Environment: RUP, Rational RequisitePro, Microsoft .Net (ASP, VB), HTML, XML, MS Visio, SQL Server, MS Access, Quality Center, QTP., Sybase, SQL Server 2005, Oracle 9i,PL/SQL, Unix, shell scripts and Perl Scripts.
Confidential, Owings Mills, MD
Business Data Analyst
Responsibilities:
- Performed analysis and tracking of requirements and data specifications for Business Objects Universes and Reports.
- Perform data analysis activities to appropriately source and document new data points to be provided over interface with the team to create sample XML scenarios to provide to application delivery team (DEV and QA) with data reflective of planned data source (new sourced data points).
- Performed Data mapping (source to target- XML transactional database to Teradata) and data profiling.
- Created Use Cases and Data Flow Diagrams in MS Visio
- Created PowerPoint Presentation for high lever overview of Projects.
- Conducted brainstorming sessions with several groups of stakeholders to the project, including Subject Matter Experts (SME’s), management groups and the IT group.
- Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducted formal weekly meetings with the team.
- Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for processing of Medicaid Claims
- Worked with SAP Business Objects developers and ETL team to ensure clear communications on requirements.
- Involved in ETL Process Validation for data completeness, data correctness and data transformations according to the requirements
- Reviewed and tested SQL codes for core reports and performed testing of adhoc BOBJ Universe.
- Created user manuals and Supported Business Objects' end-user in areas including software (Designer, Reporting, Web Intelligence, and Publisher) and running ad hoc/core reports.
- Performed Data Validation running SQL against new data source - Teradata, Integration and UAT Testing.
- Developed 100+ adhoc reports using SAP Business Objects to test new BOBJ Universe to insure all joins, calculations, filters and mapping worked according to the requirements.
- Used SharePoint to share the documentation, setting up the security and creating workflows according to the requirements
- All work was documented (Minutes of Meetings) and approved (via approval workflow in SharePoint) to avoid miscommunication