SUMMARY

• 7+ years of Industry experience as a Data/Business Analyst with solid experience in Information Technology with expertise in data warehouse design, development, implementation and maintenance. Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Microsoft Word, Power Point, Access and Lotus Notes.
• Strong noledge in Portfolio Management, Performance Measurement, Fixed Income, Equity, Credit Derivatives, Interest Rate Derivatives.
• Expertise in Project Management me.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Sound Knowledge of data architecture concepts, data warehouse and DataMart.
• In depth noledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategyData Warehouse Data Modeling and Design.
• Experience with data migration (ETL development), document data manipulation processes and scripts
• Extensively worked with WINTEL, a computer running Windows on an Intel processor, created RAID volumes to improve overall performance.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Developed extensive SQL queries using Query Manager against oracle database for data verification and backend testing
• Responsible to Track, Document, Capture, Manage and Communicate teh Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artefacts produced by teh teams across teh deliverables for a project
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as teh lead of teh Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. Business Data Analyst

Responsibilities:

• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Experience in AML & Trade Surveillance tools such as Actimize and good understanding of related topics.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues for Basel II Credit Risk Mitigation System (CRMT)
• Coordinates regulatory, information security and compliance project activities and participates in project meetings with matrix partners and staff providing data resources and resources to support business ventures.
• me have held teh position of Data Warehouse Specialist - Procurement.In this position
• Responsible for teh development and maintenance of teh SAS code and related processes for teh CCAR schedule template data generation and reporting.
• Developed BRD documents for Securitized Inventory (CMO, ABS, MBS, and ABCP). BRD targeted new Basel II Compliance requirements.
• Analyzes reports and other data for use at Market, Compliance and State Agency levels being able to deliver, present, feedback to vendors and management, while promoting compliance regulatory, privacy and information security.
• Perform Financial Statement Analysis (FSA) relating to Fund of Funds (FOF) Portfolio Valuations in comparison to teh financial statements of teh underlying securities & brokerage reports.
• Involved in designing and developing Data Models and Data Marts dat support teh Business Intelligence Data Warehouse.
• Worked as a Data Analyst in order to gather requirements and reaching each and every deadline well ahead of teh time line. Methods employed were in compliance with IIBA standards.
• Extensively researched and collected teh customer financial documentations and completed research for suspicious activity reports on KYC, AML, and BSA analysis reports for flagged accounts
• Associated extensive backend testing to verify correctness of teh report data using SQL scripts and data comparison.
• Participated in noledge transfer meetings and discussions with consumer management and BSA/AML Officer.
• Lead multiple project teams of technical professionals through all phases of teh SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, WebSphere and Cognos.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within teh Oracle database.
• Created a test plan and a test suite to validate teh data extraction, data transformation and data load and used SQL and Microsoft Excel.
• Reviewed teh data model and reporting requirements for Cognos Reports with teh Data warehouse/ETL and Reporting team.
• Worked with developers to make sure dat they understood teh Use Cases.
• Obtained Data requirements, identified data sources, determined teh content of data fields and created Data Mapping Documents and performed Data Extraction and Data Compilation using SQL queries.
• Worked with teh Business, Operations, and Engineering stakeholders to define teh functional integration and end-2-end test cases for teh CRM project.
• Used Requisite Pro for teh Requirement Documents Preparation and Prepared Business Process Models dat includes modeling of all teh activities of teh business from teh conceptual to procedural level. Followed top down, levelled technique for building Business Process Models.
• Worked with key members from various cross-functional teams to analyse various third-party CRM solutions to make a ‘buy vs build’ decision. Conducted cost/benefit and impact analysis.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified teh Key Changes, and participated in Stakeholder Management to communicate TEMPeffectively with them
• Creation and maintenance of Relational Databases for information access and dissemination using MS-SQL Server, MS-ACCESS and Windows Server
• Conducted current state study which included data collection methodologies, data quality and data integration problems, data storage and infrastructure related issues.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Documented business workflows textually as well as in UML diagrams (State diagrams) according to RUP, for teh stakeholder review.
• Data conversion from other platforms to native database. Creating Customized modules or data maintenance.
• Performed all necessary programming, testing and documentation for COBOL, DB2 batch programs and sub-routines.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment
• Served as risk manager, monitored trading desk Capital market risk exposure
• Prepared test Data sets and performed data testing using teh PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Used Data warehousing for Data Profiling to examine teh data available in an existing database.
• Worked with Data Warehouse in teh 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).
• Evaluated feasibility of new capital markets business for global Australasia products
• Used Microsoft Visio for Business Process Modeling and Data flow diagrams.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Oversee Capital Markets Group front-, middle-, and back-office to ensure compliance with securities regulations
• Worked on data modeling and produced data mapping and data definition documentation
• Used Informatica to extract and transform data from various DB2 database to teh data warehouse.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio,AML, Documentum,Capital Market, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, RUP,VBScript, CRM, SharePoint, Unix, DB2, Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, Business Objects, TestDirector, LoadRunner.

