SUMMARY

• Business Analyst with over 8 years of industry experience in Financial Industry, data modelling, process flow and quality assurance skills.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Extensive experience in testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Market research tools like SunGard and IDC which give technology services that focus on application implementation and integration, custom software development, and application management and automate process for trading, investments portfolios etc.
• Good command over Logical and Physical entity relationship data modeling using Erwin, Oracle Designer and Power Designer.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse.
• Strong knowledge of all phases in Software development life cycle (SDLC) and the iterative Rational Unified Process (RUP)
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Solid knowledge in complex SSRS reports with multiple charts through functionalities and Sub reports interfacing with MS Excel 2007.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Extensively used Financial Systems segment tools like SunGard which provides solutions that automate the business processes associated with trading, managing investment portfolios, and accounting for investment assets; and address the processing requirements of various users.
• Extensive experience in Market Statistical analysis Bloomberg and Reuters and data exchanges.
• Design and review of various documents including the Software Requirement specifications (SRS), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Design, developed and implement staging tables, cursor, stored procedure and views using TSQL.
• Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Experience in Data Transformation, Data Loading, Modeling and Performance Tuning.
• Strong in database design, domain modelling and ER diagrams design
• Experience in conducting User Acceptance Testing (UAT)
• Highly motivated and a self starter with excellent communication and interpersonal skills
• Strong analytical and problem solving skills, capable of addressing relevant facts and recommending solutions.
• Used Team Site Content Management Tool to deploy and manage the content managed files.

TECHNICAL SKILLS

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

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

Databases: SQL Server, Oracle, MS Access, DB2

Web Technologies: HTML, XML

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

Requirements Management Tools: Requisite Pro, MS Visio, Caliber

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

Documents & Processes and other Tools: SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modelling, Bloomberg, Reuters, SunGard, IDC, Data Exchanges, Project Planning & tracking, Process flow charts.

PROFESSIONAL EXPERIENCE

Confidential, Albany - NY

Responsibilities:

• Use recognized business analysis methodologies to elicit requirements from business users as the foundation for developing solutions to the organization’s business needs
• Develop systems requirements for future or to-be states of large business system projects using standard templates
• Analysed project called Duplicate Data Entry Eliminations with an applications systems like PS&E, LAS, SM, PES, PSS and EPPM, Engineer’s Estimates documentations, meeting scribe and take the requirements.
• Primavera project with multiple interfaces to manage multiple project letting, award of transportation department.
• Involved with top client executive view reporting dashboards requirements, OBIEE Analytics, Exacative Reports and Enterprise Reports.
• Analysed current or as-is states of business processes, functions and process models
• Communicate business process requirements to IT staff, program staff and stakeholders
• Develop test scenarios, scripts and data and evaluate test results
• Analysed the impact of changes to IT system requirements or business processes and evaluate project timelines and priorities
• Lead stakeholders to resolve issues with design specifications before implementation
• Monitor system testing and assess the impact of errors on system functions during and after implementation;
• Write system documentation and train users on new IT system or business process functions

Environment: Microsoft Office Suite, Microsoft Visio, UNIX, Documentum, DB2, Windows NT/XP, Oracle, SQL, SQL Server, Primavera, P6, EPPM, OBIEE, PSS, PES, LAS source and target systems, letting and award process.

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:

