We provide IT Staff Augmentation Services!

Sr. Data Warehouse Programmer Analyst Resume Profile

KY

OBJECTIVE

Seeking a Challenging Professional position as Sr. Enterprise Data Warehouse Architect / Sr. Data Warehouse Programmer Analyst in the field of Information Technology that would best utilize my experience, skills creative abilities.

PROFESSIONAL SUMMARY

  • More than 15 years of IT experience in analysis data profiling/ data quality , design, development, testing and implementation as Oracle PL/SQL Developer specializing in Enterprise Data Warehouse EDW Application Development, Designing complex Dimensional Data Models Star Schemas and ETL Process , relational databases concepts and mechanisms, Migrations, Upgrades, Production Support, Application Development and Client/Server Applications.
  • Extensive experience developing EDW ETL process and EDW ETL Tools in using IBM DataStage 8.7 Administrator/Director/Client , MS Visual Studio 2008 - Microsoft Integration Services/SSIS, Teradata 14.0, Oracle 11g Release 11.0.2, MS SQL Server Enterprise Manager 8.0 /2000/2005/2008, Business Objects 5.1.7 / XI Release 2, MS Dynamics AX 2009, Informix 8.3, Erwin 8.5, Oracle Data Modeler 3.0, T-SQL, SQL, PL/SQL, KORN SHELL, UNIX AIX 6.1, MS Windows Server Enterprise 2003, Eclipse Java EE IDE - CVS, Windows Batch Scripts and Kimball Group of Methodologies.
  • Extensive work experience in ETL analysis, designing, developing, testing and implementing ETL process in IBM DataStage Enterprise Edition 8.7.
  • Data Profiling was used for the analysis of the variety of data sources for a data warehouse to clarify the structure, content, relationships and derivation rules of the data.
  • Data Profiling was used for anomalies and to assess data quality, but also to discover, register, and assess enterprise metadata in DataStage.
  • Control-M Client 8.1 is used for EDW Scheduling.
  • Work on JIRA using Agile Development for DataStage and Teradata tasks.
  • Develop Standards and Best Practices of DataStage and Teradata for EDW.
  • Extensive work experience in developing complex ETL strategy, detailed mapping and implementing optimized ETL process in IBM DataStage.
  • Thorough experienced in troubleshooting DataStage jobs, fixing bugs and addressing production issues like performance tuning and enhancements.
  • Developed strategic and complex EDW Projects and translate Business into long term Data Architecture solution including Business Intelligence BI tools such as Business Objects XI and MicroStrategy 9i reporting environments.
  • Coordinate and work closely with EDW and BI team to ensure business reporting requirements are supported by the EDW.
  • Developed all phases of Applications Systems Development Life Cycle IEEE .
  • Analyzed disparate sources of data, design a Dimensional star schema in conjunction with the Senior VP/Director/Manager/Architects of EDW and implementing an ETL process to move the data into the Dimensional star schema on Oracle 11g, SQL Server 2000, SQL Server 2008 and Teradata 14.
  • Developed Dimensional Star Schemas over varied sources of data which meets the business imperatives.
  • Build, Design and Manage EDW Kimball Dimensional Star Schema designs, ETL process, dimensional data structures, Meta data, data repositories and data governance.
  • Administered with DW Applications and DBA's to ensure appropriate use of data and data structures within system design and modification, performed DBA daily tasks for EDW.
  • Administered with business users, Applications and DBA's to manage data within the EDW and BI structures which meets the business imperatives.
  • Extract data and develop loads into the most appropriate dimensional data structures for optimal performance in use by individual users and other systems.
  • Administered in reusability of current data for additional analysis, review objects, data models and Meta data repository to structure the data for better management and quicker access.
  • Managed in data cleansing to rid system of old, unused, or duplicate data.
  • Administered in quality assurance reviews with Applications.
  • Managed in trouble shooting and problem solving skills from all root causes.
  • Administered in the design and development of an ETL process to incorporate source data into the EDW.
  • Mentor EDW team members on ETL best practices as well as star schema design using Kimball group Data Warehouse best practices and techniques.
  • Coordination and Production support of the nightly ETL job stream for DataStage 8.7, SSIS Packages and Oracle PL/SQL on Oracle 11g.
  • Utilized IDE to ensure all code is stored in the appropriate source control system Eclipse Java EE IDE and Visual Source Safe 6.0 to ensure all code follows best practices and standards as lay out by the EDW and IT policies.
  • Developed, Managed and Administered Year End Task for EDW.
  • Trained in Teradata Decision Experts TDE , Teradata Intelligence TDI , Teradata Master Data Management MDM , Teradata Administration, Teradata Studio, Teradata View Point and Teradata Unified Industry Logical Data Model LDM of Order Management OM , General Ledger GL , Point of Sale POS , Forecast, Inventory, Planning, Manufacturing and Distribution.

