Objective

6years’ experience as a Business Analyst, Systems Analyst, Data Analyst in Retail and Financewith solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Functional Specifications, Application Design and Testing

Summary

• Highly experienced in Defining, Gathering, Documenting, Managing requirements by conducting Joint Application Design (JAD) sessions and translating them to technical requirements.
• Experienced in working with Retail, CRM, B2B, B2C, E-Commerce, Financial institutions, Loan Origination, Web Banking, Retail Banking, Annuities.
• In depth knowledge of Rational Unified Process (RUP), Agile and other traditional development methodologies, along with the Unified Modeling Language (UML), Use Case.
• Strong understanding of Conceptual, Logical and Physical Data models and Data warehouse projects.
• Highly experienced in understanding Entity Relationship Diagram (ERD).
• Excellent Analytical skills to understand the Business and Functional Requirements and communicated effectively with upper management and developers.
• Experience through all phases of the System development life cycle (SDLC) including analysis, development, black box testing and implementation. Experienced in performing GAP analysis.
• Proficient in interacting with Stakeholders, Subject Matter Experts (SMEs), System Analysts and Technical team with excellent communication and interpersonal skills. Experienced with Data mapping, data modeling, data migration, metadata and data flow diagrams.
• Excellent skills in writing Business Requirements Document (BRD), Use case Document, Functional Requirement Document (FRD) and Requirement Traceability Matrix (RTM).
• Experience in Graphical User Interface (GUI) design, wire frames, prototypes, screen mock-ups, site navigation models.
• Conducted User Acceptance Testing (UAT) with stake holders and business users.
• Highly experienced in broad range of technologies including business process tools such as MS Project, MS Office Suite and MS Visio.
• Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions, and confident, accurate, decision-making. Excellent track record for meeting deadlines and submitting deliverables on time.
• Excellent Communication skills with ability and willingness to work towards the business and technical requirements of clients and users.
• Exceptional flexibility and ability to work independently and in a team acting as liaison between management and development team for requirements.

Education

Bachelors of Computer Science Engineering

Technical Skills

• Engineering Software: MATLAB, LabVIEW
• Office Applications: MS Office (Power Point, Excel, Word), MS – Visio
• Wireframe: Axure Wireframe Tool
• RDBMS:Oracle, DB2, SQL Server. Teradata
• Datawarehouse: Informatica Power Center Designer
• Database Tools: SQL* Plus, TOAD 8.x/9.x, SQL, Data Mapping, Data Migration
• Business Intelligence: Informatica, Data Stage, Business Objects, Microsoft SQL Server Reporting Services (SSRS), SAS
• Testing: Mercury Quality Center 9.2, JIRA, Bugzilla

Experience

Confidential, Auburn Hills, MI Business Systems Analyst / Data Analyst June 11 to Present 
The Commercial Loans Application was being upgraded to move to a robust platform and an EDW was also developed. The project involved working on Data Mapping & Migration, where the key focus is on Analyzing existing Commercial Loan Reports used by various departments, identifying the different Data Elements used by these reports and preparing a Data Elements Dictionary to map the same with AFS (New Third Party Product). 

• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified functionality for the Loans Application.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Assisted the Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Interfaced between Business new product builders and System platform builders.
• Worked on data modeling and produced data mapping and data definition documentation
• Developed business intelligence reports using Business Objects (BO) tool for the updated results to the stake holder
• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
• Generating SQL queries to capture reporting data from SQL server reporting services. Providing Excel based statistical analysis and creating pivots tables and charts for business reporting and assistance in data driven decision process.
• Worked on SQL queries to extract the data required for data validation.
• Analyzed and developed large quantities of data in SQL to manipulate modify and debug various tables for reporting services. Used Inner Join, Right Join, Union & SQL Functions
• Create technical design documentation for the data models, data flow control process, metadata management.
• Developed the ETL Informatica Mappings for importing data from the sources into subsequent data marts.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• UAT testing performed along with call center managers to make sure that application meets their requirements.

Environment: Java, J2EE technology, Oracle Platform, MS Visio, MS Outlook, MS project, RUP, Rational Clear Quest, Informatica, SQL, TOAD, Business Objects, Teradata, Rational requisite pro

