PROFESSIONAL SUMMARY

• 8+ years of experience as a Business Analyst, having an in depth knowledge of the Software Development Life Cycle and a complete understanding of various phases involved such as System Engineering and Modeling, Software Requirements Analysis, Systems Analysis and Design, Documenting and End User Training
• Worked with Clients in Financial, Health and Retail Services and Business Solutions domains
• Worked in Bank Data Warehouse and Mortgage Data Warehouse projects and involved in the requirements and design of various modules like Bankruptcy, Collections and Recoveries
• Ability to multi-task in a fast-paced environment and work in multiple projects simultaneously
• Varied work experience in Agile and Waterfall environments
• In-depth knowledge of Rational Unified Process (RUP); risk engineering; data modeling and mapping; and design using UML, and Visio
• Extensive experience with process modeling using UML, flow charts, task diagrams, Sequence diagrams, Activity diagrams
• Co-ordination with Business, Developers, Testing Team and End Users
• Experience in reviewing Test Procedures, defining Test cases, reviewing and maintaining Test scripts, analyzing bugs, interacting with Development team in fixing errors and User Acceptance Testing (UAT)
• Well versed in project management tools like MS-Project, for status reporting and planning
• Strong experience in back-end programming with Oracle PL/SQL, Teradata, MySQL and understanding of database
• Helped development teams with back-end programming skills in fixing critical Production issues
• Ability to harness the client needs based on their requirements
• Excellent communication, analytical, interpersonal, trouble shooting and presentation skills
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure
• Looking for a challenging role inbusinessoperations as aBusinessAnalyst

TECHNICAL SKILLS

GUI / Tools:

MS Office, MS Project, MS Sharepoint, SmartDraw, MS Visio, HP Service Desk, HP Quality CenterUMLet, Rational Unified Process (RUP)

ETL Tools:

Informatica, Ab Initio

Testing Tools:

LoadRunner

Languages:

C, C++, Java

Databases:

Oracle PL/SQL, MySQL, Teradata, MS Access

Platforms:

• Windows NT/XP, Linux

Web Technologies:

HTML, XHTML, VB Script, Omniture, Google Analytics

EDUCATION:
B.E in Computer Science Engineering

PROFESSIONAL EXPERIENCE:

Confidential,Minneapolis, MN Mar’ 11 to Till date

Worked for Identity and Access Management group to ensure access, technology, processes, and projects related to field relationship and hierarchy are aligned across Ameriprise Wealth Management to support the field’s short, medium and long term needs. Also actively involved during remediating access for Ameriprise Advisor Center (AAC formerly FSC) expansion.

Responsibilities:

• Primarily responsible for gathering Business Requirements, User Requirements, and System Requirements
• Extensive interactions with the client and the management teams to understand the requirements
• Involved in Analysis and design of the system for AAC expansion.
• Drafting the Business Requirements, User Requirements and System Requirements, sharing them with the Development Teams and Testing Teams and taking their comments/suggestions into account
• Holding meetings with the End Users and walking them over the updated Functional Requirements and System Requirements and following up for the necessary approvals
• Setting up meetings with Subject Matter Experts (SME’s) and taking their valuable inputs to solve various issues
• Providing the Technology support desk with the tools they need to diagnose and resolve access issues.
• Liaise with business and functional owner during risk engineering and high- level review sessions to derive and execute action plans, meeting deadlines and standards
• Review the High Level and Detail Level Design Documents prepared by the Development Teams and providing them with constructive feedback
• Working with the development teams and offering them inputs during critical Production Issues
• Tracking down the details of failed Production Jobs for future course of action
• Well versed with system on providing access to various financial tools provided by Ameriprise.
• Ensure all artifacts comply with corporate SDLC Policies and guidelines
• Prioritize outstanding defects and system problems, ensuring accuracy and deadlines are met
• Worked on AQMS (Ameriprise Quality Management System) for compiling and publishing the deliverables as required.
• Maintaining the Project Artifacts in HP Quality Center and created Versions for all the documents to maintain history
• Created weekly dashboards and monthly scorecards.
• Assisted Users during User Acceptance Testing

Environment:
Mainframe, MS Office, MS Project, MS Visio, AQMS, HP Quality Center.

Confidential,Minneapolis, MN Aug’ 11 to Till date

The project dealt with Corporate Communications to encounter regular performance issues and environment downtimes, enhancing existing performance of Advisor Compass, Inside Portal, Corporate Media Server, Web Analytics and Distributed Workflow.

