Post Job Free

Resume

Sign in

Data Management

Location:
Mumbai, MH, India
Posted:
June 13, 2016

Contact this candidate

Resume:

acu7zp@r.postjobfree.com

Summary

*+ years of experience as a Business Analyst/Business System Analyst in industry domains including Financial, Mortgages, Healthcare, Life Insurance, Property & Casualty Insurance, and Engineering.

Strong knowledge of Business Analysis methodologies and Software Development Life Cycle (SDLC) using Waterfall and Waterfall- RUP, Waterfall-Scrum (hybrid) and Agile-Scrum.

Efficient using various Requirement Elicitation/gathering techniques like user interviews, workshops, email surveys, JAD sessions with clients, developers and QA Analysts and referring to existing system documentation and procedures.

Skilled in preparing Business Cases, Business Requirements Documents, Use Cases, Functional and Technical Specification Documents, Requirement Traceability, Traceability matrices, Test plans, Test scripts and Software Development Plans.

Skillful GAP analysis, Cost benefit analysis, Risk assessment and SWOT analysis.

Experienced in UML and Use Case Analysis, identifying Key performance indicators (KPI) and Change Management.

Defining Test Cases, analyzing bugs, interaction with team members in fixing errors, User Acceptance Testing (UAT), Client Acceptance Testing (CAT) and knowledge of QTP and Quality Center. Excellent knowledge in creating User Acceptance Criteria for various stages of software testing.

Experienced in managing client-interactions, project planning, scheduling and development teams.

Conducted Joint application development (JAD) sessions with relevant Subject Matter Experts to assess and document current configuration.

Experienced in using different UML diagrams including Use Case Diagrams, Sequence Diagrams, Activity Diagrams and Collaboration Diagrams.

Hands on experience with Data Warehousing, Dimensional Modeling, Data Analysis, Data loss prevention, Data Mapping and Data profiling.

Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.

Responsible for initial phases of data integration for enterprise wide Application using Service Oriented Architecture (SOA) and Enterprise Service Bus (ESB) Platform.

Strong understanding of Retail Banking, including Credit Card, Mortgage, Account Transactions, Wire Transfers, Bill Payment.

Experienced within Individual Retirement Accounts (IRA), Employer Sponsored Retirement Plans (ESR), Fixed Income Investments, Capital Market and Wealth Management domains.

Extensive experience in Investment Banking projects specialized in Securities Trading (stock trading, fixed income trading and derivatives trading), Asset management, wealth management and risk management.

Domain experience includes knowledge of CCAR, FRY9C, Equity, Bonds, Loans, Money markets, Benchmark Index, General Ledger, Credit Bills, Credit Reports, Accounts Receivable/Payable.

Knowledge of Dodd-Frank, BASEL regulatory framework specializing in the area of Liquidity Risk (LCR, NSFR), Interest Rate Risk Sensitivity, Stress Test, CCAR, Risk Management Models.

Daily tasks included gathering data, interpreting results and providing basis for operational and strategic decisions to the company's executives and working with SQL, Excel and Access to create new reports for management.

Responsible for carrying out deliverables for Basel Measurement Reporting group (BMR) in a timely and professional manner thereby adding value to the group that ensures the bank is in compliance with Basel and FINMA rules in terms of its capital requirements and exposure against Credit risk, market risk and operational risk.

Well versed with Accounting Principles and Acts (GAAP & SOX), Capital Budgeting, Equities, Fixed Income, Mortgage-backed securities (MBS), Asset-Backed Securities (ABS), Derivatives (Options, Futures, Forwards, Swaps), EWS, Credit Risk, Operational Risk, Market Risks, Commodities and Money Markets.

Experience in Capital Markets, Money markets, Trading Systems, Derivatives (Strong in Options), Equities, Fixed Income, US government Treasury Securities (T-Bills, T-Bonds and T-Notes), Municipal Bonds, Stocks Trading Cycle, Margin Requirement, Mark to Market, Hedge Funds.

