SUMMARY

• 6+ years of experience in Information Technology Industry as Sr. Business/Data Analyst.
• Experienced in data analysis, data modeling, Conceptual logical modeling and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Proficient in all phases of Software Development Life Cycle (SDLC) achieving milestone using Rational Unified Process (RUP) and waterfall model.
• Data profiling, validating, monitoring and cleansing across the enterprise through Informatica Data Quality (IDQ).
• Established Data Governance and Master Data Management processes, standards, policies and best practices.
• Experienced in Risk Management process and technology reengineering, Sarbanes Oxley implementation, valuation reviews process and technology, strategic sourcing, metrics and benchmarking.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.
• Expert in Business Function,Business Process,Negotiation,Strategic Business Planning projects
• Expertise in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), and System Requirement Specification (SRS).
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Translated high level business/data requirements into Process, Workflow, and Data Flow Diagrams using Rational Rose/MS Visio/BPMN towards facilitating clear understanding of the business process.
• Experienced working with Data Migration from Legacy systems to advanced relational databases, Data Conversion, Data Archiving into Central Repository/Informatica Servers, Merging records in Master Database Management (MDM)
• Thorough knowledge in UML Modeling, including Activity Diagram, Sequence Diagram, Use Cases, State Chart Diagram, Deployment Diagram, Class Diagram, and Component Diagram.
• Have extensive knowledge in Data flow modeling and Object modeling, case analysis and functional decomposition analysis
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
• Experienced in conducting JAD sessions meeting reviews and walkthroughs.
• Experienced in creating Test Cases, Test Plan, and Test Data. Performed User Acceptance Testing (UAT) working with team members.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Experienced in the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Informatica Power Center.
• Excellent experience and knowledge in modeling concepts like Conceptual Data Modeling (CDM), Logical Data Modeling (LDM), Physical Data Modeling (PDM), Star Schema, Snowflake Schema, Fact & Dimension tables, OLTP and OLAP
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).

TECHNICAL SKILLS

Operating Systems: Windows NT/98, XP, 2000, Unix, Linux

Application Software: MS Office suite, Rational Suite, MS Project

Databases: SQL Server, Oracle, MS Access, SPSS, DB2, Mainframe

Web Technologies: HTML, XML

Methodologies: RUP, OOAD, UML & Business/Data Modeling, ER modeling

Requirements Management Tools: Requisite Pro, MS Visio

Testing Tools: Test Director, Quality Center, Quick Test Pro, Load Runner

Process Modelling: MS Visio, Rational Rose, Virtual User Generator

Programming Languages: Java, J2EE, SQL, ASP.NET, UML, Visual Basic, C, C++, Python

Documents & Processes: SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modelling,Net Project Planning & tracking

PROFESSIONAL EXPERIENCE

Confidential - Brooklyn, NY

Sr. Data Analyst

Responsibilities:

• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools (Qlikview and Tableau).
• Created test scripts in Python, coordinate test script execution.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Worked with Systems such as AFS, ALS, CACS, APPRO, UNIFI, LoanServ, FD, DATASCAN4, Leasemaster and various in house and vendor applications.
• Thorough understanding & experience working for regulatory driven projects under Compressive Capital Analysis & Review (CCAR), Dodd Frank etc.
• Researched data issues and identify the root cause in source systems, data warehouse and data marts using various data analysis techniques, data mining, data profiling and data cleansing activities.
• Advanced ad-hoc and standard report development, including data analysis through the use of Oracle Discover, Business Objects, TOAD, Excel, Access, SPSS, SAS, SQL, and Oracle Reports.
• Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
• Analyzed requirements & recommend strategic initiatives for OTC derivatives protocols and practices around DTCC, CDS, and SWIFT for treasury and asset management documentation.
• Comprehensive knowledge of and solid experience in Derivatives, Fixed Income including Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives
• Strong working experience in the Data Analysis, Data Profile, Data Quality, Design, Development, Implementation and Testing of Business Intelligence applications using ETL and ELT methodology.
• Informatica Data Quality (IDQ) used for data quality measurement.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Created Data Flow Diagrams (DFDs), ER diagrams for database modeling and Web-page mock-ups using MS Visio for acceptance from analysts, surveyors and customers.
• Experienced in Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Incorporated the Informatica Velocity approach for Mapping design, development and Data Governance.
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Involved in Performance Measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
• Worked with end users for BI data analysis and data validation. Responsible for Master Data Management (MDM) and Data Life Cycle process. Worked on heterogeneous data coming from multi sources including Flat Files, CSV files, XML Files, Mainframe Files and DB2UDB. Worked on Mantas Anti Money Laundering (AML) data analysis and validation.
• Entity Master Support for Data Governance, Regulatory Compliance for Client Data, Dodd-Frank.
• Experienced in conducting User Acceptance Testing (UAT), SWOT analysis, and GAP Analysis.
• Worked with Mainframe team to understand the source applications and source files. Used FileAid to verify source files /records on Mainframe. Wrote SQL queries and UNIX scripts for Data Analysis and Data Validation. Created Views and Materialized Query Tables (MQTs). Prepared Metadata reports and defined new validation rules.
• Worked on Credit DataMart and Marketing DataMart and responsible for gathering requirements, preparing functional specifications and BI Business/Data Analysis / Modeling and UAT.
• Worked on Teradata insert, Update, Upsert and Dynamic SQL to transform and Load Summary tables built on Core Data Warehouse using BTEQ.
• Extensively worked on Performance Tuning of Teradata SQL using explain plan and understanding Joins and Data distribution
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Involved in the troubleshooting of universe schema with loops, chasm traps and fan traps, and cardinality problems.
• Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript
• Prepared Source-to-Target mapping documents and Involved in Fine-tuning of sources, targets, mappings and sessions for Performance tuning and optimization.
• Converted MS Access database to MS SQL database using MS SQL 7.0 Server Enterprise Manager. Created SQL scripts for uploading procedures.
• Performed custom data conversions and developed custom software for risk management applications including general claims, vehicle accident and administrative tracking. Performed all data field mappings.
• Involved in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Worked on creating a document on putting a process in place for incorporating Sarbanes - Oxley act to mock up real production data in case of volume testing.
• Actively involved in Source Driven Testing, Target Driven Testing, Business Cycle Testing, Business Scenario Testing and Data Integration Testing.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects.

Environment: Business Objects, TOAD, VBA, PowerPoint, Oracle 10g, Java, PL/SQL, SQL Server, XML, Windows 2000, UNIX, Rational Req. pro, clear case, Mainframe, Rational Rose, Lotus Notes, Clear Quest, UML, MS Visio, MS Project, MS Office, Python, IBMDatastage.

Confidential, Miami, FL

Financial Data Analyst

Responsibilities:

• Wrote functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Created .NET Reports which are used to present the data in different views and are effectively consumed using Crystal Reports.
• Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, and Maps etc.
• Gathered business requirements from users and developed the Data Model to be used to develop Qlikview dashboards.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL Server.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality.
• Designed the universes by creating the Business Objects data model.
• Specialized in testing Java, .NET and Oracle, Excel, Access applications.
• Defined and implemented QA tools and processed in Python.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, Data Mapping, and data dictionary and data analysis.
• Developed and maintained sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Skilled in Data Quality, Master Data Management, Business Systems Analysis, Data Governance Framework, Business Intelligence, Data Warehousing, Data flow analysis, Process flow analysis and mapping, Data Profiling.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Conducted workflow, process diagram and GAP analyses to derive requirements for existing system enhancements
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Created Source to target Data Mapping documents identifying key data elements and prepared Data Flow Diagrams
• Created a new risk and regulatory reporting system to deliver accurate and timely reports through a central data warehouse and Axiom's Regulatory Reporting System.
• Data profiling, validating, monitoring and cleansing across the enterprise through Informatica Data Quality (IDQ).
• Developed product provided cash identification, auto-settlement for the incoming direct purchases and wire orders and processing of international and domestic outgoing payments to clients and banks and ensuring money movement is screened for AML (Anti-Money Laundering) compliance.
• Experienced in Business Process Modeling, Requirement gathering and Analysis in for financial products such as Equities, Fixed Income Instruments, Credit Risk Analytics, and Derivatives.
• SWIFT messaging was used to establish a global communications link for data processing and a common language for international financial transactions.
• Thorough understanding of regulatory policies under Comprehensive Capital Analysis & Review (CCAR) & perform data anomalies to ensure the business needs are properly assessed and addressed to meet regulatory constraints.
• Facilitated with Data Governance effort and assert best practices.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system
• Provided test data to all the testers including UAT Business Edge team and UI testing team
• Analysis and Design of Migration Procedures for the DB Migration between Relational and Extended ERP Data Sources. Performed Database Migration from sources to the Data Warehousing database. Worked closely with Oracle DBA for migration support.
• Implemented new governance tool (Clarity) to replace multiple disconnected portfolio systems which aided in the improvement of data quality and timely information flow via executive dashboard reporting.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
• Perform Financial Statement Analysis (FSA) relating to Fund of Funds (FOF) Portfolio Valuations in comparison to the financial statements of the underlying securities & brokerage reports.
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Used Rational Rose to model the process using UML to create behavioral and structural diagrams.
• Performed data analysis by using SQL queries using the DB Artisan tool

