SUMMARY

• Over SEVEN years of comprehensive experience in the field of Information Technology as Business System Analyst, covering areas like Business Process Design, Object Oriented Analysis, System verification and validation in diverse fields such as Banking and Finance.
• Demonstrated excellence in project planning, business analysis, process management, contingency planning, change control and root cause analysis.
• Familiarity in Rational Unified Process (RUP) methodology, use cases, Software Development Life Cycle (SDLC) processes and (OOAD); Object Oriented Analysis and Design. Gathered system requirements from user groups, worked with the users and programmers to produce functional requirements.
• Methodologies: experienced with rational unified process (RUP), agile (Scrum) software development, waterfall methodology, six sigma standards and UML.
• Proven communication and exceptional people skills helped being a liaison between clients, SME, programmers and end users. Coordinated workshops, stakeholder communication sessions, and documentation gathering for multiple projects.
• Possess sound understanding of the financial industry including the Banking and Mortgage Industries. Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail and Formulae's etc.
• Experience in asset management and purchasing.
• Outstanding communication skills and ability to work effectively with technical teammates in order to translate business requirements into an effective technical solution and serve as an effective communication channel between the key IT personnel and business contacts Portfolio Analysis, Mortgage Loan Servicing, Mortgage loan origination, Asset management, Operational Risk.
• Business writing skills in writing Business requirements document (BRD), Use - Case Specifications, Functional Specifications, Systems Design Specification (SDS), and Systems Requirements Specification (SRS). Experience in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.
• Successfully designed, implemented and delivered a Reporting Solution infrastructure for the Banking division using Cognos tool. Created documents for validation and verification against business unit requirements.
• Extensive experience in gathering business and application requirements, business processes, identifying risks, impact analysis, UML modeling, sequence and activity diagrams using Rational Rose and Microsoft Visio.
• Expertise in UML implementing use case model, analysis model, design model, implementation model, use case diagrams, behavior diagrams and class diagram. Experience in creating and maintaining the requirement traceability matrix (RTM) & software requirement specifications (SRS). Created milestones which clearly defined the goals and able to track progress of projects using RUP methodologies.
• Worked with test teams to develop test scripts and ensure the testing results correspond to the business expectations. Strong experience in developing test plans; build test conditions and test cases, creating test data, analyzing bugs, interacting with development team members to fix defects.
• Strong knowledge of business intelligence, data warehousing & business architecture.

TECHNICAL SKILLS

Process/Modeling Tool: Software Development Life Cycle (SDLC), MS Visio, SnagIT.

Methodology: UML, RUP, Agile, Business Modeling.

Databases: MS Access, SQL Server, Oracle.

Operating Systems: WINDOWS 98/2000/NT/XP, UNIX/LINUX.

Office Tools: MS Office, Word, Excel, PowerPoint, Access

Project Management: MS Project, SharePoint.

ETL Tools: SQL Server Integration Services, Cognos, Enterprise Reporting.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Oracle Report Developer/System Analyst

Responsibilities:

• Extensively work with Toad for Oracle 10.6 to create and automate all the executive reporting. Designed complex reports with Charts and input comparison, also made calculations for future forecast for day over day completion and approval of loans.
• Working with an Agile, Scrum methodology to ensure delivery of high quality work with monthly iteration.
• Improved existing report’s ability by making efficiency of code and reduce cost and timing. Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
• Created report thru MS excel as well and use pivot tables to run report faster and accurate. Extensively work on BoW (Book of Work) to track down all the business request and status. Worked as a lead for the decommissioning of various schema and created new tables to more centralized data.
• Designed a dashboard for the SME’S and VPs to get data and compare data in easier way. Designed Transformer cube models using reports modeled according to user needs. Extensively work on the reports with Hurricane Sandy affected areas from Foreclosure Side.
• Created Reports to evaluate the business performance based on various financial indicators. Gathered business requirements through interviews, surveys, prototyping and observing from Business Unit and UI (User Interface) of the existing Fidelity Lending Portal.
• Developing automated reports based on Business Requirement by TOAD 10.6. Responsible for working with development team on Web form and related issues. Conducted controlled brainstorming sessions with project focus groups.
• Interacted with SME’s, Directors, Risk Management Group and Corporate for overall understanding and need of the system. Was able to fine tune the business rules with inputs. Analysed and prioritized user and business rules as system rules that must be included while developing the software.
• Modified the workflows to event tracking and suggested adjustments to the flow to improve the efficiency.
• Conducted Joint Application Development (JAD) sessions for requirements gathering with Business Stakeholders, SMEs, Users, refined it using Wireframes, Story Board Sessions, Context Diagrams, Use Case Diagrams and made conceptual illustrations.
• Scheduled meetings with data analysts, developers, System Analysts to explain the business needs and fine tune the requirements. Interacted with IT, Vendor group and SMEs for scope validation. Analysed and researched the necessity of the change and made sure the change is beneficial in long term.
• Made recommendations to improve the current application performance depending on time limitations and capacity constraints with the aid of SCRs (Scope Change Requests).
• Authored progress and completion reports, which were then submitted to project management on a weekly basis. Prepared Test Strategy, Test plans and test cases for testing. Coordinated with different departments and the vendor group to plan User Acceptance Testing.
• Prepared Test cases and test data for Users. Documented and tracked the defects found while in the testing phase and close them in time. Collaborated with the training department to provide users with training on the enhanced functionality and tools newly built.
• Conducted training sessions to familiarize users with system.

