We provide IT Staff Augmentation Services!

Principal Sap Basis/hana Consultant And Db2 Database Architect, Sr. Big Data Engineer Resume

Hawaii And Bay Area, CA

SUMMARY:

  • Principal SAP Basis/HANA/Hadoop Consultant and DB2 Database Architect, Engineer and Administrator. Several years successfully installing, configuring, designing, migrating and tuning SAP, HANA, Hadoop, several large RDBMS databases including DB2 for Z/OS, DB2 for LUW, DB2 PureScale for Linux and AIX, IIDR (IBM InfoSphere Data Replication), DB2 for Iseries (AS400), Oracle, SQL Server.
  • Demonstrated strong analytical and business intelligence skills. Have had great success delivering Big Data, Data Warehousing and Business Intelligence solutions. Projects on very large DB2 AESE (multi - partition databases) running on AIX, Solaris, Linux and Windows operating systems.
  • Successfully planned, installed and rolled out IBM Guardium Security Applicance.
  • In 2015, successfully migrated multi-terabyte PeopleSoft and DB2 for Z/OS databases to DB2 for LUW V10.5 running on LINUX 6.5. Installed configured and successfully implemented High Availability and Data Recovery (HADR).

PROFESSIONAL EXPERIENCE:

Principal SAP Basis/HANA Consultant and DB2 Database Architect, Sr. Big Data Engineer

Confidential, Hawaii and Bay Area, CA

