SUMMARY

• Business Analyst / Systems Analyst with 7+ years industry experience in business data modelling, software requirement analysis, process modelling, process flow, quality assurance skills and Software development lifecycle management.
• Experienced Data Warehouse Analyst who is well - versed in several databaseplatforms and proficient in several kind of extraction transformation and loading tools.
• Experienced in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence)using Informatica Powercenter 10x,9x.
• Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
• Experience on implementing a new customer relationship management (CRM) system.
• Knowledge on Data Warehouse concepts & experience in developing Data Warehouse & Data Marts.
• Excellent in preparing UML diagrams - Use cases, Activity diagrams, Sequence diagrams, Class diagrams, Data Flow diagram, Process Flow diagram, etc using modeling tools like Rational Rose and MS Visio.
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Experience in conducting GAP analysis, User Acceptance Testing (UAT). SWOT analysis, Cost benefit analysis and ROI analysis..
• Expertise in Analysis of Problem Severity, Defect tracking and reporting system.
• Strong communication, problem solving, organizational, interpersonal, and presentation skills.

TECHNICAL SKILLS

Business Tools: MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, Doors Erwin Data Modeller 4x, Business Object (Crystal Reports)

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modelling & Analysis, Environment and Market Research Analysis

Methodologies: Agile,Waterfall,RUP, UML & Business/Data Modeling

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker

Operating Systems: Windows XP/Vista/Windows 10/08/07, Unix, Linux,Redhat

Databases: ETL (Informatica),Oracle 11g/10g/9i, MySql, SQL Server, Netezza

Dimensional: Data Modeling,Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling

Database Tools: Oracle SQL Developer, SQL Plus, Toad, Aginity Workbench, MySql Xampp

Languages: SQL,Unix Shell Scripting, PL/SQL, XML

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst/Business Systems Analyst

Responsibilities:

• Performed Requirement Analysis by gathering both functional and non functional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Responsibility in design, implementing ecommerce applications preferably using hybris commerce suit integrating with various enterprise services.
• Worked with end users to design business requirements of a Business CRM System and manage B2B processes of distribution across the region.
• Performed data query, extraction, compilation, and reporting tasks using SQL application.
• CoordinatedInformaticaMDMUpgrade and defined required for new Match-Merge Rules, created user exits, added new rules to the publication strategy andInformaticaData Director Enhancement.
• Analyzed, standardized, documented and maintain global processes and procedures for working with CRM.
• Provided on-site floor support after each deployment to ensure business unit satisfaction eCommerce Team.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Participated in User-Story creation on JIRA along with acceptance criteria plus working on UML diagram creation.
• Involved in Installation and Configuration of Informatica MDM Hub, Informatica Power Center.
• Worked across functional teams to facilitate CRM analysis such as dashboards and reports.
• Involved in Agile Sprint planning meeting Performed CRM system administrating including Configure system wide settings, setting entity and global auditing, setting duplicate record detection roles and schedule detection jobs.
• Developed schemas for extraction, transaction, and loading (ETL) using Solonde Warehouse Workbench to expedite data integration between systems.
• Involved withInformaticateam members in Designing, document and configure theInformatica MDMHub to support loading, cleansing, matching, merging, and publication ofMDMdata.
• Using Shared Containers and creating reusable components for local and shared use in theETL process.
• Perform ETL (SSIS) procedure to develop jobs for extracting, cleaning, transforming and loading data into Data warehouse.
• Perform business analysis for Data warehouse/BI based systems and deliver high level scope and functional specification documents for ETL, BI Reports design/development.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate and test transformation rules used in source to target mappings/source views, and to verify data in target tables.
• DevelopedETLmappings when necessary using Informatica tool to facilitate data loads.
• Performed after Action/Post Milestone Reviews and quality reviews to ensure that developed software products met the business needs and are in compliance with RUP and CMMi 3.

Envirinment: Rational Functional Tester, ETL Testing, Rational Manual Tester, Rational Performance Tester, Data Warehouse, Rational Requisite Pro, Rational Clear Quest, Informatica Powercenter 9.6 and Informatica Powercenter 10.2, JIRA, In Focus, Oracle, Oracle apps, DB2.

Confidential

Technical Business Analyst

Responsibilities:

• Performed Requirement Analysis by gathering both functional and non functional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering.
• Interacted with department heads to finalize business requirements, functional requirements and technical requirements and also created Business process model.
• Facilitated JRP sessions between technical and regulatory teams for meeting requirements as well as solving problems on a daily basis
• Involved in creation and reviewing of Functional Specifications and created a Functional Requirement Document
• Used Rational Requisite Pro to improve the communication of project goals, enhance collaborative development, reduce project risk and increase the quality of application before deployment.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Designed and developed Project document templates based on SDLC methodology
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases) and modelled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
• Followed the adaptive RUP framework for the whole Project life cycle (PLC).
• Worked out solution structure that will mirror the existing structure used for actual reporting. This means, that there are no differences between the accounting structure used for actual reporting and the one used for plan determination.
• Developed customized SQL reports and queries for management decision-making and operational management.
• Fine tuned search engines and pulled data from different databases and migrated data back and forth using SQL.
• Involved in creation and execution of manual test cases in Mercury Test Director and automated Test Cases in QTP and analyzed the Test Results.

Environment: Windows XP,Jira, Agile,Watefall, Red Hat, Mac OS, ASP.NET, ETL Testing, LotusNotesMail, XML,Quick Test Professional (QTP), TFS Bug Testing, Windows, MS Project, VISIO, MS Office, JIRA, XML Spy.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Reviewing project documentation for clarity/ completeness and potential domain or function impact.
• Working with functional BA’s creating Use Cases Inventory by process/project and assign owners for completion.
• Update estimate based on completed high-level requirements.
• Participated in Stakeholder Management to communicate effectively with the right stakeholders.
• Creating Use Case scenarios and work flow diagrams after requirements gathering.
• Creating business flow diagrams using MS-Visio.
• Strong usage of Subject Matter expertise in Fixed Income, Equities, Equity Swaps, Equity Finance, Stocks Trading Cycle, Portfolio Analysis, Asset management, Bonds and Bond Trading Cycle, Bond Pricing, Derivatives (Options-Including Vanilla and Exotic and Futures/Forwards), Credit Derivatives, Interest Derivatives, Alternative investment, Portfolio Management, Sales and Marketing.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle
• Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Used PowerPoint to provide updates on the business processes.

Environment: Windows, Agile,waterfall,Mainframe, DB2, Oracle Apps Finance, Quick Test Professional (QTP), TestDirector, MS Office, Quality Center.