SUMMARY:

• Project Manager with Over 7 years of IT experience in Banking Industry.
• Excellent Skills in Performance Management to support strategic planning, goal setting, accountability, enhance decision - making, and improve customer.
• Strong communicator with great presentation skills, experience working with business users as well as senior management.
• Ability to handle Risk Management and take actions accordingly.
• Experienced with working on Accounting/General Ledger and Billing projects.
• Ability to deliver product as per the required scope, schedule and cost.
• Strong experience in working with agile lifecycle, and/or tracking and process management tools like Rally and JIRA.
• As a functional project manager, oversaw strategic IT development projects through entire lifecycle including initiation, planning, execution and closure. A self-directed leader with rich expertise defining, developing and implementing change through strategic initiatives and process improvement.
• Highly trained and tremendous expertise in agile product life cycle (SCRUM) methodologies. Proven track record to transform non-Agile teams to agile teams.
• Effective Project Scope Change Management and Configuration Change Management.
• Experienced with ETL tools to Data Cleansing, Data Mapping, Data Validation and conversion rules & applications.
• Determined Task Dependencies, Identified Milestones & Monitored Critical Paths using Gantt Charts, Resource Plans (Schedule & Allocations), Network Diagrams and Entity Relationship Diagrams (ERD).
• Master Documentation Skills to generate Project Charter, Scope Document, Milestones, RFP, Budgeting, Resource Allocation, Stakeholder Meetings, Change Management Form, BRD, FSD, Non-functional Requirements Document, Use Case Document and Manuals.
• Project management experience includes client management, customer interaction, scope definition, project planning, and change control, integration and release management.
• Extensive Experience in conducting GAP analysis, User Acceptance Testing (UAT), Cost benefit analysis and ROI analysis.
• Experienced in data profiling, data transformation, data mapping from source to target database schemas and also data cleansing.
• Able to respond with diverse array of technological solutions to business problems, as a result of extensive business and technological know-how combined with ability to bridge technology and business goals.
• Worked in close proximity with QA, development team and Project Managers to track project status and ensure that requirements are being met.
• Skilled creating Unified Modeling Language (UML) diagrams (use case, activity, sequence) using MS Visio, Rational Rose.

TECHNICAL SKILLS:

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse Database Design and Modeling, Data Integration and Migration ETL Architecture and Design, Data Warehouse, OLTP, OLAP Report Design and Development

Data Analysis: User Requirement Gathering, JAD Sessions, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis

Database Tools: SQL Plus, SQL Loader, SQL Navigator, Teradata Manager, Developer 2000, Toad

Data Modeling Tools: Erwin, Toad, MS-Visio, ER Studio

Data Warehousing: Oracle Warehouse Builder, Informatica Designer

Programming Languages: Oracle PL/SQL, MS-SQL, VB 6.0

BI Tools: Business Objects, COGNOS, SSIS, SSMS, Tableau

RDBMS: Oracle 9i, Oracle 10g, Teradata 12, Oracle Applications, MySQL, SQL Server 2005

Scripting Languages: VBScript, UNIX Shell Script

ETL Tools: Teradata, ETL, Data Stage/Quality Stage, SAS Data Flux Informatics Data Quality

PROFESSIONAL EXPERIENCE:

Confidential, Milpitas, CA

Project Manager

Responsibilities:

• Managed medium to large size/scope/complexity enhancement, development or production projects within a single application or multiple applications.
• Managed project which modified the loan scoring process to be highly configurable and efficient. The delivered application and web based front end provided the analytics team with the flexibility to add and remove customer attributes as well as change values associated with existing attributes in the current scoring model without the need for IT intervention.
• Managed project to enhance the loan application experience for returning online customers which increased completion of loan applications by 18% resulting in a revenue increase of 7%
• Managed project that integrated a third party banking information verification application into the online loan application process which resulted in reducing call center CSR time spent verifying customer's bank information by 50%.
• Provided AGILE project management controls, project plans, timeline schedules, facilitate RAD sessions, and reviewed software defects.
• Performed User Acceptance Testing (UAT) of medium to large projects.
• Performed quality assurance on converted sites, checking for conformance to new style sheet; updating hyperlinks; completing metadata; and checking URLs of images, documents, and video clips. Added value by copy editing text as needed.
• Managed requirements of the Stakeholders in every phase of the Project life cycle.
• Managed the Maintenance and Regulatory Compliance of Deposit and Loan Application Software
• Independently created project plans; analyzed and documented existing data on project objectives, deliverables, schedules, assumptions, constraints and dependencies.
• Involved in analyzing of functional specifications, technical specifications, data mapping document and conceptual diagrams.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas of Mortgage.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, data migration and support.
• Performed problem analysis and solving using SQL language (Microsoft SQL/Teradata) and handled performance tuning activities on Teradata.
• Designed and wrote test plans and manual test cases for a wide variety of tests including functional, performance, regression, and data quality.
• Implemented complex SQL queries for QA testing and report / data validation.