Responsibilities:

  • Successfully delivered conceptual design, logical data model, physical data model, capacity planning, external data interface specs, data loading, data maintenance and storage plan as well as security policies. Accomplished appropriateness of data storage, archive, purge and backup strategies. Installed, configured and maintained DB2 PureScale databases. Used IBM IDR and AWS to support big data integration, continuous availability, consolidation, warehousing, analytics initiatives as well as zero-downtime migrations and upgrades.
  • Performed Level 3 production support for SAP Basis/HANA, IDM 7.2 & 8.0 I, DB2, SQL Server, MongoDB, NoSQL, Hadoop databases. Perform SAP installation. SAP Basis security configuration, authorization and security roles, auditing, monitoring and SAP Database performance tuning • Successfully performed complete OS/DB migration, installation and configuration of High Availability - Data Recovery (HA/DR) and SAMP or SAP PI landscape. This included migrating the primary PPI database to another DB server located in a Data Recovery (DR) facility and creating the standby database on another DB server. Installed DB2 UDB software to build the \'would be primary\' PPI database in the DR facility. Implemented HADR and SA MP with ACR to leverage two locations for recoverability. Built PI database on the new LPAR. Re-configured HACMP for PI. Implemented High Availability - Data Recovery (HA/DR) and SA MP on the primary and standby database.
  • On Z/OS, set up DB2 for Z/OS as a parallel database. Enabled multiple DB2 sub system to share the same SAP database to produce a data sharing member and the set of sub system a data sharing group. All members of the group used the same shared DB2 catalog and directory. Successfully accomplished High Availability and scalability by using DB2 data sharing and SAP sysplex. Fail over support as a high availability solution to protect the database of your SAP system against failure. Plex failure support as a high availability solution to protect a legacy HANA database of the SAP system against failure.
  • Successfully tested Failure of DB2 Subsystem or Distributed Data Facility and Failure of Entire z/OS System or Entire zSeries Hardware. This exercise included network failure and failover with Application Server on z/OS and
  • Developed SAP HANA and SAP Business Objects across all the business areas for the BI Projects, including technical specifications based on functional specifications that outlined required characteristics, measures and business rules. Developed SAP HANA data models attribute views for master data, analytic views for transaction data and calculation views. Developed SQL scripts to Join/Union various attribute and analytic views for reporting with time dimensions. Developed data flows and work flow using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation. Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
  • Migrated single node DB2 databases to hash partitioning by using the DPF feature. Enabled significant data growth or satisfy a need for more historical data and to improve the accuracy of analysis and forecasting. Split databases into multiple physical partitions each of which owned its own smaller portion of a database with dedicated resources. Recommended and successfully implemented additional servers, storage and improved networking bandwidth. Added more users by adding additional coordinator partitions or user modules. Achieved a system that was scalable to support additional data and users as well as reducing I/O. In addition to hash partitioning, added table partitioning (by range). By combining DPF and table partitioning there is less data returned to the servers and all servers are processing that small amount in parallel. Added Multidimensional Clustering into the mix. This allowed for storage of DB2 data in the same contiguous set of blocks on disk. Finally applied Db2's unique compression capabilities that has resulted in 80 percent reduction in storage requirement and significant I/O bandwidth savings.
  • Reduced infrastructure cost through strong technical leadership and mentoring others on several applications teams, including application developers and DBAs. Achieved customer's target goal by formulating and implementing teams' technical vision, teaching hands on insight into system architecture, database software development and data warehouse design. Successful in the delivery of architecture and design of new applications, stored procedures, databases and infrastructure changes.
  • Successfully performed planning, installation, configuration, monitoring, and technical support of IBM InfoSphere Guardium.
  • Maintained a list of all accounts in use and their associated GUI user.
  • Maintained GUI admin, accessmgr and CLI account passwords.
  • Check aggregation/archive log for unit types reporting errors.
  • Periodically check internal Guardium DB utilization report for DB full conditions.
  • Periodically review aggregation/archive logs for job schedule and timing and increase time gap to resolve problems.
  • Resolved backup and purge errors.
  • Successfully performed planning, installation, configuration and maintenance of IBM ILMT license tool.
  • Successfully implemented High Availability - Data Recovery (HA/DR) Fail-over, Monitoring and Maintenance Strategy. Executed changes consistent with established change control policy.
  • Owned product roll out from the development phase through to production deployment.
  • Built distributed, scalable and reliable data pipelines that ingest and process data at scale and in real time.
  • Provided solutions for the design and implementation of Hadoop EMR Cluster / Big Data Infrastructure.
  • Deployed and maintained Hadoop/Big Data/ Spark and database storage infrastructure in AWS cloud.
  • Created data environments and data sets to serve a wioe range of data users that included but not limited to Data Scientists, Data Analysts and Business Analysts.
  • Performed offline analysis of large data sets using components of a big data software ecosystem.
  • Evaluated Big Data technologies and prototype solutions to improve data processing architecture.
  • Installed and monitored HDFS/Hadoop/Spark and related software releases, third party utilities with emphasis on overall system performance.
  • Conduct 24/7 performance tuning and monitoring tasks for Windows 2003 and SQL Server2005 with Red-Gate, Quest Central Spotlight, Embarcadero for 10 production and 15 Dev, QA.
  • Managed 60 production SQL Server databases with 35 TB data size.
  • Utilized collaborative tools such as Jira and confluence to create, share, and collaborate on projects all in one place to keep projects moving forward, faster.
  • Installed, configured and managed ongoing projects for server SQL Server development and production environments including 26 development and QA servers.
  • Managed Amazon Web Services (AWS) infrastructure with automation and orchestration tool such as Chef. Successfully utilized AWS services like VPC, EC2, S3, ELB, Auto Scaling Groups (ASG), EBS, RDS, IAM, CloudFormation, Route 53, CloudWatch, CloudFro.
  • Build and configure MDM server. Recode and reengineer the dataflow based on IBM out-of-the-box functionalities.
  • Analyized, designed and implemented the Conversion Activities: Extraction, Copy Build, Log Apply, Record Counts, Transformation, and Verification.
  • Developed TDM solution with CA TDM. Performed test data management, data masking, datamining, and data cloning. Successfully defined the data masking, data provisioning strategy, and built gold copy repository. Demonstrated 2 years effective working on AMDOCS. Handled end to end TDM implementation across customer applications landscape DOD Domain.

Environment: / Skills Utilized: SAP Basis, SAP HANA, DB2 v10 for Z/OS, DB2 for LUW V11 & V10, QREP, COGNOS, PureScale,, AWS, CA TDM, IBM IDR, I-Series (AS400), PureData, MongoDB, SQL SERVER, SAP, IDM 7.2 & 8.0 I, Hadoop, Cloudera, TALEND ESB HDFS, YARN, MapReduce, Zookeeper, Apache Spark, NoSQL, IBM ILMT, Jira, AIX, Solaris, Linux, Python, Shell Scripting, Windows/NT/2000, Z/OS, Oracle 10g, SQL Server, TeraData, MicroStrategy, CA DB2 Tools (Fastload, FastUnload), DataStage, SAP XI 3.0, ABAP and Java proxies, LDAP, Guardium, PeopleSoft, BMC Tools, MQ / WebSphere, Hadoop, Tableau, Erwin, Infoman, PostgreSQL, MongoDB, Hadoop, Big Data.

Senior Infrastructure Consultant- Big Data

Confidential - San Francisco Bay Area, CA

Responsibilities:

  • Provided Level 3 production support for DB2 for LUW, V8.2 through V10.5. Performed over 2000DB2 installations configuration and fine tuning. Installed and configured DB2 Connect Server. Successfully migrated a very large Peoplesoft system that had a backend DB2 for Z/OS a large V10 database to DB2 LUW V10.5. Wrote script for DB2 data migration using DB2 Cross Loader. Performed DB2 Server administration, security measures, backup and restore of several DB2 WSE databases. Successfully developed and developed several shell and bash scripts to automate DBA tasks such as backup, bulk DB2 installations, REORG, RUNSTATS, and capacity planning. Developed and maintained a comprehensive library of all supporting documentation. Configured and administered a Cloudera deployment.
  • Designed multiple DB2 databases with logical partitions and used range partitioning based on month and employee number as the partitioning keys of applicable tables.
  • Installed, configured and supported IBM ILMT software license tool. Developed ILMT plan including sizing, capacity planning for ILMT on Linux servers ILMT agents.
  • Utilized collaborative tools such as Jira and confluence to create, share, and collaborate on projects all in one place to keep projects moving forward, faster.
  • Environment / Skills and Tools Utilized: SAP BW, SAP HANA 4, DB2 v10 for Z/OS, DB2 for LUWV8.2, V9.5, V10 & V11 with DPF, HADR, JIRA, AIX, Solaris, Linux, Shell Scripting, Windows/NT/2000, Z/OS, CA DB2 Tools (Fastload, FastUnload), DB2 Cross Loader, DataStage, LDAP, Guardium, PeopleSoft, BMC Tools, MQ / WebSphere, ServiceNow, IBM Content Manager, Data Studio, DB2 Connect, Jira. SDLC.

Senior SAP Basis/HANA Architect

Confidential - San Francisco Bay Area, CA

Responsibilities:

  • Applied support package using SPAM and JSPM. Kernel patch. Administrated DB2 database space Management and capacity planning. Used BRTOOLS, SQL plus as well as native DB2 tools for DBA tasks. Worked on SAP Security in all SAP Modules like HR, FICO, MM, PM, PP and SD. Transport Administration - Troubleshooting and Monitoring ports.
  • Performed system refresh from PRD to QAS. Day to day support for the Development, Testing and production environments. Applied SAP correction notes as per the SAP and Developers requirements. Monitoring backups and investigate the logs for unsuccessful backup. Monitoring issues related to table space growth, resizing and adding data files to the table spaces using BRTOOLS and verifying database consistency. Perform load balancing across active application servers and maintain system profile parameters to optimize performance. Review the batch jobs and ABAP dumps Analysis.
  • Analyzed the workload situation by various monitors. Generated Developer key and Object key for programmer Printer setup - Monitoring and troubleshooting printer issues. Performed various Trace options to find out the error occurred in the SAP systems. Monitored SAP systems and troubleshooting any issues related to the problem. Managed RFC connection and resolved any issues. Performed portal monitoring and verify the J2EE Cluster logs. Established OSS connection. • Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non SAP data flat file uploaded and directed extraction connection DXC to acquire data into SAP HANA Data Mart. Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool. Develop SQL scripts and functions for complex reusable scenarios in HANA. Developed multi-data source challenging reports by merging data from multiple data sources using Web Intelligence WEBI. Designed web reports using Be Queries BICS Connection. Developed cross tab reports, reports with sub reports linked unlinked and charts using Crystal Reports. Created reports using SAP BO Analysis Office 1.3 and 1.4 for multidimensional ad-hoc analysis of Headcount Analytics data from SAP BW and HANA in Excel. Worked with Life Cycle Management Console to Transport the Objects to System Landscape Dev, QA and Prod
  • Successfully performed installation and configuration of SAP HANA. Developed the plan for SAPHANA HADR rollout. This included moving the primary PPI database to another DB server located in a DR facility and creating the standby database on another DB server. Built SAP HANA would be-primary\' PPI database in the DR facility. Implemented HADR and SA MP with ACR to leverage two locations for recoverability. Built PI database on the new LPAR. Re-configured HACMP for PI. Implemented HADR and SA MP on the primary and standby database.
  • On ZOS, set up DB2 for z/OS as a parallel database. Enabled multiple DB2 subsystems to share the same SAP database to produce a data sharing member and the set of subsystems a data sharing group. All members of the group used the same shared DB2 catalog and directory. Successfully accomplished availability and scalability by using DB2 Data Sharing and SAP Sysplex Failover Support as a high availability solution to protect the database of your SAP system against failure. plex Failover Support as a high availability solution to protect a legacy HANA database of the SAP system against failure.
  • Environment / Skills, Methodology and Tools Utilized: DB2 v10 for Z/OS, DB2 for LUW V9.5, V10with DPF, HADR, JIRA, AIX, Solaris, Linux, Shell Scripting, Windows/NT/2000, Z/OS, CA DB2 Tools (Fast load, Fast Unload), DB2 Cross Loader, Data Stage, LDAP, PeopleSoft running on DB2 for Z/OS, SAP HANA 4, BMC Tools, MQ / WebSphere, Content Manager, Data Studio, DB2 Connect. Change Man, CICS, Jira. SDLC.