Confidential, Minneapolis, MN

Business Analyst

Responsibilities:

• Designs and develops teh logical and physical data models to support teh Data Marts and teh Data Warehouse
• Apply custom changes to Calypso software in order to replicate vanilla and exotic OTC derivative products
• Interacted with department heads to finalize business requirements, functional requirements and technical requirements and also created Business process model.
• Supports regulatory analysis, including teh review, summarization and dissemination of key regulatory updates and changes
• Provided extensive administrative support to teh Global Head of Liquidity Risk Management and three managing directors
• me started as an administrative analyst tan me was promoted as treasury analyst, responsible for performing various cash, disbursement, and cash accounting activities within teh corporate treasury function
• Supported teh treasury operations and teh development of cash management banking solutions for multiple business segments of teh organization.
• CCAR specific GAP Analysis and IMPACT analysis for Loans, Funds dispersion on Firm and Client side dat includes creating various stress scenarios for calculating Risk (Market Risk, Liquidity Risk management and Credit Risk) for risk factor analysis and weighted risk allocations for Tier securities.
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
• Conducted Gap Analysis, and Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions
• Developed an SaaS CRM integration training program and implement teh first stages of teh program company wide.
• Acting as First point of Contact from teh Wintel Services for teh VMware and System Management Server Activities.
• Led teh preparation and submission of teh Annual Operating Plan and periodic forecasts for teh Balance Sheet
• Extensively used Visual Basic to create macros in order to make data migration testing more useful and compared results from teh legacy databases to teh new CRM database.
• Creation of Data Comparison Utilities and Excel Macros for IDW to Data Mart Comparisons
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Used MS Visio for Process modelling, Process mapping and Business Process flow diagrams.
• Designed and developed Use Cases using UML and Business Process Modelling.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Worked with data management and other groups to make sure dat quality procedures are integrated into their work processes.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Presented legal entity Balance Sheets at teh quarterly Audit & Finance Committee meetings
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Used Visual Basic Editor (VBE) for developing and testing Macros in Excel
• Created SQL reports, data extraction and data loading scripts for different databases and Schemas.
• Wrote complex SQL code with business logic for Production Data Maintenance (PDM) Impact Analyses and fallow up with implementation monitoring.
• Involved with all teh phases of Software Development Life Cycle (SDLC) methodologies throughout teh project life cycle.
• Used Test Director and Mercury Quality Center for updating teh status of all teh Test Cases & Test Scripts dat are executed during testing process.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Performed backend testing using SQL queries and analysed teh server performance on UNIX.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Using Shared Containers and creating reusable components for local and shared use in teh ETL process.
• Prepared Logical Data Models dat contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of teh Relationships between teh data elements to analyze and document teh Business Data Requirements.
• Defined teh duplication of data and columns between tables using TOAD and SQL.
• Verified teh Business Scenarios on new builds to allow extended testing by teh QA team.

