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.

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

Business/Data Analyst

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