Senior Business Analyst
Current• Attend regular meetings with the Production Support Management team to discuss issues, concerns and the weekly work to be assigned.• Strong ability to understand and develop requirements by analyzing business rules and integrating data tables within diverse databases.• Utilized Agile methodology and gathered high level requirements from the business, created Business Requirements Documents and prioritized the backlog with Scrum Master.• Facilitated JAD session with the SME, process owners, stake holders, technical team and identified various action items and enhancements to be implemented in current Medicare processing system.• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.• Experience with dimensional modeling using star schema and snowflake models.• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.• Used SQL Developer to understand the back-end tables for data mapping & migration and Informatica for data profiling• Responsible for creation of Collaboration Diagrams, Activity Diagram, ER Diagrams, Project Flow Diagram in MS- Visio.• Applied advanced Excel skills (pivot tables, macros, lookups, charts) and Access database querying skills in streamlining and automating accounting processes. • Extensive experience in EDI/HIPAA implementation, Insurance regulations and Claims Processing.• Troubleshooting file transmission problems and assisted customers with EDI and Medicaid Insurance claim related inquiries explained and enforced guidelines in the X12 Implementation guides (837P, 837I, 837D, 270/271).• Wrote User stories using Rally.• Conducted Grooming session with the BA team and Product team for the User stories.