Srinivas Gadepalli M.Tech (Computer Science), PMP, ITILv3, Scrum Certified

**** ******* *****, ***********, ** L5M6Y7

Mobile: 647-***-****

Residence: 905-***-****

Email ID: actg5z@r.postjobfree.com

(I)PROFESSIONAL PROFILE

Project Management Consultant – Information Technology professional with 10-plus years’ experience in Project Management; managed Technology (Java/J2EE, SAP BI/BW, Informatica, DWE & Reporting) Projects in the Financial Services/Banking and Retail Industries in North America; Project Manager for small, medium & large scale, cross-functional, multi-location, multi-vendor technology rollouts and upgrades from project planning to post implementation; a strong team builder with proven leadership skills and experience, excellent analytical, problem solving and communication skills; Strong experience in executing projects using Waterfall, incremental & Agile and CMMI methodologies; Pre Sales Support(Estimates, POCs, RFPs); Team Management(Performance Appraisals, Time Approvals, Resource Billing & Utilization); Strong experience in change management, Contracts, SOW and SLA negotiations, Service Catalogue setup; Hands-on and results oriented, with a proven track record in successfully managing projects of various types and sizes with full SDLC documentation including software development, systems implementation, systems integration, SOX Compliance and migrations; Web Technologies, Client Servers and mainframes; Cloud-based solutions and IT infrastructure (OS upgrades, networks, servers, storage); Strong experience in Windows-XP, Windows-7,UNIX(SunOS, HP-UX, AIX, AS/400), Solaris-10 operating systems; SharePoint, Documentum & ECM / IBM FileNet Content Management Systems; Strong experience in Data Migrations; Successfully managed multiple projects concurrently in the context of Banking and Compliance in Data warehousing (Data Mining, Data Archiving, Data Extraction, Transformation & Load(ETL) and Reporting) and Business Intelligence (BI); Create and manage Risks & Issue logs; Achieves business goals through skilled use of MS Project, Word, Excel, PowerPoint and Visio; Expertise in SAP Business Intelligence / Business Warehouse (BI/BW).

(II)HIGHLIGHTS OF QUALIFICATIONS

Membership of the Project Management Institute (PMI) with PMP designation since 2005.

Certified ITILv3 – Foundation

Certified Scrum Master

Certified Six-Sigma Green Belt

Certified CBSA in SAP BI/BW and Business Objects

Certified in Sun Java-2

Master of Technology in Computer Science

Strong Knowledge in Big Data / Hadoop

(III)PROFESSIONAL EXPERIENCE

1.Royal Bank of Canada(RBC);May 2012 – Till Date; Project Management Consultant FATCA Regulatory Compliance & DSU Infrastructure Programs

FATCA: The Foreign Account Tax Compliance Act (FATCA) Program is an Enterprise-wide initiative created in response to legislation passed by the US Congress and Senate to combat tax evasion through the use of foreign accounts or entities

Project Management support to implement the minimal system, policy and procedure changes in Personal & Non-Personal Deposits and Registered & Non-Registered Investment Products to meet FATCA requirements such as Identification of clients with US Indicia, Provide report to IRS for clients identified as U.S. Persons and implement withholding procedures on pass thru payments for recalcitrant clients. Involved in:

Implementation of changes to Sales Platform and CCP web services to support identification of potential US accounts

Implementation of changes to SRF,EDW, eForms and eCM application systems to support identification of potential US accounts

Implementation of changes for record keeping systems for registered/non-registered mutual fund accounts and non-registered GIC accounts to support identification of potential US accounts

Setup of infrastructure to file information reports for 2013 & 2014 calendar years

Implementation of PEGA solution that will interface with core systems and other applications to identify clients that are subject to withholding and reporting

Enhance Sales Platform and make required changes to all associated interfacing applications in order to support the electronic capture of common client and account data through Sales Platform web based roadmaps

Following activities are being accomplished:

Perform periodic Risk Assessment to identify potential risks/opportunities and document mitigation strategies.

Create and manage Risk & Issue logs and tracking risks/issues to conclusion

Support Organizational Audits by managing PMF Artifacts and Risk/Issue documentation on SharePoint

Create detailed Project Schedules by PMF phases from consolidated Work Breakdown Structures (WBS) for all of the projects in the FATCA program.

