PROFESSIONAL SUMMARY:

• More than 3 years of experience working as a Business Analyst and Data Analyst in financial services, fund - raising, healthcare audit and consumer product industries.
• Conversant with all phases of Software Development Life Cycle (SDLC), involving initiation, system analysis, design, development, testing and implementation.
• Expert in engaging various elicitation techniques like Interviewing, Questionnaires, Brainstorming, focus groups meetings, structuring meetings
• Experience in conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Excellent in performing GAP Analysis to check the compatibility of the existing AS-IS system infrastructure with the new TO-BE business requirements.
• Expert in understanding Business Processes such as Automation, Improvement and Reengineering.
• Extensive experience in requirements gathering, drafting Business Requirement Documents (BRD), Functional Requirement Specification/Document (FRS/FRD), Vision & Scope documents.
• Adept at creating and transforming business requirements into designing business models using UML diagrams - Use Case, Flow Charts, Data Flow, Context, Sequence and Activity diagrams.
• Proficient in managing, monitoring and change management of production processes.
• Experience providing end - user support, managing access control and resolving escalated system level issues in production systems.
• Good understanding of SQL and excellent data management skills; adept at analysis and generation of ad-hoc reports to measure performance using KPIs, report review with senior team members.
• Experience in data extraction, data transfers, data management and ETL processes.
• Well versed in different management scenarios like third party vendor management, Change Control, System Integration and Scheduling.
• Expert in tracking and managing the requirements using Requirements Traceability Matrix (RTM) that controls numerous artifacts produced by the teams across the deliverables for a project
• Experience in creating Test Plans and Test Cases for User Acceptance Testing and overlooking test script execution for Integration, Regression, Performance, Functional and System Testing
• Experience in using Defect Tracking Tools to address bugs/issues and interacting with development team to fix errors
• Proficient in creating screen mock-ups, wire frames and User Interface Documents, including Screen for Mobile Application.
• Team player with strong analytical, interpersonal, communication and problem solving skills.
• Ability to handle simultaneous projects, meet critical deadlines and timely execution of several client/server projects

TECHNICAL SKILLS:

Business Skills: Business Process Analysis and Design, Gap Analysis, Impact Analysis, JAD sessions, Requirement Gathering, Use Case Modeling, Quality Assurance, Change management, Communication, Risk management, Client relationship management

Methodologies: Waterfall, Agile

Project and Change Management Tools: MS Project, JIRA, ServiceNow, Confluence

Databases: SQL, MySql, MS Access, Oracle Toad

Languages: Java, C++, JSP, JavaScript, HTML

Data management and Business Intelligence tools: IBM Cognos 8, Tableau, RedPoint, Pentaho, R

Other Tools: Rational Rose, Visio, MS Project, MS Office, UC4, Autosys, MS Excel, VBA, PwerPoint, Word, Outlook, MS SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Junior Business Analyst

• Functioned as the liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Collaborated with global stakeholders to address critical business problems and drive decision making.
• Effectively gathered, prioritized and documented requirements based on product strategy.
• Interfaced with global and regional business owners as a part of requirements gathering and elicitation to finalize the project scope.
• Helped to create and translate user stories to define the functions the system must provide, and to facilitate requirements management.
• Identified “As is” process and “To be” process as parts of gap analysis for new functionality requirements, as well as prioritizing them based on actual business needs so as to align them with the project roadmap.
• Created Unified Modeling Language (UML) diagrams for Business Process Modeling like Activity Diagrams, Sequence Diagrams, Data Flow Diagrams and Workflow Charts using Visio.
• Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the project plans accordingly and conducted project related presentations.
• Worked on the data analysis, data mapping, defined data flows and developed the code of the batch files to be used as inputs for end-of-day batch processing of AML application.
• Used SQL during the testing phase to verify and validate that the correct information is being provided.
• Conducted User Acceptance Testing (UAT) to ensure all the business requirements have been fulfilled by the application.
• Worked with PM during RACI review process, change and release management.
• Implemented Software Quality Assurance development policies and test procedures. Documented test scripts according to the business specifications and design documents.
• Worked with development and testing teams to accomplish timely release objectives.
• Prepared user manuals and conducted training sessions.
• Analyzed and defined scope for requirements to build the production environment.
• Verified/ analyzed data used for fees and commissions calculation.
• Implemented reports to deliver internal account ownership and reconciliation break reports to business data teams in APAC, EMEA and Americas.
• Interacted with front and back office technology groups and specifically ensure tight integration between customer master systems with fees and commissions application.
• Worked with Global Application Support Team to streamline various upstream and downstream feeds
• Strategically defined the vision for Fees and Commissions applications and projects to be created related to these systems or having impact to these systems
• Worked with requirements analysts and subject matter experts to identify, understand, and document business needs for the data flow.
• Manage and maintain project plan for communication on deliverables to users for fees and commissions infrastructure build out.
• Worked on the reassessment of user privileges and co-ordinated the set up of user authentication using multiple active directories.
• Created a production environment that would allow to send/ receive data to/ from other applications (similar to UAT), migration of Level 1 and 2 support to the global app support team and data migration from UAT to prod.
• Built a new database to deploy the fees and commissions tool.
• Developed detailed analysis report for the IT team to validate exposure results and provide support during UAT.
• Resolved escalated system level issues in applications and business processes in production environment.
• Analyzed data (using Oracle Toad) and worked on data mapping to facilitate data processing for the upstream and downstream of a few back office applications, surveillance and regulatory reports.
• Managed, maintained 4 applications for Run-the-Bank and Change-the-Bank activities.
• Worked with cross-functional teams to co-ordinate upgrades, enhancements and system maintenance.
• Participated in sprint planning meetings and planned releases dependent on expected business value.
• Used MS Project, JIRA and ServiceNow for change management, project and issue tracking.
• Standardized and documented business processes that minimized business operational risk.

