SUMMARY:

• With Over 7 years of experience in Business/Data analysis, business requirements modeling and development of Web Based, and Client/Server applications in diverse business domains of Banking Sectors.
• Proficient in gathering and converting User Requirements into Business Requirements and Functional Requirement Specifications (FRS) and use Modeling tools like Rational Rose and Microsoft Visio for requirements modeling.
• Have experienced as Business Analysis, with cross functional experience in Real Estate and Financial services industry with Investment Banking, Asset Management, Portfolio management, Trades Lifecycle and Brokerage service
• Knowledge in broad range of financial practices and principles ranging from financial analysis, corporate valuation, equity/capital market research, financial modeling, forecasting, and budgeting to trend analysis, investment banking, asset allocation, portfolio management, risk analysis and derivatives.
• Solid understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT), Extreme Programming (XP), and Object Oriented Analysis (OOA).
• 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
• Familiar with SOX Compliances and Basel II standards. Worked on data analysis of Mantas - Anti-Money Laundering (AML) Compliance data and supported user requirements.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Participation in the Credit Risk Analysis like Estimation of PD, LGD and EAD.
• Expertise in using SAS output delivery system (ODS) functionality for reporting.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Excellent understanding of Data Models and Information Architecture and sound skills in SQL.
• Experienced in developing reporting application using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL and DB2 database.
• Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions.
• Experience with data migration (ETL development), document data manipulation processes and scripts

TECHNICAL SKILLS:

Databases: MS Access, MS SQL Server 7.0, My SQL

Automation tools: WinRunner, LoadRunner, and Rational Suite.

Defect Tracking tools: Rational Clear Quest, Test Director and Mercury Quality Center

Modeling tools: UML, Rational Rose,oops, MS Visio, Rational RequisitePro

BI Tools: Crystal Reports, Business Objects.

Programming: C, SQL, Java, Oracle, VB, TSL, SQABasic.

Operating Systems: UNIX, SWFIT, Windows NT/95/98/2000 & XP

MS Office Tools: Ms-Excel, Power Point, Word, MS-Access

Database Tools: DB Visualizer, TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Business/Data Analyst

Responsibilities:

• Analyzed the system from both Technical and Business perspectives and prepared Business Requirement Document (BRD).
• Followed the RUP (Rational Unified Process) methodology for elicitation and representation of requirements.
• Contributed in defining the scope of the project and defined functional specifications.
• Analyzed and documented the system specifications, Business requirements; used the tool DOORS for documenting, tracking and analyzing the requirements.
• Maintained benchmark controls to policies, company standards and contracts, performed vendor sourcing, pricing and contract negotiation, performed procurement, ensured compliance with service/joint interest contracts.
• Interacted with Business Owners, Users, and Stakeholders to identify Business System Needs, evaluated solutions for business problems, and prepared Business Requirements Document (BRD).
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• Was actively involved in the design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.
• Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds using Informatica PowerMart, PL/SQL.
• Supported Chief Compliance Officer in tracking, reporting, and maintaining all records relative to BSA/AML program including writing and updating guidelines and procedures and standardization of operating procedures.
• Conducted and participated in JAD/JAR Sessions periodically with various Subject Matter Experts at various phases of the Development Life Cycle to discuss open issues and resolve them.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Worked extensively with SME in understanding and documenting their requirements pertaining to monitoring changes and portraying a trend to maintain and analyze customer needs and many other business areas.
• Analyzed the Data Entity Relationships and worked on Functional Requirements Document (FRD).
• Analyzed and studied Credit Card process and regulations to be complied for card services in detail.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering.
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
• 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.

Environment: Windows XP, Oracle/SQL Server 2000, SQL, Tele logic DOORS 8.1, Tele logic System Architect 10.6, Mercury Quality Center, Cobol,RUP, UML, MS Visio, MS PowerPoint.

Confidential, Williston, VT

Responsibilities:

• Gathered Business Requirements. Interacted with the Users, Designers and Developers, Project Manager and SME’s to get a better understanding of the Business Processes, and Analyzed and optimized the process.
• Utilized Commercial Lending banking application and was responsible for the design and process flow of the system.
• Analyzed requirements for loan request, loan process, member services, processing and portfolio management.
• Updating the internal anti-money laundering software by monitoring anti-money laundering (AML) activity
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• ETL process design, implementation and performance tuning (SQL, Teradata macros and stored procedures).
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines
• Gained deep understanding of US GAAP and IRS regulations.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Created the User Acceptance Test Plan and conducted the user acceptance testing (UAT) for the final confirmation of the project from the Business and SME.
• Creating and maintaining the Traceability Matrix of scripts that needed remediation as part of the data conversion effort.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• 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.
• Responsible for scheduling meetings with users, SME’s and stakeholders to identify problems resolve issues and improve the process to ensure a stable and accurate solution.
• Involved in assisting the development of functional requirements, static testing the applications by preparing and developing the Test Plans and Test Rules, editing and writing Test Cases, Test Scenarios and Test Scripts.
• Implemented Actimize Anti-Money Laundering (AML) system to monitor suspicious transactions and enhance regulatory compliance.
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Executed the test cases manually for various job submissions in batch processing by using the Test Director/Mercury Quality Center.
• Did the regression testing using pre-existing test cases besides integration testing of various modules of the application.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment

Environment: RUP, Rational Requisite Pro, IBM Rational, Clear case, Clear Quest, Data warehouse, UML, Oracle, Unix, XML, MS Project.

Confidential, Ionia, MI

Business Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with SunGard's Capital Markets and Investment Banking solution.
• Strong experience in Object Oriented Programming (OOPS) concepts.
• 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.
• Converted Business Requirements to the Functional Specification and Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Conducted JAD sessions with SMEs and technological experts to gather data requirements such as securities pricing, corporate actions, trade and custodial data.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Created test scripts and plans for UAT Phase
• Managed risk-based audits, due diligence and governance of new initiatives and compliance (AML (Anti-Money Laundering), SOX, Basel II, GLBA, PCI) programs to mitigate risks
• Helped IT developers design the service oriented architecture (SOA) for the application based on the available resources, and the business requirements.
• Organized and conducted extensive JAD sessions with users to identify, understand and document requirements.
• Schedule SMEs for Business Process Validation Meetings
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Designed and developed Project document templates based on SDLC methodology.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle. Utilized Commercial Lending banking application and was responsible for the design and process flow of the system.

Environment: Microsoft Office Suite, MS Visio, MS Access, MS Project, MS Excel, Windows XP, DreamWeaver, Oracle, SQL, PLSQL, XML, VB, ASP.Net, SWIFT, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner

Confidential, Oklahoma City, OK

Business/Data Analyst

Responsibilities:

• Worked as a Business analyst for developing a Microsoft .NET-based loan origination application that handles all the complex tasks of loan origination, including credit request, credit underwriting, loan approval, facility booking, and credit administration processes through the entire development process.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Formulated functional specifications based on business requirements, inclusive of a logical data dictionary, future-state use case documentation, wire-frames, and data conversion/mapping specifications
• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting
• Using Shared Containers and creating reusable components for local and shared use in the ETL process
• Reconciling General Ledger accounts. Assisted with audit defense, Sarbanes-Oxley 404 compliance, research tax issues as they arise.
• Extensively used the UML methodology to create various use case diagrams for the system.
• Authored Use cases, Business Requirement Documentation, and System Requirement Change Request.
• Met with report users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
• Analyzed, Evaluated and assessed gaps in the current processes.
• Facilitated JAD sessions to expedite the processes of data mapping
• Negotiated with vendors in the required areas in terms of tasks performed
• Gathered requirements from business users and tracked them using Rational Requisite Pro.
• Conduct extensive analysis on security trading cycles; provide consulting on financial disclosure, regulatory and compliance issues
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Identified and clearly defined functional issues and supported IT development staff throughout the design, development and testing efforts.
• Worked with technical teams to research and advice on alternative technical solutions to address critical/major business issues and opportunities
• 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.

Environment: Rational Requisite Pro, IBM Rational, Clear case, Clear Quest, Data warehouse, UML, Oracle, XML, MS Project, SQL Server 2000, Rational Suite, MS Office

Confidential New York, NY

Business Analyst

Responsibilities:

• Analyzed the system from both Technical and Business perspectives and prepared Business Requirement Document (BRD).
• Followed the RUP (Rational Unified Process) methodology for elicitation and representation of requirements.
• Contributed in defining the scope of the project and defined functional specifications.
• Analyzed and documented the system specifications, Business requirements; used the tool DOORS for documenting, tracking and analyzing the requirements.
• Interacted with Business Owners, Users, and Stakeholders to identify Business System Needs, evaluated solutions for business problems, and prepared Business Requirements Document (BRD).
• Was actively involved in the design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.
• Gathered requirements and prepared Use Cases (General System Design documents and Detailed System Design document) by interviewing tax agents, users and clients.
• Extensively involved in data modeling
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Developed requirement reports for day-to-day retail banking needs for opening account, online banking using rational SoDA.
• Organized and conducted extensive JAD sessions with users to identify, understand and document requirements.
• Incorporated Data Acquisition, Data Privacy, Data Analysis, Data Mapping and Data Compliance rules in the auditing criteria.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Analyzed the Data Entity Relationships and worked on Functional Requirements Document (FRD).
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering.

Environment: Windows XP, Oracle/SQL Server 2000, SQL, Tele logic DOORS 8.1, Tele logic System Architect 10.6, Mercury Quality Center, Cobol,RUP, UML, MS Visio, MS PowerPoint.