We provide IT Staff Augmentation Services!

Sr. Data Warehouse Business Analyst Resume

New York, NY


  • Over Seven years of experience in Business System Analysis, Financial Analysis, Data Modeling, Object Oriented Software Analysis documenting, developing process flow diagrams.
  • Proficient in Business Requirement gathering, Business Process flow, Business Process Modeling (BPM), Process Redesign, Business Process Reengineering, Business Change Management, Documenting Enhancement Requests, Automatic and manual testing, etc. with a keen awareness of developers and end - users needs and able to dealt with user groups at all levels efficiently
  • Extensive experience in leading and designing online marketing campaigns, consumer research, Search Engine marketing, search engine optimization, web analytics and Site Tagging.
  • Extensive knowledge of project life cycle, project management processes, principals, knowledge areas and various project management tools MS Project etc.
  • Proficient in documenting System Requirement Specifications (SRS), Functional Requirement Specifications (FRS), Requirements Traceability Matrix (RTM) using Rational Requisite PRO and Software development plan.
  • Knowledge and understanding of Futures, Options, CDO, CDS, CMO, MBS, Interest Rate Swaps, Credit Derivatives, Swaps, Bonds, Equity Swaps, Capital Markets, Fixed Income, Structured Products.
  • Defined and developed specifications for financial products initiated associated project development.
  • Experience in conducting GAP analysis, ROI analysis, SWOT analysis and Cost Benefit analysis.
  • Proficient in industry standard methodologies like Software Development Life Cycle SDLC, Iterative Software Development Life Cycle Process as per Rational Unified Process RUP, CMM Capability Maturity Models and Agile.
  • Facilitated JAD and JRP session with executives and project managers, prepared workshop materials and organize workshop activities.
  • Experience in writing Business Requirements Specifications, Functional Requirement Specifications and maintaining the Requirements Traceability Matrix RTM's.
  • Sound proficiency in analyzing and creating Use Case Diagrams, Class Diagrams, Activity Diagrams, Data Flow Diagrams and Sequence Diagrams based on UML methodology using Rational Rose.
  • Performed Structured Walk Through testing with QAs and developers, to analyze the root cause of flaws. Responsible for preparation test cases, test scripts, Decision tables and documented it for regression testing.
  • Experience of Unit Testing UT, System Integration Testing SIT and User Acceptance Testing UAT as well as Defect Tracking.
  • Hands on experience of SQL - Data Manipulation Language DML, Data Definition Language DDL and Data Control Language DCL .
  • Assisted data analysts to develop logical data models, source data cleansing and data profiling. Essentially applied business rules in the transform phase.
  • Proficient in Risk Management planning that includes Risk Identification, Assessment, Risk Analysis, Reporting, and Risk response/monitor/ control.
  • Demonstrated leadership ability to resolve issues, drive projects, and meet deadlines. Excellent interpersonal and communication skills with the ability to understand both business and technical needs from the clients and customers.
  • Experience in Business reviews, Functional and System Level Requirements and Design implementation
  • Experience in making Process flow diagrams and Data flow diagrams to document Business processes and creating user documentation.
  • Experience in developing Business Based Functional Test Scenarios, User Interface, Business Requirement Analysis, System Specification Analysis, Testing Methodology and Test Plan Formulation
  • Experience in writing System Test plans, defining Test cases, developing and maintaining Test scripts, Shell scripts, documenting all phases of QA process and Release management using PVCS
  • Experience with coordinating a UAT Test effort before deployment of the software product to production.


Software/ Hardware: ERWIN, ETL Ascential DataStage 7.x, 6.x, 5.x, Star-Schema Modeling, Snowflake Modeling, FACT and dimension tables, Erwin 4.0, Business Objects, Micro strategy, Erwin 4.x, C/C, Java SE 1.4, TURBO PASCAL 7.0, VB.Net, HTML, COBOL, RDBMS, SQL Server, SOA, SAP SD, MySQL, Oracle 8i,Visio, Sybase ASA 6 - 9 .ASP/ASP.net, PHP, Microprocessors, Unix, MVS, MS Windows/ 95/ 98/ NT/ 2000/ XP, MS DOS, MS Office 2000.

Requirement Management Tools: Rational Requisite Pro, MS Word with hyperlink

Modeling Tools: Rational Rose, MS VisioDefect tracking tools Rational Clear Quest

Databases: DB2, MS SQL Server 2008, Oracle 10g

Version Control Tool: Rational Clear Case

Utilities: MS Office (Word, Excel, Access, Outlook), MS Project, MS SharePoint, Informatica Power Center 8.6

Application server: IBM Web Sphere, WebLogic


Confidential, New York, NY

Sr. Data Warehouse Business Analyst


  • Extensively involved in the modeling and development of Reporting Data Warehousing System.
  • Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
  • Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
  • Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
  • Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
  • 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.
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Write and execute positive and negative test cases to ensure the data originating from the data warehouse Oracle dB is accurate through to the SQL dB in the applications.
  • Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
  • Performed extensive Requirement analysis and developed use cases and workflows.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
  • Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
  • Senior level SQL query skills Oracle and TSQL in analyzing and validating SSIS ETL database data ware house processes.
  • Coordinate with other organizations to obtain an automated monthly data feed, from an external system, which in turn is used to update TrackWise.
  • Handled change request and change management and project management using Clarity Project.
  • Developed strategic partnerships with the business units to develop a solid knowledge base of the business line including the business plan, products, and process and revenue streams.
  • Managed the database using SQL and Unicas Affinium Campaign to execute queries against large data sets in an Oracle environment to generate lead lists for new and recurring marketing campaigns based on the documented business requirements.
  • Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
  • Parsing high-level design specification to simple ETL coding and mapping standards.
  • Developed business requirement specification documents as well as high-level project plan.
  • Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
  • Conducted benchmarking activities to identify best practices.

Environment: Mainframes, COBOL, JCL, Db2, Visual Basic, Oracle, Teradata, UNIX, Rose, MS office, Cognos, MS Word, MS Excel, MS Visio, SAS, LoadRunner, WinRunner.

Confidential, New York, NY

Sr. Business Analyst


  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
  • Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
  • Designed the business requirement collection approach based on the project scope and SDLC methodology.
  • Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
  • Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
  • Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
  • Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams. Played a leading role in the effort to rollout new Retek modules such asRDFto the organization and to upgrade existing modules as new versions were released.
  • Reported and analyzed all application defects, user issues and resolution status to the higher manager using Mercury Test Director.
  • Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
  • Responsible for writing Test cases to cover overall quality assurance using Test Director
  • Performed initial manual testing of the application as part of sanity testing
  • Performed various tests such as positive, negative to check business functionality manually
  • Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
  • Created the business process model using MS Visio for better understanding of the system and presented it to Project Manager and other team members for validation.
  • Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries
  • Enabled Proper selection of the hash table design parameters for faster table look-up.
  • Created re-usable components using shared containers for local use or shared use.
  • Imported and exported repositories across projects.
  • Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
  • Collaborated with the development team to enforce the implementation of requirements throughout the entire coding cycle and managed change request using Rational Clear Quest.
  • Developed business process models in RUP to document existing and future business processe.
  • Troubleshot the designed jobs using the DataStage Debugger.
  • Created job schedules to automate the ETL process.
  • Enhanced the job properties for performance tuning.

Environment: SQL Server, Rational Test Manager, XML Spy, Data Stage, Rational Requisite Pro, Rational Clear Case, Clear Quest, Rational Rose, Erwin, Mercury TestDirector, Agile, Waterfall, MS Access, SDLC, RUP, UML, UAT, XML.

Confidential, Columbus, OH.

Business Analyst/ Data Analyst


  • Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
  • Working with clients to better understand their needs and present solutions using structured SDLC approach.
  • Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
  • Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
  • Worked with various vendor groups to gauge the effectiveness of their solution
  • Analyzed data and created class diagrams and ER diagrams for designing databases.
  • Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
  • Created wireframes and storyboards
  • Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
  • Configured the Data mapping between Oracle and SQL Server 2005.
  • Created Mock-up forms in MS word for better visualization and understanding of the software solution.
  • Tracked change requests and monitored workload and schedule.
  • Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
  • Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
  • 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
  • Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
  • Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
  • 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. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including PeopleSoft SET and Teradata
  • Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
  • Using Shared Containers and creating reusable components for local and shared use in the ETL process.
  • Identified various frequently used modules with in the application as well as the peak user volume for load testing purposes.
  • Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
  • Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
  • Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
  • Helped in creating end user manuals and procedure manuals.

Environment: Java, J2EE technology, .NET, ASP.NET, SQL Server, Windows 2000 Advanced Server, UNIX / Oracle Platform, MS Visio, MS Dynamics, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot.

Confidential, Detroit, MI

Business Analyst


  • Created business use case, functional FRS and technical specifications for trading system.
  • Extensively involved in the modelling and development of Reporting Data Warehousing System.
  • Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype, Use Cases, UML diagrams for overall system.
  • Gathered requirements and modelled the data warehouse and the underlying transactional database
  • Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
  • Conducted Joint Application Development JAD sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
  • Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
  • Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process.
  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • 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.
  • Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
  • Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
  • Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, RUP, SDLC, UML, TestDirector, LoadRunner.

Hire Now