Environment: Agile Methodology, Microsoft Office Suite, Microsoft Visio, SQL, Oracle Toad, UC4, Autosys, ServiceNow, JIRA, UML

Confidential, Naperville, IL

Data Analyst Intern

Responsibilities:

• Achieved business process simplification, error reduction and 50% time saving by automation of donor mailing reports using Pentaho.
• Collected, cleansed, provided modeling and analyses of structured and unstructured data used for client projects.
• Used quantitative data gathered to develop an understanding of donor behavior and demographics.
• Successfully interpreted data to draw conclusions for further actions to be taken by Client Services team.
• Presented findings and data to the Client Services team to improve strategies and operations.
• Worked with other team members to complete special reports and projects.
• Leveraged analytical tools like SQL and Pentaho to develop efficient system operations.
• Performed daily data queries in SQL and prepared reports on daily, weekly, monthly and quarterly basis.
• Worked on data management, organization and classification in RedPoint for Client Services team thereby facilitating data administration and retrieval.
• Used advanced Excel functions to generate spreadsheets and pivot tables.
• Compiled and validated data to reinforce and maintain compliance with corporate standards.
• Worked with the management team to prioritize business and information requirements.

Environment: Agile Methodology, Microsoft Office Suite, Microsoft Visio, SQL DB, Pentaho

Confidential, Westmont, IL

Project Intern

• Implemented an online work order system which led to time saving of 60%, revenue increase by 50% and 30% cost reduction.
• Participated in the identification, definition and documentation of impending work flows for the purpose of migrating to an online work order management system.
• Worked with subject matter experts to identify, understand, and document business needs for the data flow to create a database model.
• Interviewed SMEs and business users to consult on domain knowledge.
• Conducted interviews with the business users to create detailed BRDs and FRDs.
• Involved in system analysis and design phase to identify the Non-Functional Requirements.
• Executed complex SQL queries to verify and validate the data in the database and to test all the modules.
• Performed Functional Testing and UAT.
• Involved in creating the User Manual Document for the end users.

Environment: Waterfall Methodology, Microsoft Office Suite, Microsoft Visio, MySQL, Java, UML, Confluence

Confidential, Chicago, IL

Project Intern

• Implemented an Android application using iBuild app, a content management system.
• Identified and resolved ambiguities, conflicting business and technical requirements.
• Functioned as the Primary Liaison between the product owner and technical project team throughout the Project Cycle.
• Conducted one to one meeting with SMEs to understand and discuss nature of the project.
• Worked with business team and development team to create user stories for all functionalities.
• Worked closely with various business stakeholders, Product Owner and scrum-master to come up with wireframe prototype and User Interface Document.
• Developed activity diagram, sequence diagram, data flow diagram, flow chart using Visio for the business process.
• For each new feature, performed smoke testing and User Acceptance Testing (UAT).
• Prepared and maintained the Requirement Traceability Matrix mapping to any changes occurred in the process.
• Involved in creating the User Manual Document for the end users.

Environment: Waterfall Methodology, Microsoft Office Suite, Microsoft Visio, UML, iBuild app