SUMMARY:

• 8+ years of IT experience with expertise in Business Analysis/ Data Analysis/Data warehousing/Data Modeling and BI reporting.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP).
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server database.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server.
• Extensive experience in Sybase Database Servers, developing and maintaining automated software used to monitor the database
• Knowledge and understanding of Futures, Options, CDO, CDS, CMO, MBS, Interest Rate Swaps, Credit Derivatives, Swaps, Bonds, Equity Swaps, Capital Markets, Fixed Income, Structured Products.
• Compiled MDM System Integration Analysis to identify data touch points, applications, interfaces that will be crucial and have MDM impact.
• Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity - Relationship Diagrams (ERD).
• Extensive experience in configuring data mapping between different Databases.
• Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
• Extensive experience in conducting Joint Application Development (JAD) sessions.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose
• Worked extensively on user requirements gathering, gap analysis, and development of functional speculations for critical mission accomplishing projects.
• Worked extensively on Teradata Analytic Data Platforms
• Knowledge 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).
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Have good experience in Order Management whereby managing orders received from the customers inBAAN, looking to the inventory and matching the customer needs/orders with the inventory.
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Efficient in converting the systems database from Sybase to oracle & vice versa.
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.

TECHNICAL SKILLS

Programming Languages: C, C++, HTML, XML, SQL.

Data Base: MS Access, Oracle (SQL Series), DB2

Project Management: Microsoft Project, Microsoft Office, OLAP Crystal Report

Operating Systems: MS-DOS, Windows, Apple McIntosh, Linux