SKILLS

Databases

:

Teradata 14.0, ORACLE 11g, MS SQL Server 2000/2005/2008, INFORMIX 8.3, DB2 Main Frame, MS Access 9.0

ETL Tools

:

IBM DataStage 8.7, MS Visual Studio 2008- Microsoft Integration Services/SSIS

Languages

:

SQL, PL/SQL, T-SQL, PERL 5.0, VB / VC 6.0

ERP

:

MS Dynamic AX 2009, MS NAVISION ATTAIN 3.6

Source Control

:

CVS Eclipse Java EE IDE, MS Visual Source Safe 6.0.

Development Tools

:

Teradata Studio 14, Oracle SQL Developer 3.0, ject Management EPM nracle 11g, 7 days a week from last 8 years.Toad 11.0 for Oracle 11g, Business Objects XI Release 2, MicroStrategy 9i, Crystal Reports 4.5, Oracle Developer 2000

Software Packages

:

Enterprise Project Management, MS Project'2010 and MS Office'2007.

Operating Systems

:

Windows 7 Enterprise, UNIX AIX 6.1, Sun OS 5.7, HP-UNIX , Red Hat LINUX 7.2, SSH, Putty.

Scripting

:

KORN Shell, PERL/CGI, Java Script

Software Engineering

:

CASE, SEI/CMM/IEEE, UML, COGNOS 8.0, Power Designer 5.0, Erwin 8.5, Oracle Data Modeler, VISIO Rational Rose

Web Technologies

:

MQ Series, HTML 4.5, CGI/Perl, Java Script 1.2

WORK EXPERIENCE

Sr. Data Warehouse Programmer Analyst

Confidential

Environment: IBM InfoSphere DataStage 8.7, IBM InfoSphere Information Server Manager 8.7, AIX 6.1, Oracle 11g, MS Visual Studio 2008, MS SQL Server Business Intelligence Studio SSIS, Erwin 8.5

  • Involved in DataStage Re-Architecture of Russell Enterprise Data Warehouse.
  • Rewrite all existing ETL SSIS Packages in IBM DataStage 8.7 for Russell EDW ETL Migration for Oracle 11g in Dimensional Star Schemas.
  • IBM InfoSphere DataStage and Quality Stage 8.7 Administrator is used to create new projects and setup the project properties with setup of new users, groups, set log to purge after set no of days, share meta data when importing from connectors, set up environment variables such as directory path, user defined all variables for datastage directories, all connections to various sources and job parameters.
  • Developed Parallel ETL jobs in IBM InfoSphere DataStage and Quality Stage 8.7 Designer and import all Table definitions.
  • Developed Parallel shared Containers, Surrogate key jobs, Parameter sets parallel job , Table Definitions IBM InfoSphere DataStage and Quality Stage 8.7 Designer.
  • Developed ETL job sequences in IBM InfoSphere DataStage and Quality Stage 8.7 Designer.
  • Developed generic Shell Scripts, properties files, ftp scripts for sequence jobs to be executed in DataStage.
  • Developed the SDLC documents such as functional designs, detail designs, data plans, test plans and implementation plans.
  • Control-M is used to schedule all DataStage ETL Loads using Shell Script on DataStage Server to load Oracle 11g.
  • IBM InfoSphere DataStage and Quality Stage 8.7 Director is used to set up option limit on warning after exceeding a certain limit to end the job, enabling job refresh every so many seconds.
  • Monitor all jobs using jobs sequences using IBM InfoSphere DataStage and Quality Stage 8.7 Director.
  • IBM InfoSphere Information Server Manager 8.7 is used for export of development project and import and overwrites in production projects.
  • Perform Production support of daily nightly ETL job stream for DataStage 8.7.
  • Utilize an IDE Eclipse Java EE IDE to ensure all code is stored in the appropriate source control system.
  • Turn OFF all SSIS Packages upon completion of ETL Migration.

Created Logical and Physical 2NF Models using Erwin 8.5.

Confidential

