We provide IT Staff Augmentation Services!

Etl Developer/database Modeler Resume

Quincy -, MA

SUMMARY

  • Experiencein the field of system analysis and extensive noledge of designing unprecedented IT solutions to enhance business efficiency and productivity.
  • Experienced working in versatile software development methodologies including Agile/Scrum, Iterative and Waterfall SDLC methodologies.
  • Good skills set in SQL, PL/SQL, Oracle, SQL server, UNIX Shell Scripts, Data Modeling, Data Warehousing strategies and IBMDataStage.
  • Worked onDataStagetools likeDataStageDesigner,DataStageDirector and DataStage Administrator.
  • Strong understanding of the principals of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling.
  • Technical and analytical skills wif clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.
  • Extensive experience in design and development ETL Packages onDataStage8.5.
  • Good hands - on experience in designing queries and other DDL, DML scripting in SQL.
  • Good hands-on experience in UNIX and Teradata.
  • Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.
  • Used Enterprise Edition/Parallel stages like Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding.
  • Having good noledge on Data Warehousing (DWH) concepts & methodologies.
  • Scheduling the jobs using Autosys and Control -M.
  • Extensive noledge of IT procedures and available technology solutions.
  • Strong ability to coordinate wif external or internal clients and Ability to analyze clients existing systems and business models.
  • Understanding of data model design concepts like conceptual, logical, physical data models, dimensional modeling concepts like Star Schema and Snowflake Schema.
  • Solid understanding of software development lifecycles and Strong analytical skills.
  • Exposure in overallSDLCincluding requirementgathering, development, testing, debugging, deployment, documentation, production supportand Extensive experience in Project Management methodologies, Microsoft SQL Server database management.
  • Involved in project related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
  • Facilitated data requirement meetings wif business and technical stakeholders and resolved conflicts to drive decisions.
  • Comprehensive noledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation. Strong noledge of DBMS concepts (views, foreign keys, primary keys, indexes, referential integrity, column constraints), SQL, DDL generation and validation.
  • Experience in preparingBusiness Process Re-Engineering Models.
  • Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers.
  • Good understanding ofviews, Synonyms, Indexes, Joins and Partitioning.
  • Mentored developers and conducted trainings for end users/analysts.
  • Exceptional communication, presentation skills and client interactions.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, UNIX, HTML/XML, C++, C, Perl

Database Tools: Oracle SQL Developer, Microsoft SQL Server 2000/2005/2008, DB2, Oracle 10g/9i, Teradata.

OLAP Tools: Microsoft Analysis Services, Business Objects.

Packages: Microsoft Office Suite, MS-Word, MS-Excel, MS-Power point.

Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7, LINUX and UNIX.

Reporting Tools: Cognos, MS Office Suite.

Other Tools: MS Visual studio, Share point, ERWIN, SQL Developer Data Modeler 4.1.5, Datastage 8.5.0, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, Quincy - MA

ETL Developer/Database Modeler

Roles & Responsibilities:

  • Maintained and supported systems for data warehouse and business intelligence (BI) initiatives, including software, servers, and networks.
  • Created the BRD (Business Requirement Document) after identifying all the requirements of the users.
  • Developed mapping to load the data in slowly changing dimension.
  • Preparation of technical specification for the development ofDataStageExtraction, Transformation and Loading (ETL) source to target mappings to load data into various tables and defining ETL standards.
  • Developed and used Stored Procedures to run on precession and post session commands.
  • Extensively involved in creating database procedures, functions and triggers.
  • Used theDataStageDesigner to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
  • Extensively worked wifDataStageActive and Passive Stages for Data Staging and Data Transformation from DB2 tables and loaded data into target databases.
  • Used aggregate, expression, lookup, update strategy, router, and rank transformation.
  • Developed joiner transformation for extracting data from multiple sources.
  • Performed data analysis, testing, debugging, audits, disaster recovery, and problem resolution.
  • Tested applications and resolved complex problems throughout software development life cycle (SDLC), including preparing detailed program specifications.
  • Researched and evaluated technology solutions and present recommendations for improved system operations.
  • Created data verification methods and comply wif standard system procedures.
  • Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for BCMS application.
  • Worked wif Database Administrators, Business Analysts and Cognos Report Developers to conduct design reviews and validate the developed models.
  • Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
  • Facilitated development, testing and maintenance of quality guidelines and procedures along wif necessary documentation.
  • Defining the naming standards for data warehouse.
  • Collected the business and technical metadata and maintained naming standards.
  • UsedOracle SQL Developer Data Modeler for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
  • Used Model Mart ofOracle SQL Developer Data Modeler for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
  • Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
  • Integrated the work tasks wif relevant teams for smooth transition from testing to implementation.

Environment: Oracle SQL Developer Data Modeler 4.1.5, Datastage 8.5.0, Windows XP/NT/2000, SQL Server 2005/2008, SQL, Oracle10g, Teradata, MS Excel, Mainframes MS Visio.

Confidential - Houston, TX

ETL Developer

Roles & Responsibilities:

  • Worked closely wif the Data Modelers for Designing and customizing data models for Data warehouse, supporting data from multiple sources in real time.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Created mapping documents to outline data flow from sources to targets.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and Union to develop robust mappings in the Datastage Designer.
  • Developed Mapping parameters and Variables to support SQL override.
  • Created Mapplets to use them in different mappings.
  • Developed mappings to load into staging tables and then to Dimensions and Facts.
  • Used existing ETL standards to develop these mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment, Timer and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loaded into data warehouse.
  • Involved in performance tuning for sources, targets, mappings and sessions.
  • Involved in preparing the migration document to move the mappings from development to testing and then to production repositories.

Environment: Datastage 8.5.0, Oracle 9i, SQL Plus, Windows 2005/XP, Microsoft Office 2003, Shell Scripting.

Confidential

Oracle Software Engineer

Roles & Responsibilities:

  • Responsible for rescue maintenance as needed across a spectrum of store developed applications built on Oracle Forms, Reports and Oracle PL/SQL.
  • Developed/Modified User Interface/Reports using Oracle Forms & Report.
  • Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
  • Prepared the Data Reconciliation report by using Oracle PL/SQL and UNIX.
  • Developed Complex SQL queries using various joins and developed various dynamic SQLs throughout the projects.
  • Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
  • Used Bulk Collect feature to improve performance.
  • Analyzed and computed statistics to improve response time for queries.
  • Involved in Performance tuning of complex queries.
  • Assigning work to an Engineer, Monitoring & controlling the release for any fix.
  • Participating in weekly client call in order to understand, clarify & resolve issues reported by client.
  • Assisting Team in resolving Data related issue by providing Business related guidance & noledge.
  • Responsible for resolving the issues reported by Client
  • Data Analysis on the data provided by different Vendors.
  • Technical troubleshooting and consultation to development teams.
  • Participated in Testing (Both Unit and Integration Level) and Implementation.

Environment: Oracle 9i/10g, Oracle 9i Developer Suite, Core Java, Linux, Oracle Designer and TOAD.

Hire Now