SUMMARY

• Business Analyst with diversified experience of 5+ years in Business strategies, Planning, Design, Data Analysis and Testing in domains of Finance (Investment Banking, Asset Management) and healthcare.
• Demonstrated strong business acumen with technical, project management and analytical skills.
• Experienced and knowledgeful in FX, Equity, OTC Derivatives trading & Structured Products, Securities Lending, Compliance and Loans Trading. Sound understanding of Dodd - Frank regulations on OTC Derivatives Compliance.
• Thorough understanding of the Software Development Life Cycle (SDLC) and strong experience working in Agile/Waterfall environments.
• Excellent interpersonal and communication skills to interact with both Business and IT teams.
• Proficient in undertaking JAD sessions, Requirement Gathering Sessions, Walkthroughs, Presentations, and meetings for communicating the work status.
• Elicited & documented Business/ Functional/ Non-Functional requirements, created Traceability Matrix, developed key artifacts and diagrams using UML modeling tools.
• Competent in Unified Modeling Language (UML) for developing Use Case Diagrams, Process Flow Diagrams, Data Flow Diagrams, and Activity Diagrams using MS Visio.
• Well versed in supporting the management team in areas like Change Control, Quality Control, Defect Tracking, UAT, Risk Management, and Scheduling etc.
• Proficient in writing and executing Test Plans, Test Cases and Test Scripts.
• Ability to simultaneously work and manage multiple projects
• Experienced in establishing and maintaining a high level of customer trust and confidence with client stakeholders.

TECHNICAL SKILLS

Programming & Tools: Tableau Desktop, C, R, Python, SQL, Unix, Advanced Excel, Microsoft BI, SAS, and Aqua Data Studio and Adobe Photoshop

Platforms: RPA (UI Path), Salesforce Administrator, Google Analytics, Confidential Aladdin and Bloomberg Terminal

Modeling Tools: ERWIN, Rational Rose, MS Visio, Entity-Relationships & UML Design

SDLC Methodologies: Waterfall, Agile, Rational Unified Process (RUP), Enterprise Development Process, GAP Analysis & Impact Analysis, JAD/RAD Sessions, Content Management, Requisite Pro, DOORS, Rational Rose, JIRA.

Project Management: MS Project (PERT, Gantt charts), OECM (Oracle) 10gR3, CMMI, MS Project Server, SWOT Analysis, CPM and WIP.

Reporting Tools: Crystal Report XI R2, SSRS, MS Access, Oracle Reports 9i/6i.

ETL Tools: Informatica, SQL *Loader, SAS, MicroStrategy, MS Excel.

Databases: Oracle 8/9i/10g, MS SQL Server 00/ 05, MS-Access 00/ 03/ 07, DB2, Sybase.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. Business Analyst / Data Analyst

Responsibilities:

• Maintain the loader processes of large data sets of securities acrossfixed income, equity and alternatives products.
• Fulfill ad-hoc client requests while acting as a liaison between cross-functional teams to provide high quality data solutions with tight deadlines.
• Initiate & drive the Index platform improvements to support new business needs, create custom tailored products & applications; Publish risk information through Aladdin investment platform in a timely manner for taking investment management decisions.
• Investigate & resolve intricate portfolio construction issues escalated for quality control checks on index data by exploiting proprietary Aladdin tools and collaborating with vendors.
• Date Contributed in the Data Warehouse STAR schema design and the mapping of Reporting fields.
• Lead workflow analysis and data integration including Analysis, Data mapping, Extraction, Transformation and Loading of data feeds from various sources to staging Area using ADS, SQL Loader, PL/SQL and Shell & PERL scripting to integrate Confidential ’s Aladdin Platform with client’s environment (Deutsche Bank with Eagle PACE serving as the global Reference Data Platform and EDM)
• Liaised with middle office (compliance, operations) and front office (trading desk and portfolio management) to gather and document requirements for IT initiatives and assisted in the troubleshooting of investment data issues.
• Supported client reporting as well as risk and compliance monitoring Business teams on Aladdin which integrates DeAM (Deutsche Asset Management) with Accounting platforms

Confidential - New York City, NY

Business Analyst

Responsibilities:

• Gathered and identified business requirements from the business stakeholders, users, SMEs and translated into FRD, BRD, and system specifications. Interacted with all levels of project development team
• Produced Functional Specifications for large trading systems. Reviewed and analyzed the entire Batch Jobs schedule and provided the analysis to the Technology Support teams to meet the goal
• Assisted the project manager in creating project plan, scheduling and tracking project timeline using MS Project
• Prepared a package of Process Flow diagrams to document the existing system and used Rational Rose UML notations for Object Oriented Design and Documentation
• Analyzed business processes and created process maps. Wrote standard and complex SQL Queries to perform Data Validation, Analysis and Data Mapping of Sybase and DB2 data
• Acquired in depth knowledge on securities, back office operations through processing (STP) platform for end-to-end automation of trade settlement such as - trade processing, settlement and position management
• Automated the process for scheduling the jobs using Informatica Scheduler and from UNIX command line
• Used SAS to do cleansing of database through a variety of techniques, including standardization, transformation and rationalization, while maintaining an accurate audit trail
• Addressed exceptions encountered during UAT and created JIRA ticket numbers assigned to appropriate development groups for bug fixes and enhancements
• Designed data staging area and created High level ETL design to meet the data requirements
• Responsible for engineering the end-to-end UAT testing across all impacted applications including FiStar & TradePipe front-end trading systems, NTAPS books and records, NCDI data warehouse & PeopleSoft general ledger; products include corporate bonds (factored, sovereign debt, high grade/high yield) as well as CDO/CLO instruments & Futures

Confidential

Supply Chain Business Analyst

Responsibilities:

• Defined the business requirements and analyzed the potential technical solutions
• Managed end to end Digital Supply Chain project enhancements and integrations. Created functional specifications, while driving complex database and system solutions like SAP Integration
• Created functional specifications for the backend solutions of Digital tokens, key activation process, new partners & new channels, online POS and Get key. Also, created end to end solution and documentation for SAP integration with CIS platform for financial reconciliation (Fulfillment and Digital Supply chain)
• Conducted daily agile standup meetings, gathered business requirements and translated them into User scenarios & User stories; prioritized and included them into schedule sprint release
• Conducted training sessions for the end users and documented various training manuals

Confidential

Business Analyst

Responsibilities:

• Analyzed, documented, and implemented new features for patient on the client’s website with regards to finding resources for the provider
• Created Traceability Matrix (RTM) to keep the stakeholders informed of the progress of the project
• Collaborated with the Developers, Testers, and business team to introduce the new feature for dental and Medical providers to log-in to the portal
• Updated the medical policies and client’s clinical guidelines for providers
• Created user cases, user scenarios and user stories for finding the online provider on the website
• Defined and documented the requirement of how to log-in to the Access Point portal to verify Eligibility to access other provider resources
• Updated the instructional manuals and resources on the SharePoint as well as on Portal for the providers