SUMMARY

• Dedicated and hardworking professional with an MBA in Information Systems & Finance and over 7 years of business systems analysis, Requirements Analysis and Data Analysis experience with major US clients
• Sound knowledge of the software development lifecycle (SDLC) with extensive experience in eliciting user requirements, analyzing needs and translating them into business requirements, documentation, Team Management and Testing
• Experienced in Business Process Modeling, Data Flow Modeling, Object Modeling, Work Flow Analysis, Use Case Analysis
• Experience in the Management of projects in software design, mobile application design and dashboard development
• Proficient in UML - Use case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams
• Effective at interviewing business users, stakeholders and subject matter experts (SME's) and eliciting needs and translating those needs into concise functional and non-functional requirements
• Expertise in using Microsoft Excel, and used the Advanced built-in functions like Vlookup, Custom Filters, Countif, Match, Dropdown lists, Pivot Tables, AverageIfs, Gantt chart, SQL data Import & Index etc
• Proficient in database querying and analysis, on Oracle, SQL Server, Teradata and MS-Access
• Proficient in Testing and Test Planning
• Extensively used tools such as Rational Rose, Rational Requisite Pro, UML, MS Visio, MS Project, MS Office, MS Access
• Facilitated and participated in Joint Application Development(JAD) sessions for requirements gathering, resolving open issues and change requests
• Excellent skills in analytical problem solving, business-writing, and verbal communication
• Consistent record of accomplishment of efficiency, attention to detail, reliability & flexibility
• Proven capability to get up to speed quickly on complex issues and leverage versatility in the industry to bring together the business side and technology side and get things done

TECHNICAL SKILLS

Modeling Languages: UML (Use case, Sequence, Class, Collaboration)

Database Languages: SQL

Programming Languages: VBA, Java, .Net

Databases: Oracle 9i -10g, SAP, MS SQL Server, MS Access, Toad Modeler

Microsoft Tools: Advanced MS Excel, MS Office, Outlook,Project

Testing Tools: JUnit, Test Director, Win Runner

Visual Modeling Tools: Rational Rose Requisite Pro (RUP), Visio, Photoshop

Document Management: SharePoint, Visual SourceSafe

PROFESSIONAL EXPERIENCE

Confidential, NJ

IT Business Consultant

Responsibilities:

• Built a database of supply chain data and performed real time analysis to identify risks and opportunities in supply chain inventories
• Compilation and analysis of sales, shipment data in Excel from various sources and management of the data models on SharePoint
• Ownership and maintenance of existing data models and creation of new data models based on business analytics including financial targets and ROI.
• Creation and preparation of reports, dashboards and PowerPoint presentations for the senior executives and North American leadership
• Creation and preparation of executive summary templates for various business initiatives as required
• Representation the portfolio management team at cross-functional team meetings

Confidential - New York, NY

IT Specialist - Business Analysis

Responsibilities:

• Organized meetings and presented storyboards/visual mapping to ensure accurate comprehension of the existing desktop application and built consensus on the standard operating procedure (SOP) and the management’s vision
• Created touch-based UI mockups for implementation of enhanced UX features on iPad
• Assisted the Project Manager in project planning, feasibility & Gap Analysis and project roadmap traceability
• Maintained project communication processes and providing business metrics as well as non-functional requirements (performance goals) for Lead Quality Analyst.
• Translated functional requirements into test conditions for product, performance and user acceptance testing
• Performed functional testing for validation of business requirements and assisted the testing team to prepare test plan and reviewed their test scripts
• Represented the client at New York City DOITT Mobile Strategy Committee for selection of technology vendor and drafted the mobile policy in New York City

Environment: MS Visio, MS Project, SharePoint, SQL Server, Excel/VBA, Photoshop, .Net, HTML5, CSS 3, JQuery, Windows Server.

Confidential

SE Business Analyst

Responsibilities:

• Lead a six-member Development Team in an agile process (4-week iterations) for automation of the client’s Enterprise Routing System that improved efficiency by 30%
• Facilitated JAD sessions for requirements gathering, resolving open issues, and change requests
• Maintained documentation for current and future business processes maps, re-engineering patterns, analysis artifacts, business issues, user stories, user workflows and related documentation (training/help manuals) for continued maintenance
• Conducted GAP analysis by identifying existing technologies and documented the enhancements to meet the end state requirements
• Lead requirement review sessions with developers to ensure that the use cases are feasible, complete, and consistent, and provided subject matter expertise throughout the implementation phase
• Reviewed Technical Designs created by the Development Team and validated the same against functional specifications
• Researched industry XML, EDI (Data format specifications), system integration (messaging API) best practices and collaborated with Product Design team on core system enhancements
• Involved in Performance testing of the source code, which helped in analyzing its performance before moving into production
• Created and maintained project plans, assignment sign-offs, and facilitated JAD sessions with development/QA team on a weekly basis to resolve open issues and change requests Optimized project process to satisfy CMMI level 5 standards and track project status
• Developed various project related documents used for Knowledge Transfer and also was involved in preparing training plan for new resources
• Acted as a liaison between the on-site and the offshore teams that included end-users, developers, SME, PM, QA, Systems Architect, Web services team, and Senior Management
• Assisted in conducting User Acceptance Testing (UAT), developing and maintaining the test plan, test conditions and test cases to be used based on business requirements and technical specifications and/or quality procedures, and ensuring that appropriate documentation is in place

Environment: RUP, UML, Java, XML, JMS, XSLT, Junit/Win Runner, Rational Rose, Visio, Excel, MS SQL Server, Oracle 10g, UAT, SOA, DB2, HTML,CSS, MVC architecture, Tibco/MQ.

Confidential

SE Business Analyst

Responsibilities:

• Re-engineered a strategic managerial reporting system from Business Objects to web standards with exporting capability in PDF, Excel
• Gathered and documented requirements (UML)
• Ensured Use-Cases were consistent and covered all aspects of the Requirements document
• Analyzed impact of requirements on effort (Impact analysis)
• Performed in depth Business Analysis and Technical Specification by working with Implementation Managers, Traders, Operations and IT and prepared Business Specifications, Technical Specifications, Data mapping documents
• Analyzed high-level requirements and identified all existing OLAP reports that are currently used and converted requirements into technical details
• Improved the performance of the Client’s report generation system from 2 minutes to 5 seconds through improved SQL Queries tuning and reengineering
• Identified the report generating process in existing batch jobs and decommissioned the batch jobs that produced the reports that were no longer used by the End users
• Was responsible for the SDLC Process Documentation
• Worked with QA team to design test plan and test cases for Integration Testing and User Acceptance Testing (UAT)
• Developed timelines for project delivery, and worked with development and testing teams to accomplish successful completion and timely release of the deliverables

Environment: UML, Java, Junit, Excel, PDF, Toad Data Modeler, Oracle 9i, UAT, HTML, CSS, Test Director, SQL.