Environment: s:Toad for Oracle10.6, MS Excel, Pivot, MS-Outlook, Windows XP, BAU & SharePoint, HP Quality Center.

Confidential, Boston, MA

Lead Business Analyst\Enterprise Report Developer

Responsibilities:

• Responsible for Gathering Requirements from the SMEs, Portfolio Managers and Technical Team to produce Business and Functional Requirements for reference data CSM (Company Security Master). Facilitated business users in identifying data and tools required to regulate financial markets.
• Involved in Installation and Configuration of all products of Business Objects. Worked with reference data from BLOOMBERG, S&P, MOODY, FITCH etc on ETL model for WMC. Conducted Requirement analysis and Design Walkthroughs with the developers and management.
• Created an agile development and release process, influenced server test organizations to adopt automated deployment to complement our testing, and drove creation of an automated build/release process.
• Prepared detailed Business documents, supporting both the Web and Publications Content Life Cycle for Documentation Management. Communicate Project Requirements, Business Issues, Solution and made recommendation.
• Assisted in conducting studies, investigating the latest technology developments and analyzed the impact of current and future system requirements. Participated in release smoke testing and sniff test case creation.
• Executed test cases for different project thru out release life cycle. Validate and co ordinate test results from QA team. Produced System Diagrams, Business Requirements, Functional Specification, Use Case Realization Documents, Workflows and other documentation as required for Project Analysis, Planning and Design.
• Prepared Use Case Models based on Business Requirement documentation gathered through interaction with users. Worked on all life cycles of reference data including customer service, default management, cash management, Investment reporting.
• Conducted JAD/RAD Sessions for understanding the workflow. Involved in writing Test Plan in accordance with the business requirements. Created Technology Evaluation Matrices to provide best-fit solutions to customers.
• Managed critical paths and bottlenecks in conjunction with Project Tracking Reports for Senior Management. Increased process efficiencies and reduced development cycle time across department by spearheading the implementation RUP methodology.
• Performed Project Management activities to maintain the Business Workflow and coordinate the project as a whole. Made Presentations for Senior Managements and Business End Users. Participated in Weekly Meeting with the management team, development teams and Walkthroughs.
• Gathered business requirements through interviews, surveys, prototyping and observing from Business Unit and UI (User Interface) of the existing Portal System. Developing automated reports based on Business Requirement by Enterprise Reporting.
• Headed the team of Enterprise report Developers, developed the reports as well as got them done by team on time for the releases. Responsible for creating all test plan, test cases, Implementation Plan, Requirement Specification and User cases.
• Working as a Lead Analyst to support Fixed Income with Onshore and Offshore Team. Have Extensive Knowledge of PL/SQL and UNIX as a part of Report Development. Extensively worked with developing reports using Oracle Report 6.0/6i/9i/10g/11g.
• Developed screens and reports using Oracle Forms 10g/Reports 10g. Also developed reports using Pro*C and PL/SQL. Strong programming and debugging skills in PL/SQL, SQL, Dynamic SQL, C, C++, Pro*C, UNIX shell scripting. Developed stored packages with Oracle's Web Toolkit.
• Responsible to support the issues with reports on the oracle enterprise environments (Development, UAT, Test and Production) Responsible to trouble shoot problems incurred on parameter tool communication to Enterprise System.
• Responsible to make sure Email, FTP and unmanaged Disk options of scheduling are always up and running. Conducted controlled brainstorming sessions with project focus groups. Interacted with SME’s, Directors, Portfolio Managers and Corporate for overall understanding and need of the system. Was able to fine tune the business rules with inputs.
• Created Objects and prepared Reports like financial reports, HR reports, standard and adhoc reports, and universes. Responsible for Weekend Support with IV (Investment View) monitor and other weekly deployment Activities.
• Worked as a primary source for offshore task and offshore team interaction. One of the development resources for KB (Knowledge Base) Analyser. Work with Accurev and Dataflux. Responsible for all Dataflux job deployment and new release.
• Actively work on Quality Centre for creating TD and also for testing purpose. Responsible for ER Portal administrator to keep it synchronised and always have a faster support for users. Analysed and prioritized user and business rules as system rules that must be included while developing the software.
• Modified the workflows to event tracking and suggested adjustments to the flow to improve the efficiency.
• Conducted Joint Application Development (JAD) sessions for requirements gathering with Business Stakeholders, SMEs, Users, refined it using Wireframes, Story Board Sessions, Context Diagrams, Use Case Diagrams and made conceptual illustrations.
• Scheduled meetings with data analysts, developers, System Analysts to explain the business needs and fine tune the requirements. Interacted with IT, Vendor group and SMEs for scope validation. Analysed and researched the necessity of the change and made sure the change is beneficial in long term.
• Made recommendations to improve the current application performance depending on time limitations and capacity constraints with the aid of SCRs (Scope Change Requests). Authored progress and completion reports, which were then submitted to project management on a weekly basis.
• Prepared Test Strategy, Test plans and test cases for testing. Coordinated with different departments and the vendor group to plan User Acceptance Testing. Prepared Test cases and test data for Users.
• Documented and tracked the defects found while in the testing phase and close them in time. Collaborated with the training department to provide users with training on the enhanced functionality and tools newly built.
• Conducted training sessions to familiarize users with system. Work with test teams to develop test scripts and ensure the testing results correspond to the business expectation. Maintain Report Inventory and Write, Update and Execute Implementation Plan and Test Plan.
• Participate in the team meetings to discuss the issues arising out of Reports. Responsible for creating SOP (Standard Operating Procedure) for all Enterprise Reporting issues.

