SUMMARY

• Over 7+ years of experience in business system analysis and data analysis wif focus on product and process management.
• Exposure in overall SDLC*Waterfall, Agile etc) including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• Experience of working wif functional project management teams in a dynamic agile environment.
• Experience in analyzing market data to make intelligent product and project management decisions and charting the source to target map.
• Experience in Business Intelligence (BI), Business Data warehousing tools and SaaS.
• Monitoring and interpreting financial information for the organization.
• Extensive experience in Project and Product Management methodologies, Microsoft SQL Server database management, OBIEE.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Experience in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Experience of working wif different departments such as human resource, finance, administration and sales to develop better plans for the product and making TEMPeffective changes to the product before launching it to the market.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Facilitated data requirement meetings wif business and technical stakeholders and resolved conflicts to drive decisions.
• Experience in various projects involving financial and banking systems like Loan Origination and Foreclosing System, Tax automation system and invoicing and payment system.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Experience in reviewed and recommending improvement to portfolio management strategy
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive noledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions - Type me & II in Dimension tables as per the requirements.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Created, documented and maintained logical and physical database models in compliance wif enterprise standards and maintained corporate metadata definitions for enterprise data stores wifin a metadata repository.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Developed mapping spreadsheets for (ETL) team wif source to target data mapping wif physical naming standards, data types, transformation rules, domain definitions, and corporate meta-data definitions.
• Exceptional communication and presentation skills and established track record of client interactions

TECHNICAL SKILLS

• MS Word
• MS Excel
• MS PowerPoint
• MS Project
• MS Visio
• MS Analysis Services
• MS Access
• MS SQL
• Oracle 10g
• Windows XP
• Windows 7

PROFESSIONAL EXPERIENCE

Confidential, DALLAS, TX

Business/Data Analyst

Responsibilities:

• Involved in the entire SDLC of the project. Focus on Business system analysis including requirement & Analysis, design, development, SaaS, QA support, UAT and Implementation.
• Gatheird Requirements and data from key stakeholders, customers and subject matter experts to define the scope of the project.
• Analyzed and developed the product strategy and roadmap for development and deployment in an Agile environment.
• Studied in-house requirements for the Data warehouse to be developed.
• Conducted one-on-one sessions wif business users to gather data warehouse requirements.
• Helped in developing user stories and deriving trends from them to substantiate the project epic.
• Analyzed clients' needs based on their current financial situation and proposed financial solutions designed to satisfy client goals and implemented the financial plan.
• Specifying market requirements for current and future product development by analyzing the data collected by market research supported by on-going interactions wif the customers and non-customers
• Organized periodic reviews to measure the success of the financial plan and to make necessary adjustments in the financial data.
• Involved in gathering, analyzing and documenting business and product requirement specifications and developing functional and data specifications based on them.
• Analyzed database requirements in detail wif the project stakeholders by conducting Joint Requirements Development sessions.
• Worked wif the stakeholders and product owners along wif scrum masters and teams to ensure user stories have business value and create good product backlogs.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1.
• Used forward engineering to create a Physical Data Model wif DDL that best suits the requirements from the Logical Data Model.
• Worked wif Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated and documented detailed business, product development criteria, rules and Use Cases based on requirements analysis.
• Facilitated development, testing and maintenance of quality guidelines and procedures along wif necessary documentation.
• Responsible for defining the naming standards for financial data warehouse.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Used Model Mart of Erwin for TEMPeffective model management of sharing, dividing and reusing model information and design for productivity improvement of the financial service.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Integrated the work tasks wif relevant teams for smooth transition from testing to implementation.
• Attended multiple extensive training and periodic meetings daily on prospecting, product management, client development, sales process techniques and financial service management.

Confidential, Tempe, AZ

Business Analyst

Responsibilities:

• Performed stakeholder analysis to identify key players for project success.
• Identified and involved all key stakeholders, contributors, business, operations and technical resources that must participate in a project and ensured that contributors are motivated to complete assigned tasks wifin the parameters of the project plan.
• Prepared BRD and FRD to confine the appropriate claim processing system in the systematic way for the users.
• Worked wif the tax management team on tax automation on e-transactions and online financial transaction management.
• Facilitate the cash improvement and managed credit risk by improving the transaction efficiency by adopting ERP concept of OTC(Order to cash).
• The SDLC Methodology was used to initiate the system application in (RUP) Rational Unified Process.
• Facilitated Joint Application Development (JAD) sessions to refine and modify the collected requirements from users and proceeded to the functional specifications.
• Actively participated in gathering, analyzing, and writing business requirements.
• Collected and documented business processes as well as business rules.
• Provided key input in working wif users in defining project and system requirements.
• Translated the business needs into system requirements and communicated wif the business on a non-technical level.
• Assisted in building a business analysis process model using Visio.
• Documented the Functional Specifications Document using UML and Visio.
• Scheduled meetings wif developers, systems analyst and testers to collaborate resource allocation and project completion using MS Project.
• Created use cases using Visio and involved in managed the functional requirements life cycle.
• Responsible for creating business flow diagrams using MS-Visio.
• Created product documentation, including online help, printed user manual, and training materials.
• Efficiently responded to client inquiries and resolved discrepancies.
• Identified, prioritized, tested essential business functions to assure compliance wif vendor and internal auditing.