Evaluated data field definitions and expected values for compliance with Basel Committee for Banking Supervision regulations version 3 (Basel III).

Worked on CCAR Credit Risk Model validation of retail and commercial portfolio for the Bank's Business lines. Complete model validation - Input data, Methodology, Code implementation, Statistical Test, Stress Testing, back testing and reporting.

Extensively involved in Data Governance process.

Worked in various technologies such as XSLT, XPATH, CSS, XML and HTML.

Extensive hands-on experience in eliciting, defining, documenting, business, functional, non-functional requirements, decomposing high-level information into details and in critically evaluating information gathered from multiple sources.

Strong SQL knowledge for querying the database and proficient in developing External Tables, Joins, Indexes, Data Modeling, Analysis, Verification, Cleansing, Transformation, Integration, Mapping, Extraction, Load Process from multiple Data Sources.

Proficient in executing Test Plans, providing Test Data, conducting unit test, documenting test cases and in Manual Testing - Functional, Database, Black Box, and in performing extensive User Acceptance Testing (UAT).

Excellent ability to converse, negotiate and liaise between the business units, technology teams and support teams.

Ability to effectively communicate across multiple levels (Executives to team members).

Technical Skillset

Web Technologies HTML, DHTML, XML, CSS, XSLT, JavaScript

Software Applications MS Office, MS Project, MS Visio, MS FrontPage, Dreamweaver, Adobe PhotoShop

SDLC Methodologies Waterfall, RUP (Rational Unified Process), Agile (Scrum)

Requirements Management Rational ClearCase, Requisite Pro, Use Cases, User Stories,

QA/Testing Rational Clear Quest, Team Foundation Server, HP Quality Center 11, QTP, LoadRunner

Project Management MS Project (PERT, Gantt charts), Excel spread sheets

Operating System Windows 95 & 2007, NT/2000/XP, LINUX, UNIX, DOS

Design Tools Rational Rose, MS Visio (UML)

Database Microsoft SQL Server, Oracle 10g & 11g, Lotus Notes, MS Access

Change Management Stakeholder Analysis, Change Classification, Prioritization, & Implementation

Other Tools Actimize, Advent Portfolio Exchange (APX)

DW/BI Tools Informatica, Cognos

Education

Master of Science (M.S.) - Organizational Effectiveness, Development and Change

University of Delaware, Delaware, USA - Alfred Lerner College of Business and Economics

Bachelor of Engineering (B.E.) - Biotechnology

Visvesvaraya Technological University, India

Professional Experience

UBS – New York, NY May 2014 – Present

Business System Analyst

UBS Investment Bank provides corporate, institutional, and wealth management clients with expert advice, innovative financial solutions, outstanding execution and comprehensive access to the world's capital markets. It offers investment banking and capital markets, research, equities, foreign exchange, precious metals and tailored fixed income services in rates and credit through its two business units, Corporate Client Solutions and Investor Client Services.

Project 1 - This project is to create a CCAR reporting application enhancements to Credit Portfolio Risk Management System. The Credit Portfolio Risk Management System provides structuring advice and credit approval on transactions by meeting regulatory requirements Basel , manages the capital and credit exposure of UBSs portfolios.

Project 2- The goal of the project was to make enhancements to existing application for the Fixed Income Trading system. The Fixed Income Trading systems serve the needs of all fixed income asset class trading desks that manage both separately managed accounts, sub advised funds and institutional accounts.

Responsibilities:

Identified, understood and documented business needs for new market risk module and credit risk module or re-usability of an existing module by performing a GAP analysis.

Performed data analytics with emphasis on credit scoring, credit risk, behavioral models, loan losses and general purpose risk/profitability models by brainstorming.

Evaluate requirements of US Basel III and requirements of Dodd Frank Act for Risk reports, such as BCBS 238, BCBS 239, BCBS 272 etc.

