Data Warehouse Developer Resume Samples

Description :

1. Experienced of CVS in implementing major Retail Projects, The existing Enterprise Pharmacy Management System needs to be developed and maintained, The scope of the project is to understand current application, design, develop, test, rollout, support and document.
2. Designed and developed Informatica mappings for data loads Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
3. Designed OLAP data mart for worker's compensation reporting Created Data Stage (ETL) jobs to denormalize and load OLTP data Developed DB2 SQL and .
4. Analyzed data source to designed simple and efficient query transforms Loaded data from flat files Designed work flows and data flows Cleaned data in .
5. Reviewed documentation, peer programming, code reviews, and conducted code walkthroughs.
6. Resolved issues and provided on-call support for production database.
7. Demonstrated ability to utilize cognos report studio for testing and report writing.

Experience

2-5 Years

Level

Executive

Education

Bachelors Of Engineering

Description :

1. Conducted JAD sessions with business users and SME's for better understanding the requirements and to define business and functional specifications.
2. Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
3. Transformed business requirements into technical specifications, source-to-target mappings.
4. Extracted data from DB2 VSAM files, XML Files, Flat Files and populated into Teradata Warehouse.
5. Developed Complex transformations, mapplets using Informatica to Extract, Transform and load data into Datamarts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
6. Analyzed data source to designed simple and efficient query transforms Loaded data from flat files Designed work flows and data flows Cleaned data in .
7. Demonstrated skill utilizing sql server management studio r2 (ssms) and sql server integration services r2 (ssis).

Experience

2-5 Years

Level

Executive

Education

BA In MIS

Description :

1. Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
2. Conducted Joint Application Development (JAD) sessions with IT groups.
3. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
4. Unified Modeling Language (UML), Object Oriented Analysis and Design (OOAD) using use case, activity and state chart diagrams.
5. Worked on Master Data Management (MDM) processes that involved collection, aggregation, consolidation, distributions and quality assurance of the data as per the project need.
6. Experienced in Master Data Management (MDM), Data Mining, Data Mapping, Data Profiling & Data Warehousing.
7. Responsible for implementing Scrum Methodology as well as on SDLC procedures in the implementation of Tableau/Spotfire.

Experience

7-10 Years

Level

Junior

Education

Bachelor Of Arts In Spanish

Description :

1. Centralized data warehouse was responsible for maintaining Nextel's customer information, their account and payment history, billing information, statements history, etc.
2. Membered of the warehouse design team, which interacted with the business community and database administrators to identify the business requirements.
3. Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational, XML and flat file sources into the data mart.
4. Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
5. Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
6. Implemented complex mapping such as Slowly Changing Dimensions Type1, Type 2, Type3.
7. Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for other mappings.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Arts In Spanish

Description :

1. Analyzed business requirements and worked closely with the various application teams and business teams to understand business requirements and the source data.
2. Involved in designing logical models for staging, production warehouses using ERWIN 3.0.
3. Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
4. Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
5. Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
6. Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
7. Partitioned sources to improve session performance.

Experience

2-5 Years

Level

Executive

Education

M.A. In Biomedical Informatics

Description :

1. Worked closely with business analysts and data analysts to understand and analyze the requirement to come up with robust design and solutions.
2. Involved in standardization of Data like of changing a reference data set to a new standard.
3. Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).
4. Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
5. Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ).
6. Involved in Exception Handling Mappings for IDQ.
7. Involved in IDQ process the team considered to create the Column Profiling.

Experience

2-5 Years

Level

Executive

Education

MBA In Business Administration

Description :

1. Created indexes, materialized views, partition tables as well as recommend oracles best practices to the data analysts and other developers in the .
2. Reviewed requirements for Web-based applications and developed the databases needed to support the front-end applications Worked on table .
3. Automated batch processes with Perl scripts to perform data loads to Oracle Database from external financial vendors (State Street, Bloomberg, etc.) .
4. Worked with Variables and Parameters in the mappings to pass the values between sessions.
5. Performed development and testing duties for ROI, UCB/POR, Proof of Revenue, PAL Lighting and Audit projects.
6. Developed, tested and deployed data replication solution based on IBM's Enterprise Data Propagator (EDP) for multiple projects.
7. Created Detailed Designs for slowly changing dimensions for core dimensions in the database (Bill Account, Premise, etc ).

Experience

2-5 Years

Level

Executive

Education

Post Graduate Diploma

Description :

1. Designed, and developmented of data warehousing and business intelligence components
2. Maintained existing data warehousing and business intelligence applications and processes using a standardized suite of software development products.
3. Implemented new application components and processes for data warehousing and business intelligence environments
4. Developed software components and solutions that adhere to development standards and are accurate, efficient, and maintainable.
5. Provided technical and functional troubleshooting of software bugs
6. Met with customers to gather and/or clarify requirements associated with a data warehousing or business intelligence deliverables.
7. Performed detaile analysis and documentation and assist in determining the best solution for meeting the needs of the customer.
    
    

Experience

2-5 Years

Level

Executive

Education

Bachelors

Description :

1. Ability to work as a team player to achieve results. Must be able to build positive working relationships with database administrators, ETL developers, and BI developers.
2. Responsible for the development of complex ETL processes for all projects assigned.
3. Design data infrastructure across all technical environments
4. Participate in the design, completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements
5. Designed and planed for the integration for all data warehouse technical components.
6. Provided input and recommended on technical issues to the project manager.
   
7. Participated in testing of the data design, tool design, and data extracts/transforms.

Experience

2-5 Years

Level

Executive

Education

Bachelors

Description :

1. Partnered Healthcare is a health care system that is committed to patient care, research, teaching and service to the community locally and globally.
2. Gathered business requirements, created specification documents, data mapping, data quality analysis, working in conjunction with the data warehouse team on the development of logical data models.
3. Worked as a developer in creating complex stored procedures, triggers, and user defined functions.
4. Managed index statistics, tables, views, cursors and optimizing queries by using execution plan for tuning the database.
5. Implemented different types of constraints on tables.
6. Responsible for MySQL installation, configuration setup, DB systems administration, provisioning, troubleshooting database performance problems.
7. Performanced tuning to optimize SQL queries to improve data retrieval using query analyzer and DMV.
8. Worked on array of .NET Services built to read incoming EDI 834 files, process the data into individual XML transactions and prepare them for sending them to the Facets database via the FXI web services.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Technology