SUMMARY

• Excellent analytical and problem - solving skills in designing, developing and implementing innovative business processes and providing system solutions using new approaches & technologies for Finance and Health Insurance applications with all phases of SDLC with in-depth knowledge of Waterfall, RUP, and AGILE methodologies.
• Highly motivated team player with attention to detail and always willing to work in a challenging and cross-platform environment. Excellent interpersonal communication and conflict resolving skills with expertise in moderating team meetings.
• Extensive experience in Data Analysis and BI Reporting , creating technical and Mapping specification documents, data modeling concepts & creating data models and building Data Mart with Normalized and Denormalized schemas. Understanding of the Database schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling and providing solutions to Master Data management (MDM) projects and performed merge-unmerge analysis and data profiling.
• Extensive experience in gathering and analyzing User, Business and Functional requirements through interviews, seminars, surveys, and questionnaires, drafting vision and scope documents , creating the BRD and FRD .
• Different analysis techniques; GAP Analysis , Root-Cause Analysis , Object-Oriented Analysis, Feasibility Analysis, Risk Analysis, Impact Analysis in Healthcare domain and programs like Managed care , understanding of HealthCare subject areas such as Medical Claims , Provider , Pharmacy , HEDIS , HCC, etc. and HIPAA compliance.
• Project tracking by maintaining TFS and JIRA backlogs, Sprint Planning, SCRUM, and AGILE and bug/incidents triaging in ServiceNow , including Project Charters & Incident Management requests, analysis, and implementation.
• Experience in latest reporting technologies Tableau , POWER BI and understanding of Hadoop , Big Data, AWS technologies (S3, Integration tools, Redshift)
• Proficient in UML - Use Case diagrams , Activity Diagrams, functional Diagrams, Sequence Diagrams, and Analysis & Design with Interaction diagrams. Analyzing and documenting existing business processes, developing workflow diagrams and process flow diagrams, working with requirements traceability matrix RTM and re-engineering business processes. Hands-on experience in building and analyzing Web Portals.
• Experience in integration of data sources like MS SQL Server , Teradata , DB2, Oracle , Flat Files, and XML files and querying data using complex SQL (or related language), stored procedures and the ability to performance tune the queries.

TECHNICAL SKILLS

Software/Applications: MS SQL Server, SQL Developer, Informatica, SSRS, SSIS, SAS, MS Office, MS Project, Quality Centre, IBM Rational Rose, Informatica Analyst, SoapUI, WinSql, SqlDBX, RedGate, Altova XML Spy, Adobe Photoshop,: Powerdesigner Viewer, Micro Strategy, TFS, Trello, ServiceNow, Tableau,: MS Power BI, Micro Strategy, Alteryx, Teradata, Erwin, Power Center, MDX, JIRA, MoveIT, BOX, API:

Business Modeling Tools: Microsoft Visio, Snag It, FrontPage, PowerDesigner

Databases: SQL Server, IBM DB2, MS Access, Teradata, SQL developer

Languages: Fundamentals - SQL, HTML, Visual Basic

Operating Systems: LINUX/UNIX, MS-DOS, All Windows platforms

Methodologies/Processes/Technologies: SDLC, AGILE, Waterfall, SCRUM

PROFESSIONAL EXPERIENCE

Project Lead

Confidential, Thousand Oaks, CA

Responsibilities:

• Acted single Point of contact as a project lead for the Patient Master project from Capgemini.
• Supported implementation in PM with downstream consumers on their UAT and PROD testing, API endpoints, match rule set up, data integration, mastering records, providing data loads, delta files and special extracts, etc.
• Coordinated among different downstream systems and partners and provided resolution on issues, deliver requests and tasks, identified and pursued ad-hoc requests and ensure delivery, reviewed and delivered weekly crosswalk reports to Consent Master.
• Driven daily and weekly cadence with operations tracker, issues and new enhancements to Confidential and participated in meetings with business stakeholders and downstream consumers to the Patient Master project.
• Defined match rules for manual and auto-merge processing. Analyzed manual queues and performed data stewarding, merged/unmerged patient records in Patient Master.
• Led offshore data stewards and operations team for daily updates, task assignments, review and mentoring on mastering concepts in Patient Master, understanding of match rules criteria as well as the UI interface, inbound and outbound data feeds from an internal database, job schedules, maintenance and enhancements of internal tables.
• Facilitated end to end daily extracts scheduling and delivery with all upstream and downstream engagement partners at Confidential and Capgemini.
• Evaluated current client process, recommended process transformation of offshore stewarding to onshore with cost-saving. Supported statement of work (SOW) and change order (CO) for new integration and extension of work.

Sr. Business Systems Analyst

Confidential, Aliso Viejo, CA

Responsibilities:

