| Candidate Information | | Title | Data Warehouse Sql Server | | Target Location | US-MD-Elkton |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSummary24 Years of development experience and 16 years in ETL processing using DataStage, Implemented and Tested of ETL applications in Banking, Healthcare and Retail performing Data Extraction, Data Cleansing, Data Transformation, Documented many programs. Data Loading and Data Analysis. Strong experience in Data Warehouse projects, created complex SQL statements using joins and sun queries. Familiar with all areas of Data warehouse. Expertise in design and development of ETL process using IBM Data Stage v7.5 thru 11.5, Upgrades from older versions to 11.5, Data Stage Designer, Data Stage Director, Parallel Extender (PX) and experience with Information Analyzer and Quality StageTechnologyOperating Systems: Windows, Linux, UnixLanguages: SQL, T-SQL and My SQLTools: IBM InfoSphere DataStage, QualityStage, Information Analyzer, Autosys,Toad, SQL Plus, SQL Server Management Studio, and othersDatabases: Oracle 9I, DB2, MS SQL, SQL Server, Vertica and NetezzaPROFESSIONAL EXPERIENCELabCorp Sept 2023 April 2024DataStage DeveloperDeveloped jobs to load data in slowly changing dimensions to the Data Warehouse using CDC Stage using DataStage 11.3Developed and modified DataStage jobs using Runtime Column Propagation to dump many tablesUtilized Pivot, Looping, Transformer, Join, Lookup, User variables, Command stage and other stagesDeveloped Job Sequences, job activities, execute commands, user variable activity and implemented logic for job sequence loops, recovery and restartCreated detailed design documents for ETL jobs and SequencesGeneral Motors Nov 2020 June 2023DataStage DeveloperDeveloped jobs in DataStage 11.5 using complex SQL Joins and Queries also used stages such as Aggregator, CDC (Change Data Capture), JDBC (Used for HANA/SAP), DB2 Connector, Lookup, Transformers, Remove duplicates, DataSets and Sequential FilesPerformed Sparse look ups and normal lookups.Created programs to update changing data similar to dimensional data.Created Sequences with Activities to run jobs daily and CMD stages to update some files with Starting dates to pull data.Support Middle East, South America and Europe ETL processesReviewed Autosys logs and Unix logs to resolve any issuesAhold-Delhaize April 2020 Oct 2020DataStage DeveloperDeveloped jobs in DataStage 11.7 using stages such as Look Up, Aggregator, Transformer, ODBC Connections, Seq File, Datasets and otherAggregated and Summarized three years of promotions and advertised salesDeveloped Sequence to run and schedule the DataStage jobs to produce test resultsDocumented all jobsBank of America (Tata) Mar 2019 Aug 2019DataStage L3 SupportDetermine the appropriate code for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rulesResolved support tickets that required some code changes and scripting changes while updating and testing DataStage jobs using AutosysReviewed all security and privacy training and other training in the banking industryProvided level 3 Support for Credit card deptWalmart (Tata) Oct 2018 Mar 2019DataStage DeveloperMigrated DataStage jobs from 9.1 to 11.5, DB2, UNIXUpdated various UNIX scripts to perform automation of stopping and starting DataStage jobsUsed DataStage stages namely Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding and MQ FTEUpdated and tested DataStage jobs and Unix scripts to run in new environmentTested updated scripts / DataStage jobsEncode Inc July 2017 June 2018Manalapan, NJData Analyst (Worked Remotely)Installed and configured IBMs Analyst Notebook, DB2 and DataStage for future projectAttending Analyst Notebook Demo on data ingestionConfigured and tested Analyst Notebook with Demo data and Law Enforcement exampleCreated data to run jobs to extract data for Analyst NotebookMRC Global Jan 2017 June 2017Charleston, WVDataStage Developer(Remote)Developed and modified DataStage jobs and SequencesDocumented IBM InfoSphere Data warehouse processes in DataStage 11.5Created detailed design documents for hundreds of ETL jobs and sequences processing facts and dimensionsDB was DB2 9.7HP Enterprise Oct 2015 Oct 2016Newark, DEDataStage DeveloperDeveloped jobs to load data in slowly changing dimensions to the Data Warehouse using CDC Stage using DataStage 11.3Developed and modified DataStage jobs using Runtime Column Propagation to dump many tablesUtilized Pivot, Looping, Transformer, Join, Lookup, User variables, Command stage and other stagesDeveloped Job Sequences, job activities, execute commands, user variable activity and implemented logic for job sequence loops, recovery and restartCreated detailed design documents for ETL jobs and SequencesWorked with State of Delaware Medicaid and Medicare systemsBank of America June 2015 Sept 2015Newark, DEDataStage Developer/Business AnalystIBM InfoSphere DataStage Version 9.5Reviewed scope and requirements to achieve Basel certificationCreated documentation for gaps and test casesCompleted all required training for fraud prevention and other financial related crimesWorked as Business Analyst for Basel certificationXO Communication July 2014 Jan 2015Senior Technical ConsultantParticipated in analysis and design of new ODS from existing warehousesDeveloped tested and maintained IBM InfoSphere DataStage jobs and Sequences.Created processes to extract Master Data extracts from several sources using DataStage 9.1.2Implemented slow changing dimensions using Change Data Capture stage to load the Data WarehousePrepared technical design/specifications for Data Extraction, Data Transformation, Data Cleansing and Data LoadingOtsuka Pharmaceuticals & IBM July 2014 Oct 2014Princeton, NJSenior Technical ConsultantMigrated and Updated DataStage jobs and sequences to load data into Netezza Data WarehouseCreated Unix scripts to run the assets required to be implementedAttended HIPAA training to for Data security and privacy requirementsAdhered to HIPAA Privacy Rules and Compliance and received required training for the sameBank of America June 2013 April 2014Newark, DELead DataStage DeveloperDeveloped DataStage jobs to load data in slowly changing dimensions using CDC Stage in DataStage 9.5Created DDLs for DB2 and Vertica tables from Mainframe files and loaded the same tablesUsed Linux scripts and Osh Wrappers to load tables to Vertica and DB2Created and Implemented Information Analyzer and QualityStage rulesProvided technical expertise and assisted DataStage developers with creating jobs and following best practicesCreated JIL scripts for implementation of effective Autosys jobs (job scheduler)Used Autosys job scheduler for automating the monthly regular run of DWMigrated and Tested all programs in several different environmentsIBM Feb 2012 April 2013Raleigh, NC (Remote)DataStage DeveloperProvided experienced technical consulting in the definition, design, and creation of many DataStage jobs in FDBReviewed test results and verified Data transformations where implemented according to designed mappingsDebugged and resolved any Data issues with Unicode and various NLS mapsImplemented several Bit fields to match Data as it is produced today using PL/1 in a mainframe environmentMentored, assisted and lead junior DataStage developers and implemented DataStage ETL standardsDeveloped many DataStage jobs on 8.5 using many different stages such as DB2 connectors, Transformers, Filters, Look ups, Joins and Complex Flat Files and othersAssisted in trouble shooting issue HM jobs implemented April 2012U.S. Department of State, Diplomatic Security Sept 2010 Feb 2012Arlington, VADatabase Analyst / DataStage DeveloperProvided experienced technical consulting in the definition, design, and creation of data migration and integration projects.Mentored Junior DataStage developers on IBM InfoSphere DataStage mapping and requirementsCreated ETL standard mapping document and demonstrated its use both for analyst and developersDeveloped many DataStage using DataStage 8.1.2 using many different stages such as ODBC connectors, Oracle enterprise, Oracle connectors, Transformers, Filters, Look ups, Flat Files and othersDatabases used: Oracle 9i, 10g and 11 and MS AccessATK Corporation July 2010 August 2010Promontory, UTDataStage ETL DeveloperDeveloped standard IBM InfoSphere DataStage job using the Oracle connector stage and documented the process for the initial dimension loadCreated and implemented and instructed DataStage developers in the use of Parameter setsMentored Junior developers on DataStage mapping and requirements and documentationDemonstrated the creation and use Parameters setsCreated standards and best practices document for DataStageWorked with DataStage version 8.1.2Dana Corporation April 2010 June 2010Maumee, OHDataStage ETL DeveloperMigrated existing ETL from DataStage 7.5 to 8.1 replacing Oracle 8i stages with Oracle ODBCModified Parallel jobs with version 8.1 using Stages, which included Transformer, Sort, Join, Lookup, Filter, Aggregator, Funnel, Change Data Capture etcMigrated target DB from Oracle 9i to SQL ServerWorked remotely as neededUsed DataStage Designer to develop ETL processes to cleanse, transform, extract and load data to Data warehouseUsed Infosphere information Manager to do analysis and review logsUtilized Administrator to create test projects and create of update Parameters and project propertiesAMC Theatres Feb 2008 Oct 2009Kansas City, MODataStage ETL DeveloperDeveloped Parallel jobs in Unix AIX with version 8.0 using Stages, which included Transformer, Sort, Join, Merge, Lookup, Filter, Pivot, Aggregator, Funnel, Change Data Capture, Column Export, Column Import, etcParticipated in development phase for Business Analysis and Requirements GatheringWorked remotely on Fridays and other times as needed Used DataStage Designer to develop ETL processes to cleanse, transform, extract and load data to Analytical Data Mart, ODS and Enterprise Data Warehouse from various Sources such as Flat files, Oracle and SQL ServerWorked closely with data modelers to understand the business process and the Data Warehouse modelUsed Designer, Administrator, Director and Infosphere Information Manager to perform daily tasksCreated detailed design documents, Technical Application Design documents and Mapping documents for ETL jobs to load the new Data Warehouse and several data martsWorked with DBAs to address day-to-day issues with items like privileges, etcUtilized Erwin modeling tool to view data structures and Database designCreated Job Sequences to Control the job flow execution using various ActivitieRoyal Bank Of CanadaOntario, Canada Feb 2007 Dec 2007DataStage ETL DeveloperDeveloped ETL Applications with DataStage 7.51A Parallel Extender using Stages, which includes Transformer, Sort, Join, Merge, Lookup, Filter, Pivot, Aggregator, Funnel etc.Designed Data Stage Jobs to extract data from Oracle and load to Data Marts and Data WarehouseWorked closely with Data Analyst and Data Architects to understand the business processesCreated detailed design documents with illustrations to show data flow and processesCreated Job Sequences to Control the job flow execution using various ActivitiesExtensively worked on Parallel Extender using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sourcesAssisted the project manager in project planning, resourcing, ETL Designs and developing conceptual designsCiti Bank June 2006 Dec 2006Duisburg, GermanyDataStage ETL DeveloperDeveloped ETL applications using IBM InfoSphere DataStage 7.51A Enterprise Edition on a Unix platformDeveloped ETL processes to cleanse, transform, extract and load data into Analytical Data Mart and Enterprise Data Warehouse from various Sources such as Flat file, Oracle and SQL ServerUsed Parallel Processing techniques to improve job performanceCreated Job Sequences to Control the job flow execution using various ActivitiesBlue Cross Blue Shield Jan 2006 April 2006Chicago, ILDataStage ETL DeveloperDeveloped ETL applications using IBM InfoSphere DataStage Parallel ExtenderCreated DataStage jobs summarizing patient billing and provider dataUtilized Parallel Job Stages like Dataset, Sequential file, ODBC, Lookup/Lookup File set, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Surrogate Key, Merge, FilterCreated Job Sequences to Control the job flow execution using various Activities (Job Activity, Email Notification, Sequencers)Created scripts to send email and data to client site for review by end usersInter American Development Bank July 2004 Dec 2005Washington, DCDataStage ETL DeveloperMigrate Legacy DB2 Data Warehouse to DataStage Oracle 9I Data warehouseExtensively used Job Stages like Dataset, Sequential file, ODBC, Lookup, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Merge, Filter, Hash files, etcWork with business analyst and DBA to learn Data Model business process to load new Oracle Data WarehouseAnalyzed existing legacy code and created detail mappings and detail Design Documents of existing DB2 Data warehouse for migrating to new Oracle 9I Warehouse.Created views and code SQL in Oracle 9i to migrate legacy Data WarehousePrepared test data from legacy system to perform unit testing and system testing for ETL routinesInactive Clearance Level: Secret Expired (2/14)U.S. Department of StatePS800 Cyber Security Awareness TrainingIBM HIPAA Compliance ProgramDepartment of Children and Families Training and Development September 2014EducationUniversity of Maryland, College Park, MarylandMajor Computer Science and Information servicesLanguages: Unix, Oracle SQLDelaware County Community College, Media, PennsylvaniaAssociates Degree Computer Science (MIS) GPA 3.64Languages: Cobol II, Pascal, SQL, Visual Basic and CMember: Phi Theta Kappa (Honor Society)Computer Learning Center, Philadelphia, PennsylvaniaCertificate Computer ProgrammingLanguages: COBOL, Assembler and JCL |
