Technical Skills

• Business Modeling Tools: Rational Rose, Microsoft Visio.
• Requirements Mgmt Tools: TFS, Rational Requisite Pro, JIRA.
• Testing Tools: Mercury Quality Center, Test Director.
• Change Management Tools: Rational ClearCase.
• Project Management: Microsoft Project, Microsoft Office and Microsoft SharePoint.
• Methodologies: RUP, Agile, Six Sigma, CMM, Waterfall, XP.
• ETL Tools: Informatica PowerCenter 8, 7.1.2.
• Business Intelligence Tools: Microstrategy, Business Objects XI, Crystal Reports.
• Databases: Oracle 11g/10g/9i, MS SQL Server 2008, MS Access, MySQL, Teradata.
• DB Utilities: SQL Query Analyzer, TOAD.
• Programming Languages: C , C, C , PL/SQL, SQL, VBA, Visual Basic, JAVA, ASP.NET, UNIX Shell Scripting.
• Web Technologies: PHP, Perl, JSP, JavaScript, HTML, CSS, DHTML, XML, SOAP, WSDL.

Professional Skills

• Results-driven professional with 8 years of experience in the analysis, design, development, implementation, modeling and testing for Web applications and Data Warehousing applications under various RDBMS platforms.
• Worked in different industries like Entertainment, Automotive, Insurance, Banking Finance services.
• Conducted Joint Application Development JAD sessions and interviewed Subject Matter Experts SME , asking detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.
• Performed Business process modeling Notation BPMN to improve process efficiency and quality.
• Defined and ensured that user stories are good, have business values and story points.
• Worked independently with minimal supervision and concurrently managed multiple assignments and deadlines.
• Planning/ Estimating Resource and Budget per release to ensure On-time delivery of project
• Ability to prioritize tasks/objectives with strong organizational, administrative and analytical skills.
• Expertise in understanding and supporting the client with project planning, project definition, requirements definition, analysis, design, testing, system documentation and user training.
• Excellent analytical skills to understand the business process, functionality and requirements in order to translate them to system requirement specifications and detailed technical specification document.
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle SDLC , Iterative Software Development Life Cycle Process as per Rational Unified Process RUP , Agile, CMM Capability Maturity Model , Six Sigma and Rational Tools like Requisite Pro, Clear Case and Test Director.
• Proficient in creating UML diagrams, Use cases, data flow diagrams, sequence diagrams, collaboration diagrams and activity diagrams etc.
• Experience in conducting GAP analysis, SWOT analysis and Cost analysis.
• Hands on experience in using ETL and Business Intelligence tools like Informatica, Crystal Reports, Business Objects, Microstrategy with data sources like Oracle, MS SQL Server, MS Access, Teradata and Flat Files.
• Strong experience in writing complex SQL queries/scripts for data profiling, data analysis and QA testing.
• Professional with extensive experience in the development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.
• Excellent communication and presentation skills.
• Ability to quickly assimilate new concepts, technologies and apply software methodologies as per business needs.

Experience

Confidential

• Sr. Businesss Analyst This project is to move functionalities of the existing system HMS based on Oracle Apps to HDMS which is based on Oracle ADF technology. As part of functional team, I am responsible to deliver the functionalities of two projects: DPC- Distributor Policy Compliance and R R Refunds and repurchase.
• Working as a backfill resource to complete the functional requirements documents for both DPC and R R projects and to deliver the functionalities as per the project timelines.
• Coordinating with QA team Development team on daily basis to make sure project deliverable are on time.
• Coordinate with other teams and users to remove any impediments for developers QA team.
• Communicate weekly status to users and HDMS Herbalife Distributor Management System team.
• Review QA test plans, train business users on using new system new functionalities.

Environment: MS Visio, Oracle Apps, Oracle ADF.

Confidential

Sr. Business System Analyst

