SUMMARY

• Project scope Management activities, planning, scheduling and risk analysis of projects
• Developing project charters, change requests, work breakdown structures (WBS) and lessons - learned reports
• Proactively Conducted project review meetings and daily scrums
• Adopting a matrix organization structure to administer the projects
• Strong development and follow up of quality matrices, checklists, risk registers
• Conducting kick-off meetings, communications with off site and on site business clients and customers. Successfully managed projects using scrum.
• Experience working on SDLC models such as the waterfall and RAD life cycle model.
• Working with cross-functional teams in the development, and quality control of applications, and databases
• Recent project experience also included agile software development approach and sprints
• Tools used: MS Project, Gantt project / Gantt chart, impact matrix (for risk analysis)
• GAP and risk analysis for projects, prioritizing and requirement gathering through participating in interviews and workshops
• Conducting JAD/JAR sessions to define the AS-IS and TO-BE business processes with business community, development team.
• Testing, creating use cases with QA analysis while referring to existing system documentation and procedures.
• Documenting Business Plan, Business Requirement Document (BRD), Functional Specification document, Standard Operating Procedures (SOP), use case scenarios, collaboration diagrams, sequence diagrams, activity diagrams, state charts, process models, test plans and test scripts.
• Performing Risk Analysis of the requirements to identify the key business risks areas for the project and prioritized the application development and testing.
• Experience in manual testing, GUI Testing, field validation testing, and functionality testing of UI and standalone applications
• Experience in project management tools like MS-Project for planning and status reporting
• Developing reports using the Cognos Reporting Tool
• End to end experience in gathering user requirements, designing framework model using the three tier approach of database layers/ business layers and presentation layers, writing and developing reports
• Preparing test cases for initial testing of reports and after support services
• Preparing technical documents for both report studio and framework manager
• Active involvement in SIT /UAT process

TECHNICAL SKILLS

Project Management Tools: MS Excel, MS Visio, MS Project, MS Word and PowerPoint, Pencil Project, Simple Diagrams, Rational Requisite Pro.

Methodology: Agile, Scrum, RUP, Water Fall, Business Modeling

Modeling Language/Tools: UML, MS Visio

Database: MS Access, SQL Server 2000/2005, MYSQL, Oracle

Reporting Tools: Cognos 8/10, Tableau, Qlik View, Crystal Reports, SQL Server 2000/2005 reporting services

IDE: Microsoft Visual Studio 2003/2005/2008

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Business Analyst /Lead

Responsibilities:

• The Electronic Data Services and Web Development department is running multiple projects, up to 22 at a given time to improve and maintain data management, incident management (Remedy) and reporting services. My responsibilities are to identify requirements from sponsors and businesses and to lead the development teams.
• Project was an Oracle ERP upgrade from 11i to R12 involving 22 operating units. This job role required a lot of interactions with different businesses; most interaction was with Sales, Finance, HR, and online Store departments.
• Involved in all phases of the Project Development Life Cycle, like user requirement analysis, design, development, implementation, conversion, upgrade and support of an application in diverse SDLC methodologies.
• Actively involved in the decision making process to implement the new data warehouse solution.
• Lead the on-site for off shore model teams in India, Canada, US, Porto Rico and Mexico.
• Developed work breakdown structures (WBS) and allocations and review of daily status reports to support efficient development in a robust agile environment.
• Working directly with senior leadership and sponsors to provide the reporting services including score cards and dashboards to support operational and strategic goals
• Managed the 22 up gradation projects simultaneously to ensure compliance and completion by the hard deadline
• Managed vendor communications and facilitated application teams with upgrade negotiations and issuance of pay orders.
• Driving the resolution back end data integrity issues by updating the data field maps in remedy.
• Conducted Impact Analysis across the applications to identify those affected by conversion while working directly with senior leadership, program manager, SMEs and multiple app management teams.
• Worked in all the sprints of the project in SCRUM.
• Developed End to End Workflow to visualize application dependencies and integration to facilitate Integration and End to End testing.
• Conducted impact analysis of the 150+ Cognos reports impacted by the Up gradation
• Co-ordinated with the existing Cognos Team to provide remediation for the impacted reports
• As a senior IT Analyst, also provided support to the Cognos application and reports
• Interviewed and assessed proposals from vendors to arrange resources for quality assurance and testing.
• Responsible for receiving sign-offs and managing the scope, requirements and requested changes.
• Presenting deliverables to sponsors and senior management while providing training to use the new systems and tools.
• Establish System Analysts taskforce to facilitate testing and supervised development of test cases based on requirements.
• Facilitating User Acceptance Testing and conducting system testing and supervising bug tracking and resolutions

Environment: Agile/Robust, Epic, Remedy, Qlikview 11.2,Planview, IBM Cognos (Report Studio and Framework manager), Oracle11i, Service now, SQL Server 2012, MS Visio, MS Excel, SharePoint 2010

