SUMMARY

• Over 7+ years experience in the IT industry as a Business Analyst/Systems Analyst/Data Analyst in Finance, Banking industries.
• Strong experience in working with different SDLC methodologies like Agile, RUP and Waterfall.
• Experience in creating and maintaining the requirements definition documents that included Business requirements and Functional requirements which includes use case narratives, use case diagrams and User Stories
• Expert in Data Quality Management techniques like Data Profiling, Data Cleansing, Data Integrity, Reference Data and Data Security, Data mining etc.
• Strong experience in Data Analysis, Requirement Analysis, Business Modeling, Data Migration, Dimensional Modeling (Star and Snowflake Schemas).
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools and maintaining Test Matrix and Traceability Matrix and performing GAP analysis.
• Strong experience and skilled in creating UML Diagrams like Use Case, Activity and Sequence.
• Skilled in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data using Informatica and SSIS.
• Excellent Business writing skills in writing Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Systems Requirements Specification (SRS), Business requirement specification (BRS), Data Flow Diagram(DFD)
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Well versed in writing SQL query for Validation & creating database Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the database.
• Proficient in conducting Joint Application Development (JAD) sessions with end users, use case walkthroughs, expert and quality assurance teams for project meetings.
• Thorough understanding of Testing Phase of SDLC, including experience in Black - Box Testing, User Acceptance Testing (UAT), as well as identifying various test scenarios and training of end-user.

TECHNICAL SKILLS

Methodologies: SDLC, Waterfall, Agile- Scrum,RUP

Operating System: Windows 2008/XP/2007/2003, Linux, Unix, Mac OS X

Project Management/ process design Tool: MS Office suite, SharePoint & Project, Rational Rose, Requisite Pro, Lotus Notes, PeopleSoft, Crystal Reports.

Web Designing: MS Visual Studio, Adobe Dreamweaver, MS Expression web/blend, iRISE, Adobe Photoshop.

Defect Tracking: Test Director/Quality Center, HP Quality Center, HP Win Runner, HP Load Runner, Microsoft Test Management tools, JIRA

Database: Microsoft SQL Server, MYSQL, Oracle 7i, 8i. MS Access.

Language: C/C#, .net, Java.,J2EE XML,TSQL

Application environments: C#, .NET Framework, ASP.NET, PDF, .NET Web Services, SSIS/ SSRS/ SSAS

PROFESSIONAL EXPERIENCE

Confidential, Newark, DE

Business Analyst

Responsibilities:

• Conducted one-to-one interview sessions and JAD sessions with stakeholders, SME’s and business owners to document the vision and scope of the project.
• Finalized and documented the Business Requirement for the application with various key stakeholders.
• Identified the impact on the existing services of Business Units, local impact of the transition on the organization and documented the To be process.
• Conducted the Data Analysis and identified the Data quality issues using Data profiling methodologies.
• Created dashboards to review the progress and used JIRAfor prioritizing issues/bugs and created meeting minutes to summarize discussions.
• Identified/documented data sources and transformation rules required to populate and maintain data ware house content.
• Involved in creating activity diagram along with swim lane to show the process of loan system.
• Wrote Sql query to extract data from data ware house and performed data analysis.
• Prepared the Dimension models and validated the models with the business requirements for the data ware house.
• Prepared Data Cleansing methodologies by relating them to DQ issues.
• Captured and finalized requirements by producing Wireframes, Prototypes and Storyboards using Serena and Visio forscreen/UI designing using specified style guide and specifications.
• Created Validationscriteria and Test Scenarios'from Use Cases and Technical Documents for the purpose of developingTest Plans,Test Cases, and FunctionalTests.
• Involved in execution of test case and maintained test traceability matrix.
• Involved with reviewing defects reported from UAT efforts and analyzed for root cause and took actions based on the findings.

Environment: DOORS, Rational Rose, Rational Clear Quest, UML, swim lane, Microsoft Office suite 2007, MS Visio, Serena, iRise, SQL Server 2012, MS SharePoint, JIRA, Crystal Reports

Confidential, Minneapolis, MN

Business Analyst (data analyst/BI reporting)

Responsibilities:

• Worked with Managers, IT professionals and Senior Management to ensure that projects are properly defined and deliver expected efficiency gains, revenue enhancements, increased customer-service levels and/strategic advantages.
• Involved in gathering requirements from the investor through interview questions and survey.
• As a scrum master facilitated of all aspects of the scrum framework, including sprint planning sessions, backlog grooming sessions, daily scrums, product demos, sprint reviews and sprint retrospectives.
• Involved in creating process flow and swim lane diagram for the system based on instruments.
• Written the specifications for the Data mapping and Reporting specifications.
• End-to-end development of the new source providers to integrate the data in the existing Data Warehouse.
• Used various SQL commands like create, delete, update, left joins, right joins and full joins to update the database and retrieve data for analysis from data ware house.
• Developed and implement streamlined processes and key KPIs (Key Performance Indicators) to reduce cost and increase customer loyalty.
• Involved in analysis of various types of risks (Credit Risk, Market Risk) which impact the portfolio management.
• Developed test cases and test scripts for system and UAT testing.
• Prepared traceability matrix using MS Excel to trace the requirement progress and change control.