Environment: RUP, Rational Requisite Pro, IBM Rational, Java, J2EE, Clear case, SharePoint Clear Quest, Data warehouse, UML, Oracle, SQL Server, Unix, XML, MS Project, Business Objects, Python, IBMDatastage.

Confidential - Chicago, IL

Sr. Business/Data Analyst

Responsibilities:

• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Worked with Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Sales and Marketing.
• Worked on equity, fixed income line of business including SWIFT standards.
• Wrote SQL queries using MS Access for data manipulations.
• Experienced in utilizing statistical tools like SAS, SPSS, MS office suite, MS projects, MS Visio and requirement management tools.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application in iSeries RPG environments.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management)
• Worked with DBA's to develop and implement a workflow process from Data Mart to populate Qlikview dashboards. Utilized best practice methodologies.
• Responsible to import the data from Crystal reports by using Business Objects Live office into Microsoft Excel and Word.
• Created customized report using OLAP Tools such as Crystal Reports for business use.
• Responsible for sitting down with business users to analyze dashboards and analytical reporting requirements using Tableau.
• Involved in Provide technical leadership for Business Intelligence (BI) roadmap and the direction of application projects from data capture through application design & implementation.
• Reengineering Using information technology to improve performance and cut costs.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system
• Have considerable expertise in Metadata Management, Data Analysis, Data Profiling & Quality, Data Governance and Master Data management (MDM).
• Provided test data to all the testers including UAT Business Edge team and UI testing team
• Analysis and Design of Migration Procedures for the DB Migration between Relational and Extended ERP Data Sources. Performed Database Migration from sources to the Data Warehousing database. Worked closely with Oracle DBA for migration support.
• Implemented Master Data Management (MDM) for all the high level entities in the project by maintaining a master hub for improving the data quality by following various data governance techniques and data dictionary standards.
• ETL process design, implementation and performance tuning (SQL, Teradata macros and stored procedures).
• Developed and maintained sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Performed sensitivity and risk analysis on program assumptions using Monte Carlo simulation and other statistical analyses
• Master Data Management (MDM): Initiated a cross-functional project to identify what master data to manage and defined a process to collect, aggregate, match, and consolidate, quality-assure, maintain and distribute such data throughout the company.
• Involved depth understanding of Credit Risk management for the application
• Conducted User Interviews and Work Shops to gather accurate Business Requirements
• Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs.
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk
• Collaborated with Basel III team on credit risk analysis and issue resolution.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel III
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues for Basel II Credit Risk Mitigation System (CRMT)
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Collected information and requirements about different Entities and attributes from FDS.
• Completed GAP analysis in detail on all entities in CCL for a source system.
• Prepared questionnaire based on the System Analysis Performed for all entities.
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.

Environment: Fidelity IMPACS, Fidelity Savings Time, Fidelity Finance Management, Mainframes, COBOL, Monarch, SQL, Java, Business Objects, IBMDatastage.

Confidential, Chicago, IL

Sr. Business/System Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system.
• Created functional specifications and design requirements for integration of current Wholesale Management System with Dealer Loan System to meet business requirements.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Developed application using Visual Basic. Wrote reports using Crystal Reports and MS Access.
• Analyzed requirements & recommend strategic initiatives for OTC derivatives protocols and practices around DTCC, CDS, and SWIFT for treasury and asset management documentation.
• Designed, developed and tested data mart prototype (SQL 2005), ETL process (SSIS) and OLAP cube (SSAS) for Computer Maintenance Management System (CMMS)
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Developed project plans and managed project scope.
• Strong subject matter expertise in Retail/Investment banking, financial statements, cash flow, financing structures, Foreign Exchange (FX) Risk Management, Capital Management, Asset Data, Fixed Income, Portfolio Analysis, Stock Valuation, Capital Structures and Budgeting, Value Based management. Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Microsoft Word, Power Point, Access and Lotus Notes.
• Established traceability matrix using HP ALM 11.0 to trace completeness of requirements in different SDLC stages. Analyzed the business and functional requirements of the application and also helped in developing detailed test plan and test cases.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Created DTS and SSIS Packages to vendors in which records were loaded Daily, also to other data resources such as Excel, Access, flat file, and XML in order to Create and maintain a centralized data warehouse.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD),Software Requirement Specification (SRS) across the deliverables of a project.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Played a key role in the planning, User Accepted testing, and Implementation of system enhancements and conversions.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Extensive experiences in Investment Banking projects specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
• Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.
• Created Business Requirement Document (BRD), Functional Requirement document (FRD) and Summary Reports.
• Developed, built and managed Reporting Services (SSRS) reports using both SSAS cube and relational database sources including distribution of reports using subscription services
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Developed business requirement specification documents as well as high-level project plan.
• Conducted benchmarking activities to identify best practices.

Environment: Mainframes, COBOL, Visual Basic, Oracle, Java, Teradata, UNIX, Rose, MS office, Cognos, MS Word, MS Excel, MS Visio, SAS, SQL Server, LoadRunner, WinRunner

Confidential - Princeton, NJ

Business Data Analyst

Responsibilities:

• Provided key input in working with users in indentifying and defining system and project requirements.
• Played an active role in gathering, analyzing, and writing business requirements using RequisitePro.
• Translated the business needs into functional requirements, and communicated the same to the business users, to baseline the initial high-level requirements.
• Involved in conducting JAD sessions with the entire team to come up with the possible solutions for the business problems.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL Server.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.
• Built Product on the Web Series e-Banking platform, and therefore integrates seamlessly with ACH, SWIFT, BAI messages and Global Cash services applications.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client’s legacy system
• Create and maintain data model/architecture standards, including master data management (MDM).
• Conducted Functional, Regression, Integration and UAT Testing.
• Created UAT documentation and conducted presentations for the end users.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Documented FRS (Functional Requirement Specifications) and assisted Systems analyst to come up with SRS (System Requirement Specifications)
• Provided inputs in the strategic development of detailed project plans, work assignments, and target dates.
• Established Data Management Office and Chair Data Governance and Business Intelligence councils, implemented global Data Governance, Data Stewardship and Data Quality monitoring processes, standards, policies and executive reporting dashboards.
• Strong visual modeling and business process modeling skills using Rational Unified Process (RUP) and Agile Unified Process (AUP) with tools like Rational Rose, MS Visio, and well experienced in developing Use Case Models, Entity Relationship Diagrams (ERD), Data Flow Diagrams (DFD), Activity Diagrams, Sequence Diagrams and UML CASE tools.
• Skilled in Data Quality, Master Data Management, Business Systems Analysis, Data Governance Framework, Business Intelligence, Data Warehousing, Data flow analysis, Process flow analysis and mapping, Data Profiling.
• Designed and developed use cases, activity diagrams, and sequence diagrams, using MS VISIO.
• Worked with the software architects / developers to ensure that the applications conform to customer requirements.
• Meticulously assessed data from various sources and generated conceptual and logical database designs using ERwin data modeling tool.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Partnered with the technical areas in the research and resolution of system and process problems.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Analyzed research on operational procedures and methods and recommend changes for improvement with an emphasis on automation and efficiency.
• Conducted impact analysis for the requested change by business users/stakeholders to control change in the requirements.
• Assisted the QA team to write the test plan and test cases.

Environment: Windows, Oracle 9, SQL, Java, Microsoft Office suite, Microsoft Visio, Clear Quest, Rational Unified Process (RUP), ClearCase, UML.

Confidential - Stanford, CT

Business Analyst

Responsibilities:

• Develop trading solutions to re-hypothecate the positions; perform high-level feasibility analysis, industry & market analysis, risk analysis, trading workflow reconfiguration
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Conducted extensive analysis on security trading cycles; provide consulting on financial disclosure, regulatory and compliance issues
• Created a procedural manual, by documenting the processes of the RSF Collateral/Custody Management System. Was the liaison person with regards to back-offices issues including: accounting, clearing, custody and regulatory.
• Design, develop, and validate testing methodologies for trading activities; perform trading-related testing via the new trading system, coordinate with various F2B components, document results, and generate reports
• Conducted business process modeling and analysis; identified, assessed and articulated gaps/operational risks associated; presented risk-mitigation and operational enhancement solutions to project management team
• Consulted with project manager in developing project plans & scope, clarifying project requests, providing root cause analyses, sharing best practices, and presenting findings and proposals in a professional format
• Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the System requirements and process flow.
• Assisted in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Developed & executed several Optimized queries in SQL on this data.
• Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time.)
• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
• Highly skilled in developing stored procedures, functions, triggers, DTS and SSIS
• Overall database design with logical modeling and physical modeling, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Was responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans

Environment: Windows, Oracle, Java. SQL, Excel, VBA, MS Visio, HTML, PHP, MS Access, UML, Quality Center, WebLogic, Requisite pro, Rational ClearQuest.