We provide IT Staff Augmentation Services!

Business Data Analyst Resume

UsA

OVERALL IT

  • A result oriented professionalwith 10 years of IT experience that involves Data/Business Analysis, Reengineering, Requirements, Design, Build, and Testing of Healthcare, Data Warehouse, Mainframe, and Client-Server applications.
  • 7 years in Enterprise Data Warehousing, and 4 years in Client Server and Mainframe applications
  • 5 years ofLeanAgile/SCRUMmodel, and 5 years ofWaterfall model experience
  • 7 years of HealthcareInsuranceand 3 years of Finance industries experience
  • 5 yearsin Leading a team of Data/Business Analysts and Tech Leads.
  • Expertise in all the artifacts of the SDLC Mapping, Business System Design, Conceptual Design, Detailed Design, Development, Migration document, UAT, Integration Testing, Warranty support, and Lights-on team hand over.
  • Experienced in Master Data Management, Metadata Management, and Data profiling.
  • Experienced on both Business and IT areas.
  • Worked closely with Senior Leadership in writing SOWs, Project Management plans (Cost Management, Schedule management, Resource management, Risk & issue management)
  • Demonstrate a willingness, interest, and aptitude to learn Domain skills and technologies.
  • Highly efficient and demonstrated superior time management and multi-tasking skills by accomplishing cross-functional tasks.

HEALTHCARE INDUSTRY SKILLS

  • 7 years of Healthcare industry experience which includes 4 years at WellPointand 3 years at United Health Group.
  • Healthcare experienceinthe areas ofClaims, Membership, Capitation, Chart Of Accounts, Product, Provider, Medicaid, Lab, EDI, and WebMD.
  • EDW (Enterprise Data Warehouse) building experience at WellPoint.
  • Acted as System Matter Expert(SME) and Point of Contact (POC) for Chart Of Accounts and GL Balancing of Claims and Membership for EDW
  • Designed and Developed Programs to assign Chartfields for claims and Membership of all regional and operations systems at WellPoint, and performed GL (General Ledger) Balancing for EDW Claims and Membership.
  • Designed and Developed programs to transform Claims and Membership of most of the regional and operations systems into Enterprise Data Warehouse (EDW)
  • Designed and Developed Calculation Engine for Capitation at United Healthcare.
  • Automated rules processing procedure for Chartfields assignment.

BUSINESS / DATA ANALYST SKILLS

  • 7 years of Business Analyst and Data Analyst experience.
  • Expertise in Use case preparation, Functional requirements specification / Business system Design, UML, MS Visio, Rational Requisite Pro, JAD sessions, business workflows such as AS-IS and TO-BE, Requirements Traceability Matrix, Mapping documents, and Gap Analysis.
  • Served as a liaison between the business and IT in translating complex business needs into application software and Conceptual Models.
  • Lead Business Analysts and coordinated SMEs of all regional warehouses/sources, and provided the SME with the GL balancing requirements of EDW Chart OF Accounts.
  • Analyzed complex end user needs to determine optimal means of meeting those needs.
  • Acted as a resource to users of the software to address questions/issues
  • Provided direction and guidance to team members and served as an expert to the team
  • Planed and Lead UAT program: Created UAT test plan; worked with stakeholders to create UAT scenarios; prioritized defects and involved in decision making, and took UAT through completion for production implementation.
  • Created detailed scenario documents to help designers understand the requirements clearly.
  • Experienced in preparing adhoc reports using SQLand MS Excel.
  • Excellent Training skills, facilitation, PowerPoint presentations, maintaining performance metrics, develop training manuals, documentation & communicating to users.

TECHNICAL SKILLS

  • 5 years of experience as Technical Lead in Data Warehousing, Mainframe, andClient Server projects.
  • Closely worked with Architects to build solution architecture for the enterprise data warehouse.
  • Mentored Tech Leads in writing the High & Detailed Level Designs; Reviewed detailed level designs; worked with DBAs in performance tuning of Teradata and DB2.
  • Hands on experience in the areas Teradata, Informatica, Datastage, SAS, DB2, COBOL, JCL, VMS, Mainframe, Java, and Servlets.
  • Have extensively used Teradata RDBMS, BTEQ, DB2, Informatica, QueryMan, Teradata SQL assistant, Tpump, FastLoad, MultiLoad, and Viewpoint.
  • Wrote High Level ETL designs, Detailed Designs, Process Flow, Source to target mappings, and built Scenarios.
  • Designed the balancing and auditing logic using the ETL process for the validation of the loaded data.
  • Worked on DB2 utilities such as OMEGAMON, REORG, RUNSTATS, LOAD, UNLOAD, REBIND, IMAGECOPY, and CHECK. And DB2 stored procedures for online applications
  • Designed and developed weekly, monthly reports related to the marketing and financial departments by using SQL, PL/SQL, Ms Excel, Ms Access, and Teradata
  • Designed, developed, and tuned SQL queries for online reports, and created stored Procedures.
  • Created jobs with 3rd party tools such as WLM and Autosys.
  • Converted complex ongoing scenarios for Healthcare COA, Membership, and Claims into performance efficient SQL queries in BTEQ scripts.
  • Monitored system performance by checking the logs and tested the components for different loads.

