SUMMARY

• Proficient Business/Data Analyst with 9 Years of experience in fields of Business, Information Technology and Finance Industry.
• With in - depth knowledge of the Software Development Life Cycle (SDLC) (Agile, Waterfall, RUP) in capturing/analyzing Business and technical Requirements.
• Rich Experienced in Data analysis, Data profiling, Object-Oriented Design/ Modeling, Service Oriented Architecture and Project Management.
• Extensive experienced in gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers and QA engineers.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Automation UAT.
• Experience in creating UML Diagrams like Use case diagram and activity diagram.
• Well versed with regulatory reporting and stress testing (Dodd Frank/CCAR, and Basel III), Portfolio Risk (Credit Risk, Market risk across all assets, Facility Risk Rating, Statement Forecasting) and Compliance regulatory (KYC and Customer on Boarding).
• Depth knowledge in financial instruments within investment banking and brokerage environments (Derivatives, Fixed Income, Equity, Capital Markets, FX, Futures, Options, Commodities, Debt, Swaps)
• Adept at designing business models using UML diagrams - Use Case, Work Flow diagrams and data flow diagrams.
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and JAD and JAR sessions. Excellent liaison skills in dealing with different stakeholders and managing business communications.
• Experience in ETL Processing, DataAnalysis,DataProfiling,DataMining,DataMigration,Data Integration, Data Mapping and Configuration Management.
• Experience inDataModeling in creating Star & Snow-Flake Schemas, FACT and Dimension table.
• Well versed in different management scenarios like Change Control, Quality Assurance, Defect Tracking, System Integration, and Scheduling.
• Have exposure in educating internal customers on business systems, rules and procedures as well as working with other analysts and QA team to set priorities and schedules.

TECHNICAL SKILLS

• MS Office
• Excel
• Word
• PowerPoint
• Project
• Visio
• Access
• Publisher
• FrontPage
• Outlook
• Communicator/Lync
• MS SharePoint 2007
• Lotus Notes
• Mainframes
• JIRA
• SQL Server 2005/2000
• Python
• Toad
• Oracle 9i/10g
• Adobe CS3/CS2 (Photoshop
• Illustrator)
• HP Quality Center 9.2
• Tableau

PROFESSIONAL EXPERIENCE

Sr Business Analyst/Data Analyst

Responsibilities:

• Supported documentation of project scope, budget and schedule with the Project Manager.
• Communicated with regulatory team to gather business requirements and worksheets. Created user stories based on business requirements with good understanding of stress testing and regulatory compliance standard.
• Worked as data analyst to query database, identified source of data and target data to generate FRY - 14M report for Schedules A to D.
• Identified data requirements with data sourcing team and provided data mapping documents to “Control M”.
• Validated data, based on data requirements by running SQL queries and set validation rules.
• Uploaded and maintained the most updated version of Data Mapping into Share Point.
• Confirmed Manual data input templates with Business Users and got sign- off.
• Performed testing phase by providing test cases and identified variances between expecting value and output.
• Created ETL mapping document based on the requirements and performed data quality and data profiling checks for the mapped data.
• Defined and documented Requirements Traceability Matrix to provide requirements to test case linkage for audit purpose.
• Requested Quarter 4 2016 legacy filing from reporting team. Identified variances from Recon Form
• Liaised between stakeholders and reporting team to identify and confirm issues for submission purposes

ENVIRONMENT: Microsoft Office Suit (Word, Excel, PowerPoint), HP ALM, SharePoint, SQL Server Management Studio, Axiom, Jira, MS Visio.

Confidential -Dallas, Texas

Sr. Business Analyst/Data Analyst

Responsibilities:

• Conducted and guided JAD and Brainstorming Sessions to gather Business Requirements and worksheets from business users - Regulatory Reporting Team and other SMEs. Documented user stories in JIRA.
• Communicated with all stakeholders and SMEs in all phases, make sure the process were on right track.
• Collaborated with regulatory reporting team and Axiom configuration team to confirm manual data input templates, which could be consumed by Axiom Controller View.
• Worked closely with data sourcing team to identify data sources and target data, documented and analyzed SQL queries against databases and upgrading data mapping documents into SharePoint for automation purpose.
• Performed data validation based on data requirements in data sourcing stage (FTDR) and Regulatory Reporting Data Mart (ESP).
• Led on the data sourcing effort for Retail Schedules pertaining to CCAR and the FRY-14Q reporting to regulatory system; Federal Reserve Bank.
• Analyzed (MDRM) and design of CCAR (FRY 14Q Retail schedules), FRY 9C (HC-L Derivatives)
• Collaborated with Axiom developers to link data to Federal Reserve Schedule templates.
• Created and managed the project schedule, monitored the whole team to complete tasks in timely manner. Recorded issue and work status to represent to Project Managers.
• Involved in documenting detailed Functional Requirement Specification based on CCAR requirements.
• Assisted the data sourcing team to integrate data using ETL tools, and involved in implementing complex Business Objects reporting solutions
• Conducted Data Analysis check like Data Quality, Data Profiling and Data Validation for the available data.
• Created ETL Mapping Document to map the data from source to target destination.
• Participated in Axiom automation UAT. Identified and analyzed variances in the Reconciliation input and output form. Traced data work flow in Axiom.
• Acted as liaison between business users and Axiom configuration team.
• Resolved issues and conflicts between different stakeholders, found out proper resolutions to make all stakeholders satisfied.

