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 knowledge in Portfolio Management, Performance Measurement, Fixed Income, Equity, Credit Derivatives, Interest Rate Derivatives.
• Expertise in Project Management i.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 knowledge 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 the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artefacts produced by the teams across the 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 the lead of the 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.
• I have held the position of Data Warehouse Specialist - Procurement.In this position
• Responsible for the development and maintenance of the SAS code and related processes for the 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 the financial statements of the underlying securities & brokerage reports.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Worked as a Data Analyst in order to gather requirements and reaching each and every deadline well ahead of the time line. Methods employed were in compliance with IIBA standards.
• Extensively researched and collected the 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 the report data using SQL scripts and data comparison.
• Participated in knowledge transfer meetings and discussions with consumer management and BSA/AML Officer.
• Lead multiple project teams of technical professionals through all phases of the 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 the Oracle database.
• Created a test plan and a test suite to validate the data extraction, data transformation and data load and used SQL and Microsoft Excel.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Worked with developers to make sure that they understood the Use Cases.
• Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction and Data Compilation using SQL queries.
• Worked with the Business, Operations, and Engineering stakeholders to define the functional integration and end-2-end test cases for the CRM project.
• Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the 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 the Key Changes, and participated in Stakeholder Management to communicate effectively 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 the 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 the 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 the data available in an existing database.
• 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).
• 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 the 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 the logical and physical data models to support the Data Marts and the 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 the review, summarization and dissemination of key regulatory updates and changes
• Provided extensive administrative support to the Global Head of Liquidity Risk Management and three managing directors
• I started as an administrative analyst then I was promoted as treasury analyst, responsible for performing various cash, disbursement, and cash accounting activities within the corporate treasury function
• Supported the treasury operations and the development of cash management banking solutions for multiple business segments of the organization.
• CCAR specific GAP Analysis and IMPACT analysis for Loans, Funds dispersion on Firm and Client side that 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 the first stages of the program company wide.
• Acting as First point of Contact from the Wintel Services for the VMware and System Management Server Activities.
• Led the preparation and submission of the Annual Operating Plan and periodic forecasts for the Balance Sheet
• Extensively used Visual Basic to create macros in order to make data migration testing more useful and compared results from the legacy databases to the 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 that 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 the 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 the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that 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 the 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 the ETL process.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Defined the duplication of data and columns between tables using TOAD and SQL.
• Verified the Business Scenarios on new builds to allow extended testing by the 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 the workflows to be incorporated into the 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 the preparation and submission of the Annual Operating Plan and periodic forecasts for the Balance Sheet
• Using UNIX console commands to check database has been connected the other functionalities.
• Wrote database interface specifications and documented in Data Manager data dictionary
• Worked on development of an information access strategy for the client including integrated data and information requirements, Tools & Process recommendations.
• Create and maintain data model/architecture standards, including master data management (MDM)
• Analysed the existing as-is system for Insurance Personal Lines, tracked defects, provided recommendations to make enhancements in the future to-be system.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Extensively involved in the 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 the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the 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 the Database Team on Oracle 9/10 based architecture, developed SQL queries for data extraction purposes.
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Organized the data for the court report performing data extraction from different data repositories
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the 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 the shortlisted vendor document signed off. Finally, CRM was decided upon by the 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 the Data Stage Repository by studying the data sources.
• Prepared Use cases and Data flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO 2003.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the 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 the 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 the configuration design and prototypes.
• Prepared Data Comparison tool by using VBA (Excel Macro).
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
• Defined the test criteria and project schedules, and baseline the Test Plan with the 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 the 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