Sam Solomon
Development
Virginia, United States
Skills
Cloud Computing
About
Sam Solomon's skills align with Programmers (Information and Communication Technology). Sam also has skills associated with Database Specialists (Information and Communication Technology). Sam Solomon has 29 years of work experience, with 4 years of management experience, including a mid-level position.
View more
Work Experience
Senior Consultant
Prior Years
September 1995 - August 2011
- for Federal and Civilian Sectors * Worked for 5+ years in and near Washington DC with the following Federal Agencies: Pension Benefits Guaranty Corporation (PBGC), Department of Labor (DOL), Government Accounting Office (GAO), and the Department of Energy (DOE). * Worked mostly with Oracle Database Administration, Oracle EBS and BI Administration similar to the tasks above. * Used PVCS for source code and files' version control. * Data had been removed to keep resume short and simple.
Oracle Developer and Architect
Allstate 09
January 2018 - August 2019
- 2019 - 07/2020. Capital One 09/2020 - 03/2021. US Federal Bank Reserves 04/2021 - 02/2022 (Worked remotely for both Richmond and Chicago sites). City of Chicago 02/2022 - 07/2022. Hitachi and other clients 07/2022 - Present. * Worked with Oracle, AWS, Azure and Google platforms and technologies. * Worked as an Oracle Developer and Architect, which included work in designing, developing, testing, and implementing Oracle-based solutions. * Developed interactive Business Intelligence Reports and Dashboards using Tableau Desktop and Cloud, PowerBI, Oracle Analytics and OBIEE, and Oracle APEX. * Designed, developed and maintained Oracle an Oracle database application, including stored procedures, triggers, functions, and packages. * Performed data modelling, schema design, and database optimization to ensure optimal performance and scalability. * Collaborated with business analysts and stakeholders to gather requirements and translate them into technical specifications. * Developed and maintained data integration processes between Oracle, AWS, Azure, Google and On-Premise systems. * Troubleshooted and debuged issues. * Conducted code reviews, performance tuning, and optimization to ensure code quality and efficiency. * Staying up to date with the latest technologies and practices and make recommendations for continuous improvement. * Mentored junior developers and provide technical guidance and support as needed. * Worked Solo and in Groups with minimum supervision. Engaged the BI Teams in thoroughly defining the DW SnowFlake Architecture and Data Elements and Layers and Hierarchies, Facts and Dimension Tables, Primary keys, Natural keys, Surrogate keys, Composite keys, Alternate keys, Unique keys, and Foreign keys, Granularity Detail of Depth for Zooming in and out on Data for the interactive BI reports, which covered the General Ledger and Sub Ledgers for the customer's Financial System in the areas of Payments, Suppliers, Vendors, Accruals, Discounts, Processing Cycles, Auditing, Float Analysis, Debits and Credits, Inventory, Expenditures, Store Analysis, Historical Data, Tend Analysis and Forecasting, Invoices, Adjustments, Performances, Assets, Acquisitions, Gross Margins, Gains and Losses, Working Capital, Budgeting, Cost Balances and Ratios, Cost Allocations, Profitability Margins, Accounts Reconciliations, Key Performance Indicators (KPIs), Project Costs and Commitments, and several other business related and customer specific data and report designs. * Developed online applications using Oracle Application Express (APEX) REST SQL, Services, REST Remote Servers and Secured Web Credentials, SAML Configurations, APEX authoriation and authentication, Workspaces, Application Groups, APEX App Builder for Forms, Reports and interactive Dashboards. * Developed Oracle EBS customizations using Key and Descriptive Flexfields. * Worked on performance tuning on SQL and PL/SQL programs using hit plans and Oracle Database optimization, Database Partitioning and others. I worked with SQL queries optimization, which includes building indexes and writing Hint Plans, and writing Inner and Outer Joins and Nexted Queries, and Group by and Having clauses. * Worked in Data Migrations and Environments' upgrades from DEV to TEST to UAT to Pre-PROD to PROD for both AWS and Azure Clouds, and On-Prem as well. My work included Blue-Green deployments, Canary deployments, sticky sessions with Load Balancers, Cutover plans and Rollback plans. * Contributed to the onsite and offsite demonstration and detailed discussions regarding the consolidation of the client's overall environments, and the requirements and high level designs needed in the Data Warehousing, and Databricks ETL and ELT automations, and what are the best practice designs and methods and models to adopt. * Managed and Worked with Senior Developers in both the USA and India. * Functional Requirements Gathering and Oracle BI Team Lead * Responsible leading the BI Technical Team, both "On Shore" and "Off Shore" for the BI Apps. * Engaged the BI Teams in setting up the GL Chart of Accounts Segments and Levels, and verifying the Parent-Child relationships for each Segment and Level. * Engaged the BI Teams in thoroughly defining the Data Elements for the ETL interfaces for inbound and outbound interfaces, and Data Loading. * Worked with Data Lineage and Data Mapping documents for BI Apps. * Worked with Project Manager on setting up Project Milestones, Planning, and Activity Unit Trackers for the BI Implementation. * Engaged the BI and DB Teams regarding performance tuning and improvement, and implemented the environment changes in the areas of Ragged Hierarchies, PySpark Tuning, SQL Query Tuning, DB Partitioning, Indexes, and Caching. * Implemented Financial Analytics and General Ledger (GL) Chart of Accounts and Segments Hierarchies in Oracle BI Apps (OBIA) in different environments. * Created Dynamic and Conditional BI Reports and Dashboards that used Conditions in Sections, Presentation Variables, Advanced Filtering, and many other advanced features in OBIEE and Tableau. * Peer reviewed teammates' codes, and GitHub and GitLab pull requests. * Worked as a Databricks Engineer and Architect for ETL and ELT Databricks Pipelines and Workflow, and Data Factory Development and Orchestrations, Data Mesh Steams Optimization, Data Management with SnowFlake and unstructured Databricks Sets, Data Governance, Data Lakes, Federated Queries across a variety of Database Engines, Ingesting Streaming Data with Kafka and Pyspark, Data Science, Machine Learning, and Databricks tuning and partitioning with PySpark and SQL, Data Migration Services (DMS), Kinesis, Lambda, AWS Glue ETL Workflow automations, Glue Studio, AWS Step Functions, Athens, Redshift, DataBrew for data profiling, GuardDuty, DataDog, Dynatrace, IAM for monitoring and permissions. * Worked with a variety of Databases and file formats such as NoSQL, MySQL, Oracle, MongoDB, Postgresql, DynamoDB, Cassandra, CosmosDB, JSON, YAML, and several others. * Worked odd hours including past midnight on PagerDuty, Cloud Foundry, and Managing incidents, monitoring the environment, working with other teams on 400 and 500 spike codes that involved hack attempts and internal interruptions of services, bouncing databases, applying environment patches for optimization performance.
Engagement Manager and Cloud Engineer
Tata Consultancy Services
May 2015 - December 2017
- * Team led teams in the USA and India, and worked with different Agile, Scrum and Kanban methodologies for managing and implementing projects and tasks. * Got trained on Cloud SaaS, PaaS, IaaS and IaaC concepts by TCS. Cloud technology was new and TCS aggressively invested in training many of its employees. * We implemented 100% on premise applications and databases, with zero existing cloud environments into AWS and Azure Cloud, which included designing the Cloud Path migrations, creating templates for DB and Apps consolidations, Public and Private IP and network configurations, High Availability designs and so much more. * Migrated Databases into a host of AWS databases and services including S3, RDS, Aurora, Hadoop Data Lake, Athen, and several others. * Have performed all the necessary configurations for Oracle SCM SAAS modules like Order Management, Procurement, Sourcing, Inventory. * Entered order information into the company's database, verifying completeness and accuracy. * Worked with team on developing AWS event triggered Serverless and Stateless architecture, Lambda and Python, Containerizations and Clustering. * Worked with Kubernetes and Docker containers inside VMs. * Developed CICD pipelines via Jenkins, and collaborated with other Engineers via GIT and Github' s forking, upstreaming, branching and rebasing. * Developed infrastructure stacks in AWS using Terraform. Worked with AWS IAM and Cloud Security, EC2 instances, ELBs, Subnets, Availability Zones, Private and Public IPs, Bastian Servers, IP configurations and other tasks using Terraform and Linux. * Worked with large onshore and offshore teams on migrating enterprise-level on premise environments to Cloud, which included Database and Application consolidations, VMs, Load Balancing, IP configurations, Security, and other areas. * Team led both Onshore and Offshore teams in the USA and India for different clients. * Multi-branch builds, multiple Jenkins files, and pipeline automation in Jenkins. * Created and managed GIT repositories branching, merging with master node, staging areas, head points and authors. * Containerized applications using Docker, and built and managed Docker Swarm clusters. * Architected Databases and Environments using Erwin, Gliffy, and other diagramming tools. * Worked with configuring Oracle Exadata and transaction processing. * Worked with AWS EC2, CloudFormation, CodeDeploy, CodePipeline, Elastic ache, CloudFront, Serverless Architecture with Lambda, CloudWatch, EC2 Clusters, Network Configurations, VPC, Public and Private Subnets, IAM Security. * Provided analysis on implementing the Security and Privacy, Storage, Recovery, API, Scheduler and Automation Services for the Cloud environments. * Created and managed VM instances, Storage and SSH authentication and Networking resources' orchestrations.
Senior Oracle Consultant
United States Air Force
November 2014 - March 2015
- * Performed SQL Tuning and Oracle Database Administration tasks. * Worked on Administration tasks in the Development and Testing environments for the Oracle Database and the Oracle Applications environment. * Used PVCS for source code and files' version control.
IT Consultant
July 2013 - March 2015
Senior Oracle Lead
Walgreens
July 2013 - November 2014
- Functional Requirements Gathering for the BI Environment * Contributed to the onsite and offsite demonstration and detailed discussions regarding the consolidation of the client's overall environments, and the requirements and high-level designs needed in the Database and Oracle BI Administration, and what are the best practice designs and methods and models to adopt. Database and Environment Administration * Performed Oracle EBS administrative tasks that included creating users, groups, roles, profile options via LDAP and EBS, managing the Oracle Fusion Middleware and WebLogic environment, managing the Oracle Database daily, weekly and monthly tasks from maintenance to backups to performance tuning to cloning to patching, managing security, managing OAM, Identity Manager, OID & SOA, managing workflows, creating and managing Key and Descriptive Flexfields, and Executing the MD-120 tasks that developers fill out for us DBAs to execute in the TEST, UAT, PRE-PROD and PROD environments, to implement their programs. * As responsible for the life cycle of Drilling department's service contracts and as part of the oil field's projects team, successfully achieved 0 delays in projects date lines in the activities assigned to SCM. * Worked with writing interface programs with Oracle EBS. * Ensured accuracy of order details, including product specifications, quantities, pricing, and shipping information. * Worked with writing customizations using Oracle Forms and Reports for Oracle EBS. * Also performed Database and System partitioning on an Operating System and Database levels. * Developed Python, Linux bash and scheduling Linux cron job scripts. * Set up security on IP configurations, setting up F5 and public and private clouds, load balancing, High Availability, Networking securities in AWS, Oracle WebLogic and Oracle Fusion Middleware and LDAP. * Created and setup AWS IAM, Policies, Firewalls, Route 53, VPC, AMI and other AWS securities. Created and setup LDAP applications, roles, groups and users securities, initialization blocks security, data profiling and restrictions. * Worked with Oracle Automatic Storage Management (ASM) and Oracle Backups. * Engaged the BI and DB Teams regarding performance tuning and improvement, and implemented the environment changes in the areas of Ragged Hierarchies, DB Partitioning, Query Tuning, and Indexes, and Database Administration tasks. * Installed and configured Oracle DB 11g R12, OBIEE 11.1.1.7, ODI 11.1.1.7 and Oracle BI Apps 11.1.1.7.1 on a test Virtual Machine. * Developed the Installation and Configuration Guide document for the OBIA tools. * Customized the OBIA RPD repository for a variety of Analytics Modules, databases and heterogeneous systems. * Worked on performance tuning on SQL and PL/SQL programs, and environment tuning using OEM, Automatic Workload Repository (AWR), AWR and In-Memory Statistics, Active Session History (ASH), and Oracle Performance Hub, along with Partitioning. * EBS Administration in the DEV and TEST environments between different Responsibilities for certain Functional requirements. * Worked on Linux Shell scripting with other Admins for nightly job processes. * Used PVCS for source code and files' version control.
Oracle BI and DB Administration Consultant
NYC School Construction Authority
September 2011 - July 2013
- Administration, Data Modeling, Business Intelligence, and Development * This was a position with State and Local with NYCSCA, which is under the Department of Education. * Responsible for System and Oracle Database Administration for Oracle Discoverer and OBIEE. * Administered and Maintained all of the Oracle Discoverer Environments for DEVs, UAT, TEST and PROD using the Oracle Discoverer Administrator tool, Client, Discoverer Plus and Viewer, covering the EUL, Business Areas, Responsibilities, Folders, Reports' Maintenance, and Reports' Migrations within the Oracle EBS 11i Environment. * Performed Oracle EBS administrative tasks for several environments in support of the EBS and Discoverer, along with the environment's database programs, security and access. * For a period of five months, I was the sole Oracle Discoverer and OBIEE Administrator and Developer for all of the Environments, Reports and Dashboards due to emergency reasons that kept my co-worker out of the country. I maintained all of the environments of DEVs (DEV1, 2 and 3), UAT, TEST and PROD efficiently and successfully, and developed new reports, and modified existing reports based on SCA's formal standards and procedures of Users' requests and Managers' Approvals. * Undergone Discoverer Business Areas' remapping from the old Oracle Materialized Views that were querying off of the old Sybase Database via Database Links, to new Oracle Tables. This required refreshing of the Business Areas and recreation of many of the existing Joins that were already in place that got either corrupted or dropped, since much of the Materialized Views' columns were case sensitive and were enclosed in double quotes, and the new Oracle tables weren't. The IT department's new policy required that all of the Oracle tables' columns to be created without being enclosed in double quotes. The remapping also required modifications for the SQL-Based Business Areas' Folders and their joins. * Administered and Maintained OBIEE 10g's Services, BI Server, iBot and Scheduler, BI Publisher, and the OBIEE Repository. * Successfully installed and configured OBIEE 11g for Testing, and developed two detailed documents that gave analysis and details on the differences and the advantages and disadvantages between OBIEE 11g, OBIEE 10g and Crystal Reports. * Worked with Oracle Forms and Reports to investigate reports and data conversions into Oracle OBIEE. * Used PVCS for version control for all of the Program, Request, and Documentation files. * Worked on Linux Shell scripting with other Admins for nightly job processes. Performance Tuning * Performed SQL Tuning for SQL and PL/SQL Programs, and environment performance using OEM, Automatic Workload Repository (AWR), AWR and In-Memory Statistics, Active Session History (ASH), and Oracle Performance Hub. * Performed Cache Management and Tuning on the OBIEE 10g Environments. * Performed Turning and Cache Management on the Oracle BI Publisher Environments. User Training * Worked on performance tuning on SQL and PL/SQL programs, and also on Table Partitioning. * Developed an OBIEE Training Manual for training the End Users. * Developed Oracle PL/SQL and Oracle SQL Programs against the Oracle EBS 11i Tables that also covered working with and developing Materialized Views, Views, and DB-Links that connected to the Sybase System. * Taught in a formal class room setting End Users and Managers on how to use Oracle Business Intelligence Enterprise Edition 10g, using the training book and labs that I developed for the company. * Conducted one-on-one training on Oracle BI Publisher and OBIEE to two workmates. * Worked on Customizations in EBS DEV, and performed Administration work between Responsibilities for certain Functional requirements. * Used PVCS for source code and files' version control.
IT Consultant
January 2018 - Present
- Clients:
Education
Northeastern Illinois University
Masters of Science