Lead Database Engineer

Confidential - San Diego, CA

Responsibilities:

  • Designed, implemented, and supported first strike defense applications, databases and technical infrastructure.
  • Designed, implemented and supported distributed intelligence data warehouses on 3main operating systems. Installed and configured RDBMS on several IBM SMP servers. Resolved locking, latching, versioning, recovery, memory management, I/O contention, indexing, inefficient SQL code generation and successfully optimized low performing reports. Developed foreground and background jobs to automate scheduled administration functions including backup to TSM. Created user groups, users & granted them roles and privileges. Designed backup and recovery strategy. Migrated older version of DB2 for LUW to a newer version and release level. Executed Snapshots and Event Monitors, EXPLAIN. Implemented new requirements for tables, indexes and views for enhancement projects. Implemented requirements for new Data Warehouses, DB2 Instances, Data Marts and Databases, Tables, Indexes and Views. Perform
  • Used the DPF feature to build an analytics database. Designed databases that had multiple physical partitions each of which ran on a dedicated SMP server.

Environment: / Skills Utilized: DB2 for Z/OS, DB2 for LUW with DPF, AIX, RHEL, DB2 for Iseries (AS400) WINDOWS, Control M, BASH, KSHELL, PERL, SQL Server, Oracle, Erwin, DataStage. TSM

Senior DB2 Database Administrator

Confidential - Plymouth, MN

Responsibilities:

  • This Tricare project was eventually awarded to UHG competitor HUMANA.
  • UDB DBA Production support experience on Unix/AIX platforms.
  • Good exposure to UDB DBA maintenance activities like reorgs, run stats, back-up, restore, expanding and reducing storage requirement.
  • Demonstrated ability to closely work with application performance issues in production.
  • Worked closely with IBM for support / Raising PMR.

Environment: /Skills Utilized: DB2 UDB v8.1, AIX, Erwin, Changeman, Ab Initio, MicroStrategy, WebSphere, MQ, DB2 for Z/OS.

Senior DB2 Database Administrator

Confidential - Scottsdale, AZ

Responsibilities:

  • Mapped highly complex physical databases from logical models for AMEX corporate card services. Actively participated in complex data modeling, integration and capacity planning efforts. Ensured compliance to management policies, procedures and standards.
  • Identified business requirements, performed analysis and development of data warehouse and database objects that supported business initiatives. (Reported to Raymond Gardner - VP - IT) Environment/Skills Utilized: DB2 UDB v8.1, AIX, Erwin, Changeman, Ab Initio, MicroStrategy, WebSphere, MQ, DB2 for Z/OS.

DB2 Migration Architect

Confidential - Hartford, NB

Responsibilities:

  • Developed DB2 VLDB migration plan and risk assessment for Confidential Corporation.
  • Executed plan for migrating DB2 UDB v7.2 data from IBM Shark to Confidential storage devices. Created new DB2 UDB v7.2 instances, databases, table spaces, tables and indexes. Created Hot Standby Databases with DB2 UDB V8.1 and using IBM Shark Flash copy and Confidential TimeFinder. Transformed that mission-critical 24x7 DevOps with the highest degree of availability, and cost savings. Successfully mapped physical layout of DB2 table spaces from IBM Shark to Confidential storage. Analyzed and tuned several DB2 databases using EXPLAIN, SNAPSHOT MONITOR, EVENT MONITOR.

Environment: / Skills Utilized: DB2, AIX, LINUX, WINDOWS, MS PROJECT, Erwin, Confidential SAN, MS

Hire Now