SUMMARY

• ProgramCoordinator/ Jr. Project Managerwith over9years ofexperience in IT with Top - Notch clients and expertise in working onmultiple projects/programsconcurrentlyin dynamicenvironments.
• Extensive knowledge of project life cycle, project management processes, principals,knowledge areas, PMBOKand various project management toolslikeCAClarity, Primavera, MS Project etc.
• Extensive working knowledge of PMO operations, IT project portfolio management, cost/variance analysis, budget(forecasting/tracking/control),resource(modeling/forecasting/levelling), project(planning/scheduling/controlling, project scorecards, project dashboards, time tracking, performance/status tracking, trend analysis and projects prioritization etc.
• Expertin developingeffective working relationships withtheclient teamsto understand and support requirements, scoping/prioritizing projects,developingstrategic plans to implement technology solutions, and effectively managingclient expectations.
• Extensive experience in conducting user acceptance testing (UAT) and trainingsessions forusers.
• Extensive experience in change management, release managementetc.
• In-depth knowledge of Soxcompliance, Six Sigma and CMMI approaches.
• Confident, pro-active,analytical,fast learner,assertive, detail-orientedcandidatewith excellent multitasking capabilitiesto perform exceptionally inever changingandstressfulenvironments.
• Exceptional organizational, interpersonal and leadership skills with goal-oriented attitude to motivate and work with a team as well as work independently.
• A good listenerwith excellent oral/written communication skillsandexcellentproblem solving skills. Adept inlearning new technologieswith organized,disciplined mindset and positive professional attitude.
• Strong expertise with MS-Project, MS-Excel, MS-PowerPoint,MS-Access,MS-Word, MS SharePointand MS-Visio.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, HTML, XML, C++, Java, Java script and Visual Basic Script.

Databases: Oracle 8i/9i, MS Access, Toad, SQL developer, Erwin 4.0/3.5.2, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, SAP FI/CO, SAP MM, SAP HR, SAP SD, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Operating Systems: Windows XP/2000/Me/98/95/3.1/NT, MS-DOS, UNIX, Linux, Solaris.

Networks: LAN, WAN, TCP/IP.

Business Tools: Developer 2000(Forms 3.0/4.5/5.0/6 i, Reports 2.5/3.0/6i)SQL*Plus, TOAD, SQL Loader, Erwin Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case, RUP (Rational Unified Process)), MS Visio, MS Project, MS Project Server, MS Access, MS Word, MS PowerPoint, MS Excel, MS Outlook, IBM-Lotus Notes, PeopleSoft, CA Clarity.

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case modeling & Analysis, Use case specification (UCS).

Testing Tools: Rational Test Manager, Win Runner 7.01/6.02/6.0 , Mercury Test Director / Quality Centre.

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NY

Jr PM/ Program Coordinator

Responsibilities:

• Assist Program/ Project Managers with CA Clarity and monitored that Project Managers adhere to the standards in Clarity.
• Maintain Program/ Project status, Dashboard; assign tasks/ resources etc in Clarity.
• Responsible for maintaining work-intake tracking system.
• Responsible for form and structure of the program/project reports and tasks in Clarity.
• Produce, distribute and publish Clarity and Work-intake reports with content provided by/ reviewed with Project Managers.
• Update work-intake tracking system and change management system with data from Clarity.
• Create weekly/ monthly/ quarterly budget/actuals summaries, for all projects and tasks. Create Program and Project level budget reports, Cost/ Variance analysis and attend various financials related meetings with the senior management. Escalate financial risks/ issues to the management on time.
• Track project deliverables across project teams and Centers of Excellence.
• Own and maintain Risk & Issues log. Followed up with various leads and project teams on the Action Items and other project related tasks. Escalate major risks, issues dependencies and any critical matter to the senior management.
• Responsible to add project tasks and resources to the Project Plan in Clarity and MS-Project. Perform various tasks using Open workbench.
• Created Change records and presented the Changes in the Release and Change Management meetings.
• Responsible to complete all the documentations, approvals and processes that need to be followed for Change and Release Management.
• Responsible to ensure that the project teams are following SDLC processes and creating documentation to support COBIT and SAS70. Work closely with the Audit & Control group.

