SUMMARY

• Above 8 years of experience in the field of Project Coordination, Project Support, Business Analysis, Data Analysis, Risk Analysis, Business Processes, Project Management, Software Development and Validation of Web Based and Client - Server, Multi-tier Applications, spanning various fields including Finance, Banking/Mortgage, Sales/BI, Marketing, Legal, Financial, Media and Service Institutions.
• Extensive experience to analyze and document business requirements and system functional specifications including use cases.
• Strong knowledge of SQL in database design and stored procedure development, with knowledge of tools like Informatica (ETL).
• Strong knowledge in reporting tools like SQL Server SSRS, and business objects. In depth knowledge of Microsoft Office tools including Word, Excel, Power point, Visio, MS Office Project and network diagrams for tracking projects. Involved in design reviews and validation of the finalized data models.
• Experience in providing technical support and preparing technical documents for the end user.
• Worked with various project team members on security for developing various applications. Have also dawned the admin role in sales force for some time in managing accesses for certain users.
• Good knowledge of Business Analysis methodologies and Iterative Software Development Life Cycle (SDLC) and Agile methodologies like SCRUM.
• Thorough knowledge of implementing RUP in all four phases of a project i.e. Inception, Elaboration, Construction and Transition.
• Experience in conducting GAP analysis & conducting JAD Sessions.
• Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions.
• Ability to manage multiple project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to team related tasks, team meetings, team interaction and conference calls.
• Adept at working with diverse technical groups and end users to develop technical solutions that meet or exceed expectations along with good analytical, communication and problem solving skills.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
• Strong experience in software testing process including planning tests, writing test scripts, executing tests, and tracking defects using mercury tools.

TECHNICAL SKILLS

Environment: C, C++, C Sharp, Asp.Net 3.0, Java, HTML, XML, Web Services.

Methodologies: RUP, SDLC-Waterfall, Agile, SCRUM, Gap Analysis.

Database Servers: SQL Server 2008/2012, Oracle 10g/11, MS Access, Microsoft Visio 2000.

Automation Tools: MS Visio, Rational Rose, Rational Requisite Pro, SharePoint

Utility Tools: MS Office Suite, MS Project, Adobe Photoshop

Business Modeling Tools: MS Visio, MS Project, MS Office, Rational Rose, UML and Rational Requisite Pro.

Defect Tracking Tools: Rational Clear Quest, Test Director, and Quality Center.

Programming Languages: SQL,PL/SQL, teradata

Domain Knowledge: Insurance, Finance, HealthCare, Retail

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Data Analyst

Responsibilities:

• Gathered requirements, analyzed and wrote the design documents.
• Ensured compliance with established internal control procedures by examining records, reports, operating practices, and documentation.
• Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Prepared High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Was responsible in using MDM to decide how to manage their life cycle, cardinality, complexity and Collect and analyze metadata about the master data.
• Performed Data Profiling and Data Quality.
• Responsible for defining the key identifiers for each mapping/interface.
• Wrote requirements for designing data marts that were used as a source for the various reporting systems in the company. Performed Data Analysis, Data profiling and Data validation by writing SQL queries using Teradata Client
• Responsible for supporting the Operations support team with releases deployed to Production. Helped Business in ad-hoc reporting request and data pulls.
• Worked closely with Data Scientist in providing advice and counsel to the customers on data science solution and implementation.
• Strong understanding on Data Modelling in data ware house such as star schema and snowflake schema.
• Worked on Metadata using Ab initio.
• Perform gap analysis of current state to desired state and document requirements for control gaps identified
• Implemented Referential Integrity using primary key and foreign key relationships and assigned appropriate cardinality between entities and documented it.
• Reverse Engineered the Existing databases for analysis and complete comparing.
• Designed and changed existing data model as per business requirements.
• Utilized Agile methodology to configure and develop process, standards and procedures and created a Business Requirement Document.
• Worked with Agile SCRUM process for the Risk Data team and utilized Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings.
• Derived functional specifications document based on the User Requirement Specification and used JIRA for documenting requirements.

Environment: Oracle 10g/11g, Erwin 9.1, Sybase Power designer 8.5, CA Harvest, MS Access 2007, MS Excel 2007, MS Word 2007, MS Outlook 2013, Teradata 15.10, Crystal Reports 7.0, PowerPoint 2007, MS Team Foundation Server (TFS), 2013.

Confidential, Austin, TX

Business Analyst

Responsibilities:

• Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business Requirement Document.
• Identified various business processes and developed process flow diagrams for the business processes and validated the same with SMEs.
• Developed test cases from functional requirements documents from the software development team.
• Conducted individual and group (JAD) sessions with business stakeholders and technical units.
• Utilized Rational the requirements and requirement change requests during various phases of project life cycle.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Conducted walkthrough with the Testing, Development team and stake holders.
• Co-Managed the Change Control process for the entire project as a whole by facilitating group meetings, one-on-one interview sessions and email correspondence with work stream owners to discuss the impact of Change Request on the project.
• Created Datasets, Maps, also and Process using Pervasive Data Integrator. Handled pipe delimited files, fixed format files in pervasive data integrator.
• Deployed the pervasive process to production servers and scheduled the process to run daily, weekly, monthly.
• Intensively worked on claims, providers, suppliers using Healthrule manager.
• Handled production issues and resolved them to meet the deadline
• Experience working in formal life cycle methodologies i.e., agile.
• Capable of functioning in an agile development environment, at times extracting data to enable discovery to help refine report specifications.
• Participated in daily standup, scrum sessions, team retrospective sessions. Participated in a small, experienced, energetic team on a rapid, agile development schedule.
• Effectively used TFS to update user stories and tasks to show the performance.

Environment: HP Quality Center, MS Project 2010, MS Access 2010, MS Excel 2010, MS SharePoint 2010, Pervasive Data Integrator V9

Confidential, Baltimore, MD

Business Analyst

Responsibilities:

• Researched on Business Requirements (BR), documented System workflow procedures, planned the project flow.
• Documented requirements & translated requirements into functional specifications.
• Facilitated team meetings to coordinate activities for project schedules with the management, Marketing & Sales Managers, clients, SME and Technical managers by conducting JAD Sessions
• Planned deadlines assigning the responsibilities, monitored and summarized project progress on weekly basis
• Extensively used MS-Visio for Business Modeling. Created - Business Use case Models and Business Object Models and Activity Diagrams.
• Reviewed test cases and test plans for Business Acceptance and User Acceptance Testing
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process as per Rational Unified Process CMM (Capability Maturity Models) and Rational Tools used during various phases of RUP.
• Proactively identified, analyzed and communicated project issues and risks.
• Used UML approaches to deliver the use cases, conceptual and detail designs, architectural flow, test plans, and business requirement
• Created business process workflow diagrams usingBusiness Process Modeling Notation(BPMN)
• Identified and documented business rules and created detailed Use Cases on different scenarios
• Acted as a resource in understanding how System carry out business functions and assisted in ensuring the timely and effective implementation
• Developed timelines for project delivery, and managed projects and resources to successful completion
• Trained End-users and customer service agents on the CRM (Customer Relationship Management) application

Environment: MS Office 2010 (Word, MS Excel, MS PowerPoint, MS Visio), SharePoint 2010, SQL Server 2008.

Confidential, New York, NY

Data Analyst

Responsibilities:

• Complete study of the in-house requirements of the project for data analysis.
• Closely worked with Business Analyst on requirements and validation process in the requirements walkthrough meeting.
• Delivered data integrity documents, which included the processes for validation, management of requirements and activity diagrams based on inputs from various lines of business.
• Performeddata profilingto analyze and to support devising data quality controls (valid value ranges, relationships between data elements, business rules & reasonability checks).
• Reviewing the Source to target mapping documents.
• When retrieving data from EDW to the Data mart, involved in denormalizing the tables whenever needed.
• Provided tech team support for SDLC Data Warehouse. Analyzed the Source data, helped Business Analyst by providing required SQL queries. Validating the source to target mappings.
• Worked on Data Quality Validation using Informatica. Close interaction with the BAs and ETL team throughout the project. Attended daily status meetings for the reviews.
• Created test plan and scripts for testing the target databases. Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Helping the ETL team on production by validating the loads after each load.

Environment: SQL Server 2012, SSIS 2012, SSRS 2012, Windows XP, MS Excel 2010, MS Visio, IDQ, MS Access 2010, Query Management Facility.

Confidential, Dover,DE

Data Analyst

Responsibilities:

• Complete study of the in-house requirements of the project for data mapping.
• Mapped Source to Target using EDM (Database Mapping Tool). Attended daily meetings with the mapping review teams using webex application.
• Helped Business Analyst by providing required sql quarries for the EDM Tool. Actively participated in the project planning sessions and gave estimates to the project manager.
• Discussed the Business Requirements with the Data Architect, Data Stewards, Project Development Team, ETL Development Team and Identified the Gaps if any. Fill the Gaps Identified by involving the Business and the concerned team in JAD sessions.
• Created the Data Process Flow Diagram in Visio. Profiled the data quality using Toad for Oracle, SQL server Management studio.
• Design, development, testing, performance tuning, deployment, and support inData warehousesystem.
• Developed strategies for data extraction from various source systems, transformation and loading into data warehouse target systems. Performed the activities necessary to support the standardization of facts and dimensions.
• Perform Data Profiling and Data Quality Analysis to analyze and to support devising data quality controls using Informatica. Worked with DBA group to create Physical Data Model from the Logical Data Model using Forward engineering in Erwin.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Used Metadata tool for importing metadata from repository, new job categories and creating new data elements. Did the Quality Analysis and prepared the quality analysis document.
• Prepared Process analysis and the data analysis documents. Generated DDL queries for creation of new database objects like tables, views, sequences, functions, indexes, packages, stored procedures, roles and granting privileges for the users.
• Assisted the developers in designing the overall ETL strategy. Assist with UAT of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

