SUMMARY

• Senior Business Analyst with experience in business, data and investment analysis.
• Excellent knowledge of Business Intelligence principles and reporting.
• Working experience of complete SDLC processes and documentations.
• Working experience of complete UAT testing process.
• Excellent knowledge of Brokerage Business data.
• Excellent knowledge of Primary and Secondary Mortgage business.
• Excellent knowledge of banking data.
• Excellent excel skills.
• Excellent knowledge of Accounting Principles.
• Familiar with Health Insurance products.
• Familiar with Agile methodology
• Cognos 8.3 Reportnet Authoring.
• Proficient in technical writing.
• Experience in Quality Assurance and SOX auditing.
• Adept in process and system development.
• Investment Products (held Series 6, 63 & 65 Lic. now inactive)

TECHNICAL SKILLS

• SAP R/3 4.6c
• UNIX (HP - UX 10x
• Solaris 2.x)
• Window 2000
• 2003 & 2007 Enterprise Edition
• DB2
• Oracle 11g
• Sybase Adaptive Server Enterprise 12.5.1
• Rapid SQL v7.4
• PL/SQL
• Java 1.5
• VBA
• Clearquest
• ClearCase
• Remedy
• MS Visio
• MS Excel 2007
• MS Access
• MS Word 2007
• SQL(Toad 9.5)
• Minitab
• BOXI
• Cognos 8.3 Reportnet
• HP Mercury Quality Center.

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Created Business Requirements document (Reverse Engg) by converting the SQL, PL/SQL codes into the requirements document for the HAMP Accounting Validation reports.
• Created new requirements document for the adhoc reports.
• Wrote the sql queries for the adhoc reports.
• Tested the sql codes for the updated /adhoc reports.
• Performed "Data Analysis", to support the Accounting team with its validation process.

Confidential

Business Analyst / Data Quality Analyst (Senior Staff Software Engg)

Responsibilities:

• As Data Warehouse/Business Intelligence Business Analyst I work with the Data Warehouse team and with other departments to design quality customized Business Intelligence solutions utilizing established methodologies and enterprise BI tools.
• Create SQL queries to analyze the data.
• Create SQL queries to fix Data quality issues.
• Understanding of Brokerage business models.
• Coordinate with external vendors.
• Coordinate with offshore development team.
• Create the Software Function Requirements Document.
• Responsible for UAT testing.

Confidential

Business Analyst /System Testing/ Project Quality

Responsibilities:

• Worked along with the development team to implement, the business requirements for application upgrades.
• Tracked and analyzed enhancements and defects using Clearquest.
• Enhancements and defects fixes were implemented in Pricing Engine, CreditWorks and Credit Portfolio Analysis system.
• Worked with the development team to create, interpret and implement business requirements into technical specifications.
• Created SQL queries using Toad, for data analysis as well as for ad-hoc reporting.
• Interacted with the business users, system analysts and Development team to track and eliminate bottlenecks.
• Effectively communicated and accurately managed technical expectations. Streamlined development and implementation life cycles.
• Assisted with the business process, data analysis and UAT for business models.
• Analyzed defects and created meaningful reports for the Development team.
• Responsible for technical and business writing and project coordination.
• Produced flowcharts and process diagrams using Visio.
• Performed qualitative/quantitative and statistical analysis.
• Created Requirement Traceability Matrix, Design, Architecture, Requirements and Testing phase documents.
• Performed System Testing for HPFA Automation application.
• Maintained SDLC documents for the team

Confidential

Senior Analyst

Responsibilities:

• Facilitated the review meetings among different groups.
• Maintained and tracked all the Action Items in Database.
• Evaluated /Analyzed the Technical Requirements to eliminate the duplicates, overlapping, out of scope etc.
• Coordinated with client to get the feedback on the opened Action Items.
• Created different documents related to the project.
• Generated reports in Excel.

Confidential

Responsibilities:

• Elucidation and Analysis of Business Requirements (JAD Sessions with Stakeholders)
• Requirement gathering for Statistical Process Control (SPC) and Analysis.
• Documenting Business Requirements using Word/HP Mercury QC.
• Gather requirements for project deliverables including Technical documents (Functional Requirements Document, Test Analysis Report & User Guides/Manuals)
• Developed use cases using Visio/Word.
• Responsible for coordination between stakeholders and the Development team.
• Assessed Data Quality and worked as a part of team to analyze the data dictionary.
• Used Toad tool to create SQL queries for data analysis and data manipulation.
• Improve the quality of the process(es) (CMMI level 3 )
• Documenting Process and Product Quality Assurance (PPQA) in Clearquest.
• Develop necessary reports using Cognos8 BI Reports.
• Report Testing using Cognos Report Net
• Help QA team for Application Testing (Functional Testing).
• Periodic meetings with the stakeholders to update the project status.
• Perform data query, data analysis and data quality.
• Responsible for process quality assurance (Defects Tracking in HP Mercury QC)
• Perform the project management documentation.
• Additional responsibilities include but are not limited to tracking and generating the invoices upon the delivery of the deliverables.