Environment: Windows XP, Microsoft Project, MS Office (Word, Excel, PowerPoint), MS Visio, Visual Studio. SDLC

Confidential, Minneapolis, MN

Business/Data Analyst

Responsibilities:

• Performed Data Analysis, created gap analysis document, and performed data quality Checking.
• Created numerous temporary, derived, permanent and volatile tables.
• Worked on automation of the AP process to shorten the AP cycle.
• Used Teradata OLAP functions like random, qualifies, top n, sample and random.
• Teradata SQL performance tuning.
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, SAS, procedures, packages, functions, database triggers.
• Prepared test plans using business requirements, data mapping documents and technical specifications
• Performing data mapping for the application, confirm and vacillating the requirement at time of testing.
• Performed complex ad hoc SQL queries from BAs in Teradata SQL Assistant.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin the Oracle database.
• Created pivot tables in Excel by getting data from Teradata and Oracle.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Maintained data consistency, database integrity and reported instances of data corruption.
• Interacted wif end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects reports.

Confidential, Irving, TX

Business/Data Analyst

Responsibilities:

• Elicited requirements using interviews, document analysis, requirement workshops, business process descriptions and workflow analysis.
• Provide IT/Business support to failing start-up and normalized operations wif internal controls and well-structured and optimized budgeting, financial reporting, cash flow, accounts payable, and accounts receivable management processes.
• Developed, documented, and trained at REI for applying the art of User Acceptance testing as a means of measuring customer satisfaction and improvements to internal process.
• Managed a team that led the launch of a new website that implemented best of class ecommerce practices that include guided navigation, dynamic promotion, click paths, checkout, personalization, SEO friendly site structure, merchandise rating and reviews, dynamic and rich product imagery, video, wish list, sharing, click to chat, product bundles and cross-sell/up-sell, social integration.
• Conducted study of product and application wif specific business rules and practices.
• Participated in JAD sessions for gathering requirements from Users, SMEs, and Developers.
• Played the role of a facilitator as well as Scribe in the JAD session.
• Reengineered claims search process for multiple applications.
• Followed a structured approach to organize requirements into logical groupings of essential Business Processes, Business Rules, Functional and Non-functional Requirements.
• Developed Use Cases from Functional Requirements and Use Case scenarios and visualized those using UML diagram (Activity Diagram) in MS Visio.
• Followed the Agile Methodology.
• Developed a Traceability Matrix to keep track of requirements, Use Cases and Test Cases.
• Reviewed designs wif stakeholders and revised and improved the design concepts through Iterative UI prototyping and UI walkthroughs.
• Reviewed Test Plan and Test Cases to ensure that they met the requirements.
• Organized meetings to discuss outstanding issues wif QA and developers.
• Managed all requirements, making it available to all team members through a centrally available matrix.
• Coordinated UAT wif the SMEs to make sure that all the Business Requirements are addressed in the application.
• Acquired the business sign-off on the Business Requirements Document (BRD) and Functional Requirements Document (FRD).

Confidential, Dallas, TX

Business-IT Analyst

Responsibilities:

• Supported e-commerce and product and process optimization wif implementation of distributed order management and automated reporting systems.
• Using a wide range of techniques to capture business requirements.
• Identifying an organizations strengths and weaknesses.
• Working wif business owners to develop solutions.
• Assisting in the preparation of business proposals.
• Documenting, testing and implementing software updates.
• Identifying client business requirements.
• Defining project scope and objectives.
• Preparing and analyzing financial performance information.
• Allocating junior staff to tasks and then tracking the progress of their work.
• Making sure that all tests are conducted and documented according the standards agreed upon.
• Identifying and managing any anticipated resistance or risks.
• Involved in the definition of roles and responsibilities.
• Carrying out business improvement reviews.
• Meeting wif project teams to review deliverable and deadlines.
• Producing test plans and scenarios on behalf of the business.