• Assisted the project managers with the development of project schedules using MS Project 2010Acted as a liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships
• Defined and documented clear and complete detailed business requirements and functional specifications using the SDLC methodology from the Business team.
• Exposed to and worked with Subject Matter Experts in Fixed Income Annuities, Equities, Swaps, Finance, Trading Cycle, Portfolio Analysis & Management, Asset Management, Bonds and Bond Trading Cycle, Pricing, Derivatives.
• Collaborated with developers and SMEs on the creation of Common Information Model (CIM) and configuration of data model centralization to define dataflow of Enterprise Service Bus (ESB) for enterprise-specific metadata.
• Evaluated existing practices of storing and handling important financial data for compliance.
• Involved in providing online training and assistant to members in Foreign Payment, SWIFT, Nostro Reconciliations, Fund Reconciliations, SWIFT Messaging and used Caliber Project Management tools to gether requirements.
• Extensively used Financial Systems segment tools like Bloomberg/SunGard which provides solutions that automate the business processes associated with trading, managing investment portfolios, and accounting for investment assets; and address the processing requirements of various users.
• Developed SQL queries, databases and SSIS packages for data warehousing and robust investments analysis.
• Used iRise Application Simulator to create web.20 effects to make web pages more interactive. Post the Bank trades to customers account.
• Elicited requirements for development of the users’ GUI, interfacing with various systems.
• Interacted with SMEs to understand and gather requirements to improvise calculations of credit risk using the STA and IRB (Internal Rating Based Approach).
• Documented project artifacts such as Stakeholders Analysis, Business Requirement Document (BRD), Functional Requirement Document (FRD), and Test cases.
• Conducted user interviews, JAD sessions, brainstorming and surveys. Gathered and analyzed the requirements using MS Visio and Irise.
• Create Data Flow Diagrams (DFD) to depict the source-to-Target Mapping and Data Lineage Analysis.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping
• Worked on data mapping of source to target elements performing gap analysis Conducted interviews
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
• Perform Data Validation, Data Integration and Backend/DB testing using SQL Queries manually.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and Business Process using MS Visio.
• Worked closely with ESB team to re-design and validate existing reports.
• Extensively worked in Data Requirement Analysis and Data Mapping for ETL process.

Environment: MS Project, MS office, .net, Visio, SOA,SQL,Bloomberg, IDC, Webservers,Axure, XML, Irise and Oracle.

Confidential - Covington, KY

Business Analyst

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Complete study of the in-house requirements for the data warehouse. Analysed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analysed.
• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Helped with Data Mapping between the data mart and the Source Systems.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Analyzed the data warehouse project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analysed.
• Analysing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Execution of PL/SQL on oracle table in order to view successful transaction of data.
• Built reports and report models using SSRS to enable end user report builder usage.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Worked with heterogeneous sources from various channels like Oracle DBMS, SQL Server, flat files, and web logs.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Created various reports such as ad-hoc reports, drill-down, drill-through, and parameterized reports using Reporting Services (SSRS) for internal teams.
• Developed SQL scripts and wrote stored procedures to validate the flow of data from Legacy source to target application database and ability to perform data validation (of ETL processes, schema and DDL check, data flow from data warehouse to application databases, data marts, return marts, referential data, repositories).
• Developed timelines for project delivery, and managed projects/resources

Environment: Microsoft Office Suite, Microsoft Visio, UNIX, Reuters, Documentum, DB2, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, Foreign Exchanges, Data Exchanges

Confidential, Chicago, Illinois

Business Analyst

Responsibilities:

• Gathered requirements from Business users, technical lead and data modeler.
• Followed agile methodology and maintained user stories.
• 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.
• Represented the business requirements in various alternative views such as analysis models, use case diagrams and user stories.
• Extensively used Financial Systems segment tool SunGard which provides solutions that automate the business processes associated with trading, managing investment portfolios, and accounting for investment assets; and address the processing requirements of various users.
• Wrote SQL for data mining and data validation checks.
• Extracted reports for internal use by business users.
• Defects were identified, tracked and rectified using defect tracking documents
• Defects were allocated to testers and a log was maintained.
• Wrote Test cases for UAT and also assisted in testing for test and production environments.
• Lead stand up meeting to gather requirements and maintained regular meeting minutes and also maintained status reports on various projects.
• Updated requirement document as per meeting minutes and accordingly changed Requirement Traceability Matrix.