Environment: IBM InfoSphere DataStage 8.7, IBM InfoSphere Information Server Manager 8.7, AIX 6.1, Oracle 11g, Erwin 8.5

  • Involved in DataStage Re-Architecture of Fruit Core Enterprise Data Warehouse.
  • Rewrite ETL jobs from Oracle PL/SQL to IBM DataStage 8.7 for Fruit EDW ETL Migration for Oracle 11g in Dimensional Star Schemas.
  • IBM InfoSphere DataStage and Quality Stage 8.7 Administrator is used to create new projects and setup the project properties with setup of new users, groups, set log to purge after set no of days, share meta data when importing from connectors, set up environment variables such as directory path, user defined all variables for datastage directories, all connections to various sources and job parameters.
  • Developed Parallel ETL jobs in IBM InfoSphere DataStage and Quality Stage 8.7 Designer and import all Table definitions.
  • Developed Parallel shared Containers, Surrogate key jobs, Parameter sets parallel job , Table Definitions IBM InfoSphere DataStage and Quality Stage 8.7 Designer.
  • Developed ETL job sequences in IBM InfoSphere DataStage and Quality Stage 8.7 Designer.
  • Developed generic Shell Scripts, properties files, ftp scripts for sequence jobs to be executed in DataStage.
  • Developed the SDLC documents such as functional designs, detail designs, data plans, test plans and implementation plans.
  • Control-M is used to schedule all DataStage ETL Loads using Shell Script on DataStage Server to load Oracle 11g.
  • IBM InfoSphere DataStage and Quality Stage 8.7 Director is used to set up option limit on warning after exceeding a certain limit to end the job, enabling job refresh every so many seconds.
  • Monitor all jobs using jobs sequences using IBM InfoSphere DataStage and Quality Stage 8.7 Director.
  • IBM InfoSphere Information Server Manager 8.7 is used for export of development project and import and over write in production projects.
  • Perform Production support of daily nightly ETL job stream for DataStage 8.7.
  • Utilize an IDE Eclipse Java EE IDE to ensure all code is stored in the appropriate source control system.
  • Turn OFF all Control-M jobs executed from AIX 6.1 UNIX Server upon completion of ETL Migration.

Created Logical and Physical 2NF Models using Erwin 8.5.

Confidential

Environment: IBM InfoSphere DataStage 8.7, IBM InfoSphere Information Server Manager 8.7, AIX 6.1, MS Dynamics AX 2009, MS SQL Server 2008, Oracle 11g and Erwin 8.5.

  • Involved in DataStage of Fruit International EDW on Oracle 11g.
  • Citrix Application Web Interface is used to connect to MS DAX 2009 which is on MS SQL Server 2008.
  • Developed and Maintained ETL jobs using IBM DataStage 8.7 for Fruit International EDW ETL from MS SQL Server 2008 into Dimensional Star Schemas on Oracle 11g.
  • IBM InfoSphere DataStage and Quality Stage 8.7 Administrator is used to create new projects and setup the project properties with setup of new users, groups, set log to purge after set no of days, share meta data when importing from connectors, set up environment variables such as directory path, user defined all variables for datastage directories, all connections to various sources and job parameters.
  • Developed Parallel ETL jobs in IBM InfoSphere DataStage and Quality Stage 8.7 Designer and import all Table definitions.
  • Developed Parallel shared Containers, Surrogate key jobs, Parameter sets parallel job , Table Definitions IBM InfoSphere DataStage 8.7 Designer.
  • Developed ETL job sequences in IBM InfoSphere DataStage 8.7 Designer.
  • Developed generic Shell Scripts, properties files, ftp scripts for sequence jobs to be executed in DataStage.
  • Developed the SDLC documents such as functional designs, detail designs, data plans, test plans and implementation plans.
  • Control-M is used to schedule all DataStage ETL Loads using Shell Script on DataStage Server to load Oracle 11g.
  • IBM InfoSphere DataStage and Quality Stage 8.7 Director is used to set up option limit on warning after exceeding a certain limit to end the job, enabling job refresh every so many seconds.
  • Monitor all jobs using jobs sequences using IBM InfoSphere DataStage and Quality Stage 8.7 Director.
  • IBM InfoSphere Information Server Manager 8.7 is used for export of development project and import and over write in production projects.
  • Perform Production support of daily nightly ETL job stream for DataStage 8.7.
  • Utilize an IDE Eclipse Java EE IDE to ensure all code is stored in the appropriate source control system.

Created Logical and Physical 2NF Models using Erwin 8.5.

Confidential