• Extensively worked on eliciting requirements from Business users and other stakeholders and coordinated with inter-teams to facilitate the impediments on deliveries.
• Performed ad-hoc reporting for business users and provided support on critical and urgent reporting requests.
• Performed data analysis based on requirement and provided feedback to stakeholders, created Source to Target Mappings and other tech specs and converted business req. to functions req. for developers.
• Analyzed req. for Data Mart build outs based on the available data elements and data warehousing table structures.
• Solution data mart build-out approach and data modeling diagrams for Data Marts.
• Documented BRDs based on requirements gathered from business users via different elicitation techniques such as brainstorming, Interviews/meetings, use cases, document analysis, sequence diagrams, etc.
• Conducted SCRUM meetings for the team to get daily status updates and discussed and facilitate any roadblocks.
• Reviewed new project charters and provided approval based on available requirements submitted.
• Discussed project charters with the team and provided detailed insight about the request during backlog grooming and estimated the effort.
• Maintained User Stories in TFS and allocated in SPRINTS based on priorities for Product Owner, Assigned user stories to the developers and story points in Sprint Planning sessions.
• Resolved bugs, analyzed and provided support to developers and on priority and complexity in SPRINTS.
• Handled the offshore team of developers and prioritized assignments, supported development activities and provided necessary documentation and requirements to complete the tasks.
• Performed QA on reports after development was completed and validated it with business requirements.
• Conducted UAT sessions with business users and provided necessary insights regarding data captured and the availability of applications.

Sr. Data Analyst

Confidential

Responsibilities:

• Worked on several reporting requirements with a focus on Finance , Member Enrollment in Medicaid , Medicare Advantage and MyCare business areas for reporting requirements for respective Business owners. Supported Finance and Member Enrollment Business department and areas. Prepared several ad-hoc, periodic reports and dashboards.
• Acted as ‘ Point of Contact ’ in CareSource’s IT department to deliver Regulatory Reports to the Department of Medicaid for the state of Ohio and Indiana.
• Extensively worked on Ad-Hoc Business and State Regulatory reporting from Relational Databases and BI report tools using Micro Strategy , SSRS, etc.
• Liaison between Business users and developers for clarification, any escalation, and facilitation, and conducted UAT on BI reports and dashboards and presented final Dashboard to stakeholders.
• Gathered and analyzed requirements as per business needs and documented them into reporting specification documents. Performed detailed data discovery and Data source analysis in EDW to ensure the availability of the required data, designed process and data flow diagrams for developers.
• Reviewed, validated and approved data mappings and reports completed by other Data Analysts.
• Participated in daily SCRUM and provided status updates to the team, AGILE methodology in this project.
• Performed Data Analysis for the claims/member/provider and Pharmacy data sets and created data mapping artifacts from source to target. Wrote complex SQL queries with Analytical functions to get desired results as per the requirements and created temporary tables to analyze data from different data sources, performed SQL JOINS and gap analysis between current and future state of the Data Warehouse and produced reports that involved HEDIS codes analysis
• Drafted technical specification document, performed data discovery , gap analysis for the requirements and data analysis on Medical claims, Member, provider and Pharmacy data sets available in the EDW.
• Created Data design documents for data migration and Source to Target Data Mapping documents and formulated the transformation/Business rules and.
• Created logics/algorithms or computation for the final output data field, SQL queries, and data profiling logics based on an understanding of the business and technical requirements.
• Collaborated with a data architect to document functional requirements describing the ETL workflow process for data migration from legacy to future state.
• Created outbound and inbound crosswalk documents, business rules and transformation logic between source and target and walkthrough the team and developers on Medical Claims Data, Members Data, Provider Data, HEDIS data set, and Pharmacy data in the enterprise data warehouse.
• Conducted walkthrough sessions for Data modelers, Developers and testing teams with pseudo-codes and assisted in understanding the transformation logic and business rules applied in the source to target mapping document.
• Conducted UAT for business users for inbound files and incoming provider data and worked closely with BI developers to help them understand the requirement to create the dashboard.
• Worked with Quality Assurance Analysts ( QAs ) during testing, data validation and helped to understand the business requirements. Provided resolution for defects during ETL development and testing.

Data Analyst

Confidential

Responsibilities:

• Followed AGILE methodology throughout and provided a daily status report to the implementation leads in Daily SCRUM meetings.
• Gathered and documented the technical details and data requirements from business users, SMEs and management groups - and reconciled conflicts by conducting Joint Application Development (JAD) sessions, through open-ended discussions, brainstorming sessions, one to one discussion and other requirements gathering strategies based on the project scope.
• Analyzed Business Requirements and segregated them into high- and low-level Use Cases and Activity Diagrams using MS Visio. Performed GAP analysis involving the current state and proposed future state.
• Educated Business users on data anomalies, issues, input errors, field value ranges, data patterns, referential integrity gaps and the level of record incompleteness that is in the source systems.
• Prepared Business Glossary and Data Dictionary , documented Data Quality Rules and Business rules related to data and performed data profiling and Data quality checks in MDM data.
• Involved actively with Data Modelers with related requirements and conducted walkthroughs with the end-users and Product owners to gather the modification requests from business users to upgrade or change the business specification that affects the database for the product.
• Involved with Data Architects to support standard data handling rules with data modeling requirements to create new tables/views.
• Developed detailed Data Mapping documents from several stages in the data flow and translated business requirements into business rules with system owners to resolve data issues and refined business rules and provided walkthrough to the ETL developers.
• Performed detailed Data Profiling using the Informatica Analytics profiling tool and tested data by writing SQL queries to the database and with the help of a data profiling tool.
• Ensured adherence to locally defined data standards for all developed components.
• Created ETL Requirements to migrate data from the Legacy system to the Current system with proper validations.