Environment: s:Enterprise Report- Report Administrator 4.0, MS-Outlook, SnagIT, Enterprise Reporting Portal, SharePoint, ClearQuest, HP Quality Center, Accurev, Dataflux, IV- Investment View Recons, KB Analyzer, PL/SQL, UNIX.

Confidential, Boston, MA

Business Analyst/ Cognos Developer

Responsibilities:

• Installation of Cognos 1.1 BI Series- Report Studio, Query Studio and Framework Manager, setting Cognos configuration and integrating the different components. Installed Cognos 1.1 BI Series in an interim environment and developed a proof of concept.
• Design, development, version control of Packages using Report Studio. Designed relational models using Report Studio and deployed packages to the Cognos connection. Designed Cognos 1.1 Transformer cube models using reports modeled according to user needs.
• Created customized BI reports linking various databases, to meet the user requirements Created standard and Ad hoc reports using Cognos Report Studio. Created Reports to evaluate the business performance based on various financial indicators.
• Created Query Prompts, calculations, Conditions and Filters, Prompt Pages using Report Studio. Created Lists, Groups and Cross-tab reports with drag and drop functionality. Developed Templates, standard Reports and Multilingual Reports using Report Studio and Query studio. Provided training on Query Studio to create Ad-hoc Reports.
• Developed complex reports with Drill through capabilities. Created user classes and roles and worked with Cognos Support team to enforce security. Gathered business requirements through interviews, surveys, prototyping and observing from Business Unit and UI (User Interface) of the existing Broker Portal System.
• Developing automated reports based on Business Requirement by Cognos 1.1. Participating as a lead tester for SSgA in Open Pages migration from 5.5 to 6.0 releases. Responsible for creating all test plan, test cases, Implementation Plan, Requirement Specification and User cases.
• Working as a Open Page Administrator for support to Global team. Responsible for working with development team on Web form and related issues. Conducted controlled brainstorming sessions with project focus groups.
• Interacted with SME’s, Directors, Risk Management Group and Corporate for overall understanding and need of the system. Was able to fine tune the business rules with inputs. Analysed and prioritized user and business rules as system rules that must be included while developing the software.
• Modified the workflows to event tracking and suggested adjustments to the flow to improve the efficiency. Conducted Joint Application Development (JAD) sessions for requirements gathering with Business Stakeholders, SMEs, Users, refined it using Wireframes, Story Board Sessions, Context Diagrams, Use Case Diagrams and made conceptual illustrations.
• Scheduled meetings with data analysts, developers, System Analysts to explain the business needs and fine tune the requirements. Interacted with IT, Vendor group and SMEs for scope validation. Analysed and researched the necessity of the change and made sure the change is beneficial in long term.
• Made recommendations to improve the current application performance depending on time limitations and capacity constraints with the aid of SCRs (Scope Change Requests).
• Authored progress and completion reports, which were then submitted to project management on a weekly basis. Prepared Test Strategy, Test plans and test cases for testing. Coordinated with different departments and the vendor group to plan User Acceptance Testing.
• Prepared Test cases and test data for Users. Documented and tracked the defects found while in the testing phase and close them in time. Collaborated with the training department to provide users with training on the enhanced functionality and tools newly built.
• Conducted training sessions to familiarize users with system. Work with test teams to develop test scripts and ensure the testing results correspond to the business expectation. Maintain Report Inventory and Write, Update and Execute Implementation Plan and Test Plan.
• Participate in the team meetings to discuss the issues arising out of Reports. Supporting OpenPages System globally (NA, EMEA and APAC). Also active member for OpenPages migration from version 5.5 to 6.0. For this migration represents SSgA.