Environment: Rational Enterprise Suite (Rose, ClearCase, ClearQuest), RUP, Visual Basic, SQL, SQL Server, Oracle, DB2, CRM, Wintel, Unix,SAAS, MS Visio, MS Office, LoadRunner,LCR, WinRunner, DOORS, Project Management.

Confidential

Data Analyst

Responsibilities:

• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict teh workflows to be incorporated into teh development of Pega Business Process Management (BPM) tool.
• Worked with data migration (ETL development), document data manipulation processes and scripts
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Led teh preparation and submission of teh Annual Operating Plan and periodic forecasts for teh Balance Sheet
• Using UNIX console commands to check database TEMPhas been connected teh other functionalities.
• Wrote database interface specifications and documented in Data Manager data dictionary
• Worked on development of an information access strategy for teh client including integrated data and information requirements, Tools & Process recommendations.
• Create and maintain data model/architecture standards, including master data management (MDM)
• Analysed teh existing as-is system for Insurance Personal Lines, tracked defects, provided recommendations to make enhancements in teh future to-be system.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Extensively involved in teh modeling and development of Reporting Data Warehousing System.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Prepared scenarios, Use Cases & UML State Diagram for scenarios using Rational Rose.
• Integrate Data from wide range of sources including in-house clinical data management systems, labs and contract research organizations and perform data cleaning.
• Involved in creating automated Test Scripts representing various Transactions, Documenting teh Load Testing Process and Methodology. Created meaningful reports for analysis and integrated teh Performance Testing in teh SDLC.
• Responsible for 24x7 coverage for various mainframe-based Cobol applications using DB2, VSAM and IMS databases
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Provided technical support to teh Database Team on Oracle 9/10 based architecture, developed SQL queries for data extraction purposes.
• Assisted in mapping teh requirements to teh source systems, teh DW and applicable data marts.
• Organized teh data for teh court report performing data extraction from different data repositories
• Tested teh final application for Usability testing to verify whether all teh User Requirements were catered to by teh application.

Environment: Rational Clear Case,Doors, IBM WebSphere, XML, Java, J2EE, JSP, RUP, VoAVPN,LCR, Oracle, MS Visio, MS Office, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential

Data Analyst

Responsibilities:

• Completed a thorough customer analysis and prepared a Request for proposal (RFP) document and got teh shortlisted vendor document signed off. Finally, CRM was decided upon by teh stakeholders among shortlisted as final implementation customer
• Create and maintain Use Cases, visual models, including activity diagrams, logical Business process models, and sequence diagrams using UML.
• Created source table definitions in teh Data Stage Repository by studying teh data sources.
• Prepared Use cases and Data flow diagrams and Work flow diagrams, considering teh scope of teh project with MS VISIO 2003.
• Reviewed Stored Procedures for reports and wrote test queries against teh source system (SQL Server) to match teh results with teh actual report against teh Data mart (Oracle).
• Created and scheduled Sessions based on demand, run on time and run only once using Informatica Server Manager.
• Developed demonstrated prototypes including data models, business objects universes, reports and business dashboards and received their feedback to define teh information access strategy for an integrated data warehousing and reporting solution.
• Worked on MS Excel Macros for creating automatic reports
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on teh configuration design and prototypes.
• Prepared Data Comparison tool by using VBA (Excel Macro).
• Assure dat all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Functioned as teh primary liaison between teh Business line, operations, and teh technical areas throughout teh Project Cycle.
• Defined teh test criteria and project schedules, and baseline teh Test Plan with teh help of project meetings, walkthroughs.
• Used master data management (MDM) to define reference data
• Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
• Participated in teh Logical and Physical Design sessions and developed Design Documents.
• Developed schemas for extraction, transaction, and loading (ETL) using Solonde Warehouse Workbench to expedite data integration between systems.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Environment: Microsoft Office Suite, MS Visio, Windows XP, Dream Weaver, CRM, SQL, PLSQL, XML, VB, ASP, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner