SUMMARY:

• 8+ years of experience in analysis in Financial Industry as business analyst i n multi - national and multi-vendor environments.
• Strong knowledge of Securities,Capital market, Financial Statements, Cash Flows and Financing Structures.
• Excellent Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem solving skills. Innovative & efficient. Capable of working as a Team Member or Individually with minimum supervision. Expertise in working extensively with senior level managers, developers and end users across multiple disciplines.
• Extensively Involved with the trading activities of Credit Derivatives, Credit default swaps, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures
• Expertise in creating business requirement documents, use cases and test plans.
• Worked across manufacturing, marketing, operations and finance environment
• Proficient in Corporate Finance, Investment Banking and Brokerage, Financial Accounting, Derivatives Valuation and Application, Review Financial Statements, Scope and Schedules and providing updates to Management.
• Extensive experience in Project management using MS Project. Excellent writing skills in writing Business requirements documents, USE Case Specifications, Functional Specifications, Non Functional Requirements, Systems Requirements Specifications (SRS)
• Experienced in all phases of the Project Development Life Cycle: Business Analysis, GAP analysis. Portfolio Performance Management and Project Finance Management across Analysis, Design, Build, Testing.
• Expertise in Data Extraction and Data Compilation using Advanced Excel and MS-Access. Proven skills in creating Business Requirement Documents (BRD), Functional Requirement Documents.
• Experience working as part of Business Intelligence, Data Warehousing and ETL projects.
• Experience working on large datasets and analyzing data using SQL and MS EXCEL.
• Hands on experience developing BI reports based on business user requirements using SAP Crystal reports & SSRS.
• Working in ETL environment and strong understanding of Dimensional models, ETL architecture. Specifically based on Informatica Power enters implementation experience.
• Responsible for Managing and executing Database Change requests using TFS
• Proficient with Excel in data manipulation, Pivot charts, Pivot tables etc.
• Extensive experience in Functional, (SIT) Integration testing, Regression, User Acceptance (UAT), System, Black Box Testing.
• Strong analytical and problem solving abilities.
• Excellent negotiating skills and ability to be tactful and diplomatic especially when engaging with senior stakeholders.
• Excellent written and oral communications skills with solid experience in delivering presentations.
• Thorough attention to detail and exceptional organization skills.
• Expertise on the Human Resource Data Warehouse Management and specialized in source translation to the warehouse, Basel domain and Risk data warehouse.
• Adaptable Data analyst skilled in recording, interpreting and analyzing data in a fast-paced environment.
• Experienced on Tableau reporting Multidimensional database and writing SQL queries.
• Business analysis expertise, meeting with key users and gathering business requirements to design reports functional and technical specifications
• Very strong experience in developing OBIEE (.RPD) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer), Answers, Interactive Dashboards with drill-down capabilities, BI Publisher, Delivers, Security Setup (groups, access/query/report privileges), configuring Analytics, Meta data Objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling Agent(IBOTS).
• Expertise in complete life cycle Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses and Data Marts.
• Expertise working full life cycle of Informatica (ETL) software development - analysis, design, development, documentation and testing.
• Experience Collaborating with project managers,analyst,technical leads, business partners and developers throughout the SDLC process
• Expertise in technical designs and has built Informatica work flows, mappings, batch file scripts, stored procedures, clearly documenting the process.
• Expertise in OBIEE Data Analysis, Performing Gap Analysis, Identification of dimensions, Facts & aggregate tables, Measures and hierarchies.
• Experience in creating, modifying, and Oracle Business Intelligence Dashboards with drill down capabilities using global and local filters in BI Presentation, using Oracle BI Answers, creating Agents in BI Delivers.
• Extensive experience in dimensional modeling design, building business models, configuring meta data, creating reports / Dashboards, cache monitor, building OBIEE Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer), time series objects, configuring OBIEE security (groups, access / query privileges) using OBIEE administration tool.
• Expertise in Cache management, Usage tracking, Performance Tuning, Security and MUD.
• Trained in Big Data Analytics and optimization and specifically Statistical Modeling for Predictive Analytics in Engineering and Business, Essentials of Applied Predictive Analytics, Advanced Predictive Analytics
• Core technical expertise in Oracle Business Intelligence Enterprise Edition (OBIEE), Business Objects, Tableau reporting, ETL- Informatica, Data Warehouse Administration Console (DAC), OBI Application, Data Modeling, star schema, data warehousing, building, Oracle SQL.

TECHNICAL SKILLS:

Oracle BI Apps: Oracle BI Apps v7.8.x/v7.9.x

Scheduling Tool: DAC

Programming Language: SQL, PL-SQL, RDBMS

Database: Oracle 10g, Oracle 11g & Tera data.

Query Tools: SQL Developer, TOAD

Data Modeling: Star Schema Modeling, Snow Flake Schema Modeling, Fact and Dimension Tables

Operating Systems: Windows

Workday, Integrations: Engineering Big Data with R and Hadoop Ecosystem

Migrating tools: Clear case, Sub version

WORK EXPERIENCE:

Sr. Buisness Analyst

Confidential, Louis, MO

Responsibility:

• Worked as a business analyst to build enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, Derivatives (ropes, interest rate swaps), Money Market Instruments and used strong knowledge of financial statements, cash flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting.
• Maintained data reconciliation efforts focused on collecting and comparing trade data from the Front Office systems and Counterpart Credit Risk systems for OTC derivatives.
• Managed the transition of Equity derivatives documentation occurring from the BOA and other end customers.
• Responsible for client documentation process from drafting to execution of deal including second review of outgoing and incoming confirms.
• Drafted, reviewed, interpreted and analyzed confirmations for OTC Derivatives including Fixed Income, Credit Derivatives and Equity.
• Support all settlement and confirmation function for FX cash products
• Verified and processed AML currency transactions according to internal procedures.
• Carried out changes in the Data warehouse area due to deployment of Derivative management system Calypso.
• Performed quality listening reviews and provided targeted feedback and coaching to associates.
• Worked with the Policy and Strategies team to ensure procedures and strategies were kept relevant.
• Create SharePoint work space to manage project, work break down items, prioritization lists, business requirement documents, and manage tasks.
• Coordinate closely with traders, middle office, data and technical operations support, various application development teams to report and communicate the execution status back to the business and senior management.
• Systematically gained knowledge on the business process being followed in the project environment.
• Optimize business requirements from as-is state documentation, Sops, interviews with key stakeholders.
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Manage Share point site and document (functional & technical) source to target mappings, process flows, procedures and business requirements. Reporting on Project status to stakeholders and senior management with respect to cost overruns, time lines, risk status etc.
• Planned all the RUP iterations and documented the artifacts throughout various phases. Conduct analyses of Business requirements and System specifications.
• Conducted JAD sessions during the various stages of upgrading the matching system and discuss the current system preference.
• Helped identifying reports for decision support system and interacted with database designers and architect for gathering the requirements for reporting.
• Worked closely with the Lead Business Analyst to monitor progress, and the deliverables for the project.

Business Analyst

Confidential, Arlington, VA

Responsibility:

• Conducted weekly financial reporting by extracting, and analyzing financial reports from Cost point and Cognos.
• Performed financial analysis for all ongoing projects by monitoring progress and working with program managers to remediate any issues.
• Managed job orders and budgets for current government projects by maintaining a precise record of changes and ensuring overruns are at a minimum.
• Supported program managers by gathering data, and compiling presentations for senior management briefings.
• Responsible for obtaining requests for quotations (RFQs) from GSA Advantage, verifying information, and providing necessary documentation to senior leadership.
• Verified details of all contract modifications (MODs) and maintained up-to-date records of all MODs on Share point.
• Assisted program managers by taking lead in setting up file structures on SharePoint to better manage government contracts.
• Supported proposal-pricing efforts by determining bill rates and assisted with preparing price proposals.
• Reviewed teaming agreements and non-disclosure agreements, ensuring corporate regulations and interests are met.
• Maintained contract information in corporate financial and administrative management systems.
• Assisted business management teams in implementing controls and processes to streamline business operations.
• Expertise in using HP automated testing tools such as Win Runner, Quick Test Pro (QTP), Load Runner, Test Director, and Quality Center.
• Expertise in Agile and SCRUM principles.
• Experience in working with Oracle, J2EE (Java, Servlets, JSP, EJB), XML, UML, .Net, C, C++, SQL, PL/SQL, UNIX Shell Scripting.
• In-depth participation in design reviews and requirement analysis with development team and the client.
• Highly motivated, detail oriented, ability to work independently and as a part of the team with excellent Technical, Analytical, Presentation, and Communication skills.

Business Analyst/QA Analyst

Confidential, Fairfax, VA

Responsibilities:

• Responsible for performing business research that's designed to improve business processes and contribute to cost savings and more efficiency.
• Provides customized business-focused advice and expertise to create value, develop business strategies, and improve internal processes and program/project performance.
• Defines requirements, analyzes data and provided input in the development phase of applying best business practices.
• Develops strategic analysis of mission needs and evaluates current organizational capabilities to determine potential gaps.
• Analyzes capability gaps to identify potential solutions sets, including information technology, to mitigate or eliminate the gaps.
• Oversees data collection, analysis, and report development and preparation.
• Familiarity with database development and management.
• Ability to work effectively in a diverse large/small team environment or independently.
• Attention to detail, strategic thinking, and organized work habits.
• Develop test plans, test cases and perform testing.
• Provide user documentation, user training and post implementation support.
• Collaborate with business leaders, IT professionals and vendors ensuring that management is kept informed of project status and those problems and issues are escalated appropriately and clearly communicated.
• Developed a thorough understanding of Cost point Budgeting and Planning, Earned Value Management and Acquisition Management processes.
• Administered bi-weekly Change Control Board (CCB) meetings with over 15-20 attendees, while making certain that Change Management (CM) Policy is followed.
• Leveraged ITIL best practices to improve existing CM processes. Performed CM Process Review to ensure audit requirements are being met, ultimately leading to positive audit findings.
• Assisted in creating a new Asset Management and Fixed Asset Disposal Process. Worked closely with the Finance dept . to make sure the processes are well understood and working without issue.
• Owned Fixed Asset Disposal Process, and took full responsibility in ensuring that all IT Assets are disposed and written off the books in a timely manner.
• Developed material to support training on the recoup process of wireless and peripheral equipment. Designed and lead training sessions for over 100 employees in the IT Department.
• Managed vendor relationships and maintained records of invoices/payments in Costpoint.