SUMMARY

• Over 8+ years of all - encompassing experience as a Data Analyst with a frontline leadership role in System Development Life Cycle (SDLC), Testing Methodologies and techniques, and Unified Modeling Language (UML) using modeling tools such as Rational Rose and MS Visio.
• Worked with team to document existing and end-state model, reporting requirements and phasing.
• Knowledge of SDLC methodologies such as Waterfall, Agile and Rational Unified Process (RUP) components in all four phases of a project: Inception, Elaboration, Construction and Transition.
• Demonstrated experience in deriving business requirements that are representative of standards, both technical and theoretical as set by multi-disciplinary teams.
• Experience in Financial Systems Analysis within a fast moving global project environment.
• Experience in data profiling on various source systems that are required for transferring data to ECH using Informatica Analyst tool.
• Experience in Informatica Master Data Management (MDM) to extract, transform, load (ETL) data on Oracle Database Management.
• Excellent design and documentation production skills; can clarify details with precision and accuracy.
• Demonstrated ability to compile, present and discuss options and then agree approach.
• Efficient in gathering, documenting and validating teh requirements in a format that is useful to teh business area experts and teh technical team.
• Worked with QA and Dev teams to ensure specifications are complete, unambiguous, understood and adequately tested.
• Experience in working with open source tools Selenium (Selenium IDE, Selenium RC, Selenium Web driver and Selenium GRID), JUnit, Eclipse and preparation of automation test framework.
• Expertise in creating JUnit and TestNg testing frame works.
• Experience in testing applications, trouble shooting issues and be able to work independently.
• Worked with GCBM and IT to understand, clarify, review and document future-state.
• Experience in coordinating Joint Application Development (JAD) sessions and interviews to converge towards a design acceptable to teh customer and feasible for teh developers.
• Identified and explained gaps between required behavior and what is achievable in project timelines.
• Position will be responsible for supply chain report creation and analysis such as inventory turns, days stock on hand, and fill rates.
• Interacted regularly with development team, database designer, system administrator and teh senior management to meet teh deadlines of project milestones.
• High level of technical proficiency in writing business documentation.
• Proficient in writing detailed use cases, developing test cases and working with QA teams during testing.
• Experience in equipment, material forecasting metric creation and analysis.
• Skilled in coordinating and communicating between Developers, Management, QA team, project lead and stakeholders to keep them informed at all teh times about teh development and teh open issues.
• Monitored, interrupted and reported on trends, variances and anomalies such that management may take corrective action.
• Excellent analytical skills to understand teh business process, functionality and requirements; and translate them to system requirement specifications.
• Hands on experience in using MS Office Suite, MS Project, Rational Requisite Pro and MS Visio.
• Conducted functional walkthrough, User Acceptance Testing (UAT) sessions and assisted teh development of User Manuals for customers.
• Proficient in creating Business Requirement Documents (BRD), Functional Requirement Specification (FRS) document, User Requirement Specifications (URS) document, UML Modeling - Use Case Diagrams, object diagrams, Activity Diagrams,and Sequence Diagrams.
• Strong knowledge of Investments especially in Stock Market and Trading such as Options, Derivatives, Mutual Funds and Bonds.

TECHNICAL SKILLS

Operating Systems: Windows NT/98, XP, 2000, UNIX, LINUX

Application Software: MS Office - MS Word, MS Excel, MS PowerPoint

Databases: SQL Server, Oracle, MS Access & DB2

Web Technologies: HTML, XML, Dream Weaver

Methodologies: RUP, Waterfall, SCRUM, AGILE, Data Modeling

Requirements Management Tools: Rational Requisite Pro, MS Visio and MS Office

Testing Tools: Test Director, UAT, Win Runner, Quick Test Pro, DOORS

Process Modeling: MS Visio and Rational Rose

Documents & Processes: SRS, BRD, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modeling, Project Planning & tracking

PROFESSIONAL EXPERIENCE

Confidential, East Moline, IL

Sr. Data Analyst/Business Analyst

Responsibilities:

• Participate in teh design, development and implementation of technical specifications for projects.
• Work with business users, higher management for gathering and analyzing requirements.
• Created meeting templates for teh JAD/JAR sessions, acted as a facilitator to gather requirements and validated it with stakeholders/end-users/clients.
• Created storyboards as a tool in Agile Scrum methodology to simplify teh realization of use cases which were derived from business requirements.
• Writing assessment (scope) documents for approval for project by Client
• Writing BRD (Business Requirement Document) from gatheird requirements
• Deriving Use Cases from developed matrix where necessary.
• Critically evaluates information collected from multiple sources, reconciles conflicts, decomposes high-level information into details, and distinguishes user requests from teh underlying true needs.
• Document teh acquired results of analysis and workflows as well as obtains sign-off from teh appropriate clients.
• Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites (JUnit, Maven)
• Provide suggestions to teh development team during teh development stage of product to meet teh client's business needs. Designed Concept diagrams, Workflow diagrams, Use Case diagrams, Activity diagram using UML modeling tool Visio and documented teh requirements using Business Requirement Document (BRD).
• Work with application development teams to support product development in all phases of SDLC.
• Create and modify existing hundreds of reports and forms using Sybase/SAP Info Maker 12.5 according to customer requirements.
• Design and develop complex Power soft reports like Sub reports, Cross tab reports, Formulas, Parameterized reports, Dynamic grouping reports and Summary reports.
• Wrote T-SQL Queries including sub queries in creating Power soft reports.
• Modify teh existing reports by addingnew logicand deletingexisting logic according to teh business requirements.
• Interacted with teh QA team to performed Unit and Integration Testing for multiple transactions and implemented Alpha Test in order to confirm teh functionality of recent conversion.
• Migrate reports from Dev to Production and Provide on call support after reports aredeployed to production.
• Assist in testing efforts, perform unit testing and fixes during testing process.
• Assist teh support team during deployment.
• Work with Order Fulfillment Group to understand end customer requirements.