Education
Bachelor of Technology in Computer Science & Engineering.

Achievements

  • Special appreciation award from Vice President for contributions towards Enterprise Data Warehouse at WellPoint.
  • Recipient of outstanding performance award from Vice President for the 3rd quarter of 2006 at United HealthCare.
  • Special appreciation award for managing the multiple applications in 2005 at D& B.
  • Lead Designer for the project that won the Healthcare Project of the Year award for year 2006 at Cognizant.

Certifications

  • Professional, Academy of Healthcare Management
  • IBM Requirements Management with use cases part I& part II.
  • Teradata SQL specialist
  • IBM certified DB2 Database Associate, Application Developer, and Administrator.
  • SAS certified Base Programmer
  • SUN certified Java Programmer

Tools
Rational Requisite Pro, UML, MS Visio, Teradata, DB2, RDB, Oracle, Java, Servlets, JSP, Tomcat, Visual Basic, Informatica, Datastage, MVS, OpenVMS, SAS, Teradata Utilities, COBOL, Quality Center, Mercury Test Director, Sharepoint, Rochade, File-Aid, and DB2 Utilities.

Experience

Jan 12 till date
Project Confidential
Roles Business Data Analyst Lead

Confidentialis an Enterprise Data Warehouse which is a new initiative. Currently adding partners such as Sony, Kohls, HBC, Canada Hotels, and eventually offer the products to partners. Marketing and Sales team is on its way to add more partners and there is an increasing demand for such products as this initiate gets lots of new membership.

Responsibilities:

  • Lead a team of Data Analysts in support of Data Analytics department for Partnerships warehouse.
  • Worked with the business to gather requirements, and directs and supervises the team to conduct analysis in support of business strategy and decision-making
  • Identified data sources for the required target data attributes
  • Mentored team in documenting requirements, analyzing the customer needs.
  • Partnered with other business groups to contribute to horizontal projects
  • Provided business clients with status updates.
  • Responsible for various reporting and ad hoc analysis
  • Managed process improvement projects for reporting processes. Validates reports for accuracy.
  • Facilitated and conducted JAD sessions with stakeholders, and reviewed the requirements documents.
  • Planed and Lead UAT program: Created UAT test plan; worked with stakeholders to create UAT scenarios; prioritized defects.
  • Lead Post Production Validation, and prioritize the defects to bucket into Warranty period Vs. BAU (Business As Usual).
  • Created detailed scenario documents to help designers understand the requirements.
  • Prepare and send the End User Communication.
  • Prepare and submit the Metadata for Rochade to Data Stewardship team.
  • Day-to-day responsibilities include customer management, workload prioritization, negotiating deliverables, and leading analyses/automation initiatives.

Client -- ConfidentialFeb 08 Dec 11
Project EDWard Direct Sourcing
Roles SME, Business Analyst Lead

Confidential project is a huge initiative to build the centralized Enterprise Data Warehouse which will support all kind of reporting needs across the enterprise. This initiative will eventually decommission all the regional warehouses, and sources data directly from the operational systems into EDWard. This redirection project plays an important role in reducing the cost incurred in supporting multiple regional warehouses as well as helps the business in accessing a single repository of data for all systems.

The subject areas include Product (WPD WellPoint Product Database system and EWPD), Claims, Membership, Provider (EPDS and six of the legacy provider databases) and Chart of Accounts.

Responsibilities

  • Directly managed a team of 2 Business Analysts and 3 Tech Leads at onsite, and a team of 10 at offsite.
  • Mentored the team in delivering all the artifacts of the SDLC Mapping, Business System Design, Conceptual Design, Detailed Design, Development, Migration document (aka SDLC in WellPoint), UAT, and Integration Testing.
  • Facilitated and conducted JAD sessions with SMEs of all sources and warehouses to help them understand the EDW requirements, identify the GAPs between warehouses and EDW, and identify the alternatives.
  • Identified data sources for the required target data attributes
  • Identified and documented data standardizations to be performed, data enrichment operations, data validations, data security requirements, and data exception handling processes
  • Lead Business Analysts and coordinated SMEs of all regional warehouses/sources, and provided the SME with the GL balancing requirements of EDW Chart OF Accounts.
  • Acted as System Matter Expert(SME) and Point of Contact (POC) for Chart Of Accounts Process at EDW
  • Acted as Liaison among Finance team (GL team), Business users, Business SMEs, Technical SMEs, and Tech Leads.
  • Produced High level design documents, and guided the Tech Leads in preparing detailed design documents and Requirements Traceability Matrix (RTM) for Design.
  • Produced Requirements Traceability Matrix (RTM) for UAT, performed UAT.
  • Closely worked with Business Users team to help completing UAT, resolving the data issues, and taking through the UAT approval.
  • Closely worked with DBAs and Technical Architects to prepare high level design and for performance tuning.
  • Involved extensively in the SDLC documentation, walk through and approvals across the phases (development, SIT, UAT, IR & Production).
  • Responsible to balance the Claims Chartfields amounts against General Ledger GL balancing.
  • Responsible to balance the Member-Product counts against WARP systems which is source of truth for WellPoint for Member-coverage information for all systems.
  • Closely worked with cross subject areas teams -- Membership, Product, and Claims -- to assign Chart of Accounts for Members and Claims and to resolve the dependencies.
  • Involved in preparing High Level Logical Data Models and BRD supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.

Jan 2006 to Jan2008
Client -- Confidential
Project Enterprise Capitation Development, Enterprise Capitation Reporting
Roles Sr. Systems Analyst, Designer

United Healthcare acquired several businesses that use a capitation reimbursement model with their gatekeeper HMO products. A “stand-alone” cap system is needed so that multiple entities may use the cap system to administer its capitation reimbursement methodologies. Provide solution for end-to-end processing of all aspects of a capitation contract. This includes capitation calculations, claim withholds, risk pools, settlements, national specialty programs, i.e. the National RX program in place with PHS today, and special regulatory provisions, i.e. the Richman Bill. The end-to-end solution also includes reporting of encounter and fee for service claim data as needed.

Responsibilities:

  • Analysis and documentation of the existing system flows into Functional Requirements Specifications Documents at modular level, then Consolidate them into use case level.
  • Facilitated and conducted Joint Application Development (JAD) sessions with Business Users to collect the reporting requirements and prepared Use case documents at screen level and consolidate them into subject area level.
  • Created targeted Questionnaires for Business Users to gather requirements.
  • Modeled the As-Is system and performed the complete Gap Analysis for the existing system in order to map it to the To-Be system, and provide recommendations.
  • Developed blueprint and tested the prototype for the front end Capitation system.
  • Used agile methodologies to accommodate the changes in front end user requirements for screen development.
  • Worked with Membership, Product/Coverage, Provider teams on the data extraction requirements for Capitation processing.
  • Involved in preparing high level requirements and high level designs of Claims, Membership, and Product/Coverage.
  • Participated in Database Design, and Document the Design Specification.
  • Designed/Created ETL process for loading the base tables to apply the business rules manipulate and/or massage the data according to the requirements.
  • Created/ Designed the balancing and auditing logic using the ETL process for the validation of the loaded data.
  • Lead the development team and guiding them in understanding the requirements.
  • Documenting test cases, test procedures, test plans, test results, defect reporting and verification.
  • Identifying the cause of high severity Defects and fixing.
  • Lead Developmentteam by giving them the insight about the approach and design standards.
  • Perform extensive code reviews on the UNIX shell scripts, ETL design.
  • Supported System testing and User Acceptance testing.
  • Documentedthe scripts, specifications, other processes and preparation of Technical Design Documents.

Environment: MVS, OpenVMS, Datastage, COBOL, DB2, RDB, Oracle, Internal proprietary tool for use case management, Test Director, AQT, QMF, SPUFI, OMEGAMON, BMC, DB2 PM, Endevor, File-Aid, File-AID/DB2, REORG, RUNSTATS, LOAD, UNLOAD, REBIND, IMAGECOPY, and CHECK

Hire Now