SUMMARY:

• Data Analyst with an experience of around 7 years in all phases of Software Development Life Cycle: Gathering Requirements, Analysis, Implementation and Testing of projects. A smart working, motivated, sincere, committed, quick learner, detail-oriented team player with excellent communication, analytical, leadership, interpersonal and problem solving skills.
• Experienced in all phases of the Software Development Life Cycle SDLC including requirements gathering, analysis, design, implementation, testing and deployment as well as software engineering methods like Rational Unified Process RUP , Agile and Waterfall Method.
• Strong experience in RUP and Agile Business Modeling process, complete UML artifacts related to Business Modeling and Requirements, including MS Visio and Rational Rose.
• Expertise in Requirements Gathering through direct user interviews and workshops.
• Facilitating JAD sessions with business users and development team to drive out detailed business requirements.
• Experience creating Wire Frames to refine requirements and create a prototype model.
• Exceptional Documentation Skills for writing Use Cases and Functional Requirement Documents as well as for creating Use Case diagrams, Activity diagrams, Sequence diagrams, State diagrams based on UML Methodology and business process flow diagrams using MS Visio/Enterprise Architect/Rational Rose.
• Defining Test Cases, creating Test Scripts, analyzing bugs, interacting with QA / dev teams in fixing errors.
• Involved in creating test data and experience in conducting User Acceptance Testing UAT .
• Strong knowledge of RDBMS for writing queries to perform data analysis and reporting and Corporate Data Warehousing skills.
• Involved in creating Fact Tables and Star Schemas from the business analysis point of view.
• Data extraction, Data Migration and Data conversion using ETL tools from application front-end with Oracle databases and data warehouse.
• Involved in writing SQL queries that were used by the testing team to validate the data in the back-end Oracle Database.
• Developed and implemented data migration and conversion tools to facilitate ETL, and validation reporting for variances.
• Experience of working with QA team closely and knowledge of QALC.
• Using project management tools like MS-Project for status reporting and planning.
• Good knowledge of Financial Analysis NPV analysis, Stocks/bonds valuation, Real/financial options pricing, and DCF analysis , Corporate Actions Analysis, Root Cause Analysis, Feasibility study and Risk assessment, GAP analysis, User Acceptance Testing UAT , SWOT analysis and Cost benefit analysis including ROI and Financial Justification.
• Strong subject matter understanding in Risk Management, Derivatives, Fixed Income Assets, Mutual Funds etc.
• Extensive knowledge in Risk Analysis like Credit Risk, Market Risk, Business Risk, etc.
• Experience in Investment including Asset Management, Brokerage and Equity analysis.
• Good understanding of various loan types: - term loans, revolver, and letter of credit L/C .

BUSINESS SKILLS :

Requirements Gathering, Business Definition Requirements , Business Processes Research, analysis, documentation, Use Cases, JAD Sessions, GAP SWOT analysis,

TECHNICAL SKILLS:

Windows,HTML, DHTML, Visual Basic, JavaScript, UML,XML , Microsoft FrontPage, Requisite Pro, Rational Rose, Test Director, Microsoft Project, Oracle, Microsoft Access, .Net, Visio, SQL,T-SQL, PL/SQL, MS Office Suite, HPQC,Methodologies: SDLC RUP, RAD, Agile, Agile-Scrum, Waterfall , UML, QALC

PROFESSIONAL EXPERIENCE:

Confidential

Position Data Analyst

Responsibilities:

• Gathered the functional and business requirements by conducting interviewing stakeholders, conducting JAD sessions and participatory Design Sessions involving major leads from the Technical Department.
• Documented and Prioritized Business and Functional Requirements.
• Managed requirements from system users and preparation of business requirement documents using Visual Use Case that provided appropriate scope of work for technical team to develop prototype and overall system.
• Implemented iRise's iBloc API for visualization of the widgets in order to customize the UI
• Implemented and managed iRise's iDocs in order to share the visualizations across different teams
• Planned and assisted in the implementation of County data migration in order to give each county a sense of ownership on the system
• Worked with change management for various counties
• Assisted in setting up a centralized criminal system to help statewide agencies with vital court information
• Created UML based diagrams such as, Use Case and Activity diagrams using Visual Use Case.
• Involved in reviewing page schematics and provided inputs to the development of interaction diagrams.
• Implemented the project around Rational Unified Process RUP methodology
• Assisted the Project Manager in preparing the Project Development Plans. Also helped in identifying and tracking Project Issues and Risks.
• Participated in database design and development as well as report design and development, testing plan co-development and quality assurance.
• Developed Business Requirement Document and Use Cases Specification for various Use Cases.
• Created prototypes / Wireframes using Dreamweaver.
• Created test cases and test plans in collaboration with QA team and coordinated UAT.

