Amerish Yadav Email & Phone Number

Ottawa, On, Ca

Ottawa, Canada Area

Delivery management, Change and Release Management as well as managing account with 50+ FTE onsite/offshore in Global Delivery Model. Provided oversight and leadership to the overall account activities including delivery commitments, resource requirements, proposal evaluation and submission. Stakeholders and Client relationship management Established Governance policies and procedures for the effective project management including Stakeholder register, Communication plan, Risk plan, Change management procedures and Training and knowledge transfer process.  Developed work breakdown structures, resource plans and critical dependencies tracking. Established project budgets, budget management and forecasting. Managed vendors, sponsors and stakeholders expectations and escalations. Provided project reporting at the multiple levels and recommendations to Senior Management.  KPI tracking. Helped to identify required Production Support model and managed the handover process.

Roseville, Ca

The WCDS Consortium originated in 1967 with Santa Clara County, and has since grown to be 18 counties strong. With their long-standing collaboration and commitment to success, these 18 counties developed and implemented the CalWORKs Information Network, known as CalWIN - one of the nation’s largest automated welfare benefits and eligibility systems. The CalWIN system supports the determination and case management of federal, state, and county public assistance programs for these 18 counties. Job duties:• Team management, task assignment, issue resolution of the assigned projects• Provide consultation to WCDS on Business Intelligence roadmap and architecture enhancements • Defining, Tracking and managing – Project scope, schedule, task and resource requirements• Project Status Reporting to relevant stakeholders• Schedule and Process planning and adherence • Tracking of backlog issues and proactive risk assessment/mitigation planning• Vendor management and coordination with respect to deliverables of the assigned projects • Release and change management• Assisting in project audits/assessments• Establish and maintain QA processes for managing the assigned projects including scope, deliverables and work products, schedule, staff and costs;• Participation in standing management and committee meetings; Provide a health assessment current projects• Define and implement process improvements with respect to key learnings from the projects• Supervise Infosys team members at client site

Chandigarh Area, India

Leading a team of committed professionals to provide 24 * 7 support for strategic BI-BW applications for leading logistics client of Canada. Important job duties are below -• Manage and review day to day support related activities, assign tasks to team and monitor progress• Project planning and any change request estimation.• Risk assessment, mitigation and recommending tools.• Perform performance optimizations on BI Applications as well as BW applications• Prepare estimations, release plan and road map for future releases• Manage offshore team and coordinate with onshore team for support related activities.

Chandigarh Area, India

As a project manager I have exposure working for District of Columbia Access Systems handling teams of up to 15 people and also worked on multi million dollar projects with requiring little oversight from seniors.Tasks included-1. Project planning and execution and scope discussion2. Budget handling, Change Request processing (as required)3. Invoicing4. Client communication5. Offshore onsite coordination and guiding team for the work6. Guiding the team for their day to day tasks and tracking their tasksWorked as a part of solo PMO leading individual track for an big program. Status reporting, issues, budget etc. required to be reported to PMO,

This project is initiated to implement the health care reforms in Washington, DC.Responsibilities:Gather and Analyze user and system requirements, document them and take client sign off.Design the database for the new Information Technology projects for the customer on Oracle 11g using the tools such Toad (version 11.6), SQL Developer etcDesign Data Warehouse and software applications using ETL tool Informatica Power center and related tools.Work on EDW integration of multiple source systems. This includes designing Star Schema/Snowflake Schema, FACT & Dimensions tables, conceptual, physical & logical data modeling.Implementation of database performance tuning techniques in System Integration by using PL/SQL query performance.Create system and user reports using the SAP Business Objects (BI 3.1 and 4.1)Design, work and support in Data Analysis (cleansing, matching, standardization, profiling and scorecard) using IDQ Informatica Developer Client 9.5.Design and create SQL and PL/SQL programs Stored Procedures, Functions, Packages, triggers and Indexes.Coordinate with the teams at client location and offshore location (India).

Hoffman Estates, Il, Usa

Leading Telecom provider of the USA merged the reporting of its Wireline and Wireless services in order to enhance the customer experience. Responsibilities:Worked closely with Business Clients for requirements for IVR as well as Reports area.Prepare and reviewed High Level Design and Low Level Design DocumentsDesign new database environments and implement the sameDesign and create SQL and PL/SQL programs Stored Procedures, Functions, Packages, triggers and Indexes.Work on perform data mining analysis for the client production environment on regular basis. Provided ideas to Client for successful merging of applications from both side. Provided extensive support for successful production implementation. Part of War Room. Provided support to Business Users by resolving their queries on new data. Onsite Offshore coordination; Nortel IVR Platform, SAP BO 3.1, UNIX (Solaris, AIX)

Chandigarh Area, India

Maintenance and support of Legacy IVR applications of a leading telecom provider in the USA from offshore. Responsibilities: Gather user requirements, analyze and create System RequirementsDeveloped High level and Detail Designs.Work on the Data Modeling and data EDW Design, Development.Development and maintenance of IVR applications.Coordination with System Test Team.Production Support and Deployment Support for IVR applications in production environment.Maintaining the project at CMMI Level 5 by execution of the project as per the quality processes; Nortel Periphonics 3.X, Avaya IR servers, Unix (Solaris), SAP BO 3.1

Piscataway, Nj, Usa And Chandigarh, India

Developer and Technology Analyst for the leading telecom provider in USA from Offshore (Chandigarh, India) and Onsite (Piscataway, NJ, USA). Worked on the Migration of platform of the IVR applications of the client from Avaya Conversant to Avaya IR. Also support and maintenance of the IVR and related applications.Responsibilities: Gather client requirements on Migration project.Create design for IVR and database part of work.Write Database scripts per Requirements document.Prepare Unit Test Plans for database change.Database code drop to QA.Documentation of the changes/updates.Production Support and Deployment Support for IVR applications in new Avaya IR production environment.Maintaining the project at CMMI Level 5 by execution of the project as per the quality processes; Nortel Periphonics 3.X, Avaya IR servers, Unix (Solaris), SAP BO 3.1