SUMMARY:

• Expertise in Information Technology industry serving as a Business Analyst in Data Governance and Warehousing Environment. Broad knowledge of mortgage industry, healthcare, insurance, and several other financial institutions.
• Expertise in broad range of technologies including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehouse, Data Modeling, and Design.
• In - depth knowledge and practical experience of using Waterfall, Agile, Scrums, Rational Unified Process, Business Process Reengineering, Unified Modeling Language, System Requirements Specification and Functional Requirements Specification, Rapid Application Development, and MS Visio.
• Highly skilled in transforming the needs of business users and stakeholders to the functional/technical requirements.
• Served as a critical resource and liaised between subject matter experts and technologists throughout the project life cycle.
• Excellent conceptual and technical skills to create Business Requirements Document, Functional Specifications Document, Process flow Diagram, and Detailed Design Document.
• Analyzed and defined business processes both “as is” and “to be”.
• Conducted Joint Application Development (JAD) sessions with stakeholders and business partners to resolve open issues.
• Developed use cases using UML and MS Visio for an ease with system interaction.
• Worked with the project team to determine appropriate test plans, deployment plans, and supported the product launch.
• Coordinated with Analysts, Managers, Developers, and Testers for complex projects during the SDLC.
• Prioritized work requests from project team.
• Identified and communicated risks and with possible solutions.
• Modified and changed the User Interface (UI) as per the system requirements and clients’ requirements.
• Performed a Change Management Role when the new requirements were proposed performing impact analysis.
• Interacted with QA team for Unit/Integration/System testing.

TECHNICAL SKILLS:

• Rational Unified Process
• UML
• Agile, Waterfall
• MS Visio
• MS Office (Word, Excel, PowerPoint, Project, Outlook, Access)
• MS SQL Server
• Rational Requisite Pro
• Rational Clear Quest
• HP Quality Center
• Test Director
• Informatica
• Erwin
• TOAD
• Power Designer
• Teradata
• Rational Rose
• MS - Visio
• E-R Studio
• DB Visualizer
• SQL Developer
• SQL Loader
• MS Project
• HPQC

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

Sr. Business Systems Analyst

Confidential, Bloomington, MN

Responsibilities:

• Translated requirements into technical specifications. Worked with developers to get projects developed.
• Elicited, understood and accurately represented product backlog requirements by working directly with Clients, Business Owners and Project Owners.
• Involved in documenting Requirement Traceability Matrix that included Business Requirements Document, Functional Requirements and Functional Specifications Document.
• Participated in creation of Business Process Workflow Diagrams with Stakeholders.
• Facilitated Joint Application Development sessions with developers and business resources.
• Identified solutions to non-standard requests and problems. Solved moderately complex problems and conducted moderately complex analysis.
• Performed Data Validation of the data flow from the front-end to the back-end using SQL to perform the Back-end testing on the database.
• Responsible to create UI designs, UI mock ups and write business rules.
• Identified and documented business process re-engineering opportunities including current and future state process flows.
• Created written and oral communication artifacts that effectively summarized findings, supported fact-based recommendations and provided appropriate detail to substantiate conclusions.
• Effectively communicated requirements details to all stakeholders and varying levels of the organization.
• Maintained and kept track of stakeholder's requests for enhancements. Used Microsoft Team Foundation Server and Rally to manage the team's software development lifecycle.
• Conducted GAP Analysis of the different reports that were being presented to clients to accommodate their requirements for the new enhancements.
• Actively managed to deliver and supported claims edit and proxy fee schedule.
• Extensively worked on Custom Eligibility Service Calls and 270/271 eligibility request and response files to map client data.
• Implemented provider files CVS proprietary Flat file and CMS Provider file.
• Extensively worked and implemented 278 Authorization Extract, CVS Standard Authorization Extract and Custom Authorization Extract.
• Worked with account management team to help understand and upgrade vendors with product enhancements on a regular basis.

Environment: Agile/Waterfall, ALM, JIRA, SharePoint, MS Office Suite, MS Visio, Rational Requisite Pro, Rational Rose, SQL, UML, HTML HP ALM.

Sr. Business Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Identified potential cross-pillar dependencies, risks, and solution for mitigation approaches.
• Conducted all Scrum ceremonies (Backlog Grooming, Release/Sprint Planning, Estimations, Retrospectives).
• Worked extensively with Quality Engineering to ensure Zero Defect Releases.
• Coordinated with Senior Management modularize Coventry’s products to increase profits.
• Facilitated Agile Training sessions for team members.
• Conducted various team-building activities to increase morale and productivity.
• Extensively gathered requirements from all users, experts, and key personnel to understand the functional requirements.
• Closely interacted with designers and software developers to understand application functionality, navigational flow, and updated them about end-user sentiments.
• Created, assigned, and maintained tickets in JIRA for bugs and defects.
• Led both internal peer review and external reviews of Use Case Specifications and in the process clarifying the finer details of the requirements.
• Requirements elicitation with the Caremark PBM teams for the webservices projects.
• Involved in developing test plans, test conditions, and test cases to be used in testing based on business requirements using Quality Center.
• Created and maintained the Requirement Traceability Matrix between the requirements and other products such as design documents and test plans.
• Conducted User Acceptance Testing (UAT), System Testing, Integration Testing. Validated and helped verify defects to weed out cosmetic problems and keep the project on schedule.