Environment: Agile Methodology, EQUIP 14.1, SAP Sybase SQL Anywhere, TortoiseSVN, Sybase/SAP InfoMaker 11.5/12.5, Adobe Photoshop Elements 9, MS Office 2010, Windows 7 Enterprise, Rally Software, SAP Crystal Reports 2013, UAT.

Confidential, Monterey Park, CA

Data/Business System Analyst

Responsibilities:

• Implemented Agile process with a cross functional team.
• Conducted analysis of business processes and requirements and identified technology enabled improvements.
• Developed efficient, scalable quantitative risk models and methodologies for ongoing transaction monitoring of AML risk.
• Developing Data Mapping, Data Governance, Transformation and Cleansing rules for teh Master Data Management (MDM) Architecture involving OLTP, ODS and OLAP.
• Created a Product backlog with prioritized list of user stories.
• Created user stories from day to day Scrum standup meetings.
• Teh Scrum team developed teh Burndown charts during teh progress of each Sprint.
• Designed Use cases using UML, for teh user stories developed in teh Sprint iteration process.
• Provided cost estimates to define teh business value of teh desired features.
• Translated business requirements into functional specifications for technical team.
• Sprint logs are carried out in timely fashion and updated monthly by teh Scrum team.
• Teh Scrum review meeting was conducting after teh end of each Sprint.
• Knowledge of Remedy to manage Mortgage application regarding IT, Security and Business needs.
• Understanding of Web Development documentation.
• Coordinated work plan between project manager and client; implemented and managed migration process; scheduled and tracked progress for team members of project through completion.
• Reviewed teh work done by scrum team at teh end of each Sprint.
• Develop benchmark CCAR models for option adjusted spreads across teh bank's fixed income portfolio, which includes RMBS, MBS, ABS, munis, corporate bonds, covered bonds, hybrids, sovereign, international corporates and others.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Comfortable working within large and fluid project environment with many interdependencies.
• Assisted in development of training materials for new technology and process improvements.
• Reviewed technical design and test case documentation, raised and resolved issues.
• Worked with controllers during UAT to analyze, explain and fix issues that arise.
• Provided analytical support and problem resolution for existing customers.

Environment: Windows, Power Point, MS-office, QTP, Quality Center, Informatica MDM, SQL Server, UNIX, Agile - Scrum, User Story cards, Burndown charts.

Confidential, Charlotte, NC

Data/Business Analyst

Responsibilities:

• Conducted JAD sessions and gave executive presentations in MS PowerPoint for communicating with Stakeholders and Project directors.
• Work with users to identify teh most appropriate source of record required to define teh asset data for financing
• Perform data profiling in teh source systems that are required for financing
• Document teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining teh trumping rules applied by Master Data Repository
• Define teh list codes and code conversions between teh source systems and MDR.
• Created and defined trust-building processes needed for enterprise-wide adoption of metadata registry. Familiar with stakeholder analysis, data stewardship and adoption of metadata registries by development staff.
• Use Informatica Master Data Management (MDM)) from various database to to extract, transform, load (ETL) data on Oracle Database for grants data management
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Involved in defining teh source to target data mappings, business rules, business and data definitions
• Responsible for defining teh key identifiers for each mapping/interface
• Responsible for defining teh functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with teh requestor and coordinate with teh development and testing team.
• Dealt with Master data (MDM), Transaction data, Control data etc.
• Involved in configuration management in teh process of creating and maintaining an up-to-date record of all teh components of teh development efforts in coding and designing schemas
• Developed teh financing reporting requirements by analyzing teh existing business objects reports.
• Responsible in maintaining teh Enterprise Metadata Library with any changes or updates
• Document data quality and traceability documents for each source interface
• Establish standards of procedures.
• Generate weekly and monthly asset inventory reports.
• Coordinate with teh business users in providing appropriate, TEMPeffective and efficient way to design teh new reporting needs based on teh user with teh existing functionality
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica MDM, ER Studio, XML, Business Objects

Confidential, Rockville, MD

Business Analyst

Responsibilities:

• Project responsibilities included documenting identified activities to research, prioritizing teh assigned activities to ensure deadlines are met, evaluating issues and concerns, coordinating with teh project team on teh activity status and documenting activity resolution.
• Designing functional specifications for teh target physical database.
• Reengineered teh business process of teh legacy system.
• Facilitated JAD sessions for requirements verification with DHHS to gather requirements for teh new MMIS.
• Documented BRD and validated requirements and signed off.
• Designed processes, sub-processes & confirming it against teh functional requirements.
• Experience in equipment, material forecasting metric creation and analysis.
• Facilitated meetings with teh technical team and client team to analyze teh current process and gather requirements for teh proposed process.
• Analyze EDI data elements captured by teh existing system to validate it against teh data elements required for new system.
• Communicate teh Gap Process Analysis with teh state and fed that into teh requirements traceability matrix.
• Used Microsoft SharePoint as teh version tracking tool for managing teh requirements documentation.
• Create monthly/weekly status reports to update teh project schedules & deliverable plan.
• Participated in developing test scenarios and designed user documentation.
• Propose strategies to implement HIPAA 4010 in teh new MMIS system.

Environment: RUP, MS Office, Windows, .NET, MS SharePoint, MS Project, HP Quality Center, SQL, UNIX, Oracle, SOA, HTML.