Create and managed the integrated Project Plan for all of the projects in FATCA Program by coordinating with IT and BU Project Teams

Provide on-going maintenance of the Project Schedules using Enterprise Project Management (EPM) /Microsoft Project (MPP) and Planview (EPPM).

Prepare weekly reports on the project schedule including Project Scorecards, Variance Analysis, Project Schedule Status report, etc.

Analysis of financial information by identifying & tracking variances, determine when program will exhaust its budgets and provide budget information to program management

Create and maintain financial status reports

Consolidate MIS reports and reconcile month on month financial reports and update the program management

Assist in the collection and analysis of Supplier/Vendor timesheets and invoices

Update program PAR with forecast to actual, spend-to-date, current burn rate etc.

Project Management Tools Used: Microsoft Project, Excel, PowerPoint, Enterprise Project Management (EPM)/MS Project Server 2003, Plainview Enterprise Project Portfolio Management (EPPM), Project Management Information System (MIS) for financial budgetary planning and MKS Integrity Suite

Methodologies Adopted: Waterfall, RUP & RBC Project Management Framework

DSU Infrastructure: Developed and Managed detailed integrated project plans, for IT infrastructure projects across multiple streams such as Core Banking & RCO, Channel Technology, Branch Platform and Payment & Trades Work streams of Retail applications DSU Program. Following activities are being accomplished:

Developed & Managed detailed integrated project plans

Identify & Evaluate Issues & Risks

Financial Reporting at Program Level

Track the Acceptance Compatibility Testing(ACT) of various applications on Windows-7 platform

Track the availability of packages, profiles and assets required for ACT Testing of various applications specific to Branch Platforms and Common Components

2.Royal Bank of Canada(RBC);Sept 2010 – April 2012; Project Management Consultant ‘DWE’

Managed small to medium sized projects concurrently for implementation of Data-warehousing (DWE) solutions to various applications such as Credit Origination Systems, Insurance, Leasing and AML Compliance areas. Implemented:

RBC Leasing Integration: Implementation of Data Load process to convert all active leases from existing NLG system to new ASSET system, Extract/Purge historical lease data from NLG and decommissioning of NLG load process. Data Migration from NLG to Asset systems

DMTI Phase-1: Implementation of DWE solution to enhance the quality of mortgage property addresses recorded in CASPER using DMTI interface for faster client and sales experience

Small Business Credit Made Easy: Implementation of DWE solution to simplify end-to-end credit process for Small Business in CASPER by adding new fields such as Auto-Qualification Indicator, Interest Price Adjustment etc.

CLSB Insurance: Implementation of changes required to receive new product type to existing Tables that holds Balance Protector Information, for optional life and disability insurance on CLSB cards

AML Enhancements 2010-2011: Implementation of Data Load Process for loading ICRE file data into EDW in order to enable AML Intelligence Team to perform their transaction monitoring process effectively with additional data related to negotiable items redeemed at RBC but purchased at OFIs in US and Canada excluding RBC

Following activities were accomplished:

Project Planning & Execution

Created and managed PMF artifacts, Microsoft Project Schedules, Issues & Risk logs by coordinating with various stakeholders

Analyzed business requirements and resolved scope issues with BU and IT stakeholders

Created and managed Resource Plans

Project Management Tools Used: Microsoft Project, Excel, PowerPoint, Enterprise Project Management (EPM) MS Project Server 2003, Project Web Access (PWA) and Project Management Information System (MIS) and MKS Integrity Suite

Technologies Used: Data Stage-ETL, Teradata and Peregrine Service Centre

3.Wipro Technologies Limited; April 2004 – July 2010; Project Manager ‘Retail/e-commerce/ SFDC’

Managed multiple projects across SDLC in multi-vendor environment for various clients in North America using Waterfall, Incremental, Agile (Scrum) and RUP software development methodologies

John Wiley & Sons, USA & Canada; Project Manager (Jan 2010-July2010)

John Wiley & Sons publishes educational materials in all media through their integrated online suite of teaching and learning resources. In the current SFDC CRM implementation for Sales Team, the data and processes are broken in silos. A new Salesforce.com (SFDC) solution is being implemented to provide seamless accessibility to JW sales teams. Following activities were accomplished:

Identified and resolved issues across Salesforce.com of the project

Achieved project objectives by Empowering and motivating the teams

