Project Manager Data

SUMMARY

• Business analyst with extensive experience of the complete project lifecycle

• Masters Degree in Computer Science Engineering (Major: Database Systems)

CORE COMPETENCIES

• Working across several teams (IT, Business and Service providers), including senior stakeholders

• Project lifecycle, including gates for approvals, presentations for steering committee, Status reporting, RAIDs

• Business Requirement identification and definition

• Execute multiple roles within team - UAT Manager, Business Analyst, Project Manager

• Data Analytics, UAT and testing with live data using SQL and SAS across multiple sources

• Process improvement

• Thorough understanding of Credit Bureau specifications

• Documenting best practices

• Proficient in the use of MS Office product suite and Quality Centre for defect management

PROFESSIONAL EXPERIENCE

BARCLAYS, UK Oct 2006 – July 2011

Business Analyst, Credit Bureau Team

• Led UAT for new feed built for reporting business accounts to 3 Credit Bureaus. Developed strategy for internal UAT, testing with bureaus and live proving. Defined test cases, data requirements, led defects management, live proving and test closure. This involved close collaboration with senior stakeholders, IT and credit bureaus. Project satisfied reciprocity requirement with the Bureaus.

• Lead Business Analyst for resolving compliance issues with reported data and for establishing new processes to ensure data quality and future accurate reporting. Led requirement capture, review and sign off of key documents like functional spec and design, defined UAT cases, requirement traceability, and conducted end to end testing. Key issues included reporting of complex events like bankruptcy, joint accounts, debt sale, etc. Involved interaction across number of teams- collections, recoveries, product development, legal, IT and use of data across several databases.

• Led UAT for migration of loans reporting data from legacy database to ALS

• Established process for sending and incorporating bureau data into decision engines, ensuring timely and accurate data was sent and received. Recommended and developed thresholds to ensure data quality of feeds and DCM data.

• Assessed internal impact of Bureau field and platform changes on all scorecards, strategies, decision engines, and processes.

• Developed reference documents detailing the As-Is code/fields and the to-be recommended by the bureaus to enable gap analysis. This was key for redevelopment of all the feeds in SAS.

Project Manager

• Managed the monthly change process for Basel reporting. This involved collaboration and testing with several groups like finance, decision science, credit risk, collections and recoveries to ensure impact of changes were accounted for.

• Led front-end screen changes to incorporate KYC requirements in the account opening process. This required screen design for 3 different business groups with separate processes.

Snr. Capability Analyst

• Responsible for implementing monthly TRIAD changes to strategies and scorecards. Involved interaction with the Business teams to gather requirements and to ensure there is no conflict of interest, with IT to resolve issues, change documentation, testing and sign off.

• Investigative piece of work to resolve incident with an application to ensure correct scoring and lending decisions.

• Analysis and resolution to satisfy requirement from Audit Report.

ACCENTURE, UK March 2005 – Oct 2006

Consultant (promoted to Consultant in around 1 year, which is the best achievement amongst peer group)

• Developed training on Data Classification for team conference

• Completed the IT Infrastructure Library (ITIL) Foundation Certification.

• Member of Accenture IT Processes & Service Management practice – a firm wide best practices initiative.

Vertex, Liverpool

• Led analysis of large amount of server data to develop age and data-type profiles. Project managed a team that used data mining tools to create the necessary profiles. This assisted in clearing up unused data and setting retention policies for the future.

• Led assessment of skill levels and processes within the IT department to determine feasibility of supporting the new infrastructure. Recommended training and process changes based on gaps identified.

Sr. Analyst

Citigroup, Inc., London

• Analyzed regulatory and internal compliance policies to assess gaps between current and required situation. Recommended changes to meet requirements and set policies for the future.

Royal Bank of Scotland, Scotland

• Member of programme management office. Responsible for managing the project plan and producing status & variance analysis reports for Sr. Mgt. review.

Vodafone, Newbury

• Led Database Optimisation stream, a subset of the Data Layer Stabilisation project. Defined requirements and scope, developed solution. Recommended data management strategy for key applications to improve performance and resolve existing issues.

• Interviewed client team to enable gap analysis and built strong relationships with key Vodafone stakeholders, Business and CIO to ensure joint ownership of decisions and deliverables.

• Documented issues, findings, recommendations, feasibility of proposed solution and dependencies on other concurrent projects

• Project managed a team of two to implement recommended data management policies. As a result, 50% space saving and performance improvement by 50% was achieved.

• Played a key role in developing a proposal for follow-on work. This included defining resource profiles, estimating budgets and identifying potential bottlenecks that could jeopardize delivery.

• Developed generic process which was used in client pitches.

ABN Amro, London

• Developed a VB macro in Excel, based on the algorithm provided, to eliminate the need for manual tiering of over 1000 servers. This significantly improved the operational efficiency.

• Designed an Access database to store the infrastructure information and record updates to the same. Furthermore developed an SQL querying tool to analyse and identify the changes required to the infrastructure.

• Assisted the lead technical consultant in researching and providing information on relevant archiving and data migration technologies. Prepared final deliverables for the handover presentation to the client.

• Documented database design and architecture as part of project handover to the client. Developed process flows for managing ongoing updates and maintenance.

MAHINDRA BRITISH TELECOM, Pune, INDIA (MBT) July 2000 – Oct 2002

(JV between British Telecom, U.K. and Mahindra & Mahindra, INDIA)

Software Engineer

• Based on requirements, designed an ER Model and Relational Schema, created tables in ORACLE, populated them with given data, updated the tables and executed queries. This was done using SQL and JDBC facility.

• Modelled a call center for Rockwell. Coded models to suit requirements using C++. Discussed the progress and problems with the onsite team during regular meetings. Studied the effects of increased load and provided solutions to minimize the response times.

EDUCATION

University of Texas at Arlington, Texas, U.S.A. Jan 2003 - Dec 2004

• M.S., Computer Science Engineering (Major: Database Systems), Grade Point Average: 4.0/4.0

Cummins College of Engineering, Pune University, INDIA July 1996 - June 2000

• B.S., Electronics and Telecommunications, First Class

Contact this candidate