We provide IT Staff Augmentation Services!

Sr Data Warehouse Developer Resume

3.00/5 (Submit Your Rating)

Trenton, NJ

SUMMARY:

  • Over 10 plus years of experience in IT Industry with experience in Architecture, analysis, design, testing, development, documentation and implementation of applications.
  • Expertise in providing Business Intelligence solutions using Datastage, Quality Stage and Business Objects reporting tools in Data warehousing/Decision Support Systems.
  • Strong knowledge of DataStage Parallel Extender and Server modules.
  • Knowledge in Data Modeling (Entity Relationship) using tools like Erwin for OLTP and Data Warehousing environment.
  • Expertise in Architecting EDW solutions from end to end.
  • As a database technologist, dealt with data warehousing tasks such as building, maintenance, migration of databases of large size, applying various Data modeling techniques like star schema, snow flake ware house concepts.
  • Expertise in migrating data from various sources into Oracle Database and vice versa.
  • Expertise in generating Simple, Pivot, Detailed, Aggregation of Reports using, Business Objects, Crystal Reports, SQL reports and MS - Excel.
  • Extensively worked on Data Extraction with Teradata, DB2, Oracle, and SQL Server.
  • Working knowledge with OLAP Servers.
  • Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers, Packages and Materialized views.
  • Worked on variety of industry/functional areas including Consumer Appliances, Office Stationery products, Sales & Distribution, Financial, Retail, Marketing, Manufacturing and Material Management.
  • Excellent Analytical, Communication and presentation skills.

TECHNICAL SKILLS:

ETL Tool: IBM Information Server - DATASTAGE 6.X/7.0/XE/ 8.1/8.5/11.5 (Designer/Manager/Administrator/Director).

OLAP Tools: BUSINESSOBJECTS 5.1/6.1/XI (Supervisor, Designer, Reports, Broadcast Agent, Set Analyzer), WEB INTELLIGENCE 2.5 / 2.7, SDK. Application foundation 5.0, SAP Business Objects XI (3.1)

Programming Languages: C, C++, JAVA (1.2), SQL and PL/SQL, Shell scripting

Internet Technologies: HTML 4.0, JAVASCRIPT 1.2, JSP, and SERVLETS.

Databases: ORACLE 7.X/8.0/8i/9i/10g/11i/12c, Teradata, Sql Server & DB2

Data Modeling Tools: ER/Studio, ERWIN, ORACLE DESIGNER.

Operating Systems: Windows NT/2000, UNIX (AIX and Solaris)

EXPERIENCE:

Confidential, Trenton, NJ

Sr Data Warehouse Developer

Responsibilities:

  • Participated in Requirements gathering from various state agencies such as NJ-DCA, NJ-DCF, NJ-DHS, NJ-DOT, NJ-DMAVA, NJ-DEP, NJ-DOE and NJ-Transit.
  • Worked with various vendors such as Witt Obrien and CGI that are currently implementing data solutions for the NJ state, to analyze the Impact in the time of code transistion.
  • Performed GAP analysis for the non common file formats among the State agencies (segegrated incoming sources) with respect to target EDW expectations.
  • Analyzed source data for data modelling by grouping and consolidating incoming data.
  • Created Design flow for the new datastage project.
  • Prepared ETL Mapping document and High level ETL design document
  • Worked closely with Business Objects reports developers at the time of modelling to identify the grain and the referentiial integrity aspects of the reporting universe .
  • Worked closely with data modellers and DBAs in getting the schema designed with necessary Oracle objects.
  • Created Logical Models using Erwin tool suit for the new datamart that is used for Business Objects reporting.
  • Created DDLs for Triggers, Indexes upon requirement.
  • Fine tuned the sql queries by using indexs and hints .
  • Created datastage parallel jobs using various passive and active stages.
  • Created XML files using Hierarchy stage.
  • Used XML composer , XML parser , Union and Sort functionalities while creating, reading XML files.
  • Used SOAP protocol in sending and receiving the xml files from IRS ACA division.
  • Create re-usable datastage utilities such as routines and shared containers.
  • Loaded data using Oracle connector stage in various modes such as insert, update, Upsert and custom SQL.
  • Used Sequential , Dataset , Transformer , Aggregator , Change Data Capture , filter , sort , join , look up , merge and several other parallel stages to build datastage jobs.
  • Extensively used various parallel transformation functions and data type manipulations in both datastage and Oracle.
  • Created Rule sets to be used in the process of Standardizing the data using Quality stage .
  • Worked with Standardize, Match frequency and Cass stages , in Quality stage , to enrich the quality of the incoming data.
  • Created Server routines for re usable transformations.
  • Implented various ETL validations and reconciliations such as matching record counts at source and targets.
  • Created sequence jobs that consist of Server, parallel jobs and execute command utililities.
  • Used QualityStage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information.
  • Performed Data cleansing by matching user introduced data with database data, removing duplicates, and extraction of relations from source systems using QualityStage
  • Promoted datastage objects to CVS environment using winCvs .
  • Created Materialized views which are required by Busines Objects reporting team.
  • Assisted with creating custom sql for Business Objects reporting team.
  • Performed and documented Unit test and results.
  • Creted Unix shell scripts for handling incoming files and validation.
  • Developed PL SQL Stored procedures and Functions for Oracle APEX team in fetching and loading data between user Interface and the APEX Oracle database.
  • Prepared Run Book documents and conducted project transistioning sessions with Full time staff at the client location.