Environment: MS Project, RUP, Rational RequisitePro, Rational ClearCase, Rational ClearQuest, QualityCenter 9.0, Windows XP

Confidential

Lead Business Analyst/Data Analyst

Responsibilities:

• Worked as a liaison between technology and the business clients to improve business processes and support critical business strategies.
• Facilitated JAD sessions for defining business requirements and follow-up for Project Plan updates.
• Reviewed the existing waterfall methodology and worked towards implementing Agile iterative process.
• Involved in creating Business Flow Diagrams, Dataflow diagrams, UML Activity diagrams and USE cases diagrams using MS VISIO to define the actual data flow and activities in the system architecture.
• Designed use-cases and use-case models to further refine the requirements and understand the business processes.
• Involved in finding and documenting requirements where the new data capture solution would be compatible with existing Customer Interface Control Systems CICS .
• Worked extensively in Rational Requisite Pro to organize and catalog requirements.
• Gained consensus for business requirements being fully met and attainable technical development expectations.
• Performed research on incoming user requirements/modifications and suggested improvements for the second release of the application.
• Proactively identified opportunities and made recommendations to improve the system's effectiveness via data mining and analysis to understand user interactions with system and to scope out opportunities to increase user engagement and satisfaction.
• Data extraction, Data Migration and Data conversion using ETL tools from application front-end with Oracle databases and data warehouse.
• Addressed software validation and compliance issues with particular attention to data migration.
• Responsible for verifying of data integration/migration from various distributors systems into the Data Warehouse environment and maintaining the Informatica Repository.
• Worked closely with the QA Team to review and enhance the Test Plan and Test Cases.
• Reviewed development plans, quality assurance test plans, and user documentation to ensure correct interpretation of original specifications.
• Analyzed PL/SQL queries that to be used by the testing team to validate the data in the back-end Oracle Database.
• Worked with the test team in Identifying and creating Test Data for Smoke, Functional, and end-to-end testing.
• Worked Closely with UAT Team to understand their needs and issues.
• Helped in designing and implementing deployment process, and thus maintaining the application in post deployment process

Environment: Mainframe, Java, Oracle, XML, HTML, UNIX, Windows, Informatica, PL/SQL, Hyperion, UML, MS Suite, Requisite Pro, Rational Rose

Confidential

SAP HR Business Analyst

Responsibilities:

• Served as key role in full life cycle implementations into SAP with integration to other modules within the SAP suite, interfaces to third party software, and outsourced processes from PeopleSoft and ADP, covering data and requirement gathering, fit gap analysis, business process analysis, system configuration, data conversion, data upload, and ending with integration testing, training, and go live support
• Developed User and Technical documentation and training materials when needed Coordinated with all levels of management, steering committees, business process members, consultants and external resources, SAP Basis and ABAP development teams to ensure successful implementations in multiple HR modules.
• Provided key user training and process improvement methods on various SAP HR modules, Ad Hoc Query, and reporting
• Configured ALE for message type HRMD A with required filters, and performed HR masterdata transfer via IDoc's to external SAP systems for various business requirements.
• Created and scheduled job to process automatic daily IDoc transfer via report RHALEINI
• Advised, supported and provided guidance as member of Global SAP HR team for conception and design of Global SAP HR Masterdata system and Global HR Template.
• Prepared functional specifications and worked with ABAP resources in technical configurations and design when needed for multiple projects
• Provided on going production support for multiple SAP systems in Personnel Administration, Organizational Management, Time Management, Reporting, Compensation Management, ALE, and Benefits
• Provided support for user roles and authorizations, both standard and structural authorizations

