SUMMARY

• 12 plus years of extensive experience in business analysis, design, support, development, Project management, testing for various clients.
• Project Management Professional PMP , Certified through Project Management Institute PMI , 2011.
• Adept in Agile and Waterfall methodologies. Able to move between different SDLC approaches depending on project specifics and known for high-quality deliverables that meet or exceed timeline and budgetary targets.
• Involved in strategically analyzing business impacts and develop customized solutions and improve performance.
• Interacted effectively with clients/business, Understanding their requirements and providing optimum solution and support.
• Managed multiple projects simultaneously.
• Experienced in group facilitation with participants from diverse business functions and work skills.
• Strengths include big picture focus while developing strategic business solutions using project management, ROI, gap, impact and risk analysis.
• Facilitated functional design discussions and documenting requirements, create use cases, change management, UAT.
• Conducted user training sessions and application demos for end users.
• Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.
• Well versed with all the Testing documentation and fully conversant with Business Requirements, Test Plans, Comprehensive Test Cases, Execution and documentation of Test Results, Defect Reporting and Tracking using Test Director / Quality Center.
• Wrote Technical Documents on Reports developed.
• Experience pulling data from Oracle, Teradata, Sybase, DB2 and Microsoft SQL Server 2008 and/or higher databases for reports
• Experience in MS Office Suite, Oracle,Teradata, UNIX , SQL ,Toad Data modeler, squirrel.

SKILLS SUMMARY

• Operating System: UNIX, Linux, Windows NT, Windows 95 MS-DOS
• Languages: SQL, PL/SQL, Java, JSP, C, Developer 2000, C , HTML, C, C , Javascript
• Databases: Oracle 10g, Oracle 9i, Oracle 8i, Ms. SQL Server 7.0, Sybase, DB2, Teradata
• Tools: Lotus 123, Word Star, MS Office, Visio, Powerpoint, Project, MS Excel, Reports 9i, Reports 6.0, Cognos, Crystal Reports, BO 5.0, SSRS, SSMS.
• EXPERIENCE HIGHLIGHTS
• Confidential
• Business Systems Analyst / DA

Roles Responsibilities:

• Created functional specification document, Use cases and maintained requirement traceability.
• Creating strategy for release management of ecommerce non prod environments.
• Created release deployment documents.
• Created Changes/RFC in service-now tool and helped coordinate the change with Environment owners/support team.
• Provide support to developers in clarifying functional, data and reporting requirements.
• Created several reports on status of the project which were pulled from HP ALM and Clearquest to be shared with project stakeholders.
• Created several CRs in Ecommerce area.
• Work with business stakeholders, application developers, across functional units to identify business needs and discuss solution options.
• Helped in creating BRD and conduct BRD review meetings with Business and IT teams.
• Worked with environment provisioning team to share concerns and get issues resolved in terms of VLANs connectivity, getting dedicated server provisioned for automation of env certification.
• Provided critical feedback for process improvement to Change management team, to update the process flow for a production change to capture test change for tracking/auditing purpose.
• Created gap analysis document and implementation plans.
• Created traceability matrix to ensure coverage of requirements for both dev and test.
• Software Used: Rational Clearquest, HP ALM, google suite of applications,as400, db2 400.iseries, Microsoft sql, service-now, Ms Visio.

Confidential

Business Analyst / DA

Roles Responsibilities:

• Work with business stakeholders, application developers, across functional units to identify business needs and discuss solution options.
• Helped in transitioning the project from AutoVIN development team to UST.
• Gathering requirements by directly interacting with the Client and estimating the effort required for each task and creating as well as assigning task within rally for team members.
• Coordinated development activity by assigning User Story/Tasks in Rally.
• Worked with support development teams to identify risks and gap as part of a requirement.
• Created multiple documents including business overview, support documents for both batch scheduling, AutoVIN DB checklist, dashboards and uploaded it to client Wiki.
• Created Functional requirement document, to on board new clients for Autovin Hyundai, Autonation .
• Created requirement documents and mapping documents for all requirements
• Helped in coordinating UAT, QA testing.
• Writing and executing SQL queries in Toad to fetch for data validation as part of investigation SR which were assigned in Clearquest.
• Conduct meetings with Business to improve the application by adding new functionality.
• Created Multiple Reports within SQL Server Reporting Services.
• Developed backend integration services which in turn interacted with tables specific to Hyundai systems.
• Involved in weekend maintenance activity and performing testing and support after maintenance activity.
• Used Toad data modeler for reverse engineering to generate ER diagrams.
• Software Used: Rational Clearquest, ActiveBatch, Rally , Toad 8.6, MS Visio, Oracle 10g, SSRS Sql Server Business Intelligence Development Studio , 4nt scripting, .net, sql loader, Visual studio 2010, Tortoise SVN

Confidential

Business Systems Analyst / Reporting Analyst

Roles Responsibilities:

• Gathering requirements by directly interacting with the Client and estimating the effort required for each task.
• Writing and executing SQL queries in Teradata SQL Assistant to fetch the data validation.
• Created the Test Data for all the possible scenarios and also worked with QA team for testing.
• Created Technical and Functional Design Document and worked with client team in preparing Solution Design Document, Requirements Traceability matrix, Detailed Business Requirement doc, Use cases, scope documents, wireframes.
• Prepared and presented periodic project Status report daily Clearquest defect reports to client team.
• Worked with BO admin in identifying missing fields in existing BO Universe and data mapping.
• Worked with Business/data solutions team to load data in Dev, Test environment.
• Ensuring the team has the required technical expertise to execute the project. This involves the identification of key technical areas related to the project and conducting training sessions to plug any gaps. Also responsible for providing technical assistance over the course of the project.
• Created WorkOrder in TSRM for copying data from Prod to different test and Dev environment.
• Coordinating with business to find fields which are not available in Data Warehouse.
• Software Used: Unix, Rational clearquest, Business Objects XI webintelligence, Work Load Manager, Tsrm, Teradata SQL Assistant, Enterprise DW, Bteq basic Teradata Query , IBM Req Pro, Ms Visio.

Confidential

Senior Business System Analyst

Roles Responsibilities:

• Managing Requirements, which involves analysis of project requirements with a view to understanding the same and to identify the gray areas in the requirements.
• Gathering requirements by directly interacting with the Client and estimating the effort required for each task.
• Ensured knowledge transfer to offshore team in a timely manner with a sign off from Delivery.
• Create Scope Document and Project Plan for new apps under transition.
• Providing solutions for improving the clients business, processes and profitability.
• Coordinate with the client to design solution for attaining the business objective.
• Coordinating, planning, project tracking and status reporting throughout development lifecycle.
• Prepared and presented periodic dashboard bi weekly reports to client manager/director.
• Lead team onsite for Transition and met Client Expectations
• Participated in production release and maintenance activity and also preparing test plans and triage documents.
• Identifying areas of system enhancements and submitting proposals.
• Analyze the various project requirements, Impacts and transferring the knowledge to offshore team.
• Ensuring the team has the required technical expertise to execute the project. This involves the identification of key technical areas related to the project and conducting training sessions to plug any gaps. Also responsible for providing technical assistance over the course of the project.
• Prepared load analysis report, Team utilization report and presented to client to take up new application support.
• Worked with Client Manager to come up with a defined SLA doc .
• Provide support to other Business Analyst s in gathering and/or clarifying data and reporting requirements from business owners
• Developed SQL queries and support ad hoc requests for data.
• Analyzed Data in Tables or Reports and find any issues.
• Software Used: Unix, IBM WAS 6.0, Mckesson product, Oracle 9i, Sybase, Windows Administration, Mainframe, IBM DB2, Sybase, Business Objects, HP Business Availability center, rational Clearquest.

Confidential

Production Support Analyst

Roles Responsibilities:

• Utilizes the online ticket-based incident reporting system to monitor, track and resolve trade applications. Also accepts urgent incidents via phone as well.
• Effectively communicate with the trading desks, Portfolio Investment control in NA, Europe and Asia.
• Perform troubleshooting by looking at Unix scripts, stored procedures or database SQL processes, running database queries and reviewing data to determine point of failure.
• Perform troubleshooting by visual inspection of the source code located in the production environment with the understanding of the business functionality to determine point of failure.
• Logging details of issues into Remedy and Notification/Escalation to appropriate teams.
• Software Used: Oracle 9i, Sybase, SQL, PL/SQL, Crystal Reports 9i, SQL Advantage, TOAD, Remedy Action Request System 5.1.1, Perforce Unicode Version 2003, Unix , Windows NT, Lotus Notes, HP Open View operations for UNIX version A.08.24, Rapid SQL 7.3.1, Remote Desktop connection.

Confidential

Roles Responsibilities:

• Developed several reports like Cross Over Clinic Patient Report, Appointment Reminder letter Report, Patients without addresses Report and third Party billing report on Reports 9i.
• Converted rdf reports to rep format.Designed webpages using javascript which calls reports and passes parameters to the reports.
• Played the role of Unit Test Coordinator between Developers and QA Team for the last 3 Releases .
• Wrote functional documents describing changes made to the Web Applications which were done by using Design Editor in Designer 9i.
• Wrote several Database Triggers, Views, Stored Procedures and Functions using PL/SQL on Oracle 10g.
• Co-ordination with the Business for requirement gathering, analysis and documentation.

Software Used: Oracle 10g, SQL, PL/SQL, Developer 2000,Designer 9i , Mercury Test Director 7.6, PVCS 8.0, Reports 9i, Javascript, Toad, SQL Developer, Unix , Windows NT.

Confidential

Oracle Developer

Roles Responsibilities:

• Developed advanced queries with multi table joins and nested sub queries which were used to display reports like Employee Personal Loan Report, Employee Product Coverage Report.
• Created Oracle database objects like Tables, Views, Indexes, Sequences, Synonyms.
• Used Oracle SQL Loader for importing data from flat files to Oracle database.

Software Used: Windows NT, Oracle 7.0, SQL, PL/SQL, Forms 4.5, Reports 2.5, TOAD, Unix.