Business Analyst/QA
Resume:
NILESH MITHBAVKAR
PROFESSIONAL PROFILE
Over * years of experience in the management, Business Analysis, Quality Process and Assurance, Development, and Implementation of numerous clients and IT projects.
Project Management Certified Professional (PMP)
Worked as a Business Analyst over eight (8) years with impeccable procreative knowledge in business and IT related pools.
Experience in all stages of Software Development Life Cycle (SDLC), Risk Analysis Model, Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP) and Rational Tools used during various phases of RUP.
Demonstrated technical and project management skills, ensuring a smooth transition between product management, development staff, and customers.
Excellent ability to gather, define, document business and functional requirements documents, lead projects and client implementations to successful completion.
Domains worked include Agribusiness, Mortgage (Loan Processing to Closure), Portfolio Management and IT services.
Expertise in eliciting and synthesizing business requirements and ensuring those requirements meet approved business plans.
Experience in modeling, documentation, analysis and design, test tools development and implementation facilitation.
Strong time management skills in handling multiple projects and deadlines under minimal supervision.
Excellent ability to work individually or as member of a team, with emphasis on quality and productivity.
Experience in managing requirements from project inception through release. Interacted with large teams of testers and developers through excellent communication and interpersonal skills. Able to handle diverse tasks simultaneously to adapt to tight deadlines.
Versed knowledge in conducting Joint Application Development (JAD) sessions, Questionnaires and Interviews acting as a liaison between the technical team and IT users for requirements gathering and business area analysis to identify business needs and technological improvements.
Expertise in creating Test Plans, Test Cases and Release Notes.
TECHNICAL SKILLS
Methodologies RUP, Agile, Waterfall.
Testing Tools Test Director, HP Quality Center, Rational Enterprise Suite.
Change Management Tools Rational Clear Quest, Requisite Pro.
Business Modeling Tools Rational Rose, Microsoft Visio, Business Modeler.
Version Control Systems Rational Clear Case, Subversion.
Project Management Microsoft Project, Microsoft Office
Platforms Windows 2000/XP/SERVER, MAC OS, UNIX
Programming Languages C, C++, SQL, PLSQL, Developer 2000, HTML.
Quality Management CMM Level 5 Compliance
Databases DB2, Oracle, MS-Access.
Web Technologies Microsoft FrontPage, Photoshop
Tools TOAD, Edit Plus, PLSQL Navigator, SQL*Plus, Developer 2000, JIRA, Peregrine Service Center, Erwin, Dollar Universe, FTP
PROFESSIONAL EXPERIENCE
Department of Finance, Brooklyn, New York Jun 07- Present
Business System Analyst
Bus Lane, Red Light Violation Project: This project involves requirement analysis, planning and modeling system specification to enhance the functionality of the existing NYCServ application.
This is a new violation for driving in Bus Lane restricted area. If a vehicle (non-bus) is driving in the bus lane and do not make the next available right turn, it is considered as Bus Lane Violation. Application was developed to accept and process payments against this violation. Payments can be made at Business Centers, KIOSKs or through internet.
Cigarette Tax – CTX Project: This project is to automate reporting for New York City Cigarette Activity reports. All NYC Cigarette Stamping Agent and Wholesale / Dealer Licensees can now use online form to report their wholesale cigarette activity. All NYC Cigarette Licensees dealing in wholesale cigarettes for sale, transfer or other forms of cigarette distribution in NYC must file a Form CTX-R with the appropriate schedules completed. Cigarette Stamping Agents (Agent-Jobbers), Wholesale Dealers (Sub-Jobbers) and Vending Machine Operators must report their wholesale cigarette distribution activity using this Form.
The CTX project effort includes process and technology changes and enhancements to improve the New York City Cigarette Activity submission process.
Hearing by Web Project: The New York City Department of Finance (DOF) implemented a feature on its website that allows respondents to contest parking tickets via a feature called Hearings by Web (HBW). This feature allows respondents to enter in a defense for why they believe the ticket should be dismissed or found not guilty. Also the Dept. of Finance has decided to allow respondents that request a hearing online to upload evidence related to their case.
Real Property Transfer Tax (RPTT): This tax is imposed on grants, assignments, transfers, or surrenders of real property in New York City. This implementation involves changes in NYCServ system in order to support the processing of payments received for penalty and interest imposed in Fairtax for late filing / late payments of the RPTT.
ePermits “Modernization” Project: The ePermits Modernization effort includes process and technology changes and enhancements to improve the ePermits issuance process and technology enablement for the new CAPP and OSAP permits and the existing ABPP and AOSPP permits. The new Permit Issuance leverages the current / existing ABPP ePermits Application and extends and enhances the application to meet the mayoral mandate for improved permit issuance and control.
Responsibilities
• Functioned as a primary liaison between the business users, upper management, and development team, Interacted with user groups and SME’s to conduct Feasibility Study and gather business requirements.
• Identified data elements from back end that map to fields on the web application.
• Performed current state analysis/As-is process/to-be model on various projects using IBM Business Modeler.
• Determined constraints, such as rules, defaults, user defined data types.
• Managed test schedules and monitor overall progress of testing, quality of testing and environments & escalated issues in defect tracking tool ClearQuest.
• Used SharePoint as document management platform.
• Created system rules, business rules, message list for various projects..
• Conducted user interviews, gathered requirements and analyzed the requirements.
• Conducted Workflow, Process Diagram and GAP analysis to derive requirements for existing systems enhancements.
• Created business use cases, data tables and User Interface designs followed by screen mockups using Adobe Photoshop.
• Identified and documented business rules, created detailed Use Cases and conducted UAT (User Acceptance Testing). Developed the test plan and test scenarios to be used in testing based on business requirements and technical specifications.
• Assisted in development of user manual and training materials for new technology and process improvement.
• Scheduled training with end users and conducted training sessions.
• Responsible for all project documentations and served as a liaison between the business team and the project team by assisting in identifying, understanding, and documenting their business needs.
• Worked with multiple product implementations, multiple teams thus effectively prioritizing and balancing responsibilities.
Environment: RUP, Visio, HP Quality Center, MS Office, Windows XP, SQL, EditPlus, DB2, IBM Business Modeler.
Bunge Global Markets, White Plains, New York Jun 06-May 07
Business System Analyst
Bunge is a leading agribusiness and Food Company with integrated operations that circle the globe, stretching from the farm field to the retail shelf. Bunge Global Markets is a commodity trading company which originated from its parent company Bunge Limited. Bunge is one of the largest producers of soybeans in world and the largest in the South American region.
Core Entities (Reference Data Integration Services, Reporting): This project involves requirement analysis, planning and modeling system specification to enhance the functionality of the existing Bunge applications. Identification of “Core Entities” used by multiple applications provides a single source for that information. System saves application development costs, saves the maintenance costs and easy to share data. This provides greater value to Bunge customers.
MDS–Market Data System: MDS is one of the core applications of BGM. Market Data System (MDS) handles various market data such as Cash prices, Futures, Options, Forex to be used by different Bunge applications. MDS has several vendor interfaces like DTN and Reuters developed to receive such market data. MDS is supporting multiple applications such as MTM and FRM for various business needs.
Responsibilities
• Created business use cases, data tables, class diagrams and User Interface designs followed by screen mockups for the Core Entities, MDS system.
• As part of Inception artifacts, created Business rules and Edit rules in accord with user requirement.
• Analyzed requirements to ensure that they are consistent, complete, feasible, accurate and traceable to the business rules and requirements.
• Collected data from SAP and/or Business Intelligence Warehouse (Data warehouse), analyzed the data, and formulated action items that positively affected business metrics and profitability.
• Coordinated efforts to integrate the applications with the ongoing IT Projects in Bunge to have one centralized location for all information.
• Assisted Program Manager with the development of project schedules. Developed requirements and preliminary design for client applications.
• Conducted Gap Analysis and Risk Analysis to show the current and proposed functionalities of the system with the risks involved in the project.
• Interacted with data architect for Data Mapping, Data Modeling and Entity Relationship Diagram.
• According to RUP, documented business workflows in UML diagrams (Activity Diagrams, Class Diagram and Use Case Diagrams) for the stakeholder review.
• Worked directly with end-users to collect data, specified technical requirements and created Use case documentations and process maps to address end users needs.
• Developed RUP artifacts at the inception and elaboration phases such as class diagrams, data models and use case documents.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing.
• Facilitated User Acceptance Testing (UAT) with stakeholders and system users to uncover latent defects in the system. The defects were logged in HP Quality Center. Coordinated with Development team to get them fixed and verified fixes through a new cycle of regression testing.
• Delivered and maintained extensive documentation for future extensibility of the system.
Environment: RUP, Visio, Test Director, HP Quality Center, Borland Together, MS Office, Windows XP, SQL, EditPlus, TOAD, Oracle 9i.
Liberty Home Funding Pittsford, New York March 05- May 06
Business Analyst
Liberty provides lending services to both first time homebuyers and those interested in refinancing. Liberty is an easy; make sense solution for obtaining the best experience when shopping for mortgage services. This project involves the basic requirements, planning and modeling system specification to enhance the functionality of the existing web site. The system automates the actual loan processing used by mortgage companies and brokers and connects the entire mortgage enterprise. Major functionality provided in the system Use Cases are Loan application (1003), Loan origination, Loan underwriting, Merged credit profile, property appraisal, Earning verifications, Title search, Count court judgment, rate assessment, Entitlement, Closing statement etc. The System automates the loan origination and underwriting process for serving clients with varying requirements in a shorter time. Liberty also provides customization of amortization as per the Debt-To-Income Ratio and other financial conditions of the borrowers and promises Lock-In on the mortgage rate.
Responsibilities
• Generated use-cases for the Online Brokers, Pre-Qualification loan application module and first time homebuyers.
• Responsible for analysis and functional specifications of “As-Is” business model to conduct GAP analysis in comparison to the proposed system to enhance the functionality of the application.
• Documented Requirement Traceability Matrix in Requisite Pro for traceability of requirements.
• Conducted interviews with SME’s in the accounts, loan servicing, underwriting and loan processing departments to gather requirements.
• Developed Activity Diagrams to capture the workflow of LIBERTY existing system and to identify the integration point for FAIR ISSAC system (for credit history and report) and Appraisal Valuation Model (AVM) software Cogentroad. Analyzed requirements to ensure that they are consistent, complete, feasible, accurate and traceable to the business rules and requirements.
• Modeled Activity diagrams to show the flow of online activity of the borrower initiating the loan request to loan closing.
• Developed RUP artifacts at the inception and elaboration phases such as sequence diagrams, data models and dictionary.
• Performed Use Case modeling to determine the context and specifications of the entire loan processing method automated by Encompass system.
• Conducted a comprehensive use case analysis to determine key abstractions such as loan underwriting, loan-closed, borrowers-info, mortgage-payments etc, and their mapping to the standard analysis mechanism to enable maximum reuse.
• Key contributor to change control board (CCB) proceedings at the front end and back end of software development cycle for effective risk management and versioned product rollout.
• Used Rational ClearQuest as a defect-tracking tool to track and manage all defects across the entire product development life cycle.
• Facilitated User Acceptance Testing (UAT) with stakeholders and system users to uncover latent defects in the system. The defects were corrected and verified through a new cycle of regression testing.
• Delivered and maintained extensive documentation for future extensibility of the system. Assisted technical writers in developing user training manuals and handbook
Environment: UML2.0, RUP, Rational RequisitePro, Rational ClearQuest, MSOffice, Windows XP, TOAD, Java.
DDC GROUP New York, NY Apr 04- Feb 05
Business Analyst
Remittance Processing
DDC (Direct Data Capture) provides secure transactions, and payment solutions to financial institutes. DDC can design, deploy and manage custom or private-labeled facilities that provide the most desirable solutions and greatest business advantage for clients with various needs.
The system was built to providing payment services through high-speed remittance processing, check clearing, ARC and Web-based image archive solutions. System processes customers' payments so that client companies can focus on their core business.
Responsibilities:
• Analyzed standard industry practices of back office applications of financial institutions.
• Applied RUP methodology in building new components of the system.
• Gathered requirements through JAD sessions and interviews with direct clients. The requirements were to ensure CHECK 21 ACT compliance for the back office.
• Gathered requirements for efficient remittance processing through ARC procedures, MICR coding requirements, batch processing, and interaction of lockbox remittance system with Originating Depository Financial Institution (ODFI), Receiving Depository Financial Institution (RDFI) and associated Automated Clearing House (ACH) Support Systems.
• Developed detailed use case models and supporting specifications for representing the lockbox operations.
• Outlined security measures for communication between Lockbox and ACH Support Systems through star networks for fraud-safe transactions.
• Developed data flow diagrams to capture flow of information between systems, and interaction diagrams for flow of control within systems.
• Drafted test strategies and test plans to verify accuracy of the functionality, security, fault-tolerance, performance and successful system integration.
Environment: RequisitePro, UML, MS-Project, Oracle 8i, Windows 2000, PLSQL Navigator.
CARDINAL ACTIVEWEAR, New Jersey Apr 03- Mar 04
Business Analyst
Cardinal Activewear is one of the leading manufacturer and exporter of Garments, assuring customers their finest quality and on time shipment. The system was designed to replace the manual gathering of data from different producing processes for product tracking and status. The Fit system was developed to automate and integrate Apparel manufacturing process that covers Order Entry, Invoicing, Finished Goods Inventory, Picking, Contact Manager Cut Tickets, Raw Materials, Materials Allocation. With its efficient and user-friendly interface Fit provide a cross platform program designed for the management of a small to medium sized apparel manufacturing for ad hoc fulfillment of orders. FIT provides decision departments and production divisions to function together and develop strategic plans for the existing and new orders. FIT run on all versions of Microsoft Windows and Apple Macintosh to facilitate the pattern makers and fashion designers.
Responsibilities
:
• Developed workflows of existing disconnected systems of inventory, invoicing, material management and production planning using Activity Diagrams.
• Elicit and synthesize business requirements of different product development departments to meet agreed and approved business plans for system integration at the product development and order processing level.
• Coordinate the analysis and design of various departments and their legacy system and model their integration into the FIT system.
• Performed requirements gathering on business processes to identify and extract system problems and solution requirements from the user community.
• Designed user-interface prototypes for discussion and development using MS Visio.
• Determined Key abstractions of proposed system along with required analysis mechanisms for efficient integration of system.
• Deliver and maintain clear documentation; capture and disseminate changes to the documents following ISO9001 standards.
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the system users.
Environment: UML2.0, Oracle, TOAD, Crystal report.
ASIAN COMPUSOFT LIMITED, India Feb 01 – Mar 03
Senior Software Developer
Oraspace ERP Project
Company involved in developing and implementing ERP package, having a turnover of billion dollars, with branches all over India.
Responsibilities
• Requirement capturing
• Document specifications.
• Gap Analysis
• Development and maintenance of HRIS module
• Determining scope of work and preparing development plan
• Creating GUI screens using Developer 2000 (Forms 4.5, Report 2.5)
• Creating Oracle Packages, Stored Procedures and Stored Functions
• Ensuring that the software meets predefined Quality Standards.
Accomplishment:
Successfully Developed and Implemented Software Packages at various clients.
Environment: Oracle 8.x, Forms 4.5, Reports 2.5, PL/SQL 8.0.4, SQL, Win NT.
BIRLA COMPANY, India Apr 00 - Jan 01
Software Developer
Triggers Conversion Project
ISO 9002 certified Birla Group Company involved in manufacturing copper, brass, bronze, silver strips and foils, having a turnover of billion dollars.
Applications involved over 800 Forms of version 3.0 having Version 2 type triggers. The most important phase was creation of a generic tool for conversion of Version 2 type triggers to PL/SQL type.
Responsibilities
• Capturing various phases
• System orientation & Requirement Analysis
• Determining scope of work
• Task scheduling
• Code Development - Unix, PL/SQL package
• Carrying out testing with respect to various test cases.
Significant Contribution:
Successfully designed tool for conversion of Version 2 to PL/SQL Trigger.
Environment: HP - UX 10.2, Oracle 7.3, SQL, PL/SQL, Forms 3.0, Developer 2000.
EDUCATIONAL QUALIFICATION
B.E. (Electronics), Mumbai University, India
Project Management Certified Professional (PMP)
CONTACT INFORMATION
***********@*****.***
Contact this candidate