SUMMARY

• Business System Analyst with over 6 years industry experience in business data modeling, software requirement analysis, process modeling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML
• Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio.
• Extensively involved in data modeling in various projects.
• Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC)
• Expertise in using Microsoft Visual Studio Team System for requirement management and work item tracking.
• Strong web development and web content management experience.
• Experience in designing and developing reports using Microsoft Reporting Services (MSRS), Crystal Reports, MS Access, and Data View web part.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Diverse work experience on Black Box Testing, Unit Testing, Functionality Testing, Integration Testing, GUI Testing, System Testing, Backend Testing, Regression Testing, Smoke Testing and User acceptance testing (UAT) and Performance Testing
• Experience with CaliberRM, StarTeam, Test Director, InfoMake
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store Procedures.
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, Perl 5.0, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
• 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
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Highly effective management and organizational skills with ability to prioritize.

TECHNICAL SKILLS

• Rational Rose
• Rational Enterprise Suite
• MS Visio
• MS Project
• Rational Requisite Pro
• WebLogic
• Crystal Reports
• Lotus Notes
• SDLC
• Test Director
• WinRunner
• LoadRunner
• Quick Test Pro
• SQL
• Oracle
• MS - Word
• Quark Express
• Load Runner
• MS PowerPoint
• GUI
• UI
• Erwin
• HTML
• DHTML
• AJAX
• PHP
• CSS
• Quality Center
• Dream Weaver Java
• Java Script
• Apache interwoven
• AS400
• Web 2.0
• C#
• .Net
• Silverlight
• Ajax
• Sharepoint
• Documentum
• E-Commerce
• Visual Studio Team System
• MS SharePoint 3.0
• ASP
• CaliberRM
• XML
• Web Application Server (3.0B)
• Internet Transaction Server
• Business Explorer

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Business System Analyst

Responsibilities:

• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case VOB
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on Ms Access.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Worked on data modelling and produced data mapping and data definition documentation
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• 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.
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs.
• Documented existing and proposed process flow, analyzed current and target system, and conducted GAP analysis.
• Written Use cases and have produced Use Case Models, creating Behavioral diagrams (use case diagram, Activity diagrams and Sequence diagrams) based on UML Methodology & Business process flow diagrams.
• Extensively used tools such as Rational Rose, Rational Requisite Pro, UML, MS Visio, MS Project, MS Office, MS Access.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Gathered requirements from JAD/JAR sections with developers and business clinets.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Developed project plans and managed project scope.
• Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Involved in Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Develop, build and manage Reporting Services (SSRS) reports using both SSAS cube and relational database sources including distribution of reports using subscription services.

Environment: JSP, Oracle, PL/SQL, Apache, HTML, XML,Clear Case, Clear Quest, Ajax, PHP, WebLogic, ERWIN, Rational Rose, Agile, IBM business process modeler, C#/.Net, Unix, MS Visio, CSS, Java/J2EE, SDLC, RUP, UML, UI/GUI, CaliberRM, MS Project, SQL, MS Access, MS Excel and MS Word.

Confidential, New York, NY

System / Data Analyst

Responsibilities:

• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Developed and provided formal training and presentations/lectures to all DWH users ensuring an understanding of the dimensional model, metadata, and effective usage.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Performed Data Analysis and Data validation by writing complex SQL queries.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Devised system to generate automated Business Intelligence reports (Hummingbird & TeraData) for the internal users.
• Performed Business Intelligence and ETL tool selection and implementation for enterprise initiatives.
• The project was to extract data using SSIS, for designing OLAP cube as per the business requirement using SSAS, creating reports for the business users using SSRS
• Worked on Credit DataMart and Marketing DataMart and responsible for gathering requirements, preparing functional specifications and BI Business/Data Analysis / Modeling and UAT.
• Devised system to generate automated Business Intelligence reports (Hummingbird & TeraData) for the internal users.
• Performed Business Intelligence and ETL tool selection and implementation for enterprise initiatives.
• The project was to extract data using SSIS, for designing OLAP cube as per the business requirement using SSAS, creating reports for the business users using SSRS.
• Development of the applications and load scripts in Teradata BTEQ Scripts
• Worked with Business Development team to perform data analysis/quality and data modeling. Worked with Data Security team to define sensitive data elements and data masking.
• Responsible for code migration of existing application from SQL Database to Oracle Database.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL and various Shell scripts.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Performed Data Analysis and Data validation by writing complex sql queries using TOAD against the ORACLE database.
• Worked with traders to develop modules to hedge long and short positions in bonds with credit spread calls and puts. Wrote rules to calculate payoffs based on credit derivatives trading strategies and calculations of credit delta and gamma to determine change in bond value.
• Interacted with Fixed Income business heads to finalize the Business Requirements for the application.
• Worked on Credit Management data and Marketing Information data coming from multi sources. Conducted Gap Analysis & Impact Analysis to support new business requirements and enhancements. . Prepared various Data Flow Diagrams (DFDs) and sources analysis documents.
• I was responsible for the Business Intelligence reporting, analytics, dashboard solutions utilizing Enterprise Business Objects product suite.

