SUMMARY:

Confidential has over 13 years of professional consulting experience in capital markets and securities industry primarily in Investment banking, Fund/Asset Management (Accounts, Securities, Positions, Transactions, and Performance), Fixed Income, Bonds, Equities, Derivatives (Swaps, Options and Futures), Loans - Commercial & Industrial, Fund Accounting, Mutual Funds, Portfolio Management and Retirement based applications. He has strong analytical skills while defining requirements, stakeholder interaction & interviews, communication with the project sponsor, business as well as end users, and report creation for executive management. He has an expertise has been in managing and working on high visibility projects within banking and finance that involve PMO, Data Governance, Data Warehousing, Data Quality, and Business Intelligence implementations. He is knowledgeable in Agile and Scrum based methodologies, SDLC, Waterfall, RUP, Six Sigma, PMI (Pursuing) and has managed UAT across multiple projects.

TECHNICAL SKILLS:

Languages: Java, Adobe Flex, ASP, .NET, C#, SQL, Visual Basic

Tools: BOXI, HP Quality Center, Load runner 7.5, Rational Clear Quest, SharePoint, Snag It, Toad, Embarcadero

SQL, MS Office: Project, Visio, Word, Excel, PowerPoint

Methodologies: Agile, Scrum, RUP, Waterfall, SDLC, PMI

Database: Oracle 11i, DB2, Mainframe, Sybase, MS Access, SQL Server 2000

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Analyst / PM

Responsibilities:

• Lead meetings with business users, document functional requirements, and create a roadmap/timeline on bringing the business users live in the allotted phase agreed with the Sales & Trading business.
• Coordinate on data remediation & cleansing of Client data, Contacts, Users, pinpoint and remove duplicate records before they are loaded into CRM.
• Work with Confidential Finance IT on downstream integration with GRD, GEAR, CSI, Salesbook etc.
• Daily interaction with vendors on external integrations with Ipic, Iconference, EBB.
• Lead the effort for Call Report migration from old system into CRM to make sure data is clean and accurate to drive early adoption with the users.
• Wrote requirements on defining team access and sharing rules based on region, LOB’s etc. to ensure proper visibility and access for the right user, per Confidential compliance guidelines.
• Wrote requirements on replacing existing reports with new enhanced reports within CRM
• Aligning to Confidential standards across client, Securities and employee data (CDR, SRDR, GDS)
• Coordinate and work with Tier1 (vendor) to implement requirements that are set by CMTA team in agreement and signed off by the business.
• Lead SIT efforts before go live, log, track and manage ongoing issues in Quality Center.
• Prepare UAT scripts for the business users for testing and identify & log issues. Create training sessions for users.
• Prepare weekly stakeholder status report & Steer co deck outlining any risks/issues

Confidential

Senior Business Analyst / Project Manager

Responsibilities:

• Create Business Requirement documentation & coordinate UAT with business users
• Map data from source system(s) to target reports (Schedule 14Q/14M/14Y/Y9C)
• Analyze requirements for financial data, Counterparty credit risk, market data in regard to firm-wide CCAR process, work close with other work streams (RWA/PPNR/Trading)
• As a part of Market Risk team, update the BRD’s based on FRTB and Basel within the IHC scope of work
• Participate in Project Plan sessions, provide feedback on planning, scheduling & estimates
• Document all processes and reports for federal auditing regulations and requirements
• Develop and manage project schedule; Status tracking and reporting
• Create protocols and templates for project planning/tracking, status, issues/risks/actions reporting
• Act as a lead source for managing CCAR Model dev process for AFS/HTM work stream
• Supported ETL dev., resolved issues with data modeling and source to target mappings
• Extensive use of Axiom Controller to retrieve data for reporting & data reconciliation
• Work closely with model developers, Quants team & model Validation team to close MRA’s (Matters requiring attention) set by Fed, assign model priorities, control frameworks, completion of documents, fix data quality issues, compare results & contribute towards firm wide CCAR methodology document for the work stream
• Review Macro economic scenario’s for Stress Testing the internal Citi models - Base / Adverse / Severely Adverse
• Review test cases with business to ensure traceability against defined business requirements
• Use of SQL to retrieve data extracts for data analysis and reconciliation
• Create management reports on overall status of project using excel and PowerPoint

Confidential, NY

Senior Business Analyst / Project Manager

Responsibilities:

• conduct meetings with SME’s from Finance, Risk and CCAR SME’s to interview and gather requirements.
• Coordinate with the Data Governance and Financial Regulatory Reporting team to write business requirements and get a sign off from the users.
• Identify upstream systems for data sourcing exercise and work with the respective systems like LAP GL, OMR, Loan IQ, and Atlas 2 etc. to identify data elements that could be mapped back to the data elements on the Schedule(s).
• Sourcing all the data for the following - 14Q Schedule, FRY 9C Schedule, FRY 14A Summary Schedule for Capital POD and 14Q Schedule for Corporate Loans POD - define data elements to be sourced, mapped all data elements, wrote transformation rules, created data dictionary and created Functional Specification Requirement (FSR) document.
• Axiom Controller view use to run reports for Data Quality & Reconciliation
• Extensive use of SQL to retrieve extracts for data analysis, data reconciliation & testing
• Create & maintain logs for data elements that require remediation, identify open items for tracking purposes.
• Create presentation & senior management reports on overall status of project using Office tools.

Confidential, NY

PMO/Senior Business Analyst (PWM)

Responsibilities:

• Liaison with Financial Advisor’s and business users to understand the requirements on 3D Advisor Desktop, analysis, prepare BRD’s, and get an approval/sign off from the end user. Lead the 3D mobile initiative for iPad as well.
• Also work in tandem to coordinate the implementation of reporting initiatives with members from Sales, Marketing, Client On Boarding, Operations, Technology, Risk and the Business.
• Work with the Lead on change related projects, coordination of deliverable, assessing risk and control measures
• Updated Roadmap documentation with data from the mapping documents (source to target) and identifies gaps and coordinate to remove these gaps
• Coordination with ETL team as well as the DEV and Data Model team to identify discrepancies
• Presented weekly status reports to Senior Management & Executive Steering Committee for the above program, covering project accomplishments, risks, issues & changes and cost / schedule performance
• Wrote requirements - Test Scripts, Plans and coordinated the UAT of various applications. Provide analysis and feedback on the test results
• Work and liaise with architecture, development (onshore/offshore), application management and QA (offshore) teams on project planning, status and deliverables
• Work with the central PMO & Governance teams for dashboard/scorecard reporting, new process initiatives

Confidential, NY

Lead Business Analyst

Responsibilities:

• Liaison with Portfolio Managers, other business end-users and subject-matter experts to define reporting requirements for the Data Hub, including pre-built canned reports and setup of self-service reporting.
• Communicate extensively with Bank of America resources (PACE - source system) to understand and consolidate information related to positions, transaction and settlement cash feeds to build requirements for EOD Positions, EOD Tax Lots (GIM/PACE/ INV1), Bank Statements, New Cash & Encumbrance Reporting.
• Daily interaction with data consumers and subject-matter experts to define downstream feed requirements from the data hub, mapping attributes (ISIN, CUSIP etc.) Required in the data model and identify gaps.
• Alignment with data delivery Program Manager to define strategy for requirement gathering and gain end-user participation. Work with data acquisition BAs to align requirements with data quality requirements.
• Leadership role in defining, implementing and communicating Deployment & Release Management methodologies, processes and governance for all delivery organizations reporting to PMO; process were based on best practices.
• Manage a portfolio of over 10 projects - driving the effort from QA, UAT to Production; assisting in defect management, documentation management, working through the change control process, ensuring all checkpoints are completed, identifying risk assessment and contingency, business users sign offs
• Prepare monthly status reports to Executive Steering Committee & senior management covering major project risks, issues and cost / schedule performance with main focus on Program management & prioritization, Release & Deployment Management, Risk & Contingency Management.

Confidential, Jersey City, NJ

Business Analyst, Project Manager

Responsibilities:

• Access current state business processes with end users, understanding the risks involved, their pain points and future needs; prioritizing mandatory items and profiling nice to have’s.
• Work with all Investment Management groups (IA, Statutory Reporting, Asset Liability Management, Global Performance, Chartis, Star, Edison, Technology Operations to understand, gauge and accumulate data consumption requirements and find out potential opportunities to maximize ROI from enterprise system rollout.
• Daily communication with program manager, project sponsor and stakeholders to secure acceptance and approval of deliverables. Responsibilities included but not limited to communication, including status reporting, risk management, escalation of issues that cannot be resolved in the team.
• Lead and mentor a team of 3 business analysts on multi phase, complex data integration and reporting.
• Provide technology and strategy consulting services to management in setting up Release Management Program and Process for theProject Management Office for IDR Division.
• Assist in implementing Fast Track process to effectively manage weekly and monthly release builds, change requests, defect management & forecast thus providing higher productivity.

Confidential, New York, NY

Business Analyst, UAT Analyst

Responsibilities:

• Managed requirements management process for GPS Scorecard project including requirement analysis, business intelligence requirements and writing business requirement documents and ensure required SLA’s and sign off are met within the stipulated timeframe - Interact across with different teams and end users across US, UK, Latin America and India.
• Managed cross team dependencies and consider business priorities when scoping, planning, and certifying change release into testing, UAT and production environments.
• Performed data quality analysis and cleansing to query & extract data from various source systems into data warehouse including CRM databases, interactions and readership feeds (XML feeds) using Business Objects XI (R3).
• Served as liaison between Businesses, Development, QA, support team and led implementation efforts of other products within CRM space (Sales & Research) for different other projects like Outlook Blast Mail, Click 2 Connect, and List Management.
• Managed UAT - releases and defects from the Business side using HP Quality Center. Also oversaw SIT plans from the QA group (Onshore & Offshore) so as to detect any possible gaps/ pitfalls during testing between QA / UAT team.

Confidential, Newark, NJ

Business Analyst, UAT Coordinator

Responsibilities:

• Developed business requirement documents and detailed functional design specifications, conducted detailed walkthrough with Dev. team for better understanding of requirements.
• Conducted stakeholder meetings, interviews throughout various releases to identify source of business/system issues in ETM and suggested measures of improvement
• Managed change and enhancement requests with the Director of ETM
• Responsible for overall QA/UAT Test Planning and strategy, writing detailed test cases, test plans, execution, document bugs and log them daily in QC, resolving and sign off before the release goes in Production environment.
• Trained testers about the overall functionality of ETM, how to perform UAT and regular Issue reporting.
• Managed a team of around 10 volunteer testers and the bug-tracking environment for ETM.