SUMMARY

• Information Technology consultant Nine years of experience in the analysis, design, development, testing, and implementation of client/server and web - based applications under various platforms and environments.
• Good domain knowledge and work experience in Finance Domain in the areas of Wealth Management, Asset Management, Risk Management, Portfolio Management and Investment Banking, Retail Banking, Credit Cards/Regulatory experience, AML, Insurance, Mortgage, Claims and Financial services.
• Good understanding of ITIL Processes, Change management, Project Process, Upstream and downstream server and ability to analyze business problems and identify solutions.
• Strong knowledge of Client’s business strategies, up and down stream business processes, and organizational objectives and the easiness to embrace new changes.
• Experience working with different methodologies such as Waterfall, RUP and Agile.
• Worked extensively through Agile development methodology by dividing the application into iterations.
• Proficient in using Agile Scrum methodologies, performed roles of Scrum Master following sprint/standup sessions and used Excel extensively to write user stories, analyzed the Iteration Burn Down charts and reviewed defects.
• Strong experience with Scrum methodology and well versed in writing user stories.
• Expertise in analyzing and creating Business Process Modeling, Use Cases and implementing UML diagrams for both Structural and Behavior diagrams like Use Case Diagrams, Class Diagrams, Sequence Diagrams, Activity diagrams using BPMN, MS Visio and Rational Rose.
• Experienced in the documenting High Level Design, Flow diagram, mapping and technical specification documents for BI applications.
• Extensive working experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Experience in Database Design, Entity-Relationship Modeling, Dimension Modeling, Star Schema & Snowflake with Kimball methodologies.
• Experience in Hyperion Essbase Application Manager modules; Outline Editor, Report Editor, Calc Script Editor, and Data Prep Editor.
• Extensive experience in creating Screen Mockups and Wireframes, conducting GAP Analysis and Impact analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Expert in Tracking and Managing the Requirements using Requirement Traceability Matrix (RTM) that controls numerous artifacts produced by the teams across the deliverables for a project.
• Has perfect blend of both business and technical knowledge of the various applications worked on in the Finance Domain.
• Analytical, methodical and resourceful approach to Problem Solving, Root-Cause Analysis, Conflict Resolution, Negotiation Strategies and providing corrective actions to meet business requirements.
• Valued contributor who performs confidently and effectively under pressure and thrives on challenge.
• Excellent communicator and good listener and heed.
• Analytical, methodical and resourceful approach to Problem Solving, Root-Cause Analysis, Conflict Resolution, Negotiation Strategies and providing corrective actions to meet business requirements.
• Enjoy challenges with projects that require notable analytical skills, enthusiastic learner, can master new concepts quickly and an interest to progress in this fast-paced, technology- driven business environment.

TECHNICAL SKILLS

• MS-DOS, IBM PC & COMPATIBLES
• UNIX, TCP/IP, LAN/WAN
• Mainframe,LINUX
• JAVA, JAVA SCRIPT, JSP, XML, HTML, DHTML, CSS, VB SCRIPT, SQL, TSQL, PL/SQL, COBOL
• SQL SERVER 7.0/2000, MySQL, MS-ACCESS 97/2000, MAINFRAME (ODS, CIS, CAMS)
• Advanced MS Studio, MS Visual Studio, TOAD, MS OfficeVISIO (Drawing)
• Business ObjectsPAC Tool (Change Management), AUTOSYS,PHOTOSHOP,SNAGIT, DOORS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst

Responsibilities:

• Project Scope was to integrate the different policies into one front end application by providing an efficient and smooth customer experience along with the implementation of secured identity verification process.
• Part of the SWAT Team, basically acts as the Business Side of Proofing Team and SME in the Proofing Process procedures serving as a go-to person for providing the business support related to Proofing.
• Worked closely with project managers, business users and developers to formalize a business idea and define requirements using rational requisite pro.
• Emphasis on requirements gathering through research, formal-informal sessions, JRP sessions and JAD sessions with SMEs (subject matter experts), Teams, Stakeholders and end users.
• Successfully used Agile/Scrum Method for gathering requirements for the browsers and Mobile (Iphone, Android, Blackberry) compatibility and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
• Functioned as the primary liaison between the business, vendor operations, and technical groups throughout the project cycle
• Conducted extensive research on various latest Proofing and verification solutions offered across the board.
• Was part of daily Scrum work meetings and weekly Sprint project progress meetings and tested the mobile applications and created defect tickets if any.
• Facilitated design negotiation and decision making between application teams (Master Data Management (MDM) (Product Creation) > Content Management (Offer Management) > Integration Hub > Data Warehouse andBusinessIntelligence (Metrics Reporting)).
• Worked as the key person in preparing the reports and monitoring stats in the morning of enterprise wide deployment.
• Participated in SPRINT review and planning meeting and organizes SCRUM meetings as Scrum Master and PO to monitor backlog items and review/update the SCRUM if needed.
• Coordinated with the test team to check the weekly status and report the same to the project manager.
• Have created UML diagrams, Structural and Chevron diagrams for Proofing process from its inception to delivery and shared it with dependent stakeholders, Business users, executives, Project team and Call Center for KI’s and KA’s purposes.
• Worked with business users to obtain requirements and design, build and deploy new Brio reports in Windows environment.
• Created tabular, non-tabular, master/detail system independent portable reports along with graphs and charts to present data in visual terms.
• Published reports in the Hyperion performance Suite and give access privileges to various user groups.
• Using functionality of Hyperion Interactive Reporting (Brio) and SQR production reporting, created personalized dashboards and report queries and performed detailed analysis using pivots and charts.
• The existing solution was using cloud based tools, suffering from fragmentation issues, solution developed allowed for the mapping of their current processes using BPMN and then the streamlining of their processes, as well as implementing integrated solutions from third party providers into the same platform. This resulted in a much faster turnaround time.
• Developed the strategy and plan for, automation of offer management and integration with digital product master data in order to support centralized metrics reporting.
• Gathered requirements, developed solution, managed application development, and data conversion and initialization across multiple environments (Master Data Management (MDM) (Product Creation) > Content Management (Offer Management) from requirements through stabilization.
• Provides 3-tier support for the IDV app, assisting the Call reps, Tech team, SWAT team for any troubleshooting for the application, outages by working with the vendor.
• Participated with various teams after implementation to upgrade Data Quality to Data Services, with data and multiple country address cleansing as per meeting the legal/compliance guidelines.
• Conducted a lead research on different technologies for other major insurance companies and participated in surveys in various cities, and prepared the SWOT Analysis, Risk Assessment and Vulnerability documents.
• Elicited, gathered and documented non-functional requirements as part of the requirements definition activity, and evaluated several COTS (Commercial off the Shelf) Systems as part of the Solution specification.
• Led teams of business and technical analysts in the collection and documentation ofbusinessand technical requirements gathering for the development of MDM, UML Diagrams and techniques, Data Warehousing and Reporting implementation roadmaps.
• Liaison/POC with third party vendors to create and maintain interfaces as needed, Manages 3 -tier Proofing, Executive, requests from internal users while troubleshooting issues and clearing tickets in a timely manner from HP Service Manager using SPLUNK etc.
• Prepares hourly, daily, weekly, monthly, quarterly, semi-annual, annual and ad-hoc reports required by both internal and external stakeholders.
• Handed - Off the Proofing FAQ’s, KA’s KI’s for the Stakeholders, Agents, Call Center Reps and other Tier - 1 and Tier - 2 Teams.
• Was a part of SOW process and participated in the meetings with stakeholders and worked on the document which was routed for leadership to be approved.
• Was part of the focus group meetings, research team to determine the latest devices in market wherein the Mobile application would be installed, gathered requirements to make on the compatibility and enhancements to be made with the developers, was part of overall testing done on the android devices.
• Presented White Papers, presentations with the Summary on the research done.
• Assisting my PM in preparing the Time lines by Phases Chart report for the Business Body of Governance around Proofing and worked on the Re prioritization spreadsheet of tasks by conducting meetings with the Project Team.
• Working on three new Proofing BDD/BDS documents by analysing the business needs and identifying problems and discussed with the Project Team, Systems side, Stakeholders and Vendor by conducting a one to one meetings, teleconferences and Web-Ex.
• Assists my PM in project management tasks like creating and maintaining project tasks, scheduling meetings, extensive data analysis on SF and Vendor’s data regarding critical decisions to be made, white board notes etc.
• Worked on BPMN, Visio to create flowcharts as well as using Snag It and other graphics software to create illustrations and screen shots for use in User's manuals, FAQ’s and other documentation shared with the Stakeholders and Systems side of the Project.
• Worked with Archer, HP Service Manager and other in house and vendor tools for audit purposes and for data mapping.
• Studied the Inherent Systems to have clear understanding of the business processes and associate system workflow.
• Clarified and prioritized requirements by conducting brainstorming sessions with the stakeholders and SMEs.
• Created custom calendars using Job Utilities menu to support the events and jobs scheduled to run the IR reports.
• Used Oracle Business Intelligence Enterprise Edition (OBIEE) to build and deliver reports based on OBIEE Data warehousing tables and COTS evaluation and implementation for reporting tool, that resulted in choosing Business Objects
• Primary contact with the vendor to discuss the Proofing applications reports, questions, concerns etc from the executive and also makes sure with SF’s legal and Risk teams on creating VA’s, RA’s and to comply with and abide by all banking policies & procedures, applicable Federal & State Laws and Regulations.
• Other duties that are equivalent in skill may be as assigned as needed.
• Conducted many meetings with the Vendor to discuss the issues found and Act as a primary contact for business partners and serve as a department liaison and established and maintained strong relationships with various business partners throughout Corporate and the Systems Department.
• Has routed the Phase authorization and BDD for sign -off in Notes by the executives, AVP's and prepared Use Case documents and checked in SharePoint to be shared by other DC’s.
• Constructed dashboards to review data validation results and prepared the daily statistics reports from the Vendor tool and Tea-leaf for the Chairman's Counsel.
• Worked in building monitoring templates for critical applications with HP Sitescope and services across the environment to support Event, Incident, and Performance management used by the Command Center, datacenter, application and infrastructure technical teams.
• Used Ariba for creating relevant reports that enabled internal stakeholders, business partners to monitor performance.
• Provides the 3 tier support of Proofing applications for resolving Business side tickets/concerns received from Agents, Call Centers and from other Stakeholders using various in house and vendor tools, HP Service Manager and monitors the Outstanding list in Sharepoint working along with the Tech Team PM.
• Participated in various architectural development sessions to provide technical teams with a better understanding of the requirements.
• Working on the upcoming Phase activities and deliverables by conducting meetings with Project team, working on BDD's by participating in the roadmap and future strategy, budget meetings.
• Part of the group which oversees the day to day cash management, including establishment and maintenance of proper controls over daily cash transactions.
• Part of the Life Product Pilot implementation in the test (lower) and PROD environments.

Environment: Agile Methodology, UML, HP Service Manager, Oracle Report Builder, BI publisher, Splunk, Archer Tool, Tealeaf, SharePoint 2010/13, HP SiteScope, Webcat, In-house tools, JIRA, COTS, BPMN 2.0, Requisite pro, Change Management, Lotus Notes, Oracle DB, MS Family- PowerPoint, Visio, Excel.

Confidential

Business Analyst

Responsibilities:

• Provided solutions to client in order to merge legacy Wachovia system with new Confidential systems.
• Worked as Business/Quality Analyst and coordinate with the onshore/offshore team of 5, providing guidance and solutions to tasks assigned.
• Experienced in Tracking GL for all the posted/unposted transactions in this module and worked closely with Dev team to extract sql scripts from those tables and also made sure GL period status to be opened in order for the GL Tx.n to be moved.
• Built and implemented validation projects to ensure quality data migration, Knowledge and experience with data conversion and loading source data into Hyperion.
• Understanding of mortgage industry guidelines and Federal and state regulations.
• Point of contact during ITE and Production deployment of the ENIN, PF and HAL system.
• Working on the major integration deliverables i.e. HR integration and GL integration
• Experience in preparing and documenting the User Acceptance test (UAT) plan and obtaining the necessary signoffs from the concerned business units and was responsible for security provisioning usingshared servicesacross the entire Hyperion environment.
• Migrated the RPD and Webcat from Dev to Test, experienced with Smartview, Data forms, and Web Forms with Hyperion Security and Task Lists.
• Prepared Traceability Matrix, Functional Requirement documents and design documents based on the requirements gathered from the Finance department of Confidential Advisors.
• Assisted ETL developers in the processes using Informatica tool to load data from Oracle 9i, DB2 into the target Oracle 9i Data warehouse understanding the data points are in line with the business users requirements’.
• Worked on OLAP Tools: Hyperion Essbase 11.x/9.x/7.x - Essbase Integration Service, Excel Add-In, Visual Explorer and Essbase Query Designer and build reports using reporting tools such as Brio and Cognos BI reporting v8.
• Generated Weekly and Monthly Audit Reports for providing status updates also validated user access rights, nationality & permissions, prepared cheat sheets and other documentation for new joiners’ training, for management assistance which include documentation, calc scriptcustomizations, Essbase application components, Smartview, Data forms, Web Forms,Task Lists, Hyperion security, data conversion, identifying alternate hierarchies, steps for loadingsource data into Hyperion.
• Have Updated environment, document, or process based upon audit results when needed.
• Worked closely with System Verification (Systems/Tech Team) and testing group to implement integration between DOORS and HP Quality Center.
• Worked in the IT Department of Confidential, interacted with the Client/Business Users (Finance Department) and have written Training Manuals for ENIN and PFO for the remediation projects.
• Performed rigorous manual testing on ENIN/PFO applications during GL Phase 3 merger and during Windows 7 Remediation by preparing the test cases and coordinating with the developers for replicating the bugs and in fixing them.
• Generated the P/L (Profit and Loss), Accruals, Expenditure monthly Reports and validated and verified them with the PROD and Back end data in PFO app.
• Played an active team member role in successfully deploying GL Phase 2 and 3 merger Projects, and few internal Application level enhancement deployments such as SQL and Database upgrade.
• Leaded the UAT, EUC products, SIT testing for the enhancements on ENIN, PFO applications in the testing and PROD environments.
• Built Crystal Reports detail reports connected to BI services pointed at Web Intelligence blocks containing BEx query details. Reports launched by and received prompts from Xcelsius dashboard
• Interacted with the end users team in understanding the business rules and writing requirement specs, technical specs and pointing documents from staging to data mart, cubes and reporting needs to the end user community.
• Experience in Commercial Off-the-Shelf (COTS) software system implementation in evaluating and selecting COTS solution
• Negotiating terms with COTS vendor, license maintenance (EULA) subscription, and royalty fees
• Leaded the QA Offshore Cognizant team by conducting SCRUM meetings and monitoring performances, conducted Stand up meetings and delegating work as per priority, Performed Smoke, Regression, GUI, UAT Testing and also by exporting the excel to Quality Center and tracking the defects in QC.
• Prepared the base test cases and developed the test cases suite of Day 1 project for Regression, UAT and functional testing at various SIT, ITE (PROD replica) environment testing levels.
• Interacted and set up meetings with the Day1 team, gathering the required information and thereby having KT sessions with the onsite/Offshore QA teams.
• Experience with large scale implementation of Hyperion planning version 11 and higher.
• Created reports UsingHyperion Financial Reporting, SmartView and Excel Add-ins.

Environment: MS Office Suite, BPMN 2.0, JIRA, DOORS, Hyperion Shared Services 11.1.1.3, Requiste Pro, Crystal Reports, Webcat, PAC Tool (Change Management), Quality Center, Oracle GL, Oracle BI publisher, Report Builder, Autosys, Toad.

Confidential, Oaks, PA

Data Analyst

Responsibilities:

• Worked on the Business requirements from vendors, stakeholders and assisted in preparing the Project Charter, budget and scope documents.
• Interacted with Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Prepared Business Requirement Documents (BRDs) after the collection of Functional Requirements, Process models, from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Written detailed business requirements documents (BRD), Functional Specifications Design (FSD) and perform assessment of current OTCderivativesinstruction trade management processes for front, middle and back office.
• Have hands on experience using Ariba tool to automate and streamline the key business processes from trading partner discovery to transaction management till the financial settlement.
• Worked in research team and was engaged to assess digital content management requirements for an ingest, storage, and distribution strategy for the investment solutions we offered.
• Utilized knowledge of Bloomberg’s application to build analytical tools to assist with the identification of funding and investment opportunities.
• Products at the trade level consists of Bonds, equities, repos, bank notes, Euro Medium Term Notes (MTN's), Total Return Swaps, Asian EquityDerivatives, CBBC's, warrants, Barrier Options.
• Interacted with Clients (UK), International business users and onsite team.
• Worked with Team business leads, Confidential, and GWS’s end clients HSBC (UK), Towry EJ, etc on product functionality and enhancement.
• Developed the repository model for the different work streams with the necessary logic that involved creating the physical, BMM and the presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.
• Merged the RPD and the Webcat Demantra Forecast, BBB and existing RPD.
• Worked in team to organize requirements for tax payment management system. Have Conducted formal stakeholder analysis meetings.
• Used interview process with key stakeholders to deliver high level business requirements documentation. Facilitated JAD with broad stakeholder participation. Have Examined in-house development, out-sourced development of standalone and existing ERP systems, Saas and COTS (commercial off-the-shelf) system.
• Extensively worked on Requisite Pro, MS Visio for creating UML diagrams for project documentation.
• Gathered and analyzed requirements coming out of the JAD sessions and created detailed Use Cases based on that information.
• Assisted in the implementation of the COTS reporting tool to integrate it with the existing software
• Was part of the Conduct training team on Confidential products/modules Front Office, Middle Office, Back Office & Operations for commodities trading, risk, supply & distribution and Treasury Management.
• Written many Functional Guides on the various tracks of the Platform for past three major releases and Performed GAP analysis of AS IS and TO BE systems from the previous ones and modeled them for better understanding of the business process.
• Analyze trade processing revaluation and post cash flow to Fortis position-keeping systems for Inflation Swaps, Volume Swaps, Loans CDX, Interest Rate Swaps, Credit Default Swaps, Swaptions, Cross-Currency Swaps.
• Monitored and reviewed all the processes posted for credit card transactions
• Verified transactions through Sales Audit, as appropriate/needed.
• Responded to inquiries and generate dashboards reports for monthly/daily stats
• Works with/through IT to ensure terminals meet proper specifications are coded with merchandise numbers.
• Created cash flow models for Credit Default Swaps, Interest Rate Swaps, Total Return Swaps, Currency Forwards, Cross-Currency Interest Rate Swaps, Equity options, Structured products, Currency Futures, Options, Exchange Traded Funds (ETFs), and indexes on commodity futures, i.e., the Goldman Sachs Commodity Index (GSCI) and the Dow Jones Commodity Index (DJ-AIGCI) and non-dollar Bond transactions on SimCorp Dimension's investment management software; diagram swap accruals, payment cash flows, and settlement scenarios to show gains and losses of hedge and documented how the current applications will be used in the hedge fund initiative.
• Ensured credit card policies and procedures are accurate & upheld and helped to ensure the payment operations is in compliance with various Payment rules & regulations.
• Also led an engagement for one of the world's premier record mastering studios. Assessed requirements, configured and installed IBM's Electronic Music Management System (EMMS) DRM solution's content mastering workstation. The system was used to ingest and prepare world class artists' CDs in EMMS format.
• Leaded the Functional documentation team for the 11.1 and 11.2 release and have conducted the KT sessions to the new team members while moving to Application Support Team.
• Worked as an Asst. Application Support Manager, by handling and leading GWP operations team at offshore, resolving day to day issue of various tracks of Confidential Ops Team.
• Understanding and Creating Business change control documents and providing training to End user, Confidential Ops team offshore on Platform usage.
• Generates ad-hoc financial analysis to assist team with the assessment of market and client developments
• Performed Business Validation, EUC applications and Smoke Validation.
• Guiding technical team on business front & helping them in understanding functionality.
• Worked with pre sales team to make RFPs, client presentations to get new business by preparing the keynote presentations.
• Analyzed Test Plans and Test Cases based on Requirements and General Design Documents involved in both Manual and Automation Testing.

Environment: Webcat, Windows XP, Agile, SharePoint, Requisite Pro, MS Office, ITIL 2007v, MS Visio, Quality Center.

Confidential, Johnston, IA

Sr. Business Analyst

Responsibilities:

• Interacted with PMO (Project Management Office) in deciding the process standards and Data management with Project manager where I have actively participated in defining the goals and laid out a prototype from the detailed understanding of the customers’ requirements.
• Provided Risk management consulting services including better measurement and management of risk and control, and improve the consistency of system and practices of the enterprise.
• Designed & Implemented complex security architecture for Financial Group and Involved in Data Modeling and SQL server Database.
• Performed Market Risk functionality for initial phase, then Credit Risk as currently companywide credit risk was done in a separate database aggregating various systems output.
• Identified and resolved many project issues and also proactively disseminated the project information with the stakeholders and Project manager.
• Have been business partner and consulted various client groups, integrating both business and technical expertise and discussed client’s business objectives.
• Created liaisons between development and database administrators in order to identify and resolve database issues.
• Assisted the Project Manager in creating and updating theRisk Assessment Planidentifying the Risks to the Project due to dependencies of the Project on internal Blocks and external Vendors / Entities etc. Also provided Mitigation plans for the Risks and Issues identified.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Utilized the 80-20 rule to prioritize and incorporate the critical features. Used Time- Boxing techniques to finish within set time frames.
• Trained developers on steps involved in migration of reports from Cognos to Crystal.
• Played key role in developing, implementing and demonstrating the successful pilot project using Crystal.
• Worked with testing team about the product behavior descriptions contained in the SRS to derive Test plans, cases and procedures.

Environment: Rational tools, RUP, Rational Rose, Microsoft SQL Server 2000, Windows Server 2003, HTML, MS Office, MS Access, MS Visio, MS Excel, MS Project, iTunes, Red Prairie products.

Confidential

Sr. Business Analyst

Responsibilities:

• As a Business System Analyst, I was involved in providing support to client and investment managers, completing specific client requests, resolving any issues that arise during quality assurance checks, communicating information to all interested parties and managing core relationships with clients, investment managers and consultants.
• Responsibilities:
• Gathered and analyzed the requirements and converted them into User Requirement Specifications and Functional Requirement Specifications for the designers and developers to understand them as per their perspective.
• Analyzed requirements modeled current business environment and produced cost effective redevelopment options for a system to capture property project details and calculate return on investment.
• Interacted with PMO group and participated in managing the overall schedule and ensuring the work assigned is completed on time and within budget.
• Involved in creation of Calc scripts, Rules for Hyperion Essbase Database and Application.
• Experience with Oracle Hyperion Enterprise Performance ManagementPlanning
• Applied Hyperion Financial Reporting to design specific financial reports to serve management requirements.
• Created complicated Keynote reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements using MS Office tools.
• Created reports and presentations by using Ariba for monitoring Research trends and variances to target/forecast
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the legacy system.
• Created Traceability Matrix to ensure that all the requirements are covered by the test cases using Mercury Quality Center.
• Analyzed business requirements and organized business and process Use Cases, Sequence, Activity, State Chart and Robustness Diagrams using Rational Rose, adapted UML standards to define modularized Data Process Models.
• As part of a team provided assistance with monthly data extractions and imports utilizing SAS, Microsoft Access, SQL and MS PowerPoint and MS Excel.
• Extensive Dashboards were built providing easy access to the managers and executives to various reports using Hyperion Interactive Reporting Studio (Brio).
• Gathered and analyzed the data from Data mart and generated reports using BI application.
• Involved in GUI design sessions with usability team and UML modeling for IT team.
• Supervised all pertinent project management processes: Business processes, User Acceptance Test, Test scripts, Test results, End user training, oversaw documentation, established regularly scheduled project team meetings milestones.

Environment: MS SQL, SAP, J2EE, Web Services, Hyperion Essbase 11.1.1.3,9.3.1, Web based application, Agile, Rational Rose, MS Visio, Text-Pad, UAT, MS Office 2003, Reporting Tools (Hyperion Interactive Reporting (Brio), SQR Production Reporting, Financial Reporting (Reports), Web Analysis (Analyzer) and Cognos BI reporting v8.).

Confidential

Business Analyst

Responsibilities:

• Gathered Business requirements from end users keeping in mind their need for the application and documenting it for the developers using requirement management tool DOORS.
• Conducted the Risk assessments, evaluated Insurance programs and recommended insurance coverage.
• Responsible for giving solution to assist enterprises to administer important business as well as operational risks and to identify best practices, operations cost reduction, and development opportunities.
• Worked with Project manager in attaining the Team objectives and defining tasks and followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and ensured that critical requirements are not missed.
• Involved in business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Was part of the Implementation Team to implement DOORS for requirements development and management for the upcoming applications for requirement gathering.
• Created numerous data models to help the report building process which is very complex, since we got data from multiple data sources.
• Led a team of four,responsible for migrating and converting the older version Hyperion Brio reports and Business Objects to the Hyperion Interactive Reporting and Financial Reporting.
• Provided training to the Exelon users in running the reports and consolidations and also to analyze the Essbase data using Hyperion Visual Analyzer and Hyperion Excel add-in.
• Participated in sessions for Creation & update of published Guidelines & How-To documents for DOORS.
• Became a DOORS support representative for first tier questions when needed and have Documented Training Files (User Guides) for the internal teams and placed them SharePoint for various team’s, Stakeholders’ access.
• Participated in the meetings of DOORS installation, configuration, support, administration, schema design, access policies, template design, training for functional extension and VBA development for report generation.
• Participated and assisted in designing the ETL processes using Informatica tool to load data from Oracle 9i, DB2 into the target Oracle 9i Datawarehouse.
• Worked on writing proposals, presenting Datawarehouse solutions, developing BI strategies, evaluating DW and BI Tool and IT Vendors
• Also worked on the entire cycle from opening period to closing period in GL (General ledger).
• Led and conducted JAD sessions to identify the flows and processes involved in the content.
• Assisted in building a business analysis process model using Rational Rose, MS PowerPoint.

Environment: Rational Rose, UML, RUP, DOORS, Informatica, MSOffice2000, VB.NET, ASP.NET, Oracle 9i, Windows NT/2000, MS Excel, MS PowerPoint.

Confidential

Business Analyst

Responsibilities:

• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Collected and documented business processes as well as business rules. Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Formed a bridge between the Project Manager and different technical teams with effective presentations as well as verbal and written communication.
• Converted existing DB2 Data Warehouse to comply with new IBM Banking model.
• Performed Positive Testing and Negative testing both manually and using automation tools.
• Used SQL queries were to retrieve data from tables and to perform Back-End testing.
• Quality Center was used to perform bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Provided end user support and problem resolution for various issues related to BO.
• Coordinating between different user groups, other areas of application, teams and individuals.

Environment: QTP 9.0, Quality Center, Oracle, SQL, Window, Java, Java Script, HTML, MS Excel.

Confidential

Business/QA Analyst

Responsibilities:

• Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.
• Performed Feasibility Analysis and Risk Analysis on the application.
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Created Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Led successful integration of two diverse technical departments into one technical team through team-building skills, career development and goal setting. Raised average performance evaluations for all staff members one full grade higher, as approved by the same reviewing manager.
• Involved in preparing test plans and in manual testing and on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• After successful release of projects, developed automation scripts using QTP and integrated the script with master script.

Environment: QTP, QC, Windows XP, Java, Oracle, MS PowerPoint.