• ITSM: Enhance the International TV Sales Marketing ITSM application as per the ongoing business requirements/needs to support the various sales marketing teams across the world.
• Served as a lead facilitator/partner to the TV marketing business clients and in conjunction with Functional Architect interfaces with other SPT business groups and outside vendor as needed.
• Worked with the business users and thoroughly analyzed user needs, conducted business process analysis and re-engineering activities, and developed business requirements documentation
• Delivered artifacts such as functional and non-functional requirements document, process-flow diagrams, use cases documentation, wireframes, test scenarios, and user guides.
• Conducted iterative requirements knowledge transfer sessions with the technical and QA/testing teams. Ensured common understating of requirements across the project team and business users.
• Worked with senior members of the functional team and the technical team to identify options to meet business requirements.
• Worked with the enterprise IT group to coordinate integration efforts with back-end software development.
• Coordinated and participated in the user sign-off on the requirements documentation
• Monitored the project activities on daily basis created weekly status report for business users.
• Developed test plans and scenarios, work with QA and technical teams to perform and certify functional regression testing, and performed user acceptance testing.

Environment: MS Project, MS Visio, Oracle 11i, SAP Business Objects XI, SharePoint, VBA, Agile, HP PPMC, ServiceNow.

Confidential

Sr. Business Analyst

• The purpose of Documentum for Dealer Credit DFDC project is to address business requirements by implementing a centralized Documentum management system that will provide support for managing and tracking the documents related to dealer lending.
• Facilitated one-on-one and group meetings with Dealer Credit Financial users and stakeholders to elicit business requirements and define scope timeline of the project.
• Worked with different external vendors to find out the cost and effort estimation to implement Enterprise Content Management system Documentum .
• Created current business process map to describe the existing loan origination business process flows across dealer credit, commercial finance and legal departments.
• Created future process flows to describe the integration of Content management system with new Dealer Credit Online Application System throughout the loan origination life cycle that is from loan application to booking.
• Designed and presented a presentation to BTS internal group that outlines the cost benefit analysis options with breakdown the core business benefits vs. cost trade-offs with Pros and Cons for the Imaging Solution for Dealer Credit.
• Assisted Sr. PM in designing of various documents like Project Agreement and deriving work/effort estimates.
• Directly worked with Treasury business users to enhance and support various treasury applications.
• Identified potential needs for improvements and advise senior management on potential solutions.
• Organized project documents for easy maintenance and retrieval. Environment: Documentum, MS Project, MS Visio, SnagIt, MS Word and Excel and SaaS, HP PPMC, SharePoint.

Confidential

Sr. Business System Analyst

• PARIS Participation Residuals Information Systems Web based Finance application is unique to the entertainment industry and serves the purpose of receiving revenue, cost and usage data that is used to calculate complex participations and residuals statements due to stakeholders based on contractual terms and guild requirements. Each calculation is recorded against a general ledger item which provides a better audit trail. Worked on multiple projects like Revenue Allocation project, Foreign Guild Calculation project, SSN Masking project, Interface to AP and Payroll project and Guild Report Lock Down Project.
• Facilitated with Residual Financial users and stakeholders to elicit business requirements and define scope of the project.
• Worked closely with the IT Director and Paris IT team to ensure that the needs of the business unit are being satisfied.
• Worked closely with the senior level management SVP, VP and Director of Residual Department to define system functionality that will support the Projects.
• Analyzed and documented the business requirements using use case diagrams, use case narratives, process flow diagrams, ensuring that the requirement statements are complete, traceable and unambiguous and that they conform to standards.
• Provided Project leadership to development team for Website Enhancements including Production Timetable, Status Reporting, client/project team coordination and Quality Assurance.
• Worked with IT director in schedule planning and creating work/effort estimate.
• Worked with analysts of Title management group and SAP Group to find out the impact on their systems.
• Created web page/screen mockups and table database design to implement new business requirements.
• Performed Gap analysis to improve the existing process and performed functional impact analysis for changing requirements.
• Coordinated development and bug fixing with development team to make the project deliverables according to planned schedule.
• Managed requirements using TFS.
• Re-design the new Pension report and enhance the Guild Report to support the new Foreign Guilds requirements.
• Designed SOX test plans, test cases and test case execution for extensive QA Testing. Also used MS SQL Query analyzer to design SQL Queries for data validation.
• Interacted with offshore/onshore developers on a daily basis in order to make sure that the defects logged in are resolved and re-tested.
• Perform integration and system testing to check functionality of the new Guild rules and new Guild reports.
• Facilitated user acceptance testing UAT with the Business users and the errors discovered were fixed to meet business requirements and then verified via regression testing.
• Trained Residual users about the new enhancements in PARIS application. Environment: MS Project, MS Visio, SQL Server 2008, Informatica, SQL Query Analyzer, SAP BO, ASP.NET, TFS, MS Word and Excel and WIN XP.