Experienced in CCAR Regulatory Reporting especially in FRY 9C, FRY 14M/Q/A, FFIEC 041, FFIEC 031 reports and the related schedules.

Worked with Investment SME's (subject matter experts), Financial Analysts as well as other business teams on requirements gathering.

Captured existing workflows of Firm Funding, Banking Services and Fund Transfer.

Generate regulatory report such as Basel 3, Anti-Money Laundering and CCAR with Axiom.

Enhanced the reporting system, enriched the RWA calculation function for both Basel III reports and for CCAR reports.

Created use case UML diagrams and User Interface (UI) Prototypes for various report documents and statements to detail the completion of the clearance transaction.

Assessed Credit Risk strategies with various internal credit tools and implemented Basel III strategies to augment Credit availability.

Mitigate extreme technology risk by retiring unsupported applications for the Fixed Income Trading platforms.

Integrate multiple reference data masters for securities to eliminate manual entry and operational risk.

Develop trade-related work flows for fixed income trades flowing through to the settlement and accounting systems.

Involved in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Stand ups, User Stories and Acceptance Criteria.

Created and prioritized the Back Log in JIRA, coordinated Planning Sessions and maintained User Stories and Acceptance Criteria.

Mapped financial data, general ledger data, loss event data, transaction data and people reference data from source to target database for creating a central Risk Data Repository as required by Basel III reporting regulations.

Performed data validation and data analysis to test mapping and development changes.

Assisted in creating and executing Test Cases/test scripts and documented all issues identified during the testing phase and ensured that all incidents were discovered, tracked/resolved and prepared the UA test cases for end-user testing.

Reported weekly status updates to project management and stakeholders.

As Scrum Master initiated and coordinated creating and prioritizing the Sprint Backlogs in Rally Scrum Sprint Planning Sessions, conducted Sprint Retrospectives and Reviews, sharing metrics to identify and implement improvements.

Constantly interacted with stakeholders to develop release backlog and User Stories into use case for the IT team.

Translated business requirement into technical requirements and system specifications.

Provided specifications for Data Modeling including Conceptual models, Logical models and Physical models.

Designed Trade-Break, Aggregate report formats and evaluating COGNOS as an strategic reporting tool.

Performed data analysis using SQL queries in Oracle Financial Server to implement ETL with the direct correlation to the data warehouse and data mart.

Documented Test Plan, Test cases and performed functional and stress testing.

Reported all the defects in Quality Center while conducting UAT and stress tests.

Environment: Agile Scrum, Rally, MS Project, MS Word, MS Excel, MS Visio, IBM Cognos, HP ALM, Oracle ERP.

DuPont – Willmington, DE Jun 2013 – May 2014

Business System Analyst

DuPont headquartered in Willmington, Delware is the world's fourth largest chemical company based on market capitalization and eighth based on revenue. DSR, Safety Resources a consulting division of DuPont contracted to assess their existing reports and whether they could be converted from their existing legacy systems into SAP BW/BI. The Proof of Concept (PoC) project was to demonstrate how processes can be mapped to SAP; to increase confidence that this could be done. Modules used in this project were EP, cProjects, xRPM, CA-TS, BW, PI, FICO, MM and SD.

Responsibilities:

Studied DSR AS-IS model and studied their current reports.

Installed business content for the critical reports mostly from Xrpm, cProjects and CATS.

Worked closely with various SAP functional modules like cProjects, xRPM, CA-TS, BW, SD, MM and FICO.

Worked with the stakeholders, users and business units on new development requests and provided business analysis and design using the SAP functionalities under the Sales and Distribution module, with integration to other SAP models (MM, FI/CO, PM, and BW).

Assessed gap analysis to create the appropriate changes and enhancements while determining alternative solutions.

Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.

Responsible for enhancements of custom SAP commercial invoice/packing list.

Understanding business processes and Implementing them newly in SAP processes.