Confidential, Hoffman Estates, IL Business Systems Analyst Sept 10 to June 11

• The project involved upgrading the Confidential Market Place portal. Confidential Marketplace is an innovative community that allows merchants to advertise or sell products on the Confidential Holdings Corporation family of websites.
• Documented the Process Flows for B2C and B2B in the High Level Requirements Document.
• Utilized Agile and PMI methodologies to monitor steer and develop project objectives.
• Worked with various e-commerce modules for electronic funds transfer, supply chain management, Internet marketing, online transaction processing, electronic data interchange (EDI), inventory management systems, and automated data collection systems. Conducted tech reviews for various modules for the team.
• Closely worked with the taxonomy team and gathered requirements to make necessary changes onConfidential.com
• Conducted JAD’s and gathered requirements and translated them to functional specifications to help the User Experience team to design the UI.
• Worked closely with the Stake holders to analyze the business requirements and translated high level business requirements to functional specifications for the IT team.
• Presented discovery documents to the IT activities for acceptance into the integrated and point releases via Statement of Business Requirements documents using MS Word, MS Excel, and Visio tools.
• Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on Ms Access.
• Generated Use Case diagrams, Sequence diagrams, Domain Object Model, and Visio to depict process flow and PowerPoint presentations.
• Captured Data flow diagrams and formatting of the data flowing modeling through interfaces.
• Provided expertise in strategic planning, business process modeling, business process analysis, object-oriented analysis & design, use case modeling, use case analysis, component-based development, and quality assurance.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling (BPM)
• Functional decomposition of the system by identifying and elaborating to business use cases
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Facilitated user acceptance testing and test strategies with Information Systems Group.
• Performed manual front-end testing to check all functionalities of different modules.
• Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests)
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro and managed the concurrence of the parties involved with respect to the evaluation criterion

Environment:JSP, Oracle , Java, J2EE, HTML, XML,DOORS, Weblogic, Clear Case, Clear Quest, XSL Agile, Rational Rose, JAD, MS Visio, UML, MS Project, SQL

Confidential, New Jersey, NJ Business Systems Analyst / Data Analyst Oct 09– Aug 10

• The project involved reengineering of the Credit appraisal system, plugging all the gaps of the old system and creating better usability and portability. It also involved enhancement of the application for accommodation of changing business and regulatory requirements. Project is to develop Early Warning System [EWS] to cater the needs of Financial Advisors with data for Fixed Income and Brokerage Trade. The final accepted system helps the lenders in automating the origination, processing and closing functions of the mortgage system, thereby increasing the operational efficiency of the system. The project was a mainframe based application.
  
• Accurately identify the business and functional requirements for the strategic process re-engineering and design
• Analyzed AS IS and TO BE processes. Statistics calculation of the solution. Created conceptual and logical data models as well as helping data warehouse developers in creating physical data model of the fact tables
• Authored Product Requirement Documents, System specification Documents including source-to-target mappings, use case specifications, business process modeling, requirement change request, data dictionary, page layout, error messages, business rules along with the technical staff and developers.
• Identified resources for information and source systems data flows
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements, Documented them in PRDs a format that can be reviewed and understood by both business people and technical people
• Analyzed the business requirements and the impact of outbound and inbound interfaces with other legacy applications (processes and reports)
• Designed functional solution of the project
• Liasoned with the IT, vendor and business user to drive the required solution
• Assisted project manager with project scoping, project plan, monitoring and milestones tasks
• Responsible for requirements elicitation (understanding, analyzing, optimizing), process reengineering, and system solution design, and documenting all the Key Performance Indicators (KPI)
• Employed Agile development process to assist with assessing unprecedented levels of tool and technology-specific guidance, helping to bring higher quality software development cycles into the project
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and assisted the development of User Manuals for customers
• Created the contents for collaterals such as solution presentations, datasheets, whitepapers and FAQs
• Worked on Security features of solution during entire SDLC
• Implemented and monitored Individual Development Plans focusing on total performance, including both quality and productivity
• Maintained and update test plan, test cases, test scenarios and test environment in QC throughout the SDLC
• Prepared Training documentation for end users to update customized information regarding employee status. Assisted in the post implementation activities
• Maintained and tracked UAT Bug Reports and coordinated with development team to ensure high priority bugs get fixed in a timely fashion
• Handled Requirements throughout the project life cycle including scope/change management
• Ensured successful UAT testing, training and end user sign off