Software: MS Office Suite(Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes

Performance Testing Tools: Virtual User Generator, Load Runner

Processes/Technologies: Rational Unified Process (RUP), Waterfall, UML & Microsoft Office SharePoint

Automation Tools: Requisite Pro, Win runner, QTP, Test Director, Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. Business Analyst

Role & Responsibilities:

• Gather business requirements; using techniques like interviewing customer & stakeholders, workshops, seminars, presentations, storyboards, JAD and work closely with VP’s, Business partners & Business sponsors.
• Conduct, GAP, end-to-end, Impact, SWOT, Risk, Feasibility analysis for business requests (which are often high-level or lacking in detail) and provide appropriate solutions.
• Create Method /1 project documentation, Business & System Requirement Analysis document K245, Design Report (BSADR), Business Systems Test Report, and Requirements Report, Create screen designs, wireframes, prototypes.
• Based on the physical model, developed strategies for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.
• Responsible for establishing and maintaining positive business relationships with IT managers and clients, and ensuring that business objectives and priorities are aligned.
• Create Process flow diagrams using Visio, Provision tools to depict the business scenario or a solutioning in a pictorial format. All documents created meet the audit requirement from AEMP and external auditor’s compliance standpoint.
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
• Technical responsible for Data Base Oracle and ERPBaanimplementation.
• Supported allbusinessreports withBaanreports and Crystal reports.
• Improved processes, tools, data quality for Master Data Management (MDM), user adoption and deliver results 50% faster and efficiently.
• Extensively used Rational Requisite Pro to facilitate project documentation and collaboration on requirements management, enabling software teams to deliver on key project milestones with greater accuracy and traceability.
• Extensively used Visual Basic to create macros in order to make data migration testing more useful and compared results from the legacy databases to the new CRM database.
• Maintain documentation of current processes and workflows; assist in the design and maintenance of business intelligence dashboards, and conduct user acceptance testing as required for internal system upgrades and new functionality
• Create Use Cases documents, Use Case Diagrams, Activity diagrams, Data Flow Diagrams, Business Flow Diagrams and Navigational flow diagram, Sequence diagrams using UML methodology
• Designed and proposed analysis on Trading systems, Forex trading, Investment banking and securities & Retail & wholesale banking applications.
• Analyzed and designed E-commerce applications which provide the user a window to by & sell products and services. Intermediate hands on experience in various GDS systems such as Sabre, Apollo, Amadeus and their cryptic commands.
• Extensive experience in gathering, managing, and documenting business requirements using MS Visio, Rational RequisitePro and Telelogic DOORS, e-Docs.
• Applied Business Process Management techniques for phases of project, Strategy, Design, and control resource, project. Cost & Time, configuration, reporting & Workflow management.
• Used XML for metadata exchange between various proprietary systems.
• Executed backend queries for validating the data using TOAD.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
• Created customized report using OLAP Tools such as Crystal Report for business use
• Assist with development and testing of Microsoft Dynamics AX.
• Create Test scripts, test cases, Test plans to execute the test phase and ensure system is stable and developed as required. Worked on Quality Center to ensure testing is being done and accurately raised in case any defects, if not fixed.
• Conduct & assist in SIT & UAT to give client a first & final level of satisfaction of how the new system or processes are put in place.

Environment: MS Office(MS Word, MS Excel, MDM, MS PowerPoint, MS Visio), RUP, UML, SQL, XML, Test Director, RequisitePro, LoadRunner, ClearCase,TOAD, ClearQuest, GAP Analysis, WinRunner, doors, MS Project

Confidential, Minneapolis, MN

Business System Analyst

Responsibilities:

• Worked as a business analyst to build enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, risks and returns, Bond Pricing, MBS, ABS, Derivatives (repos, interest rate swaps), Money Market Instruments and used strong knowledge of financial statements, cash flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting.
• Participated in the vendor selection process by doing a GAP Analysis on the vendor (clearing broker) contracts and once selected, served as a liaison between the vendor and the Business Design Team.
• Interaction with clients to understand a broad range of reporting requirements, and validating it with the regulatory requirements for reporting for a Prime Brokerage.
• Supported PMO by mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Improved processes, tools, data quality for Master Data Management (MDM), user adoption and deliver results 50% faster and efficiently.
• Implemented full project lifecycle phases including Requirements Gatherings, Design and Analysis, Construction, Integration, Quality Assurance, and Installation.
• Implemented and Used SWIFT messaging system to test the flow of messages from and into the new system and was also involved in ETL process. Performed logical/physical data modeling, data distribution, Forward/Reverse Engineering of Data Models using Allusion ERwin 3.x/4.x Data Modeler.
• Use of Reverse Engineering process to identify existing functionality using Rational Rose 2000.
• Documented Business Process Requirements with Use Cases and facilitated JAD sessions to define AS IS and TO BE IT processes for the TIERS project a conversion from Unisys COBOL to client/server.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Analyzed the system from both Technical and Business perspectives and prepared Business Requirement Document (BRD).
• Involved in creating reports for the end users using Crystal reports from the gathered requirements
• Interpreted business objectives to support the implementation of technical software application
• Extensively used Visual Basic to create macros in order to make data migration testing more useful and compared results from the legacy databases to the new CRM database.
• Created and executed test scripts and project plans for DPI conversion.
• Functional/support contact for Microsoft Dynamics NAV ERP system, liaise with stakeholders to implement critical functionalities.
• Involved in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server.
• Worked with other BAs to make an Object Oriented Model of the application and create Use Cases.
• Developed Use Case Diagrams, Activity Diagrams, Class Diagrams, and Object-Oriented Design (OOD) using Rational Rose according to the UML methodology to define business processes.
• Worked on the process for Identify patterns and exceptions with dataprocess flow, ETL processing using BI tool.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio, MS Word and MS Excel. Involved in business process modeling using UML through Rational Rose.
• Developed Use Cases, Activity Diagrams, Sequence Diagrams.
• Responsible for creating UML modeling plans, Use cases, process flows, Wire Frames and business requirements documentation using Visio, CaliberRM and Star Team.
• Collected and Documented Business Processes and participated in building a Business Process Model.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Developed and managed project plans, schedules, issues log created and business-technical conflicts.
• Prepared project related Presentations and provided Reports to Higher Management.
• Worked with the Quality Assurance lead to develop detailed Test Plan and Test Cases.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Participated in development of Training Materials for the new technology and organizing User Training.
• Provided superior client interaction to make sure all needs were met.

Environment: SDLC, Rational Tools Suite (Rose, Requisite Pro, Clear Quest, Clear Case), MDM, MS Access, UML, SQL, MS Project, MS Office.

Confidential, Winter Park, Orlando, FL

Business Analyst/ Data Analyst

Role & Responsibilities:

• Worked as a BA to assist in upgrading the system that processes thecredit cardapplications
• Conducted interviews, gather requirements and analyze the requirements
• Provided key inputs in defining the projects and system requirements
• Suggested measures and recommendations to improve the current application performance.
• PerformedGap Analysisto check the compatibility of the existing system infrastructure with the new business requirements
• Designed anddeveloped Use cases, Activity Diagrams, Sequence Diagrams, Object Oriented DesignusingUML and Visio.
• Troubleshooting and governing security for Kronos Timekeeping interface, ADP Payroll servers and software, Telligent hosting for CRM portal and technical support website, and NetSuite Open Air professional services interface
• Based on the physical model, developed strategies for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.
• Analyzed theAS-IS and TO-BEprocesses to understand the key findings, the short term considerations, the long term considerations and its benefits.
• Conductedworkflow, process diagram, GAP analysesto derive requirements from the existing system.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Assisted in designing detailedUse case, Business Requirement Documents andFunctional Specification documents. Assisted the testing team withUser Acceptance Testing.
• UsedMS-ExcelandMS Visioextensively in developing theuse cases.
• Worked with upper level management regarding projectplanning, scheduling and budgeting.
• Made extensive use ofSQL queriesandRDBMSfor the arrangement of customer data.
• Assisted indata analysisand worked with the design team in the designing of the databases with extensive use ofERDs.
• Assisted inthe development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Effectively communicateduser acceptance test (UAT)results between users and development team and provided recommendations forApplication change requests (ACR).
• Organized and setup process owner and stakeholder meeting sessions to define application scope and performed gap analysis to come up with application boundaries and touch points using Telelogic DOORS.
• Worked with marketing teams to understand the requirement and needs of the potential customers and thetarget market. Was extensively involved in allproject documentations.
• Acted as a liaison between the different corporate departments.

Environment: MS Visio, MS Office Suite, Java, Oracle 9i, MDM, DOORS, Test Director, VB, Client Server, UML, RUP, Windows XP, Test Director, MS Project

Confidential, Plymouth, Michigan

Data Analyst/Business Analyst

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Reverse Engineered the existing ODS in to Erwin.
• Conducted meetings for the Data Modeling and Analysis.
• Enforced naming standards.
• Created the logical models and generated the physical models in the databases using Erwin.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Designed and developed Project document templates based on SDLC methodology
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Tested Performance & Accuracy related queries under SQL Server.
• Designed and developed, Use Cases, Activity Diagrams, Sequence Diagrams, Visio and Business Process Modeling
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• Performed tuning of the mappings for optimum performance.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Involved in gathering, analyzing business rules, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Worked on the Business Objects Data Insight to analyze and monitor the claims reports.
• Conducted business process modeling and analysis; identified assessed and articulated gaps /operational risks associated.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Generated requirements from Feedback (from FA’s) / Users’ requirements via CRM (SFDC or Salesforce.com).
• Designed and implemented changes to Microsoft Dynamics NAV ERP system
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Imported and exported Repositories across DataStage projects.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Involved in writing the detailed Test Plan using Mercury Quality Center, after analyzing business requirements and software/functional requirement artifacts.
• Rational Unified Process (RUP) was used to implement iterative SDLC.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Used UML notations for Object Oriented Design and Documentation.
• Wrote Test plan and Test cases for the Integration testing and system testing.

Environment: Ascential DataStage 6.0(Manager, Director), Visio, Oracle, MS Word, Excel, PowerPoint, Visio, Access, MS SQL Server 7.0, PL/SQL, HTML, XML, UNIX, Unix Shell Script, Windows NT, Sybase.

Confidential, Manhattan, NYC

Business Analyst

Responsibilities:

• Conducted weekly meetings for deciding Policies and Procedures to be followed while constructing new sites.
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro. Assisting inNIST800-53 Implementation Plan activities, including development/update and implementation of agency-specific security policies, procedures, and training according to federal and agency requirements
• Analyzed system performance and initiated process improvement measures for mainframe and Web-based applications. Analyzed results and EDI ANSI X12 file mapping and reported on standard analysis spreadsheet.
• Interacted with claims payment and enrollment to review, analyze and document business processes.
• Built business requirements into the Medicare Advantage (MA) requirements database and created the Project Requirements Document for the three functional areas.
• Generated test data using X12 generator for transactions 837P/I/D. Conducted Gap Analysis to identify the gaps in the system and regulate the changes.
• Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payer contacts.
• Conducted analysis of HIPAA compliance and took part in discussions for designing the healthcare transactions to be HIPAA 5010 compliant. Acted as a liaison between client and payer/intermediary. Experienced in payer rules, requirements, governmental regulations and HIPAA compliance.
• Worked with HIPAA 270,271,835,837 transactions. Performed validation of 270,271,835 and 837 Professional and Institutional format files according to EDIFECS engine.
• Prepared a UAT Plan, where, in a Pre-UAT stage, the UAT environment is set up and tested, while the development effort is still going on.
• Generated test cases in Claims Analyzer Editor Professional to ensure unification with CPT-4 and ICD-9 codes
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc. Created use case scenarios and documented workflow and business process using Rational Rose.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
• Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture)
• Used Query Analyzer, Execution Plan to optimize SQL Queries. Meticulously assessed data from various sources and generated conceptual and logical database designs using ERwin data modeling tool.
• Assisted Project Teams in preparing Software Requirement Specifications (SRS), User Interface Design, designing of Application Architecture & Database Modeling.
• Analyzed trading partner specifications and created EDI mapping guidelines
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Developed Data Conversion Strategy for converting data from the existing site to the new site.
• Designed and developed project document templates based on SDLC methodology

Environment: Windows, Microsoft Office SharePoint, MS Office, SQL Server, Agile, MS Project, MS FrontPage, MS Access, WGS, STAR, EDI, Documentum 2.0., Rational Clear Quest, Rational Clear Case, Rational Requisite Pro, Rational Rose, UML,RUP, Microsoft Excel, Microsoft Word, Microsoft Power Point, Visio.