Environment: MS-Visio, MS-Excel, MS-Access, SQL, T-SQL, MS Project, Teradata 14.1, HP QC/ALM, File Transfer Protocol (FTP), Documentum, MS Share Point, Erwin, Waterfall SDLC, Microsoft SQL 2005, MS PowerPoint.

Confidential - Irvine, CA

Project Manager

Responsibilities:

• Responsible for conducting bug management meetings and keeping project plans using MS Project.
• Managed business implementation project road map for large projects implementation.
• Provided PMO governance for all teams related to compliance, vendors and technology, channel and Ecommerce product Marketing.
• Managed application which acts as a front-end to various back-end applications and provides primary information like type of account, account balance, Transaction and statement information, Bill payment, transfers between linked accounts, Viewing check images, credit card payments, check reorder, alerts, small business related services etc.
• Coordinated work plans between the project manager and clients, using Microsoft Project; managed migration process and developer fixes; retested fixes; scheduled and tracked progress of the project for team members.
• Created activity diagrams, use case diagrams and sequence diagrams using MS Visio to view the system from different perspectives.
• Worked with the client to improve project management practices such as the development of an integrated, cross-team project plan, and the introduction of agile approaches within the client's standard software delivery model.
• Worked with Mortgage Business Applications including Loan Origination System, Loan Processing System, Loan Origination Web Interface, Loan delivery System, and various other internal systems interface.
• Authored Requirements document, Use Case Specifications, Systems Requirement Specification (SRS), Requirement Change Request, Data Dictionary along with the technical staff and developers.
• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the Business and IT processes.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the implementation of Rational Unified Process effort in different iterations and phases of the SDLC.
• Defined the test criteria and project schedules, and base lined the Test Plan with the help of project meetings, walkthroughs and Inspections.
• Participated in the design, code and test plan walkthrough with the development and design team members.

Environment: Business objects XI R1/R2, Rational Requisite Pro, Rational Rose, Rational ClearCase, HP QC/ALM, Rational ClearQuest, Agile, Rally, Microsoft Office suite, Visio, J2EE, XML, Java Server Page

Confidential - Portland, ME

Project Manager

Responsibilities:

• Involved in major projects for the improvements of all the major components of SmartWorks including single sign-on features enhancement, brokerage alert system, on-line account opening, OSJ approvals, on-line commission center, brokerage tools, and compliance reporting.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance.
• Project Management Improvement - Plan, participate, and help facilitate the monthly cross-functional, director-level Project Management Improvement Team (PMIT) sessions.
• Participated in testing software by conducting User Acceptance Testing (UAT).
• Generated reports through Business Objects and further analyzed data through Excel Used Pivot tables, Vlookups and Offset functions in order to quickly and effectively generate actionable and insightful analysis.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Worked on Accounting/General Ledger and Billing projects.
• Responsible for creating the Roles and Responsibilities as part of the New Account Opening project and mapping them to the appropriate business unit
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Gathered data from the legacy system (db2) to the present updated system using data warehouse tools such as Informatica
• Involved in strategic projects
• Performed extensive Requirement Analysis including data analysis and gap analysis
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Worked on data modeling and produced data mapping and data definition documentation
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked with ODS and OLAP system.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions

Environment: Windows, MS Project, SQL, MS Office (MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio

Confidential, New York, NY

Project Analyst

Responsibilities:

• Established the project’s overall critical path and confirming that all project phases adhere to the agreed-upon timeline.
• Assisted project team in troubleshooting and finding solutions to unforeseen issues.
• Utilized Agile and Scrum SDLC methodologies to facilitate project fulfillment and delivery.
• Developed and monitoring project budget.
• Worked on Oracle financial modules (AR, AP, GL, FA).
• Communicated with stakeholders, team members and other project managers on project status, including progress, risk and any issues that may have an impact on project delivery.
• Wrote data mapping, data definition languages to define structure in the legacy database.
• Managed customer expectations and proactively closing expectation gaps.
• Took ownership of managing and obtaining approvals for all change requests, particularly regarding scope and budget.
• Ensured that project team is adhering to all standards and processes as defined by clients.
• Planned major project phases and establishing project success factors with input from team leads and senior team members.
• Managed and evaluating team members as well as overseeing additional consultants and subject matter experts (SMEs) as appropriate
• Conducted JAD sessions with the SMEs, users and support team to gather the requirements.
• Conducted focus groups with the customers to obtain inputs on their requirements.
• Executed Fit-Gap Analysis to determine processes that provide highest probability of success.

Environment: Rational Enterprise Suite (Rose, Clear Case, Clear Quest), J2EE, MS Visio, MS Project, Clear Quest, MS Project, WBS Chart Pro, MS Office