Environment: ERwin 7.2, Sql Server 2008, Sybase Power designer, Informatica Data Explorer Windows NT, Unix, MS Excel, MS Visio, SSIS, SSRS, ER studio, Oracle 11g/10g, TOAD 11.6, MS Access, CSV files, XML files, DB2,Data Stage, Clear Case, Query Management Facility.

Confidential, Bellevue, WA

Business Analyst

Responsibilities:

• Conducted analysis of business processes and identified technology enabled Improvements.
• Gathered all the business requirements from the end users keeping in mind their need for the application, and documented it for the developers using Rational Requisite Pro. Facilitated session with SME’s in understanding the requirements.
• Implemented the Agile methodology of application development with its various Workflows, artifacts, and activities. Was responsible for writing the test plan and test cases.
• Created FRD-Functional Requirement Documents, Use-Case Realization Documents,Business Specifications and Mapping documents, for development and QA team.
• Designed and developed use cases, activity diagrams, and sequence diagrams usingUML.
• Used Rational Clear Case, a Configuration Management tool, to maintain different builds of the application with description about all changes and versions.
• Created flow charts, sequence, class, activity and use-case diagrams using Microsoft Visio according to UML Methodology.
• Prepared Business Workflow Models that covered how business processes are accomplished.
• Once a specification has been submitted to a developer, coordinated with them to ensure they have a full understanding of the requirements, designing of application to make the implementations.
• Interacted with the developers in resolving the reported bugs and various technical, issues.
• Tested the final application for User acceptance testing (UAT) to verify whether all the User Requirements were catered to by the application.
• Identified and documented Issues, Risks, and Gaps, and their descriptions and impact, and provided recommendations and alternatives.
• Gave Presentations periodically to the management and end users during various phases of Software Development Life Cycle (SDLC) and also trained end users.

Environment: MS Project, Mercury Quality Center, MS Visio, MS Excel, SQL, MS SQL Server.

Confidential, New York, NY

Junior Business Analyst

Responsibilities:

• Conducted meetings/working sessions to focus on analyzing and obtaining requirements from all target user groups, SME’s.
• Responsible for gathering and documenting Business Requirements and Functional Requirements in BRD and FRD.
• Conducted the GAP, risk analysis and presented the issues and concerns at the JAD sessions to all the stakeholders. Documented the proceedings of the JAD session.
• Utilized the Requirements Traceability Matrix to ensure that all teams are using the right and appropriate requirements and sub-requirements for the ultimate satisfaction of customer needs.
• Prepared and consolidated all mock-up/UI design, logical and business flow modelling, and requirements gathering activities.
• Authored high level and low level use cases use case diagrams, sequence diagrams, data flow diagrams to define system interactivity and specify functional based on UML methodologies.
• Organized, keyed and maintained project plan and milestones into MS Project to prioritize the multiple tasks.
• Adept with industry standard methodologies like Rational Unified Process (RUP), object oriented Analysis and Design (OOAD) and Agile Methodology.

Environment: Microsoft Visio, MS office

Confidential

Business Analyst

Responsibilities:

• Acted as a liaison between the business units and Information Technology divisions to ensure business needs were fully identified, requirements gathered and solutions developed to improve functionality and effectiveness.
• Completed Use Cases in BRD's as needed.
• Prepared and coordinated user acceptance testing, tracked results and provided appropriate reporting and change recommendations.
• Partnered with support teams to develop and provide user training and support.
• Conducted JAD sessions with the business partners and technical development team.
• Built and fostered rapport within the business areas to gather information and to influence participation and decision-making.
• Worked closely with project managers, business users and developers to formalize a business idea and define requirements using Rational Requisite Pro.
• Worked closely with the Business Unit and the SME's to gather Business and System requirements, analyze, and document them in the Business Requirements Document.
• Hit target deadlines for project with aggressive deadlines and immovable go-live date.
• Strongly experienced in Manual and Automated testing using tools including HP Quality Center, Quick Test Professional.
• Formulated User-Acceptance Testing requirements documents and test scripts.
• Coordinate the test results, prioritize the issues found and enhancements requested, and maintain the status log of issues to facilitate resolution.
• Created extensive documentation for user manuals, processes, and procedures geared toward diverse audiences.
• Significantly involved in the development of product enhancements and implementation of parameters into the loan origination system.

Environment: s: Rational Rose, Rational Requisite Pro, MS Project, JIRA, HP QuickTest Professional, HP Quality Center.