Environment: Microsoft Visio, MS Excel, MS Access, Data Exchanges, Bloomberg, Reuters and MS PowerPoint, Erwin, PL/SQL, XML, Windows 95/98/2000, Internet Explorer and Netscape, Rational Req. pro, Rational Rose, Clear Quest,UML.

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services). .
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market.
• Ensure business requirements with using Caliber requirement gathering tool / application functionality is consistent with regulatory mandates from Dodd-Frank Act.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Reconciling General Ledger accounts. Assisted with audit defense, Sarbanes-Oxley 404 compliance, research tax issues as they arise.
• Facilitate product/content reviews for assigned projects to ensure accuracy and market sensitivity of programs. Perform project management duties for internal service management and client reporting initiatives and other projects as needed, inclusive of the entire project management lifecycle.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process..
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Designed the dimensional Data Model of the data warehouse
• Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
• Documented requirements for management reporting out of Clear Quest using Crystal Reports
• In-depth understanding of Investment/portfolio management in multicurrency securities, equities, Fixed Income, portfol0io accounting and related back office processing, lifecycle of a trade, Lifecycle of an account, Security setup, Account setup, Reconciliation.
• Involved in importing and exporting data, deriving variables and creating analysis datasets from raw data.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions
• Designed and developed Project document templates based on SDLC methodology.

Environment: Microsoft Office Suite, Bloomberg, MS Visio, Oracle,MS Access, MS Project, MS Excel, Windows XP, DreamWeaver, RDBMS, SQL, PLSQL, XML, IBM,VB.

Confidential

Business Analyst

Responsibilities:

• Worked on multiple projects in theCredit Riskand Corporate Banking Department
• In theBanking project I was involved in the development of aCredit risk analysissystem which is a management-reporting tool to provide information about the capital usage and the respective limit variances, for Confidential India, based on the rules of theBanking committee. The scope was to build a Data Ware House/ETL Tool which and monitors the various liquidity risks facing the bank such that there is no unwarranted contingent liability exposure and blocking of capital required under minimumcapital adequacynorms of Basel II.
• In thePrivate Banking Departmentprimary function of project was to automate the Consumer Loan Origination Process beginning with the customer initiation to title transfer. The system performs all the business functions of the loan process such as set-up Account Information, New Loan set-up, and Credit, Income and Title functionalities.
• Prepared consolidated financial models, valuation analysis using Net Present Value (NPV) & Total Cost of Ownership (TCO) models.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including loan Backed Securities, Loan Monitoring and Asset Management & Asset Backed Securities.
• Analysis to retire OfflineDerivativeExposure calculation engine and help onboard those trades to Online Systems so that firm can qualify for Basel II guidelines.
• Perform analysis on data for - Loans,Derivatives, Banking Book Bonds, Securitization, IR Swaps, Currency Swaps, Credit Derivatives and FX Forward.
• Extensively used Financial Systems segment tool data exchanges which provides solutions that automate the business processes associated with trading, managing investment portfolios, and accounting for investment assets; and address the processing requirements of various users.
• Performed extensiveauditing, quality checking, and data review to identify the changes needed to be made to the firm’s Risk Shifting Calculator and Securities Exposure Calculator.
• Extensively worked with the business users in defining theBasel rules.
• Worked closely with thePMOto managemilestone trackerto trace & deliver in a scheduled timeframe.
• ConductedJAD sessionsto allow regional stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Extensively worked on creating BRD, FRD & any required Change requests
• Identified and created all necessaryBusiness Use Casesfrom requirements, createdUML DiagramsincludingUse Cases Diagrams, Activity Diagrams and Sequence DiagramsusingMicrosoft Visio.
• Understood the business logic, User Requirements and test-objectives to developtest plans,test cases,and test case executionusingTest Director.
• Tested the applicationmanuallyby executingTest Cases.
• Performed all kinds of testing includingregression, system,integration, end to end, smoke, functional, backend, front end testing.
• Participated inBug-Reviewmeetings with softwaredevelopers,QAengineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Extensively supported business users to analyze any production issues and resolve them working with the IT team
• Conducted & coordinatedUAT (User Acceptance Testing)with regional users to make sure that all the user requirements are catered by the application.

Environment: Windows, Oracle, SQL, Microsoft Office suite, Business Objects, Microsoft Visio, Clear Quest, Test director, UML.