Confidential

Sr. Analyst

• DirecTV is the number one HD Cable Provider in the field of Television Service Industry. The project is to generate Bill statements and Order Confirmation Letter when new user is placing an order or Existing user is requesting a new service. The project demands high level of interaction with Business, QA and Development team to insure the integrity of 5 customer-facing applications Siebel CRM application, Order management system, Dealer Website, STMS and OS .
• Work closely with Business and Project Management teams to monitor multiple project initiatives and notify the BSA team with the upcoming requirements request that impacts Business Process End to End Testing and Order Confirmation OC Application.
• Organized joint planning sessions with our business partners like Customer Care and Sales Marketing during the planning stage of the project.
• Participated in weekly Assessment Meetings, conferences walkthroughs with Business Analysts, Subject Matter Experts SMEs and Developers to understand the business requirements plan the testing process.
• Reviewed project artifacts such as Fact Sheet, Initial Assessment, SAS, COR, FSD and HLD documents to understand new and existing customer hardware/programming offers.
• Analyzed Business Requirements System Requirements and then generated Traceability Matrix, Test Plans and Test cases using Mercury Quality Center.
• Planning/ Estimating Resource and Budget per release to ensure On-time delivery of project
• Participated and Initiated Team meetings on a regular basis and involved in active discussion in order to improve the testing quality by better strategies and testing approach.
• Worked with other test analysts and other leads to design a test approach or test strategy for the current project that is impacting the Business Process Team or the Order Confirmation team.
• Support UAT Testing by verifying test scenarios, inform when Project is Green to test, resolve defect and receive clarification on requirement/open issue.
• Documented and communicated test results using Quality Center. Responsible for Business Process/end-to-end system testing.
• Track defects prioritize defects with project team business users and worked with developers to resolve test failures.
• Interacted with developers on a daily basis to make sure the defects logged in Quality Center are resolved and re-tested.
• Responsible for LOE, resource allocation performance analysis. Lead a team of 8-10 resources.
• Assigned tasks and monitored the progress of resources. Reported progress to management by Collecting test status from the test team, created daily/weekly status reports for business users and PMO.
• Organized and prepared agenda for the meetings, and conducted status check meetings within the team.

Environment: MS Project, MS Visio, Microsoft Word, SnagIt, HP Quality Center, Oracle 9i, TOAD, Clarity, Siebel CRM Call Center and Field Services, STMS Billing system, OMS, TAOS, OS, ITIL ITSM Framework, SCRUM.

Confidential

Business Analyst

• Worked on multiple projects to enhance PARIS Participation and Residuals Information System application functionality.
• Guild Rule Modifications required by guild negotiations - Worked with the residuals department to gather requirements for WGA, DGA, SAG and AFTRA contract changes especially in the area of new media that required new rules and calculations.
• Guild Report Design Modified layout of existing Guild Reports to comply with the new Guild Rule requirements.
• Transaction Detail - Worked with the Data Staging department to gather requirements for receiving detail revenue and expense data into PARIS.

Confidential

Business System Analyst

• DW2/Global Insight was an international data warehouse. It integrates disparate distributor systems and other internal systems like procure to pay system, to consolidate sales, orders, financial planning, sales planning, intellectual property data and point of sale data to provide unified reporting of global data. These reports provide analytical capability on Product, Customer and Promotions.
• Conducted interviews and performed stakeholder analysis, worked with the SME's Subject Matter Experts , IT managers, software architects to identify the key changes and participated in stakeholder management to communicate effectively with them.
• Analyzed and documented the business requirements, ensuring that the requirement statements are complete, traceable and unambiguous and they conform to standards.
• Created use cases using UML and managed the entire functional requirements life cycle using Rational Unified Process RUP and Rational Rose.
• Worked with other Business Analysts of domestic and finance systems to understand the impact of the changes and also to ensure proper integration of new solutions.
• Developed data mapping documents ETL specification docs for ETL development team indicating the source tables, transformation required, business rules and target table's columns and data types.
• Involved in data model enhancements to meet business requirements.
• Carried out extensive data validation and Quality Assurance.
• Facilitated UAT with the stakeholders and the business users and the errors discovered were fixed and then verified via regression testing.
• Point of Contact for Enhancement and Defect Change Requests
• Checked the reports for adherence to standards and quality before delivery.

Environment: Rational Rose, Rational Test Manager, Oracle 9i, TOAD, Informatica PowerCenter 7.1.3, MS Access and Excel, Microstrategy and WIN XP.

Confidential

Business System Analyst

TRM Project:

• UBOC has implemented a Fraud Detection system which analyses the day to day bank transactions and reports any suspicious activities. Transaction data is fed to the system that compares it to the historical database of transactions identifies the trends and generates alerts if it finds any potential fraudulent activities on cards/check transactions. This project is a part of the effort to provide data for the Fraud Detection application to analyze and report.
• Facilitated Joint Application Development JAD sessions to reach consensus on project definition and application functionality, cut down on time and money overheads.
• Primary contact point for one of UBOC's major businesses, supporting all compensation cycles and system needs.
• Managed client-facing projects and processes, worked with multi-disciplinary group of comp analysts, functional analysts and technology developers.
• Developed Functional Requirement Specifications FRS based on User Requirement Specification URS.
• Understood and articulated business requirements from users and then convert requirements into technical specifications.
• Worked in partnership with other Business Analysts of the upstream systems to understand the impact of their changes and also to ensure proper integration of new solutions.
• Using RUP provided expertise in reorganization of a complex End-to-End testing effort and performed System analysis.
• Developed training documents and conducted end-user training sessions for exercising full use of application.

Environment: Rational RequisitePro, Rational Rose, MS Excel, MS Word, MS SQL Server 2005, Oracle 9i, Teradata, ASP.NET, Business Objects XI and AIX 5.

Confidential

Business System Analyst

• A web-based application was developed for customer claim management system and integrated with their insurance system that enables a prospective policyholder to interactively pursue quotes. The claim file utility developed enables policyholders to file claims and the GUI developed walked them through the claim file process.
• Conducted joint requirements planning sessions as a facilitator to gather requirements from the business area.
• Analyzed Business Requirements and created Use Cases, high level and low level Activity Diagrams/State Chart Diagrams using Rational Rose.
• Conducted regular meetings with the system architects, developers, quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand.
• Defined validations to be built into application in line with the functional requirements.
• Prepared BRD Business Requirement Design and TSD Technical System Design Documents.
• Designed Test plans, Test cases, Test case execution using specification documents and Rational Test Manager.
• Frequently updated the requirement and defect status as per the current status of the testing project in the Clear Quest.
• Coordinated work plan between project manager and client using Microsoft Project.
• Developed user manuals, presentations and training manuals as per project specifications and timelines.

Environment: RequisitePro, Rational Rose, Rational Clear Quest, Rational Test Manager, MS Project, MS Office Suite, .NET, SQL Server.

Confidential

Business System Analyst

Being a financial institution, the target is to increase its customer base. To assist in this task, bank uses a client-server application called ESB, which collects all the information regarding a Prospective Customer especially Commercial Customers and with the help of various other systems in the Bank like KYC, RACER, CIF etc. tries to convert the prospective customer in to actual bank customers. ESB also has the ability to interact with external Credit companies to get information about the Prospective customers. The project was to create ESB's interface with Clarify Call Center application to be able to collect actual customer's calls data.

Confidential

This web based application involves tasks like registering new policyholders by direct online-registration or through an authorized agent, periodic statement generation for premium remittance, claims processing, and disbursement of agent's service charges and validation of the aforesaid activities.

Environment: MS Visio, MS Office Suite, MS Project, Rational Rose.