PROFESSIONAL SUMMARY:

• An IT Project Coordinator/Business Analyst/Project Manager with over Seven years of experience providing support to IT Project Management Offices (IT PMO) within global Healthcare, Insurance, and Telecommunications corporations.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Procedures.
• Proficient in technical and business writing, business process flow, business process modeling, business analysis and testing various methodologies.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, and MicroStrategy.
• Involved in Planning, Preparation, Execution, Issue Resolution and Report Generation to assure that all aspects of a Project follow the Business Requirements.
• Provide project management support including monitoring schedules, tracking budgets, allocating resources, facilitating meetings, mitigating risks, and maintaining communications using MS Project and Clarity.
• Strong documentation skills with hands - on experience using Crystal reports, SAP, and SharePoint to provide status reports, manage technical documents, and update project management data.
• Advanced MS Office skills with experience analyzing data using Excel spreadsheets, complex formulas, pivot tables, and vlookups as well as using PowerPoint to create and deliver technical and functional presentations.
• Excellent communications skills with experience supporting report delivery and stakeholder communications.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
• Experience working with SAP Enterprise Asset Management (EAM).

TECHNICAL SKILLS:

Programming Languages: C, C++, C#, VC++, VB, VB.NET, C#.NET, ASP.NET, Java, SQL, PLSQ

Development Methodologies: RUP, AGILE, Waterfall, ESDM, STV

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM WebSphere, ATG Dynamo, BEA WebLogic

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

IT Project Coordinator

Responsibilities:

• Coordinated with functional, non-functional, and operational teams and the business groups on process streamlining and process improvement for the NYMMIS project being undertaken by Conduent.
• Participating in Release Planning to ensure SMEs are identified for planned deliverables
• Liaising with IMS Team (Integrated Master Scheduler) to ensure program milestones and release/sprint commitments are aligned and reported in the IMS
• Supporting Elicitation/Decomposition and Elaboration sessions
• Assisting the team with intra-team communication and coordination to engage functional and non-functional SMEs on a timely basis
• Assisting the team in the requirements preparation and inclusion of MITA BPs, Policies, and PSIs
• Analyze project details and requirements, and completed documentation relevant to the concerned project, including technical and support documents
• Working with the teams on decomposition and elaboration of the high-level requirements into technical/functional requirements and specifications for the benefit of the development and testing teams
• Identifying the deliverables for the project at both development and business levels
• Continuous monitoring of the project requirements as well as the updated baselines
• Updating the requirements traceability matrix as well as cooperating with the testing and QA teams to implement new validating procedures
• Working with the IT architect and development teams to identify and analyze best IT solutions for the project implementation, as well as documenting technical specifications for the IT solutions
• Liaised with the business group, the development team, and the testing and deployment teams to ensure a smooth rollout of the project releases completed without disruption to client systems
• Cross-cultural and team interactions due to multiple teams interfacing across multiple time-zones
• Ensuring Monitoring / Reporting are occurring regarding:
• Impediments, action items, risks and issues in Version One and SharePoint (planned to actual dates)
• Dependencies tracked to address / minimize impediments on a timely basis
• Visibility to Release Planning outputs and Story commitments
• IMS, Dashboard and other status reports are up-to-date
• Worked as part of the business development team in the Project Management Office to identify new and existing business processes for implementation/improvement
• Working closely with the Release Management team to identify product backlog and conduct sprint planning, as well as documenting the release scope to determine technical work inherent for each release
• Regular development status updates in business terms to the internal stakeholders
• Timeline impact analysis based on project changes/updates
• Understanding the business needs of the project

Environment: Version One, SharePoint, Microsoft office 365, DOORS, RQM, Microsoft Servers, IBM Blue works live.

Confidential, New York, NY

IT Project Coordinator/Senior Business Analyst

Responsibilities:

• Support IT Project Management Office (IT PMO); monitoring schedules, tracking budgets, allocating resources, facilitating meetings, mitigating risks, and maintaining communications using MS Project and Clarity.
• Provide status reports, manage technical documents, and update project management data utilizing Crystal reports, SAP, and SharePoint.
• Heavily involved in meetings to understand project requirements to translate them to an efficient design.
• Create and deliver technical and functional presentations during project meetings to deliver stats reports and stakeholder communications.
• Utilize Excel spreadsheets, complex formulas, pivot tables, and vlookups and mapping documents of existing processes and systems, for enhancement projects.
• Conduct risk analysis, addressing issues such as data issues, environment issues, and performance issues.
• Analyzing the existing informational sources and methods, understanding the customer expectations for the included applications.
• Create, Control and own the defect process of tickets created in the HP ALM process.
• Performed the root-cause analysis and defects resolution for the issues raised during the production run.
• Analyze and study the source system data models to understand concept tie-outs such that the integration process into existing data warehouse is seamless and data redundancy is eliminated.
• Query UDW using Teradata SQL assistant and profile data to understand relationships between data objects and domain dependencies.

Environment: Teradata, Windows Server 2008, SQL Loader, Toad, HP ALM, Microsoft Office.

Confidential, New York, NY

IT Project Coordinator/Business Analyst

Responsibilities:

• Responsible in a project that involved enhancing the system by creating a custom application with in JIRA used by Cisco and to migrate the application to be functional on the Sales force domain.
• Worked on migrating the existing functionalities and apps from the previous domain being used to the sales force domain.
• Worked as a Sales force admin during this project.
• Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
• Conducted Gap Analysis to show the current and proposed functionalities of the system.
• Extensively used agile methodology's best practices during the SDLC.
• Gathered business, system, and functional requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME's).
• Identified and developed Use Cases from the business and systems requirements. Documented high level and detailed Use Cases to include all the functionalities of the new system.
• Gathered the functional and business requirements by conducting JAD sessions and participatory Design Sessions involving major leads from the Technical Department.
• Followed the UML methodology to Create UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams (DFDs), ER Diagrams using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
• Creation of client notification letters, emails, web updates, statement inserts, etc.
• Facilitated meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
• Extensively used Rational Requisite Pro to gather and manage requirements. Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Prepared custom reports and performed SQL query, data analysis and verification on MS Access.
• Monitored version control and defect tracking activities using Rational Clear Case and Rational Clear Quest.
• Supervised the User Acceptance Testing (UAT) to test the usability of the application.
• Pre- and post-conversion training along with weekly status reports.
• Worked with MS SQL Server suite of products like SSIS, SSAS and SSRS

Environment: Salesforce SFDC CRM, JIRA, Windows, Qlikview BI, JIRA, SQL, NetSuite ERP, Microsoft Excel (pivot tables, v lookup), Microsoft word, Microsoft Access, Power Point, Agile Methodology, Rational Requisite Pro, MS Visio 2007, HP Quality Center.

Confidential, Waltham, MA

IT Project Coordinator / IT Business Analyst

Responsibilities:

• Support IT Project Management Office (IT PMO); monitoring schedules, tracking budgets, allocating resources, facilitating meetings, mitigating risks, and maintaining communications using MS Project and Clarity.
• Provide status reports, manage technical documents, and update project management data utilizing Crystal reports, SAP, and SharePoint.
• Heavily involved in meetings to understand project requirements to translate them to an efficient design.
• Create and deliver technical and functional presentations during project meetings to deliver stats reports and stakeholder communications.
• Utilize Excel spreadsheets, complex formulas, pivot tables, and vlookups and mapping documents of existing processes and systems, for enhancement projects.
• Actively participated in all the phases of the life cycle
• Initiated the project with Gap Analysis and SWOT Analysis, followed by Framing document
• Planned and organized JAD sessions for drafting out the High-Level Business Requirements
• Analyzed BRD and created Systems Architectural Design Documents, Technical Flow Diagrams detailing Interconnections between the various Sub-Systems and their ability to handle various Failure Scenarios at each level.
• Drafted out the Work Flow diagrams, showing the cross functional dependency through SWIM lane diagrams.
• Create and review functional specification documents and organize signoff from the senior Business users and Directors
• Incorporated Rational Unified Process (RUP) and analyzed Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS) using Requisite Pro, Rational Rose and MS Visio.
• Reviewed with architect and technical team various technical design documents as well as input and output parameters for various web services.
• Understood the Business Process and the Functional Specifications of Web Sales process, Underwriting, Evaluation, Enrollment, Membership and Billing, Claims, and the Vendors Business Processes.
• Involved in the SDLC and Agile Methodology for various mid-sized projects simultaneously.
• Develop process models and use cases
• Work with project stakeholders to translate their requirements into something that developers can understand as well as to translate the resulting questions that the developers have into something the stakeholders can understand.
• Translate technical requirements - Break down technical and architectural complexities so that project stakeholders can easily understand issues that crop up.
• Apply rigorous Information Protection standards, define and design application functional and user interface requirements, develop use cases and test plans, involve with system testing, conduct testing validation.
• Assist the team in technical design and reviews of Code.
• Organized impacted systems into high, medium and low impact to help business analyze the level of effort for remediation activities and ease resource allocation work.
• Prepared and maintained requirements traceability matrix (RTM) throughout the project lifecycle.
• Create Test Scenarios using MS Excel
• Involved in UAT, executing test cases evaluating test results and preparing test summary reports Analyzed defects reported in test director.
• Assist in Development and Technical Issues
• Extensive testing - DIT, SIT and UAT
• Responsible for team leading of 25 people
• Set Objectives and do performance appraisals

Environment: MS Windows 7/XP/NT/ Server 2008, MS Project, Object-Oriented Architecture as front-end using Java/J2EE, XML, XSD, JSON, Mongo DB, VCMS (Video Content Media Suite - A Cisco Product), Cisco Search Engine, WEB-services, SOAP, RESTful Web Services, UML, SharePoint, Jira (Defect Tracking), MS Word, MS Excel, MS Power Point, MS Visio, SPLUNK.

Confidential, Columbus, OH

IT Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collects requirements from department managers and users for enhancements. Acts as liaison between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Used IBM WebSphere Business Modeler to fully visualize, comprehend, and document the business processes. To model and optimize the business-critical processes. Define and refine process models through the company's best practices.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Created reports from SAP modules using Business Objects / Crystal Reports based upon business requirements.
• Used Balance Scorecard approach for developing program strategy to manage the grants program and development of metrics for monitoring success of program. Used Microstrategy dashboards for data analysis and custom reports.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2005.
• Tested Performance & Accuracy related queries under SQL Server
• Designed and implemented basic SQL queries for testing and report/data validation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Manage Scope and change throughout the SDLC process of the product.
• 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
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase