SUMMARY

• More than 7+ years Professional Experience managing requirements in E - commerce/ Supply chain domain.
• Managed requirements for web based solutions, reporting & business process management.
• Expertise in business analysis, requirement elicitation (JAD & JRP), GAP Analysis.
• Experience in Project planning, estimating and tracking of requirement activity.
• Experience on CMS (Adobe Day CQ) Web Development Project experience.
• Extensive experience in the Retail and e-commerce environments wif noledge of Microsoft commerce ATG suite and web sphere
• Lead several requirement sessions and brain storming session to arrive at work around solutions for complex requirements.
• Experience in both Agile and Waterfall methodologies and a good understanding of SDLC.
• Interact wif product managers to identify, prioritize business requirements.
• Interact wif User Experience (UX) team, Development team to finalize the screen design.
• Successful project management (planning, resource allocation, scheduling and status reports)
• Experienced in Data Analysis, extracting information from database using SQL queries
• Experience of Unit Testing (UT), System Integration Testing (SIT) and User Acceptance Testing (UAT) as well as Defect Tracking.
• Experienced in Web Analytics professional wif expertise in using Web Analytics tools - Google analytics, Web Trends, (SiteCatalyst, QA & Reporting), BI
• Assisted data analysts to develop logical data models, source data cleansing and data profiling. Essentially applied business rules in the transform phase.
• Proficient in Risk Management planning dat includes Risk Identification, Assessment, Risk Analysis, Reporting, and Risk response/monitor/ control.
• Demonstrated leadership ability to resolve issues, drive projects, and meet deadlines. Excellent interpersonal and communication skills wif the ability to understand both business and technical needs from the clients and customers.
• Experience in office applications - MS Word, MS Excel (pivot tables, Vlookups), MS Project, MS Outlook & Business process management tool- PEGA.

TECHNICAL SKILLS

Operating Systems: Windows 7/ Vista/ XP/2000, UNIX

Databases: Oracle, SQL Server and Microsoft Access

Statistical: Microsoft Excel, SAS

Business Intelligence Tools: InfoView, Web Intelligence, Desktop Intelligence, Informatica, DataStage

Automation Tools: MS Visio, Rational Rose, Rational ClearCase

Methodologies: RUP,UML, RAD,SDLC,QA Process Cycle, Product Life Cycle, Cause Effect Analysis, Agile

Data Modeling Tool: ERWIN.

Computer Skills: Microsoft Excel (Data Functions, Pivot Tables etc.) Microsoft Access and Microsoft SQL Server Analysis Services, Macromedia Dream Weaver, Adobe Photoshop, Smart Draw, Microsoft Visio, PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Business Analyst

Responsibilities:

• Worked extensively in creating the Policy, Procedure and Control Guidelines for EUC PMO.
• Created detailed Control Requirements for the various roles and responsibilities identified in the organization.
• Engineered process flows for the EUC methodology and created workflows including life cycle states of the EUCs.
• Gatheird Requirements from business area stakeholders and created Use Case diagrams and scenarios.
• Worked wif the vendor (CompaSoft and Prodiance) in understanding the COTS architecture and mapped the requirements to the tool specifications.
• Having strong skills in understanding of Web Analytics (Omniture, Nielsen, Comscore and Bango).
• Worked on Web Analytics professional wif expertise in using Web Analytics tools - Google analytics, Web Trends, (Site Catalyst, QA & Reporting), BI
• Created Detailed Business Requirements, Technical Requirements and Functional specification documents. Created Metadata models for Inventory Project and designed the full EUC life cycle system.
• Worked extensively in creating the Risk Ranking process for risk ranking and rating EUCs based on their Complexity, Material Weakness and Financial Impact in compliance wif SOX guidelines.
• Created data models and metadata definitions for Financial, Operational & Analytical EUCs.
• Created workflow design and process flows as well as configuration and change management procedures.
• Evaluated CM tools like Prodiance, CIMCON & Compassoft and prepared a detailed report, which was used by the management to initiate prototypes.
• Worked wif QA team in identifying test cases and test data and tracebility matrix
• Lead the PAT (Product Acceptance Testing). Created Test Cases & Test Data
• Played a supporting role for the Project Manager in managing the project along wif identifying project artefacts as per FTD (methodology life cycle followed in Freddie Mac)
• Created detailed user guides, presentations and other training materials for the application developed and led the training sessions in training users.
• Worked extensively in data analysis and migration of the existing data to the new application.
• Worked as liaison between the vendor and the management, as well as between the business area and the technology group.
• Worked on writing narratives, designing process flows and SOX Controls for Internal as well as external Audit.

Environment: CompasSoft, Remedy, Prodiance, Oracle, FTD, UML, Rational Rose, Rational ClearCase, Rational ClearQuest.

Confidential, Indianapolis, IN

Business Analyst

Responsibilities:

• Involved understanding the current business process, defining scope of the project along wif position statement.
• Met wif users and stakeholders to understand the problem domain, gatheird customer requirements through surveys, interviews (group and one-on-one) along wif JAD sessions.
• Created business use case, functional (FRS) and technical specifications for trading system.
• Helped document the rational and requirements behind the XML architecture dat encompasses data origination, secondary market and servicing data for implementing MISMO standards
• Assisted in preparing a data dictionary to provide business definitions and corresponding architecture data element tag names for MISMO
• Applied Unified Modeling Language (UML) methodology to create use case diagrams and sequence diagrams in Rational Rose.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application.
• Designed the UI (web interface) of the application, along wif prototyping.
• Resolved issues and improvised the process to ensure a stable and accurate solution.
• Performed cost-benefit analysis, generated reports for analyzing various investments and their profitability and also for analyzing various lost opportunities due to time delay in investing.
• Worked wif financial services as part of support for the application.
• Validated business rules and all artifacts wif users, approval and sign off.
• Provided technical and business noledge to clients.
• Working wif the architect, developers on business and technical issues, helping in designing of the system; and testers to ensure all requirements are correctly translated.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin the Oracle database.
• Worked wif the team on security features: web, encryption, authentication and SSO possibilities.
• Updated and modified progress and resources allocation in MS project for the team.
• Suggested process and product improvements for the application.
• Created test plans, scripts and facilitated user acceptance testing.
• Performed manual front-end testing to check all functionalities of different modules.
• Helped in deployment of portal a venue for the on-line trading application a collaboration bundle solution.
• Identified areas of risks, assessment, monitoring, having security and audit controls in place.
• Ensured dat the application met user and management expectations.

Environment: MS Visio, MS Project, UML, SQL Server, PL/SQL, .NET, Clear Case

Confidential, Emeryville, CA.

Data Analyst

Responsibilities:

• Responsible to play a key role in day-to-day support of Business Intelligence tools, Decisional and Reporting solutions, Business Objects, and underlying ETL framework.
• Responsible to gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
• Experienced in execution of Functional, Acceptance, Regression, and Sanity Test cases for a HTML5 based Mobile Digital Curriculum Application in a fast paced agile development environment.
• Proved ability to manage multiple complex software projects and products in Web and Mobile industries.
• Responsible to create 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.
• Provide application support to ensure availability and reliability of the shared Business Objects XI reporting environment, including administration and maintenance of user groups, users, folders, events, schedules and security.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Developed and maintained reports using in MS Excel queries, SQL in Teradata, and MS Access.
• Prepared Logical Data Models using ERWIN dat contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Converted various SQL statements into stored procedures theirby reducing the Number of database accesses.
• Participated in monitoring of Enterprise server performance and stability, and perform required support and maintenance to improve where necessary.
• Provided technical support (including upgrades and patching) of existing Production environment.
• Responsible to Test and deploy new Business Object universes to meet business needs.
• Conducted analysis of alternatives and provide recommendations for support issue resolution.
• Worked wif project team to plan a support strategy for solutions and/or enhancements to existing systems to meet current and future needs.
• Performed peer reviews on all BO universes, reports and dashboards.
• Engaged in user facing and communication tasks while interacting wif support teams, Business users and Super Users, vendors, and quality assurance team.
• Work wif IT quality assurance and software delivery teams regarding code tuning efforts, project phase, post-implementation phase, and performance analysis, as matters are observed in the production environment.
• Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.

Environment: RUP, UML, Data stage, SQL Server, Agile, Informatica, Business Objects-Web Intelligence and Desktop Intelligence, MS Office Suite (Word, Excel, Access and PowerPoint).

Confidential, MD

Data Analyst

Responsibilities:

• Analyzed data sets to better understand the HIPAA EDI transactions.
• Identified all necessary Business and System Use Cases from requirements, created UML diagrams including Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using Microsoft Visio.
• Facilitate meetings, and ability to capture meeting minutes.
• Supported project in all phases of SDLC and overall implementation activities.
• Effectively participate in cross-functional team wif systems vendors, customers, corporate partners and peers.
• Worked on healthcare terms, billing, coding and claim processing.
• Involved in gathering clinical data and supported application development. Data includes patient’s admission status, discharge details and transfers. Also tested claims and diagnosis reports of the patient.
• Captured and distributed meeting minutes to internal team and formally to external vendors.
• Worked hand in hand wif Project Manager to ensure timely and successful completion to project milestones.
• Involved in System development, including working wif business owners and SME’s in defining detailed requirements, working wif technical staff to review technical design documents and support overall implementation activities.
• Involved in claims processing and tested claims for the purpose of functional check.
• Analyzed for making system compliant wif HIPAA. Involved in making the Medicare patient profiles being compliant wif the HIPAA regulations. Management of patient profile transfer (PPT) reports created by data team by verifying the associated data.
• Involved in analysis, design and implementation of the following systems.
• Control Management Reporting and Security Systems: generation of daily, weekly and monthly reports of hospital patients’ activity.
• Medical Billing and Collection Systems: generation of daily billing activity based on patient records and establishment of collection protocols.
• Accounting Systems: Financial Statement generation and analysis according to government standards and protocols.
• Conducted detailed and comprehensive Business Analysis by working wif end users and other stakeholders to identify the system, operational requirements, and proposed enhancements.

Environment: Rational Unified Process, Rational Rose, Rational Requisite Pro, Visio, Office 2003, MS Project 2002, Windows XP.

Confidential

Business Analyst

Responsibilities:

• Served as a liaison between business team and the project team by assisting the business in Identifying, understanding, and documenting their business need
• Collected and documented Business Processes as well as Business Rules.
• Worked closely wif different departments to improve the efficiency of the existing systems in place.
• Participated in various stages of data and requirement analysis for project needs.
• Involved in developing a comprehensive system Test Plan and created the Test Cases.
• Reviewed the Customer Requirements Specifications and developed end to end Test cases using Microsoft Word.
• Worked wif the team to define and design test objectives and additionally, collaborated to formulate effective test documentation.
• Performed System testing, validated User Interface inconsistency for the application functionality.
• Performed Browser compatibility testing on various versions of Netscape, Internet Explorer and Firefox.
• Performed Web testing to test broken links and accessibility of the website for internal and external customers.
• Prepared Requirement Traceability Matrix to map the Use cases wif the Test cases
• Wrote SQL queries to test the application for data integrity.
• Reported weekly status meetings to show progress and future testing efforts.
• Documented the defects, test results, in Microsoft excel for reporting purposes.

Environment: .Net Framework, SQL Server, MS Visio, MS Word, MS Excel, MS PowerPoint, UML