ENVIRONMENT: Microsoft Office Suit (Excel, Word, PowerPoint, Project), Jira, SQL Server Management Studio, SharePoint, HP ALM.

Confidential -San Francisco, California

Business Analyst/Data Analyst

Responsibilities:

• Defining strategy level architectures and system/technology level architectures for Pillar I and PillarII(including Balance sheet planning, Corporate Stress Testing, Liquidity risk, VAR implementation, EC Credit risk, EC Aggregation and Allocation).
• Worked with platform owner and model owner to develop solutions for stress testing activities, including enterprise-wide capital adequacy stress tests such as CCAR.
• Worked with Reporting team to prepare FFIEC reports
• Analyzed theBaselII Risk Weighted Assets (RWA) classification process to determine key data for RWA and capital ratio calculation.
• Worked with product management to help develop roadmap items related to IRR & FX Risk
• Designing Balance sheet planning and Liquidity risk framework methodology
• Involved in implementation of Business user implementation of EC Credit Risk
• Providing data, application and technology consulting in pre-feasibility and feasibility discussions with IT team members and business partners,
• Worked with simple complex SQL queries to access the data from database
• Performed Data Quality, Data Profiling and Data Validation for the data to be brought into repository to make sure the data integrity is maintained.
• Created source to target mapping document to bring the data from source to target.
• Preparing project deliverables and documentation as needed to support Architecture-related processes
• Assisted in gathering the business requirements, and creating ETL documents
• Created Data specification document and data specification document, conducted data validation, and profiling.

ENVIRONMENT: Microsoft Office Suit (Excel, Word, PowerPoint, Project), SharePoint, HP ALM, Jira, SQL Server Management Studio

Confidential, Maryland

Business Analyst/Data Analyst

Responsibilities:

• Gathered the business requirements and detailed design specifications for Pillar 1 & Pillar 2and Created process manuals for Credit Risk & Market risk.
• Understood the functionality of the existing systemsand designed stress testing activities
• Designed process manuals for Counterparty Credit risk & Market riskand the overall architecture of the system
• Creation of data attributes and tables for Traded products and Implementation and customization of RWA calculator
• Managed the end to end build of the Capital / RWA requirements to facilitate regulatory filings under the newBaselII rules
• Designed system components for Pillar 1 & Pillar 2and generated test Scripts
• Analysis of Source, existing OLTP system and Identification of required dimensions and facts from the Database.
• Performed testing phase by providing test cases and identified variances between expecting value and output.
• Created ETL mapping document based on the requirements and performed data quality and data profiling checks for the mapped data.
• Defined and documented Requirements Traceability Matrix to provide requirements to test case linkage for audit purpose.
• Defined detailed design specifications for interfaces forBASELIICredit Risk Implementation.
• Created ETL mapping document based on the requirements and performed data quality and data profiling checks for the mapped data.

ENVIRONMENT: Microsoft Office Suit (Excel, Word, PowerPoint, Project), Jira, MS Visio, SQL Server Management Studio, SharePoint, HP ALM.

Business Analyst

Responsibilities:

• Manage projects in the Credit Risk, Technology and Enterprise work streams within theBasel program by monitoring project status, risks/issues and leading biweekly meetings with all necessary stakeholders.
• Led the in-depth review of all milestone submissions, change control, gap closure and project closure requests from the projects to ensure completeness and avoid downstream impact to the implementation ofBaselregulations.
• Monitor changes to theBaselprogram-wide critical path
• Track status of program-wide testing and provide updates through weekly files and monthly meetings
• Assist in updating deck for monthly meeting with Federal regulators, discussing status of individual projects and overall program
• Assisted in creating a program-wide policy to respond and ensure compliance to Regulatory feedback
• Provide updates, feedbacks to project lead with status report

ENVIRONMENT: Microsoft Office Suit (Excel, Word, PowerPoint, Project), Rational Requisite Pro, Rational Rose, HP Quality Center