PROFESSIONAL SUMMARY:

• Business Analyst with Six years of industry experience in Data Analysis, data modelling, process flow, quality assurance skills, MDM Data Analysis / Data Profiling and ETL development and design
• Expertise in creating Data Analysis / Data Profiling reports highlighting data anomalies, need for standardization, data quality and suggestions towards developing a MDM system
• Extensive experience in testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Experience in IBM Master Data Management Server MDM with Party and Account domains and working for the customization of MDM Platform
• Good command over Logical and Physical entity relationship data modeling using Erwin, Oracle Designer and Power Designer.
• Having experience of different MDM editions IBM MDM ionfosphere
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Strong knowledge of all phases in Software development life cycle SDLC and the iterative Rational Unified Process RUP
• Developed the Product MDM solution that was acquired by IBM.
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data and other SAS application for data updates, data cleansing, and reporting
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Performed data entry and reconciliation as well as back end data systems maintenance work using MDM tools Informatica and SQL language programming
• Design and review of various documents including the Software Requirement specifications SRS , Use Case Specifications, Functional Specifications FSD , Systems Design Specification SDS , Requirement Traceability Matrix RTM and testing documents
• Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• IBM InfoSphere Streams, and IBM Content Analytics for search and having experience with IBM Rational Team Concert IBM InfoSphere Information Server 8.5/8.1/8.0/7.5/7.0 .
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Experience in Data Transformation, Data Loading, Modeling and Performance Tuning.
• Strong in database design, domain modelling and ER diagrams design
• Well conversant with scripting languages like Java Script, VB Script, HTML, DHTML, and XML.
• Highly motivated and a self starter with excellent communication and interpersonal skills
• Strong analytical and problem solving skills, capable of addressing relevant facts and recommending solutions.
• Used Team Site Content Management Tool to deploy and manage the content managed files.

TECHNICAL SKILLS:

Windows NT/98, XP, 2000, Unix, MS Office suite, Rational Suite, MS Project, IBM MDM infosphere, IBM MDM, SQL Server, Oracle, MS Access, DB2, Mainframe,HTML, XML, RUP, OOAD, UML Business/Data Modeling, ER modeling, Requisite Pro, MS Visio, Test Director, Quality Center, Quick Test Pro, Load Runner, MS Visio, Rational Rose, Virtual User Generator, Java, J2EE, SQL, ASP.NET, UML, Visual Basic, C, C , SRS, Use Cases, UML diagrams, FRS, UAT, Test plans cases, Business Process Modelling, Project Planning tracking

PROFESSIONAL ACCOMPLISHMENTS:

Confidential

Designation: Business Analyst

This project involved developing a Data Warehousing System for several business areas including mortgage administration, loan monitoring, and inspection, ESCROW and default collections. The three major components of the system were ETL, Data Warehousing and Reporting for several business areas. Reviewed and assessed information gathered, defined key facts and issues, identified potential problems and facilitated problem resolution

Project Responsibilities:

• Analysed the requirements and segregated them into high level and low level Use Cases, activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Initial Solution Design using IBM MDM v11 software.
• Identified and addressed data issues that affect data integrity using MDM standards
• Analysed User Requirement Document, Business Requirement Document BRD , Technical Requirement Specification and Functional Requirement Specification FRS .
• Was responsible for indexing of the tables in that data warehouse.
• Used senior level SQL query skills Oracle and TSQL in analyzing and validating SSIS ETL database data ware house processes.
• Contributed in troubleshooting support of IBM MDM infosphere 10.1/11 by applying fixes from IBM fix central.
• Maintained and managed the cutover activites for the implementation of the MDM deployment to production in the form of a project plan to ensure that the deployment is smooth.
• Created current and future state processes, along with prototype BPM solution at medical device company
• Analyzed the data warehouse project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analysed.
• Responsible for physical/logical data modeling metadata documentation user documentation and production specs.
• Identify business rules for data migration and Perform data administration through data models and metadata.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Created project WBS work breakdown structure , allocated resources to projects and project activities in PeopleSoft and Clarity project portfolio management tool
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse EDW .
• Prepared the logical and physical models for the new database that is being built.
• Create and maintain requirements, test cases and defects in Mercury Quality Center
• Gathered, Analyzed and Translated systems requirements into technical specifications utilizing UML and RUP methodology.
• Wrote Test cases for Enterprise Data Warehousing EDW Tables and Data Mart Staging Tables.
• Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client's legacy system.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Worked on data extraction, analysis, refining, migration and loading of data into MDM database through ETL process.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Developed, modified, validated and implemented SAS programming work.
• Extracted data from disparate sources by SAS/ACCESS.
• Preparing BRD, Business Cases, and presentation to the clients, Business Re-engineering proposals.

Confidential

Designation: Business Analyst

Farmers insurance provides a wide variety of insurances ranging from Auto/Home to commercial it is one of the leading Property Casualty insurance companies, which provides various insurance products for personal and commercial lines of business to the customers through independent network of insurance agents. Farmer sells its insurance through a web application known as Point of Sale. This application is used by Farmers Insurance independent agents and Hub users Farmers Employees . This application supports backup for different lines of businesses like Personal Auto, Homeowners, Commercial Auto, Business owners, Workers Compensation and Claims.

Project Responsibilities:

• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• IBM Initiate broker configuration for data sync with sources and message processing based on source priority.
• Gathered requirements and modelled the data warehouse and the underlying transactional database
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• IBM Initiate broker configuration for data sync with sources and message processing based on source priority.
• Loading huge volume of delta which can rise up to 12 million during promotion activities through Datastage into MDM database
• Assisted in creating the Physical database for MDM and the Data Mart.
• Integrated and implemented MDM, business intelligence BI and data warehousing DW / EDW solutions
• Created technical impact documents, data mapping documents and defines ACORD mappings for various interfaces based on knowledge of business needs and working closely with senior department managers and key department members with limited supervision.
• Wrote Test cases for Enterprise Data Warehousing EDW Tables and Data Mart Staging Tables.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Coordinating with onsite counterpart and gathering day to day activities related to functional, technical and testing aspects of the project with main focus on MDM Product
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Analyze data in various applications, mapping the data between various source systems and ensuring the accurate importing of data to MDM.
• Created use cases to depict the interaction between the various actors and the system and created data flow models, data quality analysis and performed cost/benefit analysis.
• Generated Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model, and Visio to depict process flows and PowerPoint presentations
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Used BEA BPM Tool to map Process flows and migrated Visio Process flows into BEA Tool.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Engaged in different phases of SDLC of the project executing RUP methodology of iterative software development from Inception to Transition phase.
• Extensively used the UML methodology to create various use case diagrams for the system. Authored Use cases, Business Requirement Documentation, and System Requirement Change Request.

Confidential

Designation: Business Analyst

Credit Suisse, the second largest Swiss bank, operates in three segments: Investment Banking, Private Banking, and Asset Management. Personal Banking involves opening and maintenance of checking, savings, recurring deposit accounts and personal loans. The web-banking project was developed in .NET environment. It is an online banking application that enables customers to access their checking and savings accounts, and credit card account using the Internet.

Project Responsibilities:

• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM Master Data Management .
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse EDW .
• Meet expectations and deadlines for story based Agile software team's operations, MDM team liaison.
• Experienced in various aspects of Master Data Management MDM , Data Cleansing and Data Profiling. Experienced in migration and conversion of data to/from various data sources.
• In charge of comprehensive Data Quality by making sure invalid, inconsistent or missing Obligor Risk Ratings are reported to portfolio managers for remediation and ensure that checks are in place to prevent the issue from re-occurring.
• Used Master Data Management MDM technology, tools to create and maintain consistent and accurate lists of Master Data.
• Used master data management MDM to define reference data
• Create and maintain data model/architecture standards, including master data management MDM
• Created customized reports in Charles River such as commission analysis report, boxed position report, take-over report, and compliance report etc. using Crystal Reports, Excel VBA and SQL.
• Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Transformed project data requirements into project data models.
• Wrote Test cases for Enterprise Data Warehousing EDW Tables and Data Mart Staging Tables.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Implemented the entire Rational Unified Process RUP methodology of application development with its various workflows, artifacts, and activities.
• Implemented RUP and followed iterative approach followed Use Case driven process for requirement documentation and deployment.
• Produced functional decomposition and logical models into an enterprise data model.
• Worked alongside Users/SMEs Subject Matter Experts to recommend and gather low-level business processes and convert them into technical requirements for the development team, at various stages of the SDLC System Development Life Cycle .
• Used master data management MDM to define reference data
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.

Confidential

Designation: Business Analyst

The project was about creating an online application which gives customized rates and structures to the mortgage brokers. The project involved porting the existing client-server application to a web based application which can be accessed by the brokers and loan officers and users from the different locations. This online application also gives the users the ability to use various tools like mortgage qualification, mortgage payment, refinance, debt consolidation and monthly payment calculators.

Project Responsibilities

• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Performed validation and testing on the metadata in the in house metadata tool CDM.
• Written Test Plan and Test Strategy for both BID Data Project and Billing.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Created Graphical representation of reports such as Bar charts, Pie charts etc as per the End user requirements using Business Objects and Crystal reports.
• Involved in Gap analysis of processes As-Is and To-Be Processes within the organization for implementation of RUP methodologies.
• Prepared test cases for data validations between Data Mart to data cubes.
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Created Use Case Models, Analysis Models, Design Models, Implementation Models, Use Case Diagrams, Behaviour Diagrams sequence diagrams, collaboration diagrams, activity diagrams and Class Diagrams based on UML methodology using MS Visio.
• Determined the Release, Stage and Future Book of Work for deferred Change Requests.
• Conducted project related presentations and provided reports to the higher management. Interacted with the Helpdesk team to investigate and resolve production issues.