Sr. Consultant Resume
Profile and Skills
- More than 13 years of IT experience in requirement analysis, design, development, testing, implementation, support & maintenance of client/server, Internet/Intranet and distributed applications in finance, manufacturing and telecom domains. Extensive experience in Project Management, Release Management, Client Relationship and Delivery Management in Onsite/Offshore model.
- Writing complex SQL queries and performing Database Administrator activities.
- Oracle 8i/9i/10G, PL/SQL, ETL, Informatica PowerCenter6.2.2, C, SQL, ASP 2.0, Visual Basic 6.0, Java, XML, XSLT, JSP 2.0 HTML, Unix (Sun OS, AIX), Unix Scripting, MS Visio, MS Project, Microsoft Share Point, Microsoft FrontPage, Microsoft Office, Planview, Mercury Quality Centre,VMWare,VSS, Test Director, Infoman 2.0, Informatics 6.2, Siebel 2000, Crystal Reports 7.0, Oracle Web Server, Infoman, Bridge Application, Toad, SQL Navigator 5.0, CVS, Erwin 4.1.
- Motivated and customer focused with excellent analytical and communication skills, demonstrated team leadership skills, able to visualize holistic view of complex horizontal and vertical systems and align IT projects with overall corporate strategy.
KEY AREAS OF EXPERTISE
Program / Project Management
- Experience of all phases of SDLC in Offshore Onsite Model
- Scheduling Projects Project Planning
- Critical Path Analysis (CPT) & PERT Scheduling Complex Projects
- Know-how of Project Management Methodologies- Agile, Prince2, Waterfall.
- Estimating Time and Cost Accurately
- Scope Management
- Resolving client issues
Quality Management System
- Release Management
- Requirements Gathering- Ensure that business requirements are clear and agreed to by all stakeholders.
- Release Building- Involved in build, packaging of software.
- User Acceptance testing- Keep a track and status of the critical defects.
- Release Deployment- Coordinate work with the deployment team.
- Responsible for sign off the releases to be implemented to Production.
- Risk management- Identifying risks, creating risk mitigation plans and minimizing risk.
- Facilitate and lead meetings for project updates and information exchange between technology groups.
- Ensure various projects or business units are aligned with the release schedule.
- Understanding of ITIL methodology of release management.
- Configuration Management
Business Analysis
- Capturing business requirements
- Gathering functional requirements
- Identifying non-functional requirements
- Performing system analysis
- Business Process Re-engineering and Consulting
Documentation
- Proposals and Cost/Effort Estimation
- Functional and Design Specifications Documentation
- Use case, test case, traceability matrix, configuration management plan and QA documentation
- Project Performance Analysis and presentation to senior management
Professional Experience
Confidential,New York CityMay 2010 Till Now
Sr. Consultant
MSSB Conversion: Currently, involved in the conversion of applications from PWM to GWM platforms. Involved in the UAT testing, mock activities for the Client Reporting applications.
- Leading a team of 8 team members located across India, London and New York for the delivery of the projects.
- Interact with different teams like Business, Development and QA teams located at different geographical regions to ensure smooth and timely delivery of the projects.
- Schedule the governance call for the change requests with multiple teams.
- Resolving issues with different teams like Business, Development.
- Tracks quality assurance metrics such as defects, defect counts, test results and test status and present the same to the senior management.
- Lead Implementation Planning meetings prior to deployment.
- Facilitate implementation workbook review meetings with functional teams to build run book and back out plans.
- Engage and schedule functional resources in support of deployment and implementation verification.
- Acquire final approvals from all the stakeholders for application deployments.
- Coordinates Mock Deployments and Mock Rollbacks.
- Responsible for QA, UAT, DR environments.
- Coordinates with Environment Manager to ensure that all applicable environment issues are resolved in advance of production implementation.
- Execute deployment according to implementation plan
- Coordinate overall deployment
- Track deployment activities as they occur using implementation plan
- Facilitate resolution of issues during deployment and escalate issues where necessary
- Add post deployment activities where needed and follow-up on their completion
- Post Deployment meeting to review issues and activities
- Communicate status to Senior Management via checkpoint Conference Bridge.
The Confidential, platform enables PWM customers to opt for Banking Products over and above the existing wealth management products. PWM would be offering banking products like Call Account, Term Deposits, Term Loans, Bank Guarantees, Funds Transfer and Dual Currency Investment capabilities to the customers. The banking capability, T24, will be the central application for the sales force to place Deposit and Loan trade orders for PWM clients. To ensure proper integration of T24 with existing PWM systems, all the data entered on T24 needs to flow to various books and records systems such as Libra, Confirms, Capri and GIM2.
- Working in a team of 15 members spread across different geographical regions for critical delivery of the projects.
- Create, manage and update functional, design and business requirements.
- Handling Close of Business jobs for T24 banking application.
- Deploying of T24 packages in the testing environments.
- Ensure and validate the data feed generated by the T24 application runs to the downstream systems.
- Involved in reconciliation process for different systems and verifying positions and balances.
- Resolving technical issues with development teams.
- Monitoring and presenting project metrics/reports to senior management of Morgan Stanley Smith Barney highlighting the issues, risks involved, back out strategy and overall project status.
- Closely working with the vendor and engineering teams for installation of the code in IST and UAT environments.
- Act as one point of contact for both technology and business groups.
- Involved in implementing the regulatory and compliance related changes.
- Involved in test planning, writing test cases/scripts, test case automation and test execution
- Track quality assurance metrics such as defects, defect counts, test results and test status and present the same to the senior management.
Environment: T24 Banking application, MS Visio, PPM, XML, HTML, Unix Shell Scripting, Desktop Web Server, Apache/Tomcat, Web Logic, Microsoft Windows XP, Mercury Quality Centre, JBase, DB2 / Informix, DB Artisan, Autosys.
Confidential,
New York City, USA Jul 2006 May 2010
Client: Confidential,Program / Release Manager
- Confidential, uses a customized financial center banking application (Concierge) which consolidates all the activities that are performed at a Financial Center (Citibank Branch). Concierge is a window to all the legacy & distributed applications like NBS, OSRO, CWS and EXSELL which caters to different activities at the Financial Centers. Every time the system comes up with a new change as a result of mergers, acquisitions or divestures it is build in a package, shipped and released to some preferred Financial Centers in the first roll out and based on the input of these Financial Centers, enhancements are done before it is released to the rest of the Financial Centers in entire North America.
- Managing a team of 30+ team members including project managers in the onsite / offshore model for critical delivery of the projects.
- Manages the releases of financial center retail banking applications for all the branches in the entire North America.
- Resolving technical issues with development, installation, distribution and business before giving signing off for the deployment for entire Citibank NA.
- Monitor and present project metrics/ reports to senior management of Citibank highlighting the issues, risks involved, back out strategy and overall project status.
- Plan and prioritize go-live activities, status communications, go-live issue tracking and resolution
- Closely working with the development / distribution / Installation teams in maintaining the change management and configuration of IST and UAT environments.
- Coordinates with Configuration Manager to ensure that all applicable environment issues are resolved in advance of production implementation
- Act as one point of contact for both technology and business groups.
- Ensure only approved changes appear on release schedule (i.e. traceability of release notes to approved scope items).
- Involved in decision process to move scope across release boundaries.
- Involved in the Root Cause Analysis process for release-specific issues.
- Ensure changes to production have been tested, documented, communicated, approved, and successfully implemented.
- Risk management planning, change control management and impact analysis.
- Involved in test planning, writing test cases/scripts, test case automation and test execution
- Tracks quality assurance metrics such as defects, defect counts, test results and test status and present the same to the senior management.
- Create, manage and update functional, design and business requirements.
Environment: Oracle9i /10G, Peoplesoft 8.2.0, MS Visio, Planview, VBScript, JavaScript, HTML, Unix Shell Scripting, DHTML, IIS Server, Web Logic, Microsoft Windows XP, QTP, Mercury Quality Centre, VMware, VSS.
Confidential,Germany Jun 2003 -Jun 2006
Client: Confidential,Project Manager / Project Lead
- This project involves maintenance, development & production support of Stock Options applications of Agilent Technologies, Inc. This is a web based HR application, which is used by Agilent Technologies, Inc. to provide the stocks to its employees. This application also has interfaces with the payroll vendors (Fidelity) and financial service provider Smith Barney.
- Project Lead for the migration of database, application and environment from Oracle 8i to Oracle 9i and take advantage of new features of Oracle 9i. The migration also included reducing the organic data growth of the database and encapsulating the web application on 9iAS, programmed in PL/SQL.
- Involved in developing SQL Scripts, Functions and Procedures using Oracle 9i for validating the rules, data transformation.
- Lead a team of 6 software programmers for developing SQL scripts for Data Extraction, Validation and Load process. Job scheduling, monitoring and recovery.
- Implementation of SOX for Stock Options application.
Environment: Oracle 8i/9i, ETL, Informatica PowerCenter6.2.2, XML, Java, MS Visio, VBScript, JavaScript, HTML, Apache Web Server, HP Unix11.1, Test director, Sysadmiral, CVS, Batchnet, Erwin 4.1,SQL Navigator 4.5,CVS,Test director.
Education
- Bachelor of Engineering
Awards
- Awarded STAR PERFORMER by Mahindra Satyam for innovative thinking, cost effectiveness, teamwork and collaboration for outstanding contribution.