SUMMARY

• Proven success as a Business Analyst with 7+ years of diversified experience in Retail, Banking, and Finance industry.
• Proficient in collecting, understanding as well as documenting the business requirements and business processes for the project, and translating them into functional specifications.
• Strong Business Intelligence with the ability to understand operational aspects of product line and manage projects from a business perspective, and ability to conceptualize creative and innovative solutions for new product development.
• Demonstrated abilities in business systems development, business process redesign, Data analytics, Data Migration and testing.
• Hands on experience with Markit EDM and in databases like Oracle and SQL.
• Experience in transforming business requirements into Functional Requirement Specifications Document(FRD), Non - Functional Requirements Document (NFRD), and Use Case Narratives
• Excellent business writing skills essential for producing various business documents such as Business Requirements Document (BRD), Business Process Documents, Business Flow Documents, User Training Manuals, User Interface Specifications
• Strong problem solving and analytical skills with in-depth understanding of system development methodologies, techniques and tools.
• Experience in all phases of the Software Development Life Cycle (SDLC) including Requirement gathering, Design, Development, Testing, and Deployment.
• Expertise in using methodologies such as (Unified Modeling Language) UML, OOAD (Object Oriented Analysis and Design), Waterfall, and APM (Agile Project Management)
• Proficiency in feasibility analysis, budgeting and estimation, business system operations, and customer/supplier relationship management.
• Broad Knowledge in reviewing Test Procedures, creating Test plans and detailed test plans for UAT, Test scenario, defining Test cases, both System & Integration and executed many test cases. Reviewed and maintained Test Data and executed detailed Test scripts for UAT, analyzing bugs, while interacting with team members in fixing errors and User Acceptance Testing (UAT) and also assisted in post - Production support. Worked on Black box and White box Testing.
• Facilitated test plan/test cases walk through for the Business and Development teams to obtain feedback and/or approval sign-off.
• Creative execution of many projects from scratch to deploy phases across diverse domains
• Efficient in producing documented record of process re-engineering, budget/market analysis, cost-control, and profit improvement
• Hands on experience in databases like Oracle and SQL.
• Acted as a liaison between the client and technical teams. Ensured that the business requirements were clearly and unambiguously communicated to the IT team.
• Generated models to depict business processes and information flow. Expertise in Business Modeling, Business Workflow Chart, and UML Diagrams (Use Case Diagrams, Activity Diagrams, and Sequence Diagrams) using MS Visio and Rational Rose.
• Conducted Requirement Gathering Sessions such as Joint Application Development (JAD), Rapid Application Development (RAD), interviewed Subject Matter Experts (SMEs), Stakeholders for deriving detailed functionality aspects of business process and carefully updated the requirements information in an easily understandable format. Facilitated Disaster Recovery Planning (DRP) sessions
• Experience in creation of SRS for complex multi-disciplined projects
• Experience in conducting GAP Analysis, ROI Analysis, SWOT Analysis, Cost benefit analysis, and SWAG estimates
• Proven ability as a team player and to work independently with the ability to adapt to a new environment quickly.
• Possess strong communication skills (verbal and written) that help in communicating with developers, team members, stakeholders and writing the reports and test documentation.
• Excellent organizational, interpersonal, presentation, communications, teamwork, and leadership skills with proven skill to interact across multiple levels of organization.

TECHNICAL SKILLS

Operating Systems: Windows NT/ XP/ Vista/Unix MSDOS, Linux

Data Base: Oracle, SQL, MYSQL, MS Access, Informatica 7.1

Systems Development: Microsoft Visio, UML Modeling, Rational Rose

Languages: C, C++, Java, Visual Basic, OOD tools, Dot Net

Web Development: HTML, XML, Scripting languages

Project Management: MS Office Suite, MS Project, MS Visio, Share point

GUI/Tools: Cognos, Requisite Pro, Qlikview Clear Case, Clear Quest

Testing Tools: Jira, ALM, HP Quality Center, Rational Test Manager, load runner.

Methodologies: RUP, SDLC, RMM, Agile Development, SCRUM

Industry Standards: ANSI, HIPAA, ISO, Six Sigma, CMM

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Senior Business Analyst

Responsibilities:

• Interacted with SMEs of different divisions (Information Technology, Risk and Operations) and gathered requirements for the successful migration of the data from the source system to the new database.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the target state enterprise data architectures
• Analyzed and documented current applications dependencies with the database.
• Utilized Markit EDM to manage and consolidate complex data management requirements.
• Created technical specifications documents based in the Functional Design documents for the ETL coding to build data mart.
• Involved in the analysis of the accounts and payment processing system, mapping phase according to functionality and data conversion procedure
• Utilized the 80-20 rule to prioritize and in corporate the critical features. Used Time-Boxing techniques to finish within set time frames.
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Planned and defined system requirements to Wire Frames with Use Cases, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created Use Case Diagrams, Activity Diagrams and Sequence Diagrams in MS Visio.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Utilized Quality Center and the Agiletesting methodology for regression, system integration, and user acceptance system testing.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders to discuss open and pending issues.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
• Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.
• Queried the databases, wrote test validation scripts and performed the system testing.
• Utilized data analysis techniques to validate business rules and identify low quality missing data in the existing Amgen enterprise data warehouse (EDW)

Environment: Oracle 11g, Informatica, Microsoft Visio, Rational Tools, UNIX, Erwin, Microsoft Excel, Microsoft Word, Microsoft Access, SharePoint 2010

Confidential, Westlake, TX

Sr. Business Systems Analyst

Responsibilities:

• Interacted with Business users to gather requirements, then analyzed and wrote the design documents.
• Identified and validated business rules and data elements.
• Analysed the end to end data flow and systems delivery for the Retail reconciliation
• Managed the dependencies, project lags, and resources to reach the new milestones.
• Created the WBS and ETC for all of the BA’s involved across 16 different applications within the initiative.
• Documented and sign off the GAP analysis, of the Cash Blotters, Auto settle files, transactions involved.
• Conducted Data Analysis and Data Mapping for the required retail funds (Money Market and Fixed Income and Equity) from legacy to the new Invest One platform.
• Created a process to manage and consolidate relevant financial data with the utilization of Markit EDM.
• Gathered requirements and create the SRA (System Requirements Analysis) and SDS (System Delivery Specification) documents and get sign off.
• Managed resources and timelines based on Work Breakdown Structure, effort analysis and estimated analysis and testing efforts.
• Created an overall test strategy for QA and UAT.
• Interacted with users for verifying User Requirements, managing Change Control Process, and updating existing Documentation.
• Created SIT planning document including eight inter laced applications and drove the testing initiative.
• Developed and reviewed test plans. Executed test cases and facilitated defect resolution.
• Supported on shore and off shore development teams.
• Performed Proof of Concept testing for Traded Vs Settled dates with six different banks - Citi, Chase Manhattan, State Street, Bank of New York, Mellon ( Bank of New York and Mellon are merged, but continue to have separate IT systems), Brown Brother’s and Harriman.

Environment: FSDM (Fidelity Systems Delivery Methodology), Frontier Securities 4.5, Check Free, MS Visio, Share point, JAVA, Oracle, Mainframe, HP Quality Center 9.2, Cognos, Windows NT

Confidential, Camp Hill, PA

Senior Business Analyst

Responsibilities:

