SUMMARY

• An IT Business Analyst / Data Analyst with 8 years extensive experience in Software Development Life Cycle (SDLC), Object Oriented Analysis and Design (OOAD), Business Process Re - engineering (BPR), Testing Lifecycle, Unified Modeling Language (UML), GAP analysis, Risk analysis, Cost-benefit analysis, Conducting Joint Application Development Sessions (JAD) and Various methodologies including Waterfall, Agile and SCRUM, Prototyping, Six Sigma (DMAIC), US Payer, Rapid Application Development (RAD) and Rational Unified Process (RUP).
• Extensive acquaintance in gathering Business/Functional user requirements, Creating Use Cases as per user requirements, Developing/Designing Diagrams such as Activity, Class, Sequence Diagrams and in addition to creating Business Requirements Document(BRD)
• Skillfully Documented Business Requirements, Use Case Specification, Functional and Non-Functional specification, UML diagrams including Use Case diagram, Activity diagram, Class diagram, Sequence diagram, Data Flow diagram (DFD), Entity-Relationship diagram (ERD), Requirement Traceability Matrix (RTM), Change-Version Control, Training and User Manuals.
• Experience in working actively during all stages of system developmentLife Cycle, Leading, facilitating and conductingJoint Application Development (JAD)sessions among user community, stake holders and Technical management.
• Strong skills in performingData analysis, Risks analysis and Analyzed workflows.
• Development, Implementation and Integration strategies in a team oriented environment by employing Qualitative and Quantitative analytical skills.
• Proficient in creating of the Test Plan and Test Cases from the Requirements document.
• Documentation of Test Plans, Test Cases, Test Scripts and Test Procedures based on the Design document and User requirement Document for the Black box, Functional, Usability and User Acceptance Testing(UAT).
• Design and Review of the various documents including Software Requirement Specifications(SRS), Business Requirement Document (BRD), Functional Requirement Document(FRD), Requirement Traceability (RTM), Testing documents
• Experience and Understand on US Payer Options
• Knowledge of Data Warehousing (DW), Extraction, Transformation and Loading (ETL)
• Experience in White Box, Black Box, Unit, Functional, Integration, Back End and System Level Load and Stress Testing.
• First line of contact and support, for global users, with payroll, and data migration issues.
• Ability to manage workload under deadlines in addition to multitask projects or tasks.
• Excellent verbal/written communication skills and strong analytical abilities working independently and as a team player.

TECHNICAL SKILLS

Methodologies: RUP, Full SDLC, Agile, Waterfall

Business Modeling Tools: Rational Rose, Microsoft Visio, EA, BPMN1.0, 1.2, 2.0

Requirement Management: Rational RequisitePro, DOORS, Caliber RM

Change Management Tools: Rational Requisite Pro, ClearQuest

Version Control Systems: Rational ClearCase

Testing Tools: Rational Enterprise Suite

Operating Systems: Windows Family, MAC OS, UNIX and Linux

PROFESSIONAL EXPERIENCE

Confidential, IL

Data/Business Analyst

Responsibilities:

• Identifying the non - functional requirements and documenting those requirements.
• Conducted Impact Analysis on systems/Applications, in evaluating the impact of changes on the organization.
• Writing SQL scripts to profile, analyze, validate data and performed data integrity testing.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Developed mapping spreadsheets for source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Extensive experience with Data Analysis on Data warehouse system for various reporting systems within an organization.
• Understanding the business requirements and converting them to functional requirements by analyzing the applications and data.
• Worked closely with project managers, business users and developers to formalize a business idea and define requirements using ALM.
• Reviewed and provided input into the Test Specifications and Scenarios.
• Managed changes to requirements through the approved change management process.
• Worked with customers to put together UAT scenarios and plans.
• Coordinated with customers to help them through UAT, and pilot testing.
• Conducted Impact Analysis on systems/Applications, in evaluating the impact of changes on the organization.
• Participated and interacted with business/technical users and subject matter experts (SMEs) to gather new requirements and enhancements required.
• Involved in data modeling, logical and physical model using ERwin.
• Involved in comparing database catalogs to data models using Compare Utility Tool.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Exhaustively collected business and technical metadata maintained and reviewed the naming standards for the models.
• Responsible for defining the naming standards for data warehouse ( DW).
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Involved in publishing data models to the Erwin Web Portal.
• Responsible as an administrator to the Erwin ModelMart for granting access, library permissions and resolving technical issues for the users.
• Performed Naming and Data Standards review for the data models across the agency.
• Mapped the requirements using RTM to make sure the requirements were covered as per the functionality.
• Performed ETL testing to make sure the data was moved from one data source to another to check correct transformation logic is applied.
• Performed functional, regression testing and detailed integration testing in accordance with the business requirements.
• Reviewed and gained approval from customer on system use cases, business rules, and non-functional requirements.
• Worked with development and test team to ensure they have good understanding of requirements.

Confidential, Chicago, IL

Business/Data Analyst

Responsibilities:

• Gathered requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• Coordinated with several managers for Financial Data within the Financial Departments.
• Created process flow diagrams (As - Is and To-Be) and conduct gap analysis to help business and development teams understand the business processes.
• Conducted several JAD sessions and interviews to elicit system requirements and to document them in the System Requirements Specification (SRS/FRD) using Use Cases and activity diagrams.
• Worked with Business and development teams to gain consensus on requirements and to baseline the documented requirements.
• Analyzed and interpreted the business requirements for QA and design teams using Confidential DOORS.
• Performed numerous data pulling requests using SQL for analysis.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Actively participated in JAD sessions to review and document business processes and to produce high-quality deliverables.
• Created & maintained data mapping templates, Meta data information, tracked the data lineage at various hops to ensure better data quality across various systems.
• Facilitated and resolved outstanding issues with business and technical team.
• Commented the existing code for future references to make sure the new associates could understand why we are implementing the logic.
• Took ownership of the modules to deliver high quality deliverables.
• Wrote SQL queries to perform data quality checks, to know the domain of values and to determine reasonableness conditions for the fields that were getting mapped.
• Performed data analysis & validation by writing complex queries using SQL Server Management Studio.
• Performed ETL testing to make sure the data was moved from one data source to another to check correct transformation logic is applied.
• Performed research on data using pivot tables in excels.
• Utilized bulk copy program (BCP) commands to perform bulk data loads into database tables from external data files.
• Conducted post deployment analysis on production server for new code changes.
• Worked closely with various related groups to resolve the issues preventing alignment on milestones, resources and deliverables.

Confidential, Cincinnati, OH

Business Analyst

Responsibilities:

• Captured key business requirements and specifications, documented requirements and performed GAP analysis for the reporting teams.
• Worked closely with various business units to delegate the requirements based on the business unit role.
• Identified important user scenarios from the functional requirements to develop test cases. Worked with end users to define these test cases for testing functionality as well as integration with legacy systems.
• Responsible for analyzing requirements and creating use case narratives and use case diagrams, sequence diagrams and process flow diagrams. Also, worked with other team members in reviewing requirements documented in the Use Case Diagrams and Activity Diagrams.
• Conducted one - to-one meetings and web-Conferences as well as JAD sessions with different stakeholders; analyzed and came up with suggestions providing consistent process for the communication, escalation, and resolution of issues.

Confidential, Santa Clara, CA

Business Analyst ( BI)

Responsibilities:

• Supported the optimization efforts of finance, partner and product managers, to reduce costs, build better products and enhance collaboration with key business partners
• Trained internal customers on various BI reporting tools and wrote several reference materials on business attributes and metrics.
• Managed BI program performance using customer surveys and optimized workflows.
• Supported the reporting of key performance indicators, such as bookings or renewals.
• Applied analytical expertise for various special projects, such as AR failure rate analysis.