Database Management Consultant Resume Examples & Samples. Overall strategy and implementation for data management related to the FDW. Liaise with field offices to identify and locate missing data sets. Conduct data cleaning/outlier analysis across multiple data domains to identify gaps or inconsistencies Craft your perfect resume by picking job responsibilities written by professional recruiters Hands on expert level experience with or SQL Server in a data warehouse environment and Database programming (SQL, Procedural Programming) data Warehouse and business Intelligence methodology and technology used to build and deliver a high Estimated Reading Time: 10 mins SUMMARY. 5+ Years of IT experience which includes Data Analysis, Design, Development & Support of MS SQL Server , and in Warehouse, Production, QA and Development Environments. Involved in the design of Logical and Physical design models of various relational databases using Erwin Data Modeling tool and also forward/reverse
Data Warehousing Resume Samples | Velvet Jobs
ERWIN, ETL: Ascential DataStage 7. xStar-Schema Modeling, Snowflake Modeling, FACT and dimension tables, Erwin 4. Net, HTML, COBOL, RDBMS, SQL Server, SOA, SAP SD, MySQL, Oracle 8i,Visio, Sybase ASA 6 - 9. This project named Project One had an objective to provide consolidated client reporting across all the product lines offered by Citigroup globally ConfidentialThe project achieved its goal through a Central Data Warehouse CDWwhich acted as a data repository to provide data for consolidated client reporting.
This Central Data Warehouse also known as Operational Data Store ODS received data from many Around 25 upstream systems, and also fed. Environment: Mainframes, COBOL, JCL, business data database employment information resume technology warehouse, Db2, Visual Basic, Oracle, business data database employment information resume technology warehouse, Teradata, UNIX, Rose, MS office, Cognos, MS Word, MS Excel, MS Visio, SAS, LoadRunner, WinRunner.
the second largest Swiss bank, operates in three segments: Investment Banking, Private Banking, and Asset ManagementThe goal of this project was to build a data warehouse to identify if an investor was active, inactive or added newly. We had to obtain the data from various databases as well as flat files. The data from different sources was integrated and loaded into the Data Warehouse.
SQL Server, Rational Test Manager, XML Spy, Data Stage, Rational Requisite Pro, Rational Clear Case, Clear Quest, Rational Rose, Erwin, Mercury TestDirectorAgile, Waterfall, MS Access, SDLC, RUP, Business data database employment information resume technology warehouse, UAT, XML. Confidential is one of the largest insurance and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments.
Nationwide currently has about 35, employees, and is ranked 98 in the most recent Fortune The Data Warehouse was developed to integrate Nationwide in designing the end user web-based interface, which involved OLAP reporting system implemented in Business Objects to provide business intelligence capability to Asset Managers.
Environment: Java, J2EE technology. NET, ASP. Confidential top-ranked housing finance company that has a well-deserved reputation in the market for its pioneering home loans along with its other sophisticated financial products and has enabled millions of middle-class citizens to own homes. The aim of the project was to bring under one umbrella all the functionalities and BI assets of the bank into one single repository which could solve the firm's data needs. My role was in the development and testing of the Data warehousing application.
Environment: Microsoft Office Suite, Microsoft Visio, Documentum, RUP, SDLC, UML, TestDirector, LoadRunner. We provide IT Staff Augmentation Services! Data Warehouse Business Analyst Resume Profile New, YorK. Hire Now. Knowledge and understanding of Futures, Options, CDO, CDS, CMO, MBS, Interest Rate Swaps, Credit Derivatives, business data database employment information resume technology warehouse, Swaps, Bonds, Equity Swaps, Capital Markets, Fixed Income, Structured Products.
Experience in working with OBI administration tool developing metadata repository and strong experience in working as OBIEE financial analyst. 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 SDLCIterative Software Development Life Cycle Process as per Rational Unified Process RUPCMM 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 UTSystem Integration Testing SIT and User Acceptance Testing UAT as well as Defect Tracking.
Hands on experience of SQL - Data Manipulation Language DMLData 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. 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.
Data Warehouse Business Analyst This project named Project One had an objective business data database employment information resume technology warehouse provide consolidated client reporting across all the product lines offered by Citigroup globally ConfidentialThe project achieved its goal through a Central Data Warehouse CDWwhich acted as a data repository to provide data for consolidated client reporting. This Central Data Warehouse also known as Operational Data Store ODS received data from many Around 25 upstream systems, and also fed Responsibilities: 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. 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.
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. 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 business data database employment information resume technology warehouse 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, business data database employment information resume technology warehouse.
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 Sr. Business Analyst Confidential the second largest Swiss bank, operates in three segments: Investment Banking, Private Banking, and Asset ManagementThe goal of this project was to build a data warehouse to identify if an investor was active, inactive or added newly.
Responsibilities: Designed DataStage ETL jobs for business data database employment information resume technology warehouse 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.
Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Expertise in development of High level design, business data database employment information resume technology warehouse, 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 as RDF to the organization and to upgrade existing modules as new versions were released. Reported and analyzed all application defects, user issues and resolution status business data database employment information resume technology warehouse 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, business data database employment information resume technology warehouse, Clear Quest, Rational Rose, Erwin, Mercury TestDirectorAgile, Waterfall, MS Access, SDLC, RUP, UML, UAT, XML. Responsibilities: 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 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.
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.
Database Tutorial for Beginners
, time: 5:32Data Architect Job Description Example | Job Description and Resume Examples
Data Warehouse / Business Intelligence Resume. Data warehouse/Business Intelligence practitioner with full DWH/BI stack experience from analyzing requirements to implementing solution. Experience includes analyzing business; developing enterprise data models at the conceptual, logical, and physical levels; designing ODS, data warehouses, and data marts; Database Management Consultant Resume Examples & Samples. Overall strategy and implementation for data management related to the FDW. Liaise with field offices to identify and locate missing data sets. Conduct data cleaning/outlier analysis across multiple data domains to identify gaps or inconsistencies SUMMARY. 5+ Years of IT experience which includes Data Analysis, Design, Development & Support of MS SQL Server , and in Warehouse, Production, QA and Development Environments. Involved in the design of Logical and Physical design models of various relational databases using Erwin Data Modeling tool and also forward/reverse
No comments:
Post a Comment