Environment: OO Modeling, Web Sphere, Rational Requisite Pro, Rational Rose, DOORS, Rational SODA, RUP, UML, Load Runner, MS-Project, MS Visio, Java, MS Office, Windows XP, JIRA.

Data Analyst

Confidential, Dayton, OH

Responsibilities:

• Gathered and Analyzed Business requirements walkthrough with the business owners.
• Involved in writing Test Plans and Test Cases.
• Performed testing in different environment as needed.
• Involved in extensive Data Validation by writing several SQL queries and involved in back-end testing and worked to resolve data quality issues.
• Checked claim data and explained finding to client and helped in presenting the information.
• Developed statistical and analytical report from medical claim.
• Highly involved in preparing Source to Target mapping documents.
• Performed Data Analysis and Data Validation by writing SQL queries.
• Assisted in ETL development, documentation, and testing as needed.
• Worked with SMEs to develop business rules that supported the transformation of data.
• Performed analysis of all data “into and out of” and within Confidential as needed.
• Identified and quantified data issues within the organization and assisted in the development plans to resolve data issues.
• Facilitated discussions between end users and data modelers as needed.
• Monitored the quality of data submitted to regulatory agencies.
• Supported the Verification of Data Accuracy.
• Supported regular data management processes and ad hoc user requests.
• Created several reports monthly/weekly based on various Campaign for different end users.

Environment: Teradata, SQL Assistant, MS Excel, MS Office, SQL Server (Facets), Informatica, HPQC, ALM.

Data Analyst

Confidential, New York, NY

Responsibilities:

• Conducted business requirements walkthrough with the business owners.
• Gathered essential business requirements and transformations.
• Coordinated with business analysts to resolve the data gaps.
• Identified source and prepared source to target mapping documents.
• Served as a liaison between business, IT, and the data analysis teams.
• Worked with Massively Parallel Processing to provide higher level of availability and scalability.
• Divided the larger problem into small units for processing across SQL.
• Worked with SME’s, process owners and process managers to identify logic for the reports and set appropriate thresholds for defects/exceptions.
• Analyzed, documented, and prioritized CTQ’s (Critical to Quality) processes.
• Wrote complex Teradata SQL queries to pull the metrics for CTQ’s, in order to ensure that the process is within agreed tolerance limit.
• Involved in extensive Data validation by writing several SQL queries and involved in back-end testing and worked to resolve data quality issues.
• Regularly provided valuable feedback to the Dashboard team so as to enhance the visual reporting experience for everyone involved.
• Worked with the Business Intelligence(BI)/Execution Team to transit reports for day-to-day business use.
• Worked with the Process Engineer to build current and future state documents.
• Worked on Data Quality, Data Retention, and Data Governance.
• Clearly communicated information to diverse audiences.

Environment: Teradata SQL Assistant, Tableau, SAS, MS Excel, MS Visio, MS Office, Windows XP

Data Analyst

Confidential, Downers Grove, IL

Responsibilities:

• Met with various groups including business owners, SMEs (subject matter experts), and marketing team for data requirements gathering in definition Stage.
• Performed Document Analysis to create Gap Analysis for client requirements, generated workflow process, flow charts, and relevant artifacts.
• Defined and documented the vision and scope of the project in Data Requirement Documents and Requirement Specification Document.
• Performed Data Mappings based on the specified data requirements and to check for data uniformity and to modify/update the data fields.
• Verified Source to Target mapping and data validation.
• Helped design and implement processes for deploying, upgrading, managing, archiving, and extracting data for reporting.
• Helped testers to define testing strategies based on the mapping.
• Wrote queries for SQL to pull required information from the database.
• Worked with the clients on the final signing process in the User Acceptance Stages.
• Knowledge and experience with consolidating data from different sources for analysis and reporting.
• Performed database quality evaluations for adherence to data quality standards, identification of data relationships and potential data integrity issues.
• Assessed and developed long-term strategic data governance goals, data quality assurance processes, master data management administration, and data retention life cycle policy implementation.
• Developed Data Security policy and processes.
• Obtaining, organizing, defining subject area Meta Data in applicable repositories (Teradata, SQL Server, Oracle).

Environment: Windows Vista, MS SQL Server, MS Visio, Oracle, Web Logic, MS Project, Informatica, Business Object XI, UAT, Defect Tracking Matrix, Teradata.