SUMMARY:

• Over 20 years of diverse work experience in Information Technology, including hands - on technical work as well as team leadership and project management.
• I had worked on several technical areas and on numerous types of projects, including data warehouse design; structured systems design and analysis; application and systems programming; database administration; data modeling; service oriented architecture; virtualization such as KVM, VMware and Zen; web services; networking of Confidential PC to Confidential Mainframes and software engineering.
• I’m currently involved performing implementation and deployment of Big Data, Data Lakes, Open Source and Security Risk assessment management programs.

TECHNICAL SKILLS:

Confidential Software: DataStage, Information Server, Information Analyzer, Fast Track, Quality Stage and MetaStage, Tivoli Scheduler, MDM, WebSphere

Confidential Mainframe: ES9000, S/390, Z SeriesUNIX (AIX, Sun Solaris, Linux, FreeBSD, OpenBSD)MVS, VM, CICS, DOS/VSE, JCL, TSO, REXX, Windows 7/8/10

Languages: C, C++, COBOL, Basic, Fortran, RPG II/III/400, PERL, Python, Ruby

Databases: DB2, IMS, MS-SQL Server, Oracle, Sybase, Teradata Greenplum DCA, Netezza

ETL Tools: BO Data Integrator, Informatica, Talend

OLAP Tools: BO, Cognos, Essbase, Brio, OBIEEApache Project/Open Source

StorageHadoop: Horton & Pivotal distros, Ambari, Big Data, CouchDb Cassandra, Eclipse, Hbase, Hive, Mahout, MongoDB, MapReduce, Pig, Redis, Spark, Sqoop, Tez, Tomcat, Zeppelin, ZooKeeperCobol CopyBooks, HDFS, XML, DTD, HTML, YarnEMC Data Domain and Isilon, Confidential Tivoli

PROFESSIONAL EXPERIENCE:

Confidential

Solutions Architect

Responsibilities:

• Provide technical guidance and conversion processes for clientele application development using DCA - Data warehouse appliances, Greenplum Database, Pivotal Hadoop and Big Data Lake infrastructure.
• Provide Subject Matter Expertise for Confidential and Oracle software packages like Cognos, Essbase Hyperion, Information Server, MDM, OBIEE, WebLogic, WebSphere to help clientele integrate and connect with Greenplum data warehouse appliance servers and Hadoop distribution such Horton and Pivotal.
• Install, configure and setup DCA appliances servers to be utilized as analytical reporting tools for Horton or Pivotal Hadoop distros and 3rd party packages such Confidential Information Server, SAS, Informatica and others. Also, apply software update patches for DCA servers, and Greenplum database.
• Architect and engineer Use cases for client software development phase to integrate with Big Data such Greenplum, Pivotal Hadoop and data lakes analytical tools.
• Perform installation and configuration of high speed network switches and NIC cards for DCA appliances servers for security hardening procedure and storage backups such Data Domain and Isilon.
• Subject matter expert in security risk assessment management implementation program for Local Government, State and Federal Agencies.

Consultant Architect

Responsibilities:

• Provide architectural expertise for Information Server product suites such as DataStage, Fast Track, Information Analyzer, MetaStage and Quality Stage.
• Responsible for installation, configuration, testing and migration of DataStage 7.5 projects to IS Information Server v8.7.
• Perform database configuration setup for Netezza data warehouse appliance and LDAP Active Directory.
• Fine tuning existing DataStage jobs to enhance performance optimization with Confidential Information Server v8.7.
• Provide mentoring and training to Land's End DataStage Administrator and Developer of the new enhance function that was not available in the previous DataStage V7.5.1 in comparison with Confidential Information Server InfoSphere V8.7 to Land's End DataStage Administrator

Senior Technical Architect

Responsibilities:

• Provided architectural expertise for Information Server product suites such as DataStage, Fast Track, Information Analyzer, MetaStage and Quality Stage.
• Designed and developed DataStage jobs for both parallel and server edition for RTI, MQ, and Web Services for real time application development.
• Provided guidance on LDAP Active Directory configuration for Confidential Information Server v8.1
• Provide guidance and perform Information Server V8.5 product suites installation, configuration and HA setup.

DataStage Consultant

Responsibilities:

• Responsible for developing test strategies like preparing step by step procedures for testing DataStage jobs.
• Provided architectural expertise for Information Server product suites such as DataStage, Fast Track, Information Analyzer, MetaStage, Quality Stage and InfoServer MDM.
• Perform installation, configuration, setup, strategic planning and upgrades for new release of Information Server such IS 8.5 version.
• Provided LDAP Active Directory configuration guidance for Confidential Information Server v8.1
• Advice and guide developers, Project Manager and others regarding DataStage issues, such as fine tuning a DataStage Jobs, configuration and others.
• Provide mentorship to clients who needs guidance and take advantages of the new features of Information Server version such as 8.1 and 8.5.
• Design and develop DataStage jobs for both parallel and server edition in support of special project as needs arose.
• Install and configure DataStage Plug-ins like SAP/R3, Siebel, Oracle ERP application Netezza, Teradata and others.

Senior Consultant, ETL Architect

Responsibilities:

• Served as DataStage Architect for large health insurance provider, responsible for administration, installation, configuration, database connectivity and performance engineering.
• Performed architectural tasks such as estimating hardware capacity growth, user requirements for development and production environments and offer solutions to day-to-day issues concerning DataStage.
• Implemented and configured DataStage Infrastructure such as hardware and software package for a large Health Care Association.
• Advised and guided Developers, Project Managers and others regarding DataStage issues, such as fine tuning a DataStage Jobs, configuration, etc.
• Provided guidance about LDAP Tivoli configuration for Confidential Information Server v8.1
• Provided mentorship to DS Admin needing guidance and fixes to patch issues for new release. Also worked with DB2 DBA to resolve issues regarding bugs and fixes in DataStage 8.1 version.

BI Architect

Responsibilities:

• Implementation of PeopleSoft EPM data warehouse from installation of infrastructure, functional walkthrough sessions, development of customized data mapping, fixing PeopleSoft bugs and others.
• Designed and customized fact and dimension tables to enhance PeopleSoft EPM data warehouse Financial Budget modules.
• Developed custom DataStage server jobs for PeopleSoft EPM data warehouse financial budget application module.
• Performed data analysis and modeling using PeopleSoft EPM metadata through MetaStage definition as input in designing new customize data mart.
• Installed DataStage Server product suites and 3 rd Party tools used by PeopleSoft EPM data warehouse packages.
• Performed DataStage administration task like configuration of Oracle 10g instance database connectivity and doing backup task for DataStage projects.

DataStage Consultant

Responsibilities:

• Provide best practices regarding configuration and setup of DataStage EE Server in a clustered and grid computing environment.
• Perform data warehouse modeling for logical and physical database instance using ODS Metadata through MetaStage definition to design new data mart.
• Provide mentoring to Aetna’s technical development team for doing migration of Ab-Initio ETL jobs to DataStage EE environment.
• Review Aetna Ab-Initio ETL Spec’s and provides migration strategies to DataStage best practices.

Senior Consultant

Responsibilities:

• Review Spec, analyze, design and recommend best practices in implementing client large data warehouse projects.
• Provide subject matter expertise in PeopleSoft EPM Data warehouse implementation for Financial, Human Resources, CRM, Student Administration and JumpStart.
• Setup initial scripts that build OWS, OWE, WFN layers for PeopleSoft EPM 8.9 data warehouse tables and configure PeopleSoft Internet Architecture for EPM FMS module.
• Provide technical expertise in developing DataStage Server and QualityStage Jobs that performs data cleansing and fixing issues of bad data.
• Troubleshoot and fix issues for SAP/R3 Plug-ins used in SAP application modules like BW data warehouse and others.
• Install and configure DataStage Plug-ins like SAP/R3, PeopleSoft, Siebel, Oracle ERP application Netezza, Teradata and others
• Perform initial DataStage admin task for clients after doing fresh install and provide answer to issues concerning hardware and software.
• Review Spec based on process flow diagram or data mapping prepared by clients and develop DataStage jobs that interface with XML Schema and Web Services.
• Provide mentoring guidance to clients that are developing complex DataStage application for data warehouse and OLTP.
• Installed Ascential software components (DataStage, QualityStage, ProfileStage, and MetaStage) in prospect and client environments in order to provide a successful experience for the customer and to maintain a high level of customer satisfaction.
• Collaborated with a corporate staff of five developers to profile multiple systems utilizing Information Analyzer and QualityStage to provide information to other team members about the quality and consistency of data prior to being integrated into a new warehouse management system utilizing Teradata.
• Investigated and diagnosed critical situations/customer complaints in order to provide a 99% satisfaction rating within the sales district.
• Provide expertise in design and coding DataStage jobs for Parallel and Server editions.
• Design DataStage Build-Ops functionality for special client needs beyond the normal stages for both Parallel and Server editions.

Senior Consultant

Responsibilities:

• Provide technical and functional expertise on Ascential DataStage tool for SA JumpStart Data Warehouse implementation for a large educational institution in California.
• Develop SA (Student Administration) module and utilized MetaStage as source for metadata definition in design specifications, construction, testing and implementation.
• Provide PeopleSoft EPM technical subject matter expertise to a large health care provider wherein Ascential DataStage and MetaStage were utilized for developing ETL functionality. Also Cognos was for the primary analytical reporting tool. The implementation consisted of HCM JumpStart ODS data warehouse as well as the delivered HR workforce analytics.
• Perform OEM DataStage installation, configuration and database connectivity to new PeopleSoft EPM clients.
• Involved in testing PeopleSoft EPM module packages from a development point of view and preparing test strategies of all modules prior to product GA releases.

DataStage Consultant

Responsibilities:

• Provide technical expertise on designing enterprise wide data warehouse systems using high end relational database management systems, such as Teradata.
• Coordinate system architecture activity across projects to ensure adherence to standards and technologies. Serve as technical lead on data warehouse development projects.
• Conduct JAD and RAD sessions to formulate functional data warehouse specification used during requirements, analysis and design, implementation phases of the project.
• Design and develop data warehouse model for Multi-Dimensional Database for OLAP tools such Hyperion Essbase, MS-SQL OLAP, Oracle Data warehouse Builder.
• Design and develop Ascential DataStage jobs that interface with SAP/R3 plug-ins, to source data from external SAP environment.
• Utilized methodologies such as IE to formulate business requirements in doing overall enterprise wide data warehouse analysis and design.
• Developed logical and physical data model for ASC X 12 standards for a HIPAA -based compliant medical system.
• Perform DataStage and MetaStage development task like preparing functional requirement, designing facts and dimension tables, coding DataStage parallel and server edition jobs, and shell scripting.

Technical Lead Consultant

Responsibilities:

• Provide scalable solution alternatives identifying specific decision criteria and evaluation of weight factors to lead and design, using best practices, in the selection process.
• Prepare document report for technical architecture and support processes and work in tandem with the data warehouse teams to design the overall architecture of the data warehouse. Participate in the implementation of the hardware and software.
• Estimate size of the data warehouse implementation in conjunction with capacity planning and resource planning.
• Involved in performing data integration to link Essbase OLAP database using ETL tools such as Hyperion HAL, Actaworks, Ascential Data Stage and MetaStage.
• Providing technical expertise in EIS data integration for software packages such SAP/R3, JD Edwards, Lawson, PeopleSoft, DB2/UDB, Oracle, MS - SQL, Confidential Mainframe Legacy Application and Sybase
• Utilize SAP/R3 plug-ins to interface with Hyperion EIS package and Ascential DataStage ETL tool to move data from different sources.
• Perform multi dimensional data modeling using ERD diagramming tools such as Erwin and others.
• Ability to work with technical team and functional business areas.
• Developed database load processes for various RDBMs such as DB2, Oracle, MS SQL Server and Teradata.