Environment: IBM InfoSphere Datastage and Quality stage 8.5/11.5, Oracle 10g/11i/12c, Unix AIX, Toad, Sql Loader, Win CVS, SAP Business Objects XI 3.1

Confidential, Philadelphia, PA

Sr Datastage Developer

Responsibilities:

  • Involved in ETL Mapping documentation.
  • Responsible for creating Monthly release Branches and ETL Design artifacts for blue core project and retrofit tasks.
  • Created common components in Datastage 8.5
  • Involved in upgrading ETL Batch processing using IBM Datastage 8.5
  • Created Parallel jobs to read data from mainframe systems and load into Teradata staging layer.
  • Created Teradata Bteq scripts to read data from Stage layer and to load into EDW layer.
  • Crated wrapper shell scripts and symbolic links on AIX UNIX.
  • Involved in data analysis during Functional requirements gathering process (FRD).
  • Created several ETL jobs to cross check and perform audit before and after loading the data from files that originate from vendor.
  • Migrated jobs and routines from 8.1 to 8.5 versions of Datastage..
  • Designed critical Datastage job using stages such as Transformer, Aggregator, Oracle connector, Teradata connector, Complex Flat File, Sequential file and datasets.
  • Created parallel jobs using SORT, AGGREGATOR, Join, Lookup, merge, duplicate elimination, Change data capture, Modify and Funnel stages.
  • Designed Datastage jobs to handle Change data capture.
  • Worked with Various Functions of Datastage such as ICONV, OCONV, and many more String functions.
  • Worked with Quality center.
  • Created several Oracle stored procedures to validate and load the data from one module to another module of the database.
  • Created and participated in Release planning and Run book management.
  • Involved in adhoc production support to fix on going ETL job issues.

Environment: Data Stage 8.5, parallel Extender, Teradata 13.10, Oracle 10g, SQR, Microsoft TFS, Anthill Pro, Unix AIX.

Confidential, Wilmington, DE

Data warehouse Developer

Responsibilities:

  • Participation in Requirements gathering, designing and development of ETL Solutions using best optimized approaches.
  • Created Tables and Views for website support In addition to warehouse development
  • Created Database Sequences, Synonyms and triggers.
  • Created and maintained Audit tables and Audit Triggers in Oracle database.
  • Created materialized views and M$Log tables for both Complete and Fast refresh groups.
  • Created stored procedures and functions and Packages which are used in both OLTP and OLAP.
  • Crated processes to load various files from UNIX file system into Oracle database using SQLLOADER utility.
  • Performed Query tuning using explain plan and index analysis.
  • Implemented various ETL strategies to improve the Query and loading performance in data stage
  • Closely worked with database administrators and data modellers to attain better results, while the modeling of the schema is initiated.
  • Worked with the ETL jobs which need stored procedure calls from Data stage.
  • Migrated jobs and routines from 6.0 and 7.5 to 8.1 versions of Datastage.
  • Involved in the Artifacts, Checklists and Release plans for the website as well as data feed releases.
  • Used Confidential ETL framework to load ASCII and EBCDIC files into STG layer and subsequently load the data into CORE layer.
  • Worked closely with WARE, CIF, TLPHY and CDS databases.
  • Designed critical Data stage jobs to load data into Data warehouse from Source to Stage and from stage to Warehouse subsequently.
  • Created complex job designs using Hashed file, Transformer, Aggregator, Inter Process, Oracle stage and Stored procedure stages in Server version.
  • Used Ora OCI, SORT, AGGREGATOR, Join, Lookup, merge, duplicate elimination, Change data capture, Modify and Funnel Stages in Parallel Extender for handling different logics that are required to attain critical tasks in parallel extender.
  • Involved in performance tuning of datastage jobs.
  • Used Manager in exporting, importing Jobs and table definitions.
  • Developed Complex Server routines to attain a result set which has multiple exceptions.
  • Worked with Various Functions of Datastage such as ICONV, OCONV, and many more String functions.
  • Used Quality center and SDLC tools for tracing the tasks and features.
  • Created UNIX shell scripts in conjunction with Datastage jobs.
  • Used Director to monitor the results and examining the datastage logs
  • Used Batch job control as well as sequencers for the string of jobs in the final development.
  • Promoted jobs from DEV to QA using WinCVS tool.
  • Documented Unit Test results and Job designs.
  • Involved in Change management and problem management cycles.
  • Provided Trouble shooting for Production Support.