Involved in Architecture and Solution Design to develop the SFDC

Involved in Data Migration from AS400 systems to SFDC CRM

Created and maintained development schedules and budgets

Led Weekly Meetings with clients and communicated the Project Status

Tools & Technologies Used: Salesforce.com CRM, Cloud Computing, APEX, Visual force, SOQL and Microsoft Project Plan (MPP), Informatica, AS400 and Oracle DB

Methodology Used: Flex Delivery Model

Wipro Technologies; Scrum Master (Jan 2009 – Dec 2009)

Wipro Carbon Management solution is a web-based GHG accounting and reporting tool that aids enterprises with goals on environment Sustainability, to measure, manage, monitor and report their carbon emissions. This solution was built as Software as a Service (SaaS) application and deployed on Salesforce.com cloud platform. Following activities were accomplished:

Owned projects involving the development of a cloud based SaaS application known as Carbon Management Solution.

Captured Energy Analytics requirements for Energy Management Solution

Contributed of proposals for responding to RFPs

Acted as Scrum Master

Led Scrum Retrospective Meetings and encourage Team to optimize processes

Tools & Technologies Used: Salesforce.com CRM, Cloud Computing, APEX, Visual force, SOQL and

Microsoft Project Plan (MPP)/ MS Project Server 2003

Methodology Used: Scrum Development Model

Target Corporation, Minneapolis. MN, USA; Project Manager (March8 – Dec 2008)

Target Promotions Application Phase-2 seeks to enhance the existing Promotions Planning Application by adding clear pricing process automation, competitive pricing process automation and implementing changes to Improve UI for buyer driven promotion process and widget guidelines; Following activities were accomplished:

Prepared Project deliverable such as Requirements Gathering Plan, Project Management Plan, Communication Plan, Control Plan, Risk Management Plan and got client sign-off

Prepared funding requests and got approvals from customer

Prepared Statement of Works (SOW) and got sign-off from Customer

Led the RS, FS, solution Architecture and Design

Created WBS Estimates and development schedules

Maintained the development schedules using MPP Project Plan

Managed the change requests with respect to schedules & cost impacts

Managed the Project using Clarity Project Management Tool

Led Weekly Meetings with clients and communicated the Project Status

Tools & Technologies Used: Web Sphere Application Server (WAS) 6.0, ATG 7.1, Java/J2EE, XML, XSL/XSLT, Microsoft Project Plan (MPP) and Clarity Project Management Tool

Supervalu Inc., Boise, ID, USA; Project Manager; April 2004 – Feb 2008

B2C, B2B and B2A Portal projects are the largest IT projects within legacy Supervalu Inc. B2C Portal project is about re-engineering the B2C ecommerce site in J2EE platform and B2A Portal project is to re-engineer existing Associate portal using Struts Framework; Following activities were accomplished:

Achieved Customer Appreciation award for the year 2006 for my contributions to B2A, B2B & B2C Portal projects

Managed all aspects of end-to-end release process

Involved in Data Migration from legacy SQL Server based systems to Oracle DB

Ensured the coordination of build, test and release teams

Ensured release package design, build and configuration and got sign-off for implementation

Prepared Project Plan, Quality Plan, Project Metrics and got sign-off from senior management

Improved quality of deliverables through rigorous Quality Management and Continuous Improvement

Execute the projects based on SOX Compliance processes and procedure

Achieved project objectives by Empowering and motivating the teams

Contributed to proposals for responding to RFPs

Defined Statement of Work (SOW) for projects with clients, Target Corporation and Albertson’s - Supervalu Inc.

Built and Managed successful client relationships with clients, Target Corporation and Albertson’s - Supervalu Inc, by ensuring all business needs were met

Mentored Architecture and Solution Design Teams

Identified and resolved issues across SDLC for all of the projects

Oversaw Testing of all applications related to B2A & B2C Portals with client Albertson’s – Supervalu Inc. while defining test strategies to ensure SOX Compliance and assisted development & support teams with SOX Compliance

Instrumental in improving quality of deliverables through Continuous Process Improvement

Tools & Technologies Used: Documentum, Oracle 8i/9i/10G, MS SQL Server, BEA Web Logic 8.1, Java/J2EE, XML, XSL/XSLT and Siebel CRM

Project Management Tools Used: Microsoft Project Plan (MPP)/ MS Project Server 2003, Clarity Project Management Tool, Caliber RM Tool and eCube PM Tool

Methodologies Adopted: Waterfall, RUP, Agile (Scrum) and Flex Delivery Model

EDUCATION

1.Master Of Technology (M.Tech) in Computer Science

2.Master Of Science (M.Sc) in Physics/Electronics

TECHNICAL SKILLS

1.Data-warehousing & BI Systems: Teradata, Data Stage, OBI & SAP BI/BW

2.Operating Systems: UNIX (SunOS/AIX/HP-UX), Solaris 10, Windows XP

3.Applications: Documentum, Quick Test Professional(QTP), HP QC and Open view

4.Networking: Storage Area Networks (SAN), TCP/IP, Remote Procedure Call (RPC) & XDR

5.Languages: C/C++, MFC, Java/J2EE, XML, XSL/XSLT, Visual Studio. Net / C# / VB / ASP

6.Databases: Oracle 8i/9i/10G & Ingres, MS SQL Server, MS Access and MySQL

7.Application Servers: BEA Web Logic 8.1, Web Sphere Application Server (WAS) 6.0, ATG 7.1

8.Tools: Clear Case, Clear DDTS, Bugzilla, CVS, Purify, UML, JBuilder, Visual Studio and Eclipse

9.CRM/ SAAS: Salesforce.com CRM, Siebel CRM, Cloud Computing, APEX, Visual force and SOQL

Technical Training

SAP BI / BW, Jan 2014 – Dec 2015, SAPSOL Technologies Inc.

Involved in Implementation of SAP R/3 System for MAGNA with the integrated function modules such as Material Management (MM) Sales & Distribution(SD), Human Resources (HR) and Financial & Controlling (FICO).

Responsible for creation of Financial Reports on BI ECC 6.0 (both Tabular & Graphical Reports) using BW Data Model and Business Objects by extracting data from SAP Components and External Systems:

Blueprinting, Workshops & Documentation

Coordinated Projects using ASAP methodology with solution manager including ongoing support, optimization and e-training

Resolved Issues on issue log and centralized repository of project documents (Shared Drive).

Established project documents and version controls and cut over plan for GO LIVE and Support.

Performed AS-IS analysis and developed TO-BE analysis. Focus centered on SAP Best Practices Industry Specifics. Documented Process improvement charts, BPML and RICEF

Analyzed and identified required Characteristics, Key Figures, Units & Time Dimensions for Account Payable and Account Receivable Modules

Designed Extended Star Schema for Account Payable & Account Receivable Modules

Created detailed Data Flow Diagram (DFD) for Account Payable & Account Receivable Modules

Configuration and key areas with Modules/Tables Highlighted

Performed Data Modelling using SAP BI/BW Work Bench (created Info Objects, Info Catalogs, DSOs, Info Cubes, Source System Flat Files)

Created Application Components for MASTER & TRANSACTION Data Sources

Created Data Transfer Processes (DTPs) to extract data from Source Systems Tables and flat files to Data Sources, to DSOs and to Info Cubes.

Executed Data Transfer Processes to transfer data from Source Systems and Flat Files to Data Sources, from Data Sources to DSOs / Info Cubes

Successfully created Account Payable & Account Receivable Reports by writing BeX Queries using BeX Tool Set such as Query Designer, Query Analyzer, Web Reporting Designer and Business Objects Web Intelligence (WeBI)

Created Planning Models by creating Real-Time Info Cubes and created Input Ready Queries. Also created web templates to customize data view

Created Process Chains and automated the batch jobs to run at scheduled time slots

Testing, Data Conversion, Security and Cutover Planning

Incorporated authorization checks on programs and coordinated with security team to ensure information protection.

Evaluated functional specifications for FI, CO, SD, MM and HR; estimated time for development and testing and ensured design viability

Managed resource and work plans; provided work effort estimates and ensured delivery within timeline and budget

Support and Issue Management /Stabilization

Established remote support as per support model and trouble ticketing. Created and Tracked Tickets till resolution using Zen Desk

Escalated of critical issues to BASIS Team for resolution

Created Transport Requests using Transport Organizer and transferred to Business Objects to Production

Supported rollout after field trial and documented lessons learnt including upgrade roadmap

Contact this candidate