Confidential, RI

Program Coordinator/ PMO Financial Analyst

Responsibilities:

• Assisted in developing project WBS (Work Breakdown Structure), finalizing estimates, managing resources across project teams. Involved in tracking the changes to the project and updating the MS Project plan.
• Monitored the MS Project plan as per the activities planned and ensured project milestones are achieved.
• Developed the necessaryProjectReports, Budget Status and communicated to management during Project Management Review Meetings. Involved in tracking project team's weekly status reports.
• Measured and tracked team progress and provided metrics. Also ensured issues are captured, tracked and resolved in timely manner.
• Involved in organizing, leading and facilitatingproject-related meetings, including the creation of agendas and preparation of materials and following up the action items till the closure.
• Ensured projects adhere to high quality standards, meet customer expectations and are delivered on time and within budget. Pro-actively involved in sub- phase closure activities.
• Co-ordinated Risk and Issue Management and worked to provide solutions to issues or timely escalate to avoid project delays.
• Defined project milestones, schedules, monitored progress and updated plans using MS Project.
• Involved in project planning/ scheduling, cost benefit analysis, setting milestones and deadlines.
• Served as primary point of contact for project repository and administration.
• Reported status to project management and project owners on a weekly and monthly basis.
• Prepared Project Investment Board and Executive Status meeting presentations and updated the attendees on the project status and answered any queries.
• Coordinated activities between the offshore and the onshore teams for status reporting and other issues.
• Created documents and reports (Release Notes, Closure Reports, Summary reports etc.)
• Actively involved inprojectchange control. Ensured appropriate solution and budget is presented so that projected business benefits are realized within the approved budget.
• Managed budgets/ forecasts of 2 big programs totalling more than a billion dollar.
• Documented Projects progress, Lessons Learned, Process Improvements and Best Practices etc. for the project.
• Evaluated existing project management practices and recommended improvements to project management practices.

Confidential, Memphis, TN

Project Coordinator

Responsibilities:

• Jr. Project Manager / Project Coordinator with Confidential & Nephew Orthopaedics on SAP based Global Loaners Project.
• Assisted program manager, senior project manager and the project team with day to day project planning, scheduling, reporting and coordination tasks.
• Participated in the business requirements gathering sessions, creation of various business and technical requirements documents and worked closely with the business owners/ sponsors, stakeholders, solution leaders and others as needed, in order to scope/ blueprint the project and create a project charter.
• Assisted in developing labor estimates, cost estimates, milestones, deliverables, schedules, WBS, critical paths and overall plans for the project.
• Tracked project spending against project budget and budget to date vs. actual, created status and budget reports, updated team expanses on weekly basis in MS Access database and MS Excel tracking sheet, reconciled project expenses as required maintaining accuracy and monitored invoice receipt and payments.
• Used Excel for generating monthly and weekly status reports for the team and upper management
• Administered SharePoint Site, maintained project documents library, communicated project status/ progress/ issues within the project team, managers, and staff and to the business sponsor and business departments involved with the global project.
• Captured meeting minutes and issues/ action items. Followed up with the action item owners. Created and posted various project related and PMO related documentation on the SharePoint site.
• Assisted with maintenance of the master project plan as requested, compiled metrics and reports from project plan, created weekly turnaround lists for team leaders and monitored project performance.
• Maintained weekly hours tracking for all the team members and reconciled Time Tracker reports to SAP and Budget Database.
• Compiled reports and metrics on project staff resources, maintained project organization chart and project team directory.
• Logged and tracked open issues, testing issues and change list, created internal summary reports and compiled metrics and reports on issues and changes.
• Consolidated metrics and reports into weekly status reports, maintained project status report binder, updated and maintained executive dashboard and assisted with preparation of presentations, including monthly steering committee meetings.
• Identified and coordinated team training requests, supported new team members with orientation, location and team logistics, coordinated as needed with the corporate travel and housing for team members, maintained and archived project management file, ordered requested team supplies and facilitated hardware and software requests.
• Assisted with new employee setup in getting security forms, network access, SAP access, remote access, security badge, live meeting accounts, MS IM set up and NDAs.