Developing new reports, modifying existing reports (SAP Queries), BW Reporting.

Implementing change management requests.

Worked on SAP BW, workflow. Configured SD organizational data (sales organization, distribution channel, division, sales office, shipping points) and sales documents elements (document types, item categories, output types, SD tabs on material master, customer master, pricing conditions).

Created functional specification documents for ABAP team for system enhancements, custom reports and legacy system interfaces.

Assisted team lead on all project phases from Blueprint to Realization.

Liaison between SAP support team and business users.

Provided system and business knowledge to Corporate Trade Compliance group for a US Customs audit resulting in reduction of close to $1M in penalties.

Developed monthly inventory trend analysis package for senior management.

Environment: Requisite Pro, MS-Visio, SAP BW, MS Excel, MS Project, SQL, RUP, MS Access.

Silvercrest Asset Management – Boston, MA Jan 2013 – Jun 2013

Business System Analyst

Silvercrest Asset Management Group is an independent registered investment advisor which provides asset management and family office services to families and select institutional investors. Silvercrest currently advises on $16.7 billion for a clientele comprised primarily of families, as well as endowments, foundations and other institutional investors. Silvercrest's family office, advisory and investment capabilities are available to clients interested in investing substantial assets.

Wealth Management:

Worked extensively in wealth management activities (Value, Growth, Dividend Investing, Fixed Income investing, Portfolio Diversification (Asset Class, Geographical, investment style and type), Draw Down, System Back Testing, Technical Analysis, Option Strategies, Hedging, Pairs Trading, Futures, Indexes, ETFs etc.).

Fixed Income Investments:

Fixed income asset management, investment/Fund Accounting, Fixed income derivatives, Standard Settlement Procedures (Trade Confirmation, Cash Settlements, Foreign Exchange settlements), Fund Accounting, Reconciliation, Posting etc. Familiarity with collateral management, performance measurement, Swift, ISITC, FIX messaging. The application allowed traders and portfolio managers to trade multiple derivative instruments (exchange traded and OTC) with a common front end execution platform. The application interfaced with Reuters and Market for real time data, the accounting system and multiple VBA applications. System captures all market data needed to price & trade these products, including Recovery Curves, Default Probabilities & Correlations. It also generated credit-related risk reports – P&L, Industry Exposure, Counterparty Exposure and Issuer Exposure.

Responsibilities:

Performed business specification (BRD) and data requirements, use case models, GUI, use cases, functional specifications and data flow diagrams, ER diagrams, unit testing and beta testing to create a library of financial modeling tools for our applications for the analysis and modeling of derivatives for valuation, pricing and simulation, interest rate risk assessment, cash flow forecasting, intraday quotations from data feeds, contract specifications, trade capture, trading, trade processing and settlement, compliance, risk management as per ISDA and FpML standards/specifications for various trading platforms including Bond trading.

Collaborated with Change Management Group and IT to prepare a detailed derivatives infrastructure for trading for implementing the derivatives trading application – a diagrammatic flow of investment process, trading, data transaction between application, pricing and analytics, database, data feeds and back office integration (trade confirmations, processing, settlement, collateral management, market data), portfolio valuation including bond rating and accounting.

Made detailed research analysis & prepared a diagrammatic investment and trading process for derivatives instruments including CDS, CDS Index, CDS Options, Equity Swaps, Interest Rate Swaps and Exotic Options.

Prepared requirements for getting instruments reference data from MarkIT (for CDS, CDX) and RIMS.

Coordinated with various data feeds (Reuters, Bloomberg, Markit) for market data, reference data, counterparty data, and credit data; mapped them to the oracle database for credit derivatives pricing, corporate bonds, municipal bonds and analytics.

Performed detailed analysis and work – flow diagrams for derivatives trading which included - preparation of market & reference data, analysis & decision support, modeling a contract, preliminary instrument setup on the application.

Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos.

Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.

Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of Reports.

Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data.

Created T-SQL objects such as tables, views, joins and store procedures to meet client requirements.

Analyzed systems and data to identify functionality gaps for front end module, Trade Worksheet and Back office Module for various CDS and asset management platforms which includes fixed income, annuity, mutual funds and bonds.

Involved in manual trade data reconciliations, analyzing the chart of accounts, tracking the GL transactions and validating them from their mainframe systems.

Environment: Cognos 8.4, Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, XML, Power Designer

Delaware Hospice Inc – Philadelphia, PA Mar 2012- Jan 2013

Business Analyst

Delaware Hospice was founded in 1982 by a grassroots committee who wanted to provide better end-of-life care. Since that time, it has remained the only not-for-profit hospice in the state, committed to its mission of providing the highest quality of hospice care to the communities it serves.

The goal of the project was to implement NextGen, which is an EHR system. NextGen is customized to help Physicians and Office staffs for easy access of lab results, radiology results and documents. EHR is implemented to reduce the time invested for clinical data review and thereby helps Physicians to provide more time for patient's healthcare.

Responsibilities:

Organized JAD sessions between key surgeons, Pharmaceutical Research Scientists and Technology team.

Involved in Modeling and developing Business Requirements, Design process and providing Knowledge Transfer to the Support Teams.

Gathered Business Requirements from SME's and drafted Business Requirement Document (BRD) and presented for final sign off.

Involved in Data Gathering, Data Analysis and Management for Physician Office and Hospital Services for Electronic Health Records.

Documented functional specifications for Patient Clinical Information, Health Records, Pathology Test Ordering and Results, Physician Requirements and Hospital needs.

Worked with Physician and Nursing Informatics people to understand their current performing technology and provided inputs in NextGen applications.

Understood the Business Logic and developed User Interface Specifications.

Developed Business Flow Diagrams, Dataflow diagrams, Activity diagrams and Use cases diagrams using MS Visio.

Coordinated between Test team, Development and Business team in clarifying the Functionality issues and Requirement Specification.

Worked as a liaison between Technology and the Business clients to improve Business processes and Strategies.

Validated the following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment to a health plan).

Responsible for building and maintaining mainframe test environments for Worker's Compensation systems and the Carrier Access Billing application.

Work as Business Analyst for the project to build a MS SQL data warehouse for complex wide profitability reporting.

Was Involved in meeting with Clinical Users and Clearing Houses to determine the format of the ICD-10CPT codes.

Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.

Managed the team of consultants responsible for developing on-demand Medicaid Management System reports.

Performed custom data conversions and developed custom software for risk management applications including general ikaclaims, vehicle accident and administrative tracking.

Performed all data field mappings.

Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.

Wrote Test Cases and performed User Acceptance Testing, documented the in detail defects using the Defect Tracking report.

Involved in gap analysis and implementation of HIPAA 5010, ICD10 and Claim Validations.

Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models.

Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.

Designed and development of test cases based on functional requirements for Institutional and Professional claims for EDI and HIPAA Transactions 837/835, 834, 276/277, 270/271 testing.

Coordinated UAT with the stakeholders for Pilot and Go Live implementations and support.

Environment: Requisite Pro, Rational Rose, Agile, PL/SQL, Six Sigma, HTML, MS Office, MS Visio, EDI, UML.

Prospect Mortgage – Sherman Oaks, California Dec 2011 – Mar 2012

Business Analyst

Prospect Mortgage is one of the largest independent residential retail mortgage lenders in the United States. It is a leading lender offering a full range of quality home loans, including FHA and VA, conventional, jumbo, renovation and more. Worked on the Analyzer reporting tool, project. This was an intranet application designed keeping the clients analysis and reporting needs in mind. The in-house mortgage application was one that enables the mortgage specialist to view customer applications and verify their status. The application also enabled the specialist to view if the customer had any existing mortgages, loans and commitments, details of credit card balances, etc. Depending on the varied customer information the specialists would offer the customers various options, Interest only options, Repayment mortgages, advice them on variable type of interest rates Variable rates, ARM, fixed rates, etc. The application also consisted of another interface called Pre-value a calculator that considered monthly income, debt, available cash, term and rate of the current user showing the home value that the customer could afford.

Responsibilities:

Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.

Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities.

Created cash flow models for Mortgage Backed Securities, Whole Loans, Structured Securities using Bloomberg, Intex and ADCO data.

Interacted with Software development team and Business users as a liaison in helping developers to understand the business requirements thereby ensuring the proposed applications comply with the business specifications.

Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.

Analyzed information and requirements and documented them. Reviewed the Business Requirement document and detailed the Systems Requirement document.

Designed different document templates to gather Business Requirements, Change Requests and UAT.

Worked with QA testing team to design test methods to verify the applications functions of consumer loan, home equity, refinance and commercial loan activities.

Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.

Analyzed the system to be implemented for production to ensure that it handles incomplete and accurate data and performs default method of calculations for various mortgage products like Mortgage Backed Securities, Asset Backed Securities and Megas & Tranches.

Met with different business users to determine user requirements and goals.

Conducted presentations to make users understand about the processes.

Prepared project plan and defined different milestones.

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML.

Discussed different functional requirements and defined high level design and Use Cases.

Developed process flow diagrams (flow charts) using MS Visio in an effort to identify and analyze process flows in the RBC Safe Deposit Box system.

Used MS Excel and MS Word to create a field-to-field data map that was used as a main specification document for the conversion program.

Developed traceability matrix for maintaining/updating system requirements using MS Excel.

Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met. Identified and participated in resolution of business system issues.

Environment: Rational Rose, Requisite Pro, MS-Visio, MS-Excel, Advent Portfolio Exchange (APX), Microsoft Project, Oracle10g

Prudential Financial – Newark, NJ (Offshore) Oct 2008 – Dec 2011

Business Analyst

Prudential Financial, Inc. is the holding company which owns The Prudential Insurance Company of America, is an American Fortune Global 500 and Fortune 500 company whose subsidiaries provide insurance, investment management, and other financial products and services to both retail and institutional customers throughout the United States and in over 30 other countries. Principal products and services provided include life insurance, annuities, mutual funds, pension- and retirement-related investments, administration and asset management, securities brokerage services, and commercial and residential real estate in many states of the U.S. Prudential major products include Life & Protection (L&P), Individual Savings & Retirement (IS&R), Individual Retirement Accounts (IRA), Employer Sponsored Retirement Plans (ESR), and Employee Savings & Pension (ES&P) divisions,401(k), 401(a), 403(b) and 457 services.

The project was to design and implement a Web-based application to provide rating and quotation services for Prudential life insurance products. Major functions of this system include census entry, prospect data collection, qualification, site match determination, benefit selection, rate calculation with compliance and user adjustments, and proposal generation.

Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.

Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of Rational Unified Process effort in different iterations and phases of the Software Development Life Cycle.

Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.

Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.

Perform Gap Analysis of the processes to identify and validate requirements.

Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.

Facilitated Joint Application Development sessions and facilitated stakeholder meetings to identify business process and requirements; exhaustive management of project requirements using CaliberRM.

Conducted meetings and understood the requirements of the sales and marketing team.

Organize requirements into high level Use Cases and low level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.

Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.

Used MS Sharepoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.

Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.

Conduct data analysis using SQL & Excel as part of requirements analysis and to assist data quality teams.

Performed Data mapping, logical data modeling and ER diagrams and used SQL queries to filter data.

Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.

Coordinate and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.

Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.

Review the Test Plan developed by the testing team for testing the application.

Assist the QA personnel in the creation of Test Cases using Rational Test Manager.

Environment: Javaa, Caliber RM, UNIX, Rational Req. pro, clear case, Rational Rose, Clear Quest, UML, Ms Visio, Ms Project.



Contact this candidate