Environment: Windows, MS Office(MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio), .NET, Oracle, Crystal reports, Mainframes, RUP, UML, SQL, Visual Basic, GAP Analysis

Confidential, Minneapolis, Minnesota Business Systems Analyst / Data Analyst Oct 08 – Sept 09

• Collaborate with Business Data Quality team, Enterprise support team and other Data Warehouse users to identify applications and other issues (i.e. scheduling …) causing the Analytical Data Warehouse to miss performance objectives or processing deadlines. Work with the Guest Relationship and Marketing business, development and Enterprise support teams to identify requirements for running promotional campaigns. Use SQL queries and batch applications to monitor campaign results to the management.
• Acted as a liaison between Business Groups, Marketing, CRM& IT to communicate business problems and assist developers to create automated solutions.
• Involved in all phases of the Iterative approach of the SDLC from Inception to Transition.
• Propose process improvements to documentation and technical writing procedures.
• Gathered, documented, and communicated business requirements into systems design documentation using Business-Modeling concepts.
• Assisted in the development of ETL mappings and other ETL Processes.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the db2 database.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Involved in designing business use case scenarios, use case realizations diagrams, and workflow charts for documenting the requirements.
• Generating SQL queries to capture reporting data from SQL server reporting services. Providing Excel based statistical analysis and creating pivots tables and charts for business reporting and assistance in data driven decision process.
• Worked on SQL queries to extract the data required for data validation.
• Analyzed and developed large quantities of data in SQL to manipulate modify and debug various tables for reporting services. Used Inner Join, Right Join, Union & SQL Functions
• Monthly and quarterly management meetings with travel liaison for consistent communication.
• Database of individual traveler personal profiles for efficiency and accuracy with each reservation
• Interacted with representatives in supplying information, reporting defects, and obtaining information for specifications and implementation of the requirements.
• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the Entity relationships between the data elements to analyze and document business data requirements.
• Involved in User Acceptance Testing (UAT) and Test Execution.

Environment: IBM AscentialDataStage (Extract, Transform, Load – ETL), SQL, BMC Control-m scheduling and Remedy service management software, SharePoint Work Order Tracking System, Hewlett-Packard Service Desk for ITIL Change Management, CMDB, and problem and issue recovery and resolution tracking.

Confidential, New Delhi, IndiaBusiness Analyst June 06 – Sept 08 Confidential is a global services provider delivering technology-driven Business solutions that meet the strategic objectives of clients. This application provides online banking for the customers to manage their Credit Cards, Loans and other Banking Services.

• Responsible for designing, producing & implementing web applications. Participated in Project Planning and control. Defined resources, deliverables and staff engagements
• Analyzed and translated editorial and visual content for web channel
• Developed Site Map, Navigational Rules, Screen Layouts and GUI Elements. Programmed registration and search functions in Java Server Pages. Designed and developed table layouts, frame based navigation and forms in HTML/JavaScript
• Analyzed User Requirement Document and developed Test Plans, which includes the Objectives, Testing Strategies, Test Environment and others
• Involved in Change Request meetings to document changes and implemented procedures to test changes
• Developed Test Cases and Test Scripts for the Functionality Testing
• Worked closely with the Developers and System Engineers to nail down the technical problems
• Tested the Application with Development, Staging, and Production Environments
• Prepared and authored various User Level and System Level Documents
• Prepared Various System and Interface Documents for Updated QA Process
• Coordinated with development and functional teams regarding releases and Bug Tracking System
  

Environment: Microsoft Office Suite, MS Visio, Java, J2EE, JavaScript, JSP, HTML, Windows NT, Oracle, SQL

Activities/Leadership

• Computer Tutor, Rotary International, Palampur, India
• Volunteered to impart basic computer education to children of a homeless shelter.
• Life Member and Volunteer, Red Cross Society
• Volunteered in various events and fundraisers across the world.