Sr. Technical Lead Resume
New, JerseY
SUMMARY:
Well versed in SAP Business Intelligence, data warehousing and Microsoft RDMS echo systems (NW 7.3 / NW 7.4 / NW 7.5, S/4 HANA 2.x). Expert level knowledge in full life - cycle implementation and support for SAP BW, SAP HANA, SAP Business Objects, MSSQL SERVER with respect to a landscape architect design, resource/capacity planning, system configuration, implementation, upgrade, patches and support pack updates, migration, rollout planning, on-going maintenance, system and MSSQL server DB performance tuning, and “Best Practices & How TOs.”
TECHNICAL SKILLS:
SYSTEMS AND LANGUAGES: T-SQL, C/C++, JAVA, JAVA SCRIPS, PERL, PYTHON, VISUAL BASICS, WSCRIPTS, POWER SHELL, WINDOWS SERVER (2008 - 2016), LINUX (RED HAT 7.x)
EXPERIENCE:
Sr. Technical Lead
Confidential, New Jersey
Responsibilities:
- BW client, system and DB copies and refresh
- Extract source system, Information broadcasting, process chains, Infopackages & DTPs creation, configuration & scheduling
- BW Precalculation server installation and configuration
- SAP systems & kernel installations, upgrades, patch and support pack updates using SWPM, JSPM and SUM tools. (Maintained SAP BW systems since the BW 2.x version)
- SAP BPC 10.1 (Embedded & Standard) implementation & configuration
- Transport landscape configuration and exposure to CTS+
- SAP JAVA portal, SAP Web Dispatcher and SAP Router installation and configuration
- Business Objects Data Services (BODS) installation and configuration
- BW system performance tuning, SLT configuration, SLD & Solutions Manager integration, SMD & Host agent installation
- SAP HANA 2.x system deployment and configuration, HANA system copies & HANA DB refreshes
- SAP HANA DB performance traces and tuning
- SAP HANA studio installation configuration, HANA security configuration to support BW/HANA developers
- Integration of Single-Sign-on(SSO) with SAP BW, ECC, S/4 HANA, Java portal, BOBJ, CRM and Fiori front-end
- Training and mentoring Jr. BASIS, create & maintain “Best Practice” and “How to” documents
MSSQL SERVER DBA
Confidential
Responsibilities:
- Installations, upgrades, configuration and patch updates
- Trace analysis, query plan optimization and performance tuning
- DR planning (backups & recoveries), DB mirroring, log shipping, server clustering, securities
- T-SQL, stored procedures, ETL, SSIS packages
- Server configuration, size & capacity planning, hardware performance tuning
- Creation of ad-hoc & linked system queries and stored procedure batches supporting BW developers needing to extract and transform and transport data across various SAP and third party applications
- Configure and setup ODBC/JDBC drivers to support inter server communication between MSSQL windows server and SAP HANA DB Linux servers
- Training Jr. DBAs
SAP Business Objects Administrator
Confidential
Responsibilities:
- Architecting BO infrastructures, Server sizing and capacity planning
- Installations and configuration of BOBJ server clusters, upgrades and support packs & patch installations and CMS configuration.
- Split Adaptive Processing Servers into stable grouping of servers through CMC
- Implement server fail-over redundancies insuring operational stability of BO environment
- Develop & implement BO Access level securities
- LUMIRA 2.x installation
- Configure OLAP & Relational connections and Single-Sign-On (SSO) enabling SSO from SAP CRM, SAP Fiori front-end into BOBJ system
Sr. MSSQL DBA
Confidential, Livingston/ New Jersey
Responsibilities:
- Modeled and implemented a credit Exposure application on a SQL database (SQL server 7.0/2000) backend with a VB 6.0 (T-SQL) front end. (This system reported a snapshot of monthly financial exposure of various operating units throughout the company.
- Some of capabilities were its ability to report either summary or a detailed analysis by client name, location (city, state, region, country), industry type, risk grade or funded amount.
- The system also allowed more advanced users an ability to submit customized queries against the database trough easy-to-use GUI dialog boxes.
- The system enabled financial executives and controllers quickly assess company lending trends, client risks, dollar amount exposures, thereby allowing them a better decision making. )