SUMMARY:

• Solutions - oriented professional IT consultant who excels at managing projects, collaborating with project teams, interfacing with clients, and deploying technology to build successful solutions for clients. Certified Scrum Master.
• 9+ years of experience as Business and Systems Analyst, Consultant having expertise in Design, Development, Enhancement, Customization and Implementation of Master Data Management (MDM) and Oracle Order Management.
• Over 3+ years of success in delivering projects on time and within budget through improved productivity, performance, and cost control. Communicate effectively with all levels of management.
• Experience in managing Web-based and client/server-based applications, E-Business Suite, ERP and custom development projects.
• 4+ years of experience in effectively managing remote (China/India) and local (US) development and test teams.
• Certified Scrum Master, successfully migrate 2 Tracks from Waterfall to an Agile Methodology.
• Experience in writing User Stories, Sprint planning and daily standups.
• Solid in project management essentials of initiating, planning, executing, monitoring, and closing as well as processes, methodologies, tools, scope of management, budgeting, financial tracking, scheduling, resource management, solution identification and assessment.
• Expert in Designing E2E Business Processes to support No-Touch / Minimal Touch Processes.
• Deep understanding (7+ years) of Cisco’s Business and System Processes spanning across MDM, Customer Registry, Quoting, Ordering and Services.
• Proficient in Waterfall, Agile and Test-Driven Design project management methodologies.
• Extensive experience on MDM, Oracle Order Management Applications - Quote to Order along with full exposure on OLAP.
• Detailed understanding of Cisco’s Service Quoting, Ordering and Service Contracts Process along with Install Base and TCA Architecture.
• Rich work experience working with Business and IT Teams, x-Functional Tracks, Change Management and Leadership Teams.
• In-depth knowledge of IT functions and services. Plan and manage multiple project/track releases, making key decisions and prioritizing tasks to keep projects on schedule.
• Experience in Business Process/Requirements Analysis, Mapping requirements to standard application functionality, module set up and configuration, documentation (BRDs/FRDs), ability to spec customizations and reports, and knowledge transfer experience.
• Experience in Software Designing, Code Development, Unit and Integration Testing, Cutover and Production Go-Live, User and Technical Training & Support/Maintenance Post Go-Live
• Expert in evaluating new functionality, tools, modules, version releases, and third-party applications and makes recommendation to client regarding their applicability and fitness into the overall enterprise system
• Expert in managing 3rd party applications/Data Provider companies like Trillium Software, Duns and Bradstreet and Avention.
• Proficient in leading large size project teams involving multimillion dollar / multi-year projects
• Competent technical expert with 6+ years of hands-on development, quality assurance and automation.
• Rich Experience in Application Lifecycle Management tools like HP, Rally etc.
• Led the QA Team to increase the progression automation % from 20% to 60% in over 3 quarters and regression % from 30% to 80%.
• Well versed in creating reporting frameworks mainly using Excel Macro, SQL Queries, Tableau and Business Objects. Building Metrics, Reports, Pivots and Graphs & Charts like Gantt, Burndown etc.

TECHNICAL SKILLS:

Domain Exposure: Process Compliance Program like Master Data Management - Customer Registry, Site and Account Management. Order Management - Cisco Commerce, Service Contract Management and Install BaseSoftware Testing: Test Strategy, Test Plans, Test Case Design, Test Automation including designing framework, Reporting and Defect Management

Reporting Tool: Tableau and Business Objects

Data Quality Tools: Trillium Software for Quality, GRID Tool, HP ALM Quality Center and Test Director, Rally

Third Party Data Provider: Duns & Bradstreet, Avention and Trillium etc.

Modeling Tools: Visio, ERWIN and Conformiq Modeler

Automation Tool & Framework: Selenium WebDriver, IDE. TestNG, Jenkins for Continuous Integration

Languages: SQL/ PLSQL, Java, C# and HTML