Environment: WinRunner, LoadRunner, ClearQuest, Oracle11i, MS Word, MS PowerPoint, MS Excel, MS Visio, MS SharePoint, Microsoft Project 2003, UNIX, MS Access, IIS, Quality Center, RUP, UML, power builder.

Confidential, NYC, NY

Program Coordinator

Responsibilities:

• Primary responsibility was to coordinate project management activities for a group of 12 project managers in the Corporate Information Department, mainly helping three program/project managers in managing six large scale infrastructure implementation projects, in parallel.
• Worked collaboratively with business units, steering committee, project sponsors, project managers, technical leads, engineers, architects, and external vendor project teams on large scale implementation projects.
• Helped a group of 12 project managers in managing project portfolios and coordinate various project management activities. Worked mainly with three program / project managers, on multiple (infrastructure implementation, service delivery and R&D) projects, in parallel.
• Participated actively in writing, analysis and review of various Requests for Proposal (RFP) to be submitted to various vendors for providing services as per project requirements. Analysed vendor responses and prepared Scorecards in order to select the best vendor. Worked closely with vendors like Microsoft, Adobe, and CompuCom etc. for RFP responses, delivery status and project related communication.
• Participated actively in the reviews / enhancements of SOWs, getting POs signed and other contract related activities and communications.
• Managed various project codes and cost centers required to track spending vs. approved budget, using RMS System / BMC Remedy. Managed, tracked and analysed project budget portfolios and generated various spend vs. forecast reports, as needed.
• Interacted with vendor management for various vendors related selection issues and on boarding / off boarding of consultants. Made arrangements for various consulting and training engagements.
• Participated actively and monitored the progress of all the project phases - Initiation & Definition, Planning, Execution and control (design, test, build) and project production rollout in order to meet the milestones deadlines. Scheduled post project reviews and documented project deliverables / best practices on Wiki. Created wiki pages, categories and lists on the Wiki for maintaining project documentation and other project related information.
• Worked closely with various infrastructure teams (Server, Storage, Architecture and Engineering, Websphere, Webserver, Siteminder, database, LDAP etc.). Interacted with BAMs, VPS, CVPs, AVPs directly across the firm to get project related information / status and to resolve various interdependent issues and cross dependencies.
• Interacted with release management team and release coordinators for entering Change Management Requests for the new releases and production rollouts. Verified release closeout checklists and technical checklists with the help of the project leads. Created implementation verification back-out plans and activity announcements for the production rollouts. Maintained risk/issue logs and escalated risks /issues to the higher management, whenever needed.
• Created Project Definition Document (defining goals and objectives, alignment and rationale, priorities, delivery timeframe, scope inclusions, scope exclusions, approach, project deliverables, costs / benefits, risks / assumptions /constraints, impacts, project organization, team members, roles and responsibilities, communication plan, change control process, resource requirements, contract partners etc.).
• Participated in budget planning, FTE estimation and budget tracking. Interacted with Finance department for approved/allocated budgets and budget planning. Responsible for entering FTEs in the BMC Remedy / RMS system.
• Attended / facilitated daily and weekly status meetings. Scheduled WebEx meetings to coordinate with the remote teams. Tracked the status of deliverables, internal/ external dependencies, meeting follow ups and action items. Facilitated completion of the action items by coordinating efforts across the core and external teams.
• Prepared quarterly analysis reports, impact analysis reports, periodic and monthly status reports, delivery/release calendars, milestone reports and other ad-hoc reports, as needed by higher management.
• Prepared steering committee reports / meeting presentations, other project related PowerPoint presentations, reports and Visio timeline roadmaps / diagrams to communicate major deliverables, milestones and project status.
• Attended Steering Committee meetings with Vice presidents, project sponsors, project team and other higher management steering committee members. Captured / Published the minutes.
• Attended project manager’s weekly group meetings and gave recommendations on various initiatives. Met with the CTO and other high level management players in the meetings.
• Scheduled and facilitated various status and other project related meetings. Captured and published the meeting minutes. Represented project managers wherever needed.
• Worked on project plans (identified tasks / deliverables/ resources / duration, established internal / external dependencies, created WBS), from the scratch and maintained / updated the plans as projects progressed. Prepared Gantt charts and PERT charts for various.
• Responsible for entering / updating information in the Project Dashboard. Interacted with people across the firm to get needed information.
• Met with PMO staff on weekly basis to review PMO related project deliverables status and discuss / implement new PMO processes / procedures to enhance the workflow and productivity.
• Worked on PMO phase approvals for the projects in the Passport (NYL company specific tool for approval of various project phases), tracked the phase approval status with the approvers and replied to the queries and comments from the approvers.
• Posted all the project related documents to the project notebook in Lotus Notes. Created documents, categories, issue logs, change logs etc. and owned project notebook administration.
• Documented project management roadmap deliverables and PMO processes related information for the project managers group.
• Owned Webtime for time tracking. Added / deleted resources in Webtime to enable them for time entry across multiple projects.
• Participated actively in detailed projects analysis / budget analysis activities and reporting. Created various metrics based on the analysis results, as needed by the higher management for various strategic decisions..

Environment: ASP.Net, VB.Net, SQL, PL SQL, MS SQL Server, JSP, XML, MS Visual Basic, MS Word, MS PowerPoint, MS Excel, MS Visio, Win Runner, Quality Center, Oracle 8i/9i/10g, Windows XP/NT, MS Project 2007.

Confidential, Boston, MA

Project Coordinator/ Jr. Project Manager

Responsibilities:

• Assisted Sr. Project Manager in his day to day project management/coordination/control responsibilities along with various PMO administrative activities for a pool of 6 projects (budget buckets that included more than 90 projects and a major program of the firm) on equity, emerging markets, rapid solutions (to target the most urgent IT needs of the business), financial reporting, standard derivatives and global data analysis.
• Documented various project life cycle documents (project plans, project executive dashboards, status reports, project timeline roadmaps, design documents, functional specifications, mock-ups etc.) and meeting minutes on SharePoint and Confluence Wiki Space on the intranet.
• Responsible for document/web content management on SharePoint site by creating document libraries, using task pane to tie documents, granting SharePoint access to selective users, exporting data and links to Excel, data versioning, and other SharePoint customizations as needed.
• Facilitated meetings with the managers/leads (QA, business analyst and technical), project/program managers across the firm to discuss the status, identify critical issues/risks (internal/external), issue mitigation planning, identify external/internal dependencies for internal and overlapping project activities.
• Facilitated recurring status meetings (weekly/monthly/quarterly) with the work groups to make them aware of the project status and prioritize deliverables per changing business needs.
• Owned/maintained project scorecards and executive dashboards for all the projects as a mandatory PMO practice and to communicate project status to higher management for strategic planning.
• Created and maintained risk/issue logs for tracking and finalised/ documented mitigation plans for the risks/issues identified.
• Prepared Gantt Charts and PERT charts for review and analysis of the projects at high level.
• Prepared project status reports (weekly/monthly/quarterly) and various PMO reports in compliance with standard PMO templates to communicate project scope, vision, milestones, risks/issues, mitigation plans, budget status (forecast/spent/variance), resource requirements/forecast and overall health of the projects to the higher IT management.
• Established and owned various project planning / scheduling and project management (monitoring/control) processes, templates and methodologies for successful (on time, per user expectations and within budget) execution of the project.
• Maintained project/release Calenders, records of various project activities and participated in the planning, research and project analysis of the current and proposed projects.
• Facilitated various lessons learned and project review meetings to discuss project success, failures, improvement areas and issues encountered with the team, to not to repeat mistakes in future and adhere to required quality standards.
• Worked on various special assignments and project analysis as requested by the higher management, time to time. Documented and communicated the analysis results with recommendations to the management.
• Owned and maintained project timeline roadmaps to be reviewed by the higher management and PMO to prepare release calendars and to synchronise project milestone tracking.
• Met with PMO administrators and finance team on weekly/monthly/quarterly basis to discuss quarterly budget reforecasts, budget transfers, financial data/reports analysis and other budgetary, administrative and planning issues.
• Created project WBS (work breakdown structure), allocated resources to projects and project activities in PeopleSoft and Clarity (project & portfolio management tool). Worked on ESS, MSS, Project Costing, Resource Management, Worklist and reporting tools modules of PeopleSoft.
• Responsible for allocating/assigning new resources (consultant/FTE) to projects, getting them workspace, systems access, VPN access, introduction to the teams and overview of the projects and processes.
• Baselined and maintained a combined project plan enlisting major project milestones/critical paths and detailed project plans for all the projects separately, enlisting tasks/subtasks, finish dates, internal/external dependencies, % complete and duration etc. to accomplish milestones in the larger plan.
• Owned time tracking. Assigned resources to PeopleSoft and helped the teams on PeopleSoft and Clarity time entry issues.
• Owned project portfolio management. Used Planview to strategically balance demand against available resources and create operational plans, manage project portfolios and resource assignments so that they meet business objectives and for reporting and analytics for better decision making.
• Worked with leads (business analyst, QA and technical) and resource managers to assign resources to various project activities based on skill metrics maintained for the resources across the firm. Maintained and used resource metrics to avoid over and under allocation of resources.
• Helped in business analysis, QA and support activities on account of previous extensive experience in business analysis with financial investment firms.
• Created release playbooks, release plans, identifying contact persons for the issues encountered during the release, communicated bridge and release information to all the concerned people and departments across the firm.
• Maintained Mercury Quality Centre (Test Director) up to date for all the defects/enhancements logged.
• Used Six Sigma and CMMI approach to measure quality and defects. Created and owned various project and performance metrics against criteria like time, cost, resources, actions, scope and quality.
• Organised various web meetings and online workshops in order to coordinate teams at different geographical locations using Citrix and web meetings.
• Discussed cost and need of a new software/hardware with the team leads to prompt Sr. project/program manager approve the best and most cost effective product, based on quotations sent by various vendors.
• Created and reviewed POs/invoices in PeopleSoft for new hardware/software purchases and fixed bid/T&M/staff augmentation contracts with the management to select and approve the best service provider.
• Interacted directly with the vendors (Sapient, Wipro and others) for any queries regarding SOWs, invoicing and other contract/resource related issues.
• Provided ad-hoc information and worked closely with PeopleSoft team, vendor management office and finance department to analyse, enhance and establish quality processes for various operations.