• Creation of a comprehensive project plan and detailed task list along with Cost Benefit Analysis(CBA), Cost Expenditure Request (CER) and forecast for the ‘Hippocrates’ project, which is a reporting tool/application that provides multi-dimensional view of the underlying sales, finance and Rx data from the data warehouse and cube.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation and redesign of all ETL logic.
• Executed the project plan, migration plan, and management and scheduling for a data migration project intended to outsource the data warehouse data to 1010Data Corp.
• Maintained, balanced and managed an offshore team size of 10-15 with effective code review, audits along with tracking and scheduling
• Designed the use cases, process flows, check points, validations and other much needed documentation for system modification as per business needs.
• Led and participated many JAD, Requirement Gathering sessions with the business unit and translated them to the developers with supportive documentation and action plans
• Extensive Business Requirement Documentation and Process Documentation and created data trace map and data quality mapping.
• Managed the testing operations in various environments from development to production with HP Quality center and proprietary tools along with detailed test cases, test flow and test plans
• Performed time line budgeting for various projects in both the web team as well as the data warehouse front
• Performed deployment and post deployment release management and scheduled deliveries
• Identified Key Performance Indicators(KPI) and GAP analysis for the ad forecast system
• Worked on exporting reports in multiple formats including MS word, Excel, CSV, and PDF.
• Was instrumental in design, creation of features, translation of business rules and management of a loyalty project - wellness+ which has around 10 Million registered users
• Developed the validation standards and coding standards document that is being used companywide across multiple divisions for code optimization
• Prepared comprehensive Risk document with Risk index and alerts for many projects
• Organized internal training on the new 1010 Data product.

Environment: Oracle, SQL Server, Cognos, Apache Tomcat, Microsoft Visio, Microsoft Project, Share point, 1010 Data/Vision, HP Quality Center

Confidential, Minneapolis MN

Business Analyst

Responsibilities:

• Creation of a new and innovative e-commerce strategy for effective monitoring of retail and E-commerce orders.
• Involved in configuration and enhancement of payment processes and created an e-commerce ground supported by a price variant business model
• Coordinated, and supervised an off-shore development team with timely execution of deadlines and efficient use of resources
• Effective simulation of the entire project from Business View
• Identified and prioritized features(core and ancillary) that need to be developed after interacting with the stake holders
• Performed extensive requirement analysis including Data analysis and Gap analysis
• Created Root cause analysis, Cost Benefit analysis & project charter
• Created Business Case document, Activity diagrams, Sequence diagrams, Entity-Relationship diagrams based on Rational Unified Process (RUP) Model.
• Managed effective control management system
• Created Project Plan, Project Metrics, Project Governance & Business scope document
• Created, maintained & updated steering committee members with reconciliation of actual to planned expenditure, Risks, Issues & Dependencies in a timely manner.
• Created a System to interact with all POS (Point Of Sales) to get demand/supply real time information
• Extensive knowledge on compliance / regulatory laws and experience in reporting to the review committees & preparing documentation for the same
• Gathered requirements. Performed business review & technical review meetings with stakeholders & technical teams
• Performed Strategic analysis including Gap analysis, SWOT, Impact & Risk analysis
• Created Business process flows and work flow diagrams and a detailed SRS.
• Processed and Mapped XML requests and response (transaction based services) as per Business Rules
• Generated reports and used business intelligence tools
• Performed UAT& Created training modules for end users
• Coordinated with the legal team in preparation and analysis of the various legal documents including privacy policy and user agreements.
• Worked in alliance with the marketing team to make the portal SEO friendly

Environment: Java, J2EE, JSP, DOM, Hibernate, Dot Net, SQL, Apache Tomcat, Microsoft Visio, Microsoft Project, HP Quality Center, Share point.

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Conducted various meetings with SME, Vendors, users and other stakeholders to understand the user requirements.
• Accumulated business requirements from various business users and translated them into Business requirements document.
• Documented all the discussions, stored the requirements and tracked the changes maintaining the versions of document.
• Identified the key business processes to model by analyzing the Requirements and modeled using MS Visio.
• Worked closely with the UI team to ensure that the product has consistent look and feel over the entire application platform.
• Conducted walk through of the requirements to the Vendors and the QA team. Participated in testing of the application over the QA environment.
• Conducted various meeting sessions with the development team to understand the technology and the procedure of deployment in the MOSS environment.
• Assured that there is compliance between the requirement and the final product.

Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), MS Project, Windows 2000, Clear Case, Clear Quest.