Environment: Cognos 1.1, MS-Outlook, Windows XP, OpenPages 5.5, BAU & SharePoint, ClearQuest.

Confidential, Chicago IL

Business Analyst/Oracle Developer

Responsibilities:

• Facilitated JAD sessions to collect requirements from system users and prepared business requirement that provided appropriate scope of work for technical team to develop prototype and overall system. Developing Automated reports based on Business Requirement by Oracle Report Developer.
• Migrated Oracle Forms using oracle 10g.
• Wrote test plans and test cases based on the business requirements which involved market risk analysis and risk management like continuous time finance & asset pricing, stochastic processes & simulations, credit derivatives, structured products, documentation, value at risk, risk & return optimization.
• Supply real time asset updates to Senior IT management Developed an Integrated Trading System for equity and derivative trading and risk management system for OTC securities. Identified processes for developing and documenting detailed business requirements. Data was collected from end-users, and analysts.
• Created Use-Cases and Requirements documents to document business needs. Requirements were gathered through interactions and meetings and periodic walkthroughs with loan analysts, credit analysts and other potential users of the application.
• Develop, implement and report metrics on all IT purchases and asset management. Conducted Use-Case reviews and identified gaps, leading to improvements/enhancements in the same. Created and maintained the Requirements Traceability Matrix (RTM).
• Worked with the Project Manager on various Project Management activities like keeping track of Project Status, Deadlines, Environment Request, and Compliance Issues. Used Advanced lending solution to verify the customer credit line.
• Ensured Use-Cases were consistent and covered all aspects of the Requirements document. Maintained the Business Impact Analysis Template (BIAT) to analyze and document the effect of proposed changes on the project schedule and costs.
• Used Rational Clear Quest for bug reporting. Was responsible for tracking issues that are detected and updating the status of existing issues based on the daily meetings with the off-shore team. Identified and analyzed the data requirements for the various site teams and made sure that the required data is available in the testing environment.
• Worked directly with software engineers to ensure clear communications on requirements and defect reports. Followed the RUP methodology for the entire SDLC. Validated the scripts to make sure they have been executed correctly and meets the scenario description.
• Involved in project status meetings, QA review meeting, and System Test meeting. Wrote test cases and test scripts for the User Acceptance testing. . Design, write and maintain data requests and/or queries to support the business.
• Identify data process improvements and leverage technology to automate and streamline existing processes. Assist in the development of ad-hoc reports or presentations as needed by senior management.

Environment: JAVA, Oracle, Windows NT, UML, Requisite Pro, MS-Visio, Rational Clear Quest, Cognos, Ms access, ms visual basic.

Confidential, Virginia

Oracle Report Developer/Business Analyst

Responsibilities:

• Ability to produce clear documented and commented code. Experience in Oracle database design and development. Proficiency in SQL, PL/SQL and JSP Development experience in Configuration models, rules, and extensions.
• Analyzed surveys of actual users and gave technical inputs in Business meetings. Monitored progress of foreclosure through liaison with attorneys including an analysis delinquent steps, sales results, closed accounts and unacknowledged new referrals.
• Held meetings with business process owners, SME (subject matter experts) and the marketing team for requirements gathering during the Definition Stage. Created technical documents for software and hardware architecture.
• Contributed to the user interface design team for the Intranet. Created functional specifications documents based on customer requirements Compiled the Requirements, developed the Process Model and detailed business policies, and modified the business requirement document.
• Created use cases, activity, class diagrams and workflow process diagrams. Validated the business requirements and the business scenarios. Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Created Logical data modeling for production database and data warehousing Projects using Erwin Tool. Created the Physical Database design for production and data warehousing project. Played role in design of scalable, reusable, and low maintenance ETL templates
• Worked closely with project stakeholders to formulate a strategy for UAT. Defined data requirements for testing effort and made data requests to the appropriate database team. Involved myself in functionality and regression testing during the various phases of the development.
• Validated the system end-to-end testing to meet the Approved functional requirements Created technical documents and led Power Point/Visio presentations for the development of financial and technical applications for the purpose of the departmental user base and for audit.
• Analyzed team performance with the QA manager and implemented the changes (if any) in order to improve the efficiency of the entire team. Participated in the team for user acceptance testing.

Environment: s: SQL, Clear Quest, Rational Test Manager, Microsoft Visio, Requisite Pro.