Responsibilities:

• Primarily responsible for gathering Business Requirements, User Requirements, and System Requirements
• Conducted several Requirement Gathering Sessions (RGS) for gaining detailed requirements and finalizing Business Requirement Document (BRD)
• Extensive interactions with the client and the management teams to understand the requirements
• Drafting the Business Requirements, User Requirements and System Requirements, sharing them with the Development Teams and Testing Teams and taking their comments/suggestions into account
• Holding meetings with the End Users and walking them over the updated Functional Requirements and System Requirements and following up for the necessary approvals
• Setting up meetings with Subject Matter Experts (SME’s) and taking their valuable inputs to solve various issues
• Well versed with Omniture Web Analytics reports and dealt with its pain points.
• Worked with IBM to solve Media Server space and server synchronization issues.
• Worked on making Advisor Compass and Inside Portal rich media capable.
• Review the High Level and Detail Level Design Documents prepared by the Development Teams and providing them with constructive feedback
• Working with the development teams and offering them inputs during critical Production Issues
• Ensure all artifacts comply with corporate SDLC Policies and guidelines
• Maintaining the Project Artifacts in HP Quality Center and created Versions for all the documents to maintain history
• Prioritize outstanding defects and system problems, ensuring accuracy and deadlines are met
• Worked on AQMS (Ameriprise Quality Management System) for compiling and publishing the deliverables as required.
• Created weekly dashboards and monthly scorecards.

Environment:
Mainframe, MS Office, MS Project, MS Visio, AQMS, Omniture, Google Analytics, HP Quality Center.

Confidential,Sterling VA Jan’ 09 – Dec’ 10
Business Analyst
Worked for Confidential,a tool that increases productivity across the procurement process from requisitioning to closeout, minimizes data entry, and maximizes efficiency through electronic routing, workflow, workload management and financial interfaces.

Responsibilities:

• Meet with all developers and project stakeholders to lead a kickoff meeting.
• Defined and introduced the project, team members\' roles, and key deliverables.
• Developed prototype of new information processing application. Collected Functional

Requirements and prepared Business Requirement Documents using Rational Requisite Pro

• Strategized implementation of Agile effort throughout SDLC
• Interviewing Business Area Experts, asking detailed questions and carefully recorded the requirements in a format that can be reviewed and understood by both Business Users and Development Teams
• supplemented functional requirements with use cases and wired frames
• Conducted and coordinated Joint Application Development (JAD) with different Teams
• Utilized RUP to configure and develop process, standards, and procedures
• Designed an approach for standardizing Web applications by preparing GUI standards and recommending alternatives for incorporation in phased, iterative manner
• Followed UML based methods using Rational Rose to develop use cases and activity diagrams; assisted developers in creating sequence diagrams and collaboration diagrams
• Worked on MS SharePoint portal for reporting and automating business processes
• Reviewed various Project Artifacts like High Level Design, Detailed Design, Unit Test Cases, and Integrated Test Plans etc.
• Implemented the Planningmoduleand customized it to fit thebusinessrequirements and the company needs
• Maintaining the Project Artifacts in Share Point and created Versions for all the documents to maintain history
• Assisted Users during User Acceptance Testing

Environment:
HTML, .Net, Oracle PL/SQL, Rational Rose, MS Office, MS Project, Rational Unified Process (RUP), MS Sharepoint, VB Scripting

Confidential,New Jersey Aug’ 07 to Nov’ 08
Business System Analyst

The project dealt with Managing the Data Sourcing ETL for Corporate, regulatory and management reporting initiative, Retail Banking and creating a Data Warehouse for Mortgage Industry data, by grouping the data by subject area.

Responsibilities:

• The project involved creating a Data Warehouse for Mortgage Industry data, by grouping the data by subject area and building data models for the various applications, like Collections, Recoveries and Bankruptcy.
• Performed Gap Analysis on the existing Mortgage Repository and drafted the requirements to be built for the Mortgage Data Warehouse accordingly.
• Conducted Joint Application Development (JAD) sessions with Client Team, SME, end users and other stakeholders to gather business requirements and translating the same to the development teams
• Worked closely with the Data Modeler during the creation of Collections & Recoveries Data Model
• Conducted several Requirement Gathering Sessions (RGS) for gaining detailed requirements and finalizing Business Requirement Document (BRD)
• Translated Business Requirement Documents to Functional and Technical language with the help of Use cases and UML diagrams for developers
• Strategized implementation of RUP effort throughout SDLC
• Translated Business requirements to functional and technical language with the help of Use cases and UML diagrams for developers.
• Experience in Coding SQL queries during data analysis.
• Validated Technical Designs created by Technical Lead, against functional specifications
• Worked on developing Unit Test Cases, Unit Test Plans, Integration Test Cases and Integration Test Plans
• Created and coded a very flexible LoadRunner script that allowed for fast configuration changes during testing.
• Worked on risk analysis and mitigation plans, status reports, and client presentations
• Coordinated User Acceptance Testing (UAT) and assisted users during UAT. Walked them through Integration Test Cases
• Wrote queries in MySQL and Oracle for data manipulations and data analysis
• Reviewed the SQLs developed by the Dev Team and ensured that the queries are optimal and adhering to standards

Environment:
Ab Initio, SQL, TOAD for Oracle, UNIX, MS Office, MS Project, UMLet, MS Visio, MS Sharepoint

Confidential,Chicago, IL Feb’ 06 to July’ 07

Worked on a couple of projects during my tenure at Wachovia. The first Project dealt with enhancing the existing ETL sub system of the NYSE OTS (Order Tracking System) of the Brokerage Data Warehouse (DB2) to meet the regulatory requirements of the NYSE. Backfill data for 5 years to comply with the regulatory requirements of NYSE.
The second one dealt with Commingling AG Edwards Data into Brokerage Data Warehouse (DB2) and KEMSA Data Mart (DB2) as part of the Wachovia Securities and AG Edwards Merger, one of the biggest mergers in the History of Brokerage Business.

Responsibilities:

• Primarily responsible for gathering Business Requirements, Functional Requirements
• Worked with the Data Modeling team to understand and refine ETL transformation rules
• Extensive interactions with the client and the management teams to understand the requirements
• Involved in Analysis and design of the system
• Drafting the Business Requirements, System Requirements and Functional Requirements, sharing them with the Development Teams and Testing Teams and taking their comments/suggestions into account
• Holding meetings with the End Users and walking them over the updated Functional Requirements and System Requirements and following up for the necessary approvals
• Setting up meetings with Subject Matter Experts (SME’s) and taking his valuable inputs to solve various issues
• Developed Source to Target Mappings for the ETL Processes based on the Functional and Non-Functional Requirements
• Liaise with business and functional owner during risk engineering and high- level review sessions to derive and execute action plans, meeting deadlines and standards
• Review the High Level and Detail Level Design Documents prepared by the Development Teams and providing them with constructive feedback
• Review the Unit Test Plans and Integration Test Plans to see if all the test cases are captured based on the Business and Functional Requirements
• Retail lending, Retail, Auto and Home Loans
• Working with the development teams and offering them inputs during critical Production Issues
• Tracking down the details of failed Production Jobs for future course of action
• Ensure all artifacts comply with corporate SDLC Policies and guidelines
• Prioritize outstanding defects and system problems, ensuring accuracy and deadlines are met

• Informatica PowerCenter 8.6, DB2 V9, UNIX, MS Office, SQL, MS Project, .NET, SmartDraw, MS Sharepoint

Confidential,Deerfield, IL Aug’ 03 to Jan’ 06

The project involved building a Rebate Management System, focusing on profit-building solutions, but eventually helps to calculate, track, and process both bill backs and rebates related to vendor purchases and customer sales

Responsibilities:

• Responsible for defining the scope of the project and gathering Business Requirements
• Performed Gap and Risk analysis of existing system and evaluated benefits of new system.
• Designed and reviewed different comprehensive data reports using MS Access and MS Excel
• Extensively used UML based Methodology to create the Business Object Model
• Reviewed Technical Designs created by the development teams and validated them against functional

specifications and provided useful suggestions

• Created Source to Target Mapping Documents based on the Business requirements and System

requirements documents

• Worked with QA team to create Test Plan and Test Cases for User Acceptance Testing
• Entered the various defects found during System Testing and User Acceptance Testing in BugZilla.

updated the status of the defects in Bugzilla periodically, based on the progress

• Coordinated work plans between project manager and client using MS Project
• Created documentation for training and Help Desk teams
• Involved in Project Management activities like documentation and implementation throughout the

project lifecycle

Environment:
Ab Initio, UNIX, Toad for Oracle, .NET, WinCVS, FileZilla, BugZilla, MS Office, SQL, MS Project, MS Visio