Confidential

Business Analyst

Responsibilities:

• Worked along with the development team to implement, the business requirements for application upgrades.
• Tracked and analyzed Data Modifications using Clearquest.
• Defects fixes were implemented in Securities Trading Accounting system (STATS).
• Worked with the technical staff to create, interpret and implement business requirements into technical specifications.
• Created SQL queries using Toad, for data analysis as well as for ad-hoc reporting.
• Gathered requirements from the end users to understand the defects. Then classified the defects into different categories and assigned priorities to fix them.
• Identified, analyzed, reported and tracked test script issue creation and resolution.
• Interacted with the business users, system analysts and Development team to track and eliminate bottlenecks.
• Effectively communicated and accurately managed technical expectations. Streamlined development and implementation life cycles.
• Gained a good understanding of Fixed Income Securities and products such as MBS, REMIC and MEGA.
• Familiar with Multifamily Housing Programs.
• Creating defects tracking system in Clearquest, this helped in analyzing the defects and also prioritizing the fixes.
• Created Change Management tickets using Clearquest.
• Assisted with the business process, data analysis and UAT for an accounting system.
• Analyzed defects and created meaningful reports for the Development team.
• Responsible for technical and business writing and project coordination.
• Produced flowcharts and process diagrams using Visio.
• Performed qualitative/quantitative and statistical analysis.
• Published documents for the Production Release Analysis and Delivery Traceability Matrix.
• Assessed the Data quality through the reports run on loan calculations.
• Maintained the ELSIF documents for the STATS team.
• Participated in the analysis of the RFP for a COTS application.
• Tracked and analyzed Access and Change Management controls as part of SOX auditing.
• Posted and managed documents on SharePoint.
• Designed reports using BOXI.
• Responsible for tracking and analyzing the data corrections executed in the production environment.
• Assisted in producing the Month End closing matrix.
• Edited and facilitated the production of training/user manuals.
• Analyzed data and produced presentations for senior management.

Confidential

Release Manager/Business Process Quality Analysis

Responsibilities:

• Worked with program/product management locally, remote development and a QA team in India to fully define quality requirements and certify project deliverables. These included the release of Process Insights covering several areas of the business cycle such as Procurement to Pay (Accounts Payable), Order to Cash (Accounts Receivable), Financial Close (General Ledger) and Payroll. Another deliverable was to analyze the Authorization Insight (SU01/ PFCG - Roles) where the application would detect security and internal controls settings for the financial accounting system, as well as any unauthorized access and transactions being allowed.
• Created and executed Use Cases to test the functionality of various application modules.
• Improved the quality of reports for end-users through reverse engineering.
• Developed Business Rules to detect fraud, inefficiency and SOX compliance in the accounting cycle.
• Responsible for creating a flow chart for the Business Rules (requirements to testing) and test cases. Assisted in creating functional specifications from the rules objective.
• Analyzed rules and conditions. Reported outputs meeting the rules objective.
• Validated back-end testing. Verified data in the SAP R/3 system and MS SQL Server. The end product was a web server based application. The core architecture for the application was based on a data warehouse model.
• Extracted data from the SAP system. Uploaded it on the MS SQL Server. Performed queries through a reporting tool using SQL in the back-end and the reporting server MSSSRS.
• Performed Data quality check for accuracy and timeliness.
• Worked extensively on SAP R/3 (Ides 46c and 47db) systems.

Confidential

Financial Analyst

Responsibilities:

• Served as a Client Financial Analyst. Assisted clients in choosing various financial products. Responsible for assisting business and professional clients with meeting business and financial needs.
• Sourced a business account. The total relationship for the account was $35M.
• Became licensed to sell investment products such as mutual funds and insurance to meet client needs.
• Sold mortgage products and became familiar with mortgage financing and laws to include CRA, TILA and HOEPA.
• Gained a good understanding of mortgage backed securities.
• Familiar with Multifamily housing and Commercial Loan Programs.
• Marketed various products including banking products for both business and non business clients and financial products.
• Assisted the Citigroup Business Analysts with end-user requirements.
• Responsible for assisting the application developers by manually testing the beta versions of various financial, administrative and business applications. The applications were tested under an Intranet environment from the end-user perspective.
• Manually tested web-based applications.
• Participated in the formulation of the requirements for future use.
• Worked on the cross functioning of several applications as part of application design.