Confidential, Pittsburgh, PA

Sr. Business Analyst

Responsibilities:

• Interacted with the Subject Matter Experts (SME's) and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Worked with Internal Users to define requirements and coordinated user management and developer expectations.
• Business Requirement Document (BRD) and Functional Specification documents prepared along with Impact analysis
• Used SQL queries for extracting desired data from multiple databases.
• Developed Use Cases using MS Visio, and a detailed project plan with emphasis on deliverable.
• Monitored Change Requests and documented requirements, integrating them with Use Cases.
• Assisted QA team in developing test scripts, test cases and test plans and automation of the test scripts for the user acceptance testing.
• Conducted system and User Acceptance Testing (UAT) by defining the test plan, test cases
• Developed various Cognos reports to assist the project
• Maintained proper communication with the developers ensuring that the modifications and requirements were addressed and also monitored these revisions.
• User administration, configuring various utilities, and data backup
• Also worked as a proxy PM for project coordination, facilitation, time management, risk assessment and work breakdown structures (WBS).

Environment: Agile methodology, MS Visio, SQL Server 2000, MS Access, Windows server 2003, Windows XP.IBM COGNOS Framework, IBM Cognos Report Studio, Tableau

Confidential, Orangeburg, NY

Sr. Business Analyst

Responsibilities:

• Utilized Rational Unified Process (RUP) to configure and develop process, and procedures.
• Designed Mapping documents, conducted Data Profiling, Reviewed Metadata and Verified source-to-target mappings between data sources and target data stores.
• Helped IT Team develop SSIS package to apply business rules driven by market using dynamic sql script.
• Documented.Net Windows Form application to supply parameters for on-demand execution of SSIS packages for the end user.
• Validated data model has accurate definitions and joins.
• Developed reports using BI Cognos Report Studio and packages using Framework Manager
• Helped in writing technical training material and memorandum of the company.
• Lead the less experienced staff for efficient UAT process.
• Provided oversight and mentoring in various data analysis and test phases.
• Performing impact analysis, GAP analysis and risk analysis.
• Worked on Data Integration and Data Migration.
• Created UML based diagrams using Rational Rose for Use Cases and Activity Diagrams/ Business Process Flows for better understanding of the layout of the new process.
• Facilitated and managed meeting sessions with a committee of SMEs from various business areas.
• Involvement with the QA team to design test plans, test cases and test scenarios.
• Participated in regression testing, system testing and functional testing.
• Played a key role in the planning, testing, and implementation of system enhancements.
• Identified Data Testing issues.
• Participated in the System Analysis, Design and deployment, Testing and migration to the Production server and maintenance of the Production software applications.
• Used VISIO for design and architecture and flow diagrams.
• Created documentation and trained administrators and tech support personnel.
• Documented and maintained the RDB design of the systems using ER Models.
• Involved in extensive debugging and unit testing of the application.

Environment: RUP methodology, Waterfall, Rational Rose, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), MS SQL Server, PL-SQL, SSIS, SSRS, ETL Informatica, IBM COGNOS.

Confidential

Project Manager

Responsibilities:

• Conducting planning, scheduling and risk analysis of projects and communication with onsite business clients and customers.
• Used a matrix structure to administer the projects
• Developed project charters and work breakdown structures (WBS). Experience on SDLC Models.
• Discussions with clients about present reporting system and understand their current reporting issues to meet their needs.
• Demonstrating the flexibility of Cognos using Cognos Report Studio, and how Cognos could help them to meet their reporting needs.
• Building POC reports to showcase how to achieve client needs using real time scenarios.
• Deployed the Cognos Content from Development environment to UAT/Production environments
• Involved in User Acceptance Testing (UAT) process for every project led.
• Worked extensively on checklists, risk registers and impact analysis to ensure smooth operations
• Worked with cross-functional teams in the development, and quality control of applications, and databases
• Closely worked with Cognos Support team for troubleshooting complex issues.
• Supported Cognos 8 environment in multiple projects. Major departments included: HR, Sales and contact centers reporting. This included day to day support as well as an upgrade.
• Analysis of Fact and Dimension tables used in the Cognos FM model for Package building.
• Built new packages using Cognos Framework Manager and converted the existing reports from Excel to Cognos reports using Cognos Report Studio. Also conducted an impact analysis
• Performed the distributed installation and configuration of Cognos 8.4 on new servers in Production, Testing and Development environments.

Environment: Cognos 8.4 Report Studio, Analysis Studio, Event Studio, Metric Studio, Query Studio, Cognos Power Play Transformer v8.4, Siebel 7, e-Point, Avaya 10 Agent, MS Project, Gantt project / Gantt chart, impact matrix (for risk analysis)