Summary

Insert name and contact information for the CAI Account Manager listed on the Peoplefluent requirement. For ease of reference, the Account Managers' contact information appears below.

Skills

Add or delete rows as necessary.>

Employment History

Confidential

Sr. Business Analyst

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Used XML for building and parsing of Application Configuration file.
• Used Castor to create objects from XML documents.
• Conceptualized primary process flow diagrams using Microsoft Visio and CaseWise tool sets.
• Performed data modeling for OLTP database and Data warehouse
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Liaison between customer and business as usual team, Project Requests, SOW, business work flow Analysis, Design, Resource Allocation, Executed project Plan
• Conducted interviews with key business users to collect requirement and business process information.
• Comprehensively work with requirement gathering for Enterprise reporting system using RequisitePro.
• Designed and developed all Use Cases and UML models using Rational.
• Developed Sequence Diagrams, OOD using UML.
• Established a business analysis methodology around the RUP Rational Unified Process . Helped develop use cases, project plans and manage scope.
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, process and revenue streams.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Web sphere and Cognos.
• Conducted current state study which included data collection methodologies, data quality and data integration problems, data storage and infrastructure related issues.
• Coordinated with system analysts, development team, project manager for application development and Pre-validation specifications.
• Developed business process flows, Use Cases, and other documentation for the trading model while coordinated with Development Team in translating business requirements into design specifications for expansion of loan securitization business.
• Involved in design of Operational Data Store ODS to facilitate ease of data warehouse loading Established documentation regarding data warehouse best-practices in the areas of information requirements gathering and DDW/ETL
• Used Rational Clear Case and Clear Quest as Configuration Management and Change control tools.
• Performed User Acceptance Testing UAT .
• Full knowledge of most phases of the Systems Development Life Cycle.
• Handled large and complex projects basing on the requirement.
• Ability to work with all members of the project team, following the project through the Systems Development Life Cycle and ensuring business objectives are met extensive Project life cycle experience .

Environment: Windows NT 4.0, Erwin, AGILE, XML, Visual Basic, SQL, Sharepoint, Dbase3, DOS and UNIX Sequential Files, MS Office Word, Excel, Access, Project, PowerPoint, Outlook , .Net, HTML, ERWIN,GIS Tools.

Confidential

Business Analyst

Responsibilities:

• Leaded business initiatives including brainstorming on new functionality for current systems.
• Created use case scenarios and documents work flow and business process.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Estimated ROI for this project, analyzed advanced Meta data architectures, pulse-of-the-market analysis of meta data integration tool vendors
• Streamlined the Restatement of Data Warehouse access review Process.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Used UML to produce Use-Cases, Use case diagrams and Activity diagrams to explain process flows and functional specifications. Monitoring General Ledger A/c in Flexi, inputting daily transactions in Flexi and evaluating any differences in debits and credits and sending reports to the Accounting dept. for review. Analyzing and preparing Balance Sheet and Income Statement presentation for the Consolidated Close tasks include Accounts Receivable and related accruals. Used the tool Systems Architect and MS-Visio to create use case diagrams and process flows.
• Involved in understanding the requirements and functional specifications of corporate managers.
• Developed schemas for extraction, transaction, and loading ETL using Solonde Warehouse Workbench to expedite data integration between systems.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Involved in the complete SDLC system providing SOW to the client notifying the client about the work to be done in detail, specifying both hardware and software involved Scope of Work
• Very closely involved in all phases of SDLC from gathering requirements to testing.
• Supported project governance and provided regular project communications to the project manager and business areas.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Responsible for cost estimation and timelines for various BusinessIntelligence reports
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Worked with SQL queries using MS Access for data manipulations.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Converted MS Access database to MS SQL database using MS SQL 7.0 Server Enterprise Manager. Created SQL scripts for uploading procedures.
• Documented business workflows textually as well as in UML diagrams State diagrams according to RUP, for the stakeholder review.
• Coordinated with system analysts, development team, project manager for application development and Pre-validation specifications.

Environment: RUP, AGILE, MS Office Word, Excel, Access, Project, PowerPoint, Outlook ,SQL, Rational Rose ,SAS, Clear Case, HTML, Visual Basic, Sybase, Windows 2000/NT, .Net, UML, Business Objects, Oracle9i ,Excel, Visio, VBA, Erwin, GIS Tools, Requisite Pro and Data Mapping/Modeling , Informatica.

Confidential

Business Analyst

Responsibilities:

• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Reconciling General Ledger accounts. Assisted with audit defense, Sarbanes-Oxley 404 compliance, research tax issues as they arise.
• Ensures that all accountability standards are met.
• Check and verify cash balance projection reports daily for accuracy and completeness
• Direct supervision of the transaction processing groups including Accounts Payable, Accounts Receivable and Payroll.
• Interfaced with Business in understanding the present functionality of Advisor tab and defining the phases in which the complete migration would be done.
• Worked with Designers to create data warehouses and/or reporting solutions using Informatica.
• Conducted user interviews, gathered Requirements, analyzed the Requirements and managed change requirement.
• Conducted interviews with end-users to collect requirement and business process information.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications Data Mapping, and process flows
• Developed business process models in RUP to document existing and future business processes.
• Designed and developed project document templates based on SDLC methodology.
• Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training classes.
• Developed business requirement specification documents as well as high-level project plan.
• Duties were included designing the model of ODS to automate and maintain the ETL process.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language PL/SQL .
• Developed executed several Optimized queries in SQL on this data.
• Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Handled large and complex projects basing on the requirement.
• Conducted User Acceptance Testing UAT .

Environment: Rational Unified Process RUP , AGILE, DB2, Documentum, Rational Requisite Pro, Rational Test Manager, Visual Basic, Java, J2EE, .Net, Win Runner, SQL, MS Office Word, Excel, Access, Project, PowerPoint, Outlook , MS Visio, UNIX, Rational Clear Quest, HTML, XML, XSL and XSLT

Confidential

Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Worked with the SME's Financial Analysts, Risk Managers, and Project Managers to define business critical needs and analyse the possible technical solutions.
• Maintained the data integrity of the Baan ERP system by developing an end-user strategy for data cleansing and engineering revision control
• Involved in identification of business rules, business and system process flows, user administration, requirements and assumptions.
• Developed process flow diagrams flow charts using MS Visio in an effort to identify and analyze process.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Organize requirements into high level Use Cases and low level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams DFD .
• Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
• Generated complex reports using business object XI and web intelligence
• Coordinated various kinds of User Acceptance Testing UAT including regression testing, system testing, integration testing, functional testing, alpha beta testing.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Used Test Director which is a Mercury tool to help manage defects and issues log during the testing phase..
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Participated in Bug-Review meetings with software developers, QA engineers, managers, and suggested enhancements and solution to the existing application problem from business perspectives.
• Handled large and complex projects basing on the requirement.
• Worked as a User/Customer advocate and negotiated with user as well as the technical team and management staff to resolve any outstanding requirement conflict during the whole SDLC process.

Environment: DOORS, AGILE, Windows XP/2000, PL/SQL, XML, HTTP, MS-Project, MS-Office Suite, DB2, Documentum, MS Office Word, Excel, Access, Project, PowerPoint, Outlook , MS Visio, GIS Tools, Unix, Visual Basic, Win Runner, Load Runner, Test Director Mercury Interactive , Java, Oracle, PL SQL

Confidential

Business Analyst

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
• Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.
• Conducted interviews with end-users to collect requirement and business process information.
• Used SAS ODS to create output files in different formats including PDF and RTF
• Performed extensive Requirement Analysis including data analysis and gap analysis.
• Designed and developed project document templates based on SDLC methodology.
• Participated in various stages of data and requirement analysis for project needs.
• Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training classes.
• Developed business requirement specification documents as well as high-level project plan.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
• Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts.
• Relieved pressure off the PM by maintaining artifacts and portions of the project binder.
• Documented and delivered Functional Specification Document to the project team.
• Participated in the logical and physical design sessions, assisted and developed high and low level design documents.
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Conducted User Acceptance Testing UAT .
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Assisted the PM in performing Risk Assessment, Management and Mitigation.
• Handled large and complex projects basing on the requirement.

Environment: MS Office Word, Excel, Access, Project, PowerPoint, Outlook , Microsoft Visio, Documentum, UML, J2EE, Windows NT/XP, Oracle, PL/SQL, SQL Server, Sybase, VBA, VBScript, C . NET, ASP.NET, Business Objects, TestDirector, LoadRunner.