Environment: Data Stage 6.0/7.5.1/8.1 , Multi client manager, parallel Extender, Oracle 9.2/10g, Micro Strategy, wincvs 2.0, Unix Solaris/AIX, PeopleSoft EPM8.9.

Confidential, Livingston, NJ

Datastage Developer

Responsibilities:

  • Participated in gathering user requirements and working closely with data modeling team.
  • Defining and designing the E-T-L mapping document.
  • Participated in data modeling design for OLAP systems.
  • Analyzed the data feeds and defined rules for loading various Business objects universe data marts..
  • Understanding the functionality of the Salseforce.com (CRM) which is the source data system.
  • Used Scribe Insight 6.2(etl tool) to Extract the data from the Salseforce.com and loaded in to MS Access to supply as the source system's data
  • Involved in data cleansing aspects such as .new line carriage elimination and Space truncation issues in MS Access as well as in CSV files(Also Tab delimited)
  • Worked with Data stage Manager for importing Metadata from repository, new job categories and creating new data elements
  • Used Change capture stage / Modify stage in parallel jobs to achieve complicated tasks which involves delta (change) data and Meta data change aspects.
  • Designed and implemented slowly changing dimensions methodologies.
  • Used SQL Developer utility to perform sql Queries and unit test the data.
  • Extensively used Oracle OCI, Bulk Load, and ODBC Stages, as passive stages and Transformer, Aggregator for active stages.
  • Created Universe in Business objects XI/R2
  • Generated complex reports in webi as well as in desktop intelligence.
  • Used salient features of Business objects such as @Aggregate awareness, user defined variables, Derived tables, filters, alerter etc...
  • Applied row level security to restrict the data on a given condition in Business Objects Universe.
  • Involved in documenting the job flows and design diagrams.

Environment: Salesforce.com(CRM), SCRIBE INSIGHT 6.2,, Data Stage 7.5.1, Parallel Extender, Oracle 9.2, Meta Stage, Quality Stage, Profile Stage, Audit Stage, Business Objects XI/R2, Web IntelligenceXI/R2.

Confidential, NJ

Database Developer

Responsibilities:

  • Provided system analysis and design of the Data warehouse.
  • Built Data Warehouse from scratch with star schema model.
  • Used Joiner/Merger/Lookup stages for loading data.
  • Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
  • Mapping Data Items from Source Systems to the Target System.
  • Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
  • Designing and Developing PL/SQL Procedures, functions, and packages to create Summary tables.
  • Performed data conversion from DB2, AS/400 system to Data Warehouse.
  • Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
  • Written batch Job Controls for automation of Execution of data Stage Jobs.
  • Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
  • Implemented orchestrate for parallel processing of the data stage jobs.
  • Implemented Auto Sys for scheduling Data Stage Batch Jobs.
  • Migrated XML data files to Oracle data mart for Data Lineage Statistics.
  • Implemented Log-based change data capture (CDC) for delta loading.
  • Designed guide lines for Source based CDC & Target based CDC
  • Defined Stage variables for data validations and data filtering process..
  • Developed both canned and Ad-Hoc reports based on the end users requirements.
  • Involved in creating and publishing reports in webi.

Environment: DB2, AS/400, AIX 5.1, Data Stage 7.5,Parallel Extender, Oracle 9.2, Meta Stage, Quality Stage, Profile Stage, Audit Stage, Business Objects 6.51, Web Intelligence 6.51

We'd love your feedback!