Environment: UML, Oracle, PL/SQL, MS Word, MS PowerPoint, MS Excel, Visio2003, MS Project 2003, MS Sharepoint, Quality Center, WindowsXP/2003 and UNIX.

Confidential, Lincolnshire, IL

Sr. Business Analyst / Project Coordinator

Responsibilities:

• Involved in automation of 401K plan administration (administering/managing various benefits offered by Dell Computers to its employees like their Portfolio, Mutual Fund Investments, Withdrawals, Transfers, Reallocations, Loan Payoffs, Loan Request, Rollovers, Payroll etc.) ), a new implementation project undertaken by Confidential .
• Worked closely with stakeholders, project managers and senior business & SQA (software quality assurance) analysts in defining, documenting and diagramming business process flows and 401K plan provisions
• Involved in preparing quality response to Dell computer’s RFP (Request for Proposal) to fetch the project.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) in different iterations and phases (Inception, Elaboration, Construction and Transition) of the software development life cycle (SDLC).
• Facilitated JAD (Joint Application Development) sessions for requirements gathering, analysis, validation and documentation to document functional specifications, technical specifications, use cases, use case diagrams, business rules, screen prototypes and activity/sequence/class diagrams etc. per user inputs and agreement.
• Created process flow diagrams to understand the accounting system for payroll (earnings, deductions, taxes, direct deposits, special check processing etc. as required per federal, state and local laws) and for reporting.
• Worked closely as a bridge between the users and the development team (on-shore and off-shore), clarifying requirements and resolving issues, surfaced during software development lifecycle.
• Coordinated with the offshore team through conference phone calls, emails and documents saved in the project database using IBM - Lotus Notes.
• Led the team of BAs and coordinated all the business analysis and project management related efforts. Helped project manager extensively in administrative and coordination activities.
• Worked with project manager to prepare project plan, iteration plan, implementation plan, tasks identification/creation, resource assignments and cutover plans. Worked on MSS/ESS and reporting modules of PeopleSoft to help project manager in various status reporting and project analysis tasks.
• Prepared Gantt/PERT charts, status reports, issues/risk logs, mitigation plans and project and performance metrics to communicate status of project deliverables against timelines to the higher IT management.
• Worked extensively with the QA (quality assurance) team for designing and validating test plans, test scripts and test cases for functional, regression, integration and user acceptance (UAT) testings.
• Worked with data modellers and data profilers in formatting the HR-feeds and data cleansers for cleansing, enrichment and formatting of EDI data feeds to be sent to the client as output for their use.
• Performed automated testing on ECHO and ATTA ( Confidential proprietary automated testing tools) as well as manual testing of the 401k YBR website, IVR system. Tested stage and production environment extensively. Logged and reported any defects using Clear Quest.
• Wrote SQL queries by using Confidential proprietary tool ATCI (Automated Test Case Identification) and BFQuery to identify test participants/data using DB2 on MAINFRAME.
• Designed mock-ups and tested reports/statements (PCS - personalised communication statements) created.
• Worked with information architect for user interface (UI) design i.e. designing YBR (Your Benefit Resources) website/web page wire-frame prototypes and IVR (Interactive Voice Response) menu for 401K plans.
• Took care of change management, configuration management and project documentation such as business process models, workflow diagrams and problem definition documents.
• Reviewed and evaluated the deliverables before delivery to users to confirm that the standard criteria are met.
• Trained users on how to operate and manage their 401K accounts on YBR website and IVR systems.

Environment: Windows 2000, WinRunner, LoadRunner, Oracle11i, Microsoft Project 2000, UNIX, MS Access, MS Office Suite, IBM - Lotus Notes, PeopleSoft, HTML, DHTML, IIS, Java, JavaScript, JSP, MS SQL server, Mercury Quality centre, RUP, UML.

Confidential, Minneapolis, MN

Sr. Business Analyst/ Project Coordinator

Responsibilities:

• Conducted user interviews, one to one sessions with the managers and the critical users, and arranged JAD/JRP/JARD sessions at both in-house and client locations to gather requirements.
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Involved in creating business process models/workflows, activity diagrams, class diagrams, use cases, use case diagrams, UML models, functional requirements, business requirements, test strategy and test plans.
• Performed gap analysis by preparing and analysing AS IS and TO BE workflow.
• Performed feasibility analysis, risk analysis and business process mapping for new requirements.
• Involved in creating/enhancing/managing requirements, analysis and design using Rational Tools (Rational Requisite Pro, Rational Clear Case, Clear Quest and Rational Rose).
• Owned project planning, scheduling and coordination to achieve timely and priority based product delivery.
• Led, motivated and coordinated team efforts for timely delivery of quality products requested by business. Coordinated all project management and business analysis efforts.
• Used MS SharePoint extensively for document storage, tracking, linking and management.
• Involved in writing test strategies, test plans and implementation of QA methodology.
• Involved in comprehensive data modelling, data profiling data cleansing and data verification.
• Mapped data to the new system providing design for data extraction and data loading.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases.
• Assisted with user testing of systems (User Acceptance Testing), developing and maintaining quality procedures, and ensuring the appropriate documentation of training sessions and enhancement requests.
• Involved in training users and end users on how to operate the system and in writing user manuals for newly created or modified system.

Environment: Rational Unified Process (RUP), XML, XSL, XSLT, IIS, Java, J2EE, Web sphere, Visual Basic, MS Excel, MS Project 2000, MS Word, Microsoft Visio, MS SharePoint, PL SQL, SQL, Oracle 9i, Unix, WinNT, Win Runner & Mercury Quality centre.

Confidential, Malvern, PA

Sr. Business Analyst

Responsibilities:

• Gathered requirements from users assuring that the artifacts are in compliance with the SDLC guidelines.
• Storyboard methodology was used to gather requirements from various stakeholders.
• Prepared a schedule and work flow, following agile methodology of software development.
• Used Requisite Pro for requirement management/traceability/exporting and MS Visio to draw diagrams for better representation and understanding of the design.
• Extracted and validated performance data sent by market sources like Morning star, Lipor Inc. and Bloomberg using different formulas given by the portfolio managers.
• Interaction with the different SMEs deciding about the design and format of the reports.
• Involved in data cleansing during ETL process. Performed data analysis, data validation and data profiling.
• Worked with data modellers. Helped in enhancing data quality, data integration and data enrichment.
• Created logical database design and helped in creating physical database design.
• Used agile analysis model and agile methodology of SDLC (focusing on frequently changing business needs) to prepare use case diagrams, narrative use cases and business flow diagrams.
• Organized workshops, explaining technical the design of the reports to be uploaded on business objects
• Assisted technical team in quality testing and production testing to ensure that reports reflect user needs for the performance and usability.
• Coordinated all project management activities like project planning/scheduling, identifying tasks and resources, creating WBS, tracking and monitoring project status and progress etc.
• Involved in writing functional, user acceptance testing (UAT) test scripts and in facilitating, executing and coordinating testing

Environment: Agile, Java, Java Swing, Servlets, JavaScript, Oracle, XML, UML, Windows XP, Sun Solaris, Linux, WinRunner, Mercury Quality centre, Crystal Reports, Business Objects, Informatica, J2EE, Rational Suite, MS Project 2000, MS Word, MS Excel, MS Visio, MS SharePoint.

Confidential, Lockport, NY

Sr. Business Analyst

Responsibilities:

• Used JAD(Joint Application Development) sessions and one to one meetings with the stakeholders, groups- policy holders, agents project head and the technical side of the project
• Developed a project plan for the development and implementation of the new system
• Used an iterative model of software development to develop artifacts after each stage of the process
• Authored the business case document preparing the vision, scope and environment document on the basis of business model
• Conducted web page mock-ups in MS Visio by creating activity and process flow diagrams
• Extensively supported development team in online transaction processing applications
• Prepared wire-frames and prototypes for the web based application for better visualization and verification of user requirements. to refine functional requirements and send final specification model to be developed and tested
• Closely worked with technical team on detailed test plans, test cases, and test input data
• Worked closely with QA and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Involved in writing user manuals and training users about the new system.

Environment: MS SQL Server, HTML, DHTML, JSP, C++, Rational Suite, Mercury Test Director, QTP, ASP.NET, UNIX, Windows NT, MS Word, MS Excel, MS PowerPoint, MS Visio, MS SharePoint, MS Project 2000.

Confidential, NYC, NY

Business Analyst

Responsibilities:

• Analysed impact of proposed solution across the business, develop use cases to explain/demonstrate business requirements/specifications to IT team, and contribute a business process perspective during design reviews.
• Made a detailed analysis of the existing systems and developed a model to develop a common Fixed Income trading platform with expertise in Fixed Income securities and trading for Fixed Income portfolios.
• Interacted extensively with business through JAD sessions and one to one interview sessions to write use cases, drawing UML diagrams and designing graphical user interface prototype.
• Worked closely with on-site and off-shore team members, resolving issues that surfaced during this stage of the software development lifecycle.
• Applied Iterative Model technique in every stage of the SDLC.
• Managed the workflow process using SDLC methodology and Iterations.
• Studied simple Fixed Income securities (Bond) to more complex structured products like MBS and ABS
• Extensively used ER diagrams and performed data modelling
• Worked with Information Architect to create wire-frames / prototypes of the web based application.
• Worked directly with senior development engineers to identify areas to focus testing activities, report and track defects and project schedules. Helped them wherever they needed.
• Extensively involved in user acceptance testing, performance management and documenting user manual.

Environment: Rational Requisite Pro, HTML, JavaScript, Rational Rose, RUP,UML, Oracle 8i, SQL, PL/SQL, MS Word, MS Excel, MS PowerPoint, MS-Project, MS SharePoint, Windows 2000, Crystal Reports, MS Visio.