We provide IT Staff Augmentation Services!

Business Analyst(data Warehouse) Resume

Santa Ana, CA

SUMMARY

  • Extensive experience and knowledge in Data warehousing field.
  • Strong ability to interact with technical, functional and business teams.
  • Knowledge of Data Warehousing and data modeling concepts with strong analytical and diagnostic skills.
  • Strong SQL experience and knowledge of relational databases.
  • Deep knowledge and experience in Data Warehousing concepts and BI designing.
  • Develop technical specification and documentation of ETL and metrics requirements to maintain the EDS data stores environment.
  • Strong understanding of Data Warehousing and RDBMS concepts.
  • Experience in Toad (Tool for Oracle Application Developers).
  • Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
  • Experienced in Database creation, MS Access Queries, and custom reporting, with intensive data manipulation.
  • In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment.
  • Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
  • Worked on establishing architecture and standards, meta data strategy, data quality strategy, ETL, Master Data Management (MDM), as well as Information Integration strategy and standards.
  • Ability to create and document requirements for BI solutions preferred.
  • Experience in Designing, Creating and maintaining the Universes, Business object reports.
  • Good knowledge and experience with RDBMS concepts: SQL, DML, DDL, views, index, constraints. Worked on DB2, Oracle
  • Experience with Business Objects, SSRS, one or more best of breed BI tools.
  • Experience using different development methodologies including SDLC, Scrum, and/or Agile, and test - driven development
  • Experience in data architecture, data warehousing, master data management, enterprise information integration and ETL.
  • Ability to develop conceptual and logical data models from elaboration of requirements.
  • Extensive experience with SQL query writing and query tools, data mining and views and stored procedures on platforms of Oracle, Teradata, SQL server.
  • Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
  • Experience working with FTP and SFTP file transfers.
  • Experience with Shell Scripting and Unix.
  • Builds strong relationships with business staff and management, in order to facilitate project success.
  • Participated in project code development, troubleshooting and enhanced in collaborating with development team members.

TECHNICAL SKILLS

Data ware Housing Tools: Informatica Power mart, Informatica Power Center … OBIEE, BO XI R3.

Databases: Oracle 10G, DB2 8.0, SQL Server 2000

Operating Systems: Linux, Unix, Windows XP

Application Packages: Sub Version, Visual Source Safe 6.0

Tools: Visual Interdev 6.0, Tivoli Maestro.

Languages: SQL, PL/SQL.

Web Technologies: HTML, XML, Java Script, JRun, Tomcat, JBoss, Apache Web Serve.

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

Business Analyst(Data Warehouse)

Responsibilities:

  • Responsible for providing college-wide support and services required to optimize extraction, warehousing, querying and reporting of data from the Enterprise Resource Planning system and other internal and external databases/sources.
  • Designs and implements testing procedures to ensure accuracy of data and quality / effectiveness of applications.
  • Performed risk management, including development of contingency plans, oversight of project completion, and submission of periodic project status reviews to higher management.
  • Performed Data Analysis on data warehouse systems for various reporting needs within an organization using SQL.
  • Involved in formatting data stores and generate UML diagrams of logical and physical data.
  • Designed and developed databases on RDBMS(MySQL and MS SQL servers), which makes data backup and recovery safer, easier and more efficient.
  • Created Mapping tables for Data load and Complex Report views for Business Objects Universes and Dashboard reports.
  • Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
  • Interaction with DBA on database diagrams, database objects, schema's and normalization rules.
  • Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.
  • Generate SQL server reports against (RDBMS) Relational Database Management System.
  • Used the Database tables from different environments such as Test, QA and Training.
  • Conducted meetings with business and development teams for data validation and end-to-end data mapping.
  • Conducted meetings with business and development teams for data validation and end-to-end data mapping.

Environment: Informatica Power Center 8.1, OLAP, DB2, UNIX, T-SQL, SQL Loader, Maestro Flat Files, XML Spy, Cognos 7.0, Oracle 10g

Confidential, Herndon, VA

Data Warehouse Developer

Responsibilities:

  • Develop Functional Requirements that describe what the system, process, or product/service must do in order to fulfill the business requirement(s).
  • Develop test scenarios and test cases for use in system and integration testing.
  • Analyze alignment of proposals to business strategies.
  • Analyzed complex sets of data to identify quality issues and pro actively initiated steps for improvement.
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Involved in troubleshooting, diagnosing and resolving complex business object problems to ensure high performance and minimal disruption of critical systems.
  • Involved in end user training and documenting the procedures.
  • Defined the duplication of data and columns between tables using TOAD and SQL.
  • Provides guidance and direction for the protection of information systems assets to other areas as needed.
  • Installation of Oracle RDBMS server software and version upgrades.
  • Extracted data from sources like XML, Oracle and Flat files according to the requirements.
  • Did the Unit Testing, FRD testing, Integration testing and UAT testing.
  • Reviewed and validated data models for ETL and BO.
  • Responsible for overall architecture and strategy of the Analytics Data Warehouse.
  • Researched and recommended solutions to complex data warehouse technical issues.
  • Developed small applications with Tera data at the back end.

Environment: Informatica Power Center 7.1/8.1, Business Objects XI, OLAP, TOAD, Oracle 9i, T-SQL, SQL Loader, Flat Files, XML, UNIX

Confidential, Jersey City, NJ

Data Warehouse Architect

Responsibilities:

  • Created use case diagrams to explain the flow of events and how different software systems interact with each other.
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
  • Reviewed the logical model with Business users, ETL Team, DB A's and testing team to provide information about the data model and business requirements.
  • Created fully normalized till 3rd Normalization technique using Power Designer.
  • Ensure proper validation documentation is created for all projects.
  • Performed data model analysis & mapping and analyzed complex SQL queries, working closely with Data Analysts in evaluating relational database solutions.
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
  • Installation, Configuration, Upgrade, patching of Oracle RDBMS in development, test and production environments.
  • Wrote, tested and implemented Tera data Fast load, Multi-load and Bteq scripts, DML and DDL.
  • Worked with heterogeneous sources from various channels like Oracle DBMS, SQL Server, flat files, and web logs.
  • Implemented JavaScript for validation of the prompts in the reports.
  • Responsible for providing analytical support in the Design, Development and Implementation of Project.
  • Interacted and work effectively with technical & non technical levels within the organization.
  • Help support various projects or application outsourcing clients with integrations across multiple third parties and client's.
  • Developed, mentored and trained clients in data quality using Quality Manager.
  • Assists the technical team in identification and resolution of Data Quality issues.
  • Participate and assist in meetings as a member of the Data Warehouse team.
  • Develop technical specification and documentation of ETL and metrics requirements to maintain the EDS data stores environment.

Environment: Informatica Power Center 6.1, Oracle 9i, UNIX and Windows XP.

Hire Now