Environment: MS Access 2000, MS Excel, MS Project, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS Office suite, MS Visio 2003.

Confidential, PA

Data Analyst

Responsibilities:

• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Developed and provided formal training and presentations/lectures to all DWH users ensuring an understanding of the dimensional model, metadata, and effective usage.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Performed Data Analysis and Data validation by writing complex SQL queries.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Devised system to generate automated Business Intelligence reports (Hummingbird & TeraData) for the internal users.
• Performed Business Intelligence and ETL tool selection and implementation for enterprise initiatives.
• The project was to extract data using SSIS, for designing OLAP cube as per the business requirement using SSAS, creating reports for the business users using SSRS
• Worked on Credit DataMart and Marketing DataMart and responsible for gathering requirements, preparing functional specifications and BI Business/Data Analysis / Modeling and UAT.
• Involved in supporting over the counter (OTC) derivative trade capture and straight through processing (STP).
• Worked with Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Sales and Marketing.
• Worked with traders to develop modules to hedge long and short positions in bonds with credit spread calls and puts. Wrote rules to calculate payoffs based on credit derivatives trading strategies and calculations of credit delta and gamma to determine change in bond value.
• Interacted with Fixed Income business heads to finalize the Business Requirements for the application.
• Worked on Credit Management data and Marketing Information data coming from multi sources. Conducted Gap Analysis & Impact Analysis to support new business requirements and enhancements. . Prepared various Data Flow Diagrams (DFDs) and sources analysis documents.
• Worked on various source systems analysis and prepared gap analysis documents, impact analysis documents, Source-to-Target Mapping documents and Data Definitions documents. Defined new validation rules and Domains. Worked on data mining and data profiling.
• Prepare, maintain and publish ETL documentation, including source-to-target mappings and business-driven transformation rules.
• Development of the applications and load scripts in Teradata BTEQ Scripts
• Worked with Business Development team to perform data analysis/quality and data modeling. Worked with Data Security team to define sensitive data elements and data masking.
• Responsible for code migration of existing application from SQL Database to Oracle Database.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL and various Shell scripts.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Performed Data Analysis and Data validation by writing complex sql queries using TOAD against the ORACLE database.
• Executed SQL and PL/SQL queries on the DB2 Database.
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.

Environment: Business Objects, Crystal Reports XI/XI R2, TOAD, Java, Oracle 11i, 10g, PL/SQL, SQL Server, XML, Rational Req. pro, clear case, Rational Rose, Clear Quest, UML, Ms Visio, Ms Project, MS Office.

Confidential, OH

Business Analyst/Data Analyst

Responsibilities:

• Created Use Cases / Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model.
• Converted Business Requirements to the Functional Specification and Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• I was responsible for the Business Intelligence reporting, analytics, dashboard solutions utilizing Enterprise Business Objects product suite.
• Worked on multi sources data related to various Loan products (Auto, Home Equity, Personnel etc)
• Worked with Business Analyst, Data Modeler and Project management team to do System Study, Analysis and Design of research data warehouse.
• Performed Informatica Administrator functions like Creating Users, Folders and giving permissions on the folders to the Users etc. Involved in creation of Effective Test Data and Unit Test cases to ensure the successful execution of the data loading processes.
• Analyzed the existing Tables, Corporate Data Warehouse to identify data fields, sources, impacted tables, candidates for remediation and data mapping
• Wrote SQL queries to validate expected data and actual data. Wrote UNIX shell scripts.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Defined Functional Test Cases, documented, Executed test script in Facets system.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Implemented and monitored Individual Development Plans focusing on total performance, including both quality and productivity and validated technical designs created by IT developers against functional specifications.

Environment: VB 6.0, Oracle, SQL Server, Java, DBA, DB2, COBOL, Windows, PMAP, Rational Enterprise suite,, MS Office (Word, Excel, Access, Project, PowerPoint, Outlook), MS Project.