Environment: IBM InfoSphere DataStage 8.7, IBM InfoSphere Information Server Manager 8.7, AIX 6.1, Oracle 11g, MS Visual Studio 2008, MS SQL Server Business Intelligence Studio SSIS, Teradata 14, AS/400, JD Edwards, Erwin 8.5.

  • Involved in DataStage Re-Architecture of Huffy Enterprise Data Warehouse.
  • Developed Dimensional Star Schema for Huffy EDW in Semantic Layer.
  • Rewrite all existing ETL SSIS Packages in IBM DataStage 8.7 for Russell EDW ETL Migration in Teradata using 3NF by creating Logical and Physical Models.
  • Creation of Physical Layer all Star Schema tables , Access Layer views from physical layer and Semantic Layer view from access layer for EDW.
  • IBM InfoSphere DataStage and Quality Stage 8.7 Administrator is used to create new projects and setup the project properties with setup of new users, groups, set log to purge after set no of days, share meta data when importing from connectors, set up environment variables such as directory path, user defined all variables for datastage directories, all connections to various sources and job parameters.
  • Developed Parallel ETL jobs in IBM InfoSphere DataStage and Quality Stage 8.7 Designer and import all Table definitions.
  • Developed Parallel shared Containers, Surrogate key jobs, Parameter sets parallel job , Table Definitions IBM InfoSphere DataStage and Quality Stage 8.7 Designer.
  • Developed ETL job sequences in IBM InfoSphere DataStage and Quality Stage 8.7 Designer.
  • Developed generic Shell Scripts, properties files, ftp scripts for sequence jobs to be executed in DataStage.
  • Developed the SDLC documents such as functional designs, detail designs, data plans, test plans and implementation plans.
  • Control-M is used to schedule all DataStage ETL Loads using Shell Script on DataStage Server to load Oracle 11g.
  • IBM InfoSphere DataStage and Quality Stage 8.7 Director is used to set up option limit on warning after exceeding a certain limit to end the job, enabling job refresh every so many seconds.
  • Monitor all jobs using jobs sequences using IBM InfoSphere DataStage and Quality Stage 8.7 Director.
  • IBM InfoSphere Information Server Manager 8.7 is used for export of development project and import and overwrites in production projects.
  • Perform Production support of daily nightly ETL job stream for DataStage 8.7.
  • Utilize an IDE Eclipse Java EE IDE to ensure all code is stored in the appropriate source control system.
  • Turn OFF all SSIS Packages upon completion of ETL Conversion.

Created Logical, Physical 3NF Models and Semantic 2NF Models using Erwin 8.5.

Confidential

Environment: IBM InfoSphere DataStage 8.7 Administrator/Designer/Designer , IBM InfoSphere Information Server Manager 8.7, AIX 6.1, Oracle 11g and Teradata 14 Enterprise Data Warehouse.

  • Developed DataStage Replication of Fruit Oracle tables OTC to Teradata and Russell Oracle tables ROTC to Teradata Enterprise Data Warehouse on separate databases.
  • Created Projects in DataStage Administrator separately for FOTC and ROTC and user defined environment variables.
  • Developed Parallel jobs in DataStage Designer for Migration of data from Oracle to Teradata Replication.
  • Created job sequences in DataStage and execute these sequences through Generic Shell script from Control-M Client.
  • Replicate Star Schema 2NF from Oracle 11g into Teradata 14 Physical Layer by range.
  • Created parameter sets in DataStage Designer for all DataStage jobs.
  • Created Access Layer views in Teradata from 2NF/ 3NF Tables of Physical Layer.
  • Created Semantic Layer views in Teradata using Access Layer views of Inventory, POS, Forecast, Open Orders, Credits and Invoices Shipments and 3NF Date Dimensions.
  • Created Generic DataStage Validation jobs for counts and sums using Parameter sets for each 2NF Tables Dimensions and Fact and 3NF Dates.
  • Export and Import projects from Development to Production using IBM InfoSphere Information Server Manager 8.7.
  • CVS Project Repository is created using Eclipse for Physical, Access and Semantic Layers.
  • Created Logical and Semantic 2NF Models using Erwin 8.5.

Perform Production support of daily nightly ETL job stream for DataStage 8.7.

Confidential

Environment: IBM InfoSphere DataStage 8.7 Administrator/Designer/Designer , IBM InfoSphere Information Server Manager 8.7, AIX 6.1, SQL Server 2008, Oracle 11g and Teradata 14 Enterprise Data Warehouse.

  • Developed DataStage Replication of DAX SQL Server 2008 tables to Teradata Phyical layer and Replication of DW DAX in Oracle 11g to Teradata EDW and Conversion of DW DAX from Oracle 11g to Teradata Enterprise Data Warehouse.
  • Created International DAX Project in DataStage Administrator for EDW and user defined environment variables.
  • Developed Parallel jobs in DataStage Designer for Migration of data from DAX MS SQL Server 2008 to Teradata 14 Replication in Physical layer.
  • Developed Parallel jobs in DataStage Designer for Migration of data from Oracle 11g to Teradata Replication.
  • Conversion of DataStage jobs from Oracle 11g to Teradata for all Dimensions and Fact Tables.
  • Created job sequences in DataStage and execute these sequences through Generic Shell script from Control-M Client.
  • Created parameter sets in DataStage Designer for all DataStage jobs.
  • Created Access Layer views in Teradata from 2NF/ 3NF Tables of Physical Layer.
  • Created Semantic Layer views in Teradata using Access Layer views of Inventory, Open Orders and Invoices and 2NF Dimensions and other 3NF tables.
  • Created Generic DataStage Validation jobs for counts and sums using Parameter sets for each 2NF Tables Dimensions and Fact .
  • Export and Import projects from Development to Production using IBM InfoSphere Information Server Manager 8.7.
  • CVS Project Repository is created using Eclipse for Physical, Access and Semantic Layers.
  • Created Logical and Semantic 2NF Models using Erwin 8.5.

Perform Production support of daily nightly ETL job stream for DataStage 8.7.

Confidential

Environment: MS Windows Server 2003 Enterprise, MS SQL Enterpise Manager 8.0, MS SQL Server 2000, Windows Batch Scripts, Business Objects 5.1 / XI Release 2, DB2 Mainframe.

  • Involved in Development, Enhancement Production support for Enterprise Russell Data Warehouse.
  • Design Dimensional Star Schemas using Erwin 8.5 for each Business Process.
  • Developed ETL from multiple varied source system DB2 Mainframe/AS400/Data files into Data Warehouse using Data Transformation Services DTS Packages.
  • Developed T-SQL queries to load into Staging, Dimension and Fact tables using Dimensional Star Schema.
  • Tables, Partitions, Indexes, Triggers, Sequences, Link Servers, SQL Profiling and Tuning were performed on MS SQL Server 2000.
  • Developed generic Windows Batch Scripts on Windows Enterprise 2003 to execute the ETL Loads.
  • Support BI team and business users to ensure business reporting requirements are supported by the Data Warehouse using Business Objects XI Release 2.
  • Developed all required steps of the SDLC process, including but not limited to documentation, testing and implementation.
  • Control-M is used to schedule all ETL Loads on DB2 Mainframe jobs by Beta 41.
  • Performed Production support of daily nightly ETL job stream.
  • Performed upgrade of source System changes to EDW.
  • Utilize an IDE Visual Source Safe 6.0 to ensure all code is stored in the appropriate source control system.
  • Mentor EDW team members on Russell EDW.

Confidential

Environment: MS Visual Studio 2008, MS SQL Server Business Intelligence Studio SSIS, MS SQL Enterprise Manager 8.0, MS SQL Server 2000/2008, MS Windows Server 2003 Enterprise, Windows Batch Scripts, Business Objects 5.1 / XI Release 2, Oracle 11g, MicroStrategy 9i

  • Involved in Development, Enhancement Production support for Enterprise Russell Data Warehouse.
  • Visual Studio 2008 is used to developed separate projects for MS SQL Server and Oracle 11g on Windows ETL Server.
  • Created Data Sources using SSIS Packages for Enterprise Data Warehouse for all varied sources and also developed configuration files.
  • Created SSIS Packages for EDW to load SQL Server and Oracle 11g from all sources including data files send from mainframe to ETL Server.
  • Migration of SSIS Packages was created to migrate data from MS SQL Server to Oracle 11g.
  • Design Dimensional Star Schemas using Erwin 8.5 for MS SQL Server and Oracle.
  • Develop ETL from multiple source system DB2 Mainframe/AS400/MS SQL Server into EDW using Dimensional Star Schemas Dimension and Fact.
  • Developed T-SQL/SQL queries and PL/SQL Stored Procedure to load into Staging, Dimension and Fact tables on MS SQL Server and Oracle 11g.
  • Tables, Partitions, Indexes, Triggers, Sequences, Link Servers SQL Server , SQL Profiling and Tuning were performed on both MS SQL Server and Oracle 11g.
  • Developed generic Windows Batch Scripts on Windows Enterprise 2003 to execute the ETL Loads for MS SQL Server and Oracle 11g.
  • Work closely with the Business Intelligence Director/Manager/Analyst to ensure business reporting requirements are supported by the EDW using Business Objects 5.1 / XI Release 2 on MS SQL Server and MicroStrategy 9i on Oracle 11g.
  • Ensure Business Objects services are running on Application and Web Server.
  • Developed the SDLC process, including but not limited to Enterprise Project Management EPM , project estimation, functional design, detail design, data plan, test plan, implementation plan.
  • Control-M is used to schedule all ETL Loads using Windows Command Scripts on ETL Server for both SQL Server and Oracle 11g.
  • Perform Production support of daily nightly ETL job stream.
  • Work in concert with an EDW Manager to design star schemas over varied sources of data which meet the business imperatives for all new business process.
  • Performed upgrade of source system changes to EDW.
  • Utilize an IDE Eclipse Java EE IDE and Visual Source Safe 6.0 to ensure all code is stored in the appropriate source control system.

Confidential

Environment: Oracle 11g, AIX 6.1, Korn Shell, Erwin 8.5, IBM MQ Series, Perl 5.0 and MicroStrategy 9i.

  • Involved in Requirements, Analysis, Design, Development, Implementation, Enhancement Production support for Data Warehouse PKMS.
  • Involved in Software Development Life Cycle from Requirements through Deployment, Maintenance Enhancement of Data Warehouse PKMS.
  • Design Dimensional Star Schemas using Erwin 8.5.
  • Develop ETL from PKMS System into Data Warehouse using Star Schema.
  • Design and develop an ETL process to incorporate source data into the Enterprise Data Warehouse.
  • MQ Series is used to extract and export data from PKMS System to AIX 6.1 UNIX Server.
  • SQL Loader is used to load into Data Warehouse Staging area from data files.
  • Develop generic Korn Shell Scripts, Control Files to load data from data files into Data Warehouse Star Schema.
  • Developed SQL and PL/SQL Stored Procedure to load into Dimension and Fact tables using Oracle 11g.
  • Tables, Partitions, Indexes, Trigger, Sequences, and Tuning were performed.
  • Developed generic Korn Shell and Perl Scripts on AIX 6.1 to execute the ETL Loads.
  • Work closely with the Business Intelligence team to ensure business reporting requirements are supported by the Data Warehouse.
  • Participate in all required steps of the SDLC process, including but not limited to documentation, testing and implementation.
  • Control-M is used to schedule all ETL Loads.
  • Performed Production support and Business Intelligence support for PKMS Business Users.
  • Support of nightly ETL job stream, including some after hours support as needed.
  • Work in concert with a Data Warehouse Enterprise Manager to design star schemas over varied sources of data which meet the business imperatives.
  • Performed upgrade of PKMS System changes to Data Warehouse.
  • Utilize an IDE Eclipse Java EE IDE to ensure all code is stored in the appropriate source control system.

Confidential

Environment: Oracle 11g, AIX 6.1, Korn Shell, Perl 5.0, Erwin 8.5, MES Synapse and MicroStrategy 9i.

  • Involved in Requirements, Analysis, Design, Development, Implementation, Enhancement Production support for MES Systems.
  • Involved in Data Warehouse Life Cycle from Requirements through Deployment, Maintenance Enhancement of Data Warehouse.
  • SQL Loader is used to load into Data Warehouse Staging area from data files.
  • Develop generic Korn Shell Scripts, Control Files to load data from data files into Data Warehouse Star Schema.
  • Developed SQL and PL/SQL Stored Procedure to load into Dimension and Fact tables using Oracle 11g.
  • Design Dimensional Star Schemas using Erwin 8.5.
  • MES Synapse is used to extract and export data from textiles facilities to AIX 6.1 UNIX Server.
  • Control-M is used to schedule all ETL Loads jobs.
  • Performed Production support of Data Warehouse MES.
  • Performed upgrade of MES Synapse System changes to Data Warehouse MES.
  • Support Business Intelligence team with all MicroStrategy reporting.

Confidential

Environment: Oracle 11g, AIX 6.1, Korn Shell, Erwin 8.5 and MicroStrategy 9i.

  • Involved in Requirements, Analysis, Design, Development, Implementation, Enhancement Production support for AIM Systems.
  • Involved in Data Warehouse Life Cycle from Requirements through Deployment, Maintenance Enhancement of Data Warehouse AIM.
  • SQL Loader is used to load into Data Warehouse Staging area from data files.
  • Develop generic Korn Shell Scripts, Control Files to load data from data files into Data Warehouse Star Schema.
  • Developed SQL and PL/SQL Stored Procedure to load into Dimension and Fact tables using Oracle 11g.
  • Design Dimensional Star Schemas using Erwin 8.5.
  • AIM Oracle Database is use to replicated data using sync Manager on Data Warehouse and Data Warehouse ETL load are performed from the replicated tables.
  • Materialized view was created on the source oracle database and perform fast refresh using Sync Manager for all facilities.
  • Control-M is used to schedule all ETL Loads jobs.
  • Performed Production support of Data Warehouse AIM.
  • Performed upgrade of AIM Client Server System changes to Data Warehouse AIM.
  • Support Business Intelligence team with all MicroStrategy reporting.

Confidential

Environment: Oracle 11g, AIX 6.1, Korn Shell, Erwin 8.5, MQ Series, SQL Server 2000 and MicroStrategy 9i.

  • Involved in Requirements, Analysis, Design, Development, Implementation, Enhancement Production support for ESPS Sourcing Systems.
  • Involved in Data Warehouse Life Cycle from Requirements through Deployment, Maintenance Enhancement of Data Warehouse Sourcing.
  • Extract Data using Windows Batch script from SQL Server and place on the queue using MQ Series Channel.
  • MQ Trigger is used to extract from queue to the flat files on AIX 6.1 UNIX Server.
  • SQL Loader is used to load into Data Warehouse Staging area from data files.
  • Develop generic Korn Shell Scripts, Control Files to load data from data files into Data Warehouse Star Schema.
  • Developed SQL and PL/SQL Stored Procedure to load into Dimension and Fact tables using Oracle 11g.
  • Design Dimensional Star Schemas using Erwin 8.5.
  • Control-M is used to schedule all ETL Loads jobs.
  • Performed Production support of Data Warehouse Sourcing.
  • Performed upgrade of Sourcing EPPS Client Server System changes to Data Warehouse Sourcing.
  • Support Business Intelligence team with all MicroStrategy reporting.

Sr. Data Warehouse Programmer/Analyst, Confidential

Environment: Oracle 8i, HP-UNIX, Korn Shell, Perl 5.0, CGI Scripts, Html 4.5, Java Script 1.2, Cognos 8.0.

  • Involved in Requirements, Analysis, Design, Development, Implementation, Enhancement Production support for TD Waterhouse Global Securities.
  • Involved in Software Engineering Life Cycle from Requirements through Maintenance Enhancement. Develop applications from business requirements through deploy them in a multi-user client / server env.
  • Dynamic database was maintained at TD Waterhouse using Oracle 8i.
  • Design and develop Intranet using Html 4.5, Perl 5.0, CGI, and Java Script 1.2.
  • Packages, Classes, Modules were developed using Perl 5.0, CGI Korn Shell.
  • Crontab jobs were created using Korn Shell Scripts on UNIX platform.
  • Triggers, Cursors, Packages Dynamic SQL's were developed using PL/SQL.
  • Impromptu SQL queries were written using Cognos 8.0 for Business users.
  • OLAP Cubes were built in Cognos 8.0 for building reports for Business users.
  • Identified benchmark results in system performance and recommended solutions for enhanced system. Design and model system architecture using UML.
  • Develop and implemented new methods for Production Support.
  • Performed System support / customer support for Business Users.
  • Performed Migration from Development into Production and SQA testing.
  • Analysis, Investigation, Audit Verification were done using Oracle 8i.

Sr. Data Warehouse Programmer/Analyst, Confidential

Environment: Oracle 8i, Sun 5.6, Korn Shell, Perl 5.0, VC , CGI Scripts, Html 4.5, Java Script 1.2, Cognos 6.0, Power Designer 5.0, MS Project 2000, MS Access 9.0.

  • Involved in Requirements, Analysis, Design, Development, Implementation, Enhancement Production support for MIS Data Mart at Bank of America.
  • Technically responsible for maintaining MIS Data Mart in Production support Business users. Identified benchmark results in system performance and recommended solutions for enhanced system performance. Identified tasks necessary for completion prior to Go-Live production.
  • Responsible for developing, implementing new methods for Production Support.
  • Responsible for Migrating MIS Data Mart from Development into Production.
  • Responsible for the QA performance of the MIS Data Mart application.
  • Maintained the project workplan using MS Project'2000 after the Vendor left the project and acted as liaison between the user community and other technical departments in New England within Bank of America.
  • Impromptu SQL queries were written for Business users using Cognos 6.0.
  • Dynamic Html Reports was also developed using Web Powerplay.
  • On Line Analytical Processing was also done for data analysis for Business users.
  • OLAP Cubes were built in Cognos 6.0 for building reports for Retail Group users.
  • DDL's, DML, Stage Main database was created for MIS Data Mart using PL/SQL.
  • Modules were written using Perl 5.0 Korn Shell scripts.
  • Object, Classes, Modules were built using Visual C 6.0.
  • Triggers, Cursors, Packages Dynamic SQL's were developed using Oracle 8i.
  • Linked Tables, Reports and Forms were developed using MS Access 9.0.
  • Implementation of SQA, Audit Controls, Threshold Logic, Error/Exception
  • Handling Routines. Data Modeling was developed using Power Designer 5.0.

Data Warehouse Programmer/Analyst, Confidential

Environment: HP-UNIX, Oracle 8.0.5, Perl 5.0, CGI Scripts, Korn Shell, Java Scripts 1.2, Html 4.0, Crystal Reports 4.5.

  • Involved in Design, Development, Enhancement, Implementation Production Support of Lilly Interplant Demand Management Systems at Eli Lilly Company.
  • Korn Shell Perl/CGI Scripts was developed. Wrote Triggers, Cursors Packages using Oracle 8.0.5. Crontab Commands were written using Korn Shell Scripts.
  • Dynamic Web site was developed using Perl/CGI, Java Scripts 1.2 Html 4.0.
  • SQL Loader was used to load Oracle database from external files.
  • Reports were developed using Crystal Reports 4.5.

Programmer/Analyst, Confidential

Environment: HP-UNIX, Oracle 8.0.5, Korn Shell, Perl 5.0, CGI Scripts, Java Scripts 1.2, Html 4.0, Developer 2000.

  • Involved in Design, Development, Enhancement, Implementation Production Support of Manufacturing Corporate Research Engineering Advanced Technology Applications at Ford Motor Company.
  • GUI was developed for Mfg. Corporate Research Engg. App. using Korn Shell, Perl, CGI, and Java Scripts Html. Scripts were written to maintain, update improve data integrity for Oracle using Perl/CGI Scripts. Scripts were also written to support the LDAP Server, Oracle Web Server for data integrity.
  • Dynamic reports were done in Access, Html, Excel Word using Perl, CGI Scripts Java Scripts. Dynamic Forms Reports were also developed using Oracle Developer/2000. Wrote Procedures, Functions, Methods, and Events Modules using Perl, CGI, Java Script Html. Wrote Triggers, and Cursors Packages using Oracle 8.0.
  • SQL Loader was used to load Oracle database from external files.
  • Database Administration/Maintenance was done in Development Production.

Programmer/Analyst, Confidential

Environment: HP-UNIX, Oracle 8.0, Visual Basic 6.0, MS Access 7.0.

  • Involved in Design, Development, and Implementation Production Support for Visteon Pricing Model at Ford Motor Company.
  • Developed a prototype for Visteon Pricing Model using MS Visual Basic 6.0.
  • Developed various forms in Visual Basic 6.0 for the Visteon Pricing Model.
  • DAO were used to connect Oracle 8.0 with MS Visual Basic 6.0.
  • Active X controls were used extensively in forms especially Formula One Grid.
  • Created Class Modules, Events Modules using Class Builder.
  • Administration Forms for the database was developed using MS Visual Basic 6.0.

Contract - Programmer/Analyst, Confidential

Environment: HP-UNIX, Oracle 7.3, Visual Basic 4.0, MS Access 7.0, Crystal Reports.

  • Involved in Design, Development, Enhancement, and Implementation Production Support for the Warranty Claims TAA Systems at Ford Motor Company.
  • Development Enhancements of Forms using MS Visual Basic 4.0.
  • Wrote Functions, Triggers, Stored Procedures, Cursors, and Packages Exceptions using Oracle 7.3.4. Reports were developed using Crystal Report 4.5.
  • Wrote Function, Methods, MDI, Procedures Exceptions using Visual Basic 4.0.
  • Forms, Classes Modules were developed using Visual Basic 4.0.

Hire Now