ETL Tools: Informatica 7.X/8.X, DataStage 7.5.2

Databases: Oracle 9i/10g/11g, Teradata, MS SQL Server and MS Access

Web Application Tool: SOAP UI / REST

Operating Systems: Windows, Unix

Documentation Tools: MS Office (Word, Excel, Power Point, Project)

Version Control: SVN, PVCS and Visual Source Safe

PROFESSIONAL EXPERIENCE:

Project Manager

Confidential

Responsibilities:

• Manage release over release projects with a development and test teams to develop/test system that is competent to survive on a longer run.
• Establish and maintain the project vision, scope, design, schedule, budget, and resource plan.
• Charting a timeline for all activities. Review Business and QA execution plan along with Change Management Plans.
• Review cross functional architecture, solutions and system design resolutions by conducting meeting with Architect leads , PM leads , boundary leads , test leads and change management leads .
• Manage deliverables and activities to Cisco’s Project Lifecycle (PLC) and defined milestones (from Concept commit to Normalization ).
• Establish cross-functional partnerships to minimize risk and issues .
• Guide all teams through full lifecycle and provide technical guidance and assistance as needed.
• Manage scope, effort / cost, schedule, and quality, while continuously identifying and mitigating underlying risks.
• Conduct various war-rooms to plan risk mitigation on any foreseen risks and critical defects.
• Manage and coordinate test execution activities , including BAT and UAT .
• Review baselines and goals from the developments and test teams.
• Management escalation if required.
• Establish cross-functional partnerships to minimize risks and issues.
• Assess daily updates from development and test teams based on their submitted baselines .
• Provide weekly project status to the higher management and cross functional PMs and send a daily status reports on the progress of development and test executions.
• Conduct various meetings, scoping the benefits on retiring 3rd party data provider and introducing a new 3 rd party data provider vendor like Avention/Trillium/DnB fits to the process designed newly along with a new data model accompanied with latest technologies.
• Migrating all tracks from waterfall to an agile methodologies, successfully completed for 3 tracks
• Analyze the structure, forecast the quality of data and pain areas on to plug n play new 3rd party data provider.
• Collaborate with stakeholders to elicit and review Requirements and Design.
• Work with Business Solution Team to identify new business rules and policy to be implemented on accepting the data from the 3 rd party data provider without affecting the AS-IS behavior.
• Analyzed the complete legality, geography and business impact on Cisco End to End (E2E) from MDM perspective.
• Adopted an agile methodology and successfully migrated 2 tracks from waterfall to an agile.
• Conduct/Attend Daily Scrum meetings and sprint accomplishment meetings.
• Post Production Troubleshooting and analysis of business streamlining with in MDM Customer Registry and with other cross functional teams.
• Led the China Cisco team and built an overall assessment strategy/ plan for all the Customer Registry services for a localization project.
• Design a framework for analyzing the behavior of 2 tools to take decision that which could be the best in cleansing and validation for Cisco to manage MDM, New Tool Trillium (Address Cleansing & validation) Vs Old Tool Global Address, Data Migration and ETL Sanity Checks.
• Encourage and assist QA team to adopt automation. Current automation suite based on WebDriver and TestNG framework.
• Go-Live and Normalization support.
• Conduct Pre Release/ Post Release Assessments/ Success Wins etc.

Project Lead

Confidential

Responsibilities:

• Prepare Project /Track Plan, Efforts Estimates, Baselines and goals identifications, Scoping, Review Test Plan, Design Strategies and Prototypes Detailed Design.
• Managing and mentoring on-site and off-shore teams.
• Conduct dialogues with stakeholders to capture the requirements and discussion with technical teams to assess functional and technical details of various systems.
• Design E2E Business Processes to support No-Touch / Minimal Touch Processes.
• Functioned as the primary liaison between the business and the technical teams throughout the project cycle. Managed tasks within geographically dispersed international team members of Engineering, QA, Technical Support and vendors to provide standard/custom solutions.
• Create Assessment documents based on the interviews covering business overview, functional architecture, application interfaces and operational details.
• Define and validate project scope along with analyzing the business requirements.
• Identify and manage issues and mitigate risks to ensure timely issue closure and proper planning for risks.
• Collaborate with business, development and other project stakeholders.
• Facilitate knowledge transition to QA and support teams.
• Estimate level of efforts, prepare development project plan, QA Strategy and plan, manage onsite and offshore resources, and allocate tasks in changing priority environment.
• Access impact of change requests, generate options, recalibrate plans and advise team members.
• Prepare proof of concept for initializing new project.
• Identified as subject-matter experts especially in Order Management (E2E Order Processing) and led the E2E Order Processing team to provide the orders in stage environment for unit/integration testing.
• Conduct various sessions with Users to guide them on the data flow especially on the Q2O Orders.
• Lead and coordinate full Dev/BA/QA process lifecycle for QA Integration, UAT and regression testing activities.
• Lead the Data Mining Activities and supported Business Acceptance Testing/User Acceptance Testing for various initiatives.
• Build an efficient way of tracking the orders and requests from different users, automate the defect tracking mechanism.
• Conduct Defect War Room, daily status and review calls with multiple stakeholders, development team and QA team.
• Involve in Normalization to look after overall Quality of the fixes by taking assurance from QA team and supporting BAT in normalization phase.
• Ad-hoc meetings/war rooms, reports conducted upfront to expedite on solving the issue, analyzing and testing thoroughly.
• Involve in Change Management, trainings, and communications
• Involve in various Reporting and metrics using tools like Excel Macro/Business Objects and Tableau etc.
• Create Daily Status Reports and Metrics, ensured to cover all the relevant statistics along with the visual representation. Along with it created the Root Cause Analysis Reports, Pre-Post Release Assessment Reports, Exit Reports and Metrics to aid in taking analytical decisions.
• Create an Automated Tracker to track the progress of overall Development and QA Test Execution along with Defect Root Cause Analysis Reports to assist in any case of troubleshooting in test cycle.
• Provide daily status reports ensured to cover all the relevant stats along with best visual representation.
• Involve in Estimation Planning and Budgeting with Program and Project managers.

Project Lead/Quality Analyst

Confidential

Responsibilities:

• Prepare Project /Track Plan, Efforts Estimates, Baseline and goals identifications, High Level Scenarios, Test Plan, Design Strategies and Prototypes Detailed Design.
• Develop detailed test plans and test cases, as well as an Entrance and Exit criteria for the application being tested ensured along with standards for documentation to be followed.
• Managing and mentoring on-site and off-shore teams.
• Estimate level of efforts, prepare development project plan, QA Strategy and plan, manage onsite and offshore resources, and allocate tasks in changing priority environment.
• Access impact of change requests, generate options, recalibrate plans and advise team members.
• Conduct dialogues with stakeholders to capture the requirements and discussion with technical teams to assess functional and technical details of various systems
• Interact with Business User to understand Cisco’s Business and ERP application and Cisco’s custom business rules.
• Create Assessment documents based on the interviews covering business overview, functional architecture, application interfaces and operational details.
• Produce Use Cases for capturing system functionality from user’s perspective.
• Co-ordinate with offshore teams to guide them for technical documentation.
• Collaborating with cross-application teams along with business users to document and test the developed code based on business and system requirements.
• Present review sessions for approval of project documentation, Functional documents.
• Review Acceptance Testing test plans, executing test cycles, documenting results, and created sign-off documentation.
• Participate in peer reviews of documents created by other team members.
• Prepare status report to indicate current project status and connect it to wider audience and x-functional flow teams.
• Present applications that can be retained / revamped / replaced based on assessment exercise and actively contributed on successful new project proposals (RFPs).
• Lead and coordinate full BA/QA process lifecycle for QA Integration, UAT and regression testing activities.
• Analyze the flow of data, creating and generating business reports infoviews using BO, Excel Reports etc.
• Assist developers on presenting pseudo codes and mapping for Installed Base, Service Agreements and TCA tables.

Quality/Systems Analyst

Confidential

Responsibilities:

• Gathered the inputs and needs from the users and worked closely with Oracle Support team. Converted such needs into Business Rules which guided the functional team to put the requirements, and Design Specifications in each phase of the application plus estimation of time and effort for execution, which involved series of meetings with developers, Systems Analysts and X-flow Business Analysts to verify the flow of data and the required measures that can comes under report, testability of the requirements and signed off on requirements.
• Interact with Business User to understand Cisco’s Business and ERP application and Cisco’s custom business rules.
• Analyzed the flow of data, creating and generating business reports infoviews using BO, Excel Reports/Pivots etc.
• Worked parallel on Reporting and maintaining the quality of the data by performing various business validations.
• Created detailed Data Warehouse Test Strategy, Test plan and High Level Scenarios on the basis of Business Requirements gathered, Functional Documents and Technical Design Documents.
• Worked on Data mapping between DWH tables and OLTP tables.
• Involved in Data Modeling, Analyzing and Reporting of mass volume of data.
• Developed PL/SQL scripts, various database objects and ETL Mappings.
• Authored, Approved and Reviewed the Unit Specification, Unit Test Cases and High Level Scenarios.
• Executed the Unit Test Cases, defect logging and fixing.
• Monitored/Executed various jobs/mapping to load data.
• Effective Offshore - Onsite Coordination and worked in a cross functional team of Business, Architects and Developers to implement new features.

Technical Lead

Confidential

Responsibilities:

• Interact with Business User to understand Cisco’s Business and ERP applications and Cisco’s custom business rules to be implemented.
• Develop the changes in the web applications using Java.
• Develop PL/SQL scripts, various database objects to extract transform and load to the C3 systems.
• Create detailed Data Warehouse Test Strategy, Test plan and High Level Scenarios on the basis of Business Requirements gathered, Functional Documents and Technical Design Documents.
• Worked on Data mapping between DWH tables and OLTP tables.
• Involved in Data Modeling, Analyzing and Reporting of mass volume of data.
• Authored, Approved and Reviewed the Unit Specification, Unit Test Cases and High Level Scenarios.
• Monitored/Executed various jobs/mapping to load data.
• Involved and managed Unit Test, defect logging and fixing.
• Effective Offshore - Onsite Coordination and worked in a cross functional team of Business, Architects and Developers to implement new features.

Developer & Data Analysts

Confidential

Responsibilities:

• Gather Business Requirement, analyzed, validated, managed and documented the stated Requirements. Interacted with business users for verifying requirements, managing change control process.
• Develop the Data Capture Tool and Mapping Tool, web based applications using ASP.Net C#.
• Involve in Data Modeling, Analyzing and Reporting of mass volume of data captured through Data Capture/Mapping tool.
• Develop PL/SQL scripts, various database objects and ETL Mappings to extract and load the data into the reporting system.
• Author, Approved and Reviewed the Unit Specification, Unit Test Cases.
• Execute the Unit Test Cases, defect logging and fixing.
• Monitor/Execute various jobs/mapping to load data.
• Effective Offshore - Onsite Coordination and worked in a cross functional team of Business, Architects and Developers to implement new features.
• Play a role of Deputy Configuration Administrator (IR Management using PVCS Tracking Tool).
• Conduct meetings for project status, issue identification, and parent task review, Progress Reporting.

Developer

Confidential

Responsibilities:

• Develop WebPages for Portal, Content Acquisition Module.
• Code for Portal, Content Acquisition Module in C# by following coding standards.
• Develop database objects and created number of stored procedure both for Oracle and MS SQL 2000.
• Work on JavaScript for client side functions.