Environment: Rally, Agile, Microsoft Office suites (Word, PowerPoint, Access, swim lane, Excel, Outlook, Project, Visio), Windows, Microsoft SQL Server 2008, Oracle (9i & 10g), UML, SQL, Cognos, Quality Center (v8.2 & v9.2).

Confidential, Atlanta, GA

Business Analyst (ETL)

Responsibilities:

• Worked with business teams on requirements gathering to capture the Business Requirements of all the Business Processes and created use case and process flow diagrams.
• Conducted GAP analysis between the old and new system by doing current state assessment of the entire data warehousing & ETL process.
• Involved in end user training and support for new source providers.
• Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Designed and developed Informatica Mappings to load data from Source systems.
• Studied the Gap analysis for the proposed reports with the existing Data, for the feasibility of reports.
• Wrote data mapping specification for the data migration from source to target data ware house.
• Involved in writing ETL specification document for the data ware house.
• Written specifications for the additional data captures.
• Worked on Reference data, Source to Target Data Mappings, Data Element Mapping, Functional Element List, Report layout templates and prototypes.
• Designed the dimension models for the data marts and validated against the reports.
• Conducted review meeting to continuously assess the status of project with regard to project plan and controlled iterations of the deliverables in conjunction with UAT’s bugs or revision.
• Managed project performance and reporting through project scorecards and milestone reports

Environment: PMBOK, UML, MS Office Suite, Rational Clear Case, swim lane, Doors, IBM Web Sphere, XML, HP Service Centre Caliber, Java, Oracle, MS Visio, DB2, Sybase, SQL Server Reports, Quality Center

Confidential, Houston, TX

Business Analyst (Reporting)

Responsibilities:

• Experience in supporting the full Software Development Life Cycle (SDLC) in Agile (Scrum) methodology.
• Documented the AS-IS Business Workflow adhering to UML standards. Comprehensively performed requirement gathering for enterprise reporting system-using Requisite Pro.
• Participated in JAD Sessions for gathering requirements from SME'S. Played the role of a Facilitator in the JAD session.
• Knowledgeable in the ETL process used by the Data Stage System designers used for extracting data from heterogeneous source systems, transforming and loading the data into the data warehouse/ data marts.
• Documented data flow diagram and swim lane diagram for the process.
• Performed extensive business process analysis including Data Mapping, Data analysis and GAP analysis. Involved in version control management for storage and distribution of documentation using Rational Clear Case.
• Understanding of Trade Life Cycle & Middle office functions. Responsible in the back office operations such as accounting and human resources are in place to hold the business together from a financial and legal standpoint.
• Worked with end users to define, implement, and maintain their reporting requirements.
• Developed strategies with Quality Assurance group to implement Test Cases in Quality Center for stress testing and UAT (User Acceptance Testing)

Environment: Rally, Oracle, .Net, Windows XP, Acrobat Pro, Lotus Notes, swim lane, MS Suits, SharePoint server, MS Showcase, Rational RequisitePro, Rational Rose, SQL Server 2008R2, Data stage, Win Runner, Quality center and Load Runner.

Confidential, Providence, RI

Business Analyst

Responsibilities:

• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Followed a RUP (Rational Unified Process) centric business analysis methodology.
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, and process and revenue streams.
• Collaborated with development architect and the business users to develop both high-level and detailed application architecture to meet the business needs.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Collaborated in building a business analysis process model using Rational Rose, Requisite Pro and Visio
• Participated in the logical and physical design sessions, developing design documents.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, for OOD using Rational Rose.
• Performed requirement analysis, and detailed examination of all the use cases and issue logs.
• Worked with Data Extraction, Transformation and Loading.
• Metadata architecture was also provided, for the purposes of query enhancement and clarification of data relationships (Use point in earlier project).
• Provide ad-hoc data to internal and external requests from the business users.

Environment: .NET, Windows XP, PHP, Rational RequisitePro, UML, Rational Clear Quest, MS Word, MS Project, MS PowerPoint, and MS SQL Server, salesforce.com.

Confidential

Technical Analyst

Responsibilities:

• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Designed ER diagrams and created level 3 Process models.
• Created the Logical/Physical Data models, defining attributes and Relationships using the ERWIN 3.5.
• Created database objects like tables, views, procedures, packages using Oracle tools like PL/SQL developer and SQL* Plus.
• Designed and developed a custom package which extracts supplies used by the customer, information about current stock in inventory.
• Administered and maintained Concord ehealth, an enterprise NMS server
• IP address management as the network consisted of large no. of nodes, switches, L3 switches and route.
• Team member in various video conferencing events, worked on Polycom, RAD and Tandberg video conferencing endpoints

Environment: Java J2ee, Windows XP, MS Visio, MS Project, MS Office, MS SQL Server.