Environment: MS Project, RUP, Rational RequisitePro, Rational ClearCase, Rational ClearQuest, QualityCenter 9.0, Windows XP, SAP

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Worked with the team lead in understanding the scope of the projectwhich included defining the in scope data sources, asset classes, accounting bases, legal entities and AMG user groups
• Worked on enhancing the information management initiative to respond to the needs of stakeholders by identifying the missing fronts and interfaces
• Worked closely with the important stakeholders and decision makers including the data governance work stream to drive transformation of the operating model
• Involved in understanding and gathering the requirements for the establishment of Quantra Commercial Mortgage Lending System IDR interface. Documented the business and functional requirements for GAAP and STAT bases data and involved in BRD socialization process and stakeholder sign-off process
• Assisted one of the team members in understanding and documenting the business requirements for the AMG Finance-Billing Process. Completely involved in documenting the functional requirements for the same by understanding the dependencies of the billing process on month-end closing. Also involved in understanding AUM billing data calculation by analyzing the existing queries
• Identified the other sources of investments data for Houston based data warehouse IDB , documented the business and functional requirements for the establishment of additional interface to capture the missing data elements
• Created a data feed specifications template to be used across AIG as nothing existed in the organization to capture the data sourcing and data loading specifications
• Involved in risk analysis and risk management. Created a data feed specifications document to identify the data elements from the current credit risk system- that captured the credit risk ratings assigned by the internal AIG analysts
• Created data feed specifications document for Quantra and CPP interfaces to IDR
• Created data flow diagrams to understand the flow of data into IDR
• Created wire frames for the front-end to be developed for global billing, mortgage and NYPAM operations for viewing client reference data, billing data provider information and AUM billing values
• Worked closely with the team members in addressing the whole spectrum of reporting needs-Schedule B, Schedule BA and Schedule D
• Assisted developers in the creation of several detailed and summary reports including line and pie charts, trend analysis reports using micro-strategy based on the business requirements
• Worked closely with the other team members in identifying the implementation requirements for the model that reduced risk Regulatory, Reputational and Operational due to transparency and consistency

Environment: PAM-Portfolio Accounting Management System, Eagle Pace, Micro-Strategy, InfoPoint, DART, Microsoft Visio, Microsoft Office Suite, Embarcadero Rapid SQL, Microsoft Expressions Blend, Oracle 10g

Confidential

Business Analyst

Responsibilities:

• Identified opportunities for web site process improvement through various meetings with business users, AON Insurance Brokers and Marketing team, AICPA Insurance and Investment Advisory Group and developers.
• Developed the project plan with assistance from the web site designers, and included provisions for project scope changes.
• Participated in Primary and Secondary Research at AICPA to determine User Requirements and Workflow Processes.
• Documented use case specifications on the basis of requirements gathered from stakeholders.
• Created functional requirement specifications FRS for Insurance Management, Competitive pricing, Risk management and risk reduction education.
• Documented and analyzed the catastrophic loss from their insurance claim database using risk management software and ACORD Insurance data standards.
• Created use case diagrams, UML diagrams and activity diagrams.
• Effectively analyzed and created business requirements from the customer needs into detailed user and product requirements for enterprise content management applications.
• Developed website wire frames to refine requirements, and created detailed prototype of the AICPA website portal, outlining all the insurance products available to members.
• Documented and analyzed the automated process in which claims would be scanned and indexed into the workflow and imaging system and prioritized and forwarded to department's inboxes using FIFO.
• Documented the most-asked insurance inquiries, and online explanation of benefits EOB's which Aon wanted to implement in their database for higher employee empowerment and workload balance.
• Created detailed periodic status reports, Plan, Risk Mitigation Plan, Project Scope Document, Project Glossary and artifacts to provide client, top management and implementation team, visibility into the progress of the implementation.
• Conducted UAT, prepared test plans and test cases and performed load/stress test. Environment: Java JSP , HTML, IBM DB2, Quick Test Pro QTP , Oracle 10g, PL/SQL, UML, Agile Methodology Extreme Programming , MS Visio, MS Office Suite, MS Project, Enterprise Architect